# NTSB investigations: Training, general

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 ERA17FA180](https://openairdocs.org/ntsb/ERA17FA180.md): Beech A36TC · Hopkinsville, KY · Accident · 2 fatal · Field investigation · Final report · May 12, 2017 · N1804E · Destroyed
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…
- [NTSB CEN17LA176](https://openairdocs.org/ntsb/CEN17LA176.md): Thrush S2R-H80 · Gypsum, KS · Accident · No injuries · Limited investigation · Final report · May 5, 2017 · N3045R · Substantial damage
  > A total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…
- [NTSB GAA15CA153](https://openairdocs.org/ntsb/GAA15CA153.md): Grumman American Avn. AA 5A · Mackay, ID · Accident · No injuries · Data collection · Final report · Jul 1, 2015 · N9887U · Substantial damage
  > The student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.
- [NTSB CEN14FA328](https://openairdocs.org/ntsb/CEN14FA328.md): Piper PA 28-235 · Georgetown, CO · Accident · 3 fatal · Field investigation · Final report · Jun 30, 2014 · N8814W · Destroyed
  > The pilot’s inability to maintain a climb while maneuvering the airplane in high-density altitude conditions that degraded the airplane’s climb performance and his exceedance of the airplane’s critical angle-of-attack, which led to an aerodynamic stall and…
- [NTSB CEN14LA259](https://openairdocs.org/ntsb/CEN14LA259.md): Sibley Glasair · Midlothian, TX · Accident · Serious injuries · Limited investigation · Final report · May 24, 2014 · N4VX · Destroyed
  > The pilot’s failure to maintain lateral control during the initial climb. Contributing to the accident was the pilot’s failure to obtain sufficient training and experience to operate the high-performance airplane.
- [NTSB CEN13CA144](https://openairdocs.org/ntsb/CEN13CA144.md): Mooney M20J · Warsaw, IN · Accident · No injuries · Data collection · Final report · Jan 27, 2013 · N5763H · Substantial damage
  > The pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…
- [NTSB ERA10LA391](https://openairdocs.org/ntsb/ERA10LA391.md): Turck G L/Duflo J T SEA REY · Winter Haven, FL · Accident · 1 fatal · Limited investigation · Final report · Aug 2, 2010 · N914SR · Substantial damage
  > The pilot's failure to maintain adequate airspeed on approach for landing, resulting in an inadvertent stall/spin and collision with water.
- [NTSB CEN10FA011](https://openairdocs.org/ntsb/CEN10FA011.md): Cessna 150F · Alexandria, LA · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2009 · N8642S · 2 aircraft · Substantial damage
  > Failure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.

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

This list as a web page: https://openairdocs.org/ntsb-findings/02031500/cases

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