NTSB investigations: Lycoming 0-320 series, 1998, 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, 1998, 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\") = 1998
    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 DEN99LA021Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Aurora, COThe pilot's failure to maintain directional control. Factors were the gusty crosswind and terrain.Nov 22, 1998 · N9632S · Substantial damageNTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.Sep 19, 1998 · N6028D · DestroyedNTSB FTW98LA398Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Watkins, COGusting winds which blew the aircraft inverted during taxi.Sep 13, 1998 · N4037E · Substantial damageNTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.Jul 16, 1998 · N172AT · Substantial damageNTSB FTW98LA198Accident · No injuriesLimited investigationFinal reportCessna 172N · Parker, COa fractured #1 exhaust valve rocker arm stud, which subsequently resulted in loss of engine power and a forced landing. The lack of suitable terrain in the forced landing area was a related factor.Apr 25, 1998 · N6356D · Substantial damageNTSB FTW98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe pilot inadvertently stalling the aircraft during the landing touchdown. Factors were a crosswind and the pilot's lack of total flight experience.Apr 19, 1998 · N6174K · Substantial damageNTSB FTW98LA128Accident · No injuriesLimited investigationFinal reportBeech 23 · Colorado Sprngs, COThe pilot's inadvertent porpoise during landing roll. A factor was the ditch.Feb 11, 1998 · N2382L · Substantial damage