NTSB investigations: Lycoming 0-320 series, 1978, CA

36 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
NTSB investigations: Lycoming 0-320 series, 1978, CA per year, 1964–2026: 1,367 cases
196425
196530
196646
196750
196841
196933
197041
197130
197236
197331
197424
197524
197618
197739
197836
197932
198032
198130
198228
198327
198424
198519
198627
198722
198822
198919
199029
199122
199220
199328
199425
199520
199620
199713
199817
199920
200024
200124
200225
200321
200417
200520
200619
200718
200817
200917
201012
20119
20126
201311
20148
201512
201612
201712
201813
201914
20207
20217
20226
202313
20249
20253
202611

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\") = 1978
    AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 OAK79DVA21Accident · No injuriesClosedPiper PA-23 · Visalia, CADec 21, 1978 · N1437P · Substantial damageNTSB LAX79FUQ08Accident · No injuriesClosedPiper PA-22 · Van Nuys, CADec 5, 1978 · N1720P · Substantial damageNTSB LAX79FUG07Accident · No injuriesClosedPiper PA-28 · Newberry Spgs, CANov 25, 1978 · N6184H · Substantial damageNTSB LAX79FUA03Accident · No injuriesClosedCessna 172N · Huntington Bch, CANov 14, 1978 · N734TW · Substantial damageNTSB LAX79FA013Accident · 1 fatalClosedCessna 172N · Sn Jun Cpstrn, CANov 12, 1978 · N739HG · DestroyedNTSB LAX79FUQ06Accident · Minor injuriesClosedCessna 172I · Santa Barbara, CANov 3, 1978 · N46016 · Substantial damageNTSB OAK78DVA07Accident · No injuriesClosedCessna 172N · Huron, CAOct 28, 1978 · N734TE · Substantial damageNTSB OAK78DVA84Accident · No injuriesClosedCessna 172 · Coalinga, CASep 26, 1978 · N2038E · Substantial damageNTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CASep 22, 1978 · N36762 · 2 aircraft · DestroyedNTSB OAK78DVG79Accident · No injuriesClosedCessna 172 · Vacaville, CASep 14, 1978 · N6572H · Substantial damageNTSB LAX78DUG51Accident · No injuriesClosedBellanca 7GCBC · 29 Palms, CASep 4, 1978 · N7592F · Substantial damageNTSB OAK78DVM43Accident · No injuriesClosedCessna 172N · San Francisco, CAAug 30, 1978 · N734UF · Substantial damageNTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CAAug 30, 1978 · N864B · DestroyedNTSB LAX78DUG48Accident · No injuriesClosedCessna 172 · Apple Valley, CAAug 27, 1978 · N739PG · DestroyedNTSB OAK78DVG73Accident · No injuriesClosedCessna 177 · Shingletown, CAAug 16, 1978 · N2261Y · Substantial damageNTSB LAX78FUA24Accident · Serious injuriesClosedCessna 172M · Avalon, CAAug 8, 1978 · N64188 · Substantial damageNTSB LAX78FUQ44Accident · No injuriesClosedPiper PA-28 · Quartz Hill, CAJul 28, 1978 · N4915T · Substantial damageNTSB LAX78FUG42Accident · No injuriesClosedBellanca 7GCBC · Hemet, CAJul 23, 1978 · N88130 · Substantial damageNTSB OAK78DVA58Accident · No injuriesClosedPiper PA-28 · Coalinga, CAJul 15, 1978 · N6345R · Substantial damageNTSB OAK78DVD45Accident · No injuriesClosedPiper PA-28 · Stockton, CAJul 9, 1978 · N7746F · Substantial damageNTSB OAK78DVG51Accident · Minor injuriesClosedCessna 172 · Weed, CAJun 19, 1978 · N9935Q · DestroyedNTSB OAK78FVG46Accident · No injuriesClosedBeech 19A · Butte City, CAJun 5, 1978 · N6530T · Substantial damageNTSB LAX78DUM26Accident · No injuriesClosedCessna 172K · Brawley, CAJun 4, 1978 · N79130 · Substantial damageNTSB OAK78DVD40Accident · No injuriesClosedPiper PA-28 · Shelter Cove, CAMay 28, 1978 · N9886W · Substantial damageNTSB LAX78FUQ28Accident · No injuriesClosedCessna 172F · Simi Valley, CAMay 21, 1978 · N9340H · Substantial damageNTSB OAK78FVG27Accident · No injuriesClosedCessna 177 · Vacaville, CAMay 2, 1978 · N2943X · Substantial damageNTSB LAX78DVA36Accident · No injuriesClosedPiper PA-28 · Bakersfield, CAApr 11, 1978 · N75164 · Substantial damageNTSB LAX78DVA33Accident · No injuriesClosedBeech B23 · Bakersfield, CAApr 9, 1978 · N9737L · Substantial damageNTSB OAK78DXQ16Accident · No injuriesClosedPiper PA-18 · Emigrant Gap, CAMar 30, 1978 · N9714P · Substantial damageNTSB OAK78FA023Accident · 2 fatalClosedGrumman AA-5A · Red Bluff, CAMar 21, 1978 · N9740U · DestroyedNTSB LAX78FA035Accident · 2 fatalClosedPiper PA-28 · Frazier Park, CAMar 12, 1978 · N6594W · DestroyedNTSB LAX78FA030Accident · 4 fatalClosedPiper PA-28 · Santa Susana, CAFeb 26, 1978 · N4467J · DestroyedNTSB LAX78FA026Accident · 3 fatalClosedGrum Amer AA-5A · Fontana, CAFeb 12, 1978 · N9842U · Substantial damageNTSB OAK78DVD14Accident · No injuriesClosedPiper PA-28R · San Francisco, CAJan 22, 1978 · N1302P · DestroyedNTSB LAX78FUQ11Accident · No injuriesClosedBeech B19 · Van Nuys, CAJan 20, 1978 · N18966 · 2 aircraft · Substantial damageNTSB OAK78DVG13Accident · No injuriesClosedCessna 172 · Grass Valley, CAJan 2, 1978 · N737QF · Substantial damage