# NTSB investigations, 2017: Knowledge

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 ERA18LA020](https://openairdocs.org/ntsb/ERA18LA020.md): Bell 206 · Union City, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 8, 2017 · N275AE · Substantial damage
  > The pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.
- [NTSB DCA17IA202](https://openairdocs.org/ntsb/DCA17IA202.md): DJI Phantom · Hoffman Island, NY · Incident · No injuries · Incident investigation · Final report · Sep 21, 2017 · UNREG · 2 aircraft · Destroyed
  > the failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.
- [NTSB CEN17LA156](https://openairdocs.org/ntsb/CEN17LA156.md): Loomis Xenon 4 · Knoxville, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N912XV · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.
- [NTSB ERA17FA135](https://openairdocs.org/ntsb/ERA17FA135.md): Cessna 500 · Marietta, GA · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N8DX · Destroyed
  > The pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…
- [NTSB GAA17CA179](https://openairdocs.org/ntsb/GAA17CA179.md): Burkhart Grob G 109B · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Mar 8, 2017 · N109FH · Substantial damage
  > The failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.
- [NTSB GAA17CA135](https://openairdocs.org/ntsb/GAA17CA135.md): Hughes OH 6A · Price, UT · Accident · No injuries · Data collection · Final report · Feb 8, 2017 · N6640Z · Substantial damage
  > The fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.
- [NTSB CEN17FA100](https://openairdocs.org/ntsb/CEN17FA100.md): Bell 206B · Galveston, TX · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2017 · N978RH · Destroyed
  > The pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020320'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/020320/cases?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.
