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

## Cases, newest first

- [NTSB SEA88LA152](https://openairdocs.org/ntsb/SEA88LA152.md): Cassutt III · Shelton, WA · Accident · 1 fatal · Limited investigation · Final report · Aug 13, 1988 · N2984G · Destroyed
  > Acft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…
- [NTSB NYC88LA211](https://openairdocs.org/ntsb/NYC88LA211.md): Mooney M20C · E. Stroudsburg, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1988 · N2HV · Destroyed
  > The plt said that during an attempted landing the acft floated during the flare. After using about half the rwy he decided to go-around. The temp was 90 deg f resulting in a density alt of 3200 ft. the plt said he applied full pwr but the acft did not climb…
- [NTSB FTW88LA148](https://openairdocs.org/ntsb/FTW88LA148.md): Piper PA-32RT-300 · Edna, TX · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N8355L · Substantial damage
  > A delay in initiation of the go-around during the pilot's second attempt to land in the dark night conditions. Contributing to the accident was the runway closure due to construction, which resulted in no runway lights illuminated, and the fact that the pilot…
- [NTSB DEN88LA181](https://openairdocs.org/ntsb/DEN88LA181.md): Cessna 180 · Cascade, MT · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N1509C · Substantial damage
  > The plt was landing at an unattended airstrip with a 1000' dirt rwy. There was a northerly wind, but due to the sloping rwy terrain, he elected to use rwy 19 & land uphill with a tailwind. The plt rprted that as he was about to flare, the acft pitched down &…
- [NTSB MKC88LA152](https://openairdocs.org/ntsb/MKC88LA152.md): Cessna 150 · Coy, AR · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N8697S · Substantial damage
  > While practicing for his pvt plt check ride, the student pilot returned to the airstrip to practice takeoffs and ldgs. He lost all power on final approach, and due to aircraft on the departure end of the runway, he attempted an emergency ldg on an adjacent…
- [NTSB NYC88LA210](https://openairdocs.org/ntsb/NYC88LA210.md): Robinson R22 · Ashburnham, MA · Accident · No injuries · Limited investigation · Final report · Aug 5, 1988 · N90789 · Substantial damage
  > A student pilot and flight instructor were making a practice pinnacle approach. The student pilot tried to terminate the descent, but was unable and a landing on rough terrain took place. The helicopter rolled over and received substantial damage but the two…
- [NTSB MIA88LA245](https://openairdocs.org/ntsb/MIA88LA245.md): Stanford Monofly · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N70061 · Substantial damage
  > Flt experienced total loss of engine power while on a downwind position for landing. The runway could not be reached and a forced landing was made in trees. The fuel pump was mounted directly to the engine block and auto fuel was being used. After the…
- [NTSB MIA88LA242](https://openairdocs.org/ntsb/MIA88LA242.md): Beech B19 · Greenville, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1988 · N1948W · Substantial damage
  > The pilot reported that while on short final during a personal flt, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a levee, small trees, then the terrain.
- [NTSB CHI88DEI03](https://openairdocs.org/ntsb/CHI88DEI03.md): Piper PA-28-140 · Salem, OH · Accident · Minor injuries · Final report · Aug 2, 1988 · N7024R · Substantial damage
  > The airplane engine failed to respond when the throttle was advanced during the recovery from a practice forced landing. The airplane struck wires while attempting to reach a suitable landing area during the resulting forced landing. The wires did not break;…
- [NTSB LAX88LA276](https://openairdocs.org/ntsb/LAX88LA276.md): Raven RX-6 · Sun City, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 1988 · N1183R · Substantial damage
  > The pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…
- [NTSB MIA88FA239](https://openairdocs.org/ntsb/MIA88FA239.md): Piper PA-23-160 · Avon Park, FL · Accident · 2 fatal · Field investigation · Final report · Jul 30, 1988 · N3464P · Destroyed
  > The CFI radioed that he would be conducting a simulated engine-out aprch. 2 plt witnesses, 1 of whom was a CFI, stated that acft was seen on final aprch at about 200 ft with the left prop feathered & the gear & flaps down. They stated that although the acft…
- [NTSB LAX88FA274](https://openairdocs.org/ntsb/LAX88FA274.md): Learjet 23 · Perris, CA · Accident · 2 fatal · Field investigation · Final report · Jul 30, 1988 · N745F · Destroyed
  > The pilot decided to conduct his flight with known aircraft deficiencies. Induced company pressure to deliver the aircraft to its destination is considered to have been a factor in the accident.
- [NTSB LAX88LA271](https://openairdocs.org/ntsb/LAX88LA271.md): Piper PA-38-112 · Healdsburg, CA · Accident · No injuries · Limited investigation · Final report · Jul 29, 1988 · N91352 · Substantial damage
  > Solo student pilot failed to maintain airspeed above the stall speed during the go around attempt, thereby losing control of the airplane and stalling and mushing until colliding with a tree.
- [NTSB NYC88FA196](https://openairdocs.org/ntsb/NYC88FA196.md): Piper PA-28-140 · Pocantico Hills, NY · Accident · 2 fatal · Field investigation · Final report · Jul 27, 1988 · N9715W · Destroyed
  > The non-instrument rated private pilot departed in instrument flight conditions against the advice of several people he talked to. Approximately 1 hour and 30 minutes after departure the first of four or five mayday calls were heard by bridgeport radio and an…
- [NTSB CHI88LA174](https://openairdocs.org/ntsb/CHI88LA174.md): Cessna 172 · Neillsville, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1988 · N5700A · Destroyed
- [NTSB SEA88LA139](https://openairdocs.org/ntsb/SEA88LA139.md): Cessna 172 · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Jul 26, 1988 · N46692 · Substantial damage
  > The pilot reported that he encountered a downdraft on final. He added power for a go-around; however, a wingtip struck the ground. The aircraft cartwheeled and came to rest to the left of the runway.
- [NTSB MKC88MA134](https://openairdocs.org/ntsb/MKC88MA134.md): Learjet 35A · Morristown, NJ · Accident · 1 fatal · Major investigation · Final report · Jul 26, 1988 · N442NE · Destroyed
  > The crew was positioning the aircraft in preparation for a revenue flight and executing a non-directional beacon (NDB) apch to rwy 05. The captain reported that the copilot was flying the acft. However, the capt stated that he took controlof the acft during…
- [NTSB BFO88LA069](https://openairdocs.org/ntsb/BFO88LA069.md): Bellanca 7GCAA · Windsor, VA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1988 · N31253 · Substantial damage
  > While on long final after a glider tow flight the eng lost power. A forced landing was made in an open field and when the plt applied brakes, the acft nosed over. Post accident exam of the acft revealed 1 gallon of fuel remained. The plt reported that he…
- [NTSB LAX88DUD01](https://openairdocs.org/ntsb/LAX88DUD01.md): Ferris VARI-EZE · Hawthorne, CA · Accident · Minor injuries · Final report · Jul 23, 1988 · N7YE · Substantial damage
  > During a local flight, while on final approach, the pilot reported that a gust of wind from the right raised the right wing resulting in the left wing contacting the runway. The pilot lost control of the airplane which nosed over during the landing roll.…
- [NTSB FTW88DPA05](https://openairdocs.org/ntsb/FTW88DPA05.md): Luscombe 8A · Burleson, TX · Accident · No injuries · Final report · Jul 23, 1988 · N25236 · Substantial damage
  > The airplane was on downwind when the pilot pulled on the carburetor heat and reduced the RPM. When he reapplied power, the engine would not respond. During the forced landing, the pilot got the airplane on the airport but hit the right wing and tailwheel on…
- [NTSB MKC88LA133](https://openairdocs.org/ntsb/MKC88LA133.md): Grumman 164A · Poplar Bluff, MO · Accident · No injuries · Limited investigation · Final report · Jul 19, 1988 · N8706H · Substantial damage
  > The pilot experienced an engine failure while attempting to land during an aerial application flight. Altitude was not adequate to select a suitable forced landing area. The aircraft impacted in a pipeline right of way and came to rest in a small stream,…
- [NTSB MKC88LA132](https://openairdocs.org/ntsb/MKC88LA132.md): Grumman G-164A · Knobel, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1988 · N6553 · Substantial damage
  > Proper touchdown point not attained, and aircraft control not maintained by the pilot in command.
- [NTSB LAX88LA263](https://openairdocs.org/ntsb/LAX88LA263.md): Cessna 182 · Ajo, AZ · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N6223A · Substantial damage
  > The plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…
- [NTSB MIA88FA224](https://openairdocs.org/ntsb/MIA88FA224.md): Beech 95 · Destin, FL · Accident · 2 fatal · Field investigation · Final report · Jul 17, 1988 · N669Q · Destroyed
  > Plt reported arpt in sight and was cleared for visual approach. Witnesses reported seeing acft on left downwind & said it flew into a thundershower. The flt was not heard from again. The acft's wreckage was found in the bay 1 1/4 miles north of the runway.…
- [NTSB DEN88LA160](https://openairdocs.org/ntsb/DEN88LA160.md): Cessna 180 · Boulder, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1988 · N2815A · Substantial damage
  > According to the plt, he was returning to Boulder after making a flt to aspen. He said he started the morning flt with 2/3 fuel load (about 40 gallons) but didn't know how much flt time he accumulated during the day. During his VFR approach to the Boulder…
- [NTSB MIA88LA226](https://openairdocs.org/ntsb/MIA88LA226.md): Evans Maxair MU503 · Fort Walton Bch, FL · Accident · No injuries · Limited investigation · Final report · Jul 16, 1988 · N5358G · Substantial damage
  > While on a personal flt with reported thunderstorms in the vicinity, the plt lost control of the homebuilt acft while on final aprch to land. The acft descended & collided with terrain.
- [NTSB DEN88LA157](https://openairdocs.org/ntsb/DEN88LA157.md): Cessna 182A · Gillette, WY · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1988 · N5903B · Substantial damage
- [NTSB CHI88DEX09](https://openairdocs.org/ntsb/CHI88DEX09.md): Sollars Rotorway Executive · Newburgh, IN · Accident · Serious injuries · Final report · Jul 15, 1988 · N3047 · Substantial damage
  > The eng lost power as the homebuilt helicopter was on an apch to land at a private heliport. The student plt rprtd the helicopter was at aprx 50 ft AGL when the power loss occurred. Subsequently, during an autorotation, the helicopter touched down hard. No…
- [NTSB CHI88DEP05](https://openairdocs.org/ntsb/CHI88DEP05.md): Griffin Pitts S-1S · Rio, WI · Accident · No injuries · Final report · Jul 11, 1988 · N77LG · Substantial damage
  > When the pilot of the amateur built biplane initiated a go-around from a VFR approach, he found that he had no response to throttle application. He then executed an intentional forced landing in an adjacent field. During this landing the aircraft collapsed a…
- [NTSB ATL88LA212](https://openairdocs.org/ntsb/ATL88LA212.md): Cessna 310 · New Bern, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1988 · N670R · Substantial damage
  > The plt rptd the lt engine lost pwr on 'very short final'. Shortly thereafter, he heard the stall warning. The airplane rolled and yawed left, and crashed nose-down short of the rwy. The acft was examined the next day by an FAA inspector; he rptd finding no…
- [NTSB CHI88LA156](https://openairdocs.org/ntsb/CHI88LA156.md): Piper PA-28-180 · Moraine, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1988 · N7222W · 2 aircraft · Substantial damage
  > While on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…
- [NTSB FTW88LA128](https://openairdocs.org/ntsb/FTW88LA128.md): Cessna 170 · Marble Falls, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N2642V · Substantial damage
  > The pilot lost directional control during the lndg on runway 17. The aircraft collided with the terrain and trees after veering off the right side of the runway. The pilot reported a left quartering headwind of 25 knots gusting to 35 knots. The acft was…
- [NTSB CHI88LA151](https://openairdocs.org/ntsb/CHI88LA151.md): Cessna 177 · Lowell, IN · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N30238 · Substantial damage
  > The student pilot was on final approach for landing when the aircraft began to drift to the left of the runway. The pilot decided to go-around and added full power, pushed the carburetor heat in and retracted the flaps to '1/2'. According to the pilot he…
- [NTSB NYC88DHD03](https://openairdocs.org/ntsb/NYC88DHD03.md): Schweizer SGS 1-23H-15 · Hammonton, NJ · Accident · Serious injuries · Final report · Jul 2, 1988 · N8619R · Destroyed
  > The glider pilot's failure to avoid the stall/spin encountered during low altitude operation in the traffic pattern.
- [NTSB LAX88DVD06](https://openairdocs.org/ntsb/LAX88DVD06.md): Locolce/Blackwell Falcon XP · Antioch, CA · Accident · Serious injuries · Final report · Jul 2, 1988 · N607AA · Substantial damage
  > While entering downwind for landing, the rudder did not respond. The airplane began to yaw to the left at a 30 degree banking spiral turn. The pilot deployed the emergency parachute and the airplane collided with the terrain. Inspection of the airplane…
- [NTSB NYC88LA174](https://openairdocs.org/ntsb/NYC88LA174.md): Piper PA-23-250 · East Hampton, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1988 · N62771 · Destroyed
  > The pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…
- [NTSB LAX88LA243](https://openairdocs.org/ntsb/LAX88LA243.md): Ryan Navion · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1988 · N4179K · Substantial damage
- [NTSB DEN88LA143](https://openairdocs.org/ntsb/DEN88LA143.md): Mooney M-20K · Gunnison, CO · Accident · No injuries · Limited investigation · Final report · Jul 1, 1988 · N231PG · Substantial damage
- [NTSB CHI88FA145](https://openairdocs.org/ntsb/CHI88FA145.md): Piper PA-28R-200 · Detroit Lakes, MN · Accident · No injuries · Field investigation · Final report · Jun 29, 1988 · N44140 · Substantial damage
- [NTSB SEA88LA118](https://openairdocs.org/ntsb/SEA88LA118.md): I.C.A. Brasov IS-29D · Athol, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 26, 1988 · N91419 · Destroyed
  > Plt was on third flt in make/model. Witness stated approach was too low and slow to make airport. Acft made a turn to the left and then to the right. Wing dropped and acft entered stall/spin to the right and continued rotation to the ground.
- [NTSB DEN88LA136](https://openairdocs.org/ntsb/DEN88LA136.md): Piper PA-28-160 · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1988 · N5113W · Substantial damage
  > The low time private plt and his non-pilot wife were practicing touch and go landings. The plt used the right seat and his wife used the left seat. While on final apch, the plt recognized that the airplane was too high, added full flaps and cut the power. The…
- [NTSB LAX88FA230](https://openairdocs.org/ntsb/LAX88FA230.md): Cessna 310 · Big Bear Lake, CA · Accident · 4 fatal · Field investigation · Final report · Jun 23, 1988 · N170R · Destroyed
  > The recently certificated multiengine pilot and friends flew to big Bear airport for lunch. The density altitude at the airport was about 8,000 feet. The pilot entered a south downwind leg for runway 07 at the airport following a Mooney 231. Ground witnesses…
- [NTSB LAX88LA205](https://openairdocs.org/ntsb/LAX88LA205.md): Cessna 150J · Calistoga, CA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1988 · N61175 · Substantial damage
- [NTSB MIA88LA199](https://openairdocs.org/ntsb/MIA88LA199.md): Cessna 152 · Coldwater, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1988 · N95056 · Substantial damage
  > The physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…
- [NTSB LAX88LA225](https://openairdocs.org/ntsb/LAX88LA225.md): Beech 77 · Santa Barbara, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1988 · N37354 · Substantial damage
- [NTSB CHI88DEC03](https://openairdocs.org/ntsb/CHI88DEC03.md): Cessna 150 · Jackson, MI · Accident · Minor injuries · Final report · Jun 18, 1988 · N5810E · Substantial damage
  > Total loss of engine power due to carburetor icing.
- [NTSB MIA88FA195](https://openairdocs.org/ntsb/MIA88FA195.md): Piper PA-31-P · Miami Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Jun 17, 1988 · N560JB · Destroyed
  > The instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…
- [NTSB LAX88LA226](https://openairdocs.org/ntsb/LAX88LA226.md): de Havilland DHC-6-100 · Tau, Antarctica · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 1988 · N202RH · Destroyed
  > The captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…
- [NTSB ATL88LA194](https://openairdocs.org/ntsb/ATL88LA194.md): Cessna 150F · Newnan, GA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1988 · N7776F · Destroyed
  > After making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…
- [NTSB BFO88FA054](https://openairdocs.org/ntsb/BFO88FA054.md): Cessna 177RG · Clinton, MD · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1988 · N2070Q · Substantial damage
  > Eng pwr loss occurred when the instrument student advanced the throttle to do a go-around when the acft was too high to lnd on rwy 5 following a simulated instrmt apch. The instr took control of the acft and about half-way down the rwy, at about 300 ft AGL,…

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

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

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