# NTSB investigations: Dehavilland DHC-6-300: Miscellaneous/other

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 LAX97LA157](https://openairdocs.org/ntsb/LAX97LA157.md): de Havilland DHC-6-300 · Hilo, HI · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1997 · N242CA · Destroyed
  > the pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.
- [NTSB LAX87IA176](https://openairdocs.org/ntsb/LAX87IA176.md): de Havilland DHC-6-300 · Agana (Pacific Ocean) · Incident · No injuries · Incident investigation · Final report · Apr 11, 1987 · N96RA · No damage
  > As the aircraft approached its home airport at Agana, guam the captain passed out. The first officer took over the controls and landed the acft without further incident. The cause of the incapacitation was not determined.

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

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

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