# NTSB investigations, 2002: Approach

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

## Latest cases

- [NTSB ATL03LA028](https://openairdocs.org/ntsb/ATL03LA028.md): Cessna 172F · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Dec 31, 2002 · N5338R · Substantial damage
  > The pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.
- [NTSB MIA03FA034](https://openairdocs.org/ntsb/MIA03FA034.md): Cessna 208B · Manteo, NC · Accident · 1 fatal · Field investigation · Final report · Dec 25, 2002 · N1122Y · Substantial damage
  > The pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…
- [NTSB SEA03LA020](https://openairdocs.org/ntsb/SEA03LA020.md): Grumman American AA-1 · Chehalis, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2002 · N5985L · Substantial damage
  > The total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.
- [NTSB FTW03LA065](https://openairdocs.org/ntsb/FTW03LA065.md): Beech BE-35 · Denver City, TX · Accident · No injuries · Limited investigation · Final report · Dec 21, 2002 · N9096Q · Substantial damage
  > The pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.
- [NTSB NYC03LA031](https://openairdocs.org/ntsb/NYC03LA031.md): Bell 206B · Odenton, MD · Accident · No injuries · Limited investigation · Final report · Dec 18, 2002 · N651GA · Substantial damage
  > The pilot's failure to monitor his fuel supply which resulted in a power loss due to fuel exhaustion, and the pilot's misjudged flare, which resulted in a hard landing.
- [NTSB CHI03FA041](https://openairdocs.org/ntsb/CHI03FA041.md): Cessna 208B · Rockford, IL · Accident · 1 fatal · Field investigation · Final report · Dec 18, 2002 · N277PM · Destroyed
  > The pilot's failure to maintain control of the airplane during the ILS approach. Factors associated with the accident were the low ceilings, high winds, crosswind, and wind shear conditions that existed.
- [NTSB OPS03IA001](https://openairdocs.org/ntsb/OPS03IA001.md): Airbus Industrie 330-301 · Agana · Incident · No injuries · Incident investigation · Final report · Dec 17, 2002 · F-OHZO · Minor damage
  > The pilot's initiation of a premature descent that was both below the nominal glideslope and steeper than normal. Contributing to the incident was the air traffic controller's failure to respond to the MSAW warning and issue a safety alert as required by FAA…
- [NTSB LAX03FA051](https://openairdocs.org/ntsb/LAX03FA051.md): Piper PA-24-250 · Anaheim Hills, CA · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2002 · N6268P · Destroyed
  > the pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…
- [NTSB FTW03FA059](https://openairdocs.org/ntsb/FTW03FA059.md): Beech 1900C · Eagleton, AR · Accident · 3 fatal · Field investigation · Final report · Dec 9, 2002 · N127YV · Destroyed
  > In-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.
- [NTSB MIA03FA025](https://openairdocs.org/ntsb/MIA03FA025.md): Raytheon 58 · Fort Myers, FL · Accident · 2 fatal · Field investigation · Final report · Dec 6, 2002 · N241JG · Destroyed
  > the pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.
- [NTSB CHI03LA040](https://openairdocs.org/ntsb/CHI03LA040.md): Cessna 172M · Moline, IL · Accident · No injuries · Limited investigation · Final report · Dec 6, 2002 · N80213 · Substantial damage
  > The pilot's failure to maintain altitude clearance during a base to final turn on approach. Contributing factors to the accident were the night conditions and the trees.
- [NTSB DEN03LA020](https://openairdocs.org/ntsb/DEN03LA020.md): Aerospatiale AS-350BA · Monticello, UT · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2002 · N20840 · Substantial damage
  > the pilot's failure to maintain rotor rpm. A related factor was the presence of an object in the path during the touchdown.
- [NTSB DEN03LA019](https://openairdocs.org/ntsb/DEN03LA019.md): Cameron Balloons O-70 · Montrose, CO · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2002 · N5303Z · No damage
  > the unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.
- [NTSB LAX03LA040](https://openairdocs.org/ntsb/LAX03LA040.md): Piper PA-34-220T · Elko, NV · Accident · No injuries · Limited investigation · Final report · Nov 27, 2002 · N224BD · Substantial damage
  > The pilot's inadequate in-flight planning/decision resulting in fuel exhaustion.
- [NTSB IAD03FA019](https://openairdocs.org/ntsb/IAD03FA019.md): Piper PA-32RT-300 · Bastian, VA · Accident · 2 fatal · Field investigation · Final report · Nov 27, 2002 · N31554 · Substantial damage
  > The pilot's failure to maintain an adequate altitude above terrain. Factors in the accident were the dark night conditions and the low cloud ceiling.
- [NTSB LAX03FA037](https://openairdocs.org/ntsb/LAX03FA037.md): Beech B36TC · Union City, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2002 · N3242Q · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…
- [NTSB LAX03LA038](https://openairdocs.org/ntsb/LAX03LA038.md): Piper PA-28-161 · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 2002 · N2937M · Substantial damage
  > The pilot's failure to follow the checklist and switch the fuel selector to the fullest tank for landing, which resulted in fuel starvation and loss of engine power.
- [NTSB ATL03LA019](https://openairdocs.org/ntsb/ATL03LA019.md): Aeronca 7AC · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Nov 24, 2002 · N4264E · Substantial damage
  > The pilot's failure to maintain airspeed during an approach to land that resulted in an inflight collision with the runway. A factor was the crosswind condition.
- [NTSB NYC03LA025](https://openairdocs.org/ntsb/NYC03LA025.md): Cessna 172G · Stow, MA · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N1152F · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.
- [NTSB ATL03FA017](https://openairdocs.org/ntsb/ATL03FA017.md): Cessna 182Q · Cornelia, GA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2002 · N58GH · Substantial damage
  > The pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.
- [NTSB NYC03FA021](https://openairdocs.org/ntsb/NYC03FA021.md): Mooney M10 · Fairfield, NJ · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2002 · N9502V · 2 aircraft · Substantial damage
  > The inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.
- [NTSB MIA03FA016](https://openairdocs.org/ntsb/MIA03FA016.md): Piper PA-28-140 · Climax, NC · Accident · 1 fatal · Field investigation · Final report · Nov 15, 2002 · N8162N · Substantial damage
  > The pilot's operation of the airplane at a low altitude during final approach that resulted in an in-flight collision with a tree, a witness reported pitch-up, and subsequent stall and in-flight collision with terrain.
- [NTSB SEA03LA009](https://openairdocs.org/ntsb/SEA03LA009.md): Piper PA-28-201T · La Grande, OR · Accident · No injuries · Limited investigation · Final report · Nov 14, 2002 · N2208Y · Substantial damage
  > Inadequate supervision and the premature raising of flaps before a positive climb was established.
- [NTSB NYC03FA020](https://openairdocs.org/ntsb/NYC03FA020.md): Cessna 210L · Rochester, NY · Accident · 1 fatal · Field investigation · Final report · Nov 14, 2002 · N2444S · Destroyed
  > A loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.
- [NTSB NYC03LA019](https://openairdocs.org/ntsb/NYC03LA019.md): Mooney M20R · Vineyard Haven, MA · Accident · 2 fatal · Limited investigation · Final report · Nov 13, 2002 · N2165Y · Destroyed
  > The pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.
- [NTSB LAX03FA031](https://openairdocs.org/ntsb/LAX03FA031.md): Cessna T210L · Pacoima, CA · Accident · Minor injuries · Field investigation · Final report · Nov 13, 2002 · N76TL · Substantial damage
  > a loss of engine power due the inadvertent unporting of the fuel pickup tube, which resulted in fuel starvation during the go-around. The pilot's preflight and in-flight decisions regarding fuel quantity and fuel system management are also causal.
- [NTSB IAD03LA015](https://openairdocs.org/ntsb/IAD03LA015.md): Bell 206L1 · Albany, KY · Accident · No injuries · Limited investigation · Final report · Nov 8, 2002 · N108AE · Substantial damage
  > The pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.
- [NTSB FTW03FA037](https://openairdocs.org/ntsb/FTW03FA037.md): Cessna 152 · Justin, TX · Accident · 1 fatal · Field investigation · Final report · Nov 8, 2002 · N4835B · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in a stall.
- [NTSB FTW03FA036](https://openairdocs.org/ntsb/FTW03FA036.md): Israel Aircraft Industries 1124A · Taos, NM · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2002 · N61RS · Destroyed
  > The pilot's inadvertent flight into mountain wave weather conditions while IMC, resulting in a loss of aircraft control.
- [NTSB CHI03LA019](https://openairdocs.org/ntsb/CHI03LA019.md): Cessna 150M · New Town, ND · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2002 · N2995V · Substantial damage
  > The pilot's failure to maintain terrain clearance and his inadequate in-flight planning/decision. Contributing factors are the pilot becoming lost/disoriented and night conditions.
- [NTSB LAX03LA024](https://openairdocs.org/ntsb/LAX03LA024.md): Beech 35 · Santa Ana, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 2002 · N3373C · Substantial damage
  > The pilot's encounter with wake turbulence resulting in a loss of control. A related factor was insufficient separation by air traffic control.
- [NTSB SEA03LA007](https://openairdocs.org/ntsb/SEA03LA007.md): Riddell IV-P · Bozeman, MT · Accident · 1 fatal · Limited investigation · Final report · Nov 5, 2002 · N41RJ · Destroyed
  > The loss of power for undetermined reason(s) and the pilot's failure to maintain the aircraft's flying speed above the power off stall speed in the landing configuration.
- [NTSB LAX03LA022](https://openairdocs.org/ntsb/LAX03LA022.md): Lewis Barnett J4B · Vacaville, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 2002 · N23152 · Substantial damage
  > An in-flight loss of control for undetermined reasons.
- [NTSB CHI03FA018](https://openairdocs.org/ntsb/CHI03FA018.md): Piper PA-24 · Fond du Lac, WI · Accident · 2 fatal · Field investigation · Final report · Nov 4, 2002 · N6606P · Destroyed
  > The pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.
- [NTSB FTW03LA022](https://openairdocs.org/ntsb/FTW03LA022.md): Piper PA-22 · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Oct 29, 2002 · N1456A · 2 aircraft · Substantial damage
  > the failure of both pilots to maintain visual separation with each other. Factors were the Cessna pilot's inability to listen to or make radio transmissions and the Piper pilot's nonstandard traffic pattern.
- [NTSB ANC03LA013](https://openairdocs.org/ntsb/ANC03LA013.md): Cessna 180 · Larson Bay, AK · Accident · No injuries · Limited investigation · Final report · Oct 29, 2002 · N5355D · Substantial damage
  > The pilot's failure to maintain adequate clearance while landing, which resulted in an in-flight collision with a tree.
- [NTSB CHI03LA012](https://openairdocs.org/ntsb/CHI03LA012.md): Mork Kitfox III · Evansville, WI · Accident · No injuries · Limited investigation · Final report · Oct 27, 2002 · N192MB · Substantial damage
  > The loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.
- [NTSB DCA03MA008](https://openairdocs.org/ntsb/DCA03MA008.md): Beech King Air 100 · Eveleth, MN · Accident · 8 fatal · Class 1 · Major · Final report · Oct 25, 2002 · N41BE · Destroyed
  > The flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.
- [NTSB ATL03FA010](https://openairdocs.org/ntsb/ATL03FA010.md): Cessna R182 · Greensboro, NC · Accident · 3 fatal · Field investigation · Final report · Oct 25, 2002 · N4629S · Destroyed
  > 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 MIA03LA006](https://openairdocs.org/ntsb/MIA03LA006.md): Piper PA-28-140 · Las Palmas, PR · Accident · No injuries · Limited investigation · Final report · Oct 23, 2002 · N2838T · Substantial damage
  > The pilot's failure to switch fuel tanks resulting in a partial loss of engine power due to fuel starvation during a go-around. Additionally, the pilot's failure to monitor airspeed and proper touchdown point during the emergency landing resulted in another…
- [NTSB IAD03IA017](https://openairdocs.org/ntsb/IAD03IA017.md): Craig N. Moen RV-8 · Leesburg, VA · Incident · No injuries · Incident investigation · Final report · Oct 22, 2002 · N184CM · No damage
  > A low-stress, high-cycle fatigue fracture of the right ignition timing rotor.
- [NTSB LAX03LA014](https://openairdocs.org/ntsb/LAX03LA014.md): Cessna 210C · Riverside, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2002 · N9788X · Substantial damage
  > the pilot's failure to position the fuel selector to the tank containing fuel resulting in a loss of engine power due to fuel exhaustion.
- [NTSB DEN03LA008](https://openairdocs.org/ntsb/DEN03LA008.md): Diamond Aircraft Industries DA20-C1 · Grand Junction, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 2002 · N315CL · Substantial damage
  > The pilot's inadequate preflight and in-flight planning resulting in fuel mismanagement and fuel exhaustion.
- [NTSB FTW03LA015](https://openairdocs.org/ntsb/FTW03LA015.md): Bell 206L-1 · Edinburg, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2002 · N303CH · Substantial damage
  > The loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.
- [NTSB IAD03FA005](https://openairdocs.org/ntsb/IAD03FA005.md): Cessna 172N · Mount Sterling, KY · Accident · 2 fatal · Field investigation · Final report · Oct 15, 2002 · N6413J · Destroyed
  > The failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.
- [NTSB CHI03LA008](https://openairdocs.org/ntsb/CHI03LA008.md): Cessna 175B · Lake Elmo, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2002 · N8161T · Destroyed
  > The pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…
- [NTSB FTW03LA009](https://openairdocs.org/ntsb/FTW03LA009.md): Cessna 152 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 2002 · N520SU · Substantial damage
  > The pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.
- [NTSB CHI03LA007](https://openairdocs.org/ntsb/CHI03LA007.md): Madewell EAA-Biplane-P · Forest Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 9, 2002 · N21WL · Substantial damage
  > The loss of engine power for undetermined reasons. A related factor was the swampy terrain.
- [NTSB MIA03LA001](https://openairdocs.org/ntsb/MIA03LA001.md): Bowers Velocity SR6E · Valkaria, FL · Accident · 1 fatal · Limited investigation · Final report · Oct 5, 2002 · N954PB · Destroyed
  > the failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.
- [NTSB CHI03LA005](https://openairdocs.org/ntsb/CHI03LA005.md): Cessna 172L · Fish Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 5, 2002 · N713SX · Substantial damage
  > The altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2002&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") = 2002
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?year=2002

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