NTSB investigations: Lycoming 0-540 series, 1971

118 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\") = 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 ('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 DEN72FQA06Accident · No injuriesClosedPiper PA-32 · Albuquerque, NMJul 24, 1971 · N3507W · Substantial damageNTSB SEA72FTA02Accident · No injuriesClosedCallair A-9 · Laurel, MTJul 19, 1971 · N8264H · Substantial damageNTSB LAX72DVA03Accident · Minor injuriesClosedCallair A-9 · Shafter, CAJul 17, 1971 · N7215V · Substantial damageNTSB FTW72DQD04Accident · No injuriesClosedPiper PA-24 · Sierra Blanca, TXJul 17, 1971 · N7117P · Substantial damageNTSB OAK72FVW01Accident · No injuriesClosedPiper PA-24 · Beatty, NVJul 11, 1971 · N8053P · DestroyedNTSB FTW72FQG05Accident · No injuriesClosedPiper PA-25 · Plainview, TXJul 5, 1971 · N7770Z · Substantial damageNTSB DEN72FQA02Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMJul 5, 1971 · N5387Y · Substantial damageNTSB FTW72DQG01Accident · No injuriesClosedPiper PA-25 · Springlake, TXJun 26, 1971 · N6806Z · Substantial damageNTSB SEA71FTA23Accident · No injuriesClosedCallair A-9 · Opheim, MTJun 20, 1971 · N9650Z · Substantial damageNTSB SEA71DYA38Accident · No injuriesClosedPiper PA-25 · Blackfoot, IDJun 20, 1971 · N7283Z · Substantial damageNTSB OAK71DVA86Accident · No injuriesClosedPiper PA-24 · Visalia, CAJun 19, 1971 · N7852P · Substantial damageNTSB MKC71DCQ44Accident · No injuriesClosedCallair A-9 · Ulysses, KSJun 17, 1971 · N3572G · Substantial damageNTSB FTW71DPG64Accident · No injuriesClosedPiper PA-25 · Tuckerman, ARJun 16, 1971 · N4552Y · Substantial damageNTSB DEN71DTE12Accident · No injuriesClosedPiper PA-25 · Breen, COJun 11, 1971 · N6629Z · Substantial damageNTSB DEN71FTE10Accident · Serious injuriesClosedCallair A-9 · Firestone, COJun 5, 1971 · N9648Z · DestroyedNTSB MKC71DTG28Accident · Serious injuriesClosedPiper PA-25 · Devils Lake, NDJun 1, 1971 · N4812Y · Substantial damageNTSB CHI71DEP52Accident · No injuriesClosedPiper PA-25 · Random Lake, WIMay 28, 1971 · N4421Y · Substantial damageNTSB FTW71FRH31Accident · No injuriesClosedPiper PA-24 · Mcallen, TXMay 27, 1971 · N7731P · Substantial damageNTSB ANC71AA063Accident · No injuriesClosedPiper PA-32 · Pilot Sta, AKMay 23, 1971 · N3519W · Substantial damageNTSB SEA71DYG55Accident · No injuriesClosedPiper PA-25 · Lind, WAMay 22, 1971 · N4722Y · Substantial damageNTSB IAD71DLJ26Accident · No injuriesClosedCallair A-9 · Aurora, NCMay 22, 1971 · N8266H · Substantial damageNTSB CHI71FLQ24Accident · No injuriesClosedAero Comdr A-9 · Morganfield, KYMay 15, 1971 · N7712V · DestroyedNTSB MKC71FCJ62Accident · No injuriesClosedAero Comdr A-9 · St Libory, NEMay 13, 1971 · N8292H · Substantial damageNTSB OAK71FVA71Accident · No injuriesClosedPiper PA-32 · Merced, CAMay 10, 1971 · N3343W · Substantial damageNTSB LAX71FUG83Accident · No injuriesClosedPiper PA-24 · Chino, CAMay 9, 1971 · N6229P · Substantial damageNTSB MKC71DCQ39Accident · No injuriesClosedPiper PA-25 · Yates Center, KSMay 8, 1971 · N6810Z · Substantial damageNTSB IAD71AI051Accident · No injuriesClosedPiper PA-32 · Buckhannon, WVMay 8, 1971 · N3344W · Substantial damageNTSB MIA71RM104Accident · No injuriesClosedPiper PA-32 · Santa Domngo, DRMay 2, 1971 · N4794S · Substantial damageNTSB OAK71FVW31Accident · No injuriesClosedPiper PA-24 · Lathrop Wells, NVApr 26, 1971 · N8241P · Substantial damageNTSB MIA71FKT57Accident · Serious injuriesClosedPiper PA-25 · Miami, FLApr 26, 1971 · N8773L · Substantial damageNTSB IAD71DLJ21Accident · No injuriesClosedPiper PA-24 · Hatteras, NCApr 25, 1971 · N7460P · Substantial damageNTSB MKC71DCA33Accident · No injuriesClosedPiper PA-25 · Washington, MOApr 23, 1971 · N6576Z · Substantial damageNTSB OAK71DVA69Accident · No injuriesClosedPiper PA-25 · Tulare, CAApr 20, 1971 · N7092Z · Substantial damageNTSB MIA71DKJ53Accident · No injuriesClosedPiper PA-25 · Mccullough, ALApr 20, 1971 · N7509Z · Substantial damageNTSB NYC71FNA46Accident · No injuriesClosedPiper PA-23 · Norwood, MAApr 17, 1971 · N5376Y · Substantial damageNTSB MKC71DCD72Accident · No injuriesClosedPiper PA-32 · Kingsley, IAApr 16, 1971 · N3954W · Substantial damageNTSB LAX71DUJ44Accident · No injuriesClosedPiper PA-24 · Yuma, AZApr 9, 1971 · N7541P · Substantial damageNTSB MKC71FCJ59Accident · Minor injuriesClosedCallair A9 · Gibbon, NEApr 8, 1971 · N3606G · Substantial damageNTSB FTW71DQG65Accident · No injuriesClosedPiper PA-25 · Spearman, TXApr 6, 1971 · N6907Z · DestroyedNTSB DEN71DXA20Accident · No injuriesClosedPiper PA-25 · Casper, WYApr 2, 1971 · N7685Z · Substantial damageNTSB NYC71FFD41Accident · No injuriesClosedPiper PA-24 · Lincoln, RIMar 30, 1971 · N8233P · Substantial damageNTSB CHI71FBJ64Accident · No injuriesClosedPiper PA-28 · Alpena, MIMar 26, 1971 · N8547N · Substantial damageNTSB ANC71AA047Accident · No injuriesClosedHelio Acft H-250 · Kobuk, AKMar 22, 1971 · N5463E · Substantial damageNTSB CHI71FGG29Accident · No injuriesClosedPiper PA-28 · Columbus, OHMar 21, 1971 · N9081W · Substantial damageNTSB OAK71FXQ31Accident · No injuriesClosedPiper PA-24 · Reno, NVMar 17, 1971 · N7005P · Substantial damageNTSB MKC71DCG47Accident · No injuriesClosedPiper PA-24 · Olathe, KSMar 14, 1971 · N6424P · Substantial damageNTSB MIA71AM081Accident · No injuriesClosedPiper PA-32 · Vieques Island, PRMar 9, 1971 · N3996W · Substantial damageNTSB CHI71FGA18Accident · No injuriesClosedPiper PA-28 · Middletown, OHMar 4, 1971 · N8664W · Substantial damageNTSB FTW71DRF29Accident · No injuriesClosedPiper PA-32 · Georgetown, LAMar 3, 1971 · N7742J · Substantial damageNTSB SEA71DWA31Accident · No injuriesClosedPiper PA-32 · Condon, ORFeb 25, 1971 · N3623W · Substantial damage