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.
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
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 GAA26WA051Accident · 2 fatalClass 5 · ForeignBell 206 · Ranana, New ZealandNTSB GAA26WA063Accident · 1 fatalClass 5 · ForeignRobin DR400 · Le Havre, FranceNTSB GAA26WA041Accident · 2 fatalClass 5 · ForeignRobinson R44 · Malawa, PolandNTSB GAA26WA037Accident · 1 fatalClass 4 · ForeignCessna 172 · Nanaimo, CanadaNTSB 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…NTSB 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…NTSB GAA26WA030Accident · 3 fatalClass 5 · ForeignCirrus SR20 · Yame City, JapanNTSB GAA26WA027Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Krivi Put, CroatiaNTSB 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…NTSB GAA26WA022Accident · 4 fatalClass 5 · ForeignCessna TU206 · Bocoa, Vaupés, ColombiaNTSB GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB GAA26WA019Accident · 1 fatalClass 4 · ForeignRans S9 · San Felipe, ChileNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaNTSB GAA26WA014Accident · 1 fatalClass 5 · ForeignTextron 182T · Nuuk, GreenlandNTSB 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…NTSB 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…NTSB 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…NTSB 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)…NTSB 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…NTSB GAA26WA003Accident · 1 fatalClass 4 · ForeignRobinson R22 · Brogans Creek, AustraliaNTSB GAA25WA268Accident · 1 fatalForeign investigationBushmaster Super 22 · Lillooet, CanadaNTSB GAA25WA270Accident · 4 fatalClass 5 · ForeignCessna 175 · Aquidauana, BrazilNTSB 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…NTSB GAA25WA271Accident · 1 fatalClass 5 · ForeignCessna P210 · Corumba, BrazilNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB GAA25WA243Accident · 4 fatalClass 3 · ForeignCessna TU206 · Mitu, ColombiaNTSB 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…NTSB 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…NTSB GAA25WA287Accident · 2 fatalClass 5 · ForeignRobin DR400 · Saint-Pons, FranceNTSB 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…NTSB 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…NTSB 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…NTSB GAA25WA222Accident · 2 fatalClass 5 · ForeignLional Ray Ward Ward F-4 Rocket · Mallorca, SpainNTSB GAA25WA282Accident · 2 fatalClass 5 · ForeignRiems Aviaition F406 · Kelvinhaugh, AustraliaNTSB 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…NTSB 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…NTSB 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.NTSB GAA25WA208Accident · 4 fatalClass 5 · ForeignBeech B200 · Southend-on-Sea, United KingdomNTSB 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…NTSB 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…NTSB 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…NTSB GAA25WA202Accident · 1 fatalClass 5 · ForeignBell 206 · Condor, CanadaNTSB 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…NTSB 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…NTSB GAA25WA284Accident · 1 fatalClass 5 · ForeignAirbus Helicopters AS350 · Naters, SwitzerlandNTSB GAA25WA191Accident · 1 fatalClass 4 · ForeignRobinson R44 · Naboonspruit, South AfricaNTSB 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…