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

6 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, CA per year, 1964–2026: 494 cases
19647
19654
19666
19676
19687
19696
19707
19711
19727
19732
19745
19758
19765
197713
197812
197917
198022
198111
198213
198325
198416
198515
198610
198710
198816
198913
199010
19918
19923
199310
199412
199515
19968
19976
19986
19994
200012
20016
20029
20037
200410
20055
20067
200711
20089
200911
20103
20114
20124
201311
20145
20165
20172
20182
20195
20206
20213
20225
20231
20241
20252
20262

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\" = 'CA' 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 LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…Nov 25, 1997 · N757FT · 2 aircraft · DestroyedNTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…Oct 12, 1997 · N11860 · DestroyedNTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.Oct 11, 1997 · N67293 · DestroyedNTSB LAX97LA309Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Imperial, CAThe pilot's failure to maintain directional control during landing and to arrest porpoising after an improper recovery from a bounced landing. Factors in the accident were the misjudging of distance and speed during a downwind landing.Aug 31, 1997 · N65273 · Substantial damageNTSB LAX97LA233Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAthe student pilot's failure to maintain runway alignment during takeoff.Jul 2, 1997 · N64954 · Substantial damageNTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…Apr 6, 1997 · N64845 · Destroyed