# NTSB investigations, DC: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB OPS25LA034](https://openairdocs.org/ntsb/OPS25LA034.md): Embraer ERJ 170-100 LR · Washington, DC · Incident · Class 3 · Limited · Preliminary report · May 1, 2025 · N879RW · 2 aircraft · No damage
  > On May 1, 2025, about 1433 eastern daylight time (EDT), Priority Air Transport flight 23 (PAT23), (tail number forthcoming), a UH-60 Blackhawk helicopter landing at the Pentagon Heliport (JPN), and Republic Airways flight 5825 (RPA5825), an Embraer 170,…
- [NTSB DCA25MA108](https://openairdocs.org/ntsb/DCA25MA108.md): Bombardier CL-600-2C10 · Washington, DC · Accident · 67 fatal · Class 1 · Major · Final report · Jan 30, 2025 · N709PS · 2 aircraft · Destroyed
  > The Federal Aviation Administration’s (FAA) placement of a helicopter route in close proximity to a runway approach path; their failure to regularly review and evaluate helicopter routes and available data, and their failure to act on recommendations to…
- [NTSB NYC06MA131](https://openairdocs.org/ntsb/NYC06MA131.md): Eurocopter EC-135P1 · Washington, DC · Accident · 1 fatal · Major investigation · Final report · May 30, 2006 · N601FH · Destroyed
  > The operator's inadequate training program and the pilot's failure to maintain control of the helicopter following his inadvertent disabling of the No. 1 and then the No. 2 engine full authority digital engine control system.
- [NTSB CHI95IA138](https://openairdocs.org/ntsb/CHI95IA138.md): Airbus Industrie A320-211 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Apr 27, 1995 · N331NW · No damage
  > the pilot's excessive use of the flight controls during the landing approach, the company's disregard of information provided by the airplane manufacturer, and the company's failure to identify a potentially hazardous conditions based on the information…
- [NTSB BFO90IA028](https://openairdocs.org/ntsb/BFO90IA028.md): Boeing B-727-29 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Feb 17, 1990 · N902TS · Minor damage
  > The accident was fatigue failure of the right main landing gear support link shaft because of overtorque.
- [NTSB MIA87IA204](https://openairdocs.org/ntsb/MIA87IA204.md): Boeing 727-225 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jul 11, 1987 · N8892Z · Minor damage
  > Drg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…
- [NTSB ATL83IA085](https://openairdocs.org/ntsb/ATL83IA085.md): Boeing 737-222 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Dec 28, 1982 · N752N · No damage
  > The acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…
- [NTSB IAD79FA051](https://openairdocs.org/ntsb/IAD79FA051.md): Mooney M20J · Washington, DC · Accident · Serious injuries · Closed · May 26, 1979 · N201PW · Destroyed
- [NTSB IAD75AI044](https://openairdocs.org/ntsb/IAD75AI044.md): Beech 65-A90 · Washington, DC · Accident · 5 fatal · Closed · Jan 25, 1975 · N57V · Destroyed
- [NTSB NYC73AN016](https://openairdocs.org/ntsb/NYC73AN016.md): Nihon YS-11A · Washington, DC · Accident · Serious injuries · Closed · Jun 21, 1972 · N162P · No damage
- [NTSB IAD71AI002](https://openairdocs.org/ntsb/IAD71AI002.md): Short Bros SC7-3 · Washington, DC · Accident · 2 fatal · Closed · Jul 2, 1970 · N21CK · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=DC

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.