# NTSB investigations, 2017, MT: Collision with terr/obj (non-CFIT)

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA17CA572](https://openairdocs.org/ntsb/GAA17CA572.md): Cub Crafters CC19-180 · Kalispell, MT · Accident · No injuries · Data collection · Final report · Sep 27, 2017 · N53XC · Substantial damage
  > The pilot’s inadvertent brake application during the landing roll, which resulted in a loss of directional control.
- [NTSB GAA17CA529](https://openairdocs.org/ntsb/GAA17CA529.md): Cessna 182 · Fairfield, MT · Accident · Minor injuries · Data collection · Final report · Sep 7, 2017 · N735KQ · Destroyed
  > The pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.
- [NTSB WPR17LA145](https://openairdocs.org/ntsb/WPR17LA145.md): Piper L 21B · Big Timber, MT · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2017 · N99031 · Substantial damage
  > The pilot's decision to fly at low altitude in the vicinity of power lines, which resulted in a wire strike.
- [NTSB GAA17CA225](https://openairdocs.org/ntsb/GAA17CA225.md): Weatherly 620B · Lewistown, MT · Accident · No injuries · Data collection · Final report · Apr 10, 2017 · N9004M · Substantial damage
  > The pilot’s failure to maintain altitude during low-altitude maneuvers in flat light conditions.
- [NTSB WPR17LA046](https://openairdocs.org/ntsb/WPR17LA046.md): Softex Invest V-24L · Paradise, MT · Accident · Serious injuries · Limited investigation · Final report · Jan 3, 2017 · N710XP · Substantial damage
  > A partial loss of power during cruise flight for reasons that could not be determined because postaccident examination of the engines did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."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
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?state=MT&year=2017

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
