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

7 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, 2001, 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\") = 2001
    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 DEN02LA005Accident · No injuriesLimited investigationFinal reportIrwin Thorp T-18 · Longmont, COThe loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landingOct 26, 2001 · N2819L · Substantial damageNTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.Oct 8, 2001 · N2364E · Substantial damageNTSB DEN01LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Peyton, COThe pilot's improper go-around procedure and his failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's lack of total experience.Aug 15, 2001 · N733BW · Substantial damageNTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.Jun 6, 2001 · N2970P · Substantial damageNTSB DEN01FA111Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Meeker, COthe pilot's failure to maintain terrain clearance as a result of his drug induced impairment. A factor was his exceeding the airplane's gross weight limits.May 29, 2001 · N5999V · DestroyedNTSB DEN01LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangely, COthe pilot's improper use of aileron and his failure to maintain directional control during landing. A contributing factor was the direct gusty crosswind.Mar 31, 2001 · N54663 · Substantial damageNTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.Mar 29, 2001 · N9464D · Substantial damage