The Secret Service agent who tried to shield US President John F Kennedy when he was fatally shot in Dallas has died after remaining haunted by his experience.