NTSB investigations: Lycoming TVO-435-GIA
16 cases on aircraft whose registry engine model is Lycoming TVO-435-GIA, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2005 | 2 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41526')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41526')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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.NTSB DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.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.NTSB ATL99LA105Accident · Minor injuriesLimited investigationFinal reportBell 47 · Trenton, GAThe loss of main rotor rpm due to improper use of the flight controls by the pilot. Factors were the tailwind and trees.NTSB SEA97LA158Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Roosevelt, UTthe pilot's failure to maintain directional control. Wind gusts were a factor.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…NTSB NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…NTSB MIA91LA217Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Penuelas, PRInadvertent control interference by a passenger shortly after takeoff resulting in the loss of control and roll over after touchdown.NTSB SEA89LA116Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2A · Dyer, NVThe pilots poor planning in attempting a hover in undesirable conditions which resulting in the inability to maintain rotor rom. Contributing to the accident was the mountainous terrain and high density alt.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…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.NTSB DEN86LA119Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Santa Fe, NMAccording to the student plt, he was attempting to hover the helicopter when he encountered turbulence. The student plt stated that the hard landing which followed resulted in spreading the skids & severing the tailboom.NTSB DEN85LA144Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat Mark 5A/OH13H · Freeman, SDThe plt said he had completed 4 to 5 swath runs (crop spraying mission). During a turning manuever with a left quatering tail wind, full left pedal,full pwr,the helicopter had a high sink rate until grd impact.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.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…NTSB DEN83LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G3B1 · Malta, MTThe pilot stated that he "was spraying the alfalfa field west to east" and that "there were tall cottonwood trees on three sides. A very sudden wind "came up" and "pushed" him into a tree.