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

10 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, 1997, 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\") = 1997
    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 FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.Oct 2, 1997 · N4957A · Substantial damageNTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…Sep 1, 1997 · N89268 · Substantial damageNTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.Jul 24, 1997 · N94912 · 2 aircraft · Substantial damageNTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…Jul 2, 1997 · N69073 · Substantial damageNTSB FTW97LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gorman, TXthe student pilot's improper inflight planning/decision, and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: a fluctuation in the electrical system, due to an undetermined reason, the student pilot's lack of…Jun 29, 1997 · N6099L · Substantial damageNTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Jun 12, 1997 · N6182U · Substantial damageNTSB FTW97LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe pilot's loss of control due to delayed landing flare. A factor was the porpoise encountered during landing.May 8, 1997 · N93124 · Substantial damageNTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.May 3, 1997 · N86RG · Substantial damageNTSB FTW97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Abilene, TXThe unlatching of the front bench seat for an undetermined reason.Mar 20, 1997 · N6883K · Substantial damageNTSB FTW97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brownsville, TXThe pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.Jan 26, 1997 · N2422N · Substantial damage