OpenAirDocs.org

NTSB investigations, WY

28 cases where the phase of flight was Uncontrolled descent.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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\" = 'WY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB DEN05CA138Accident · No injuriesData collectionFinal reportRobinson R44 II · Jackson, WYthe pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.Sep 9, 2005 · N944U · Substantial damageNTSB FTW97LA310Accident · No injuriesLimited investigationFinal reportWaco KNF · Wamsutter, WYThe pilot's failure to maintain directional control during the precautionary landing. A factor was a wind gust.Aug 15, 1997 · NC698N · Substantial damageNTSB DEN83FTC02Accident · 1 fatalFinal reportPitts S-15 · Laramie, WYThe acft crashed during a ferry flt in VMC wx conditions. While in formation with two other acft N6CQ was observed to pull up to a near vertical climb, reverse course and disappear. Found near the maneuver location, the acft struck the ground in a nearly…Apr 20, 1983 · N6CQ · DestroyedNTSB DEN81AA064Accident · 5 fatalClosedMitsubishi MU-2B · Riverton, WYSep 6, 1981 · N3ED · DestroyedNTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYMay 7, 1981 · N6842R · DestroyedNTSB DEN79FA020Accident · 1 fatalClosedCessna R172K · Banner, WYFeb 6, 1979 · N758AV · DestroyedNTSB DEN78FA060Accident · 2 fatalClosedPiper PA-28 · Edgerton, WYAug 14, 1978 · N40439 · DestroyedNTSB DEN78FA040Accident · 4 fatalClosedBeech D50C · Wheatland, WYMay 4, 1978 · N320Z · DestroyedNTSB DEN78FA003Accident · 2 fatalClosedMooney M20C · Sheridan, WYOct 4, 1977 · N5581Q · DestroyedNTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYMay 6, 1977 · N4948F · DestroyedNTSB DEN77FA028Accident · 1 fatalClosedCessna 414 · Farson, WYMar 2, 1977 · N8066Q · DestroyedNTSB DEN76AD042Accident · 4 fatalClosedPiper PA-23 · Lusk, WYMar 20, 1976 · N3080P · DestroyedNTSB DEN76AD034Accident · 2 fatalClosedCessna 320E · Sinclair, WYFeb 18, 1976 · N3440Q · DestroyedNTSB DEN75AD053Accident · 1 fatalClosedPiper PA-18 · Rock Springs, WYApr 15, 1975 · N13833 · DestroyedNTSB DEN73AD045Accident · 2 fatalClosedCessna 210 · Farson, WYMar 31, 1973 · N9545T · DestroyedNTSB DEN73AD013Accident · 1 fatalClosedCessna 170A · Midwest, WYSep 25, 1972 · N1253D · DestroyedNTSB DEN72AD045Accident · 7 fatalClosedBeech C-18S · Mcfadden, WYApr 2, 1972 · N1322M · DestroyedNTSB DEN72ADO43Accident · 1 fatalClosedCessna 180H · Medicine Bow, WYMar 20, 1972 · N9050M · DestroyedNTSB DEN72AD024Accident · 3 fatalClosedCessna 172 · Opal, WYOct 29, 1971 · N6151E · DestroyedNTSB DEN71AD028Accident · 1 fatalClosedCessna T310P · Cheyenne, WYDec 18, 1970 · N5810M · DestroyedNTSB DEN71AD015Accident · 2 fatalClosedBeech B35 · Evanston, WYOct 6, 1970 · N8817A · DestroyedNTSB DEN69A0047Accident · Serious injuriesClosedLockheed 12A · Casper, WYMay 9, 1969 · N399X · Substantial damageNTSB DEN68A0056Accident · 2 fatalClosedCessna 182 · Thermopolis, WYJun 8, 1968 · N3195Q · DestroyedNTSB DEN68A0008Accident · 2 fatalClosedBell 47G3B1 · Bondurant, WYJul 27, 1967 · N8471E · DestroyedNTSB DEN65A0082Accident · 2 fatalClosedChampion 7ECA · Alcova, WYJun 16, 1965 · N11060 · DestroyedNTSB DEN65A0069Accident · 1 fatalClosedCessna 182A · 8s Cheyenne, WYMay 3, 1965 · N9987T · DestroyedNTSB UNK64X1396Accident · 1 fatalClosedCessna 172 · Dubois, WYApr 20, 1964 · N5831A · Substantial damageNTSB UNK64X0696Accident · 2 fatalClosedChampion 7GCB · Split Rock, WYFeb 26, 1964 · N9909Y · Destroyed