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

## Cases, newest first

- [NTSB SEA00LA156](https://openairdocs.org/ntsb/SEA00LA156.md): Cessna 152 · Hillsboro, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2000 · N6434H · Substantial damage
  > An inadequately planned approach. The encounter of wake turbulence and not being able to maintain aircraft control were factors.
- [NTSB LAX00LA291](https://openairdocs.org/ntsb/LAX00LA291.md): Piper PA-28R-200 · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 2000 · N200EG · Substantial damage
  > The pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain proper glide path. A factor in the accident was the upsloping runway and nature of the terrain around the runway, which presented an optical illusion and lead…
- [NTSB IAD00LA072](https://openairdocs.org/ntsb/IAD00LA072.md): Aero Commander 114-B · Somerset, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2000 · N6101T · Substantial damage
  > Pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB NYC00LA221](https://openairdocs.org/ntsb/NYC00LA221.md): Piper PA28-235 · Chester, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2000 · N8809W · Substantial damage
  > The CFI's delayed remedial action.
- [NTSB NYC00LA219](https://openairdocs.org/ntsb/NYC00LA219.md): Cessna 140 · Post Mills, VT · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2000 · N73044 · Substantial damage
  > was the pilot's improper fuel management which resulted in power loss due to fuel starvation.
- [NTSB CHI00LA245](https://openairdocs.org/ntsb/CHI00LA245.md): Cessna 152 · Arthur, ND · Accident · No injuries · Limited investigation · Final report · Aug 5, 2000 · N7385W · Substantial damage
  > the water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.
- [NTSB CHI00LA241](https://openairdocs.org/ntsb/CHI00LA241.md): Cessna 150 · Eastport, MI · Accident · No injuries · Limited investigation · Final report · Aug 4, 2000 · N6712F · Substantial damage
  > the maneuver, performed by the pilot, to avoid obstructions on highway US.31. Factors were the carburetor icing weather condition, no suitable terrain conditions, the ground terrain condition, and the impacted fence.
- [NTSB ATL00LA074](https://openairdocs.org/ntsb/ATL00LA074.md): Beech A36 · Clarksville, TN · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2000 · N86BC · Substantial damage
  > The pilot's failure to follow published instrument approach procedures, and collided with a tree while executing a missed approach. Factors were low clouds, fog and a tree.
- [NTSB MIA00FA229](https://openairdocs.org/ntsb/MIA00FA229.md): de Havilland DHC-6-200 · Raleigh, NC · Accident · 1 fatal · Field investigation · Final report · Jul 31, 2000 · N201RH · Destroyed
  > the pilot's continued VFR flight into IMC conditions, by failing to maintain altitude, and descending from VFR conditions into IMC, which resulted in him subsequently impacting with trees. Factors in this accident were: reduced visibility due to dark night…
- [NTSB IAD00FA067](https://openairdocs.org/ntsb/IAD00FA067.md): Piper PA-24-250 · Bluffton, OH · Accident · 1 fatal · Field investigation · Final report · Jul 30, 2000 · N5271P · Substantial damage
  > Pilot's improper fuel calculations, which resulted in fuel exhaustion. Also causal, was his abrupt maneuver during the forced landing, which resulted in an inadvertent stall.
- [NTSB FTW00LA220](https://openairdocs.org/ntsb/FTW00LA220.md): Aero Tek Zuni · Uvalde, TX · Accident · No injuries · Limited investigation · Final report · Jul 30, 2000 · N6ZF · Substantial damage
  > The pilot's inadvertent flight into adverse weather conditions which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC00LA213](https://openairdocs.org/ntsb/NYC00LA213.md): Schwarz Zodiac CH 601 · Wooster, OH · Accident · 2 fatal · Limited investigation · Final report · Jul 29, 2000 · N601GS · Destroyed
  > The pilot's loss of control of the airplane while turning from base onto final, which resulted in an inadvertent stall/spin. A factor was the pilot's improper loading of the airplane, outside the weight and balance limitations.
- [NTSB ATL00LA071](https://openairdocs.org/ntsb/ATL00LA071.md): Ryskamp Sonex · Greenville, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 2000 · N202BA · Substantial damage
  > The pilot's misjudgment of airspeed and altitude resulting in an undershoot.
- [NTSB LAX00LA281](https://openairdocs.org/ntsb/LAX00LA281.md): Cessna 180 · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jul 28, 2000 · N3386D · Substantial damage
  > The pilot's improper recovery from a bounced landing and subsequent failure to maintain directional control of the aircraft. Wind shear on landing approach was a factor in the accident.
- [NTSB FTW00LA221](https://openairdocs.org/ntsb/FTW00LA221.md): Luscombe 8A · Kingfisher, OK · Accident · No injuries · Limited investigation · Final report · Jul 27, 2000 · N71620 · Destroyed
  > The pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.
- [NTSB CHI00LA226](https://openairdocs.org/ntsb/CHI00LA226.md): Halsmer Crazy 8 · Lafayette, IN · Accident · 1 fatal · Limited investigation · Final report · Jul 27, 2000 · N9034L · Destroyed
  > Aircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.
- [NTSB FTW00LA216](https://openairdocs.org/ntsb/FTW00LA216.md): Schweizer 269C · Sherman, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 2000 · N298SH · Substantial damage
  > the total failure of the clutch cable during landing, which resulted from fatigue cracking of the cable's individual wires.
- [NTSB NYC00LA205](https://openairdocs.org/ntsb/NYC00LA205.md): Lake LA-4-200 · Logan, WV · Accident · No injuries · Limited investigation · Final report · Jul 22, 2000 · N12SF · Substantial damage
  > Fuel exhaustion of the engine due to improper fuel consumption calculations performed by the pilot.
- [NTSB SEA00LA137](https://openairdocs.org/ntsb/SEA00LA137.md): Beaver Ferguson F-II · Benton City, WA · Accident · No injuries · Limited investigation · Final report · Jul 21, 2000 · N8228R · Substantial damage
  > The pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…
- [NTSB DEN00LA131](https://openairdocs.org/ntsb/DEN00LA131.md): Rotorway Executive 162F · Tooele, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2000 · N6399L · Substantial damage
  > The pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.
- [NTSB LAX00LA267](https://openairdocs.org/ntsb/LAX00LA267.md): Piper PA-22-160 · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2000 · N8768D · Substantial damage
  > The pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.
- [NTSB LAX00LA265](https://openairdocs.org/ntsb/LAX00LA265.md): Cessna TR182 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 2000 · N738XP · Substantial damage
  > The pilot's failure to refuel the airplane and his improper fuel consumption calculations.
- [NTSB FTW00LA211](https://openairdocs.org/ntsb/FTW00LA211.md): Beech D35 · Decatur, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2000 · N3424B · Substantial damage
  > The inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.
- [NTSB SEA00LA131](https://openairdocs.org/ntsb/SEA00LA131.md): Wsk Pzl Mielec M-18 Dromader · Burley, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 2000 · N2054S · Destroyed
  > Improper airstrip operations by ground personnel, and the pilot's failure to visually detect a vehicle on the airstrip in time to avoid a collision. Factors included a vehicle on the airstrip, tailwind conditions, and high density altitude conditions.
- [NTSB NYC00LA196](https://openairdocs.org/ntsb/NYC00LA196.md): Cessna 337C · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Jul 11, 2000 · N2574S · Substantial damage
  > The pilot's failure to follow the published go-around procedure. Factors were the pilot's improper evaluation of the wind conditions, and a tailwind.
- [NTSB ANC00IA088](https://openairdocs.org/ntsb/ANC00IA088.md): McDonnell Douglas MD-82 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Jul 11, 2000 · N935AS · No damage
  > An inoperative traffic alert and collision avoidance system (TCAS).
- [NTSB SEA00LA128](https://openairdocs.org/ntsb/SEA00LA128.md): Keith Kinden Rebel · Libby, MT · Accident · No injuries · Limited investigation · Final report · Jul 10, 2000 · N6317Y · Substantial damage
  > An improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.
- [NTSB LAX00LA259](https://openairdocs.org/ntsb/LAX00LA259.md): Piper PA-28-180 · Santa Maria, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2000 · N4209T · Substantial damage
  > The pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.
- [NTSB DEN00LA124](https://openairdocs.org/ntsb/DEN00LA124.md): Bell 206L-3 · Logan, UT · Accident · No injuries · Limited investigation · Final report · Jul 7, 2000 · N38903 · Substantial damage
  > in-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.
- [NTSB CHI00LA182](https://openairdocs.org/ntsb/CHI00LA182.md): Cessna 172R · Athens, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 2000 · N996WW · Substantial damage
  > the failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…
- [NTSB ANC00IA083](https://openairdocs.org/ntsb/ANC00IA083.md): Cessna 207A · Deadhorse, AK · Incident · No injuries · Incident investigation · Final report · Jul 5, 2000 · N73100 · Minor damage
  > An in-flight fracture of the engine crankshaft propeller flange. A factor associated with the accident was the manufacturer's inadequate quality control standards.
- [NTSB MIA00LA198](https://openairdocs.org/ntsb/MIA00LA198.md): Piper PA-28-180 · Ocracoke, NC · Accident · No injuries · Limited investigation · Final report · Jul 3, 2000 · N5381L · Substantial damage
  > The pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.
- [NTSB NYC00LA184](https://openairdocs.org/ntsb/NYC00LA184.md): Hartzell Rans S-12 · Strattanville, PA · Accident · 2 fatal · Limited investigation · Final report · Jul 2, 2000 · UNREG · Destroyed
  > The pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.
- [NTSB CHI00LA193](https://openairdocs.org/ntsb/CHI00LA193.md): Schleicher K8B · Manchester, MI · Accident · No injuries · Limited investigation · Final report · Jul 1, 2000 · N885D · Substantial damage
  > the downdraft experienced during final approach and altitude/clearance from the fence post not being maintained by the pilot. A factor to the accident was the fence post.
- [NTSB FTW00LA190](https://openairdocs.org/ntsb/FTW00LA190.md): Mooney M20C · Whitney, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2000 · N6932N · Substantial damage
  > The partial loss of engine power, which resulted from the worn carburetor.
- [NTSB CHI00LA172](https://openairdocs.org/ntsb/CHI00LA172.md): Cessna 172N · Canton, MI · Accident · No injuries · Limited investigation · Final report · Jun 26, 2000 · N3416E · Substantial damage
  > the CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.
- [NTSB DEN00LA116](https://openairdocs.org/ntsb/DEN00LA116.md): Cessna 310C · Erie, CO · Accident · No injuries · Limited investigation · Final report · Jun 24, 2000 · N1779H · Substantial damage
  > A sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.
- [NTSB CHI00LA173](https://openairdocs.org/ntsb/CHI00LA173.md): Mcclish Funk B85C · Gardner, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 2000 · N24120 · Substantial damage
  > an improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.
- [NTSB CHI00FA170](https://openairdocs.org/ntsb/CHI00FA170.md): Aeronca 7AC · Lakeville, MN · Accident · 1 fatal · Field investigation · Final report · Jun 24, 2000 · N81681 · Substantial damage
  > the pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.
- [NTSB LAX00LA240](https://openairdocs.org/ntsb/LAX00LA240.md): Schweizer SGS 1-26C · Tehachapi, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 23, 2000 · N2792Z · Substantial damage
  > The pilot's failure to maintain aircraft speed and control while maneuvering to land.
- [NTSB NYC00LA167](https://openairdocs.org/ntsb/NYC00LA167.md): Piper PA-38 · Cheswold, DE · Accident · No injuries · Limited investigation · Final report · Jun 18, 2000 · N407DS · Substantial damage
  > The instructor's delayed remedial action. Factors included the instructor's failure to take positive control of the airplane, and the student's failure to maintain adequate airspeed during the approach.
- [NTSB LAX00LA226](https://openairdocs.org/ntsb/LAX00LA226.md): Hughes 269C · Santa Clarita, CA · Accident · No injuries · Limited investigation · Final report · Jun 14, 2000 · N9692F · Substantial damage
  > Settling with power precipitated by a wind direction change during the approach to land sequence and the check pilot's delayed remedial action to correct the event. Factors in the accident were crew resource management coordination concerning flight control…
- [NTSB DEN00LA108](https://openairdocs.org/ntsb/DEN00LA108.md): Piper PA-44-180T · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jun 12, 2000 · N838PC · 2 aircraft · Minor damage
  > Failure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…
- [NTSB NYC00LA160](https://openairdocs.org/ntsb/NYC00LA160.md): Bryant/Rhodus LONG-EZ · West Chester, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 2000 · N5534V · Substantial damage
  > Was the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.
- [NTSB ATL00LA064](https://openairdocs.org/ntsb/ATL00LA064.md): Aeronca 7BCM · Palmetto, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 2000 · N83972 · Substantial damage
  > The pilot's failure to maintain airspeed during final approach to landing, resulting in an inadvertent stall.
- [NTSB ATL00LA063](https://openairdocs.org/ntsb/ATL00LA063.md): Hughes 369A · Hampton, GA · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 2000 · N330CM · Substantial damage
  > A total loss of engine power due to foreign object damage to the turbine wheel assembly.
- [NTSB NYC00LA157](https://openairdocs.org/ntsb/NYC00LA157.md): Siai-Marchetti SF260TP · Norfolk, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2000 · N43GP · Substantial damage
  > Fuel starvation of the engine, caused by the failure of the fuel transfer pump.
- [NTSB NYC00LA155](https://openairdocs.org/ntsb/NYC00LA155.md): Cessna 172R · West Milford, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2000 · N7274D · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB IAD00LA049](https://openairdocs.org/ntsb/IAD00LA049.md): Beech BE-55 · Erie, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2000 · N777K · Destroyed
  > the pilot's improper fuel management which resulted in fuel starvation and a loss of power to both engines. A factor was the pilot's inadequate pre-flight planning and takeoff with inadequate fuel for the flight.
- [NTSB FTW00LA175](https://openairdocs.org/ntsb/FTW00LA175.md): Cessna 177 · Nacogdoches, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2000 · N29383 · Substantial damage
  > the loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.

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

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

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