Fatal NTSB investigations: Lycoming 0-320 series, 1968

16 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, 1968 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\") = 1968
    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 MIA69A0031Accident · 1 fatalClosedPiper PA-28 · Homestead, FLDec 7, 1968 · N7286F · DestroyedNTSB DEN69A0026Accident · 1 fatalClosedPiper PA-28 · Creede, CONov 21, 1968 · N7481R · Substantial damageNTSB OAK69F0156Accident · 2 fatalClosedPiper PA-28 · Mt View, HIOct 14, 1968 · N5433W · DestroyedNTSB DEN69A0012Accident · 1 fatalClosedInterstate S-1A · Bitter Creek, WYSep 16, 1968 · N37455 · 2 aircraft · DestroyedNTSB FTW69F0191Accident · 1 fatalClosedPiper PA-25 · Presidio, TXSep 7, 1968 · N6271Z · DestroyedNTSB FTW69A0012Accident · 1 fatalClosedPiper PA-18A · Sinton, TXAug 24, 1968 · N7798B · DestroyedNTSB SEA69D0071Accident · 1 fatalClosedBeech A23-19 · Mccall, IDAug 12, 1968 · N4831B · Substantial damageNTSB CHI69A0004Accident · 1 fatalClosedPiper PA-28 · Hazard, KYJul 4, 1968 · N9804W · DestroyedNTSB FTW69F0345Accident · 1 fatalClosedPiper PA-18A · Breckenridge, TXJun 24, 1968 · N9121D · DestroyedNTSB DIA68A0053Accident · 1 fatalClosedPiper PA-28 · Greenville, NCJun 24, 1968 · N6957W · DestroyedNTSB ANC68A0051Accident · 2 fatalClosedPiper PA-18 · Soldotna, AKJun 24, 1968 · N3694Z · DestroyedNTSB OAK68A0072Accident · 4 fatalClosedCessna 177 · Bass Lake, CAJun 14, 1968 · N2914X · DestroyedNTSB MIA68A0101Accident · 1 fatalClosedPiper PA-28 · Pomaria, SCJun 2, 1968 · N6090W · DestroyedNTSB LAX69F0016Accident · 1 fatalClosedPiper PA-18 · Seligman, AZMay 30, 1968 · N5656Y · DestroyedNTSB ANC68A0046Accident · 1 fatalClosedPiper PA-18 · Kenai, AKMay 8, 1968 · N9491D · Substantial damageNTSB LAX68A0074Accident · 2 fatalClosedCessna 177 · Ocotillo Well, CAFeb 18, 1968 · N2264Y · Destroyed