NTSB investigations: Lycoming 0-235 series, 1998, TX

7 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, 1998, TX per year, 1964–2026: 344 cases
19643
19657
19664
19673
19687
19692
19704
19716
19723
19733
19743
19754
19763
19777
197810
197920
198013
198123
198214
198314
198410
19855
19865
19878
19886
19893
19903
19913
19926
19934
19942
19956
19968
199710
19987
19994
20006
20015
20023
20033
20045
20059
20064
20074
20084
20091
20101
20111
20123
20134
20144
20153
20166
20172
20185
20197
20202
20215
20222
20233
20245
20253
20261

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\") = 1998
    AND c.\"eventStateOrRegion\" = 'TX' 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 FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.Dec 31, 1998 · N46285 · Substantial damageNTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Dec 31, 1998 · N25778 · Substantial damageNTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.Dec 1, 1998 · N4755B · Substantial damageNTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 9, 1998 · N757XC · Substantial damageNTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 15, 1998 · N6217Q · Substantial damageNTSB FTW98LA317Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXThe inadequate visual lookout by the pilots of both airplanes.Jun 6, 1998 · N47354 · 2 aircraft · Substantial damageNTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.Jan 9, 1998 · N757CH · Substantial damage