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 CEN23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Navasota, TXThe pilot’s loss of control while landing resulting in a runway excursion and ground loop.NTSB CEN23LA005Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7BCM · San Antonio, TXThe flight instructor’s failure to attain/maintain aircraft control during landing.NTSB WPR23LA020Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters FX-3 · Hot Springs, MTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB ERA23LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, FLThe pilot's unstable approach, which resulted in a hard landing and impact with a runway threshold light. Also causal was the flight instructor’s failure to take remedial action to prevent the hard landing.NTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.NTSB ERA23LA004Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Coleman, FLThe pilot's failure to maintain an appropriate final approach airspeed, which resulted in a runway excursion and impact with a fence.NTSB WPR23LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182C · Boulder City, NVA total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.NTSB GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, AustraliaNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyNTSB ENG23WA001IncidentClass 5 · ForeignBoeing 777 · Islamabad, PakistanNTSB DCA23WA116Incident · No injuriesClass 5 · ForeignBoeing 737 · Frankfurt, GermanyNTSB DCA23WA012Accident · Minor injuriesClass 5 · ForeignBoeing 737 · Komatsu, Ishikawa, JapanNTSB CEN23LA004Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Waconia, MNThe pilot's failure to maintain aircraft control during a touch-and-go landing.NTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.NTSB WPR23LA002Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Clovis, NMThe pilot’s failure to follow the go-around procedures by prematurely retracting the flaps and not establishing a proper go-around climb speed after attempting to land with a quartering tailwind, resulting in the airplane’s inability to climb.NTSB WPR23LA001Accident · 1 fatalClass 3 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Perma, MTThe pilot’s failure to maintain clearance from the powerline.NTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyNTSB ERA23LA002Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7AC · Murray, KYThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during post-maintenance checks and the pilot's inadequate preflight check.NTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…NTSB CEN23LA002Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Danville, ILThe pilot decision to perform a precautionary landing to a field with obstacles which resulted in a ground loop. Contributing was the pilot’s inadequate fuel planning.NTSB CEN23LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Burnet, TXThe pilot’s failure to maintain directional control during the landing roll with an unexpected quartering tailwind.NTSB WPR23LA008Accident · No injuriesClass 4 · LimitedFinal reportSeabourn Scott R CCK-2000 · Clarksburg, CAThe pilot's failure to maintain directional control during the landing roll with a gusting quartering tailwind.NTSB WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB WPR23LA005Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2000 · Reno, NVThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR23LA004Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206B · Fresno, CAThe disbond of a tail rotor drive shaft splined adapter, which resulted in a loss of tail rotor drive and a subsequent hard landing.NTSB WPR22LA365Accident · Minor injuriesClass 4 · LimitedFinal reportMary Alexander JA30 Superstol · Groveland, CAThe pilot's excessive application of brake during an attempt to avoid wildlife while taxing resulted in a nose over.NTSB ENG23WA017Accident · 3 fatalClass 5 · ForeignAirbus Helicopters MBB BK117 · Tabasco, MexicoNTSB DCA23WA002Incident · No injuriesClass 5 · ForeignBoeing 777 · Manila, PhilippinesNTSB DCA23WA001Accident · No injuriesClass 5 · ForeignBoeing 737 · Nantes, FranceNTSB WPR22LA363Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Cedar City, UTA partial loss of engine power due to a damaged cylinder intake valve and subsequent collision with terrain during an autorotation.NTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoNTSB CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.NTSB WPR22LA366Accident · No injuriesClass 4 · LimitedFinal reportArter Warren Carbon CUB CCK-1865 · Willard, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR22LA364Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20 · Hood River, ORThe pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaNTSB ERA22LA431Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R-22 Beta · Nashville, TNA loss of tail rotor effectiveness while hovering in crosswind conditions resulting in the student pilot's loss of control of the helicopter, impact with terrain, and dynamic rollover.NTSB DCA23LA008Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COAn encounter with clear air turbulence during cruise flight.NTSB CEN22LA441Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Shell Lake, WIA collision with a deer during landing, which resulted in substantial damage to the left wing.NTSB WPR22FA361Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5B · Sahuarita, AZThe pilot's loss of control following a separation of the aileron carry-through cable.NTSB ERA22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Winterville, NCThe student pilot’s improper recovery from a bounced landing. A factor in the accident was the instructor’s delayed remedial action which resulted in an inability to recover the airplane from an aerodynamic stall.NTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonNTSB CEN22LA445Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Monticello, IAThe pilot’s failure to maintain a proper approach airspeed and glidepath which resulted in a long landing and his inability to stop the airplane on available runway and the subsequent runway excursion.NTSB CEN22LA437Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · San Antonio, TXThe student pilot’s failure to maintain control of the airplane during the landing.NTSB CEN22FA436Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Allentown, PAA partial loss of engine power for undetermined reasons.NTSB WPR22LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Hermiston, ORThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.NTSB CEN22LA442Accident · No injuriesClass 3 · LimitedInvestigation openPiper PA-18 · Battle Creek, MINTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.