NTSB investigations: Lycoming 0-320 series, 1964

302 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\") = 1964
    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 UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALOct 25, 1964 · N6212W · Substantial damageNTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WAOct 25, 1964 · N6241W · Substantial damageNTSB UNK65X0405Accident · No injuriesClosedPiper PA28 · Beckenridge, TXOct 24, 1964 · N5768W · Substantial damageNTSB UNK65X0372Accident · No injuriesClosedPiper PA23 · Laporte, TXOct 22, 1964 · N1119P · Substantial damageNTSB UNK65X0366Accident · No injuriesClosedPiper PA28 · Oahu, HIOct 22, 1964 · N6007W · Substantial damageNTSB UNK65X0303Accident · No injuriesClosedPiper PA22 · Kennett, MOOct 17, 1964 · N9317D · Substantial damageNTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, ALOct 16, 1964 · N6021W · Substantial damageNTSB UNK65X0278Accident · No injuriesClosedBeechcraft 23 · Cleveland, OHOct 14, 1964 · N2386J · Substantial damageNTSB UNK65X0262Accident · No injuriesClosedPiper PA28 · Long Beach, CAOct 13, 1964 · N6134W · Substantial damageNTSB UNK65X0198Accident · No injuriesClosedPiper PA18A · Socorro, NMOct 8, 1964 · N9271D · Substantial damageNTSB UNK65X0192Accident · No injuriesClosedPiper PA28 · Adams, NYOct 8, 1964 · N6060W · Substantial damageNTSB UNK65X0175Accident · No injuriesClosedPiper PA22 · Plymouth, MIOct 7, 1964 · N7412D · Substantial damageNTSB UNK65X0144Accident · No injuriesClosedPiper PA28 · Lumberton, NJOct 4, 1964 · N6135W · Substantial damageNTSB UNK65X0125Accident · No injuriesClosedPiper PA22 · Fresno, CAOct 3, 1964 · N3730P · Substantial damageNTSB UNK65X0105Accident · No injuriesClosedPiper PA22 · Beckwourth, CAOct 1, 1964 · N1740P · Substantial damageNTSB UNK64X4219Accident · No injuriesClosedPiper PA22 · Kissimmee, FLSep 30, 1964 · N3762P · Substantial damageNTSB UNK64X4193Accident · No injuriesClosedPiper PA22 · Council Bluff, IASep 28, 1964 · N3664P · Substantial damageNTSB UNK64X4174Accident · No injuriesClosedPiper PA22 · Alameda, NMSep 27, 1964 · N9994D · Substantial damageNTSB UNK64X4074Accident · No injuriesClosedPiper PA22 · Chico, CASep 20, 1964 · N2335P · Substantial damageNTSB UNK64X4061Accident · No injuriesClosedPiper PA22 · Sparks, NVSep 20, 1964 · N7144D · Substantial damageNTSB UNK64X4015Accident · No injuriesClosedPiper PA22 · Blawnox, PASep 17, 1964 · N7032B · Substantial damageNTSB UNK64X4002Accident · Minor injuriesClosedBeechcraft M23 · Tacoma, WASep 16, 1964 · N8706M · DestroyedNTSB UNK64X3993Accident · No injuriesClosedPiper PA22 · Gaylord, MNSep 15, 1964 · N3265Z · Substantial damageNTSB UNK64X3988Accident · No injuriesClosedBeechcraft 23 · Ogallala, NESep 14, 1964 · N2377Q · Substantial damageNTSB UNK64X3972Accident · No injuriesClosedPiper PA28 · Roselle, ILSep 13, 1964 · N5085W · Substantial damageNTSB UNK64X3961Accident · No injuriesClosedPiper PA28 · Woolstock, IASep 13, 1964 · N5286W · Substantial damageNTSB UNK64X3944Accident · No injuriesClosedPiper PA23 · Broomfield, COSep 12, 1964 · N2050P · Substantial damageNTSB UNK64X3939Accident · No injuriesClosedPiper PA22 · Endicott, NYSep 12, 1964 · N4353A · DestroyedNTSB UNK64X3938Accident · No injuriesClosedPiper PA22 · Kremlin, MTSep 12, 1964 · N303F · Substantial damageNTSB UNK64X3929Accident · 1 fatalClosedPiper PA-25 · Hereford, TXSep 12, 1964 · N6481Z · DestroyedNTSB UNK64X3915Accident · Minor injuriesClosedPiper PA28 · Martinsburg, PASep 11, 1964 · N5166W · Substantial damageNTSB UNK64X3911Accident · Minor injuriesClosedPiper PA22 · Chistochina, AKSep 11, 1964 · N7850D · Substantial damageNTSB UNK64X3906Accident · Serious injuriesClosedPiper PA25 · Mclean, TXSep 10, 1964 · N6477Z · DestroyedNTSB UNK64X3859Accident · Minor injuriesClosedPiper PA18 · Highlake, AKSep 7, 1964 · N7360D · Substantial damageNTSB UNK64X3819Accident · No injuriesClosedPiper PA28 · Houston, TXSep 6, 1964 · N5151W · Substantial damageNTSB UNK64X3816Accident · Minor injuriesClosedPiper PA22 · Patten, MESep 6, 1964 · N8858D · Substantial damageNTSB UNK64X3788Accident · No injuriesClosedPiper PA22 · Southport, NCSep 5, 1964 · N9766D · Substantial damageNTSB UNK64X3781Accident · Serious injuriesClosedBeechcraft 23 · Tracy, CASep 4, 1964 · N2354L · DestroyedNTSB UNK64X3770Accident · No injuriesClosedPiper PA12 · Gulkana, AKSep 4, 1964 · N3569M · Substantial damageNTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GASep 4, 1964 · N7294D · Substantial damageNTSB UNK64X3757Accident · Minor injuriesClosedPiper PA18A · Midnight, MSSep 3, 1964 · N8992D · DestroyedNTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNAug 31, 1964 · N6276Z · Substantial damageNTSB UNK64X3701Accident · No injuriesClosedPiper PA18 · Hendry County, FLAug 31, 1964 · N3932Z · Substantial damageNTSB UNK64X3674Accident · No injuriesClosedBeechcraft M23 · Milan, ILAug 29, 1964 · N8748M · Substantial damageNTSB UNK64X3673Accident · No injuriesClosedPiper PA28 · Laurel, MSAug 29, 1964 · N5357W · Substantial damageNTSB UNK64X3642Accident · No injuriesClosedPiper PA28 · Madison, CTAug 28, 1964 · N5391W · Substantial damageNTSB UNK64X3628Accident · No injuriesClosedBeechcraft M23 · Liberal, KSAug 27, 1964 · N2303Q · Substantial damageNTSB UNK64X3575Accident · No injuriesClosedPiper PA12 · Plymouth, MIAug 24, 1964 · N3719M · Substantial damageNTSB UNK64X3541Accident · Minor injuriesClosedCallair A5 · Camillia, GAAug 22, 1964 · N9970C · DestroyedNTSB UNK64X3513Accident · No injuriesClosedPiper PA22 · Sheffield, TXAug 21, 1964 · N8019D · Substantial damage