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

41 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, 1968, 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\") = 1968
    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 OAK69D0205Accident · No injuriesClosedPiper PA-28 · S Lake Tahoe, CANov 27, 1968 · N4337J · Substantial damageNTSB LAX69D0188Accident · Minor injuriesClosedPiper PA-22 · Bermuda Dunes, CANov 24, 1968 · N9616D · Substantial damageNTSB LAX69F0167Accident · No injuriesClosedPiper PA-28 · Torrance, CANov 7, 1968 · N1599J · Substantial damageNTSB OAK69D0186Accident · No injuriesClosedPiper PA-23 · Morgan Hill, CANov 5, 1968 · N1152P · Substantial damageNTSB OAK69D0166Accident · No injuriesClosedPiper PA-22 · Ukiah, CAOct 27, 1968 · N2824Z · Substantial damageNTSB LAX69D0153Accident · No injuriesClosedCessna 177 · Santa Barbara, CAOct 20, 1968 · N3390T · Substantial damageNTSB OAK69D0135Accident · No injuriesClosedBeech A23-19 · Concord, CASep 14, 1968 · N7909L · Substantial damageNTSB LAX69F0082Accident · Minor injuriesClosedPiper PA-28 · Calexico, CAAug 15, 1968 · N6853W · Substantial damageNTSB LAX69F0068Accident · No injuriesClosedPiper PA-28 · Upland, CAAug 9, 1968 · N7264J · Substantial damageNTSB OAK69D0063Accident · No injuriesClosedPiper PA-28 · Novato, CAJul 27, 1968 · N5418W · Substantial damageNTSB LAX69D0052Accident · No injuriesClosedPiper PA-22 · Eagle Mtn, CAJul 17, 1968 · N7042B · Substantial damageNTSB LAX69F0134Accident · Minor injuriesClosedPiper PA-28 · Huntgton Bch, CAJul 15, 1968 · N4443J · Substantial damageNTSB OAK69D0041Accident · No injuriesClosedBeech A-23 · San Carlos, CAJul 3, 1968 · N3640Q · Substantial damageNTSB OAK69F0006Accident · No injuriesClosedPiper PA-18 · Dutch Flat, CAJun 24, 1968 · N2404P · Substantial damageNTSB OAK69D0024Accident · No injuriesClosedPiper PA-22 · Petaluma, CAJun 23, 1968 · N3023Z · Substantial damageNTSB OAK68A0072Accident · 4 fatalClosedCessna 177 · Bass Lake, CAJun 14, 1968 · N2914X · DestroyedNTSB LAX69F0015Accident · No injuriesClosedBeech A23 · Van Nuys, CAJun 12, 1968 · N6905Q · Substantial damageNTSB OAK69F0097Accident · No injuriesClosedBeech A23-19 · Beckwourth, CAMay 26, 1968 · N6901Q · Substantial damageNTSB OAK69D0018Accident · No injuriesClosedPiper PA-28 · Los Banos, CAMay 25, 1968 · N6105W · Substantial damageNTSB LAX68F0423Accident · No injuriesClosedPiper PA-16 · Long Beach, CAMay 19, 1968 · N5348H · Substantial damageNTSB LAX69D0007Accident · No injuriesClosedPiper PA-28 · Bakersfield, CAMay 12, 1968 · N6702W · Substantial damageNTSB LAX68D0409Accident · No injuriesClosedPiper PA-28 · Holtville, CAMay 9, 1968 · N6853W · Substantial damageNTSB OAK68D0373Accident · No injuriesClosedPiper PA-28 · Concord, CAMay 3, 1968 · N9986W · Substantial damageNTSB OAK69D0005Accident · No injuriesClosedCessna 177 · Fair Oaks, CAMay 2, 1968 · N2266Y · Substantial damageNTSB OAK68D0371Accident · No injuriesClosedCessna 177 · Santa Cruz, CAApr 26, 1968 · N3450T · Substantial damageNTSB OAK68D0362Accident · No injuriesClosedPiper PA-28 · San Carlos, CAApr 24, 1968 · N6325R · Substantial damageNTSB LAX68D0394Accident · Minor injuriesClosedPiper PA-18 · Tehachapi, CAApr 18, 1968 · N9470D · DestroyedNTSB OAK68D0364Accident · No injuriesClosedCessna 177 · Modesto, CAApr 9, 1968 · N3270T · Substantial damageNTSB LAX68F0401Accident · No injuriesClosedPiper PA-23 · Long Beach, CAApr 6, 1968 · N4106P · Substantial damageNTSB LAX68D0349Accident · No injuriesClosedCessna 150 · Compton, CAMar 30, 1968 · N8916S · Substantial damageNTSB OAK68D0339Accident · Minor injuriesClosedPiper PA-18 · Palo Alto, CAMar 29, 1968 · N4337Z · Substantial damageNTSB OAK68D0342Accident · No injuriesClosedPiper PA-18 · Byron, CAMar 23, 1968 · N4198Z · Substantial damageNTSB LAX68D0368Accident · No injuriesClosedBeech A23 · Gaviota, CAMar 6, 1968 · N5968S · Substantial damageNTSB OAK68D0311Accident · No injuriesClosedCessna 177 · Vernalis, CAMar 3, 1968 · N3397T · Substantial damageNTSB LAX68A0074Accident · 2 fatalClosedCessna 177 · Ocotillo Well, CAFeb 18, 1968 · N2264Y · DestroyedNTSB OAK68D0292Accident · No injuriesClosedPiper PA-28 · Santa Cruz, CAFeb 10, 1968 · N6873W · Substantial damageNTSB OAK68D0294Accident · No injuriesClosedCessna 177 · Waterford, CAFeb 6, 1968 · N3316T · Substantial damageNTSB LAX68F0316Accident · Minor injuriesClosedCessna 177 · Imperial Bch, CAFeb 4, 1968 · N2355Y · Substantial damageNTSB OAK68D0273Accident · Minor injuriesClosedPiper PA-22 · Visalia, CAJan 21, 1968 · N3064Z · Substantial damageNTSB OAK68D0319Accident · No injuriesClosedChampion 7GCBC · Hilt, CAJan 14, 1968 · N8341V · Substantial damageNTSB LAX68D0320Accident · Serious injuriesClosedPiper PA-28 · Baker, CAJan 6, 1968 · N5765W · Substantial damage