OpenAirDocs.org

NTSB investigations, TX

10 cases where the phase of flight was Other.

Cases per year

19872026

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\" = 'TX' AND c.\"eventCountry\" = 'USA'
    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 CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.Nov 6, 2020 · N617Q · 2 aircraft · DestroyedNTSB CEN10FA124Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Austin, TXThe pilot’s intentional flight into a building.Feb 18, 2010 · N2889D · DestroyedNTSB CEN09IA578Incident · No injuriesIncident investigationFinal reportCessna 421 · Sugar Land, TXThe improper installation of the pitch trim cable which resulted in it making improper contact with a guard pin that led to the fatigue failure of the cable.Sep 4, 2009 · N2349S · Minor damageNTSB DFW08CA064Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Houston, TXThe student pilot's improper use of the collective and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.Feb 8, 2008 · N2364B · Substantial damageNTSB DFW05LA047Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Austin, TXThe failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.Dec 29, 2004 · N506MJ · No damageNTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.Apr 11, 1995 · N683A · No damageNTSB FTW91LA119Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Boerne, TXThe pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.Jun 22, 1991 · N6MN · Substantial damageNTSB FTW91LA048Accident · 1 fatalLimited investigationFinal reportBell 206B II · High Island, TXFor occurrence #1 - inadequate supervision by the operator in launching a hazardous mission without an adequate sling/harness, the pilot's poor judgement in accepting and continuing the mission into low light conditions, and the crewmember's inadvertent…Mar 8, 1991 · N59491 · Substantial damageNTSB FTW88DQG03Accident · No injuriesFinal reportBeech G35 · Friona, TXAfter touchdown on the landing strip, the left landing gear collapsed, and the airplane went off the left side of the strip. The airplane went into a water pit, and struck a pump station and associated equipment. Later the pilot stated to his son that he had…Jan 26, 1988 · N313B · Substantial damageNTSB FTW87DRG06Accident · Minor injuriesFinal reportWilliam M. Burge Tern · Refugio, TXOn August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…Aug 8, 1987 · N38826 · Substantial damage