# 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 325 of 718 · 35,885 cases ## Cases, newest first - [NTSB NYC86LA146](https://openairdocs.org/ntsb/NYC86LA146.md): Cessna 152 · Middletown, CT · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N31SD · Substantial damage > The student pilot was on the third leg of an approved three leg cross country solo flight. He was instructed to refuel at the second stop. However, he made a decision not to refuel since the fuel tanks indicated about 1/2 full. The aircraft ran out of fuel… - [NTSB FTW86MA097](https://openairdocs.org/ntsb/FTW86MA097.md): Mitsubishi MU-2B-35 · Bartlett, TX · Accident · 1 fatal · Major investigation · Final report · Jun 3, 1986 · N8CC · Destroyed > About 6 min after takeoff, at 2138:31 CDT, the plt rprtd level at 9000 ft MSL. At 2140:17, he transmitted that he had trouble & said he could not control or disconnect the autopilot (a/p) which was causing the acft to descend. At 2141:14,he stated he was… - [NTSB FTW86FA098](https://openairdocs.org/ntsb/FTW86FA098.md): Cessna T210N · Sperry, OK · Accident · 3 fatal · Field investigation · Final report · Jun 3, 1986 · N9444Y · Destroyed > The airplane departed jones (riverside) airport and climbed, on course, to its assigned altitude. It was in IMC conditions and a IFR flight plan had been filed. The pilot told ATC (after being asked) that his ride was 'smooth so far'. Shortly thereafter the… - [NTSB FTW86LRG23](https://openairdocs.org/ntsb/FTW86LRG23.md): North American Rockwell S2-R · Mercedes, TX · Accident · No injuries · Final report · Jun 2, 1986 · N34956 · Substantial damage > The acft experienced a complete loss of eng power at an alt of 200 ft AGL shortly after takeoff. The plt was forced to land against the rows in a muddy cotton field. Shortly after touchdown, the acft flipped over. The exact nature of the eng failure was not… - [NTSB FTW86LA099](https://openairdocs.org/ntsb/FTW86LA099.md): Cessna 150K · Eagle Pass, TX · Accident · No injuries · Limited investigation · Final report · Jun 2, 1986 · N6079G · Substantial damage > The pilot failed to take appropriate steps to prevent water from entering the magnetos while washing the aircraft. As a result the water caused the magnetos to cut out and in turn caused the engine failure. - [NTSB DEN86LA148](https://openairdocs.org/ntsb/DEN86LA148.md): Cessna 207 · Frederick, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1986 · N92807 · Substantial damage > According to the plt, he had descended from 8,200 ft AGL to 700 ft AGL in preparation for landing. The plt stated that when he started to add power, he noticed the engine had quit and a forced landing was made. During the investigation, the plt did not… - [NTSB FTW86LA095](https://openairdocs.org/ntsb/FTW86LA095.md): Cessna A185F · Orange Grove, LA · Accident · Minor injuries · Limited investigation · Final report · May 31, 1986 · N96158 · Destroyed > During a part 135 check ride, the check plt had the plt execute a pwr off landing from an alt of 150 ft AGL. The plt reacted to the pwr loss by attempting a left turn to land. The acft then stalled and impacted the ground after the failure maintain airspeed. - [NTSB ATL86LA150](https://openairdocs.org/ntsb/ATL86LA150.md): Cessna 150 · Cumming, GA · Accident · No injuries · Limited investigation · Final report · May 31, 1986 · N1321Q · Substantial damage > During a normal landing, the plt lost directional control of the acft which subsequently collided with a parked C-172. The plt reported that the right tire was inflated during the preflt inspection. Following the accident the tire was found deflated. The plt… - [NTSB CHI86LA147](https://openairdocs.org/ntsb/CHI86LA147.md): Cessna 195 · Port Huron, MI · Accident · No injuries · Limited investigation · Final report · May 30, 1986 · N4745G · Substantial damage > The flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed… - [NTSB BFO86IA031](https://openairdocs.org/ntsb/BFO86IA031.md): Douglas DC-9-31 · Calverton, NY · Incident · No injuries · Incident investigation · Final report · May 30, 1986 · N1310T · 2 aircraft · No damage > N1031T a DC-9-31, was in a descent for landing at jamaica, NY. The captain reported he heard a noise that he thought was a failing cabin door pressure seal and advised the copilot. The copilot indicated he thought the noise was the soundof a jet eng. Between… - [NTSB BFO86FA029](https://openairdocs.org/ntsb/BFO86FA029.md): Cessna 150L · Upper Marlboro, MD · Accident · Minor injuries · Field investigation · Final report · May 30, 1986 · N11463 · Substantial damage > The acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air… - [NTSB ATL86LA141](https://openairdocs.org/ntsb/ATL86LA141.md): Hughes 269A · Daniels, WV · Accident · Serious injuries · Limited investigation · Final report · May 29, 1986 · N8889F · Substantial damage > The plt stated that he noted a 'large vibration' after he had taken off. He suspected a psbl bird strike or bearing failure, & subsequently, the helicopter crashed into trees. According to the plt, the eng did not fail; however, witnesses saw the helicopter… - [NTSB LAX86FA233](https://openairdocs.org/ntsb/LAX86FA233.md): Piper PA 28-236 · Chino, CA · Accident · 4 fatal · Field investigation · Final report · May 27, 1986 · N43504 · Substantial damage > The private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The… - [NTSB MIA86LA167](https://openairdocs.org/ntsb/MIA86LA167.md): Cessna 172 · Windermere, FL · Accident · No injuries · Limited investigation · Final report · May 26, 1986 · N7850X · Substantial damage > After leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.… - [NTSB BFO86FA027](https://openairdocs.org/ntsb/BFO86FA027.md): Bellanca 17-30A · Riverdale, MD · Accident · 3 fatal · Field investigation · Final report · May 26, 1986 · N14781 · Destroyed > Aircraft's engine sputtered and quit while the aircraft was climbing through 400 feet after departure. In an attempt to turn back to the runway the pilot stalled the aircraft and it descended out of control crashing into trees and the ground. Post crash… - [NTSB ATL86LA143](https://openairdocs.org/ntsb/ATL86LA143.md): Aero Commander 100 · Eufaula, AL · Accident · Serious injuries · Limited investigation · Final report · May 26, 1986 · N4003X · Substantial damage > During a descent of 400-500 fpm at 120-125 mph the windshield blew into the aircraft. A portion of the windshield remained attached to the acft, folded up so as to jut above the cabin roof and acted as a spoiler. Level flight could not be maintained due to… - [NTSB SEA86LA133](https://openairdocs.org/ntsb/SEA86LA133.md): Cessna 188B · Nyssa, OR · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N53177 · Destroyed > During aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in… - [NTSB FTW86FA092](https://openairdocs.org/ntsb/FTW86FA092.md): Cessna 210M · Calumet, OK · Accident · 2 fatal · Field investigation · Final report · May 24, 1986 · N750RS · Destroyed > Acft on a night xc flt in marginal VFR to IMC conditions impacted in an 80 deg nose down attitude in a left spiral. Immediately prior to the accident the non-instrument rated pvt plt had indicated that he was IMC and was going to attempt to climb out of it.… - [NTSB SEA86LA129](https://openairdocs.org/ntsb/SEA86LA129.md): Cessna 310 · Skinner Ranch, OR · Accident · No injuries · Limited investigation · Final report · May 23, 1986 · N2634C · Substantial damage > The pilot elected to make a precautionary landing due to a stated electrical problem. The runway was only 30 feet wide and the aircraft struck a dirt mound to the right of the center line. The aircraft's main landing gear then collasped. - [NTSB NYC86FA216](https://openairdocs.org/ntsb/NYC86FA216.md): Bell 206B · Noman'S Land, MA · Accident · 3 fatal · Field investigation · Final report · May 23, 1986 · N2776V · Destroyed > The Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's… - [NTSB CHI86FEM05](https://openairdocs.org/ntsb/CHI86FEM05.md): Eagle DW-1 · Baroda, MI · Accident · No injuries · Final report · May 23, 1986 · N8807Z · Substantial damage > The plt shut down the acft engine after noticing oil on the canopy and a loss of oil pressure. A forced landing was performed in a corn field and the acft nosed over. Post accident inspection disclosed the oil pressure hose had ruptured. - [NTSB ATL86LA140](https://openairdocs.org/ntsb/ATL86LA140.md): Cessna 150E · Gulfshore, AL · Accident · No injuries · Limited investigation · Final report · May 23, 1986 · N6108T · Substantial damage > The pilot related that the aircraft ran out of fuel and he attempted a forced landing in a field 3 miles from his airport of intended landing. The fuel cells were not visually inspected to determine the fuel quantity, however, the pilot stated that the fuel… - [NTSB ATL86IA144](https://openairdocs.org/ntsb/ATL86IA144.md): Boeing 727-295 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · May 23, 1986 · N1644 · No damage > The flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection… - [NTSB FTW86FRG19](https://openairdocs.org/ntsb/FTW86FRG19.md): Soward Rutan Longeze · Georgetown, TX · Accident · 1 fatal · Final report · May 22, 1986 · N196MS · Destroyed > The acft crashed after hitting trees on short final following an inflight fire and an eng failure. The acft was on it's first flt following an eng overhaul and had been airborne about 2 minutes when ground and air observers noticed smoke trailing from the eng… - [NTSB DEN86FA142](https://openairdocs.org/ntsb/DEN86FA142.md): Cessna T210N · Elgin, ND · Accident · 3 fatal · Field investigation · Final report · May 22, 1986 · N5280A · Destroyed > Plt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a… - [NTSB MIA86LA165](https://openairdocs.org/ntsb/MIA86LA165.md): Bell UH-1B · Fellsmere, FL · Accident · Minor injuries · Limited investigation · Final report · May 21, 1986 · N3879G · Destroyed > The plt stated that he had about 350 lbs of fuel onboard when he took off on his 4th night crop dusting mission. He indicated that each mission is 6 to 8 mins in duration and that the average fuel consumption is about 570 lbs per hr. He stated that the 20 min… - [NTSB FTW86LA089](https://openairdocs.org/ntsb/FTW86LA089.md): Piper PA-23-250 · Rio Hondo, TX · Accident · Minor injuries · Limited investigation · Final report · May 21, 1986 · N717WL · Substantial damage > The right eng failed during cruise flt and the plt was unsuccessful in his attempt to restart the eng. The acft was unable to maintain alt and impacted the ground resulting in substantial damage to the acft. Although there was no evidence of any… - [NTSB FTW86FRG20](https://openairdocs.org/ntsb/FTW86FRG20.md): Air Tractor AT301 · Taylor, TX · Accident · No injuries · Final report · May 21, 1986 · N3168H · Substantial damage > Commercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was… - [NTSB CHI86LA144](https://openairdocs.org/ntsb/CHI86LA144.md): Cessna 150 · Columbia City, IN · Accident · No injuries · Limited investigation · Final report · May 21, 1986 · N6612G · Substantial damage > The pilot had become disoriented and was concerned about his low fuel state when he decided to make a precautionary landing. The weather was deteriorating and it was getting dark although the pilot stated he could distinguish the trees from the ground. He… - [NTSB BFO86LA030](https://openairdocs.org/ntsb/BFO86LA030.md): Short Brothers SD3-30 · Hopewell, VA · Accident · Serious injuries · Limited investigation · Final report · May 21, 1986 · N331SB · No damage > The captain reported that moderate to severe turbulence was encountered while passing through some clouds. He called the flight attendant on the intercom and told her to sit down; while she was attempting to answer the intercom, an object from the galley area… - [NTSB DEN86FA141](https://openairdocs.org/ntsb/DEN86FA141.md): Cessna 150-H · Glen Canyon, UT · Accident · Serious injuries · Field investigation · Final report · May 20, 1986 · N22796 · Substantial damage > While in a descent 20 miles before reaching the destination, the acft engine quit due to fuel exhaustion. The plt initiated an emergency forced landing to a dry stream bed in rough desert terrain. After touchdown, the acft impacted an embankment and flipped… - [NTSB CHI86LA143](https://openairdocs.org/ntsb/CHI86LA143.md): Beech BE-F90 · Eaton, IN · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N960V · Substantial damage > The acft had made a stop at muncie to pick up a fourth passenger. After boarding, the passenger closed the cabin door. After departure and climbing thru 6,000 ft the airstair separated from the aircraft and struck the vertical stabilizer. - [NTSB SEA86LA128](https://openairdocs.org/ntsb/SEA86LA128.md): Ayres S-2R · Odessa, WA · Accident · No injuries · Limited investigation · Final report · May 19, 1986 · N4945X · Destroyed > A rough running engine accompanied by smoke rising from the left side of the engine occurred shortly after takeoff. The landing gear then collapsed during the subsequent forced landing and the acft was destroyed by fire. The number one cylinder was found to… - [NTSB CHI86FA141](https://openairdocs.org/ntsb/CHI86FA141.md): Piper PA-34-200 · Angola, IN · Accident · 1 fatal · Field investigation · Final report · May 18, 1986 · N44603 · Destroyed > The pilot diverted into Angola, an airfield he had never landed at before, due to an unidentified electrical problem at night. He was given vectors to the airport and reported the field in sight. He then said he was going to circle to lose altitude prior to… - [NTSB MIA86LA162](https://openairdocs.org/ntsb/MIA86LA162.md): Cessna 182E · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N9218X · Substantial damage > The plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of… - [NTSB LAX86FA223](https://openairdocs.org/ntsb/LAX86FA223.md): General Balloon AX-6 · Temecula, CA · Accident · 2 fatal · Field investigation · Final report · May 17, 1986 · N2490Z · Substantial damage > The balloon was going to participate in a 'hare and hound' event and had departed a festival staging area on a positioning flight. Prior to departing the area the balloon had flown for about 45 minutes. While enroute to the positioning area the balloon had… - [NTSB DEN86LA138](https://openairdocs.org/ntsb/DEN86LA138.md): Cessna 172 · Pierre, SD · Accident · Minor injuries · Limited investigation · Final report · May 17, 1986 · N3559E · Substantial damage > Plt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to… - [NTSB BFO86LA026](https://openairdocs.org/ntsb/BFO86LA026.md): Cessna 150G · Selbyville, DE · Accident · Minor injuries · Limited investigation · Final report · May 17, 1986 · N4004J · Destroyed > The acft impacted trees while attempting to release a banner at the drop zone. The acft was reportedly equipped with separate towing and release mechanisms, so that up to four banners could be towed in succession without the acft having to land. The plt… - [NTSB ATL86FA132](https://openairdocs.org/ntsb/ATL86FA132.md): Cessna 172D · Athens, GA · Accident · 1 fatal · Field investigation · Final report · May 17, 1986 · N2592U · Destroyed > During the return from a local sightseeing flight, the pilot reported over the UNICOM that they were making an emergency approach and were out of fuel. An interview with one of the non-pilot passengers revealed that prior to the flight they discussed… - [NTSB MIA86LA160](https://openairdocs.org/ntsb/MIA86LA160.md): Varga 2150A · Kiln, MS · Accident · Minor injuries · Limited investigation · Final report · May 16, 1986 · N5601G · Substantial damage > The plt stated that while on local flight he ran out of fuel & upon landing in a field, the acft struck a tree, severing the wings. - [NTSB DEN86FA137](https://openairdocs.org/ntsb/DEN86FA137.md): Beech BE-99C · Laramie, WY · Accident · No injuries · Field investigation · Final report · May 16, 1986 · N6728J · Substantial damage > This part 135 IFR flt was inbound for landing at Laramie, Wyoming. During the en route and approach for ldg portions of the flt the acft picked up a moderate to heavy load of ice. During the landing flare the acft stalled, hit the rwy, bounced, veered off the… - [NTSB FTW86LA087](https://openairdocs.org/ntsb/FTW86LA087.md): Boeing PT-13/E-75 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · May 15, 1986 · N10583 · Substantial damage > The plt had just departed the arpt, started to turn crosswind at 500 ft and began climbing, when the eng started sputtering and lost pwr. He did not have enough alt to return to the arpt and had to ditch the acft 200 yds off the north end of the rwy. No… - [NTSB ATL86FA129](https://openairdocs.org/ntsb/ATL86FA129.md): Cessna 182P · Bay Minette, AL · Accident · 1 fatal · Field investigation · Final report · May 15, 1986 · N52911 · Substantial damage > The acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications… - [NTSB NYC86LA128](https://openairdocs.org/ntsb/NYC86LA128.md): Enstrom F-28C · Ephrata, PA · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N100WZ · Substantial damage > The Enstrom F28C was cruising enroute when it experienced a loss of power for reasons unknown. During the landing, in a large open field, the main rotor was damaged and the tail rotor separated from the tail boom. The lone occupant, the pilot, was uninjured… - [NTSB SEA86LA125](https://openairdocs.org/ntsb/SEA86LA125.md): Maule M-6-235 · Fallon, NV · Accident · Serious injuries · Limited investigation · Final report · May 13, 1986 · N5644J · Destroyed > The plt was attempting a precautionary landing on a remote ranch strip after encountering turbulence and high winds enroute. Control was lost on short final when the acft was caught by a gust of wind. The acft contacted the ground on one wingtip and… - [NTSB FTW86FA086](https://openairdocs.org/ntsb/FTW86FA086.md): Cessna 172G · Blackwell, OK · Accident · 1 fatal · Field investigation · Final report · May 13, 1986 · N5878R · 2 aircraft · Destroyed > The pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that… - [NTSB ATL86LA127](https://openairdocs.org/ntsb/ATL86LA127.md): Cessna 152 · Natural Bridge, AL · Accident · No injuries · Limited investigation · Final report · May 13, 1986 · N89339 · Substantial damage > The student plt reported making an error during preflt planning for the solo x-country flt. The student's instructor didnot detect the error. The student plt flew an incorrect hdg, became lost and ran out of fuel. A forced ldg was made in a field. - [NTSB NYC86LA126](https://openairdocs.org/ntsb/NYC86LA126.md): Cessna P206A · Wellsboro, PA · Accident · No injuries · Limited investigation · Final report · May 12, 1986 · N4626F · Substantial damage > The acft was cruising at 5,500 ft when the plt experienced a total loss of power. He tried to make it to the Wellsboro arpt, however, he was unable to and landed the acft in a field. The acft ran through a fence and was substantially damaged. When the engine… - [NTSB MKC86LA107](https://openairdocs.org/ntsb/MKC86LA107.md): Piper PA-22-150 · Ashby, NE · Accident · No injuries · Limited investigation · Final report · May 11, 1986 · N7255D · Substantial damage > The plt stated that he and a passenger were sightseeing when he increased the mixture to full rich, applied carb heat and reduced power for a glide across a valley. When he advanced the throttle to level off the engine did not respond. During the forced… - [NTSB MKC86LA104](https://openairdocs.org/ntsb/MKC86LA104.md): Cessna 175 · Louisburg, KS · Accident · No injuries · Limited investigation · Final report · May 11, 1986 · N7027M · Substantial damage > During a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=326 ## 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=325 --- 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.