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

## Cases, newest first

- [NTSB NYC04LA016](https://openairdocs.org/ntsb/NYC04LA016.md): Cessna 210N · Swanton, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 2003 · N5452V · Substantial damage
  > The pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.
- [NTSB MIA04LA012](https://openairdocs.org/ntsb/MIA04LA012.md): Headburg RV6 · Wellington, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N331JH · Substantial damage
  > the failure of the dual student pilot to maintain airspeed, and the CFI to properly supervise the dual student, which resulted in an inadvertent stall, and subsequent impact with an embankment, during a simulated loss of engine power.
- [NTSB LAX04LA028](https://openairdocs.org/ntsb/LAX04LA028.md): Mooney M20K · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2003 · N1147N · Destroyed
  > the pilot's failure to configure the airplane properly for the go-around which resulted in degraded climb performance, and his failure to maintain adequate airspeed which resulted in a stall. The tailwind was a contributing factor.
- [NTSB LAX04LA025](https://openairdocs.org/ntsb/LAX04LA025.md): Piper PA-28R-200 · Pacoima, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 2003 · N15192 · Substantial damage
  > the pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.
- [NTSB MIA04LA011](https://openairdocs.org/ntsb/MIA04LA011.md): Let NP Kinovice Z37A · Oak Hill, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 2003 · N137MS · Substantial damage
  > The pilots failure to maintain airspeed while maneuvering to re-enter the pattern resulting in an inadvertent stall and impact with trees and the ground during the subsequent uncontrolled descent.
- [NTSB CHI04IA018](https://openairdocs.org/ntsb/CHI04IA018.md): Enstrom F-28C · Lapeer, MI · Incident · No injuries · Incident investigation · Final report · Oct 22, 2003 · N77HX · Minor damage
  > Complete failure of the right anti-torque cable while on final approach for landing. A factor was the diminished tail rotor control resulting from the broken cable.
- [NTSB NYC04LA014](https://openairdocs.org/ntsb/NYC04LA014.md): Cessna 182G · Athol, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2003 · N3419S · Substantial damage
  > The loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.
- [NTSB LAX04FA019](https://openairdocs.org/ntsb/LAX04FA019.md): Beech 35-C33 · Mesquite, NV · Accident · 2 fatal · Field investigation · Final report · Oct 19, 2003 · N9438S · Destroyed
  > fuel starvation due to the pilot's inadequate in-flight planning and fuel system management, and failure to select a fuel tank containing fuel. Also causal was the certified flight instructor's inadequate supervision.
- [NTSB SEA04LA008](https://openairdocs.org/ntsb/SEA04LA008.md): Luscombe 8E · Spanaway, WA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 2003 · N1806K · Substantial damage
  > The pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.
- [NTSB LAX04TA017](https://openairdocs.org/ntsb/LAX04TA017.md): MD Helicopter 900 · Fredonia, AZ · Accident · No injuries · Final report · Oct 16, 2003 · N179PA · Substantial damage
  > the pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.
- [NTSB CHI04LA014](https://openairdocs.org/ntsb/CHI04LA014.md): Croke Zenith CH 701 · Brussels, WI · Accident · No injuries · Limited investigation · Final report · Oct 16, 2003 · N701US · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB LAX04TA018](https://openairdocs.org/ntsb/LAX04TA018.md): Bell UH-1H · Sacramento, CA · Accident · No injuries · Final report · Oct 15, 2003 · N114FD · Substantial damage
  > The loss of engine power due to the fatigue failure of a planetary reduction gear.
- [NTSB FTW04LA008](https://openairdocs.org/ntsb/FTW04LA008.md): Cessna 172H · Manvel, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2003 · N3760R · Substantial damage
  > The pilot's failure to maintain airspeed during the attempted go-around resulting in an inadvertent stall. A contributing factor was the pilot's failure to maintain directional control during the crosswind landing.
- [NTSB NYC04LA007](https://openairdocs.org/ntsb/NYC04LA007.md): Piper PA-28-180 · Cheswold, DE · Accident · 1 fatal · Limited investigation · Final report · Oct 12, 2003 · N5320L · Substantial damage
  > The pilot's failure to maintain a proper glide path to the runway, and his failure to maintain obstacle clearance which resulted in an in-flight collision with an unlit utility pole. Factors related to the accident were the unlit utility pole, and the dark…
- [NTSB DEN04LA009](https://openairdocs.org/ntsb/DEN04LA009.md): Piper PA-28-140 · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Oct 12, 2003 · N891GP · Substantial damage
  > the CFI's failure to maintain aircraft control during a go-around resulting in an inadvertent stall/mush and impact with terrain. Contributing factors include the CFI's inadequate supervision, the private pilot's delayed relinquishing of control, and the…
- [NTSB DEN04LA007](https://openairdocs.org/ntsb/DEN04LA007.md): Aviat Pitts S2B · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Oct 11, 2003 · N331DM · Substantial damage
  > the instructor's improper in-flight planning/decision making and fuel mismanagement which resulted in fuel starvation/exhaustion, the loss of engine power and the subsequent forced landing. Contributing factors include the instructor's inadequate preflight…
- [NTSB NYC04CA009](https://openairdocs.org/ntsb/NYC04CA009.md): Cessna 182C · Clarence Center, NY · Accident · No injuries · Data collection · Final report · Oct 10, 2003 · N8511T · Substantial damage
  > The pilot's delayed go-around decision. A factor in this accident was the night light condition.
- [NTSB CHI04LA008](https://openairdocs.org/ntsb/CHI04LA008.md): Ercoupe 415-D · Harvard, IL · Accident · No injuries · Limited investigation · Final report · Oct 10, 2003 · N3848H · Substantial damage
  > The pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…
- [NTSB FTW04FA006](https://openairdocs.org/ntsb/FTW04FA006.md): Twin Commander Acft. 680FL · Harrison, AR · Accident · Serious injuries · Field investigation · Final report · Oct 8, 2003 · N680WS · Destroyed
  > The loss of power to both engines due to fuel starvation as a result of the pilot's failure to complete the landing checklist while on final approach. A factor contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB ATL04LA003](https://openairdocs.org/ntsb/ATL04LA003.md): Whitty Mustang II · Holly Ridge, NC · Accident · 1 fatal · Limited investigation · Final report · Oct 3, 2003 · N888PW · Substantial damage
  > The loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed while maneuvering for a forced landing.
- [NTSB LAX03LA302](https://openairdocs.org/ntsb/LAX03LA302.md): Piper PA-34-220T · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Oct 1, 2003 · N4167B · Substantial damage
  > The pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…
- [NTSB SEA03CA200](https://openairdocs.org/ntsb/SEA03CA200.md): Piper PA-18-150 · Basin City, WA · Accident · No injuries · Data collection · Final report · Sep 30, 2003 · N4451Z · Substantial damage
  > Clearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.
- [NTSB LAX03LA290](https://openairdocs.org/ntsb/LAX03LA290.md): Cessna 172RG · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Sep 30, 2003 · N9564B · Substantial damage
  > the failure of the right main landing gear pivot assembly.
- [NTSB SEA03LA196](https://openairdocs.org/ntsb/SEA03LA196.md): Beech T-34 (A-45) · McCall, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 2003 · N234KC · Substantial damage
  > The inadequacy of the pilot's remedial action taken in an attempt to fly out of an encounter with the wake vortex turbulence created by a preceding aircraft while on short final to land. Factors include calm winds in the area of the final approach course, and…
- [NTSB CHI03LA323](https://openairdocs.org/ntsb/CHI03LA323.md): Cessna 150L · Siloam Springs, AR · Accident · No injuries · Limited investigation · Final report · Sep 28, 2003 · N21915 · Substantial damage
  > A loss of engine power due to the pilot's inadequate planning/decision resulting in fuel exhaustion. Factors were the trees and the night conditions.
- [NTSB NYC03FA205](https://openairdocs.org/ntsb/NYC03FA205.md): Cessna 182T · Concord, MA · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2003 · N963LP · Destroyed
  > The pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.
- [NTSB NYC03FA203](https://openairdocs.org/ntsb/NYC03FA203.md): Cessna 402C · Nantucket, MA · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2003 · N405BK · Substantial damage
  > The pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.
- [NTSB LAX03CA299](https://openairdocs.org/ntsb/LAX03CA299.md): Cessna 150F · Reedley, CA · Accident · No injuries · Data collection · Final report · Sep 22, 2003 · N3093X · Substantial damage
  > the pilot's failure to maintain the proper glide path and airspeed during final, which resulted in an inadvertent stall/mush.
- [NTSB ATL03LA145](https://openairdocs.org/ntsb/ATL03LA145.md): Cessna 180 · Pavo, GA · Accident · No injuries · Limited investigation · Final report · Sep 21, 2003 · N2807A · Substantial damage
  > The pilot's failure to maintain airspeed, resulting in an inadvertent stall.
- [NTSB DEN03LA154](https://openairdocs.org/ntsb/DEN03LA154.md): Bellanca 7ECA · Byers, CO · Accident · No injuries · Limited investigation · Final report · Sep 20, 2003 · N41698 · Substantial damage
  > The pilot not maintaining adequate clearance from the ground and his improper in-flight planning/decision. Factors contributing to the accident were the tailwind, the low altitude, the tree, the people, the embankment, and the ravine.
- [NTSB ANC03LA117](https://openairdocs.org/ntsb/ANC03LA117.md): Piper PA-18 · Ninilchick, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 2003 · N6978B · Substantial damage
  > The pilot's failure to maintain control of the airplane which resulted in a collision with terrain during an approach to landing on a ridgeline. Factors contributing to the accident were the pilot's inadequate evaluation of the wind conditions, and an…
- [NTSB NYC03LA201](https://openairdocs.org/ntsb/NYC03LA201.md): Raytheon B36TC · Batavia, OH · Accident · No injuries · Limited investigation · Final report · Sep 16, 2003 · N3212D · Substantial damage
  > A loss of engine power during an approach for undetermined reasons.
- [NTSB FTW03FA225](https://openairdocs.org/ntsb/FTW03FA225.md): Cessna 310J · New Orleans, LA · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2003 · N2010E · Destroyed
  > The pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.
- [NTSB ATL03LA138](https://openairdocs.org/ntsb/ATL03LA138.md): Great Lakes 2T-1A-2 · Seymour, TN · Accident · No injuries · Limited investigation · Final report · Sep 15, 2003 · N22TE · Substantial damage
  > The pilot's failure to maintain clearance during the final approach to land which resulted in an inflight collision with a tree.
- [NTSB FTW03LA220](https://openairdocs.org/ntsb/FTW03LA220.md): Cessna 172M · Ardmore, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 2003 · N9651Q · Substantial damage
  > The failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.
- [NTSB NYC03LA198](https://openairdocs.org/ntsb/NYC03LA198.md): Mooney M20A · Rockford, OH · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 2003 · N1072B · Destroyed
  > The pilot's failure to maintain the proper altitude/clearance, which resulted in an in-flight collision with a utility wire. The owner's improper decision to allow the airplane to be operated by an uncertificated pilot was also causal.
- [NTSB LAX03LA283](https://openairdocs.org/ntsb/LAX03LA283.md): Cessna 210L · Monterey, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 2003 · N93860 · Substantial damage
  > The pilot’s inadequate in-flight planning/decision, which resulted in a loss of engine power during an instrument approach to land, and an in-flight collision with a tree and terrain.
- [NTSB DEN03LA150](https://openairdocs.org/ntsb/DEN03LA150.md): Cessna 182A · Pine Haven, WY · Accident · No injuries · Limited investigation · Final report · Sep 7, 2003 · N6384B · Substantial damage
  > The loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.
- [NTSB DEN03LA149](https://openairdocs.org/ntsb/DEN03LA149.md): Cessna 150J · Farmington, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2003 · N60571 · Substantial damage
  > the pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…
- [NTSB ANC03CA109](https://openairdocs.org/ntsb/ANC03CA109.md): Maule M-6-235 · Kenai, AK · Accident · No injuries · Data collection · Final report · Sep 6, 2003 · N4564B · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance during an intentional go-around, which resulted in an in-flight collision with trees.
- [NTSB NYC03LA195](https://openairdocs.org/ntsb/NYC03LA195.md): Piper PA-28-140 · Somerville, NJ · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 2003 · N6183J · Substantial damage
  > The pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.
- [NTSB CHI03FA291](https://openairdocs.org/ntsb/CHI03FA291.md): Beech B36TC · Uniondale, IN · Accident · 3 fatal · Field investigation · Final report · Sep 2, 2003 · N8018J · Destroyed
  > The pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…
- [NTSB SEA03LA182](https://openairdocs.org/ntsb/SEA03LA182.md): Pitts S-2A · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2003 · N5301W · Destroyed
  > The pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.
- [NTSB LAX03LA273](https://openairdocs.org/ntsb/LAX03LA273.md): Piper PA-46-350P · North Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2003 · N103TK · Substantial damage
  > the pilot's failure to maintain an adequate airspeed during approach for the airplane's flight configuration, which resulted in an inadvertent stall and impact with terrain.
- [NTSB LAX03CA272](https://openairdocs.org/ntsb/LAX03CA272.md): Cessna 182J · Marble Canyon, AZ · Accident · No injuries · Data collection · Final report · Aug 31, 2003 · N2898F · Substantial damage
  > the failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.
- [NTSB LAX03LA270](https://openairdocs.org/ntsb/LAX03LA270.md): Beech K35 · Gerlach, NV · Accident · 1 fatal · Limited investigation · Final report · Aug 30, 2003 · N5343E · Substantial damage
  > the pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.
- [NTSB NYC03LA184](https://openairdocs.org/ntsb/NYC03LA184.md): Piper PA-38-112 · Pawtucket, RI · Accident · No injuries · Limited investigation · Final report · Aug 29, 2003 · N2550A · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI03FA296](https://openairdocs.org/ntsb/CHI03FA296.md): Beech 58P · Grand Marais, MN · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2003 · N285V · Destroyed
  > The continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.
- [NTSB SEA03FA173](https://openairdocs.org/ntsb/SEA03FA173.md): Piper PA-32R-300 · Warm Lake, ID · Accident · 2 fatal · Field investigation · Final report · Aug 26, 2003 · N6126J · Destroyed
  > The pilot's failure to maintain adequate airspeed during final approach resulting in a stall/spin. Contributing factors were the rapidly rising terrain and trees.
- [NTSB NYC03FA180](https://openairdocs.org/ntsb/NYC03FA180.md): Aero Vodochody L-39ZO · Forest Hill, MD · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2003 · N298RD · Destroyed
  > The pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…

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

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

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