NTSB investigations: Lycoming 0-320 series, 1972

335 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\") = 1972
    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 CHI73FEI15Accident · No injuriesClosedCessna 172 · Medina, OHOct 8, 1972 · N7805G · Substantial damageNTSB SEA73DYI05Accident · No injuriesClosedAero Comdr 100 · Burns, OROct 7, 1972 · N4115X · Substantial damageNTSB MKC73FER25Accident · No injuriesClosedPiper PA-28 · Duluth, MNOct 7, 1972 · N4486J · Substantial damageNTSB NYC73FGT04Accident · No injuriesClosedPiper PA-23 · Carlisle, PAOct 5, 1972 · N2236P · Substantial damageNTSB LAX73AL019Accident · 1 fatalClosedCessna 172K · Missing AircraftOct 3, 1972 · N7369G · DestroyedNTSB CHI73FEM19Accident · No injuriesClosedAero Comdr 100 · Greenville, MIOct 2, 1972 · N3898X · Substantial damageNTSB MIA73DKJ26Accident · No injuriesClosedAero Comdr 100 · Slocomb, ALOct 1, 1972 · N3650X · Substantial damageNTSB CHI73DEG08Accident · Minor injuriesClosedPiper PA-22 · Mt Sterling, OHOct 1, 1972 · N1715P · Substantial damageNTSB CHI73FEC10Accident · No injuriesClosedPiper PA-22 · Sebewaing, MISep 30, 1972 · N3338Z · Substantial damageNTSB OAK73DVG22Accident · No injuriesClosedCessna 172 · Vacaville, CASep 29, 1972 · N3854Q · Substantial damageNTSB CHI73FEC11Accident · Minor injuriesClosedCessna 172 · Clinton, MISep 29, 1972 · N46567 · Substantial damageNTSB LAX73DUG19Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CASep 28, 1972 · N1163C · Substantial damageNTSB DEN73DQG19Accident · No injuriesClosedPiper PA-23 · Humble City, NMSep 28, 1972 · N4358P · Substantial damageNTSB CHI73FEC09Accident · No injuriesClosedAero Comdr 100 · Laingsburg, MISep 28, 1972 · N2951T · Substantial damageNTSB NYC73DKM13Accident · No injuriesClosedCessna 172 · Maiden, NCSep 27, 1972 · N7163Q · Substantial damageNTSB DEN73DTC09Accident · No injuriesClosedPiper PA-18 · Kaycee, WYSep 26, 1972 · N3086Z · Substantial damageNTSB LAX73FUM06Accident · No injuriesClosedPiper PA-23 · San Diego, CASep 23, 1972 · N156M · Substantial damageNTSB NYC73DFJ10Accident · No injuriesClosedPiper PA-22 · Wolcott, NYSep 20, 1972 · N3840P · Substantial damageNTSB CHI73FEK06Accident · No injuriesClosedPiper PA-28 · Gahanna, OHSep 20, 1972 · N95111 · Substantial damageNTSB SEA73FYC10Accident · No injuriesClosedPiper PA-28 · Portland, ORSep 18, 1972 · N8490R · Substantial damageNTSB MIA73FKG37Accident · Minor injuriesClosedPiper PA-28 · Kennesaw, GASep 17, 1972 · N5096T · 2 aircraft · Substantial damageNTSB CHI73DEG05Accident · No injuriesClosedPiper PA-28 · Proctorville, OHSep 17, 1972 · N1828T · Substantial damageNTSB NYC73FFA15Accident · No injuriesClosedBeech A23 · Albany, NYSep 16, 1972 · N7980L · Substantial damageNTSB NYC73DKM10Accident · Minor injuriesClosedPiper PA-28 · Murphy, NCSep 16, 1972 · N7225F · DestroyedNTSB MIA73DLG20Accident · No injuriesClosedPiper PA-28 · Johns Island, SCSep 15, 1972 · N4825T · Substantial damageNTSB CHI73FEM17Accident · No injuriesClosedCessna 177 · Grand Rapids, MISep 15, 1972 · N2396Y · Substantial damageNTSB OAK73FJA06Accident · No injuriesClosedChampion 7GCBC · Dillng Afb, HISep 14, 1972 · N8341V · Substantial damageNTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WISep 14, 1972 · N2348L · DestroyedNTSB OAK73DVD13Accident · Minor injuriesClosedPitts Spec S-1C · Tracey, CASep 13, 1972 · N8L · Substantial damageNTSB MIA73FLA17Accident · No injuriesClosedPiper PA-28 · Defuniak Spgs, FLSep 13, 1972 · N4421T · Substantial damageNTSB MIA73FKJ22Accident · Serious injuriesClosedPiper PA-22 · Ashland, ALSep 13, 1972 · N2514P · Substantial damageNTSB MIA73DLD15Accident · No injuriesClosedPiper PA-28 · Seminole, FLSep 12, 1972 · N9866W · Substantial damageNTSB ANC73DAD02Accident · No injuriesClosedPiper PA-18 · Haines, AKSep 11, 1972 · N4473Z · Substantial damageNTSB DEN73FTE26Accident · Minor injuriesClosedPiper PA-28 · Littleton, COSep 10, 1972 · N5821U · DestroyedNTSB ANC73FAG42Accident · Serious injuriesClosedPiper PA-18 · Gakona, AKSep 8, 1972 · N3097Z · Substantial damageNTSB FTW73FRA10Accident · No injuriesClosedPiper PA-28 · Friendswood, TXSep 7, 1972 · N6380R · Substantial damageNTSB LAX73OL002Accident · No injuriesClosedPiper PA-28 · Culiacan, MexicoSep 6, 1972 · N5752U · Substantial damageNTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CASep 6, 1972 · N4166M · Substantial damageNTSB FTW73FRJ13Accident · No injuriesClosedCessna 172L · Garrison, TXSep 6, 1972 · N19719 · Substantial damageNTSB SEA73FYC04Accident · No injuriesClosedPiper PA-22 · Mcminville, ORSep 4, 1972 · N6157D · Substantial damageNTSB CHI73FER04Accident · No injuriesClosedPitts SPL S1C · Osceola, WISep 4, 1972 · N51AC · Substantial damageNTSB ANC73DAG39Accident · No injuriesClosedPiper PA-18 · Glenallen, AKSep 4, 1972 · N4302Z · Substantial damageNTSB CHI73FEE22Accident · Minor injuriesClosedPiper PA-28 · Rockford, ILSep 3, 1972 · N5677U · Substantial damageNTSB CHI73DEP19Accident · No injuriesClosedPiper PA-28 · Endeavor, WISep 3, 1972 · N6218W · Substantial damageNTSB NYC73FHM10Accident · No injuriesClosedPiper PA-28 · East Hanover, NJSep 2, 1972 · N5318T · Substantial damageNTSB ANC73DAG28Accident · No injuriesClosedPiper PA-18A · Skwentna, AKSep 2, 1972 · N2666P · Substantial damageNTSB FTW73FQD08Accident · Serious injuriesClosedPiper PA-18 · Canutillo, TXSep 1, 1972 · N4335Z · Substantial damageNTSB NYC73FFJ05Accident · Minor injuriesClosedPiper PA-28 · Weedsport, NYAug 27, 1972 · N659FL · Substantial damageNTSB NYC73DID07Accident · No injuriesClosedPiper PA-28 · Chesapeake, VAAug 27, 1972 · N5578U · Substantial damageNTSB ANC73DAG22Accident · No injuriesClosedPiper PA-18 · Skwetna, AKAug 27, 1972 · N6644Z · Substantial damage