NTSB investigations: Lycoming 0-540 series, 1973

83 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\") = 1973
    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 MKC73DCJ47Accident · Minor injuriesClosedPiper PA-25 · Stamford, NEJun 5, 1973 · N7114Z · DestroyedNTSB OAK73DVD39Accident · No injuriesClosedPiper PA-32 · La Paz, MexicoMay 26, 1973 · N3852W · Substantial damageNTSB MIA73FKA10Accident · Minor injuriesClosedPiper PA-32 · Humacao, PRMay 24, 1973 · N4795S · DestroyedNTSB MKC73DTG14Accident · No injuriesClosedPiper PA-25 · Kindred, NDMay 23, 1973 · N7308Z · Substantial damageNTSB CHI73FEC37Accident · No injuriesClosedPiper PA-28 · Flushing, MIMay 19, 1973 · N8882W · Substantial damageNTSB IAD73FIJ22Accident · Serious injuriesClosedPiper PA-32 · Fleminton, WVMay 17, 1973 · N3442W · Substantial damageNTSB OAK73FVD35Accident · Minor injuriesClosedCallair A-9 · Clements, CAMay 11, 1973 · N7232V · DestroyedNTSB OAK73DVD36Accident · No injuriesClosedPiper PA-24 · Mazatlan, MexicoMay 11, 1973 · N9468P · Substantial damageNTSB MIA73DKJ56Accident · No injuriesClosedPiper PA-25 · Mccullough, ALMay 10, 1973 · N7716Z · Substantial damageNTSB FTW73DRJ32Accident · No injuriesClosedPiper PA-25 · Mer Rouge, LAMay 10, 1973 · N7295Z · Substantial damageNTSB CHI73FEE56Accident · No injuriesClosedPiper PA-24 · Joliet, ILMay 5, 1973 · N7132P · Substantial damageNTSB NYC73DNA45Accident · No injuriesClosedPiper PA-24 · S.Weymouth, MAApr 28, 1973 · N8430P · Substantial damageNTSB MKC73DCD55Accident · No injuriesClosedPiper PA-28 · Wapello, IAApr 14, 1973 · N8502W · Substantial damageNTSB LAX73FUQ29Accident · No injuriesClosedPiper PA-24 · Van Nuys, CAApr 14, 1973 · N7540P · Substantial damageNTSB OAK73FVD29Accident · No injuriesClosedPiper PA-24 · Lodi, CAApr 11, 1973 · N7543P · Substantial damageNTSB LAX73DVA49Accident · No injuriesClosedPiper PA-25 · Pond, CAApr 11, 1973 · N6988Z · Substantial damageNTSB MKC73DER49Accident · No injuriesClosedPiper PA-32 · Starbuck, MNApr 7, 1973 · N3364W · Substantial damageNTSB MIA73FLG43Accident · No injuriesClosedPiper PA-23 · Cameron, SCApr 6, 1973 · N681M · DestroyedNTSB LAX73AL049Accident · No injuriesClosedBoeing 707 · Los Angeles, CAApr 6, 1973 · FBHSY · 2 aircraft · Minor damageNTSB MIA73DLG41Accident · No injuriesClosedPiper PA-28 · Little River, SCApr 2, 1973 · N9466W · Substantial damageNTSB MIA73OKT97Accident · No injuriesClosedPiper PA-32 · G.Harbor C, Burkina FasoMar 31, 1973 · N3945W · Substantial damageNTSB MIA73DLD68Accident · No injuriesClosedPiper PA-24 · Inverness, FLMar 29, 1973 · N7438P · Substantial damageNTSB MKC73FER45Accident · No injuriesClosedPiper PA-24 · Grand Rapids, MNMar 25, 1973 · N5671P · Substantial damageNTSB OAK73FVG53Accident · No injuriesClosedPiper PA-25 · W.Sacramnto, CAMar 15, 1973 · N7028Z · Substantial damageNTSB DEN73FTE66Accident · Serious injuriesClosedPiper PA-32 · Aurora, COMar 14, 1973 · N3234W · Minor damageNTSB MIA73FLD62Accident · Minor injuriesClosedPiper PA-32 · Windermere, FLMar 11, 1973 · N5571J · Substantial damageNTSB NYC73AN118Accident · 4 fatalClosedPiper PA-24 · Pontiac, MIMar 2, 1973 · N5910P · DestroyedNTSB CHI73AEM72Accident · No injuriesClosedPiper PA-32 · Charlotte, MIFeb 20, 1973 · N4394T · Substantial damageNTSB FTW73FPA24Accident · No injuriesClosedPiper PA-28 · Dallas, TXFeb 15, 1973 · N3082T · Substantial damageNTSB OAK73DVG46Accident · No injuriesClosedPiper PA-24 · Auburn, CAFeb 12, 1973 · N5619P · Substantial damageNTSB CHI73FEC22Accident · No injuriesClosedPiper PA-32 · Laingsburg, MIFeb 4, 1973 · N3589W · Substantial damageNTSB DEN73FTE44Accident · No injuriesClosedPiper PA-32 · Broomfield, COJan 12, 1973 · N3700W · Substantial damageNTSB NYC73FNC45Accident · No injuriesClosedPiper PA-24 · Keene, NHJan 1, 1973 · N4250 · Substantial damage