The Secret Service agent who leapt onto the back of President John F. Kennedy's limousine after the president was shot has died