The mystery of the missing motorhome has ended with a devastating discovery for a New Brunswick family.