Skip to content

NTSB investigations: Lycoming TVO-435-GIA, CO

22 cases on aircraft whose registry engine model is Lycoming TVO-435-GIA. 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

19672026

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" = 'CO' 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 ('41526')) 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\" = 'CO' 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 ('41526'))
  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" = 'CO' 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 ('41526'))
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 DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.Sep 12, 2007 · N360SS · Substantial damage NTSB FTW97LA319Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Montrose, COfailure of the flight instructor (CFI) to properly supervise the flight and ensure that adequate rotor rpm was maintainted during the autorotation/landing. The high density altitude was a related factor.Aug 19, 1997 · N2243W · Substantial damage NTSB FTW96TA383Accident · No injuriesFinal reportBell 47G-3B-1 · Rangely, COthe pilot's excessive cyclic control input during a low altitude operation, and his failure to maintain altitude/clearance from high vegetation (sage brush). The proximity of high vegetation was a related factor.Sep 10, 1996 · N1335X · Substantial damage NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.Jul 4, 1991 · N40DP · Substantial damage NTSB DEN88FA106Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Cortez, COThe plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft…May 7, 1988 · N8455E · Destroyed NTSB DEN86LA079Accident · Minor injuriesLimited investigationFinal reportBell 47G3 B-2 · Grand Junction, COThe plt stated that while turning to the intended landing area, the helicopter he was piloting encountered both downdrafts & tailwind. The plt indicated the helicopter settled until grnd contact.Feb 18, 1986 · N1424W · Substantial damage NTSB DEN83LA002Accident · No injuriesLimited investigationFinal reportBell 47G3B · Nr. Englewood, COPilot was practicing maneuvers for certification test. He said he made a precautionary landing due to suspected engine trouble and a fire started under the aircraft in the grass. He exited the aircraft but left battery and radio on. This investigation…Oct 5, 1982 · N204Z · Destroyed NTSB DEN81FTE51Accident · No injuriesClosedHiller UHI2D · Craig, COSep 8, 1981 · N96107 · Destroyed NTSB DEN77FTE47Accident · Minor injuriesClosedBell 47G3B1 · Wellington, COMay 24, 1977 · N1301X · Destroyed NTSB DEN77FTE31Accident · Serious injuriesClosedBell 47G3B2 · Greeley, COApr 8, 1977 · N665GD · Destroyed NTSB DEN77FTE18Accident · Minor injuriesClosedBell 47G3B1 · Cimmaron, COJan 24, 1977 · N1362X · Destroyed NTSB DEN76FTE94Accident · Serious injuriesClosedBell 47G3B2 · Aspen, COAug 24, 1976 · N4074G · Destroyed NTSB DEN76FTE18Accident · No injuriesClosedBell 47G3B1 · Denver, COAug 24, 1975 · N90769 · Substantial damage NTSB DEN75FTE54Accident · No injuriesClosedBell 47G3B1 · Montrose, COMar 4, 1975 · N1362X · Substantial damage NTSB DEN73FTE92Accident · No injuriesClosedBell 47G3B1 · Carbondale, COJun 9, 1973 · N1357X · Substantial damage NTSB DEN73AD015Accident · No injuriesClosedBell 47G3B1 · Hayden, COOct 3, 1972 · N1397X · Substantial damage NTSB DEN70D0097Accident · Minor injuriesClosedBell 47G3B2 · Breckenridge, COJul 17, 1969 · N4074G · Substantial damage NTSB DEN70F0008Accident · Serious injuriesClosedBell 47G3B1 · Broomfield, COJun 14, 1969 · N8541F · Substantial damage NTSB DEN69A0004Accident · Serious injuriesClosedBell 47G3B2 · Aspen, COJul 29, 1968 · N4074G · Substantial damage NTSB DEN68A0020Accident · Minor injuriesClosedBell 47G-3B · Silverthorne, COOct 12, 1967 · N1397X · Substantial damage NTSB DEN68A0006Accident · No injuriesClosedBell 47G3B1 · Leadville, COJul 22, 1967 · N1334X · Substantial damage NTSB DEN67A0049Accident · Serious injuriesClosedBell 47G3B1 · Estes Park, COMar 1, 1967 · N8541F · Destroyed