Skip to content

NTSB investigations: Lycoming VO-435 series, PA

18 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

19662026

Where

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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.Apr 20, 2016 · N202CH · Substantial damage NTSB ERA09CA542Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Quarryville, PAAn untrained bystander's attempt to marshal the helicopter, which resulted in the helicopter's inadvertent encounter with an object.Sep 26, 2009 · N233JA · Substantial damage NTSB NYC06FA100Accident · 2 fatalField investigationFinal reportBell 47G-3B-1 · East Hanover Tw, PAThe pilot's improper decision to hover out-of-ground-effect in a tailwind, and his failure to maintain aircraft control. A factor in the accident was the tailwind.Apr 20, 2006 · N22MP · Destroyed NTSB NYC01LA130Accident · No injuriesLimited investigationFinal reportContinental Copters Tom Cat Mark 5A · Benton, PAThe pilot's inadequate preflight inspection, which resulted in a takeoff with a hose still attached and a subsequent dynamic rollover.May 29, 2001 · N25561 · Substantial damage NTSB NYC86FGM02Accident · Minor injuriesFinal reportContinental Copters OH13H Tomcat Mark 5A · Indiana, PAThe acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off…May 10, 1986 · N41830 · Substantial damage NTSB NYC84FGT02Accident · No injuriesFinal reportBell 47G-3 · Landisburg, PAThe helicopter lost eng power while turning on approach for landing, autorotated to a hard landing with main rotor contact to the tail boom. Two gals of fuel were drained from the acft fuel tank at the accident site. An eng run up was performed & found…Jun 4, 1984 · N49882 · Substantial damage NTSB NYC83FA106Accident · 2 fatalField investigationFinal reportBell 47G-2 · Waymart, PAThis was an introductory instructional flt. Witnesses observed the helicopter flying straight & level prior to the accident. The helicopter had impacted a 60-FT tree at about the 40-FT level. No preimpact failure/falfunction of either the airframe or engine…Apr 30, 1983 · N2829B · Destroyed NTSB NYC81FGM30Accident · Minor injuriesClosedBell 47G-2A · Hollidaysburg, PASep 7, 1981 · N7764 · Destroyed NTSB NYC79FHA15Accident · Serious injuriesClosedBell 47G-2 · Waupwallopen, PAJun 16, 1979 · N2884B · Substantial damage NTSB NYC79DHA13Accident · Serious injuriesClosedBell 47G · Weatherly, PAMay 6, 1979 · N73979 · Substantial damage NTSB NYC78FGT07Accident · Minor injuriesClosedBell 47G-2 · Warriors Mark, PAMay 22, 1978 · N64589 · Substantial damage NTSB NYC75FGM04Accident · No injuriesClosedBell 47G-5 · Sligo, PAAug 1, 1974 · N6277N · Substantial damage NTSB NYC69A0105Accident · 1 fatalClosedBell 47D1 · Gettysburg, PAMay 25, 1969 · N6598D · Destroyed NTSB NYC68F0500Accident · Minor injuriesClosedBell 47D-1 · Bangor, PAJun 4, 1968 · N6598D · Destroyed NTSB NYC68A0044Accident · No injuriesClosedBell 47G-2 · Shippensburg, PASep 15, 1967 · N866Z · Substantial damage NTSB NYC67A0187Accident · No injuriesClosedBell 47G-2 · Bedford, PAJun 24, 1967 · N6749D · Substantial damage NTSB NYC67A0016Accident · No injuriesClosedBell 47G2A1 · St.Marys, PAJul 19, 1966 · N73983 · Substantial damage NTSB NYC66A0155Accident · No injuriesClosedBell 47G2A1 · New Bethlehem, PAJun 21, 1966 · N73983 · Substantial damage