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

4 cases on aircraft whose registry engine model is Lycoming O&VO-360 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.

Cases per year

19642026
NTSB investigations: Lycoming O&VO-360 series, 1987, PA per year, 1964–2026: 152 cases
19644
19657
19666
19679
19688
19693
19705
19716
19724
19736
19745
19753
19766
19772
19784
19792
19802
19815
19827
19832
19843
19874
19881
19901
19922
19933
19942
19951
19961
19973
19981
19993
20001
20011
20034
20044
20051
20063
20071
20091
20113
20122
20141
20163
20201
20212
20223

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.\"eventStateOrRegion\" = 'PA' 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 ('41514'))
  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 NYC87LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Waynesburg, PAThe pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the…Sep 26, 1987 · N9122J · Substantial damageNTSB NYC87LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Towanda, PAThe Taylorcraft, N43978, collided with the tail of Piper, N4889L while both were taxiing to rwy 22. The plt of the Taylorcraft stated that he was taxiing parallel to the rwy and the Piper came from behind and to the left to cross in front of him. The plt of…Jun 14, 1987 · N4889L · 2 aircraft · Substantial damageNTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.Apr 25, 1987 · N7726W · Substantial damageNTSB NYC87FA127Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · York, PAThe Piper PA-28-180 was making an NDB instrument approach under instrument meteorological conditions at night. The pilot manuevered the aircraft over the airport several times in an apparent attempt to acquire visual contact with the runway, lost control of…Apr 18, 1987 · N7987W · Destroyed