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

## Cases, newest first

- [NTSB IAD02LA034](https://openairdocs.org/ntsb/IAD02LA034.md): Cessna 170 · Fredericksburg, VA · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2002 · N3832V · Substantial damage
  > The unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.
- [NTSB FTW02LA084](https://openairdocs.org/ntsb/FTW02LA084.md): Cessna 172A · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 22, 2002 · N6845X · Substantial damage
  > the pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.
- [NTSB NYC02LA061](https://openairdocs.org/ntsb/NYC02LA061.md): Piper PA-28R-200 · Fredericksburg, VA · Accident · No injuries · Limited investigation · Final report · Feb 17, 2002 · N9302N · Substantial damage
  > The private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.
- [NTSB NYC02FA060](https://openairdocs.org/ntsb/NYC02FA060.md): Rockwell 500S · Exeter, RI · Accident · 1 fatal · Field investigation · Final report · Feb 17, 2002 · N999N · Substantial damage
  > The pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.
- [NTSB ANC02LA015](https://openairdocs.org/ntsb/ANC02LA015.md): Boeing 727-100 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Feb 14, 2002 · N190AJ · Substantial damage
  > The pilot's decision to continue an unstabalized approach to landing. A factor associated with the accident is the pilot's failure to attain proper alignment with the runway.
- [NTSB FTW02LA076](https://openairdocs.org/ntsb/FTW02LA076.md): Piper PA-31T · Hobbs, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 2002 · N794CA · Destroyed
  > the pilot's failure to maintain the proper glidepath during the instrument approach. Contributing factors were the dark night light conditions and the pilot's diverted attention.
- [NTSB LAX02LA079](https://openairdocs.org/ntsb/LAX02LA079.md): Schweizer SGS 2-33A · Warner Springs, CA · Accident · No injuries · Limited investigation · Final report · Feb 4, 2002 · N34292 · Substantial damage
  > The student pilot's failure to maintain directional control during the landing sequence.
- [NTSB LAX02LA076](https://openairdocs.org/ntsb/LAX02LA076.md): Beech 95-B55 · Joshua Tree, CA · Accident · No injuries · Limited investigation · Final report · Feb 3, 2002 · N9DD · Substantial damage
  > The pilot's inadvertent missetting of the fuel selector position on the auxiliary fuel tanks (versus the main tanks) resulting in fuel starvation of the engines.
- [NTSB MIA02LA058](https://openairdocs.org/ntsb/MIA02LA058.md): Harleman Tornado II · Molino, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 1, 2002 · N140V · Substantial damage
  > The pilot's failure to maintain obstacle clearance, resulting in the in-flight collision with a static wire and an uncontrolled descent and collision with the ground. A factor in the accident was the pilot's impairment resulting from the use of unapproved…
- [NTSB NYC02FA055](https://openairdocs.org/ntsb/NYC02FA055.md): Beech V35B · Chester, CT · Accident · 2 fatal · Field investigation · Final report · Jan 31, 2002 · N32BR · Destroyed
  > The pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.
- [NTSB CHI02LA075](https://openairdocs.org/ntsb/CHI02LA075.md): Piper PA-42-720 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Jan 31, 2002 · N66MT · Substantial damage
  > The pilot's failure to maintain the proper glide path during the final portion of the approach. Factors relating to this accident were the low altitude and the utility pole.
- [NTSB LAX02FA069](https://openairdocs.org/ntsb/LAX02FA069.md): Cameron Balloons US N-145 · North Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2002 · N8004J · Substantial damage
  > The pilot's misjudged approach and inadequate obstacle clearance, which resulted in his failure to attain the proper touchdown point. Contributing factors were the high gusty wind condition, and the pilot's failure to provide protective safety equipment.
- [NTSB FTW02LA073](https://openairdocs.org/ntsb/FTW02LA073.md): Cessna 152 · Ardmore, OK · Accident · No injuries · Limited investigation · Final report · Jan 26, 2002 · N47802 · Substantial damage
  > the instructor pilot's delayed go-around which resulted in an in-flight collision with trees. A contributing factor to the accident was the instructor pilot's fatigued condition due to lack of sleep.
- [NTSB FTW02FA072](https://openairdocs.org/ntsb/FTW02FA072.md): Cessna 177 · Farmington, NM · Accident · 1 fatal · Field investigation · Final report · Jan 22, 2002 · N29406 · Substantial damage
  > the pilot's inadequate in-flight planning decision which resulted in fuel exhaustion while in the traffic pattern at the destination airport.
- [NTSB FTW02FA071](https://openairdocs.org/ntsb/FTW02FA071.md): Beech C23 · Sinton, TX · Accident · 1 fatal · Field investigation · Final report · Jan 18, 2002 · N6622X · Destroyed
  > The pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.
- [NTSB FTW02LA069](https://openairdocs.org/ntsb/FTW02LA069.md): Bellanca 17-30 · Plainview, TX · Accident · No injuries · Limited investigation · Final report · Jan 16, 2002 · N7388V · Substantial damage
  > the pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.
- [NTSB LAX02LA065](https://openairdocs.org/ntsb/LAX02LA065.md): Piper PA-24-250 · Oceano, CA · Accident · No injuries · Limited investigation · Final report · Jan 13, 2002 · N328EJ · Substantial damage
  > A loss of engine power due to the separation of the mixture control cable from the mixture control arm of the carburetor. The mixture cable separation was due to maintenance personnel's failure to secure the mixture control cable away from the nose landing…
- [NTSB NYC02LA048](https://openairdocs.org/ntsb/NYC02LA048.md): Piper PA-28 · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Jan 12, 2002 · N6315R · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB FTW02LA270](https://openairdocs.org/ntsb/FTW02LA270.md): Raven S60A · La Vernia, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 2002 · N804DL · Minor damage
  > The pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.
- [NTSB FTW02LA066](https://openairdocs.org/ntsb/FTW02LA066.md): Piper PA-46T · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jan 10, 2002 · N87WW · Substantial damage
  > The pilot's failure to obtain/maintain proper runway alignment. Contributing factors were the pilot's inadvertant flight into adverse weather conditions, the pilot not performing a missed approach, and the low ceiling and snow weather conditions.
- [NTSB ATL02LA036](https://openairdocs.org/ntsb/ATL02LA036.md): Cessna 170B · Bellewood, MS · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 2002 · N48031 · Substantial damage
  > The pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.
- [NTSB CHI02LA051](https://openairdocs.org/ntsb/CHI02LA051.md): Beech S35 · Angola, IN · Accident · No injuries · Limited investigation · Final report · Jan 6, 2002 · N7915K · Destroyed
  > The pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.
- [NTSB LAX02FA061](https://openairdocs.org/ntsb/LAX02FA061.md): Cessna T337H · Buena Park, CA · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2002 · N1348L · Destroyed
  > the pilot's failure to maintain control of the airplane during the landing approach. Factors included the pilot's distraction when informed that his landing gear was not down, and his impairment from the effects of prescription drugs.
- [NTSB NYC02FA044](https://openairdocs.org/ntsb/NYC02FA044.md): Raytheon BE-23-B24R · Armonk, NY · Accident · 1 fatal · Field investigation · Final report · Dec 31, 2001 · N2173W · Destroyed
  > The pilot's failure to maintain aircraft control.
- [NTSB IAD02FA024](https://openairdocs.org/ntsb/IAD02FA024.md): Piper PA-28R-180 · Milford, CT · Accident · 1 fatal · Field investigation · Final report · Dec 30, 2001 · N7427J · Substantial damage
  > The pilot's failure to follow the published IFR approach procedure, which resulted in a premature descent and subsequent impact with water. A factor was the night, overwater visual conditions.
- [NTSB ATL02FA026](https://openairdocs.org/ntsb/ATL02FA026.md): Mooney M20C · Gainesville, GA · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2001 · N6953V · Destroyed
  > The loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.
- [NTSB CHI02FA059](https://openairdocs.org/ntsb/CHI02FA059.md): Borgman Smyth Sidewinder · Independence, KS · Accident · 2 fatal · Field investigation · Final report · Dec 28, 2001 · N133G · Substantial damage
  > The pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.
- [NTSB CHI02LA055](https://openairdocs.org/ntsb/CHI02LA055.md): Cessna 182P · Elkhart, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 2001 · N58797 · Substantial damage
  > The pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.
- [NTSB ATL02LA019](https://openairdocs.org/ntsb/ATL02LA019.md): Cessna 210D · Vero Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2001 · N3776Y · Substantial damage
  > The pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.
- [NTSB LAX02LA053](https://openairdocs.org/ntsb/LAX02LA053.md): Cessna T210N · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Dec 20, 2001 · N7AL · Substantial damage
  > The pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.
- [NTSB LAX02LA050](https://openairdocs.org/ntsb/LAX02LA050.md): Cessna R182 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Dec 17, 2001 · N7317X · Substantial damage
  > Inadequate maintenance and inspection of the engine dual magneto that resulted in a loss of engine power during a critical phase of flight, and the subsequent undershoot forced landing in soft terrain.
- [NTSB LAX02FA049](https://openairdocs.org/ntsb/LAX02FA049.md): Cessna T210L · San Jacinto, CA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2001 · N210RE · Destroyed
  > The pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.
- [NTSB MIA02FA045](https://openairdocs.org/ntsb/MIA02FA045.md): Piper PA-32-260 · Jacksonville, FL · Accident · 4 fatal · Field investigation · Final report · Dec 13, 2001 · N7701J · Destroyed
  > The pilot becoming spatially disoriented and losing control of the airplane during a missed approach resulting in the airplane descending uncontrolled and colliding with trees and the ground.
- [NTSB MIA02FA044](https://openairdocs.org/ntsb/MIA02FA044.md): Piper PA-46-350P · Raleigh, NC · Accident · 3 fatal · Field investigation · Final report · Dec 13, 2001 · N41003 · Destroyed
  > the pilot's failure to maintain control of the airplane, due to spatial disorientation, while performing a missed approach, resulting in an uncontrolled descent, and subsequent impact with a tree and a house. Factors in this accident were dark night, fog,…
- [NTSB FTW02LA052](https://openairdocs.org/ntsb/FTW02LA052.md): Piper PA-23-250 · Duncan, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2001 · N127CA · Substantial damage
  > The pilot's descent below the minimum descent altitude, and his failure to maintain obstacle clearance. Contributing factors were the below approach/landing minimum weather, the dark night conditions, and the inoperative REIL's.
- [NTSB FTW02TA051](https://openairdocs.org/ntsb/FTW02TA051.md): Cessna T210K · San Antonio, TX · Accident · No injuries · Final report · Dec 11, 2001 · N8299M · Substantial damage
  > the failure of the right main landing gear downlock mechanism to engage for reasons undetermined.
- [NTSB LAX02LA043](https://openairdocs.org/ntsb/LAX02LA043.md): Rominger Zic Zac Bird · Marina, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 9, 2001 · N204ED · Destroyed
  > the failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.
- [NTSB LAX02LA042](https://openairdocs.org/ntsb/LAX02LA042.md): Burkhart Grob G102 Club Astir Iiib · Banning, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 2001 · N102FC · Substantial damage
  > On final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.
- [NTSB NYC02LA034](https://openairdocs.org/ntsb/NYC02LA034.md): Gillette Baby Ace · Spencerport, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 2001 · N916MG · Substantial damage
  > The pilot's failure to maintain aircraft control during approach to the airport, which resulted in an inadvertent stall.
- [NTSB LAX02LA036](https://openairdocs.org/ntsb/LAX02LA036.md): Piper PA-24-250 · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2001 · N7213P · Substantial damage
  > Fuel starvation on final approach due to the pilot's fuel mismanagement, and his inattentiveness in following established prelanding procedures.
- [NTSB MIA02LA038](https://openairdocs.org/ntsb/MIA02LA038.md): Byrd KR-2S · Linden, NC · Accident · No injuries · Limited investigation · Final report · Dec 1, 2001 · N366KR · Destroyed
  > The pilot's failure to correct a condition where visual contact with the terrain was lost due to sunshine glare, resulting in collision with a tree during final approach for landing.
- [NTSB MIA02FA037](https://openairdocs.org/ntsb/MIA02FA037.md): Cessna 208B · Bessemer, AL · Accident · 2 fatal · Field investigation · Final report · Dec 1, 2001 · N499BA · Destroyed
  > The poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…
- [NTSB LAX02LA035](https://openairdocs.org/ntsb/LAX02LA035.md): Classic Waco YMF · Banning, CA · Accident · No injuries · Limited investigation · Final report · Dec 1, 2001 · N31BN · Substantial damage
  > a loss of engine power due to a crack in the carburetor float and leaking portions of the carburetor that resulted in an overly rich mixture.
- [NTSB CHI02LA044](https://openairdocs.org/ntsb/CHI02LA044.md): Mitsubishi MU-2B-40 · St Paul, MN · Accident · No injuries · Limited investigation · Final report · Nov 30, 2001 · N9052Y · Substantial damage
  > The autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.
- [NTSB LAX02LA033](https://openairdocs.org/ntsb/LAX02LA033.md): Beech B95 · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Nov 29, 2001 · N2012C · Substantial damage
  > the loss of engine power in the left engine for undetermined reasons. A contributing factor was the check pilot's failure to completely configure the airplane for a single engine go-around in a timely way.
- [NTSB LAX02LA030](https://openairdocs.org/ntsb/LAX02LA030.md): Beech C-99 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 2001 · N228BH · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his failure to maintain directional control. Contributing factors were the icing conditions, icing, and the improper use of the anti-ice/deicing equipment.
- [NTSB MIA02LA033](https://openairdocs.org/ntsb/MIA02LA033.md): Vernon D. Pitts RV-4 · Burgaw, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2001 · N15VP · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB MIA02FA026](https://openairdocs.org/ntsb/MIA02FA026.md): Enstrom 280FX · Tallassee, AL · Accident · 2 fatal · Field investigation · Final report · Nov 22, 2001 · N280XF · Destroyed
  > The failure of the pilot to maintain a safe altitude above terrain and maintain a visual lookout resulting in the helicopter colliding with power transmission lines and crashing into a river. A factor in the accident was the power transmission lines not being…
- [NTSB MIA02LA028](https://openairdocs.org/ntsb/MIA02LA028.md): Cessna 150M · Stuart, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 2001 · N590AM · Substantial damage
  > The pilot's improper fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion and collision with trees during a forced landing.
- [NTSB MIA02LA023](https://openairdocs.org/ntsb/MIA02LA023.md): Boeing 727-233 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Nov 20, 2001 · N277FE · Substantial damage
  > The inadvertent collision with birds while on final approach to land resulting in substantial damage to the airplane.

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

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

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