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 GAA25WA188Accident · 1 fatalClass 5 · ForeignRand Robinson KR2 · Klint, GermanyNTSB WPR25FA169Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 414 · San Diego, CAOn June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA186Accident · 1 fatalClass 4 · ForeignCessna 210 · Lanseria, South AfricaNTSB ANC25FA044Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Kaparuk, AKOn June 4, 2025 about 1055 Alaska daylight time, a Robinson R66 turbine-powered helicopter, N962MD, was substantially damaged when it was involved in an accident near Kaparuk, Alaska. The pilot and passenger were fatally injured. The helicopter was operated…NTSB CEN25FA194Accident · 2 fatalClass 3 · FieldPreliminary reportUniversal Stinson 108 · Farmington, NCOn June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously…NTSB GAA25WA239Accident · 1 fatalClass 3 · ForeignCessna TU206 · Vereda El Canelón, ColombiaNTSB WPR25FA161Accident · 6 fatalClass 3 · FieldPreliminary reportCessna S550 · San Diego, CAOn May 22, 2025, at 0347 Pacific daylight time (PDT), a Cessna Citation S550, N666DS, was destroyed when it was involved in an accident near San Diego, California. The pilot and five passengers were fatally injured. Eight people on the ground received minor…NTSB GAA25WA156Accident · 6 fatalClass 5 · ForeignBell 407 · Gangnani, IndiaNTSB CEN25FA166Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Wilson, KSOn May 4, 2025, about 1325 central daylight time, a Piper J3C-65 airplane, N98416 was destroyed when it was involved in an accident near Wilson, Kansas. The pilot was fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…NTSB GAA25WA153Accident · 1 fatalClass 5 · ForeignAirbus AS350B · Whitehorse, CanadaNTSB GAA25WA152Accident · 1 fatalClass 5 · ForeignDe Havilland DHC2 · Saint-Basile-le-Grand, CanadaNTSB CEN25LA164Accident · 1 fatalClass 4 · LimitedFinal reportAir Tractor AT802 · Atlantic Ocean, CanadaThe airplane’s impact with the ocean for undetermined reasons based on the available evidence.NTSB ANC25FA035Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T207 · Nanwalek, AKOn April 28, 2025, about 1355 Alaska daylight time, a Cessna T207 airplane, N91025, was substantially damaged when it was involved in an accident near Nanwalek, Alaska. The pilot and one passenger were fatally injured. One passenger was seriously injured. The…NTSB GAA25WA138Accident · 2 fatalClass 5 · ForeignPiper PA60 · Salzgitter, GermanyNTSB WPR25MA128Accident · 6 fatalClass 3 · MajorPreliminary reportMitsubishi MU-2B-40 · Copake, NYOn April 12, 2025, about 1203 eastern daylight time, a Mitsubishi MU-2B-40, N635TA, was destroyed when it was involved in an accident near Copake, New York. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA126Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20F · Reliance, TNOn April 11, 2025, about 1402 eastern daylight time, a Mooney M20F, N7026V, sustained substantial damage when it was involved in an accident near Reliance, Tennessee. The pilot, pilot-rated passenger and passenger were fatally injured. The airplane was…NTSB GAA25WA132Accident · 2 fatalClass 5 · ForeignChampion 8KCAB · Bergen, NorwayNTSB GAA25WA126Accident · 1 fatalClass 4 · ForeignSikorsky S76 · Euiseong, South KoreaNTSB DCA25WA167Accident · 5 fatalClass 5 · ForeignDe Havilland DHC5 · Jazeera, SomaliaNTSB GAA25WA113Accident · 1 fatalClass 5 · ForeignMooney M20R · Velika Planina, SloveniaNTSB CEN25MA115Accident · 3 fatalClass 2 · MajorPreliminary reportEurocopter Deutschland EC 135 P2+ · Canton, MSOn March 10, 2025, about 1237 central daylight time, an Airbus Helicopters (formerly Eurocopter Deutschland) EC135 P2+ helicopter, N835CS, operated as AirCare 3, was destroyed when it was involved in an accident near Canton, Mississippi. The commercial pilot,…NTSB GAA25WA117Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Balsas, BrazilNTSB GAA25WA091Accident · 2 fatalClass 5 · ForeignHughes 269C · Dippenricht, GermanyNTSB GAA25WA084Accident · 1 fatalClass 5 · ForeignBell 206 · Polokwane Civil Aerodrome, South AfricaNTSB ERA25MA106Accident · 7 fatalClass 2 · MajorPreliminary reportLearjet 55 · Philadelphia, PAOn January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two…NTSB GAA25WA083Accident · 1 fatalClass 5 · ForeignCessna C185F · Naivasha, KenyaNTSB GAA25WA052Accident · 3 fatalClass 5 · ForeignCessna 208 · Rottnest Island, AustraliaNTSB WPR25LA080Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-32-300 · Round Mountain, NVImpact with mountainous terrain for reasons that could not be determined due to a lack of available evidence.NTSB WPR25FA072Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Fullerton, CAOn January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19…NTSB DCA25WA069Accident · 35 fatalClass 5 · ForeignEmbraer ERJ190 · Aktau, KazakhstanNTSB ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB CEN25FA052Accident · 2 fatalClass 3 · FieldPreliminary reportCozy MK III · Mineola, TXOn November 27, 2024, about 18:30 central standard time, a Cozy Mark III, N51810 was destroyed when it was involved in an accident near Mineola, Texas. The pilot and passenger were fatally injured. The flight was operated under the provisions of Title 14 Code…NTSB ERA25FA058Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Windham, NYOn November 24, 2024, at about 1809 eastern standard time, a Mooney M20J, N58156, was substantially damaged when it was involved in an accident near Windham, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA033Accident · 2 fatalClass 5 · ForeignPiper PA-28-140 · Cimanes del Tejar, SpainNTSB GAA25WA031Accident · 1 fatalClass 5 · ForeignAerospatiale AS332L · Broken Hill, AustraliaNTSB GAA25WA030Accident · 3 fatalClass 5 · ForeignCessna 172 · Murska Sobota, SloveniaNTSB GAA25WA029Accident · 1 fatalClass 5 · ForeignAir Tractor AT602 · SãO Paulo, BrazilNTSB GAA25WA023Accident · 2 fatalClass 4 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB WPR25FA031Accident · 5 fatalClass 3 · FieldPreliminary reportHonda HA420 · Mesa, AZOn November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of…NTSB GAA25WA015Accident · 8 fatalClass 5 · ForeignSikorsky S76 · Port Harcourt, NigeriaNTSB WPR25FA007Accident · 5 fatalClass 3 · FieldPreliminary reportBeech 95-B55 · Avalon, CAOn October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…NTSB CEN25FA005Accident · 1 fatalClass 3 · FieldPreliminary reportChampion 7EC · Fort Worth, TXOn October 7, 2024, about 1240 central daylight time, a Champion 7EC airplane, N4337C, sustained substantial damage when it was involved in an accident near Fort Worth, Texas. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ANC24FA091Accident · 2 fatalClass 3 · FieldPreliminary reportChampion 7GCBC · Ninilchik, AKOn September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as…NTSB CEN24FA353Accident · 1 fatalClass 3 · FieldPreliminary reportHawker Beechcraft G36 · Lafayette, LAOn September 12, 2024, about 1137 central daylight time, a Hawker Beechcraft G36 airplane, N643RS, was destroyed when it was involved in an accident near Lafayette, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA24WA280Accident · 1 fatalClass 5 · ForeignGreat Lakes 2T-1A-2 · Gütersloh, GermanyNTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB GAA24WA300Accident · 9 fatalClass 5 · ForeignCessna 208 · What Khao Din, ThailandNTSB GAA24WA282Accident · 2 fatalClass 5 · ForeignPartenavia P66 · LIAA (Identifier), ItalyNTSB GAA24WA266Accident · 2 fatalClass 3 · ForeignCessna 152 · Jamshedpur, IndiaNTSB GAA24WA260Accident · 1 fatalClass 5 · ForeignCessna 152 · Santa Fe, Argentina