Ongoing NTSB investigations
28 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2024 | 3 |
|---|---|
| 2025 | 13 |
| 2026 | 12 |
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.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '120' 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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '120' 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 WPR27FA014Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Aeneas, WANTSB CEN26LA324Accident · 2 fatalClass 3 · LimitedPreliminary reportMagni M16 · Annapolis, MOOn September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…NTSB ERA26FA271Accident · 3 fatalClass 3 · FieldPreliminary reportSmith Aerostar 601 · Lake Clear, NYOn July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB ERA26FA266Accident · 1 fatalClass 3 · FieldPreliminary reportSikorsky S76 · Huntersville, WVOn July 10, 2026, about 0745 eastern daylight time, a Sikorsky S-76D helicopter, N93RT, was destroyed when it was involved in an accident near Huntersville, West Virginia. The commercial pilot was fatally injured. The helicopter was operated as a Title 14…NTSB WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB ANC26FA057Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA20 · Cordova, AKOn June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR26FA186Accident · 4 fatalClass 3 · FieldPreliminary reportBeech C90 · Lincoln, NMOn May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the…NTSB ERA26FA178Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Ironton, OHOn April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26LA158Accident · Minor injuriesClass 3 · LimitedPreliminary reportAlexander Schleicher ASH 31 MI · Williams, CAOn April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…NTSB CEN26LA129Accident · No injuriesClass 4 · LimitedInvestigation openCameron Balloons US Z-77 · East Mountain, TXNTSB 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 CEN26FA115Accident · 4 fatalClass 3 · FieldPreliminary reportEpic E1000 · Steamboat Springs, COOn February 13, 2026, about 0019 mountain standard time, an Epic E1000 airplane, N98FK, was substantially damaged when it was involved in an accident near Steamboat Springs, Colorado. The pilot and three passengers were fatally injured. The airplane was…NTSB WPR26FA067Accident · 6 fatalClass 3 · FieldPreliminary reportBeechcraft B300 · Galveston, TXOn December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two…NTSB CEN26FA049Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-201 · Pittsfield, ILOn November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…NTSB ERA26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportJabiru USA Sport J230-SP · New Bavaria, OHOn November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…NTSB ERA26FA019Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus SR22 · Ruston, LAOn October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA26LA004Accident · No injuriesClass 3 · LimitedPreliminary reportPitts S1C · Mount Washington, KYOn October 6, 2025, about 1415 eastern daylight time, a Pitts S-1C Special, C-FAZJ, was substantially damaged when it was involved in an accident in Mt. Washington, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA367Accident · 1 fatalClass 3 · FieldPreliminary reportToop Thomas A Glasair Super II FT · Wallkill, NYOn September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a…NTSB ERA25FA344Accident · 2 fatalClass 3 · FieldPreliminary reportHughes 369D · Jim Thorpe, PAOn September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The…NTSB ANC25FA098Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Wolf, WYOn September 1, 2025 about 1612 mountain daylight time, a Piper PA-28-180 airplane, N8307W, was substantially damaged when it was involved in an accident near Wolf, Wyoming. The pilot and one passenger were seriously injured; one passenger was fatally…NTSB WPR25FA269Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28R-200 · Alta, UTOn August 31, 2025, about 1720, mountain daylight time a Piper PA28-200R, N1147X, was substantially damaged when it was involved in an accident near Alta, Utah. The pilot was seriously injured, and the passenger sustained fatal injuries. The airplane was…NTSB WPR25LA259Accident · Serious injuriesClass 3 · LimitedPreliminary reportCzech Aircraft Group Sro Sportcruiser · Puyallup, WAOn August 25, 2025, about 1456 Pacific daylight time, a Czech Aircraft Group SRO Sportcruiser, N538SF was substantially damaged when it was involved in an accident near Puyallup, Washington. The pilot sustained serious injuries, and the passenger was not…NTSB WPR25FA256Accident · 2 fatalClass 3 · FieldPreliminary reportBeech M35 · Des Moines, NMOn August 13, 2025, about 2300 mountain daylight time, a Beech M35, N951T, was destroyed when it was involved in an accident near Des Moines, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25FA232Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW27-18 · Morgan, UTOn August 1, 2025, about 1358 mountain daylight time, a Schleicher ASW27-18, N929JK, was involved in an accident near Morgan, Utah. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. A…NTSB ERA25FA272Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA46-500TP · Lititz, PAOn July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The…NTSB 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 ERA25FA069Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-12IS · Homosassa, FLOn December 6, 2024, about 2004 eastern standard time, an experimental amateur-built Vans Aircraft Inc RV-12IS, N702DP, was substantially damaged when it was involved in an accident near Homosassa, Florida. The private pilot was fatally injured. The flight…NTSB ANC24FA094Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 207 · Saint Mary's, AKOn September 15, 2024, about 2204 Alaska daylight time, a Cessna 207 airplane, N90193, was destroyed when it was involved in an accident near St. Mary’s, Alaska. The pilot and three passengers were fatally injured. The flight was operated as a Title 14 Code…