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

8 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, 2004, 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\") = 2004
    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 DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.Dec 18, 2004 · N78AT · Substantial damageNTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.Dec 4, 2004 · N55250 · Substantial damageNTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.Nov 16, 2004 · N54165 · Substantial damageNTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.Oct 31, 2004 · N25HM · DestroyedNTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.Aug 9, 2004 · N911JR · DestroyedNTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…May 26, 2004 · N4173Y · Substantial damageNTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.Apr 24, 2004 · N5048E · Substantial damageNTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.Jan 8, 2004 · N57534 · Substantial damage