NTSB investigations: Lycoming VO-540 series, CA

5 cases on aircraft whose registry engine model is Lycoming VO-540 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19822026

NTSB investigations: Lycoming VO-540 series, CA per year, 1982–2026: 5 cases
1982	1
1985	1
1986	1
1987	1
1989	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."eventStateOrRegion" = 'CA' 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') 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" = 351)) 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\" = 'CA' 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')
      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\" = 351))
  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" = 'CA' 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')
    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" = 351))
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 LAX90DVA01Accident · Serious injuriesFinal reportHiller 12E · Huron, CAThe pilot failed to properly preflight the airplane before departing on the accident flight and misjudged the flare during the ensuing autorotation. Factors relating to this accident were oil starvation and total failure of the connecting rod.Oct 16, 1989 · N4026G · Substantial damage NTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…Feb 2, 1987 · N28938 · Substantial damage NTSB LAX86FVM06Accident · No injuriesFinal reportHiller UH21E · Salinas, CAThe plt experienced a 'ratcheting' to the right and a decrease in rotor RPM during cruise flt at 75-100 ft AGL. The plt made an autorotation but could not cushion the landing due to the low alt and lack of rotor RPM. The helicopter impacted hard and…Aug 12, 1986 · N169HA · Substantial damage NTSB LAX85FA132Accident · Minor injuriesField investigationFinal reportHiller UH12E · Five Points, CAWhile performing an ag flight the helicopter's engin suddenly lost power. At the time the aircraft was near its max allowable gross weight and it was between 3-5FT AGL. As the aircraft yawed left and descended. The pilot in command attempted to land on a…Feb 3, 1985 · N5323V · Substantial damage NTSB LAX82FA245Accident · No injuriesField investigationFinal reportHiller UH-12L3 · Stockton, CAThe pilot reported that the engine lost power at about 5 ft AGL as he was taking off from a trailer. He turned to avoid a gas and water tank near the poll truck. The helicopter came to rest, right-side-up, but was damaged. A fuel leak was found in a line that…Jul 1, 1982 · N86689 · Substantial damage