NTSB investigations
1,421 cases where the defining event was Loss of engine power (partial).
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '342') 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 ANC25LA077Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210-5 · Yakutat, AKOn July 23, 2025, about 1700 Alaska daylight time, a Cessna 210-5 (205) airplane, N8457Z, was substantially damaged when it was involved in an accident on a remote beach about 50 miles southeast of Yakutat, Alaska. The pilot was uninjured. The airplane was…NTSB WPR25LA228Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Astoria, OROn July 22, 2025, about 1706 Pacific daylight time, a Beechcraft Bonanza V35, N3785Q, sustained substantial damage when it was involved in an accident near Astoria, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB GAA25WA214Incident · No injuriesClass 5 · ForeignCessna 152 · Miranda, VenezuelaNTSB ERA25LA270Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA46 · Sunset, SCOn July 17, 2025, about 1122 eastern daylight time, a Piper PA-46-310P, N460WW, was substantially damaged when it was involved in an accident near Sunset, South Carolina. The commercial pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA269Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech K35 · Sylacauga, ALOn July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…NTSB GAA25WA212AccidentClass 5 · ForeignHughes 369 · Galapagos Islands, PanamaNTSB WPR25LA210Accident · No injuriesClass 3 · LimitedPreliminary reportHibbard Rick Rans S7 · Blackfoot, IDOn July 12, 2025, about 2015 mountain daylight time, an experimental amateur-built Rans S7 airplane, N69TY, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was not injured. The airplane was operated as a Title 14…NTSB ANC25LA063Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182G · Kona, HIOn July 3, 2025, about 0657 Hawaii-Aleutian standard time, a Cessna 182G airplane, N3261S, was substantially damaged when it was involved in an accident near Kona, Hawaii. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ENG25WA054IncidentClass 5 · ForeignPilatus PC12 · Kitakyushu, JapanNTSB CEN25LA232Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B · Edgerton, MOOn July 1, 2025, at 0845 central daylight time, a Bell 206B, N17626, was substantially damaged when it was involved in an accident near Edgerton, Missouri. The commercial pilot was uninjured. The helicopter was operated under Title 14 Code of Federal…NTSB GAA25WA226Accident · Minor injuriesClass 5 · ForeignAir Tractor AT301 · Cienaga, ColombiaNTSB GAA25WA196AccidentClass 5 · ForeignCirrus Design SR22 · Remomeix, FranceNTSB ERA25LA238Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Fayetteville, TNThe pilot’s decision to operate the airplane with known discrepancies.NTSB DCA25LA233Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 747-47UF · Guayaquil, EcuadorNTSB ERA25LA222Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6 Twin Otter · Tullahoma, TNOn June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…NTSB WPR25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182J · Kooskia, IDOn May 31, 2025, about 0930 Pacific daylight time, a Cessna 182J, N3463F, was substantially damaged when it was involved in an accident near Kooskia, Idaho. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA214Accident · No injuriesClass 3 · LimitedPreliminary reportJernigan Zenith 750 · Greenville, SCOn May 18, 2025, about 1416 eastern daylight time, an experimental, amateur-built Zenith 750, N864AJ, was substantially damaged when it was involved in an accident near Greenville, South Carolina. The private pilot was not injured. The airplane was operated…NTSB WPR25LA159Accident · Serious injuriesClass 3 · LimitedPreliminary reportNorth American T-28B · Olivehurst, CAOn May 17, 2025, at 1022 Pacific daylight time, a North American T-28B, N28DE, was substantially damaged when it was involved in an accident near Marysville, California. The pilot and passenger were seriously injured. The airplane was operated as a Title 14…NTSB CEN25LA182Accident · No injuriesClass 3 · LimitedPreliminary reportBeech F33A · Houston, TXOn May 16, 2025, about 1459 central daylight time, a Beech F33A airplane, N6376S, was destroyed when it was involved in an accident near Houston, Texas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB GAA25WA164Incident · No injuriesClass 5 · ForeignRobinson R44 · International Waters, EcuadorNTSB CEN25LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe disconnected throttle control that resulted in a loss of engine power due to improper maintenance.NTSB GAA25WA163Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Shelford, AustraliaNTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB WPR25LA130Accident · Serious injuriesClass 3 · LimitedPreliminary reportHy-Tek Hurricane HP · Elko, NVOn April 14, 2025, about 1003 Pacific daylight time, an experimental amateur-built Hy-Tek Hurricane HP, N9088G, was substantially damaged when it was involved in an accident near Elko, Nevada. The pilot sustained serious injuries. The airplane was operated as…NTSB WPR25LA133Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182L · Erie, NVOn April 13, 2025, about 0850 Pacific daylight time, a Cessna 182L, N182VE, was substantially damaged when it was involved in an accident near Erie, Nevada. The pilot and two passengers were uninjured, and one passenger sustained minor injuries. The airplane…NTSB WPR25FA127Accident · 1 fatalClass 3 · FieldPreliminary reportAzalea Saberwing · Justin, TXOn April 11, 2025, about 1906 central daylight time (CDT), an experimental amateur-built Azalea Aviation LLC Saberwing, N121DF, was destroyed when it was involved in an accident near Justin, Texas. The pilot was fatally injured. The airplane was operated as a…NTSB GAA25WA136Accident · No injuriesClass 5 · ForeignRobinson R44 · Puerto Lopez, EcuadorNTSB GAA25WA118Accident · No injuriesClass 5 · ForeignCessna 177RG · Vereda El Corzo, ColombiaNTSB GAA25WA123Incident · No injuriesClass 5 · ForeignBell 206 · Raul Soares, BrazilNTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Pearland, TXOn March 6, 2025, about 1145 central standard time, a Piper PA-28-140 airplane, N54479, was substantially damaged when it was involved in an accident near Pearland, Texas. One pilot sustained minor injuries, and the other pilot was not injured. The airplane…NTSB CEN25LA107Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Alvord, TXA total loss of engine power for a reason that could not be determined.NTSB GAA25WA151Accident · No injuriesClass 5 · ForeignCessna 188 · La Puntilla, EcuadorNTSB GAA25WA097Accident · Minor injuriesClass 5 · ForeignPiper PA38 · Ilpango,, El SalvadorNTSB CEN25LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5A · Gladewater, TXOn February 17, 2025, about 2215 central standard time, a Grumman AA-5A airplane, N26071, was substantially damaged when it was involved in an accident near Gladewater, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN25LA097Accident · Serious injuriesClass 3 · LimitedPreliminary reportDouglas A-20G · Laredo, TXOn February 16, 2025, about 1239 central standard time, a Douglas A-20G airplane, N747HS, was substantially damaged when it was involved in an accident in Laredo, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.NTSB GAA25WA076AccidentClass 5 · ForeignRobinson R22 · Workingham, Berkshire, United KingdomNTSB GAA25WA067Accident · No injuriesClass 5 · ForeignPiper PA31 · Canelillos, ChileNTSB ERA25LA098Accident · Minor injuriesClass 3 · LimitedPreliminary reportMontaer Ltda Montaer MC01 · Miramar, FLOn January 19, 2025, about 1410 eastern standard time, a Montaer MC-01, N916VS, was substantially damaged when it was involved in an accident near Miramar, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR25LA084Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Prescott, AZOn January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB GAA25WA074Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Paracatu, BrazilNTSB GAA25WA054Accident · Minor injuriesClass 3 · ForeignCessna 188 · Colon, EcuadorNTSB GAA25WA043Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Los Lagos, ChileNTSB ERA25FA076Accident · 1 fatalClass 3 · FieldPreliminary reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTOn December 12, 2024, about 1846 eastern standard time, a Costruzioni Aeronautiche Tecnam P2008, N298PM, was substantially damaged when it was involved in an accident near Greenwich, Connecticut. The commercial pilot was fatally injured, and the private pilot…NTSB GAA25WA039Accident · Serious injuriesClass 5 · ForeignCessna Cessna FA 150L · Watorowo, PolandNTSB WPR25LA054Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150L · Glen Avon, OROn December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ENG25WA013OccurrenceClass 5 · ForeignBoeing 737-9 · Cancún, MexicoNTSB ENG25WA010IncidentClass 5 · ForeignAirbus A320 · Aukland, New ZealandNTSB CEN25LA054Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA-1B · Brenham, TXA partial loss of engine power due to an obstructed induction system from a mud dauber nest.NTSB ERA25LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Chattanooga, TNA partial loss of engine power due to a fouled spark plug in engine’s the No. 4 cylinder. Contributing was the flight instructor’s failure to maintain aircraft control during an attempted go-around following an unsuccessful landing approach in IMC, which…