# Final NTSB investigations, OK: 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 FTW95LA247](https://openairdocs.org/ntsb/FTW95LA247.md): Air Tractor AT-301 · Guymon, OK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1995 · N315PF · Destroyed
  > The pilot's failure to maintain airspeed. The high density altitude was a factor.
- [NTSB FTW87LA073](https://openairdocs.org/ntsb/FTW87LA073.md): Balloon Works Firefly 7-B · Broken Arrow, OK · Accident · No injuries · Limited investigation · Final report · Mar 5, 1987 · N15253 · Substantial damage
  > The Balloon drifted into power lines just after liftoff. The pilot stated he was hooking up a new temperature gauge and did not notice that the Balloon was descending.
- [NTSB FTW84FA035](https://openairdocs.org/ntsb/FTW84FA035.md): Cessna 310 · Fairview, OK · Accident · 2 fatal · Field investigation · Final report · Oct 30, 1983 · N5343A · Destroyed
  > The acft was observed to take off at about 1830. Witnesses near the crash site reported seeing & hearing a low flying acft at about 2000 & stated the engs were running smoothly. There was fog in the low areas with visibility of less than 1/4 mi in those…
- [NTSB DCA82AA001](https://openairdocs.org/ntsb/DCA82AA001.md): Learjet 24 · Felt, OK · Accident · 3 fatal · Closed · Oct 1, 1981 · N44CJ · Destroyed
- [NTSB FTW81FA128](https://openairdocs.org/ntsb/FTW81FA128.md): Piper PA-28 · Mcalester, OK · Accident · 3 fatal · Closed · Jul 30, 1981 · N2209Z · Destroyed
- [NTSB FTW81FA121](https://openairdocs.org/ntsb/FTW81FA121.md): Mooney M20J · Eagletown, OK · Accident · 2 fatal · Closed · Jun 6, 1981 · N1039C · Destroyed
- [NTSB FTW81FA074](https://openairdocs.org/ntsb/FTW81FA074.md): Beech E35 · Fay, OK · Accident · 4 fatal · Closed · Apr 18, 1981 · N3281C · Destroyed
- [NTSB FTW81FA005](https://openairdocs.org/ntsb/FTW81FA005.md): Grum Amer AA-5B · Madill, OK · Accident · 4 fatal · Closed · Oct 16, 1980 · N28252 · Destroyed
- [NTSB FTW80FA046](https://openairdocs.org/ntsb/FTW80FA046.md): Piper PA-32 · Ardmore, OK · Accident · 5 fatal · Closed · Feb 20, 1980 · N56482 · Destroyed
- [NTSB FTW80FPM03](https://openairdocs.org/ntsb/FTW80FPM03.md): Benson B8M · Sand Springs, OK · Accident · 1 fatal · Closed · Nov 19, 1979 · N6933 · Destroyed
- [NTSB FTW79FA029](https://openairdocs.org/ntsb/FTW79FA029.md): Cessna 172N · Ada, OK · Accident · 4 fatal · Closed · Dec 20, 1978 · N75819 · Destroyed
- [NTSB FTW78FA006](https://openairdocs.org/ntsb/FTW78FA006.md): Piper PA-30 · Wetumka, OK · Accident · 2 fatal · Closed · Oct 23, 1977 · N7623Y · Destroyed
- [NTSB FTW77FA074](https://openairdocs.org/ntsb/FTW77FA074.md): Beech V35A · Idabel, OK · Accident · 3 fatal · Closed · Sep 12, 1977 · N800SC · Destroyed
- [NTSB FTW77FA071](https://openairdocs.org/ntsb/FTW77FA071.md): Piper PA-28R · Healdton, OK · Accident · 1 fatal · Closed · Aug 19, 1977 · N38140 · Destroyed
- [NTSB FTW76AF126](https://openairdocs.org/ntsb/FTW76AF126.md): Piper PA-28 · Greenfield, OK · Accident · 1 fatal · Closed · Sep 26, 1976 · N55481 · Destroyed
- [NTSB FTW76FPM30](https://openairdocs.org/ntsb/FTW76FPM30.md): Hughes 269C · Vinita, OK · Accident · Serious injuries · Closed · Sep 25, 1976 · N7453F · Destroyed
- [NTSB FTW76AF124](https://openairdocs.org/ntsb/FTW76AF124.md): Bellanca 17-30 · Eagletown, OK · Accident · 1 fatal · Closed · Sep 18, 1976 · N4885V · Destroyed
- [NTSB FTW76AF046](https://openairdocs.org/ntsb/FTW76AF046.md): Beech V35A · Davenport, OK · Accident · 1 fatal · Closed · Nov 21, 1975 · N7798R · Destroyed
- [NTSB FTW75AK018](https://openairdocs.org/ntsb/FTW75AK018.md): Aero Comdr 100 · Inola, OK · Accident · 3 fatal · Closed · Sep 10, 1974 · N2970T · Destroyed
- [NTSB FTW74AF065](https://openairdocs.org/ntsb/FTW74AF065.md): Beech 35 · Fanshawe, OK · Accident · 3 fatal · Closed · Mar 10, 1974 · N3125V · Destroyed
- [NTSB FTW74DPJ20](https://openairdocs.org/ntsb/FTW74DPJ20.md): Piper PA-25 · Eldorado, OK · Accident · No injuries · Closed · Jan 30, 1974 · N8848L · Substantial damage
- [NTSB FTW74AF044](https://openairdocs.org/ntsb/FTW74AF044.md): Piper PA-23 · Weatherford, OK · Accident · 2 fatal · Closed · Dec 18, 1973 · N14099 · Destroyed
- [NTSB FTW74AF037](https://openairdocs.org/ntsb/FTW74AF037.md): Cessna 180B · Enid, OK · Accident · 1 fatal · Closed · Nov 23, 1973 · N5083E · Destroyed
- [NTSB FTW73AF057](https://openairdocs.org/ntsb/FTW73AF057.md): Cessna 172G · Tuttle, OK · Accident · 3 fatal · Closed · Apr 7, 1973 · N7539G · Destroyed
- [NTSB FTW73AF039](https://openairdocs.org/ntsb/FTW73AF039.md): Lockheed TV-2 · Burns Flat, OK · Accident · 1 fatal · Closed · Jan 24, 1973 · N152 · Destroyed
- [NTSB FTW69A0009](https://openairdocs.org/ntsb/FTW69A0009.md): Cessna U206C · Miami, OK · Accident · 6 fatal · Closed · Aug 19, 1968 · N3996G · Destroyed
- [NTSB FTW68A0057](https://openairdocs.org/ntsb/FTW68A0057.md): Piper PA-22 · Porum, OK · Accident · 1 fatal · Closed · Dec 1, 1967 · N7007B · Destroyed
- [NTSB FTW68A0056](https://openairdocs.org/ntsb/FTW68A0056.md): Piper PA-24 · Enid, OK · Accident · 2 fatal · Closed · Nov 30, 1967 · N6020P · Destroyed
- [NTSB FTW68A0023](https://openairdocs.org/ntsb/FTW68A0023.md): Piper PA-28 · Springer, OK · Accident · 2 fatal · Closed · Aug 31, 1967 · N7452R · Destroyed
- [NTSB FTW68A0012](https://openairdocs.org/ntsb/FTW68A0012.md): Piper PA-16 · Duncan, OK · Accident · 2 fatal · Closed · Aug 2, 1967 · N5800H · Destroyed
- [NTSB FTW68A0005](https://openairdocs.org/ntsb/FTW68A0005.md): Piper PA-28 · Tonkawa, OK · Accident · 2 fatal · Closed · Jul 16, 1967 · N8954J · Destroyed
- [NTSB MKC66A0056](https://openairdocs.org/ntsb/MKC66A0056.md): Piper PA-22 · Elk City, OK · Accident · 1 fatal · Closed · Apr 29, 1966 · N2802P · Destroyed
- [NTSB FTW66A0041](https://openairdocs.org/ntsb/FTW66A0041.md): Cessna 182H · Moore, OK · Accident · 2 fatal · Closed · Nov 5, 1965 · N1850X · Destroyed
- [NTSB FTW66A0040](https://openairdocs.org/ntsb/FTW66A0040.md): Beech 95-55 · Lawton, OK · Accident · 2 fatal · Closed · Nov 3, 1965 · N1344Z · Destroyed
- [NTSB FTW66A0035](https://openairdocs.org/ntsb/FTW66A0035.md): Cessna 182B · Tulsa, OK · Accident · 1 fatal · Closed · Oct 7, 1965 · N2300G · Destroyed
- [NTSB FTW66A0007](https://openairdocs.org/ntsb/FTW66A0007.md): Cessna 172 · 2e Chelsea, OK · Accident · 1 fatal · Closed · Jul 25, 1965 · N7031A · Destroyed
- [NTSB FTW65A0077](https://openairdocs.org/ntsb/FTW65A0077.md): Hughes 269A · Oklahoma Cty, OK · Accident · Serious injuries · Closed · Jan 25, 1965 · N8883F · Destroyed
- [NTSB FTW65A0067](https://openairdocs.org/ntsb/FTW65A0067.md): Cessna 182B · Kla City, OK · Accident · 3 fatal · Closed · Jan 5, 1965 · N2401G · Destroyed

## 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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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?state=OK&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
