# 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 122 of 420 · 20,996 cases

## Cases, newest first

- [NTSB CHI96LA289](https://openairdocs.org/ntsb/CHI96LA289.md): Mrotek Minicab GY20 · Albion, IN · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1996 · N263AM · Substantial damage
  > the pilot's misjudgment of distance and altitude during the approach to land, and his failure to attain the proper touchdown point. Factors relating to the accident were: the uneven and uphill terrain conditions at the approach end of the airstrip.
- [NTSB LAX96LA302](https://openairdocs.org/ntsb/LAX96LA302.md): Beech B23 · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1996 · N6087N · Destroyed
  > fuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.
- [NTSB ANC96LA121](https://openairdocs.org/ntsb/ANC96LA121.md): Piper PA-18 · Arctic Village, AK · Accident · No injuries · Limited investigation · Final report · Aug 8, 1996 · N9730P · Substantial damage
  > The airplane's low airspeed during final approach, and the pilot's delayed remedial action in correcting the low airspeed condition.
- [NTSB CHI96LA276](https://openairdocs.org/ntsb/CHI96LA276.md): Piper PA-22 · Flushing, MI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1996 · N7245D · Substantial damage
  > fuel exhaustion caused by the failure of the pilot to select a fuel tank with fuel remaining.
- [NTSB SEA96LA180](https://openairdocs.org/ntsb/SEA96LA180.md): Grumman American AA-5A · Klamath Falls, OR · Accident · No injuries · Limited investigation · Final report · Aug 6, 1996 · N26414 · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…
- [NTSB ANC96LA120](https://openairdocs.org/ntsb/ANC96LA120.md): Cessna 185 · Kaktovik, AK · Accident · No injuries · Limited investigation · Final report · Aug 6, 1996 · N8536L · Substantial damage
  > The pilot's inadequate compensation for the existing wind conditions. A factor associated with the accident was the windshear.
- [NTSB MIA96LA202](https://openairdocs.org/ntsb/MIA96LA202.md): Piper PA-32-260 · Live Oak, FL · Accident · No injuries · Limited investigation · Final report · Aug 4, 1996 · N3399W · Substantial damage
  > failure of the pilot to use carburetor heat during the approach to land, which resulted in loss of engine power due to carburetor ice. The weather (carburetor icing condition) was a related factor.
- [NTSB IAD96LA125](https://openairdocs.org/ntsb/IAD96LA125.md): Cessna 172M · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Aug 4, 1996 · N172PS · Substantial damage
  > failure of the student pilot to maintain sufficient airspeed during an attempted go-around, which resulted in a stall/spin and an uncontrolled collision with the ground. A factor related to the accident was: an improper (premature) flare for landing.
- [NTSB IAD96LA124](https://openairdocs.org/ntsb/IAD96LA124.md): Cessna 150 · Waverly, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1996 · N61049 · Destroyed
  > the pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) with subsequent loss of visual contact and collision with the ground. Darkness and fog were related factors.
- [NTSB ANC96LA116](https://openairdocs.org/ntsb/ANC96LA116.md): Piper PA-18 · Tyonek, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1996 · N8995D · Substantial damage
  > The pilot's improper approach to landing, and his delay in initiating a go-around.
- [NTSB CHI96LA274](https://openairdocs.org/ntsb/CHI96LA274.md): Beech 35 · Yankton, SD · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N3392V · Substantial damage
  > an improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…
- [NTSB CHI96LA266](https://openairdocs.org/ntsb/CHI96LA266.md): Cessna 404 · Benton Harbor, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1996 · N8919G · Destroyed
  > the pilot's delay in initiating a go-around after not attaining the proper touchdown point during the landing, and his failure to remain clear of obstructions (trees) during the go-around. Factors relating to the accident were the adverse weather condition…
- [NTSB CHI96LA267](https://openairdocs.org/ntsb/CHI96LA267.md): Yakovlev YAK-3UA · Fond Du Lac, WI · Accident · No injuries · Limited investigation · Final report · Aug 1, 1996 · N33UA · Substantial damage
  > the pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.
- [NTSB MIA96LA198](https://openairdocs.org/ntsb/MIA96LA198.md): Cessna 210L · Sarasota, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1996 · N397MS · Substantial damage
  > the pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA96LA173](https://openairdocs.org/ntsb/SEA96LA173.md): Cessna 182G · Portland, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1996 · N3135S · Substantial damage
  > The pilot's failure to maintain a proper glide path above the MD-80's wake turbulence.
- [NTSB CHI96LA256](https://openairdocs.org/ntsb/CHI96LA256.md): Cessna 172M · Backus, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1996 · N1620V · Substantial damage
  > the pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.
- [NTSB NYC96FA157](https://openairdocs.org/ntsb/NYC96FA157.md): Cessna 182P · Brewer, ME · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1996 · N9920E · Destroyed
  > failure of the pilot to maintain control of the airplane, during a missed approach, after diverting to an alternate destination, while on his first solo flight in instrument meteorological conditions (IMC).
- [NTSB CHI96LA253](https://openairdocs.org/ntsb/CHI96LA253.md): Yasecko LONG-EZE · Waukesha, WI · Accident · No injuries · Limited investigation · Final report · Jul 24, 1996 · N303Y · Substantial damage
  > Failure of the throttle cable.
- [NTSB NYC96LA155](https://openairdocs.org/ntsb/NYC96LA155.md): Cessna 150G · Turner, ME · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1996 · N3269J · Substantial damage
  > the pilot's inadequate preflight inspection, by failing to remove the pitot tube cover, which resulted in false airspeed indications, and his failure to maintain adequate obstacle clearance from a utility pole.
- [NTSB MIA96LA193](https://openairdocs.org/ntsb/MIA96LA193.md): Cessna 210L · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Jul 22, 1996 · N1623X · Substantial damage
  > failure of the pilot (PIC) to ensure that an adequate preflight inspection was performed; a missing (or loose) fuel cap on the left wing; probable fuel siphoning; and fuel exhaustion, which resulted in a loss of engine power and a subsequent forced landing…
- [NTSB FTW96LA314](https://openairdocs.org/ntsb/FTW96LA314.md): Barton Sylkie 1 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Jul 22, 1996 · N711WB · Substantial damage
  > The pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.
- [NTSB ATL96LA112](https://openairdocs.org/ntsb/ATL96LA112.md): Cessna 180 · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Jul 22, 1996 · N3122C · Substantial damage
  > Inadequate annual inspection that resulted in the in-flight loss of the fuel system strainer and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.
- [NTSB FTW96LA312](https://openairdocs.org/ntsb/FTW96LA312.md): Cessna 182A · Skiatook, OK · Accident · No injuries · Limited investigation · Final report · Jul 21, 1996 · N2182G · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB FTW96LA328](https://openairdocs.org/ntsb/FTW96LA328.md): Cessna T210L · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N210RE · Substantial damage
  > the pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in fuel starvation before reaching the airport. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA249](https://openairdocs.org/ntsb/CHI96LA249.md): Cessna 172 · Emily, MN · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N7101T · Destroyed
  > the pilot misjudged his altitude and distance to the runway on final approach, and he failed to maintain obstacle clearance during landing. A factor relating to the accident was: the parked car.
- [NTSB CHI96LA248](https://openairdocs.org/ntsb/CHI96LA248.md): Cessna 182 · Rose Hill, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1996 · N5335B · Substantial damage
  > the worn carburetor, and inadequate inspection of the aircraft by other maintenance personnel.
- [NTSB IAD96LA120](https://openairdocs.org/ntsb/IAD96LA120.md): Cessna 172 · Stowe, VT · Accident · No injuries · Limited investigation · Final report · Jul 19, 1996 · N5091G · Destroyed
  > failure of the pilot to follow proper IFR procedures and to maintain proper terrain clearance (altitude) during an NDB approach. Factors related to the accident were: the pilot's lack of instrument experience, low ceiling, and mountainous terrain.
- [NTSB LAX96LA273](https://openairdocs.org/ntsb/LAX96LA273.md): Bellanca 8GCBC · Pacoima, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1996 · N87107 · Destroyed
  > a total loss of engine power for undetermined reasons.
- [NTSB CHI96LA244](https://openairdocs.org/ntsb/CHI96LA244.md): Cessna 150L · Versailles, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1996 · N11303 · Substantial damage
  > the student pilot's failure to maintain airplane control during a go-around.
- [NTSB ANC96FA099](https://openairdocs.org/ntsb/ANC96FA099.md): Rotorway Exec 90 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1996 · N9297H · Destroyed
  > the pilot's excessive control inputs and the lack of familiarity with the helicopter. A factor associated with the accident was the pilot's failure to follow the prescribed operating limitations.
- [NTSB IAD96LA117](https://openairdocs.org/ntsb/IAD96LA117.md): Beech A100 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Jul 15, 1996 · N4391W · Substantial damage
  > The pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.
- [NTSB CHI96LA242](https://openairdocs.org/ntsb/CHI96LA242.md): Bellanca 7ECA · Belle Plaine, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1996 · N5026K · Substantial damage
  > the pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.
- [NTSB FTW96LA306](https://openairdocs.org/ntsb/FTW96LA306.md): Smith RV4 · Mandeville, AR · Accident · No injuries · Limited investigation · Final report · Jul 14, 1996 · N83FS · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB SEA96LA154](https://openairdocs.org/ntsb/SEA96LA154.md): Colonial C-1 · Halls Crossing, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1996 · N248B · Substantial damage
  > the pilot's inadequate preflight of the airplane, and subsequent fuel exhaustion due to an inadequate supply of fuel, which resulted in loss of engine power and an emergency landing. Uneven terrain in the emergency landing area was a related factor.
- [NTSB FTW96LA302](https://openairdocs.org/ntsb/FTW96LA302.md): Piper PA-32RT-300T · Rogers, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1996 · N810EM · Substantial damage
  > fuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA234](https://openairdocs.org/ntsb/CHI96LA234.md): Cessna 172L · Vicksburg, MI · Accident · No injuries · Limited investigation · Final report · Jul 11, 1996 · N7545G · Substantial damage
  > the pilot's premature raising of the flaps during a go-around. The presence of birds was a factor.
- [NTSB SEA96LA149](https://openairdocs.org/ntsb/SEA96LA149.md): Cessna 152 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N4897P · Substantial damage
  > the student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.
- [NTSB MIA96LA178](https://openairdocs.org/ntsb/MIA96LA178.md): Cessna 140 · Holt, FL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N2102N · Substantial damage
  > Loss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.
- [NTSB CHI96LA233](https://openairdocs.org/ntsb/CHI96LA233.md): Cessna 172 · Freeport, IL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1996 · N5542R · Substantial damage
  > The pilot's misjudgment of altitude and distance on final approach, and his failure to attain the proper touchdown point for landing.
- [NTSB FTW96LA294](https://openairdocs.org/ntsb/FTW96LA294.md): O'Day Sonerai II-LS · Friendswood, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1996 · N30155 · Substantial damage
  > a loss of engine power for undetermined reasons, and the pilot's failure to attain the proper traffic pattern altitude on the downwind leg prior to turning the base leg.
- [NTSB LAX96LA266](https://openairdocs.org/ntsb/LAX96LA266.md): Cessna 150J · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1996 · N50814 · Substantial damage
  > Fuel starvation due to the pilot's failure to monitor and correctly configure the fuel system for landing prior to entering the traffic pattern, and the pilot's premature lowering of full flaps which led to the runway undershoot. A factor in the accident was…
- [NTSB SEA96LA143](https://openairdocs.org/ntsb/SEA96LA143.md): Taylorcraft BC12-D · Sun Valley, ID · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1996 · N95658 · Substantial damage
  > the pilot's inadequate compensation for wind conditions and failure to obtain/maintain adequate airspeed for the go-around. The crosswind, downdraft, and high density altitude were related factors.
- [NTSB NYC96LA142](https://openairdocs.org/ntsb/NYC96LA142.md): Cessna 152 · Greenwood Lake, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1996 · N6137H · Substantial damage
  > failure of the pilot to maintain adequate airspeed, during the approach/go-around, which resulted in an inadvertent stall and collision with the terrain.
- [NTSB LAX96LA262](https://openairdocs.org/ntsb/LAX96LA262.md): Ryan ST3KR · Santa Paula, CA · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 1996 · N57017 · Destroyed
  > a partial loss of engine power for undetermined reasons and the pilot's failure to maintain control of the airplane while maneuvering toward the runway following the power loss.
- [NTSB CHI96LA229](https://openairdocs.org/ntsb/CHI96LA229.md): Hewitt Cassutt 3M · Vermillion, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1996 · N290E · Substantial damage
  > the failure of the unapproved fuel pump.
- [NTSB MIA96LA174](https://openairdocs.org/ntsb/MIA96LA174.md): Beech 58 · Kinston, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1996 · N23806 · Substantial damage
  > failure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.
- [NTSB NYC96LA139](https://openairdocs.org/ntsb/NYC96LA139.md): Titan Tornado · Richland, NY · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 1996 · UNREG · Destroyed
  > failure of the student pilot to maintain adequate airspeed, during an apparent go-around, which resulted in an inadvertent stall and subsequent collision with the terrain. Factors relating to the accident were: the pilot's lack of certification, and…
- [NTSB FTW96TA289](https://openairdocs.org/ntsb/FTW96TA289.md): Cessna 182RG · Broomfield, CO · Accident · Minor injuries · Final report · Jul 2, 1996 · N4314R · Substantial damage
  > failure of the pilot to maintain directional control and runway alignment during a go-around, and the lack of power response from the engine for undetermined reason(s). The sudden wind shift was a related factor.
- [NTSB FTW96FA288](https://openairdocs.org/ntsb/FTW96FA288.md): Air Tractor AT-400 · Huffman, TX · Accident · 1 fatal · Field investigation · Final report · Jul 2, 1996 · N501JS · Substantial damage
  > corroded flight control components, due to the operator's inadequate maintenance and inspection of the airplane; the pilot's failure to follow procedures and directives, by flying the airplane without proper maintenance and annual inspection; and subsequent…
- [NTSB CHI96LA226](https://openairdocs.org/ntsb/CHI96LA226.md): Bellanca 17-30 Viking · Alexandria, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1996 · N838MM · Substantial damage
  > the flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.