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

## Cases, newest first

- [NTSB ANC83LA047](https://openairdocs.org/ntsb/ANC83LA047.md): Cessna 150G · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N8541J · Substantial damage
  > The student & instructor plt (CFI) were on an instructional flt on a cold winter day (temp -10 deg f). The CFI stated that while practicing turns at 3000 ft MSL, he closed the throttle to give the student a forced landing excercise. He stated that carburetor…
- [NTSB ATL83LA111](https://openairdocs.org/ntsb/ATL83LA111.md): Luscombe 8A · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Feb 20, 1983 · N2975K · Substantial damage
  > The plt intended to refuel at starkville, MS, but the FBO was closed. He continued to his intended destination of raymond, MS, but was unable to turn on the rwy lights. He then diverted to Jackson, MS. The plt realized the acft was low on fuel, but didn't…
- [NTSB LAX83LA109](https://openairdocs.org/ntsb/LAX83LA109.md): Midget Mustang I · Bermuda Dunes, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1983 · N138X · Destroyed
  > The acft crashed on a road near the active runway while making a go-around to avoid an acft which taxied on the runway as he approached. At about 400 feet AGL on final approach the pilot of the accident acft realized a safe landing was notpossible. He stalled…
- [NTSB DEN83FTK03](https://openairdocs.org/ntsb/DEN83FTK03.md): Beech V35A · Sioux Falls, SD · Accident · Serious injuries · Final report · Feb 16, 1983 · N8478N · Destroyed
  > During an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…
- [NTSB DCA83AA017](https://openairdocs.org/ntsb/DCA83AA017.md): de Havilland DHC-6-300 · Hailey, ID · Accident · Serious injuries · Final report · Feb 15, 1983 · N361V · Destroyed
  > The acft was less than 2 miles from the arpt of intended landing during the approach when the crew experienced a loss ofelevator control. The acft started diving toward the ground when the power was reduced. The plt applied full power to try and restore level…
- [NTSB MKC83LA068](https://openairdocs.org/ntsb/MKC83LA068.md): Cessna R182 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Feb 14, 1983 · N9886C · Substantial damage
  > Prior to landing, the pilot was unable to extend the left main gear and elected to land with all gear retracted. An investigation revealed that a bolt in the left main gear brake assembly was loose and jammed the wheel in the wheel well. An annual inspection…
- [NTSB CHI83FA114](https://openairdocs.org/ntsb/CHI83FA114.md): Piper PA-44-180T · Indianapolis, IN · Accident · Serious injuries · Field investigation · Final report · Feb 14, 1983 · N8278T · Destroyed
  > During an ILS apch to rwy 22R, apch control asked the plt to keep his speed up as much as practical. At a later inter- view, the plt could not remember details of the apch. He recalled putting the gear down at the outer marker (om) & using the autopilot to…
- [NTSB FTW83LA110](https://openairdocs.org/ntsb/FTW83LA110.md): Piper PA-22 · Hennessey, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1983 · N1139C · Substantial damage
  > While on a short final to land at a private ag strip, the acft struck power lines, then flipped over & impacted on the apch end of the rwy. Although the plt was unfaamilar with the arpt, she had been briefed on the existance of the wires before her departure.…
- [NTSB CHI83LA112](https://openairdocs.org/ntsb/CHI83LA112.md): Piper PA28-140 · Three Oaks, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 1983 · N6487W · Substantial damage
  > The acft collided with a wire during the landing approach and landed hard enough to collapse the nose gear. According to the owner the flt was not authorized and the person at the controls held no pilot certificate. The pilot made the following statement, 'I…
- [NTSB MKC83FA066](https://openairdocs.org/ntsb/MKC83FA066.md): Piper PA-28R-200 · Wichita, KS · Accident · Serious injuries · Field investigation · Final report · Feb 12, 1983 · N8981C · Destroyed
  > The acft was cleared to make the approach and to descend not below 2300 ft. the pilot descended from 3000 after he reported passing hance, the final appoach fix. He descended to 2300 ft at 500 ft a minute and leveled the acft and lowered the landing gear. The…
- [NTSB MIA83LA076](https://openairdocs.org/ntsb/MIA83LA076.md): Beech 23 · Naples, FL · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N2302L · Substantial damage
  > According to the pilot the engine lost power while on a short final due to water in the fuel. The acft impacted the ground at a high rate of sink, the nose gear collapsed and the acft was damaged substantially.
- [NTSB FTW83LA118](https://openairdocs.org/ntsb/FTW83LA118.md): Cessna 152 · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N5283P · Substantial damage
  > During a touch & go landing on runway 17, the student pilot allowed the acft to touch down short. The landing gear struck a 1 ft dirt bank aprx 2 ft short of the paved runway. A NOTAM was in effect to alert plts that the first 400 ft of runway 17 & 35 was…
- [NTSB CHI83LA110](https://openairdocs.org/ntsb/CHI83LA110.md): Cessna 152 · St. Cloud, MN · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N93214 · Substantial damage
  > During final the acft started to drift & the rate of descent increased. The plt was late in adding power & the acft touched down 75 ft short of the rwy in 20 inches of snow & nosed over.
- [NTSB CHI83FA108](https://openairdocs.org/ntsb/CHI83FA108.md): Champion 7KCAB · Reedsburg, WI · Accident · 2 fatal · Field investigation · Final report · Feb 12, 1983 · N5277X · Destroyed
  > The acft impacted a quonset-type bldg while apparently on an unusual type approach for landing. One witness observed theacft make a low south to north pass over the rwy & then pull up into a loop that culminated in the quonset impact. Another witness observed…
- [NTSB DEN83LA057](https://openairdocs.org/ntsb/DEN83LA057.md): Cessna 182Q · Burlington, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 1983 · N94618 · Destroyed
  > The acft crashed during an attempted go-around. The pilot had landed downwind with an approach speed of 80 KTS and 25 degrees flaps. The pilot said he used rwy 13 instead of 31 because of a NOTAM prohibiting landing on rwy 31. There was no NOTAM to that…
- [NTSB LAX83FA098](https://openairdocs.org/ntsb/LAX83FA098.md): Beech H35 · Tucson, AZ · Accident · No injuries · Field investigation · Final report · Feb 7, 1983 · N4687D · Substantial damage
  > During arrival, the plt was advised of the position of a Boeing 727 that was landing on rwy 29R & he reported seeing theacft. He also was cautioned about possible wake turbulence from the Boeing & he acknowledged. The plt reported that while he was on an…
- [NTSB FTW83LA106](https://openairdocs.org/ntsb/FTW83LA106.md): Robinson R22 · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Feb 7, 1983 · N90763 · Substantial damage
  > A simulated autorotational landing was initiated at about 450 ft AGL. During the approach, a 90 deg arc was flown toward an open field. A flare was begun with a power recovery at about 40 ft AGL when a wire was observed in the flight path. By this time, the…
- [NTSB DCA83IA016](https://openairdocs.org/ntsb/DCA83IA016.md): McDonnell Douglas DC-9-50 · Greer, SC · Incident · No injuries · Incident investigation · Final report · Feb 7, 1983 · N421EA · Minor damage
  > Acft drifted to the right before a missed apch was initiated during which it made an inadvertent touchdown & struck a rwy light. The plt erroneously used RVR as his landing minimum. Actual RVR was below the published minimum. The sequenceflasher lights were…
- [NTSB LAX83LA088](https://openairdocs.org/ntsb/LAX83LA088.md): Cessna 182P · Napa, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 1983 · N9907M · Substantial damage
  > The passenger, who was the owner of the acft, preflighted the acft & stated the fuel tanks were over half full. The plt also noted that both fuel gauges read over half full. The flt departed oakland at 1310. About 10 mi from Napa the plt briefly applied carb…
- [NTSB SEA83LA051](https://openairdocs.org/ntsb/SEA83LA051.md): Cessna 177A · Oregon City, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1983 · N30356 · Substantial damage
  > During arrival at dusk, the plt made an apch to rwy 9 with a headwind at 19, gusting 30 KTS. While on final apch, the acft collided with power lines near the apch end of the rwy. The plt reported that he did not see the lines until just prior to impact, then…
- [NTSB SEA83LA050](https://openairdocs.org/ntsb/SEA83LA050.md): Cessna 182N · Chiloquin, OR · Accident · No injuries · Limited investigation · Final report · Feb 2, 1983 · N92353 · Substantial damage
  > During a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…
- [NTSB ANC83LA040](https://openairdocs.org/ntsb/ANC83LA040.md): Taylorcraft BC-12-D · White Mountain, AK · Accident · No injuries · Limited investigation · Final report · Jan 31, 1983 · N39196 · Substantial damage
  > The plt was demonstrating ski landings on river ice. The OAT was at least minus 20 deg f. after a prolonged power-off descent he recognized a need for additional power but the eng would not respond. The plt attempted to stretch his glide but the acft stalled…
- [NTSB MKC83FA059](https://openairdocs.org/ntsb/MKC83FA059.md): Rockwell 500-S · Kansas City, KS · Accident · No injuries · Field investigation · Final report · Jan 30, 1983 · N57222 · Substantial damage
  > A gear up, forced landing was made on the east bank of the Kansas river after both engines quit due to fuel exhaustion. The pilot had landed at new orleans for fuel and requested the tanks be topped off. En route to Kansas City,the pilot stopped at Nevada, MO…
- [NTSB NYC83FA054](https://openairdocs.org/ntsb/NYC83FA054.md): Cessna 310R · Atlantic City, NJ · Accident · 4 fatal · Field investigation · Final report · Jan 29, 1983 · N310TA · Destroyed
  > The flt proceeded routinely from chicago to Atlantic City. Communications and procedures all seemed routine and normal and at 1901 local control at Atlantic City informed the pilot that he was one mile out and should be picking up the 'rabbit' momentarily. At…
- [NTSB LAX83LA085](https://openairdocs.org/ntsb/LAX83LA085.md): Cessna 152 · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1983 · N48406 · Destroyed
  > The acft crashed about one mile north of the runway after engine failure during a go-around. The student pilot on a solotraining flight had returned to Tucson international airport and could not land because of cross-winds. He diverted to davis-monthan afb.…
- [NTSB FTW83FA102](https://openairdocs.org/ntsb/FTW83FA102.md): Schweizer SGS 1-26B · Hempstead, TX · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1983 · N2465W · Destroyed
  > The glider was observed to stall/spin during turn from base to final. The plt was endorsed for solo in the heavier blanik L-13 & Schweizer 2-33, but not in the 1-26B. His logbook revealed four instructor entries concerning airspeed control. The acft was being…
- [NTSB MKC83LA058](https://openairdocs.org/ntsb/MKC83LA058.md): Beech D55 · Cape Girardeau, MO · Accident · No injuries · Limited investigation · Final report · Jan 25, 1983 · N7815R · Destroyed
  > The aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…
- [NTSB MIA83FA062](https://openairdocs.org/ntsb/MIA83FA062.md): Beech C45H · Leesburg, FL · Accident · Serious injuries · Field investigation · Final report · Jan 21, 1983 · N69K · Substantial damage
  > The acft crashed into a lake during a forced landing after the engines quit. The PIC had gone for a local flt with a plt/passenger. After a few minutes of flt he announced that they did not have any fuel. The acft was on an approach to return when both…
- [NTSB ANC83FAG03](https://openairdocs.org/ntsb/ANC83FAG03.md): Cessna A185F · Nyac, AK · Accident · 3 fatal · Final report · Jan 21, 1983 · N61764 · Destroyed
  > The aircraft crashed after colliding with a tree near the destination airport at Nyac, AK. The pilot had tried this flight from aniak to Nyac the day before and had returned to aniak because of weather. The weather at the time of the accident was snowing and…
- [NTSB DEN83LA051](https://openairdocs.org/ntsb/DEN83LA051.md): Cessna 172XP · Harmony, WY · Accident · No injuries · Limited investigation · Final report · Jan 19, 1983 · N736YA · Substantial damage
  > The acft collided with a fence at the departure end of a pasture field during a go-around. The pilot had decided to land in an easterly direction to avoid powerlines and did not consider direction of the wind. Full flaps did not slow the acft effectively…
- [NTSB ATL83LA089](https://openairdocs.org/ntsb/ATL83LA089.md): Cessna 182M · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Jan 18, 1983 · N70872 · Substantial damage
  > During arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…
- [NTSB SEA83LA043](https://openairdocs.org/ntsb/SEA83LA043.md): Bellanca 17-30A · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Jan 17, 1983 · N28163 · Substantial damage
  > During a missed approach a partial power loss occurred during the transition to climb. The plt executed a course reversal to return visually to the arpt. Shortly thereafter he chose to execute an emergency landing on a frontage road which paralleled rr…
- [NTSB FTW83FA088](https://openairdocs.org/ntsb/FTW83FA088.md): Cessna 172N · Carrollton, TX · Accident · Serious injuries · Field investigation · Final report · Jan 16, 1983 · N737VQ · Substantial damage
  > The plt reported that during arrival, he entered the downwind with no problem; however, when he attempted to turn on a left base, the aileron control locked up. He stated he could turn neither left nor right by using ailerons. Reportedly, the acft would bank…
- [NTSB LAX83LA077](https://openairdocs.org/ntsb/LAX83LA077.md): Cessna R172K · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1983 · N9927V · Substantial damage
  > The acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…
- [NTSB CHI83FA080](https://openairdocs.org/ntsb/CHI83FA080.md): Piper PA-28-140 · Glenview, IL · Accident · No injuries · Field investigation · Final report · Jan 13, 1983 · N6347W · Destroyed
  > During a long final approach to o'hare intl arpt the eng quit at 1,900 ft MSL. The plt was over a residential area but found a short field in which to land. The left main landing gear separated & then the left wing separated. The fuel selector was found…
- [NTSB CHI83LA077](https://openairdocs.org/ntsb/CHI83LA077.md): Rutan Varieze · Youngstown, OH · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 1983 · N441EZ · Destroyed
  > The pilot took off with minimum fuel to practice touch and go landings. After 20 minutes of flight he turned on final approach and advanced the throttle with no power response. Due to low altitude and a wooded area on final he attempted a right turn to land…
- [NTSB ATL83FKJ02](https://openairdocs.org/ntsb/ATL83FKJ02.md): Luscombe 8E · Elba, AL · Accident · Serious injuries · Final report · Jan 8, 1983 · N1860K · Substantial damage
  > The plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…
- [NTSB LAX83LA068](https://openairdocs.org/ntsb/LAX83LA068.md): Piper PA-28-161 · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Jan 7, 1983 · N38916 · Substantial damage
  > The non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended. During arrival at night, he circled twice over the airport and noticed that the runway lights were clear, then entered the pattern…
- [NTSB FTW83LA080](https://openairdocs.org/ntsb/FTW83LA080.md): Beech B35 · Canadian, TX · Accident · No injuries · Limited investigation · Final report · Jan 7, 1983 · N8849A · Substantial damage
  > The acft collided with a tree during rollout after a forced landing following engine power loss on final approach. The pilot said he was one and a half miles out on final at 200 ft AGL when the engine quit. He was operating on the right main fuel tank. He…
- [NTSB DEN83FA044](https://openairdocs.org/ntsb/DEN83FA044.md): Piper Aerostar 602P · Almy, WY · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1983 · N6893L · Destroyed
  > Before departing, the plt obtained a wx briefing & was advised of a SIGMET which forecasted severe turbulence below 18,000 ft, strong up/downdrafts, strong surface winds & wind shear near mountains & in passes. He took off with full fuel tanks & aprx 400 lbs…
- [NTSB CHI83FA075](https://openairdocs.org/ntsb/CHI83FA075.md): Mooney M-20D · Lindenwood, IL · Accident · 3 fatal · Field investigation · Final report · Jan 5, 1983 · N1968Y · Destroyed
  > At 0306 the plt contacted rockford fss requesting local wx. He then requested an ILS apch to rockford & stated he had noapproach plates. After being cleared for an ILS apch to rwy 36, the plt reported he was unable to pick up the ILS & was low on fuel. ARTCC…
- [NTSB LAX83FUA02](https://openairdocs.org/ntsb/LAX83FUA02.md): Piper PA-28-161 · Avalon, CA · Accident · 2 fatal · Final report · Jan 3, 1983 · N2239M · Destroyed
  > The aircraft crashed during an attempted go-around at catalina island. The front seat occupants were fatally injured andthe two rear seat passengers received serious injuries. The pilot had not had the specified three takeoffs and landings within the…
- [NTSB DCA83AA010](https://openairdocs.org/ntsb/DCA83AA010.md): Canadair CL-600-1A11 · Hailey, ID · Accident · 2 fatal · Final report · Jan 3, 1983 · N805C · Destroyed
  > The acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…
- [NTSB SEA83LA036](https://openairdocs.org/ntsb/SEA83LA036.md): Cessna 182P · Newport, OR · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1983 · N1296M · Substantial damage
  > The engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…
- [NTSB LAX83LA063](https://openairdocs.org/ntsb/LAX83LA063.md): Cessna 172RG · Sedona, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 1983 · N5262U · Destroyed
  > While enroute, the plt noticed that he had lost his airspeed indication. Observing the pitot head on the wing with a flashlight, he stated that the flip-up cover was down, covering the ram tube. Unable to maintain proper airspeed, the plt inadvertently…
- [NTSB LAX83FUG11](https://openairdocs.org/ntsb/LAX83FUG11.md): Piper PA-28R-200 · Upland, CA · Accident · Minor injuries · Final report · Jan 1, 1983 · N3084R · Substantial damage
  > The aircraft crashed 150 yards short of the runway during landing. The pilot said the manifold pressure kept falling as he progressed around the field in the traffic pattern. The engine went to idle on the base leg. The pilot had lowered the gear but not the…
- [NTSB MKC83LA048](https://openairdocs.org/ntsb/MKC83LA048.md): Cessna 152 · Olathe, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1982 · N94291 · Substantial damage
  > The aircraft was on downwind when the engine stopped. The aircraft touched down 1000 ft short of the runway. Investigation revealed there was no fuel in the fuel tanks.
- [NTSB MIA83FA055](https://openairdocs.org/ntsb/MIA83FA055.md): Piper PA-28RT-201T · St. Augustine, FL · Accident · Serious injuries · Field investigation · Final report · Dec 31, 1982 · N8412F · Destroyed
  > Approach control advised the flt at the time of the initiation of the approach that weather for the general area was 300 ft overcast, 2 mi in fog. The flt was cleared for the VOR rwy 13 approach. The acft struck trees about 65 ft AGL in an area about 4 mi nw…
- [NTSB LAX83LVG06](https://openairdocs.org/ntsb/LAX83LVG06.md): Beech G35 · Chico, CA · Accident · No injuries · Final report · Dec 29, 1982 · N4428D · Substantial damage
  > The aircraft was on a flight from arcata, CA to sacramento, CA with en route stops at redding, red bluff and Chico. The pilot reported that when he was on final approach to land at Chico, the engine lost power. Subsequently, the aircraft struck elements of…
- [NTSB ATL83IA085](https://openairdocs.org/ntsb/ATL83IA085.md): Boeing 737-222 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Dec 28, 1982 · N752N · No damage
  > The acft was observed by witnesses to descend below its normal descent path and to horizontially stray off course to thepoint that office bldg occupants and persons on the ground were concerned by the appearance and noise of the acft duringa vor/dme approach…

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

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

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