# NTSB investigations: Dehavilland DHC-7-102

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 NYC88FA238](https://openairdocs.org/ntsb/NYC88FA238.md): de Havilland DH-7-58C · Albany, NY · Accident · Serious injuries · Field investigation · Final report · Sep 22, 1988 · N170RA · Substantial damage
  > The acft experienced an uncontained disintegration of the no.2 engine. Scorched engine fragments ripped through the fuselage injuring two passengers, one seriously. The uncontained failure was the result of wear or spalling of the 1st stage reduction gear and…
- [NTSB LAX84LA115](https://openairdocs.org/ntsb/LAX84LA115.md): de Havilland DHC 7-102 · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1983 · N929HA · No damage
  > While on a five mile final apch to rwy 26R the dhc 7 encountered moderate turbulence and two cabin attendants sustained injuries. At 1506:02 hours HST a western airlines DC10 requested an s turn to lose altitude in order land on rwy 26L. Seven seconds later…
- [NTSB DEN80IA055](https://openairdocs.org/ntsb/DEN80IA055.md): Dehavilland DHC-7 · Denver, CO · Incident · No injuries · Closed · Aug 18, 1980 · N47RM · Minor damage
- [NTSB DEN79IA026](https://openairdocs.org/ntsb/DEN79IA026.md): Dehavilland DHC-7 · Denver, CO · Incident · No injuries · Closed · Mar 3, 1979 · N27RM · Minor damage
- [NTSB DEN78FI012](https://openairdocs.org/ntsb/DEN78FI012.md): Dehavilland DHC-7 · Denver, CO · Incident · No injuries · Closed · Dec 6, 1977 · N27RM · Minor damage

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

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

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