NTSB investigations
1,226 cases where NTSB found Engine (reciprocating).
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010585')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010585')) 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 CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB CEN23LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Batesville, MSThe pilot’s failure to maintain airplane control while landing with a left gusting crosswind. Contributing to the accident was the partial loss of engine power during the go-around.NTSB ERA23LA205Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Springfield, TNA partial loss of engine power for undetermined reasons.NTSB WPR23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Grand Canyon, AZThe airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB WPR23LA160Accident · No injuriesClass 3 · LimitedFinal reportRemos Remos GX · Glendale, AZA total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.NTSB WPR23LA156Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Riverside, CAThe pilot’s failure to use carburetor heat during an extended ground delay before takeoff, which resulted in a total loss of engine power during initial climb due to carburetor ice.NTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB CEN23LA165Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Lsa Sinus · Kingsford, MIThe failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.NTSB ERA23LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · Charles Town, WVA loss of engine power for undetermined reasons.NTSB ERA23FA188Accident · 1 fatalClass 3 · FieldFinal reportMiller Glenn F RV-12 · Climax, NCThe airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…NTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.NTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.NTSB ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.NTSB ANC23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Minto, AKA total loss of engine power for reasons that could not be determined.NTSB WPR23LA134Accident · No injuriesClass 3 · LimitedFinal reportHarris Robert W Zenith CH 801 · Brigham City, UTThe pilot’s improper flare, which resulted in a hard landing following a reported loss of engine thrust for undetermined reasons.NTSB ERA23LA148Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity Velocity SE · Bahia Key, FLA total loss of engine power for undetermined reasons.NTSB ERA23LA146Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Titusville, FLThe pilot’s failure to maintain adequate main rotor RPM during an autorotation which resulted in a hard landing and subsequent rotor blade strike of the tail boom.NTSB ERA23LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Miami, FLA total loss of engine power due to a lack of oil lubrication.NTSB ERA23LA173Accident · No injuriesClass 3 · LimitedFinal reportBeech P35 · Perry, FLMaintenance personnel’s incorrect torquing of the oil filter adapter jam nut, resulting in the failure of the adapter threads, a complete loss of oil, and subsequent total loss of engine power.NTSB WPR23LA117Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Lampasas, TXImproper case hardening of the crankshaft timing gear, which resulted in the fatigue failure of the gear and a total loss of engine power.NTSB CEN23LA114Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Venus, TXThe loss of engine power for undetermined reasons.NTSB CEN23LA107Accident · No injuriesClass 3 · LimitedFinal reportMooney M20 · Lakeway, TXA total loss of engine power due to detonation and preignition in the No. 6 cylinder.NTSB ANC23LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-16 · Soldotna, AKA total loss of engine power for undetermined reasons.NTSB WPR23LA104Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Gladewater, TXThe loss of engine power for undetermined reasons.NTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.NTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB ERA23FA113Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · North Castle, NYThe pre-ignition/detonation damage to the No. 4 piston for reasons that could not be determined, which allowed the crankcase to become pressurized and resulted in oil exhaustion and subsequent catastrophic internal engine failure.NTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.NTSB WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB CEN23LA066Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Harrison, ARA loss of engine power for reasons that could not be determined.NTSB CEN23LA062Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Addison, TXThe fatigue failure of the engine’s camshaft gear teeth which resulted in a loss of all engine power. Contributing to the accident was the non-compliance with the engine manufacturer’s recommended service bulletin.NTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…NTSB ERA23LA073Accident · No injuriesClass 3 · LimitedFinal reportChilds Michael A Rotorway Exec 162-F · Titusville, FLA failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.NTSB CEN23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Cypress, TXFailure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.NTSB CEN23FA038Accident · 1 fatalClass 3 · FieldFinal reportCessna 421C · Decatur, TXA loss of power on the left engine due to fuel starvation and the subsequent loss of power on the right engine for undetermined reasons.NTSB WPR23LA031Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150G · Star Valley, AZThe failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain.NTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.NTSB ANC23LA005Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · Kenai, AKImproper installation of the crankshaft drive gear by maintenance personnel, who failed to install all required hardware, resulting in an in-flight engine failure.NTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.NTSB ERA23LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna A185E · York, PAOil starvation of the number 1 connecting rod bearings, which resulted in a total loss of engine power.NTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB WPR23LA016Accident · No injuriesClass 3 · LimitedFinal reportQuickie Q2 · Laramie, WYThe partial loss of engine power due to the seizure of the No. 1 cylinder exhaust valve in the valve guide.NTSB 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 WPR22LA363Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Cedar City, UTA partial loss of engine power due to a damaged cylinder intake valve and subsequent collision with terrain during an autorotation.NTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.NTSB WPR22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172L · Ventura, CAA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve.NTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…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 ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.