# 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 108 of 420 · 20,992 cases

## Cases, newest first

- [NTSB NYC99LA139](https://openairdocs.org/ntsb/NYC99LA139.md): Aero Commander 500S · Windsor Locks, CT · Accident · No injuries · Limited investigation · Final report · Jun 12, 1999 · N33PG · Substantial damage
  > Hydraulic system contamination which prevented normal landing gear extension. A factor was the misjudged landing flare by the flying pilot.
- [NTSB MIA99LA174](https://openairdocs.org/ntsb/MIA99LA174.md): Cessna T210N · Seneca, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1999 · N6407N · Substantial damage
  > The PIC's improper fuel management resulting in loss of engine power during approach to landing due to fuel starvation and the subsequent collision with trees and a residence during an emergency landing. Contributing to the accident was the PIC's failure to…
- [NTSB MIA99LA171](https://openairdocs.org/ntsb/MIA99LA171.md): Cessna 182P · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 1999 · N1578M · Substantial damage
  > The poor in-flight planning by the pilot during the approach for a precautionary landing following a power interruption during the downwind leg, resulting in a go-around. A Contributing factor to the accident was the total loss of engine power during the…
- [NTSB LAX99LA213](https://openairdocs.org/ntsb/LAX99LA213.md): Cessna 172 · Weaverville, CA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1999 · N5577E · Substantial damage
  > the pilot's failure to follow prescribed procedures and directives for the particular airport.
- [NTSB MIA99LA163](https://openairdocs.org/ntsb/MIA99LA163.md): Cessna 152 · Chapel Hill, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1999 · N68762 · Destroyed
  > The failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.
- [NTSB MIA99LA162](https://openairdocs.org/ntsb/MIA99LA162.md): Piper PA-38-112 · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Jun 5, 1999 · N78HR · Substantial damage
  > The loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.
- [NTSB LAX99LA211](https://openairdocs.org/ntsb/LAX99LA211.md): Cessna 150G · Rimrock, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 5, 1999 · N2675J · Substantial damage
  > The pilot's failure to attain the proper touchdown point and to maintain airspeed during the aborted landing, resulting in an inadvertent stall. A factor was the pilot's failure to adjust the flaps for the attempted aborted landing in accordance with the…
- [NTSB LAX99LA206](https://openairdocs.org/ntsb/LAX99LA206.md): Cessna 182Q · St. David, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1999 · N234TT · Substantial damage
  > The pilot's failure to maintain an adequate reference approach airspeed for the existing gusty wind conditions, and, his improper (uncoordinated) use of the pitch and power controls to arrest the resulting high sink rate.
- [NTSB DEN99LA095](https://openairdocs.org/ntsb/DEN99LA095.md): Piper PA-38-112 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 3, 1999 · N4273E · Substantial damage
  > Inadequate remedial action by the pilot in command (CFI) after the student failed to maintain control of the aircraft during the final stages of a visual approach to land. Factors were gusting crosswinds and the flight instructor's lack of total instructional…
- [NTSB LAX99LA203](https://openairdocs.org/ntsb/LAX99LA203.md): Cessna P210N · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · May 31, 1999 · N37MJ · Substantial damage
  > Fuel starvation resulting from the pilot's inattentive monitoring and management of the fuel system.
- [NTSB LAX99LA204](https://openairdocs.org/ntsb/LAX99LA204.md): Cessna 172P · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · May 30, 1999 · N66018 · 2 aircraft · Substantial damage
  > The failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.
- [NTSB FTW99FA153](https://openairdocs.org/ntsb/FTW99FA153.md): Mooney M20B · Mesquite, TX · Accident · 2 fatal · Field investigation · Final report · May 29, 1999 · N74706 · 2 aircraft · Destroyed
  > The failure by both pilots to maintain visual lookout. A factor was the inadequate radio communications maintained by both pilots while in the traffic pattern.
- [NTSB LAX99LA205](https://openairdocs.org/ntsb/LAX99LA205.md): Cessna 180 · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · May 28, 1999 · N9270C · Substantial damage
  > Fuel exhaustion due to an inadequate fuel supply, and the pilot's inadequate in-flight planning fuel consumption calculations.
- [NTSB SEA99LA077](https://openairdocs.org/ntsb/SEA99LA077.md): Cessna 172N · Covington, WA · Accident · Minor injuries · Limited investigation · Final report · May 27, 1999 · N5120D · Substantial damage
  > The student pilot's inadequate recovery from a bounced landing, and his subsequent improper execution of the go-around procedure, resulting in collision with trees off the departure end of the runway. Factors included the student pilot's lack of total…
- [NTSB DEN99LA087](https://openairdocs.org/ntsb/DEN99LA087.md): Cessna 170B · Ogden, UT · Accident · No injuries · Limited investigation · Final report · May 27, 1999 · N2716C · Destroyed
  > The pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).
- [NTSB CHI99FA163](https://openairdocs.org/ntsb/CHI99FA163.md): Cessna 421B · Jefferson City, MO · Accident · 4 fatal · Field investigation · Final report · May 27, 1999 · N34TM · Destroyed
  > the pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.
- [NTSB LAX99LA198](https://openairdocs.org/ntsb/LAX99LA198.md): Cessna 150L · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · May 26, 1999 · N1371Q · Substantial damage
  > the pilot's failure to maintain aircraft control and the resulting intentional off-airport landing. Inadequate recurrent training and recent flight experience were factors in this accident.
- [NTSB CHI99FA165](https://openairdocs.org/ntsb/CHI99FA165.md): Air Tractor AT-400 · Elkhart, KS · Accident · 1 fatal · Field investigation · Final report · May 25, 1999 · N400MJ · Destroyed
  > The pilot's inadequate in-flight planning/decision and his inadvertent flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was the poor weather…
- [NTSB ANC99LA064](https://openairdocs.org/ntsb/ANC99LA064.md): de Havilland DHC-6-300 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · May 25, 1999 · N72GC · Substantial damage
  > An in-flight collision with a bird.
- [NTSB SEA99LA070](https://openairdocs.org/ntsb/SEA99LA070.md): Piper PA-24-180 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · May 23, 1999 · N6017P · Substantial damage
  > A loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.
- [NTSB LAX99LA193](https://openairdocs.org/ntsb/LAX99LA193.md): Aerotek Pitts Special S-1S · Merced, CA · Accident · Serious injuries · Limited investigation · Final report · May 22, 1999 · N93J · Substantial damage
  > The pilot's improper/inadequate use of the rudders during the attempted recovery from a bounced landing and his subsequent failure to maintain directional control of the aircraft.
- [NTSB FTW99FA143](https://openairdocs.org/ntsb/FTW99FA143.md): Taylorcraft BC12-D · Rose Bud, AR · Accident · 1 fatal · Field investigation · Final report · May 22, 1999 · N95754 · Substantial damage
  > The pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall.
- [NTSB NYC99LA114](https://openairdocs.org/ntsb/NYC99LA114.md): Beech V35B · Columbus, OH · Accident · Serious injuries · Limited investigation · Final report · May 21, 1999 · N7355R · Substantial damage
  > the failure of the pilot to follow the procedures in the Pilot's Operating Handbook, and the use of tip tanks for level flight only, which resulted in fuel starvation. A factor was the pilot's lack of familiarity with the airplane.
- [NTSB DEN99LA082](https://openairdocs.org/ntsb/DEN99LA082.md): Rich RV3-A · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · May 21, 1999 · N4461V · Substantial damage
  > The pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.
- [NTSB ATL99LA095](https://openairdocs.org/ntsb/ATL99LA095.md): Aircraft Parts & Dev. A-9B · Hartsell, AL · Accident · No injuries · Limited investigation · Final report · May 21, 1999 · N9082A · Substantial damage
  > The pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.
- [NTSB LAX99LA187](https://openairdocs.org/ntsb/LAX99LA187.md): Cessna 150J · Alderpoint, CA · Accident · No injuries · Limited investigation · Final report · May 20, 1999 · N51096 · Substantial damage
  > The pilot's inadequate compensation for the existing turbulent, gusty wind conditions during the approach. Contributing factors were the pilot's delayed go-around maneuver, the gusty and turbulent winds, and the tree.
- [NTSB FTW99LA135](https://openairdocs.org/ntsb/FTW99LA135.md): Piper PA-28R-201T · Taylor, TX · Accident · No injuries · Limited investigation · Final report · May 20, 1999 · N6558C · Substantial damage
  > The pilot's failure to maintain a proper glide path, which resulted in a collision with a wire. A factor was the dark night condition.
- [NTSB MIA99LA156](https://openairdocs.org/ntsb/MIA99LA156.md): Champion Glastar · Mableton, GA · Accident · 2 fatal · Limited investigation · Final report · May 19, 1999 · N75419 · Destroyed
  > An in-flight loss of control for undetermined reasons, resulting in an in-flight collision with trees and the ground.
- [NTSB LAX99LA186](https://openairdocs.org/ntsb/LAX99LA186.md): Robinson R22A · San Luis Obispo, CA · Accident · Minor injuries · Limited investigation · Final report · May 19, 1999 · N8558N · Substantial damage
  > The student's inadvertent and uncoordinated application of forward cyclic during an autorotation flare, which resulted in a loss of main rotor rpm; and the flight instructor's inadequate supervision.
- [NTSB DEN99LA078](https://openairdocs.org/ntsb/DEN99LA078.md): Bell/Mason RV-6 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · May 14, 1999 · N107BB · Substantial damage
  > The loss of aircraft control for undetermined reasons. Factors were the sudden wind shift and wind gusts weather condition.
- [NTSB DEN99FA077](https://openairdocs.org/ntsb/DEN99FA077.md): Cessna 172Q · Greeley, CO · Accident · No injuries · Field investigation · Final report · May 13, 1999 · N96299 · 2 aircraft · Minor damage
  > Failure of both the pilot receiving instruction and the flight instructor to maintain a visual lookout. A factor was the failure of the other pilot to maintain a visual lookout.
- [NTSB MIA99LA155](https://openairdocs.org/ntsb/MIA99LA155.md): Aero Commander 500B · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · May 12, 1999 · N6138X · Destroyed
  > an in-flight collision with water for undetermined reasons, due to the wreckage never being recovered from the water.
- [NTSB SEA99LA056](https://openairdocs.org/ntsb/SEA99LA056.md): Piper PA-18-150 · Salem, OR · Accident · No injuries · Limited investigation · Final report · May 9, 1999 · N7483L · Substantial damage
  > The pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…
- [NTSB NYC99LA109](https://openairdocs.org/ntsb/NYC99LA109.md): Beech A35 · Phillipsburg, OH · Accident · Minor injuries · Limited investigation · Final report · May 9, 1999 · N722B · Substantial damage
  > Fuel starvation to the engine due to the pilot's failure to switch fuel tanks.
- [NTSB LAX99LA174](https://openairdocs.org/ntsb/LAX99LA174.md): Cessna T303 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · May 8, 1999 · N3303S · Substantial damage
  > The pilot-in-command's inaccurate fuel consumption calculations that resulted in fuel exhaustion and the subsequent ditching.
- [NTSB LAX99LA173](https://openairdocs.org/ntsb/LAX99LA173.md): Cessna 152 · Chandler, AZ · Accident · Minor injuries · Limited investigation · Final report · May 8, 1999 · N48845 · Substantial damage
  > The pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.
- [NTSB ATL99LA082](https://openairdocs.org/ntsb/ATL99LA082.md): Piper PA-24-250 · Southern Pines, NC · Accident · No injuries · Limited investigation · Final report · May 8, 1999 · N7001P · Substantial damage
  > A failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.
- [NTSB NYC99LA105](https://openairdocs.org/ntsb/NYC99LA105.md): Piper PA-22-150 · Oswego, NY · Accident · Serious injuries · Limited investigation · Final report · May 3, 1999 · N2716P · Substantial damage
  > The pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.
- [NTSB DEN99FA071](https://openairdocs.org/ntsb/DEN99FA071.md): Mooney M20E · Cedar City, UT · Accident · 3 fatal · Field investigation · Final report · May 3, 1999 · N5594Q · Destroyed
  > The pilot's inadequate fuel consumption calculations. Factors were the loss of engine power due to fuel exhaustion and the obscuring weather conditions.
- [NTSB FTW99LA129](https://openairdocs.org/ntsb/FTW99LA129.md): Piper J3C-65 · Claremore, OK · Accident · Serious injuries · Limited investigation · Final report · May 2, 1999 · N3732C · Destroyed
  > The pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.
- [NTSB ATL99LA080](https://openairdocs.org/ntsb/ATL99LA080.md): Cessna 182 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · May 2, 1999 · N6382B · Substantial damage
  > The pilot's misjudgment of altitude and distance to the runway.
- [NTSB CHI99LA141](https://openairdocs.org/ntsb/CHI99LA141.md): Barrett Bensen B-8 · Mt. Pleasant, MI · Accident · Minor injuries · Limited investigation · Final report · May 1, 1999 · N4659T · Substantial damage
  > the inadequate rotor rpm by the pilot.
- [NTSB FTW99LA130](https://openairdocs.org/ntsb/FTW99LA130.md): Cessna 210A · Bay City, TX · Accident · No injuries · Limited investigation · Final report · Apr 30, 1999 · N9404X · Substantial damage
  > The pilot's inadequate management of fuel and his failure to follow the pre-landing checklist resulting in the loss of engine power as a result of fuel starvation. Factors were the pilot's physiological condition and the lack of suitable terrain for the…
- [NTSB DEN99LA070](https://openairdocs.org/ntsb/DEN99LA070.md): Cessna T210L · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 1999 · N59235 · Destroyed
  > The pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…
- [NTSB ATL99FA078](https://openairdocs.org/ntsb/ATL99FA078.md): Cessna 172N · Winter Haven, FL · Accident · Serious injuries · Field investigation · Final report · Apr 29, 1999 · N739FX · 2 aircraft · Substantial damage
  > The pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.
- [NTSB NYC99FA098](https://openairdocs.org/ntsb/NYC99FA098.md): Cessna 150G · Watertown, NY · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1999 · N8426J · Substantial damage
  > The pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.
- [NTSB ATL99LA076](https://openairdocs.org/ntsb/ATL99LA076.md): Schempp-Hirth MINI-NIMBUS · Groveland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1999 · N100GG · Substantial damage
  > The pilot's inability to locate a thermal and the in-flight encounter with a down draft.
- [NTSB ANC99LA052](https://openairdocs.org/ntsb/ANC99LA052.md): Cessna 185 · Juneau, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1999 · N93311 · Substantial damage
  > The failure of the engine driven fuel pump for undetermined reasons. Factors associated with this accident were the low altitude at which the failure occurred resulting in task overload of the pilot, and landing the amphibious airplane in the swampy terrain…
- [NTSB DEN99LA065](https://openairdocs.org/ntsb/DEN99LA065.md): Piper PA-25-235 · Wendover, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 1999 · N906DS · Substantial damage
  > The pilot's improper preflight/in-flight planning and decision making, resulting in fuel supply exhaustion. A factor was the closed runway condition.
- [NTSB LAX99FA161](https://openairdocs.org/ntsb/LAX99FA161.md): Cessna 210 · Hayward, CA · Accident · 2 fatal · Field investigation · Final report · Apr 24, 1999 · N9512T · Destroyed
  > The pilot's inadequate preflight planning and his failure to verify fuel consumption during flight that resulted in fuel exhaustion and subsequent collision with obstacles and the ground.

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

## 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=108

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