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

4 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, 1984, 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\") = 1984
    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 CHI85LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Alton, ILWhile on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy…Nov 8, 1984 · N94494 · Substantial damageNTSB CHI84FA402Accident · Serious injuriesField investigationFinal reportCessna 152 · Wheeling, ILWitnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student…Sep 24, 1984 · N757ZG · DestroyedNTSB CHI84LA333Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Bloomington, ILPlt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to…Aug 4, 1984 · N5881Z · Substantial damageNTSB CHI84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Millstadt, ILThe acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy.May 20, 1984 · N8973L · Substantial damage