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 LAX93LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Davenport, CAThe pilot's failure to maintain directional control to avoid the high vegetation. Factors relating to this accident were the failure of the pilot to obtain the climb airspeed and the inadvertent stall/mush.NTSB FTW93LA171Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Harrisburg, ARThe loss of engine power due to the failure of the reduction gear assembly due to fatigue. A factor was the lack of suitable terrain for the forced landing.NTSB CHI93LA187Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sandwich, ILThe fixed-wing student pilot's poor judgement in attempting to fly a rotary wing aircraft, and the subsequent loss of control in-flight. The pilot's inadequate training in rotary wing aircraft was a factor.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.NTSB BFO93LA099Accident · No injuriesLimited investigationFinal reportCessna 177 · Newport, NHThe pilot's failure to properly recover from a bounced landing, and his failure to maintain directional control during the aborted landing.NTSB BFO93LA098Accident · 1 fatalLimited investigationFinal reportCessna 150 · Milroy, PAThe pilot's inadvertent flight into instrument meteorological conditions, and his failure to maintain clearance with terrain. Factors related to the accident include mountain obscuration and fog.NTSB ATL93LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA5B · Cummings, GAThe loss of engine power resulting from the formation of carburetor ice during the ground operation. A factor was the pilot's failure to obtain a weather briefing.NTSB ANC93LA079Accident · No injuriesLimited investigationFinal reportCessna A185F · Kahiltna Glacie, AKThe pilot-in-command not maintaining directional control. A factor is the rough condition of the glacier airstrip.NTSB ANC93LA075Accident · No injuriesLimited investigationFinal reportCessna 185F · Gustavus, AKThe pilot misjudging his speed while landing on a wet grass strip.NTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.NTSB ANC93IA076Incident · No injuriesIncident investigationFinal reportCessna 310 · Kodiak, AKThe failure of the nose gear idler bell crank due to overstress by an undetermined source.NTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.NTSB DEN93LA064Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Buena Vista, COFailure to follow procedures and directives when operating the flaps.NTSB CHI93LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INa misjudged flare and subsequent hard landing by the student pilot. A factor in the accident was the student pilot's failure to perform a go-around.NTSB CHI93DCQ01Accident · 1 fatalFinal reportGrumman G-164A · Liberal, KSthe pilot's failure to maintain clearance with the powerlines. A factor related to the accident were the powerlines which were contacted during the aerial application operation.NTSB ANC93LA073Accident · No injuriesLimited investigationFinal reportCessna 140 · Dillingham, AKThe pilot in command's failure to maintain proper runway alignment.NTSB SEA93FA125Accident · 3 fatalField investigationFinal reportCessna 172P · Enumclaw, WAInadvertent VFR flight into IMC. Factors to the accident were: fog and rain.NTSB MIA93LA136Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Laurel, MSA ruptured center bellows seal in the fuel servo and/or a plugged fuel injector due to contamination (rust) from the fuel servo. Factors related to the accident were: improper servicing of the aircraft, and people and trees in the emergency landing area.NTSB MIA93LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pensacola, FLThe pilot-in-command's inadequate compensation for wind conditions and delayed remedical action.NTSB LAX93LA236Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Sedona, AZA failure of the pilot to adequately compensate for the wind conditions and subsequent loss of directional control during the landing roll. A factor in the accident was a lack of total experience in the aircraft type.NTSB LAX93LA232Accident · No injuriesLimited investigationFinal reportCessna 170B · Escondido, CAThe pilot-in-command's improper use of the brakes. The high vegetation was a factor in the accident.NTSB LAX93LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Turlock, CAThe pilot's poorly planned approach and his failure to maintain airspeed.NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayNTSB ATL93LA097Accident · No injuriesLimited investigationFinal reportLet L-13 · Elberta, ALThe pilot's inadequate preflight planningNTSB ANC93LA072Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain control of the airplane during landing.NTSB ANC93LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Bulchitna Lake, AKThe failure of the landing gear leg due to a fatigue fracture caused by corrosion.NTSB SEA93LA126Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's inadequate remedial action. Factors include crosswinds, gusts, and the pilot's lack of total experience in tailwheel type aircraft.NTSB MIA93LA134Accident · No injuriesLimited investigationFinal reportCessna 182P · Corinth, MSFailure of the engine over terrain unsuitable for a forced landing. Contributing to the accident was the failure of the no. 5 piston for undetermined causes.NTSB LAX93FA231Accident · 4 fatalField investigationFinal reportBeech D-50E · Lee Vining, CAThe pilot's inadequate weather evaluation; inadequate in-flight planning and decision making; and the pilot's continued VFR flight into instrument meteorological conditions.NTSB ANC93FA070Accident · No injuriesField investigationFinal reportCessna 320 · Anchorage, AKAn undetermined failure that resulted in an overvoltage condition of the electrical system, overheating of the battery, overdrive (overtorque) of the landing gear extension system, a disconnect of the emergency extension system, and a susbsequent collapse of…NTSB SEA93LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Bellevue, WAFailure of the right main landing gear shock strut.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB MIA93LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Myers, FLFailure of the pilot-in-command to perform in-flight fuel consumption calculations. The lack of suitable terrain for a forced landing was a factor.NTSB MIA93LA131Accident · No injuriesLimited investigationFinal reportCessna 210K · Myakka, FLThe failure of the No. 2 piston connecting rod for undetermined reasons. Contributing to the accident was a forced landing to unsuitable terrain.NTSB LAX93LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hesperia, CAFatigue failure of the exhaust valve due to inadequate maintenance and inspection.NTSB FTW93LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Searcy, ARTotal power loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB FTW93LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Weiner, ARPartial power loss due to improper installation of the linkage control bracket. A factor was the lack of suitable terrain for the forced landing.NTSB CHI93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Jeffersonville, INThe flight instructor's delayed remedial action and failure to assure recovery from a bounced landing. A factor related to the accident was: improper flare by the student pilot.NTSB CHI93LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Ely, MNthe pilot's decision to continue flight with a known deficiency in the airplane's hydraulic system. Factors associated with the accident are the loss of power in the left engine due to fuel contamination, and a leak in the hydraulic system.NTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.NTSB CHI93FA182Accident · 2 fatalField investigationFinal reportAerospatiale AS-350B · Cameron, MOThe loss of engine power due to failure of the second stage turbine labyrinth seal. Factors related to the accident were: the unfavorable wind and tall trees bordering the emergency landing area.NTSB BFO93LA101Accident · No injuriesLimited investigationFinal reportCessna 150 · Brandenburg, KYThe pilot's failure to attain adequate airspeed prior to liftoff, leading to an inadvertent stall and loss of aircraft control. Factors related to the accident include the pilot's improper use of flaps and his failure to follow the published procedures for a…NTSB ATL93T#A01Accident · No injuriesFinal reportBellanca 8GCBC · Billingsley, ALNTSB ANC93LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot in command's inadvertent ground loop.NTSB LAX93LA228Accident · No injuriesLimited investigationFinal reportWSK PZL KR-03A · Avenal, CAThe glider's encounter with the downdraft. Contributing to this accidents were the turbulence and the powerlines.NTSB LAX93LA227Accident · No injuriesLimited investigationFinal reportHughes 269C · Van Nuys, CAthe student pilot's failure to maintain the altitude while maneuvering toward the parking area. The student pilot's lack of total experience was a factor in this accident.NTSB LAX93LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAThe pilot's failure to maintain directional control. A factor related to this accident was the left quartering tailwind.NTSB LAX93LA224Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Pacoima, CAThe student pilot's failure to maintain directional control, his improper use of the throttle and antitorgue pedals. A factor related to this accident was the student's lack of total experience.NTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.