Ok, so remote Federation scientists seem to suffer a lot in ST, but I wonder how much of that is survivor bias. I mean, we can assume redshirt casualty rates are fairly consistent across starships, although that could be a leadership issue; but what if there's a vast population of remote research outposts and only a very tiny fraction ever gets in trouble? We just don't know. The Federation is enormous, and covers a vast 3d volume - if there are outposts even slightly evenly distributed across the surface of that volume, we'd be looking at a large population. More researchers probably die from slipping on food spills than rogue revived eugenics war corpcicles.
That didn't affect any of the civilians on Earth. The most they got were minor warnings that The Borg were getting close, but then they were miraculously stopped about 35 light years from Earth.....