# NTSB investigations, 2003: 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 9 · 415 cases

## Latest cases

- [NTSB MIA04FA037](https://openairdocs.org/ntsb/MIA04FA037.md): Cessna 441 · Greenacres City, FL · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2003 · N111RC · Destroyed
  > The pilot's failure to maintain aircraft control, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into a canal. A factor was the pilot's impairment by the drug chlorpheniramine.
- [NTSB ANC04LA017](https://openairdocs.org/ntsb/ANC04LA017.md): Piper PA-12 · Togiak, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 2003 · N3624M · Substantial damage
  > A loss of engine power due to an undetermined reason that resulted in a forced landing, a collapse of the main landing gear, and a collision with trees. A factor associated with the accident was the lack of suitable terrain for a forced landing.
- [NTSB ATL04FA061](https://openairdocs.org/ntsb/ATL04FA061.md): Mooney 20F · Campobello, SC · Accident · 1 fatal · Field investigation · Final report · Dec 28, 2003 · N2996L · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering for an emergency landing resulting in an inadvertent stall and a collision with trees and the ground during an uncontrolled descent. A factor in the accident was the pilot's inadequate preflight…
- [NTSB LAX04FA076](https://openairdocs.org/ntsb/LAX04FA076.md): Agusta A109A · Redwood Valley, CA · Accident · 3 fatal · Field investigation · Final report · Dec 24, 2003 · N25RX · Destroyed
  > The pilot's improper in-flight planning and decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in an inadvertent in-flight encounter with instrument meteorological conditions and a collision with rising…
- [NTSB LAX04FA075](https://openairdocs.org/ntsb/LAX04FA075.md): Learjet 24B · Helendale, CA · Accident · 2 fatal · Class 1 · Field · Final report · Dec 23, 2003 · N600XJ · Destroyed
  > A loss of airplane control for undetermined reasons.
- [NTSB FTW04LA063](https://openairdocs.org/ntsb/FTW04LA063.md): Cessna 172K · Lake Charles, LA · Accident · No injuries · Limited investigation · Final report · Dec 23, 2003 · N111TK · Substantial damage
  > The disintegration of the piston, which resulted in the catastrophic failure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN04LA032](https://openairdocs.org/ntsb/DEN04LA032.md): Piper PA-12 · Edgewood, NM · Accident · No injuries · Limited investigation · Final report · Dec 23, 2003 · N4159M · Substantial damage
  > the pilot's inadequate in-flight planning and decision making. Factors contributing to the accident include the resulting fuel exhaustion, the snow covered field and the fence.
- [NTSB LAX04LA074](https://openairdocs.org/ntsb/LAX04LA074.md): Beech B55 · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Dec 20, 2003 · N20480 · Substantial damage
  > The pilot's continued VFR flight into adverse weather conditions during cruise flight, which resulted in a low fuel state and a precautionary landing in rough terrain.
- [NTSB LAX04LA073](https://openairdocs.org/ntsb/LAX04LA073.md): Robinson R22 Beta · Temecula, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 20, 2003 · N7189U · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB ATL04LA058](https://openairdocs.org/ntsb/ATL04LA058.md): Cessna 152 · Louisburg, NC · Accident · No injuries · Limited investigation · Final report · Dec 20, 2003 · N93002 · Substantial damage
  > Other maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.
- [NTSB CHI04FA044](https://openairdocs.org/ntsb/CHI04FA044.md): Piper PA-32-260 · Brooklyn, IA · Accident · 4 fatal · Field investigation · Final report · Dec 18, 2003 · N3733W · Substantial damage
  > The pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…
- [NTSB CHI04FA043](https://openairdocs.org/ntsb/CHI04FA043.md): Piper PA46-500TP · Daytona Beach, FL · Accident · 2 fatal · Field investigation · Final report · Dec 17, 2003 · N155BM · Destroyed
  > The unqualified pilot's continued flight into known instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Factors were the pilot's lack of instrument flight experience and the low ceiling.
- [NTSB LAX04FA067](https://openairdocs.org/ntsb/LAX04FA067.md): Robinson R22 Beta · Redlands, CA · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2003 · N1225D · Destroyed
  > a loss of engine power due to the pilot inadvertently turning off the magnetos and his failure to initiate an autorotation and to maintain main rotor rpm. A factor in the accident was the pilot's use of an over-the-counter medication that impaired his…
- [NTSB FTW04FA044](https://openairdocs.org/ntsb/FTW04FA044.md): Beech H-35 · Mena, AR · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2003 · N7929D · Destroyed
  > The pilot's failure to maintain proper altitude and clearance from terrain. Contributing factors were the mountainous terrain, fog, clouds, and turbulence.
- [NTSB FTW04LA042](https://openairdocs.org/ntsb/FTW04LA042.md): Cessna 210 · Clarendon, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2003 · N718LG · Destroyed
  > the loss of engine power due the separation of the number six cylinder as a result of a fatigue failure from the loosening of the cylinder attachment hardware.
- [NTSB ANC04LA014](https://openairdocs.org/ntsb/ANC04LA014.md): Piper PA-32-260 · Larson Bay, AK · Accident · No injuries · Limited investigation · Final report · Dec 12, 2003 · N3983W · Substantial damage
  > The loss of engine power for an unknown reason while maneuvering, which resulted in the pilot ditching the airplane. Factors contributing to the accident were a low ceiling and a snow squall.
- [NTSB ATL04FA049](https://openairdocs.org/ntsb/ATL04FA049.md): Cessna 441 · Vestavia Hills, AL · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2003 · N441W · Destroyed
  > The pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.
- [NTSB NYC04LA045](https://openairdocs.org/ntsb/NYC04LA045.md): Cessna 152 · Butler, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 2003 · N94820 · Substantial damage
  > The student pilot's improper use of carburetor heat, which resulted in a total loss of engine power during cruise flight. A factor was carburetor icing conditions.
- [NTSB LAX04LA062](https://openairdocs.org/ntsb/LAX04LA062.md): Cessna 172N · Snelling, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 2003 · N739SU · Substantial damage
  > The total loss of engine power due to oil starvation caused by the failure of the engine driven oil pump.
- [NTSB LAX04FA061](https://openairdocs.org/ntsb/LAX04FA061.md): Piper PA-28R-200 · Chino Hills, CA · Accident · 2 fatal · Field investigation · Final report · Dec 8, 2003 · N16264 · Destroyed
  > the pilot's inadequate in-flight planning/decision by which he conducted VFR flight into night instrument meteorological conditions. Mountainous terrain, dark night conditions and the pilot's failure to obtain a preflight weather briefing are contributing…
- [NTSB LAX04LA060](https://openairdocs.org/ntsb/LAX04LA060.md): Cessna 172S · Watsonville, CA · Accident · No injuries · Limited investigation · Final report · Dec 7, 2003 · N396TA · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB ATL04TA047](https://openairdocs.org/ntsb/ATL04TA047.md): Bell OH-58A · Ruskin, FL · Accident · No injuries · Final report · Dec 7, 2003 · N62939 · Substantial damage
  > Loss of engine power due to undertermined reasons which resulted in a collision with terrain.
- [NTSB FTW04IA077](https://openairdocs.org/ntsb/FTW04IA077.md): Bell BH-212 · Galliano, LA · Incident · No injuries · Incident investigation · Final report · Dec 3, 2003 · N5017H · No damage
  > The loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.
- [NTSB FTW04FA029](https://openairdocs.org/ntsb/FTW04FA029.md): Bell 407 · High Island 573 · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2003 · N457PH · Destroyed
  > The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.
- [NTSB NYC04LA039](https://openairdocs.org/ntsb/NYC04LA039.md): Bell 206B · Cranston, RI · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2003 · N90013 · Substantial damage
  > The pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.
- [NTSB SEA04FA022](https://openairdocs.org/ntsb/SEA04FA022.md): Beech S35 · Warren, OR · Accident · 4 fatal · Field investigation · Final report · Nov 25, 2003 · N10BX · Destroyed
  > The vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.
- [NTSB FTW04IA043](https://openairdocs.org/ntsb/FTW04IA043.md): Bell 206B · Venice, LA · Incident · No injuries · Incident investigation · Final report · Nov 25, 2003 · N125TA · Minor damage
  > The failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.
- [NTSB LAX04GA051](https://openairdocs.org/ntsb/LAX04GA051.md): Piper PA-28-180 · Big Bear City, CA · Accident · 2 fatal · Final report · Nov 22, 2003 · N7292W · Destroyed
  > The pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.
- [NTSB FTW04LA027](https://openairdocs.org/ntsb/FTW04LA027.md): Piper PA-28-235 · Sweetwater, TX · Accident · No injuries · Limited investigation · Final report · Nov 21, 2003 · N56318 · Substantial damage
  > the loss of engine power due to a failure of the crankshaft bolt. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW04LA026](https://openairdocs.org/ntsb/FTW04LA026.md): Cessna 172N · La Grange, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2003 · N739YK · Substantial damage
  > The pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.
- [NTSB LAX04LA046](https://openairdocs.org/ntsb/LAX04LA046.md): Suminski Cozy Long Ez · Maui, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2003 · N534S · Destroyed
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching.
- [NTSB FTW04FA022](https://openairdocs.org/ntsb/FTW04FA022.md): Cessna 210M · Tolar, TX · Accident · 1 fatal · Field investigation · Final report · Nov 16, 2003 · N777SG · Destroyed
  > The pilot's improper pre-flight planning and loss of engine power for undetermined reasons. A factor was the fog.
- [NTSB MIA04LA022](https://openairdocs.org/ntsb/MIA04LA022.md): Hughes OH-6A · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Nov 15, 2003 · N369PS · Substantial damage
  > A loss of engine power due to the pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the helicopter during the landing.
- [NTSB LAX04FA042](https://openairdocs.org/ntsb/LAX04FA042.md): Cessna 177RG · Blk Canyon City, AZ · Accident · 1 fatal · Field investigation · Final report · Nov 13, 2003 · N431DL · Destroyed
  > a loss of engine power due to the failure of the single-drive dual magneto that resulted from inadequate lubrication of the breaker cam. Also causal was the improper maintenance by other maintenance personnel during a recent inspection, which should have…
- [NTSB LAX04LA041](https://openairdocs.org/ntsb/LAX04LA041.md): Daughters T18C · Needles, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 11, 2003 · N647C · Destroyed
  > the pilot's continuation of a visual flight rules (VFR) flight into an area of adverse weather, which resulted in an encounter with moderate to severe turbulence and in-flight breakup of the airplane.
- [NTSB CHI04LA028](https://openairdocs.org/ntsb/CHI04LA028.md): Cessna 175 · Mears, MI · Accident · No injuries · Limited investigation · Final report · Nov 8, 2003 · N9275B · Substantial damage
  > Loss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.
- [NTSB LAX04LA038](https://openairdocs.org/ntsb/LAX04LA038.md): Cathaway RV-6A · Saticoy, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2003 · N102RC · Destroyed
  > A loss of engine power due to fuel exhaustion as a result of a loose B-nut fitting for the carburetor fuel inlet line, which allowed fuel to leak out.
- [NTSB NYC04IA023](https://openairdocs.org/ntsb/NYC04IA023.md): Cessna 208B · Bangor, ME · Incident · No injuries · Incident investigation · Final report · Nov 5, 2003 · N805TH · Minor damage
  > The pilot's inability to see through the windshield, which was obscured due to icing conditions. This resulted in the pilot's inadequate flare, and a subsequent hard landing. A factor contributing to the accident was the wing icing.
- [NTSB LAX04LA035](https://openairdocs.org/ntsb/LAX04LA035.md): Eurocopter AS350 B3 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Nov 4, 2003 · N820NA · Substantial damage
  > The pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.
- [NTSB CHI04LA027](https://openairdocs.org/ntsb/CHI04LA027.md): Bell 206B · Coleman, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2003 · N3198C · Destroyed
  > The loss of engine power for undetermined reasons and the unsuitable terrain encountered for the forced landing. The garage building was a factor.
- [NTSB ANC04LA005](https://openairdocs.org/ntsb/ANC04LA005.md): Piper PA-20 · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 2003 · N1486A · Substantial damage
  > The pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent forced landing. Factors associated with the accident were weather conditions conducive to carburetor icing, and the lack of suitable terrain for a…
- [NTSB DEN04LA019](https://openairdocs.org/ntsb/DEN04LA019.md): Boeing 737-500 · Denver, CO · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 2003 · N956UA · No damage
  > the in-flight encounter with heavy to moderate turbulence.
- [NTSB DEN04LA017](https://openairdocs.org/ntsb/DEN04LA017.md): Cessna 172R · Cloudcroft, NM · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 2003 · N9864F · Destroyed
  > the dual student's failure to maintain clearance from the terrain. Also causal was the flight instructor's inadequate supervision. Low altitude flight and rising terrain are contributing factors.
- [NTSB LAX04FA031](https://openairdocs.org/ntsb/LAX04FA031.md): Cessna 421B · Kelso, CA · Accident · 5 fatal · Field investigation · Final report · Oct 29, 2003 · N444AM · Destroyed
  > The pilot's continued VFR flight into instrument conditions between cloud layers and with reduced visibility due to smoke that resulted in an in-flight loss of control from spatial disorientation, and the structural overload of the airframe during the…
- [NTSB LAX04LA029](https://openairdocs.org/ntsb/LAX04LA029.md): North American T-28B · Hornbrook, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 28, 2003 · N28AF · Destroyed
  > a catastrophic engine failure from oil exhaustion due to inadequate maintenance installation of the lubricating system hoses.
- [NTSB MIA04LA013](https://openairdocs.org/ntsb/MIA04LA013.md): Mooney M20J · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2003 · N4103H · Substantial damage
  > loss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.
- [NTSB FTW04LA015](https://openairdocs.org/ntsb/FTW04LA015.md): Piper PA-28-161 · Henryetta, OK · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N8090E · Substantial damage
  > A loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.
- [NTSB CHI04LA021](https://openairdocs.org/ntsb/CHI04LA021.md): Schweizer 269C · Ann Arbor, MI · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N191GC · Substantial damage
  > The loss of engine power due to carburetor ice. Weather conditions conducive to the formation of carburetor ice and a roadway were contributing factors.
- [NTSB LAX04CA024](https://openairdocs.org/ntsb/LAX04CA024.md): Cessna 172N · Fresno, CA · Accident · No injuries · Data collection · Final report · Oct 25, 2003 · N738YL · Substantial damage
  > the pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power. Also causal was the pilot's failure to follow engine out emergency procedures as defined by the pilot operating handbook.
- [NTSB ATL04LA025](https://openairdocs.org/ntsb/ATL04LA025.md): Cessna U206F · Edgefield, SC · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2003 · N3007R · Substantial damage
  > The pilot's failure to follow the checklist to ensure the fuel filler cap was secured resulting in fuel starvation and subsequent loss of engine power.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=2003&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") = 2003
  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=2003

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