NTSB investigations, 2017

6 cases where NTSB found Tower/antenna (incl guy wires).

Cases per year

20082026
NTSB investigations, 2017 per year, 2008–2026: 55 cases
20083
20094
20112
20123
20137
20143
20151
20165
20176
20185
20192
20205
20212
20224
20242
20261

Latest cases

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\") = 2017
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022017'))
  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 GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.Aug 14, 2017 · N97UP · Substantial damageNTSB ERA17LA249Accident · Serious injuriesLimited investigationFinal reportGrumman G 164 · Marydel, DEThe pilot's failure to maintain adequate clearance from power lines while conducting an aerial application flight.Jul 19, 2017 · N691Y · Substantial damageNTSB GAA17CA385Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Edna, TXThe pilot’s failure to see and avoid a tower during an agricultural application flight.Jul 2, 2017 · N6135P · Substantial damageNTSB CEN17FA127Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Chalmers, INThe pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.Mar 14, 2017 · N530KD · DestroyedNTSB GAA17CA170Accident · No injuriesData collectionFinal reportMaule M5 · Roxbury, KSThe pilot’s failure to maintain directional control during a go-around.Mar 2, 2017 · N56552 · Substantial damageNTSB CEN17FA095Accident · 1 fatalField investigationFinal reportCessna 177 · Price, TXThe pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.Jan 31, 2017 · N2810X · Destroyed