# NTSB investigations, 2004: Takeoff

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 3 · 129 cases

## Latest cases

- [NTSB NYC05LA034](https://openairdocs.org/ntsb/NYC05LA034.md): Cessna 172R · Smoketown, PA · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 2004 · N9962F · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.
- [NTSB CHI05LA047](https://openairdocs.org/ntsb/CHI05LA047.md): Learjet 25B · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Dec 20, 2004 · N252BK · Substantial damage
  > The pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.
- [NTSB DEN05LA036](https://openairdocs.org/ntsb/DEN05LA036.md): Robinson R22 · Provo, UT · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 2004 · N333UH · Substantial damage
  > the flight instructor's failure to maintain clearance from the water. Contributing to the accident was the flight instructor's inability to detect a descent because of the obscuration between the water and the horizon due to the gray sky
- [NTSB CHI05CA043](https://openairdocs.org/ntsb/CHI05CA043.md): Bellanca 14-19 · Williston, ND · Accident · No injuries · Data collection · Final report · Dec 10, 2004 · N6563N · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during the takeoff roll. A contributing factorwas the approach light.
- [NTSB LAX05FA045](https://openairdocs.org/ntsb/LAX05FA045.md): Cessna T310R · Flagstaff, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2004 · N592DM · Destroyed
  > The pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…
- [NTSB NYC05LA025](https://openairdocs.org/ntsb/NYC05LA025.md): Mitsubishi MU-2B-60 · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Nov 30, 2004 · N941MA · Substantial damage
  > The failure of the ground controller to coordinate the runway crossing of a maintenance tug, with the local controller, which resulted in a ground collision with an MU-2 airplane during it's takeoff roll.
- [NTSB DEN05MA029](https://openairdocs.org/ntsb/DEN05MA029.md): Canadair CL-600-2A12 · Montrose, CO · Accident · 3 fatal · Class 1 · Major · Final report · Nov 28, 2004 · N873G · Destroyed
  > the flight crew's failure to ensure that the airplane’s wings were free of ice or snow contamination that accumulated while the airplane was on the ground, which resulted in an attempted takeoff with upper wing contamination that induced the subsequent stall…
- [NTSB IAD05CA018](https://openairdocs.org/ntsb/IAD05CA018.md): Piper PA 28-181 · York, PA · Accident · No injuries · Data collection · Final report · Nov 25, 2004 · N720GP · Substantial damage
  > The pilot's inadequate weather evaluation and his decision to depart from a rain-soaked runway with strong quartering tailwinds, which resulted in a runway overrun and collision with a fence during the aborted takeoff.
- [NTSB NYC05CA019](https://openairdocs.org/ntsb/NYC05CA019.md): Vigneau RAF 2000 GTX · Chatham, MA · Accident · No injuries · Data collection · Final report · Nov 21, 2004 · N9327B · Substantial damage
  > The pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.
- [NTSB DEN05LA028](https://openairdocs.org/ntsb/DEN05LA028.md): Farrell Lancair LC3 · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Nov 20, 2004 · N41MF · Substantial damage
  > the pilot's failure to maintain directional control during takeoff.
- [NTSB ATL05LA026](https://openairdocs.org/ntsb/ATL05LA026.md): Golden Circle Air T-Bird II · Dunlap, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 2004 · UNREG · Substantial damage
  > The pilot's improper flare during forced landing following a loss of engine power for undetermined reasons, which resulted in a hard landing. A factor was the separation of a fuel line, which resulted in fuel starvation to the engine.
- [NTSB SEA05LA016](https://openairdocs.org/ntsb/SEA05LA016.md): Hannah Avid Amphibian · Creswell, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 2004 · N80AH · Substantial damage
  > Carburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.
- [NTSB DEN05CA016](https://openairdocs.org/ntsb/DEN05CA016.md): Cessna 152 · Santa Teresa, NM · Accident · No injuries · Data collection · Final report · Oct 28, 2004 · N5290B · Substantial damage
  > the student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.
- [NTSB NYC05LA010](https://openairdocs.org/ntsb/NYC05LA010.md): Fairchild 24R-40 · Custar, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 2004 · N28539 · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain. A factor was a crosswind.
- [NTSB MIA05LA012](https://openairdocs.org/ntsb/MIA05LA012.md): Rockwell 112A · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Oct 24, 2004 · N112ND · Substantial damage
  > The pilot's failure to properly set flaps for takeoff which resulted in the aborted takeoff and subsequent impact with water during an overrun of the runway and seawall.
- [NTSB LAX05LA013](https://openairdocs.org/ntsb/LAX05LA013.md): Cessna 152 · Mesa, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 2004 · N856ER · Substantial damage
  > the student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.
- [NTSB MIA05CA014](https://openairdocs.org/ntsb/MIA05CA014.md): Piper PA-28-161 · Valkaria, FL · Accident · No injuries · Data collection · Final report · Oct 19, 2004 · N607FT · Substantial damage
  > The inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.
- [NTSB SEA05LA009](https://openairdocs.org/ntsb/SEA05LA009.md): Cessna A185F · White Bird, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2004 · N101AM · Substantial damage
  > The pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.
- [NTSB NYC05CA007](https://openairdocs.org/ntsb/NYC05CA007.md): Beech A23 · New Market, VA · Accident · No injuries · Data collection · Final report · Oct 16, 2004 · N130SV · Substantial damage
  > A collision with a deer during the takeoff roll. A factor in the accident was the night.
- [NTSB DFW05CA006](https://openairdocs.org/ntsb/DFW05CA006.md): Gunnoe Velocity · Myrick, OK · Accident · No injuries · Data collection · Final report · Oct 16, 2004 · N92VA · Substantial damage
  > The pilot's improper wind evaluation. Contributing factors were the tailwind and the short runway.
- [NTSB SEA05LA005](https://openairdocs.org/ntsb/SEA05LA005.md): Piper PA-18-150 · Oak Harbor, WA · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 2004 · N6410W · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain.
- [NTSB IAD05LA003](https://openairdocs.org/ntsb/IAD05LA003.md): Aero Commander 100 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Oct 12, 2004 · N81DC · Substantial damage
  > The delayed remedial action by the flight instructor.
- [NTSB ANC05IA002](https://openairdocs.org/ntsb/ANC05IA002.md): Boeing MD-11F · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Oct 9, 2004 · N275WA · Minor damage
  > The operator's failure to provide sufficient weight and balance information to the flight crew, which resulted in a center of gravity aft of the limit, and a tail strike during the takeoff roll. Factors associated with the incident are the operator's improper…
- [NTSB LAX05CA004](https://openairdocs.org/ntsb/LAX05CA004.md): Hughes 369HS · Pacific Ocean (Pacific Ocean) · Accident · No injuries · Data collection · Final report · Oct 6, 2004 · N74AM · Substantial damage
  > the pilot's inadequate preflight inspection to ensure that all tie downs were removed from the helicopter, which resulted in a dynamic rollover.
- [NTSB FTW05LA003](https://openairdocs.org/ntsb/FTW05LA003.md): Lockheed 18-56 · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2004 · N6371C · Substantial damage
  > The pilot's failure to maintain directional control during takeoff. Contributing factors were the choice of runway used and the prevailing tailwind.
- [NTSB SEA05LA002](https://openairdocs.org/ntsb/SEA05LA002.md): Cessna 150G · Augusta, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 2004 · N3086R · Substantial damage
  > The pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.
- [NTSB IAD05LA001](https://openairdocs.org/ntsb/IAD05LA001.md): Piper PA-34-200T · Robbinsville, NJ · Accident · No injuries · Limited investigation · Final report · Oct 2, 2004 · N5507V · Substantial damage
  > The repair station's improper installation of the stabilator trim tab. A factor was the pilot's inadequate preflight inspection of the airplane.
- [NTSB ATL04CA197](https://openairdocs.org/ntsb/ATL04CA197.md): Cessna 150M · Sevierville, TN · Accident · No injuries · Data collection · Final report · Sep 30, 2004 · N45667 · Substantial damage
  > The pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.
- [NTSB CHI04LA298](https://openairdocs.org/ntsb/CHI04LA298.md): Cessna 208B · Decatur, IL · Accident · No injuries · Limited investigation · Final report · Sep 29, 2004 · N276PM · Substantial damage
  > The pilot's inadequate preflight preparation, and his subsequent selection of a runway for takeoff that was listed as out of service, resulting in a collision with barricades and uneven terrain during takeoff.
- [NTSB ANC04CA119](https://openairdocs.org/ntsb/ANC04CA119.md): Piper PA-28-181 · Haines, AK · Accident · No injuries · Data collection · Final report · Sep 29, 2004 · N3002T · Substantial damage
  > The pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a premature liftoff and subsequent uncontrolled descent and collision with the runway.
- [NTSB ANC04IA115](https://openairdocs.org/ntsb/ANC04IA115.md): McDonnell Douglas MD-82 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Sep 26, 2004 · N16894 · No damage
  > The loss of engine power due to the flight crew's failure to follow published procedures and directives, and an inadequate preflight inspection, which resulted in ice ingestion into the left engine during the takeoff roll. Factors associated with the incident…
- [NTSB CHI04CA291](https://openairdocs.org/ntsb/CHI04CA291.md): Johnson Titan Tornado I · Carlton, MN · Accident · No injuries · Data collection · Final report · Sep 25, 2004 · UNREG · Substantial damage
  > The pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.
- [NTSB MIA04FA128](https://openairdocs.org/ntsb/MIA04FA128.md): Cessna R182 · Milton, FL · Accident · 4 fatal · Field investigation · Final report · Sep 23, 2004 · N5157T · Destroyed
  > The pilots operation of the airplane with known deficiencies in the equipment based on witness statements describing an excessive rpm drop and rough running engine after starting, during the engine run-up, and after becoming airborne, his failure to abort the…
- [NTSB LAX04LA328](https://openairdocs.org/ntsb/LAX04LA328.md): Cessna 210B · Flagstaff, AZ · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 2004 · N9757X · Substantial damage
  > the pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.
- [NTSB DEN04LA146](https://openairdocs.org/ntsb/DEN04LA146.md): Smith Aerostar 601P · Lordsberg, NM · Accident · No injuries · Limited investigation · Final report · Sep 21, 2004 · N11BE · Substantial damage
  > aircraft control not maintained by the pilot. Contributing to the accident was the dirt devil/whirlwind.
- [NTSB CHI04CA266](https://openairdocs.org/ntsb/CHI04CA266.md): Piper PA-28-180 · Hurdland, MO · Accident · Minor injuries · Data collection · Final report · Sep 18, 2004 · N8275W · Substantial damage
  > The pilot's failure to maintain proper airspeed and directional control during the takeoff and his failure to properly abort the takeoff after the encountered tailstrike. A factor to the accident was the stall/mush encountered during the attempted takeoff and…
- [NTSB CHI04CA261](https://openairdocs.org/ntsb/CHI04CA261.md): Abbott RAF 2000 · Pontiac, MI · Accident · No injuries · Data collection · Final report · Sep 18, 2004 · N702BX · Substantial damage
  > The partial loss of engine power due to the scoring and overheating of the cylinders as a result of the pilot/owner's improper servicing of the modified engine cooling system. Additional factors included the pilot/owner modifying and servicing the engine…
- [NTSB SEA04FA188](https://openairdocs.org/ntsb/SEA04FA188.md): Beech A-36 · Auburn, WA · Accident · Serious injuries · Field investigation · Final report · Sep 13, 2004 · N100EV · Destroyed
  > The pilot's failure to abort the takeoff early enough to allow him to stop the aircraft before it went off the departure end of the runway. Factors include the pilot's inadequate preflight procedures, water contamination in the fuel, a partial loss of power,…
- [NTSB CHI04CA259](https://openairdocs.org/ntsb/CHI04CA259.md): Schroeder Wichawk · New Hudson, MI · Accident · No injuries · Data collection · Final report · Sep 12, 2004 · N227PS · Substantial damage
  > The pilot failed to maintain directional control during takeoff roll. A factor was the VASI light.
- [NTSB NYC04LA211](https://openairdocs.org/ntsb/NYC04LA211.md): Cessna 172M · Medina, OH · Accident · No injuries · Limited investigation · Final report · Sep 10, 2004 · N172WW · Substantial damage
  > The partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.
- [NTSB ATL04CA184](https://openairdocs.org/ntsb/ATL04CA184.md): Piper PA-28-140 · Mount Pleasant, SC · Accident · No injuries · Data collection · Final report · Sep 10, 2004 · N9621W · Substantial damage
  > Ground collision with an animal (deer) during an attempted takeoff.
- [NTSB NYC04CA207](https://openairdocs.org/ntsb/NYC04CA207.md): Cessna 402C · Charleston, WV · Accident · No injuries · Data collection · Final report · Sep 8, 2004 · N5774C · Substantial damage
  > The pilot's improper decision to abort the takeoff with insufficient runway remaining. A factor was the wet runway.
- [NTSB DEN04FA134](https://openairdocs.org/ntsb/DEN04FA134.md): Mooney M20D · Pagosa Springs, CO · Accident · 1 fatal · Field investigation · Final report · Sep 6, 2004 · N1907Y · Destroyed
  > the pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.
- [NTSB ATL04CA189](https://openairdocs.org/ntsb/ATL04CA189.md): Beech D18S · Tullahoma, TN · Accident · No injuries · Data collection · Final report · Sep 6, 2004 · N432U · Substantial damage
  > Right tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.
- [NTSB ANC04LA118](https://openairdocs.org/ntsb/ANC04LA118.md): Piper PA-22-160 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 2004 · N9028D · Substantial damage
  > The pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.
- [NTSB ANC04CA105](https://openairdocs.org/ntsb/ANC04CA105.md): Piper PA-18 · Healy, AK · Accident · No injuries · Data collection · Final report · Sep 6, 2004 · N7472D · Substantial damage
  > The pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with vegetation and a nose over. A factor contributing to the accident was a tailwind.
- [NTSB SEA04LA180](https://openairdocs.org/ntsb/SEA04LA180.md): Piper PA-32R-301T · Picabo, ID · Accident · No injuries · Limited investigation · Final report · Sep 5, 2004 · N880SC · Substantial damage
  > The pilot's failure to set the propeller control for takeoff performance needed to outclimb obstacles. The pilot's failure to use the checklist, trees, and a fence are contributing factors.
- [NTSB DEN04LA138](https://openairdocs.org/ntsb/DEN04LA138.md): Gates Learjet 25B · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Sep 4, 2004 · N47MR · Substantial damage
  > right main tire failure for reasons undetermined.
- [NTSB CHI04CA246](https://openairdocs.org/ntsb/CHI04CA246.md): Utterback Mustang II · Kendallville, IN · Accident · Minor injuries · Data collection · Final report · Sep 4, 2004 · N91622 · Substantial damage
  > The pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.
- [NTSB SEA04LA178](https://openairdocs.org/ntsb/SEA04LA178.md): Helio H800 · Fossil, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2004 · N4033G · Destroyed
  > The pilot's failure to remove the aileron wing gust locks prior to flight, which resulted in a loss of control during the descent/emergency landing. A factor contributing to the accident was the pilot's inadequate preflight.

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

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