NTSB investigations: Lycoming 0-540 series, 1972

115 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\") = 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 ('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 FTW73FQG07Accident · Serious injuriesClosedPiper PA-25 · Dumas, TXJul 24, 1972 · N6577Z · DestroyedNTSB LAX73FUG03Accident · Minor injuriesClosedPiper PA-24 · Hesperia, CAJul 18, 1972 · N5941P · DestroyedNTSB CHI73FLQ01Accident · No injuriesClosedPiper PA-24 · Erlanger, KYJul 14, 1972 · N8656P · Substantial damageNTSB MIA73FLA05Accident · No injuriesClosedPiper PA-23 · Pensacola, FLJul 13, 1972 · N4746P · Substantial damageNTSB MKC73DCJ07Accident · No injuriesClosedPiper PA-25 · Humbolt, NEJul 10, 1972 · N4886Y · Substantial damageNTSB FTW73DPD01Accident · Serious injuriesClosedPiper PA-25 · Priddy, TXJul 7, 1972 · N6708Z · Substantial damageNTSB DEN73FTE02Accident · No injuriesClosedPiper PA-25 · Mead, COJul 7, 1972 · N4999Y · Substantial damageNTSB MKC73DCJ01Accident · No injuriesClosedPiper PA-25 · Oshkosh, NEJul 4, 1972 · N6692Z · Substantial damageNTSB FTW73AF001Accident · 5 fatalClosedPiper PA-28 · Intrcoastl Cty, LAJul 4, 1972 · N8602W · DestroyedNTSB FTW73FRA03Accident · 1 fatalClosedPiper PA-25 · Caldwell, TXJul 3, 1972 · N6925Z · DestroyedNTSB NYC73DFA03Accident · No injuriesClosedPiper PA-32 · Delhi, NYJul 1, 1972 · N3701W · Substantial damageNTSB CHI73FEK03Accident · No injuriesClosedPiper PA-24 · Lima, OHJul 1, 1972 · N6004P · Substantial damageNTSB MIA72DLT16Accident · Minor injuriesClosedPiper PA-25 · Trimble, TNJun 29, 1972 · N4837Y · DestroyedNTSB FTW72DQG48Accident · No injuriesClosedPiper PA-25 · Wall, TXJun 28, 1972 · N6587Z · Substantial damageNTSB NYC72DFA48Accident · No injuriesClosedPiper PA-24 · Oneonta, NYJun 23, 1972 · N7178P · Substantial damageNTSB MKC72FTG24Accident · No injuriesClosedPiper PA-28 · Lisbon, NDJun 22, 1972 · N9032W · Substantial damageNTSB MIA72FKH18Accident · Minor injuriesClosedPiper PA-25 · Ocilla, GAJun 22, 1972 · N4437Y · Substantial damageNTSB ANC72AA052Accident · No injuriesClosedPiper PA-32 · Kalskag, AKJun 20, 1972 · N3519W · Substantial damageNTSB CHI72FEC48Accident · No injuriesClosedPiper PA-24 · Plymouth, MIJun 18, 1972 · N6753P · Substantial damageNTSB NYC72FNA45Accident · No injuriesClosedPiper PA-24 · Hopedale, MAJun 17, 1972 · N7825P · Substantial damageNTSB MIA72FLD74Accident · No injuriesClosedPiper PA-24 · Tampa, FLJun 16, 1972 · N6435P · Substantial damageNTSB MIA72DKH23Accident · Serious injuriesClosedPiper PA-24 · Dublin, GAJun 16, 1972 · N5100P · No damageNTSB OAK72DVG73Accident · No injuriesClosedPiper PA-28 · Nut Tree, CAJun 14, 1972 · N9308W · Substantial damageNTSB MKC72FCA29Accident · Minor injuriesClosedPiper PA-24 · Tyrone, MOJun 10, 1972 · N5909P · Substantial damageNTSB CHI72FEE84Accident · Serious injuriesClosedPiper PA-24 · Chicago, ILJun 10, 1972 · N7883P · Minor damageNTSB DEN72AD059Accident · 6 fatalClosedPiper PA-32 · Nucla, COJun 8, 1972 · N3681W · DestroyedNTSB MIA72FLG43Accident · No injuriesClosedCallair A-9 · Barnwell, SCJun 5, 1972 · N7244V · DestroyedNTSB MKC72DCJ71Accident · No injuriesClosedPiper PA-25 · Crawford, NEJun 2, 1972 · N4997Y · DestroyedNTSB LAX72FUQ89Accident · Serious injuriesClosedPiper PA-32 · Lake Hughes, CAMay 29, 1972 · N3435W · Substantial damageNTSB OAK72DXQ36Accident · No injuriesClosedPiper PA-24 · Mammoth Lks, CAMay 27, 1972 · N8105P · Substantial damageNTSB NYC72FHJ20Accident · No injuriesClosedPiper PA-28 · Montauk, NYMay 27, 1972 · N9366W · Substantial damageNTSB MIA72FLD72Accident · No injuriesClosedPiper PA-24 · Lakeland, FLMay 27, 1972 · N6381P · Substantial damageNTSB MKC72DCQ57Accident · No injuriesClosedPiper PA-25 · Laharpe, KSMay 26, 1972 · N6792Z · Substantial damageNTSB NYC72FIG26Accident · Serious injuriesClosedPiper PA-32 · Oakland, MDMay 25, 1972 · N3930W · Substantial damageNTSB ANC72DAG14Accident · No injuriesClosedPiper PA-28 · Cold Bay, AKMay 19, 1972 · N8556W · Substantial damageNTSB MKC72FCA27Accident · No injuriesClosedPiper PA-25 · New Madrid, MOMay 16, 1972 · N6666Z · Substantial damageNTSB MIA72FKH02Accident · Serious injuriesClosedCallair A-9 · Calhoun, GAMay 16, 1972 · N7233V · Substantial damageNTSB MIA72FKG99Accident · No injuriesClosedPiper PA-23 · Chamblee, GAMay 16, 1972 · N5220Y · Substantial damageNTSB CHI72DET26Accident · No injuriesClosedPiper PA-28 · Syracuse, INMay 16, 1972 · N8733W · Substantial damageNTSB OAK72FVG57Accident · Minor injuriesClosedPiper PA-28 · Montague, CAMay 15, 1972 · N8619W · Substantial damageNTSB DEN81FA070Accident · 1 fatalClosedPiper PA-23 · Estes Park, COMay 9, 1972 · N4909P · DestroyedNTSB FTW72DPG73Accident · No injuriesClosedPiper PA-25 · Osceola, ARMay 6, 1972 · N4837Y · Substantial damageNTSB CHI72FEA42Accident · Minor injuriesClosedPiper PA-32 · Crawfordsvile, INMay 2, 1972 · N3459W · Substantial damageNTSB MIA72FKJ52Accident · No injuriesClosedPiper PA-24 · Birmingham, ALApr 23, 1972 · N5496P · Substantial damageNTSB DEN72FQG38Accident · 1 fatalClosedPiper PA-25 · Clovis, NMApr 22, 1972 · N4656Y · DestroyedNTSB NYC72FIA20Accident · No injuriesClosedPiper PA-24 · Manassas, VAApr 19, 1972 · N8104P · Substantial damageNTSB LAX72DUJ94Accident · No injuriesClosedPiper PA-28 · Kingman, AZApr 11, 1972 · N9077W · Substantial damageNTSB FTW72FPA19Accident · Minor injuriesClosedPiper PA-28 · Dallas, TXApr 8, 1972 · N9322W · DestroyedNTSB DEN72FTE65Accident · No injuriesClosedPiper PA-25 · Merino, COApr 5, 1972 · N7712Z · Substantial damageNTSB MIA72DKJ49Accident · No injuriesClosedPiper PA-24 · Uniontown, ALApr 4, 1972 · N6394P · Substantial damage