NTSB investigations, GA
14 cases where NTSB found Recip eng cyl section.
Cases per year
| 2009 | 2 |
|---|---|
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2023 | 1 |
| 2024 | 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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' 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 ERA24LA392Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · LaGrange, GAImproper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.NTSB ERA23LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150L · Elberton, GAThe pilot’s decision to take off with a known engine issue, which resulted in a partial loss of power on the initial climb due to the No. 1 cylinder’s exhaust valve becoming stuck. Contributing to the outcome, was the pilot’s delay in aborting the takeoff.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 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 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 ERA17LA015Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stockbridge, GAA partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA16LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Brunswick, GAMaintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder.NTSB ERA13LA126Accident · No injuriesLimited investigationFinal reportMccowan Steve A Shttd · Montrose, GAA total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.NTSB ERA13LA029Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Edison, GAThe total loss of engine power due to the fatigue failure of the k-pin associated with the No. 1 cylinder.NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB ERA11LA307Accident · No injuriesLimited investigationFinal reportFlightstar Flightstar II · Grantville, GAA total loss of engine power while maneuvering due to a seized piston.NTSB ERA09LA510Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampi · Milner, GAThe failure of the No. 3 cylinder exhaust valve for undetermined reasons.NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.