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

## Cases, newest first

- [NTSB SEA05LA153](https://openairdocs.org/ntsb/SEA05LA153.md): Mooney M20J · Sunriver, OR · Accident · No injuries · Limited investigation · Final report · Jul 28, 2005 · N110MP · Substantial damage
  > The loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…
- [NTSB NYC05LA125](https://openairdocs.org/ntsb/NYC05LA125.md): Cessna 172P · Caldwell, NJ · Accident · No injuries · Limited investigation · Final report · Jul 28, 2005 · N98730 · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.
- [NTSB CHI05LA200](https://openairdocs.org/ntsb/CHI05LA200.md): Vans RV-9A · Neenah, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2005 · N219CC · Substantial damage
  > The pilot failed to maintain sufficient airspeed on final approach to avoid a stall, resulting in an inadvertent stall and uncontrolled descent to the terrain.
- [NTSB CHI05FA199](https://openairdocs.org/ntsb/CHI05FA199.md): Glasair GS-2 · Wautoma, WI · Accident · 1 fatal · Field investigation · Final report · Jul 27, 2005 · N105TW · Destroyed
  > the abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.
- [NTSB IAD05FA110](https://openairdocs.org/ntsb/IAD05FA110.md): Piper PA-28-181 · Georgetown, DE · Accident · 2 fatal · Field investigation · Final report · Jul 26, 2005 · N59RK · Substantial damage
  > The pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…
- [NTSB MIA05CA141](https://openairdocs.org/ntsb/MIA05CA141.md): Piper PA-28-161 · Kissimmee, FL · Accident · No injuries · Data collection · Final report · Jul 22, 2005 · N280FT · Substantial damage
  > Failure of the student pilot to maintain control of the airplane during a go around resulting in the airplane descending and colliding with the ground.
- [NTSB SEA05CA149](https://openairdocs.org/ntsb/SEA05CA149.md): Hughes 269A · Laurel, MT · Accident · Minor injuries · Data collection · Final report · Jul 21, 2005 · N801CP · Substantial damage
  > the pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.
- [NTSB LAX05LA239](https://openairdocs.org/ntsb/LAX05LA239.md): As+ AC4 · Sparks, NV · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 2005 · N9276Y · Destroyed
  > the pilot's failure to maintain an adequate airspeed while performing S-turns on final approach, which resulted in a stall and uncontrolled descent into terrain. A contributing factor in the accident was the pilot's impairment due to ingestion of an…
- [NTSB CHI05CA193](https://openairdocs.org/ntsb/CHI05CA193.md): Piper PA-22 · Plainwell, MI · Accident · Minor injuries · Data collection · Final report · Jul 19, 2005 · N2654A · Substantial damage
  > The loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.
- [NTSB MIA05LA135](https://openairdocs.org/ntsb/MIA05LA135.md): Robinson R-22B · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Jul 16, 2005 · N2614D · Substantial damage
  > A loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.
- [NTSB IAD05CA098](https://openairdocs.org/ntsb/IAD05CA098.md): Grumman G164A · Williamstown, NJ · Accident · No injuries · Data collection · Final report · Jul 15, 2005 · N48408 · Substantial damage
  > The pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.
- [NTSB DFW05CA181](https://openairdocs.org/ntsb/DFW05CA181.md): Messerschmitt BK-117 B-2 · Houston, TX · Accident · No injuries · Data collection · Final report · Jul 14, 2005 · N440HH · Substantial damage
  > The separation of the left passenger door due to worn attaching hardware.
- [NTSB DEN05LA106](https://openairdocs.org/ntsb/DEN05LA106.md): Clarke YAK 3UR 2000 · Heber City, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2005 · N134US · Substantial damage
  > loss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…
- [NTSB DEN05LA104](https://openairdocs.org/ntsb/DEN05LA104.md): Cessna 150L · Rocky Ford, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2005 · N6839G · Substantial damage
  > the pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.
- [NTSB ANC05FA098](https://openairdocs.org/ntsb/ANC05FA098.md): Maule M-7-235 · Seward, AK · Accident · 1 fatal · Field investigation · Final report · Jul 7, 2005 · N5661J · Substantial damage
  > The pilot's failure to maintain minimum airspeed during final approach, which resulted in an inadvertent stall, and impact with the surface of the lake.
- [NTSB ANC05CA096](https://openairdocs.org/ntsb/ANC05CA096.md): Piper PA-18-160 · Hope, AK · Accident · No injuries · Data collection · Final report · Jul 6, 2005 · N18VF · Substantial damage
  > The pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with trees and tundra-covered terrain. A factor in the accident was trees.
- [NTSB CHI05LA163](https://openairdocs.org/ntsb/CHI05LA163.md): Becker RAF 2000 · Gladwin, MI · Accident · 1 fatal · Limited investigation · Final report · Jul 4, 2005 · N481KB · Substantial damage
  > The pilot's failure to maintain control of the gyrocopter while in the traffic pattern. A factor associated with the accident was the pilot's lack of gyrocopter experience.
- [NTSB CHI05CA170](https://openairdocs.org/ntsb/CHI05CA170.md): Mooney M20K · Kennett, MO · Accident · No injuries · Data collection · Final report · Jul 4, 2005 · N5791U · Substantial damage
  > The fuel starvation, inadequate preflight planning and preparation, and inadequate in-flight planning/decision by the pilot.
- [NTSB ATL05LA121](https://openairdocs.org/ntsb/ATL05LA121.md): Denmark Mini-Max · Covington, GA · Accident · 1 fatal · Limited investigation · Final report · Jul 3, 2005 · N11949 · Destroyed
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.
- [NTSB LAX05LA223](https://openairdocs.org/ntsb/LAX05LA223.md): Piper PA-28-180 · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Jul 2, 2005 · N9254J · Substantial damage
  > the pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…
- [NTSB CHI05LA171](https://openairdocs.org/ntsb/CHI05LA171.md): Yonchak Skybolt · El Dorado, KS · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 2005 · N112MK · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering in the traffic pattern which resulted in an inadvertent stall. A factor was the low altitude.
- [NTSB DEN05FA103](https://openairdocs.org/ntsb/DEN05FA103.md): Agusta A119 · Mancos, CO · Accident · 3 fatal · Field investigation · Final report · Jun 30, 2005 · N403CF · Substantial damage
  > a loss of engine power for undetermined reasons and the pilot's inability to get into autorotation prior to impacting the ground. A factor contributing to the accident was the helicopter's low altitude when power was lost.
- [NTSB LAX05CA219](https://openairdocs.org/ntsb/LAX05CA219.md): Cessna 180A · Big Bend, CA · Accident · Minor injuries · Data collection · Final report · Jun 29, 2005 · N2929C · Substantial damage
  > the pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.
- [NTSB DEN05FA101](https://openairdocs.org/ntsb/DEN05FA101.md): Taylorcraft BC12-D · Marble, CO · Accident · 1 fatal · Field investigation · Final report · Jun 29, 2005 · N44269 · Substantial damage
  > the pilot's improper decision to perform a go-around, and failure to maintain clearance from terrain and obstacles during a go-around. Factors contributing to the accident include the pilot's lack of recency of experience and lack of mountain flying…
- [NTSB SEA05LA134](https://openairdocs.org/ntsb/SEA05LA134.md): Jones Long EZ · Marsing, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 2005 · N58LD · Substantial damage
  > The pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.
- [NTSB NYC05FA109](https://openairdocs.org/ntsb/NYC05FA109.md): Cessna 182Q · Groton, CT · Accident · 4 fatal · Field investigation · Final report · Jun 27, 2005 · N5155N · Destroyed
  > The pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.
- [NTSB DEN05FA100](https://openairdocs.org/ntsb/DEN05FA100.md): CGS Hawk Two Place Arrow · Jackson, WY · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2005 · UNREG · Destroyed
  > The loss of airplane pitch control resulting from the pilot/owner's improper reinstallation of the rear locking collar on the elevator control torque tube, which allowed the torque tube to move rearward during flight and loosen the elevator control cable…
- [NTSB SEA05LA129](https://openairdocs.org/ntsb/SEA05LA129.md): Mooney M20J · Hailey, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 2005 · N201U · Substantial damage
  > The pilot's failure to maintain aircraft control while on final approach for undetermined reasons.
- [NTSB SEA05FA125](https://openairdocs.org/ntsb/SEA05FA125.md): Cessna 172M · Yamhill, OR · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2005 · N4368R · Substantial damage
  > The flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…
- [NTSB DFW05FA170](https://openairdocs.org/ntsb/DFW05FA170.md): Beech E90 · New Roads, LA · Accident · 5 fatal · Field investigation · Final report · Jun 24, 2005 · N62BL · Destroyed
  > The pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.
- [NTSB CHI05CA156](https://openairdocs.org/ntsb/CHI05CA156.md): Bell 206L-3 · Algonac, MI · Accident · Minor injuries · Data collection · Final report · Jun 24, 2005 · N311JX · Substantial damage
  > The pilot not maintaining helicopter control, the loss of tail rotor effectiveness he encountered, and his not maintaining clearance from objects during the approach. Factor were the low altitude, the transmission lines, and the garage.
- [NTSB NYC05LA106](https://openairdocs.org/ntsb/NYC05LA106.md): Cessna 172N · Edgartown, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2005 · N5118D · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]
- [NTSB LAX05LA215](https://openairdocs.org/ntsb/LAX05LA215.md): Beech BE76 · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 2005 · N5274M · Destroyed
  > the flight instructor's decision to attempt a single engine go-around with multiple aircraft system failures, and his improper in-flight decision to pass up one airport for landing and continue the flight to the home base airport with known mechanical…
- [NTSB CHI05CA153](https://openairdocs.org/ntsb/CHI05CA153.md): S C Aerostar S A YAK-52 · Columbus, NE · Accident · Minor injuries · Data collection · Final report · Jun 21, 2005 · N962KY · Substantial damage
  > The mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.
- [NTSB IAD05CA081](https://openairdocs.org/ntsb/IAD05CA081.md): PZL Swidnik PW-5 · Bloomingburg, NY · Accident · Minor injuries · Data collection · Final report · Jun 20, 2005 · N341PW · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with terrain.
- [NTSB DFW05LA165](https://openairdocs.org/ntsb/DFW05LA165.md): Cessna 401A · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 2005 · N7KF · Substantial damage
  > The loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI05CA150](https://openairdocs.org/ntsb/CHI05CA150.md): Cessna 172P · St. Francis, KS · Accident · No injuries · Data collection · Final report · Jun 19, 2005 · N53462 · Substantial damage
  > The pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.
- [NTSB ATL05CA104](https://openairdocs.org/ntsb/ATL05CA104.md): Cessna 152 · Naples, FL · Accident · No injuries · Data collection · Final report · Jun 19, 2005 · N625PA · Substantial damage
  > The CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.
- [NTSB LAX05LA210](https://openairdocs.org/ntsb/LAX05LA210.md): Cirrus Design SR-22 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Jun 18, 2005 · N626Z · Substantial damage
  > the pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.
- [NTSB CHI05CA151](https://openairdocs.org/ntsb/CHI05CA151.md): Kirby Christen Eagle · Wheeling, IL · Accident · No injuries · Data collection · Final report · Jun 17, 2005 · N92RK · Substantial damage
  > The pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.
- [NTSB ATL05CA099](https://openairdocs.org/ntsb/ATL05CA099.md): Cessna 150M · Panama City, FL · Accident · Minor injuries · Data collection · Final report · Jun 16, 2005 · N45372 · Substantial damage
  > The pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.
- [NTSB DEN05FA080](https://openairdocs.org/ntsb/DEN05FA080.md): Schweizer 269C · Pueblo, CO · Accident · Serious injuries · Field investigation · Final report · Jun 15, 2005 · N311CP · Destroyed
  > the flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…
- [NTSB SEA05CA116](https://openairdocs.org/ntsb/SEA05CA116.md): Taylorcraft BC12-D · Yellow Pine, ID · Accident · No injuries · Data collection · Final report · Jun 13, 2005 · N96156 · Substantial damage
  > The pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.
- [NTSB LAX05LA203](https://openairdocs.org/ntsb/LAX05LA203.md): Beech C90 · Marble Canyon, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2005 · N49LL · Substantial damage
  > the pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.
- [NTSB LAX05FA202](https://openairdocs.org/ntsb/LAX05FA202.md): Bombardier Aerospace CL-600-2B19 · Los Angeles, CA · Accident · No injuries · Field investigation · Final report · Jun 13, 2005 · N960SW · Substantial damage
  > failure of the nose landing gear to extend to the down and locked position for undetermined reasons.
- [NTSB CHI05LA138](https://openairdocs.org/ntsb/CHI05LA138.md): Mooney M20K · Jefferson City, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2005 · N231HX · Substantial damage
  > The pilot's delay in diverting to an alternate destination due to low fuel indications which led to the fuel exhaustion, loss of engine power and the subsequent forced landing. Factors were the pilot's improper preflight inspection which resulted in an…
- [NTSB IAD05LA076](https://openairdocs.org/ntsb/IAD05LA076.md): Aeronca C-3 · Toughkenamon, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 2005 · N13002 · Substantial damage
  > The failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.
- [NTSB NYC05CA097](https://openairdocs.org/ntsb/NYC05CA097.md): Burkhart Grob G103 Twin Astir · Wellington, OH · Accident · Minor injuries · Data collection · Final report · Jun 11, 2005 · N3872G · Substantial damage
  > The pilot's misjudgment of distance and altitude which resulted in an undershoot of the runway.
- [NTSB CHI05CA139](https://openairdocs.org/ntsb/CHI05CA139.md): Grimes SNS-9 · Niles, MI · Accident · Minor injuries · Data collection · Final report · Jun 10, 2005 · N143WW · Substantial damage
  > The pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.
- [NTSB NYC05IA093](https://openairdocs.org/ntsb/NYC05IA093.md): Saab-Scania 340A · Dulles, VA · Incident · No injuries · Incident investigation · Final report · Jun 9, 2005 · N40SZ · Minor damage
  > Failure of the right main landing gear to extend and lock for undetermined reasons, which resulted in the right main landing gear collapsing during touchdown.

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

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

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