Fatal, Ongoing NTSB investigations
21 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2024 | 4 |
|---|---|
| 2025 | 8 |
| 2026 | 9 |
Where
Open the mapLatest 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'
AND c.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' 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 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…NTSB ERA26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportDiamond Aircraft Ind DA20-A1 · Bristol, MEOn August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…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 CEN26FA228Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 680A · Laredo, TXOn June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one…NTSB WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…NTSB WPR26FA103Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 210B · Camarillo, CAOn February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…NTSB ERA26FA106Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22 · Lexington, SCOn February 6, 2026, at 0921 eastern standard time, a Cirrus Design Corp SR22, N705CD, was substantially damaged when it was involved in an accident near Lexington, South Carolina. The commercial pilot sustained serious injuries and the passenger was fatally…NTSB CEN26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportRobert G Elves Tarragon (Tarr) · Shawmut, AZOn February 6, 2026, at 1532 mountain standard time, a Tarragon airplane, N35RR, was substantially damaged when it was involved in an accident near Shawmut, Arizona. The pilot was fatally injured and the passenger received serious injuries. The airplane was…NTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB ERA26FA027Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20E · Ballston Spa, NYOn October 31, 2025, about 1035 eastern daylight time, a Mooney M20E, N79338, was destroyed when it was involved in an accident near Ballston Spa, New York. The pilot was fatally injured, and the flight instructor was seriously injured. The airplane was…NTSB WPR25FA279Accident · 1 fatalClass 3 · FieldPreliminary reportBellanca 17-30A · Moriarty, NMOn September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…NTSB CEN25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportAero Vodochody L-39C · Granite Falls, MNOn July 21, 2025, about 1728 central daylight time, an Aero Vodochody L-39C airplane, N339L, was substantially damaged during an accident near Granite Falls, Minnesota. The flight instructor, seated in the front seat, sustained serious injuries after ejecting…NTSB WPR25FA213Accident · 1 fatalClass 3 · FieldPreliminary reportScott Macwilliam SR3500 Moose · Quinault, WAOn July 15, 2025, at about 1440 Pacific daylight time, an experimental amateur-built Murphy Moose SR3500 airplane, N80TM, sustained substantial damage when it was involved in an accident near Quinault, Washington. The pilot received minor injuries, one…NTSB ERA25FA187Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20TN · Sparta, TNOn April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB ERA25FA103Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35B · Charlottesville, VAOn January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA25FA080Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · East Aurora, NYOn December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN24LA361Accident · 1 fatalClass 3 · LimitedPreliminary reportRans S14 · Teague, TXOn September 20, 2024, about 1648 central daylight time, an unregistered Rans S-14 Airaile light sport airplane, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot was fatally injured. The airplane was operated as a…NTSB ERA24FA326Accident · 1 fatalClass 3 · FieldPreliminary reportSchweizer 269C · West Carthage, NYOn July 27, 2024, about 1242 eastern daylight time, a Schweizer 269C-1, N61486, was substantially damaged when it was involved in an accident near West Carthage, New York. The private pilot was fatally injured. The helicopter was operated as a Title 14 Code…NTSB ERA24FA305Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 402 · Easton, MDOn July 16, 2024, about 0932 eastern daylight time, a Cessna 402B, N7875E, was substantially damaged when it was involved in an accident near Easton, Maryland. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…