NTSB investigations
1,858 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 99 |
|---|---|
| 2009 | 116 |
| 2010 | 105 |
| 2011 | 118 |
| 2012 | 124 |
| 2013 | 82 |
| 2014 | 114 |
| 2015 | 115 |
| 2016 | 108 |
| 2017 | 99 |
| 2018 | 98 |
| 2019 | 105 |
| 2020 | 72 |
| 2021 | 111 |
| 2022 | 80 |
| 2023 | 75 |
| 2024 | 81 |
| 2025 | 88 |
| 2026 | 68 |
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' 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 CEN27LA029Accident · No injuriesLimited investigationInvestigation openPiper PA-28 · Claremore, OKNTSB ERA27LA007AccidentLimited investigationInvestigation openPiper PA-32-260 · Whiteville, NCNTSB WPR27LA008Accident · No injuriesClass 3 · LimitedInvestigation openHakala John Charles Lancair IV-P-T · Ontario, ORNTSB CEN26LA330AccidentClass 3 · LimitedInvestigation openCessna 152 · Bolingbrook, ILNTSB CEN26LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportHaberman Habercraft · Pelican Rapids, MNOn September 27, 2026, about 1720 central daylight time, a Haberman Habercraft airplane, N10516, was substantially damaged during an accident near Pelican Rapids, Minnesota. The pilot sustained a minor injury. The airplane was operated as a Title 14 Code of…NTSB ERA26LA348Accident · No injuriesClass 4 · LimitedInvestigation openHopwood Joseph R Zodiac · Stockton, ALNTSB WPR26LA347Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B-III · Creswell, NCOn September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…NTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…NTSB ANC26LA103Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Colquitt, GAOn September 11, 2026 about 0830 eastern daylight time, a Robinson R44 helicopter, N4026E, was substantially damaged when it was involved in an accident near Colquitt, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…NTSB WPR26LA335Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210 · Polson, MTOn September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title…NTSB ERA26LA342Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Panama City, FLOn September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was…NTSB ANC26LA098Accident · Serious injuriesClass 3 · LimitedPreliminary reportPitts Model 12 · Lake Stevens, WAOn September 6, 2026, about 1800 Pacific daylight time, an experimental Pitts Model 12 airplane, N491X, was substantially damaged when it was involved in an accident near Lake Stevens, Washington. The pilot sustained serious injuries. The airplane was…NTSB ERA26LA331Accident · No injuriesClass 3 · LimitedPreliminary reportBell 47G-4A · Alcoma, FLOn September 5, 2026, at 1422 eastern daylight time, a Bell 47G-4A, N797WS, was substantially damaged when it was involved in an accident near Alcoma, Florida. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations…NTSB WPR26LA327Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150E · Siler, WAOn September 1, 2026, at 1220 Pacific daylight time, a Cessna 150E, N3037J, sustained substantial damage when it was involved in an accident near Siler, Washington. The pilot and pilot rated passenger were not injured. The airplane was operated as a Title 14…NTSB ERA26FA317Accident · 2 fatalClass 3 · FieldPreliminary reportConsolidated Aeronautics Lake LA-4-200 · Ithaca, NYOn August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was…NTSB ERA26LA319Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA22 · Pace, FLOn August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA26LA314Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 421 · Fulton, KYThe misfuelling of the airplane by the refueler. Contributing to the accident was the pilot’s failure to verify that the airplane had been properly fueled prior to departing on the accident flight.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 ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…NTSB CEN26LA293Accident · No injuriesClass 3 · LimitedInvestigation openGildea William D Jabiru Calypso · Lake Isabella, MINTSB CEN26LA292Accident · Serious injuriesClass 3 · LimitedInvestigation openTaylorcraft DCO-65 · Copper City, MINTSB ERA26LA296Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA32 · Dawsonville, GANTSB CEN26LA281Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · Longmont, CONTSB CEN26LA265Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Bulverde, TXOn July 20, 2026, about 1340 central daylight time, a Piper PA-28-180, N454MD was substantially damaged when it was involved in an accident near Bulberde, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a…NTSB CEN26LA259Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 · Adair, IAOn July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB CEN26LA248Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Tulsa, OKOn July 9, 2026, about 1729 central daylight time, a Piper PA-30 airplane, N8154Y, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The flight instructor and pilot under instruction were seriously injured. The airplane was…NTSB DCA26WA276IncidentClass 5 · ForeignBoeing 767 · enroute, FranceNTSB ANC26LA068Accident · Minor injuriesClass 4 · LimitedInvestigation openSchweizer 269C · Skwentna, AKNTSB CEN26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-25-235 · Forest Lake, MNOn July 4, 2026, about 0942 central daylight time, a Piper PA-25-235 airplane, N386AB, was substantially damaged when it was involved in an accident near Forest Lake, Minnesota. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA254Accident · No injuriesClass 3 · LimitedPreliminary reportRath Michael J Sonerai 2 · Cynthiana, KYOn June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB ANC26LA066Accident · Serious injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 NG · Petersburg, VAOn June 29, 2026, about 1945 eastern daylight time (EDT), a Diamond Aircraft Industries Inc. DA40 NG airplane, N602RF, was substantially damaged when it was involved in an accident near Petersburg, Virginia. The flight instructor sustained serious injuries,…NTSB ERA26LA251Accident · Minor injuriesClass 3 · LimitedPreliminary reportJones Peter M Boeing/Jones 75 · Cleveland, GAOn June 26, 2026, about 1045 eastern daylight time, a Boeing/Jones 75, N3993C, was substantially damaged when it was involved in an accident near Cleveland, Georgia. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB ANC26LA062Accident · Minor injuriesClass 3 · LimitedPreliminary reportTextron 208B · Wiseman, AKOn June 22, 2026, about 1043 Alaska standard time, a turbine-powered Cessna 208B airplane N94AW, was substantially damaged when it was involved in an accident near Wiseman, Alaska. The nine passengers were uninjured, the pilot sustained minor injuries. The…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 ANC26LA053Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Key West, FLOn June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB CEN26LA223Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T206H · Bryant, AROn June 10, 2026, about 1223 central daylight time, a Cessna T206H airplane, N72RK, was substantially damaged when it was involved in an accident near Bryant, Arkansas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26LA049Accident · Minor injuriesClass 4 · LimitedInvestigation openWilliam F Schoen RV-7 · Alpine, CONTSB CEN26LA220Accident · Minor injuriesClass 3 · LimitedPreliminary reportAero Commander 112 · Fabens, TXOn June 6, 2026, at 0900 central daylight time, an Aero Commander, N27007, sustained substantial damage when it was involved in an accident in Fabens, Texas. The private pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA221Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Pembroke Pines, FLOn May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…NTSB CEN26LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportMustang Aeronautics Mustang II · Richmond, TXOn May 28, 2026, about 1440 central daylight time, a Mustang Aeronautics Mustang II airplane, N160MT, sustained substantial damage when it was involved in an accident near Richmond, Texas. The pilot sustained minor injuries. The airplane was operated as a…NTSB ERA26LA219Accident · Serious injuriesClass 3 · LimitedPreliminary reportRainbow Cheetah XLS · Knightdale, NCOn May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were…NTSB ANC26LA044Accident · Minor injuriesClass 3 · LimitedPreliminary reportSling Sling LSA · Makanalua, HIOn May 25, 2026, about 1110 Hawaii-Aleutian Standard time, a Sling Aircraft LSA, N83PF, was substantially damaged when it was involved in an accident near Kalaupapa, Hawaii Airport (LUP). The two pilots onboard sustained minor injuries. The airplane was…NTSB WPR26LA190Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Chandler, AZOn May 14, 2026, at 2043 mountain standard time, a Piper PA-28, N8714N, was substantially damaged when it was involved in an accident near Chandler, Arizona. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA197Accident · Serious injuriesClass 3 · LimitedPreliminary reportMooney M20J · Lake Havasu City, AZOn May 14, 2026, at 1523, a Mooney M20J, N4665H, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The pilot and two passengers sustained serious injuries. The airplane was operated under Title 14 Code of Federal…NTSB WPR26LA193Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ACA · Pacific City, ORThe pilot’s loss of directional control during a precautionary landing following a partial reduction in engine rpm.NTSB DCA26WA207Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Lahore, PakistanNTSB ERA26LA197Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Lancaster, OHOn May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA196Accident · No injuriesClass 3 · LimitedPreliminary reportBeech C23 · Bangor, MEOn May 01, 2026, at 1604 eastern daylight time, a Beechcraft C23 airplane, N18516, was substantially damaged when it was involved in an accident near Bangor, Maine. The private pilot and flight instructor were uninjured. The airplane was operated as a Title…NTSB GAA26WA182IncidentClass 5 · ForeignPiper PA60 · Villavicencio, ColombiaNTSB ERA26FA179Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 401B · Land O' Lakes, FLOn April 19, 2026, about 0834 eastern daylight time, a Cessna 401B, N122AT, was destroyed when it was involved in an accident near Land O’ Lakes, Florida. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…