NTSB investigations: Lycoming 0-540 series, 1969

110 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\") = 1969
    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 FTW70F0114Accident · Serious injuriesClosedPiper PA-25 · Nazareth, TXJul 9, 1969 · N6517Z · Substantial damageNTSB MKC70D0098Accident · Minor injuriesClosedPiper PA-25 · La Plata, MOJul 8, 1969 · N4838Y · Substantial damageNTSB MIA70F0044Accident · No injuriesClosedPiper PA-25 · Cleveland, MSJul 8, 1969 · N6737Z · Substantial damageNTSB CHI70D0095Accident · No injuriesClosedPiper PA-25 · Suring, WIJul 8, 1969 · N4598Y · Substantial damageNTSB MKC70F0074Accident · No injuriesClosedPiper PA-24 · Sarcoxie, MOJul 7, 1969 · N487SC · Substantial damageNTSB DEN70D0033Accident · No injuriesClosedPiper PA-24 · Cedar City, UTJul 5, 1969 · N6186P · Substantial damageNTSB DEN70D0060Accident · No injuriesClosedPiper PA-24 · Lake City, COJul 4, 1969 · N7335P · Substantial damageNTSB CHI70A0003Accident · No injuriesClosedPiper PA-32 · Madison, INJul 4, 1969 · N7704J · Substantial damageNTSB FTW70D0040Accident · No injuriesClosedPiper PA-25 · Wynne, ARJul 3, 1969 · N4677Y · Substantial damageNTSB LAX70F0031Accident · No injuriesClosedPiper PA-23 · Redlands, CAJul 2, 1969 · N4694P · Substantial damageNTSB CHI70D0123Accident · No injuriesClosedCallair A-9 · Hobart, INJun 28, 1969 · N3603G · Substantial damageNTSB NYC70F0064Accident · No injuriesClosedPiper PA-24 · Ridgeway, PAJun 27, 1969 · N7531P · Substantial damageNTSB MIA69A0093Accident · No injuriesClosedPiper PA-18 · Flora, MSJun 27, 1969 · N4032Z · 2 aircraft · DestroyedNTSB CHI70F0055Accident · No injuriesClosedPiper PA-32 · Chicago, ILJun 27, 1969 · N5581J · Substantial damageNTSB NYC70F0046Accident · No injuriesClosedPiper PA-24 · White Plains, NYJun 24, 1969 · N5999P · Substantial damageNTSB MKC70D0025Accident · No injuriesClosedPiper PA-24 · Dora Lake, MNJun 22, 1969 · N5186P · Substantial damageNTSB FTW70F0056Accident · No injuriesClosedPiper PA-25 · Texarkana, ARJun 19, 1969 · N4559Y · DestroyedNTSB FTW70D0058Accident · No injuriesClosedPiper PA-25 · Guymon, OKJun 19, 1969 · N4631Y · Substantial damageNTSB MKC70D0060Accident · No injuriesClosedPiper PA-28 · Olathe, KSJun 18, 1969 · N9418W · Substantial damageNTSB DIA70F0023Accident · No injuriesClosedPiper PA-24 · Laytonsville, MDJun 18, 1969 · N7181P · Substantial damageNTSB MKC70D0017Accident · No injuriesClosedPiper PA-25 · Burlington, KSJun 7, 1969 · N6810Z · Substantial damageNTSB FTW70D0049Accident · No injuriesClosedPiper PA-24 · Lubbock, TXJun 7, 1969 · N6715P · Substantial damageNTSB FTW69D0542Accident · Minor injuriesClosedPiper PA-25 · Bay, ARJun 3, 1969 · N7451Z · Substantial damageNTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJMay 30, 1969 · N4792P · Substantial damageNTSB LAX70D0009Accident · No injuriesClosedPiper PA-24 · Safford, AZMay 30, 1969 · N7780P · Substantial damageNTSB FTW70D0030Accident · Minor injuriesClosedPiper PA-28 · Kingsland, TXMay 30, 1969 · N9352W · Substantial damageNTSB FTW70D0006Accident · No injuriesClosedPiper PA-25 · Amagon, ARMay 29, 1969 · N7373Z · Substantial damageNTSB FTW69D0512Accident · No injuriesClosedCallair A-9 · Doole, TXMay 29, 1969 · N3602G · Substantial damageNTSB MKC70D0030Accident · No injuriesClosedPiper PA-25 · Wilsonville, NEMay 27, 1969 · N4514Y · Substantial damageNTSB DEN69D0238Accident · No injuriesClosedPiper PA-25 · Logan, UTMay 27, 1969 · N8593L · DestroyedNTSB FTW70D0074Accident · No injuriesClosedPiper PA-25 · Roby, TXMay 24, 1969 · N6791Z · Substantial damageNTSB FTW69D0544Accident · Serious injuriesClosedPiper PA-25 · Morganza, LAMay 20, 1969 · N4379Y · DestroyedNTSB FTW69A0083Accident · 1 fatalClosedPiper PA-32 · Keller, TXMay 18, 1969 · N3229W · DestroyedNTSB OAK69F0302Accident · No injuriesClosedPiper PA-25 · Stockton, CAMay 9, 1969 · N4429Y · Substantial damageNTSB NYC69F0456Accident · No injuriesClosedPiper PA-22 · Gratz, PAMay 6, 1969 · N6510Z · Substantial damageNTSB SEA69F0250Accident · No injuriesClosedCallair A-9 · St.Xavier, MTMay 5, 1969 · N7223V · Substantial damageNTSB MKC69F0446Accident · No injuriesClosedCallair A-9 · Kadoka, SDMay 5, 1969 · N9653Z · Substantial damageNTSB FTW69D0508Accident · No injuriesClosedPiper PA-25 · Cisco, TXMay 1, 1969 · N6794Z · Substantial damageNTSB CHI70F0007Accident · Minor injuriesClosedCallair A-9 · Bronson, MIApr 26, 1969 · N3603G · Substantial damageNTSB DIA69D0201Accident · No injuriesClosedPiper PA-24 · Asheboro, NCApr 21, 1969 · N7746P · Substantial damageNTSB CHI69F0623Accident · No injuriesClosedPiper PA-24 · Napoleon, OHApr 21, 1969 · N5466P · Substantial damageNTSB NYC69F0434Accident · Minor injuriesClosedPiper PA-23 · Schenectady, NYApr 18, 1969 · N4809P · Substantial damageNTSB CHI69F0594Accident · No injuriesClosedPiper PA-24 · Marysville, MIApr 13, 1969 · N7358P · Substantial damageNTSB CHI69D0576Accident · No injuriesClosedPiper PA-24 · Greenwood, INApr 13, 1969 · N7167P · Substantial damageNTSB OAK69D0301Accident · No injuriesClosedPiper PA-28 · Santa Rosa, CAApr 10, 1969 · N8679W · Substantial damageNTSB DIA69F0171Accident · No injuriesClosedPiper PA-32 · New Kent, VAApr 9, 1969 · N3576W · Substantial damageNTSB DIA69F0170Accident · Minor injuriesClosedPiper PA-28 · Bower, MDApr 1, 1969 · N8564W · Substantial damageNTSB FTW69F0412Accident · No injuriesClosedPiper PA-32 · Sarepta, LAMar 31, 1969 · N3853W · Substantial damageNTSB CHI69D0567Accident · No injuriesClosedPiper PA-23 · Drummond, MIMar 29, 1969 · N5157Y · Substantial damageNTSB FTW69F0455Accident · No injuriesClosedPiper PA-32 · San Antonio, TXMar 18, 1969 · N3754W · Substantial damage