When Tasha Yar died unceremoniously and then came back as a Romulan
The only badass female on the entire ship, and how does she go? She gets blasted by a tar monster when she tries to walk around him. Sure, the writers attempted to give her a proper sendoff later on, but still. That first death was total bullshit.