# 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 341 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC85LA107](https://openairdocs.org/ntsb/NYC85LA107.md): Beech D95A · Boston, MA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1985 · N348JL · Substantial damage > According to the plt, the gear warning horn circuit breaker was pulled en route to stop the horn from sounding while the pwr was at a low setting because of turbulence. The circuit breaker was not reset prior to landing. During the apch,the plt lowered the… - [NTSB LAX85LA208](https://openairdocs.org/ntsb/LAX85LA208.md): Huff SA-300 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1985 · N9BH · Destroyed > The acft collided with trees prior to grnd contact after the eng reportedly quit about 20 min after takeoff. The acft reportedly had more than 29 gallons of fuel on board. The acft has 3 fuel tanks. The fuel selector had been changed several times during… - [NTSB LAX85IA206](https://openairdocs.org/ntsb/LAX85IA206.md): Boeing 727-227 · Las Cruces, NM · Incident · No injuries · Incident investigation · Final report · Apr 16, 1985 · N718AA · Minor damage > While cruising at flt level 350 in clear smooth air, a loud noise was heard, accompanied by a severe jolt on the right side of the cabin, as the number 3 end separated from its mounts. Subsequent investigation disclosed that the forward lavatory was leaking… - [NTSB FTW85IA184](https://openairdocs.org/ntsb/FTW85IA184.md): de Havilland DHC-7-103 · College Station, TX · Incident · No injuries · Incident investigation · Final report · Apr 16, 1985 · N210AW · Minor damage > Following a torque drop and RPM fluctuation on the #2 engine the pilots observed flames from the tailpipe. They shut the engine down and extinquished the fire. A precautionary landing was accomplished without incident. A tear down revealed a failed #4 bearing… - [NTSB ATL85FA135](https://openairdocs.org/ntsb/ATL85FA135.md): Bell 206L-1 · Prestonburg, KY · Accident · Serious injuries · Field investigation · Final report · Apr 16, 1985 · N773WW · Substantial damage > The pax deplaned & the plt took off on a short flt to a nearby arpt to refuel. After climbing for about 30 to 40 sec & accelerating to aprx 100 KTS, the plt started to adjust the pwr for lvl flt. At about that time, the eng lost pwr. The plt attempted to… - [NTSB MKC85FA084](https://openairdocs.org/ntsb/MKC85FA084.md): Beech A-36 · Gray Summit, MO · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1985 · N7244S · Destroyed > After departing the st. clair airport establishing a normal climb to the destination airport 24 miles to the northeast, the acft was tracked by radar for a four minute period. The short period of coverage showed a normal climb tolevel flight. The radar image… - [NTSB LAX85LA203](https://openairdocs.org/ntsb/LAX85LA203.md): Piper PA-28-140B · Moorpark, CA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1985 · N8188N · Substantial damage > The student plt became disoriented while on a solo x-country flt during wich he was on top of an overcast. Fuel exhaustion occurred while he was being radar vectored to an arpt. A forced landing was attempted on a freeway offramp and the acft's wing struck a… - [NTSB CHI85FA165](https://openairdocs.org/ntsb/CHI85FA165.md): Piper PA-30 · Worthington, IN · Accident · 3 fatal · Field investigation · Final report · Apr 15, 1985 · N8007Y · Destroyed > The acft stalled and crashed in a fld after the plt declared an emergency stating he was losing pwr on the right eng and he could not maintain alt. At 1405 EST, the acft was told to contact hulman apch with instructions to descend to 3000 ft MSL. The mode c… - [NTSB ATL85LA134](https://openairdocs.org/ntsb/ATL85LA134.md): Champion 7GCAA · Casville Juct, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1985 · N2580F · Substantial damage > While on a personal x-country flt, the acft lost power & the plt attempted a landing on a road. During the attempted landing, the acft struck a guy wire & crashed inverted on the road. A post crash exam revealed that aprx 1.5 pints of fuel was in the acft… - [NTSB MIA85LKG01](https://openairdocs.org/ntsb/MIA85LKG01.md): Cessna 150G · Daytona Beach, FL · Accident · Minor injuries · Final report · Apr 14, 1985 · N3338J · Destroyed > The acft was ditched as a result of a loss of power. The plt stated that while banner towing 200 yds offshore at 3000 ft AGL, the acft eng skipped. The plt applied carb heat and checked the fuel controls. Then the eng quit completely. Since the Beach was… - [NTSB FTW85FA181](https://openairdocs.org/ntsb/FTW85FA181.md): Cessna 320B · Athens, LA · Accident · 4 fatal · Field investigation · Final report · Apr 14, 1985 · N3RU · Destroyed > The acft was on an instrument flt plan. The plt had received a pre takeoff weather briefing. He was briefed on the area of weather that was at the acft's twelve o'clock position four miles in front. The area was thirty miles southwest and twenty miles wide.… - [NTSB FTW85FA180](https://openairdocs.org/ntsb/FTW85FA180.md): Cessna 152 · Franklin, LA · Accident · 1 fatal · Field investigation · Final report · Apr 13, 1985 · N68303 · Destroyed > Acft crashed into a crawfish pond during a forced landing at night following a power loss as a result of fuel exhaustion. After departure, the plt contacted ARTCC and stated that his alternator was out. With center help, alternator was restored and plt cont'd… - [NTSB DEN85FTE01](https://openairdocs.org/ntsb/DEN85FTE01.md): Ultralight Flight Phantom II · Erie, CO · Accident · 2 fatal · Final report · Apr 13, 1985 · UNREG · Destroyed > The Ultralight descended uncontrolled to ground impact following a failure of the outboard forward wing support cable/swage. Witnesses reported the Ultralight turned from north to south and upon leveling out, the left wing snapped upward, the right wing… - [NTSB CHI85LA163](https://openairdocs.org/ntsb/CHI85LA163.md): Cessna 150L · East Liverpool, OH · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N15JT · Substantial damage > While on a night/solo x-country flt, the eng had a partial loss of power. The student attempted to make an emergency landing at a nearby arpt, but the rwy lights were not illuminated. At first, the student did not remember that the lights could be controlled… - [NTSB SEA85LA090](https://openairdocs.org/ntsb/SEA85LA090.md): Hiller UH-12E · Okanogan, WA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1985 · N9QA · Destroyed > During an aerial application flt, the acft collided with a power line at about 30 ft AGL. The acft then rolled to the right & struck the ground. The accident occurred about 5 min after the acft had departed the spray area. - [NTSB LAX85LA200](https://openairdocs.org/ntsb/LAX85LA200.md): Bell 206B · Lake Berryessa, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1985 · N2925W · Substantial damage > The acft was on a low level, eagle survey mission. While cruising between 20 & 30 mph, the plt flew up a canyon & was crossing a ridge at about 150 ft AGL when he saw wires ahead. He took evasive action, but the helicopter struck the wires. The tail rotor &… - [NTSB BFO85LA038](https://openairdocs.org/ntsb/BFO85LA038.md): Piper PA 22-150 · New London, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1985 · N5738D · Destroyed > While exiting the traffic pattern after tkof the plt smelled smoke and observed flames near the left rudder pedal. After failing to put the fire out with his shoes the plt returned to the arpt and subsequently lndd using side window to look out of due to… - [NTSB ATL85IA132](https://openairdocs.org/ntsb/ATL85IA132.md): Piper PA-32R-300 · Marion, AL · Incident · No injuries · Incident investigation · Final report · Apr 12, 1985 · N46PC · Minor damage > Cruising at 4000 ft MSL when engine vibration occurred and became severe. Reduced throtte but roughness persisted. Unable to mntn altitude with 2000 RPM and 25 inches map. Made forced ldg in corn field. Nose ldg gr collapsed. Engine checked out okay. One… - [NTSB LAX85FA198](https://openairdocs.org/ntsb/LAX85FA198.md): Cessna 140 · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Apr 11, 1985 · N140MC · Destroyed > The ATP plt initiated a short x-country flt at night in an acft with no attitude gyro instruments. Just before the acft crashed, witnesses heard the acft. They reported that the eng sounded like the plt was doing stunts or sharp turns. They said they could… - [NTSB FTW85LA178](https://openairdocs.org/ntsb/FTW85LA178.md): Beech C23 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Apr 10, 1985 · N9243S · Substantial damage > The acft departed stutgart, AR, with full fuel tanks at 1250 CST. Five hours and eight minutes later, the plt made an emergency landing following fuel exhaustion near his intended destination, San Antonio, TX. In an interview with FAA investigators the plt… - [NTSB ATL85LKG04](https://openairdocs.org/ntsb/ATL85LKG04.md): Aero Commander S2R · Leslie, GA · Accident · No injuries · Final report · Apr 10, 1985 · N8834Q · Destroyed > The acft lost power en route to spray crops & crash landed in a wooded area. The acft had flown only 2 miles when the power loss occurred. During the post accident investigation an exam of the powerplant & systems revealed that the supercharger had a loose… - [NTSB LAX85LA196](https://openairdocs.org/ntsb/LAX85LA196.md): Cessna P210N · Santa Barbara, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 8, 1985 · N6099P · Destroyed > After receiving a special VFR clearance to depart the control zone to the northeast the non-instrument rated plt took off on a southeasterly heading over the water under low ceilings and in low visibility. A controller observed the acft start a right turn… - [NTSB NYC85FA103](https://openairdocs.org/ntsb/NYC85FA103.md): Mooney MO-20J · Lock Haven, PA · Accident · 5 fatal · Field investigation · Final report · Apr 7, 1985 · N5764D · Destroyed > Preflt wx briefings were issued to the plt that forecasted moderate icing & turbulence from 3000 to 14000 ft across the planned route. An IFR flt plan was filed and during the flt the plt reported engine problems at 1100 ft MSL. During vectors to closest arpt… - [NTSB NYC85FA100](https://openairdocs.org/ntsb/NYC85FA100.md): Cessna 150G · Acme, PA · Accident · 2 fatal · Field investigation · Final report · Apr 7, 1985 · N8367J · Destroyed > At 1221 EST, the plt was advised by a fss that VFR flt was not recommended due to widespread IFR conditions along the route of flt & at the destination. The plt departed at aprx 1430 hrs. At 1700 hrs, witnesses saw the acft flying westbound at low altitude in… - [NTSB LAX85FVG02](https://openairdocs.org/ntsb/LAX85FVG02.md): Cessna 172 · Auburn, CA · Accident · Serious injuries · Final report · Apr 7, 1985 · N6167E · Destroyed > The acft crashed into trees during an approach to land after sunset. The plt stated that he was descending from 10,500 ft thru 5000 ft with the arpt in sight as well as the lights of sacramento, CA. He does not remember the accident but remembers his wife was… - [NTSB CHI85FA157](https://openairdocs.org/ntsb/CHI85FA157.md): Cessna 210L · Muncie, IN · Accident · 4 fatal · Field investigation · Final report · Apr 7, 1985 · N35592 · Destroyed > The plt took off at 1125 EST after receiving a wx briefing. While en route, the forecast wx for the destn bcm worse & a SIGMET (1E) was issued. At 1444, the plt contacted ft wayne fss & had his VFR flt plan extndd 1 hr. He neither requestednor received… - [NTSB SEA85LA085](https://openairdocs.org/ntsb/SEA85LA085.md): Beech BE-23 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Apr 6, 1985 · N6125N · Substantial damage > A forced landing was made due to fuel exhaustion. A landing was made short of the runway onto rough terrain during which time the gear collapsed. The plt's route of flight wasvery close to airport's having fuel available, but the plt elected to continue to… - [NTSB DEN85LA112](https://openairdocs.org/ntsb/DEN85LA112.md): Piper PA-32RT-300T · Garneill, MT · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 1985 · N21092 · Destroyed > The plt reported that during a night x-country flt, he encountered marginal (obscured) wx & reversed course to return to the departure point. He stated that while he was returning, he 'dozed off a little bit' & when he awoke, he saw a mountain directly ahead.… - [NTSB MIA85LA142](https://openairdocs.org/ntsb/MIA85LA142.md): Canard Long EZ · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N280EZ · Substantial damage > The plt stated that while flying at low level he collided with some power lines, severing his main landing gear & one half of his left winglet. He then continued about 4 miles further landing in a clear area on the Crystal River power plant property & slid… - [NTSB MIA85LA141](https://openairdocs.org/ntsb/MIA85LA141.md): Piper PA-28-140 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N8705N · Substantial damage > The plt stated that while on a local sightseeing flt, the eng quit completely & opon touchdown in the water the acft flipped over & came to rest inverted. Investigation revealed that the plt departed summerland key with an insufficient amount of fuel for his… - [NTSB LAX85FXQ01](https://openairdocs.org/ntsb/LAX85FXQ01.md): Piper PA-28-161 · Tahoe Paradise, CA · Accident · Serious injuries · Final report · Apr 5, 1985 · N80530 · Substantial damage > The acft contacted trees and the terrain during an attempted climb in a narrow canyon. The plt stated he was attempting to climb in order to clear rising terrain in the canyon when a downdraft was encountered. He stated, he cleared the top of the ridge at… - [NTSB CHI85FA153](https://openairdocs.org/ntsb/CHI85FA153.md): Beech N35 · La Porte, IN · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1985 · N9429Y · Destroyed > The thousand hour plus instrument rated plt filed IFR into a known area of three and four level thunderstorms. While being drct by ATC it was noted that headings flown were very erratic. When questioned by ATC the pilot replied 'stand by'. Shortly afterward… - [NTSB DEN85LA106](https://openairdocs.org/ntsb/DEN85LA106.md): Cessna 210 · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1985 · XBCKE · Substantial damage > On April 1, 1985, a Cessna 210 with mexican registry, xbcke,piloted by a mexican national, lost engine power and landed short of the runway at Salt Lake City international airport the flight had depated the grand canyon AZ airport. Post accident examination… - [NTSB NYC85LA096](https://openairdocs.org/ntsb/NYC85LA096.md): Maule M-5-235C · Pittsfield, MA · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N386X · Substantial damage > During a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered… - [NTSB NYC85LA094](https://openairdocs.org/ntsb/NYC85LA094.md): Piper PA-28R-201 · Red Hook, NY · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N2263Q · 2 aircraft · Substantial damage > During flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.… - [NTSB LAX85LA194](https://openairdocs.org/ntsb/LAX85LA194.md): Bell 206A · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1985 · N1434W · Substantial damage > During flt, the eng lost power & the plt began an autorotative landing in a parking lot. During the apch, he maneuvered to avoid a 100 ft crane. As the helicopter was approaching the intended touchdown point, a vehicle was driven into the flt path of the… - [NTSB LAX85FUQ02](https://openairdocs.org/ntsb/LAX85FUQ02.md): Cessna 150H · Sylmar, CA · Accident · No injuries · Final report · Mar 31, 1985 · N23045 · Substantial damage > The acft eng quit during a return from a x-country flt. The plt stated that nearing the end of his flt the acft encountered turbulence over the mts and he climbed to 7500 ft in search of smoother air. Shortly afterwards he started a slow descent from 7500 ft… - [NTSB BFO85FA032](https://openairdocs.org/ntsb/BFO85FA032.md): Bellanca 17-30A · Roanoke, VA · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1985 · N8233R · Substantial damage > The plt reported he ran a fuel tank dry during flt at 6000 ft. he switched fuel tanks, turned on the boost pump & manip-ulated the eng controls, but was unable to restart the eng. During a forced landing on I-581, the acft struck a pickup truck (traveling in… - [NTSB SEA85LA081](https://openairdocs.org/ntsb/SEA85LA081.md): Piper PA-28-180 · Trinidad, WA · Accident · 1 fatal · Limited investigation · Final report · Mar 30, 1985 · N772GW · Substantial damage > The pilot was operating the aircraft by flying at low altitude down the columbia river so as to avoid turbulence. During the flight a downdraft was encountered in which insufficient altitude was available to prevent the water and an unintentional ditching… - [NTSB MIA85LA138](https://openairdocs.org/ntsb/MIA85LA138.md): Aeronca 7AC · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N84303 · Substantial damage > The acft departed tavernaro arpt with an estimated 3 to 4 gallons of fuel on board & proceeded northeast to port Largo arpt, executed two touch & go landings, departed the pattern & approximately 6 miles northeast of port Largo arpt the eng started to run… - [NTSB DEN85FA103](https://openairdocs.org/ntsb/DEN85FA103.md): Gulfstream 681 · Calhan, CO · Accident · 1 fatal · Field investigation · Final report · Mar 29, 1985 · N772CB · Destroyed > During a xcountry flt from WI to CA and return, the noninst, low experienced pvt plt, flew into IMC conditions. The acft impacted flat snow-covered grd, destroying the acft and fatally injuring his pax. Exam of wreckage revealed no evidence of pre-acc… - [NTSB SEA85IA080](https://openairdocs.org/ntsb/SEA85IA080.md): Mcdonnell Douglas DC-9-14 · Reno, NV · Incident · No injuries · Incident investigation · Final report · Mar 27, 1985 · N85AS · No damage > After a ground time of 36 minutes during rain/wet snow the aircraft departed Reno. During the climb in below freezing conditions the crew experienced elevator pitch control difficulties which persisted until the descent into seattle. Examination of the… - [NTSB MKC85FA078](https://openairdocs.org/ntsb/MKC85FA078.md): Cessna 182A · Onxy, AR · Accident · 2 fatal · Field investigation · Final report · Mar 27, 1985 · N6048B · Destroyed > At 1230 CST on 3/27/85, the plt & his wife departed on a x-country flt, but did not arrive at their destination. When family members became concerned, a search was initiated. The wreckage was located on 3/31/85 where the acft collided with trees & crashed on… - [NTSB FTW85LA165](https://openairdocs.org/ntsb/FTW85LA165.md): Cessna 206 · Pharr, TX · Accident · No injuries · Limited investigation · Final report · Mar 26, 1985 · XBANR · Destroyed > The aircraft is mexican registered and was being flown by a mexican national, from mcallen TX. To tuxpan ver. Mexico. Its cargo was television sets. About five minutes after departing mcallen the pilot reported a power loss and that he was returning to the… - [NTSB NYC85FA088](https://openairdocs.org/ntsb/NYC85FA088.md): Lake LA-4-200 · Swanton, VT · Accident · Serious injuries · Field investigation · Final report · Mar 25, 1985 · N6024V · Destroyed > During normal cruise flt the plt became unable to move the elevator control. The flt was continued to the planned destination using elevator trim for pitch control. On final approach to the rwy the acft was caught by a wind gust & pitched nose down. The plt… - [NTSB NYC85LA087](https://openairdocs.org/ntsb/NYC85LA087.md): Piper PA-32R-301 · Zelienople, PA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N8429T · Substantial damage > The acft collided with trees shortly after takeoff. Prior to takeoff the plt was made aware that the lock cylinder for the cabin door was broken. Upon reaching an alt of 1800 ft, the cabin door popped open. The plt attempted to secure the door after… - [NTSB MIA85LA130](https://openairdocs.org/ntsb/MIA85LA130.md): Piper PA-25-235 · Everglades, FL · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N8773L · Destroyed > The acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted… - [NTSB FTW85LA160](https://openairdocs.org/ntsb/FTW85LA160.md): Cessna 195B · Bay City, TX · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N2163C · Substantial damage > Cessna exhaust stack failed at weld. Hot exhaust burned through magnrto p leads and eng failed. During forced landing on a narrow farm road with a quartering tailwind. The acft drifted off the side of the road during the landing roll and nosed over. - [NTSB CHI85IA149](https://openairdocs.org/ntsb/CHI85IA149.md): Boeing 727-100 · Chattan00gr, TN · Incident · Minor injuries · Incident investigation · Final report · Mar 24, 1985 · N285AT · No damage > Approximately 8 hours into his duty day, after flying for approximately 6 hours. The first officer experienced a 20 second episode of simple vaso-vaso syncope (fainting), as diagnosed by the FAA aeromedical standards division manager. This occurred as he was… - [NTSB ATL85LA124](https://openairdocs.org/ntsb/ATL85LA124.md): Kirst Allen J DR-1 · Thomaston, GA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N1387B · Substantial damage > The plt made an emergency ldg in a fld after total loss of power due to fuel exhaustion. The plt was on a flt from lakeland, FL. To griffin, GA. With a planned refueling stop at americus, GA. According to the plt he was unable to land at americus due to… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=342 ## 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=341 --- 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.