Fatal NTSB investigations: Lycoming 0-320 series, 1973

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
Fatal NTSB investigations: Lycoming 0-320 series, 1973 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\") = 1973
    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 ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKDec 31, 1973 · N7694D · Substantial damageNTSB DEN74AD018Accident · 2 fatalClosedPiper PA-18 · Lusk, WYOct 28, 1973 · N8579C · DestroyedNTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILOct 6, 1973 · N36034 · DestroyedNTSB LAX74AL026Accident · 2 fatalClosedPiper PA-18 · Tacna, AZOct 4, 1973 · N4265Z · Substantial damageNTSB DEN74AD007Accident · 1 fatalClosedCessna 172L · Preston, IDAug 11, 1973 · N7725G · Substantial damageNTSB DEN74FTE17Accident · 1 fatalClosedPiper PA-18 · Pritchett, COAug 8, 1973 · N8438Y · DestroyedNTSB ANC74AA015Accident · 2 fatalClosedChampion 7GCBC · Healy, AKJul 31, 1973 · N5248X · Substantial damageNTSB SEA74AS001Accident · 1 fatalClosedPiper PA-18 · Metolius, ORJul 15, 1973 · N1758P · DestroyedNTSB SEA74AS002Accident · 2 fatalClosedPiper PA-22 · Missing AircraftJul 11, 1973 · N5017Z · DestroyedNTSB MIA73AM111Accident · 1 fatalClosedCessna 172L · Newberry, FLJun 17, 1973 · N9842G · DestroyedNTSB MKC73FER68Accident · 1 fatalClosedPiper PA-18A · Beardsley, MNJun 12, 1973 · N8073D · DestroyedNTSB MKC73AK060Accident · 2 fatalClosedPiper PA-12 · Bock, MNApr 8, 1973 · N7705H · DestroyedNTSB MIA73FLD63Accident · 1 fatalClosedPiper PA-28 · Orlando, FLMar 18, 1973 · N5785F · DestroyedNTSB NYC73AN100Accident · 1 fatalClosedPiper PA-18 · Providence Frg, VAJan 11, 1973 · N3902Z · DestroyedNTSB OAK73AP019Accident · 1 fatalClosedPiper PA-28 · Hayward, CAJan 7, 1973 · N4160J · 2 aircraft · Substantial damage