Fatal NTSB investigations: Lycoming 0-235 series, 1995

8 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
Fatal NTSB investigations: Lycoming 0-235 series, 1995 per year, 1964–2026: 356 cases
19643
19652
19664
19675
19684
19694
19711
19723
19734
19743
19752
19775
197813
197914
198011
198112
198215
198314
198414
19856
19868
19876
19887
19896
199011
19915
19925
19936
19945
19958
19963
19977
19988
19995
20006
200110
20028
20033
20045
200510
20064
20075
20086
200910
20102
20114
20126
20135
20143
20155
20165
20175
20183
20191
20203
20216
20227
20231
20254

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\") = 1995
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.Nov 21, 1995 · N6392Q · DestroyedNTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.Sep 15, 1995 · N117ER · 2 aircraft · DestroyedNTSB FTW95FA307Accident · 2 fatalField investigationFinal reportCessna 152 · Rhome, TXthe flight instructor's delay in recovery from the intentional stall/spin.Jul 21, 1995 · N6463B · DestroyedNTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.Jun 21, 1995 · N1348 · 2 aircraft · DestroyedNTSB LAX95LA179Accident · 1 fatalLimited investigationFinal reportCessna 152 · Palos Verdes, CAthat the pilot initiated the flight into known adverse weather, and inadvertent flight into instrument meteorological conditions.Apr 28, 1995 · N49058 · DestroyedNTSB MIA95FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 152 · MissingUndetermined. The airplane and occupants have not been located.Feb 28, 1995 · N25900 · DestroyedNTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.Feb 18, 1995 · N115EZ · Substantial damageNTSB FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.Jan 24, 1995 · N4892A · Minor damage