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

## Cases, newest first

- [NTSB FTW02LA034](https://openairdocs.org/ntsb/FTW02LA034.md): Air Tractor AT-802A · Benton, LA · Accident · 1 fatal · Limited investigation · Final report · Nov 14, 2001 · N202AT · Destroyed
  > in-flight collision with trees while on final approach to land for an undetermined reason.
- [NTSB FTW02FA036](https://openairdocs.org/ntsb/FTW02FA036.md): Piper PA-31T1 · Graham, TX · Accident · 4 fatal · Field investigation · Final report · Nov 13, 2001 · N6134A · Destroyed
  > The pilot's failure to discontinue the approach after encountering instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing factors were the dark night light condition, low ceiling, and reduced visibility due to fog.
- [NTSB SEA02LA016](https://openairdocs.org/ntsb/SEA02LA016.md): Piper PA-28R-200 · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N9466K · Substantial damage
  > The pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.
- [NTSB LAX02LA025](https://openairdocs.org/ntsb/LAX02LA025.md): Cessna 150L · Nogales, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2001 · N10680 · Substantial damage
  > The pilot failed to maintain directional control while landing in a cross wind. He attempted a go-around, but inadvertently stalled the airplane, which resulted in an uncontrolled descent and collision with the runway.
- [NTSB CHI02LA027](https://openairdocs.org/ntsb/CHI02LA027.md): Beech V35 · Mounds View, MN · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2001 · N4890J · Destroyed
  > Fuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…
- [NTSB ATL02LA012](https://openairdocs.org/ntsb/ATL02LA012.md): Extra Flugzeugbau EA300/L · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N2XA · 2 aircraft · Minor damage
  > The pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…
- [NTSB LAX02LA024](https://openairdocs.org/ntsb/LAX02LA024.md): Taylorcraft BC12-D · Copperopolis, CA · Accident · No injuries · Limited investigation · Final report · Nov 9, 2001 · N43382 · Substantial damage
  > The pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.
- [NTSB DEN02LA010](https://openairdocs.org/ntsb/DEN02LA010.md): Agusta A119 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2001 · N119RX · Destroyed
  > improper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.
- [NTSB MIA02LA015](https://openairdocs.org/ntsb/MIA02LA015.md): Cessna 177 · Gainesville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 2001 · N177X · Substantial damage
  > The failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.
- [NTSB LAX02LA023](https://openairdocs.org/ntsb/LAX02LA023.md): Piper PA-18-150 · Herald, CA · Accident · No injuries · Limited investigation · Final report · Nov 8, 2001 · N9461P · Substantial damage
  > The pilot's delay initiating a go-around during a downwind approach to a short runway.
- [NTSB LAX02FA019](https://openairdocs.org/ntsb/LAX02FA019.md): Cessna 182S · Little River, CA · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2001 · N7270E · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.
- [NTSB FTW02LA023](https://openairdocs.org/ntsb/FTW02LA023.md): Piper PA28-140 · Wilton, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2001 · N8305R · Substantial damage
  > the pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.
- [NTSB CHI02LA015](https://openairdocs.org/ntsb/CHI02LA015.md): Piper PA-28R-201 · Lapeer, MI · Accident · No injuries · Limited investigation · Final report · Oct 28, 2001 · N6899C · Substantial damage
  > the touchdown aim point not attained by the pilot rated student and the remedial action not performed by the flight instructor.
- [NTSB CHI02LA014](https://openairdocs.org/ntsb/CHI02LA014.md): Piper PA-28-180 · Fort Wayne, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 28, 2001 · N4879L · Destroyed
  > The pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.
- [NTSB NYC02LA017](https://openairdocs.org/ntsb/NYC02LA017.md): Beech B95A · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 2001 · N919Q · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in an inadvertent stall. A factor was the gusty wind conditions.
- [NTSB CHI02FA009](https://openairdocs.org/ntsb/CHI02FA009.md): Beech 58 · Dubuque, IA · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2001 · N7235R · Destroyed
  > The pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.
- [NTSB FTW02LA018](https://openairdocs.org/ntsb/FTW02LA018.md): Piper PA-30 · Ozona, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 2001 · N8642Y · Substantial damage
  > The loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel the airplane. Contributing factors were the lack of suitable terrain for the forced landing and the dark night conditions.
- [NTSB ANC02LA002](https://openairdocs.org/ntsb/ANC02LA002.md): Embraer 120ER · Bethel, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 2001 · N120AX · Substantial damage
  > The captain's continued descent below the minimum descent altitude which resulted in impact with terrain during an instrument landing approach. Factors contributing to the accident were the flightcrew's failure to reset the altimeters to the correct altimeter…
- [NTSB SEA02FA005](https://openairdocs.org/ntsb/SEA02FA005.md): Piper PA-18 · Sandy, OR · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2001 · N7502K · Substantial damage
  > The pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…
- [NTSB FTW02LA008](https://openairdocs.org/ntsb/FTW02LA008.md): Beech C90 · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2001 · N690JP · Substantial damage
  > the pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.
- [NTSB FTW02LA009](https://openairdocs.org/ntsb/FTW02LA009.md): Cessna 182A · Chickasha, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 2001 · N3862D · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB MIA02LA003](https://openairdocs.org/ntsb/MIA02LA003.md): Piper PA-30B-160 · Clarksville, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2001 · N8402Y · Substantial damage
  > The failure of the CFI/check pilot to insure Vmc was maintained during a go-around following a simulated failed engine approach, resulting in an in-flight loss of control, uncontrolled descent, and collision with the terrain. A factor in the accident was the…
- [NTSB FTW02FA003](https://openairdocs.org/ntsb/FTW02FA003.md): Fokker F28 Mk 0100 · DFW Airport, TX · Accident · No injuries · Field investigation · Final report · Oct 3, 2001 · N1448A · Substantial damage
  > The collapse of the nose landing gear as a result of the failure of company maintenance personnel to follow the proper procedures for a towing the airplane with an unsafe nose landing gear indication. Contributing factors were the inadequate communication…
- [NTSB IAD01LA109](https://openairdocs.org/ntsb/IAD01LA109.md): Rhoades Rotorway Exec 162F · Whitehouse, OH · Accident · No injuries · Limited investigation · Final report · Sep 30, 2001 · N25GR · Substantial damage
  > The soft terrain condition, which resulted in the helicopter's rollover during the forced landing. A factor was the loss of engine power due to engine overtemperature for undetermined reasons.
- [NTSB SEA01FA175](https://openairdocs.org/ntsb/SEA01FA175.md): Piper PA-30 · McCall, ID · Accident · 1 fatal · Field investigation · Final report · Sep 29, 2001 · N954S · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a loss of power on the left engine, resulting in loss of aircraft control. Factors included a loss of power on the left engine for undetermined reasons, and the pilot's failure to properly configure…
- [NTSB FTW01LA214](https://openairdocs.org/ntsb/FTW01LA214.md): Bell 206L-1 · W Cameron 168 · Accident · No injuries · Limited investigation · Final report · Sep 26, 2001 · N1067D · Substantial damage
  > the failure of the rotor tachometer generator, which resulted in a precautionary landing in the Gulf of Mexico. A contributing factor to the accident was the rough water condition.
- [NTSB DEN01FA162](https://openairdocs.org/ntsb/DEN01FA162.md): Cessna 337B · St. George, UT · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2001 · N337PM · Destroyed
  > total loss of engine power on both engines due to fuel starvation and the pilot's inability to access the available fuel supply. Contributing factors were the pilot's inadequate supervision of the refueling operation, and his intentional operation of the…
- [NTSB LAX01LA305](https://openairdocs.org/ntsb/LAX01LA305.md): Hughes 369D · Carlsbad, CA · Accident · No injuries · Limited investigation · Final report · Sep 23, 2001 · N268ST · Substantial damage
  > A hard landing due to the dual student's failure to maintain main rotor speed, his improper landing flare, and the flight control interference by the flight instructor.
- [NTSB LAX01LA304](https://openairdocs.org/ntsb/LAX01LA304.md): Aerospatiale AS350BA · Chico, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 23, 2001 · N911NT · Destroyed
  > the pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…
- [NTSB ANC01LA134](https://openairdocs.org/ntsb/ANC01LA134.md): Cessna 182 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 2001 · N3961D · Substantial damage
  > A loss of engine power, due to contaminated fuel, during approach for landing. A factor associated with the accident was unsuitable terrain.
- [NTSB CHI01LA317](https://openairdocs.org/ntsb/CHI01LA317.md): Beech 200 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Sep 19, 2001 · N711MZ · Substantial damage
  > The pilot not maintaining the proper ILS glide slope during the approach and the pilot not executing a missed approach. Contributing to the accident was the rain/mist.
- [NTSB SEA01LA170](https://openairdocs.org/ntsb/SEA01LA170.md): Cessna 182J · Gold Beach, OR · Accident · 1 fatal · Limited investigation · Final report · Sep 9, 2001 · N3056F · Substantial damage
  > The pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.
- [NTSB LAX01LA303](https://openairdocs.org/ntsb/LAX01LA303.md): Cessna P206B · Willits, CA · Accident · 2 fatal · Limited investigation · Final report · Sep 9, 2001 · N146A · Substantial damage
  > the failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.
- [NTSB DEN01LA159](https://openairdocs.org/ntsb/DEN01LA159.md): Boeing A75N1 (PT17) · Watkins, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 2001 · N1259V · Substantial damage
  > the pilot's failure to maintain clearance with the guy wire.
- [NTSB FTW01LA204](https://openairdocs.org/ntsb/FTW01LA204.md): Cessna A188B · Harrisonburg, LA · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2001 · N2162J · Destroyed
  > loss of control during approach for an undetermined reason.
- [NTSB NYC01FA223](https://openairdocs.org/ntsb/NYC01FA223.md): Piper PA-31-350 · Bern Township, PA · Accident · 1 fatal · Field investigation · Final report · Sep 5, 2001 · N8PK · Destroyed
  > The pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.
- [NTSB CHI01LA305](https://openairdocs.org/ntsb/CHI01LA305.md): Piper PA-28-161 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Sep 5, 2001 · N240ND · Substantial damage
  > The student pilot's improper flare, and the flight instructor's delayed remedial action, which resulted in a loss of directional control.
- [NTSB SEA01LA165](https://openairdocs.org/ntsb/SEA01LA165.md): Cessna T210L · Olympia, WA · Accident · No injuries · Limited investigation · Final report · Sep 3, 2001 · N6721M · Substantial damage
  > The inability of the landing gear to fully extend due to the failure of a hydraulic hose in the nose gear extension system.
- [NTSB MIA01LA226](https://openairdocs.org/ntsb/MIA01LA226.md): Piper PA-22-160 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 2001 · N3516Z · Substantial damage
  > a total loss of engine power due to the pilot's improper procedures by not placing the fuel selector on the tank with the most fuel, after a reported restricted movement of the flight controls for undetermined reasons, which resulted in fuel starvation and a…
- [NTSB NYC01LA222](https://openairdocs.org/ntsb/NYC01LA222.md): Piper PA-25 · Warren, VT · Accident · No injuries · Limited investigation · Final report · Sep 2, 2001 · N7247Z · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion.
- [NTSB LAX01LA299](https://openairdocs.org/ntsb/LAX01LA299.md): Piper PA-28-235 · Carson City, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2001 · N9199W · Destroyed
  > The pilot's incorrect setting of the fuel selector valve during the prelanding checklist to a position between usable tanks, resulting in fuel starvation.
- [NTSB LAX01FA297](https://openairdocs.org/ntsb/LAX01FA297.md): Cessna T210M · Watsonville, CA · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2001 · N6877M · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CHI01LA303](https://openairdocs.org/ntsb/CHI01LA303.md): Cessna 172N · Sheldon, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2001 · N5593E · Substantial damage
  > the in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.
- [NTSB ANC01LA129](https://openairdocs.org/ntsb/ANC01LA129.md): de Havilland C-7A · Port Alsworth, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 2001 · N2225C · Substantial damage
  > The captain's failure to maintain the proper glidepath, and improper short field landing procedures. Factors in the accident were a downdraft, and the captain's inadequate evaluation of the weather conditions.
- [NTSB FTW01LA199](https://openairdocs.org/ntsb/FTW01LA199.md): John Greenlee X-Aircamper · Healdton, OK · Accident · No injuries · Limited investigation · Final report · Aug 25, 2001 · N899JG · Substantial damage
  > The loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat during the approach to land. Contributing factors were weather conditions conducive to carburetor icing conditions and the lack of suitable terrain for…
- [NTSB NYC01FA215](https://openairdocs.org/ntsb/NYC01FA215.md): Beech BE-200 · Piqua, OH · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2001 · N18260 · Destroyed
  > The pilot's improper decision to attempt a visual landing under instrument meteorological conditions and his failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with trees. A factor in this accident was the ground fog.
- [NTSB ANC01LA123](https://openairdocs.org/ntsb/ANC01LA123.md): Piper PA-12 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 2001 · N7604H · Substantial damage
  > The pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.
- [NTSB NYC01FA212](https://openairdocs.org/ntsb/NYC01FA212.md): Pitts S-2B · Shirley, NY · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2001 · N225SD · Substantial damage
  > The pilot under instruction's failure to maintain adequate airspeed, and the flight instructor's inadequate remedial action during a simulated engine-out approach, which resulted in an inadvertent stall, and subsequent ground impact.
- [NTSB FTW01LA187](https://openairdocs.org/ntsb/FTW01LA187.md): Beech F33C · Sugarland, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 2001 · N133DA · Substantial damage
  > the pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.
- [NTSB IAD01LA098](https://openairdocs.org/ntsb/IAD01LA098.md): Cessna 150M · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Aug 15, 2001 · N704SE · Substantial damage
  > The pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.

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

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

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