NTSB investigations, 2014, MT

7 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2014, MT per year, 2008–2026: 127 cases
20087
20094
20104
201116
201211
201312
20147
201512
20168
20175
20185
20198
20208
20214
20222
20233
20243
20258

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\") = 2014
    AND c.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.Nov 28, 2014 · N3292A · Substantial damageNTSB WPR15CA012Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's failure to maintain directional control during landing.Oct 2, 2014 · N156JM · Substantial damageNTSB WPR14CA246Accident · No injuriesData collectionFinal reportPiper PA 22-160 · Jackson, MTThe pilot's failure to maintain directional control of the airplane during landing roll.Jun 13, 2014 · N9024D · Substantial damageNTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.Jun 7, 2014 · N2804P · DestroyedNTSB WPR14LA232Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Ronan, MTA loss of engine power for reasons that could not be determined due to insufficient evidence.Jun 6, 2014 · N3376B · Substantial damageNTSB WPR14CA401Accident · No injuriesData collectionFinal reportPiper PA 22 · Roundup, MTThe pilot's delayed action to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude.May 23, 2014 · N3460A · Substantial damageNTSB WPR14CA157Accident · No injuriesData collectionFinal reportRobert A Miller Murphy Rebel Elite · Roundup, MTThe pilot's loss of directional control while landing.Apr 2, 2014 · N3552J · Substantial damage