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 DEN93LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, COThe pilot's failure to maintain directional control.Jul 20, 1993 · N1113N · Substantial damageNTSB BFO93FA132Accident · 2 fatalField investigationFinal reportNorth American T-6G · Berryville, VA1.) The pilot's poor judgment in performing a maneuver in close proximity to the ground, and 2.) the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and subsequent loss of control in flight, resulting in a collision…Jul 20, 1993 · N44CT · DestroyedNTSB BFO93FA131Accident · 1 fatalField investigationFinal reportBeech C33A · Paintsville, KY1) Fatigue failure of the engine crankshaft at the number 2 main journal due to undetermined reason (s) which resulted in the total loss of engine power, and 2) the pilot not maintaining an adequate airspeed which resulted in an inadvertent stall/spin. A…Jul 20, 1993 · N3722Q · DestroyedNTSB ATL93LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poplar Branch, NCThe pilot's failure to maintain directional control during landing.Jul 20, 1993 · N5764W · Substantial damageNTSB MIA93LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Total loss of engine power due to fuel exhaustion. Contributing to the accident was inaccurate fuel comsumption calculations by the pilot-in-command.Jul 19, 1993 · N99BW · DestroyedNTSB CHI93LA264Accident · No injuriesLimited investigationFinal reportBellanca DW-1 · Grinnell, IAthe loss of engine power due to undetermined reason(s). A factor in the accident is the soft field landing site.Jul 19, 1993 · N8815W · Substantial damageNTSB BFO93LA130Accident · No injuriesLimited investigationFinal reportMooney M20J · Cooperstown, NYThe pilot's failure to attain the proper touchdown point and his delay in initiating a go-around. Other related factors were the rain and the wet runway.Jul 19, 1993 · N5817P · Substantial damageNTSB ANC93LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Kelly River Bar, AKThe pilot's failure to assure that adequate takeoff distance was available. The rough/uneven terrain was a factor.Jul 19, 1993 · N756AH · Substantial damageNTSB ANC93LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon Flat, AKThe pilot in commands misjudgment of aerodynamic maneuvering parameters (inflight decision making), and his inadvertant stall/spin entry at low altitude.Jul 19, 1993 · N1009A · DestroyedNTSB SEA93LA156Accident · 1 fatalLimited investigationFinal reportStark Rand KR-2 · Townsend, MTThe loss of engine power due to the failure of the improperly modified magneto and loss of control in flight by the PIC while maneuvering to return to the airport.Jul 18, 1993 · N2AL · DestroyedNTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.Jul 18, 1993 · N851BZ · Substantial damageNTSB CHI93LA260Accident · 2 fatalLimited investigationFinal reportChampion 7KCAB · Hill City, KSthe loss of engine power for an undetermined reason and the pilot's decision to continue flying the airplane with known deficiencies. Factors in the accident are the lack of suitable terrain available for a forced landing, the airplane's low altitude, and the…Jul 18, 1993 · N11AT · DestroyedNTSB CHI93DTK02Accident · Minor injuriesFinal reportHiller UH-12E · Milbank, SDUndeterminedJul 18, 1993 · N4028M · DestroyedNTSB CHI93DTG02Accident · No injuriesFinal reportAero Commander S2R · Hoople, NDA loss of engine power due to a cracked engine cylinder.Jul 18, 1993 · N5635X · Substantial damageNTSB BFO93LA127Accident · No injuriesLimited investigationFinal reportCessna 172P · Edgartown, MAThe pilot failed to maintain directional control during takeoff. Other related factors were: the tailwind, and the gross weight of the airplane being exceeded.Jul 18, 1993 · N52858 · Substantial damageNTSB BFO93FA128Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-65 · Danbury, CTUndetermined.Jul 18, 1993 · N34009 · DestroyedNTSB LAX93LA292Accident · Minor injuriesLimited investigationFinal reportSanders S-1C · Saint Johns, AZthe pilot's inadequate compensation for the existing cross wind conditions and his subsequent failure to maintain directional control of the aircraft.Jul 17, 1993 · N128DS · DestroyedNTSB LAX93LA291Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Thermal, CAthe pilot's inadvertent movement of the landing gear selector switch to the up position. A factor in the accident was the difference in cockpit switch layout between the PA23 and PA39 aircraft.Jul 17, 1993 · N8975Y · Substantial damageNTSB DEN93LA082Accident · No injuriesLimited investigationFinal reportCessna 305A · Belen, NMFailure of the pilot in command to maintain directional control. A factor was: a quartering tailwind.Jul 17, 1993 · N5214G · Substantial damageNTSB CHI93LA265Accident · No injuriesLimited investigationFinal reportBeech C24R · Chesterfield, MOthe pilot's improper recovery from a bounced landing.Jul 17, 1993 · N2256L · Substantial damageNTSB BFO93LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172D · New Milford, PALoss of engine engine power due to water contamination of the fuel. Factors related to the accident were the mice, which partially blocked fuel and air flow to the carburetor, and the lack of suitable terrain in the emergency landing area.Jul 17, 1993 · N2494U · Substantial damageNTSB ATL93LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Summerdale, ALThe pilot's failure to attain the proper touchdown point.Jul 17, 1993 · N65735 · Substantial damageNTSB SEA93LA155Accident · Serious injuriesLimited investigationFinal reportBeech 60 · Fairfield, IDThe pilot's improper inflt planning/decision in selecting the wrong runway for landing. A factor relating to the accident was the strong tailwind weather conditions.Jul 16, 1993 · N75CX · DestroyedNTSB MIA93LA157Accident · Serious injuriesLimited investigationFinal reportBoeing 767-322ER · Caribbean SeaTurbulence encountered during cruise flight after entering Cirrus clouds.Jul 16, 1993 · N645UA · No damageNTSB DEN93LA080Accident · Minor injuriesLimited investigationFinal reportGlasflugel Standard Libell · Boulder, COImproper rigging of the spoiler system by maintenance personnel, which caused an uncommanded spoiler deployment and prevented spoiler retraction by the pilot. A factor was unsuitable terrain for a forced landingJul 16, 1993 · N4362 · Substantial damageNTSB CHI93LA263Accident · No injuriesLimited investigationFinal reportGrumman G164B · Wyndmere, NDthe pilot's decision to land on unsuitable terrain. Factors in the accident are the wet and soft turf runway.Jul 16, 1993 · N2008 · Substantial damageNTSB CHI93LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Branson, MOthe fractured nose gear retract arm which allowed the nose gear to collapse.Jul 16, 1993 · N7636Y · Substantial damageNTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.Jul 16, 1993 · N9810M · Substantial damageNTSB BFO93LA125Accident · Serious injuriesLimited investigationFinal reportHancock- Harris Pitts Special · Independent Hil, VAThe pilot's inadequate preflight planning/preparation which resulted in fuel exhaustion and subsequent loss of engine power.Jul 16, 1993 · N3186 · Substantial damageNTSB SEA93FA153Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Battleground, WAThe pilot in command's failure to maintain adequate altitude during his maneuver.Jul 15, 1993 · N8472C · DestroyedNTSB MIA93FA156Accident · 1 fatalField investigationFinal reportMooney M20-J · Jackson, MSA power loss for undetermined reasons during takeoff, the failure of the pilot-in-command to abort the takeoff, and his improper decision to turn back to the airport when there was suitable terrain ahead for the forced landing.Jul 15, 1993 · N57287 · Substantial damageNTSB MIA93FA155Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Jacksonville, FLAn explosion and fire from undetermined fuel and ignition sources in the left wing.Jul 15, 1993 · N2200Q · DestroyedNTSB LAX93LA290Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Buckeye, AZthe pilot's failure to visually detect and avoid a power line. A factor in the accident was the twilight light condition.Jul 15, 1993 · N40203 · DestroyedNTSB DEN93LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Dermott, ARPower loss due to the total failure of the engine's master rod. Factors were an improper engine overhaul and the lack of suitable terrain for a forced landing.Jul 15, 1993 · N1009T · Substantial damageNTSB DEN93LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Burkburnett, TXThe disconnection of the up elevator cable from the control horn. A factor was the incorrect installation of the bolt and castle nut by unknown maintenance personnel.Jul 15, 1993 · N4834M · Substantial damageNTSB CHI93LA259Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Vassar, MIThe pilot's inadequate compensation for the crosswind.Jul 15, 1993 · N2695Z · Substantial damageNTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.Jul 15, 1993 · N217ER · DestroyedNTSB ANC93LA118Accident · No injuriesLimited investigationFinal reportLake LA4 · Turner Lake, AKPilot-in-command misjudged the landing flare on a glassy water landing. A factor in the accident was the glassy water condition.Jul 15, 1993 · N2672P · Substantial damageNTSB MIA93GA154Accident · 4 fatalFinal reportSikorsky UH-60A · Hortense, GAThe pilot-in-command's inadequate supervision of the flight, the co-pilot's failure to maintain an adequate altitude, and the failure of both pilots to see and avoid the wires. Contributing to the accident was the pilot-in-command's inadequate preflight…Jul 14, 1993 · USA · DestroyedNTSB DEN93LA078Accident · No injuriesLimited investigationFinal reportCessna 172XP · Allen, TXFuel exhaustion induced power loss. A factor was the lack of suitable terrain for the forced landing.Jul 14, 1993 · N736TJ · Substantial damageNTSB ATL93LA128Accident · Minor injuriesLimited investigationFinal reportBrown Glassair SH-2 · Timmonsville, SCThe pilot's inadequate fuel planning which resulted in the exhaustion of the fuel supply and the loss of engine power. A factor was the pilot's failure to comply with a manufacturer's service bulletin.Jul 14, 1993 · N412NV · Substantial damageNTSB ANC93LA119Accident · No injuriesLimited investigationFinal reportTaylorcraft TC19 · Resurrect'N Bay, AKThe pilot-in-command's failure to maintain directional control upon landing.Jul 14, 1993 · N3541T · Substantial damageNTSB ANC93LA117Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control during taxi. Factor is the rough/rutted condition of the airstrip.Jul 14, 1993 · N4946M · Substantial damageNTSB LAX93LA289Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · La Jolla, CAthe failure of the injured ground crewman to release his hold on the basket in a timely manner when instructed by the pilot.Jul 13, 1993 · N2809D · No damageNTSB FTW93LA215Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.Jul 13, 1993 · N9780 · Substantial damageNTSB CHI93LA256Accident · Minor injuriesLimited investigationFinal reportQuad City Challenger II Specia · Ottawa, ILThe pilot in command's failure to maintain proper clearance. Factors to the accident include an oil fouled spark plug and a power ground cable.Jul 13, 1993 · N415JR · Substantial damageNTSB CHI93LA254Accident · No injuriesLimited investigationFinal reportGrumman G164B · Eldred, MNthe pilot's failure to maintain directional control during the takeoff roll.Jul 13, 1993 · N48518 · Substantial damageNTSB BFO93LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150J · East Corinth, METhe pilot's misjudgement of airspeed while making a precautionary landing without airspeed indication, and the block pitot tube.Jul 13, 1993 · N50896 · Substantial damageNTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.Jul 12, 1993 · N5858G · Substantial damageNTSB SEA93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Arlington, WYFuel contamination, directives not followed by the pilot in command, and his premature flare.Jul 12, 1993 · N3774W · Substantial damage