NTSB investigations: Lycoming VO-540 series, OK

7 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

19762026

NTSB investigations: Lycoming VO-540 series, OK per year, 1976–2026: 7 cases
1976	2
1979	1
1990	1
1995	1
2008	1
2009	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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN09CA359Accident · No injuriesData collectionFinal reportHiller UH-12E · Stringtown, OKThe pilot's failure to maintain clearance from power lines. Contributing to the accident was the pilot's preoccupation with personal affairs.Jun 11, 2009 · N34SD · Substantial damage NTSB DFW08LA100Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Quinton, OKAn undetermined mechanical malfuction associated with the tail rotor drive system which led to a loss of control.Apr 7, 2008 · N34SD · Substantial damage NTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.Jun 4, 1995 · N4254X · Substantial damage NTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.Apr 14, 1990 · N2238W · Destroyed NTSB FTW79FPJ26Accident · Minor injuriesClosedHiller UH12L4 · Elk City, OKJun 22, 1979 · N90453 · Substantial damage NTSB FTW76FPJ46Accident · Serious injuriesClosedBrantley 305 · Chattanooga, OKSep 11, 1976 · N2231U · Destroyed NTSB FTW76DPJ25Accident · Minor injuriesClosedBell 47G-4 · Billings, OKFeb 25, 1976 · N1150W · Destroyed