The woman, who was a passenger in one of the cars, was pronounced dead at the scene