# NTSB investigations: Dehavilland DHC-3, 2015

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 ANC15FA071](https://openairdocs.org/ntsb/ANC15FA071.md): Dehavilland DHC 3T · Iliamna, AK · Accident · 3 fatal · Field investigation · Final report · Sep 15, 2015 · N928RK · Substantial damage
  > The pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…
- [NTSB ANC15MA041](https://openairdocs.org/ntsb/ANC15MA041.md): Dehavilland DHC-3 · Ketchikan, AK · Accident · 9 fatal · Class 1 · Major · Final report · Jun 25, 2015 · N270PA · Substantial damage
  > (1) the pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in his geographic disorientation and controlled flight into terrain; and (2) Promech's company culture, which tacitly endorsed flying in…
- [NTSB ANC15LA037](https://openairdocs.org/ntsb/ANC15LA037.md): Dehavilland DHC-3T · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jun 4, 2015 · N3125N · Substantial damage
  > The flutter failure of the right elevator servo tab due to the improper fabrication of the servo tab and maintenance personnel’s subsequent failure to detect anomalies with the servo tab.

## 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") = 2015
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802412', '2800202', '2802414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2802412&year=2015

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