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

## Cases, newest first

- [NTSB BFO86FA006](https://openairdocs.org/ntsb/BFO86FA006.md): Eipper Quicksilver MXL II · Parkton, MD · Accident · 1 fatal · Field investigation · Final report · Nov 17, 1985 · N401WA · Destroyed
  > Witnesses in the area observed the vehicle flying in the local area at other times however this was the first time they had seen two people in it. They also observed the vehicle flying erratically after liftoff and noted that the winds were gusty. Upon…
- [NTSB SEA86LA024](https://openairdocs.org/ntsb/SEA86LA024.md): Cessna 421C · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Nov 16, 1985 · N124RS · Substantial damage
  > During initial apch inflight icing was encountered. The windscreen failed to heat due to an inoperative inverter. A small area on the right bottom portion of the windscreen de-iced due to defrost heat. The plt elected to land using the small clear area of the…
- [NTSB NYC86LA035](https://openairdocs.org/ntsb/NYC86LA035.md): Lake LA4-200 · Millbrook, NY · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1985 · N6195V · Substantial damage
  > During a go-around the aircraft stalled and crashed on the airport.
- [NTSB NYC86FA034](https://openairdocs.org/ntsb/NYC86FA034.md): Piper PA-28-161 · Wellsville, NY · Accident · 3 fatal · Field investigation · Final report · Nov 13, 1985 · N1400H · Destroyed
  > After departure the plt made 3 practice isl apchs at bradford regional arpt located 35 mls away. The acft returned to Wellsville and was cleared for rwy localizer apch. The plt radioed Wellsville UNICOM for advisories and was informed that a fog bank was over…
- [NTSB MKC86FA026](https://openairdocs.org/ntsb/MKC86FA026.md): Cessna P210N · Wichita, KS · Accident · 4 fatal · Field investigation · Final report · Nov 13, 1985 · N3864P · Destroyed
  > The acdt occurred during an IFR, non-precision approach to the uncontrolled jabara airport. When the flt was one mile from the faf, ATC told the flt that in the event of a missedapproach N3864P should enter controlled airspace heading 360 deg. The controller…
- [NTSB FTW86FA024](https://openairdocs.org/ntsb/FTW86FA024.md): Beech S35 · Pampa, TX · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1985 · N6843Q · Destroyed
  > Drg arrival, N6843Q was cleared for an NDB rwy 17 apch. The plt's last radio call was at 1949 CST, when he acknowleged radar svc was terminated & freq chg was approved. When the acft did not arrive, a search was initiated. At 2335, after fog had lifted, the…
- [NTSB CHI86FA026](https://openairdocs.org/ntsb/CHI86FA026.md): Cessna 402C · Detroit, MI · Accident · 1 fatal · Field investigation · Final report · Nov 12, 1985 · N6788Y · Destroyed
  > A 100-FT ceiling with 3000 ft RVR existed at Detroit. The plt attempted an ILS apch with a 200 ft dh when he struck trees one mile from the rwy. He flew the acft to the airfield but crashed near the threshold. The only apch plates found onboard were for…
- [NTSB BFO86FA005](https://openairdocs.org/ntsb/BFO86FA005.md): Piper PA-23-250 · Coatesville, PA · Accident · 2 fatal · Field investigation · Final report · Nov 12, 1985 · N54136 · Destroyed
  > There was no wx rprtg stn at Coatesville, but aprx 25 mi ese at philadelphia, the forecast was for ocnl ceilings of 600'OVERCAST, vis 3 mi with lgt rain showers & fog. There were flt prctns for turbc blo 5000' due to wnd shear, ceilings & vis freq blo 1000' &…
- [NTSB SEA86LA022](https://openairdocs.org/ntsb/SEA86LA022.md): Cessna T210N · Overton, NV · Accident · No injuries · Limited investigation · Final report · Nov 11, 1985 · N1604U · Substantial damage
  > Several diversions had been made due to encountering airframe icing. Once the pilot realized that a low fuel condition existed he asked for vectors to the nearest airport. The pilot had to make a forced landing due to fuel exhaustion 1 mile short of the…
- [NTSB NYC86LA031](https://openairdocs.org/ntsb/NYC86LA031.md): Piper PA-32R-301T · West Chester, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 1985 · N4313T · Substantial damage
  > A practice VOR apch was made to the arpt. Afterwards a landing was attempted on rwy 27. A G0 around was made when the acft was too high on final. A second landing attempt was made. According to the CFI, while on final the student was headed for a touchdown…
- [NTSB CHI86MA025](https://openairdocs.org/ntsb/CHI86MA025.md): Cessna 441 · Derry, PA · Accident · 5 fatal · Major investigation · Final report · Nov 11, 1985 · N59MD · Destroyed
  > Drg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…
- [NTSB DCA86AA004](https://openairdocs.org/ntsb/DCA86AA004.md): Dassault Falcon 50 · Fairview, NJ · Accident · 6 fatal · Final report · Nov 10, 1985 · N784B · 2 aircraft · Destroyed
  > Dassalt falcon 50 (D50), N784B, was on vor/dme-a apch at dusk to circle/lnd at teterboro (teb), as Piper PA-28, N1977H, was transiting arpt traffic area (ata) fm west to east at 1500' in VFR (no flt pln). PA-28 plt was clrd thru ata by teb twr (staying blo…
- [NTSB ATL86LLT02](https://openairdocs.org/ntsb/ATL86LLT02.md): Cessna 152 · Knoxville, TN · Accident · No injuries · Final report · Nov 10, 1985 · N49164 · Substantial damage
  > The plt was on a personal night proficiency flt. He made 2 stop & go landings without incident. On the 3rd landing, the acft touched down about 50 to 60 ft short of the rwy on upsloping terrain & the nose gear collapsed. The plt stated that he was making a…
- [NTSB NYC86LA032](https://openairdocs.org/ntsb/NYC86LA032.md): Cessna 210M · Butler, PA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1985 · N6629B · Substantial damage
  > The plt had flown to new jersey, dropped off a passenger and was returning to Butler, PA, when a pwr loss occurred. The eng failed on base to final to rwy 26 when the position of the mixture was changed to the rich position. The plt stalled the acft into…
- [NTSB MIA86FA027](https://openairdocs.org/ntsb/MIA86FA027.md): Parsons B/P Gyrocopter · Dunnellon, FL · Accident · 2 fatal · Field investigation · Final report · Nov 9, 1985 · N54WP · Destroyed
  > The instructor plt who was not rated in helicopters or gyroplanes and had an expired instructors certificate was imparting instruction to a student plt in a 2 place homebuilt gyrocopter. When on downwind turn to base leg the student tipped the rotor disc…
- [NTSB DEN86FA020](https://openairdocs.org/ntsb/DEN86FA020.md): Piper PA-230-250 · Englewood, CO · Accident · 1 fatal · Field investigation · Final report · Nov 9, 1985 · N1909T · Destroyed
  > The plt had new avionics and autopilot system installed in the acft prior to the accident. Ntap data indicated that the acft did not attain the assigned alt of 8200 ft prior to reaching the outer marker. The acft did not get established on the localizer…
- [NTSB MKC86LA025](https://openairdocs.org/ntsb/MKC86LA025.md): Boeing 727-23 · Bellevue, NE · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N1908 · Substantial damage
  > During a night arrival, a Boeing 727, operating as American flt 334, was vectored for an apch to rwy 32L. While descending thru about 5000 ft MSL, aprx 12 mi south of the arpt, the acft reportedly collided with a flock of snow geese. The ATC controller had…
- [NTSB CHI86LA027](https://openairdocs.org/ntsb/CHI86LA027.md): Cessna 152 · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N24457 · Substantial damage
  > The acft struck wires during the recovery phase of a simulated forced landing apch. The plt continued the flt for aprx 1 hr after the wire strike and landed without incident. Examination of the acft revealed replacement of the right wing was needed.
- [NTSB MIA86LA026](https://openairdocs.org/ntsb/MIA86LA026.md): Cessna 310G · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Nov 7, 1985 · N7962Q · Substantial damage
  > The ac departed on a ferry flight with the landing gear clamped in the down position and leaking fuel system from a previous accident. The flight was uneventful until arrival at the destin ation airport. The left engine failed on the downwind leg of the…
- [NTSB LAX86LA033](https://openairdocs.org/ntsb/LAX86LA033.md): Piper PA-32R-301T · San Diego, CA · Accident · 3 fatal · Limited investigation · Final report · Nov 7, 1985 · N2512Y · Destroyed
  > The flt departed in VFR conditions after a wx briefing which indicated that clear skies and unrestricted visibilty existed and were forecasted at the destination airport. On arrival the plt requested and received clearance for an instrument apch. When the flt…
- [NTSB ATL86LA018](https://openairdocs.org/ntsb/ATL86LA018.md): Cessna 172N · Greer, SC · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N733KU · Substantial damage
  > While on an ILS rwy 03 aprch at Greer, SC, the pilot descended below dh and collided with trees approx 500 ft left of runway centerline. The plt related that he descended below dh because he observed what he thought were the aprch lights.
- [NTSB ATL86LA017](https://openairdocs.org/ntsb/ATL86LA017.md): Cessna 172 M · Moncks Corner, SC · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N73171 · Substantial damage
  > The plt reported that the acft engine experienced a loss of power while being vectored for the initial ILS approach to charleston, SC (chs). Attempts by the plt to regain pwr failed and a forced landing was made in a swampy field a few miles north of chs. The…
- [NTSB FTW86FRG02](https://openairdocs.org/ntsb/FTW86FRG02.md): Beech K35 · Austin, TX · Accident · Serious injuries · Final report · Nov 1, 1985 · N3091C · Substantial damage
  > The acft stalled & crashed during a go-around attempt. The plt/owner was flying the acft from the left seat with the mechainc, who had just completed an annual inspection on the acft, seated in the co-plts seat. The mechanic received serious injuries when the…
- [NTSB FTW86FPA04](https://openairdocs.org/ntsb/FTW86FPA04.md): Piper PA-24-250 · Terrell, TX · Accident · No injuries · Final report · Oct 31, 1985 · N6393P · Substantial damage
  > The acft traveled through a barbed wire fence during a forced landing short of rwy 35 at Terrell arpt. When aprx 1 mile from the arpt, the eng quit. The plt was unable to move the fuel selector, however, by applying a full rich mixture and turning on the…
- [NTSB ATL86FA014](https://openairdocs.org/ntsb/ATL86FA014.md): Piper PA-34-220T · Ocilla, GA · Accident · Serious injuries · Field investigation · Final report · Oct 31, 1985 · N8401E · Destroyed
  > The pilot of the second company aircraft to arrive in the vicinity of the airport held while the first attempted an ndr approach. After the first aircraft made a missed approach the pilot of the second aircraft attempted the approach. The aircraft flew into…
- [NTSB CHI86LA018](https://openairdocs.org/ntsb/CHI86LA018.md): Balloon Works Firefly 7 · Comstock Park, MI · Accident · No injuries · Limited investigation · Final report · Oct 29, 1985 · N4056L · Substantial damage
  > According to the pilot she received wind information from a flight service station, the noaa and ATIS approximately 1.5 hours prior to takeoff. All these sources predicted winds to be less than 7 knots. Winds were 'very light' during Balloon inflation. The…
- [NTSB ATL86LA012](https://openairdocs.org/ntsb/ATL86LA012.md): Cessna 152 · Parkersburg, WV · Accident · No injuries · Limited investigation · Final report · Oct 28, 1985 · N48987 · Substantial damage
  > The acft experienced a total loss of power due to fuel exhaustion while on a baseleg for landing. The pilot elected to land in a corn field approx 1.5 miles short of the runway because he did not think he could make it to the runway. The plt was returning…
- [NTSB NYC86FA023](https://openairdocs.org/ntsb/NYC86FA023.md): Cessna 172N · Rochester, NH · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1985 · N734PX · Destroyed
  > During landing approach to runway 32, the aircraft started to porpoise over the runway. The aircraft continued in this manner until it neared the end of the runway. The aircraft then started a slow climbing right turn just clearing nearby trees. The…
- [NTSB NYC86LA021](https://openairdocs.org/ntsb/NYC86LA021.md): Cessna 150 · Freeport, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 1985 · N60563 · Substantial damage
  > The stu plt departed with 10.5 gals of fuel for a 48 mile x-country flt. While en route the plt became lost. Aprx 10 minutes of fuel remained when the plt spotted a arpt. She attempted to land at the arpt. During the apch to the rwy she made a go around when…
- [NTSB NYC86LA020](https://openairdocs.org/ntsb/NYC86LA020.md): Piper PA-15 · Lee Center, NY · Accident · No injuries · Limited investigation · Final report · Oct 26, 1985 · N4499H · Substantial damage
  > The acft experienced a loss of control during an apch to the plt's pvt airstrip. After a pleasure flt of one-half hour, with no reported problems the acft returned to the arpt. On about a one-half mile final, the acft entered a steep left turn at about a 60…
- [NTSB SEA86MA018](https://openairdocs.org/ntsb/SEA86MA018.md): Gates Learjet 24D · Juneau, AK · Accident · 4 fatal · Major investigation · Final report · Oct 23, 1985 · N456JA · Destroyed
  > Drg arrival to pick up a med-evac patient, the flt was clrd for an LDA-1 rwy 8 apch via the asort transition. Thus, the plt should have contd se on J-541 twd the ssr VORTAC & intercepted the localizer (LOC) at asort; then track inbnd on theloc (062 deg),…
- [NTSB FTW86LA017](https://openairdocs.org/ntsb/FTW86LA017.md): Cessna 310 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1985 · N2952N · Substantial damage
  > The plt experienced fuel exhaustion while on final apch for landing on rwy 35L at Tulsa international arpt, OK. The acft undershot the rwy by 1/2 to 3/4 of a mile where it contacted railroad tracks.
- [NTSB MKC86LA013](https://openairdocs.org/ntsb/MKC86LA013.md): Beech H-18 · Osage Beach, MO · Accident · No injuries · Limited investigation · Final report · Oct 17, 1985 · N936S · Substantial damage
  > On fianl approach to land on rwy 14 at the linn creek/grand glaize airport the plt began to apply prw to the two engines to arrest the descent of the approach. The plt finally had full pwr applied but the acft impacted. The ground short of the rwy. The plt…
- [NTSB MIA86FA012](https://openairdocs.org/ntsb/MIA86FA012.md): Piper PA-23-250 · Pensacola, FL · Accident · 1 fatal · Field investigation · Final report · Oct 16, 1985 · N5815Y · Destroyed
  > After takeoff acft headed to destination arpt located 4 miles south. When aprx two miles out, the plt turned back to the departure arpt. Witnesses reported the acft was in a shallow descent, low and fast when it collided with trees and exploded about 1400 ft…
- [NTSB MKC86LA010](https://openairdocs.org/ntsb/MKC86LA010.md): Piper PA-32-300 · Monticello, IA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1985 · N4KE · Substantial damage
  > The pilot stated that he knew that he would have strong cross-winds for landing but when he was ready to land, he was unable to correct for them. He started a go-around, hit gusty winds that rolled him to the right and when the airplane would'nt climb, they…
- [NTSB LAX86LA015](https://openairdocs.org/ntsb/LAX86LA015.md): Piper PA-28R-201T · Concord, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1985 · N47340 · Substantial damage
  > The plt was landing at night at the conclusion of a cross country flt. On entry to the downwind for fwy 19R, the plt asked that the approach lights be turned up full bright. On short final, the plt said she encounted excessive glare in her contact lenses from…
- [NTSB FTW86LA012](https://openairdocs.org/ntsb/FTW86LA012.md): Piper PA-28-161 · Killeen, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 1985 · N84691 · Substantial damage
  > The pilot stopped enroute to refuel. Fuel service at the airport and already closed for the night so the pilot drained about 10 gallons of fuel into his airplane from a parked Cessna airplane and departed for his destination. However, this amount of fuel was…
- [NTSB LAX86LA013](https://openairdocs.org/ntsb/LAX86LA013.md): Cessna 172M · Vacaville, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1985 · N64142 · Substantial damage
  > The acft collided with the ground during an attempted landing. The plt used full flaps in a x-wind of 16-21 KTS. Two attempts were made to align the acft with the rwy before a pull-up in a 45 degree climb bank to the rt resulted in a stall & crash.
- [NTSB LAX86FA012](https://openairdocs.org/ntsb/LAX86FA012.md): Ken Brock Mfg. KB-2 · Tracy, CA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1985 · N199CR · Destroyed
  > The inexperienced student pilot applied excessive main rotorcontrol inputs while flying on the downwind leg of the traffic pattern. The main rotor blades flexed downward and severed the pushing propeller and empennage. The gyroplane pitched forward and…
- [NTSB LAX86LA011](https://openairdocs.org/ntsb/LAX86LA011.md): Beech B19 · Ruth, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N1983W · Substantial damage
  > The 117 hr pvt plt completed a 50 min flt at dusk & prepared for ldg on rwy 31. The plt had never landed on that rwy before & stated that he was unaware of the remarks contained in the arpt/facility directory indicating that the threshold for rwy 31 had been…
- [NTSB ANC86LA002](https://openairdocs.org/ntsb/ANC86LA002.md): Artic S-1B2 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N53AT · Substantial damage
  > The engine failure was due to a line cap loose in the baffled portion of the tank near the outlet lines. The pilot stated the aircraft engine quit at 1000 feet he then attempted an emergency landing in a school yard.
- [NTSB NYC86LA007](https://openairdocs.org/ntsb/NYC86LA007.md): Ercoupe 415-D · Sterling, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1985 · N3191H · Destroyed
  > The acft contacted trees while making an apch to rwy 34 at Sterling, Massachusetts. The acft crashed about 100 ft short of the rwy. The plt stated that a severe downdraft was encountered and then a rapid rate of descent followed. The left main gear struck…
- [NTSB NYC86LA005](https://openairdocs.org/ntsb/NYC86LA005.md): Beech BE-99 · Albany, NY · Accident · No injuries · Limited investigation · Final report · Oct 11, 1985 · N336PL · Substantial damage
  > A Beech BE-99 N336PL experienced a landing gear collapse while landing on runway 01 at Albany county airport and was substantially damaged. On initial approach to the airport the gear selector was put in the down position, only two green gear lights were…
- [NTSB FTW86LA013](https://openairdocs.org/ntsb/FTW86LA013.md): Piper PA-28 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 11, 1985 · N5341W · Substantial damage
  > The passengers stated that the pilot was unable to obtain higher power settings on a go-around from a low approach to an airport, and elected to land on a rural street. An examination of the engine revealed insect nests in the intake manifold and water in the…
- [NTSB NYC86LA004](https://openairdocs.org/ntsb/NYC86LA004.md): Cessna 140 · Newport, NH · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N77110 · Substantial damage
  > Acft collided with trees while executing a go-around. The acft lost power, the plt lowered the nose in an attempt to restart the eng while turning right in an effort to return to the rwy. The acft stalled and collided with trees.
- [NTSB DEN86LA003](https://openairdocs.org/ntsb/DEN86LA003.md): Grumman AA-5A · Sawyer, ND · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N26207 · Substantial damage
  > The plt allowed the airspeed to decrease to the extent of activating the acft stall warning system on final apch at 100 ft above the ground and 200 ft from the end of the rwy. He corrected the low airspeed condition by lowering the nose, resulting in a high…
- [NTSB ATL86FKG04](https://openairdocs.org/ntsb/ATL86FKG04.md): Mooney M20J · Americus, GA · Accident · Serious injuries · Final report · Oct 6, 1985 · N4287H · Destroyed
  > The acft contacted a tree and came to rest inverted during a forced landing following a loss of pwr. The loss of pwr occurred aprx 5 miles west of the destination arpt. Post accident inspection of the airframe and powerplant failed to disclose any mechanical…
- [NTSB SEA86LA002](https://openairdocs.org/ntsb/SEA86LA002.md): Cessna 150 · Fall City, WA · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1985 · N5584E · Destroyed
  > During an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…
- [NTSB MKC86FA002](https://openairdocs.org/ntsb/MKC86FA002.md): Rockwell 112A · Gravois Mills, MO · Accident · 2 fatal · Field investigation · Final report · Oct 5, 1985 · N1347J · Substantial damage
  > The acft was observed on final with the gear down, flying along a ridge that was beside a lake. Witnesses stated that it was below the elevation of the arpt that was on top of the hill. Two witnesses also stated that the eng was running but not at full pwr.…
- [NTSB BFO86FA002](https://openairdocs.org/ntsb/BFO86FA002.md): Piper PA-32RT-300T · Gaithersburg, MD · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1985 · N2106X · Destroyed
  > The plt was clrd for a VOR rwy 14 apch. On apch, he rprtd at the sleet intxn (a fix on the NDB apch). The acft was then seen flying ovr the arpt on an easterly hdg. UNICOM operator said he then heard the plt call "turning final." However, bfr lndg, the acft…

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

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

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