The latest attempt to fly at over five times the speed of sound joins the long list of efforts that have ended in failure.