# 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 195 of 420 · 20,996 cases

## Cases, newest first

- [NTSB ATL85LA121](https://openairdocs.org/ntsb/ATL85LA121.md): Bell 47G · Erin, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1985 · N73DB · Substantial damage
  > After a power loss at low alt. During approach to touchdown,the pilot bled off rotor RPM attempting to clear power lines across his approach path. This resulted in a lack of rotor energy necessary for an autorotaiton landing. A hard landing resulted.…
- [NTSB ATL85LA119](https://openairdocs.org/ntsb/ATL85LA119.md): Cessna 150G · Tarboro, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 1985 · N2624J · Substantial damage
  > The plt was attempting a simulated emergency landing on an ag airstrip & collided with several unmarked power lines while on final approach. The student plt was not authorized to land at the ag strip according to his flight instructor.
- [NTSB MKC85LA072](https://openairdocs.org/ntsb/MKC85LA072.md): Hughes 369HS · Princeton, MO · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N1040Z · Substantial damage
  > The helicopters tail rotor collided with power lines during an apch to an open field. According to the plt, upon descending onto the fld, the acft began to vibrate severely. Consequently, the plt lost control and the helicopter made two 360 degree revolutions…
- [NTSB DEN85LA094](https://openairdocs.org/ntsb/DEN85LA094.md): Enstrom F-28L · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N51671 · Substantial damage
  > The acft eng lost pwr on final apch at aprx 100 ft AGL. The tail boom was severed during the autorotational landing on soft ground. Post accident exam of the eng revealed that the left magneto point gap was excessively closed. During eng test run, when the…
- [NTSB FTW85IA149](https://openairdocs.org/ntsb/FTW85IA149.md): Beech A36 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Mar 13, 1985 · N2057A · No damage
  > Drg arr, a Beech A36, N2057A, was vectored for an ILS rwy 17L apch while a hvy Boeing 747 was being vectored for an ILS rwy 18R apch. The ATC arrival controller (ctlr) stated he had 'staggered' the A36 bhnd the 747 with at least 3 mi sepn. After the A36 was…
- [NTSB CHI85FA139](https://openairdocs.org/ntsb/CHI85FA139.md): Piper PA-32-260 · Angola, IN · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1985 · N3974W · Destroyed
  > The pilot departed into adverse weather conditions. During flight the acft began to accumulate structural icing. The pilot elected to continue on & eventually decided to land at Angola, IN. During final turn the pilot selected 10 degrees of flaps. The acft…
- [NTSB CHI85FA137](https://openairdocs.org/ntsb/CHI85FA137.md): Piper PA-24 · Toledo, OH · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1985 · N7241P · Destroyed
  > The plt was obsvd taking medication within 2 hrs bfr flt. A witness identified 1 pill as darvocet-n 100, since she took the same medication. When the plt started the eng, it went to a very hi RPM, as if the throttle was too FAR open. While taxiing to takeoff,…
- [NTSB ANC85FA054](https://openairdocs.org/ntsb/ANC85FA054.md): de Havilland DHC-6-300 · Barter Island, AK · Accident · Serious injuries · Field investigation · Final report · Mar 12, 1985 · N540N · Substantial damage
  > Acft crashed during missed apch to temporary winter landing strip. Acft hit in steep nose down attitude. Marginal wx conditions prevailed, with icing reported.
- [NTSB ATL85FA118](https://openairdocs.org/ntsb/ATL85FA118.md): Cessna 177RG · Charleston, WV · Accident · 2 fatal · Field investigation · Final report · Mar 11, 1985 · N1625H · Destroyed
  > The plt filed an IFR flt plan before obtaining the en route wx. He then revised the flt plan by extending the planned flt from Washington, DC, (dulles) to Charleston, WV. The plt did not obtain wx info pertinent to revised flt plan. The plt was unfamiliar…
- [NTSB NYC85LA079](https://openairdocs.org/ntsb/NYC85LA079.md): Cessna 177 · Wheatfield, NY · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 1985 · N30155 · Destroyed
  > The plt reported that during arrival, he made a complete landing check & applied carb heat before reducing power. He stated that when the power was reduced to 1900 to 2000 RPM, the eng suddenly stopped running. He attempted to restart the eng, but was unable.…
- [NTSB FTW85LA143](https://openairdocs.org/ntsb/FTW85LA143.md): Cessna 172-N-II · Markham, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1985 · N52920 · Substantial damage
  > The accident occurred on go-around from an inadvertant down-wind approach to a crop duster strip. The pilot failed to retract the flaps, and the heavily-laden aircraft could not accelerate to climb. The pilot elected to fly under powerlines at the end of the…
- [NTSB CHI85LA135](https://openairdocs.org/ntsb/CHI85LA135.md): Piper PA-28-140B · Barlow, OH · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 1985 · N8778N · Destroyed
  > Acft owner-student plt was flying the acft accompanied by a pvt plt. During a simulated forced landing apch the acft struck static lines on a high tension installation and descended to ground impacted.
- [NTSB CHI85LA132](https://openairdocs.org/ntsb/CHI85LA132.md): Cessna 172 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Mar 8, 1985 · N4332Q · Substantial damage
  > During a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…
- [NTSB LAX85FA169](https://openairdocs.org/ntsb/LAX85FA169.md): Smith, Ted Aerostar 601 · Sepulveda, CA · Accident · 1 fatal · Field investigation · Final report · Mar 7, 1985 · N777PL · Destroyed
  > The acft crashed into a residence 2 miles short of the rwy after loss of pwr on the left eng. This eng was feathered, the gear was extended, but the flaps remained up as the acft continued the lndg approach. Post acc investigation revealed no irregularities…
- [NTSB FTW85FA140](https://openairdocs.org/ntsb/FTW85FA140.md): Piper PA-28-180 · Gilmer, TX · Accident · 1 fatal · Field investigation · Final report · Mar 7, 1985 · N7012W · Destroyed
  > An associate of the plt/owner stated that he had departed at about 2030 CST to get some night practice prior to getting a day VFR restriction removed from his pvt license. Reportedly, the owner/plt & an instructor (CFI) were intending to fly together &…
- [NTSB FTW85LA138](https://openairdocs.org/ntsb/FTW85LA138.md): Cessna 180 · Lockhart, TX · Accident · No injuries · Limited investigation · Final report · Mar 5, 1985 · N4679B · Substantial damage
  > The pilot was practicing short field landings at a private landing strip, got too low on the approach & snagged his horizontal stabilizer on a tree stump about 10 feet above ground level.
- [NTSB CHI85LA128](https://openairdocs.org/ntsb/CHI85LA128.md): Piper PA-32-300 · Lacon, IL · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 1985 · N3012L · Substantial damage
  > While on final apch moderate turbulence was experienced. A 200 to 300 foot verticle loss of alt occurred. The plt added pwr and increased the pitch attitude. Before alt could be regained the acft contacted a utility pole. The apch was being made to rwy 18.…
- [NTSB LAX85LA164](https://openairdocs.org/ntsb/LAX85LA164.md): Piper PA-28-140 · Healdsburg, CA · Accident · No injuries · Limited investigation · Final report · Mar 3, 1985 · N8468R · Substantial damage
  > A pvt plt & an instructor plt (CFI) were on a bfr instructional flt. For the purpose of this flt, the pvt plt was considered to be the PIC. The CFI reported that when the acft was at 3500 ft AGL, he retarded the throttle to simulate an eng failure. The pvt…
- [NTSB FTW85LA133](https://openairdocs.org/ntsb/FTW85LA133.md): Piper PA-28-181 · Bartlesville, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1985 · N7068C · Destroyed
  > After one uneventful full-stop landing the plt re-entered the pattern for a second landing. The plt truned to final at about 500 ft AGL and 65-70 KTS with the rwy lights in sight. Shortly thereafter, according to the plt, the landing light illuminated two…
- [NTSB BFO85LA021](https://openairdocs.org/ntsb/BFO85LA021.md): Cessna 150 · Martinsburg, WV · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1985 · N6562F · Substantial damage
  > The plt took off on rwy 35 & departed the arpt without contacting the tower. Aprx 30 min later, he returned & made svrl missed apchs, still without contacting the tower. Tower psnl tried to communicate with the plt & used light signals while directing other…
- [NTSB NYC85LA032](https://openairdocs.org/ntsb/NYC85LA032.md): Piper PA-28R-200 · Taunton, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1985 · N4416X · Substantial damage
  > While approaching about 6 mi from the arpt, the eng lost power & the acft began descending toward a pond. There was a surge of power, but power was lost again. The plt stated that he brought the nose up above the trees to 'mush' the plane in rather than go…
- [NTSB MKC85LA065](https://openairdocs.org/ntsb/MKC85LA065.md): Beech 35 · Osage Beach, MO · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N541T · Substantial damage
  > Plt stated turbulence was encountered 1/2 mile from the rwy. Near the apch end of the rwy the acft dropped suddenly contacting the terrain short of the threshold. The acft continued onto the rwy where the nose gear and rt main gear collapsed. The acft then…
- [NTSB ANC85LA051](https://openairdocs.org/ntsb/ANC85LA051.md): Piper PA-12 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N7889H · Substantial damage
  > While attempting to land, acft stalled in right downwind turn and contacted the ground. Plt was unaware of the 5 to 7 mph wind.
- [NTSB DEN85LA089](https://openairdocs.org/ntsb/DEN85LA089.md): Beech E33-C · Richfield, UT · Accident · No injuries · Limited investigation · Final report · Mar 1, 1985 · N8112R · Substantial damage
  > The plt stated that he was returning to the arpt and was on the base leg of the traffic pattern when he experienced a partial loss of eng pwr. The plt stated that when he turned on the boost pump, pwr was restored for a short time. He continued to state that…
- [NTSB LAX85FA160](https://openairdocs.org/ntsb/LAX85FA160.md): Beech 76 · Shafter, CA · Accident · 2 fatal · Field investigation · Final report · Feb 28, 1985 · N6705T · Destroyed
  > The accident occurred during a multi-enigne training flight. A witness stated he observed the acft initiated a single engine go around at about 50 feet above ground level and that it yawed to the left as full power was applied to the right engine. He further…
- [NTSB CHI85LA124](https://openairdocs.org/ntsb/CHI85LA124.md): Beech A36 · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · Feb 27, 1985 · N1816M · Substantial damage
  > According to the plt, no icing pireps or sigmets were received during his preflt wx briefing. However, the NWS briefer stated that he told him of one PIREP & one SIGMET concerning icing that affected his proposed route of flt. En route to his destination, the…
- [NTSB MKC85FA062](https://openairdocs.org/ntsb/MKC85FA062.md): Piper PA-31P · Sunset Hills, MO · Accident · 3 fatal · Field investigation · Final report · Feb 26, 1985 · N404RS · Destroyed
  > The acft was on a ngt instructional flt with 2 multi-eng instructor plts at the controls & a rated plt occupying a rear pax seat. The rgt fnt seat occupant was an experienced multi-eng plt with 110 hrs in this make & model; however, his 2NDCLASS med cert was…
- [NTSB FTW85LA126](https://openairdocs.org/ntsb/FTW85LA126.md): Cessna 150J · Broken Bow, OK · Accident · No injuries · Limited investigation · Final report · Feb 25, 1985 · N61243 · Substantial damage
  > The acft nosed over short of the rwy while the plt was making an emergency landing after a reported power loss. During the landing, the acft nosed over & was damaged. No reason for the power loss was found.
- [NTSB NYC85LA072](https://openairdocs.org/ntsb/NYC85LA072.md): Cessna 152 · Hudson, NY · Accident · No injuries · Limited investigation · Final report · Feb 24, 1985 · N757BS · Substantial damage
  > While en route, the plt encountered strong, gusty winds & moderate to severe turbulence. After arriving at the destination arpt, he made 3 approaches to rwy 21. He stated that wind shear caused up & downdrafts & that the acft hit the rwy hard & ballooned.…
- [NTSB NYC85LA070](https://openairdocs.org/ntsb/NYC85LA070.md): Cessna 182 · Medford, NJ · Accident · No injuries · Limited investigation · Final report · Feb 24, 1985 · N1966X · Substantial damage
  > According to a cap plt, who was waiting to takeoff, the plt of N1966X undershot his landing touchdown point to such a degree that N1966X nearly hit an embankment short of the rwy. N1966X touched down at or near the apch end of the rwy. The plt (of N1966X)…
- [NTSB MIA85LA104](https://openairdocs.org/ntsb/MIA85LA104.md): Auton - Dunham Rutan Long EZ · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Feb 23, 1985 · N83CR · Substantial damage
  > The plt stated that the flt was smooth until he crossed over the trees at the end of the rwy & was hit with a gust of wind & hit the ground short of the rwy causing the main & nose landing gear to separate. The plane continued to fly about 75 yards before…
- [NTSB MIA85FA102](https://openairdocs.org/ntsb/MIA85FA102.md): Globe Swift GC-1B · Rockledge, FL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1985 · N1ZF · Substantial damage
  > The acft crashed into a field after experiencing a loss of pwr. Inspection revealed one of the two check valves inside the eng driven fuel pump was unsetted and wedged between the metal pump housing and the pump diaphram actuating plate. With the check valve…
- [NTSB CHI85FA120](https://openairdocs.org/ntsb/CHI85FA120.md): Piper PA-31T · Utica, MI · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1985 · N100RN · Destroyed
  > The pilot attempted a VOR approach and missed. He advised ATC he was going to attempt the NDB & if he could not see the rwy he would go to metro at detroit or pontiac. On the NDB approach the aircraft struck trees 960 ft below the moa. The aircraft flipped…
- [NTSB ATL85FMG01](https://openairdocs.org/ntsb/ATL85FMG01.md): Mcclellan J. Grote Dragonfly · Morrisville, NC · Accident · 1 fatal · Final report · Feb 22, 1985 · N5275U · Destroyed
  > The owner/builder had prepared the acft for its 1st flt. This preparation included high speed taxi tests, a brake line repair & eng adjustments. Two 17.6 lb barbell weights were tied to the wing lift bulkhead with 5/16 inch hemp rope for purposes of weight &…
- [NTSB MKC85FCQ01](https://openairdocs.org/ntsb/MKC85FCQ01.md): Beech 95-B55 · Hutchinson, KS · Accident · Serious injuries · Final report · Feb 21, 1985 · N617CA · Substantial damage
  > During arrival, the plt began an ILS apch to rwy 13 at the Hutchinson muni arpt. He reported that he had turned off the 16 mi arc, had intercepted the localizer & had begun his descent to the min published alt to cross over the outermarker (final apch fix).…
- [NTSB ATL85LA102](https://openairdocs.org/ntsb/ATL85LA102.md): Piper PA-22-150 · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1985 · N1613P · Substantial damage
  > Student pilot bought acft previous day, asked instructor to fly acft with him to home airport. CFI delayed en route to practice touch and go. On go around engine would not produce full power and acft would not climb. During subsequent interview pic/cfi told…
- [NTSB MKC85FA060](https://openairdocs.org/ntsb/MKC85FA060.md): Piper PA-34-200T · Mena, AR · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1985 · N8658E · Destroyed
  > The pilot had been cleared for an instrument approach to themena, Arkansas intermountain regional airport. The airplane impacted a mountain side 8 1/2 miles off course.
- [NTSB FTW85LA119](https://openairdocs.org/ntsb/FTW85LA119.md): Sikorsky S-76A · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1985 · N31223 · Destroyed
  > The aircrew had just completed a medivac flt & were repositioning the helicopter to the home base. While they were en route, the company dispatcher informed the crew that fog was moving into the area & that they had better hurry. During the night apch, the…
- [NTSB SEA85LA062](https://openairdocs.org/ntsb/SEA85LA062.md): Beech BE-77 · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1985 · N1806C · Substantial damage
  > Plt made full flap apch at idle pwr while practicing a short field landing. Plt stated apch originally was high and later became low. Plt delayed adding pwr and acft touched down 130 ft short of the rwy. Acft bounced and contacted the ground again nose wheel…
- [NTSB SEA85LA061](https://openairdocs.org/ntsb/SEA85LA061.md): Cessna 172 · Spanaway, WA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1985 · N84578 · Substantial damage
  > The plt was attempting to better align the acft for final apch when a tree was struck with the right wing. The plt stated she was distracted while making preparations to land. The landing was continued without incident.
- [NTSB NYC85LA067](https://openairdocs.org/ntsb/NYC85LA067.md): Beech A23A · Waterville, ME · Accident · No injuries · Limited investigation · Final report · Feb 17, 1985 · N2234L · Substantial damage
  > The owner of the acft was a student plt with only 10.7 hrs total time, of which, 8.1 hrs were dual instruction. He was on a flt with a private plt occupying the right front seat, who reportedly was aboard as a passenger. The owner/student stated that the eng…
- [NTSB MIA85FA098](https://openairdocs.org/ntsb/MIA85FA098.md): Cessna 182A · Williston, FL · Accident · Serious injuries · Field investigation · Final report · Feb 17, 1985 · N3891D · Destroyed
  > The plt took off with the fuel selector on 'both' and at 300 feet AGL switched the fuel selector to 'left'. The selector was still on 'left' when engine lost power at the beginning of the base leg. The plt tried to reach the rwy but collided with edge of…
- [NTSB NYC85FA064](https://openairdocs.org/ntsb/NYC85FA064.md): Beech G90 · St. Mary'S, PA · Accident · 2 fatal · Field investigation · Final report · Feb 14, 1985 · N2019U · Destroyed
  > The acft crashed during a log DME approach. According to ATC the acft crashed after making a procedure turn at the faf. The winds in the area were being called 250 degrees at 10 KTS gusting to 28 knts. A caution on the apch plate has a remark,-'precipitious…
- [NTSB MKC85IA057](https://openairdocs.org/ntsb/MKC85IA057.md): Swearingen SA-226-TC · Berkeley, MO · Incident · No injuries · Incident investigation · Final report · Feb 14, 1985 · N328BA · No damage
  > Crew accomplished descent checklist. Checklist was approved manufacturer's checklist. Descent was made through 2500 footthick clouds with OAT below freezing without auto-ignition switch on auto/continuous position. Both engines quit on final approach.…
- [NTSB CHI85IA118](https://openairdocs.org/ntsb/CHI85IA118.md): Mcdonnell Douglas DC-9 · Champaign, IL · Incident · No injuries · Incident investigation · Final report · Feb 11, 1985 · N978Z · No damage
  > Ozark flt #814 momentarily touched down with the left main landing gear 16 ft off the left side of rwy 31. When 50 ft above minimums during the ILS rwy 31 apch the f/o called rwy in sight. Captain asked for landing lights which the f/o turned on. Captain…
- [NTSB MIA85LA093](https://openairdocs.org/ntsb/MIA85LA093.md): Monerai S-P · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1985 · N5587X · Substantial damage
  > The plt was making an apch to a grass portion of the arpt not usually used for acft. The glider contacted pwr lines during the apch and subsequently collided wtih the terrain. The plt stated he never saw the pwr lines before contacting them.
- [NTSB SEA85FA056](https://openairdocs.org/ntsb/SEA85FA056.md): Gulfstream AC-680F · Central Point, OR · Accident · 4 fatal · Field investigation · Final report · Feb 9, 1985 · N233W · Destroyed
  > The plt reported a loss of power on both engs during descent to land. Aprx 3 mins prior, twr gave plt option of 'straight-in' to rwy 14 or reg pattern to rwy 32. The plt hesitated & said 'just a minute' & twr offered wind info as '210 at 13.' Plt replied,…
- [NTSB ANC85LA045](https://openairdocs.org/ntsb/ANC85LA045.md): Piper PA-11 · Soldotna, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1985 · N4523M · Substantial damage
  > The plt stated a gust of wind forced the left wing up as the acft touched down. Fuul pwr was added to go around. The acft continued to veer to the right until it stalled and impacted the ground in a nose low attitude aprx 100 yards south of the rwy. Winds…
- [NTSB DCA85AA012](https://openairdocs.org/ntsb/DCA85AA012.md): Beech 65-A80 · Soldotna, AK · Accident · 9 fatal · Final report · Feb 4, 1985 · N50NP · Destroyed
  > During arrival, the crew of npa flt 1802 contacted the company wx observer at Soldotna who advised the wx was: wnd calm,ceiling 600 to 800 ft, vis 8 to 10 mi, no precip. They made an NDB apch, but missed the apch & requested another apch. Aprx 1 min later,…
- [NTSB FTW85LA108](https://openairdocs.org/ntsb/FTW85LA108.md): Cessna 182A · Covington, LA · Accident · No injuries · Limited investigation · Final report · Feb 3, 1985 · N2222G · Substantial damage
  > During an apch to land, the eng lost power & the plt made an off arpt landing. While he was landing, the acft collided with a levee & was damaged. Ample fuel was still remaining in the acft & no preimpact failure or malfunction was found that would have…

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.