You likely mean Leo Petro (not Leo Popps), host of cult classic "Television X" (late 1980s–early 1990s).
No dramatic event or scandal caused his disappearance. After the show ended:
Leo Petro is presumably alive and well, choosing a private life. He made significant impact with "Television X" and continues industry work quietly.