# NTSB investigations, 1986: 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 LAX87LA013](https://openairdocs.org/ntsb/LAX87LA013.md): Piper PA-30 · Oceanside, CA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N7982Y · Destroyed
  > During a x-country flt, the plt stated, that just south of los angeles international arpt, the acft's right engine was running rough. At the same time pwr in the left engine began decreasing, then the prop automatically feathered. The plt attempted a re-start…
- [NTSB LAX86LA357](https://openairdocs.org/ntsb/LAX86LA357.md): Cessna 210N · Douglas, AZ · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N5340U · Substantial damage
  > The acft was found abandoned 25 miles west of Douglas, Arizona. A landing was made on a dirt road where the acft contacted a ditch and nosed over. The acft was reported stolen and the plt was not located. According to the local sheriff's office, traces of…
- [NTSB CHI86LA228](https://openairdocs.org/ntsb/CHI86LA228.md): Piper PA-31-310 · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N707HB · Substantial damage
  > At the end of an uneventful flight the pilot lowered the landing gear and noted three gear down indicator lights. Upon landing rollout the nose gear collapsed. An inspection following the accident revealed that a hydraulic leak was present near the hydraulic…
- [NTSB ATL86LA254](https://openairdocs.org/ntsb/ATL86LA254.md): Piper PA-25 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N9101D · Destroyed
  > The acft was about 1/2 hrs into a planned 2.0 hr banner tow flt. On the last pass along the Beach, at about 500 ft AGL, the eng popped and lost pwr. The plt turned the acft out to sea and landed in the ocean. The plt swam to shore and the acft sank.
- [NTSB ANC86LA062](https://openairdocs.org/ntsb/ANC86LA062.md): Lake LA-4-200 · Lake Clark, AK · Accident · 3 fatal · Limited investigation · Final report · May 24, 1986 · N6190V · Destroyed
  > The aircraft crashed in Lake Clark, Alaska, and sank into 170 feet of water. There were no witnesses to the accident; the aircraft was not recovered.
- [NTSB LAX86FA183](https://openairdocs.org/ntsb/LAX86FA183.md): Cessna 150B · Bermuda Dunes, CA · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1986 · N1118Y · Destroyed
  > The purpose of the research & development flight was to document through the use of videotape the deployment & trajectory of a speciality parachute which was connected to a ballast bag. The plt, who was the designer of the device, utilized his experimental…
- [NTSB ATL86FA066](https://openairdocs.org/ntsb/ATL86FA066.md): Cessna 152 · Lexington, NC · Accident · 2 fatal · Field investigation · Final report · Jan 30, 1986 · N25277 · Substantial damage
  > The plt/mechanic had completed a top overhaul on the acft eng and was believed to have been conducting a night maintenance flight when the accident occurred. The acft impacted the ground in a near vertical attitude in a wooded areaaprx one mile from the…
- [NTSB DEN86LA068](https://openairdocs.org/ntsb/DEN86LA068.md): Cameron 0-77 · Rio Rancho, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1986 · N3SB · Substantial damage
  > The plt stated that during the inflation of his balloon, the safety line holding the basket to his support vehicle broke during windy conditions. According to the plt, he tried to inflate the envelope in order to climb above buildings nearby. The plt…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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") = 1986
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 800)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/800/cases?year=1986

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