OpenAirDocs.org

NTSB investigations, 1983

8 cases where the phase of flight was Other.

Cases per year

19622026

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 year(c.\"eventDate\") = 1983
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 800)
  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 ATL84LA077Accident · No injuriesLimited investigationFinal reportCessna 150L · Ozark, ALThe plt reported that the acft had about 17 gal of fuel on board before he took off. About 2 hrs & 40 mins later, while in slow flt at aprx 700 ft AGL, the eng lost power. The plt landed in a small field that was surrounded by trees. During the landing roll…Dec 26, 1983 · N6816G · Substantial damageNTSB FTW84LA044Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tulsa, OKDuring a missed approach from a practice ILS apch, a loud noise was heard during gear retraction. Subsequent attempts toextend the gear, both normally & manually, resulted in the right gear remaining up & locked with the inboard gear door slightly open. The…Nov 6, 1983 · N677K · Substantial damageNTSB LAX84LA019Accident · No injuriesLimited investigationFinal reportBell 206B · Santa Ana, CAAfter returning from a flt, the helicopter was shutdown & refueled, then it was moved to a dolly. During the moving operation, the left 'shoe' slipped off the platform & the helicopter rocked back & damaged the tail rotor area.Oct 15, 1983 · N49670 · Substantial damageNTSB MIA83IA217Incident · Minor injuriesIncident investigationFinal reportSemco SEM 182 · Palm Beach, FLWhile being ground handled after landing a balloon contacted high tension high voltage wires.Aug 27, 1983 · N2052J · Minor damageNTSB DCA83AA036Accident · 11 fatalFinal reportLockheed Learstar, L-18-56 · Silvana, WAThe acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…Aug 22, 1983 · N116CA · DestroyedNTSB CHI83LA272Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-30 · Milwaukee, WIA jetway collapsed as passenger loading commenced. The drive gear failed & oil was found to be contiminated with water. Heat had transferred to the worm gear which was misaligned & was not manufactured for acft use specifications.Jun 21, 1983 · N980Z · Minor damageNTSB NYC83LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Argyle, NYThe plt attempted to start the eng by hand propping for aprx 20 min. The eng finally started & continued to rev up. During this time, the passenger was in the rear seat. As the plt was returning to the cockpit, the acft began to roll forward. The plt was…Jun 12, 1983 · N19AN · Substantial damageNTSB FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…Mar 15, 1983 · N1841P · Substantial damage