Fatal NTSB investigations: Lycoming 0-320 series, 1979

42 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, 1979 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\") = 1979
    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 DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CODec 23, 1979 · N2013P · Substantial damageNTSB FTW80FA021Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 15, 1979 · N57329 · DestroyedNTSB ANC80FA020Accident · 2 fatalClosedPiper PA-18 · Grayling, AKDec 4, 1979 · N4325Z · Substantial damageNTSB LAX80FA012Accident · 2 fatalClosedPiper PA-28 · Phoenix, AZNov 10, 1979 · N6350W · DestroyedNTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MIOct 29, 1979 · N4437J · 2 aircraft · DestroyedNTSB NYC80FA006Accident · 1 fatalClosedPiper PA-28 · Gilead, MEOct 25, 1979 · N407FL · Substantial damageNTSB ANC79FA096Accident · 2 fatalClosedPiper PA-18 · Skwentna, AKSep 24, 1979 · N4032Z · Substantial damageNTSB NYC79FA101Accident · 2 fatalClosedBeech 19 · Manchester, NHSep 16, 1979 · N24601 · DestroyedNTSB IAD79FA080Accident · 1 fatalClosedPiper PA-28 · Cashiers, NCSep 12, 1979 · N41413 · DestroyedNTSB NYC79FA091Accident · 3 fatalClosedPiper PA-28 · Charlestown, NHSep 9, 1979 · N159TA · DestroyedNTSB CHI79FEI41Accident · 1 fatalClosedOsprey 2 · Medina, OHSep 6, 1979 · N96JR · DestroyedNTSB NYC79FA090Accident · 3 fatalClosedPiper PA-28 · No.Whitehall, PASep 5, 1979 · N6275W · DestroyedNTSB IAD79FA073Accident · 4 fatalClosedCessna 172N · Pinnacle, NCSep 4, 1979 · N738FR · DestroyedNTSB CHI79FEP74Accident · 1 fatalClosedPitts Spcl S1S · Camp Douglas, WIAug 14, 1979 · N751BF · DestroyedNTSB MIA79FA112Accident · 1 fatalClosedPiper PA-28 · Canton, GAAug 12, 1979 · N6322R · DestroyedNTSB LAX79FA062Accident · 1 fatalClosedCessna 172 · Mesa, AZJul 20, 1979 · N6250D · Substantial damageNTSB NYC79FA057Accident · 2 fatalClosedPiper PA-18S · Shenley, PAJul 14, 1979 · N4399A · DestroyedNTSB CHI79FEK17Accident · 1 fatalClosedVariviggen Edgar · Columbus, OHJul 6, 1979 · N101JE · DestroyedNTSB LAX79FAMS3Accident · 2 fatalClosedPiper PA-28 · Missing AircraftJul 1, 1979 · N3494M · DestroyedNTSB OAK79DAMS6Accident · 2 fatalClosedPiper PA-28 · Maui, HIJun 25, 1979 · N30775 · DestroyedNTSB NYC79FA049Accident · 3 fatalClosedPiper PA-28 · Flushing, NYJun 18, 1979 · N9283C · DestroyedNTSB MIA79FLT06Accident · 1 fatalClosedPitts S1-C · Southaven, MSJun 17, 1979 · N20JH · DestroyedNTSB LAX79FA059Accident · 4 fatalClosedCessna 177 · Long Beach, CAJun 9, 1979 · N29482 · DestroyedNTSB MIA79FA092Accident · 3 fatalClosedPiper PA-22 · Redlick, MSJun 5, 1979 · N9560D · DestroyedNTSB DEN79FA042Accident · 3 fatalClosedPiper PA-28 · Moab, UTMay 27, 1979 · N7098R · DestroyedNTSB LAX79FA053Accident · 2 fatalClosedPiper PA-28 · Long Beach, CAMay 14, 1979 · N2383T · DestroyedNTSB MIA79FA082Accident · 4 fatalClosedCessna 172M · San Juan, PRMay 13, 1979 · N707AC · DestroyedNTSB NYC79FA042Accident · 1 fatalClosedPiper PA-18 · Lebanon, NHApr 21, 1979 · N2344J · DestroyedNTSB MIA79FA069Accident · 1 fatalClosedAmer Avco AA-5 · Marathon, FLApr 11, 1979 · N7373L · DestroyedNTSB NYC79FGM22Accident · 2 fatalClosedPiper PA-22 · Monroeville, PAApr 7, 1979 · N5720D · DestroyedNTSB MIA79FA065Accident · 3 fatalClosedPiper PA-28 · Naples, FLApr 3, 1979 · N2181P · DestroyedNTSB NYC79FA032Accident · 4 fatalClosedGrum Amer AA-5 · Pompey, NYApr 1, 1979 · N9535L · DestroyedNTSB ANC79FA041Accident · 3 fatalClosedBellanca 7GCBC · Ruby, AKMar 26, 1979 · N5108X · DestroyedNTSB MIA79FA057Accident · 1 fatalClosedPiper PA-28 · Camden, SCMar 18, 1979 · N6920W · DestroyedNTSB FTW79FA064Accident · 1 fatalClosedPiper PA-22 · Gladewater, TXMar 17, 1979 · N936A · DestroyedNTSB MKC79FA022Accident · 2 fatalClosedChampion 7GCB · Waverly, KSMar 16, 1979 · N9835Y · DestroyedNTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LAMar 10, 1979 · N737XR · DestroyedNTSB LAX79FA031Accident · 3 fatalClosedCessna 172 · Mt Baldy, CAFeb 19, 1979 · N1527V · DestroyedNTSB DEN79FA022Accident · 1 fatalClosedPiper PA-28 · Logan, UTFeb 17, 1979 · N3893M · 2 aircraft · Minor damageNTSB FTW79FA049Accident · 1 fatalClosedPiper PA-28 · Comanche, TXFeb 16, 1979 · N5960U · DestroyedNTSB OAK79FAMS1Accident · 4 fatalClosedPiper PA-23 · Missing AircraftFeb 3, 1979 · N1330P · DestroyedNTSB OAK79FA015Accident · 1 fatalClosedPiper PA-28 · Porterville, CAJan 11, 1979 · N6970F · Destroyed