NTSB investigations: Lycoming 0-540 series, 1977

97 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\") = 1977
    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 SEA77FYM49Accident · No injuriesClosedPiper PA-24 · Silverton, ORJul 25, 1977 · N5457P · Substantial damageNTSB FTW77DQG41Accident · No injuriesClosedPiper PA-25 · Edmonson, TXJul 25, 1977 · N8682L · DestroyedNTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKJul 21, 1977 · N22JA · Substantial damageNTSB FTW77DPG65Accident · No injuriesClosedPiper PA-25 · Manila, ARJul 14, 1977 · N9511P · Substantial damageNTSB CHI77FET23Accident · No injuriesClosedPiper PA-25 · Niles, MIJul 13, 1977 · N7278Z · Substantial damageNTSB NYC77FNE30Accident · No injuriesClosedPiper PA-32 · New Marlboroug, MAJul 11, 1977 · N3737W · Substantial damageNTSB MKC770A002Accident · No injuriesClosedPiper PA-28 · Kipling, CanadaJul 9, 1977 · N15999 · Substantial damageNTSB FTW77FPA22Accident · No injuriesClosedPiper PA-28 · Lancaster, TXJul 8, 1977 · N32025 · Substantial damageNTSB NYC77FHA25Accident · No injuriesClosedPiper PA-24 · Warrington, PAJul 6, 1977 · N5473P · Substantial damageNTSB CHI77FER04Accident · 1 fatalClosedPiper PA-24 · Superior, WIJul 4, 1977 · N8898 · Substantial damageNTSB FTW77FPG60Accident · No injuriesClosedPiper PA-24 · Russellville, ARJul 2, 1977 · N7757P · Substantial damageNTSB OAK77DVG49Accident · No injuriesClosedPiper PA-24 · Oroville, CAJun 29, 1977 · N6441P · Substantial damageNTSB NYC77FFJ37Accident · No injuriesClosedPiper PA-24 · Elmira, NYJun 26, 1977 · N8154P · Substantial damageNTSB LAX77DUG49Accident · No injuriesClosedPiper PA-24 · Rialto, CAJun 26, 1977 · N7342P · Substantial damageNTSB MIA77DLD68Accident · No injuriesClosedMaule M5-235 · Lake Wales, FLJun 19, 1977 · N9071E · Substantial damageNTSB MIA77DKG32Accident · No injuriesClosedPiper PA-25 · Rebecca, GAMay 31, 1977 · N8809L · Substantial damageNTSB FTW77DQG31Accident · No injuriesClosedPiper PA-25 · San Angelo, TXMay 28, 1977 · N4860Y · Substantial damageNTSB SEA77FYP25Accident · No injuriesClosedPiper PA-24 · Spokane, WAMay 22, 1977 · N6487P · Substantial damageNTSB SEA77FTA18Accident · No injuriesClosedPiper PA-25 · Brockway, MTMay 21, 1977 · N7312Z · Substantial damageNTSB CHI77FEX28Accident · No injuriesClosedPiper PA-25 · Westfield, INMay 19, 1977 · N7547Z · Substantial damageNTSB ANC77FAD06Accident · Minor injuriesClosedPiper PA-24 · Juneau, AKMay 4, 1977 · N7292P · Substantial damageNTSB FTW77DRA20Accident · No injuriesClosedPiper PA-24 · Jewett, TXApr 30, 1977 · N5663P · Substantial damageNTSB MKC77FCG21Accident · No injuriesClosedPiper PA-24 · Osawatomie, KSApr 27, 1977 · N5454P · Substantial damageNTSB MIA77FKT34Accident · No injuriesClosedAero Comdr 500 · Miami, FLApr 21, 1977 · N6274B · Substantial damageNTSB NYC77FNA15Accident · No injuriesClosedPiper PA-24 · Plymouth, MAApr 10, 1977 · N5855P · Substantial damageNTSB FTW77DQG23Accident · No injuriesClosedMaule 235H · Dumas, TXApr 8, 1977 · N9066E · Substantial damageNTSB OAK77FJA08Accident · No injuriesClosedBrittnorman BN-2 · Maui, HIApr 5, 1977 · N555JA · Substantial damageNTSB DEN77DQG03Accident · No injuriesClosedPiper PA-25 · Rogers, NMMar 30, 1977 · N9890P · Substantial damageNTSB MIA77DKT55Accident · Minor injuriesClosedPiper PA-32 · Ft Meyers, FLMar 26, 1977 · N3750W · Substantial damageNTSB LAX77DUG35Accident · No injuriesClosedPiper PA-32 · Needles, CAMar 20, 1977 · N3595W · Substantial damageNTSB FTW77DA041Accident · No injuriesClosedBell 47G2A1 · Laredo, TXMar 15, 1977 · N8417E · DestroyedNTSB DEN77FTE26Accident · No injuriesClosedPiper PA-24 · Wray, COMar 13, 1977 · N6212P · Substantial damageNTSB OAK77DXQ08Accident · No injuriesClosedPiper PA-24 · Hawthorne, NVFeb 26, 1977 · N7506P · Substantial damageNTSB DEN77FA026Accident · 2 fatalClosedPiper PA-24 · Broomfield, COFeb 26, 1977 · N7237P · DestroyedNTSB IAD77DKW16Accident · No injuriesClosedPiper PA-24 · Greenville, TNFeb 25, 1977 · N5349P · Substantial damageNTSB OAK77FVD18Accident · No injuriesClosedPiper PA-32 · Santa Rosa, CAFeb 20, 1977 · N67180 · Substantial damageNTSB NYC77DHD11Accident · No injuriesClosedPiper PA-32 · Blue Bell, PAFeb 20, 1977 · N8982W · Substantial damageNTSB CHI77FEV11Accident · No injuriesClosedPiper PA-24 · Tolono, ILFeb 5, 1977 · N7440P · Substantial damageNTSB MIA77DLD27Accident · No injuriesClosedMaule M5 · Venice, FLFeb 3, 1977 · N362X · Substantial damageNTSB SEA77FA017Accident · 1 fatalClosedPiper PA-23 · Moro, ORFeb 2, 1977 · N484G · DestroyedNTSB LAX77FUG27Accident · No injuriesClosedPiper PA-28 · Riverside, CAJan 30, 1977 · N101YT · Substantial damageNTSB DEN77FQA13Accident · Minor injuriesClosedPiper PA-23 · Datil, NMJan 24, 1977 · N4867P · Substantial damageNTSB CHI77FEG09Accident · No injuriesClosedPiper PA-32 · Hamilton, OHJan 24, 1977 · N3528W · Substantial damageNTSB DEN77DQA12Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJan 23, 1977 · N8031P · Substantial damageNTSB MIA77FA024Accident · No injuriesClosedBrittnorman BN2A-8 · St.Thomas, VIJan 14, 1977 · N121DW · Substantial damageNTSB SEA77FYM13Accident · No injuriesClosedPiper PA-24 · Yamhill, ORJan 8, 1977 · N7364H · Substantial damageNTSB CHI77FEG07Accident · No injuriesClosedPiper PA-24 · Middletown, OHJan 8, 1977 · N5232P · Substantial damage