Allan McNish’s dreams of motorsport history are in tatters after a string of problems ruined his chances of Le Mans 24 Hours glory.