NTSB investigations, AZ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 WPR23LA306Accident · No injuriesClass 3 · LimitedFinal reportBoeing CH-46E · Springerville, AZThe flight crew’s misidentification of a No. 2 torque sensing system signal conditioner malfunction when both engines were performing normally, which resulted in their attempt to execute a single-engine steep approach and landing without sufficient engine…NTSB WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.NTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.NTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…NTSB WPR23LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Prescott, AZThe pilot’s improper landing flare, which resulted in an aerodynamic stall. Contributing to the accident was his delayed decision to initiate a go-around.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB WPR23LA201Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177B · Tucson, AZA partial loss of engine power due to restricted fuel flow resulting from foreign object debris in the fuel flow transducer.NTSB WPR23LA199Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Casa Grande, AZAn in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.NTSB WPR23LA195Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Mobile, AZThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB DCA23LA290AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 Block 1 · Elgin, AZThe pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain.NTSB WPR23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Queen Creek, AZThe airplane’s encounter with a dust devil after landing, which resulted in a loss of directional control.NTSB WPR23LA169Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe student pilot’s improper landing flare, which resulted in a hard landing and the flight instructor’s delayed remedial action.NTSB WPR23LA167Occurrence · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Page, AZThe fueler’s inadvertent addition of diesel exhaust fluid (DEF) to the FSII reservoir on the fuel truck, and its subsequent mixture with the JET A that was used to fuel the airplane, resulting in a total loss of power to the right engine and a partial loss of…NTSB WPR23LA164Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s failure to maintain directional control, and the flight instructor’s delayed remedial action.NTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB WPR23LA148Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZThe student pilot’s failure to maintain directional control during the landing roll.NTSB WPR23LA182Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Marana, AZThe pilot’s improper landing flare, which resulted in a hard bounced landing in a dust devil.NTSB WPR23LA132Accident · No injuriesClass 4 · LimitedFinal reportFay David Velocity Elite · Bullhead City, AZThe student pilot’s improper landing during crosswind conditions and the flight instructor’s failure to take remedial action, which resulted in a loss of control.NTSB WPR23LA129Accident · Serious injuriesClass 4 · LimitedFinal reportNavion Navion A · Mesa, AZThe pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision.NTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.NTSB WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.NTSB WPR23LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.NTSB WPR23LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Skull Valley, AZThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB WPR23LA075Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB WPR23LA085Accident · Minor injuriesClass 4 · LimitedFinal reportAuto-Gyro Cavalon · Benson, AZA loss of directional control on takeoff, which resulted in the collapse of the nose wheel strut and a runway excursion.NTSB WPR23LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Manual, AZThe pilot’s failure to maintain directional control during landing which, resulted in a runway excursion.NTSB WPR23LA064Accident · No injuriesClass 4 · LimitedFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna TP206A · Maricopa, AZA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s improper fuel management.NTSB WPR23LA060Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Willow Spring, AZThe airplane’s loss of engine power for undetermined reasons.NTSB WPR23LA051Accident · No injuriesClass 4 · LimitedFinal reportCosmos Phase II · Lake Havasu, AZThe pilot’s inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.NTSB WPR23LA030Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s improper decision to takeoff from an unimproved airstrip with insufficient takeoff distance which, resulted in a runway overrun and collision with vegetation.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 WPR23LA022Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Nogales, AZThe pilot’s failure to establish a positive rate of climb before retracting the landing gear when he executed an aborted landing, which resulted in a propeller strike, diminished climb performance, and the inadvertent contact with terrain.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 WPR23LA023Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Marble Canyon, AZThe pilot’s loss of directional control during a takeoff from a rough, narrow runway, resulting in an aborted takeoff and subsequent runway excursion.NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.NTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.NTSB WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.NTSB WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB WPR22FA361Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5B · Sahuarita, AZThe pilot's loss of control following a separation of the aileron carry-through cable.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 WPR22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Mesa, AZThe flight instructor’s failure to maintain control of the helicopter’s rate of descent, resulting in a hard landing.NTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…NTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.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 WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB WPR22LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Prescott, AZThe pilot receiving instructions failure to maintain directional during the takeoff ground roll and the flight instructor’s inadequate supervision.