NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 FTW99LA134Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164-B · Garwood, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A related factor was the high density altitude.NTSB FTW99LA133Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lancaster, TXThe pilot's inadequate preflight inspection which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB FTW99FA132Accident · No injuriesField investigationFinal reportGrumman American AA-5B · Claremore, OKThe fatigue fracture of the propeller bolts resulting from the improper installation of the propeller assembly.NTSB DEN99LA076Accident · No injuriesLimited investigationFinal reportCessna 150M · Maybell, COThe pilot's inadvertent stall while maneuvering. Factors were the wind gusts weather conditions, and the high density altitude weather conditions.NTSB DEN99FA075Accident · 2 fatalField investigationFinal reportPiper PA-11 · Lander, WYThe pilot inadvertently stalling the airplane. Factors were his abrupt maneuvering of the airplane to avoid a powerline, and his attention being diverted.NTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.NTSB ATL99FA081Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Vicksburg, MSThe pilot's failure to obtain and maintain flying speed that resulted in an inadvertent stall, and the collision with trees. A factor is the dark night.NTSB ANC99LA060Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Pedro Bay, AKA separation of the number 3 engine cylinder head assembly, and a burned through fuel line.NTSB SEA99LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Detroit, ORThe pilot's inadvertent visual flight rules flight into instrument meteorological conditions, eventually resulting in a non-mechanical loss of engine power. Factors were: the pilot's inadequate preflight planning and preparation; a snowstorm with icing…NTSB LAX99LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Maxwell, CAFailure of the pilot to attain and maintain the proper reference climb airspeed during the rotation and initial climb, which resulted in a stall/mush condition.NTSB FTW99LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sulphur Springs, TXThe delayed aborted takeoff by the pilot-in-command. Factors were the short runway, the tall grass, and the tree.NTSB DEN99LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burlington, WYThe pilots' inadequate preflight planning for take off in that he failed to consider the takeoff surface not being a paved surface. A factor was loose material on the roadway used for take off.NTSB ANC99LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Galena, AKThe pilot-in-command's inadvertent stall during the flare for landing. A factor associated with the accident was the pilot-in-command's obstructed view of the airspeed indicator.NTSB NYC99FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA28RT-201T · Plymouth, MAundetermined (missing airplane)NTSB LAX99LA172Accident · No injuriesLimited investigationFinal reportBeech A36 · San Diego, CAThe pilot's failure to maintain a visual lookout while taxiing resulting in the aircraft's colliding with a runway sign. Contributing factors were dusk light conditions, the sign, and the pilot's diverting his attention to aircraft instrumentation during taxi.NTSB LAX99LA171Accident · Minor injuriesLimited investigationFinal reportWidner RV-3A · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition and his subsequent failure to maintain directional control during the takeoff roll. The pilot's distraction in looking for the aircraft which announced an intention to land in the…NTSB LAX99LA170Accident · No injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Reno, NVThe flight instructor's improper supervision of the pilot trainee and his failure to make timely control inputs in order to maintain aircraft control.NTSB DEN99LA073Accident · Minor injuriesLimited investigationFinal reportDavis RV-6A · Truth Or Cnsqnc, NMA soft runway surface that caused the airplane to nose over.NTSB CHI99LA145Accident · Serious injuriesLimited investigationFinal reportBoeing 737-222 · Chicago, ILthe flight attendants did not follow the cockpit crews instructions to be seated because of expected turbulence. A factor associated with the accident was the turbulence encountered.NTSB NYC99LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, OHA loss of engine power for undetermined reasons.NTSB MIA99FA150Accident · 1 fatalField investigationFinal reportCessna 172 · Fontana, NCthe pilot continued visual flight into know weather conditions which resulted in reduced visibility, and the subsequent in-flight collision with rising terrain. Factors in this accidents were clouds and low ceiling in the accident area.NTSB ANC99TA058Accident · 1 fatalFinal reportBell UH-1B · Wrangell, AKThe pilot-in-command's failure to maintain sufficient distance from a transmission wire, arcing of the transmission wire, the failure of company personnel to utilize a nonconducting cable, and an inadequate procedure utilized by the construction project…NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB LAX99LA169Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lancaster, CAThe pilot's decision to attempt a ground turning maneuver in wind conditions beyond the capability of the aircraft.NTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB CHI99LA142Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Houghton Lake, MIThe loss of engine power for undetermined reasons.NTSB SEA99WA057Accident · 2 fatalForeign investigationPiper PA-60-602P · Tambon Tha Chal, IndiaNTSB NYC99LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Oswego, NYThe pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.NTSB DEN99FA071Accident · 3 fatalField investigationFinal reportMooney M20E · Cedar City, UTThe pilot's inadequate fuel consumption calculations. Factors were the loss of engine power due to fuel exhaustion and the obscuring weather conditions.NTSB NYC99LA104Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbus, OHThe pilot's failure to maintain obstacle clearance and his visual perception of the perimeter road as Taxiway Charlie. A factor in the accident was the absence of a sign identifying the perimeter road.NTSB NYC99LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Cross Keys, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the gusty wind conditions.NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB NYC99FA100Accident · 1 fatalField investigationFinal reportStock S-1S · Westtown, NYThe pilot's inability to recover from an intentional stall spin maneuver. A factor in the accident was the change in the airplane's center of gravity which made the airplane more difficult to recover from a spin.NTSB MIA99LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chattanooga, TNThe failure of the student pilot to maintain directional control during the flare/touchdown.NTSB LAX99LA168Accident · No injuriesLimited investigationFinal reportR.M. Bishop Aero Spec 2150 · Payson, AZThe pilot's inadequate use of the rudder controls to maintain directional control during the takeoff roll, which resulted in veering off the runway and ground looping in tall vegetation.NTSB FTW99LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Claremore, OKThe pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.NTSB DEN99FA072Accident · 2 fatalField investigationFinal reportCessna 182B · Pagosa Springs, COThe pilot's disregard of the adverse weather forecast, and his flight into known adverse weather by flying into instrument meteorological conditions. Factors were the existing weather conditions that included low ceilings, obscuration, and icing conditions,…NTSB CHI99LA139Accident · No injuriesLimited investigationFinal reportCessna 182C · Loraine, ILA fuel system related fire in the engine compartment.NTSB CHI99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bonner Springs, KSthe pilot's failure to obtain sufficient altitude during the aborted landing to clear obstacles at the end of the field. Factors associated with the accident were poor preflight planning/preparation, the tailwind, the telephone pole, and the trees.NTSB CHI99FA140Accident · 3 fatalField investigationFinal reportPiper PA-28R-201 · Curran, MIthe inadvertent stall/mush. Factor which contributed to this accident were the pilot's inadequate preflight planning, the premature lift-off during the takeoff, the airplane's low airspeed following lift-off, and the trees.NTSB ATL99LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Murfreesboro, TNThe pilot's misjudgment of altitude and distance to the runway.NTSB ANC99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent ground loop. A factor in the accident was a quartering tailwind.NTSB ANC99FAMS1Accident · 2 fatalMissing aircraftFinal reportPiper PA-24-260 · Juneau, AKUndetermined. Missing aircraft.NTSB NYC99LA102Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · New Milford, CTThe manufacturer's use of inadequate adhesive material which resulted in the de-bonding and subsequent failure of the wing spar pin-lock assembly.NTSB MIA99LA144Accident · No injuriesLimited investigationFinal reportCessna 172H · Sylvan Springs, ALThe total loss of engine power for undetermined reasons.NTSB IAD99FA041Accident · 3 fatalField investigationFinal reportCessna 305A · Hilltown, PAThe inadequate lookout of both pilots, and the pilot of the other aircraft.NTSB FTW99LA128Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Conroe, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Marfa, TXThe pilot's failure to maintain clearance with the dirt bank during the landing flare.