# NTSB investigations, 1992: Uncontrolled descent

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 SEA93LA001](https://openairdocs.org/ntsb/SEA93LA001.md): Hughes 269C · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Oct 1, 1992 · N7400F · Substantial damage
  > The pilot in command's failure to maintain proper altitude during the hover. Factors contributing to the accident were the pilot in command's lack of total experience in rotorcraft and his diversion of attention while hovering.
- [NTSB LAX92LA379](https://openairdocs.org/ntsb/LAX92LA379.md): Ayres S2R-600 · Tranquillity, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1992 · N5674X · Substantial damage
  > The pilot's improper inflight planning; his failure to attain the proper descent rate; and the excessive descent. Contributing to this accident was the landing gear collapse due to overload.
- [NTSB NYC92LA177](https://openairdocs.org/ntsb/NYC92LA177.md): Aerostar AX-9 · Hopkinton, MA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1992 · N28267 · Substantial damage
  > The pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.
- [NTSB ANC92LA112](https://openairdocs.org/ntsb/ANC92LA112.md): Piper J3C-65 · Cloudy Lake, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1992 · N21375 · Substantial damage
  > The pilot failed to enter an aerobatic maneuver with sufficient altitude to effect a recovery prior to ground impact.
- [NTSB LAX92LA255](https://openairdocs.org/ntsb/LAX92LA255.md): Stinson 108-3 · Window Rock, AZ · Accident · No injuries · Limited investigation · Final report · Jun 19, 1992 · N589C · Substantial damage
  > The failure of the pilot to calculate the aircraft's performance data and perform a weather evauluation. The existing high density altitude was a factor in the accident.
- [NTSB LAX92LA153](https://openairdocs.org/ntsb/LAX92LA153.md): Beech F33A · Payson, AZ · Accident · 2 fatal · Limited investigation · Final report · Mar 27, 1992 · N8000J · Destroyed
  > The pilot's poor preflight planning/preparation by intentionally flying into known adverse weather and his poor in-flight decision by not flying to an alternate airport when the airplane began to encounter icing. Contributing to this accident was the icing…
- [NTSB FTW92LA089](https://openairdocs.org/ntsb/FTW92LA089.md): Ayres S2R-T34 · Wright, AR · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 1992 · N41KM · Destroyed
  > The failure of the pilot to maintain altitude due to diverted attention.
- [NTSB FTW92LA079](https://openairdocs.org/ntsb/FTW92LA079.md): Burkhart Grob G103 · Boerne, TX · Accident · No injuries · Limited investigation · Final report · Mar 1, 1992 · N94BG · Substantial damage
  > The pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.
- [NTSB ANC92LA038](https://openairdocs.org/ntsb/ANC92LA038.md): Cessna 180 · Shishmaref, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1992 · N2788X · Substantial damage
  > The non-instrumented rated pilot-in-command attempted visual flight into known instrument meteorological conditions. Factors contributing to the accident were the fog, the icing conditions, and the pilot's over confidence in his personal ability.

## 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") = 1992
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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