Fatal NTSB investigations: Lycoming TVO-435-GIA

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

19642026

Fatal NTSB investigations: Lycoming TVO-435-GIA per year, 1964–2026: 20 cases
1964	1
1966	1
1968	1
1969	2
1970	1
1972	1
1973	1
1974	1
1976	1
1979	2
1980	1
1983	1
1986	1
1988	1
1989	1
1998	1
2000	1
2013	1

Where

Open the map

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 CEN13FA357Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Maplewood, MNThe loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.Jun 19, 2013 · N5024N · Destroyed 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 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 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 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 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 ATL84FA001Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Pliny, WVThe helicopter was being used in the construction of elect transmission lines. A 150-FT longline cable had been utilizedon an earlier flight for lifting external loads. However, there was no reason for the longline to be attached on the accident flight as the…Oct 1, 1983 · N1334X · Destroyed NTSB SEA80FA018Accident · 2 fatalClosedBell 47G3B1 · Jefferson, ORJan 30, 1980 · N73285 · Destroyed NTSB DEN80FA005Accident · 1 fatalClosedSoloy 47G · Ruidoso, NMOct 23, 1979 · N7828S · Destroyed NTSB DEN79FA065Accident · 1 fatalClosedBell 47G · Deming, NMSep 20, 1979 · N2220W · Destroyed NTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNov 6, 1976 · N6755D · Destroyed NTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTSep 5, 1974 · N73972 · Destroyed NTSB DEN73AD055Accident · 1 fatalClosedBell 4G3B2A · Luna, NMJun 19, 1973 · N83111 · Substantial damage NTSB SEA73FYG13Accident · 1 fatalClosedBell 47-G2A · Selah, WASep 23, 1972 · N73284 · Substantial damage NTSB LAX71AL033Accident · 1 fatalClosedBell 47G3B1 · Rim Forest, CADec 1, 1970 · N1126W · Destroyed NTSB LAX70A0008Accident · 3 fatalClosedBell 47G3B1 · Grnd Canyon, AZJul 30, 1969 · N73909 · Destroyed NTSB CAN70A4457Accident · 3 fatalClosedSchweizer SGS126 · Hope, CanadaJul 26, 1969 · CF-VEQ · 2 aircraft · Destroyed NTSB SEA69A0008Accident · 1 fatalClosedBell 47G3B1 · North Fork, IDJul 23, 1968 · N8537F · Destroyed NTSB DEN66A0074Accident · 1 fatalClosedBell 47G-3B · Grand Canyon, AZApr 12, 1966 · N73909 · Destroyed NTSB UNK64X0473Accident · 1 fatalClosedBell 47G3B1 · Little Nway, CAFeb 5, 1964 · N73909 · Destroyed