NTSB investigations
1,858 cases where the sequence of events included 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 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 CEN09CA386Accident · No injuriesData collectionFinal reportHubbell Prescott Pusher · Ashville, OHA partial loss of engine power due to propeller damage from being struck by the cabin-entry door, which inadvertently opened and departed the airframe for undetermined reasons during flight.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 WPR09CA303Accident · No injuriesData collectionFinal reportCessna A188B · Ogden, UTA partial loss of engine power due to the number one cylinder air induction tube becoming disconnected for undetermined reasons.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 ERA09CA332Accident · No injuriesData collectionFinal reportTeratorn Tierra · Cutchogue, NYThe pilot's decision to attempt takeoff from unsuitable terrain.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 ERA09LA293Accident · Serious injuriesLimited investigationFinal reportGossard Ronald F Kitfox IV · Camden, NCA loss of engine power due to an in-flight separation of the engine muffler exhaust pipe and resulting impingement of hot exhaust gases on the carburetor.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 CEN09CA283Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Iowa, LAA partial loss of engine power due to the Number 8 cylinder head cracking and separating from the barrel.NTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.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 CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.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 CEN09CA257Accident · No injuriesData collectionFinal reportEnstrom 280FX · Dacono, COA partial loss of engine power for undetermined reasons.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 CEN09LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Georgetown, TXA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management. Contributing to the accident was the pilot's improper engine restart procedures.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 ERA09LA203Accident · Serious injuriesLimited investigationFinal reportWayne O Robinson S6S Rans · Cartersville, GAThe pilot's failure to maintain airspeed following a partial loss of engine power during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was chafed wires in the ignition system.NTSB CEN09LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Shelbyville, INThe loss of engine power during cruise flight due to fuel contamination. Also causal was the pilot's decision to conduct the flight with known contaminants in the fuel.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 WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.NTSB ERA09LA176Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ridgeland, SCThe pilot's failure to maintain control of the airplane during a precautionary landing. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.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 ERA09LA158Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lakeville, NYThe pilot's failure to maintain aircraft control following a loss of engine power on the left engine for undetermined reasons.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.