# NTSB investigations, 2004: 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.

Page 1 of 5 · 216 cases

## Latest cases

- [NTSB NYC05CA037](https://openairdocs.org/ntsb/NYC05CA037.md): Piper PA-32RT-300 · Johnstown, NY · Accident · No injuries · Data collection · Final report · Dec 29, 2004 · N300WE · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in airframe ice with subsequent degradation of aircraft performance, and inadequate airspeed during the landing flare.
- [NTSB DFW05LA049](https://openairdocs.org/ntsb/DFW05LA049.md): Beech BE35 · Los Fresnos, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2004 · N860R · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.
- [NTSB LAX05FA054](https://openairdocs.org/ntsb/LAX05FA054.md): Cessna 182P · La Mirada, CA · Accident · 2 fatal · Field investigation · Final report · Dec 19, 2004 · N9187G · Substantial damage
  > the pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.
- [NTSB LAX05FA053](https://openairdocs.org/ntsb/LAX05FA053.md): Eurocopter AS-350-B3 · Apache Junction, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2004 · N971AE · Substantial damage
  > A loss of control during the final approach to land for undetermined reasons.
- [NTSB DFW05LA031](https://openairdocs.org/ntsb/DFW05LA031.md): Beech B200 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 2004 · N6PE · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.
- [NTSB CHI05FA042](https://openairdocs.org/ntsb/CHI05FA042.md): Piper PA-32R-301T · Glenwood, MN · Accident · 2 fatal · Field investigation · Final report · Dec 9, 2004 · N587C · Substantial damage
  > The pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…
- [NTSB ATL05FA034](https://openairdocs.org/ntsb/ATL05FA034.md): Diamond DA40-180 · Pelzer, SC · Accident · 3 fatal · Field investigation · Final report · Dec 9, 2004 · N42SE · Substantial damage
  > The pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.
- [NTSB LAX05CA044](https://openairdocs.org/ntsb/LAX05CA044.md): Cessna 150J · Amado, AZ · Accident · Minor injuries · Data collection · Final report · Dec 8, 2004 · N60469 · Substantial damage
  > the pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.
- [NTSB NYC05FA028](https://openairdocs.org/ntsb/NYC05FA028.md): Piper PA-31-350 · Vandalia, OH · Accident · 1 fatal · Field investigation · Final report · Dec 7, 2004 · N54316 · Destroyed
  > The pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.
- [NTSB SEA05LA026](https://openairdocs.org/ntsb/SEA05LA026.md): Cessna 140 · Spanaway, WA · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 2004 · N3571V · Substantial damage
  > The pilot's misjudgment of distance/altitude during final approach to land which resulted in an undershoot and in flight collision with a fence. A factor was the pilot's alcohol impairment.
- [NTSB SEA05FA025](https://openairdocs.org/ntsb/SEA05FA025.md): Cessna 208B · Bellevue, ID · Accident · 2 fatal · Field investigation · Final report · Dec 6, 2004 · N25SA · Destroyed
  > The pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.
- [NTSB MIA05CA041](https://openairdocs.org/ntsb/MIA05CA041.md): Piper PA-28-161 · Holly Springs, MS · Accident · No injuries · Data collection · Final report · Dec 4, 2004 · N3570J · Substantial damage
  > The failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.
- [NTSB IAD05LA022](https://openairdocs.org/ntsb/IAD05LA022.md): Cessna 414 · Petersburg, VA · Accident · No injuries · Limited investigation · Final report · Dec 2, 2004 · N2EQ · Substantial damage
  > The partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).
- [NTSB NYC05FA026](https://openairdocs.org/ntsb/NYC05FA026.md): Gulfstream Aerospace G-IV · Teterboro, NJ · Accident · No injuries · Field investigation · Final report · Dec 1, 2004 · G-GMAC · Substantial damage
  > The flightcrew's inadvertent engagement of the autothrottle system, and their failure to recognize the engagement during landing, which resulted in a runway excursion. Factors were the lack of autothrottle switch guards, lack of an autothrottle engagement…
- [NTSB CHI05CA039](https://openairdocs.org/ntsb/CHI05CA039.md): Piper PA-28-181 · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · Dec 1, 2004 · N3575X · Substantial damage
  > The inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. Contributing factors were the muddy terrain and the vegetation.
- [NTSB ATL05LA031](https://openairdocs.org/ntsb/ATL05LA031.md): Cessna 172K · Smyrna, TN · Accident · No injuries · Limited investigation · Final report · Nov 29, 2004 · N78402 · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB NYC05CA023](https://openairdocs.org/ntsb/NYC05CA023.md): Piper PA-28-180 · Appomattox, VA · Accident · No injuries · Data collection · Final report · Nov 26, 2004 · N33061 · Substantial damage
  > the pilot's misjudgment of distance and altitude.
- [NTSB NYC05FA021](https://openairdocs.org/ntsb/NYC05FA021.md): Cessna 310R · Paeonian Spring, VA · Accident · 2 fatal · Field investigation · Final report · Nov 24, 2004 · N310DM · Substantial damage
  > The pilot's failure to follow the published instrument approach procedure, which resulted in an in-flight collision with terrain. A factor related to the accident was the low cloud ceiling.
- [NTSB CHI05LA033](https://openairdocs.org/ntsb/CHI05LA033.md): Cessna 150H · Columbia, IL · Accident · No injuries · Limited investigation · Final report · Nov 24, 2004 · N6932S · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. Factors were the unsuitable field encountered during the forced landing, the muddy field, and the dark night.
- [NTSB DCA05MA011](https://openairdocs.org/ntsb/DCA05MA011.md): Gulfstream Aerospace G-III · Houston, TX · Accident · 3 fatal · Class 1 · Major · Final report · Nov 22, 2004 · N85VT · Destroyed
  > the flight crew's failure to adequately monitor and cross check the flight instruments during the approach. Contributing to the accident was the flight crew's failure to select the instrument landing system frequency in a timely manner and to adhere to…
- [NTSB ATL05CA028](https://openairdocs.org/ntsb/ATL05CA028.md): Enstrom F-28A · Smyrna, TN · Accident · No injuries · Data collection · Final report · Nov 22, 2004 · N9235 · Substantial damage
  > The loss of engine power for undetermined reasons, and the pilot's improper flare during forced landing, which resulted in an inflight collision into an open field.
- [NTSB DEN05IA027](https://openairdocs.org/ntsb/DEN05IA027.md): McDonnell Douglas DC-9-82 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Nov 21, 2004 · N234AA · Minor damage
  > the first officer's failure to maintain proper glide slope during the landing approach, and the captain's failure to adequately monitor the approach and landing, and his failure to challenge and/or intervene when the first officer continued to descend below…
- [NTSB ATL05CA027](https://openairdocs.org/ntsb/ATL05CA027.md): Beech A36TC · Huntsville, AL · Accident · Serious injuries · Data collection · Final report · Nov 20, 2004 · N38047 · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing to an open field.
- [NTSB IAD05CA015](https://openairdocs.org/ntsb/IAD05CA015.md): Socata TB 21-TC · Binghamton, NY · Accident · No injuries · Data collection · Final report · Nov 18, 2004 · N55510 · Substantial damage
  > The pilot's improper IFR procedure by his flight below the decision altitude, and his failure to maintain obstacle clearance.
- [NTSB NYC05LA017](https://openairdocs.org/ntsb/NYC05LA017.md): Labhart Kolb Twinstar Mk III · London, KY · Accident · 1 fatal · Limited investigation · Final report · Nov 14, 2004 · N83NK · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.
- [NTSB DFW05FA020](https://openairdocs.org/ntsb/DFW05FA020.md): Piper PA-31-350 · San Antonio, TX · Accident · 5 fatal · Field investigation · Final report · Nov 14, 2004 · N40731 · Destroyed
  > The pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.
- [NTSB CHI05LA030](https://openairdocs.org/ntsb/CHI05LA030.md): Hedge Bede-4 · Omaha, NE · Accident · 1 fatal · Limited investigation · Final report · Nov 13, 2004 · N435BD · Substantial damage
  > The pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.
- [NTSB LAX05LA033](https://openairdocs.org/ntsb/LAX05LA033.md): Cessna 210 · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 2004 · N5LT · Substantial damage
  > loss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.
- [NTSB LAX05CA031](https://openairdocs.org/ntsb/LAX05CA031.md): Cessna P210N · North Las Vegas, NV · Accident · Minor injuries · Data collection · Final report · Nov 11, 2004 · N6663P · Substantial damage
  > the pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.
- [NTSB SEA05LA014](https://openairdocs.org/ntsb/SEA05LA014.md): Swearingen SA226TC · Boise, ID · Accident · No injuries · Limited investigation · Final report · Nov 9, 2004 · N162WA · Substantial damage
  > The pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.
- [NTSB CHI05LA023](https://openairdocs.org/ntsb/CHI05LA023.md): Taylorcraft BC12-D · Wasta, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 2004 · N39971 · Substantial damage
  > The pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.
- [NTSB LAX05FA026](https://openairdocs.org/ntsb/LAX05FA026.md): Cessna T210M · Lomita, CA · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2004 · N732RW · Destroyed
  > A loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.
- [NTSB ATL05CA019](https://openairdocs.org/ntsb/ATL05CA019.md): Cessna 172N · Columbia, SC · Accident · Serious injuries · Data collection · Final report · Nov 3, 2004 · N4874G · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.
- [NTSB DEN05LA019](https://openairdocs.org/ntsb/DEN05LA019.md): Piper PA-24-250 · Ogden, UT · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 2004 · N7852P · Substantial damage
  > the loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.
- [NTSB LAX05LA027](https://openairdocs.org/ntsb/LAX05LA027.md): Cessna 172RG · Kingman, AZ · Accident · No injuries · Limited investigation · Final report · Nov 1, 2004 · N6140R · Substantial damage
  > Landing gear extension system component failure resulting in a gear up landing.
- [NTSB LAX05LA022](https://openairdocs.org/ntsb/LAX05LA022.md): Bell 47D1 · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Oct 31, 2004 · N903B · Substantial damage
  > A loss of power for undetermined reasons.
- [NTSB LAX05LA021](https://openairdocs.org/ntsb/LAX05LA021.md): Cessna 210A · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Oct 30, 2004 · N6675X · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB NYC05LA012](https://openairdocs.org/ntsb/NYC05LA012.md): Douglas Adventure Air Ampib · Pawtucket, RI · Accident · 1 fatal · Limited investigation · Final report · Oct 29, 2004 · N469PD · Destroyed
  > The pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.
- [NTSB NYC05LA009](https://openairdocs.org/ntsb/NYC05LA009.md): Beech BE-200 · Dulles, VA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2004 · N888TR · Substantial damage
  > The pilot's improper in-flight decision to continue the instrument approach and landing, which resulted in a collision with a sign. A factor was the below instrument approach landing minimum weather conditions.
- [NTSB ATL05LA012](https://openairdocs.org/ntsb/ATL05LA012.md): Rogers Lancair IVP · Sylvester, GA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2004 · N724HP · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB MIA05LA013](https://openairdocs.org/ntsb/MIA05LA013.md): Piper PA-23-250 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Oct 25, 2004 · N62711 · Substantial damage
  > The pilot-in-command's failure to maintain airspeed while on base to final leg, which resulted in an inadvertent stall/mush and subsequent impact with the runway.
- [NTSB LAX05CA016](https://openairdocs.org/ntsb/LAX05CA016.md): Bellanca BL17-30 · Las Vegas, NV · Accident · Minor injuries · Data collection · Final report · Oct 25, 2004 · N4894V · Substantial damage
  > the pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power.
- [NTSB ATL05FA011](https://openairdocs.org/ntsb/ATL05FA011.md): Beech BE-P35 · Aiken, SC · Accident · 1 fatal · Field investigation · Final report · Oct 25, 2004 · N32AB · Destroyed
  > The pilot’s failure to follow IFR procedures, and continued flight below the minimum descent altitude and collided with trees.
- [NTSB IAD05MA006](https://openairdocs.org/ntsb/IAD05MA006.md): Beech 200 · Stuart, VA · Accident · 10 fatal · Class 1 · Major · Final report · Oct 24, 2004 · N501RH · Destroyed
  > The flight crew's failure to properly execute the published instrument approach procedure, including the published missed approach procedure, which resulted in controlled flight into terrain. Contributing to the cause of the accident was the flight crew's…
- [NTSB SEA05LA011](https://openairdocs.org/ntsb/SEA05LA011.md): Cessna T210H · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Oct 23, 2004 · N2240R · Substantial damage
  > The pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.
- [NTSB DEN05LA013](https://openairdocs.org/ntsb/DEN05LA013.md): Cessna 170A · Glenwood Spring, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 2004 · N9176A · Substantial damage
  > the pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.
- [NTSB DCA05MA004](https://openairdocs.org/ntsb/DCA05MA004.md): British Aerospace Jetstream 32 · Kirksville, MO · Accident · 13 fatal · Class 1 · Major · Final report · Oct 20, 2004 · N875JX · Destroyed
  > the pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…
- [NTSB SEA05LA010](https://openairdocs.org/ntsb/SEA05LA010.md): Beech 99A · Billings, MT · Accident · No injuries · Limited investigation · Final report · Oct 18, 2004 · N955AA · Substantial damage
  > the pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.
- [NTSB ATL05LA005](https://openairdocs.org/ntsb/ATL05LA005.md): Moody Easy Riser · Augusta, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2004 · N87EZ · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.
- [NTSB IAD05LA005](https://openairdocs.org/ntsb/IAD05LA005.md): Beech C24R · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Oct 15, 2004 · N6598C · Substantial damage
  > The mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2004&page=2

## 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 year(c."eventDate") = 2004
  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?year=2004

---
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.