# NTSB investigations, 2017: Inflight upset

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 WPR18LA055](https://openairdocs.org/ntsb/WPR18LA055.md): Kelley Derrick/Leza Aircam · Newport, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 23, 2017 · N959M · Substantial damage
  > The pilot’s failure to maintain airplane control while on final approach for landing in crosswind conditions, which resulted in a collision with trees.
- [NTSB WPR18LA029](https://openairdocs.org/ntsb/WPR18LA029.md): Bell 206 · Rolling Fork, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 7, 2017 · N93PH · Substantial damage
  > An uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.
- [NTSB WPR17IA086](https://openairdocs.org/ntsb/WPR17IA086.md): Beech A36TC · Livermore, CA · Incident · No injuries · Class 3 · Incident · Final report · Apr 10, 2017 · N755R · Minor damage
  > A mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…
- [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.
- [NTSB CEN17WA087](https://openairdocs.org/ntsb/CEN17WA087.md): Cessna 560 · Gardermoen, Norway · Accident · No injuries · Foreign investigation · Jan 11, 2017 · LN-IDB · Substantial damage
  > On January 11, 2017, about 1521 UTC, a Cessna 560, Norwegian registration LN-IDB, experienced a control upset during departure from the Oslo Airport (ENGM), Gardermoan, Norway. The two pilots on board were not injured. The airplane sustained substantial…

## 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '271' 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/271/sequence?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.