Skip to content

NTSB investigations: Lycoming VO-540 series, TX

22 cases on aircraft whose registry engine model is Lycoming VO-540 series. 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" = 'TX' 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 ('41534', '41582')) 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\" = 'TX' 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 ('41534', '41582'))
  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" = 'TX' 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 ('41534', '41582'))
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 DEN08LA071Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · La Porte, TXThe loss of tail rotor effectiveness. Contributing factors were the sudden windshift to a tailwind, and the pilot initiating a hovering turn in ground effect.Apr 4, 2008 · N40289 · Substantial damage NTSB DFW06CA013Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Pasadena, TXThe pilot's inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.Oct 23, 2005 · N909BC · Substantial damage NTSB FTW04LA198Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · La Porte, TXThe loss of engine power for undetermined reasons.Aug 1, 2004 · N7892B · Destroyed NTSB FTW03CA146Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Robinson, TXThe pilot's failure to maintain clearance with the ground while performing a quick stop maneuver which resulted in a dynamic rollover.May 12, 2003 · N4205D · Substantial damage NTSB FTW96LA005Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Edinburg, TXthe pilot's improper takeoff planning which resulted in the loss of conrol. A factor was the gusty crosswind condition.Oct 3, 1995 · N6SR · Substantial damage NTSB FTW95LA105Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · El Indio, TXThe loss of tail rotor effectiveness. A factor was the gusty right quartering tailwind.Feb 1, 1995 · N6SR · Destroyed NTSB FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.Oct 11, 1991 · N4029D · Substantial damage NTSB FTW91LA064Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Corpus Christi, TXThe initial restricted movement and eventual locking of the cyclic control as a result of the failure of the lateral servo. A factor was the installation of the failed component by an unqualified person.Apr 27, 1991 · N1195W · Destroyed NTSB FTW88DRA05Accident · No injuriesFinal reportHiller UH-12E · La Salle, TXAcft was substantially damaged during an emergency autorotation following an engine failure while the acft was completing an aerial application maneuver. Acft touched down tail low and the main rotor blades flexed down and cut off the tail boom. Investigation…Apr 4, 1988 · N4029D · Substantial damage NTSB FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.Sep 13, 1986 · N40268 · Substantial damage NTSB FTW82DRG16Accident · No injuriesClosedBell 47G-4A · Encinal, TXDec 9, 1981 · N8573F · Substantial damage NTSB FTW82DRG07Accident · No injuriesClosedBell 47G-4A · Telegraph, TXNov 2, 1981 · N62446 · Substantial damage NTSB FTW79FRG52Accident · No injuriesClosedBell 47G-4A · Alice, TXAug 24, 1979 · N8573F · Substantial damage NTSB FTW79FRA34Accident · No injuriesClosedBell 47G-4 · Manvel, TXJun 29, 1979 · N1150W · Substantial damage NTSB FTW79DRA20Accident · No injuriesClosedBell 47-G4 · Alvin, TXApr 24, 1979 · N1150W · Minor damage NTSB FTW79FQG05Accident · No injuriesClosedHiller UH-12E · Stratford, TXOct 19, 1978 · N4026S · Substantial damage NTSB FTW74FRG55Accident · No injuriesClosedBell 47G3B1 · Corpus Chrsti, TXJan 25, 1974 · N11HV · Substantial damage NTSB FTW73DQG40Accident · No injuriesClosedBell 47G-4A · Borger, TXMay 25, 1973 · N4062G · Substantial damage NTSB FTW68A0084Accident · 1 fatalClosedBrantly 305 · Orange, TXMar 30, 1968 · N2212U · Destroyed NTSB FTW67A0056Accident · No injuriesClosedHiller UH-12L · Woodville, TXNov 19, 1966 · N9780C · Substantial damage NTSB FTW66A0056Accident · No injuriesClosedBell 47J-2 · Refugio, TXDec 9, 1965 · N73902 · Substantial damage NTSB UNK64X2221Accident · No injuriesClosedBell 47J2 · Refugio, TXJun 10, 1964 · N73902 · Substantial damage