NTSB investigations, AZ
33 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 2 |
| 2011 | 6 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 2 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR25LA148Accident · No injuriesClass 3 · LimitedPreliminary reportRutan LONG-EZE · Tucson, AZOn May 1, 2025, about 1030 mountain standard time, an experimental amateur-built Long EZE, N433EZ, was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR24LA061Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Prescott, AZLoss of directional control during landing due to an improperly constructed and maintained tailwheel locking assembly.NTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.NTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…NTSB WPR20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 208 · Whitmore, AZA loss of directional control during landing due to a flat main landing gear tire, which resulted in a lateral runway excursion and impact with terrain.NTSB WPR19LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Phoenix, AZThe failure of the landing gear due to the nose gear being positioned to the far right during retraction, which caused the nose gear to jam upon retraction.NTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.NTSB WPR17LA121Accident · No injuriesLimited investigationFinal reportBob Frederick Titan T-51 · Goodyear, AZFailure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.NTSB WPR15IA244Incident · No injuriesIncident investigationFinal reportQuest Kodiac 100 · Page, AZThe pilot's inadvertent failure to engage the seat in the locked position before takeoff, which resulted in the seat sliding back during the takeoff roll and a subsequent loss of directional control. Contributing to the incident was the seat locking…NTSB WPR15LA183Accident · No injuriesLimited investigationFinal reportBeech E33A · Tucson, AZA loss of left braking action for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation, which resulted in a loss of…NTSB WPR15IA080Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Beta II · Phoenix, AZThe failure of the fanshaft due to fatigue.NTSB WPR15LA038Accident · No injuriesLimited investigationFinal reportCessna 210B · Bullhead City, AZThe failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.NTSB WPR15IA035Incident · No injuriesIncident investigationFinal reportNorth American P51 - D · Mesa, AZThe failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…NTSB WPR14CA390Accident · No injuriesData collectionFinal reportWilliam M Oprendek Pitts S1S · Sedona, AZFailure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.NTSB WPR14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Carefree, AZThe failure of the left brake master cylinder seal, which rendered the left brake inoperative during landing.NTSB WPR12FA191Accident · Serious injuriesField investigationFinal reportHughes 269C · Phoenix, AZA loss of tail rotor drive due to a fatigue failure of the main transmission pinion, which resulted in a loss of directional control during cruise flight.NTSB WPR12LA039Accident · Serious injuriesLimited investigationFinal reportWilliams Helicopter UH-1H · Grand Canyon, AZThe loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.NTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…NTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.NTSB WPR11LA245Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Lake Havasu, AZThe failure of the low pressure switch in the normal landing gear system, which prevented normal operation of that system, and the misrigging of the emergency extension gear release valve, which prevented the system from being depressurized to allow for the…NTSB WPR11CA197Accident · No injuriesData collectionFinal reportXtremeair Sbach 342 · Springerville, AZThe pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.NTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.NTSB WPR11IA019Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZThe overextension of the main cabin door due to difficulty opening the door because the power-assist motor cable was lodged within the main cabin door assembly.NTSB WPR10LA216Accident · No injuriesLimited investigationFinal reportCessna 210 · Show Low, AZInadequate clearance between a landing gear brake system line and airframe components, which precluded gear extension and resulted in an intentional gear-up landing.NTSB WPR10LA004Accident · No injuriesLimited investigationFinal reportCessna 172A · Payson, AZThe stress corrosion cracking of the nose gear landing fork, which resulted in the fork's failure during landing.NTSB WPR09LA253Accident · 2 fatalLimited investigationFinal reportGauchat Safari · Rock Springs, AZThe separation of the main rotor head during cruise flight as a result of cyclic fatigue of the main rotor head spindle. The fatigue crack was due to an inadequate manufacturing process.NTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…NTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB WPR09CA017Accident · No injuriesData collectionFinal reportPiper L-4 · Buckeye, AZAnother airplanes total loss of wheel brakes while taxing which resulted in the pilot of the other aircraft colliding with a standing aircraft. Contributing to the accident was the other airplanes low brake hydraulic fluid.NTSB LAX08LA269Accident · No injuriesLimited investigationFinal reportCessna TU206F · Glendale, AZA loose fuel line fitting that resulted in a partial loss of engine power during the initial takeoff climb. Contributing to the accident was inadequate maintenance installation of the fitting.