NTSB investigations: Lycoming 0-235 series, 1997

13 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Lycoming 0-235 series, 1997 per year, 1982–2026: 468 cases
198233
198323
198433
198522
198627
198730
198835
198919
199015
199116
199211
199319
199417
199528
199614
199713
199813
199913
200012
200114
200211
20038
200411
200514
20067
200710

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.Oct 28, 1997 · N49788 · Substantial damageNTSB NYC98LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Piqua, OHThe student pilot's inadequate compensation for the wind condition. A factor in this accident was the crosswind condition.Oct 15, 1997 · N6154Q · Substantial damageNTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.Oct 3, 1997 · N94999 · Substantial damageNTSB 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 ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.Sep 16, 1997 · N5840Z · Substantial damageNTSB NYC97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencerport, NYfailure of the pilot to maintain directional control of the airplane, while landing. The crosswind was a related factor.Aug 23, 1997 · N7682H · Substantial damageNTSB ATL97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Swansboro, NCThe pilot's failure to maintain directional control. A factor was the gusting winds.Jul 5, 1997 · N7799H · Substantial damageNTSB CHI97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNthe student pilot's improper recovery from a bounced landing and failure to maintain proper runway alignment during a go-around (aborted landing). Factors relating to the accident were: the pilot's improper flare for landing, the reduced light conditions at…Jun 17, 1997 · N2455F · Substantial damageNTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.May 30, 1997 · N66980 · 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 CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.May 6, 1997 · N5225B · Substantial damageNTSB FTW97LA152Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stillwater, OKthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control, which resulted in a ground swerve and collapse of the nose gear. The crosswind was a related factor.Mar 29, 1997 · N194BA · Substantial damageNTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.Jan 16, 1997 · N51448 · Substantial damage