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.

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.May 31, 1993 · N2790X · Substantial damageNTSB 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.May 31, 1993 · N6051F · Substantial damageNTSB 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.May 31, 1993 · N44227 · Substantial damageNTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.May 31, 1993 · N37139 · Substantial damageNTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.May 31, 1993 · N2342Y · Substantial damageNTSB 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.May 31, 1993 · N30041 · Substantial damageNTSB 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.May 31, 1993 · N2892S · DestroyedNTSB 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.May 31, 1993 · N74092 · Substantial damageNTSB 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.May 31, 1993 · N333DG · Substantial damageNTSB ANC93LA075Accident · No injuriesLimited investigationFinal reportCessna 185F · Gustavus, AKThe pilot misjudging his speed while landing on a wet grass strip.May 31, 1993 · N185TD · Substantial damageNTSB ANC93LA074Accident · No injuriesLimited investigationFinal reportCessna 170 · Soldotna, AKThe inadequate handling of the airplane by the pilot-in-command.May 31, 1993 · N1260D · Substantial damageNTSB ANC93IA076Incident · No injuriesIncident investigationFinal reportCessna 310 · Kodiak, AKThe failure of the nose gear idler bell crank due to overstress by an undetermined source.May 31, 1993 · N5847M · Minor damageNTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.May 30, 1993 · N91633 · DestroyedNTSB DEN93LA064Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Buena Vista, COFailure to follow procedures and directives when operating the flaps.May 30, 1993 · N173 · Substantial damageNTSB 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.May 30, 1993 · N2816A · Substantial damageNTSB 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.May 30, 1993 · N8385 · DestroyedNTSB ANC93LA073Accident · No injuriesLimited investigationFinal reportCessna 140 · Dillingham, AKThe pilot in command's failure to maintain proper runway alignment.May 30, 1993 · N1926V · Substantial damageNTSB SEA93FA125Accident · 3 fatalField investigationFinal reportCessna 172P · Enumclaw, WAInadvertent VFR flight into IMC. Factors to the accident were: fog and rain.May 29, 1993 · N53408 · DestroyedNTSB 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.May 29, 1993 · N5783V · Substantial damageNTSB MIA93LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pensacola, FLThe pilot-in-command's inadequate compensation for wind conditions and delayed remedical action.May 29, 1993 · N4156V · Substantial damageNTSB 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.May 29, 1993 · N5388T · Substantial damageNTSB 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.May 29, 1993 · N2962D · Substantial damageNTSB LAX93LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Turlock, CAThe pilot's poorly planned approach and his failure to maintain airspeed.May 29, 1993 · N12857 · DestroyedNTSB 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 highwayMay 29, 1993 · N6924S · Substantial damageNTSB ATL93LA097Accident · No injuriesLimited investigationFinal reportLet L-13 · Elberta, ALThe pilot's inadequate preflight planningMay 29, 1993 · N640RM · Substantial damageNTSB ANC93LA072Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain control of the airplane during landing.May 29, 1993 · N1763U · Substantial damageNTSB ANC93LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Bulchitna Lake, AKThe failure of the landing gear leg due to a fatigue fracture caused by corrosion.May 29, 1993 · N80124 · Substantial damageNTSB 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.May 28, 1993 · N43387 · Substantial damageNTSB 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.May 28, 1993 · N21530 · Substantial damageNTSB 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.May 28, 1993 · N2R · DestroyedNTSB 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…May 28, 1993 · N4198T · Substantial damageNTSB SEA93LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Bellevue, WAFailure of the right main landing gear shock strut.May 27, 1993 · N2215T · Substantial damageNTSB 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.May 27, 1993 · N43LL · Substantial damageNTSB 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.May 27, 1993 · N11831 · Substantial damageNTSB 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.May 27, 1993 · N8278M · Substantial damageNTSB LAX93LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hesperia, CAFatigue failure of the exhaust valve due to inadequate maintenance and inspection.May 27, 1993 · N4820T · Substantial damageNTSB 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.May 27, 1993 · N5272Y · Substantial damageNTSB 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.May 27, 1993 · N4593 · Substantial damageNTSB 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.May 27, 1993 · N3109V · Substantial damageNTSB 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.May 27, 1993 · N3333P · Substantial damageNTSB 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.May 27, 1993 · N714AN · Substantial damageNTSB 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.May 27, 1993 · N782LF · DestroyedNTSB 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…May 27, 1993 · N60347 · Substantial damageNTSB ATL93T#A01Accident · No injuriesFinal reportBellanca 8GCBC · Billingsley, ALMay 27, 1993 · N88111 · Substantial damageNTSB ANC93LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot in command's inadvertent ground loop.May 27, 1993 · N4388Z · Substantial damageNTSB 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.May 26, 1993 · N6644A · Substantial damageNTSB 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.May 26, 1993 · N58407 · Substantial damageNTSB 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.May 26, 1993 · N48632 · DestroyedNTSB 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.May 26, 1993 · N2312N · Substantial damageNTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.May 26, 1993 · N8405K · Destroyed