NTSB investigations: Lycoming VO-540 series
376 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.
Cases, newest first
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 ('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."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" 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 LAX00LA107Accident · Minor injuriesLimited investigationFinal reportHiller H-12E · Byron, CAThe pilot's inadequate visual lookout while maneuvering in proximity to wires. A contributing factor was the sun glare, which reduced the wire's conspicuity.NTSB LAX00LA077Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAThe pilot's inadequate clearance while maneuvering beneath a telephone line.NTSB SEA00TA013Accident · Serious injuriesFinal reportHiller UH-12E · Stites, IDInadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…NTSB LAX00LA027Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Castroville, CAThe pilot's inadequate visual lookout and diverted attention.NTSB SEA99LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Wenatchee, WAFuel exhaustion due to the pilot's failure to accomplish refueling.NTSB SEA99FA013Accident · 1 fatalField investigationFinal reportHiller UH-12E · Marshall, WAThe loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.NTSB MIA98FA229Accident · No injuriesField investigationFinal reportBell 47G-4A · Carrollton, ALThe pilots failure to follow written instructions in the flight manual for an engine failure, and the improper use of flight controls (cyclic/collective) during an autorotation resulting in a hard landing, and collision of the main rotor blades with the…NTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.NTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.NTSB LAX98LA089Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chico, CAFuel exhaustion due to the pilot's failure to ensure that an adequate fuel supply was onboard. A contributing factor was related to the fuel quantity gage's erroneous indication of fuel.NTSB FTW98LA030Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Welsh, LAthe pilot's failure to maintain control of the helicopter, while maneuvering to avoid an obstruction. The abrupt maneuver was a related factor.NTSB CHI98LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Liberty, NEA loss of engine power for undetermined reasons.NTSB SEA97LA191Accident · Minor injuriesLimited investigationFinal reportBell 47G · Wellpinit, WAThe pilot's selection of an unsuitable landing site, and his failure to maintain rotor blade clearance from terrain during landing.NTSB SEA97LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Idaho Falls, IDThe pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.NTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…NTSB LAX96LA315Accident · 1 fatalLimited investigationFinal reportBell 47-G4A · Guamloss of tail rotor control due to improper maintenance.NTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA279Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Healdsburg, CAThe failure of the pilot to confirm a loss of power before entering autorotation after reading an erroneous instrument indication on the helicopter's dual tachometer. Factors in the accident were the erratic instrument, and maintenance personnel who failed to…NTSB ATL96LA104Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cottondale, FLfailure of the main rotor drive torsional coupling and inner gimbal ring, which resulted in jamming of the flight controls during an attempted autorotation.NTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.NTSB SEA96LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12 · Walla Walla, WAthe pilot's inadequate preflight/planning, and his failure to refuel the helicopter with sufficient fuel before flight, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: an inaccurate fuel quantity…NTSB ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.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.NTSB CHI95LA270Accident · Minor injuriesLimited investigationFinal reportBell 47 · Arlington Hts, ILplot misjudged the flare. The factors included the pilot getting too close to the lead helicopter, allowing his airspeed to get too slow, and encountering settling with power.NTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.NTSB LAX95LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAfuel exhaustion due to the pilot's inattention to the fuel supply.NTSB LAX95LA109Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Arvin, CAThe seizure of the transmission due to lack of lubrication from a plugged oil supply line.NTSB LAX95LA096Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Chowchilla, CAthe in-flight failure and separation of the main rotor hub due to a fatigue crack.NTSB FTW95LA105Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · El Indio, TXThe loss of tail rotor effectiveness. A factor was the gusty right quartering tailwind.NTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.NTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.NTSB FTW94LA210Accident · No injuriesLimited investigationFinal reportHiller UH-12L4 · West Helena, ARA total loss of power due to a leak in the main fuel line which occurred as a result of an electrical short which burned a hole in the fuel line. Factors were a failure by the pilot to perform recommended maintenance and the lack of suitable terrain for a…NTSB SEA94T#A01Accident · No injuriesClass 3Final reportHiller UH-12E · Eugene, ORNTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.NTSB LAX94LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAThe pilot's improper handling of the helicopter which resulted in overloading of the rotor system in a maneuvering turn during aerial application of chemical, and subsequent failure of the main rotor paddle assembly.NTSB CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.NTSB SEA93LA181Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Auburn, WAFailure of the connecting rod bolt. The high vegetation was a factor.NTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.NTSB LAX93LA166Accident · 1 fatalLimited investigationFinal reportBell 47G2A · Pacific Ocean (Pacific Ocean)The passenger's failure to adhere to the pilot's instructions. Factors which contributed to the accident were: the language/communications difficulty between the pilot & the passenger, and the bird strike.NTSB LAX93LA120Accident · No injuriesLimited investigationFinal reportBell 47G · Bakersfield, CAThe clutch slippage and failure of the pilot to jettison the load.NTSB LAX92LA396Accident · Minor injuriesLimited investigationFinal reportBell 47-G4A · Volcano, HIThe pilot's improper use of the collective control after inadvertently entering a power settling condition.NTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.NTSB LAX92LA349Accident · Minor injuriesLimited investigationFinal reportHiller UH12-E, Saloy Conver · Arvin, CAThe failure of the tension torsion bar pin due to fatigue. Contributing to this accident was that it was not possible for the pilot to flare the helicopter on landing.NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB LAX92LA152Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAA failure of the pilot to conduct an adequate pre-flight inspection of the aircraft to ensure that the fuel supply was free of contaminates. Contributing to this accident was fuel contamination.NTSB LAX92LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAA separation of the control rotor cuff due to fatigue.NTSB FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.NTSB LAX91LA388Accident · 1 fatalLimited investigationFinal reportTexas Helicopter M74 · Farmington, CALoss of engine power for an undetermined reason. Factors related to the accident were: the excessive gross weight of the helicopter, and the pilot's improper use of flight controls due to impairment from use of a drug (marijuanna).NTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.NTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.