# NTSB investigations, 2004: Initial climb

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

## Latest cases

- [NTSB SEA05LA032](https://openairdocs.org/ntsb/SEA05LA032.md): Aerostar 601 · Hamilton, MT · Accident · No injuries · Limited investigation · Final report · Dec 30, 2004 · N601DF · Destroyed
  > A partial loss of engine power due to the lack of lubrication and subsequent failure of the left engine's right turbocharger for undetermined reasons, and subsequent forced landing after takeoff. A factor was the unsuitable terrain for the forced landing.
- [NTSB IAD05CA027](https://openairdocs.org/ntsb/IAD05CA027.md): Enstrom 280C · Pedricktown, NJ · Accident · Minor injuries · Data collection · Final report · Dec 30, 2004 · N175BM · Substantial damage
  > The pilot's failure to maintain control of the helicopter during the takeoff and his failure to flare during the autorotation.
- [NTSB ANC05IA020](https://openairdocs.org/ntsb/ANC05IA020.md): Boeing 747-123 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Dec 29, 2004 · N858FT · Minor damage
  > The failure of a high-pressure fuel line fitting, which resulted in an engine fire during takeoff/initial climb.
- [NTSB DEN05LA039](https://openairdocs.org/ntsb/DEN05LA039.md): Raytheon C90A · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Dec 19, 2004 · N55EP · Substantial damage
  > the pilot's failure to obtain/maintain a proper climb rate and the pilot's premature initiation of the turn (low altitude flight maneuver). Contributing factors include the pilot's improper in-flight planning and decision making, the low altitude, the fog,…
- [NTSB SEA05CA027](https://openairdocs.org/ntsb/SEA05CA027.md): Breit Zodiac (CH-601-HDS) · Everett, WA · Accident · Minor injuries · Data collection · Final report · Dec 18, 2004 · N826JB · Substantial damage
  > The pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.
- [NTSB DFW05LA043](https://openairdocs.org/ntsb/DFW05LA043.md): Akers Douglas RA40 Defiant · Slaton, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 17, 2004 · N765MM · Destroyed
  > The pilot's failure to maintain aircraft control. Contributing factors were the opening of the canopy in-flight and the pilot's diverted attention.
- [NTSB DEN05FA038](https://openairdocs.org/ntsb/DEN05FA038.md): Cessna 421 · Englewood, CO · Accident · 3 fatal · Field investigation · Final report · Dec 17, 2004 · N421FR · Destroyed
  > loss of engine power due to fuel starvation, and the instructor's failure to maintain aircraft control. Contributing factors were a partially blocked fuel line resulting in restricted fuel flow, the instructor's failure to perform critical emergency…
- [NTSB DEN05FA034](https://openairdocs.org/ntsb/DEN05FA034.md): Mitsubishi MU-2B-60 · Englewood, CO · Accident · 2 fatal · Field investigation · Final report · Dec 11, 2004 · N538EA · Destroyed
  > the pilot's failure to maintain minimum controllable airspeed during the night visual approach resulting in a loss of control and uncontrolled descent into terrain. A contributing factor was the precautionary shutdown of the left engine for undetermined…
- [NTSB DFW05LA034](https://openairdocs.org/ntsb/DFW05LA034.md): Beech BE-200 · Bay View, TX · Accident · No injuries · Limited investigation · Final report · Dec 10, 2004 · N648KA · Destroyed
  > The pilot's failure to maintain directional control as result of his improper runway selection for takeoff. A contributing factor was the prevailing right quartering tailwind.
- [NTSB DFW05CA044](https://openairdocs.org/ntsb/DFW05CA044.md): Bell B206L-1 · Patterson, LA · Accident · No injuries · Data collection · Final report · Dec 9, 2004 · N5007F · Substantial damage
  > The loss of engine power due to fuel starvation resulting from the pilot's failure to activate the fuel boost pumps prior to takeoff. A contributing factor was that the helicopter was at an airspeed and altiutude combination (below height/velocity curve)…
- [NTSB NYC05LA030](https://openairdocs.org/ntsb/NYC05LA030.md): Day VP-2 · Warrenton, VA · Accident · No injuries · Limited investigation · Final report · Dec 8, 2004 · N19LC · Substantial damage
  > A loss of engine power for an undetermined reason.
- [NTSB SEA05FA022](https://openairdocs.org/ntsb/SEA05FA022.md): Cessna 185F · Renton, WA · Accident · 1 fatal · Field investigation · Final report · Dec 5, 2004 · N532PC · Destroyed
  > The pilot's failure to maintain aircraft control when the flaps became jammed/stuck in their full-down position during a takeoff from a touch-and-go landing. Factors include a worn/disconnected flap latch mechanism, and the flaps being unable to be retracted.
- [NTSB CHI05CA044](https://openairdocs.org/ntsb/CHI05CA044.md): Goiden Circle T-Bird · Ft. Dodge, IA · Accident · Serious injuries · Data collection · Final report · Dec 4, 2004 · UNREG · Destroyed
  > The loss of engine power during initial climb for undetermined reasons.
- [NTSB MIA05LA036](https://openairdocs.org/ntsb/MIA05LA036.md): Piper PA-28-180 · Milton, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2004 · N7510W · Destroyed
  > A loss of engine power due to fuel starvation as a result of the improper fuel selector position.
- [NTSB ATL05FA032](https://openairdocs.org/ntsb/ATL05FA032.md): Cessna 421B · Apison, TN · Accident · 5 fatal · Field investigation · Final report · Dec 2, 2004 · N421SD · Destroyed
  > The pilot's improper identification of a partial loss of engine power on initial takeoff climb resulting in a collision with trees and the ground. A factor was a partial failure of the left engine starter adapter due to overload.
- [NTSB DFW05LA026](https://openairdocs.org/ntsb/DFW05LA026.md): Piper PA-24-250 · Granbury, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2004 · N7706P · Substantial damage
  > The loss of engine power due to fuel starvation. Contributing factors were the pilot's inadequate preflight planning/preparation, and the lack of suitable terrain for the forced landing.
- [NTSB NYC05LA022](https://openairdocs.org/ntsb/NYC05LA022.md): Cessna 182E · Duanesburg, NY · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 2004 · N1DZ · Substantial damage
  > The pilot's improper decision to attempt a takeoff without allowing the engine to adequately warm-up; which resulted in a partial loss of power during takeoff and subsequent forced landing.
- [NTSB LAX05FA041](https://openairdocs.org/ntsb/LAX05FA041.md): Cessna 411 · Corona, CA · Accident · 2 fatal · Field investigation · Final report · Nov 25, 2004 · N747JU · Destroyed
  > A loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…
- [NTSB LAX05LA039](https://openairdocs.org/ntsb/LAX05LA039.md): Schweizer 269C · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Nov 22, 2004 · N45012 · Substantial damage
  > the pilot's failure to maintain adequate rotor rpm and altitude/clearance during the takeoff initial climb.
- [NTSB ATL05IA025](https://openairdocs.org/ntsb/ATL05IA025.md): Cirrus Design SR22 · Peachtree City, GA · Incident · No injuries · Incident investigation · Final report · Nov 16, 2004 · N723CD · Minor damage
  > The failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.
- [NTSB MIA05LA029](https://openairdocs.org/ntsb/MIA05LA029.md): Joseph R. Sirgo Aquilla · Eustis, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2004 · N2011G · Substantial damage
  > The passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.
- [NTSB CHI05FA024](https://openairdocs.org/ntsb/CHI05FA024.md): Piper PA-23-250 · Detroit, MI · Accident · Serious injuries · Field investigation · Final report · Nov 8, 2004 · N63887 · Destroyed
  > The pilot's failure to feather the propeller and to maintain control of the airplane following the loss of engine power which resulted from undetermined reasons. Factors associated with the accident were the power lines and the house that the airplane…
- [NTSB ATL05LA022](https://openairdocs.org/ntsb/ATL05LA022.md): Piper PA-32-260 · Chamblee, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2004 · N411CP · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power..
- [NTSB LAX05FA029](https://openairdocs.org/ntsb/LAX05FA029.md): Piper PA-18-150 · Mesa, AZ · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2004 · N6854P · Destroyed
  > the pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.
- [NTSB DFW05LA016](https://openairdocs.org/ntsb/DFW05LA016.md): Wilson Loenslo YMF-80 · Arcola, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N6254A · Destroyed
  > The pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff initial climb.
- [NTSB MIA05FA020](https://openairdocs.org/ntsb/MIA05FA020.md): Rawdon Bros. T1 · Pembroke Pines, FL · Accident · 1 fatal · Field investigation · Final report · Nov 2, 2004 · N2706D · Destroyed
  > Improper maintenance by company maintenance personnel, and the pilot-in-command's operating the airplane with known deficiencies, which resulted in the loss of engine power due to fuel system contamination, and a loss of control while maneuvering to return to…
- [NTSB LAX05LA025](https://openairdocs.org/ntsb/LAX05LA025.md): Eurocopter AS350B3 · Sierra Vista, AZ · Accident · No injuries · Limited investigation · Final report · Nov 2, 2004 · N106LN · Substantial damage
  > An inconsistency between the engines' two N2 sensor signals caused the fuel control to enter a fixed mode, which limited the power available. Contributing to the accident was the lack of altitude and airspeed available to give the pilot time to select a…
- [NTSB MIA05FA017](https://openairdocs.org/ntsb/MIA05FA017.md): Cessna P206 · Jacksonville, FL · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2004 · N2588X · Substantial damage
  > The improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…
- [NTSB ATL05LA017](https://openairdocs.org/ntsb/ATL05LA017.md): David Nielson Ison Hi-Max 1700 · Hendersonville, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 2004 · N105DN · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.
- [NTSB CHI05LA019](https://openairdocs.org/ntsb/CHI05LA019.md): Piper PA-24 · Buffalo Grove, IL · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 2004 · N6764P · Substantial damage
  > Fatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.
- [NTSB IAD05LA008](https://openairdocs.org/ntsb/IAD05LA008.md): Cessna 180 · Freedom, PA · Accident · 1 fatal · Limited investigation · Final report · Oct 27, 2004 · N2922C · Substantial damage
  > The pilot's failure to maintain obstacle clearance during the takeoff resulting in an in-flight collision with trees.
- [NTSB ATL05FA013](https://openairdocs.org/ntsb/ATL05FA013.md): Beech BE-60 · Asheville, NC · Accident · 4 fatal · Field investigation · Final report · Oct 27, 2004 · N611JC · Substantial damage
  > The pilot's failure to follow emergency procedures and to maintain airspeed following a loss of engine power during takeoff, which resulted in an inadvertent stall/spin and subsequent uncontrolled impact with terrain. Contributing to the cause was inadequate…
- [NTSB MIA05LA015](https://openairdocs.org/ntsb/MIA05LA015.md): David Cadorette Fox Model II · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2004 · N267KF · Substantial damage
  > Loss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.
- [NTSB CHI05LA018](https://openairdocs.org/ntsb/CHI05LA018.md): Kramer Glasair III · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Oct 26, 2004 · N6158N · Substantial damage
  > Fuel starvation for undetermined reasons during initial climb after takeoff. Contributing factors were the fence and fence post impacted during the forced landing.
- [NTSB LAX05FA015](https://openairdocs.org/ntsb/LAX05FA015.md): Learjet 35A · San Diego, CA · Accident · 5 fatal · Class 1 · Field · Final report · Oct 24, 2004 · N30DK · Destroyed
  > The failure of the flight crew to maintain terrain clearance during a VFR departure, which resulted in controlled flight into terrain, and the air traffic controller's issuance of a clearance that transferred the responsibility for terrain clearance from the…
- [NTSB ATL05FA008](https://openairdocs.org/ntsb/ATL05FA008.md): Beech F33A · Flat Rock, NC · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2004 · N18303 · Substantial damage
  > The pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.
- [NTSB CHI05LA013](https://openairdocs.org/ntsb/CHI05LA013.md): Stinson 108-2 · Indian River, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2004 · N425C · Substantial damage
  > Loss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing encountered by the pilot and the airplane's low altitude at the time engine power was lost.
- [NTSB DFW05LA009](https://openairdocs.org/ntsb/DFW05LA009.md): Cessna 150L · Denton, TX · Accident · No injuries · Limited investigation · Final report · Oct 19, 2004 · N6870G · Substantial damage
  > The loss of engine power due to the separation of the accessory drive gear bolts, and the failure of the starter-clutch assembly. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC05FA006](https://openairdocs.org/ntsb/NYC05FA006.md): Beech H50 · Hartwood, VA · Accident · 1 fatal · Field investigation · Final report · Oct 17, 2004 · N171S · Destroyed
  > The pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.
- [NTSB CHI05LA004](https://openairdocs.org/ntsb/CHI05LA004.md): Malone Vans RV-6A · Joliet, IL · Accident · 1 fatal · Limited investigation · Final report · Oct 15, 2004 · N85MM · Destroyed
  > The total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and inadequate fuel consumption calculations, also causal was the pilot's failure to maintain aircraft control during the forced landing. A factor was the…
- [NTSB ANC05LA006](https://openairdocs.org/ntsb/ANC05LA006.md): Piper J-3 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Oct 14, 2004 · N92469 · Substantial damage
  > An inadequate annual inspection by other maintenance personnel, which resulted in a loss of engine power during takeoff-initial climb, and subsequent collision with trees during the ensuing emergency landing. Factors associated with the accident are a…
- [NTSB ANC05CA004](https://openairdocs.org/ntsb/ANC05CA004.md): Cessna 185F · King Salmon, AK · Accident · Serious injuries · Data collection · Final report · Oct 10, 2004 · N5001R · Substantial damage
  > The pilot's failure to use a checklist, and to remove the flight control locks prior to flight, which resulted in an uncontrolled descent and in-flight collision with terrain/water.
- [NTSB NYC05CA004](https://openairdocs.org/ntsb/NYC05CA004.md): Boeing Stearman B75-N1 · Jaffery, NH · Accident · Minor injuries · Data collection · Final report · Oct 9, 2004 · N49738 · Substantial damage
  > The pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.
- [NTSB ATL05CA002](https://openairdocs.org/ntsb/ATL05CA002.md): Cessna 172K · Knoxville, TN · Accident · Serious injuries · Data collection · Final report · Oct 9, 2004 · N78211 · No damage
  > The pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.
- [NTSB SEA05FA004](https://openairdocs.org/ntsb/SEA05FA004.md): Maule MT-7-420 · Bend, OR · Accident · No injuries · Field investigation · Final report · Oct 8, 2004 · N186SB · Substantial damage
  > Loss of engine power during takeoff climb for undetermined reasons. Rough terrain was a factor.
- [NTSB IAD05LA002](https://openairdocs.org/ntsb/IAD05LA002.md): Bradley Renegade · Stow, MA · Accident · No injuries · Limited investigation · Final report · Oct 7, 2004 · N210SQ · Substantial damage
  > A partial loss of engine power for undetermined reasons, which resulted in the airplane's inability to climb over a stand of trees.
- [NTSB CHI05CA001](https://openairdocs.org/ntsb/CHI05CA001.md): Piper PA-23-180 · Beatrice, NE · Accident · Serious injuries · Data collection · Final report · Oct 3, 2004 · N173DC · Destroyed
  > The loss of right engine power undetermined reasons. Factors to the accident were the loss of engine power at a low altitude and below the single engine best rate of climb airspeed (Vyse), and the unsuitable terrain encountered during the subsequent forced…
- [NTSB CHI04LA292](https://openairdocs.org/ntsb/CHI04LA292.md): Cessna 150M · Durand, MI · Accident · No injuries · Limited investigation · Final report · Sep 30, 2004 · N45673 · Substantial damage
  > The elongated exhaust valve leading to the in-flight loss of engine power during initial climb. A factor was the transmission wire the airplane impacted during its emergency landing after takeoff.
- [NTSB CHI04FA290](https://openairdocs.org/ntsb/CHI04FA290.md): Beech B95A · Burlington, WI · Accident · 3 fatal · Field investigation · Final report · Sep 30, 2004 · N1703Y · Destroyed
  > The improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…
- [NTSB NYC04FA220](https://openairdocs.org/ntsb/NYC04FA220.md): Piper PA-28-180 · Avondale, PA · Accident · 1 fatal · Field investigation · Final report · Sep 29, 2004 · N54397 · Substantial damage
  > The pilot's inadequate preflight inspection that resulted in fuel contamination and a subsequent loss of engine power.

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

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