# NTSB investigations, 2014: Resources

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 DCA15MA019](https://openairdocs.org/ntsb/DCA15MA019.md): Scaled Composites 339 · Koehn Dry Lake, CA · Accident · 1 fatal · Class 1 · Major · Final report · Oct 31, 2014 · N339SS · Destroyed
  > Scaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…
- [NTSB OPS14IA011](https://openairdocs.org/ntsb/OPS14IA011.md): Boeing 777 - 236 · Shemya, AK · Incident · No injuries · Incident investigation · Final report · Aug 16, 2014 · N773AN · No damage
  > The air traffic controller’s failure to identify a conflict between two aircraft and to issue an adequate clearance, which resulted in a loss of required separation. Contributing to the incident was the Federal Aviation Administration’s failure to provide…
- [NTSB CEN14LA390](https://openairdocs.org/ntsb/CEN14LA390.md): Bell 206B · Bennet, NE · Accident · No injuries · Limited investigation · Final report · Jul 26, 2014 · N240SJ · Substantial damage
  > A total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.
- [NTSB CEN14CA391](https://openairdocs.org/ntsb/CEN14CA391.md): Continental Copters Tomcat MK5A · Osage, MN · Accident · No injuries · Data collection · Final report · Jul 25, 2014 · N161SH · Substantial damage
  > The total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…

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

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

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