NTSB investigations: Lycoming 0-320 series, 1971

396 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\") = 1971
    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 MIA72FLA13Accident · No injuriesClosedPiper PA-28 · Hastings, FLOct 11, 1971 · N3713K · Substantial damageNTSB SEA72DYC20Accident · No injuriesClosedPiper PA-22 · Oregon City, OROct 9, 1971 · N7323D · Substantial damageNTSB SEA72DYA14Accident · No injuriesClosedCessna 172K · Mtn Home, IDOct 9, 1971 · N84704 · Substantial damageNTSB MKC72DER24Accident · No injuriesClosedBeech 19A · Blue Earth, MNOct 9, 1971 · N7682R · Substantial damageNTSB CHI72DEI20Accident · No injuriesClosedBeech A23-19 · Northfield, OHOct 9, 1971 · N5989S · Substantial damageNTSB CHI72AC033Accident · Minor injuriesClosedPiper PA-28 · Urbana, ILOct 9, 1971 · N6597W · 2 aircraft · Substantial damageNTSB MIA72DLD15Accident · No injuriesClosedPiper PA-28 · Englewood, FLOct 8, 1971 · N3897K · Substantial damageNTSB FTW72FPG44Accident · No injuriesClosedCessna 172 · El Dorado, AROct 7, 1971 · N84805 · Substantial damageNTSB CHI72FLQ16Accident · Minor injuriesClosedChampion 7GCBC · Independence, KYOct 6, 1971 · N9118L · Substantial damageNTSB NYC72FGM19Accident · Minor injuriesClosedPiper PA-28 · Franklin, PAOct 4, 1971 · N6097W · Substantial damageNTSB MKC72DCJ29Accident · No injuriesClosedPiper PA-28 · Glenvil, NEOct 3, 1971 · N6744W · Substantial damageNTSB MIA72FLD14Accident · Serious injuriesClosedCessna 172L · Orlando, FLOct 3, 1971 · N7766G · Substantial damageNTSB MIA72DKG46Accident · No injuriesClosedPiper PA-28 · Waycross, GAOct 3, 1971 · N6954W · Substantial damageNTSB CHI72FEC15Accident · No injuriesClosedPiper PA-28 · S Rockwood, MIOct 3, 1971 · N95236 · Substantial damageNTSB LAX72DUJ48Accident · No injuriesClosedCessna 172 · Sprngrville, AZOct 1, 1971 · N2813Q · Substantial damageNTSB MIA72FKW06Accident · No injuriesClosedPiper PA-28 · Fayetteville, TNSep 30, 1971 · N6967W · Substantial damageNTSB CHI72DEP17Accident · No injuriesClosedMooney M20 · Hayward, WISep 28, 1971 · N5247B · Substantial damageNTSB MIA72DLG13Accident · No injuriesClosedBeech B23 · Florence, SCSep 26, 1971 · N2311Q · Substantial damageNTSB NYC72FHA17Accident · No injuriesClosedCessna 172 · Kempton, PASep 23, 1971 · N7558G · Substantial damageNTSB DEN72DTE25Accident · Minor injuriesClosedPiper PA-23 · Aspen, COSep 20, 1971 · N4313P · Substantial damageNTSB ANC72DAG59Accident · No injuriesClosedPiper PA-18 · Chitina, AKSep 20, 1971 · N1755P · Substantial damageNTSB MIA72FLD12Accident · No injuriesClosedPiper PA-23 · Lakeland, FLSep 19, 1971 · N1431P · Substantial damageNTSB ANC72DAG66Accident · No injuriesClosedPiper PA-18 · Kukalkek, AKSep 17, 1971 · N6195D · Substantial damageNTSB NYC72FHM11Accident · No injuriesClosedPiper PA-22 · Marlboro, NJSep 14, 1971 · N8940D · Substantial damageNTSB MIA72DKG39Accident · No injuriesClosedPiper PA-22 · Loganville, GASep 13, 1971 · N4352A · Substantial damageNTSB MKC72FER20Accident · No injuriesClosedPiper PA-28 · Duluth, MNSep 12, 1971 · N95112 · DestroyedNTSB NYC72FLJ10Accident · Minor injuriesClosedPiper PA-22 · Clinton, NCSep 10, 1971 · N3814P · Substantial damageNTSB NYC72DIA05Accident · No injuriesClosedCessna 177 · Manassas, VASep 9, 1971 · N29562 · Substantial damageNTSB MKC72FCJ24Accident · No injuriesClosedCessna 177 · Omaha, NESep 9, 1971 · N3242T · Substantial damageNTSB NYC72FGM14Accident · No injuriesClosedPiper PA-22 · Prospect, PASep 8, 1971 · N7348D · Substantial damageNTSB MIA72FLT08Accident · No injuriesClosedPiper PA-18 · Ramer, TNSep 7, 1971 · N4091Z · Substantial damageNTSB LAX72FUQ21Accident · No injuriesClosedPiper PA-28 · Santa Paula, CASep 7, 1971 · N7163R · Substantial damageNTSB NYC72FLJ11Accident · No injuriesClosedPiper PA-28 · Holly Ridge, NCSep 6, 1971 · N9070W · Substantial damageNTSB MKC72FTK07Accident · Serious injuriesClosedPiper PA-18 · Philip, SDSep 6, 1971 · N3927Z · Substantial damageNTSB NYC72FKM04Accident · No injuriesClosedCessna 172 · Indian Trail, NCSep 5, 1971 · N7894G · Substantial damageNTSB MKC72DCD33Accident · No injuriesClosedPiper PA-28 · Osage, IASep 5, 1971 · N4203J · Substantial damageNTSB MIA72FLA09Accident · Minor injuriesClosedCessna 177 · Destin, FLSep 5, 1971 · N29330 · Substantial damageNTSB NYC72FNE10Accident · Minor injuriesClosedPiper PA-28 · Plainville, CTSep 4, 1971 · N1769T · Substantial damageNTSB MKC72FCD28Accident · No injuriesClosedCessna 172 · Blakesburg, IASep 4, 1971 · N2517Y · 2 aircraft · Substantial damageNTSB DEN72FQA16Accident · Minor injuriesClosedCessna 172K · Santa Fe, NMSep 4, 1971 · N7065G · DestroyedNTSB MIA72DKQ15Accident · No injuriesClosedPiper PA-18 · Edwards, MSSep 2, 1971 · N3864Z · DestroyedNTSB ANC72AA015Accident · No injuriesClosedPiper PA-14 · Homer, AKSep 2, 1971 · N4200H · Substantial damageNTSB DEN72FTE27Accident · No injuriesClosedTemco D-16 · Trinidad, COSep 1, 1971 · N79S · Substantial damageNTSB CHI72DEE24Accident · No injuriesClosedPiper PA-28 · Clearing, ILSep 1, 1971 · N5875U · Substantial damageNTSB FTW72FPD07Accident · No injuriesClosedHafe CH-1 · Mineral Wells, TXAug 31, 1971 · N86495 · Substantial damageNTSB FTW72FPA05Accident · No injuriesClosedPiper PA-25 · Rockwall, TXAug 31, 1971 · N6206Z · Substantial damageNTSB FTW72FPJ12Accident · Serious injuriesClosedPitts Spcl S1C · Cushing, OKAug 30, 1971 · N11MA · Substantial damageNTSB CHI72FEI14Accident · No injuriesClosedPiper PA-22 · Richmond Hts, OHAug 30, 1971 · N5986D · Substantial damageNTSB CHI72DEA13Accident · No injuriesClosedPiper PA-28 · Delphi, INAug 30, 1971 · N6018W · Substantial damageNTSB NYC72FLJ09Accident · No injuriesClosedCessna 177 · Coats, NCAug 29, 1971 · N29307 · Substantial damage