# NTSB investigations: 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 91 of 420 · 20,992 cases

## Cases, newest first

- [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.
- [NTSB IAD03FA001](https://openairdocs.org/ntsb/IAD03FA001.md): Piper Aerostar 602P · Bradford, PA · Accident · 1 fatal · Field investigation · Final report · Oct 4, 2002 · N700DJ · Destroyed
  > The pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.
- [NTSB NYC03LA003](https://openairdocs.org/ntsb/NYC03LA003.md): Piper PA-28-181 · Edgartown, MA · Accident · No injuries · Limited investigation · Final report · Oct 1, 2002 · N8071Z · Substantial damage
  > The pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.
- [NTSB CHI03LA034](https://openairdocs.org/ntsb/CHI03LA034.md): Waco UPF-7 · Owatonna, MN · Accident · No injuries · Limited investigation · Final report · Oct 1, 2002 · N32039 · Substantial damage
  > The remedial action not performed by the certified flight instructor (CFI) during the bounced landing and directional control not maintained during the go-around by CFI. Contributing factors were the CFIs preflight planning/preparation in placing the dual…
- [NTSB CHI02LA299](https://openairdocs.org/ntsb/CHI02LA299.md): Piper PA-28-140 · Moorhead, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2002 · N9714W · Substantial damage
  > The inadequate fuel management by the certified flight instructor.
- [NTSB IAD02LA097](https://openairdocs.org/ntsb/IAD02LA097.md): Aeronca 65-C · Front Royal, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2002 · N24277 · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the airplane's proximity to the ground when the spin commenced.
- [NTSB CHI02LA295](https://openairdocs.org/ntsb/CHI02LA295.md): Cessna 172R · Greenwood, IL · Accident · No injuries · Limited investigation · Final report · Sep 26, 2002 · N3510A · Substantial damage
  > The CFI's poor inflight planning/decision to allow the airplane to get to too low of an altitude to assure a safe recovery from the simulated forced landing. Factors associated with the accident were the student pilot's delay initiating the go around and the…
- [NTSB ATL02FA175](https://openairdocs.org/ntsb/ATL02FA175.md): Piper PA-28-140 · Milton, FL · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2002 · N8828N · Substantial damage
  > A sheared mixture cable which resulted in a loss of engine power.
- [NTSB MIA02LA171](https://openairdocs.org/ntsb/MIA02LA171.md): Johnson Hornet · Archdale, NC · Accident · No injuries · Limited investigation · Final report · Sep 21, 2002 · N1928J · Substantial damage
  > the pilot's failure to maintain directional control during final approach, which resulted in the airplane drifting off course and impacting with trees. Factors in this accident were the pilot's attention being diverted due to the right door not being secured.
- [NTSB MIA02FA170](https://openairdocs.org/ntsb/MIA02FA170.md): Beagle B-206 Series 2 · McAlpin, FL · Accident · 1 fatal · Field investigation · Final report · Sep 21, 2002 · N86GW · Destroyed
  > the pilot's failure to maintain an adequate airspeed to sustain controlled flight, which resulted in an inadvertent stall during a turn from base to final. A contributing factor was the pilot's use of judgment and performance impairing drugs.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=92

## 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 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?page=91

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