The sports anchors' death is being investigated after he passed away in New Orleans as he prepared to cover the Super Bowl clash between Kansas City Chiefs and Philadelphia Eagles