A man in his 40s was pronounced dead at the scene on Saturday night after police and paramedics rushed to help