# NTSB investigations: Dehavilland DHC-6-300, Outside the U.S.

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 MIA96WA110](https://openairdocs.org/ntsb/MIA96WA110.md): de Havilland DH6 · Virgin Gorda, British Virgin Islands · Accident · Minor injuries · Foreign investigation · Apr 7, 1996 · N143SA · Substantial damage
- [NTSB LAX84FA415](https://openairdocs.org/ntsb/LAX84FA415.md): de Havilland DHC-6-300 · Tau, Antarctica · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1984 · N43SP · Substantial damage
  > The acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company…
- [NTSB LAX80DA011](https://openairdocs.org/ntsb/LAX80DA011.md): Dehavilland DHC-6 · Tau, Antarctica · Accident · Serious injuries · Closed · Nov 5, 1979 · N23BC · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=2802630&state=OF

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