# NTSB investigations: Bombardier DHC-8-202

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 DCA16CA226](https://openairdocs.org/ntsb/DCA16CA226.md): Bombardier DHC 8 202 · Dulles, VA · Accident · No injuries · Data collection · Final report · Sep 24, 2016 · N366PH · Substantial damage
  > incorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.
- [NTSB ENG15IA024](https://openairdocs.org/ntsb/ENG15IA024.md): Bombardier DHC 8 · Windsor Locks, CT · Incident · No injuries · Incident investigation · Final report · Jun 5, 2015 · N363PH · Minor damage
  > The arcing failure of the windshield heat power wire on the right windshield due to unknown reasons. Contributing to the severity of the fire was the lack of training or guidance provided to the crew for selecting the windshield heat to off that would cut…
- [NTSB ERA09LA529](https://openairdocs.org/ntsb/ERA09LA529.md): Bombardier DHC-8-202 · Sterling, VA · Accident · No injuries · Limited investigation · Final report · Aug 29, 2009 · N367PH · Substantial damage
  > Undetermined.
- [NTSB SEA05LA184](https://openairdocs.org/ntsb/SEA05LA184.md): Airbus Industrie A330-223 · Portland, OR · Accident · No injuries · Limited investigation · Final report · Aug 29, 2005 · N855NW · 2 aircraft · Minor damage
  > The failure of the flightcrew of the other airplane to maintain clearance while taxiing.

## 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 ('1390007'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1390007

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