A woman in her 40s tragically died at the scene, with two men arrested in connection with the incident - which left six other passengers in both vehicles injured