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 WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…NTSB GAA26WA279Accident · 4 fatalForeign investigationRobinson R44 · Rio de Janeiro, BrazilNTSB GAA26WA278Accident · 1 fatalClass 5 · ForeignCessna 150 · Portimao, PortugalNTSB ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…NTSB ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26FA289Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Bend, OROn August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…NTSB GAA26WA277Accident · 1 fatalForeign investigationCessna 172L · Chilliwack, CanadaNTSB GAA26WA270Accident · 2 fatalClass 5 · ForeignBell 214ST · West Attica, GreeceNTSB GAA26WA268Accident · 13 fatalClass 5 · ForeignCessna 208 · Nazca, PeruNTSB GAA26WA267Accident · 7 fatalClass 5 · ForeignBell 412 · San Agustín, ArgentinaNTSB ANC26FA077Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA22 · Chitina, AKOn July 27, 2026, about 2130 Alaska daylight time, a deregistered Piper PA-22-150 airplane, N4535A, was destroyed when it was involved in an accident near Chitina, Alaska. The pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Temelli, TürkiyeNTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…NTSB GAA26WA258Accident · 2 fatalClass 5 · ForeignCessna 335 · Barinas, VenezuelaNTSB GAA26WA261Incident · 1 fatalClass 5 · ForeignCessna 152 · Mengeringhausen, GermanyNTSB GAA26WA251Accident · 2 fatalClass 5 · ForeignHughes 369 · British Columbia, CanadaNTSB CEN26FA253Accident · 1 fatalClass 3 · FieldPreliminary reportMontana Coyote · Fredericksburg, VAOn July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…NTSB GAA26WA250Accident · 2 fatalClass 5 · ForeignPiper PA28 · Seitenstetten, AustriaNTSB GAA26WA265Accident · 1 fatalClass 5 · ForeignRobinson R44 · RorainóPolis, BrazilNTSB GAA26WA249Accident · 10 fatalClass 3 · ForeignCessna 402C · Nicholls Town, BahamasNTSB GAA26WA332Accident · 1 fatalClass 5 · ForeignRobin DR400 · Alençon, FranceNTSB GAA26WA243Accident · 2 fatalClass 5 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB GAA26WA237Accident · 2 fatalClass 5 · ForeignBeech V35 · San Miguel Pochuta, GuatemalaNTSB GAA26WA234Accident · 2 fatalClass 5 · ForeignCessna A152 · Ongar, United KingdomNTSB ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA26WA236Accident · 11 fatalClass 5 · ForeignPilatus PC6 · Tomblaine, FranceNTSB GAA26WA235Accident · 2 fatalClass 5 · ForeignPiper PA28 · Fochville, South AfricaNTSB GAA26WA233Accident · 3 fatalClass 5 · ForeignRockwell 690 · Fort Simpson, CanadaNTSB GAA26WA230Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Warsaw, PolandNTSB GAA26WA226Accident · 2 fatalClass 5 · ForeignPiper PA28 · Al Hoceïma, MoroccoNTSB WPR26FA224Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Middlefield, OHOn June 20, 2026, about 1535 eastern daylight time, a Piper PA-24-250, N6403P, was substantially damaged when it was involved in an accident near Middlefield, Ohio. The pilot and two passengers sustained fatal injuries. The airplane was operated as a Title 14…NTSB GAA26WA220Accident · 2 fatalClass 5 · ForeignCessna 421 · La Baule-Escoublac, FranceNTSB ANC26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502B · Forbes, MOOn June 15, 2026, about 2015 Central daylight time, an Air Tractor AT-502B airplane, N503GK, sustained substantial damage when it was involved in an accident near Forbes, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA216Accident · 9 fatalClass 4 · ForeignBell 206 · Recreio dos Bandeirantes, Rio de Janeiro., BrazilNTSB WPR26FA217Accident · 1 fatalClass 3 · FieldPreliminary reportLancair 235 · Hillsboro, OROn June 12, 2026, at about 1508 Pacific daylight time, a Lancair 235, N10CF, was destroyed when it was involved in an accident near Hillsboro, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26FA216Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-36-300 · Henderson, NEOn June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA223Accident · 1 fatalClass 5 · ForeignBell 206 · Lesa, ItalyNTSB GAA26WA217Accident · 1 fatalClass 5 · ForeignCessna 172 · 6th of October City, EgyptNTSB GAA26WA218Accident · 2 fatalClass 5 · ForeignBeech 58 · Marilia-Sao Paulo, BrazilNTSB GAA26WA210Accident · 2 fatalClass 5 · ForeignGulfstream Gulfstream 200 · La Romana, Dominican RepublicNTSB GAA26WA224Accident · 1 fatalClass 5 · ForeignShort SC7 · Be'er Sheva, IsraelNTSB GAA26WA207Accident · 4 fatalClass 5 · ForeignBeech G36 · Medulin, CroatiaNTSB GAA26WA209Accident · 1 fatalClass 5 · ForeignRobinson R44 · Kasina Wielka, PolandNTSB GAA26WA206Accident · 4 fatalClass 5 · ForeignCessna TU206 · La Macarena, ColombiaNTSB GAA26WA205Accident · 1 fatalClass 5 · ForeignCessna 152 · Valbrembo, ItalyNTSB WPR26FA202Accident · 1 fatalClass 3 · FieldPreliminary reportPipistrel D O O Sinus 912 · Columbus, MSOn May 31, 2026, about 1236 central daylight time, a Pipistrel D O O Sinus 912, N1277P, was destroyed when it was involved in an accident near Columbus, Mississippi. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26FA207Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Dawsonville, GAOn May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had…NTSB GAA26WA331Accident · 1 fatalClass 5 · ForeignSocata Rallye 100S · Roquebrune-sur-Argens, France