NTSB investigations: Lycoming O&VO-360 series, 1987

4 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 O&VO-360 series, 1987 per year, 1982–2026: 89 cases
19828
19838
19847
19853
19863
19874
19884
19896
19913
19924
19934
19942
19963
19972
19981
19993
20013
20026
20035
20042
20054
20062
20072

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 ('41514')
      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 MKC88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mena, AROn the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had…Nov 16, 1987 · N9131J · DestroyedNTSB FTW88FA028Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lancaster, TXThe pilot received a weather report indicating that IFR conditions prevailed. After takeoff the airplane traveled approximately 1/2 mile before it crashed. Pilot was not instrument rated and had very little total time. He did have three hours of night time…Nov 14, 1987 · N8980J · DestroyedNTSB BFO87FA046Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Abingdon, VAFss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the…Jul 6, 1987 · N19SM · DestroyedNTSB SEA87FA102Accident · 3 fatalField investigationFinal reportSocata TB10 · Battle Mountain, NVAfter receiving a weather briefing calling for mountains occasionally obscured, occasional moderate icing from 18000 ft & below, and ceilings across north & central Nevada, the noninstrument rated pilot filed a VFR flight plan and departed salt lake city for…May 26, 1987 · N20FU · Destroyed