Skip to content

NTSB investigations: Lycoming TVO-435-GIA, OR

20 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

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.Jun 23, 2004 · N73909 · Substantial damage NTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.Sep 12, 2003 · N48020 · Substantial damage NTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.Jul 4, 2000 · N30DP · Substantial damage NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.Jun 10, 1999 · N24MP · Substantial damage NTSB SEA94LA065Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Gold Hill, ORSeparation of the crossover fuel line, and the inability of the pilot in command to maintain a proper rate of descent during the autorotation.Feb 24, 1994 · N73909 · Destroyed NTSB SEA87LA118Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Milton-Freewatr, ORThe pilot was hovering up rising terrain at a slow airspeed, at 15 feet above the ground while on an agricultural spraying flight and encountered settling with power. The aircraft entered an uncontrolled descent and impacted the ground.Jun 12, 1987 · N2219W · Destroyed NTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…Jul 29, 1986 · N9417A · Substantial damage NTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…Apr 15, 1986 · N9417A · Substantial damage NTSB SEA85LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Lebanon, ORThe plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor.Jul 19, 1985 · N9417A · Substantial damage NTSB SEA84LA162Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Eagle Point, ORThe acft main rotor struck the ground during landing. The commercial plt had taken 2 passengers for a sight seeing tour and during landing he said one of them grabbed his right arm at 4 ft AGL and he was unable to recover before ground contact.Jul 5, 1984 · N73224 · Substantial damage NTSB SEA81DYM48Accident · No injuriesClosedBell 47G3B1 · Albany, ORSep 30, 1981 · N2243W · Substantial damage NTSB SEA80DYM29Accident · No injuriesClosedBell 47G-3B · Albany, ORMar 28, 1980 · N2243W · Substantial damage NTSB SEA80FA018Accident · 2 fatalClosedBell 47G3B1 · Jefferson, ORJan 30, 1980 · N73285 · Destroyed NTSB SEA78FYM25Accident · No injuriesClosedBell 47G · Kings Valley, ORApr 15, 1978 · N2919W · Substantial damage NTSB SEA78DYK11Accident · No injuriesClosedBell 47G3B1 · Myrtle Creek, ORMar 6, 1978 · N73984 · Substantial damage NTSB SEA78FYM14Accident · Serious injuriesClosedBell 47G3B2 · Milton-Freewtr, ORJan 4, 1978 · N2906W · Substantial damage NTSB SEA78FYM02Accident · Minor injuriesClosedBell 47G3B1 · Alsea, OROct 2, 1977 · N1199W · Substantial damage NTSB SEA71DVQ22Accident · No injuriesClosedBell 47G3B · Days Creek, ORApr 7, 1971 · N8455E · Substantial damage NTSB SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORDec 21, 1970 · N73284 · Substantial damage NTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damage