SpaceX's latest test flight was a failure. The company has seen mixed results after more than two years of launching test flights.