NTSB investigations: Lycoming VO-435 series, OH

11 cases on aircraft whose registry engine model is Lycoming VO-435 series. 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

19682026

NTSB investigations: Lycoming VO-435 series, OH per year, 1968–2026: 11 cases
1968	1
1969	1
1972	1
1974	1
1975	2
1978	1
1979	2
1982	1
1984	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 ('41525')) 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 ('41525'))
  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 ('41525'))
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 CHI84LA317Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Jeffersonville, OHThe acft started to settle with power during takeoff after the acft was loaded with chemicals. The plt said he had a choice of, going through a fence or over it and decided to go over it. Pulling collective bled off m/r and the acft stopped flying. The tail…Jul 29, 1984 · N59H · Substantial damage NTSB CHI82DA198Accident · Minor injuriesFinal reportBell 47G-5A · New Philadelphi, OHWhile patrolling a powerline, the pilot heard a loud noise, similar to a gunshot, which seemed to come from directly behind the firewall. Immediately after that, the helicopter started to pitch up and roll to the right. He reported that the helicopter reached…Jun 1, 1982 · N2988W · Destroyed NTSB CHI79FEI25Accident · Serious injuriesClosedBell 47G-2A · Carrollton, OHJun 3, 1979 · N7575 · Substantial damage NTSB CHI79DEG13Accident · Minor injuriesClosedBell 47G-2 · Piqua, OHMay 23, 1979 · N4423 · Substantial damage NTSB CHI78FEK27Accident · No injuriesClosedHiller UH12E · Findlay, OHAug 25, 1978 · N9759C · Substantial damage NTSB CHI75FEK32Accident · No injuriesClosedBell 47G2 · Paulding, OHJun 19, 1975 · N555D · Substantial damage NTSB CHI75FEI31Accident · Minor injuriesClosedK-Copter 47G-2 · Wakeman, OHFeb 1, 1975 · N7730 · Destroyed NTSB CHI75FEI01Accident · Minor injuriesClosedBell 47G-5 · Wauseon, OHJul 8, 1974 · N4041G · Substantial damage NTSB CHI73FEK07Accident · No injuriesClosedBell 47G-4 · Cambridge, OHOct 2, 1972 · N73979 · Substantial damage NTSB CHI70F0264Accident · No injuriesClosedBell 47G-2 · Gallipolis, OHSep 22, 1969 · N6776D · Destroyed NTSB CHI68A0070Accident · No injuriesClosedBell 47J · Harrison, OHFeb 9, 1968 · N2895B · Substantial damage