NTSB investigations, AZ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WPR13CA158Accident · No injuriesData collectionFinal reportCessna 172 · Gila Bend, AZThe student pilot’s failure to maintain clearance from an above-ground fuel tank while taxiing.NTSB WPR13CA162Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR13CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chino Valley, AZThe pilot receiving instruction’s failure to maintain rotor rpm during the pinnacle landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.NTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.NTSB WPR13LA135Accident · Serious injuriesLimited investigationFinal reportSummit II · Quartzsite, AZThe noncertificated pilot’s failure to maintain aircraft control after encountering shifting wind, which resulted in collision with a windsock.NTSB WPR13FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Tucson, AZThe pilot's incapacitation due to his preexisting cardiac disease, which resulted in his degraded or complete loss of ability to control the airplane.NTSB WPR13FA115Accident · 2 fatalField investigationFinal reportBeech E90 · Casa Grande, AZThe pilot’s loss of control of the airplane after pitching it excessively nose up during a go-around, which resulted in a subsequent aerodynamic stall/spin.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB WPR13CA092Accident · No injuriesData collectionFinal reportHeinz Rans S-4 Coyote · Lake Pleasant, AZA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR13FA074Accident · 1 fatalField investigationFinal reportCharland Vortex · Wellton, AZThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB WPR13FA072Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Payson, AZThe airplane’s inadvertent encounter, in night instrument meteorological conditions, with unforecast strong up- and downdrafts and possibly severe airframe icing conditions (which likely included supercooled large droplets that the airplane was not…NTSB WPR13CA064Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Roosevelt Lake, AZThe pilot's visual disorientation, which resulted in a collision with the lake.NTSB WPR13LA060Accident · No injuriesLimited investigationFinal reportPiper PA30 · Phoenix, AZThe pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…NTSB WPR13TA051Accident · Minor injuriesFinal reportEurocopter AS350B3 2B1 · Newfield, AZThe pilot's distraction while retrieving an item behind him while the helicopter was on the ground with the engine running, which led to his aggressive overapplication of the flight controls after experiencing a ground resonance condition and subsequent loss…NTSB WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB WPR13LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maricopa, AZThe pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.NTSB WPR13LA034Accident · No injuriesLimited investigationFinal reportJeffair Barracuda · Payson, AZThe failure of the landing gear to remain extended during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.NTSB WPR13CA028Accident · No injuriesData collectionFinal reportSport Plane Dynamics Lightning · Casa Grande, AZThe pilot’s failure to follow specified procedures for an aborted landing and loss of control during the attempt.NTSB WPR13IA020Incident · No injuriesIncident investigationFinal reportAgusta A119 · Dolan Springs, AZInsufficient clearance between a truck and the main rotor blades of a helicopter on the ground with the engine running because of the lack of on-scene coordination between the agencies that responded to and were tasked with managing the vehicle accident site.NTSB WPR13LA015Accident · No injuriesLimited investigationFinal reportBeech N35 · Phoenix, AZA loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.NTSB WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA011Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Parker, AZThe pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…NTSB WPR13FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Marana, AZThe pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB WPR12CA438Accident · No injuriesData collectionFinal reportCessna 150 · St Johns, AZThe pilot's failure to maintain directional control during landing in gusty crosswind conditions.NTSB WPR12LA423Accident · No injuriesLimited investigationFinal reportBarney Stardustrer SA-100 · Chandler, AZA loss of engine power as a result of fuel exhaustion due to a fuel line failure. Contributing to the accident was the pilot’s failure to adhere to the maintenance inspection criteria for the airplane.NTSB WPR12CA425Accident · No injuriesData collectionFinal reportCessna 172N · Eloy, AZThe pilot's improper flare, and his inadequate recovery from a bounced landing.NTSB WPR12FA420Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Strawberry, AZThe flight instructor's and the evaluator's failure to divert at an appropriate time during cruise flight, which resulted in the airplane's inability to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was the flight…NTSB WPR12CA412Accident · No injuriesData collectionFinal reportGrob-Werke G 120A · Mobile, AZThe student pilot’s failure to maintain directional control of the airplane during the takeoff roll and the subsequent aborted takeoff in a gusting crosswind.NTSB WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.NTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.NTSB WPR12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe flight instructor’s delayed response in correcting the student pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR12CA372Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot's failure to maintain directional control while landing in a crosswind.NTSB WPR12CA342Accident · Serious injuriesData collectionFinal reportPiper PA18 · McNeal, AZThe pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high…NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR12FA326Accident · 3 fatalField investigationFinal reportBeech B60 · Sedona, AZThe airplane’s failure to rotate and the pilot’s failure to reject the takeoff, which resulted in a runway overrun for reasons that could not be undetermined because postaccident examination of the airplane and engines did not reveal any malfunctions or…NTSB WPR12LA302Accident · 1 fatalLimited investigationFinal reportBunch COZY-CANARDIII · Winslow, AZThe pilot’s failure to maintain airplane control during climb in high-density altitude conditions and with the airplane’s weight in excess of its maximum allowable gross weight.NTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…NTSB WPR12CA300Accident · No injuriesData collectionFinal reportCessna T182T · Flagstaff, AZThe pilot’s inadequate landing flare after encountering a downdraft, which resulted in a hard landing.NTSB WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…NTSB WPR12CA287Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Paulden, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12LA267Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Scottsdale, AZThe flight instructor’s failure to maintain adequate rotor rpm during a practice autorotation, which resulted in a loss of helicopter control and subsequent hard landing.