NTSB investigations: Lycoming 0-320 series, 1964, TX

28 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, 1964, TX per year, 1964–2026: 916 cases
196428
196525
196630
196727
196834
196933
197030
197116
197224
197314
197420
197518
197626
197723
197823
197924
198019
198122
198225
198314
198411
198511
198613
19876
19887
19897
19908
199110
199211
199316
19944
19958
199613
199713
199810
199913
200011
20019
200217
200320
200414
200510
200614
20077
200813
200910
201011
201112
20127
20137
201410
201511
20168
20177
20186
20196
202013
20219
202211
202310
20249
20257
202611

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\") = 1964
    AND c.\"eventStateOrRegion\" = 'TX' 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 UNK65X1086Accident · No injuriesClosedPiper PA28 · Addison, TXDec 22, 1964 · N6323W · Substantial damageNTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXDec 7, 1964 · N2393L · Substantial damageNTSB UNK65X0834Accident · No injuriesClosedPiper PA18 · Marfa, TXNov 25, 1964 · N3994Z · Substantial damageNTSB UNK65X0778Accident · No injuriesClosedPiper PA-28 · Bula, TXNov 21, 1964 · N6122W · Substantial damageNTSB UNK65X0620Accident · No injuriesClosedBeechcraft PA-23 · Dallas, TXNov 8, 1964 · N2314L · Substantial damageNTSB UNK65X0615Accident · No injuriesClosedPiper PA22 · Alice, TXNov 8, 1964 · N9650D · Substantial damageNTSB UNK65X0405Accident · No injuriesClosedPiper PA28 · Beckenridge, TXOct 24, 1964 · N5768W · Substantial damageNTSB UNK65X0372Accident · No injuriesClosedPiper PA23 · Laporte, TXOct 22, 1964 · N1119P · Substantial damageNTSB UNK64X3929Accident · 1 fatalClosedPiper PA-25 · Hereford, TXSep 12, 1964 · N6481Z · DestroyedNTSB UNK64X3906Accident · Serious injuriesClosedPiper PA25 · Mclean, TXSep 10, 1964 · N6477Z · DestroyedNTSB UNK64X3819Accident · No injuriesClosedPiper PA28 · Houston, TXSep 6, 1964 · N5151W · Substantial damageNTSB UNK64X3513Accident · No injuriesClosedPiper PA22 · Sheffield, TXAug 21, 1964 · N8019D · Substantial damageNTSB UNK64X3412Accident · No injuriesClosedPiper PA25 · Abilene, TXAug 16, 1964 · N6213Z · Substantial damageNTSB UNK64X3346Accident · No injuriesClosedCallair A5 · Victoria, TXAug 12, 1964 · N2937G · Substantial damageNTSB UNK64X2949Accident · No injuriesClosedBeechcraft 23 · Pearland, TXJul 21, 1964 · N2390L · Substantial damageNTSB UNK64X2815Accident · Serious injuriesClosedChampion 7GCB · Raymondville, TXJul 13, 1964 · N9911Y · DestroyedNTSB UNK64X2637Accident · No injuriesClosedBeechcraft M23 · Abilene, TXJul 4, 1964 · N8708M · Substantial damageNTSB UNK64X2533Accident · No injuriesClosedPiper PA23 · Ft Worth, TXJun 28, 1964 · N2154P · Substantial damageNTSB UNK64X2481Accident · No injuriesClosedBeechcraft 23 · Seminole, TXJun 25, 1964 · N2331J · Substantial damageNTSB UNK64X2479Accident · No injuriesClosedPiper PA28 · Fabens, TXJun 25, 1964 · N6036W · Substantial damageNTSB UNK64X2298Accident · No injuriesClosedPiper PA25 · Spearman, TXJun 15, 1964 · N6520Z · Substantial damageNTSB UNK64X2282Accident · No injuriesClosedBeechcraft 23 · Dallas, TXJun 14, 1964 · N2343Q · Substantial damageNTSB UNK64X2219Accident · No injuriesClosedPiper PA25 · Raymondville, TXJun 10, 1964 · N6201Z · Substantial damageNTSB UNK64X1735Accident · No injuriesClosedPiper PA28 · Cresson, TXMay 12, 1964 · N5074W · Substantial damageNTSB UNK64X1628Accident · No injuriesClosedPiper PA23 · Abilene, TXMay 5, 1964 · N4367P · Substantial damageNTSB UNK64X1537Accident · No injuriesClosedPiper PA28 · Post, TXApr 30, 1964 · N5368W · Substantial damageNTSB UNK64X0537Accident · No injuriesClosedPiper PA23 · Beeville, TXFeb 11, 1964 · N3115P · Substantial damageNTSB UNK64X0462Accident · No injuriesClosedPiper PA22 · Cotton Center, TXFeb 5, 1964 · N7538D · Substantial damage