Police have opened a critical incident investigation after a car crash in Sydney's north which has left five people in hospital.