NTSB investigations, 2017
23 cases where NTSB found Recip eng cyl section.
Cases per year
| 2008 | 16 |
|---|---|
| 2009 | 23 |
| 2010 | 25 |
| 2011 | 28 |
| 2012 | 24 |
| 2013 | 23 |
| 2014 | 23 |
| 2015 | 21 |
| 2016 | 23 |
| 2017 | 23 |
| 2018 | 24 |
| 2019 | 18 |
| 2020 | 21 |
| 2021 | 12 |
| 2022 | 30 |
| 2023 | 17 |
| 2024 | 19 |
| 2025 | 3 |
Where
Latest cases
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01058530'))
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 year(c."eventDate") = 2017 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01058530')) 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 CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB WPR18LA051Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Hinesville, GAA total loss of engine power due to the failure of a connecting rod.NTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…NTSB ERA18LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Ebensburg, PAThe pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB ERA18LA007Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Centre Hall, PAThe partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.NTSB ERA17LA335Accident · Minor injuriesClass 3 · LimitedFinal reportBrad J Bates Mosquito XE 285 · Odessa, FLA total loss of engine power due to cold seizure of the No.1 piston, which resulted in its failure and a subsequent emergency autorotation and impact with a house’s roof.NTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.NTSB CEN17FA331Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Ellabell, GAThe total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…NTSB CEN17LA330Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Pearsall, TXThe fatigue crack of an engine cylinder, which resulted in a partial loss of engine power.NTSB ERA17LA284Accident · No injuriesLimited investigationFinal reportMooney M20C · Palm Coast, FLA crack in the No. 4 cylinder head, which resulted in engine roughness, a fuel leak, a loss of engine power, and the subsequent in-flight fire.NTSB CEN17LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Beckville, TXA stuck exhaust valve, which resulted in the failure of the valve and a loss of engine power. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…NTSB ERA17LA257Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Myrtle Beach, SCA loss of available power to the main rotor due to a fractured exhaust pushrod and housing, which allowed engine oil to coat the V-belts. Contributing to the accident was the pilot's decision to continue the tour and his failure to maintain adequate rotor rpm…NTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.NTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ERA17LA182Accident · Minor injuriesLimited investigationFinal reportStinson 108 · West Creek, NJA total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.NTSB ERA17LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Homerville, GAA total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.NTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.NTSB CEN17LA163Accident · No injuriesLimited investigationFinal reportGrumman Schweizer G-164 · Palmer, KSA crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.NTSB ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.NTSB WPR17LA048Accident · No injuriesLimited investigationFinal reportSchosanski John H Cozy MK IV R · Napa, CAA partial loss of power due to missing apex seals.