TWA 800 had to be the worst. When you watch the computer animation of what happened there, it's bone-chilling. The cockpit broke off and fell to the water while the fuselage continues to soar upward with many passengers still alive, before it ran out of steam and plummeted to the water. Can't imagine.
YouTube - TWA Flight 800 Disaster