# 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 192 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC85LA184](https://openairdocs.org/ntsb/NYC85LA184.md): Piper PA-28-161 · Nantucket, MA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 1985 · N8247A · Destroyed > The acft was observed in a medium left bank turning through a south southwest heading as it appeared from the clouds. The acft continued to descend in that attitude until it collided with the trees about 3.5 miles southeast of the arpt. The plt and passenger… - [NTSB SEA85LA168](https://openairdocs.org/ntsb/SEA85LA168.md): Cessna 172N · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N4931G · Substantial damage > Plt returning from local flight lost visual contact with runway during flare due to sunglare. ATCT had cleared acft to runway and no request for chc initiated by plt, or go around attempted. - [NTSB LAX85LA319](https://openairdocs.org/ntsb/LAX85LA319.md): Cessna 152 · Thermal, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1985 · N6322B · Substantial damage > The acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down. - [NTSB CHI85LA293](https://openairdocs.org/ntsb/CHI85LA293.md): John H. MC Clain, JR. Rand KR2 · Mechanicstown, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1985 · N717J · Substantial damage > The acft landed short of the rwy after a power loss. The plt said he was approaching to ladn at 1800 RPM when he added power to clear some power lines. The eng did not respond and the acft was flown under the wires where it collided with a tree during landing… - [NTSB MKC85LA159](https://openairdocs.org/ntsb/MKC85LA159.md): Piper PA-28 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N5424W · Substantial damage > During a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where… - [NTSB DEN85FA189](https://openairdocs.org/ntsb/DEN85FA189.md): Cessna 320F · Rapid City, SD · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1985 · N90HC · Destroyed > The acft crashed during an attempted VFR go-around. The plt said he didn't recall touching down and he thought he was 'floating.' When the acft began drifting left of rwy centerline, the plt initiated a go-aroung. He said he applied full power and rotated. He… - [NTSB NYC85LA177](https://openairdocs.org/ntsb/NYC85LA177.md): Sikorsky S-76A · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N3124L · Substantial damage > The apch to the pvt helipad was uneventful up to the last 100 ft where the plts noticed a high sink rate. The plt increased collective to correct for the situation. At about 20 ft from touchdown point the plt noticed a decrease in RPM and realized that they… - [NTSB NYC85LA171](https://openairdocs.org/ntsb/NYC85LA171.md): Burkhart Grob G-109B · Pittstown, NJ · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N44GF · Destroyed > The approach to runway 08 was normal, however it was long. Although the approach was not too long to land, the student applied full power and decided to go around. The ins tructor took control of the aircraft after realizing that clearing the trees would be… - [NTSB MKC85LA157](https://openairdocs.org/ntsb/MKC85LA157.md): Boeing A75N1 · Earle, AR · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N1391M · Substantial damage > The plt reports that the propeller ran away when the acft was at 75 ft AGL on final apch for landing at a pvt airstrip. The plt said he was to low to correct the propeller malfunction and was forced to land in a bean field adjacent to the strip. An FAA… - [NTSB CHI85LA289](https://openairdocs.org/ntsb/CHI85LA289.md): Bensen B8M · Hebron, OH · Accident · No injuries · Limited investigation · Final report · Jul 12, 1985 · N9729N · Destroyed > The gyrocopter lost partial pwr while in the traffic pattern and the plt executed an autorotation into a corn field. The throttle cable was found loose after the accident. - [NTSB NYC85LA194](https://openairdocs.org/ntsb/NYC85LA194.md): Maule MX-7-235 · Savoy, MA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N70LB · Substantial damage > The pilot was attempting to land on a dirt runway approximately 800 feet long with a small dirt embankment at the threshold. During the approach, the aircraft landed short and the landing gear collided with the embankment. The aircraft nosed over and came to… - [NTSB MKC85FCQ05](https://openairdocs.org/ntsb/MKC85FCQ05.md): Cessna 150M · Manhattan, KS · Accident · Serious injuries · Final report · Jul 11, 1985 · N3201V · Substantial damage > The acft contacted the terrain aprx 175 yds short of rwy 21 and aprx 50 ft right of the centerline. A witness reported the acft appeared slow on final apch and it was rolling slightly from side to side. The nose of the acft then suddenly dropped and the acft… - [NTSB ATL85LA210](https://openairdocs.org/ntsb/ATL85LA210.md): Cessna 150H · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N22553 · Substantial damage > While on a solo training flight the aircraft lost power while on downwind and the student pilot made an mergency landing on the runway, however, during landing roll the aircraft went off the side of the rwy and nosed over in the soft soil. Post crash… - [NTSB LAX85FA310](https://openairdocs.org/ntsb/LAX85FA310.md): Polliwagen Unknown · Bakersfield, CA · Accident · 2 fatal · Field investigation · Final report · Jul 8, 1985 · N81PW · Destroyed > On July 7, 1985, at 1917 PDT, a Polliwagen, N81PW, collided with the ground during an attempted go around at bakersfieldairpark, Bakersfield, California, while on a personal flight. VMC prevailed at the time; no flight plan was filed. The aircraft was… - [NTSB LAX85LA309](https://openairdocs.org/ntsb/LAX85LA309.md): Hiller UH-12B · Durham, CA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N1048P · Substantial damage > The purpose of the LCL flight was for the CFI to demo the newly acquired helicopter to its owner. The CFI reported that during the flt a 'somewhat common' vibration was detected, & he associated the vibration with the acft's wooden main rotor blades. He… - [NTSB FTW85LA273](https://openairdocs.org/ntsb/FTW85LA273.md): Piper PA-32RT-300T · Brownsville, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1985 · N21698 · Substantial damage > While practicing touch-and-go landings the plt allowed the acft to descend below the proper glide slope while on final apch. The acft impacted a power line aprx 1000 ft short of the rwy and crashed on the side of a drainage ditch levee. The elevation of the… - [NTSB CHI85LA282](https://openairdocs.org/ntsb/CHI85LA282.md): Cessna 172L · Akron, OH · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N7841G · Substantial damage > The acft contacted trees during a forced landing in a cemetery following a loss of pwr while on final apch at Akron fulton arpt. After the accident, 10 gallons of fuel were added to the acft and the eng operated normally when started. An A&P mechanic… - [NTSB SEA85LA157](https://openairdocs.org/ntsb/SEA85LA157.md): Meyers 2000 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N200AW · Substantial damage > A loss of pwr occurred just as the acft was entering the traffic pattern. The acft was landed 650 ft short of the rwy. The reason for the pwr loss could not be determined by an a & p mechanic. The plt did not plan the apch accurately enough to touchdown on… - [NTSB DEN85FA180](https://openairdocs.org/ntsb/DEN85FA180.md): Hughes 369HS · Keystone, SD · Accident · 4 fatal · Field investigation · Final report · Jul 6, 1985 · N5410W · Destroyed > Main rotor hub was overhauled by a repair station that was not authroized by Hughes helicopters for hub overhauls. The main rotor hub and blades separated in-flt 279 hrs after overhaul. The acft crashed in a densily wooded area. Post accident exam of the main… - [NTSB CHI85LA276](https://openairdocs.org/ntsb/CHI85LA276.md): Cessna 210MII · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N29008 · Substantial damage > The acft contacted a tree during a forced landing in a residential area following a loss of pwr. Post accident inspection revealed the right fuel tank contained fuel and the left tank was dry, the left wing fuel vent was installed backwards and the fuel… - [NTSB MKC85LA150](https://openairdocs.org/ntsb/MKC85LA150.md): Cessna 152 · La Porte City, IA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N5116P · Substantial damage > The plt reported that the acft had the proper airspeed when it was on final apch about 1/2 mi from the rwy. However, he reported that it quickly lost 500 ft, landed short of the rwy & was damaged. The acft came to rest in a corn field beside the rwy. - [NTSB MIA85LA206](https://openairdocs.org/ntsb/MIA85LA206.md): Cessna 172P · Daytona Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1985 · N92ER · Substantial damage > The student plt entered the traffic pattern after making a local solo training flt. He stated that during the landing pattern, he reduced the the throttle incrementally & did not use carburetor heat. As the acft was on final apch at about 50 ft AGL, the… - [NTSB LAX85LA303](https://openairdocs.org/ntsb/LAX85LA303.md): Piper PA-24-250 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N7198P · Substantial damage > The pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for… - [NTSB ANC85LA117](https://openairdocs.org/ntsb/ANC85LA117.md): Cessna 207 · Jakolok Bay, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N1686U · Substantial damage > Plt landed short of gravel beach and substantially damaged airplane on large rocks. - [NTSB MKC85LA164](https://openairdocs.org/ntsb/MKC85LA164.md): Brantly Helicopter B-2 · Denison, IA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1985 · N6799D · Substantial damage > Plt reports that the eng idle setting was too low and the eng quit when he reduced power during a practice autorotation. The acft touched down hard and the main rotor contacted tail boom. - [NTSB BFO85LA066](https://openairdocs.org/ntsb/BFO85LA066.md): Cessna 152 · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N757MP · Substantial damage > After not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt… - [NTSB ANC85FA112](https://openairdocs.org/ntsb/ANC85FA112.md): Douglas DC-3 · King Salmon, AK · Accident · No injuries · Field investigation · Final report · Jun 30, 1985 · N168Z · Substantial damage > During an instrument apch, the acft's right eng lost power. The plt moved the right fuel selector to the left main tank & began emergency procedures. Shortly after that, the acft broke out of the overcast & the aircrew saw the arpt. However, the left eng also… - [NTSB ATL85FA197](https://openairdocs.org/ntsb/ATL85FA197.md): Piper PA-42 · Charlotte, NC · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1985 · N542TW · Destroyed > The acft collided with a tree and a pole short of the rwy during a night VFR approach to land. The plt changed from rwy 18 to 36 during the approach. He was seen low & fast on dwnwind which ended in a steep descending turn to ground contact. The twr had… - [NTSB MKC85LA142](https://openairdocs.org/ntsb/MKC85LA142.md): Aero Commander 100-180 · Maryville, MO · Accident · No injuries · Limited investigation · Final report · Jun 27, 1985 · N3621X · Destroyed > The plt slowed the airspeed on final apch & the acft stalled. Subsequently, the acft impacted on the rwy & was damaged beyond economical repair. The plt stated that he did not hear the stall warning sys; however, it operated normally during a post-crash check. - [NTSB FTW85LA267](https://openairdocs.org/ntsb/FTW85LA267.md): Cessna 172E · New Orleans, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1985 · N888W · Substantial damage > The pilot stated the engine quit while he was being vectored for an approach to msy airport, New Orleans. He stated orally that he did not run out of fuel. A successful test run was made with adequate power for flight available. The cause of the engine power… - [NTSB SEA85LA145](https://openairdocs.org/ntsb/SEA85LA145.md): Cessna 310L · Albany, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1985 · N222MR · Substantial damage > The plt was attempting to bracket the low bar on the 2 bar VASI to avoid landing long on the rwy. On final, the acft landing gear struck unmarked powerlines. The acft then struck the ground in a level attitude. A small fire ensued in the left tip tank. The 4… - [NTSB ATL85LA196](https://openairdocs.org/ntsb/ATL85LA196.md): Piper PA-38-112 · Mt. Airy, NC · Accident · No injuries · Limited investigation · Final report · Jun 25, 1985 · N2395G · Substantial damage > While nearing completion of a solo x-country flt, the eng quit. The student plt selected an open area, but overshot the intended touchdown point & the acft crashed in the backyard of a single family dwelling. An investigation failed to disclose any system… - [NTSB SEA85LA144](https://openairdocs.org/ntsb/SEA85LA144.md): Luscombe 8A · Orofino, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1985 · N25231 · Substantial damage > During strong gusting winds the private plt was attempting to give dual instruction. During short final for rwy 27 and the wind from 270 at 8 to 12 knots gusting to 18 knots an approach stall was entered into a about 50 feet AGL. Although an attempted… - [NTSB MKC85FA137](https://openairdocs.org/ntsb/MKC85FA137.md): Cessna 152 · Independence, MO · Accident · Serious injuries · Field investigation · Final report · Jun 23, 1985 · N95496 · Substantial damage > Student pilot and instructor were practicing pre-solo landings. When airplane was 30 feet AGL and on very short final approach, airplane dropped to ground, went through top of two dikes and two ditches, impacted bank of second ditch and flipped forward to… - [NTSB LAX85LA288](https://openairdocs.org/ntsb/LAX85LA288.md): Starduster II · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 1985 · N17RM · Destroyed > The plt crossed the arpt at midfield and made a left turn for a close in downwind. Witnesses estimated that he made a 180 deg descending turn to final. While on final the plt observed another acft which was already on final slightly aheadand slightly below… - [NTSB FTW85FA261](https://openairdocs.org/ntsb/FTW85FA261.md): Cessna 150 · Temple, TX · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1985 · N8496J · 2 aircraft · Substantial damage > A midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by… - [NTSB DEN85FTM03](https://openairdocs.org/ntsb/DEN85FTM03.md): Killian Briegleb BG-12B · Heber City, UT · Accident · 1 fatal · Final report · Jun 23, 1985 · N997 · Destroyed > The acft was a george Killian/briegleb BG-12B, experimental, home built glider. An owner reported that the plt had come from new Mexico to buy the glider. After spending about 3 hrs in familiarization training, the plt went on his 1st flt which was… - [NTSB DEN85FTI04](https://openairdocs.org/ntsb/DEN85FTI04.md): Failing/Rand-Robinson KR-2 · Laurel, MT · Accident · 1 fatal · Final report · Jun 22, 1985 · N8483Y · Destroyed > Drg a test flt, the plt made a fast taxi run, then took off on rwy 21. After takeoff, he made a gradual climb & shallow left turns to a downwind, circled the arpt & reentered a downwind for rwy 21. Witnesses reported that the plt made a power reduction &… - [NTSB NYC85LA153](https://openairdocs.org/ntsb/NYC85LA153.md): Cessna R-182RG · Spring Valley, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1985 · N109MD · Substantial damage > During the final approach to runway 25, the aircraft encountered a downdraft and began to descend, the pilot added power but but unable to recover prior to the aircraft contacting the trees. - [NTSB ANC85LA106](https://openairdocs.org/ntsb/ANC85LA106.md): Piper PA-18 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1985 · N3684Z · Substantial damage > The plt stated that he was making an apch to the arpt when the acft ran out of fuel. Subsequently, the acft crash landed about 1-1/2 mi nw of the arpt. - [NTSB NYC85LA160](https://openairdocs.org/ntsb/NYC85LA160.md): Cessna 182P · Newport, NH · Accident · No injuries · Limited investigation · Final report · Jun 19, 1985 · N9977E · Substantial damage > The acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft… - [NTSB NYC85FA152](https://openairdocs.org/ntsb/NYC85FA152.md): Schempp-Hirth VENTUS-B · Waitsfield, VT · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1985 · N240WT · Destroyed > This glider was involved in a soaring championship course. About 52 minutes after starting the course witnesses observed the aircraft maneuvering for a landing on an open field. While in a steep bank the aircraft stalled and impacted the ground. - [NTSB LAX85LA279](https://openairdocs.org/ntsb/LAX85LA279.md): Piper PA-28-181 · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1985 · N4382N · Substantial damage > Eng failed due to fuel exhaution while the acft was on final apch to rwy 18 at Apple Valley. A forced landing on rough terrain short of the rwy resulted in substantial damage to the acft. - [NTSB CHI85LA235](https://openairdocs.org/ntsb/CHI85LA235.md): Beech V35B · Boscobel, WI · Accident · No injuries · Limited investigation · Final report · Jun 17, 1985 · N18382 · Substantial damage > The engine failed on final approach. The aircraft did not clear a wooded area resulting in an uncontrolled descent. The camshaft had failed at the number 1 journal oil groove. - [NTSB LAX85LA278](https://openairdocs.org/ntsb/LAX85LA278.md): Piper J3C-65 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N30738 · Substantial damage > An eng failue was experienced while on final apch to rwy 16R and the plt elected to make the forced landing on a sod farm near the arpt. He stated he had plenty of alt to reach the selected touchdown point, but he made a slight left turn to avoid large trees.… - [NTSB FTW85LA260](https://openairdocs.org/ntsb/FTW85LA260.md): Piper PA-31-350 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N66887 · Substantial damage > The pilot stated he first saw another aircraft ahead of and below him on final to the runway. He maneuvered to establish interval, then decided to go around. He added fullthrottles but left the flaps and gear down. Unalbe to climb,he decided to land behind… - [NTSB NYC85LA147](https://openairdocs.org/ntsb/NYC85LA147.md): Cessna 210M · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N732VU · Substantial damage > During the preflt inspection, the plt visually checked the fuel tanks and determined them to be full. The flt was made with the fuel selector on the left wing tank. During the apch to Linden arpt, the eng stopped operating. The plt attempted to restart the… - [NTSB LAX85FUG04](https://openairdocs.org/ntsb/LAX85FUG04.md): Briegleb Amature Built BG-12-BD · Hemet, CA · Accident · Serious injuries · Final report · Jun 15, 1985 · N2310B · Destroyed > In was reported that Mr. Campbell departed perris airport, perris, CA at approximately 1215 PDT. It is unknown in what area he was flying. Mr. Campbell was sighted a few minutes prior to attempting to land in a field near 36875 menlo street, Hemet, CA. A… - [NTSB LAX85FA275](https://openairdocs.org/ntsb/LAX85FA275.md): Cessna 31OQ · Chino, CA · Accident · Serious injuries · Field investigation · Final report · Jun 14, 1985 · N7649Q · Substantial damage > The acft collided with the terrain following a total loss of power while circling for landing. The left fuel selector was in the auxiliary tank position and the right fuel selectorwas in the left main tank position. A limited quanity of fuel was drained from… - [NTSB DEN85LA165](https://openairdocs.org/ntsb/DEN85LA165.md): Piper PA-24-250 · Clearfield, UT · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N7259P · Substantial damage > The plt/owner was receiving a cap check ride with an instructor plt & a passenger aboard the acft. The plt reported that during a simulated eng out excercise, the acft got within 200 ft of the ground when the insturctor 'gave me engine power back.' The acft… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=193 ## 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=192 --- 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.