The Fate of the Space Jockey and what LV-426 is up for debate again i guess... With the U-Turn Plot of Alien Covenant.
Prior to that.. Ridley Scott confirmed the Derelict was related to a Juggernaught they are just a few Centuries Apart Technology wise (which makes little sense) but he had confirmed the Derelict had left its Origin but it DID-NOT get Far (which means it left LV-223) something Evolved in the Cargo Hold, got to the Pilot and knowing he was infected he set a course to LV-426 to Quarantine the Cargo and set off a SOS.
The Ship had intended to Land on LV-426 and RS said it did not Crash, well it kind of did or did it? RS said the event happened within a Few Hundred years of the LV-223 Outbreak that killed off those Engineers.
So must have likely been... Space Jockey Enters Cryo-Sleep like the Last Engineer Bob..... he awakens a few hundred years latter to carry on his Mission but his Cargo had Evolved, infected him, i am going to think he did not realize until he was departing that something was WRONG and then he laid a Course to LV-426 to Quarantine the Cargo.
But ALAS... all this is potentially changed with the David Creates the Xenomorph Route.