A man died following a crash on a Yorkshire motorway despite the best efforts of an off-duty police officer who tried to save his life.