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 WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.NTSB GAA23WA085Accident · Serious injuriesClass 5 · ForeignMcdonnell Douglas 500 · Dansey Pass, Livingston, New ZealandNTSB ERA23LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Slaughters, KYMaintenance personnel’s failure to secure the fuel strainer bowl with safety wire, which resulted in the fuel strainer bowl leaking and starving the engine of fuel. Also causal was the obstruction of two fuel injector nozzles.NTSB DCA23LA196Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-251N · Dallas, TXThe flight’s encounter with convective turbulence.NTSB GAA23WA118Accident · 4 fatalClass 5 · ForeignSud Aviation/Eurocopter Alouette II SE313B · Mangsee Island, PhilippinesNTSB CEN23LA136AccidentClass 4 · LimitedFinal reportCessna 150F · Hillsboro, TXSubstantial damage for reasons undetermined based on the available evidence.NTSB GAA23WA088AccidentClass 5 · ForeignCessna 337G · Itzehoe, GermanyNTSB GAA23WA087Accident · 2 fatalClass 5 · ForeignCessna 208 · Nakina, CanadaNTSB ERA23LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 182S · Labelle, FLA malfunction of the airplane’s right main wheel brake, which resulted in a loss of control and runway excursion during landing.NTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.NTSB DCA23WA189OccurrenceClass 5 · ForeignBoeing 737 · Budapest, HungaryNTSB DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.NTSB GAA23WA102Accident · Serious injuriesClass 5 · ForeignQuicksilver GT500 · Flaminio Suárez, ColombiaNTSB DCA24WA007Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Nairobi, KenyaNTSB CEN23LA123Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Erie, COThe pilot’s loss of directional control during landing.NTSB WPR23MA113Accident · 5 fatalClass 2 · MajorFinal reportPilatus PC-12/45 · Stagecoach, NVThe pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…NTSB WPR23LA115Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Mulino, ORThe pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.NTSB DCA23LA191Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer ERJ 190-100 IGW · New York, NYElectrical sparking caused by a faulty connection between the aircraft and ground power unit resulting in a serious injury to a ground service agent.NTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.NTSB WPR23LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Ephraim, UTThe pilot’s improper landing flare and loss of directional control.NTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.NTSB GAA23WA081AccidentClass 5 · ForeignBeech 1900 · Winnipeg, CanadaNTSB GAA23WA077AccidentClass 5 · ForeignHughes 269A · Budaors, HungaryNTSB DCA23LA185Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2D24 · Burbank, CAThe interruption of the local controller’s workflow due to the necessitated management of a go-around of a third airplane that was approaching a different runway. Contributing to the incident was: 1) the controller’s decision to continue the landing of…NTSB CEN23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Martinsville, INThe pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.NTSB GAA23WA080Accident · No injuriesClass 5 · ForeignEmbraer EMB202 · Rincão de Santana, BrazilNTSB GAA23WA075Accident · No injuriesClass 5 · ForeignPiper PA46 · Dessau, GermanyNTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB WPR23LA116Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · San Jose, CAA landing gear collapse due to an inadequately maintained landing gear extension and retraction system.NTSB CEN23LA121Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Oklahoma City, OKThe pilot’s failure to maintain directional control during the landing, that resulted in a runway excursion, and an impact with an obstacle.NTSB CEN23LA117Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Guthrie, OKThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Grand Prairie, TXThe pilot’s failure to extend the landing gear before landing.NTSB WPR23LA111Accident · Serious injuriesClass 4 · LimitedFinal reportGlasair Sportsman · Cal-Nev-Ari, NVThe pilot’s improper decision to takeoff with known damage to the wing and his failure to maintain directional control during takeoff on rough terrain.NTSB WPR23FA110Accident · 2 fatalClass 3 · FieldFinal reportWillman Loren LOREN'S Aircam · Grass Valley, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB ERA23LA129Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Chatham, MAThe pilot’s failure to lower the landing gear before touchdown.NTSB CEN23LA118Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Houston, TXThe pilot’s failure to attain/maintain lateral airplane control during landing, which resulted in an impact with the runway surface.NTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA23WA281Accident · No injuriesClass 4 · ForeignCessna T337 · Montevideo, UruguayNTSB ERA23LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Buckhannon, WVA total loss of engine power due to fuel starvation. Contributing was the pilot’s decision to depart on the flight with an inoperative fuel selector valve.NTSB DCA23WA206IncidentClass 5 · ForeignBoeing 787 · Sydney, AustraliaNTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.NTSB CEN23LA110Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado II · Windom, MNThe fatigue failure of the right landing gear leg that resulted in its separation from the airplane during takeoff.NTSB GAA23WA119Accident · 2 fatalClass 5 · ForeignRobinson R44 · Checkhov, RussiaNTSB GAA23WA083AccidentClass 5 · ForeignAirbus Helicopters EC175 · Aberdeen, United KingdomNTSB GAA23WA082Accident · 1 fatalClass 5 · ForeignRobinson 44 · Xian, ChinaNTSB GAA23WA073AccidentClass 5 · ForeignCessna 340 · Mount Mayon, PhilippinesNTSB ERA23LA150Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fernandina Beach, FLThe pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions, with resulted in a runway excursion and collision with a runway identifier sign.NTSB DCA23WA389IncidentClass 5 · ForeignAirbus A330 · Chennai, India