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 WPR21LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Show Low, AZA partial loss of engine power due to the failure of the No. 4 cylinder exhaust valve.NTSB CEN21LA031Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Buda, TXAn improperly torqued oil line fitting during an engine overhaul, which resulted in oil exhaustion and a total loss of engine power.NTSB CEN21FA024Accident · 1 fatalClass 3 · FieldFinal reportGlasair III · Ford Heights, ILThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21LA008Accident · No injuriesClass 3 · LimitedFinal reportExperimental Quad City Challenger II · Northfield, NHA total loss of engine power due to oil starvation of the No. 1 cylinder. Contributing to the accident was the pinched No. 1 cylinder oil injection line.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Moosic, PAThe inadequate torquing of anchored-thru and free-thru studs during installation of the No. 2 cylinder, resulting in their fatigue fracture and subsequent total loss of engine power. Contributing to the undershoot landing was the pilot’s failure to divert to…NTSB ERA20LA327Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · Weston, FLA total loss of engine power because of the overheating and failure of the connecting rod bearings due to a lack of lubrication for reasons that could not be determined.NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB ERA20LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Weston, FLA total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.NTSB CEN20LA364Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Ogallala, NEThe total loss of engine power due to a failure of the master connecting rod.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB ERA20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportJust JA 30 Superstol · Clover, SCThe separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.NTSB CEN20LA338Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · Sugar Land, TXA total loss of engine power after takeoff for undetermined reasons, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB WPR20LA258Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Hanna, UTThe pilot’s failure to maintain sufficient airspeed after a partial loss of power for undetermined reasons, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall from which the pilot could not recover.NTSB ERA20LA277Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · St. Agatha, METhe failure of the crankshaft gear alignment dowel due to fatigue crack propagation and overstress, which resulted in a partial loss of engine power.NTSB WPR20LA239Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV7 · Henefer, UTThe total loss of engine power due to the separation of the idler gear shaft bolts as a result of improper installation, which allowed for the idler gear to become disengaged.NTSB WPR20LA225Accident · No injuriesClass 3 · LimitedFinal reportVans RV 8 · Grimes, CAA partial loss of engine power for reasons that could not be determined because the airplane was not examined.NTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.NTSB WPR20LA212Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Lake Tahoe, CAThe partial loss of engine power due to carbon buildup in the No. 4 cylinder resulting from the pilot’s inadequate mixture-leaning procedures.NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA262Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F35 · Ravenna, TXElectrical and engine problems for reasons that could not be determined based on available evidence.NTSB CEN20LA260Accident · No injuriesClass 3 · LimitedFinal reportChampion 7EC · Port O'Conner, TXThe loss of engine power due to a stuck intake valve.NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.NTSB WPR20LA193Accident · Serious injuriesClass 3 · LimitedFinal reportThatcher CX4 · Upland, CAThe inflight separation of the propeller assembly due to a fatigue fracture of the crankshaft. Contributing to the accident was the pilot’s restricted visibility during landing, which resulted in an excessive approach speed, a long landing, and subsequent…NTSB WPR20LA191Accident · 1 fatalClass 3 · LimitedFinal reportEnstrom 280 · Hayden, IDThe total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.NTSB CEN20LA228Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 24 · Livingston, TXThe total loss of engine power due to the failure of the No. 3 cylinder for reasons that could not be determined based on available evidence.NTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.NTSB CEN20LA219Accident · 1 fatalClass 3 · LimitedFinal reportFlight Design Ctls · Beecher, ILThe pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…NTSB CEN20LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 23 · Cleburne, TXThe total loss of engine power due to metal fatigue failure of the No. 1 cylinder wall.NTSB ERA20LA195Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · South Boston, VAThe powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.NTSB CEN20LA189Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Steele, MOThe loss of oil pressure for a reason that could not be determined leading to failure of the engine connecting rod.NTSB WPR20LA133Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Lodi, CAThe fatigue failure of the no. 4 cylinder connecting rod, which resulted in a total loss of engine power.NTSB WPR20LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Angostura, NMThe pilots precautionary off airport landing due to an undetermined engine issue.NTSB CEN20LA145Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sidney, IAA loss of engine power for reasons that could not be determined.NTSB CEN20LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Seguin, TXThe pilot’s mismanagement of airspeed and glidepath during approach for a precautionary landing, which resulted in a runway excursion and a collision with a fence.NTSB CEN20LA123Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Baxterville, MSThe failure of the No. 1 cylinder intake valve due to inadequate valve seating.NTSB ERA20LA126Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Beverly, MAA loss of engine power due to carburetor icing, and the student pilot’s failure to utilize carburetor heat in conditions conducive to carburetor icing.NTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.NTSB WPR20LA097Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Baker City, ORThe failure of the No. 2 connecting rod bearing as a result of oil starvation due to a contaminated oil filter screen.NTSB WPR20FA077Accident · 2 fatalClass 3 · FieldFinal reportStinson V77 · Auburn, CAA total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies.NTSB WPR20FA057Accident · 1 fatalClass 3 · FieldFinal reportThunder Mustang TM-1 · Santa Clarita, CAEngine detonation that resulted in material deformation of the crankcase and led to engine failure and restricted cockpit visibility.NTSB CEN20LA055Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 100 · Mullin, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA20LA064Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Kenansville, NCA fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.NTSB CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.NTSB ERA20LA062Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Fletcher, NCA failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.NTSB WPR20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Carlsbad, CAThe fatigue failure of the crankshaft. Contributing to the accident was the undocumented installation of the supercharger, which resulted in increased stress on the crankshaft.