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

## Cases, newest first

- [NTSB LAX89LA186](https://openairdocs.org/ntsb/LAX89LA186.md): Piper PA-32RT-300T · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · May 24, 1989 · N39520 · Substantial damage
  > The failure of the pilot to maintain adequate clearance behind the B-737 which resulted in the inadvertent encounter with wake turbulence.
- [NTSB FTW89FA096](https://openairdocs.org/ntsb/FTW89FA096.md): Piper PA-28-180 · Boise City, OK · Accident · 2 fatal · Field investigation · Final report · May 22, 1989 · N2211T · Destroyed
  > An inadvertent stall resulting from the pilot's failure to maintain control of the aircraft and to maintain sufficient airspeed. The dark night and adverse wind conditions were contributing factors.
- [NTSB MKC89LA111](https://openairdocs.org/ntsb/MKC89LA111.md): Luscombe 8F · Ramsey, MN · Accident · No injuries · Limited investigation · Final report · May 21, 1989 · N2746K · Substantial damage
  > The passengers interference with the flight controls and the pilot's failure to maintain control of the aircraft. Contributing to the severity of the accident was the ditch located short of the runway which the aircraft contacted.
- [NTSB CHI89DET05](https://openairdocs.org/ntsb/CHI89DET05.md): Billings/White Avid Flyer · Niles, MI · Accident · 2 fatal · Final report · May 21, 1989 · N305BJ · Destroyed
  > Loose carburetor(s) due to improper maintenance/installation, which resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and…
- [NTSB LAX89LA199](https://openairdocs.org/ntsb/LAX89LA199.md): Piper PA-31-350 · Arcata, CA · Accident · No injuries · Limited investigation · Final report · May 20, 1989 · N35479 · Substantial damage
  > The pilots inaccurate fuel consumption calculations and improper fuel tank selector position. These resulted in fuel starvation to both engines when the aux tanks ran dry and the mains had fuel remaining in them. A factor in this accident was the rough…
- [NTSB ATL89LA148](https://openairdocs.org/ntsb/ATL89LA148.md): Cessna 152 · Hinckley, OH · Accident · No injuries · Limited investigation · Final report · May 18, 1989 · N24334 · Substantial damage
  > The pilots failure to calculate proper fuel consumption for the flight which resulted in fuel exhaustion.
- [NTSB LAX89LA193](https://openairdocs.org/ntsb/LAX89LA193.md): Cessna T210L · Upland, CA · Accident · Serious injuries · Limited investigation · Final report · May 12, 1989 · N5368V · Substantial damage
  > Inadequate in-flight planning/decision by the pilot in command, the instructor pilot. Factors were the private pilot did not switch the fuel tanks and the instructor did not catch it.
- [NTSB SEA89LA083](https://openairdocs.org/ntsb/SEA89LA083.md): Davis Starship Alpha · Star, ID · Accident · Serious injuries · Limited investigation · Final report · May 9, 1989 · N5531N · Substantial damage
  > Failure of the propeller drive belt (stripped teeth). Contributing factors were: strong/gusty winds and the hilly terrain.
- [NTSB SEA89LA082](https://openairdocs.org/ntsb/SEA89LA082.md): Cessna 172 · Woodland, WA · Accident · No injuries · Limited investigation · Final report · May 9, 1989 · CGREV · Substantial damage
  > The pilot's poor planning and inadequate calculation of fuel consumption which resulted in fuel exhaustion.
- [NTSB LAX89LA185](https://openairdocs.org/ntsb/LAX89LA185.md): Cessna 210T · Imperial, CA · Accident · Minor injuries · Limited investigation · Final report · May 8, 1989 · N30678 · Substantial damage
  > The pilots inaccurate fuel consumption calculations along with the decision to depart with inadequate fuel to insure landing at his proposed destination which resulted in fuel exhaustion. The rough/uneven terrain on which the landing was made contributed to…
- [NTSB SEA89LA081](https://openairdocs.org/ntsb/SEA89LA081.md): Cessna 150 · Yamhill, OR · Accident · No injuries · Limited investigation · Final report · May 6, 1989 · N6575G · Substantial damage
  > Failure of the pilot to maintain proper airspeed on final approach. Contributing to the accident was lack of total experience.
- [NTSB SEA89LA080](https://openairdocs.org/ntsb/SEA89LA080.md): Mccoy Super Koala · Kelso, WA · Accident · Minor injuries · Limited investigation · Final report · May 6, 1989 · N30SK · Destroyed
  > The pilot's failure to adequately compensate for wind conditions, and the pilot's delay in initiating a go-around. Contributing to the accident were crosswind gusts, and lack of total pilot experience.
- [NTSB ATL89LA143](https://openairdocs.org/ntsb/ATL89LA143.md): Cessna 182A · Lugoff, SC · Accident · Serious injuries · Limited investigation · Final report · May 6, 1989 · N4985D · Substantial damage
  > Inadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…
- [NTSB ATL89FA142](https://openairdocs.org/ntsb/ATL89FA142.md): Embraer EMB-110-P1 · Mt. Pleasant, TN · Accident · 1 fatal · Field investigation · Final report · May 6, 1989 · N95PB · Destroyed
  > Pilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.
- [NTSB DEN89LA119](https://openairdocs.org/ntsb/DEN89LA119.md): Piper PA-28RT-201T · Durango, CO · Accident · No injuries · Limited investigation · Final report · May 5, 1989 · N9147Y · Substantial damage
  > Inadequate inflight planning and inadequate compensation for wind conditions. Contributing to the accident were crosswind and turbulence encountered close to the ground and high density altitude conditions.
- [NTSB ATL89LA140](https://openairdocs.org/ntsb/ATL89LA140.md): Cessna A185F · Charlotte, NC · Accident · Minor injuries · Limited investigation · Final report · May 4, 1989 · CGCMT · Destroyed
  > Complete loss of engine power due to fuel exhaustion. The fuel exhaustion was due to the pilot not assuring an adequate fuel supply for the flight by visual inspection during his preflight inspection. Contributing was the pilot's decision to continue flight…
- [NTSB CHI89DEP03](https://openairdocs.org/ntsb/CHI89DEP03.md): Tesmer Glassair SH-2 · Watertown, WI · Accident · No injuries · Final report · Apr 30, 1989 · N29HJ · Substantial damage
  > Lack fuel flow to the engine (fuel starvation) due to an undetermined fuel system problem.
- [NTSB ATL89FA139](https://openairdocs.org/ntsb/ATL89FA139.md): Beech B24R · Suches, GA · Accident · 5 fatal · Field investigation · Final report · Apr 29, 1989 · N2526W · Destroyed
  > The pilot's flight into known adverse weather, and his failure to maintain clearance above the wooded terrain. The adverse weather condition, high terrain, and trees were related factors.
- [NTSB CHI89FA078](https://openairdocs.org/ntsb/CHI89FA078.md): Cessna 208A · Mt. Zion, IL · Accident · Minor injuries · Field investigation · Final report · Apr 27, 1989 · N9637F · Substantial damage
  > The pilot's intentional flight into known adverse weather. Contributing factors were the pilot's poor evaluation of the weather information given him by the air traffic controllers.
- [NTSB LAX89LA172](https://openairdocs.org/ntsb/LAX89LA172.md): Piper PA-28-140 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Apr 25, 1989 · N6073W · Substantial damage
  > The pilot did not adequately preflight the airplane to determine fuel quanity nor did he accurately calculate the fuel consumption. In addition, he failed to position the fuel selector to the fullest tank which resulted in fuel starvation to the engine on…
- [NTSB NYC89IA123](https://openairdocs.org/ntsb/NYC89IA123.md): Fairchild Swearingen SA-227AC · New York, NY · Incident · No injuries · Incident investigation · Final report · Apr 23, 1989 · N3044J · 2 aircraft · No damage
  > The failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R.
- [NTSB MKC89FA096](https://openairdocs.org/ntsb/MKC89FA096.md): Piper PA-28-140 · Wellsville, KS · Accident · Serious injuries · Field investigation · Final report · Apr 23, 1989 · N4315J · Substantial damage
  > The failure of the pilot to use carburetor heat during the descent for landing which resulted in a loss of engine power at a critical time in flight, a go-around.
- [NTSB MKC89LA098](https://openairdocs.org/ntsb/MKC89LA098.md): Cessna 177 · Brinkley, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1989 · N2969X · Substantial damage
  > The pilot's failure to gradually raise the flaps during the go-around and maintain adeqaute airspeed to continue the climbout.
- [NTSB MKC89LA097](https://openairdocs.org/ntsb/MKC89LA097.md): Cessna 150 · Creve Couer, MO · Accident · No injuries · Limited investigation · Final report · Apr 22, 1989 · N19220 · Substantial damage
  > The pilot's misjudgement of altitude and distance to the runway, and his failure to attain the proper touchdown point for landing. A factor related to the accident was: the soft/uneven terrain short of the runway.
- [NTSB LAX89LA168](https://openairdocs.org/ntsb/LAX89LA168.md): Stinson 108 · Avalon, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1989 · N97169 · Substantial damage
  > The pilot's inadequate compensation for the downdrafts he encountered and the delay in his decision to perform a go-around.
- [NTSB LAX89LA167](https://openairdocs.org/ntsb/LAX89LA167.md): Schweizer T-26E · Fremont, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1989 · N1134S · Substantial damage
  > The pilot's failure to maintain sufficient airspeed in an effort to avoid obstacles during an inadequately planned approach.
- [NTSB CHI89LA073](https://openairdocs.org/ntsb/CHI89LA073.md): Piper PA-38-112 · Brazil, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1989 · N2601A · Substantial damage
  > Failure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.
- [NTSB NYC89FA121](https://openairdocs.org/ntsb/NYC89FA121.md): Beech B19 · Augusta, ME · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1989 · N2231L · Destroyed
  > Failure of the pilot to maintain the proper altitude during the approach. A factor related to the accident was: the pilot's psychological condition.
- [NTSB BFO89LA030](https://openairdocs.org/ntsb/BFO89LA030.md): Cessna 150F · New Cumberland, WV · Accident · No injuries · Limited investigation · Final report · Apr 19, 1989 · N3570L · Substantial damage
  > The pilot's failure to compensate for crosswind conditions during an attempted go-around. Contributing factors were the crosswind condition and the pilot's low level of experience.
- [NTSB DEN89LA109](https://openairdocs.org/ntsb/DEN89LA109.md): Cessna 310E · Glenwood Spgs, CO · Accident · No injuries · Limited investigation · Final report · Apr 17, 1989 · N4127G · Substantial damage
  > Inadequate compensation for the wind conditions by the pilot, resulting in a loss of control of final approach. Contributing to the accident was the downdraft.
- [NTSB SEA89LA070](https://openairdocs.org/ntsb/SEA89LA070.md): Consolidated Aeronautics LA-4 · Yamhill, OR · Accident · No injuries · Limited investigation · Final report · Apr 15, 1989 · N2990P · Substantial damage
  > Pilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.
- [NTSB BFO89FA027](https://openairdocs.org/ntsb/BFO89FA027.md): Cessna 152 · West Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1989 · N93748 · Destroyed
  > Improper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…
- [NTSB LAX89LA159](https://openairdocs.org/ntsb/LAX89LA159.md): British Aerospace HS125-700 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Apr 13, 1989 · CGPCC · Substantial damage
  > The captain misjudged distance and altitude to the runway and allowed the aircraft to touch down just short of the runway lip. The runway lip was a related factor.
- [NTSB CHI89LA072](https://openairdocs.org/ntsb/CHI89LA072.md): Beech A60 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Apr 13, 1989 · N4445W · Substantial damage
  > The pilot misjudged altitude and/or distance to the runway wile on final approach to land. Factors related to the accident were: dark night and pilot fatigue.
- [NTSB ATL89LA127](https://openairdocs.org/ntsb/ATL89LA127.md): Cessna 172 · Xenia, OH · Accident · No injuries · Limited investigation · Final report · Apr 12, 1989 · N4898G · Substantial damage
  > The pilot's improper in-flight planning/decision and improper use of the flaps. Contributing was the downdraft.
- [NTSB NYC89LA119](https://openairdocs.org/ntsb/NYC89LA119.md): Cessna 152 · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1989 · N94822 · Substantial damage
  > Improper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…
- [NTSB DEN89FA104](https://openairdocs.org/ntsb/DEN89FA104.md): Cessna T210F · Aspen, CO · Accident · 1 fatal · Field investigation · Final report · Apr 9, 1989 · N6812R · Destroyed
  > The engine falure due to undetermined reasons and the pilot's misjudgement of the wind conditions which resulted in the attempt to glide to the runway. The pilot also failed to maintain adequate airspeed during the glide which resulted in a stall.
- [NTSB NYC89DGM01](https://openairdocs.org/ntsb/NYC89DGM01.md): Sharp FOX Model 1 · Loretto, PA · Accident · No injuries · Final report · Apr 8, 1989 · N8387S · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB MIA89LA125](https://openairdocs.org/ntsb/MIA89LA125.md): Beech A23 · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1989 · N2326W · Substantial damage
  > Improper in-flight planning/decision, which resulted in fuel starvation, while the fuel selector was positioned to a tank with the least amount of fuel. A factor related to the accident was: the faulty fuel quantity indication for the right tank.
- [NTSB CHI89FA069](https://openairdocs.org/ntsb/CHI89FA069.md): Cessna 150M · Kankakee, IL · Accident · 2 fatal · Field investigation · Final report · Apr 6, 1989 · N3892V · Destroyed
  > Failure of the instructor pilot (CFI) to maintain control of the aircraft and his failure to maintain sufficient altitude above the ground.
- [NTSB FTW89FA075](https://openairdocs.org/ntsb/FTW89FA075.md): Bell 206B · West Cameron · Accident · No injuries · Field investigation · Final report · Apr 5, 1989 · N5004L · Substantial damage
  > Inadequate maintenance/inspection of the aircraft fuel system by company maintenance personnel and fuel contamination, which resulted in a partial loss of engine power. Related factors were: a binding (stuck) fuel filter cap bypass valve and partial failure…
- [NTSB LAX89DVA04](https://openairdocs.org/ntsb/LAX89DVA04.md): Lowe Quickie Q-200 · Hanford, CA · Accident · Minor injuries · Final report · Apr 2, 1989 · N26PL · Substantial damage
  > The pilot misjudged his altitude & distance to the runway, while on final approach, which resulted in an undershoot of the runway. A factor related to the accident was the fence.
- [NTSB ATL89LA119](https://openairdocs.org/ntsb/ATL89LA119.md): Cessna 152 · Bolivar, TN · Accident · No injuries · Limited investigation · Final report · Apr 1, 1989 · N6475Q · Substantial damage
  > The pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.
- [NTSB CHI89FA064](https://openairdocs.org/ntsb/CHI89FA064.md): Cessna 150L · Clawson, MI · Accident · 1 fatal · Field investigation · Final report · Mar 28, 1989 · N5335Q · Destroyed
  > The pilot allowing the airspeed to decay below the airplanes stall speed.
- [NTSB CHI89DEP02](https://openairdocs.org/ntsb/CHI89DEP02.md): Cessna 172M · West Bend, WI · Accident · No injuries · Final report · Mar 27, 1989 · N9578V · Substantial damage
  > Partial failure of the throttle cable. Unsuitable (soft) terrain and transmission wires in the landing area were considered to be factors.
- [NTSB LAX89FA136](https://openairdocs.org/ntsb/LAX89FA136.md): Aerospatiale AS-355-F · Bear Valley, CA · Accident · No injuries · Field investigation · Final report · Mar 26, 1989 · N84MH · Substantial damage
  > Improper in-flight planning/decision by the pilot, which resulted in a loss of aircraft control during a slow speed, downwind approach to a high altitude stolport. Contributing factors were: high density altitude, tailwind, improper weather evaluation by the…
- [NTSB LAX89LA135](https://openairdocs.org/ntsb/LAX89LA135.md): Piper PA-34-200 · Lake Elsinore, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 1989 · N4374T · Destroyed
  > CFI displayed poor judgement in his demonstration of single engine operation of a twin engine acft. His lack of supervision of an improper, deteriorating situation assured an unsuccessful conclusion.
- [NTSB MIA89FA113](https://openairdocs.org/ntsb/MIA89FA113.md): Piper Aerostar 600 · Jacksonville, FL · Accident · 1 fatal · Field investigation · Final report · Mar 23, 1989 · N77BR · Destroyed
  > Improper use of the IFR procedure by the pilot, his failure to maintain a proper glide path, and his failure to identify the decision height.
- [NTSB DEN89LA092](https://openairdocs.org/ntsb/DEN89LA092.md): Poehls Bobcat · Billings, MT · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 1989 · N80927 · Destroyed
  > The pilot inadvertently stalled the aircraft at an altitude which was too low to permit recovery.
- [NTSB LAX89DUG03](https://openairdocs.org/ntsb/LAX89DUG03.md): Van'S/Fish RV-4 · Hesperia, CA · Accident · 1 fatal · Final report · Mar 21, 1989 · N239X · Substantial damage
  > The pilot's failure to properly latch the canopy prior to takeoff and by allowing the aircraft to enter into a stall during a critical phase of flight at an attitude insufficient to recover safely. A factor in the accident was the loss of his eyeglasses when…

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

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

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