NTSB investigations: Lycoming 0-320 series, 1968

424 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\") = 1968
    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 MIA69F0271Accident · No injuriesClosedBeech A23-19 · West Columbia, SCOct 25, 1968 · N5081T · Substantial damageNTSB FTW69D0255Accident · No injuriesClosedPiper PA-18 · El Paso, TXOct 24, 1968 · N9690D · Substantial damageNTSB MIA69F0296Accident · No injuriesClosedCessna 177 · Spartanburg, SCOct 22, 1968 · N3107T · Substantial damageNTSB MIA69D0206Accident · No injuriesClosedPiper PA-28 · Trenton, TNOct 20, 1968 · N7135R · Substantial damageNTSB LAX69D0153Accident · No injuriesClosedCessna 177 · Santa Barbara, CAOct 20, 1968 · N3390T · Substantial damageNTSB CHI69D0284Accident · No injuriesClosedBeech A23-19 · Roselle, ILOct 17, 1968 · N4787J · Substantial damageNTSB NYC69D0231Accident · No injuriesClosedPiper PA-28 · Montpelier, VTOct 16, 1968 · N6556W · Substantial damageNTSB OAK69F0156Accident · 2 fatalClosedPiper PA-28 · Mt View, HIOct 14, 1968 · N5433W · DestroyedNTSB ANC69D0071Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKOct 13, 1968 · N5142H · Substantial damageNTSB FTW69F0260Accident · No injuriesClosedPiper PA-25 · Woodrow, TXOct 12, 1968 · N6280Z · Substantial damageNTSB FTW69D0261Accident · No injuriesClosedPiper PA-22 · Perryton, TXOct 12, 1968 · N1749P · Substantial damageNTSB CHI69D0314Accident · No injuriesClosedCessna 177 · So.Branch, MIOct 12, 1968 · N2972X · Substantial damageNTSB MKC69D0217Accident · No injuriesClosedPiper PA-22 · Salina, KSOct 7, 1968 · N9247D · Substantial damageNTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJOct 6, 1968 · N1870J · 2 aircraft · Substantial damageNTSB FTW69F0219Accident · No injuriesClosedBeech A23 · Groom, TXOct 6, 1968 · N6970Q · Substantial damageNTSB CHI69D0268Accident · No injuriesClosedPiper PA-22 · Salem, MIOct 5, 1968 · N2343P · Substantial damageNTSB ANC69D0075Accident · No injuriesClosedPiper PA-18 · Anchorage, AKOct 5, 1968 · N1755P · Substantial damageNTSB DEN69D0106Accident · No injuriesClosedPiper PA-28 · Rangely, COOct 3, 1968 · N9639W · Substantial damageNTSB DEN69D0134Accident · No injuriesClosedPiper PA-18 · Gillette, WYSep 30, 1968 · N7573K · Substantial damageNTSB DIA69F0085Accident · No injuriesClosedPiper PA-22 · Cumberland, MDSep 29, 1968 · N8816D · Substantial damageNTSB CHI69F0299Accident · No injuriesClosedCessna 177 · Xenia, OHSep 27, 1968 · N2910X · Substantial damageNTSB ANC69F0060Accident · No injuriesClosedPiper PA-14 · Talkeetna, AKSep 22, 1968 · N5116H · Substantial damageNTSB CHI69D0308Accident · No injuriesClosedPiper PA-28 · Albion, WISep 21, 1968 · N6114W · Substantial damageNTSB ANC69F0068Accident · Minor injuriesClosedPiper PA-22 · Mcgrath, AKSep 20, 1968 · N3319Z · Substantial damageNTSB NYC69A0037Accident · No injuriesClosedPiper PA-28 · Lincoln, RISep 19, 1968 · N6690J · 2 aircraft · Minor damageNTSB DEN69F0117Accident · Serious injuriesClosedPiper PA-28 · Grnd Jnction, COSep 19, 1968 · N6962W · Substantial damageNTSB MIA69D0176Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLSep 18, 1968 · N2251P · Substantial damageNTSB DEN69A0012Accident · 1 fatalClosedInterstate S-1A · Bitter Creek, WYSep 16, 1968 · N37455 · 2 aircraft · DestroyedNTSB CHI69F0327Accident · Minor injuriesClosedPiper PA-28 · Dowagiac, MISep 16, 1968 · N7371J · Substantial damageNTSB ANC69D0074Accident · No injuriesClosedPiper PA-18 · Montague Isl, AKSep 16, 1968 · N3910Z · Substantial damageNTSB OAK69D0135Accident · No injuriesClosedBeech A23-19 · Concord, CASep 14, 1968 · N7909L · Substantial damageNTSB FTW69D0186Accident · Minor injuriesClosedPiper PA-28 · Stigler, OKSep 11, 1968 · N5066W · Substantial damageNTSB OAK69D0116Accident · No injuriesClosedPiper PA-28 · Battle Mtn., NVSep 10, 1968 · N8485R · Substantial damageNTSB NYC69F0169Accident · No injuriesClosedCessna 177 · Kutztown, PASep 8, 1968 · N3238T · Substantial damageNTSB MKC69D0176Accident · No injuriesClosedCessna 172 · Walker, MNSep 8, 1968 · N35519 · Substantial damageNTSB FTW69F0191Accident · 1 fatalClosedPiper PA-25 · Presidio, TXSep 7, 1968 · N6271Z · DestroyedNTSB MKC69D0209Accident · No injuriesClosedCessna 177 · Milford, NESep 6, 1968 · N29462 · Substantial damageNTSB CHI69F0200Accident · No injuriesClosedPiper PA-28 · Cincinnati, OHSep 5, 1968 · N7258J · Substantial damageNTSB MKC69D0170Accident · No injuriesClosedCessna 177 · Eagle Grove, IASep 4, 1968 · N3483T · Substantial damageNTSB MIA69D0145Accident · No injuriesClosedPiper PA-28 · West Palm Bch, FLSep 3, 1968 · N6914W · Substantial damageNTSB FTW69F0183Accident · No injuriesClosedPiper PA-28 · Esperanza, TXSep 3, 1968 · N1517J · Substantial damageNTSB MIA69F0190Accident · No injuriesClosedBeech 23 · Hartsville, SCSep 2, 1968 · N2394J · Substantial damageNTSB CHI69F0207Accident · No injuriesClosedCessna 177 · Detroit, MISep 2, 1968 · N2940X · Substantial damageNTSB MKC69F0227Accident · No injuriesClosedBeech B23 · Pequot Lakes, MNAug 31, 1968 · N2388Q · Substantial damageNTSB MKC69D0195Accident · No injuriesClosedCessna 177 · Waukon, IAAug 31, 1968 · N2260Y · Substantial damageNTSB MIA69F0319Accident · Minor injuriesClosedPiper PA-28 · Blackville, SCAug 31, 1968 · N5516W · Substantial damageNTSB MIA69D0289Accident · No injuriesClosedPiper PA-28 · Hernando, FLAug 31, 1968 · N5749W · Substantial damageNTSB CHI69F0220Accident · No injuriesClosedPiper PA-22 · Mecosta, MIAug 31, 1968 · N6939B · Substantial damageNTSB SEA69F0109Accident · No injuriesClosedPiper PA-14 · Silverdale, WAAug 30, 1968 · N4296H · Substantial damageNTSB CHI69D0286Accident · No injuriesClosedPiper PA-28 · No.Kingsvlle, OHAug 30, 1968 · N7223J · Substantial damage