NTSB investigations
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 WPR26LA356Accident · No injuriesClass 3 · LimitedPreliminary reportZenith CH 750 Stol · Spring Creek, NVOn September 24, 2026, about 0958 mountain daylight time, an experimental amateur-built Zenith CH750 STOL airplane, N750WZ, was substantially damaged when it was involved in an accident near Silver Creek, Nevada. The pilot was not injured. The airplane was…NTSB WPR26FA355Accident · 2 fatalClass 3 · FieldInvestigation openAeronca 7AC · Hesperia, CANTSB WPR26FA354Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172B · Royal City, WAOn September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA26WA335Accident · No injuriesForeign investigationPiper PA18 · Bragado, ArgentinaNTSB GAA26WA328Incident · Minor injuriesClass 5 · ForeignCessna 152 · João Pessoa, BrazilNTSB ERA26LA353Accident · No injuriesClass 4 · LimitedInvestigation openRoberts GS-2 Sportsman · Kerrtown, PANTSB GAA26WA327Accident · No injuriesForeign investigationCessna 172 · Campo Alegre, ColombiaNTSB ENG26WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Naha, JapanNTSB CEN26LA324Accident · 2 fatalClass 3 · LimitedPreliminary reportMagni M16 · Annapolis, MOOn September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…NTSB CEN26LA323Accident · No injuriesClass 4 · LimitedInvestigation openCessna 120 · Llano, TXNTSB WPR26LA359Accident · Minor injuriesClass 4 · LimitedInvestigation openHawker Hawker Hunter MK.58 · Morro Bay, CANTSB ERA26LA362Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-140 · Canon, GANTSB DCA26WA372Incident · No injuriesClass 5 · ForeignAirbus Canada BD500 · Garbutt, AustraliaNTSB WPR26LA361Accident · No injuriesClass 4 · LimitedInvestigation openCessna U206G · Stony River, AKNTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB GAA26WA326Accident · No injuriesClass 5 · ForeignLaviasa PA25 · Cajati, BrazilNTSB GAA26WA324Accident · 5 fatalForeign investigationBell 430 · Serra do Corvo Branco, BrazilNTSB DCA26WA373IncidentClass 5 · ForeignAirbus A330 · Tunis, TunisiaNTSB ANC26LA107Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA-28-140 · Junction, TXNTSB WPR26LA353Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182P · Warren, IDNTSB WPR26LA350Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Salem, ORNTSB WPR26FA346Accident · 2 fatalClass 3 · FieldPreliminary reportAirbus AS332 · Yosemite Valley, CAOn September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…NTSB GAA26WA323Incident · No injuriesClass 5 · ForeignBAE Jetstream 3100 · Maiquetía, VenezuelaNTSB ERA26LA348Accident · No injuriesClass 4 · LimitedInvestigation openHopwood Joseph R Zodiac · Stockton, ALNTSB ERA26LA347Accident · No injuriesClass 4 · LimitedInvestigation openShaffer John Thomas KR-2 · Westminster, OHNTSB WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB WPR26LA357Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182Q · Water Valley, MSNTSB WPR26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Medford, ORNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB ERA26LA352Accident · No injuriesClass 4 · LimitedInvestigation openHart Frank RV-8A · Sanford, NCNTSB ERA26LA349Accident · No injuriesClass 3 · LimitedInvestigation openBeech 200 · Dothan, ALNTSB ERA26LA345Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR20 · Asheville, NCOn September 19, 2026, at 1045 eastern daylight time, a Cirrus SR-20, N189WM, sustained substantial damage when it was involved in an accident near Ashville, North Carolina. The flight instructor and the student pilot received minor injuries. The airplane was…NTSB DCA26WA367Incident · No injuriesClass 5 · ForeignAirbus A321-271NX · Guayaquil, EcuadorNTSB WPR26LA347Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B-III · Creswell, NCOn September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…NTSB GAA26WA330Accident · 2 fatalClass 5 · ForeignComp Air 7SL · Primavera do Leste, BrazilNTSB GAA26WA325Accident · 2 fatalForeign investigationCessna 172 · Kisbey, CanadaNTSB ERA26LA346Accident · 1 fatalClass 3 · LimitedPreliminary reportSchleicher ASW-24 · Edinburg, NYOn September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was…NTSB ERA26LA344Accident · No injuriesClass 3 · LimitedPreliminary reportAerospatiale SA 315 · Workmore, GAOn September 18, 2026, at 1604 eastern daylight time, an Aerospatiale SA315B helicopter, N238HA was substantially damaged when it was involved in an accident near Workmore, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…NTSB ANC26FA106Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Northway, AKNTSB ERA26FA341Accident · 1 fatalClass 3 · FieldPreliminary reportWeatherly 620 · Lynchburg, SCOn September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as…NTSB ENG26WA044Incident · No injuriesClass 5 · ForeignAirbus A320 · Zapote del Valle, MexicoNTSB DCA26WA375IncidentClass 5 · ForeignBoeing 777 · Schiphol, NetherlandsNTSB DCA26WA371Incident · No injuriesClass 5 · ForeignBoeing 787 · Pacific Ocean, VietnamNTSB DCA26WA365Incident · No injuriesClass 5 · ForeignBoeing 737 · Comalapa, El SalvadorNTSB DCA26WA363Accident · No injuriesClass 5 · ForeignBoeing 737 · Kindu, Congo - KinshasaNTSB CEN26LA332Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA18 · Karinen, SDOn September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…NTSB WPR26FA345Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter AS 350 B2 · Chatsworth, CAOn September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…NTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…NTSB WPR26LA366Accident · No injuriesClass 4 · LimitedInvestigation openAbbott Dudley L Levitator · Skwentna, AKNTSB WPR26LA348Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-150 · Roundup, MT