NTSB investigations: Lycoming 0-235 series, 1983, OK

5 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, 1983, OK per year, 1964–2026: 83 cases
19641
19651
19661
19672
19691
19731
19742
19751
19761
19771
19782
19792
19804
19814
19821
19835
19844
19851
19862
19872
19884
19891
19911
19922
19951
19961
19973
19983
20013
20023
20031
20041
20056
20073
20082
20092
20121
20151
20161
20171
20211
20241
20251

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\") = 1983
    AND c.\"eventStateOrRegion\" = 'OK' 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 FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…Dec 4, 1983 · N4579Z · DestroyedNTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.Nov 18, 1983 · N46237 · DestroyedNTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…Aug 7, 1983 · N67452 · Substantial damageNTSB FTW83LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft collided with a ditch during a forced landing. This was an instructional flt and the CFI gave the student a simulated forced landing. During the attempted go-around the engine reportedly developed only 1800 RPM and a landing wasmade in a field by the…Jul 31, 1983 · N49352 · Substantial damageNTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…May 16, 1983 · N65412 · Substantial damage