I reckon his wife cheated on him, and by accident he killed her. His son witnessed it and in panic he killed him too, then racked by guilt he killed himself.
Also, not to be horrible, but is anyone else kind of dismayed that we won't ever know the end to the who killed Mr McMahon stroyline?