# Final NTSB investigations, DC: Standing

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 DCA05MA070](https://openairdocs.org/ntsb/DCA05MA070.md): Embraer 170 · Washington, DC · Accident · 1 fatal · Major investigation · Final report · Jun 7, 2005 · N803MD · Minor damage
  > The inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.
- [NTSB DCA04IA052](https://openairdocs.org/ntsb/DCA04IA052.md): Airbus Industrie A340-311 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jun 7, 2004 · G-VFLY · No damage
  > The incorrect loading of baggage into the aft cargo compartment instead of the forward compartment, which resulted in aft CG light in-flight.
- [NTSB NYC02IA117](https://openairdocs.org/ntsb/NYC02IA117.md): Dornier 328 · Washington, DC · Incident · Minor injuries · Incident investigation · Final report · Jun 17, 2002 · N439JS · No damage
  > The ground service personnel's failure to follow company procedure, which resulted in the flight attendant sustaining a serious injury.
- [NTSB NYC94LA144](https://openairdocs.org/ntsb/NYC94LA144.md): de Havilland DHC-8-311 · Washington, DC · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1994 · N433AW · Substantial damage
  > The vehicle operator's improper handling of the baggage tractor resulting in loss of control of a second baggage tractor being pushed and its subsequent collision with the airplane.
- [NTSB BFO87FA053](https://openairdocs.org/ntsb/BFO87FA053.md): Boeing 747-200B · Washington, DC · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1987 · JA182 · No damage
  > A flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a…
- [NTSB BFO84IA005](https://openairdocs.org/ntsb/BFO84IA005.md): Boeing 727-22 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Sep 3, 1984 · N7078U · 2 aircraft · Minor damage
  > Mishap acft, new york air flight 306 (nya 306) followed a Boeing 727, united flight 827 (ual 827), to the run-up area and positioned in the #2 spot for takeoff, anticipating ual 827 would receive takeoff clearance first. Nya 306 was cleared first for takeoff…
- [NTSB ATL81FA110](https://openairdocs.org/ntsb/ATL81FA110.md): Beech 99 · Washington, DC · Accident · Serious injuries · Closed · Aug 23, 1981 · N124CA · Minor damage
- [NTSB ATL81IA060](https://openairdocs.org/ntsb/ATL81IA060.md): Boeing 727 · Washington, DC · Incident · Minor injuries · Closed · Apr 9, 1981 · N281US · No damage
- [NTSB NYC72AN098](https://openairdocs.org/ntsb/NYC72AN098.md): Boeing 727 · Washington, DC · Accident · Serious injuries · Closed · Feb 19, 1972 · N8163G · No damage
- [NTSB DCA71IZ003](https://openairdocs.org/ntsb/DCA71IZ003.md): Boeing 737 · Washington, DC · Incident · No injuries · Closed · Dec 31, 1970 · N9003U · Substantial damage
- [NTSB IAD71FIA02](https://openairdocs.org/ntsb/IAD71FIA02-201131.md): Cessna 150 · Washington, DC · Accident · Minor injuries · Closed · Aug 2, 1970 · N60489 · Substantial damage
- [NTSB DIA69A0064](https://openairdocs.org/ntsb/DIA69A0064.md): Boeing 727 · Wash Natl Apt, DC · Accident · No injuries · Closed · May 14, 1969 · N4612 · 2 aircraft · Minor damage
- [NTSB DIA68A0035](https://openairdocs.org/ntsb/DIA68A0035.md): Lockheed 188C · Wash.Natl.Apt, DC · Accident · No injuries · Closed · Mar 3, 1968 · N135US · No damage
- [NTSB UNK64X2013](https://openairdocs.org/ntsb/UNK64X2013.md): Lockheed L-188 · Washington, DC · Incident · No injuries · Closed · May 30, 1964 · N537 · No damage

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
