NTSB investigations: Lycoming 0-235 series, OK

83 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, newest first

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 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 FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.Apr 14, 1984 · N24708 · Substantial damageNTSB FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…Feb 15, 1984 · N6202M · Substantial damageNTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.Feb 1, 1984 · N94467 · Substantial damageNTSB 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 damageNTSB FTW83FPM03Accident · Minor injuriesFinal reportCessna 152 · Tulsa, OKOn the day before the accident the plt flew the acft to excelsor springs, MO for refueling, returning to liberty. On 11/7/82 at 1545 the flt departedliberty on an IFR flt plan. Approximately 7 mi north of Tulsa intl arpt the plt elected to land at Tulsa for…Nov 8, 1982 · N67798 · Substantial damageNTSB FTW81DPM14Accident · No injuriesClosedCessna 152 · Whitefield, OKJun 28, 1981 · N757BA · Substantial damageNTSB FTW81DPJ23Accident · No injuriesClosedCessna 152 · Ada, OKMay 20, 1981 · N49022 · Substantial damageNTSB FTW81FPJ18Accident · Minor injuriesClosedCessna 152 · Bethany, OKApr 9, 1981 · N24734 · Substantial damageNTSB FTW81FPJ08Accident · No injuriesClosedPiper PA-38 · Hennessey, OKJan 4, 1981 · N2405L · Substantial damageNTSB FTW81FPJ03Accident · Serious injuriesClosedPiper PA-38 · Hammon, OKOct 19, 1980 · N2476L · DestroyedNTSB FTW81FPJ01Accident · Minor injuriesClosedPiper PA-38 · Stillwater, OKOct 11, 1980 · N2592B · DestroyedNTSB FTW80FPJ21Accident · No injuriesClosedCessna 152 · Grandfield, OKJun 3, 1980 · N757YQ · Substantial damageNTSB FTW80FA070Accident · 1 fatalClosedCessna 150 · Tulsa, OKMay 7, 1980 · N2970V · 2 aircraft · DestroyedNTSB FTW80FPJ05Accident · No injuriesClosedPiper PA-38 · Guymon, OKDec 8, 1979 · N4387E · Substantial damageNTSB FTW79DPJ25Accident · No injuriesClosedCessna 152 · Lawton, OKJun 23, 1979 · N47053 · Substantial damageNTSB FTW79DPJ02Accident · No injuriesClosedCessna 152 · Tonkawa, OKNov 3, 1978 · N714WX · Substantial damageNTSB FTW78FPM13Accident · No injuriesClosedPiper PA-22 · Tulsa, OKMay 27, 1978 · N5760Z · Substantial damageNTSB FTW77FPJ08Accident · No injuriesClosedPiper PA-22 · Duncan, OKMar 12, 1977 · N5426Z · Substantial damageNTSB FTW76FPM18Accident · No injuriesClosedAmer Avco AA1-B · Cookson, OKApr 23, 1976 · N9657L · Substantial damageNTSB FTW76FPM06Accident · No injuriesClosedBellanca 7ECA · Keifer, OKSep 3, 1975 · N90968 · Substantial damageNTSB FTW75FRJ10Accident · No injuriesClosedPiper PA-16 · Fairview, OKNov 11, 1974 · N5985H · Substantial damageNTSB FTW75DPJ05Accident · No injuriesClosedPiper PA-16 · Ardmore, OKSep 14, 1974 · N5757H · Substantial damageNTSB FTW74DPJ07Accident · No injuriesClosedChampion 7GCBC · Seminole, OKAug 14, 1973 · N5242X · Substantial damageNTSB FTW70D0244Accident · No injuriesClosedPiper PA-16 · Norman, OKSep 25, 1969 · N5273H · Substantial damageNTSB MKC68A0018Accident · 4 fatalClosedPiper PA-16 · Blocker, OKSep 3, 1967 · N5746H · 2 aircraft · DestroyedNTSB FTW67D0382Accident · No injuriesClosedPiper PA-22 · Enid, OKJan 2, 1967 · N4517Z · Substantial damageNTSB FTW66D0591Accident · No injuriesClosedPiper PA-18 · Morris, OKFeb 27, 1966 · N228T · Substantial damageNTSB UNK65X1432Accident · No injuriesClosedPiper PA22 · Ardmore, OKFeb 17, 1965 · N4579Z · Substantial damageNTSB UNK64X1067Accident · Minor injuriesClosedPiper PA16 · Henryetta, OKMar 28, 1964 · N5956H · Substantial damage