# NTSB investigations, 2012: Training

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 ANC13FA017](https://openairdocs.org/ntsb/ANC13FA017.md): Eurocopter AS350 B3 · Beluga, AK · Accident · Serious injuries · Field investigation · Final report · Dec 15, 2012 · C-GYPH · Substantial damage
  > The pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…
- [NTSB ANC12GA114](https://openairdocs.org/ntsb/ANC12GA114.md): Quest Kodiak 100 · Anchorage, AK · Accident · No injuries · Final report · Sep 30, 2012 · N745 · Substantial damage
  > The pilot's failure to maintain directional control while landing, which resulted in a collision with the water. Contributing to the accident were the pilot's lack of experience conducting waterborne operations in the accident make and model airplane and the…
- [NTSB DCA12FA058](https://openairdocs.org/ntsb/DCA12FA058.md): Bombardier DHC-8-402 · Houston, TX · Accident · No injuries · Field investigation · Final report · Apr 7, 2012 · N213WQ · Substantial damage
  > the nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…
- [NTSB ERA12TA251](https://openairdocs.org/ntsb/ERA12TA251.md): Bell 407 · Delray Beach, FL · Accident · Minor injuries · Final report · Mar 23, 2012 · N31PB · Substantial damage
  > The pilot’s improper response to a simulated engine failure and the instructor’s delayed and improper remedial action.

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

This list as a web page: https://openairdocs.org/ntsb-findings/040310/cases?year=2012

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