I have spotted a picture in the Superman Wikipedia article.

And it was noted:

Superman dies in Lois Lane's arms: Superman No. 75 (vol. 2, January 1993); Art by Dan Jurgens and Brett Breeding

However, I haven't found any answer in this article. So my question: which incident caused Superman to die? Is it true in the orthodox story series?