NTSB investigations: Lycoming 0-320 series, 1970

393 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\") = 1970
    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 OAK71DVG33Accident · No injuriesClosedPiper PA-28 · Vacaville, CAOct 25, 1970 · N5714U · Substantial damageNTSB NYC71FFD17Accident · No injuriesClosedPiper PA-28 · Norwood, MAOct 25, 1970 · N5884U · Substantial damageNTSB MKC71FCD30Accident · No injuriesClosedPiper PA-28 · Earlham, IAOct 25, 1970 · N2500U · Substantial damageNTSB FTW71FRA24Accident · No injuriesClosedPiper PA-18 · Conroe, TXOct 25, 1970 · N3996Z · Substantial damageNTSB NYC71FGM19Accident · No injuriesClosedBeech 23 · Washington, PAOct 23, 1970 · N2328L · Substantial damageNTSB MKC71FCQ22Accident · No injuriesClosedCessna 172K · El Dorado, KSOct 23, 1970 · N7080G · Substantial damageNTSB MIA71FLD29Accident · Minor injuriesClosedCessna 172I · Daytona Beach, FLOct 21, 1970 · N46057 · Substantial damageNTSB MIA71DLD28Accident · No injuriesClosedPiper PA-28 · Melbourne, FLOct 21, 1970 · N5520F · Substantial damageNTSB CHI71DGD27Accident · No injuriesClosedPiper PA-28 · Shelby, OHOct 19, 1970 · N8182N · Substantial damageNTSB NYC71FGM17Accident · Serious injuriesClosedPiper PA-28 · Washington, PAOct 18, 1970 · N8702N · Substantial damageNTSB NYC71FFA21Accident · No injuriesClosedPiper PA-22 · Duanesburg, NYOct 18, 1970 · N2395P · Substantial damageNTSB IAD71FIJ09Accident · Minor injuriesClosedCessna 172I · Ronceverte, WVOct 18, 1970 · N35713 · Substantial damageNTSB FTW71FRG36Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXOct 18, 1970 · N4251J · Substantial damageNTSB NYC71DHD30Accident · No injuriesClosedPiper PA-23 · Bridgeton, NJOct 17, 1970 · N4476P · Substantial damageNTSB LAX71AL022Accident · No injuriesClosedPiper PA-28 · Gila Bend, AZOct 17, 1970 · N5071W · 2 aircraft · Substantial damageNTSB MIA71FKG45Accident · No injuriesClosedChampion 7GCAA · Chamblee, GAOct 16, 1970 · N9026L · Substantial damageNTSB NYC71DGM18Accident · Minor injuriesClosedCessna 172K · Russell, PAOct 14, 1970 · N79150 · Substantial damageNTSB CHI71FBQ20Accident · No injuriesClosedPitts SC · Decatur, ILOct 11, 1970 · N28K · Substantial damageNTSB LAX71DUJ32Accident · No injuriesClosedPiper PA-28 · Grnd Canyon, AZOct 10, 1970 · N8737N · Substantial damageNTSB DEN71FQA18Accident · Minor injuriesClosedPiper PA-22 · Bloomfield, NMOct 10, 1970 · N9974D · Substantial damageNTSB MIA71DKG44Accident · No injuriesClosedPiper PA-28 · St Simons Isle, GAOct 9, 1970 · N5861U · Substantial damageNTSB DEN71DXA12Accident · No injuriesClosedPiper PA-18 · Shell, WYOct 5, 1970 · N4227Z · Substantial damageNTSB DEN71DQG40Accident · No injuriesClosedPiper PA-22 · Clovis, NMOct 5, 1970 · N3946P · Substantial damageNTSB SEA71DXM12Accident · No injuriesClosedCessna 177 · American Falls, IDOct 3, 1970 · N29442 · Substantial damageNTSB MIA71DKJ22Accident · No injuriesClosedCessna 172K · Monroeville, ALOct 3, 1970 · N84684 · Substantial damageNTSB MIA71AKJ20Accident · Minor injuriesClosedPiper PA-28 · Jasper, ALSep 29, 1970 · N5763U · DestroyedNTSB ANC71DAG31Accident · No injuriesClosedPiper PA-12 · Anchorage, AKSep 29, 1970 · N2581M · Substantial damageNTSB OAK71DVM18Accident · No injuriesClosedPiper PA-18 · Bradley, CASep 28, 1970 · N4425Z · Substantial damageNTSB ANC71DAG32Accident · Minor injuriesClosedCessna 172K · Port Alswrth, AKSep 28, 1970 · N46633 · Substantial damageNTSB NYC71DHJ11Accident · Serious injuriesClosedPiper PA-28 · Farmingdale, NYSep 27, 1970 · N5430W · Substantial damageNTSB IAD71DID09Accident · Serious injuriesClosedChampion 7GCBC · Lynchburg, VASep 26, 1970 · N9040L · DestroyedNTSB CHI71FBA13Accident · No injuriesClosedPiper PA-28 · Seymour, INSep 26, 1970 · N6346W · Substantial damageNTSB SEA71FWG21Accident · No injuriesClosedCessna 172K · Moses Lake, WASep 22, 1970 · N84153 · Substantial damageNTSB LAX71DUJ25Accident · No injuriesClosedCessna 177 · Scottsdale, AZSep 22, 1970 · N3186T · Substantial damageNTSB LAX71FUQ17Accident · No injuriesClosedPiper PA-22 · Lancaster, CASep 21, 1970 · N3954P · Substantial damageNTSB NYC71FFJ12Accident · Minor injuriesClosedPiper PA-22 · Farmersville, NYSep 20, 1970 · N7037D · Substantial damageNTSB MIA71FKJ18Accident · No injuriesClosedPiper PA-28 · Birmingham, ALSep 20, 1970 · N1576J · Substantial damageNTSB CHI71FGA09Accident · No injuriesClosedCessna 172I · Harrison, OHSep 20, 1970 · N35802 · Substantial damageNTSB MIA71FKQ14Accident · Minor injuriesClosedPiper PA-22 · Quitman, MSSep 19, 1970 · N4406A · Substantial damageNTSB ANC71DAG29Accident · No injuriesClosedPiper PA-18 · Ugashik, AKSep 19, 1970 · N5743Y · Substantial damageNTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNSep 18, 1970 · N2331Q · DestroyedNTSB FTW71FPD20Accident · No injuriesClosedPiper PA-28 · Saginaw, TXSep 18, 1970 · N8197N · Substantial damageNTSB IAD71DKM14Accident · No injuriesClosedPiper PA-28 · Salisbury, NCSep 15, 1970 · N5839W · Substantial damageNTSB FTW71FPG21Accident · No injuriesClosedPiper PA-22 · N Little Rock, ARSep 14, 1970 · N7026B · Substantial damageNTSB MKC71AK015Accident · 2 fatalClosedCessna 172I · Vichy, MOSep 13, 1970 · N46223 · DestroyedNTSB DEN71FQA11Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMSep 13, 1970 · N6177W · Substantial damageNTSB DEN71DQA12Accident · No injuriesClosedPiper PA-28 · Tecolotito, NMSep 13, 1970 · N7296J · Substantial damageNTSB NYC71DFJ11Accident · No injuriesClosedPiper PA-28 · Batavia, NYSep 11, 1970 · N8773N · Substantial damageNTSB ANC71DAG44Accident · No injuriesClosedCessna 150J · Talkeetna, AKSep 9, 1970 · N60938 · Substantial damageNTSB CHI71FGD16Accident · Minor injuriesClosedPiper PA-28 · Willoughby, OHSep 7, 1970 · N5032W · Destroyed