# NTSB investigations: Dehavilland DHC-6-300: Airframe/component/system failure/malfunction

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 SEA01TA083](https://openairdocs.org/ntsb/SEA01TA083.md): de Havilland DHC-6-300 · Star, ID · Accident · No injuries · Final report · May 1, 2001 · N49SJ · Substantial damage
  > Fatigue failure of the nose wheel steering cable during the landing roll. Rough/uneven terrain was a factor.
- [NTSB DEN91LA082](https://openairdocs.org/ntsb/DEN91LA082.md): Boeing DHC-6-300 · Denver, CO · Accident · No injuries · Limited investigation · Final report · Jun 12, 1991 · N242CA · Substantial damage
  > The pilot's failure to perform an adequate preflight, I.e., not following the check list and the normal brake system was inoperative as a result of no hydraulic system pressure (hydraulic system circuit breaker not 'in').
- [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…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2802630')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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