NTSB investigations: Lycoming 0-435, OH

8 cases on aircraft whose registry engine model is Lycoming 0-435. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Lycoming 0-435, OH per year, 1964–2026: 8 cases
1964	1
1965	1
1966	1
1970	1
1973	1
1976	1
1980	1
1985	1

Where

Open the map

Latest cases

Query with SQL

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" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
  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" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41516'))
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 CHI85LA317Accident · No injuriesLimited investigationFinal reportStinson L-5 · Waynesville, OHThe plt took off on a test flt to check the eng after it had been inspected & the carburetor had been overhauled. He made a ground check & full eng run-up before taking off. Intending to stay in a closed traffic pattern, he took off, made a normal climb in…Jul 28, 1985 · N1156V · Substantial damage NTSB CHI80DEG15Accident · No injuriesClosedTomcat MK5A · Sinking Sp, OHMay 27, 1980 · N9096T · Substantial damage NTSB CHI76FEK20Accident · No injuriesClosedBellanca 14-19 · Cambridge, OHJul 2, 1976 · N6560N · Substantial damage NTSB CHI73FEG30Accident · No injuriesClosedStarduster SA-200 · New Carlisle, OHJun 30, 1973 · N1593 · Substantial damage NTSB CHI70FGA07Accident · Minor injuriesClosedStarduster TOO · Tremont City, OHApr 5, 1970 · N1593 · Substantial damage NTSB CHI67F0304Accident · No injuriesClosedStinson 108-1 · Columbus, OHOct 30, 1966 · N8389K · Substantial damage NTSB CHI65F0184Accident · No injuriesClosedStinson 108 · Delaware, OHMay 30, 1965 · N8389K · Substantial damage NTSB UNK65X0475Accident · No injuriesClosedBellanca 1419 · Centerburg, OHOct 29, 1964 · N6556N · Substantial damage