Fatal NTSB investigations: Lycoming 0-320 series, 1970

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, 1970 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\") = 1970
    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 DEN71AD025Accident · 2 fatalClosedPiper PA-18 · Montrose, CONov 29, 1970 · N1874P · DestroyedNTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNSep 18, 1970 · N2331Q · DestroyedNTSB MKC71AK015Accident · 2 fatalClosedCessna 172I · Vichy, MOSep 13, 1970 · N46223 · DestroyedNTSB MEX71A0051Accident · 2 fatalClosedCessna 150A · San Quintin, MexicoAug 29, 1970 · N8916S · DestroyedNTSB ANC71AA012Accident · 1 fatalClosedPiper PA-18 · Seward, AKAug 11, 1970 · N3830Z · DestroyedNTSB LAX71AL005Accident · 2 fatalClosedPiper PA-22 · Simmler, CAAug 10, 1970 · N2722P · DestroyedNTSB MKC71AK008Accident · 1 fatalClosedPiper PA-18 · Merriman, NEAug 9, 1970 · N9060D · DestroyedNTSB FTW71FRD04Accident · 2 fatalClosedPiper PA-18A · Crowley, LAJul 25, 1970 · N6776B · DestroyedNTSB NYC71AN010Accident · 2 fatalClosedPiper PA-28 · Provincetown, MAJul 20, 1970 · N6245W · DestroyedNTSB MIA71AM004Accident · 4 fatalClosedBeech 23 · Ocala, FLJul 9, 1970 · N8715M · DestroyedNTSB IAD71AI004Accident · 3 fatalClosedPiper PA-22 · Chesapeake, VAJul 5, 1970 · N1909P · DestroyedNTSB MKC70FDD21Accident · 1 fatalClosedPiper PA-18 · Maddock, NDJun 26, 1970 · N8567D · DestroyedNTSB IAD70AI062Accident · 1 fatalClosedPiper PA-28 · Rose Hill, NCJun 14, 1970 · N3936K · Substantial damageNTSB DEN70AD055Accident · 1 fatalClosedChampion 7GCBC · Colorado Sps, COMay 17, 1970 · N7549F · DestroyedNTSB DEN70AD053Accident · 2 fatalClosedPiper PA-18 · Littleton, COApr 29, 1970 · N2671P · DestroyedNTSB IAD70FLJ01Accident · 1 fatalClosedPiper PA-22 · Orrum, NCMar 3, 1970 · N7120B · Substantial damage