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

## Cases, newest first

- [NTSB DEN02LA071](https://openairdocs.org/ntsb/DEN02LA071.md): Cessna T206H · Jackson, WY · Accident · No injuries · Limited investigation · Final report · Jul 6, 2002 · N2453V · Substantial damage
  > the engine failure for undetermined reasons and the pilot's failure to maintain aircraft control during the forced landing attempt. A factor contributing to the accident was the inadvertent stall.
- [NTSB IAD02LA071](https://openairdocs.org/ntsb/IAD02LA071.md): Burkhart Grob G103 Twin Astir · Unionville, PA · Accident · No injuries · Limited investigation · Final report · Jul 5, 2002 · N4446W · Substantial damage
  > The pilot's evasive maneuver to avoid a collision with a departing airplane, which resulted in a landing short of the runway. A factor was the pilot's decision to land on the runway opposite the one in use.
- [NTSB MIA02LA121](https://openairdocs.org/ntsb/MIA02LA121.md): Kenneth Parmerter Loehle 5151 Mustang · Lake Placid, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 2002 · UNREG · Substantial damage
  > The pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…
- [NTSB SEA02LA128](https://openairdocs.org/ntsb/SEA02LA128.md): Taylorcraft F19 · Heron, MT · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2002 · N374D · Substantial damage
  > The pilot's failure to maintain vertical clearance from trees. Factors include tall trees just off the approach end of the runway.
- [NTSB MIA02LA125](https://openairdocs.org/ntsb/MIA02LA125.md): Mooney M20R · Mt. Pleasant, SC · Accident · No injuries · Limited investigation · Final report · Jul 2, 2002 · N2043N · Substantial damage
  > The pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.
- [NTSB DEN02LA064](https://openairdocs.org/ntsb/DEN02LA064.md): Beech 35 · Cortez, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2002 · N404B · Substantial damage
  > an inadvertent stall as the pilot attempted to clear a cliff and ravine and avoid power lines, resulting in a collision with the ground. Contributing factors were a loss of engine power for undetermined reasons, a leaking carburetor and fuel pump, and the…
- [NTSB FTW02LA191](https://openairdocs.org/ntsb/FTW02LA191.md): Beech BE-V35B · Baton Rouge, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 2002 · N1SU · Substantial damage
  > the loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL02LA135](https://openairdocs.org/ntsb/ATL02LA135.md): Cessna 172 · Perry, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2002 · N4406L · Substantial damage
  > The pilot's inadequate preflight inspection that resulted in fuel starvation due to fuel system contamination and the subsequent loss of engine power.
- [NTSB SEA02LA113](https://openairdocs.org/ntsb/SEA02LA113.md): Cessna 177 · Mt. Vernon, WA · Accident · No injuries · Limited investigation · Final report · Jun 26, 2002 · N29441 · Substantial damage
  > The pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.
- [NTSB SEA02LA111](https://openairdocs.org/ntsb/SEA02LA111.md): Rockwell S-2R Thrush · Winifred, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 2002 · N600DN · Substantial damage
  > The pilot's improper inflight decision to continue his aerial application flight after he realized the aircraft might be low on fuel. Factors include the pilot's failure to maintain clearance from a shed.
- [NTSB ANC02LA061](https://openairdocs.org/ntsb/ANC02LA061.md): Robinson R-44 · Shageluk, AK · Accident · No injuries · Limited investigation · Final report · Jun 26, 2002 · N144AK · Substantial damage
  > The pilot's failure to maintain a proper glide path. A factor associated with the accident was the pilot's diverted attention.
- [NTSB DEN02LA057](https://openairdocs.org/ntsb/DEN02LA057.md): Beech 58P · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Jun 24, 2002 · N94PB · Substantial damage
  > the pilot's failure to follow procedures for a balked landing which resulted in a stall/mush.
- [NTSB MIA02LA118](https://openairdocs.org/ntsb/MIA02LA118.md): Cessna 150D · Louisburg, NC · Accident · No injuries · Limited investigation · Final report · Jun 23, 2002 · N4313U · Substantial damage
  > the failure of the pilot-in-command to follow emergency procedures after smelling smoke that resulted in an electrical fire, damage to the airplane, and a forced landing.
- [NTSB LAX02LA208](https://openairdocs.org/ntsb/LAX02LA208.md): WSK PZL Swidnik PW-5 · Loch Lomand, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2002 · N115TM · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during final approach. A contributing factor was the windshear and turbulence encountered during the approach.
- [NTSB ANC02LA059](https://openairdocs.org/ntsb/ANC02LA059.md): Bellanca 7GCBC · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Jun 22, 2002 · N57391 · Substantial damage
  > The unqualified pilot's selection of an unsuitable landing site which resulted in an in-flight collision with a power line. Factors associated with the accident are the unqualified pilot's failure to see and avoid a power line, an unmarked power line, and…
- [NTSB MIA02LA116](https://openairdocs.org/ntsb/MIA02LA116.md): Navion Nav4 · Raleigh, NC · Accident · No injuries · Limited investigation · Final report · Jun 21, 2002 · N5235K · Substantial damage
  > the pilot's inadequate preflight planning, improper fuel consumption calculations, and selection of the auxiliary fuel tank for landing, which resulted in a loss of engine power due to fuel starvation, and forced landing in trees. A factor in this accident…
- [NTSB LAX02TA207](https://openairdocs.org/ntsb/LAX02TA207.md): Cessna 337C · Big Bear City, CA · Accident · No injuries · Final report · Jun 21, 2002 · N2671S · Destroyed
  > The loss of engine power due to fuel starvation.
- [NTSB SEA02LA107](https://openairdocs.org/ntsb/SEA02LA107.md): Cessna 172E · Troutdale, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 2002 · N5383T · Substantial damage
  > A loss of engine power for an undetermined (non-mechanical) reason. Contributing factors were high grass and soft terrain which lead to the collapse of the nose gear during the landing roll.
- [NTSB NYC02LA120](https://openairdocs.org/ntsb/NYC02LA120.md): Smith Kitfox Classic IV · Limerick, ME · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 2002 · N3023J · Substantial damage
  > The pilot's failure to perform a modification required by the manufacturer, which resulted in a failure of the float covering.
- [NTSB MIA02LA119](https://openairdocs.org/ntsb/MIA02LA119.md): Cessna 208B · Isla De Vieques, PR · Accident · No injuries · Limited investigation · Final report · Jun 20, 2002 · N786DM · 2 aircraft · Substantial damage
  > the failure of both pilots to see and avoid, also causal was the failure of the pilot of the Britten-Norman Islander (N663VL) to yield right of way to an aircraft in the traffic pattern.
- [NTSB NYC02LA116](https://openairdocs.org/ntsb/NYC02LA116.md): Piper PA-28-160 · Huron, OH · Accident · No injuries · Limited investigation · Final report · Jun 18, 2002 · N5369W · Substantial damage
  > The dual student's inadvertent shutdown of the engine and the certified flight instructor's inadequate supervision. A factor was the lack of suitable terrain.
- [NTSB NYC02LA114](https://openairdocs.org/ntsb/NYC02LA114.md): Cessna 150K · Seaman, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 2002 · N6319G · Substantial damage
  > The pilot's failure to maintain airspeed during a precautionary landing, which resulted in an inadvertent stall/mush, and uncontrolled descent to the ground. A factor was the pilots' lack of recent experience.
- [NTSB SEA02LA102](https://openairdocs.org/ntsb/SEA02LA102.md): Piper PA-16 · Umpqua, OR · Accident · No injuries · Limited investigation · Final report · Jun 15, 2002 · N5942H · Substantial damage
  > The pilot's failure to adequately compensate for unfavorable wind conditions and maintain clearance from the terrain during an attempted VFR go-around. Factors include an encounter with unfavorable wind conditions during the landing flare and the attempted…
- [NTSB SEA02LA101](https://openairdocs.org/ntsb/SEA02LA101.md): Cessna 182Q · Yellow Pine, ID · Accident · No injuries · Limited investigation · Final report · Jun 15, 2002 · N4725N · Substantial damage
  > Compensation for wind conditions inadequate during the approach for landing. A downdraft was a factor.
- [NTSB FTW02LA176](https://openairdocs.org/ntsb/FTW02LA176.md): Bell 206L-3 · Dover, AR · Accident · No injuries · Limited investigation · Final report · Jun 9, 2002 · N103AE · Substantial damage
  > The pilot's failure to maintain clearance with trees during the approach. A contributing factor was dark night light conditions.
- [NTSB LAX02LA187](https://openairdocs.org/ntsb/LAX02LA187.md): Mooney M20E · Placerville, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2002 · N1285X · Substantial damage
  > A loss of engine power due to the pilot's inadequate in-flight planning/decision which led to fuel exhaustion.
- [NTSB CHI02LA155](https://openairdocs.org/ntsb/CHI02LA155.md): Aeronca O-58B · Alexandria, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 2002 · N46899 · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.
- [NTSB MIA02LA108](https://openairdocs.org/ntsb/MIA02LA108.md): Piper PA-32R-301 · Meridian, MS · Accident · Serious injuries · Limited investigation · Final report · Jun 7, 2002 · N697MA · Substantial damage
  > inadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.
- [NTSB FTW02LA172](https://openairdocs.org/ntsb/FTW02LA172.md): Beech BE-100-A100 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jun 5, 2002 · N799DD · Substantial damage
  > The malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.
- [NTSB DCA02MA042](https://openairdocs.org/ntsb/DCA02MA042.md): McDonnell Douglas MD-11F · Subic Bay, Philippines · Accident · No injuries · Major investigation · Final report · Jun 2, 2002 · N601FE · Substantial damage
  > The failure of the lower outboard nut and bolt assembly of the left inboard flap's outboard hinge that resulted from stress corrosion cracking and fatigue. Factors contributing to the accident were the inadequate materials specification of the bolt, and…
- [NTSB SEA02LA093](https://openairdocs.org/ntsb/SEA02LA093.md): Cessna 172M · Anacortes, WA · Accident · Minor injuries · Limited investigation · Final report · May 31, 2002 · N496HM · Substantial damage
  > The pilot's improper decision to continue his flight after failing to take on fuel at a planned en route refueling stop, which lead to a loss of power from fuel exhaustion while on final approach to his round-robin final destination. Factors include…
- [NTSB CHI02LA146](https://openairdocs.org/ntsb/CHI02LA146.md): Cessna 182J · Galesville, WI · Accident · No injuries · Limited investigation · Final report · May 31, 2002 · N3027F · Substantial damage
  > The pilot failed to maintain clearance with the wires while on final approach. Factors associated with the accident were the low altitude, the downdraft, and the wires which the airplane contacted.
- [NTSB NYC02TA104](https://openairdocs.org/ntsb/NYC02TA104.md): Hughes OH-6A · Angola, NY · Accident · Minor injuries · Final report · May 29, 2002 · N42SD · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB ATL02LA111](https://openairdocs.org/ntsb/ATL02LA111.md): Boeing 757-200 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · May 29, 2002 · N626DL · No damage
  > In-flight encounter with turbulence during descent, that resulted in an serious injury to the flight attendant.
- [NTSB LAX02LA178](https://openairdocs.org/ntsb/LAX02LA178.md): Bell 206L-1 · Meadview, AZ · Accident · Minor injuries · Limited investigation · Final report · May 28, 2002 · N1075S · Destroyed
  > the pilot's failure to maintain distance and altitude during landing approach, resulting in the helicopter striking the ground during approach.
- [NTSB LAX02LA170](https://openairdocs.org/ntsb/LAX02LA170.md): Piper PA-38-112 · Kingman, AZ · Accident · No injuries · Limited investigation · Final report · May 28, 2002 · N4326E · Substantial damage
  > the CFI's failure to obtain/maintain an adequate airspeed during an attempted go-around, which resulted in a stall/mush condition. The high density altitude, tailwind, inadequate supervision, and overgross weight condition were factors.
- [NTSB ATL02LA108](https://openairdocs.org/ntsb/ATL02LA108.md): Cessna T210N · Orlando, FL · Accident · No injuries · Limited investigation · Final report · May 28, 2002 · N4672Y · Destroyed
  > The pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.
- [NTSB LAX02LA177](https://openairdocs.org/ntsb/LAX02LA177.md): Cessna 310N · Dayton, NV · Accident · Minor injuries · Limited investigation · Final report · May 26, 2002 · N588JL · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's failure to use a checklist and position the fuel selectors to tanks containing fuel.
- [NTSB DEN02LA046](https://openairdocs.org/ntsb/DEN02LA046.md): Bell 206B-III · Moab, UT · Accident · No injuries · Limited investigation · Final report · May 24, 2002 · N191RH · Substantial damage
  > The pilot's failure to maintain rotor rpm during a forced landing. A contributing factor was fuel starvation.
- [NTSB CHI02LA139](https://openairdocs.org/ntsb/CHI02LA139.md): Wattier Tornado · Grant, MI · Accident · No injuries · Limited investigation · Final report · May 20, 2002 · N5143C · Substantial damage
  > The disregarded replacement of the airplane's fuel lines, the operation of the aircraft with known deficiencies, and the turn back to the departure airport by the owner/pilot. The inadequate condition inspection by the mechanic, the cracked fuel line, the…
- [NTSB CHI02LA138](https://openairdocs.org/ntsb/CHI02LA138.md): Cessna 150G · Kenosha, WI · Accident · Minor injuries · Limited investigation · Final report · May 19, 2002 · N8657J · Substantial damage
  > The student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.
- [NTSB ATL02LA099](https://openairdocs.org/ntsb/ATL02LA099.md): Aero Partners One CA 7SL · Merritt Island, FL · Accident · 1 fatal · Limited investigation · Final report · May 15, 2002 · N4075Z · Substantial damage
  > The pilot's inadequate in-flight planning/decision resulting in the misconfiguration of the flaps and the elevator trim setting. The misconfiguration resulted in an inadvertent pitch-up, loss of airspeed, stall and collision with the ground.
- [NTSB LAX02LA160](https://openairdocs.org/ntsb/LAX02LA160.md): Mulligan RV4 · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · May 12, 2002 · N6579B · Substantial damage
  > The failure of the pilot to maintain sufficient airspeed during the attempted go-around resulting in a stall/mush. The gusting winds, recent purchase of airplane, and premature raising of the flaps were factors.
- [NTSB LAX02FA157](https://openairdocs.org/ntsb/LAX02FA157.md): Ercoupe 415C · El Cajon, CA · Accident · Serious injuries · Field investigation · Final report · May 11, 2002 · N2948H · Destroyed
  > fuel starvation due to the mechanic's failure to properly tighten a fuel line fitting on the engine driven fuel pump, which led to a depletion of the fuel in the header tank. The mechanic's self induced pressure to complete the job prior to leaving on…
- [NTSB DEN02LA042](https://openairdocs.org/ntsb/DEN02LA042.md): Piper PA-28-140B · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · May 11, 2002 · N345M · Substantial damage
  > the pilot's inadvertent stall/mush to the ground during landing flare. Contributing factors were the earth berm along the side of the runway, and the wind shear weather condition on short final.
- [NTSB CHI02LA134](https://openairdocs.org/ntsb/CHI02LA134.md): Aeronca 7FC · Neenah, WI · Accident · Serious injuries · Limited investigation · Final report · May 11, 2002 · N85258 · Substantial damage
  > The pilot not maintaining control of the airplane during the landing approach, and his failure to maintain clearance from terrain.
- [NTSB IAD02LA049](https://openairdocs.org/ntsb/IAD02LA049.md): Cessna 210 · Westhampton Bch, NY · Accident · Serious injuries · Limited investigation · Final report · May 10, 2002 · N7482E · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB CHI02LA135](https://openairdocs.org/ntsb/CHI02LA135.md): Mooney M20F · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · May 10, 2002 · N976SB · Substantial damage
  > The pilot did not attain a proper climb rate during the go-around and the intentional wheels up landing. Factors associated with the accident were the inability of the pilot to maintain directional control of the airplane during the landing and the parked…
- [NTSB FTW02LA142](https://openairdocs.org/ntsb/FTW02LA142.md): Piper Aerostar 602P · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · May 9, 2002 · N61RG · Substantial damage
  > The pilot's delayed extension of the main landing gear prior to the landing flare/touchdown, which resulted in a wheels-up landing. A contributing factor was the loss of engine power for an undetermined reason.
- [NTSB LAX02LA151](https://openairdocs.org/ntsb/LAX02LA151.md): Cessna T210N · Flagstaff, AZ · Accident · Serious injuries · Limited investigation · Final report · May 6, 2002 · N888GB · Substantial damage
  > a loss of engine power for undetermined reasons.

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

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

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