Fatal 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 per year

19622026
Fatal NTSB investigations per year, 1962–2026: 30,828 cases
196211
196313
1964539
1965560
1966581
1967625
1968718
1969655
1970643
1971664
1972697
1973731
1974727
1975692
1976707
1977713
1978800
1979691
1980672
1981705
1982638
1983651
1984617
1985555
1986507
1987496
1988502
1989484
1990499
1991482
1992494
1993437
1994445
1995456
1996421
1997402
1998422
1999404
2000443
2001412
2002417
2003440
2004418
2005428
2006408
2007387
2008373
2009359
2010363
2011398
2012389
2013344
2014360
2015365
2016341
2017338
2018361
2019381
2020294
2021321
2022330
2023295
2024292
2025275
2026240

Latest cases

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
  WHERE c.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB CEN27LA021Accident · 1 fatalClass 3 · LimitedInvestigation openPiper J3C-65 · Boonville, INOct 18, 2026 · N88218NTSB GAA27WA015Accident · 2 fatalClass 5 · ForeignVans RV7 · Sao Paulo, BrazilOct 16, 2026 · PP-ZLC · Substantial damageNTSB GAA27WA013Accident · 2 fatalClass 5 · ForeignPiper PA38 · Dryman, United KingdomOct 16, 2026 · G-LFSU · Substantial damageNTSB CEN27FA016Accident · 5 fatalClass 3 · FieldInvestigation openPiper PA 46-350P · Reedsburg, WIOct 14, 2026 · N931TTNTSB WPR27FA015Accident · 1 fatalClass 3 · FieldInvestigation openBertling Courtney MXL-2 · Newberg, OROct 12, 2026 · N947BXNTSB WPR27FA014Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Aeneas, WAOct 11, 2026 · N927JSNTSB GAA27WA016Accident · 3 fatalForeign investigationBeech 300 · Santana Do Paraiso, BrazilOct 9, 2026 · PP-EJONTSB WPR27FA012Accident · 2 fatalClass 3 · FieldInvestigation openGugger David RV-7A · Petaluma, CAOct 7, 2026 · N425DGNTSB CEN27FA006Accident · 1 fatalClass 3 · FieldPreliminary reportLancair IV · Haslet, TXOn October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…Oct 7, 2026 · N5SV · DestroyedNTSB GAA27WA003Accident · 1 fatalClass 5 · ForeignRutan Varieze · Worplesdon, United KingdomOct 6, 2026 · G-BIMX · Substantial damageNTSB ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVOct 6, 2026 · N9390FNTSB GAA27WA002Accident · 2 fatalClass 5 · ForeignCessna 501 · Los Mezquites, MexicoOct 5, 2026 · XB-BAR · DestroyedNTSB CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…Oct 5, 2026 · N162GL · DestroyedNTSB GAA27WA001Accident · 6 fatalForeign investigationGulfstream Gulfstream G100 · International Waters, CanadaOct 3, 2026 · C-GRJPNTSB WPR27FA001Accident · 1 fatalClass 3 · FieldInvestigation openRoesler Scott D Roesler Glasair · Everett, WAOct 1, 2026 · N314SRNTSB WPR26FA363Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter Deutschland EC 135 P2+ · Avalon, CAOn September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…Oct 1, 2026 · N313RX · Substantial damageNTSB GAA26WA336Accident · 5 fatalClass 5 · ForeignBell 430 · Mendamu, ZimbabweSep 30, 2026 · Z-PED · DestroyedNTSB CEN26FA325Accident · 1 fatalClass 3 · FieldPreliminary reportEXP PA-18 Replica · Buffalo, MNOn September 27, 2026, about 1608 central daylight time, an experimental PA-18 Replica airplane, N43LK, sustained substantial damage when it was involved in an accident near Buffalo, Minnesota. The pilot was fatally injured, and the pilot-rated passenger was…Sep 27, 2026 · N43LK · Substantial damageNTSB GAA26WA329Accident · 4 fatalForeign investigationRobinson R44 · Farnham, CanadaSep 26, 2026 · C-GARBNTSB ERA26FA350Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 112 · Chatsworth, GAOn September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Sep 26, 2026 · N1102J · Substantial damageNTSB WPR26FA355Accident · 2 fatalClass 3 · FieldInvestigation openAeronca 7AC · Hesperia, CASep 24, 2026 · N12DFNTSB 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…Sep 24, 2026 · N44P · Substantial damageNTSB 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…Sep 23, 2026 · N109MG · Substantial damageNTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORSep 21, 2026 · N529RBNTSB GAA26WA324Accident · 5 fatalForeign investigationBell 430 · Serra do Corvo Branco, BrazilSep 21, 2026 · PP-MGRNTSB 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…Sep 20, 2026 · N332N · DestroyedNTSB GAA26WA330Accident · 2 fatalClass 5 · ForeignComp Air 7SL · Primavera do Leste, BrazilSep 18, 2026 · PP-XHV · DestroyedNTSB GAA26WA325Accident · 2 fatalForeign investigationCessna 172 · Kisbey, CanadaSep 18, 2026 · C-GPTONTSB 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…Sep 18, 2026 · N94CG · 2 aircraft · Substantial damageNTSB ANC26FA106Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Northway, AKSep 18, 2026 · N9128DNTSB 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…Sep 17, 2026 · N20003 · Substantial damageNTSB 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…Sep 16, 2026 · N358TV · DestroyedNTSB ERA26FA338Accident · 1 fatalClass 3 · FieldPreliminary reportReed Julian Estill RV-4 · Albertville, ALOn September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…Sep 15, 2026 · N469TW · Substantial damageNTSB ANC26FA105Accident · 2 fatalClass 3 · FieldInvestigation openCessna A185F · Stony River, AKSep 15, 2026 · N4358QNTSB GAA26WA320Accident · 3 fatalClass 5 · ForeignCessna F172 · Fronderath, GermanySep 14, 2026 · PH-WMA · DestroyedNTSB GAA26WA311Accident · 5 fatalForeign investigationCessna T206 · Tatama Massif, ColombiaSep 13, 2026 · HK4985NTSB GAA26WA322Accident · 3 fatalClass 4 · ForeignCessna 402 · Agua Boa, BrazilSep 10, 2026 · unknown · DestroyedNTSB WPR26FA330Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · San Diego, CAOn September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…Sep 8, 2026 · N734ZK · DestroyedNTSB GAA26WA302Accident · 1 fatalClass 5 · ForeignCanadian Home Rotors Safari · Eyrewell, New ZealandSep 8, 2026 · ZK-IQP · DestroyedNTSB GAA26WA300Accident · 5 fatalClass 5 · ForeignBolkow BO105 · Long Lellang, MalaysiaSep 8, 2026 · 9M-LLF · Substantial damageNTSB GAA26WA301Accident · 2 fatalClass 5 · ForeignBeech A36 · Archerfield, AustraliaSep 7, 2026 · VH-MPT · DestroyedNTSB GAA26WA297Occurrence · 4 fatalClass 3 · ForeignPiper PA-34-200T · Andros, BahamasSep 7, 2026 · N212MLNTSB CEN26FA311Accident · 2 fatalClass 3 · FieldPreliminary reportEXP Stol CH701 · Neosho, MOOn September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was…Sep 7, 2026 · N101XV · Substantial damageNTSB CEN26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20F · Titusville, FLOn September 7, 2026, about 1015 eastern daylight time, a Mooney M20F airplane, N9546M, was destroyed when it was involved in an accident near Titusville, Florida. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 7, 2026 · N9546M · Substantial damageNTSB ERA26FA329Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Ludlow, MAOn September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…Sep 6, 2026 · N7653F · DestroyedNTSB DCA26MA352Accident · 5 fatalClass 1 · MajorPreliminary reportBoeing 767 · Miami, FLOn September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…Sep 6, 2026 · N1997A · Substantial damageNTSB WPR26FA329Accident · 4 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · Fresno, CAOn September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 5, 2026 · N6510L · DestroyedNTSB GAA26WA317Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Calgary, CanadaSep 5, 2026 · N65KB · DestroyedNTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…Sep 3, 2026 · N305PV · DestroyedNTSB ANC26FA097Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T206H · Dunton, COOn September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…Sep 3, 2026 · N919CW · Destroyed