NTSB investigations
2,826 cases where the defining event was Loss of engine power (total).
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\" = '341') 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" = '341') 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 CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB WPR25LA171Accident · Minor injuriesClass 3 · LimitedPreliminary reportYakovlev YAK-50 · Hayward, CAOn June 7, 2025, about 1252 Pacific daylight time, a Yakovlev YAK-50, N150YK, was substantially damaged when it was involved in an accident near Hayward, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA170Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150M · Phoenix, AZOn June 6, 2025, about 0530 mountain standard time, a Cessna 150M, N45659, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane was operated as a…NTSB GAA25WA197Incident · No injuriesClass 5 · ForeignPiper PA31 · Meekatharra, AustraliaNTSB GAA25WA177Accident · No injuriesClass 5 · ForeignCessna U206 · Santa Elena de Uairén, VenezuelaNTSB ERA25LA225Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150J · Elberta, ALOn June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…NTSB ERA25LA215Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Branford, CTMaintenance personnel's improper installation and inspection of the crankshaft gear bolt during major overhaul, which resulted in the crankshaft gear disengaging from the accessory gears which led to a total loss of engine power.NTSB GAA25WA172Accident · 2 fatalClass 5 · ForeignBeech B36 · Korschenbroich, GermanyNTSB CEN25LA192Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-32RT-300T · Tulsa, OKOn May 30, 2025, about 1627 central daylight time, a Piper PA-32RT-300T airplane, N130XR, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…NTSB GAA25WA173Accident · No injuriesClass 5 · ForeignPiper PA-24 · Reykjavik, IcelandNTSB CEN25LA186Accident · No injuriesClass 3 · LimitedPreliminary reportAeronca 7AC · Westphalia, MIOn May 24, 2025, at 1300 eastern daylight time, an Aeronca 7AC, N2659E, was substantially damaged when it was involved in an accident near Westphalia, Michigan. The commercial pilot was not injured. The airplane was operated under Title 14 Code of Federal…NTSB CEN25LA181Accident · Serious injuriesClass 3 · LimitedPreliminary reportGrumman TBM-3 · Terre Haute, INOn May 15, 2025, about 1339 eastern daylight time, a Grumman TBM-3 airplane, N420GP, was substantially damaged when it was involved in an accident near Terre Haute, Indiana. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…NTSB CEN25LA175Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA 46-350P · Greenwood, INOn May 11, 2025, about 1231 central daylight time, a Piper PA46-350P, N253MA, sustained substantial damage when it was involved in an accident near Greenwood, Indiana. The pilot and passenger received serious injuries. The airplane was operated as a Title 14…NTSB WPR25LA155Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18-150 · Enumclaw, WAOn May 10, 2025, about 1412 Pacific daylight time, a Piper PA-18-150, N333TM, was substantially damaged when it was involved in an accident near Enumclaw, Washington. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA154Accident · No injuriesClass 3 · LimitedPreliminary reportLee JA30 Superstol · Evanston, WYOn May 9, 2025, about 1020 mountain daylight time, an experimental amateur-built Just Aircraft Superstol, N128EL, was substantially damaged when it was involved in an accident near Evanston, Wyoming. The pilot and passenger were not injured. The airplane was…NTSB GAA25WA168Accident · No injuriesClass 5 · ForeignCirrus SR22 · Toronto, CanadaNTSB WPR25FA146Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Grass Valley, CAAn improperly tightened B-nut fitting at the fuel flow divider, which resulted in a fuel leak and loss of engine power due to fuel starvation, and the inadequate maintenance inspection, which failed to detect and correct the discrepancy.NTSB CEN25LA162Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210N · Fayetteville, AROn April 22, 2025, about 13:25 central daylight time a Cessna T210N, N4795C was involved in an accident near Fayetteville, Arkansas. The pilot and two passengers were not injured. The flight was operated under the provisions of Title 14 Code of Federal…NTSB WPR25LA136Accident · No injuriesClass 3 · LimitedPreliminary reportD'Apuzzo Senior Aero Sport · Phoenix, AZOn April 19, 2025, about 1106 Pacific daylight time, an experimental amateur built D'Apuzzo Senior Aero Sport, N321WC, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot was not injured. The airplane was operated as…NTSB ERA25LA177Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A24 · Greenville, SCOn April 17, 2025, about 1540 eastern daylight time, a Beech A24 airplane, N8060R, was substantially damaged when it was involved in an accident at the Greenville Downtown Airport (GMU), Greenville, South Carolina. The pilot sustained minor injuries. The…NTSB GAA25WA157Accident · 1 fatalClass 5 · ForeignCessna 182 · Oriximina, BrazilNTSB GAA25WA148AccidentClass 5 · ForeignCessna F150 · Gliwice, PolandNTSB WPR25LA134Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B · Amboy, WAOn April 14, 2025, about 1800 Pacific daylight time, a Bell 206B, N16671, was substantially damaged when it was involved in an accident near Amboy, Washington. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations,…NTSB CEN25LA156Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20J · Edinburg, TXOn April 12, 2025, at 1010 central daylight time, a Mooney M20J, N5807T, was substantially damaged when it was involved in an accident near Edinburg, Texas. The private pilot and two passengers were uninjured. The airplane was operated under Title 14 Code of…NTSB GAA25WA140Accident · Minor injuriesClass 5 · ForeignCessna 150 · Campina Grande, BrazilNTSB ERA25LA169Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Fredericksburg, VAOn April 9, 2025, about 1505 eastern daylight time, a Beech A36, N2Z, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot and the pilot rated passenger sustained minor injuries. The airplane was operated…NTSB WPR25LA135Accident · No injuriesClass 4 · LimitedFinal reportMartin Uav Vbat · Douglas, AZThe malfunction of the throttle servo which resulted in the complete loss of engine power.NTSB GAA25WA135Accident · No injuriesClass 5 · ForeignCessna 150 · 9 de Julio, ArgentinaNTSB GAA25WA127AccidentClass 5 · ForeignCessna 152 · Antanhol, PortugalNTSB GAA25WA122Accident · No injuriesClass 5 · ForeignCessna T210R · El Perico, MexicoNTSB GAA25WA128AccidentClass 5 · ForeignBeech B36TC · Bonn, GermanyNTSB GAA25WA131Accident · No injuriesClass 5 · ForeignCozy MK IV · Gloucester, United KingdomNTSB ERA25LA141Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Hollywood, FLA total loss of engine power was due to a fracture of the crankshaft at the No. 3 main journal, which originated from a preexisting, thermally induced crack that had gone undetected by maintenance personnel during an inspection performed as part of the…NTSB CEN25LA114Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A23-19 · Rochester, MNOn March 9, 2025, about 2215 central daylight time, a Beech A23-19, N4784J, was substantially damaged when it was involved in an accident near Rochester, Minnesota. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA132Accident · No injuriesClass 3 · LimitedPreliminary reportTextron 172 · New Smyrna Beach, FLOn March 1, 2025, about 1138 eastern standard time, a Cessna 172S, N923EP, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB GAA25WA101Accident · No injuriesClass 5 · ForeignCessna 210 · Santa Ana, Beni, BoliviaNTSB GAA25WA103Accident · No injuriesClass 5 · ForeignCessna 150 · Landshut, GermanyNTSB GAA25WA111Accident · No injuriesClass 5 · ForeignPiper PA-25-150 · Pinzon, ArgentinaNTSB GAA25WA102Accident · No injuriesClass 5 · ForeignCessna 152 · San Rafael, ArgentinaNTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB CEN25LA103Accident · Minor injuriesClass 3 · LimitedPreliminary reportStarduster II · Azle, TXOn February 24, 2025, at 1430 central standard time, a Starduster II airplane, N78WT, was destroyed when it was involved in an accident near Azle, Texas. The private pilot and a passenger received minor injuries. The airplane was operated as a Title 14 Code…NTSB WPR25LA095Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver Aeronautics L-S2S · Geyserville, CAThe pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.NTSB CEN25LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Breckenridge, TXThe mechanic’s failure to properly install the throttle cable hardware resulting in a separation of the cable and loss of engine throttle control.NTSB WPR25LA094Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210R · Flagstaff, AZOn February 16, 2025, about 1445 mountain standard time, a Cessna T210R, N105DF, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA113Accident · Minor injuriesClass 3 · LimitedPreliminary reportVulcanair S P A Vulcanair V1.0 · Cheswold, DEOn February 7, 2025, at 2233 eastern standard time, a Vulcanair S.p.A V1.0, N186DS, was substantially damaged when it was involved in an accident near Cheswold, Delaware. The private pilot and pilot-rated passenger were uninjured. The airplane was operated as…NTSB GAA25WA104Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Morcovia, HondurasNTSB GAA25WA088Accident · Serious injuriesClass 5 · ForeignJodel DR1050 · Clermont, IrelandNTSB CEN25LA094Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 58P · Pine Bluff, AROn February 5, 2025, about 1848 central standard time, a Beech 58P airplane, N138TL, was substantially damaged when it was involved in an accident near Pine Bluff, Arkansas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB GAA25WA108Accident · No injuriesClass 5 · ForeignCessna U206 · Novo Progresso, BrazilNTSB 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…