NTSB investigations: Lycoming 0-320 series, 1966

427 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, newest first

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\") = 1966
    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 OAK67F0152Accident · No injuriesClosedPiper PA-28 · Honolulu, HINov 7, 1966 · N6649W · Substantial damageNTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNov 3, 1966 · N3957Z · Substantial damageNTSB MKC67D0312Accident · No injuriesClosedBeech A23 · Garden City, KSNov 3, 1966 · N7912L · Substantial damageNTSB MKC67F0298Accident · No injuriesClosedPiper PA-28 · Lincoln, NENov 2, 1966 · N6913W · Substantial damageNTSB CHI67D0341Accident · No injuriesClosedPiper PA-23 · Racine, WIOct 30, 1966 · N2150P · Substantial damageNTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJOct 29, 1966 · N4306Y · Substantial damageNTSB DIA67D0008Accident · No injuriesClosedMorrisey 2150A · New Castle, VAOct 29, 1966 · N5142V · Substantial damageNTSB SEA67F0170Accident · No injuriesClosedPiper PA-18 · Weiser, IDOct 28, 1966 · N4395A · Substantial damageNTSB MKC67F0270Accident · Minor injuriesClosedPiper PA-18 · Eli, NEOct 26, 1966 · N3236P · Substantial damageNTSB MKC67F0266Accident · No injuriesClosedPiper PA22 · Lisbon, NDOct 26, 1966 · N2306P · Substantial damageNTSB FTW67D0368Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXOct 26, 1966 · N6932W · Substantial damageNTSB MKC67D0331Accident · No injuriesClosedMooney M20 · Ottawa, KSOct 25, 1966 · N5252B · Substantial damageNTSB CHI67F0314Accident · No injuriesClosedPiper PA28 · Troy, MIOct 25, 1966 · N7495R · Substantial damageNTSB CHI67D0357Accident · No injuriesClosedPiper PA-28 · Logansport, INOct 25, 1966 · N4563R · Substantial damageNTSB NYC67D0321Accident · No injuriesClosedPiper PA-28 · Milford, NHOct 23, 1966 · N7581W · Substantial damageNTSB MKC67F0296Accident · No injuriesClosedPiper PA-28 · St.Charles, MOOct 23, 1966 · N7040R · Substantial damageNTSB SEA66D0166Accident · No injuriesClosedPiper PA-25 · Pasco, WAOct 22, 1966 · N6049Z · Substantial damageNTSB OAK67D0145Accident · No injuriesClosedPiper PA-22 · Milpitas, CAOct 22, 1966 · N2476P · Substantial damageNTSB MKC67F0300Accident · No injuriesClosedBeech 23 · Burden, KSOct 22, 1966 · N2302Z · Substantial damageNTSB CHI67F0327Accident · No injuriesClosedPiper PA-28 · Delafield, WIOct 22, 1966 · N5582W · Substantial damageNTSB ANC67D0059Accident · No injuriesClosedPiper PA-18 · Aleknagik, AKOct 22, 1966 · N5988Z · Substantial damageNTSB OAK67D0222Accident · No injuriesClosedChampion 7GCAA · Petaluma, CAOct 20, 1966 · N9533S · Substantial damageNTSB MIA67F0257Accident · No injuriesClosedPiper PA-28 · Miami, FLOct 18, 1966 · N7599R · Substantial damageNTSB SEA67D0186Accident · No injuriesClosedPiper PA-28 · Billings, MTOct 17, 1966 · N6991W · Substantial damageNTSB OAK67F0132Accident · No injuriesClosedPiper PA-28 · Fresno, CAOct 16, 1966 · N6471W · Substantial damageNTSB MKC67D0255Accident · No injuriesClosedPiper PA-22 · De Witt, IAOct 16, 1966 · N4744A · Substantial damageNTSB LAX67F0148Accident · No injuriesClosedPiper PA-28 · Santa Ana, CAOct 14, 1966 · N6421W · Substantial damageNTSB SEA67D0145Accident · No injuriesClosedPiper PA-18 · Coulee City, WAOct 11, 1966 · N1883P · Substantial damageNTSB CHI67F0269Accident · No injuriesClosedPiper PA-28 · Sycamore, ILOct 11, 1966 · N5103W · Substantial damageNTSB MIA67F0187Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNOct 10, 1966 · N6070W · Substantial damageNTSB NYC67D0334Accident · No injuriesClosedBeech A23-19 · New Castle, DEOct 9, 1966 · N5988S · Substantial damageNTSB MKC67D0252Accident · No injuriesClosedBeech A23-19 · St.Joseph, MOOct 9, 1966 · N7913L · Substantial damageNTSB NYC67F0297Accident · No injuriesClosedPiper PA-28 · Ocean City, NJOct 8, 1966 · N5339W · Substantial damageNTSB NYC67D0269Accident · No injuriesClosedPiper PA-28 · College Park, MDOct 8, 1966 · N6453R · Substantial damageNTSB MIA67F0285Accident · No injuriesClosedPiper PA-18A · Jay, FLOct 8, 1966 · N1493C · Substantial damageNTSB CHI67D0255Accident · No injuriesClosedPiper PA-28 · Vandalia, OHOct 8, 1966 · N7158R · Substantial damageNTSB CHI67D0345Accident · No injuriesClosedPiper PA-28 · Stow, OHOct 6, 1966 · N6904W · Substantial damageNTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYOct 5, 1966 · N4751A · Substantial damageNTSB MKC67F0245Accident · No injuriesClosedPiper PA-28 · Dodge City, KSOct 4, 1966 · N6294W · Substantial damageNTSB CHI67F0204Accident · Minor injuriesClosedPiper PA-28 · Columbus, OHOct 4, 1966 · N6314R · Substantial damageNTSB MKC67D0225Accident · No injuriesClosedPiper PA-22 · Lebanon, IAOct 2, 1966 · N6166D · Substantial damageNTSB DEN67F0175Accident · No injuriesClosedPiper PA-22 · Greeley, COSep 30, 1966 · N7614D · Substantial damageNTSB CHI67F0198Accident · No injuriesClosedPiper PA-28 · Adrian, MISep 28, 1966 · N4590R · Substantial damageNTSB OAK67D0167Accident · No injuriesClosedPiper PA-23 · Reno, NVSep 27, 1966 · N1368P · Substantial damageNTSB NYC67D0272Accident · No injuriesClosedPiper PA-28 · Plainville, CTSep 25, 1966 · N5674W · Substantial damageNTSB CHI67D0338Accident · No injuriesClosedPiper PA-28 · Medina, OHSep 25, 1966 · N5320W · Substantial damageNTSB NYC67F0251Accident · Minor injuriesClosedAeronca 7GCA · Warwick, NJSep 24, 1966 · N11088 · Substantial damageNTSB OAK67F0105Accident · No injuriesClosedPiper PA-23 · Honolulu, HISep 23, 1966 · N2060P · Substantial damageNTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTSep 20, 1966 · N5182W · DestroyedNTSB LAX67D0122Accident · No injuriesClosedPiper PA-28 · Acton, CASep 17, 1966 · N6852W · Substantial damage