# NTSB investigations: Beech D18S, HI

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 LAX92LA042](https://openairdocs.org/ntsb/LAX92LA042.md): Beech D18S · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Nov 10, 1991 · N4193 · Substantial damage
  > The aircraft's lack of single engine performance to maintain altitude after the engine lost power. Factors related to the accident were: displacement/mechanical interference within the accessory drive gear system of the left engine, failure of the left engine…
- [NTSB LAX88LA044](https://openairdocs.org/ntsb/LAX88LA044.md): Beech D18S · Mokuleia, HI · Accident · No injuries · Limited investigation · Final report · Nov 15, 1987 · N802H · Substantial damage
  > The plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…
- [NTSB LAX80FJA19](https://openairdocs.org/ntsb/LAX80FJA19.md): Beech D18S · Honolulu, HI · Accident · Minor injuries · Closed · Jun 22, 1980 · N191U · Substantial damage
- [NTSB LAX80FA033](https://openairdocs.org/ntsb/LAX80FA033.md): Beech D18S · Honolulu, HI · Accident · 2 fatal · Closed · Jan 8, 1980 · N641E · Destroyed
- [NTSB DCA72AZ008](https://openairdocs.org/ntsb/DCA72AZ008.md): Beech D18S · Molokai, HI · Accident · 8 fatal · Closed · Feb 22, 1972 · N5642V · Destroyed
- [NTSB UNK64X0232](https://openairdocs.org/ntsb/UNK64X0232.md): Beechcraft D18S · Kaanapali, HI · Accident · Minor injuries · Closed · Jan 12, 1964 · N2424E · Substantial 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."eventStateOrRegion" = 'HI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151004'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151004&state=HI

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