# NTSB investigations, 2004: Enroute

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 8 · 380 cases

## Latest cases

- [NTSB NYC05LA036](https://openairdocs.org/ntsb/NYC05LA036.md): Cessna 175B · Lawrenceburg, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 2004 · N8141T · Substantial damage
  > The pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.
- [NTSB LAX05LA057](https://openairdocs.org/ntsb/LAX05LA057.md): Orr Long-Ez · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 2004 · N321EZ · Substantial damage
  > a loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.
- [NTSB DFW05IA048](https://openairdocs.org/ntsb/DFW05IA048.md): Beech A36 · Natchitoches, LA · Incident · No injuries · Incident investigation · Final report · Dec 29, 2004 · N920GL · Minor damage
  > The loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.
- [NTSB DEN05FA045](https://openairdocs.org/ntsb/DEN05FA045.md): Piper PA-31P · Gallup, NM · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2004 · N573B · Destroyed
  > the pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.
- [NTSB CHI05FA049](https://openairdocs.org/ntsb/CHI05FA049.md): Piper PA-23-250 · Ironwood, MI · Accident · 5 fatal · Field investigation · Final report · Dec 28, 2004 · N5398M · Substantial damage
  > Fatigue fracture of an engine cylinder resulting in a loss of power on the left engine. Additional causes were the pilot's failure to maintain minimum control airspeed (Vmc), the resulting loss of aircraft control, and an inadvertent stall/spin. Contributing…
- [NTSB LAX05CA055](https://openairdocs.org/ntsb/LAX05CA055.md): Top Dog Trike · Torrey Pines, CA · Accident · No injuries · Data collection · Final report · Dec 26, 2004 · UNREG · Substantial damage
  > the pilot's inadequate visual lookout, which resulted in the in-flight collision with a power line and a subsequent forced landing. Low altitude flight was a contributing factor.
- [NTSB IAD05LA026](https://openairdocs.org/ntsb/IAD05LA026.md): Cessna 150C · East Moriches, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 2004 · N7857Z · Substantial damage
  > Several mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.
- [NTSB CHI05FA048](https://openairdocs.org/ntsb/CHI05FA048.md): Beech S35 · Herman, WI · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2004 · N5631K · Substantial damage
  > The installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…
- [NTSB DEN05LA043](https://openairdocs.org/ntsb/DEN05LA043.md): Mooney M20E · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Dec 23, 2004 · N5550Q · Substantial damage
  > the pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.
- [NTSB LAX05LA036](https://openairdocs.org/ntsb/LAX05LA036.md): Piper PA-28-180 · Jean, NV · Accident · No injuries · Limited investigation · Final report · Dec 19, 2004 · N32034 · Substantial damage
  > the pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.
- [NTSB DEN05LA041](https://openairdocs.org/ntsb/DEN05LA041.md): Arctic S-1B2 · Steamboat Spngs, CO · Accident · No injuries · Limited investigation · Final report · Dec 18, 2004 · N78AT · Substantial damage
  > the loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.
- [NTSB DFW05FA038](https://openairdocs.org/ntsb/DFW05FA038.md): Cessna T210N · Abita Springs, LA · Accident · 2 fatal · Field investigation · Final report · Dec 14, 2004 · N4873C · Destroyed
  > The loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…
- [NTSB CHI05LA045](https://openairdocs.org/ntsb/CHI05LA045.md): Pilatus PC-12/45 · South Bend, IN · Accident · No injuries · Limited investigation · Final report · Dec 14, 2004 · N922RG · Substantial damage
  > Failure of the fuel control unit (FCU) bellows which resulted in a significant loss of engine power and the pilot's encounter with unsuitable terrain during the subsequent forced landing. A contributing factor was the pilot's inadvertent exceedence of the…
- [NTSB ANC05LA018](https://openairdocs.org/ntsb/ANC05LA018.md): Piper PA-28-140 · Sleetmute, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 2004 · N801FS · Substantial damage
  > A loss of engine power during cruise flight due to a fractured exhaust valve, which resulted in a forced landing, and subsequent nose over of the airplane. A factor associated with the accident was the lack of suitable terrain for a successful emergency…
- [NTSB LAX05LA050](https://openairdocs.org/ntsb/LAX05LA050.md): Schweizer 269C · Ontario, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 2004 · N130JS · Substantial damage
  > a loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.
- [NTSB LAX05LA049](https://openairdocs.org/ntsb/LAX05LA049.md): Robinson R22B · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 11, 2004 · N145RJ · Substantial damage
  > The activation of the low main rotor rpm warning system for undetermined reasons.
- [NTSB DFW05LA033](https://openairdocs.org/ntsb/DFW05LA033.md): Mooney M20F · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Dec 9, 2004 · N3208F · Substantial damage
  > The loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX05FA046](https://openairdocs.org/ntsb/LAX05FA046.md): Cessna T207A · Meadview, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2004 · N1783U · Destroyed
  > a loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.
- [NTSB IAD05LA024](https://openairdocs.org/ntsb/IAD05LA024.md): Hare Seawind · Trenton, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2004 · N42HA · Substantial damage
  > The pilot's improper fuel management which resulted in fuel starvation and subsequent loss of engine power. A contributing factor to the accident was the pilot's inadvertent loss of airspeed.
- [NTSB CHI05CA041](https://openairdocs.org/ntsb/CHI05CA041.md): Piper PA-30 · Atlantic, IA · Accident · No injuries · Data collection · Final report · Dec 5, 2004 · N7803Y · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The dark night light conditions was a contributing factor.
- [NTSB ANC05IA016](https://openairdocs.org/ntsb/ANC05IA016.md): Boeing 747SR-146B SF · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Dec 5, 2004 · JA8158 · Minor damage
  > The fatigue and subsequent fracture of a portion of the airplane's pressure bulkhead, which resulted in a rapid decompression during cruise flight.
- [NTSB NYC05IA029](https://openairdocs.org/ntsb/NYC05IA029.md): Fairchild-Heliporter Pilatus PC6/B2-H2 · Cross Keys, NJ · Incident · No injuries · Incident investigation · Final report · Dec 4, 2004 · N7391U · Minor damage
  > A total failure of the left elevator attachment point for undetermined reasons.
- [NTSB MIA05FA040](https://openairdocs.org/ntsb/MIA05FA040.md): Convair Div. of Gen. Dynamics 340 · N. Miami Beach, FL · Accident · No injuries · Field investigation · Final report · Dec 4, 2004 · N41626 · Substantial damage
  > The improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…
- [NTSB DFW05LA027](https://openairdocs.org/ntsb/DFW05LA027.md): Cessna P210N · Pawhuska, OK · Accident · No injuries · Limited investigation · Final report · Dec 1, 2004 · N6300P · Substantial damage
  > The pilot's mismanagement of the fuel by his failure to adequately set the fuel selector position which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX05LA042](https://openairdocs.org/ntsb/LAX05LA042.md): Piper PA-22-108 · Big Pine, CA · Accident · No injuries · Limited investigation · Final report · Nov 28, 2004 · N4913Z · Substantial damage
  > oil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…
- [NTSB CHI05LA037](https://openairdocs.org/ntsb/CHI05LA037.md): Cessna 172H · Belle Plaine, MN · Accident · No injuries · Limited investigation · Final report · Nov 28, 2004 · N2663L · Substantial damage
  > A loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.
- [NTSB SEA05FA019](https://openairdocs.org/ntsb/SEA05FA019.md): Robinson R22 Beta · Arlington, WA · Accident · 2 fatal · Field investigation · Final report · Nov 27, 2004 · N4029Q · Destroyed
  > The divergence of the main rotor from its normal plane of rotation for an undetermined reason, resulting in rotor contact with the aircraft's left windscreen. The failure of the door pins to be installed was a factor.
- [NTSB IAD05LA017](https://openairdocs.org/ntsb/IAD05LA017.md): Chumsae Kitfox Speedster · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Nov 27, 2004 · N124KF · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB IAD05FA023](https://openairdocs.org/ntsb/IAD05FA023.md): CASA 212-200-CC · Bamiyan, Afghanistan · Accident · 6 fatal · Class 1 · Field · Final report · Nov 27, 2004 · N960BW · Destroyed
  > the captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…
- [NTSB DFW05LA025](https://openairdocs.org/ntsb/DFW05LA025.md): Wingo Long-Ez · Huntsville, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2004 · N234BW · Substantial damage
  > Loss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.
- [NTSB CHI05CA036](https://openairdocs.org/ntsb/CHI05CA036.md): Spaulding Tailwind W-8 · Davey, NE · Accident · No injuries · Data collection · Final report · Nov 24, 2004 · N191AS · Substantial damage
  > The loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.
- [NTSB IAD05LA013](https://openairdocs.org/ntsb/IAD05LA013.md): Cessna 172E · Rupert, WV · Accident · No injuries · Limited investigation · Final report · Nov 21, 2004 · N3750S · Substantial damage
  > The pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.
- [NTSB CHI05CA032](https://openairdocs.org/ntsb/CHI05CA032.md): Olson Sonex · Oconomowoc, WI · Accident · Serious injuries · Data collection · Final report · Nov 21, 2004 · N478SX · Substantial damage
  > The loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…
- [NTSB MIA05CA030](https://openairdocs.org/ntsb/MIA05CA030.md): Enstrom F-28C · Panama City Bch, FL · Accident · Minor injuries · Data collection · Final report · Nov 17, 2004 · N595H · Substantial damage
  > The pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.
- [NTSB MIA05FA028](https://openairdocs.org/ntsb/MIA05FA028.md): Piper PA-28R-200 · Dubbs, MS · Accident · 3 fatal · Field investigation · Final report · Nov 14, 2004 · N56960 · Substantial damage
  > The pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.
- [NTSB LAX05FA034](https://openairdocs.org/ntsb/LAX05FA034.md): Beech A36 · Lake Havasu, CA · Accident · 2 fatal · Field investigation · Final report · Nov 14, 2004 · N6111C · Destroyed
  > the pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.
- [NTSB DEN05LA023](https://openairdocs.org/ntsb/DEN05LA023.md): Cessna 152 · Lyons, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 2004 · N48943 · Destroyed
  > the pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.
- [NTSB ATL05CA024](https://openairdocs.org/ntsb/ATL05CA024.md): Cessna 172N · Wilmington, NC · Accident · No injuries · Data collection · Final report · Nov 14, 2004 · N75776 · Substantial damage
  > The student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…
- [NTSB IAD05FA012](https://openairdocs.org/ntsb/IAD05FA012.md): Cessna P210 · Paint Lick, KY · Accident · 1 fatal · Field investigation · Final report · Nov 12, 2004 · N6539P · Destroyed
  > Improper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.
- [NTSB LAX05FA032](https://openairdocs.org/ntsb/LAX05FA032.md): Piper PA-32R-301T · Santa Barbara, CA · Accident · 3 fatal · Field investigation · Final report · Nov 11, 2004 · N803ZG · Destroyed
  > The pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…
- [NTSB LAX05CA030](https://openairdocs.org/ntsb/LAX05CA030.md): Cessna P210N · Rancho Cordova, CA · Accident · No injuries · Data collection · Final report · Nov 11, 2004 · N6416W · Substantial damage
  > The pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…
- [NTSB LAX05LA020](https://openairdocs.org/ntsb/LAX05LA020.md): American Eurocopter AS350-BA · Oxnard, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2004 · N655TV · Substantial damage
  > The inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…
- [NTSB DFW05LA019](https://openairdocs.org/ntsb/DFW05LA019.md): Bell 206L1 · Sapulpa, OK · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2004 · N1075P · Substantial damage
  > The loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.
- [NTSB DFW05LA023](https://openairdocs.org/ntsb/DFW05LA023.md): Cessna 150M · Longview, TX · Accident · No injuries · Limited investigation · Final report · Nov 6, 2004 · N704KX · Substantial damage
  > The pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI05CA025](https://openairdocs.org/ntsb/CHI05CA025.md): Jabat Avid Flyer · Cleveland, MO · Accident · No injuries · Data collection · Final report · Nov 6, 2004 · N90JW · Substantial damage
  > The separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.
- [NTSB MIA05FA024](https://openairdocs.org/ntsb/MIA05FA024.md): Socata TB 20 · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2004 · N1905S · Destroyed
  > The pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.
- [NTSB DFW05LA017](https://openairdocs.org/ntsb/DFW05LA017.md): Bell 206B · S.Timbelier 187 · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N496RL · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB DEN05CA020](https://openairdocs.org/ntsb/DEN05CA020.md): Mooney M20E · Santa Rosa, NM · Accident · No injuries · Data collection · Final report · Nov 5, 2004 · N2695W · Substantial damage
  > Inadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.
- [NTSB ATL05LA020](https://openairdocs.org/ntsb/ATL05LA020.md): Franzreb Loehle 5151 Mustang · Athens, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N711AH · Substantial damage
  > The loss of engine power due to the electrical fuel pump failure, and fuel starvation.
- [NTSB LAX05FA023](https://openairdocs.org/ntsb/LAX05FA023.md): Cessna 182Q · Lebec, CA · Accident · 4 fatal · Field investigation · Final report · Oct 31, 2004 · N95902 · Destroyed
  > the pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.

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

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