# NTSB investigations, 2017: Task environment

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 GAA18CA034](https://openairdocs.org/ntsb/GAA18CA034.md): Airbus Helicopters EC 130 · La Paloma, TX · Accident · No injuries · Data collection · Final report · Oct 26, 2017 · N22TZ · Substantial damage
  > The separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.
- [NTSB ERA17MA316](https://openairdocs.org/ntsb/ERA17MA316.md): Eurocopter Deutschland MBB BK 117 · Hertford, NC · Accident · 4 fatal · Class 2 · Major · Final report · Sep 8, 2017 · N146DU · Destroyed
  > A failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…
- [NTSB GAA17CA465](https://openairdocs.org/ntsb/GAA17CA465.md): Czech Aircraft Works Spol Sro Sportcruiser · Salisbury, NC · Accident · No injuries · Data collection · Final report · Aug 4, 2017 · N777NG · Substantial damage
  > The physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.
- [NTSB GAA17CA458](https://openairdocs.org/ntsb/GAA17CA458.md): Randall Marvin L Vans RV 3A · Spokane, WA · Accident · No injuries · Data collection · Final report · Jul 28, 2017 · N16MR · 2 aircraft · Substantial damage
  > The other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.
- [NTSB CEN17FA288](https://openairdocs.org/ntsb/CEN17FA288.md): Zenith CH701SP · Laddonia, MO · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2017 · N701XL · Destroyed
  > The pilot's decision to take off at night and continue visual flight into instrument meteorological conditions. which resulted in the pilot becoming spatially disoriented and losing control of the airplane. Contributing to the accident were the pilot's…
- [NTSB GAA17CA299](https://openairdocs.org/ntsb/GAA17CA299.md): Thomas E Hudzinski Backcountry Super CR · Talkeetna, AK · Accident · No injuries · Data collection · Final report · May 21, 2017 · N484WT · Substantial damage
  > The pilot’s failure to maintain a proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [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 GAA17CA223](https://openairdocs.org/ntsb/GAA17CA223.md): Piper J3C · New Carlisle, OH · Accident · No injuries · Data collection · Final report · Apr 8, 2017 · N88470 · 2 aircraft · Substantial damage
  > The other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.
- [NTSB ERA17FA143](https://openairdocs.org/ntsb/ERA17FA143.md): Cessna 170B · Edgewater, FL · Accident · 2 fatal · Field investigation · Final report · Apr 1, 2017 · N8082A · 2 aircraft · Destroyed
  > The Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.
- [NTSB WPR17FA066](https://openairdocs.org/ntsb/WPR17FA066.md): Cessna T310Q · Riverside, CA · Accident · 4 fatal · Field investigation · Final report · Feb 28, 2017 · N1246G · Destroyed
  > The pilot's failure to maintain airplane control upon entering instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's personal pressure…

## 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", '0304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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