This isn't entirely relevant, since it wasn't actually me that died, but the strangest and by far death I've seen in a game was the first time I played GTA IV for the 360. I was driving really REALLY slowly, because I was lost, and was driving through a gas station, and as I was doing so, an NPC was getting out of their car, I clipped their door, which slammed into them, and they crumpled to the ground. I've tried a million times to replicate this, but no luck.