Death is the Only Option:
You're a low-ranking ensign on the Enterprise assigned to an away mission on a never-before visited planet. The rest of the away team consists of senior officers.
You're serving any position on any other Federation starship, your ship has been dispatched to rendezvous with the Enterprise.
The writers were better with Picard's love interests.
I don't remember a single one dying.
Any time a woman was interested in Kirk, they tend to end up dead.