The two occupants of the Silverado — a 31-year-old woman and a 30-year-old man — were pronounced dead at the scene