Fatal NTSB investigations: Lycoming 0-320 series, 1966

17 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
Fatal NTSB investigations: Lycoming 0-320 series, 1966 per year, 1964–2026: 1,382 cases
196411
19655
196617
196714
196816
196917
197016
197113
197210
197315
197421
197517
197617
197725
197843
197942
198036
198139
198250
198329
198426
198524
198635
198722
198838
198921
199018
199122
199221
199328
199418
199527
199617
199717
199817
199920
200015
200126
200245
200326
200432
200533
200624
200728
200827
200924
201023
201114
201223
201318
201417
201523
201619
201718
201813
201917
202012
202111
202212
202322
202412
20258
202616

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\") = 1966
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 NYC67A0092Accident · 2 fatalClosedPiper PA-18 · North Canaan, CTDec 11, 1966 · N3697Z · 2 aircraft · DestroyedNTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANov 23, 1966 · N4202Z · DestroyedNTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTSep 20, 1966 · N5182W · DestroyedNTSB MIA67A0029Accident · 1 fatalClosedPiper PA-18 · Cliftonville, MSAug 27, 1966 · N9280D · DestroyedNTSB CHI67F0302Accident · 1 fatalClosedPiper PA-18A · Sandwich, ILJul 19, 1966 · N7192D · DestroyedNTSB FTW67A0012Accident · 1 fatalClosedChampion 7GCBA · Brownsville, TXJul 18, 1966 · N9945Y · DestroyedNTSB ANC67A0008Accident · 1 fatalClosedPiper PA-18 · Kodiak, AKJul 17, 1966 · N3886Z · DestroyedNTSB MIA67S0002Accident · 2 fatalClosedMooney M20 · Vera Cruz, MexicoJul 14, 1966 · N5291B · DestroyedNTSB DEN67A0002Accident · 2 fatalClosedPiper PA-18 · Quemado, NMJul 7, 1966 · N3695Z · DestroyedNTSB FTW67A0005Accident · 1 fatalClosedChampion 7GCB · Los Fresnos, TXJul 6, 1966 · N9919Y · DestroyedNTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARJul 6, 1966 · N42418 · DestroyedNTSB DEN66A0087Accident · 1 fatalClosedPiper PA-22 · Weston, COMay 31, 1966 · N2559P · DestroyedNTSB CHI66A0095Accident · 1 fatalClosedPiper PA-12 · Gaylord, MIMay 30, 1966 · N2906M · No damageNTSB MIA66A0107Accident · 2 fatalClosedPiper PA-23 · Gallatin, TNMar 20, 1966 · N2179P · Substantial damageNTSB OAK66A0037Accident · 3 fatalClosedPiper PA-23 · El Granada, CAMar 19, 1966 · N2204P · DestroyedNTSB MIA66A0099Accident · 4 fatalClosedPiper PA-28 · Oak Hill, FLFeb 27, 1966 · N5832W · DestroyedNTSB LAX66A0062Accident · 1 fatalClosedPiper PA-18 · Empire, NVFeb 7, 1966 · N6978B · Destroyed