The pilot, a 41-year man from Whitecourt, Alta., survived the initial impact but later died of his injuries