# 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 322 of 718 · 35,885 cases ## Cases, newest first - [NTSB MIA86LA229](https://openairdocs.org/ntsb/MIA86LA229.md): Boeing 727-224 · Gulf Of Mexico · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 1986 · N32724 · No damage > The commercial air carrier domestic flight was operating in an aera of known thunderstorm activity and encountered a jolt of turbulence. The passenger who was injured disregarded the illuminated seat belt sign and two announcements to remain seated by the… - [NTSB FTW86LA143](https://openairdocs.org/ntsb/FTW86LA143.md): Forney F-1A · Wagoner, OK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1986 · N3026G · Substantial damage > An 80 yr old stu plt with an expired medical certificate was using auto fuel in the acft without an STC. FAA records forthe acft showed a sale was pending for svrl yrs. During flt, the plt decided to make a precautionary landing when the engine began 'running… - [NTSB DEN86FA216](https://openairdocs.org/ntsb/DEN86FA216.md): Piper PA-32-260 · Lander, WY · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1986 · N3621W · Destroyed > The flt departed Lander, Wyoming, arpt in high density altitude conditions and in an over gross weight condition. The acft was observed flying low over rising terrain until it impacted the ground. The acft was destroyed in a post accident fire and two pax was… - [NTSB NYC86LA212](https://openairdocs.org/ntsb/NYC86LA212.md): Cessna 150L · Reamstown, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1986 · N18619 · Destroyed > The plt made a precautionary landing in a corn field following a decrease in engine RPM during cruise flt. Examination of the engine revealed a coating of carbon and lead on the valves of the #2, #3 and #4 cylinders which caused the valves to become stuck in… - [NTSB NYC86FA199](https://openairdocs.org/ntsb/NYC86FA199.md): Rockwell 114 · Bedford, PA · Accident · 4 fatal · Field investigation · Final report · Aug 4, 1986 · N5766N · Destroyed > The acft nearing the close of a x-country flight had requested a decent to start an approach to land at its final destination. ATC had granted the request, but stated to the pilot that he most remain VFR, the pilot acknowledged the clearance. Acft was located… - [NTSB MKC86FA166](https://openairdocs.org/ntsb/MKC86FA166.md): Attebery-Stainbrook Varieze · Osawatomie, KS · Accident · 1 fatal · Field investigation · Final report · Aug 3, 1986 · N6BZ · Destroyed > Witnesses stated that the aircraft appeared to be operating normally and flying at cruise altitude when, suddenly the left (port) wing separated from the fuselage. Sounds of engine power ceased immediately following the in-flight breakup and the aircraft… - [NTSB FTW86FRA11](https://openairdocs.org/ntsb/FTW86FRA11.md): Thorp Aero 211 · Liberty, TX · Accident · Minor injuries · Final report · Aug 3, 1986 · N29754 · Substantial damage > The acft collided with a ditch which sheared the nose gear during a forced landing. The plt said he had only flown about 30 minutes since refueling and suspected a fuel problem. He stated that he had checked for water & contaminents during pre-flt but found… - [NTSB DEN86LA215](https://openairdocs.org/ntsb/DEN86LA215.md): Waco UPF-7 · Laramie, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1986 · N30196 · Destroyed > The plt stated that a flt from California to Laramie was uneventful. The acft was then refueled and he departed to the east. Shortly after takeoff, the engine began to lose power and the cockpit filled with smoke. The plt executed an emergency landing next to… - [NTSB NYC86LA208](https://openairdocs.org/ntsb/NYC86LA208.md): Beech C24R · Hartford, CT · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 1986 · N6637E · No damage > The Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft… - [NTSB NYC86FNC07](https://openairdocs.org/ntsb/NYC86FNC07.md): Cessna 150M · Nashua, NH · Accident · Serious injuries · Final report · Aug 2, 1986 · N66672 · Destroyed > The CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from… - [NTSB MIA86LA224](https://openairdocs.org/ntsb/MIA86LA224.md): Grumman AA-5B · Boynton Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N45529 · Destroyed > The acft was ditched in the atlantic ocean about 4 miles off shore in about 600 ft of water after allegedly sustaining eng failure. The plt stated that the acft was full of fuel prior to departure & that no water or other foreign matter was detected in the… - [NTSB CHI86LA197](https://openairdocs.org/ntsb/CHI86LA197.md): Globe GC-1B · Perrysville, IN · Accident · No injuries · Limited investigation · Final report · Aug 1, 1986 · N80591 · Substantial damage > The acft was substantially damaged during a forced landing in a corn field following a loss of power. Post accident inspection of the acft failed to reveal any fuel in either the fuel tanks or carburetor. - [NTSB CHI86FA193](https://openairdocs.org/ntsb/CHI86FA193.md): Capetown Builders Glasair RG · Fond Du Lac, WI · Accident · No injuries · Field investigation · Final report · Aug 1, 1986 · N137JM · Destroyed > The pilot experienced a complete electrical system failure that was caused by a broken wire at an alternator terminal. Upon extension of the hydraulically operated landing gear a safe gear down indication was not obtained. Activation of the CO2 operated… - [NTSB CHI86FA192](https://openairdocs.org/ntsb/CHI86FA192.md): Cessna 177RG · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Aug 1, 1986 · N52476 · Substantial damage > The IFR flt experienced an engine failure during the landing apch to the destination aprt in Oshkosh, WI, and the plt ditched the acft in lake winnebago. Exam of the acft showed that the eng failed due to fuel exhaustion. The plt reported there were 60… - [NTSB ANC86LA119](https://openairdocs.org/ntsb/ANC86LA119.md): Lake LA-4 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Aug 1, 1986 · N6169V · Substantial damage > During the climbout over the mountain ridge, the aircraft began to lose altitude eventually contacting the edge of the ridge. At the time of the accident strong winds and heavy rain was reported in the area. - [NTSB SEA86LA185](https://openairdocs.org/ntsb/SEA86LA185.md): Varga 2150A · Everett, WA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1986 · N5074V · Substantial damage > The plt reported he made an emergency landing in a wheat field following a loss of power due to fuel exhaustion. The acft struck a ditch and nosed over during the landing roll. The plt stated he sould have refueled at the last stop. - [NTSB FTW86LA141](https://openairdocs.org/ntsb/FTW86LA141.md): Cessna 150H · Bartlesville, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1986 · N50101 · Substantial damage > The plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.… - [NTSB NYC86FGM05](https://openairdocs.org/ntsb/NYC86FGM05.md): Bomberger Vans RV-4 · Friedens, PA · Accident · Serious injuries · Final report · Jul 30, 1986 · N86AB · Destroyed > Due to a low ceiling and poor visibility, the plt decided to make a precautionary landing at somerset arpt. Unable to locate the arpt, a landing was being made to a field when the acft stalled into trees during the approach. - [NTSB MIA86LA221](https://openairdocs.org/ntsb/MIA86LA221.md): Cessna 210B · Hopewell, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1986 · N9620X · Substantial damage > Flight experienced complete engine failure when crankshaft failed due to fatigue cracking of the crankshaft cheek between the number 1 and 2 rodbearing journal. During the subsequent forced landing the aircraft collided with trees due to the pilot not wanting… - [NTSB LAX86LA308](https://openairdocs.org/ntsb/LAX86LA308.md): Temco GC-1B · Huntington Bch, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1986 · N2338B · Substantial damage > The pilot stated that he was putting some time on the engine after maintenance had been performed when the engine quit. He initially stated that he departed at 1300 PDT with 12 gallons of fuel on board. He later stated that he departed at 1400 PDT and that… - [NTSB CHI86FEP07](https://openairdocs.org/ntsb/CHI86FEP07.md): Wheeler Gold Wing · Sturdevant, WI · Accident · No injuries · Final report · Jul 30, 1986 · N54314 · Substantial damage > This aircraft force landed shortly after takeoff and was substantially damaged when the wing struck the shoulder of a ditch during the landing. An examination of the engine after the accident revealed that the fuel pump was improperly installed (not in… - [NTSB SEA86LA182](https://openairdocs.org/ntsb/SEA86LA182.md): Bell 47G3B1 · Albany, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1986 · N9417A · Substantial damage > A Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter… - [NTSB CHI86LA185](https://openairdocs.org/ntsb/CHI86LA185.md): Piper PA-32R-301T · Morris, IL · Accident · No injuries · Limited investigation · Final report · Jul 29, 1986 · N81753 · Substantial damage > During cruise flight, the engine stopped and the pilot attempted to glide to an airport, but was forced to land in a cornfield, aprx one mile short of the airfield. A post-crash inspection revealed the flange of the left intermediate exhaust pipe (pn… - [NTSB CHI86FER15](https://openairdocs.org/ntsb/CHI86FER15.md): Samuel R. Hoskins Q-200 · Eden Prairie, MN · Accident · No injuries · Final report · Jul 29, 1986 · N202SH · Substantial damage > Aircraft was being test flown following ground adjustment of rudder control cables. During the flight rudder control was lost when rudder bearing blocks detached from their mounting surfaces. Pilot was unable to maintain directional control during landing… - [NTSB ANC86FA116](https://openairdocs.org/ntsb/ANC86FA116.md): Stinson 108-2 · Willow, AK · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1986 · N942D · Destroyed > About 5 to 10 min prior to the acdnt, svrl witnesses in the vicinity of the Willow arpt saw the acft headed southbound. They rprtd the eng was running rough, but they saw no smoke or fire. Aprx 3 mi further south, other witnesses saw the acft make a 180 deg… - [NTSB ANC86FA115](https://openairdocs.org/ntsb/ANC86FA115.md): Stinson ST108 · Chugiak, AK · Accident · Minor injuries · Field investigation · Final report · Jul 28, 1986 · N75092 · Substantial damage > The aircraft lost power in flight and crashed into a wooded area. VMC conditions prevailed and a VFR flight plan was filed. On site examination of the fuel tanks revealed that less than a quart of fuel remained in both tanks. - [NTSB LAX86FA303](https://openairdocs.org/ntsb/LAX86FA303.md): Piper PA-32-260 · Yosemite Nation, CA · Accident · 3 fatal · Field investigation · Final report · Jul 27, 1986 · N3643W · Destroyed > After flying low over Yosemite national park the Piper PA-32-260, operating as an on-demand passenger flight, climbed eastward into rising terrain. The flight path selected by the pilot was approximately one mile north and 1000 feet higher than tioga pass… - [NTSB ANC86LA113](https://openairdocs.org/ntsb/ANC86LA113.md): Cessna 150L · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1986 · N1504Q · Substantial damage > The acft contacted a roadside embankment during a forced landing following an engine failure due to fuel exhaustion. The acft had operated 5.1 hours since it was last refueled. The acft operator reported 4.5 hours is the normal endurance for the acft. - [NTSB DEN86LA209](https://openairdocs.org/ntsb/DEN86LA209.md): Piper PA-28-180 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jul 26, 1986 · N7592W · Destroyed > The plt reports that the flt was descending through 7,000 ft approaching the dest arpt when the eng began to run rough and lost pwr. The flt continued toward to the arpt but was unable to reach the rwy and landed about 1/4 mi short. After touchdown the acft… - [NTSB SEA86LA184](https://openairdocs.org/ntsb/SEA86LA184.md): Cessna T-210 · Battle Mountain, NV · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N4137C · Substantial damage > After a loss of power and a propeller overspeed, a forced landing was made. The pilot diverted from two chosen landing sites due to power lines crossing them. A road was chosen and during landing rollout the aircraft's wing tip clipped the top of a fence. The… - [NTSB CHI86LA180](https://openairdocs.org/ntsb/CHI86LA180.md): Cessna 152 · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N5499B · Substantial damage > The student pilot landed the aircraft on a road and it collided with a road sign after experiencing fuel exaustion on a solo cross-country flight. The flight lasted approximately 3.2 hours and covered 289 miles. The student stated that both fuel tanks looked… - [NTSB CHI86FEM12](https://openairdocs.org/ntsb/CHI86FEM12.md): Robinson R-22HP · Grayling, MI · Accident · No injuries · Final report · Jul 25, 1986 · N83595 · Substantial damage > The helicopter, during cruise flight, was flying low in an attempt to remain clear of clouds when it struck a power line and was forced to make an emergency landing. The helicopter received substantial damaged when it struck the power line and reportedly… - [NTSB CHI86LA178](https://openairdocs.org/ntsb/CHI86LA178.md): Cessna 172N · West Branch, MI · Accident · No injuries · Limited investigation · Final report · Jul 24, 1986 · N734XX · Substantial damage > The student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough… - [NTSB MIA86FA218](https://openairdocs.org/ntsb/MIA86FA218.md): Piper PA-28-181 · Steinhatchee, FL · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1986 · N6151J · Destroyed > On 7/23/86, ARTCC lost radar & radio contact with the acft while the plt was in lvl flt at 6000 ft in an area of lvl 3 & 4 thunderstorms (tstms). Two days later, the left wing panel & the tips of the horizontal stabilators were fnd in the vicinity of where… - [NTSB ATL86LA205](https://openairdocs.org/ntsb/ATL86LA205.md): Piper PA-28-160 · Dozier, AL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1986 · N5041W · Destroyed > The private plt and his pax were on a night cross country flt when he ran one fuel tank dry and the eng sputtered. He switched to the other tank and the eng caught for a few seconds then quit. He let down over a heavily forested area and stalled the acft into… - [NTSB MIA86MA217](https://openairdocs.org/ntsb/MIA86MA217.md): Douglas DC-3 · Isla Verde, PR · Accident · 1 fatal · Major investigation · Final report · Jul 22, 1986 · N27PR · Destroyed > Shortly after takeoff, the acft's climb performance bgn to deteriorate & the r eng started to overheat. Subsequently, the r eng was feathered & the crew attempted to return to the arpt. The radio transmitter bcm unintelligible, so the tower psnl cleared the… - [NTSB ATL86LA202](https://openairdocs.org/ntsb/ATL86LA202.md): Douglas DC-9-31 · Montgomery, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 1986 · N9332 · Minor damage > During flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi… - [NTSB ATL86LA201](https://openairdocs.org/ntsb/ATL86LA201.md): Piper PA-28-140 · Topsail Beach, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1986 · N7059R · Substantial damage > The plt was on a x-country flt from new york state to Florida with a planned refueling stop at wilmington, NC. He reported that he became disoriented when the acft's VOR needle began wavering, about 28 miles north of wilmington. Also, he stated that he no… - [NTSB ATL86FA203](https://openairdocs.org/ntsb/ATL86FA203.md): Bell 222UT · Chapel Hill, NC · Accident · Minor injuries · Field investigation · Final report · Jul 21, 1986 · N222DU · Substantial damage > Drg an emerg med svc (EMS)/med evac flt, an uncontained pwr turbine burst of the #1 eng occurred. Debris fm the #1 eng disabled the #2 eng & severed the tail rotor drive shaft. The #2 eng fire lgt illuminated & the plt discharged the #2 eng fire extinguisher.… - [NTSB MIA86LA215](https://openairdocs.org/ntsb/MIA86LA215.md): Cessna 177RG · Dania, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1986 · N1554H · Substantial damage > While flying along the beach the pilot noticed that the engine steadily lost power. The pilot then ditched the aircraft. Examination of the aircraft wreckage after recovery revealed that the fuel line from the fuel servo unit to the fuel divider block was… - [NTSB FTW86LA135](https://openairdocs.org/ntsb/FTW86LA135.md): Hughes 369D · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N1109T · Substantial damage > Reportedly the pilot was instructing the co-pilot in quick stop maneuvers, when the helicopter's tail boom and aft skids struck the ground on descent. The helicopter tail boom was bent 2 feet forward of the tail rotor gear box and both aft skids were broken.… - [NTSB CHI86FA174](https://openairdocs.org/ntsb/CHI86FA174.md): Cessna 172K · Random Lake, WI · Accident · 2 fatal · Field investigation · Final report · Jul 20, 1986 · N79069 · Destroyed > The acft lost pwr on final apprch and crashed into a swamp. Post accident investigation revealed that the eng camshaft was worn reducing the pwr output of the powerplant. - [NTSB MKC86FA151](https://openairdocs.org/ntsb/MKC86FA151.md): Whittman WD (Bigx) · Sheldahl, IA · Accident · 3 fatal · Field investigation · Final report · Jul 19, 1986 · N31637 · Destroyed > Witnesses state that they saw two airplanes, one silver and one red, climbing northbound to cruise altitude in loose formation when the red aircraft's engine backfired and the antique fabric-covered aircraft started burning. Flames five to eight feet in… - [NTSB ATL86LA199](https://openairdocs.org/ntsb/ATL86LA199.md): Bellanca 7KCAB · Orange Beach, AL · Accident · No injuries · Limited investigation · Final report · Jul 19, 1986 · N11703 · Substantial damage > During a banner towing flight along a Beach, the aircraft lost power and the pilot attempted a landing on the Beach of a small island. During landing roll the aircraft rolled into the water and flipped inverted. The operator of the aircraft reported that the… - [NTSB SEA86LA172](https://openairdocs.org/ntsb/SEA86LA172.md): Piper PA-28 · Petersburg, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 1986 · N7642F · Destroyed > The plt reported he had taken off in 'ok visibility' and proceeded toward wrangell, Alaska. En route he encountered 'ground fog' and was in the process of turning around when he 'hit conner (SIC) of fog on the hillside. Then hit trees.'the passenger reported… - [NTSB MIA86LA214](https://openairdocs.org/ntsb/MIA86LA214.md): Cessna 172P · Whiting, FL · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N54069 · Substantial damage > The private pilot of a rented Cessna 172P experienced an engine failure after flying 4.7 hours on a cross country flight. During the landing roll the nose gear failed in rough terrain. No fuel was found in the aircraft fuel tanks or lines during recovery and… - [NTSB NYC86FA183](https://openairdocs.org/ntsb/NYC86FA183.md): Bell B-222A · Staten Island, NY · Accident · No injuries · Field investigation · Final report · Jul 17, 1986 · N404WW · Substantial damage > The helicopter, on a FAR 135 flight was in cruise flt at 900 ft. the plt was checking for called VFR traffic and the co-pilot was occuppied with the RNAV when a loud bang was heard and a sudden yaw was felt. Both crew members stated they reacted as instructed… - [NTSB NYC86LA185](https://openairdocs.org/ntsb/NYC86LA185.md): Piper PA-28-140 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1986 · N32777 · Destroyed > The pilot made a departure from an uncontrolled airport. During the climb in IMC conditions, the aircraft struck trees and crashed. The aircraft received substantial damage and the pilot received serious injuries. The pilot had a clearance, however, the… - [NTSB BFO86LA040](https://openairdocs.org/ntsb/BFO86LA040.md): Cessna 172L · Aberdeen, MD · Accident · No injuries · Limited investigation · Final report · Jul 16, 1986 · N3933Q · Destroyed > The plt stated that the eng began to run rough during flt, then all at once, it started vibrating excessively. He attempted to land at the phillips aaf, but the arpt was closed & the rwy lights were not illuminated. By the time he saw the rwy, the acft was… - [NTSB ATL86IA197](https://openairdocs.org/ntsb/ATL86IA197.md): Boeing 727-25C · Erlanger, KY · Incident · No injuries · Incident investigation · Final report · Jul 16, 1986 · N126FE · No damage > An inflt fire started in a cargo 'igloo' during hi-alt cruise due to spillage of nitric acid in a contact with a wooden packing crate. The fire went out when the acft was de-pressurized but smoke and acid fumes were hazard to the cockpit crew. An emer lndg… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=323 ## 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=322 --- 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.