# NTSB investigations, 1987: Altitude deviation,uncontrolled

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 DEN87FA234](https://openairdocs.org/ntsb/DEN87FA234.md): Piper PA-12-150 · Anaconda, MT · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1987 · N7695H · Destroyed
  > Both plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently…
- [NTSB ANC87LA136](https://openairdocs.org/ntsb/ANC87LA136.md): Piper PA-18 · High Lake, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 1987 · N9775D · Substantial damage
  > The pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second…
- [NTSB LAX87FA087](https://openairdocs.org/ntsb/LAX87FA087.md): Cessna 208 · Cima, CA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1987 · N9613F · Destroyed
  > While on a day/vfr flt from ontario, CA to las vegas, NV, the acft collided with mountainous terrain near the top of a 6500' peak. Radar data showed that aprx 20 min before the acdnt, the acft began a gradual dscnt from about 10,000'. No preimpact part…
- [NTSB MIA87LA070](https://openairdocs.org/ntsb/MIA87LA070.md): Smith, Ted Aerostar Aerostar 601 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Jan 10, 1987 · N181X · Substantial damage
  > The plt stated that he was conducting an over water apch to rwy 17 when he observed traffic preparing to land ahead of him. He slowed the acft for traffic separation, lowered the gear, & extended partial flaps. He then stated that he felt an abnormal loss of…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 110)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=110&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.