I really only know about him because he's Tim Drake's favorite Superhero. In what book did he die in?
He died in one of the Countdown books, I believe.... OMAC, maybe? Ted found out that Maxwell Lord was up to something shady, and went to all the Justice Leaguers for help investigating, but everyone was too busy....
So he went out to investigate on his own, and got shot by Lord.
Edit: I think he actually died in the Countdown to Infinite Crisis special.