# NTSB investigations: Upgrade 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 CEN14LA036](https://openairdocs.org/ntsb/CEN14LA036.md): Cessna 182L · Superior, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2013 · N70520 · 2 aircraft · Destroyed
  > The failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.
- [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.
- [NTSB DCA09FA048](https://openairdocs.org/ntsb/DCA09FA048.md): Boeing DC-10 · Baltimore, MD · Accident · Serious injuries · Field investigation · Final report · May 6, 2009 · N139WA · Substantial damage
  > the captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…

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

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