OpenAirDocs.org

NTSB investigations, DC

15 cases where the phase of flight was Taxi.

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\" = 'DC' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 250)
  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 DCA08CA041Accident · No injuriesData collectionFinal reportEmbraer ERJ170 · Washington, DCInadequate ground separation maintained by the pilot of the Embraer E170.Feb 17, 2008 · N828MD · 2 aircraft · Minor damageNTSB DCA01MA056Accident · 1 fatalMajor investigationFinal reportde Havilland Dash 8-100 · Washington, DCThe ramp agent's impaired performance due to his hyperthyroidism, which was exacerbated by the heat and was inadequately controlled by medication, and possibly also due to the use of an antianxiety medication.Aug 5, 2001 · N935HA · Minor damageNTSB IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.Aug 23, 1999 · N926TS · Minor damageNTSB IAD96LA066Accident · No injuriesLimited investigationFinal reportCessna 208 · Washington, DCThe pilot's failure to maintain control of the aircraft while taxiing for takeoff. Related factors were the wet runway and the gusty crosswind.Apr 24, 1996 · N776FE · Substantial damageNTSB BFO85IA074Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Washington, DCNorthwest flight 78 (NW78), a B-757, was parked at gate 17 facing east with mobile passenger lounge (mpl) docked at L1 door. United 52, a DC-10, taxied in easterly direction by left side of NW78, then turned right to southeasterly heading to follow lead-in…Sep 8, 1985 · N1842U · Minor damageNTSB IAD80IA043Incident · No injuriesClosedBoeing 727 · Washington, DCApr 11, 1980 · N8873Z · Minor damageNTSB IAD80IA015Incident · No injuriesClosedBeech K35 · Washington, DCDec 6, 1979 · N3077C · Minor damageNTSB IAD78IA112Incident · No injuriesClosedPiper PA-31 · Washington, DCSep 19, 1978 · N59911 · Minor damageNTSB NYC73AN057Accident · No injuriesClosedBoeing 727 · Washington, DCOct 30, 1972 · N498US · Substantial damageNTSB IAD71II020Incident · No injuriesClosedDouglas D DC-8 · Washington, DCOct 28, 1970 · N8027 · Minor damageNTSB IAD71II011Incident · No injuriesClosedBoeing 707 · Dulles Intl Apt, DCOct 16, 1970 · N799TW · Minor damageNTSB DIA69I0050Incident · Minor injuriesClosedBoeing 727 · Wash Natl Apt, DCMar 23, 1969 · N4618H · No damageNTSB DIA68D0224Accident · No injuriesClosedBeech C35 · Washington, DCMay 2, 1968 · N653D · Substantial damageNTSB NYC65A0106Accident · No injuriesClosedNo American 265A · Washington, DCFeb 18, 1965 · N168H · Substantial damageNTSB UNK65X1076Accident · No injuriesClosedBell 47H1 · Washington, DCDec 20, 1964 · N2475B · Substantial damage