# NTSB investigations: Dehavilland DHC-3: In flight encounter with weather

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 SEA06LA112](https://openairdocs.org/ntsb/SEA06LA112.md): de Havilland DHC-3T · Port Townsend, WA · Accident · No injuries · Limited investigation · Final report · Jun 1, 2006 · N606KA · Substantial damage
  > The pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.
- [NTSB ANC04LA098](https://openairdocs.org/ntsb/ANC04LA098.md): de Havilland DHC-3 · McGrath, AK · Accident · 1 fatal · Limited investigation · Final report · Aug 28, 2004 · N197TT · Destroyed
  > The pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.
- [NTSB SEA89FA036](https://openairdocs.org/ntsb/SEA89FA036.md): de Havilland DHC-3 · Ketchikan, AK · Accident · 2 fatal · Field investigation · Final report · Jan 15, 1989 · N11250 · Destroyed
  > The pilot's inadvertant flight into IFR conditions and the stall which occurred during the turn to reverse course. Contributing to the accident were the snow conditions encountered.
- [NTSB SEA88LA132](https://openairdocs.org/ntsb/SEA88LA132.md): De Havilland DHC-3 · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N55CX · Substantial damage
  > Plt attempted flight through a mountain pass in the presence of low clouds and fog. Visual ground reference was lost and the acft collided with a snow bank. Plt cited personal and company-induced pressures as factors. Operator completed accident report.

## 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 ('2802412', '2800202', '2802414')
    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" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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