The off-duty detective was putting footballs in the back of his car and was with his son, when he was shot multiple times by two gunmen.