In the spirit of Star Trek, here are the members of the Hazard Team who can die (usually due to your incompetence):
Tom Odell. Being sighted by too many Klingons on the Find the Isodesium Mission (the Scavenger Base) will result in his death when Munro finds him.
Ken Lathrop. Dies when the Borg attack trying to seize the isodesium.
Lt. Foster. Dies if Munro fails to deactivate the "assimilator" device in the Borg Cube. Detour around the forcefields to get to Foster's cell to save him.
Jeff Nelson. Can die during the fight in the Borg Cube.
Mitch Csatlos. Can die on the Dreadnaught Vessel if he takes too much damage (or falls off an elevator).
Rick Beissman. Dies on the Dreadnaught Gunship.