NTSB investigations, OK

6 cases where NTSB found Recip eng cyl section.

Cases per year

20152026
NTSB investigations, OK per year, 2015–2026: 6 cases
20151
20191
20211
20221
20231
20241

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\" = 'OK' 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.

NTSB CEN24LA317Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Guthrie, OKA loss of engine power due to the separation and ingestion of an air filter retaining bracket into the engine cylinder.Aug 15, 2024 · N184DC · Substantial damageNTSB CEN23LA370Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Durant, OKThe loosening of a connecting rod cap nut for reasons that could not be determined, which resulted in a mechanical failure of the engine and an in-flight fire.Aug 21, 2023 · N3589X · Substantial damageNTSB CEN22LA315Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 650B · Eufaula, OKThe loss of engine power due to a push rod that was incorrectly installed by the airplane owner.Jul 12, 2022 · N452VC · Substantial damageNTSB CEN21LA408Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Heavener, OKA total loss of engine power due to the failure of the No. 2 cylinder exhaust valve for reasons that could not be determined.Aug 15, 2021 · N50055 · Substantial damageNTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.Jul 22, 2019 · N8251L · Substantial damageNTSB CEN15LA238Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Omega, OKImproper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.May 11, 2015 · N7279Z · Substantial damage