NTSB investigations: Lycoming 0-320 series, 1974, IL

15 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, 1974, IL per year, 1964–2026: 465 cases
196411
196516
196621
196723
196815
196917
197016
197121
197216
197315
197415
197520
197614
197715
197822
197913
198012
198115
19828
19838
19843
19854
19867
19876
19884
19896
19906
19917
19927
19944
19964
19975
19986
19995
20002
20018
20024
20033
20044
20055
20066
20074
20091
20114
20123
20132
20142
20154
20165
20183
20191
20203
20211
20226
20231
20242
20253
20261

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\") = 1974
    AND c.\"eventStateOrRegion\" = 'IL' 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 CHI75DEE37Accident · No injuriesClosedPiper PA-23 · Monee, ILDec 23, 1974 · N2207P · Substantial damageNTSB CHI75FEE32Accident · Minor injuriesClosedPiper PA-28 · Lansing, ILDec 10, 1974 · N44112 · Substantial damageNTSB CHI75DEE31Accident · No injuriesClosedPiper PA-28 · Grayslake, ILNov 25, 1974 · N55617 · Substantial damageNTSB CHI75FEV11Accident · No injuriesClosedChampion 7GCAA · Shelbyville, ILNov 6, 1974 · N251JB · Substantial damageNTSB CHI75FEV06Accident · Serious injuriesClosedCessna 172K · Beason, ILOct 9, 1974 · N79468 · Minor damageNTSB CHI75AC021Accident · 3 fatalClosedCessna 177 · New Lenox, ILAug 24, 1974 · N2802X · Substantial damageNTSB CHI75FEE15Accident · No injuriesClosedCessna 172 · Ottawa, ILJul 30, 1974 · N7284Q · Substantial damageNTSB CHI75FEE01Accident · No injuriesClosedPiper PA-28 · West Chicago, ILJul 14, 1974 · N15003 · Substantial damageNTSB CHI74AC097Accident · Minor injuriesClosedCessna 120 · Manito, ILJun 18, 1974 · N1762N · 2 aircraft · DestroyedNTSB CHI74FEE77Accident · Minor injuriesClosedCessna 172K · Schaumberg, ILMay 26, 1974 · N78418 · Substantial damageNTSB CHI74FEE75Accident · Minor injuriesClosedCessna 172M · Waukegan, ILMay 3, 1974 · N4381R · Substantial damageNTSB CHI74DEE71Accident · No injuriesClosedPiper PA-28 · Sandwich, ILApr 26, 1974 · N459FL · Substantial damageNTSB CHI74FEE61Accident · No injuriesClosedPiper PA-28 · Tonica, ILMar 17, 1974 · N15533 · Substantial damageNTSB CHI74DEE54Accident · No injuriesClosedPiper PA-28 · Kankakee, ILFeb 16, 1974 · N7443R · Substantial damageNTSB CHI74FEV35Accident · No injuriesClosedCessna 172L · Quincy, ILJan 14, 1974 · N9883G · Substantial damage