NTSB investigations, 2016
18 cases where NTSB found Recip engine power section.
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 16 |
| 2010 | 12 |
| 2011 | 7 |
| 2012 | 13 |
| 2013 | 18 |
| 2014 | 9 |
| 2015 | 20 |
| 2016 | 18 |
| 2017 | 11 |
| 2018 | 16 |
| 2019 | 14 |
| 2020 | 12 |
| 2021 | 12 |
| 2022 | 11 |
| 2023 | 14 |
| 2024 | 11 |
| 2025 | 1 |
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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01058520'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01058520')) 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 ERA17LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Shoreham, NYA fatigue crack of the crankshaft at the No. 4 main bearing journal.NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.NTSB ERA17LA037Accident · No injuriesLimited investigationFinal reportAviat A 1B · Geneva, FLA partial loss of engine power due to debris in the No. 1 cylinder that damaged the spark plugs.NTSB WPR17LA012Accident · Minor injuriesLimited investigationFinal reportNorthland IVP · Lovelock, NVA total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information.NTSB CEN17LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Clarendon, TXThe failure of a cylinder piston pin, which resulted in an obstructed oil inlet screen, reduced the amount of oil available to the engine, and led to the subsequent loss of engine power. Contributing to the accident was the failure of the nonmechanic, who had…NTSB CEN16LA391Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cloquet, MNA lack of lubrication in the engine for reasons that could not be determined based on the available information, which resulted in a failure of the No. 4 connecting rod and a subsequent total loss of engine power.NTSB ERA16LA319Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Chestertown, MDLoss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment.NTSB ERA16LA272Accident · No injuriesLimited investigationFinal reportHarrity William V Glasair (SH2F) · Maynardville, TNThe in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination.NTSB ERA16LA235Accident · No injuriesLimited investigationFinal reportCessna 150 · Peachtree City, GAThe fatigue failure of the No. 3 cylinder exhaust valve, which resulted in a total loss of engine power at low altitude after takeoff.NTSB ERA16LA220Accident · No injuriesClass 3 · LimitedFinal reportChampion 7AC · Gorham, NHThe partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s failure to abort the takeoff after the airplane’s initial failure to climb.NTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.NTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…NTSB ERA16LA124Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hauppauge, NYThe total loss of engine power, which resulted from the failure of the camshaft gear due to fatigue. Contributing to the accident was the owner/operator's failure to comply with the engine manufacturer's recommended overhaul interval.NTSB CEN16LA118Accident · No injuriesLimited investigationFinal reportCessna 150G · Simmesport, LAThe installation of an improper bearing and thrust washer during engine overhaul, which resulted in failure of the connecting rods and a subsequent total loss of engine power.NTSB ERA16LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Gainesville, FLThe failure of the engine crankshaft near the Nos. 4 and 5 crankshaft journals due to oil starvation. The reason for the oil starvation could not be determined during postaccident examination.NTSB CEN16LA107Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Bryan, TXA failure of the crankshaft due to improper torque of the crankcase through bolts.NTSB WPR16LA047Accident · No injuriesLimited investigationFinal reportKevin Metzler Velocity STD RG · Rosamond, CAA partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.