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 GAA23WA128AccidentClass 5 · ForeignRobinson R44 · Staverton, United KingdomNTSB GAA23WA127Accident · No injuriesClass 5 · ForeignPiper PA-23-250 · San José Pinula, GuatemalaNTSB ENG23WA026IncidentClass 5 · ForeignAirbus A320 · Puerto Vallarta, MexicoNTSB CEN23FA160Accident · Serious injuriesClass 3 · FieldFinal reportAero Vodochody L-139 · Bridgeport, TXThe pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…NTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB WPR23LA159Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Upland, CAThe pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.NTSB GAA23WA137Accident · No injuriesClass 5 · ForeignCessna 172 · Usa City, JapanNTSB GAA23WA132Accident · No injuriesClass 5 · ForeignEmbraer EMB711 · Manoel Urbano, BrazilNTSB ERA23LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · St. Augustine, FLThe pilot’s failure to extend the landing gear before landing.NTSB ERA23LA202Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 112 · Miami, FLFailure of the right main landing gear due to inadequate hydraulic pressure as result of a torn O-ring that was installed on the hydraulic pack’s check valve during overhaul.NTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB GAA23WA131Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Bankstown, AustraliaNTSB ENG23WA046IncidentClass 5 · ForeignBoeing 747 · Nairobi, KenyaNTSB DCA23WA241IncidentClass 5 · ForeignBoeing 757-232 · Mexico City, MexicoNTSB DCA23WA238Incident · No injuriesClass 5 · ForeignBoeing 747 · Nairobi, KenyaNTSB CEN23LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Fredericksburg, TXThe pilot’s failure to maintain airplane control during an attempted go-around resulting in abnormal contact with the runway pavement and a runway excursion.NTSB WPR23LA156Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Riverside, CAThe pilot’s failure to use carburetor heat during an extended ground delay before takeoff, which resulted in a total loss of engine power during initial climb due to carburetor ice.NTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.NTSB DCA23WA239Accident · No injuriesClass 5 · ForeignSaab 340 · Peten, GuatemalaNTSB WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.NTSB ERA23LA207Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Wake Forest, NCThe student pilot’s failure to maintain airspeed during the landing approach, which resulted in an exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a loss of control.NTSB ERA23LA196Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Gilford, NHThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with the runway.NTSB ERA23FA194Accident · 1 fatalClass 3 · FieldFinal reportHolland Travis E Velocity · Andrews, NCThe pilot’s failure to engage the turbocharger for takeoff and his improper decision to continue the takeoff with partial power, rather than reject the takeoff.NTSB ENG23WA025Incident · No injuriesClass 5 · ForeignAirbus A321 · Cairo, EgyptNTSB WPR23LA161Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Concord, CAThe pilot’s failure to maintain directional control of the airplane during a landing in gusting wind conditions.NTSB WPR23LA158Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18A 150 · Garrison, MOThe pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.NTSB GAA23WA136Accident · No injuriesClass 4 · ForeignJetstream 3112 · Fort Smith, CanadaNTSB GAA23WA125Accident · 1 fatalClass 5 · ForeignEmbraer EMB203 · Tapurah, BrazilNTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB ERA23LA213Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · West Mifflin, PAThe student pilot’s improper landing flare, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.NTSB DCA23WA245Incident · No injuriesClass 5 · ForeignBoeing 737 · Luqa, MaltaNTSB CEN23LA165Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Lsa Sinus · Kingsford, MIThe failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.NTSB CEN23LA156Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Evansville, INThe pilot’s failure to engage the tailwheel lock before landing which resulted in the loss of control and ground loop.NTSB CEN23FA155Accident · 1 fatalClass 3 · FieldFinal reportJunior Ace · Mammoth Springs, ARThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN23LA153Accident · Minor injuriesClass 3 · LimitedFinal reportRyan Navion A · New Waverly, TXA total loss of engine power as a result of fuel contamination.NTSB WPR23FA153Accident · 2 fatalClass 3 · FieldFinal reportMullins David J JR Glastar · Cal-Nev-Ari, NVThe pilot's failure to maintain sufficient altitude for undetermined reasons while maneuvering to land in dark night conditions, which resulted in collision with terrain.NTSB ERA23LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Charles Town, WVA loss of engine power for undetermined reasons.NTSB ERA23FA188Accident · 1 fatalClass 3 · FieldFinal reportMiller Glenn F RV-12 · Climax, NCThe airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…NTSB CEN23LA157Accident · Minor injuriesClass 4 · LimitedFinal reportAcro Sport II · Skiatook, OKThe pilot's failure to maintain directional control during landing in a gusting crosswind.NTSB CEN23LA154Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Terrell, TXThe student pilot’s failure to maintain directional control during landing and the flight instructor’s delayed remedial response.NTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.NTSB ERA23LA191Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Danbury, CTThe flight instructor’s inadequate preflight fuel planning and oversight of the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23LA149Accident · No injuriesClass 3 · LimitedFinal reportStevens Kelly C RV-7 · Morgan, UTThe pilot/builder improperly torqued the propeller attachment bolts while reinstalling the propeller, which resulted in the fatigue failure of the bolts and the separation of the propeller assembly.NTSB WPR23LA148Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA189Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Ft. Lauderdale, FLThe pilot’s ineffective use of the airplane’s brakes, which resulted in a runway overrun.NTSB DCA23WA235Accident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNTSB CEN23LA150Accident · Minor injuriesClass 3 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe lack of proper attachment of the cyclic control that resulted in a loss of control during a landing approach and impact with terrain. Contributing to the accident was the improper maintenance performed.NTSB WPR23LA147Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Midway, UTThe pilot’s failure to maintain aircraft control during a pinnacle landing that resulted in a hard landing and subsequent roll over.NTSB GAA23WA121AccidentClass 5 · ForeignCessna 210 · Mazatlan, Mexico