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

## Cases, newest first

- [NTSB LAX95LA111](https://openairdocs.org/ntsb/LAX95LA111.md): Cessna 182C · Novato, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1995 · N9036T · Substantial damage
  > The pilot's failure to maintain a proper base leg alignment while flying in the traffic pattern and his misjudged distance and altitude during the approach. A factor which contributed to the accident was the dark nighttime lighting condition which reduced the…
- [NTSB NYC95FA056](https://openairdocs.org/ntsb/NYC95FA056.md): Piper PA-46-310P · Chippewa Falls, WI · Accident · 2 fatal · Field investigation · Final report · Feb 15, 1995 · N9YP · Destroyed
  > The pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…
- [NTSB FTW95LA115](https://openairdocs.org/ntsb/FTW95LA115.md): Cessna 414 · Mcgregor, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1995 · N4643G · Destroyed
  > The pilot's delayed initiation of the missed approach until well below the minimum descent altitude and beyond the published missed approach point. Factors were the dark night and the low ceiling and visibility.
- [NTSB LAX95LA106](https://openairdocs.org/ntsb/LAX95LA106.md): Burkhart Grob Twin Astir · Fort Huachuca, AZ · Accident · No injuries · Limited investigation · Final report · Feb 11, 1995 · N333BH · Substantial damage
  > Improper in-flight planning/decision by the pilot, which resulted in his failure to remain clear of tree(s) during an off-airport landing. Factors related to the accident were: lack of thermal lift, and high obstructions in the off-airport landing area.
- [NTSB LAX95FA105](https://openairdocs.org/ntsb/LAX95FA105.md): Piper PA-32R-301T · Ceres, CA · Accident · 2 fatal · Field investigation · Final report · Feb 11, 1995 · N560LM · Destroyed
  > the pilot inadvertently becoming lost/disoriented during a missed approach, his failure to follow the proper missed approach procedure, and his failure to maintain control of the aircraft due to spatial disorientation.
- [NTSB FTW95FA112](https://openairdocs.org/ntsb/FTW95FA112.md): Piper PA-32R-300 · Conroe, TX · Accident · 5 fatal · Field investigation · Final report · Feb 10, 1995 · N5373F · Destroyed
  > The pilot's failure to follow published IFR procedures. Factors were the weather conditions, the dark night, and the pilot's failure to activate the approach lighting system.
- [NTSB MIA95FA072](https://openairdocs.org/ntsb/MIA95FA072.md): Cessna 152 · Mobile, AL · Accident · Serious injuries · Field investigation · Final report · Feb 7, 1995 · N757XX · Substantial damage
  > The pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.
- [NTSB FTW95LA109](https://openairdocs.org/ntsb/FTW95LA109.md): Rockwell 112B · Coyote, NM · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1995 · N1403J · Destroyed
  > Water contamination of the fuel from an unknown source. A factor related to the accident was: lack of suitable terrain for a forced landing.
- [NTSB LAX95LA094](https://openairdocs.org/ntsb/LAX95LA094.md): Cessna 152 · Sedona, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1995 · N46874 · Substantial damage
  > the pilot's improper compensation for the prevailing wind conditions, and his improper remedial action by raising the flaps before applying the power. The downdraft was a factor.
- [NTSB CHI95LA076](https://openairdocs.org/ntsb/CHI95LA076.md): Beech V35A-TC · Pembina, ND · Accident · No injuries · Limited investigation · Final report · Jan 29, 1995 · N68DC · Substantial damage
  > the pilot's misjudgement of the actual altitude of the airplane. Factors were the visual illusion caused by the snow covered runway environment and the whiteout weather condition.
- [NTSB ATL95FA046](https://openairdocs.org/ntsb/ATL95FA046.md): Beech A36 · Chamblee, GA · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1995 · N3086T · Destroyed
  > The pilot's failure to maintain aircraft control after becoming spatially disoriented. Factors relating to the accident were: the pilot's lack of proficiency (recent experience) in instrument flying, and improper approach control service by vectoring the…
- [NTSB SEA95FA043](https://openairdocs.org/ntsb/SEA95FA043.md): Beech E18S · Butte, MT · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1995 · N250RP · Substantial damage
  > The pilot's failure to follow the IFR procedure by not maintaining the proper altitude prior to the initial appraoch fix. Factors to the accident were dark night conditions and a low ceiling.
- [NTSB SEA95LA039](https://openairdocs.org/ntsb/SEA95LA039.md): Piper PA-31-350 · La Grande, OR · Accident · No injuries · Limited investigation · Final report · Jan 21, 1995 · N36PB · Substantial damage
  > Failure of the pilot to maintain proper altitude/clearance from higher terrain that was located near the airport. Factors related to the accident were: low ceiling, fog, false/incorrect indication of the NDB, failure of other personnel to properly issue a…
- [NTSB SEA95FA038](https://openairdocs.org/ntsb/SEA95FA038.md): Beech V35 · Moose, WY · Accident · 3 fatal · Field investigation · Final report · Jan 19, 1995 · N5603S · Substantial damage
  > The pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.
- [NTSB CHI95LA068](https://openairdocs.org/ntsb/CHI95LA068.md): Piper PA-28-181 · Brookfield, WI · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1995 · N39955 · Destroyed
  > The instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.
- [NTSB ATL95LA040](https://openairdocs.org/ntsb/ATL95LA040.md): Piper PA-28-151 · Orange Beach, AL · Accident · No injuries · Limited investigation · Final report · Jan 16, 1995 · N32411 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL95LA039](https://openairdocs.org/ntsb/ATL95LA039.md): Piper PA-31-350 · Burlington, NC · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1995 · N7144Z · Substantial damage
  > The pilot's improper pre-flight inspection, in that he failed to visually confirm the fuel quantity prior to departure.
- [NTSB ATL95LA037](https://openairdocs.org/ntsb/ATL95LA037.md): Cessna P210R · Lumberton, NC · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 1995 · N5464A · Destroyed
  > The failure of the pilot to maintain aircraft control during the approach for landing, resulting in a collision with objects.
- [NTSB FTW95FA087](https://openairdocs.org/ntsb/FTW95FA087.md): Beech B95 · Hot Springs, AR · Accident · 3 fatal · Field investigation · Final report · Jan 10, 1995 · N673Q · Destroyed
  > The pilot's failure to follow IFR and missed approach procedures.
- [NTSB ATL95LA035](https://openairdocs.org/ntsb/ATL95LA035.md): Cessna 310N · Covington, GA · Accident · No injuries · Limited investigation · Final report · Jan 10, 1995 · N4104Q · Substantial damage
  > The pilot's improper fuel management which resulted in fuel starvation and loss of engine power.
- [NTSB FTW95LA085](https://openairdocs.org/ntsb/FTW95LA085.md): Piper PA-31-350 · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1995 · N50WT · Destroyed
  > The fuel starvation loss of engine power due to the pilot's improper use of the fuel tank selector. Factors were the pilot's qualification and the lack of suitable terrain for landing.
- [NTSB ATL95LA034](https://openairdocs.org/ntsb/ATL95LA034.md): Cessna 150H · Fayetteville, TN · Accident · No injuries · Limited investigation · Final report · Jan 4, 1995 · N7185S · Substantial damage
  > The pilot's improper use of carburetor heat.
- [NTSB ATL95LA033](https://openairdocs.org/ntsb/ATL95LA033.md): Piper PA-28-151 · Foley, AL · Accident · No injuries · Limited investigation · Final report · Jan 3, 1995 · N6829F · Destroyed
  > An engine fire for undetermined reasons.
- [NTSB MIA95FA053](https://openairdocs.org/ntsb/MIA95FA053.md): Larson, C.H. Cozy MK IV · Wauchula, FL · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1995 · N5037 · Substantial damage
  > Distance vs. altitude misjudged by the pilot-in-command while on short final approach. Additionally, altitude/clearance not maintained while on short final approach resulting in the collision with an unmarked static power line.
- [NTSB FTW95IA083](https://openairdocs.org/ntsb/FTW95IA083.md): Boeing 737-3A4 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Jan 1, 1995 · N326SW · No damage
  > Encounter with wake turbulence.
- [NTSB NYC95DNC01](https://openairdocs.org/ntsb/NYC95DNC01.md): Wyman Scorpion II · Cornish Flat, NH · Accident · No injuries · Final report · Dec 28, 1994 · N65562 · Destroyed
  > Partial failure and subsequent partial separation of skin on the underside of one main rotor blade, which resulted in a severe vibration, in-flight loss of aircraft control, and impact with the ground during an attempted autorotation.
- [NTSB LAX95FA062](https://openairdocs.org/ntsb/LAX95FA062.md): Piper PA-28-140 · Holtville, CA · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1994 · N4647R · Destroyed
  > the pilot's becoming lost/disoriented during a night cross- country flight at a time the flight was in a critical low fuel state, and his failure to maintain aircraft control during a go-around from an aborted precautionary landing. Factors in the accident…
- [NTSB NYC95LA047](https://openairdocs.org/ntsb/NYC95LA047.md): Grumman American AA-1A · Lancaster, NY · Accident · No injuries · Limited investigation · Final report · Dec 27, 1994 · N9457L · Substantial damage
  > The pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel to return to the home airport after proceeding to an alternate airport and making a missed approach. Factors related to the accident were:…
- [NTSB NYC95LA046](https://openairdocs.org/ntsb/NYC95LA046.md): Mooney M20J · Huber Heights, OH · Accident · No injuries · Limited investigation · Final report · Dec 27, 1994 · N201JT · Substantial damage
  > The pilot's inadequate inflight decision/planning, which resulted in fuel exhaustion and the loss of engine power. A factor is the pilot's inadequate preflight planning.
- [NTSB FTW95LA070](https://openairdocs.org/ntsb/FTW95LA070.md): Piper PA-28R-200 · Oklahoma City, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1994 · N2874R · Substantial damage
  > The loss of engine power due to fuel starvation as a result of improper fuel selector position. Factors were the dark night and lack of suitable terrain for the forced landing.
- [NTSB CHI95LA062](https://openairdocs.org/ntsb/CHI95LA062.md): Piper PA-32-260 · Fort Dodge, IA · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1994 · N7JD · Substantial damage
  > The pilot's improper IFR procedure. The low ceiling and fog were a factor.
- [NTSB NYC95LA045](https://openairdocs.org/ntsb/NYC95LA045.md): Cessna 150H · Wheeling, WV · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1994 · N7175S · Destroyed
  > The student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.
- [NTSB MIA95LA046](https://openairdocs.org/ntsb/MIA95LA046.md): Piper PA-28-181 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Dec 21, 1994 · N82895 · Substantial damage
  > In flight planning decision delay by the pilot-in-command in that he failed to divert to an alternate airport before loss of engine power due to fuel exhaustion.
- [NTSB SEA95LA024](https://openairdocs.org/ntsb/SEA95LA024.md): Piper PA-28-161 · Auburn, WA · Accident · No injuries · Limited investigation · Final report · Dec 15, 1994 · N8388Y · Substantial damage
  > The pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.
- [NTSB DCA95MA006](https://openairdocs.org/ntsb/DCA95MA006.md): British Aerospace Jetstream 3201 · Morrisville, NC · Accident · 15 fatal · Major investigation · Final report · Dec 13, 1994 · N918AE · Destroyed
  > 1) the captain's improper assumption that an engine had failed, and 2) the captain's subsequent failure to follow approved procedures for engine failure, single-engine approach and go-around, and stall recovery. Contributing to the cause of the accident was…
- [NTSB FTW95LA065](https://openairdocs.org/ntsb/FTW95LA065.md): Commonwealth Rearwin 185 · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Dec 12, 1994 · N93290 · Substantial damage
  > Oil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.
- [NTSB SEA95FA029](https://openairdocs.org/ntsb/SEA95FA029.md): Piper PA-28-235 · Seattle, WA · Accident · 2 fatal · Field investigation · Final report · Dec 11, 1994 · N2VZ · Destroyed
  > Fuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.
- [NTSB ATL95LA027](https://openairdocs.org/ntsb/ATL95LA027.md): Aero Commander 500S · Millington, TN · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1994 · N9171N · Substantial damage
  > The pilot's inadequate preflight of the aircraft, in that he did not ensure that there was adequate fuel for the flight, which resulted in fuel exhaustion.
- [NTSB CHI95LA053](https://openairdocs.org/ntsb/CHI95LA053.md): Beech E18S · Kansas City, MO · Accident · 1 fatal · Limited investigation · Final report · Dec 9, 1994 · N5647D · Destroyed
  > Failure of the pilot to maintain adequate airspeed on final approach, which resulted in an inadvertent stall/spin. Factors related to the accident were: the adverse weather (icing) conditions, the accumulation of airframe/wing ice, the pilot's improper use of…
- [NTSB ATL95LA024](https://openairdocs.org/ntsb/ATL95LA024.md): Piper PA-28-161 · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Dec 8, 1994 · N8075S · Substantial damage
  > The pilot's failure to properly pre-flight the airplane to ensure the left fuel tank cover was properly secured.
- [NTSB NYC95LA041](https://openairdocs.org/ntsb/NYC95LA041.md): Cessna T210M · Wadsworth, OH · Accident · No injuries · Limited investigation · Final report · Dec 4, 1994 · N7614K · Substantial damage
  > The loss of engine power for undetermined reasons which resulted in a forced landing on unsuitable terrain.
- [NTSB NYC95LA040](https://openairdocs.org/ntsb/NYC95LA040.md): Burkhart Grob 103A · Blairstown, NJ · Accident · No injuries · Limited investigation · Final report · Dec 4, 1994 · N858BG · Substantial damage
  > The pilot's failure to maintain the proper descent rate.
- [NTSB LAX95LA042](https://openairdocs.org/ntsb/LAX95LA042.md): Grumman AA5 · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1994 · N6353L · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain an adequate visual lookout for other traffic in the pattern, and the other pilot's failure to effectively use the CTAF for position reports while in the pattern.
- [NTSB ATL95FA022](https://openairdocs.org/ntsb/ATL95FA022.md): American AA-1A · Gastonia, NC · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1994 · N9260L · Destroyed
  > The pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…
- [NTSB ATL95LA020](https://openairdocs.org/ntsb/ATL95LA020.md): Cessna 182P · Greer, SC · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1994 · N6556M · Substantial damage
  > The pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.
- [NTSB ATL95FA021](https://openairdocs.org/ntsb/ATL95FA021.md): Beech 95B55 · Mableton, GA · Accident · 1 fatal · Field investigation · Final report · Nov 27, 1994 · N8933M · Substantial damage
  > The pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.
- [NTSB NYC95FA033](https://openairdocs.org/ntsb/NYC95FA033.md): Piper PA-28-181 · Doylestown, PA · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1994 · N2949Q · Substantial damage
  > the pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.
- [NTSB BFO95LA014](https://openairdocs.org/ntsb/BFO95LA014.md): Cessna 172L · Bethel, ME · Accident · No injuries · Limited investigation · Final report · Nov 22, 1994 · N19735 · Substantial damage
  > the flight instructor's failure to ensure adequate control of the airplane during a go-around. The gusty wind conditions were contributing factors.
- [NTSB ATL95LA017](https://openairdocs.org/ntsb/ATL95LA017.md): WSK PZL Mielec TS-11 Iskra · Shelby, NC · Accident · 1 fatal · Limited investigation · Final report · Nov 20, 1994 · N619R · Destroyed
  > The pilot's failure to maintain landing approach speed, which resulted in a final approach stall. Factors were the night lighting conditions, and the pilot's failure to use the landing light.
- [NTSB NYC95FA031](https://openairdocs.org/ntsb/NYC95FA031.md): Mooney M20J · Brewster, MA · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1994 · N5681Y · Destroyed
  > Failure of the pilot to maintain control of the airplane during a missed approach. A factor related to the accident was: the deteriorating weather condition with a low ceiling and rain.

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

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

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