Skip to content

NTSB investigations: Lycoming TVO-435-GIA, WA

26 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

19642026

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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.Jun 19, 2005 · N8554F · Substantial damage NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…Apr 2, 2000 · N3377H · Destroyed NTSB SEA98LA069Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Stanwood, WAThe failure of the number two connecting rod, which led to additional internal engine damage and a complete loss of power. Factors include soft terrain in the area where the pilot found it necessary to execute his forced landing.May 3, 1998 · N7965J · Substantial damage NTSB SEA97LA112Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Snohomish, WAthe pilot's encounter with of a loss of tail rotor effectiveness (LTE) situation, and his subsequent inadequate remedial action. Related factors included: wind conditions that were conducive to an unanticipated right yaw event, and the pilot's limited…May 15, 1997 · N8491E · Substantial damage NTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.Nov 15, 1993 · N1181W · Substantial damage NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.May 19, 1991 · N73903 · Destroyed NTSB SEA90LA048Accident · Minor injuriesLimited investigationFinal reportBell BH-47G3B2 · Des Moines, WAPartial loss of engine power, cause undetermined. The aircraft was not recovered and examination of the engine was not possible.Mar 1, 1990 · N4073G · Destroyed NTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.Sep 18, 1989 · N83111 · Destroyed NTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.Jul 23, 1986 · N1197W · Minor damage NTSB SEA81DYP21Accident · Serious injuriesClosedBell 47G3B2 · Walla Walla, WAJun 11, 1981 · N14827 · Substantial damage NTSB SEA80FYP34Accident · No injuriesClosedBell 47G-2 · Sunnyside, WAAug 23, 1980 · N73284 · Substantial damage NTSB SEA79DYP14Accident · No injuriesClosedBell 47G-3B · Wenatchee, WAApr 26, 1979 · N6712D · Substantial damage NTSB SEA77FYP29Accident · No injuriesClosedBell 47G3B1 · Pomeroy, WAApr 26, 1977 · N73919 · Substantial damage NTSB SEA76DYG74Accident · No injuriesClosedBell 47G-3B · Cashmere, WASep 15, 1976 · N6712D · Substantial damage NTSB SEA76DYE41Accident · Minor injuriesClosedBell 47G-3B · Forks, WAMay 12, 1976 · N3794G · Substantial damage NTSB SEA76FYG50Accident · No injuriesClosedBell 47G-3B · Spokane, WAMay 10, 1976 · N58131 · Substantial damage NTSB SEA75DYG12Accident · No injuriesClosedBell 47G-2 · Ruff, WASep 11, 1974 · N3794G · Substantial damage NTSB SEA73FYG13Accident · 1 fatalClosedBell 47-G2A · Selah, WASep 23, 1972 · N73284 · Substantial damage NTSB SEA72DYG40Accident · No injuriesClosedBell 47G2 · Moses Lake, WAMay 26, 1972 · N6712D · Destroyed NTSB SEA71FWG15Accident · Minor injuriesClosedBell 47G3B1 · Colville, WASep 2, 1970 · N3097G · Substantial damage NTSB SEA69D0183Accident · No injuriesClosedBell 47G-2 · Chelan, WAFeb 14, 1969 · N6712D · Substantial damage NTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WAOct 11, 1967 · N1321X · Substantial damage NTSB SEA68A0007Accident · No injuriesClosedBell 47G-2 · Palisades, WAJul 17, 1967 · N3794G · Substantial damage NTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WAJan 4, 1967 · N73919 · Substantial damage NTSB SEA65A0059Accident · Minor injuriesClosedBell 47G3B1 · Marblemount, WAApr 28, 1965 · N68645 · Substantial damage NTSB UNK64X3780Accident · No injuriesClosedBell 47G2 · Manson, WASep 4, 1964 · N3794G · Substantial damage