# NTSB investigations, 2017: Emergency descent initiated

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 WPR17FA179](https://openairdocs.org/ntsb/WPR17FA179.md): Michaelian Lancair IV-TP · Rio Linda, CA · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2017 · N420M · Substantial damage
  > A loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR17LA176](https://openairdocs.org/ntsb/WPR17LA176.md): Cessna 172S · Seattle, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 31, 2017 · N957TA · Substantial damage
  > The total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.
- [NTSB WPR17LA104](https://openairdocs.org/ntsb/WPR17LA104.md): Evolution Air Lancair Evolution · Firebaugh, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 15, 2017 · N846PM · Substantial damage
  > A failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.
- [NTSB CEN17FA071](https://openairdocs.org/ntsb/CEN17FA071.md): Columbia Aircraft Mfg LC41 550FG · Gurdon, AR · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2017 · N972JK · Destroyed
  > The loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.

## 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" = '130' 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/130/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.