NTSB investigations: Lycoming 0-540 series, 1979

92 cases on aircraft whose registry engine model is Lycoming 0-540 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\") = 1979
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
  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 SEA79FYM45Accident · No injuriesClosedPiper PA-24 · Salem, ORJul 1, 1979 · N6651P · Substantial damageNTSB SEA79FYP31Accident · No injuriesClosedHiller Acft UH-12E · Quincy, WAJun 29, 1979 · N65048 · Substantial damageNTSB MIA79FKJ46Accident · No injuriesClosedPiper PA-25 · Opp, ALJun 28, 1979 · N4966Y · Substantial damageNTSB LAX79DUJ88Accident · No injuriesClosedPiper PA-28 · Douglas, AZJun 24, 1979 · N4591X · Substantial damageNTSB MIA79DKT74Accident · Minor injuriesClosedPiper PA-28 · Miami, FLJun 21, 1979 · N57347 · Substantial damageNTSB IAD79DLT05Accident · No injuriesClosedPiper PA-25 · Covington, TNJun 21, 1979 · N7260Z · Substantial damageNTSB MIA79FKG49Accident · 1 fatalClosedPiper PA-25 · Wrightsville, GAJun 18, 1979 · N9534P · DestroyedNTSB DEN79DTE43Accident · No injuriesClosedPiper PA-25 · Eads, COJun 12, 1979 · N6496Z · Substantial damageNTSB FTW79DPG52Accident · No injuriesClosedPiper PA-28 · Benton, ARJun 9, 1979 · N4687P · Substantial damageNTSB SEA79FYK15Accident · Serious injuriesClosedPiper PA-25 · Burns, ORJun 1, 1979 · N4753Y · Substantial damageNTSB IAD79FIG07Accident · No injuriesClosedPiper PA-22 · College Park, MDJun 1, 1979 · N3618Z · Substantial damageNTSB NYC79DFJ20Accident · Minor injuriesClosedPiper PA-25 · Cohocton, NYMay 31, 1979 · N6905Z · Substantial damageNTSB FTW79DPD20Accident · No injuriesClosedPiper PA-25 · Anson, TXMay 22, 1979 · N9733P · Substantial damageNTSB FTW79DPJ16Accident · No injuriesClosedPiper PA-25 · Sharon, OKMay 11, 1979 · N4742Y · Substantial damageNTSB FTW79FPA16Accident · Serious injuriesClosedPiper PA-25 · Frisco, TXMay 9, 1979 · N7103Z · Substantial damageNTSB IAD79DLQ16Accident · Serious injuriesClosedMaule M-5 · Greenville, KYMay 7, 1979 · N9101E · No damageNTSB OAK79DVW13Accident · No injuriesClosedPiper PA-32 · Furnace Creek, CAMay 4, 1979 · N5584J · Substantial damageNTSB SEA79FYP15Accident · 1 fatalClosedCallair A-9 · Dayton, WAApr 29, 1979 · N8259H · DestroyedNTSB MKC79FCQ20Accident · 1 fatalClosedPiper PA-25 · Mayday, KSApr 28, 1979 · N7641Z · DestroyedNTSB DEN79DQA27Accident · No injuriesClosedCessna 182RG · Chama, NMApr 27, 1979 · N2834C · DestroyedNTSB CHI79FEE53Accident · No injuriesClosedPiper PA-28 · Cherry, ILApr 25, 1979 · N5KS · Substantial damageNTSB IAD79FIJ05Accident · No injuriesClosedMaule M5-235 · Daybrook, WVApr 21, 1979 · N5630Y · Substantial damageNTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTApr 20, 1979 · N8372P · DestroyedNTSB LAX79DVA29Accident · Minor injuriesClosedPiper PA-28 · Avenal, CAApr 20, 1979 · N9434W · DestroyedNTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJApr 17, 1979 · N7318P · DestroyedNTSB SEA79DYM27Accident · No injuriesClosedMaule M235C · Lord Flat, ORApr 13, 1979 · N9196E · Substantial damageNTSB OAK79DVD21Accident · No injuriesClosedCessna 182RG · Stockton, CAApr 9, 1979 · N2263T · Substantial damageNTSB DEN79FQA22Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMMar 25, 1979 · N8243P · Substantial damageNTSB LAX79FA035Accident · 2 fatalClosedPiper PA-24 · Taft, CAMar 17, 1979 · N7167P · DestroyedNTSB CHI79FA035Accident · 2 fatalClosedPiper PA-28 · Park Forrest, ILMar 17, 1979 · N9458W · DestroyedNTSB CHI79DEE48Accident · No injuriesClosedCessna 182RG · Crystal Lake, ILMar 11, 1979 · N3648C · Substantial damageNTSB IAD79FKW07Accident · No injuriesClosedPiper PA-25 · Sparta, TNMar 6, 1979 · N4390Y · DestroyedNTSB OAK79FVG19Accident · No injuriesClosedPiper PA-28 · Galt, CAMar 5, 1979 · N56649 · Substantial damageNTSB LAX79DUJ52Accident · No injuriesClosedPiper PA-25 · Maricopa, AZFeb 27, 1979 · N6705Z · Substantial damageNTSB DEN79FTE24Accident · Minor injuriesClosedPiper PA-24 · Silver Cliff, COFeb 10, 1979 · N6428P · DestroyedNTSB MKC79DCQ13Accident · No injuriesClosedCessna R-182 · Greenburg, KSFeb 9, 1979 · N3167C · Substantial damageNTSB MIA79FLD36Accident · Minor injuriesClosedPiper PA-32 · Wimauma, FLFeb 6, 1979 · N3747W · DestroyedNTSB CHI79FEP24Accident · No injuriesClosedPiper PA-32 · Milwaukee, WIJan 29, 1979 · N4823S · Substantial damageNTSB MIA79DKT41Accident · No injuriesClosedPiper PA-25 · Miami, FLJan 26, 1979 · N7417Z · Substantial damageNTSB FTW79FQG15Accident · No injuriesClosedPiper PA-24 · Amarillo, TXJan 19, 1979 · N6999P · Substantial damageNTSB CHI79FEM08Accident · No injuriesClosedPiper PA-23 · Muskegon Hgts, MIJan 5, 1979 · N5120Y · Substantial damageNTSB MIA79FLA14Accident · Minor injuriesClosedPiper PA-32 · Cross City, FLJan 3, 1979 · N3705W · Substantial damage