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 GAA24WA195IncidentClass 5 · ForeignTextron 208 · Bailey Town, BahamasNTSB CEN24LA236Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Boerne, TXMaintenance personnel’s inadequate adjustment of fuel flow, which resulted in an excessively rich mixture, a rough-running engine, and a subsequent partial loss of engine power.NTSB ERA24LA271Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hernando, FLThe improper installation of a cylinder rocker stud by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing.NTSB CEN24LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hebron, NDForeign object debris in the Negative Torque Sensing (NTS) system check valve, which impeded the flow of oil to the NTS system and the propeller governor (PG) reset piston, resulting in a total loss of engine power and an off-airport forced landing.…NTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.NTSB WPR24LA198Accident · Minor injuriesClass 3 · LimitedFinal reportWarren B Cox COX Breezy · Albuquerque, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was maintenance…NTSB ANC24LA045Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · King Salmon, AKA partial loss of engine power due to detonation/preignition of the No. 1 cylinder for reasons that could not be determined.NTSB ERA24LA239Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · San Juan, PRA partial loss of engine power due to the failure of the No. 2 cylinder rocker shaft bosses from fatigue cracking.NTSB WPR24LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Nephi, UTThe pilot’s incorrect movement of the fuel selector valve to an off or restricted position, which resulted in fuel starvation and a loss of engine power.NTSB CEN24LA200Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Taylor, TXA partial loss of engine power due to an incorrect carburetor air inlet hose, which led to a reduction in air flow to the engine.NTSB WPR24LA159Accident · No injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Peoria, AZThe partial loss of engine power during cruise flight due to the improper installation of the master connecting rod main bushing set screws, which backed off and allowed the main bushing to shift, resulting in scoring damage on the crankshaft that led to the…NTSB GAA24WA216AccidentClass 5 · ForeignBell 505 · Minsk, PolandNTSB WPR24LA148Accident · No injuriesClass 3 · LimitedFinal reportKjelsrud Gary Kitfox · Powell, WYThe pilot’s adjustment of the carburetor to an incorrect setting, which resulted in partial loss of engine power during takeoff.NTSB ERA24LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Apopka, FLA partial loss of engine power due to sticking exhaust valves. Contributing to the accident was maintenance personnel’s failure to use available engine data while troubleshooting a known engine issue and maintenance personnel’s failure to comply with…NTSB GAA24WA170Accident · No injuriesClass 5 · ForeignCessna 172 · Novosibirsk, RussiaNTSB ERA24LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palatka, FLThe failure of the nose oil seal to remain secure in the engine crankcase, which resulted in a loss of engine oil and partial loss of engine power.NTSB ERA24LA190Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B24R · Lumberton Township, NJThe pilot/owner’s failure to ensure adequate maintenance of the airplane, which resulted in a partial loss of engine power during takeoff.NTSB GAA24WA149Accident · Minor injuriesClass 5 · ForeignBell 206 · State of Mato Grosso do Sul, MS, BrazilNTSB GAA24WA173AccidentClass 5 · ForeignPiper PA-25 · Trissa Charkaoua, MoroccoNTSB GAA24WA153Accident · No injuriesClass 5 · ForeignCessna 172 · Valparaso, ChileNTSB ERA24FA157Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Fort Pierce North, FLThe flight instructor’s failure to maintain control of the multiengine airplane after a partial loss of engine power on one engine during a go-around, which resulted in an aerodynamic stall. Contributing to the accident was the mechanic’s failure to check the…NTSB GAA24WA130Incident · No injuriesClass 5 · ForeignCessna 172 · Grenchen, SwitzerlandNTSB ERA24LA152Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Opelika, ALA partial loss of engine power due to a combination of fuel/oil contamination in the fuel injector assembly.NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB GAA24WA114AccidentClass 5 · ForeignPiper 24 · Leicestershire, United KingdomNTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.NTSB GAA24WA107Accident · Minor injuriesClass 5 · ForeignCessna 150 · Warsaw, PolandNTSB CEN24LA121Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Watertown, SDThe stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing due to an undersized exhaust valve guide. Contributing to the accident were the improper manufacture of the engine cylinders, and the operation of…NTSB GAA24WA090Accident · No injuriesClass 5 · ForeignBritten Norman BN2A · Puerto Baquerizo Moreno, EcuadorNTSB ERA24FA110Accident · 2 fatalClass 3 · FieldFinal reportBombardier CL-600-2B16 · Naples, FLCorrosion of both engines’ variable geometry (VG) system components, which led to their operation in an off-schedule position and resulted in near-simultaneous sub-idle rotating compressor stalls on approach, subsequent loss of thrust in both engines, and an…NTSB ERA24LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Parkland, FLA catastrophic engine failure due to oil starvation to the main bearings for undetermined reasons.NTSB GAA24WA088Accident · Minor injuriesClass 5 · ForeignPiper PA-36 · Orihueca, ColombiaNTSB GAA24WA085Accident · No injuriesClass 5 · ForeignCessna 140 · Buenos Aires, ArgentinaNTSB GAA24WA075Accident · No injuriesClass 5 · ForeignCessna 172 · Speck-Fehraltorf, SwitzerlandNTSB CEN24FA095Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Little Rock, ARThe pilot’s failure to maintain airplane control after a partial loss of engine power during initial climb. Contributing to the accident was the pilot’s failure to follow airplane flight manual procedures and limitations for the turbocharged engine, which…NTSB WPR24LA074Accident · No injuriesClass 3 · LimitedFinal reportBeck Michael J Sonex · Auburn, WAWater contamination within the fuel regulator air-reference system, which resulted in improper fuel metering and a loss of engine power during initial climb.NTSB GAA24WA067Accident · Serious injuriesClass 5 · ForeignCessna 208B · Lizard Island, AustraliaNTSB CEN24LA065Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B36TC · Burnet, TXThe loss of engine power due an overly rich mixture from an improper adjustment of the fuel pump, which resulted in a forced landing and impact with a car and terrain.NTSB GAA24WA056Accident · No injuriesClass 5 · ForeignCessna F150 · Budapest, HungaryNTSB WPR24FA054Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Topock, AZThe failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a…NTSB CEN24LA056Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Fordyce, ARThe pilot’s failure to attain a proper touchdown point following an unidentified electrical system failure and subsequent partial loss of engine power, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s…NTSB GAA24WA050Accident · Serious injuriesClass 5 · ForeignPiper PA30 · Villejuif, FranceNTSB ANC24LA005Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Kapolei, HIA partial loss of engine power due to lose baffling from the muffler, which resulted in an obstruction of the exhaust system.NTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.NTSB GAA24WA055AccidentClass 5 · ForeignRobinson R44 · Groenvlei, South AfricaNTSB GAA24WA042Accident · 1 fatalClass 5 · ForeignBeech C23 · Bram Fischer International Airpor, South AfricaNTSB ERA24LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Richmond, VAThe loss of engine power due to a restriction of fuel flow as a result of a fractured float bracket in the carburetor.NTSB GAA24WA019Accident · Serious injuriesClass 5 · ForeignCessna 208 · Barwon Heads Geelong, AustraliaNTSB ENG24WA006Incident · No injuriesClass 5 · ForeignViking DHC-6-200 · Hulhulé Island, MaldivesNTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.