NTSB investigations: Lycoming 0-540 series, 1989

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

19822026
NTSB investigations: Lycoming 0-540 series, 1989 per year, 1982–2026: 65 cases
19822
19834
19843
19856
19862
19876
19881
19895
19901
19913
19921
19943
19952
19961
19973
19981
19993
20002
20011
20023
20034
20041
20051
20063
20073

Latest cases

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 year(c.\"eventDate\") = 1989
    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\" = 240))
  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.

NTSB NYC90FA036Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Coventry, CTThe non-instrument rated pilot initiating VFR flight into IMC on a dark night which resulted in spatial disorientation and uncontrolled flight into the ground. Contributing factor(s) was: the adverse weather existing at the time of the accident and the…Nov 28, 1989 · N3309W · DestroyedNTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.Nov 19, 1989 · N8289P · DestroyedNTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…Nov 9, 1989 · N2257T · DestroyedNTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.Sep 21, 1989 · N5450E · Substantial damageNTSB NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.Jul 16, 1989 · N6206P · Destroyed