NTSB investigations, SC
10 cases where NTSB found Recip eng cyl section.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
Where
Open the mapLatest 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\" = 'SC' 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" = 'SC' 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 ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.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 ERA19LA143Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Edgefield, SCThe total loss of engine power due to a stuck engine exhaust valve. Contributing to the loss of engine power was the pilot’s failure to properly address the recurring stuck exhaust valve issue.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 ERA12LA473Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Pickens, SCA total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.NTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB NYC08LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCA loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.