A famous UFO expert, dubbed a real-life 'X-Files investigator, has died following a battle with cancer.