# Final NTSB investigations, NE: 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 CHI91DCJ07](https://openairdocs.org/ntsb/CHI91DCJ07.md): Piper PA-25-150 · Stapleton, NE · Accident · No injuries · Final report · Aug 23, 1991 · N6070Z · Substantial damage
  > The pilot's disregard for aircraft performance data. Related factors are the pilot's poor weather evaluation, and delayed remedial action.
- [NTSB MKC86FCJ01](https://openairdocs.org/ntsb/MKC86FCJ01.md): Carothers Monoplane · Lincoln, NE · Accident · Serious injuries · Final report · Nov 7, 1985 · N44XP · Destroyed
  > The plt was performing aerobatics while being photographed for a promotional video. On the last pass over the arpt the acft lost airspeed and began a side slip with the left wing down. At a very low alt AGL the acft appeared to stall and assume a higher sink…
- [NTSB MKC80FA029](https://openairdocs.org/ntsb/MKC80FA029.md): Cessna 210L · Sidney, NE · Accident · 1 fatal · Closed · Apr 7, 1980 · N2120S · Destroyed
- [NTSB MKC80FA010](https://openairdocs.org/ntsb/MKC80FA010.md): Piper PA-23 · Columbus, NE · Accident · 6 fatal · Closed · Nov 25, 1979 · N6496Y · Destroyed
- [NTSB MKC79FA012](https://openairdocs.org/ntsb/MKC79FA012.md): Piper PA-32 · Virginia, NE · Accident · 3 fatal · Closed · Dec 18, 1978 · N4757S · Destroyed
- [NTSB MKC78FA050](https://openairdocs.org/ntsb/MKC78FA050.md): Piper PA-28 · Columbus, NE · Accident · 2 fatal · Closed · Jun 23, 1978 · N8993W · Destroyed
- [NTSB MKC78FA043](https://openairdocs.org/ntsb/MKC78FA043.md): Cessna 140 · Wolbach, NE · Accident · 2 fatal · Closed · May 31, 1978 · N76011 · Destroyed
- [NTSB MKC78DCJ07](https://openairdocs.org/ntsb/MKC78DCJ07.md): Mooney M10 · Emerson, NE · Accident · Minor injuries · Closed · Dec 16, 1977 · N9525V · Substantial damage
- [NTSB MKC78FA004](https://openairdocs.org/ntsb/MKC78FA004.md): Piper PA-28 · Blair, NE · Accident · 4 fatal · Closed · Oct 23, 1977 · N55184 · Destroyed
- [NTSB MKC78FA002](https://openairdocs.org/ntsb/MKC78FA002.md): Grumann AA-5A · Pierce, NE · Accident · 2 fatal · Closed · Oct 23, 1977 · N9762U · Destroyed
- [NTSB MKC77DCJ25](https://openairdocs.org/ntsb/MKC77DCJ25.md): Piper PA-28 · Gothenburg, NE · Accident · Minor injuries · Closed · Jun 22, 1977 · N57301 · Substantial damage
- [NTSB MKC77FA007](https://openairdocs.org/ntsb/MKC77FA007.md): Piper PA-24 · Kimball, NE · Accident · 3 fatal · Closed · Dec 5, 1976 · N6973P · Destroyed
- [NTSB MKC76AK075](https://openairdocs.org/ntsb/MKC76AK075.md): Beech B35 · Columbus, NE · Accident · 3 fatal · Closed · Aug 14, 1976 · N5232C · Destroyed
- [NTSB MKC74AK023](https://openairdocs.org/ntsb/MKC74AK023.md): Taylorcraft BC12-D · Fairbury, NE · Accident · 1 fatal · Closed · Nov 14, 1973 · N5041M · Destroyed
- [NTSB DEN73AD029](https://openairdocs.org/ntsb/DEN73AD029.md): Piper PA-32 · Kearney, NE · Accident · 7 fatal · Closed · Dec 28, 1972 · N8915N · Destroyed
- [NTSB MKC73AK039](https://openairdocs.org/ntsb/MKC73AK039.md): Piper PA-24 · Fremont, NE · Accident · 2 fatal · Closed · Nov 12, 1972 · N5095P · Destroyed
- [NTSB MKC73AK036](https://openairdocs.org/ntsb/MKC73AK036.md): Cessna 150F · Long Pine, NE · Accident · 1 fatal · Closed · Nov 5, 1972 · N7704F · Destroyed
- [NTSB MKC73AK013](https://openairdocs.org/ntsb/MKC73AK013.md): Piper PA-28R · Lincoln, NE · Accident · 2 fatal · Closed · Aug 3, 1972 · N301LC · Destroyed
- [NTSB MKC72AK058](https://openairdocs.org/ntsb/MKC72AK058.md): Beech F35 · Kimball, NE · Accident · 1 fatal · Closed · Mar 30, 1972 · N3368C · Destroyed
- [NTSB MKC72AK051](https://openairdocs.org/ntsb/MKC72AK051.md): Cessna 172G · Bartlett, NE · Accident · 3 fatal · Closed · Feb 24, 1972 · N5963R · Destroyed
- [NTSB MKC71AK055](https://openairdocs.org/ntsb/MKC71AK055.md): Piper PA-28 · Chadron, NE · Accident · 1 fatal · Closed · May 10, 1971 · N4614R · Destroyed
- [NTSB MKC71AK053](https://openairdocs.org/ntsb/MKC71AK053.md): N.American B · Paxton, NE · Accident · 2 fatal · Closed · Apr 19, 1971 · N8630H · Destroyed
- [NTSB MKC70A0007](https://openairdocs.org/ntsb/MKC70A0007.md): Piper PA-22 · Loup City, NE · Accident · 1 fatal · Closed · Aug 30, 1969 · N3306A · Destroyed
- [NTSB MKC68A0051](https://openairdocs.org/ntsb/MKC68A0051.md): Mooney M20C · Lexington, NE · Accident · 4 fatal · Closed · Feb 11, 1968 · N7833V · Destroyed
- [NTSB MKC68F0299](https://openairdocs.org/ntsb/MKC68F0299.md): Cessna 150H · Millard, NE · Accident · Minor injuries · Closed · Oct 18, 1967 · N6549S · Substantial damage
- [NTSB DEN68A0016](https://openairdocs.org/ntsb/DEN68A0016.md): N.American P-51D · Minden, NE · Accident · 1 fatal · Closed · Sep 3, 1967 · N2871D · Destroyed
- [NTSB MKC67A0033](https://openairdocs.org/ntsb/MKC67A0033.md): Cessna 172G · Venango, NE · Accident · 1 fatal · Closed · Nov 3, 1966 · N3646L · Destroyed
- [NTSB MKC67F0170](https://openairdocs.org/ntsb/MKC67F0170.md): Boeing A75 · Lexington, NE · Accident · 1 fatal · Closed · Jul 28, 1966 · N63911 · Destroyed
- [NTSB MKC66A0066](https://openairdocs.org/ntsb/MKC66A0066.md): Brantly B-2 · N.Platte, NE · Accident · No injuries · Closed · Jun 16, 1966 · N2131U · Substantial damage
- [NTSB MKC66A0062](https://openairdocs.org/ntsb/MKC66A0062.md): Cessna 182 · Hyannis, NE · Accident · 1 fatal · Closed · May 27, 1966 · N3215U · Destroyed
- [NTSB MKC66A0034](https://openairdocs.org/ntsb/MKC66A0034.md): Piper PA-22 · Burr, NE · Accident · 1 fatal · Closed · Dec 9, 1965 · N9584D · Destroyed
- [NTSB MKC66F0004](https://openairdocs.org/ntsb/MKC66F0004.md): Piper PA-22 · Imperial, NE · Accident · Serious injuries · Closed · May 28, 1965 · N2661P · Destroyed
- [NTSB MKC65A0047](https://openairdocs.org/ntsb/MKC65A0047.md): Cessna 310G · Nebraska Cty, NE · Accident · 2 fatal · Closed · Jan 12, 1965 · N8981Z · Destroyed
- [NTSB UNK65X0345](https://openairdocs.org/ntsb/UNK65X0345.md): Brantly B2 · Broadwater, NE · Accident · 1 fatal · Closed · Oct 20, 1964 · N5924X · Destroyed
- [NTSB UNK64X3831](https://openairdocs.org/ntsb/UNK64X3831.md): Bellanca 14-193 · Atkinson, NE · Accident · 2 fatal · Closed · Sep 6, 1964 · N8816R · 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" = 'NE' 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=NE&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.
