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

## Cases, newest first

- [NTSB DFW05FA152](https://openairdocs.org/ntsb/DFW05FA152.md): Beech 76 · Conroe, TX · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2005 · N819ER · Destroyed
  > The pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.
- [NTSB LAX05LA197](https://openairdocs.org/ntsb/LAX05LA197.md): Cessna 172L · Santa Ynez, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2005 · N7668G · Substantial damage
  > the pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.
- [NTSB LAX05FA193](https://openairdocs.org/ntsb/LAX05FA193.md): Mooney M20C · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Jun 2, 2005 · N6574U · Destroyed
  > The pilot's decision to attempt flight into instrument meteorological conditions, which resulted in the pilot's loss of aircraft control due to spatial disorientation. Factors in the accident were haze and low ceilings, the night lighting condition, an…
- [NTSB SEA05LA110](https://openairdocs.org/ntsb/SEA05LA110.md): Beech A-36 · Tacoma, WA · Accident · No injuries · Limited investigation · Final report · May 31, 2005 · N9017V · Substantial damage
  > The malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.
- [NTSB DFW05LA139](https://openairdocs.org/ntsb/DFW05LA139.md): Beech A36 · Arcola, TX · Accident · Minor injuries · Limited investigation · Final report · May 30, 2005 · N2015A · Substantial damage
  > The pilot's failure to maintain directional control and airspeed which resulted in an inadvertent stall while attempting a go-around. A contributing factor was the quartering tailwind.
- [NTSB CHI05LA129](https://openairdocs.org/ntsb/CHI05LA129.md): Cessna 210B · Friendship, WI · Accident · No injuries · Limited investigation · Final report · May 30, 2005 · N9623X · Substantial damage
  > The loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.
- [NTSB NYC05LA088](https://openairdocs.org/ntsb/NYC05LA088.md): Klasing Bradley BA100 · Xenia, OH · Accident · 1 fatal · Limited investigation · Final report · May 29, 2005 · N53SK · Substantial damage
  > A loss of engine power for undetermined reasons, and the pilot's failure to maintain aircraft control, which resulted in an inadvertent stall and uncontrolled descent into terrain.
- [NTSB SEA05CA109](https://openairdocs.org/ntsb/SEA05CA109.md): Jackson Rans S-6S · Laurel, MT · Accident · No injuries · Data collection · Final report · May 28, 2005 · N133DJ · Substantial damage
  > The flight instructor's inadequate remedial action which resulted in a stall/spin during final approach to land. A contributing factor was the student pilot's failure to maintain adequate airspeed during the landing approach.
- [NTSB MIA05LA112](https://openairdocs.org/ntsb/MIA05LA112.md): Vans RV4 · Ft. Pierce, FL · Accident · Serious injuries · Limited investigation · Final report · May 28, 2005 · N3074T · Substantial damage
  > The loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel.
- [NTSB ATL05CA090](https://openairdocs.org/ntsb/ATL05CA090.md): Cessna 172R · Louisburg, NC · Accident · No injuries · Data collection · Final report · May 28, 2005 · N22055 · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.
- [NTSB SEA05LA107](https://openairdocs.org/ntsb/SEA05LA107.md): Cessna 150L · Spokane, WA · Accident · No injuries · Limited investigation · Final report · May 27, 2005 · N1770Q · Substantial damage
  > The pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.
- [NTSB CHI05LA130](https://openairdocs.org/ntsb/CHI05LA130.md): Pilatus PC-6 · Sturtevant, WI · Accident · Minor injuries · Limited investigation · Final report · May 26, 2005 · N346F · Substantial damage
  > Failure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…
- [NTSB DFW05LA134](https://openairdocs.org/ntsb/DFW05LA134.md): Gulfstream-Schweizer G-164D · Jennings, LA · Accident · No injuries · Limited investigation · Final report · May 24, 2005 · N8120K · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.
- [NTSB ATL05CA087](https://openairdocs.org/ntsb/ATL05CA087.md): Beech BE-36 · Dahlonega, GA · Accident · No injuries · Data collection · Final report · May 23, 2005 · N17836 · Substantial damage
  > The pilot's mismanagment of the fuel supply which resulted in fuel starvation and subsequent loss of engine power.
- [NTSB LAX05CA185](https://openairdocs.org/ntsb/LAX05CA185.md): Robinson R44 · Sedona, AZ · Accident · No injuries · Data collection · Final report · May 22, 2005 · N963JM · Substantial damage
  > the pilot's improperly planned approach and misjudged distance/speed. A factor was the high density altitude.
- [NTSB DFW05CA128](https://openairdocs.org/ntsb/DFW05CA128.md): Bellanca 17-30A · Houston, TX · Accident · Serious injuries · Data collection · Final report · May 22, 2005 · N39821 · Substantial damage
  > The pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.
- [NTSB CHI05CA119](https://openairdocs.org/ntsb/CHI05CA119.md): Schweizer SGS 2-33A · Beloit, WI · Accident · No injuries · Data collection · Final report · May 21, 2005 · N65855 · Substantial damage
  > The pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.
- [NTSB DEN05CA079](https://openairdocs.org/ntsb/DEN05CA079.md): Schweizer 269C · Pueblo, CO · Accident · No injuries · Data collection · Final report · May 19, 2005 · N958CP · Substantial damage
  > the student pilot's failure to maintain control of the helicopter during the landing. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.
- [NTSB MIA05LA103](https://openairdocs.org/ntsb/MIA05LA103.md): American General AG-5B · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · May 12, 2005 · N1193G · Substantial damage
  > The separation of the throttle control for undetermined reasons, and the unsuitable terrain encountered by the pilot during the forced landing, resulting in a nose-over after touchdown.
- [NTSB CHI05LA110](https://openairdocs.org/ntsb/CHI05LA110.md): Cessna 150L · Buffalo Grove, IL · Accident · Serious injuries · Limited investigation · Final report · May 8, 2005 · N11239 · Substantial damage
  > A loss of engine power due to fuel exhaustion during approach, inadequate preflight planning/preparation by the certified flight instruction (CFI), and the unsuitable terrain encountered by the CFI during the forced landing. An additional cause was the…
- [NTSB ATL05LA078](https://openairdocs.org/ntsb/ATL05LA078.md): Earnest Jodel D-9 · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · May 6, 2005 · N5164J · Substantial damage
  > The pilot's misjudgment of distance/altitude, and his failure to maintain adequate airspeed resulting in a stall and subsequent undershoot.
- [NTSB CHI05LA109](https://openairdocs.org/ntsb/CHI05LA109.md): Piper PA-31T · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · May 4, 2005 · N2338V · Substantial damage
  > Rupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…
- [NTSB NYC05CA076](https://openairdocs.org/ntsb/NYC05CA076.md): Piper PA-28-140 · Indian Head, MD · Accident · No injuries · Data collection · Final report · Apr 27, 2005 · N8730E · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.
- [NTSB DFW05LA110](https://openairdocs.org/ntsb/DFW05LA110.md): Friddle Super Cub Replica · Springtown, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 2005 · N10038 · Substantial damage
  > The pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.
- [NTSB MIA05LA098](https://openairdocs.org/ntsb/MIA05LA098.md): Gordon E. Brown Nieuport C-1 · Homestead, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 25, 2005 · N749GB · Substantial damage
  > The reported loss of engine power for undetermined reasons on the downwind leg which resulted in a forced landing, and subsequent in-flight collision with a guy-wire and terrain.
- [NTSB NYC05FA075](https://openairdocs.org/ntsb/NYC05FA075.md): Cessna 172R · Armonk, NY · Accident · 2 fatal · Field investigation · Final report · Apr 23, 2005 · N61AF · Destroyed
  > The flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.
- [NTSB MIA05LA096](https://openairdocs.org/ntsb/MIA05LA096.md): de Havilland DHC-6 · Deland, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 23, 2005 · N24HV · Substantial damage
  > The pilot's inadequate visual lookout.
- [NTSB SEA05LA084](https://openairdocs.org/ntsb/SEA05LA084.md): Cessna T210N · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2005 · N2AK · Destroyed
  > An airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…
- [NTSB LAX05LA141](https://openairdocs.org/ntsb/LAX05LA141.md): Bailey Lowing Loadster · Bakersfield, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 2005 · N8058Q · Substantial damage
  > the loss of engine power for undetermined reasons.
- [NTSB SEA05LA077](https://openairdocs.org/ntsb/SEA05LA077.md): Beech V35B · Tupelo, MS · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 2005 · N6645G · Substantial damage
  > A loss of engine power due to the inadequate in-flight planning and the pilot's failure to refuel the airplane resulting in fuel exhaustion.
- [NTSB NYC05CA072](https://openairdocs.org/ntsb/NYC05CA072.md): Cessna 172B · Collegeville, PA · Accident · No injuries · Data collection · Final report · Apr 16, 2005 · N7653X · Substantial damage
  > The pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident was the downdraft wind conditions.
- [NTSB CHI05CA100](https://openairdocs.org/ntsb/CHI05CA100.md): Mitchell KR-2S · Cameron, MO · Accident · Minor injuries · Data collection · Final report · Apr 14, 2005 · N316RP · Destroyed
  > The loss of engine power for an undetermined reason and the misjudged landing flare which resulted in the bounced landing. Additional causes were the improper recovery from the bounced landing and the inadvertent stall. A factor was the pilot's lack of…
- [NTSB LAX05LA143](https://openairdocs.org/ntsb/LAX05LA143.md): Firefly Balloon Firefly 11 · Saint Helena, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2005 · N15001 · No damage
  > The pilot's encounter with wind shear during landing, which resulted in a hard touchdown.
- [NTSB LAX05LA136](https://openairdocs.org/ntsb/LAX05LA136.md): Cessna T210M · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2005 · N732SY · Substantial damage
  > a loss of power for undetermined reasons.
- [NTSB DFW05LA102](https://openairdocs.org/ntsb/DFW05LA102.md): Spearman Raptor · Bogalusa, LA · Accident · 2 fatal · Limited investigation · Final report · Apr 12, 2005 · N750TP · Destroyed
  > The pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.
- [NTSB CHI05LA094](https://openairdocs.org/ntsb/CHI05LA094.md): Tschida Glastar · Kendallville, IN · Accident · No injuries · Limited investigation · Final report · Apr 10, 2005 · N5DK · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the fuel flow restriction at the internal engine fuel filter due the presence of the silicone sealant material. Contributing factors were the unsuitable terrain for a forced landing short of the…
- [NTSB SEA05CA080](https://openairdocs.org/ntsb/SEA05CA080.md): Cessna 172 · Yamhill, OR · Accident · No injuries · Data collection · Final report · Apr 9, 2005 · N8400L · Substantial damage
  > The pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.
- [NTSB SEA05FA072](https://openairdocs.org/ntsb/SEA05FA072.md): Stinson 10-A · Oak Harbor, WA · Accident · 2 fatal · Field investigation · Final report · Apr 8, 2005 · N39482 · Substantial damage
  > The pilot's failure to adequately plan the approach for landing and maintain clearance from trees during the go-around. A tailwind and trees were factors.
- [NTSB CHI05CA095](https://openairdocs.org/ntsb/CHI05CA095.md): Cessna 172P · Ann Arbor, MI · Accident · No injuries · Data collection · Final report · Apr 8, 2005 · N777UM · Substantial damage
  > The failure of the carburetor nozzle resulting in loss of engine power and the unsuitable terrain encountered during the forced landing. A factor was the low altitude.
- [NTSB IAD05LA053](https://openairdocs.org/ntsb/IAD05LA053.md): Mooney M20J · Rocky Hill, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 2005 · N4398H · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall, and subsequent impact with terrain. Factors included the night lighting conditions, and the airplane approaching the opposite runway.
- [NTSB IAD05FA052](https://openairdocs.org/ntsb/IAD05FA052.md): Piper PA-28R-201 · Green Creek, NJ · Accident · 2 fatal · Field investigation · Final report · Apr 6, 2005 · N36725 · Destroyed
  > The flight crew's failure to maintain terrain clearance while executing a practice published instrument approach in night visual meteorological conditions. A factor in the accident was the dark night.
- [NTSB CHI05LA088](https://openairdocs.org/ntsb/CHI05LA088.md): Air Tractor AT-602 · Imperial, NE · Accident · No injuries · Limited investigation · Final report · Apr 4, 2005 · N5015K · Substantial damage
  > The pilot's inadequate preflight planning which led to fuel exhaustion and subsequent loss of engine power. The soft ground was a factor.
- [NTSB IAD05LA050](https://openairdocs.org/ntsb/IAD05LA050.md): Piper PA-31P-350 · Ridgefield, CT · Accident · No injuries · Limited investigation · Final report · Apr 2, 2005 · N134DE · Substantial damage
  > The pilot's improper IFR procedure by flying below the minimum descent altitude, which resulted in the airplane striking trees.
- [NTSB NYC05CA065](https://openairdocs.org/ntsb/NYC05CA065.md): Piper PA-28-180 · Sussex, NJ · Accident · Minor injuries · Data collection · Final report · Mar 30, 2005 · N9235J · Substantial damage
  > The pilot's failure to insure adequate obstacle clearance while conducting a practice forced landing approach, and the flight instructor's failure to take remedial action, which resulted in an in-flight collision with wires.
- [NTSB ATL05CA067](https://openairdocs.org/ntsb/ATL05CA067.md): Aviat A1A · Alexander City, AL · Accident · No injuries · Data collection · Final report · Mar 29, 2005 · N119WP · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB ATL05FA066](https://openairdocs.org/ntsb/ATL05FA066.md): Cessna T206H · Johns Island, SC · Accident · 2 fatal · Field investigation · Final report · Mar 27, 2005 · N222YT · Substantial damage
  > The pilot's failure to follow instrument flight procedures and descent below the published minimum descent altitude, which resulted in an in-flight collision with terrain during an instrument approach.
- [NTSB IAD05FA047](https://openairdocs.org/ntsb/IAD05FA047.md): Pilatus PC-12/45 · Bellefonte, PA · Accident · 6 fatal · Field investigation · Final report · Mar 26, 2005 · N770G · Destroyed
  > The pilot's failure to maintain sufficient airspeed to avoid a stall during an instrument final approach to land, which resulted in an inadvertent stall/spin. Factors associated with the accident are the inadvertent stall/spin, the pilot's failure to follow…
- [NTSB SEA05LA066](https://openairdocs.org/ntsb/SEA05LA066.md): Abbott Glasair Legend · Cascade, MT · Accident · No injuries · Limited investigation · Final report · Mar 24, 2005 · C-GUTT · Substantial damage
  > The accumulation of wet snow on the engine inlet assembly protection screen during a rapid increase in outside air temperature, while on an instrument approach for landing. Factors include falling snow, a sudden and significant increase in outside air…
- [NTSB LAX05LA122](https://openairdocs.org/ntsb/LAX05LA122.md): Robinson R22 Beta · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 24, 2005 · N225G · Substantial damage
  > The company mechanic's improper maintenance actions, which resulted in the total failure of the main rotor drive belt system on approach to landing. A factor was the soft terrain.
- [NTSB LAX05LA120](https://openairdocs.org/ntsb/LAX05LA120.md): Cessna T210N · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 22, 2005 · N6897N · Substantial damage
  > the pilot's improper use of the fuel boost pump contrary to the procedures specified in the pilot owner handbook and other documents.

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

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

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