A cargo ship carrying new vehicles to Mexico has sunk in the North Pacific Ocean, weeks after its crew was forced to abandon it due to an uncontrollable fire.