The man, 56, died at the scene as a one-year-old boy was rushed to hospital following the crash in Barnsley