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

## Cases, newest first

- [NTSB FTW92LA081](https://openairdocs.org/ntsb/FTW92LA081.md): Cameron 084 · Maumelle, AR · Accident · No injuries · Limited investigation · Final report · Mar 7, 1992 · N6008J · Destroyed
  > The pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.
- [NTSB BFO92FA032](https://openairdocs.org/ntsb/BFO92FA032.md): Piper PA-23-250 · Sandston, VA · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1992 · N100LC · Destroyed
  > The pilot's improper in-flight planning/decision failure to follow the missed approach procedure.
- [NTSB BFO92FA031](https://openairdocs.org/ntsb/BFO92FA031.md): Cessna 210K · Frederick, MD · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1992 · N8104G · Destroyed
  > The pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.
- [NTSB DEN92FA040](https://openairdocs.org/ntsb/DEN92FA040.md): Mitsubishi MU-2B-60 · New Castle, CO · Accident · 6 fatal · Field investigation · Final report · Mar 5, 1992 · N303CA · Destroyed
  > An inadvertent stall during an instrument approach with the autopilot engaged. A factor was: the pilot's physical impairment from a prescription drug.
- [NTSB FTW92LA096](https://openairdocs.org/ntsb/FTW92LA096.md): Burnett Teenie II · Edmond, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 1992 · N5749 · Substantial damage
  > Partial engine power loss due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW92LA074](https://openairdocs.org/ntsb/FTW92LA074.md): Cessna 172F · Mc Alester, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1992 · N5499R · Substantial damage
  > Inadvertent stall. A factor was a total power loss due to fuel exhaustion.
- [NTSB FTW92LA075](https://openairdocs.org/ntsb/FTW92LA075.md): Bell 206B III · Grand Isle · Accident · No injuries · Limited investigation · Final report · Feb 26, 1992 · N2750F · Substantial damage
  > Heavy sea state due to the high winds. A factor was the power loss.
- [NTSB ATL92FA049](https://openairdocs.org/ntsb/ATL92FA049.md): Beech H-18 · Morganton, NC · Accident · 1 fatal · Field investigation · Final report · Feb 26, 1992 · N347G · Destroyed
  > The failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.
- [NTSB NYC92FA067](https://openairdocs.org/ntsb/NYC92FA067.md): Cessna 310K · Unionville, PA · Accident · 1 fatal · Field investigation · Final report · Feb 25, 1992 · N6928L · Destroyed
  > The pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…
- [NTSB LAX92FA121](https://openairdocs.org/ntsb/LAX92FA121.md): Grumman American AA1B · Agua Dulce, CA · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1992 · N9066L · Destroyed
  > The pilot's abrupt aircraft control and failure to maintain airspeed. Contributing to this accident was the inadvertent stall/spin.
- [NTSB NYC92LA063](https://openairdocs.org/ntsb/NYC92LA063.md): Cessna 150D · Moneta, VA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1992 · N4373U · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during landing with a crosswind.
- [NTSB ATL92LA048](https://openairdocs.org/ntsb/ATL92LA048.md): Piper PA32-300 · Hickory, NC · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1992 · N332DD · Substantial damage
  > While on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…
- [NTSB ATL92FA047](https://openairdocs.org/ntsb/ATL92FA047.md): Piper PA-28R-200 · Raleigh, NC · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1992 · N33464 · Substantial damage
  > The failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.
- [NTSB NYC92FA062](https://openairdocs.org/ntsb/NYC92FA062.md): Cessna 150 · White Lake, NY · Accident · 1 fatal · Field investigation · Final report · Feb 16, 1992 · N6559F · Substantial damage
  > The pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…
- [NTSB DCA92MA022](https://openairdocs.org/ntsb/DCA92MA022.md): Douglas DC-8-63 · Swanton, OH · Accident · 4 fatal · Major investigation · Final report · Feb 15, 1992 · N794AL · Destroyed
  > The failure of the flightcrew to properly recognize or recover in a timely manner from the unusual aircraft attitude that resulted from the captain's apparent spatial disorientation, resulting from physiological factors and/or a failed attitude director…
- [NTSB ATL92LA044](https://openairdocs.org/ntsb/ATL92LA044.md): Cessna 152 · Macon, GA · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1992 · N89071 · Substantial damage
  > The improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.
- [NTSB ANC92LA035](https://openairdocs.org/ntsb/ANC92LA035.md): Piper PA-18A-150 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1992 · N3877P · Substantial damage
  > The pilot's misjudgment of the fuel consumption of the airplane; thereby exhausting the fuel supply prematurely. Factor relating to the accident was the lack of a suitable forced landing area.
- [NTSB MIA92FA085](https://openairdocs.org/ntsb/MIA92FA085.md): Cessna 425 · Lakeland, FL · Accident · 1 fatal · Field investigation · Final report · Feb 11, 1992 · N66LM · Substantial damage
  > Loss of control in flight by the pilot for undetermined reasons.
- [NTSB MIA92LA084](https://openairdocs.org/ntsb/MIA92LA084.md): Piper PA-28-161 · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · Feb 10, 1992 · N20974 · Substantial damage
  > Improper weather evaluation by the pilot in command resulting in the in flight encounter with fog during the downdwind leg shortly after takeoff to remain in the traffic pattern.
- [NTSB MIA92LA082](https://openairdocs.org/ntsb/MIA92LA082.md): Burch Rotorway Exec · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Feb 9, 1992 · N618VN · Substantial damage
  > The pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing. This resulted in a hard landing, collision of the main rotor blades with the tailboom, and subsequent roll over of the helicopter. Contributing…
- [NTSB MIA92LA078](https://openairdocs.org/ntsb/MIA92LA078.md): American AA-1 · Leesburg, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 1992 · N6222L · Substantial damage
  > The pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an in flight loss of control (stall) and in flight collision with terrain. Contributing to the accident was the pilot-in-command's inadequate…
- [NTSB DEN92LA031](https://openairdocs.org/ntsb/DEN92LA031.md): Maule M-5-235C · Durango, CO · Accident · No injuries · Limited investigation · Final report · Feb 9, 1992 · N5637W · Substantial damage
  > The pilot's failure to maintain directional control. A factor was: crosswind.
- [NTSB ANC92LA033](https://openairdocs.org/ntsb/ANC92LA033.md): Stinson 108-2 · Cube Cove, AK · Accident · 1 fatal · Limited investigation · Final report · Feb 9, 1992 · N905D · Substantial damage
  > The encounter of windshear during the final approach and the pilot's improper in flight planning and decisions by electing to land downwind. Factor in this accident was the rough and uneven terrain.
- [NTSB NYC92LA056](https://openairdocs.org/ntsb/NYC92LA056.md): Beech 95 · Caldonia, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1992 · N986T · Substantial damage
  > The pilot's improper use of carburetor heat which resulted in a loss of engine power. A factor relating to the accident was weather conducive to carburetor icing.
- [NTSB ANC92LA034](https://openairdocs.org/ntsb/ANC92LA034.md): Cessna 150 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Feb 8, 1992 · N8620S · Substantial damage
  > The pilot misjudged the altitude necessary for terrain clearance on the final approach. Factors which contributed to the accident were the snowbank and the dusk lighting conditions.
- [NTSB CHI92DCD02](https://openairdocs.org/ntsb/CHI92DCD02.md): Quad City Challenger · Blakesburg, IA · Accident · Minor injuries · Final report · Feb 7, 1992 · UNREG · Destroyed
  > Failure of the pilot to maintain aircraft control during final approach. Weather conditions, high wind and turbulence, were factors in the accident.
- [NTSB FTW92LA066](https://openairdocs.org/ntsb/FTW92LA066.md): Cessna 172RG · Waco, TX · Accident · No injuries · Limited investigation · Final report · Feb 4, 1992 · N9754B · Substantial damage
  > The pilot's failure to fully extend the landing gear by the alternate gear extention system. Factors were the dark night, low ceiling, fog, drizzle and failure of the electrical system.
- [NTSB ANC92LA032](https://openairdocs.org/ntsb/ANC92LA032.md): De Havilland DHC-3 · Metlakatla, AK · Accident · No injuries · Limited investigation · Final report · Feb 4, 1992 · N13GA · Substantial damage
  > Total failure of the rivets attaching the trim tab control horn to the right elevator trim tab.
- [NTSB ANC92LA031](https://openairdocs.org/ntsb/ANC92LA031.md): Piper PA-32-300 · Tununak, AK · Accident · No injuries · Limited investigation · Final report · Feb 4, 1992 · N76RL · Substantial damage
  > Misjudged wind information. Factors to the accident were: turbulence, crosswind and flight into known adverse weather.
- [NTSB FTW92LA065](https://openairdocs.org/ntsb/FTW92LA065.md): Cessna 150L · Searcy, AR · Accident · No injuries · Limited investigation · Final report · Feb 2, 1992 · N11567 · Substantial damage
  > The pilot's improper use of carburetor heat resulting in the loss of engine power due to carburetor ice. The carburetor icing conditions and the soft terrain in the landing area were factors.
- [NTSB FTW92DQA01](https://openairdocs.org/ntsb/FTW92DQA01.md): Air Trans. White Lightning · Aztec, NM · Accident · 1 fatal · Final report · Jan 31, 1992 · N121WE · Destroyed
  > The inadvertent stall and the pilot's lack of experience in the accident aircraft.
- [NTSB FTW92LA062](https://openairdocs.org/ntsb/FTW92LA062.md): Bell 206L-3 · E.I. Blk 108 · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1992 · N65603 · Substantial damage
  > The pilot's failure to maintain altitude above the water. Factors were the pilot attempting flight into known adverse weather conditions of fog and low ceilings during dawn light conditions.
- [NTSB BFO92LA026](https://openairdocs.org/ntsb/BFO92LA026.md): Piper PA-28-161 · East Taunton, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 29, 1992 · N8379N · Destroyed
  > Inadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.
- [NTSB LAX92LA104](https://openairdocs.org/ntsb/LAX92LA104.md): Cessna 150H · Ft Mojave, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1992 · N23455 · Substantial damage
  > An inadequate annual inspection performed by other maintenance personnel. Contributing to this accident was the flap cable failure due to corrosion.
- [NTSB LAX92LA101](https://openairdocs.org/ntsb/LAX92LA101.md): Piper PA-31P · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Jan 25, 1992 · N7325L · Substantial damage
  > The pilot's failure to assure that there was an adequate supply of fuel in the airplane to complete the flight due to alcoholic impairment of efficiency and judgement resulting in a total loss of power of both engines.
- [NTSB MIA92LA063](https://openairdocs.org/ntsb/MIA92LA063.md): Beech 58 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 12, 1992 · N4188S · Substantial damage
  > Partial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.
- [NTSB BFO92LA016](https://openairdocs.org/ntsb/BFO92LA016.md): Piper PA-28-151 · Mount Holly, NJ · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1992 · N3906F · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI92FA067](https://openairdocs.org/ntsb/CHI92FA067.md): Beech A-36TC · Pekin, IL · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1992 · N345CC · Destroyed
  > The pilot-in-command's continued flight into icing conditions and his failure to use the airplane's anti-ice/de-ice system resulting in a build-up of ice over the airplane's surface area and resultant loss of control. Factors which contributed to the accident…
- [NTSB SEA92LA035](https://openairdocs.org/ntsb/SEA92LA035.md): Piper PA-28-140 · Newberg, OR · Accident · Serious injuries · Limited investigation · Final report · Jan 4, 1992 · N7491R · Substantial damage
  > A poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.
- [NTSB BFO92LA015](https://openairdocs.org/ntsb/BFO92LA015.md): Piper PA-38-112 · Wadsworth, OH · Accident · No injuries · Limited investigation · Final report · Jan 4, 1992 · N2587L · Substantial damage
  > Failure of the pilot to attain an adequate airspeed during an attempted go around, which resulted in a stall. His premature raising of the flaps and lack of experience in the make and model of aircraft were related factors.
- [NTSB DCA92MA016](https://openairdocs.org/ntsb/DCA92MA016.md): Beech 1900C · Gabriels, NY · Accident · 2 fatal · Major investigation · Final report · Jan 3, 1992 · N55000 · Destroyed
  > Failure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…
- [NTSB MIA92LA055](https://openairdocs.org/ntsb/MIA92LA055.md): Cessna 182Q · Eustis, FL · Accident · No injuries · Limited investigation · Final report · Jan 2, 1992 · N7582S · Substantial damage
  > The pilot misjudged altitude and distance resulting in undershooting the landing. Contributing to the acident was the dark night condition.
- [NTSB LAX92LA075](https://openairdocs.org/ntsb/LAX92LA075.md): Piper PA601P · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Jan 1, 1992 · N680JM · Substantial damage
  > The pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…
- [NTSB CHI92LA064](https://openairdocs.org/ntsb/CHI92LA064.md): Cessna 182K · Huntington, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1991 · N2859R · Destroyed
  > Pilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…
- [NTSB BFO92FA013](https://openairdocs.org/ntsb/BFO92FA013.md): Piper PA-60-601P · North Salem, NY · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1991 · N36362 · Destroyed
  > A loss of control due to a distraction caused by a partial loss of power. Contributing to the accident was adverse weather near the destination airport.
- [NTSB NYC92FA053](https://openairdocs.org/ntsb/NYC92FA053.md): Beech 1900C · Block Island, RI · Accident · 3 fatal · Class 1 · Field · Final report · Dec 29, 1991 · N811BE · Destroyed
  > The instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…
- [NTSB SEA92LA033](https://openairdocs.org/ntsb/SEA92LA033.md): Cessna 182B · Toledo, WA · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1991 · N2471G · Substantial damage
  > The pilot's failure to maintain a proper glidepath.
- [NTSB MIA92FA053](https://openairdocs.org/ntsb/MIA92FA053.md): Cessna 172RG · Melbourne, FL · Accident · Serious injuries · Field investigation · Final report · Dec 28, 1991 · N9718B · Substantial damage
  > The flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…
- [NTSB SEA92LA031](https://openairdocs.org/ntsb/SEA92LA031.md): Piper PA-24-250 · Missoula, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1991 · N6408P · Substantial damage
  > The pilot's poor in-flight decision, failure to perform a missed approach, and improper altitude. Factors include poor preflight planning/preparation, and weather conditions below approach minimums.
- [NTSB MIA92LA052](https://openairdocs.org/ntsb/MIA92LA052.md): Piper PA-28-150 · Fayetteville, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1991 · N5583W · Substantial damage
  > The pilot-in-command's failure to perform an adequate preflight in that he failed to assure adequate fuel for the flight was available. Contributing to the accident was the unsuitable terrain encountered during the forced landing.

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

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

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