OpenAirDocs.org

NTSB investigations

211 cases where the phase of flight was Other.

Cases, newest first

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.\"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 LAX83LA046Accident · No injuriesLimited investigationFinal reportBeech G35 · Fair Oaks, CADuring takeoff, the engine lost power at about 50 ft AGL after the pilot had raised the gear. Reportedly, there was insufficient time to extend the gear, so a wheels-up landing was made on the remaining portion of the runway. An investigation revealed that a…Dec 18, 1982 · N218B · Substantial damageNTSB SEA82DA164Accident · No injuriesFinal reportHiller-Soloy UH-12E · Spirit Lake, WAPilot performed autorotation from 2000 feet to check RPM. At 200-300 feet when collective was added power loss occurred. Aircraft landed hard and severed tail boom. Logging support operations.Sep 15, 1982 · N513HA · Substantial damageNTSB DEN82IA192Incident · No injuriesIncident investigationFinal reportFairchild/Swearingen SA226TC · Denver, CODuring takeoff on a maintenance ferry flight, with a mechanic flying from the right seat, the aircraft would not accelerate above V1 and would not rotate even with full aft yoke. The captain aborted the takeoff and the aircraft was stopped at the end of the…Sep 13, 1982 · N5471M · Minor damageNTSB CHI82FA290Accident · 3 fatalField investigationFinal reportStarduster II · Oshkosh, WIBoth acft were operating in the fly-by (no radio) pattern during the annual eaa convention. According to participant records both plts had received fly-by pattern briefings. Both acft were observed to be in the southern most portion of the upwind leg of the…Aug 3, 1982 · N9JR · 2 aircraft · DestroyedNTSB DEN82FTC07Accident · 2 fatalFinal reportPiper 18 · Labarge, WYThe aircraft was on a power line patrol mission. The rear seat occupant was acting as an observer. He was also along to assist the company in route familiarization of the pilot, but was assigned no other official crewmember duties. The accident occurred while…Jul 21, 1982 · N83503 · DestroyedNTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…Jul 5, 1982 · N4698L · DestroyedNTSB LAX82DA185Accident · 2 fatalFinal reportRockwell 112TC · Fort Apache, AZThe aircraft was observed to fly between two parked campers in a left wing low attitude before hitting a pine tree. The aircraft then went into an inverted position before contacting the ground about 300 yards from the campers. Investigation revealed that the…May 20, 1982 · N4567W · DestroyedNTSB ANC82DA023Accident · No injuriesFinal reportPiper PA-18 · Near Gulkana, AKThe pilot stated that he arrived at crosswinds lake, made a low pass and attempted to contact the wheels on the snow to determine if a landing was possible. The wheels broke through the crust on the snow and the aircraft flipped over.Mar 2, 1982 · N8293C · Substantial damageNTSB MIA82DA056Accident · No injuriesFinal reportCessna 210A · Florida City, FLThe aircraft was found inverted in 5 feet of water. Only one seat was installed and an auxiliary fuel pump was inside the aircraft. It appeared that the aircraft landed on the adjacent canal bank and then purposely run into the water. Police suspect a drug…Feb 22, 1982 · N7335E · Substantial damageNTSB LAX82FXQ04Accident · 1 fatalFinal reportBell 214B-1 · Quincy, CAThe pilot was moving logs during an external load operation in a mountainous, burned out, wooded area. The elevation was about 4500 ft. logging crews observed the helicopter approach the "log landing area" while hauling a load of logs with a 160 ft cable.…Feb 14, 1982 · N2240H · DestroyedNTSB LAX82FUJ24Accident · Minor injuriesFinal reportCessna 182P · Sunflower, AZThe pilot reported that he had throttled back below cruise power to survey one of his business locations. Reportedly, he moved the throttle forward to climb, but was unable to get full power. He stated that he gradually lost power and airspeed, and…Jan 17, 1982 · N7383S · Destroyed