NTSB investigations: Lycoming 0-320 series, 1990, CO

6 cases on aircraft whose registry engine model is Lycoming 0-320 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-320 series, 1990, CO per year, 1964–2026: 416 cases
19645
19656
19669
19679
196815
196914
197015
197110
19726
19739
197414
19759
197611
197710
197812
197910
19808
19819
19827
198310
19846
19856
19862
19876
19889
19897
19906
199113
19928
19935
19945
19956
19967
19979
19987
199910
20004
20017
200211
20033
20048
20053
20065
20075
20086
20093
20102
20112
20123
20135
20143
20151
20161
20172
201810
20191
20204
20212
20222
20231
20244
20255
20263

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\") = 1990
    AND c.\"eventStateOrRegion\" = 'CO' 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 ('41508'))
  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 DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.Oct 16, 1990 · N5523Z · Substantial damageNTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.Sep 11, 1990 · N1241U · Substantial damageNTSB DEN90LA126Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder, COThe pilot's failure to touch down at the proper point, his misjudgment of the distance required for takeoff following the touch and go, and his delayed decision to abort the takeoff.Jun 7, 1990 · N2723E · Substantial damageNTSB DEN90LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Englewood, COThe pilot landed with a tailwind, and cost control of the airplane during rollout.Apr 27, 1990 · N6356D · Substantial damageNTSB DEN90LA079Accident · No injuriesLimited investigationFinal reportCessna 172M · Colorado Spring, COThe pilot's decision to initiate flight into known adverse weather, and his in-flight planning/decison. Factors related to the accident were: the adverse weather conditions, and the accumulation of airframe ice.Mar 25, 1990 · N19948 · Substantial damageNTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.Jan 30, 1990 · N9172Y · Substantial damage