NTSB investigations: Lycoming 0-320 series, 1978, AZ

14 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, 1978, AZ per year, 1964–2026: 383 cases
19647
19656
19666
19675
19687
19693
19707
197111
19723
19736
19744
19757
19769
19775
197814
19799
19809
198110
198214
19832
19842
19857
19867
19872
19882
19899
19906
19918
19924
19933
19946
19955
19964
199710
19988
19995
20006
20017
200213
20036
20046
20059
200611
200710
20087
20096
20104
20113
201210
20135
20147
20151
20161
20173
20184
20194
20204
20216
20225
20234
20244
20251
20264

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\") = 1978
    AND c.\"eventStateOrRegion\" = 'AZ' 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 LAX79DUJ25Accident · No injuriesClosedMidget Mustng · Prescott, AZDec 27, 1978 · N86DL · Substantial damageNTSB LAX79DUJ27Accident · No injuriesClosedPiper PA-18 · Pinon, AZDec 21, 1978 · N2883Z · Substantial damageNTSB LAX79DUJ20Accident · No injuriesClosedPiper PA-18 · Eloy, AZNov 27, 1978 · N4090E · Substantial damageNTSB LAX79FUJ09Accident · Minor injuriesClosedCessna 172N · Scottsdale, AZOct 25, 1978 · N733WM · Substantial damageNTSB LAX79FUJ02Accident · No injuriesClosedVarga 2150 · Chandler, AZOct 14, 1978 · N5108V · Substantial damageNTSB LAX78DUK07Accident · No injuriesClosedCessna 172 · Mesa, AZSep 10, 1978 · N734SB · Substantial damageNTSB LAX78DUJ79Accident · No injuriesClosedCessna 172N · Wintersburg, AZJul 7, 1978 · N734TU · Substantial damageNTSB LAX78DUJ71Accident · Minor injuriesClosedGrum Amer AA-5 · Chilchinbeto, AZJun 16, 1978 · N9932U · Substantial damageNTSB LAX78DUJ69Accident · No injuriesClosedCessna 172M · Grand Canyon, AZMay 27, 1978 · N13367 · Substantial damageNTSB LAX78DUJ44Accident · No injuriesClosedCessna 172 · Kayenta, AZApr 4, 1978 · N9468H · Substantial damageNTSB LAX78FUJ35Accident · Serious injuriesClosedPiper PA-22 · El Mirage, AZMar 25, 1978 · N3447Z · Substantial damageNTSB LAX78DUJ38Accident · No injuriesClosedCessna 172N · Show Low, AZMar 19, 1978 · N75532 · Substantial damageNTSB LAX78FVJ31Accident · Minor injuriesClosedPiper PA-22 · Quartzsite, AZMar 10, 1978 · N9564D · Substantial damageNTSB LAX78DUJ22Accident · No injuriesClosedPiper PA-28 · Lake Havasu, AZJan 20, 1978 · N32841 · Substantial damage