Skip to content

NTSB investigations: Lycoming VO-540 series, OR

17 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

19662026

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 SEA05CA104Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Estacada, ORThe failure of the pilot to maintain landing skid clearance during hover taxi, which resulted in a dynamic rollover. A factor was the gusty wind condition.May 23, 2005 · N3030H · Substantial damage NTSB SEA04LA073Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Haines, ORA momentary partial loss of power for undetermined reason(s) and the pilot's failure to maintain adequate RPM during his autorotation landing.Apr 26, 2004 · N9785C · Substantial damage NTSB SEA02LA073Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Goshen, ORThe failure of company maintenance personnel to identify and replace/repair the degraded exhaust stack. Contributing factors were the mis-rigged carburetor heat control and the pilot's failure to maintain appropriate rotor RPM. Additional contributing factors…Apr 22, 2002 · N3004T · Substantial damage NTSB SEA94T#A01Accident · No injuriesClass 3Final reportHiller UH-12E · Eugene, ORMay 6, 1994 · N94492 · Substantial damage NTSB SEA85LA107Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Fall Creek, ORThe helicopter sustained substantial damage during a forced landing following a loss of power. According to the plt, the helicopter was refueled aprx 1 hr flt time prior to the accident. Cause of the power loss was not determined.May 5, 1985 · N28872 · Substantial damage NTSB SEA84LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Redmond, ORThe acft collided with the ground after a in-flt main rotor blade separation during an aerial application flt. Inspection of the fracture surface of the failed blade revealed characteristics consistant with the high stress, low cycle fatigue. Lab findings…Jul 16, 1984 · N1043L · Substantial damage NTSB SEA84LA091Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Buxton, ORThe helicopter entered an uncontrolled right roll while lifting off from a trailer & struck the ground with the m/r. the plt reported the trailer was not level.Apr 19, 1984 · N56BA · Substantial damage NTSB SEA79FYM08Accident · No injuriesClosedHiller Acft Soloy · Lacomb, ORDec 22, 1978 · N172ET · Substantial damage NTSB SEA79FYM01Accident · No injuriesClosedHiller Acft UH-12E · Falls City, OROct 2, 1978 · N90476 · Substantial damage NTSB SEA78DYA18Accident · No injuriesClosedHiller Acft UH-12E · Adrian, ORJul 20, 1978 · N67696 · Destroyed NTSB SEA78FYM06Accident · Serious injuriesClosedHiller Acft UH-12E · Depoe Bay, ORNov 3, 1977 · N9786C · Substantial damage NTSB SEA76FYC45Accident · Serious injuriesClosedHiller Acft UH-12E · Tillamook, ORMay 14, 1976 · N9785C · Destroyed NTSB SEA75FYC03Accident · No injuriesClosedHiller Acft UH-12E · Dayton, ORJul 16, 1974 · N104HA · Substantial damage NTSB SEA74FYC39Accident · No injuriesClosedHiller Acft UH-12E · Sublimity, ORMar 18, 1974 · N9749C · Destroyed NTSB SEA74FYC36Accident · No injuriesClosedHiller Acft UH-12E · Mt Hood, ORMar 5, 1974 · N5367V · Substantial damage NTSB SEA69D0181Accident · No injuriesClosedHiller UH-12E · Brightwood, ORDec 21, 1968 · N3820 · Substantial damage NTSB SEA66A0066Accident · No injuriesClosedHiller UH-12E · Huntington, ORJun 13, 1966 · N9785C · Substantial damage