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

32 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, 1979, 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\") = 1979
    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 LAX80FUA06Accident · No injuriesClosedPiper PA-22 · Dana Point, CADec 25, 1979 · N3328Z · Substantial damageNTSB LAX80FUA05Accident · Serious injuriesClosedPiper PA-28 · Avalon, CADec 10, 1979 · N8432C · DestroyedNTSB LAX80FUG11Accident · Serious injuriesClosedCessna 172N · La Verne, CADec 7, 1979 · N739JX · Minor damageNTSB LAX80FVD0OAccident · No injuriesClosedBellanca 7GCBC · Fremont, CANov 25, 1979 · N5518K · Substantial damageNTSB LAX80DXQ01Accident · No injuriesClosedCessna 172N · Truckee, CAOct 31, 1979 · N75844 · Substantial damageNTSB LAX80DVM04Accident · Minor injuriesClosedPiper PA-18 · San Jose, CAOct 31, 1979 · N2370H · Substantial damageNTSB LAX80FUA02Accident · No injuriesClosedPiper PA-28 · Huntington Bch, CAOct 29, 1979 · N15969 · Substantial damageNTSB LAX79FUQ44Accident · Serious injuriesClosedPiper PA-28 · Frazier Park, CASep 9, 1979 · N5207T · Substantial damageNTSB LAX79FVG75Accident · Serious injuriesClosedPiper PA-28 · Rio Linda, CAAug 30, 1979 · N5559W · DestroyedNTSB LAX80DXQ09Accident · No injuriesClosedCessna 172 · Mammoth Lakes, CAAug 15, 1979 · N739ZE · Substantial damageNTSB LAX79DA063Accident · No injuriesClosedCessna 172N · Santa Ana, CAJul 21, 1979 · N738VC · Substantial damageNTSB OAK79DVG63Accident · No injuriesClosedCessna 172M · Lower Lake, CAJul 17, 1979 · N70376 · Substantial damageNTSB LAX79FXQ22Accident · Minor injuriesClosedPiper PA-18 · Sierraville, CAJul 16, 1979 · N2404P · Substantial damageNTSB LAX79FUM21Accident · Minor injuriesClosedPiper PA-28 · Chula Vista, CAJul 7, 1979 · N4374J · Substantial damageNTSB OAK79FVD34Accident · No injuriesClosedCessna 172K · Livermore, CAJun 30, 1979 · N7134G · Substantial damageNTSB LAX79DUQ36Accident · No injuriesClosedBeech 19 · Santa Barbara, CAJun 21, 1979 · N4344W · Substantial damageNTSB LAX79FUG47Accident · No injuriesClosedPiper PA-28 · Big Bear, CAJun 16, 1979 · N1115X · DestroyedNTSB LAX79FA059Accident · 4 fatalClosedCessna 177 · Long Beach, CAJun 9, 1979 · N29482 · DestroyedNTSB OAK79FVM26Accident · No injuriesClosedPiper PA-28 · San Carlos, CAJun 6, 1979 · N5965F · DestroyedNTSB LAX79FUG44Accident · No injuriesClosedPiper PA-23 · Riverside, CAJun 3, 1979 · N3407P · Substantial damageNTSB OAK79DVG47Accident · No injuriesClosedCessna 172 · Chico, CAJun 1, 1979 · N13585 · Substantial damageNTSB OAK79DVG44Accident · No injuriesClosedPiper PA-28 · Zenia, CAMay 27, 1979 · N8200N · Substantial damageNTSB LAX79FA053Accident · 2 fatalClosedPiper PA-28 · Long Beach, CAMay 14, 1979 · N2383T · DestroyedNTSB LAX79DUG41Accident · No injuriesClosedCessna 172M · Giant Rock, CAMay 13, 1979 · N20092 · Substantial damageNTSB LAX79DUG36Accident · No injuriesClosedCessna 172N · Murrieta, CAMay 10, 1979 · N737CL · Substantial damageNTSB LAX79FUG32Accident · No injuriesClosedPiper PA-18A · Lake Elsinore, CAApr 25, 1979 · N8581D · Substantial damageNTSB LAX79FUQ23Accident · No injuriesClosedCessna 172 · Lompoc, CAMar 31, 1979 · N1466U · Substantial damageNTSB OAK79DVM16Accident · No injuriesClosedBellanca 7GCBC · Hollister, CAMar 25, 1979 · N8649V · Substantial damageNTSB LAX79DUG24Accident · No injuriesClosedMustang TWO · Yucca Valley, CAMar 25, 1979 · N22880 · Substantial damageNTSB LAX79FA031Accident · 3 fatalClosedCessna 172 · Mt Baldy, CAFeb 19, 1979 · N1527V · DestroyedNTSB LAX79FUQ18Accident · No injuriesClosedPiper PA-28 · Van Nuys, CAFeb 14, 1979 · N44590 · Substantial damageNTSB OAK79FA015Accident · 1 fatalClosedPiper PA-28 · Porterville, CAJan 11, 1979 · N6970F · Destroyed