A man and a four-year-old boy have both died following a horror crash.