NTSB investigations: Lycoming 0-540 series, CA

6 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “In flight collision with object”. 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

19842026

NTSB investigations: Lycoming 0-540 series, CA per year, 1984–2026: 6 cases
1984	1
1988	2
1990	1
1993	1
2001	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 ('41532') 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" = 220)) 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 ('41532')
      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\" = 220))
  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 ('41532')
    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" = 220))
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 LAX02LA001Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Petaluma, CAThe pilot's inadvertent (dark, nighttime) VFR flight into instrument meteorological conditions and subsequent loss of altitude control. A factor in the accident was the pilot's inadequate preflight weather evaluation.Oct 8, 2001 · N7846C · Substantial damage NTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.Sep 4, 1993 · N5523P · Substantial damage NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.Aug 9, 1990 · N117HA · Destroyed NTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.May 9, 1988 · N117HA · Substantial damage NTSB LAX88LA111Accident · Serious injuriesLimited investigationFinal reportCessna R182 · San Andreas, CADuring a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not…Feb 22, 1988 · N3178C · Destroyed NTSB LAX84FA337Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Barstow, CAThe flt had originated somewhere in Mexico & was being tracked by dea investigators until radar contact was lost. In the vicinity of amboy, CA an anonymous caller had contacted the highway patrol & reported a low flying acft near amboy with no visible…Jun 7, 1984 · N5306Y · Destroyed