NTSB investigations
1,419 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 WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.NTSB CEN09LA396Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Shelbyville, INThe partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.NTSB CEN09CA412Accident · Minor injuriesData collectionFinal reportQuicksilver Mxii Sport · Longmont, COThe loss of engine power for undetermined reasons.NTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB ERA09CA361Accident · No injuriesData collectionFinal reportHummelbird Hummelbird · Sunrise, FLA partial loss of engine power during cruise flight for an undetermined reason.NTSB CEN09CA378Accident · No injuriesData collectionFinal reportPiper PA-24 · Urbana, OHA failure of the carburetor heat cable attach bracket which resulted in the inadvertent activation of carburetor heat and the subsequent loss of engine power during takeoff. Contributing to the accident was the pilot's operation of the aircraft with a known…NTSB ERA09LA357Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Chipley, FLA partial loss of power due to the use of automotive gasoline that contained ethanol, which was prohibited by the operating limitations. Contributing to the accident was the pilot/owner's failure to obtain and comply with the applicable operating limitations.NTSB ERA09FA355Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Naples, FLA loss of engine power due to the improper installation of the right magneto by maintenance personnel resulting in subsequent loss of engine power. Contributing to the accident was the inadequate 100-Hour inspection by the mechanic when he failed to note that…NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09LA330Accident · Serious injuriesLimited investigationFinal reportFrey FLY Baby · Keller, TXA partial loss of engine power due to an obstruction of the air intake, as reported by the pilot. Contributing to the accident was the pilot's insufficient preflight inspection.NTSB CEN09LA325Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKLoss of engine power for undetermined reasons.NTSB WPR09LA254Accident · No injuriesLimited investigationFinal reportMooney M20J · Healdsburg, CAA partial loss of engine power during the takeoff initial climb for undetermined reasons.NTSB CEN09LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Baton Rouge, LAThe partial loss of engine power due to the instructor pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing. Contributing to the accident was the instructor pilot's decision to attempt a return to the departure…NTSB WPR09LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Desert Center, CAA partial loss of engine power due to low compression from an obstructed intake valve. Contributing to the accident was the pilot’s decision to shut down the engine while in flight.NTSB CEN09LA284Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Alpine, TXThe loss of engine power due to disengagement of the magneto idler gear support pin.NTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB WPR09LA219Accident · No injuriesLimited investigationFinal reportEllumax Leasing Epic LT · Astoria, ORThe partial loss of engine power during climb to cruise due to the failure of the engine's fuel control unit. Contributing to the accident was the incorrect machining of an internal component of the fuel control unit, and the failure of the assembling…NTSB ERA09LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · Kinston, NCA partial loss of engine power due to the failure of the No. 1 cylinder exhaust valve for undetermined reasons.NTSB ERA09LA264Accident · No injuriesLimited investigationFinal reportMooney M20J · Moncks Corner, SCThe reported partial loss of engine power for undetermined reasons.NTSB WPR09LA205Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAA partial loss of engine power during takeoff due to carbon fouling of a spark plug.NTSB ERA09LA247Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cross City, FLLoss of engine power for undetermined reasons.NTSB ERA09LA239Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · Shelbyville, TNA partial loss of engine power for an undetermined reason.NTSB CEN09FA243Accident · 2 fatalField investigationFinal reportEngineering and Research 415C · Sandwich, ILThe pilot's failure to execute an immediate forced landing to a suitable field and the engine's partial loss of power for an undetermined reason.NTSB WPR09CA186Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 58 · Anacortes, WAThe partial loss of engine power due to the passenger's inadvertent movement of the engine throttle control.NTSB CEN09FA241Accident · 1 fatalField investigationFinal reportCessna T210N · Edinburg, TXA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select a suitable alternate landing site.NTSB WPR09LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Kalispell, MTA partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.NTSB ERA09LA221Accident · No injuriesLimited investigationFinal reportT51 T51 · Lake Wales, FLA partial loss of engine power due to the carburetor not being secured to its mounting pad.NTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.NTSB ERA09LA187Accident · Minor injuriesLimited investigationFinal reportDoyle-Michael Sonerai-II · Leonardtown, MDThe pilot's continued operation of the airplane with a known mechanical deficiency. Contributing to the accident was the improper installation of the electronic ignition system.NTSB CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.NTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.NTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.NTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.NTSB WPR09LA115Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Rialto, CAA partial loss of engine power to one engine during initial climb for undetermined reasons.NTSB WPR09CA114Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAA loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB ERA09LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 112A · Everglades City, FLThe partial loss of engine power for an undetermined reason. Contributing to the accident was the pilot's attempt to continue takeoff with partial engine power.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB WPR09CA091Accident · No injuriesData collectionFinal reportSiemer James H Earthstar · Santa Ynez, CAA partial loss of engine power due to the rear cylinder's spark plug coming out of the cylinder head.NTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09FA100Accident · Serious injuriesField investigationFinal reportBeech C23 · Linden, NJA partial loss of engine power for undetermined reasons.NTSB ANC09CA014Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Willow, AKA partial loss of engine power during takeoff, which prevented the airplane from reaching takeoff airspeed, resulting in an aborted takeoff, and an on-ground collision with a tree.NTSB WPR09FA060Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kapolei, HIThe partial loss of engine power during the initial climb due to the failure of both pilots to use carburetor heat during a long descent for landing in carburetor icing conditions, and, the flight instructor's inadequate supervision of the flight.NTSB ERA09FA083Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-60 · Millington, TNThe pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.NTSB ERA09CA095Accident · No injuriesData collectionFinal reportBeech C23 · Panacea, FLA loss of engine power due to a failure of the mixture control cable housing attachment.