# NTSB investigations: Beech D18S, 1987

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 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 MIA87FA259](https://openairdocs.org/ntsb/MIA87FA259.md): Beech D18S · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1987 · N76Q · Destroyed
  > Witnesses observed the aircraft taxi to the end of runway 27R and positioned so the tail was out in the overrun area. Witnesses further stated the aircraft appeared to take an overly long takeoff roll before lifting off. After lift off, the aircraft pitched…
- [NTSB LAX87LA265](https://openairdocs.org/ntsb/LAX87LA265.md): Beech D18S · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N99CP · Substantial damage
  > The acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The…
- [NTSB DEN87MA168](https://openairdocs.org/ntsb/DEN87MA168.md): Beech D18S · Lakeside, MT · Accident · 10 fatal · Major investigation · Final report · Jul 5, 1987 · N132E · Destroyed
  > The plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…

## 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 year(c."eventDate") = 1987
  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&year=1987

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