Skip to content

NTSB investigations: Lycoming VO-435 series, AR

17 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

19702026

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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CHI03FA277Accident · Serious injuriesField investigationFinal reportBell TH-13T · Light, ARThe total failure and seizure of the main rotor transmission while in cruise flight leading to the helicopter’s impact with terrain.Aug 21, 2003 · N38CD · Substantial damage NTSB FTW02LA264Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Edmondson, ARThe pilot's failure to maintain clearance from the high voltage power lines.Sep 25, 2002 · N5193B · Destroyed NTSB FTW97LA264Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Crossett, ARfailure of maintenance personnel to perform an adequate inspection of the fuselage center frame and detect a fatigue fracture of a longeron tube on the upper left side of the center frame, which resulted in a disconnect of the tail rotor drive shaft from the…Jul 13, 1997 · N83701 · Substantial damage NTSB FTW95LA310Accident · Serious injuriesLimited investigationFinal reportWilliams Bell OH13H/Tomcat MK5A · Alicia, ARThe pilot's failure to remove the refueling hose. A factor was that he diverted his attention from the refueling operation.Jul 21, 1995 · N3771W · Substantial damage NTSB FTW93LA178Accident · No injuriesLimited investigationFinal reportBell-Transworld 47G-2 · Wynne, ARPartial power loss due to the failure of one magneto. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1993 · N9238Z · Substantial damage NTSB FTW92DPG15Accident · No injuriesFinal reportBell-Transworld 47G-2 · Birdeye, ARFuel contamination. A factor was the high density altitude.Aug 19, 1992 · N9238Z · Substantial damage NTSB FTW91LA091Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Peach Orchard, ARThe pilot's failure to maintain adequate main rotor RPM resulting in deteriorated helicopter performance. A factor was the tailwind condition.Jun 5, 1991 · N8117 · Substantial damage NTSB MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.Jul 12, 1990 · N8117 · Substantial damage NTSB MKC88LA092Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mc Dougal, ARThe pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades…May 19, 1988 · N4690 · Substantial damage NTSB FTW79DPG55Accident · No injuriesClosedBell 47G-2 · Earle, ARJun 19, 1979 · N3550 · Substantial damage NTSB FTW78DPG32Accident · No injuriesClosedBell OH-13E · Fisher, ARMay 22, 1978 · N38113 · Substantial damage NTSB FTW77FPG86Accident · No injuriesClosedBell 47G2H1 · Mountain View, ARSep 19, 1977 · N38926 · Destroyed NTSB FTW76FPG82Accident · Serious injuriesClosedQuinn MK-5A · Corning, ARJul 10, 1976 · N8429 · Destroyed NTSB FTW75DPG68Accident · Minor injuriesClosedBell 47G-2 · Denmark, ARMay 26, 1975 · N38926 · Substantial damage NTSB FTW74FPG26Accident · No injuriesClosedBell 47G2A1 · Little Rock, ARSep 29, 1973 · N73970 · Substantial damage NTSB FTW74FPG23Accident · Serious injuriesClosedBell 47G2 · Viola, ARSep 18, 1973 · N2870B · Substantial damage NTSB FTW71DPG02Accident · No injuriesClosedBell 47G-2 · Norfork, ARJul 30, 1970 · N6744D · Substantial damage