NTSB investigations, WA
12 cases where NTSB found Recip eng cyl section.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2023 | 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\" = 'WA' 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" = 'WA' 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 WPR23LA196Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172H · Seattle, WAA stuck exhaust valve that resulted in a partial loss of engine power and a forced water ditching.NTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.NTSB WPR19LA226Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177RG · Fall City, WAThe failure of the No. 3 cylinder intake valve that resulted in a partial loss of engine power and a forced landing on uneven terrain.NTSB WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.NTSB WPR18LA098Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon A36 · Enumclaw, WAA total loss of engine power due to oil starvation as a result of a loose oil line B-nut.NTSB WPR15LA023Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Basin City, WAMaintenance personnel’s and the airplane owner’s failure to inspect the engine for cracks in the cylinders as required by an airworthiness directive, which resulted in the loss of engine power during low-altitude maneuvering flight.NTSB WPR14LA284Accident · No injuriesLimited investigationFinal reportGlobe GC 1B · Puyallup, WAThe failure of the exhaust assembly in the No. 3 cylinder for reasons that could not be determined due to the damage incurred to the fractured parts. Also causal to the accident was maintenance personnel’s improper installation of the cylinder.NTSB WPR12LA356Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe loss of engine power due to the separation of the No. 2 cylinder exhaust rocker boss housing, which prevented the exhaust valve from opening.NTSB WPR11LA391Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cowiche, WAA partial loss of engine power during maneuvering flight due to an exhaust valve failure.NTSB WPR11LA340Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lopez, WAA partial loss of engine power due to a cracked engine case near the rear cylinder.NTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.