# NTSB investigations, 2017: Indicating/recording systems

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 CEN17LA303](https://openairdocs.org/ntsb/CEN17LA303.md): Cessna A188B · Marshall, MO · Accident · No injuries · Limited investigation · Final report · Aug 4, 2017 · N3047J · Substantial damage
  > The pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…
- [NTSB WPR17LA159](https://openairdocs.org/ntsb/WPR17LA159.md): Robinson Helicopter R44 II · Van Nuys, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 2017 · N3254E · Substantial damage
  > An improper repair of the right magneto's tachometer and governor signal wire, which failed during cruise flight and initiated a simultaneous malfunction of both the engine tachometer and governor control system, which resulted in erroneous and contradictory…
- [NTSB DCA17IA148](https://openairdocs.org/ntsb/DCA17IA148.md): Airbus A320-211 · San Francisco, CA · Incident · No injuries · Class 1 · Incident · Final report · Jul 8, 2017 · C-FKCK · No damage
  > The flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…
- [NTSB CEN17FA252](https://openairdocs.org/ntsb/CEN17FA252.md): Airbus Helicopters Deutschland MBB-BK 117 B-2 · Perryville, MO · Accident · Minor injuries · Field investigation · Final report · Jul 2, 2017 · N238BK · Substantial damage
  > Fuel starvation due to the pilot’s failure to turn on the fuel transfer pump switches during takeoff, which led to a total loss of engine power. Contributing to the accident was the pilot's improper decision to activate the annunciator panel’s dimming…
- [NTSB ERA17LA163](https://openairdocs.org/ntsb/ERA17LA163.md): Robinson R44 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 2017 · N899GB · Substantial damage
  > A partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…
- [NTSB GAA17CA215](https://openairdocs.org/ntsb/GAA17CA215.md): Cessna 182 · Blue Earth, MN · Accident · Minor injuries · Data collection · Final report · Apr 3, 2017 · N8889X · Substantial damage
  > The pilot's decision to continue the night, visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain while on final approach. Contributing to the accident was the pilot's improper use of an electronic flight…
- [NTSB ERA17LA125](https://openairdocs.org/ntsb/ERA17LA125.md): Grob G120TP-A · Abbeville, AL · Accident · Serious injuries · Class 2 · Limited · Final report · Mar 8, 2017 · N196TP · Substantial damage
  > The flame-out of the engine due to a mis-set fuel control unit at the time of manufacture. Contributing to the accident was the pilots’ delayed recognition that the engine had flamed out, partially due to the operator’s requirement to disable the crew…

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

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