NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ERA23FA358Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR20 · Toms River, NJThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion), which resulted in impact with trees and terrain.NTSB ENG23WA036Incident · No injuriesClass 5 · ForeignAirbus A320 · Chihuahua, MX, MexicoNTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.NTSB CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC23LA069Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall and loss of airplane control.NTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…NTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.NTSB ERA23LA361Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Rutledge, TNA total loss of engine power due to the fatigue failure of a retaining circlip in one of the No. 2 crankshaft cheek counterweights, which resulted in liberation of the counterweight.NTSB ENG24WA002IncidentClass 5 · ForeignBoeing 737 · Rio de Janeiro, BrazilNTSB CEN23LA394Accident · Minor injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COAn in-flight collision with multiple geese during initial climb.NTSB WPR23LA333Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Three Rocks, CAThe airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.NTSB WPR23LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Coolidge, AZThe pilot's failure to extend the landing gear before landing.NTSB GAA23WA248Accident · No injuriesClass 5 · ForeignBeech 200C · Port Moresby, Papua New GuineaNTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.NTSB DCA23WA458Incident · No injuriesClass 3 · ForeignBoeing 767-332 · Prague, CzechiaNTSB CEN23LA399Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Ava, MOA loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.NTSB CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA331Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Ennis, MTThe pilot's failure to extend the landing gear before landing.NTSB GAA23WA280Accident · 3 fatalClass 5 · ForeignCessna 172N · Mountains, IcelandNTSB ERA23FA357Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Kingston, NJA loss of control, which resulted in the main rotor blade severing the tail boom, for reasons that could not be determined.NTSB CEN23LA392Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Midlothian, TXThe pilot’s failure to maintain directional control during landing which resulted in the right main landing gear collapse.NTSB CEN23LA389Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 530FF · Liberty Hill, TXThe pilot’s improper recovery from a practice autorotation resulting in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.NTSB CEN23FA391Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Wellington, COThe pilot’s loss of glider control during approach for reasons that could not be determined, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB GAA24WA027Incident · No injuriesClass 5 · ForeignFokker F28 · Adelaide Aerodrome, AustraliaNTSB DCA23WA432IncidentClass 5 · ForeignAirbus 320 · Dulles, VANTSB DCA23WA431AccidentClass 5 · ForeignAirbus A330-941 · Paris, FranceNTSB CEN23LA428Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-31A · Maurice, IAThe pilot’s failure to maintain directional control during the landing.NTSB CEN23LA407Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Greeley, COThe pilot’s failure to extend the landing gear. Contributing to the accident was a malfunction of the landing gear warning horn for undetermined reasons.NTSB CEN23LA390Accident · No injuriesClass 3 · LimitedFinal reportZlin Aviation S R O Savage Norden · Cabot, ARThe airplane manufacturer’s routing of the fuel pump wiring next to the engine’s turbocharger and exhaust, which thermally damaged the wiring and resulted in a malfunction of the fuel delivery system and a total loss of engine power.NTSB CEN23LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210B · Wichita, KSLoss of engine power for reasons that could not be determined.NTSB CEN23LA387Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Henderson, KYAn in-flight collision with a bird shortly after takeoff.NTSB ANC23LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s excessive application of brakes during landing that resulted in a nose over.NTSB WPR23LA330Accident · No injuriesClass 4 · LimitedFinal reportYamaha Fazer SAR · Reno, NVThe operator’s incorrect input into the ground station controller, resulting in a loss of control during flight and subsequent impact with terrain.NTSB GAA23WA265Accident · No injuriesClass 3 · ForeignRobinson 66 · Buenos Aires, ArgentinaNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayNTSB DCA23WA444Incident · No injuriesClass 5 · ForeignAirbus A319 · Samui, ThailandNTSB DCA23FA428Accident · Serious injuriesClass 3 · FieldFinal reportAirbus A350-941 · Atlanta, GAThe flight crew’s unintentional encounter with rapidly developing cumulus clouds which resulted in an encounter with severe convectively induced turbulence.NTSB WPR23LA326Accident · No injuriesClass 4 · LimitedFinal reportHenry Steven J JA 30 Superstol · Leavenworth, WAThe pilot's failure to maintain airplane control during taxi, which resulted in a nose over.NTSB ERA23LA353Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hopkinsville, KYThe pilot’s inadvertent encounter with helicopter wake turbulence during initial climb, which resulted in a loss of airplane control.NTSB ERA23FA352Accident · 2 fatalClass 3 · FieldFinal reportEurocopter EC135 · Pompano Beach, FLAn inflight fire outside of the engine firewalls, likely from overheating of the No. 1 engine for undetermined reasons, which resulted in a partial tailboom separation.NTSB ANC23LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chinitna Bay, AKThe pilot’s failure to maintain directional control on takeoff.NTSB WPR23LA328Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Hillsboro, ORThe student pilot’s failure to maintain airplane control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB WPR23LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Santa Fe, NMThe pilot’s improper landing flare following an unstable approach, which resulted in a hard landing.NTSB DCA23WA429IncidentClass 4 · ForeignBoeing 737 · Palma de Mallorca, SpainNTSB CEN23LA385Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206 · Hibbing, MNThe ground crew’s failure to secure the backpack at the landing zone (LZ), that resulted in the tail rotor impacting the backpack during the landing. Contributing to the accident was the pilot’s inadequate selection of an area at the LZ, the lack of awareness…NTSB CEN23LA383Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12A · Mosby, MOThe pilot’s failure to maintain adequate rotor rpm which resulted in a loss of control and impact with terrain.NTSB ANC23LA065Accident · 2 fatalClass 3 · LimitedFinal reportBeech B36TC · Cape Yakataga, AKThe pilot’s continued flight into moderate to severe icing conditions, including supercooled large droplets, over mountainous terrain, which resulted in a loss of control and impact with terrain. Contributing to the accident was the National Weather Service…NTSB GAA23WA276AccidentClass 5 · ForeignCessna 207 · Kamiji, Congo - KinshasaNTSB ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.