# NTSB investigations: Enroute 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 343 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI85LA127](https://openairdocs.org/ntsb/CHI85LA127.md): Cessna 152 II · Wayne City, IL · Accident · No injuries · Limited investigation · Final report · Mar 1, 1985 · N68183 · Destroyed > While en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was… - [NTSB MIA85LA111](https://openairdocs.org/ntsb/MIA85LA111.md): Piper PA-32R · W. Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1985 · N120DG · Substantial damage > While en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did… - [NTSB MIA85FA106](https://openairdocs.org/ntsb/MIA85FA106.md): Grumman American AA-5 · Horseshoe Beach, FL · Accident · 1 fatal · Field investigation · Final report · Feb 28, 1985 · N9228L · Destroyed > The acft crashed in the gulf of Mexico while the plt was on a night x-country flt. The wx at the destination had been forcast to be IFR. However, in the area of the accident, witnesses stated the wx was good with no fog & it was a dark night. When the acft… - [NTSB DEN85LA093](https://openairdocs.org/ntsb/DEN85LA093.md): Cessna 421C · Butte, MT · Accident · No injuries · Limited investigation · Final report · Feb 28, 1985 · N98487 · Substantial damage > While in level flt the plt noticed a puff of smoke emit from the left engine, followed by the appearance of hydraulic fluid and the illumination of the left and right hydraulic flow lights. The plt lowered the landing gear during the apch, however, the nose… - [NTSB ATL85LA104](https://openairdocs.org/ntsb/ATL85LA104.md): Luscombe 8A · Suches, GA · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1985 · N71877 · Substantial damage > After takeoff in mountainous terrain pilot used shallow climb on course. Pilot stated he failed to climb to a suitable altitude. When first ridge was cleared a downdraft was encountered. Pilot made 180 degree turn but was unable to climb above terrain. - [NTSB DEN85LA086](https://openairdocs.org/ntsb/DEN85LA086.md): Cessna 210 · Fort Bridger, WY · Accident · No injuries · Limited investigation · Final report · Feb 25, 1985 · N9795X · Substantial damage > The acft encountered moderate turbulence and IFR conditions while en route over Fort Bridger, WY. The plt stated he attempted to climb on top but the acft had accumulated ice and the altimeter and VSI indicated a rapid descent. A forced landing was then… - [NTSB SEA85LA066](https://openairdocs.org/ntsb/SEA85LA066.md): Cessna TU206F · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1985 · N1539U · Substantial damage > The acft landed short of rwy 13R at Boeing fld following a loss of pwr due to fuel exhaustion. The acft was topped off for a ttl of 108 gals of fuel before this third leg of a x-country flt. The plt stated that the eng ceased operating en route, however, pwr… - [NTSB FTW85LA125](https://openairdocs.org/ntsb/FTW85LA125.md): Taylorcraft BC12-65 · Boerne, TX · Accident · No injuries · Limited investigation · Final report · Feb 24, 1985 · N47665 · Substantial damage > The plt reported that as he was returning to the arpt from a local flt, he made a descending turn from 2500 ft MSL to lose alt, he applied carb heat before retarding the throttle & cleared the eng after about 180 deg of turn. After about another 180 deg of… - [NTSB MIA85FA101](https://openairdocs.org/ntsb/MIA85FA101.md): Mooney M20D · Punta Gorda, FL · Accident · 3 fatal · Field investigation · Final report · Feb 23, 1985 · N5588Q · Destroyed > Flt departed on runway 9 and a witness reported seeing the aircraft shortly after this with its engine losing power and the pilot attempting to return to the airport, this witness then lost sight of the aircraft. The aircraft crashed one quarter mile from the… - [NTSB FTW85FA123](https://openairdocs.org/ntsb/FTW85FA123.md): Piper PA-601P · Bentonville, AR · Accident · Minor injuries · Field investigation · Final report · Feb 22, 1985 · N60817 · Destroyed > The acft contacted livestock, a fence and the gear collapsed during a forced landing following a loss of pwr on the right eng. The plt reported that after he feathered the right eng prop and lowered the gear he noted the aux hydraulic system pressure gage was… - [NTSB MKC85FA059](https://openairdocs.org/ntsb/MKC85FA059.md): Piper PA-23-250 · Hot Springs, AR · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1985 · N104JK · Destroyed > Pilot had been cleared for an ILS approach to Hot Springs, Arkansas. After he crossed the initial approach fix, he said he was going to climb back above the clouds for just a second. He climbed 500 feet in the next 12 seconds, then started a fast descent. The… - [NTSB LAX85LA147](https://openairdocs.org/ntsb/LAX85LA147.md): Bell 47G-2 · Stockton, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 1985 · N4021A · Substantial damage > The eng experienced a ttl loss of pwr during cruise flt at 300-400 ft AGL. The plt performed an autorotation into a grape vineyard which resulted in substantial damage to the helicopter. Cause of the loss of pwr was not determined. - [NTSB MIA85IA099](https://openairdocs.org/ntsb/MIA85IA099.md): Cessna 402C · W.Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Feb 19, 1985 · N6789X · No damage > While descending for landing passengers noticed pilot had slumped over in his seat and was unconscious. The pilot was revived after approximately two minutes and landed the aircraft without further incident. The pilot submitted himself for medical examination… - [NTSB LAX85LA152](https://openairdocs.org/ntsb/LAX85LA152.md): Cessna 150F · Tranquility, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1985 · N7084F · Substantial damage > According to the student plt's mother, her son took off from their company's privately owned airstrip for the purpose of refueling the company's acft. After flying for about 15 min, the acft exhausted its fuel supply. The plt made a forced landing in an open… - [NTSB FTW85LA121](https://openairdocs.org/ntsb/FTW85LA121.md): Boeing A75N1 · Holmwood, LA · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1985 · N60885 · Substantial damage > The acft was 1 of 2 that were being repositioned form 1 ag strip to another. While en route, the flt encountered dense fog & the lead plt initiated a 180 deg turn. During the turn, the 2nd acft (N60885) was about 100 ft in trail of the 1st acft at aprx 150 ft… - [NTSB FTW85LA120](https://openairdocs.org/ntsb/FTW85LA120.md): Cessna 172P · Comanche, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1985 · N54149 · Destroyed > The non-instrument rated plt flew the acft into rising terrain in a wings level attitude during a period of low ceilingson a dark night. The plt stated he was descending to stay clear of the overcast and never saw the ground. Plt had a total of 80 hrs flt… - [NTSB DCA85AA015](https://openairdocs.org/ntsb/DCA85AA015.md): Boeing 747 SP-09 · San Francisco, CA · Accident · Serious injuries · Final report · Feb 19, 1985 · N4522V · Substantial damage > While abv a cloud layer (top at FL 370) nr the jet stream, autoplt was engaged & was in the performance mngmnt sys (pms)mode. The pms provided pitch guidance to hold FL 410, roll guidance to ailerons & spoilers for roll ctl & autothrottle to maint.85 mach… - [NTSB ATL85FA101](https://openairdocs.org/ntsb/ATL85FA101.md): Cessna 182R · Burkes Garden, VA · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1985 · N2370E · Destroyed > The plt departed manassas without a current wx briefing or filing a flt plan. Plt had also left maps and a list of checkpoints at home. His route of flt was into an area of low ceilings and visibility. The acft crashed into a mountain at the 3850 ft level.… - [NTSB LAX85LA145](https://openairdocs.org/ntsb/LAX85LA145.md): Beech B 90 · Los Alamitos, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1985 · N444SR · Substantial damage > The acft simultaneously lost pwr in both engines after the left fuel pump failed. The fuel system automatically went to x-feed and then the right fuel pump failed. Both engines quit simultaneously after surging. The plt was unable to locatean unlighted rwy… - [NTSB SEA85LA059](https://openairdocs.org/ntsb/SEA85LA059.md): Schweizer SGS-126E · Reno, NV · Accident · No injuries · Limited investigation · Final report · Feb 17, 1985 · N33883 · Destroyed > Student glider pilot was ridge flying in thermals then lift dropped off. The acft turned downwind, away from rising terrain and the plt made an emergency off arpt landing. - [NTSB FTW85LA124](https://openairdocs.org/ntsb/FTW85LA124.md): Cessna T-188C · De Quincy, LA · Accident · No injuries · Limited investigation · Final report · Feb 16, 1985 · N2633J · Destroyed > The acft made an emergency landing in trees following an eng failure at 200 ft AGL. Shortly after departure from an ag strip, the eng oil temp started rising. The plt started a turn to return to the strip. During the turn the eng seized and the plt landed in… - [NTSB ATL85LA099](https://openairdocs.org/ntsb/ATL85LA099.md): Gulfstream AA-5 · Ridgeland, SC · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 1985 · N5823L · Destroyed > Approx 3.75 hours after takeoff the plt contacted savannah approach and requested a straight in approach to land at savannah airport because of low fuel. Moments later the engine lost power and the plt made a forced landing in a field 10 miles NE of savannah… - [NTSB LAX85FJA03](https://openairdocs.org/ntsb/LAX85FJA03.md): Hughes 369D · Hilo, HI · Accident · No injuries · Final report · Feb 15, 1985 · N58395 · Substantial damage > The helicopter tail boom was damaged by the main rotor blades during a forced autorotative landing. The plt reported that shortly after takeoff at an alt of 4500 ft MSL, the eng N2 dropped to 92% and aprx 15 seconds later, the eng flamed out. Investigation… - [NTSB MIA85FA097](https://openairdocs.org/ntsb/MIA85FA097.md): Piper PA-23 · Everglades City, FL · Accident · 3 fatal · Field investigation · Final report · Feb 14, 1985 · N3163P · Destroyed > The acft departed the airport for a short flight to drop off one passenger. Shortly after takeoff witnesses stated that the acft started a shallow turn to the left in a nose high attitude. The acft continued to lose speed and rolled rapidly to the left at… - [NTSB ANC85FA047](https://openairdocs.org/ntsb/ANC85FA047.md): Piper PA-31 · Port Heiden, AK · Accident · 1 fatal · Field investigation · Final report · Feb 14, 1985 · N63719 · Destroyed > This flt originated near becharof lake and was destined for cold bay. Acft crashed into the side of a mountain at the 7500 ft level, 23 miles left of course. Marginal weather conditions existed including a 35 kt right x-wind. Plt had flown the same route… - [NTSB MIA85LA096](https://openairdocs.org/ntsb/MIA85LA096.md): Cessna 150 · Westville, FL · Accident · No injuries · Limited investigation · Final report · Feb 13, 1985 · N2316O · Substantial damage > Shortly after reaching a cruise alt of 2500 ft MSL a total loss of pwr was experienced. Plt stated he was able to momentarily restart the eng 2 or 3 times during the emergency descent but that it would fail. The nose gear collapsed and the acft nosed over… - [NTSB FTW85FA117](https://openairdocs.org/ntsb/FTW85FA117.md): Piper PA-32RT-300 · Healdton, OK · Accident · 3 fatal · Field investigation · Final report · Feb 12, 1985 · N39516 · 2 aircraft · Destroyed > The acft collided at 4,500 ft MSL within aprx 15 degrees of head-on. VMC with 30 mi visibility existed with plt reported winds aloft as being light from the west. En route recorded data indicated that N39516 was on a true course of 180 deg and N1162N was on a… - [NTSB ATL85IA096](https://openairdocs.org/ntsb/ATL85IA096.md): British Aerospace BAE 3101 Jetstream · Macon, GA · Incident · No injuries · Incident investigation · Final report · Feb 12, 1985 · N401MX · No damage > Acft was being slowed to holding speed in icing conditions. Crew heard sound of ice striking left side of fuselage followed by spool down of left engine. Then same occurred on the right side. Dual airstart successful. Crew elected to make precautionary ldg.… - [NTSB ATL85LA093](https://openairdocs.org/ntsb/ATL85LA093.md): Beech A36 · New Albany, MS · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1985 · N6088S · Substantial damage > PIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The… - [NTSB NYC85LA061](https://openairdocs.org/ntsb/NYC85LA061.md): Piper PA-28-200 · Malone, NY · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 1985 · CGDVM · Destroyed > The acft collided with the terrain on the side of a hill after encountering low ceilings and snow. The plt departed massena under a special VFR clearance and after aprx 25 minutes he decided to return to massena because of deterioratingweather. After flying… - [NTSB ATL85LA091](https://openairdocs.org/ntsb/ATL85LA091.md): Beech 58 · Holly Springs, MS · Accident · No injuries · Limited investigation · Final report · Feb 8, 1985 · N112TC · Substantial damage > About 40 to 45 min after takeoff pilot noted electrical load meters at 0. Alternator warning lights were on. Reset was attempted but unsuccessful due to low battery voltage. Plt decided to make a precautionary ldg at Holly Springs, MS,but could not lower the… - [NTSB LAX85FA136](https://openairdocs.org/ntsb/LAX85FA136.md): Hughes 369D · Hilo, HI · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1985 · N369LA · Substantial damage > A search was initiated when the helicopter did not arrive. It was fnd 2 days later where it crashed drg an autorotation in a rain forest. Drg the flare/touchdown, vegetation had caught on a tundra pad on the l skid & the acft rolled over. An exam revealed the… - [NTSB DEN85FA074](https://openairdocs.org/ntsb/DEN85FA074.md): Beech BE-23-24 · Eureka, UT · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1985 · N5781V · Destroyed > On feb 6, 1985,a Beech BE-23-24 musketeer,owned and operated by the plt crashed into the side of a 7000 ft mtn at the 6700 ft level. The ac was demolished and the plt received fatal injuries. The wx conditions were reported as VMC by provo, Utah and by a… - [NTSB SEA85LA054](https://openairdocs.org/ntsb/SEA85LA054.md): Cessna 182-F · Ashland, OR · Accident · 4 fatal · Limited investigation · Final report · Feb 5, 1985 · N3559Y · Destroyed > The plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970… - [NTSB FTW85LA111](https://openairdocs.org/ntsb/FTW85LA111.md): Aerospatiale AS 355F-1 · Sabine Pass, TX · Accident · No injuries · Limited investigation · Final report · Feb 4, 1985 · N5796A · Substantial damage > While en route at an alt of 500 to 700 ft, the #1 eng spooled down. The plt secured the #1 eng & turned back toward the heliport to make a single eng landing. However, he could not maintain level flt & the rotor RPM began dropping. The plt noted that the #2… - [NTSB BFO85LA014](https://openairdocs.org/ntsb/BFO85LA014.md): Piper PA-24-250 · Chantilly, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 1985 · N5682P · Substantial damage > While retracting the landing gear after takeoff, the gear hesitated briefly at about midpoint before retracting fully. Attempts to extend the gear through normal and emergency procedures failed. The acft landed at dulles international airport with the gear in… - [NTSB MIA85FA089](https://openairdocs.org/ntsb/MIA85FA089.md): Piper PA-23-250 · Key Largo, FL · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1985 · N5103Y · Substantial damage > The aircraft crashed into the waters of the atlantic ocean and sank nose first into 15 feet of water. On impact the 25 bales of marijuana located in the cabin of the aircraft shifted forward and pinned the pilot and passenger in the aircraft. No usable fuel… - [NTSB FTW85LA116](https://openairdocs.org/ntsb/FTW85LA116.md): Beech C-35 · Sheffield, TX · Accident · No injuries · Limited investigation · Final report · Feb 3, 1985 · N5821X · Substantial damage > The plt stated the eng failed completely during cruise. The crankshaft was found separated during the eng teardown, with the rod and bearings also separated. Metallurgical testing revealed fractures to be from fatigue. Eng maintenance had been improperly… - [NTSB NYC85FA059](https://openairdocs.org/ntsb/NYC85FA059.md): Beech A100 · Cedarville, NJ · Accident · 2 fatal · Field investigation · Final report · Feb 2, 1985 · N72BS · Destroyed > The two ATP rated plts were en route back to their home base arpt flying on an IFR flt plan in actual instrument wx conditions. Communications with ATC controllers was normal. During a night localizer apch into millville municipal arpt, an ATC specialist… - [NTSB ATL85LA088](https://openairdocs.org/ntsb/ATL85LA088.md): Cessna 150F · Hartford, TN · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 1985 · N8572G · Destroyed > The plt was informed during wx briefing that VFR was not recommended because of low clouds. Plt elected to takeoff and follow I-90, however, wx conditions were poor and plt executed a climb to 10000 ft to clear the cloud layer. While en route the plt tuned to… - [NTSB FTW85LA109](https://openairdocs.org/ntsb/FTW85LA109.md): Rockwell S-2R (Thrush) · Stockdale, TX · Accident · No injuries · Limited investigation · Final report · Feb 1, 1985 · N8418V · Destroyed > During flt, the eng began missing, so the plt applied carb heat, but this did not help. He noted a trace of ice on the upper part of the windshield & decided to land before the eng power deteriorated further. While landing in a pasture, the acft hit soft… - [NTSB DEN85LA073](https://openairdocs.org/ntsb/DEN85LA073.md): Cessna 180A · Sioux, SD · Accident · No injuries · Limited investigation · Final report · Feb 1, 1985 · CFCBT · Substantial damage > Acft departed winnepeg at 1035 and landed at grand forks, ND, at 1150. Departed grand forks, ND, at 1305 and the accident occurred at 1524. 4 miles nw of Sioux falls, SD, the plt reported a rough running engine which subsequently quit. A forced landing was… - [NTSB ATL85LA087](https://openairdocs.org/ntsb/ATL85LA087.md): Beech B-80 · Newbern, NC · Accident · No injuries · Limited investigation · Final report · Feb 1, 1985 · N640K · Substantial damage > Pilot experienced left engine fire at cruise. Emergency procedures completed, extinguishing the fire. Left nacelle sustained substantial damage, preventing determination of fire orgin. - [NTSB ANC85LA187](https://openairdocs.org/ntsb/ANC85LA187.md): Cessna 210 · Sparrevohn, AK · Accident · 1 fatal · Limited investigation · Final report · Feb 1, 1985 · N6554X · Substantial damage > The primary cause of this accident was the pilot's inability to see and avoid obstructing terrain. Since the accident occurred in February, the mountains were covered with snow and on an overcast day and with the reported fog, the pilot in command either flew… - [NTSB LAX85FA130](https://openairdocs.org/ntsb/LAX85FA130.md): Piper PA-32RT-300T · Bishop, CA · Accident · No injuries · Field investigation · Final report · Jan 31, 1985 · N2129G · Substantial damage > The plt rptd that shortly after leveling off at 11500 ft MSL, the engine exploded causing both windscreens to be covered with oil and fire. The fire stopped during the emergency descent. The acft landed on ry 30 at Bishop arpt, Bishop, CA without further… - [NTSB ATL85FA085](https://openairdocs.org/ntsb/ATL85FA085.md): Beech B-50 · Edgewood, KY · Accident · 3 fatal · Field investigation · Final report · Jan 31, 1985 · N3669B · Destroyed > During a VFR flt from london, KY, to detroit, MI, the acft crashed into a single family home while attempting a landing at cvg arpt. The plt reported a right eng pwr loss, from suspected impact ice. The alternate air source did not change the acft… - [NTSB LAX85FA126](https://openairdocs.org/ntsb/LAX85FA126.md): Aerospatiale SA316B · Galt, CA · Accident · Serious injuries · Field investigation · Final report · Jan 30, 1985 · N67081 · Substantial damage > While in cruise the plt lost tail rotor control and elected to execute an emergency landing in an open field. The tail rotor gearbox was found 45 ft from the main wreckage. The tail rotor guard was found 60 ft from the main wreckage. It did not exhibit any… - [NTSB MIA85FA088](https://openairdocs.org/ntsb/MIA85FA088.md): Piper PA-23-250 · St. Croix · Accident · No injuries · Field investigation · Final report · Jan 28, 1985 · N555MF · Substantial damage > When starting descent the pilot stated the right eng failed & the propeller feathered by itself. The pilot then switchedthe left fuel tank selector to the left aux tank. Shortly thereafter, the left engine failed. The pilot declared a mayday to St. Croix twr… - [NTSB SEA85FA049](https://openairdocs.org/ntsb/SEA85FA049.md): Cessna 170A · Lopez, WA · Accident · 3 fatal · Field investigation · Final report · Jan 27, 1985 · N3845V · Destroyed > Shortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,… - [NTSB SEA85FA048](https://openairdocs.org/ntsb/SEA85FA048.md): Piper PA-28-161 · Bickleton, WA · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1985 · N4369F · Destroyed > The pilot began flight activity at dawn on the day of the accident. Weather briefings indicated marginal conditions for an afternoon flight to another city, which was accomplished without incident. At 2027 hours, without updated weather briefing, the pilot… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=344 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=343 --- 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.