OpenAirDocs.org

NTSB investigations, DC

32 cases where the phase of flight was Landing.

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 = 550)
  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 DCA99IA023Incident · No injuriesIncident investigationFinal reportBoeing 757 · Washington, DCUndetermined.Nov 29, 1998 · UNK · No damageNTSB IAD96IA044Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Washington, DCexcessive airspeed was maintained by the captain during the approach/landing phase of the flight, which resulted in an overrun and an encounter with soft/wet terrain. Factors relating to the incident were: the pilot's failure to attain the proper touchdown…Feb 20, 1996 · N33202 · Minor damageNTSB BFO89LA013Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Washington, DCPilots failure to maintain control of the airplane during a touch and go landing.Nov 30, 1988 · N263CM · Substantial damageNTSB BFO88LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Washington, DCDuring the landing roll the left main landing gear collapsed. The acft continued to roll and came to a stop on taxiway 'k'. Inspection revealed that the push-pull rod assembly, p/n 0840125-15, failed allowing the gear to collapse. The purpose of the rod is to…Sep 15, 1988 · N87297 · Substantial damageNTSB BFO86LA025Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Washington, DCThe acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The…May 17, 1986 · N6828P · Substantial damageNTSB BFO85IA036Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCWhile on final for runway 36 at Washington national airport, Washington, d.c., the pilot was given a change of lndg rwys because of traffic on rwy 36. Drng the ensuing realignment the cpt took the ctls and lndg the acft, scraping the right wing on the runway.…Apr 16, 1985 · N400DL · Minor damageNTSB BFO85FA003Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Washington, DCAfter a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,…Oct 27, 1984 · N6235Y · Substantial damageNTSB ATL83IA053Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Washington, DCThe pilot reported that he had 3 green lights after extending the landing gear. During landing roll, the left main ldg gr collapsed for an undetermined reason. The landing gear handle was found in the down position.Dec 5, 1982 · N501BC · Minor damageNTSB IAD80FIA02Accident · No injuriesClosedBeech 95-55 · Washington, DCNov 8, 1979 · N77PW · Substantial damageNTSB IAD77IA010Incident · No injuriesClosedBoeing 727 · Washington, DCOct 25, 1976 · N8837E · No damageNTSB IAD76II075Incident · No injuriesClosedPiper PA-34 · Washington, DCJun 5, 1976 · N8312C · Minor damageNTSB IAD74II024Incident · No injuriesClosedBoeing 727 · Washington, DCNov 7, 1973 · N7435 · Minor damageNTSB NYC73IN019Incident · No injuriesClosedBoeing 707 · Washington, DCJul 30, 1972 · N105BN · Minor damageNTSB NYC72IN075Incident · No injuriesClosedDouglas DC-10 · Dulles Int Apt, DCDec 4, 1971 · N1805U · Minor damageNTSB IAD71II029Incident · No injuriesClosedBeech E33 · Washington, DCDec 9, 1970 · N5475U · Minor damageNTSB IAD71II025Incident · No injuriesClosedBoeing 727 · Washington, DCNov 17, 1970 · N7273 · Minor damageNTSB IAD71II007Incident · No injuriesClosedNihon YS-11A · Washington, DCJul 28, 1970 · N259P · Minor damageNTSB IAD70D0068Accident · No injuriesClosedBeech 35-A33 · Wash Natl Apt, DCAug 30, 1969 · N486T · Substantial damageNTSB DIA69D0091Accident · No injuriesClosedHughes 269B · Washington, DCOct 15, 1968 · N9474F · Substantial damageNTSB DIA68A0018Accident · No injuriesClosedSudaviation DA20 · Washington, DCNov 7, 1967 · N809F · Substantial damageNTSB DIA68A0006Accident · No injuriesClosedBeech 95-B55 · Washington, DCAug 21, 1967 · N354RJ · Substantial damageNTSB DIA67A0020Accident · No injuriesClosedPiper PA-31 · Washington, DCJun 6, 1967 · N9004Y · Substantial damageNTSB DIA67I0010Incident · No injuriesClosedBoeing B-727 · Washington, DCFeb 25, 1967 · N468US · Minor damageNTSB NYC67F0415Accident · No injuriesClosedNavion A · Washington, DCDec 6, 1966 · N91662 · Substantial damageNTSB NYC67F0200Accident · No injuriesClosedCessna 310 · Washington, DCJul 18, 1966 · N66E · Substantial damageNTSB NYC66A0124Accident · No injuriesClosedDehavilland DH-104 · Washington, DCMay 4, 1966 · N70L · Substantial damageNTSB NYC66I0101Incident · No injuriesClosedLear Jet 23 · Washington, DCApr 1, 1966 · N4486C · Minor damageNTSB NYC66D0564Accident · No injuriesClosedBeech B-55 · Washington, DCFeb 13, 1966 · N146 · Substantial damageNTSB NYC66F0426Accident · No injuriesClosedBeechcraft H35 · Washington, DCDec 24, 1965 · N194HA · Substantial damageNTSB NYC66F0403Accident · No injuriesClosedCessna 310B · Washington, DCDec 1, 1965 · N5347A · Substantial damageNTSB UNK64X1410Accident · No injuriesClosedMeyers 200A · Washington, DCApr 22, 1964 · N34398 · Substantial damageNTSB UNK64X1160Accident · No injuriesClosedCessna 182 · Washington, DCApr 4, 1964 · N3720D · Substantial damage