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 ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB DCA24WA216OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB DCA24FA120Accident · No injuriesClass 2 · FieldFinal reportBoeing 737-8 · Houston, TXThe captain's decision not to establish and maintain deceleration devices in accordance with company training and standard operating procedures.NTSB WPR24FA104Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar KXP · Cave Junction, ORThe pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…NTSB ERA24LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Stafford, VAAn overloading of the landing gear push/pull cable rod ends, which resulted in the landing gear being seized in an intermediate position during the subsequent landing.NTSB DCA24WA302OccurrenceClass 5 · ForeignBoeing 747 · London, United KingdomNTSB CEN24LA128Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-2 · West Lafayette, INThe failure of maintenance personnel to properly install the tail rotor pitch change slider attachment hardware (T-bolt), which led to the disconnection of the pitch change slider, a loss of tail rotor control, and subsequent hard landing. Contributing to the…NTSB WPR24LA108Accident · No injuriesClass 4 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Maricopa, AZThe pilot’s failure to maintain pitch control, which resulted in abnormal contact with the runway.NTSB WPR24FA103Incident · No injuriesClass 3 · FieldFinal reportCirrus Design SR22T · Bellevue, WAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB GAA24WA115Accident · No injuriesClass 4 · ForeignCessna 172S · Guna, IndiaNTSB GAA24WA113Accident · 2 fatalClass 5 · ForeignCessna 208B · Belo Horizonte, BrazilNTSB CEN24LA132Accident · No injuriesClass 4 · LimitedFinal reportPietenpol Aircamper · Lockhart, TXThe pilot’s failure to maintain control during after takeoff.NTSB GAA24WA166AccidentClass 5 · ForeignBell 407 · Raigad, IndiaNTSB GAA24WA108AccidentClass 5 · ForeignCessna 172M · Wilson Airport, KenyaNTSB GAA24WA105IncidentClass 5 · ForeignCessna 150 · Budaors, HungaryNTSB ERA24FA127Accident · 5 fatalClass 3 · FieldFinal reportPiper PA32RT · Nashville, TNThe pilot’s failure to ensure the proper placement of the fuel selector during the approach and landing, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB WPR24LA101Accident · Minor injuriesClass 4 · LimitedFinal reportUtah County Sheriff CCX-2000 · Spanish Fork, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA24WA142AccidentClass 5 · ForeignRockwell Commander · Dortmond, GermanyNTSB GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaNTSB ERA24LA151Accident · No injuriesClass 3 · LimitedFinal reportPalmetto Electronics X-AIR H · Ellenboro, NCA total loss of engine power due to an inoperative ignition system.NTSB ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.NTSB DCA24WA116IncidentClass 5 · ForeignBoeing 737 · Bristol, United KingdomNTSB CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.NTSB ERA24LA129Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11 · Fort Myers, FLThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN24LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Paragould, ARThe pilot’s failure to maintain directional control during landing.NTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB GAA24WA107Accident · Minor injuriesClass 5 · ForeignCessna 150 · Warsaw, PolandNTSB ERA24LA137Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Leesburg, VAAn in-flight collision with a bird while on the downwind leg of the airport traffic pattern.NTSB ERA24LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Zephyrhills, FLThe pilot’s failure to lower the landing gear before touchdown, which resulted in a gear-up landing.NTSB ERA24LA128Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters PA18-150 · Edgewater, FLMaintenance personnel’s failure to detect the worn aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and a subsequent loss of airplane control during landing.NTSB ERA24LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Key Largo, FLThe pilot’s improper go-around technique, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ENG24LA012IncidentClass 3 · LimitedFinal reportBritish Aerospace BAE 146 Series 200A · Missoula, MTThe use of a new long term fire retardant with a chemical composition incompatible with the retardant previously in use for the integration-operational field evaluation without adequate testing and qualification.NTSB WPR24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Albuquerque, NMThe pilot’s loss of control during landing due to a flat tire. Contributing to the accident was the pilot’s failure to replace the worn tire in a timely manner.NTSB GAA24WA106Accident · No injuriesClass 5 · ForeignBell 206 · Narsaq, GreenlandNTSB GAA24WA103AccidentClass 3 · ForeignSikorsky S92 · Bergen, NorwayNTSB CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB WPR24LA099Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Dallesport, WAThe pilot’s failure to disengage the ignition prior to moving the propeller by hand resulting in the inadvertent starting of the engine.NTSB ERA24LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Sanford, FLA total loss of engine power due to fuel starvation and the flight crew’s mismanagement of the available fuel.NTSB ANC24LA017Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369E/500E · Kekaha, HIMaintenance personnel’s noncompliance with maintenance manual procedures that required the removal of the overrunning clutch output bearing during the regreasing procedure, which resulted in inadequate regreasing of the bearing and the subsequent failure of…NTSB WPR24LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Casper, WYThe pilot’s failure to maintain directional control while taxiing with a crosswind.NTSB GAA24WA160AccidentClass 5 · ForeignRans S6 · Newtownards, United KingdomNTSB GAA24WA102Accident · No injuriesClass 5 · ForeignMaule M7 · Staniel Cay, BahamasNTSB DCA24LA110Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-224 · San Francisco, CAThe crew’s over-rotation of the aircraft pitch during takeoff which resulted in a tailstrike.NTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.NTSB GAA24WA111Accident · No injuriesClass 5 · ForeignMooney M20R · Eschbach, GermanyNTSB ERA24LA123Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Moultonborough, NHThe pilots’ failure to maintain directional control of the airplane during the landing.NTSB CEN24LA124Accident · Minor injuriesClass 4 · LimitedFinal reportSearey Classic · Winchester, TXThe pilot’s failure to attain/maintain airplane control during a landing approach that resulted in an uncontrolled descent and an impact with the lake.