NTSB investigations
3,825 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 WPR23LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Mesa, AZThe failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.NTSB ERA23FA023Accident · 2 fatalClass 3 · FieldFinal reportPeryera Adventura II · Miramar, FLThe pilot’s failure to remove the ECU select switch per the manufacturer’s service bulletin, which resulted in a loss of engine power.NTSB CEN23LA014Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 62 · Dallas, TXA total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.NTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaNTSB WPR23LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182C · Boulder City, NVA total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.NTSB GAA23WA004Accident · Minor injuriesClass 5 · ForeignPilatus BN2A-21 · Kubin, AustraliaNTSB WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB ERA22FA418Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Afton, VAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power at night over mountainous terrain.NTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…NTSB CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.NTSB GAA22WA281AccidentClass 5 · ForeignCessna A188B · Santa Helena de Goias, BrazilNTSB ERA22LA410Accident · No injuriesClass 3 · LimitedFinal reportCessna U206 · Buckland, AKThe installation of incompatible rocker arms and rocker arm bushings during an engine overhaul, which resulted in a complete loss of engine power.NTSB ERA22LA417Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Meridianville, ALA loss of engine power that could not be determined based on the available evidence.NTSB WPR22FA335Accident · 1 fatalClass 3 · FieldFinal reportRutan Varieze · Columbia, CAThe pilot’s improper maintenance of the ignition system, which led to an ignition system failure and a loss of engine power.NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB WPR22LA330Accident · Minor injuriesClass 3 · LimitedFinal reportSikorsky S-61N · Shady Cove, ORA total loss of engine power due to the failure of the No. 2 engine’s stage 1 turbine blades as a result of an unreported hot start two days earlier.NTSB GAA22WA264AccidentClass 5 · ForeignMooney M20J · Braunschweig, GermanyNTSB ERA22LA392Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Gates Mills, OHThe instructor pilot’s decision to perform an inflight magneto check with no suitable area to land. Contributing to the accident was the pilot's failure to correctly perform a magneto check that resulted in a total loss of engine power.NTSB ENG22WA047OccurrenceClass 5 · ForeignAirbus Canada BD500 · Zurich, SwitzerlandNTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.NTSB GAA22WA252Accident · No injuriesClass 5 · ForeignMooney M20E · Augsburg, GermanyNTSB WPR22LA302Accident · Minor injuriesClass 3 · LimitedFinal reportGoddard Dick Sim Bensen B-8M · Corona, CAThe fatigue failure of the engine mount resulting in a loss of engine power and directional control while maneuvering.NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB ERA22LA372Accident · Minor injuriesClass 3 · LimitedFinal reportThomas Wayne L THOMAS' Flyer · Searsmont, MEA total loss of engine power during the initial climb for reasons that could not be determined.NTSB CEN22FA383Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Hanna City, ILA total loss of engine power due to fuel exhaustion.NTSB GAA22WA250Accident · No injuriesClass 5 · ForeignCessna 172H · Assens, DenmarkNTSB GAA22WA243Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Bueanaventura Beach, PanamaNTSB WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.NTSB GAA22WA246Accident · No injuriesClass 5 · ForeignRobinson R22 · Lotus Vale, AustraliaNTSB GAA22WA244Accident · No injuriesClass 5 · ForeignPiper PA-28-161 · Hampshire, United KingdomNTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.NTSB CEN22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206B · Arcadia, IAMaintenance personnel’s failure to properly torque a fuel control unit B-nut, which resulted in a loss of engine power at low altitude and an impact with terrain.NTSB WPR22LA287Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Livermore, CAThe total loss of engine power due to an inadequately maintained fuel injection servo.NTSB CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.NTSB ERA22LA333Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Batesburg, SCThe fatigue failure of the crankshaft gear, resulting in a total loss of engine power.NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB GAA22WA237Accident · No injuriesClass 5 · ForeignRobinson R44 · Buenos Aires, ArgentinaNTSB WPR22LA263Accident · Serious injuriesClass 3 · LimitedFinal reportZenith CH701 · Bothell, WAA loss of engine power due to the fatigue failure of the engine’s flywheel screws that were likely overloaded when the engine was involved in a previous accident.NTSB WPR22LA262Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Three Forks, MTA loss of engine power due to degraded and incorrectly maintained ignition system components. Contributing to the accident was the pilot’s delay in turning the airplane towards the runway when the engine began to lose power.NTSB GAA22WA253Accident · No injuriesClass 5 · ForeignEnstrom F28 · Nurnberg, GermanyNTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.NTSB CEN22LA322Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 112 · Granbury, TXThe loss of engine power due to metal contamination within the cylinder following poor maintenance.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB ERA22LA323Accident · Serious injuriesClass 3 · LimitedFinal reportAllan G Pixley Thatcher CX4 · Baker, FLThe improper engine idle setting, which resulted in a total loss of engine power when the pilot reduced the throttle to idle to initiate a descent.NTSB CEN22LA341Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421B · Riverdale, NEA total loss of engine power as a result of fuel exhaustion.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB CEN22LA315Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 650B · Eufaula, OKThe loss of engine power due to a push rod that was incorrectly installed by the airplane owner.NTSB CEN22LA312Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Decatur, ILFracture of the compressor turbine (CT) blades due to creep.NTSB WPR22LA243Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Oxnard, CAFuel starvation due to an inappropriately maintained and modified fuel selector valve.NTSB GAA22WA249Accident · No injuriesClass 5 · ForeignPiper PA-32R-301T · Tamaulipas, Mexico