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 DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.Aug 3, 1993 · N4816B · Substantial damageNTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.Aug 3, 1993 · N23459 · DestroyedNTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).Aug 3, 1993 · N80797 · Substantial damageNTSB SEA93LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Yellow Pine, IDThe pilot's improperly planned approach and delayed remedial action. A factor related to the accident was: the proximity of mountainous terrain.Aug 2, 1993 · N9554H · Substantial damageNTSB MIA93IA168Incident · No injuriesIncident investigationFinal reportBoeing 707-341 · Miami, FLThe improper inspection of the engine core cowling, which resulted in fatigue cracks in the forward inboard hinge support structure to go undetected. This resulted in the hinge separating and the cowling separating in flight.Aug 2, 1993 · N107BV · Minor damageNTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.Aug 2, 1993 · N508UA · Substantial damageNTSB CHI93LA304Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Coffeyville, KSUndetermined.Aug 2, 1993 · N25TC · Substantial damageNTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.Aug 2, 1993 · N49899 · Substantial damageNTSB CHI93DCD03Accident · 1 fatalFinal reportHoward W. Dutton Glas AIR II RG · Mt. Pleasant, IAthe pilot-in-command's not maintaining aircraft control.Aug 2, 1993 · N92T · DestroyedNTSB ATL93LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moncks Corner, SCFailure of the number one cylinder at the cylinder flange radius.Aug 2, 1993 · N7027P · Substantial damageNTSB ANC93T#A03Accident · No injuriesClass 3Final reportDe Havilland DHC-2 · Samsing Cove, AKAug 2, 1993 · N450DB · Substantial damageNTSB ANC93LA131Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Kodiak, AKThe pilot in command did not use the airplane checklist. A factor was his diverted attention to other mission related activities.Aug 2, 1993 · N9526F · Substantial damageNTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.Aug 1, 1993 · N95HH · Substantial damageNTSB SEA93LA168Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Ephrata, WAInadequate visual lookout by both pilots, resulting in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: failure of the Grumman 164B pilot to adequately monitor the UNICOM frequency.Aug 1, 1993 · N5958J · 2 aircraft · DestroyedNTSB NYC93LA143Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Milford, NHUnfavorable winds during landing which resulted in a hard landing and one passenger sustaining a broken angle.Aug 1, 1993 · N2574M · No damageNTSB FTW93LA225Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Osceola, ARInadvertent stall. Factors were the improper latching of the engine cowling by the pilot and his inadequate preflight inspection.Aug 1, 1993 · N4021C · Substantial damageNTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 1, 1993 · N66081 · Substantial damageNTSB FTW93LA223Accident · No injuriesLimited investigationFinal reportBeech 35-33 · Guymon, OKThe pilot's inadequate compensation for wind conditions. Factors were windshear and gusty crosswinds.Aug 1, 1993 · N864R · Substantial damageNTSB CHI93LA301Accident · 1 fatalLimited investigationFinal reportCessna 180 · Naubinway, MIThe pilot's improper flare for landing. Factors associated with the accident are the low clouds and fog, the rough water at the landing site, and the pilot's continued flight into known adverse weather.Aug 1, 1993 · CFPTU · Substantial damageNTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.Aug 1, 1993 · N3025 · Substantial damageNTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.Aug 1, 1993 · N4864Q · Substantial damageNTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.Aug 1, 1993 · N6255R · Substantial damageNTSB ATL93LA138Accident · No injuriesLimited investigationFinal reportMolino PIK-20 · Jonesville, NCThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.Aug 1, 1993 · N3WX · Substantial damageNTSB ANC93LA133Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Soldotna, AKThe pilot's failure to attain a proper touchdown point. A factor was the pilot's improper in flight planning/decision.Aug 1, 1993 · N68578 · Substantial damageNTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.Aug 1, 1993 · N3680C · Substantial damageNTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.Aug 1, 1993 · N91219 · Substantial damageNTSB MIA93WA167Accident · 4 fatalForeign investigationPiper PA-23-250 · Marsh Harbor, BahamasJul 31, 1993 · N2402Z · DestroyedNTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.Jul 31, 1993 · N3053N · Substantial damageNTSB LAX93LA310Accident · Minor injuriesLimited investigationFinal reportNall Varieze · Newark, CAImproper annual inspection performed by other maintenance personnel. Factors relating to this accident were the loose exhaust bolts.Jul 31, 1993 · N75PD · DestroyedNTSB LAX93FA311Accident · 3 fatalField investigationFinal reportRobinson R44 · El Monte, CAFatigue failure of the cyclic control (stick) assembly, which resulted in loss of cyclic (pitch & roll) control.Jul 31, 1993 · N445RH · DestroyedNTSB FTW93LA221Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Burnet, TXInadvertent groundloop by the pilot.Jul 31, 1993 · N65355 · Substantial damageNTSB FTW93FA222Accident · Serious injuriesField investigationFinal reportHarral Glasair 1 · Rusk, TXThe pilot's failure to select the proper fuel tank which resulted in a fuel starvation engine power loss and his inadvertant entry into a stall during the ensuing forced landing.Jul 31, 1993 · N16LA · DestroyedNTSB DEN93LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corpus Christi, TXAn inadvertent stall. A factor was the pilot's intentional buzzing at low altitude over the beach.Jul 31, 1993 · N5115B · Substantial damageNTSB DEN93LA092Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Galveston, TXThe disconnection of the throttle linkage and the resultant power loss. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1993 · N8161V · Substantial damageNTSB CHI93LA307Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Excelsior Spgs, MOthe private pilot's failure to maintain adequate aircraft control during landing.Jul 31, 1993 · N4411V · Substantial damageNTSB CHI93LA305Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Clarinda, IAThe commercial pilot's failure to maintain adequate clearance from obstacles during aerial application maneuvers.Jul 31, 1993 · N8480E · DestroyedNTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.Jul 31, 1993 · N703SR · Substantial damageNTSB BFO93LA143Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Danielson, CTUndetermined.Jul 31, 1993 · N21918 · DestroyedNTSB ANC93LA143Accident · 2 fatalLimited investigationFinal reportArtic S-1B2 · Johnson Glacier, AKThe pilot's attempted flight in an airplane which exceeded the maximum allowable weight. The high mountainous terrain was a factor.Jul 31, 1993 · N59AT · DestroyedNTSB MIA93LA166Accident · No injuriesLimited investigationFinal reportCessna 414 · Lake City, FLThe failure of the pilot-in-commmand to properly flare before touchdown and the pilot's decision to land with excessive airspeed. A contributing factor was the aprehension/anxiety of the pilot during the precautionary landing.Jul 30, 1993 · N4232C · Substantial damageNTSB LAX93LA309Accident · 1 fatalLimited investigationFinal reportCessna 182P · Dayton, NVThe pilot's failure to maintain an altitude sufficient to clear terrain due to alcohol and drug impairment.Jul 30, 1993 · N8185M · DestroyedNTSB LAX93LA308Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Verdi, NVThe instructor's improper supervision of the flight; the dual student's improper in-flight decision to follow another helicopter on departure and the dual students delay in correcting the inadvertent yaw. Factors related to this accident was the inadvertent…Jul 30, 1993 · N549SM · Substantial damageNTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.Jul 30, 1993 · N2464P · Substantial damageNTSB FTW93LA220Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Elaine, ARThe pilot's failure to maintain clearance of water spraying and the resultant power loss. A factor was unsuitable terrain for the forced landing.Jul 30, 1993 · N8842Q · Substantial damageNTSB DEN93LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pagosa Springs, COThe decision by the pilot in command to fly at an altitude insufficient for the surrounding terrain. Factors were: the pilot's attention being momentarily diverted and the airplane's climb performance being exceeded.Jul 30, 1993 · CGLIL · DestroyedNTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.Jul 30, 1993 · N7319V · Substantial damageNTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.Jul 30, 1993 · N9014T · Substantial damageNTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.Jul 30, 1993 · N8521E · Substantial damageNTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.Jul 30, 1993 · N8163A · Substantial damageNTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…Jul 30, 1993 · N707BP · 2 aircraft · Destroyed