The plane had taken off from Austin and was attempting to land at Phoenix-Scottsdale Municipal Airport when its landing gear reportedly collapsed. The pilot died in the crash