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

## Cases, newest first

- [NTSB CHI88DEX04](https://openairdocs.org/ntsb/CHI88DEX04.md): Cessna 172M · Alexandria, IN · Accident · No injuries · Final report · Apr 25, 1988 · N80269 · Substantial damage
  > Aircraft experienced intermittent engine operation while on final, followed by complete engine failure on landing rollout. Pilot noticed smoke entering cockpit during restart attempt. Aircraft was evacuated by pilot and three passengers. There was an engine…
- [NTSB ATL88LA151](https://openairdocs.org/ntsb/ATL88LA151.md): Cirrus Design Standard · Chester, SC · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1988 · N3LB · Substantial damage
  > The glider pilot failed to maintain sufficient altitude while on final approach for landing and struck trees.
- [NTSB ATL88FA150](https://openairdocs.org/ntsb/ATL88FA150.md): Cessna 152 · Moncks Corner, SC · Accident · Minor injuries · Field investigation · Final report · Apr 22, 1988 · N94251 · Substantial damage
- [NTSB MIA88LA157](https://openairdocs.org/ntsb/MIA88LA157.md): Cessna 150J · Deland, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 1988 · N60358 · Substantial damage
  > After landing at umatilla, muni, an unattended arpt, the plt asked an unauthorized individual to fill the acft's tanks. The individual stated that fuel is not sold to transient acft. The plt departed with the fuel tank gauges indicating 1/4 each. When it was…
- [NTSB LAX88LA167](https://openairdocs.org/ntsb/LAX88LA167.md): Cessna 182D · Coolidge, AZ · Accident · No injuries · Limited investigation · Final report · Apr 20, 1988 · N8847X · Substantial damage
  > At the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…
- [NTSB CHI88DEC01](https://openairdocs.org/ntsb/CHI88DEC01.md): Beech 23 · Brighton, MI · Accident · Minor injuries · Final report · Apr 18, 1988 · N2326L · Substantial damage
  > The unsuitable terrain (trees and a lake) encountered during a forced landing made necessary by the partial failure of the aircraft's powerplant during and attempted go-around. The occupants were able to exit the aircraft before it sank; the aircraft was…
- [NTSB CHI88LA098](https://openairdocs.org/ntsb/CHI88LA098.md): Cessna 150K · Pinconning, MI · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N6126G · Substantial damage
  > The airplane collided with a hangar and a tree during an attempted go-around at gross airport. The pilot stated that he flared too high and failed to correct the left yaw when he added power. The resultant flight path was directly into trees which he felt he…
- [NTSB ATL88IA147](https://openairdocs.org/ntsb/ATL88IA147.md): Boeing 737-200 · Cleveland, OH · Incident · Minor injuries · Incident investigation · Final report · Apr 17, 1988 · N433PE · Minor damage
- [NTSB SEA88FA078](https://openairdocs.org/ntsb/SEA88FA078.md): Piper PA-32RT-300T · Port Angeles, WA · Accident · 3 fatal · Field investigation · Final report · Apr 16, 1988 · N36815 · Destroyed
  > Drg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…
- [NTSB LAX88FA161](https://openairdocs.org/ntsb/LAX88FA161.md): Cessna 172G · Los Banos, CA · Accident · 4 fatal · Field investigation · Final report · Apr 16, 1988 · N4493L · Destroyed
  > Failure of the pilot to maintain control of his aircraft to avert a collision with the ground.
- [NTSB SEA88LA077](https://openairdocs.org/ntsb/SEA88LA077.md): Beech K-35 · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1988 · N40NL · Substantial damage
  > While on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…
- [NTSB MIA88FA144](https://openairdocs.org/ntsb/MIA88FA144.md): Beech A-23 · Fort Myers, FL · Accident · Serious injuries · Field investigation · Final report · Apr 13, 1988 · N8856M · Substantial damage
  > The private pilot experienced an engine failure on final approach and executed a forced landing to a wooded area and crashed. The pilot said he had flown about 2.0 hours on the right tank and did not switch to the left tank prior to landing. Another pilot had…
- [NTSB LAX88LA158](https://openairdocs.org/ntsb/LAX88LA158.md): Cessna 152 · Temecula, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1988 · N5518H · Substantial damage
  > While on final approach, the pilot encountered crosswind conditions and was unable to maintain the runway centerline. The pilot advanced the throttle and remembered hearing the stall horn. The aircraft cleared a building by 10 feet off the side of the runway…
- [NTSB DEN88LA094](https://openairdocs.org/ntsb/DEN88LA094.md): Agusta A109A · Sioux Falls, SD · Accident · No injuries · Limited investigation · Final report · Apr 9, 1988 · N33SV · Substantial damage
- [NTSB DEN88FA093](https://openairdocs.org/ntsb/DEN88FA093.md): Cessna 310I · Helena, MT · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1988 · N8008M · Destroyed
  > The acft depd glasgow, Montana, where the passenger (secretary of state for Montana) had been campaigning. Initially, a VFR flt plan had been filed; however, drg arrival at Helena, an IFR flt plan was filed when the plt realized the wx had deteriorated. The…
- [NTSB NYC88LA121](https://openairdocs.org/ntsb/NYC88LA121.md): Piper PA-31-325 · West Seneca, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1988 · N59845 · Destroyed
  > Loss of power due to fuel starvation. Contributing factor was adversed weather conditions.
- [NTSB BFO88FA034](https://openairdocs.org/ntsb/BFO88FA034.md): Piper PA-28-140 · Manassas, VA · Accident · 4 fatal · Field investigation · Final report · Apr 6, 1988 · N1719J · Destroyed
  > The pilot had departed waycross, GA, on the morning of the accident for a cross country flight to Manassas, VA. During the approach into Manassas, the aircraft contacted trees off the approach ends of rwys 34L and 34R. Both rwys were in use at the time and it…
- [NTSB DEN88LA092](https://openairdocs.org/ntsb/DEN88LA092.md): Cessna 210L · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Apr 5, 1988 · N910DS · Substantial damage
  > The CFI was giving a checkout to the private pilot doctor. The CFI flight records showed only one hour in this make/model. The fuel selector was in the right tank position throughout the flight. The pilot reported that the engine quit on one mile short final…
- [NTSB FTW88LA087](https://openairdocs.org/ntsb/FTW88LA087.md): Cessna 172E · Leona, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1988 · N8775U · Substantial damage
  > The plt planned his apch to land about 1000 ft down the 3400 ft dirt rwy because the first 1000 ft was wet and soft. The last 400 ft was also wet and soft. The wind was calm and the apch speed was high. During the flare, the acft ballooned and floated past…
- [NTSB LAX88LA151](https://openairdocs.org/ntsb/LAX88LA151.md): Ercoupe 415-C · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1988 · N99373 · Substantial damage
  > During a local flight in the pattern, the engine experienced a loss of power and a forced landing was made short of the runway. Inspection of the engine revealed that water was in the fuel pump bowl and rust was present on the cylinders.
- [NTSB CHI88FA090](https://openairdocs.org/ntsb/CHI88FA090.md): Piper PA-32-300 · Quincy, IL · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1988 · N32076 · Destroyed
  > Descent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.
- [NTSB MKC88FA072](https://openairdocs.org/ntsb/MKC88FA072.md): Beech H18 · Kansas City, MO · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1988 · N989B · Destroyed
  > The cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…
- [NTSB MIA88LA137](https://openairdocs.org/ntsb/MIA88LA137.md): Grumman G-164A · Wayside, MS · Accident · No injuries · Limited investigation · Final report · Apr 1, 1988 · N7961 · Substantial damage
  > While on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…
- [NTSB LAX88LA155](https://openairdocs.org/ntsb/LAX88LA155.md): Cessna 182RG · Davis, CA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1988 · N400BT · Substantial damage
- [NTSB NYC88LA113](https://openairdocs.org/ntsb/NYC88LA113.md): Piper J-3 · Downingtown, PA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1988 · N7170H · Substantial damage
  > The pilot was performing touch and go wheel landings. During an approach the pilot came in too low and the right main landing gear impacted an electric power pole. The pilot landed the aircraft on a grass strip with only the left main gear then flipped…
- [NTSB LAX88FA140](https://openairdocs.org/ntsb/LAX88FA140.md): Enstrom 280C · Fremont, CA · Accident · No injuries · Field investigation · Final report · Mar 27, 1988 · N5692P · Substantial damage
  > Failure of the engine to main rotor drive system due to a drive belt slippage caused by a drive pulley worn beyond its service limit. Contributing to the accident was the inadequate factory maintenance manuals which did not provide the serviceable limits for…
- [NTSB MIA88LA129](https://openairdocs.org/ntsb/MIA88LA129.md): Piper PA-28-151 · Terra Ceia, FL · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N44759 · Destroyed
  > While on a cross country flt, the plt elected to return to the departure point due to 'bad weather.' He later advised tower personnel when the flt was 10 miles south, inbound for landing. The plt was given landing information after which he reported a loss of…
- [NTSB DEN88FA087](https://openairdocs.org/ntsb/DEN88FA087.md): Cessna 421A · Albuquerque, NM · Accident · 2 fatal · Field investigation · Final report · Mar 26, 1988 · CGVDG · Destroyed
  > The plt and one pax were on a business trip in the U.S. From Canada. The plt had the acft fuel tanks 'topped off' prior to departure from Kansas city. The flt plan indicated 3 hours 30 min enroute to Albuquerque with 5 hours 30 min of fuel on board. Strong…
- [NTSB CHI88FA082](https://openairdocs.org/ntsb/CHI88FA082.md): Piper PA-23-250 · Alma, MI · Accident · Minor injuries · Field investigation · Final report · Mar 25, 1988 · N54848 · Destroyed
  > Drg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…
- [NTSB MKC88FA067](https://openairdocs.org/ntsb/MKC88FA067.md): Piper PA-23-250 · Excelsior Spgs, MO · Accident · No injuries · Field investigation · Final report · Mar 22, 1988 · N62526 · Destroyed
  > During arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…
- [NTSB MIA88LA128](https://openairdocs.org/ntsb/MIA88LA128.md): Cessna 150H · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Mar 22, 1988 · N22954 · Substantial damage
  > The 3.8 hr cross country flt was uneventful, but after the flt entered the downwind leg of the traffic pattern for landing, the eng quit due to fuel exhaustion. During the forced landing the acft collided with trees & came to rest.
- [NTSB ATL88LA121](https://openairdocs.org/ntsb/ATL88LA121.md): Cessna 140 · Easley, SC · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N2233N · Substantial damage
  > The plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…
- [NTSB SEA88FA060](https://openairdocs.org/ntsb/SEA88FA060.md): Pitts S-1C · Carson City, NV · Accident · Serious injuries · Field investigation · Final report · Mar 19, 1988 · N6389 · 2 aircraft · Destroyed
  > Upon returning to the Carson airport, N3545 (nieuport) approached from the south and executed a 45 degree entry to the downwind leg for runway 27. While established on final and approximately 100 feet from the threshold to runway 27, and at an elevation of…
- [NTSB CHI88FA079](https://openairdocs.org/ntsb/CHI88FA079.md): Bell 206L-1 · Taylorville, IL · Accident · Serious injuries · Field investigation · Final report · Mar 18, 1988 · N5759H · Destroyed
  > The helicopter experienced a loss of control while in slow flight out of ground effect. The helicopter impacted the ground in a black plowed field during a period of low visibility due to snow. The occurrence happened in a remote area with few ground…
- [NTSB LAX88FA130](https://openairdocs.org/ntsb/LAX88FA130.md): Dornier DO-24 · Oildale, CA · Accident · Serious injuries · Field investigation · Final report · Mar 17, 1988 · N772AX · Destroyed
  > Pilot's improper fuel consumption calculations and his failure to properly use the mixture control.
- [NTSB MIA88FA127](https://openairdocs.org/ntsb/MIA88FA127.md): Mooney M-20J · Fernandina Bch, FL · Accident · 1 fatal · Field investigation · Final report · Mar 15, 1988 · N4781H · Destroyed
  > The private pilot flew a flight that consumed about 31 gallons of fuel from a 31 gallon tank. The other fuel tank still had 31 gallons of fuel. The engine failed on base leg and the aircraft crashed in a wooded area. The pilot did not switch the fuel selector…
- [NTSB SEA88LA055](https://openairdocs.org/ntsb/SEA88LA055.md): Cessna 207A · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Mar 10, 1988 · N6380H · Substantial damage
  > During a maintenance flight, while on final approach, the engine ceased operating. Adequate fuel was available in the right fuel tank. The left fuel tank contained 4.5 gallons of which 3.5 gallons are unusable. The plt said he was slipping the acft on the…
- [NTSB CHI88LA076](https://openairdocs.org/ntsb/CHI88LA076.md): Piper PA-31-350 · Dixon, IL · Accident · No injuries · Limited investigation · Final report · Mar 10, 1988 · N4072D · Substantial damage
- [NTSB LAX88LA119](https://openairdocs.org/ntsb/LAX88LA119.md): Cessna 172N · Columbia, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 1988 · N8216E · Substantial damage
  > At the end of a pleasure flight, while on short final over the landing threshold, the left wing suddenly lifted. The pilot lost control of the aircraft which collided with the terrain and nosed over. There were no reported mechanical failures or malfunctions.
- [NTSB CHI88IA074](https://openairdocs.org/ntsb/CHI88IA074.md): Swearingen SA226T · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 7, 1988 · N600TA · 2 aircraft · No damage
  > The TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft.
- [NTSB CHI88DEP04](https://openairdocs.org/ntsb/CHI88DEP04.md): Cessna 172L · West Bend, WI · Accident · No injuries · Final report · Mar 6, 1988 · N7089Q · Substantial damage
  > After 30 minutes of local flight, on a dark night, the pilot increased the throttle setting after selecting approach flaps. There was no response from the engine. A forced landing was initiated and the aircraft collided with trees and terrain. A subsequent…
- [NTSB ATL88FA106](https://openairdocs.org/ntsb/ATL88FA106.md): Cessna 150 · Knoxville, TN · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1988 · N60371 · 2 aircraft · Minor damage
  > The Cessna made a long straight in final approach. The aircraft's radio transmitter was inop. Afterward the Cessna PIC rpted that initially he saw the Beech on a left base. Later he stated the Beech was heading away from the traffic pattern. Witnesses…
- [NTSB CHI88DEM02](https://openairdocs.org/ntsb/CHI88DEM02.md): Galloway XTC · Lowell, MI · Accident · No injuries · Final report · Mar 5, 1988 · N3969C · Substantial damage
  > The pilot of the homebuilt aircraft was attempting to perform some 'pattern flights' when, after turning on to the base leg of the traffic pattern, the engine seized. The pilot attempted to 'dead stick' the aircraft to the runway, but altitude and airspeed…
- [NTSB BFO88FA025](https://openairdocs.org/ntsb/BFO88FA025.md): Cessna 150E · Mitchellville, MD · Accident · No injuries · Field investigation · Final report · Mar 2, 1988 · N6202T · Substantial damage
  > The student plt elected to initiate the flt even though the flaps malfunctioned during the previous flt. Shortly after takeoff the plt was unable to keep the flaps in the extended position. The plt had not been feeling well on the morning of the flt and felt…
- [NTSB CHI88DEX02](https://openairdocs.org/ntsb/CHI88DEX02.md): Logan Junior ACE · Cloverdale, IN · Accident · Serious injuries · Final report · Feb 29, 1988 · N21BL · Substantial damage
  > During approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.
- [NTSB NYC88LA096](https://openairdocs.org/ntsb/NYC88LA096.md): Piper PA-24-250 · Plymouth, MA · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1988 · N5435P · Destroyed
  > The pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…
- [NTSB NYC88DNA01](https://openairdocs.org/ntsb/NYC88DNA01.md): Grosvenor Quickie · Middletown, RI · Accident · No injuries · Final report · Feb 28, 1988 · N3774X · Substantial damage
  > The worn propeller transmission (reduction gear assembly), which failed to transmit power to the propeller at a critical point in the go-around.
- [NTSB MIA88LA117](https://openairdocs.org/ntsb/MIA88LA117.md): Cessna 150M · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1988 · N66661 · 2 aircraft · Substantial damage
  > The plt stated that he turned a long final apch due to other traffic in the pattern. He only saw one other acft in front of him. He was approximately 200 feet from the end of the runway when he felt the impact as the two acft collided. He then attempted to go…
- [NTSB LAX88FA117](https://openairdocs.org/ntsb/LAX88FA117.md): Piper PA-28R-180 · Soledad, CA · Accident · Serious injuries · Field investigation · Final report · Feb 27, 1988 · N7660J · Substantial damage
  > Pilot's failure to promptly initiate remedial action and his failure to raise the aircraft's landing gear during an attempted go-around. Contributing factors relate to the pilot's poor in-flight decision, inattentiveness to VFR procedures and his not…
- [NTSB FTW88FA074](https://openairdocs.org/ntsb/FTW88FA074.md): Cessna 150J · Henderson, TX · Accident · 1 fatal · Field investigation · Final report · Feb 27, 1988 · N5522G · 2 aircraft · Substantial damage
  > The Cessna had just rolled out on base on 3rd or 4th touch go when it collided with a biplane that was not in the traffic pattern. Collision occurred between the outer panel of the left upper wing of the biplane and the rt side of the eng cowling of the…

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

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

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