Skip to content

NTSB investigations: Lycoming TVO-435-GIA, UT

17 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

19652026

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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 DEN99LA168Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Tremonton, UTThe pilot's failure to maintain rotor rpm while attempting a precautionary autorotation landing. A factor was the loss of engine power for undetermined reasons.Sep 23, 1999 · N83246 · Substantial damage NTSB FTW98GA097Accident · 1 fatalFinal reportBell 47G-3B-2 · Spanish Fork, UTA total loss of power due to repeated engine overspeeds. A related factor was unsuitable terrain.Jan 14, 1998 · N1461W · Substantial damage NTSB SEA97LA158Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Roosevelt, UTthe pilot's failure to maintain directional control. Wind gusts were a factor.Jul 5, 1997 · N8537F · Substantial damage NTSB DEN87LA235Accident · No injuriesLimited investigationFinal reportBell 47-G3B2 · Oakley, UTThe plt had just taken off from a confined area surrounded on two sides with electrical power lines. As he attempted to climb, he said his RPM began to bleed off. He stated that he made a right pedal turn to avoid the wires but was unable to prevent a hard…Sep 10, 1987 · N1038X · Substantial damage NTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…May 8, 1987 · N58131 · Substantial damage NTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…Nov 10, 1986 · N47042 · Substantial damage NTSB DEN84LA079Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Ogden, UTThe plt took off from a mountainous work site to return to salt lake city, UT. The wx was clear at the work site (elevation 6700 ft), but there was fog below. After encountering the fog, the plt hovered with a slow forward speed over snow covered terrain. A…Jan 31, 1984 · N90769 · Substantial damage NTSB DEN80DTM36Accident · Serious injuriesClosedHiller Acft UH-12D · Coalville, UTAug 8, 1980 · N31332 · Substantial damage NTSB DEN80DTM01Accident · No injuriesClosedBell 47G3B1 · Torrey, UTOct 1, 1979 · N8537F · Substantial damage NTSB DEN79DTM24Accident · No injuriesClosedBell 47G3B1 · Beaver, UTSep 16, 1979 · N512YP · Substantial damage NTSB DEN75ATM08Accident · No injuriesClosedBell 47G-3B · Kamas, UTDec 16, 1974 · N73218 · Substantial damage NTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTSep 5, 1974 · N73972 · Destroyed NTSB DEN73DTM30Accident · Minor injuriesClosedBell 47G3B1 · Magna, UTJun 12, 1973 · N8532F · Destroyed NTSB DEN73AD039Accident · No injuriesClosedBell 47G3B1 · Salt Lake City, UTFeb 21, 1973 · N73972 · Substantial damage NTSB DEN72AD011Accident · No injuriesClosedBell 47G3B1 · Sandy, UTSep 13, 1971 · N73972 · Substantial damage NTSB DEN69D0043Accident · No injuriesClosedBell 47G3B1 · Loa, UTJun 22, 1968 · N1357X · Substantial damage NTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTOct 5, 1965 · N8537F · Destroyed