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

## Cases, newest first

- [NTSB ATL90LA063](https://openairdocs.org/ntsb/ATL90LA063.md): Beech A 36 · Ocean Island Be, NC · Accident · No injuries · Limited investigation · Final report · Feb 10, 1990 · N4723M · Substantial damage
  > Loss of engine power due to fuel starvation and the pilot in commands failure to turn on the electric boost pump during attempted engine restart resulting in a forced landing.
- [NTSB MKC90LA052](https://openairdocs.org/ntsb/MKC90LA052.md): Cessna 150 · Clear Lake, MN · Accident · No injuries · Limited investigation · Final report · Feb 9, 1990 · N7359G · Substantial damage
  > Failure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.
- [NTSB LAX90FA082](https://openairdocs.org/ntsb/LAX90FA082.md): Beech 95-55 · Chico, CA · Accident · 3 fatal · Field investigation · Final report · Feb 6, 1990 · N721L · 2 aircraft · Destroyed
  > The failure of the pilots of N790T and N721L to see and avoid each other. Factors which contributed to the accident were: the pilot of the C-182P, N790T, was disoriented and improperly entered the traffic pattern due to recent marijuana use; the pilot of the…
- [NTSB FTW90FA063](https://openairdocs.org/ntsb/FTW90FA063.md): Cessna 172M · Tomball, TX · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1990 · N128S · 2 aircraft · Destroyed
  > Failure of the pilot in Cessna 150, N714RS, to comply with the air traffic control clearance, and failure of both pilots to maintain adequate visual lookout to see-and-avoid each other. Factors related to the accident were: physical impairment of the pilot in…
- [NTSB MIA90FA067](https://openairdocs.org/ntsb/MIA90FA067.md): Piper PA-28-161 · Sebastian, FL · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1990 · N473FT · 2 aircraft · Destroyed
  > Failure of the AA-1A pilot to see-and-avoid the Piper PA-28 which had entered traffic first. A factor related to the accident was: failure of the PA-28 pilot to see the American AA-1A, when the AA-1A was on a base leg and the PA-28 was further out on final…
- [NTSB DEN90LA048](https://openairdocs.org/ntsb/DEN90LA048.md): Cameron N105 · Littleton, CO · Accident · No injuries · Limited investigation · Final report · Feb 3, 1990 · N29675 · Substantial damage
  > Inadequate compensation for the wind conditions by the pilot in command.
- [NTSB ATL90LA059](https://openairdocs.org/ntsb/ATL90LA059.md): Cessna 425 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1990 · N6846D · Substantial damage
  > Failure of the pilot to maintain control of the aircraft during the go-around. A factor related to the accident was: the pilot's delay in initiating the go-around.
- [NTSB ATL90FA056](https://openairdocs.org/ntsb/ATL90FA056.md): Cessna 150F · Weaver, AL · Accident · Serious injuries · Field investigation · Final report · Jan 30, 1990 · N6871F · Substantial damage
  > The pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…
- [NTSB ATL90LA058](https://openairdocs.org/ntsb/ATL90LA058.md): Beech C24R · Greer, SC · Accident · No injuries · Limited investigation · Final report · Jan 28, 1990 · N66336 · Substantial damage
  > The pilot in command's improper flare which resulted in a hard landing.
- [NTSB ANC90FA032](https://openairdocs.org/ntsb/ANC90FA032.md): Cessna 182 · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Jan 28, 1990 · N8849T · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.
- [NTSB DCA90MA019](https://openairdocs.org/ntsb/DCA90MA019.md): Boeing 707-321B · Cove Neck, NY · Accident · 73 fatal · Class 1 · Major · Final report · Jan 26, 1990 · HK201 · Destroyed
  > The failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…
- [NTSB FTW90LA058](https://openairdocs.org/ntsb/FTW90LA058.md): Piper PA-28-161 · Austin, TX · Accident · No injuries · Limited investigation · Final report · Jan 25, 1990 · N30057 · Substantial damage
  > Failure of the rocker arm in the engine driven fuel pump.
- [NTSB CHI90DET03](https://openairdocs.org/ntsb/CHI90DET03.md): Pterodactyl Ascender II+2 · Lake Village, IN · Accident · 1 fatal · Final report · Jan 24, 1990 · UNREG · Substantial damage
  > In-flight structural failure of the right wing spar.
- [NTSB LAX90LA074](https://openairdocs.org/ntsb/LAX90LA074.md): Robinson R22 · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1990 · N2258R · Substantial damage
  > The pilot encountered a tailwind while on final approach, but delayed the go-around. During the go-around the pilot failed to maintain airspeed and entered a descent (settling with power).
- [NTSB LAX90LA073](https://openairdocs.org/ntsb/LAX90LA073.md): Piper PA-28-161 · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1990 · N2572Y · Substantial damage
  > The pilot's misjudgement of distance and altitude to the runway, while on final approach, which resulted in his failure to attain the proper touchdown point for landing. Factors related to the accident were: darkness, haze, and soft terrain in the area where…
- [NTSB LAX90LA108](https://openairdocs.org/ntsb/LAX90LA108.md): Piper PA-32-R-300 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1990 · N38908 · Substantial damage
  > An inadvertent collision with a large bird during the hours of darkness while in the landing pattern.
- [NTSB LAX90LA071](https://openairdocs.org/ntsb/LAX90LA071.md): North American Navion · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1990 · N727G · Substantial damage
  > The pilot failed to properly preflight the airplane and departed on the accident flight with minimal fuel.
- [NTSB CHI90LA071](https://openairdocs.org/ntsb/CHI90LA071.md): Cessna 177B · Acme, MI · Accident · No injuries · Limited investigation · Final report · Jan 20, 1990 · N34860 · Substantial damage
  > The student pilot misjudged distance and altitude to the runway, and the instructor pilot (CFI) failed to attain remedial action, which resulted in their failure to attain the proper touchdown point. Factors related to the accident were: the cfi's lack of…
- [NTSB MKC90MA049](https://openairdocs.org/ntsb/MKC90MA049.md): Grumman G1159 · Little Rock, AR · Accident · 7 fatal · Major investigation · Final report · Jan 19, 1990 · N46TE · Destroyed
  > Failure of the pilot-in-command to follow IFR procedures (maintain an ILS glide path or initiate a missed approach) during an IFR arrival to the airport. Factors related to the accident were: unfavorable weather conditions, an erroneous wind indication from…
- [NTSB ANC90LA030](https://openairdocs.org/ntsb/ANC90LA030.md): Stinson 108-3 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jan 19, 1990 · N551C · Substantial damage
  > The pilot misjudged his distance and altitude to the runway on final approach, and failed to attain the proper touchdown point. Factors related to the accident were: dark night, unfavorable wind wind conditions and snow covered terrain.
- [NTSB MIA90LA057](https://openairdocs.org/ntsb/MIA90LA057.md): Beech 400 · West Point, MS · Accident · No injuries · Limited investigation · Final report · Jan 17, 1990 · N3121B · Substantial damage
  > The pilot misjudged distance, speed, and altitude on final approach, and failed to attain the proper touchdown Point for landing.
- [NTSB MIA90LA056](https://openairdocs.org/ntsb/MIA90LA056.md): Cessna 404 · Boca Raton, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1990 · N335GP · Substantial damage
  > Loss of power in the right engine due to a disconnected duct between the turbocharger and the plenum chamber. The reason for the loss of power in the left engine was not determined.
- [NTSB CHI90FA066](https://openairdocs.org/ntsb/CHI90FA066.md): Cessna 402A · Mosinee, WI · Accident · Serious injuries · Field investigation · Final report · Jan 17, 1990 · N4532Q · Destroyed
  > The pilot disregarding the published decision height and not performing a missed approach.
- [NTSB CHI90FA065](https://openairdocs.org/ntsb/CHI90FA065.md): Cessna 402B · Appleton, WI · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1990 · N87163 · Destroyed
  > The pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.
- [NTSB NYC90FA054](https://openairdocs.org/ntsb/NYC90FA054.md): Cessna 310R · Burlington, VT · Accident · 3 fatal · Field investigation · Final report · Jan 16, 1990 · N5115J · Destroyed
  > For an unknown reason, the aircraft entered a descent and crashed in a lake.
- [NTSB MKC90LA048](https://openairdocs.org/ntsb/MKC90LA048.md): Cessna 172 · Dexter, MO · Accident · Minor injuries · Limited investigation · Final report · Jan 15, 1990 · N7726U · Substantial damage
  > The pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.
- [NTSB DEN90FA042](https://openairdocs.org/ntsb/DEN90FA042.md): Fairchild SA227-AC · Elko, NV · Accident · Serious injuries · Field investigation · Final report · Jan 15, 1990 · N2721M · Substantial damage
  > Improper IFR procedure by the captain, and inadequate monitoring of the approach by the first officer, which resulted in a failure to maintain proper altitude during the approach. Factors related to the accident were: the terrain and weather conditions at the…
- [NTSB MKC90LA047](https://openairdocs.org/ntsb/MKC90LA047.md): Burnett Starduster TOO · Lawrence, KS · Accident · Serious injuries · Limited investigation · Final report · Jan 14, 1990 · N4GB · Substantial damage
  > The pilot misjudged clearance from tree(s) near the approach end of the runway, while on final approach to land. Factors related to the accident were: sunglare, lack of visual cues to the pilot, and tree(s).
- [NTSB MKC90LA045](https://openairdocs.org/ntsb/MKC90LA045.md): Cessna 150H · Hornersville, MO · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1990 · N22182 · Substantial damage
  > Poor judgement of the pilot due to consumption of alcohol, and his misjudgement of distance and altitude to the runway, while on final approach, which subsequently resulted in a touchdown and nose over short of the runway.
- [NTSB DEN90LA039](https://openairdocs.org/ntsb/DEN90LA039.md): Piper PA-28-140 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Jan 12, 1990 · N5693U · Substantial damage
  > Fuel starvation due to pilot misjudgement of fuel requirements for the trip and a failure to refuel the airplane en route.
- [NTSB LAX90LA067](https://openairdocs.org/ntsb/LAX90LA067.md): Piper PA-46 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jan 8, 1990 · N9150X · Substantial damage
  > The pilot's failure to maintain adequate airspeed during final approach which allowed the aircraft to stall and collide with the runway.
- [NTSB LAX90LA066](https://openairdocs.org/ntsb/LAX90LA066.md): Mooney M20B · Santa Ana, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 7, 1990 · N74520 · Substantial damage
  > The failure of bolts retaining the idler shaft allowing the cam shift timing to change and by its failure to drive the left magneto.
- [NTSB LAX90FA068](https://openairdocs.org/ntsb/LAX90FA068.md): Cessna 182P · Napa, CA · Accident · 1 fatal · Field investigation · Final report · Jan 7, 1990 · N1283S · Destroyed
  > The failure of the pilot to properly execute the published approach and missed approach which resulted in a collision with mountainious terrain.
- [NTSB CHI90LA061](https://openairdocs.org/ntsb/CHI90LA061.md): Cessna 150L · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · Jan 7, 1990 · N6763G · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.
- [NTSB MIA90FA050](https://openairdocs.org/ntsb/MIA90FA050.md): Piper PA-30 · Tallahassee, FL · Accident · Serious injuries · Field investigation · Final report · Jan 6, 1990 · N7030Y · Destroyed
  > Pilot factor in that he failed to maintain a/c control in instrument meteorological conditions due to spatial disorientation caused by fixation of an undetermined light source.
- [NTSB LAX90LA059](https://openairdocs.org/ntsb/LAX90LA059.md): Piper PA28-181 · Santa Barbara, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 1989 · N8138E · Substantial damage
  > The pilot's failure to maintain adequate terrain clearance during a night visual approach.
- [NTSB MKC90LA040](https://openairdocs.org/ntsb/MKC90LA040.md): Piper PA-32-301 · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Dec 29, 1989 · N8157R · Substantial damage
  > Inproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…
- [NTSB CHI90LA053](https://openairdocs.org/ntsb/CHI90LA053.md): Piper PA-34-200 · Jenison, MI · Accident · No injuries · Limited investigation · Final report · Dec 29, 1989 · N1294T · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the approach. A contributing factor was the icing condition that existed at the time of the accident.
- [NTSB MIA90FA044](https://openairdocs.org/ntsb/MIA90FA044.md): Cessna 210M · Stuart, FL · Accident · Serious injuries · Field investigation · Final report · Dec 28, 1989 · N456GS · Substantial damage
  > The pilot's improper calculation of fuel consumption which resulted in an inadequate fuel supply to reach his destination.
- [NTSB FTW90LA048](https://openairdocs.org/ntsb/FTW90LA048.md): Piper PA-32-260 · Clinton, OK · Accident · No injuries · Limited investigation · Final report · Dec 28, 1989 · N3809W · Substantial damage
  > Pilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.
- [NTSB CHI90FA056](https://openairdocs.org/ntsb/CHI90FA056.md): Cessna 340 · Merrill, WI · Accident · No injuries · Field investigation · Final report · Dec 28, 1989 · N69556 · Substantial damage
  > Failure of the pilot to maintain proper alignment with the runway during his landing roll and an inflight encounter with icing conditions.
- [NTSB CHI90FA050](https://openairdocs.org/ntsb/CHI90FA050.md): Beech 60 · Erie, PA · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1989 · N478AD · Destroyed
  > The pilot's failure to assure that the aircraft had an adequate supply of fuel on board for the intended flight. Contributing factors to the accident were an inoperative right fuel quantity gage which resulted in inaccurate fuel consumption calculations, and…
- [NTSB NYC90LA042](https://openairdocs.org/ntsb/NYC90LA042.md): Piper PA-18-135 · No. Andover, MA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1989 · N9975Q · Substantial damage
  > The pilot inadvertently turned off the magneto switch during a go-around, resulting in a loss of power. Also causal to the accident was the failure of the pilot of a second airplane to respond to the tower controller's instructions. A factor related to the…
- [NTSB FTW90FA046](https://openairdocs.org/ntsb/FTW90FA046.md): Bell 206L-1 · S Marsh Is 7 · Accident · Serious injuries · Field investigation · Final report · Dec 27, 1989 · N3913S · Destroyed
  > The pilot's failure to recognize and correct a situation involving loss of tail rotor effectiveness, resulting in loss of aircraft control.
- [NTSB DCA90MA011](https://openairdocs.org/ntsb/DCA90MA011.md): British Aerospace BAE-3101 · Pasco, WA · Accident · 6 fatal · Class 1 · Major · Final report · Dec 27, 1989 · N410UE · Destroyed
  > The flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…
- [NTSB ATL90LA046](https://openairdocs.org/ntsb/ATL90LA046.md): Piper PA-38-112 · Selmer, TN · Accident · No injuries · Limited investigation · Final report · Dec 27, 1989 · N2443K · Substantial damage
  > The failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…
- [NTSB MIA90LA041](https://openairdocs.org/ntsb/MIA90LA041.md): Cessna 150 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Dec 26, 1989 · N704SM · Substantial damage
  > The pilot's loss of control of the aircraft due to a loss of consciousness brought on by reactive hypoglycemia.
- [NTSB FTW90DQG01](https://openairdocs.org/ntsb/FTW90DQG01.md): Senior Aerosport/Paet PJ 260 · Hereford, TX · Accident · 1 fatal · Final report · Dec 25, 1989 · N260LP · Destroyed
  > The pilot's failure to maintain adequate obstacle clearance on the approach to landing. A factor was the power pole just short of the end of the runway.
- [NTSB ATL90LA044](https://openairdocs.org/ntsb/ATL90LA044.md): Piper PA-24 · Danielsville, GA · Accident · No injuries · Limited investigation · Final report · Dec 24, 1989 · N5556P · Substantial damage
  > Inadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…
- [NTSB ANC90LA017](https://openairdocs.org/ntsb/ANC90LA017.md): Beech 18 · Brevig Mission, AK · Accident · No injuries · Limited investigation · Final report · Dec 23, 1989 · N220H · Substantial damage
  > Loss of power in the the right engine for an unknown reason. The rough/uneven terrain was a contributing factor.

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

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

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