NTSB investigations
3,824 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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" = '341' 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 ERA10CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Highgate, VTThe pilot’s improper fuel management which resulted in loss of engine power due to fuel starvation.NTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB WPR09CA462Accident · No injuriesData collectionFinal reportAgusta A109 · Page, AZA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning and his decision to continue flight with a known low fuel level state.NTSB CEN09WA598Accident · 2 fatalForeign investigationSchweizer 269C · Blackpool, United KingdomOn September 22, 2009, at 1104 universal coordinated time, a Schweizer 269C helicopter, United Kingdom registered G-LINX, registered to Heli-Lynx Limited, was destroyed when it impacted terrain near Blackpool, Lancashire, England. Visual meteorological…NTSB WPR09LA460Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valley Center, CAThe failure of the engine’s camshaft due to fatigue of unknown origin.NTSB ERA09LA532Accident · No injuriesLimited investigationFinal reportRyan Navion · Fire Island, NYA total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.NTSB CEN09IA595Incident · No injuriesIncident investigationFinal reportBeech V35 · Nacogdoches, TXThe complete loss of engine power due to failure of the number two connecting rod. The reason for the connecting rod failure could not be determined.NTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.NTSB WPR09LA454Accident · Minor injuriesLimited investigationFinal reportLewis Jennings Nieuport 11 · Pahrump, NVA total loss of engine power during cruise flight due to a failure of the engine's sole magneto.NTSB CEN09CA593Accident · Minor injuriesData collectionFinal reportLinke KR-2 · Mt. Vernon, ILThe inadequate preflight planning/preparation and fuel management by the pilot which led to fuel exhaustion and a total loss of engine power during approach. Contributing to the accident was the inoperative fuel indicator.NTSB WPR09LA452Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Paula, CAA total loss of engine power during takeoff for undetermined reasons.NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.NTSB ERA09LA512Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Fredericksburg, PAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement of available fuel.NTSB CEN09LA574Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Kimball, NEA loss of engine power due to improper installation of an oil line fitting resulting in oil depletion.NTSB ERA09LA509Accident · Serious injuriesLimited investigationFinal reportHebert Kitfox Speedster · Morrisville, VTA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09LA511Accident · Minor injuriesLimited investigationFinal reportAir Creation 582SL · Strafford, NHA loss of engine power for undetermined reasons.NTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.NTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.NTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.NTSB ERA09LA491Accident · Minor injuriesLimited investigationFinal reportMyers Donald E Kitfox 4 · Flintstone, MDA total loss of engine power due to the lack of sufficient lubrication and the pilot/owner’s failure to adequately service the airplane’s engine.NTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.NTSB CEN09WA607Accident · No injuriesForeign investigationEurocopter AS350 B2 · Némisko, CanadaOn August 28, 2009, at 1200 eastern daylight time, a Eurocopter model AS350 B2 (AStar), s/n 3292, Canadian registration C-FHAP, experienced a loss of engine power during cruise flight near Némisko, Québec, Canada. The helicopter was substantially damaged…NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.NTSB ERA09WA486Accident · Minor injuriesForeign investigationCessna 208 · La Tortuga, VenezuelaOn August 26, 2009, about 1152 UTC, a Cessna 208B, Venezuelan registration YV1182, registered to and operated by Linea Turista Aerotuy (LTA), as a scheduled domestic passenger flight, had a total loss of engine power. The airline transport (ATP) rated pilot…NTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09LA481Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Rockaway, NJA total loss of engine power due to oil starvation for undetermined reasons.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ANC09LA086Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsNTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.NTSB CEN09LA602Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · New Miner, WIA total loss of engine power due to the fatigue failure of the engine torsion shaft. Contributing to the accident was the chrome plating of the shaft by an undetermined maintenance/overhaul facility.NTSB ERA09LA473Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Okeechobee, FLA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.NTSB CEN09CA535Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Leland, ILA total loss of engine power in flight due to a loss of engine oil as a result of the separation of the propeller hub components for undetermined reasons.NTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.NTSB CEN09CA531Accident · Serious injuriesData collectionFinal reportFisher Michael H T-BIRD II · Dundee, OHA total loss of engine power due to the failure of the outer crankshaft seal.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.NTSB ERA09LA460Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Acworth, GAThe loss of engine power due to the fatigue failure of the third-stage turbine wheel airfoil.NTSB CEN09CA517Accident · No injuriesData collectionFinal reportBell 47G-2A · Covert, MIA loss of engine power due to fuel starvation as a result of blocked fuel vents.NTSB ERA09LA453Accident · Serious injuriesLimited investigationFinal reportLaurienzo Gabriel A Varieze · North Augusta, SCA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection.NTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.