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

## Cases, newest first

- [NTSB ATL85LA257](https://openairdocs.org/ntsb/ATL85LA257.md): Piper PA-30 · Portland, TN · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1985 · N7369Y · Substantial damage
  > The plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.
- [NTSB DEN85LA228](https://openairdocs.org/ntsb/DEN85LA228.md): Beech V35B · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N25AB · Substantial damage
  > The aircraft collided with the ground off to the side of the runway during a go around. The pilot had retracted the flaps and gear prior to ground contact. The pilot said he should not have retracted the flaps to the full up position.
- [NTSB ATL85LA255](https://openairdocs.org/ntsb/ATL85LA255.md): Cessna 172E · Villa Rica, GA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1985 · N8499U · Substantial damage
  > The plt took off from the stockmar arpt on a local flt. After flying in the local area, he returned at dusk to land, but inadvertently made an approach to another arpt that was located about 1/2 mi from the stockmar arpt. He did not realized that he was…
- [NTSB LAX85LA359](https://openairdocs.org/ntsb/LAX85LA359.md): Cessna 150 · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1985 · N6900S · Substantial damage
  > The pilot stated he was on the downwind leg of the traffic pattern when the engine quit. He was unable to glide to the runway and landed in a construction area where the aircraft collided with a dirt pile and flipped over. He further stated that he had flown…
- [NTSB ATL85LA253](https://openairdocs.org/ntsb/ATL85LA253.md): Piper PA-18S · Carlisle, MS · Accident · No injuries · Limited investigation · Final report · Aug 20, 1985 · N3267N · Substantial damage
  > After aprx 1 hr of LCL flt, the 67 hr pvt plt returned to his pvt grass strip for landing. He made a full left traffic pattern. At the 180 deg point, carb heat was applied and pwr reduced. After turning final and lowering full flaps, the plt added throttle…
- [NTSB ANC85MA157](https://openairdocs.org/ntsb/ANC85MA157.md): Gates Learjet 24D · Gulkana, AK · Accident · 3 fatal · Major investigation · Final report · Aug 20, 1985 · N455JA · Destroyed
  > During a night arrival, the flt was on an instrument apch to the Gulkana arpt when radio contact with the acft was lost. A search was initiated & the wreckage was found 7.4 mi north of the terminal VOR on the 330 deg radial. The inbound course for the VOR rwy…
- [NTSB DEN85LA224](https://openairdocs.org/ntsb/DEN85LA224.md): Cessna 172 M · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · N9880V · Substantial damage
  > The student pilot stated that he was attempting to land on runway 14. He executed a go-around because the aircraft was not aligned with the runway. The pilot applied full power and raised the flaps. Because of the flap switch design, when the pilot put the…
- [NTSB NYC85FHJ05](https://openairdocs.org/ntsb/NYC85FHJ05.md): Maule M-4-220C · Somers, NY · Accident · No injuries · Final report · Aug 17, 1985 · N40326 · Destroyed
  > The acft stalled & nosed over during an attempted go-around after a fast approach to a gravel landing strip which was 5 miles from the planned destination. The plt said he added power to go around when he thought his airspeed was too high. The acft dropped on…
- [NTSB FTW85LA325](https://openairdocs.org/ntsb/FTW85LA325.md): Piper PA-28-181 · Llano, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1985 · N2217G · Substantial damage
  > The plt stated he entered the traffic pattern at 2000 ft for a left downwind to rwy 17. He then reduced pwr to 1700 RPM and placed the mixture control into the full rich position. He assured that carburetor heat was off and then started his descent. The eng…
- [NTSB BFO85LIA01](https://openairdocs.org/ntsb/BFO85LIA01.md): Cessna U206 · Leesburg, VA · Accident · No injuries · Final report · Aug 16, 1985 · N7144Q · Substantial damage
  > The acft was on a round-robin x-country flt from Leesburg to manassas, VA, gaithersburg, MD & return to Leesburg. When the plt departed gaithersburg on the final leg of the flt, he estimated he had 11 gal of fuel. He reported that during arrival at Leesburg,…
- [NTSB ATL85LA260](https://openairdocs.org/ntsb/ATL85LA260.md): Smith, Ted Aerostar Aerostar 601P · Prestonburg, KY · Accident · No injuries · Limited investigation · Final report · Aug 15, 1985 · N9763Q · Substantial damage
  > The pilot stated that while on short final the aircraft encountered a down draft which caused a sudden loss of altitude resulting in a hard landing. The aircraft tire blew on landing and the aircraft veered off of the side of the runway and was substantially…
- [NTSB MIA85FA234](https://openairdocs.org/ntsb/MIA85FA234.md): Cessna C-172M · Immokalee, FL · Accident · Serious injuries · Field investigation · Final report · Aug 14, 1985 · N13750 · Destroyed
  > The acft had departed from the north-south oriented grass strip for a local flt and was returning to land toward the north. On short final the acft collided with an umarked power transmission line aprx 100 ft AGL and 0.25 mile south of the apch end of the…
- [NTSB BFO85FA067](https://openairdocs.org/ntsb/BFO85FA067.md): Bellanca 17-31A · Woodbridge, VA · Accident · 2 fatal · Field investigation · Final report · Aug 13, 1985 · N8242R · Destroyed
  > The acft departed saratoga springs, NY, en route to manassas, VA. Wx was VFR and as the acft approached gaithersburg, MD, at 2132 LCL the plt contacted dulles apch for vectors through the area to manassas. The acft was issued a heading to manassas. Shortly…
- [NTSB MIA85FA233](https://openairdocs.org/ntsb/MIA85FA233.md): Cessna C-150 · Kissimmee, FL · Accident · No injuries · Field investigation · Final report · Aug 12, 1985 · N704MH · 2 aircraft · Minor damage
  > The acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely.
- [NTSB FTW85LA316](https://openairdocs.org/ntsb/FTW85LA316.md): Cessna 150M · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Aug 12, 1985 · N714DM · Substantial damage
  > The acft lost eng pwr while on downwind for rwy 12. The plt was cleared to land on any rwy and he chose rwy 36. (The south end of this rwy joins rwy 13 at midfield). However, a strong tail wind prevailed and the acft was high and fast. It touched down on rwy…
- [NTSB NYC85LA206](https://openairdocs.org/ntsb/NYC85LA206.md): Cessna C150 · Eliot, ME · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1985 · N714NC · Substantial damage
  > Aircraft collided with trees when the aircraft stalled during an attempted go around. The student pilot was on his first solo supervised flight. On landing he came in long and prior to the wheels touching down, power was added. However during the climb, with…
- [NTSB LAX85LA346](https://openairdocs.org/ntsb/LAX85LA346.md): Cessna 150M · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1985 · N3359V · Substantial damage
  > The CFI, who was a retired airline captain, and his student pilot, embarked on a round-robin flight which included landings at four arpts. The fuel tanks were not completely filled prior to th initial departure and no additional fuel was obtained during the…
- [NTSB CHI85LA342](https://openairdocs.org/ntsb/CHI85LA342.md): Cessna 152 · Lansing, IL · Accident · No injuries · Limited investigation · Final report · Aug 8, 1985 · N65619 · Substantial damage
  > The student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…
- [NTSB FTW85FA308](https://openairdocs.org/ntsb/FTW85FA308.md): Fairchild Swearingen SA226TC · Dallas, TX · Accident · No injuries · Field investigation · Final report · Aug 7, 1985 · N5356M · Substantial damage
  > The aircraft sustained substantial damage when it landed with the gear up. The pilots reported lowering the gear, but did not confirm the gear position. The tower transmitted a warning, but the crew did not respond. Subsequent investigation revealed a…
- [NTSB CHI85LA337](https://openairdocs.org/ntsb/CHI85LA337.md): Cessna 402B · Moline, IL · Accident · No injuries · Limited investigation · Final report · Aug 7, 1985 · N100FG · Substantial damage
  > The acft was landed on soft terrain 1500 ft short of the rwy following a total loss of pwr. The plt reported he failed to use fuel from the aux tanks during the flt and he exhausted the fuel in the main tanks. The fuel boost pumps are located in the main…
- [NTSB ANC85LA149](https://openairdocs.org/ntsb/ANC85LA149.md): Piper PA-20-135 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1985 · N7070K · Substantial damage
  > Low time student plt lost control during attempted go-around & crashed into two parked acft. 8 to 12 kt crosswind was reported.
- [NTSB FTW85LA305](https://openairdocs.org/ntsb/FTW85LA305.md): Cessna 152 · Sand Springs, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1985 · N47300 · Destroyed
  > The plt allowed the acft to get too low on the VFR final apch. He added pwr and stated a gust of wind tipped the acft tothe left. When he corrected for this the acft's nose dropped and the nose sheel contacted the ground and separated. The acft then nosed…
- [NTSB ANC85FA146](https://openairdocs.org/ntsb/ANC85FA146.md): Piper PA-30 · Kodiak, AK · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1985 · N7811Y · Destroyed
  > During a wx briefing at 0719 adt, the plt was advised that VFR flt was not recommended. Later, at 0827. He called the fss to update his wx & filed an IFR clearance. At 0938, the acft departed anchorage. During arrival at Kodiak, the acft was cleared for an…
- [NTSB NYC85LA198](https://openairdocs.org/ntsb/NYC85LA198.md): Piper J3C-65 · Quakertown, PA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N92279 · Substantial damage
  > The acft collided with wires during a lndg attempt. The acft was thrown out of control and dragged a wing after which it nosed over. The plt said that he thought the wires had been cleared. He was trying to put the acft right at the edge of the field because…
- [NTSB FTW85LA294](https://openairdocs.org/ntsb/FTW85LA294.md): North American AT-6 · Port Isabel, TX · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N4434N · Substantial damage
  > The acft was substantially damaged when it undershot the runway and cartwheeled during an emergency landing following an engine failure in the traffic pattern. The plt reported that initial examination of the engine revealed that initial examination of the…
- [NTSB ATL85LA232](https://openairdocs.org/ntsb/ATL85LA232.md): Cessna 150L · Hattiesburg, MS · Accident · No injuries · Limited investigation · Final report · Aug 3, 1985 · N7952G · Substantial damage
  > During a full-flap approach to landing, the pilot saw that the acft was going to land long and he initiated a go-around. He began retracting the flaps at the same time, and the acft started to settle. The pilot then elected to continue the landing straight…
- [NTSB ATL85FA230](https://openairdocs.org/ntsb/ATL85FA230.md): Cessna 210N · Chamblee, GA · Accident · No injuries · Field investigation · Final report · Aug 3, 1985 · N6419N · Substantial damage
  > Plt had obtained check out in acft prior to departure on x-cflt. About 3.35 hrs into flt called atl ctr exp concern about fuel. At that time acft was about 4 mi w of rome ga VOR and about 15 mi from rome apt. Plt nor center were sure if fuel was avail at rome…
- [NTSB DCA85AA031](https://openairdocs.org/ntsb/DCA85AA031.md): Lockheed L-1011-385-1 · Dallas/Ft Worth, TX · Accident · 135 fatal · Final report · Aug 2, 1985 · N726DA · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Psbl…
- [NTSB NYC85LA210](https://openairdocs.org/ntsb/NYC85LA210.md): Cessna 172P · Stormville, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 1985 · N52503 · Substantial damage
  > According to the pilot, during the second touch and go landing, at abut 30 feet from touchdown, a wind gust lifted and veered the aircraft left of the runway centerline. The pilot attempted to go around applied full power; however, the left wing collided with…
- [NTSB ANC85LA140](https://openairdocs.org/ntsb/ANC85LA140.md): Balloon Works Firefly 8 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N7404X · Substantial damage
  > While the plt was approaching a field to land, the wind shifted & gusted, blowing the Balloon toward a light standard. The envelope grazed the standard, ripping the material near the top of the Balloon. The Balloon then landed in the field. The wind was…
- [NTSB LAX85LA335](https://openairdocs.org/ntsb/LAX85LA335.md): Beech 23 · Kamuela, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1985 · N2354Z · Substantial damage
  > On July 31, 1985, a Beech BE-23 operated by a student pilot, crashed during an attempted go-around at the waimea-kohala airport in Hawaii. The acft sustained substantial damage and the plt received minor injuries. The plt indicated he had not used full flaps…
- [NTSB ANC85LA141](https://openairdocs.org/ntsb/ANC85LA141.md): Cessna 188 · Dry Creek Mine, AK · Accident · No injuries · Limited investigation · Final report · Jul 31, 1985 · N53135 · Substantial damage
  > The plt reported that while on final apch aprx 100 ft from touchdown, the acft yawed to the left and the left wing dropped. The acft contacted the ground aprx 25 ft left of the rwy and nosed over.
- [NTSB SEA85LA186](https://openairdocs.org/ntsb/SEA85LA186.md): Cessna T210-L · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1985 · N15ES · Destroyed
  > The pilot failed to insure that adequate fuel was available for the flight. A visual inspection of the fuel in the fuel tanks was not done. To make matters worse landing was accomplished with gear down and flaps up-contrary to the recommended procedure for…
- [NTSB DEN85LA206](https://openairdocs.org/ntsb/DEN85LA206.md): Piper PA-22 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N5430Z · Substantial damage
  > According to the plt, he was approaching the Boulder municipal arpt, Boulder, Colorado, for a VFR landing when his engine failed to develop sufficient power to sustain flight. A forced landing was made to a farmer's field. The acft sustained substantial…
- [NTSB CHI85LA340](https://openairdocs.org/ntsb/CHI85LA340.md): Cessna 150J · Sharonville, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1985 · N51405 · Substantial damage
  > According to the plt, the eng quit 4 hrs into the flt due to 'apparent fuel exhaustion.' He had entered the blue ash traffic pattern instead of going to his original destination because his fuel gages read 1/8 full instead of 1/4 full as he had expected. The…
- [NTSB CHI85LA317](https://openairdocs.org/ntsb/CHI85LA317.md): Stinson L-5 · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N1156V · Substantial damage
  > The plt took off on a test flt to check the eng after it had been inspected & the carburetor had been overhauled. He made a ground check & full eng run-up before taking off. Intending to stay in a closed traffic pattern, he took off, made a normal climb in…
- [NTSB NYC85LA195](https://openairdocs.org/ntsb/NYC85LA195.md): Cessna 182C · West Lebanon, ME · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N8951T · Substantial damage
  > The acft nosed over after overrunning the airstrip following a loss of pwr. The plt reported the eng began running rough and the application of carb heat did not increase the pwr. During the landing apch the eng began runnin rougher and about 1/2 of the…
- [NTSB MKC85LA170](https://openairdocs.org/ntsb/MKC85LA170.md): Piper PA-28-181 · Leon, IA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1985 · N8089C · Substantial damage
  > The plt reported that when he was on final apch to land, the acft encountered a downdraft & its rate of descent increased. He applied power to correct the situation, but the left main gear hit a fence post aprx 10 ft short of the rwy & failed. Subsequently,…
- [NTSB SEA85LA176](https://openairdocs.org/ntsb/SEA85LA176.md): Beech A-24-R · Tuscarora, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1985 · N8026R · Destroyed
  > The plt was attempting to land on a dirt road uphill at about 6,200 ft with gear and flaps down a go-around was attempted at about 50 ft AGL when the plt decided not to land. The acft failed to climb and a barn was struck before it hit the ground. The density…
- [NTSB ANC85LA133](https://openairdocs.org/ntsb/ANC85LA133.md): Piper PA-18 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N8688D · Substantial damage
  > Plt stated, '... On the go-around attempt I got behind the power curve & could not clear the trees. It stalled & turned to the left, hitting the trees about 15 ft off the ground which cushioned the fall & then slid down to the ground.' The plt was attempting…
- [NTSB NYC85LA191](https://openairdocs.org/ntsb/NYC85LA191.md): Schweizer SGS 2-33A · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1985 · N2039T · Substantial damage
  > The aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…
- [NTSB MIA85IA217](https://openairdocs.org/ntsb/MIA85IA217.md): Cessna 402B · West Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Jul 24, 1985 · N1554G · Minor damage
  > Aircraft experienced unsafe right main gear indication several days prior to the incident. Mechanics found a damaged micro switch mounting plate which they repaired enough to hold until a new plate could be ordered and installed. On day of incident pilot…
- [NTSB DEN85LA197](https://openairdocs.org/ntsb/DEN85LA197.md): Piper PA-28 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N2203D · Substantial damage
  > The student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.
- [NTSB DEN85FA196](https://openairdocs.org/ntsb/DEN85FA196.md): Balloon Works Firefly 7 · Brighton, CO · Accident · Serious injuries · Field investigation · Final report · Jul 23, 1985 · N40501 · Destroyed
  > A hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…
- [NTSB CHI85LA311](https://openairdocs.org/ntsb/CHI85LA311.md): Piper PA-28-140 · Culver, IN · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N32858 · Substantial damage
  > The student plt was attempting his first solo landing and had difficulty correcting for the crosswind. When he was over the threshold, he initiated a go-around. The acft drifted to the left of the rwy and collided with trees 200 ft from the rwy centerline.…
- [NTSB CHI85LA309](https://openairdocs.org/ntsb/CHI85LA309.md): Cessna 150D · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N4460U · Substantial damage
  > When the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.
- [NTSB LAX85LA339](https://openairdocs.org/ntsb/LAX85LA339.md): Cessna 310D · Kahului, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1985 · N6740T · Substantial damage
  > On July 22, 1985, a Cessna 3100, N6740T experienced a loss of engine power while on final approach to the Kahului arpt in maui, Hawaii. The ac sustained substantial damage and the plt received minor injuries. The ac has a fuel capacity of 90 gal useable. The…
- [NTSB DEN85LA198](https://openairdocs.org/ntsb/DEN85LA198.md): Mooney M20K · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1985 · N3866H · Substantial damage
  > The plt reported that prior to landing, the UNICOM operator reported that the wind was from the northwest at 10 to 20 KTS & was gusty. Also, he said that while on base leg, he encountered a severe downdraft. He stated that he applied pwr & retracted the flaps…
- [NTSB CHI85LA308](https://openairdocs.org/ntsb/CHI85LA308.md): Cessna 150M · Mt Pleasant, MI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1985 · N6350K · Substantial damage
  > The student plt was on a solo x-country flt between maple grove arpt & houghton lake arpt. During the flt, the plt requested radar assistance to locate houghton lake. Due to her solo student status & the close proximity of Mt Pleasant arpt, she was advised to…
- [NTSB LAX85LUJ01](https://openairdocs.org/ntsb/LAX85LUJ01.md): Aerotek Pitts S-1 · Page, AZ · Accident · Minor injuries · Final report · Jul 21, 1985 · N1LM · Destroyed
  > The acft contacted the ground during an attempted go-around. The plt had tried to perform a x-wind landing.

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

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

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