Edit: Apparently it he was swimming directly over a large stingray with a camera man out in front filming both Irwin and the stingray. The ray got spooked and went into defensive mode and lashed out with its tail. The barb entered Irwin's chest, piercing his heart.
Stabbed in the heart by a stingray. There's one for the freak accident file.