NTSB investigations: Lycoming 0-540 series, 1987

6 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, 1987 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\") = 1987
    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 ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…Dec 12, 1987 · N3632W · DestroyedNTSB FTW88FA023Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Fulton, TXAcft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…Nov 4, 1987 · N3666W · DestroyedNTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…Oct 29, 1987 · N5431P · DestroyedNTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…Sep 6, 1987 · N8692W · DestroyedNTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…Jul 11, 1987 · N7858P · DestroyedNTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…Feb 2, 1987 · N6089T · Destroyed