NTSB investigations: Lycoming 0-235 series, 1986

6 cases on aircraft whose registry engine model is Lycoming 0-235 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.

Cases per year

19822026
NTSB investigations: Lycoming 0-235 series, 1986 per year, 1982–2026: 119 cases
19829
19839
19847
19856
19866
19877
19885
19897
19904
19913
19926
19933
19945
19953
19966
19973
19982
19993
20004
20011
20025
20034
20043
20051
20063
20074

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\") = 1986
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
      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.

NTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…Dec 27, 1986 · N78475 · DestroyedNTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…Dec 2, 1986 · N4784A · Substantial damageNTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…Nov 18, 1986 · N68328 · DestroyedNTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.Aug 30, 1986 · N5159T · Substantial damageNTSB NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.Jul 10, 1986 · N2NH · Substantial damageNTSB LAX86LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Snellings, CAThe CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was…Apr 13, 1986 · N5150B · Substantial damage