NTSB investigations: Lycoming 0-235 series, 1987, IL

6 cases on aircraft whose registry engine model is Lycoming 0-235 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 0-235 series, 1987, IL per year, 1964–2026: 160 cases
196410
19655
19668
196710
19682
19693
19705
19715
19721
19731
19744
19752
19761
19773
19788
19796
19805
19813
19827
19837
19844
19852
19865
19876
19883
19892
19903
19915
19923
19933
19942
19953
19971
19982
19993
20001
20013
20021
20051
20071
20091
20101
20111
20121
20132
20231
20251
20262

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\" = 'IL' 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 ('41505'))
  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 CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…Dec 6, 1987 · N757KW · Substantial damageNTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…Sep 27, 1987 · N6320A · Substantial damageNTSB CHI87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILThe accident occurred on a local training flight. At 3500 ft MSL the eng failed. The student plt landed at a near-by arpt but bounced on touchdown, veered off the rnwy and nosed over. Eng exam disclosed broken primary venturi in carb.Sep 5, 1987 · N67447 · Substantial damageNTSB CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…Jul 16, 1987 · N4967B · Substantial damageNTSB CHI87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILAccording to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft…Jan 23, 1987 · N48241 · Substantial damageNTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…Jan 23, 1987 · N2536A · Substantial damage