# Fatal NTSB investigations, 2017: Other weather encounter

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 CEN18FA061](https://openairdocs.org/ntsb/CEN18FA061.md): Cessna 340 · Bartow, FL · Accident · 5 fatal · Field investigation · Final report · Dec 24, 2017 · N247AT · Destroyed
  > The pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.
- [NTSB CEN17FA361](https://openairdocs.org/ntsb/CEN17FA361.md): Cessna TR182 · Thief River Falls, MN · Accident · 3 fatal · Field investigation · Final report · Sep 23, 2017 · N4777T · Destroyed
  > The noninstrument-rated pilot's decision to depart into instrument meteorological conditions, and his subsequent loss of control due to spatial disorientation.
- [NTSB ERA17FA181](https://openairdocs.org/ntsb/ERA17FA181.md): Mitsubishi MU2B · Eleuthera, Bahamas · Accident · 4 fatal · Field investigation · Final report · May 15, 2017 · N220N · Destroyed
  > The pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.
- [NTSB ERA17FA174](https://openairdocs.org/ntsb/ERA17FA174.md): Cirrus Design SR22 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · May 5, 2017 · N271TS · Substantial damage
  > The pilot's decision to attempt to land while a line of rain showers with microburst activity was crossing the airport, which resulted in a loss of control during a subsequent attempted go-around.
- [NTSB CEN17FA103](https://openairdocs.org/ntsb/CEN17FA103.md): Bell Helicopter Textron Canada 429 · Shreveport, LA · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2017 · N598PB · Substantial damage
  > The pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' 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/400/sequence?fatal=1&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.
