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

## Cases, newest first

- [NTSB FTW00LA170](https://openairdocs.org/ntsb/FTW00LA170.md): Aero Commander 700 · Breckenridge, TX · Accident · No injuries · Limited investigation · Final report · Jun 5, 2000 · N700AF · Substantial damage
  > Fuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL00LA058](https://openairdocs.org/ntsb/ATL00LA058.md): Bell 407 · Lake Placid, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 2000 · N234BH · Substantial damage
  > The pilot's failure to establish/maintain a safe rate of descent during approach to landing. Contributing factors were the pilot's incorrect altimeter (Kollsman) setting, smoke, and dark night conditions.
- [NTSB LAX00LA217](https://openairdocs.org/ntsb/LAX00LA217.md): Schweizer SGS-1-26 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jun 4, 2000 · N3814A · Substantial damage
  > Diminished control during the landing phase of operation due to a partial blockage of the elevator controls by a microphone that became lodged in the control stick well.
- [NTSB DEN00LA101](https://openairdocs.org/ntsb/DEN00LA101.md): Schumacher Swearingen SX-300 · Richfield, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2000 · N2H · Substantial damage
  > Fuel starvation due to the unavailability of fuel to the engine for undetermined reasons and the pilot's misjudgment of distance/altitude on final approach. Contributing factors were the pilot's premature gear extension and the berm.
- [NTSB FTW00LA263](https://openairdocs.org/ntsb/FTW00LA263.md): Piper PA-32-260 · Clinton, OK · Accident · No injuries · Limited investigation · Final report · Jun 3, 2000 · N3869W · Substantial damage
  > The pilot's improper setting of the cockpit fuel selector, which resulted in a total loss of engine power and forced landing.
- [NTSB NYC00LA149](https://openairdocs.org/ntsb/NYC00LA149.md): Piper PA-28-161 · Miamisburg, OH · Accident · No injuries · Limited investigation · Final report · Jun 2, 2000 · N8234L · Substantial damage
  > The CFI's delayed remedial action.
- [NTSB IAD00LA051](https://openairdocs.org/ntsb/IAD00LA051.md): Slingsby 41-2 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Jun 2, 2000 · N41SL · Substantial damage
  > The pilot's failure to retract the speed brakes which resulted in not obtaining the proper touch down point. A factor to the accident was the pilot's lack of experience in the make and model glider.
- [NTSB LAX00FA209](https://openairdocs.org/ntsb/LAX00FA209.md): Cessna 152 · Palm Springs, CA · Accident · 2 fatal · Field investigation · Final report · May 31, 2000 · N5538M · Destroyed
  > The failure of the pilot/flight instructor to maintain sufficient airspeed to prevent the aircraft stalling and spinning. Factors in the accident were terrain induced windshear and sudden wind shift and the pilot/flight instructor's lack of total experience.
- [NTSB IAD00LA047](https://openairdocs.org/ntsb/IAD00LA047.md): Mooney M20K · Grt Barrington, MA · Accident · Serious injuries · Limited investigation · Final report · May 31, 2000 · N1154K · Substantial damage
  > The pilot's failure to perform a go around and his inadequate recovery from a bounced landing. Factors in the accident were the pilot's s failure to maintain the proper glide path and to reach the proper touchdown point.
- [NTSB MIA00LA175](https://openairdocs.org/ntsb/MIA00LA175.md): Cessna 172N · Lincolnton, NC · Accident · No injuries · Limited investigation · Final report · May 27, 2000 · N734ZD · Substantial damage
  > The inadequate supervision of the student pilot by the CFI for his failure to note that the student was performing a go-around from a low pass with 30-degree of flaps extended instead of the POH recommended 20-degrees. A factor in the accident was the failure…
- [NTSB IAD00LA045](https://openairdocs.org/ntsb/IAD00LA045.md): Beech A-36 · Bedford, MA · Accident · No injuries · Limited investigation · Final report · May 27, 2000 · N66SB · Substantial damage
  > the pilot's improper fuel management which resulted in fuel starvation.
- [NTSB CHI00FA145](https://openairdocs.org/ntsb/CHI00FA145.md): Bellanca 17-30A · Taylor, MO · Accident · 2 fatal · Field investigation · Final report · May 27, 2000 · N136EL · Destroyed
  > flight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…
- [NTSB MIA00LA183](https://openairdocs.org/ntsb/MIA00LA183.md): Hayes LONG-EZ · Collegedale, TN · Accident · No injuries · Limited investigation · Final report · May 26, 2000 · N9JZ · Substantial damage
  > The pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.
- [NTSB SEA00LA090](https://openairdocs.org/ntsb/SEA00LA090.md): Cessna T210M · Boise, ID · Accident · No injuries · Limited investigation · Final report · May 25, 2000 · N761VZ · Substantial damage
  > The deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.
- [NTSB MIA00LA171](https://openairdocs.org/ntsb/MIA00LA171.md): Piper PA-28-161 · Chapel Hill, NC · Accident · Minor injuries · Limited investigation · Final report · May 25, 2000 · N47561 · Destroyed
  > The failure of the CFI to delay his landing until the approaching line of thunderstorms passed, causing the flight to encounter severely gusting wind conditions resulting in the loss of altitude control and collision with the terrain.
- [NTSB CHI00LA142](https://openairdocs.org/ntsb/CHI00LA142.md): American AA-1 · Sandstone, MN · Accident · Minor injuries · Limited investigation · Final report · May 23, 2000 · N5712L · Substantial damage
  > the pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.
- [NTSB DCA00MA052](https://openairdocs.org/ntsb/DCA00MA052.md): British Aerospace J-3101 · Bear Creek Town, PA · Accident · 19 fatal · Class 1 · Major · Final report · May 21, 2000 · N16EJ · Destroyed
  > The flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…
- [NTSB MIA00FA163](https://openairdocs.org/ntsb/MIA00FA163.md): Piper PA-23-160 · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · May 19, 2000 · N3492P · Destroyed
  > The failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…
- [NTSB DEN00LA091](https://openairdocs.org/ntsb/DEN00LA091.md): Cessna 172XP · Larkspur, CO · Accident · No injuries · Limited investigation · Final report · May 19, 2000 · N758SZ · Substantial damage
  > A forced landing on soft unsuitable terrain. Factors were improper wiring of the electric fuel boost pump, which produce high pressure when either on position was selected causing the engine to flood during the practice engine out approach.
- [NTSB LAX00LA197](https://openairdocs.org/ntsb/LAX00LA197.md): Beech H35 · Show Low, AZ · Accident · Minor injuries · Limited investigation · Final report · May 16, 2000 · N5477D · Substantial damage
  > The pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.
- [NTSB MIA00LA155](https://openairdocs.org/ntsb/MIA00LA155.md): Beech 18 · Monroe, NC · Accident · No injuries · Limited investigation · Final report · May 14, 2000 · N6082 · Substantial damage
  > The pilot's failure to maintain directional control during an attempted go-around, resulting in a loss of directional control, and subsequent collapse of the left main landing gear after the airplane departed the runway.
- [NTSB NYC00LA132](https://openairdocs.org/ntsb/NYC00LA132.md): Piper PA-22 · Moneta, VA · Accident · Minor injuries · Limited investigation · Final report · May 13, 2000 · N6841B · Substantial damage
  > Loss of power for undetermined reasons.
- [NTSB LAX00LA196](https://openairdocs.org/ntsb/LAX00LA196.md): Piper PA-32R · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · May 13, 2000 · N4148R · Substantial damage
  > The student pilot's inadvertant movement of the fuel selector to the "off" positon when selecting the alternate tank, and the flight instructor's lack of verification that the fuel selector was in the proper position during the emergency procedure checklist.…
- [NTSB LAX00LA195](https://openairdocs.org/ntsb/LAX00LA195.md): Eurocopter AS350B2 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · May 11, 2000 · N851HW · Substantial damage
  > the instructor pilot's failure to maintain control of the helicopter.
- [NTSB LAX00FA191](https://openairdocs.org/ntsb/LAX00FA191.md): Rockwell NA-265-65 · Kaunakakai, HI · Accident · 6 fatal · Field investigation · Final report · May 11, 2000 · N241H · Destroyed
  > Inadequate crew coordination led to the captain's decision to discontinue the instrument approach procedure and initiate a maneuvering descent solely by visual references at night in an area of mountainous terrain. The crew failed to review the instrument…
- [NTSB ATL00LA056](https://openairdocs.org/ntsb/ATL00LA056.md): Cessna 210A · Fayetteville, NC · Accident · Serious injuries · Limited investigation · Final report · May 9, 2000 · N6607X · Substantial damage
  > The pilot's improper fuel management resulting in fuel starvation. A factor was improper planned approach.
- [NTSB ATL00LA055](https://openairdocs.org/ntsb/ATL00LA055.md): Jackson Velocity RG · Kennesaw, GA · Accident · Minor injuries · Limited investigation · Final report · May 9, 2000 · N34BD · Substantial damage
  > A separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.
- [NTSB LAX00LA184](https://openairdocs.org/ntsb/LAX00LA184.md): McCoy Glasair III · Burbank, CA · Accident · No injuries · Limited investigation · Final report · May 7, 2000 · N1ML · Substantial damage
  > The failure of the pilot to maintain a proper glidepath, which resulted in a collision with a power pole and damage to the landing gear.
- [NTSB FTW00LA141](https://openairdocs.org/ntsb/FTW00LA141.md): Cessna R182 · Monument Valley, UT · Accident · Minor injuries · Limited investigation · Final report · May 7, 2000 · N3622C · Substantial damage
  > The pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.
- [NTSB ATL00LA054](https://openairdocs.org/ntsb/ATL00LA054.md): Schweizer SGU2-22E · Farmington, NC · Accident · No injuries · Limited investigation · Final report · May 7, 2000 · N2728Z · Substantial damage
  > The pilot's misjudgment of traffic pattern altitude that resulted in an off-field landing and the subsequent collision with the ground. A factor was rough terrain.
- [NTSB FTW00LA143](https://openairdocs.org/ntsb/FTW00LA143.md): Lewis Spitfire/Raven · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · May 6, 2000 · N17ST · Substantial damage
  > The pilot's inadvertent stall of the aircraft.
- [NTSB SEA00LA079](https://openairdocs.org/ntsb/SEA00LA079.md): Morton Christavia Mark I · Salem, OR · Accident · No injuries · Limited investigation · Final report · May 1, 2000 · N1143L · Substantial damage
  > The pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…
- [NTSB NYC00IA124](https://openairdocs.org/ntsb/NYC00IA124.md): Canadair CL-600-2B19 · White Plains, NY · Incident · No injuries · Incident investigation · Final report · May 1, 2000 · N924CA · Minor damage
  > The pilots of the CRJ were conducting a visual approach at night. As the wing flaps were extended from 30 degrees, to 45 degrees, there was an uncommanded extension of the right wing flight spoiler. A roll to the right accompanied the extension, which was…
- [NTSB FTW00LA137](https://openairdocs.org/ntsb/FTW00LA137.md): Bell 206L3 · Salt Marsh · Accident · No injuries · Limited investigation · Final report · Apr 29, 2000 · N17237 · Substantial damage
  > The company mechanic's failure to replace the bolt's cotter key properly and the subsequent loss of the nut, which then resulted in the tail rotor control disconnection and the pilot's inability to maintain aircraft control.
- [NTSB LAX00FA176](https://openairdocs.org/ntsb/LAX00FA176.md): Cessna T210L · North Las Vegas, NV · Accident · 2 fatal · Field investigation · Final report · Apr 28, 2000 · N2193S · Destroyed
  > The pilot's failure to maintain control of the airplane during a go-around in a crosswind condition.
- [NTSB FTW00LA133](https://openairdocs.org/ntsb/FTW00LA133.md): Lake LA-4-200 · Claremore, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 2000 · N5023L · Substantial damage
  > The pilot's premature raising of the flaps.
- [NTSB CHI00FA123](https://openairdocs.org/ntsb/CHI00FA123.md): Cessna 177RG · Watertown, SD · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2000 · N1978Q · Destroyed
  > the pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.
- [NTSB ATL00LA045](https://openairdocs.org/ntsb/ATL00LA045.md): Cessna 150 · Waycross, GA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2000 · N60763 · Substantial damage
  > The student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.
- [NTSB FTW00LA129](https://openairdocs.org/ntsb/FTW00LA129.md): Ercoupe 415-D · Lindsay, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2000 · N99470 · Substantial damage
  > The student pilot's inadequate compensation for wind conditions. A factor was the downdraft wind condition.
- [NTSB IAD00LA037](https://openairdocs.org/ntsb/IAD00LA037.md): Greenleaf Exec 162F · Manassas, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 2000 · N162GG · Substantial damage
  > Was the pilot' use of an unsecured ballast weight in the cockpit that shifted in flight and blocked the collective control movement.
- [NTSB ANC00LA047](https://openairdocs.org/ntsb/ANC00LA047.md): Piper PA-12 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Apr 16, 2000 · N3697M · Substantial damage
  > The pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.
- [NTSB ATL00FA041](https://openairdocs.org/ntsb/ATL00FA041.md): Beech BE-58 · Palatka, FL · Accident · 1 fatal · Field investigation · Final report · Apr 15, 2000 · N1072D · Destroyed
  > The pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.
- [NTSB FTW00LA123](https://openairdocs.org/ntsb/FTW00LA123.md): Piper PA-32R-301 · Rocksprings, TX · Accident · No injuries · Limited investigation · Final report · Apr 12, 2000 · N789CA · Destroyed
  > The pilot's failure to maintain proper glidepath. A factor was the dark night light conditions.
- [NTSB SEA00LA067](https://openairdocs.org/ntsb/SEA00LA067.md): Cessna 172P · Seattle, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2000 · N38GF · Substantial damage
  > The pilot's failure to attain proper alignment with the landing runway, and her failure to maintain proper glide path for the landing runway, resulting in an encounter with vortex turbulence from a preceding heavy aircraft landing on a parallel runway and…
- [NTSB SEA00IA069](https://openairdocs.org/ntsb/SEA00IA069.md): Cessna 182P · Tacoma, WA · Incident · No injuries · Incident investigation · Final report · Apr 11, 2000 · N1298M · Minor damage
  > Flap attachment failure. Restricted movement of the aileron was a factor.
- [NTSB NYC00LA075](https://openairdocs.org/ntsb/NYC00LA075.md): Bellanca 7ECA · Kennedyville, MD · Accident · No injuries · Limited investigation · Final report · Apr 11, 2000 · N88466 · Substantial damage
  > The pilot inadvertently stalling the airplane while turning final.
- [NTSB ATL00LA040](https://openairdocs.org/ntsb/ATL00LA040.md): Cessna 150M · Leesburg, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 2000 · N45618 · Substantial damage
  > The pilot's failure to maintain clearance from objects during the final approach. A factor was downdraft on final approach.
- [NTSB LAX00LA173](https://openairdocs.org/ntsb/LAX00LA173.md): Rotorway Exec 162F · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Apr 6, 2000 · N21901 · Substantial damage
  > The inadequate maintenance inspection of the secondary shaft which resulted in its fatigue failure that emanated from a corroded circumferential score mark. A factor was the fence that the pilot flared to avoid, resulting in a hard landing.
- [NTSB MIA00FA129](https://openairdocs.org/ntsb/MIA00FA129.md): Learjet 35A · Marianna, FL · Accident · 3 fatal · Field investigation · Final report · Apr 5, 2000 · N86BE · Destroyed
  > the pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.
- [NTSB FTW00LA122](https://openairdocs.org/ntsb/FTW00LA122.md): Mooney M20A · Houston, TX · Accident · No injuries · Limited investigation · Final report · Apr 5, 2000 · N8159E · Substantial damage
  > The pilot's delayed go-around and his failure to maintain the aircraft's clearance with trees.

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

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

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