# NTSB investigations, 2004: Maneuvering

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 · 224 cases

## Latest cases

- [NTSB NYC05LA033](https://openairdocs.org/ntsb/NYC05LA033.md): Cessna 172N · Mount Gilead, OH · Accident · 3 fatal · Limited investigation · Final report · Dec 30, 2004 · N737AZ · Substantial damage
  > The pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.
- [NTSB LAX05FA056](https://openairdocs.org/ntsb/LAX05FA056.md): Eurocopter France AS350BA · Panamint Spring, CA · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2004 · N410JC · Destroyed
  > The pilot's misjudged lateral distance from a mountainside and failure to maintain an adequate clearance from terrain and obstacles while performing a low altitude filming maneuver.
- [NTSB DEN05FA044](https://openairdocs.org/ntsb/DEN05FA044.md): Cessna 172S · Roswell, NM · Accident · 1 fatal · Field investigation · Final report · Dec 28, 2004 · N849SP · Destroyed
  > the pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.
- [NTSB SEA05TA028](https://openairdocs.org/ntsb/SEA05TA028.md): Christen Industries A-1 · Terreton, ID · Accident · Serious injuries · Final report · Dec 20, 2004 · N2898D · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.
- [NTSB DFW05LA041](https://openairdocs.org/ntsb/DFW05LA041.md): American Champion 8KCAB · Texas City, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 2004 · N992RS · Substantial damage
  > The pilot's failure to maintain clearance with terrain while performing aerobatics at a low altitude.
- [NTSB LAX05LA083](https://openairdocs.org/ntsb/LAX05LA083.md): Aircraft Mfg & Dev. CH-2000 · Jean, NV · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2004 · N285AM · Minor damage
  > an in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…
- [NTSB DFW05FA040](https://openairdocs.org/ntsb/DFW05FA040.md): Bell 407 · Ship Shoal 130E · Accident · 1 fatal · Field investigation · Final report · Dec 17, 2004 · N976AA · Destroyed
  > The pilot's failure to maintain clearance with a stationary object while maneuvering for landing. Contributing factors were the inadequate facilities available for landing, the pilot's lack of information regarding the landing area, and the operational status…
- [NTSB ATL05LA035](https://openairdocs.org/ntsb/ATL05LA035.md): Bell UH-1H · Rockford, AL · Accident · No injuries · Limited investigation · Final report · Dec 16, 2004 · N51AG · Substantial damage
  > The pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.
- [NTSB DFW05LA037](https://openairdocs.org/ntsb/DFW05LA037.md): Crosley Christen Eagle II · Morris, OK · Accident · 2 fatal · Limited investigation · Final report · Dec 12, 2004 · N222CE · Destroyed
  > The pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.
- [NTSB DEN05LA035](https://openairdocs.org/ntsb/DEN05LA035.md): Piper J3C-65 · Monte Vista, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2004 · N23375 · Substantial damage
  > the pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.
- [NTSB DFW05FA032](https://openairdocs.org/ntsb/DFW05FA032.md): Hughes 369D · Zachary, LA · Accident · Serious injuries · Field investigation · Final report · Dec 9, 2004 · N7148Z · Substantial damage
  > The loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…
- [NTSB DEN05FA032](https://openairdocs.org/ntsb/DEN05FA032.md): Beech A45 · Montgomery, TX · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2004 · N141SW · Destroyed
  > the in-flight separation of the left wing as a result of extensive fatigue cracking throughout the wing carry-through structure.
- [NTSB DFW05FA028](https://openairdocs.org/ntsb/DFW05FA028.md): Piper PA-28-180 · Hammond, LA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2004 · N4750L · Destroyed
  > A loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.
- [NTSB SEA05FA023](https://openairdocs.org/ntsb/SEA05FA023.md): Cirrus Design SR22 · Belgrade, MT · Accident · 3 fatal · Field investigation · Final report · Dec 4, 2004 · N1159C · Destroyed
  > The pilot's failure to maintain altitude/clearance while maneuvering in mountainous terrain, which resulted in an inflight collision with trees and terrain. Contributing factors were the mountainous terrain and the downdraft.
- [NTSB NYC05LA027](https://openairdocs.org/ntsb/NYC05LA027.md): Close Air Command · Wilmont, OH · Accident · 2 fatal · Limited investigation · Final report · Dec 3, 2004 · UNREG · Substantial damage
  > The pilot's failure to maintain clearance from a wire while maneuvering to land in an open field.
- [NTSB MIA05FA035](https://openairdocs.org/ntsb/MIA05FA035.md): Cessna 195 · Kilmichael, MS · Accident · 2 fatal · Field investigation · Final report · Nov 25, 2004 · N195DD · Destroyed
  > The pilot's ostentatious display, flying at low altitude, resulting in collision with a static wire power line, in-flight loss of control, and collision with terrain. A factor in the accident was sun glare.
- [NTSB SEA05LA017](https://openairdocs.org/ntsb/SEA05LA017.md): Trikes GTE 503 SL · Emmett, ID · Accident · 1 fatal · Limited investigation · Final report · Nov 22, 2004 · UNREG · Destroyed
  > The pilot intentionally performing an aerobatic maneuver while not maintaining clearance of the terrain.
- [NTSB MIA05LA033](https://openairdocs.org/ntsb/MIA05LA033.md): Taylorcraft BC12-D · Cocoa Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 2004 · N44263 · Substantial damage
  > The pilot's failure to maintain altitude resulting in flight collision with ground and subsequent collision with fence.
- [NTSB NYC05LA020](https://openairdocs.org/ntsb/NYC05LA020.md): Unknown Sky Raider · Rappahannock Ac, VA · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2004 · UNREG · Substantial damage
  > The uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.
- [NTSB LAX05FA035](https://openairdocs.org/ntsb/LAX05FA035.md): Cessna 337B · Drake, AZ · Accident · 3 fatal · Field investigation · Final report · Nov 16, 2004 · N133JW · Destroyed
  > the pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…
- [NTSB NYC05CA016](https://openairdocs.org/ntsb/NYC05CA016.md): Syreini Hipps J3 Kitten · Delaware, OH · Accident · Serious injuries · Data collection · Final report · Nov 14, 2004 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with wires.
- [NTSB IAD05LA031](https://openairdocs.org/ntsb/IAD05LA031.md): Enstrom 280C · Galloo Island, NY · Accident · No injuries · Limited investigation · Final report · Nov 14, 2004 · N51739 · Substantial damage
  > A partial loss of engine power for undetermined reasons. A factor was the pilot's improper decision to operate the helicopter outside the height velocity curve.
- [NTSB DEN05LA024](https://openairdocs.org/ntsb/DEN05LA024.md): Bell 206B3 · Eureka, UT · Accident · No injuries · Limited investigation · Final report · Nov 13, 2004 · N130JH · Substantial damage
  > the pilot's improper in-flight planning and decision making and failure to maintain obstacle clearance, resulting in contact with a power transmission line. Contributing factors include the intentional low-level maneuver, the power transmission line, and the…
- [NTSB CHI05CA029](https://openairdocs.org/ntsb/CHI05CA029.md): Gray Skybolt · St. Clair, MI · Accident · Minor injuries · Data collection · Final report · Nov 13, 2004 · N80TG · Substantial damage
  > The pilot's improper spin recovery procedure, which resulted in a failure to maintain control of the aircraft during the intentional spin. An additional cause was the pilot's inability to maintain clearance to the trees and terrain during recovery.…
- [NTSB DFW05LA022](https://openairdocs.org/ntsb/DFW05LA022.md): Robinson R22 Beta · Eagle Pass, TX · Accident · No injuries · Limited investigation · Final report · Nov 8, 2004 · N995JW · Substantial damage
  > The pilot's failure to maintain control of the helicopter. A contributing factor was the unsuitable terrain for landing.
- [NTSB CHI05LA026](https://openairdocs.org/ntsb/CHI05LA026.md): Bruce Protech PT2B · Anita, IA · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 2004 · N46WT · Substantial damage
  > The pilot's failure to maintain sufficient airspeed and an inadvertent stall/spin resulting in loss of control and an in-flight collision with terrain. An additional cause was a loss of engine power for undetermined reasons.
- [NTSB DFW05FA015](https://openairdocs.org/ntsb/DFW05FA015.md): Piper PA-30 · Boise City, OK · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2004 · N7415Y · Substantial damage
  > The pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.
- [NTSB SEA05FA013](https://openairdocs.org/ntsb/SEA05FA013.md): Cessna 172P · Olympia, WA · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2004 · N53161 · Substantial damage
  > The pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.
- [NTSB DFW05LA012](https://openairdocs.org/ntsb/DFW05LA012.md): Huber DR 107 · Fletcher, OK · Accident · 1 fatal · Limited investigation · Final report · Oct 28, 2004 · N255HR · Destroyed
  > The pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.
- [NTSB CHI05FA017](https://openairdocs.org/ntsb/CHI05FA017.md): Cessna 182J · Springfield, MO · Accident · 2 fatal · Field investigation · Final report · Oct 27, 2004 · N2703F · Substantial damage
  > The pilot's failure to maintain a proper altitude and his failure to maintain obstacle clearance while turning to reverse direction on final approach. A factor associated with the accident was the night lighting conditions which existed at the time of the…
- [NTSB IAD05LA007](https://openairdocs.org/ntsb/IAD05LA007.md): SanClemente Zenith CH 601HDS · Leominster, MA · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 2004 · N166DK · Destroyed
  > A loss of aircraft control for an undetermined reason.
- [NTSB LAX05TA018](https://openairdocs.org/ntsb/LAX05TA018.md): Hughes OH-6A · Tucson, AZ · Accident · Serious injuries · Final report · Oct 25, 2004 · N6188L · Destroyed
  > The loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…
- [NTSB CHI05LA015](https://openairdocs.org/ntsb/CHI05LA015.md): Strissel Pitts S1S · Liberal, KS · Accident · 1 fatal · Limited investigation · Final report · Oct 24, 2004 · N230SB · Destroyed
  > The pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.
- [NTSB LAX05LA014](https://openairdocs.org/ntsb/LAX05LA014.md): AMS Flight Carat A · Minden, NV · Accident · 1 fatal · Limited investigation · Final report · Oct 23, 2004 · N418AP · Destroyed
  > the pilot's likely inadvertent entry into instrument meteorological conditions created by the rapidly changing cloud conditions that resulted in his spatial disorientation and exceeding the glider's ultimate design loads while in a spiral dive, which resulted…
- [NTSB SEA05LA001](https://openairdocs.org/ntsb/SEA05LA001.md): Aviat A-1 · Winifred, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2004 · N79795 · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.
- [NTSB MIA05CA006](https://openairdocs.org/ntsb/MIA05CA006.md): Schweizer 269C · Diamond Head, MS · Accident · No injuries · Data collection · Final report · Oct 16, 2004 · N119DM · Destroyed
  > The pilot's inadvertent loss of tail rotor effectiveness during takeoff to a hover and aborted landing in a grass area resulting in the grass catching fire from the engine exhaust and the helicopter being consumed by fire.
- [NTSB SEA05FA007](https://openairdocs.org/ntsb/SEA05FA007.md): Piper PA-28-140 · Grand Ronde, OR · Accident · 3 fatal · Field investigation · Final report · Oct 15, 2004 · N454FL · Destroyed
  > The pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.
- [NTSB LAX05TA008](https://openairdocs.org/ntsb/LAX05TA008.md): Hughes OH-6A · Jacumba, CA · Accident · No injuries · Final report · Oct 15, 2004 · N6639R · Substantial damage
  > the pilot's failure to maintain adequate clearance from the mountainous terrain, which resulted in the helicopter's tail rotor blades impacting rocks. A factor in the accident was the pilot's complacency.
- [NTSB LAX05LA009](https://openairdocs.org/ntsb/LAX05LA009.md): Brackett And Peltz Kit Fox III · Aguila, AZ · Accident · 1 fatal · Limited investigation · Final report · Oct 15, 2004 · N543BP · Substantial damage
  > the pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.
- [NTSB LAX05LA007](https://openairdocs.org/ntsb/LAX05LA007.md): DeRosier DR-107 · San Diego, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 15, 2004 · N31SH · Substantial damage
  > the pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.
- [NTSB ANC05FA008](https://openairdocs.org/ntsb/ANC05FA008.md): Piper PA-18 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2004 · N4126E · Destroyed
  > The pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with water during maneuvering flight. Factors contributing to the accident were fog and low ceilings.
- [NTSB SEA05LA006](https://openairdocs.org/ntsb/SEA05LA006.md): Caldwell Glasair II · Hermiston, OR · Accident · 1 fatal · Limited investigation · Final report · Oct 14, 2004 · N706C · Destroyed
  > The pilot's failure to maintain an airspeed above stall speed while executing a wingover maneuver at the top of a vertical climb, leading to an inadvertent spin, and the pilot's inadequate remedial action in attempting to recover from the spin. Factors…
- [NTSB ATL05CA003](https://openairdocs.org/ntsb/ATL05CA003.md): Bell 206 B · Eutaw, AL · Accident · Minor injuries · Data collection · Final report · Oct 14, 2004 · N300HT · Substantial damage
  > The pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB NYC05CA008](https://openairdocs.org/ntsb/NYC05CA008.md): Hughes 269C · Minerva, OH · Accident · No injuries · Data collection · Final report · Oct 10, 2004 · N7423F · Substantial damage
  > The pilot's failure to maintain control of the helicopter during liftoff.
- [NTSB DFW05CA004](https://openairdocs.org/ntsb/DFW05CA004.md): Schweizer SGS 1-26E · El Paso, TX · Accident · Serious injuries · Data collection · Final report · Oct 8, 2004 · N17911 · Substantial damage
  > The pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.
- [NTSB DEN05FA003](https://openairdocs.org/ntsb/DEN05FA003.md): Cessna A185E · Luna, NM · Accident · 1 fatal · Field investigation · Final report · Oct 3, 2004 · N5964 · Destroyed
  > the pilot's improper use of the mixture control, his failure to maintain clearance from the trees, and his improper preflight planning resulting in his taking off into a canyon and subsequently impacting the trees and terrain. Factors contributing to the…
- [NTSB DEN05FA002](https://openairdocs.org/ntsb/DEN05FA002.md): Sukhoi SU-29 · Santa Fe, NM · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2004 · N92CG · Destroyed
  > the pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…
- [NTSB ATL04LA195](https://openairdocs.org/ntsb/ATL04LA195.md): Cessna 172L · Gadsden, AL · Accident · 2 fatal · Limited investigation · Final report · Sep 29, 2004 · N4336Q · Destroyed
  > The flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.
- [NTSB LAX04CA332](https://openairdocs.org/ntsb/LAX04CA332.md): Bell 222U · Santa Rosa, CA · Accident · No injuries · Data collection · Final report · Sep 28, 2004 · N222UT · Substantial damage
  > the pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.
- [NTSB DEN04LA149](https://openairdocs.org/ntsb/DEN04LA149.md): American Eurocopter AS-350-B3 · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2004 · N497AE · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/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.