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 DCA23WA184Occurrence · Serious injuriesClass 5 · ForeignBoeing 767-300F · Derby, United KingdomNTSB DCA23FA149Incident · No injuriesClass 1 · FieldFinal reportBoeing 737-79P · Austin, TXthe local controller’s incorrect assumption that the Southwest Airlines (SWA) airplane would depart from the runway before the Federal Express airplane arrived on the same runway, which resulted in a loss of separation between both airplanes. Contributing to…NTSB CEN23LA109Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Montevideo, MNThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA101Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7ACA · Bayport, MNThe pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.NTSB GAA23WA066Incident · No injuriesClass 5 · ForeignCessna 206 · Stann Creek, BelizeNTSB DCA23WA313Incident · Serious injuriesClass 5 · ForeignAirbus A330 · Grand Anse Village, SeychellesNTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaNTSB ERA23LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46 · Port Orange, FLThe pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees.NTSB ANC23LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control while landing with a crosswind on an ice-covered runway, resulting in a loss of control and subsequent impact with a snowbank. A factor was the check airman’s inadequate supervision.NTSB CEN23LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Limon, COThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR23LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hayden, IDThe failure of the right main landing gearbox assembly due to fatigue cracking, which resulted in a loss of directional control during the landing roll.NTSB GAA23WA061AccidentClass 5 · ForeignAir Tractor AT-502 · Puerto Barrios, GuatemalaNTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.NTSB WPR23LA106Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing and subsequent failure to maintain clearance from a snow berm during a go around.NTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.NTSB DCA23WA141IncidentClass 5 · ForeignAirbus A321 · Doha, QatarNTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…NTSB CEN23FA095Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Hooker, OKThe pilot’s decision to depart and continue the visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB GAA23WA285Accident · No injuriesClass 4 · ForeignPiper PA46 · Mateiros - Tocantins - Brasil, BrazilNTSB ERA23LA122Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 500 · Sylacauga, ALThe pilot’s failure to assure there was an adequate amount of fuel onboard to complete the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA121Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Brinkman Lancair 4P · Hartford, CTThe pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…NTSB ERA23LA120Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Calhoun, GAA partial loss of engine power during the initial climb due to an improperly installed spark plug.NTSB ERA23LA119Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Miami, FLThe pilot’s mismanagement of fuel supply, which resulted in fuel starvation.NTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.NTSB ENG23WA016IncidentClass 5 · ForeignCessna 560 · Toronto, CanadaNTSB DCA23WA146IncidentClass 5 · ForeignBombardier CL600 2D24 · Sault Ste. Marie, CanadaNTSB DCA23WA143IncidentClass 5 · ForeignBoeing 777-319ER · Auckland, New ZealandNTSB DCA23WA138Incident · No injuriesClass 5 · ForeignBoeing 737 · Merauke-Papua Island, IndonesiaNTSB CEN23LA096Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Chickala, ARThe pilot’s decision to land on the snow-covered runway and his failure to attain/maintain aircraft control during landing rollout.NTSB WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.NTSB DCA23WA137Accident · No injuriesClass 5 · ForeignBoeing 767 · Narita, JapanNTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.NTSB WPR23LA097Accident · No injuriesClass 3 · LimitedFinal reportKaman Aerospace K-1200 · Sweet Home, ORImproper installation of the hardware retaining the adjustment screw in the N2 topping governor lever and roller assembly, which resulted in a partial loss of engine power.NTSB GAA23WA091Accident · 6 fatalClass 5 · ForeignCessna 206 · Barangay Ditarum, PhilippinesNTSB ERA23LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Buford, GAWater contamination in the fuel system that was not observed during the preflight inspection, resulting in a total loss of engine power and forced landing.NTSB DCA23LA133Incident · No injuriesClass 3 · LimitedFinal reportBoeing 777-222 · Honolulu, HIThe airport’s continued use of taxiway Kilo, despite an identified risk of pilots repeatedly failing to stop at a hold short line prior to two intersecting runways. Contributing were 1) the operator’s moving map display, which omitted a published restriction…NTSB CEN23LA093Accident · 1 fatalClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB WPR23LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.NTSB ERA23LA118Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Raleigh/Durham, NCThe pilot's flooding the engine with fuel during a cold engine start, which resulted in an engine fire.NTSB DCA23WA136Incident · No injuriesClass 5 · ForeignMcdonnell Douglas DC-9-82 · Kermanshah, IranNTSB CEN23LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Eden Prairie, MNThe student pilot exceeded the airplane's critical angle of attack, resulting in an aerodynamic stall and ground impact.NTSB GAA23WA059Accident · No injuriesClass 5 · ForeignBell 206 · Itacare, BrazilNTSB CEN23LA088Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Tomball, TXA loss of engine power during cruise flight for undetermined reasons.NTSB WPR23LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Skull Valley, AZThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB DCA23WA160Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Niederrhein/Weeze, GermanyNTSB WPR23LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 195A · Calexico, CAThe pilot’s failure to maintain directional control during the landing roll in gusting wind.NTSB ERA23LA115Accident · Minor injuriesClass 4 · LimitedFinal reportEiriavion PIK-20D · Benton, TNThe pilot’s decision to turn toward a mountain ridge in a thermal, which resulted in a collision with terrain.NTSB ERA23LA114Accident · Minor injuriesClass 4 · LimitedFinal reportDegraw Richard R Summit 23 · Wauchula, FLThe pilot’s improper landing flare, which resulted in a hard landing and dynamic rollover.NTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.NTSB CEN23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.