# Fatal NTSB investigations, 2018: 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 ERA19LA026](https://openairdocs.org/ntsb/ERA19LA026.md): Piper PA31T · Atlantic Ocean (Atlantic Ocean) · Accident · 5 fatal · Limited investigation · Final report · Oct 25, 2018 · N555PM · Destroyed
  > An in-flight loss of control, which resulted in an impact with water, for reasons that could not be determined because the airplane was not recovered.
- [NTSB ANC18LA057](https://openairdocs.org/ntsb/ANC18LA057.md): Aeros Venture 2000 · Bad Axe, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 2018 · N43865 · Substantial damage
  > The pilot's loss of aircraft control for reasons that could not be determined based on the available information.
- [NTSB WPR18WA123](https://openairdocs.org/ntsb/WPR18WA123.md): Cessna T210N · Oudtshoorn, South Africa · Accident · 2 fatal · Foreign investigation · Feb 25, 2018 · ZS-KOM · Destroyed
- [NTSB WPR18FA091](https://openairdocs.org/ntsb/WPR18FA091.md): Piper PA34 · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2018 · N14GQ · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.
- [NTSB WPR18FA088](https://openairdocs.org/ntsb/WPR18FA088.md): Hastings Thomas G Cirrus VK 30 · Agua Dulce, CA · Accident · 4 fatal · Field investigation · Final report · Feb 11, 2018 · N52TH · Substantial damage
  > The driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…

## 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") = 2018
  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" = '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?fatal=1&year=2018

---
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.
