Fatal NTSB investigations

1,013 cases where the sequence of events included Unknown or undetermined.

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
  WHERE c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandDec 13, 2025 · ZK-IWZ · Substantial damageNTSB GAA26WA063Accident · 1 fatalClass 5 · ForeignRobin DR400 · Le Havre, FranceDec 11, 2025 · F-GLVG · DestroyedNTSB GAA26WA041Accident · 2 fatalClass 5 · ForeignRobinson R44 · Malawa, PolandNov 29, 2025 · F-HEAT · DestroyedNTSB GAA26WA037Accident · 1 fatalClass 4 · ForeignCessna 172 · Nanaimo, CanadaNov 27, 2025 · C-GFYW · DestroyedNTSB WPR26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportAmerican AA-1A · High Rolls, NMOn November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a…Nov 26, 2025 · N9439L · DestroyedNTSB CEN26FA050Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Monroe, WIOn November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…Nov 24, 2025 · N700PT · Substantial damageNTSB GAA26WA030Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Yame City, JapanNov 18, 2025 · JA102H · DestroyedNTSB GAA26WA027Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Krivi Put, CroatiaNov 13, 2025 · OR-2025 · DestroyedNTSB WPR26FA043Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172M · Poleta, CAOn November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously…Nov 10, 2025 · N13221 · Substantial damageNTSB GAA26WA022Accident · 4 fatalClass 5 · ForeignCessna TU206 · Bocoa, Vaupés, ColombiaNov 10, 2025 · HK641 · Substantial damageNTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomOct 30, 2025 · G-CFNF · DestroyedNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileOct 29, 2025 · ULM-200 · DestroyedNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaOct 28, 2025 · 5Y-CCA · DestroyedNTSB GAA26WA014Accident · 1 fatalClass 5 · ForeignTextron 182T · Nuuk, GreenlandOct 25, 2025 · N9009F · DestroyedNTSB CEN26FA022Accident · 1 fatalClass 3 · FieldPreliminary reportKitfox II · Spruce Pine, NCOn October 17, 2025, about 1154 eastern daylight time, a Kitfox II airplane, N8610X was destroyed when it was involved in an accident near Spruce Pine, North Carolina. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Oct 17, 2025 · N8610X · DestroyedNTSB WPR26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35 · Austin, NVOn October 15, 2025, about 1447 Pacific daylight time, a Beech V35, C-FETM, was substantially damaged when it was involved in an accident near Austin, Nevada. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Oct 15, 2025 · CFETM · Substantial damageNTSB WPR26FA008Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Sacramento, CAOn October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse…Oct 7, 2025 · N414RX · Substantial damageNTSB CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…Oct 7, 2025 · N577B · DestroyedNTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…Oct 5, 2025 · N121GJ · DestroyedNTSB GAA26WA003Accident · 1 fatalClass 4 · ForeignRobinson R22 · Brogans Creek, AustraliaOct 3, 2025 · VH-RDL · DestroyedNTSB GAA25WA268Accident · 1 fatalForeign investigationBushmaster Super 22 · Lillooet, CanadaSep 24, 2025 · C-GWNQNTSB GAA25WA270Accident · 4 fatalClass 5 · ForeignCessna 175 · Aquidauana, BrazilSep 23, 2025 · PT-BANNTSB WPR25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportMurphy SR3500 · Bigfork, MTOn September 19, 2025, about 1205 mountain daylight time, an experimental amateur built Murphy SR3500, N62ZT, was destroyed when it was involved in an accident near Bigfork, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code…Sep 19, 2025 · N62ZT · DestroyedNTSB GAA25WA271Accident · 1 fatalClass 5 · ForeignCessna P210 · Corumba, BrazilSep 16, 2025 · PS-FDW · Substantial damageNTSB CEN25FA367Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Lakeville, MNOn September 6, 2025, about 1442 central daylight time, a Robinson Helicopter Company R66 helicopter, N6633L was destroyed when it was involved in an accident near Lakeville, Minnesota. The pilot and passenger were fatally injured. The helicopter was operated…Sep 6, 2025 · N6633L · DestroyedNTSB CEN25FA348Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 210D · Kearney, NEOn August 27, 2025, about 20:57 central daylight time, a Cessna 210D, N3806Y was destroyed when it was involved in an accident near Kearney, Nebraska. Both pilots were fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…Aug 28, 2025 · N3806Y · Substantial damageNTSB WPR25FA264Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172S · Los Banos, CAOn August 26, 2025, about 1905 Pacific daylight time, a Cessna 172S, N5203H, was destroyed when it was involved in an accident near Los Banos, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…Aug 27, 2025 · N5203H · DestroyedNTSB CEN25FA346Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 340 · Kearney, MOOn August 27, 2025, about 1158 central daylight time, a Cessna 340A, N888MT, was substantially damaged when it was involved in an accident near Kearney, Missouri. The pilot and passenger were fatally injured. The airplane operated as a Title 14 Code of…Aug 27, 2025 · N888MT · Substantial damageNTSB GAA25WA243Accident · 4 fatalClass 3 · ForeignCessna TU206 · Mitu, ColombiaAug 24, 2025 · HK1833 · DestroyedNTSB ERA25FA310Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Milledgeville, GAOn August 23, 2025, about 1825 eastern daylight time, a Cessna 310Q, N7664Q was destroyed when it was involved in an accident near Milledgeville, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Aug 23, 2025 · N7664Q · DestroyedNTSB CEN25FA321Accident · 1 fatalClass 3 · FieldPreliminary reportLancair NLA-275-FR-C · Bradley, AROn August 18, 2025, about 2133 central daylight time, a Lancair NLA-275-FR-C airplane, N345LA, was destroyed when it was involved in an accident near Bradley, Arkansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Aug 19, 2025 · N345LA · DestroyedNTSB GAA25WA287Accident · 2 fatalClass 5 · ForeignRobin DR400 · Saint-Pons, FranceAug 16, 2025 · F-HRPB · 2 aircraft · DestroyedNTSB CEN25FA320Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172L · Walters, OKOn August 14, 2025, about 0934 central daylight time, a Cessna 172L, N2860Q, was destroyed when it was involved in an accident near Walters, Oklahoma. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code of Federal Regulations as…Aug 14, 2025 · N2860Q · DestroyedNTSB ANC25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportNorth American T-28B · Monticello, IAOn August 11, 2025, about 1505 Central daylight time, a North American T-28B airplane, N28XT, was substantially damaged when it was involved in an accident near Monticello, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Aug 11, 2025 · N28XT · Substantial damageNTSB CEN25FA308Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T182T · Augusta, AROn August 7, 2025, at 1037 central daylight time, a Cessna T182T airplane, N35370, was substantially damaged when it was involved in an accident near Augusta, Arkansas. The pilot was fatally injured and the passenger received minor injuries. The airplane was…Aug 7, 2025 · N35370 · Substantial damageNTSB GAA25WA222Accident · 2 fatalClass 5 · ForeignLional Ray Ward Ward F-4 Rocket · Mallorca, SpainAug 2, 2025 · N31VX · Substantial damageNTSB GAA25WA282Accident · 2 fatalClass 5 · ForeignRiems Aviaition F406 · Kelvinhaugh, AustraliaJul 20, 2025 · VH-EYQ · DestroyedNTSB CEN25FA261Accident · 1 fatalClass 3 · FieldPreliminary reportKolb Firestar · Meadow Grove, NEOn July 19, 2025, about 2050 central daylight time, a Kolb Firestar airplane, N55161, was destroyed when it was involved in an accident near Meadow Grove, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Jul 20, 2025 · N55161 · DestroyedNTSB WPR25FA208Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Needles, CAOn July 13, 2025, about 2128 Pacific daylight time, a Piper PA-28-180, N8375W, was substantially damaged when it was involved in an accident near Needles, California. Both pilots sustained fatal injuries. The airplane was operated as a Title 14 Code of…Jul 14, 2025 · N8375W · Substantial damageNTSB WPR25LA212Accident · 1 fatalClass 4 · LimitedFinal reportCessna T240 · San Diego, CAImpact with the ocean for reasons that could not be determined because the pilot and airplane were not located.Jul 13, 2025 · N636CSNTSB GAA25WA208Accident · 4 fatalClass 5 · ForeignBeech B200 · Southend-on-Sea, United KingdomJul 13, 2025 · PH-ZAZ · DestroyedNTSB CEN25FA247Accident · 1 fatalClass 3 · FieldPreliminary reportZenith CH601 · Pawnee National Grassland, COOn July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…Jul 12, 2025 · N314LB · DestroyedNTSB ERA25FA260Accident · 4 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Sanford, NCOn July 7, 2025, about 1330 eastern daylight time, a Cirrus SR22T, N5656M, was substantially damaged when it was involved in an accident near Sanford, North Carolina. The private pilot and three passengers were fatally injured. The airplane was operated as a…Jul 7, 2025 · N5656M · Substantial damageNTSB WPR25FA205Accident · 1 fatalClass 3 · FieldPreliminary reportBeech F35 · Eagle Nest, NMOn July 6, 2025, about 1345 mountain daylight time, a Beech F35, N5009B, was destroyed when it was involved in an accident near Eagle Nest, New Mexico. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Jul 6, 2025 · N5009B · DestroyedNTSB GAA25WA202Accident · 1 fatalClass 5 · ForeignBell 206 · Condor, CanadaJul 6, 2025 · C-GKVX · Substantial damageNTSB ERA25FA253Accident · 1 fatalClass 3 · FieldPreliminary reportErcoupe 415 · Gallatin, TNOn July 2, 2025, about 1300 central daylight time, an Ercoupe 415-C, N93985, was substantially damaged when it was involved in an accident near Gallatin, Tennessee. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Jul 2, 2025 · N93985 · Substantial damageNTSB ERA25FA246Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 441 · Warren, OHOn June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code…Jun 29, 2025 · N441LS · Substantial damageNTSB GAA25WA284Accident · 1 fatalClass 5 · ForeignAirbus Helicopters AS350 · Naters, SwitzerlandJun 28, 2025 · HB-ZNRNTSB GAA25WA191Accident · 1 fatalClass 4 · ForeignRobinson R44 · Naboonspruit, South AfricaJun 22, 2025 · ZS-HFH · Substantial damageNTSB CEN25FA212Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A150L · Three Points, AZOn June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was…Jun 18, 2025 · N6436F · Substantial damage