The driver was forced to abandon his luxury SUV when the rescue mission backfired in North Yorkshire.