# 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 337 of 718 · 35,889 cases ## Cases, newest first - [NTSB FTW85MA297](https://openairdocs.org/ntsb/FTW85MA297.md): Beech H35 · El Reno, OK · Accident · 3 fatal · Major investigation · Final report · Jul 25, 1985 · N356B · Destroyed > The acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre… - [NTSB LAX85LA329](https://openairdocs.org/ntsb/LAX85LA329.md): Stinson 108-3 · Anza, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1985 · N876C · Substantial damage > During a cross country personal flight, the aircraft experienced fuel exhaustion for undertermined reasons and nosed over during the subsequent forced landing in a soft sand and scrub brush covered area. Prior to departure of the flight (a measured straight… - [NTSB ANC85FA135](https://openairdocs.org/ntsb/ANC85FA135.md): Stinson SR6 · Port Lions, AK · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1985 · N15120 · Destroyed > The pilot continued the flight into less than visual conditions; became spatially disoriented and crashed while the aiplane was out of control. - [NTSB CHI85LA305](https://openairdocs.org/ntsb/CHI85LA305.md): Kauffman BD4 · Acme, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1985 · N115PK · Substantial damage > The plt was on the second flt of newly certificated acft and had been airborne aprx 10 minutes when a total loss of pwr was experienced. Unable to return to the arpt the plt landed the acft in an open fld. During the landing roll the acft struck a road… - [NTSB FTW85LA293](https://openairdocs.org/ntsb/FTW85LA293.md): Piper PA-38-112 · Graford, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1985 · N2323E · Destroyed > The pilot arrived in the mineral wells, TX, area, his intended destination, and stated he couldn't see the airport due to the rotating beacon and runway lights not operating. Notamed to this effect, however, the airport supervisor stated that to the best of… - [NTSB CHI85LA307](https://openairdocs.org/ntsb/CHI85LA307.md): Bellanca 17-30 · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N7315V · Substantial damage > The acft collided with a ditch during a forced landing following a loss of power in cruise flt. The plt reported he switched the fuel selector from the left to the right tank, & after aprx 3 minutes, a total loss of power was experienced. He stated that… - [NTSB CHI85LA304](https://openairdocs.org/ntsb/CHI85LA304.md): Cessna 210H · Burlington, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 1985 · N6139F · Substantial damage > Pilot estimated 15 gals of fuel at preflt. After 15 min grd delay due to traffic pilot tookoff and climbed to 2,500'MSL. After cruising 22 nmi the engine quit due to fuel exhaustion. During attempt to ld in corn field pilot attempted to stretch his glide and… - [NTSB NYC85LA186](https://openairdocs.org/ntsb/NYC85LA186.md): Piper PA-18-95 · Stowe, VT · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N5777D · Substantial damage > During cruise flt, the plt heard a loud knocking coming from the eng and a decrease in oil pressure. During the landing in a fld, the landing gear collapsed and the acft ground looped. Examination of the eng disclosed that the hydraulic lifters of three of… - [NTSB MIA85LA216](https://openairdocs.org/ntsb/MIA85LA216.md): Cessna 172N · Frostproof, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N4941G · Substantial damage > The instructor plt (CFI) reported that while cruising at 2000 ft, the acft eng began losing power. He elected to land on a narrow highway that was bordered by trees. He stated that during the landing, the wind blew the acft off the asphalt surface, the nose… - [NTSB LAX85LA326](https://openairdocs.org/ntsb/LAX85LA326.md): Beech 95-B55 · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N7474N · Substantial damage > The preparing for an air taxi, sightseeing flight, the PIC performed a preflight inspection of the acft & failed to observe that the rt main fuel tank was nearly empty. Five(5) min after takeoff the rt eng's main tank fuel supply was exhausted & the eng lost… - [NTSB LAX85LA324](https://openairdocs.org/ntsb/LAX85LA324.md): Bellanca 17-30 · San Andreas, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 1985 · N7305V · Substantial damage > The plt took off on a 2 hr flt with about 6 hrs of fuel on board. On several occasions during the flt, he repositioned the fuel selector handle. He stated that when he made a very shallow turn to the right, near his destination, the eng suddenly lost power.… - [NTSB NYC85LA183](https://openairdocs.org/ntsb/NYC85LA183.md): Cessna 172E · Gardiner, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 1985 · N3625S · Substantial damage > During the return flt to Gardiner, NY, the plt elected to fly along the walkill river. The acft contacted power lines which crossed over the river and came to rest inverted in aprx 1 1/2 ft of water. The plt stated he was unaware of the power lines and he did… - [NTSB NYC85FA189](https://openairdocs.org/ntsb/NYC85FA189.md): Smith, Ted Aerostar Aerostar 601 · Erie, PA · Accident · 2 fatal · Field investigation · Final report · Jul 19, 1985 · N71MA · Destroyed > During a normal IFR cruise flight, the pilot of air Ohio flight 21, did not respond to ATC instructions. Air Ohio flight 21 continued for 40 minutes with no reply and without deviation in altitude or heading until the discrete target disappeared from radar… - [NTSB LAX85FA322](https://openairdocs.org/ntsb/LAX85FA322.md): Piper PA-28-181 · Phelen, CA · Accident · 3 fatal · Field investigation · Final report · Jul 19, 1985 · N2640Q · Destroyed > After receiving a preflight weather briefing 1 hour and 20 minutes before takeoff, that cautioned of lowering ceilings and thunderstorms along his proposed flt route, the plt took off under VFR. A flt plan was not filed. As the acft climbed to its cruise alt… - [NTSB FTW85LA296](https://openairdocs.org/ntsb/FTW85LA296.md): Cessna T210M · Kilgore, TX · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N761YK · Substantial damage > The plt was to ferry the acft from mena, AR, to jacksonville, TX. During pre-flt he discovered the fuel gages were inop and a visual check of the fuel quantity was made. The plt estimated sufficient fuel remained in the tanks to complete the 50 minute flt. En… - [NTSB MIA85LA213](https://openairdocs.org/ntsb/MIA85LA213.md): Cessna 172 · Leesburg, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1985 · N3781S · Destroyed > The plt experienced an electrical failure while on a night flt & was unable to activate the rwy lights by keying his radio. He elected to land on the unlighted rwy without any landing lights rather than divert to another arpt. The plt stated that during the… - [NTSB CHI85FEK01](https://openairdocs.org/ntsb/CHI85FEK01.md): Dietz Evans VP-1 · Bryan, OH · Accident · Serious injuries · Final report · Jul 18, 1985 · N6267 · Substantial damage > The acft impacted the terrain in an uncontrolled descent after stalling during an emergency descent. The plt stated that at an alt of 700-800 ft AGL, the engine RPM decreased from 3000 to 2400. The RPM continued to decrease and the acft stalled at an alt of… - [NTSB CHI85FA300](https://openairdocs.org/ntsb/CHI85FA300.md): Cessna 150L · Bainbridge, IN · Accident · 2 fatal · Field investigation · Final report · Jul 18, 1985 · N19293 · Destroyed > The acft was observed at about 300 ft AGL. It had just completed a turn with its wings level when it suddenly nosed over and entered a spin to ground impact. - [NTSB SEA85LA166](https://openairdocs.org/ntsb/SEA85LA166.md): Aerospatiale AS350D · Hoonah, AK · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N3601D · Substantial damage > During a CFR 135 flt the plt heard a loud noise coming from the rear of the acft with a corresponding left yaw. The eng was shut down in-flt and a successful autorotation was made onto water. The plt discovered 50 lbs of tools and 50 ft of cable had exited… - [NTSB NYC85LA179](https://openairdocs.org/ntsb/NYC85LA179.md): Cessna 152 · W.Stafford, CT · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N89856 · Substantial damage > The plt stated that shortly after takeoff upon reaching an alt of 3000 ft, the eng pwr dropped to 1000 RPM with the prop windmilling. He then went through the restart procedure to no avail. The plt then performed an eng shut down and force landed the acft in… - [NTSB FTW85LA289](https://openairdocs.org/ntsb/FTW85LA289.md): Bellanca 14-19-3 · Gatesville, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1985 · N7620E · Destroyed > The acft was destroyed by fire after executing an emergency landing following an inflight fire and eng failure. Shortly after takeoff the plt smelled electrical insulation overheating and noticed a decrease in fuel pressure. Fire broke out on the left side of… - [NTSB CHI85IA296](https://openairdocs.org/ntsb/CHI85IA296.md): Piper PA-28-180D · Lansing, MI · Incident · 1 fatal · Incident investigation · Final report · Jul 17, 1985 · N5328L · Minor damage > While en route to jackson, MI, the owner/plt suffered an apparent heart attack. The passenger, who was a private plt, safely landed the acft at Lansing, MI. The owner/plt's wife said that he had a plt certificate, but she could not locate it. There was no… - [NTSB CHI85FEX04](https://openairdocs.org/ntsb/CHI85FEX04.md): Texas Helicopter OH13E/M74 · Veedersburg, IN · Accident · Serious injuries · Final report · Jul 17, 1985 · N10000 · Destroyed > The acft was destroyed during a hard forced landing in a soybean fld following a loss of pwr. Inspection of the helicopter revealed the carburetor, fuel filter and fuel tank were void of fuel. The plt received received serious injuries during the accident and… - [NTSB ANC85LA128](https://openairdocs.org/ntsb/ANC85LA128.md): Cessna A-185F · Portage, AK · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N4611E · Substantial damage > Acft attempted to land on inlet mud flats & nosed over following a reported rough running engine. - [NTSB SEA85LA167](https://openairdocs.org/ntsb/SEA85LA167.md): Cessna 182 · Denio, NV · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N2611G · Substantial damage > A loss of pwr occurred while cruising above mountainous terrain. During forced landing the nose gear collapsed and the acft nosed over. The eng had just been rebuilt less than 37 hrs prior to the accident. The plt stated that a week prior to the accident the… - [NTSB NYC85LA174](https://openairdocs.org/ntsb/NYC85LA174.md): Piper PA-28-140 · Spring Valley, NY · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · CFEYV · Substantial damage > The plt decided to divert to the rampa valley arpt due to wx. He over flew the arpt 2 times, then made an apch to land, but the acft was high & fast, so he made a go-around. He stated that he made a normal landing on the next apch. However, he was unable to… - [NTSB CHI85LA291](https://openairdocs.org/ntsb/CHI85LA291.md): Balloon Works Firefly 6B · Battle Creek, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1985 · N1533S · 2 aircraft · Substantial damage > The envelope of Balloon N1533S was penetrated and torn by the basket of Balloon i-frog. The envelope was damaged to the degree that altitude could not be sustained. The aeronqut of N1533S was seriously injured upon ground impact. I-frog was landed without… - [NTSB ATL85FA213](https://openairdocs.org/ntsb/ATL85FA213.md): Beech 99 · Louisville, KY · Accident · No injuries · Field investigation · Final report · Jul 16, 1985 · N95WA · Substantial damage > While enroute to 8000 ft, both eng lost all power. The plts attempted return to the departure a/p was unsuccessful. He made an emerg ldg on the interstate highway. All landing gear was damaged. The fuel tanks were empty. There were conflicting fuel quantity… - [NTSB LAX85LA316](https://openairdocs.org/ntsb/LAX85LA316.md): Mooney M-20-E · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N6891U · Substantial damage > The acft collided with a cement embankment during the landing roll after completing an emergency landing in an open field about 5 miles so. Of Los Banos arpt, Los Banos, CA. The plt reported that shortly after departing harris-argo west arpt (5CA7), the acft… - [NTSB DEN85LA190](https://openairdocs.org/ntsb/DEN85LA190.md): Piper PA-25-235 · Thistle, UT · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N7614Z · Substantial damage > The plt had just completed an aerial spray mission and was flying through a canyon when the acft collided with pwr lines. Control of the acft was lost and it contacted the terrain. - [NTSB ATL85FA216](https://openairdocs.org/ntsb/ATL85FA216.md): Bell 206B · Anneville, KY · Accident · No injuries · Field investigation · Final report · Jul 15, 1985 · N16646 · Substantial damage > The pilot stated that the aircraft experienced hydraulic system failure followed by a loss of engine power. An emergency autorotation landing was attempted in a pasture and during the landing the aircraft was substantially damaged. Post crash examination… - [NTSB SEA85LA164](https://openairdocs.org/ntsb/SEA85LA164.md): Cessna 172 · Idaho City, ID · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N8655U · Substantial damage > Shortly after takeoff the pilot was unable to outclimb rising terrain. A tree was struck with the left wing tip. And shortly afterwards the aircraft mushed into trees. Density altitude at the time of takeoff computed to be about 6000 feet. The aircraft was… - [NTSB NYC85LA172](https://openairdocs.org/ntsb/NYC85LA172.md): Beech 36 · Calverton, NY · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N9031S · Substantial damage > The pilot of N9031S was advised that nantucket memorial airport was in IFR conditions and decided to turn back towards long island. During the flight to long island, N9031S lost radio communications and soon electrical power to the navigational equipment. The… - [NTSB MIA85LA210](https://openairdocs.org/ntsb/MIA85LA210.md): Cessna 177B · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N13714 · Substantial damage > The plt reported that shortly after taking off, while flying at 1400 ft, there was a strong odor of fuel in the cabin, then the eng lost power. He was unable to restart the eng & subsequently ditched the acft in the gulf of Mexico about 1/4 mi south of Cedar… - [NTSB FTW85LA285](https://openairdocs.org/ntsb/FTW85LA285.md): Ryan ST3KR (PT-22) · Hondo, TX · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N46170 · Substantial damage > The plt was on a x-country flt. Near the destination the eng experienced sudden seizure and all eng pwr was lost. The plt attempted an emergency landing but collided with a pwr line which resulted in substantial damage to the acft. The cause of the loss of… - [NTSB SEA85LA163](https://openairdocs.org/ntsb/SEA85LA163.md): Piper PA-38-112 · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N25678 · Substantial damage > The student solo x-country flt departed ogden, UT, at aprx 1130 MDT and made a touch & go at black foot, ID, at aprx 135 MDT. The plt stated the landing was a little rough and due to the distraction, he forgot to switch fuel tanks. Fuel exhaustion occurred at… - [NTSB LAX85LA318](https://openairdocs.org/ntsb/LAX85LA318.md): Grumman AA-1B · Paso Robles, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1985 · N8964L · Destroyed > The Paso Robles (prb) flight service station air traffic control specialist reptd that the pilot radioed that the aircraft ran out of fuel abt 5 miles so of prb. Examination of the wreckage disclsed both wing fuel tanks contained less that 1 gallon of fuel in… - [NTSB CHI85LA285](https://openairdocs.org/ntsb/CHI85LA285.md): Cessna 182 · North Canton, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1985 · N3920D · Substantial damage > The preflight, engine runup and initial takeoff were uneventful. At approx 600 ft AGL the engine sputtered for two or three seconds then stopped. The pilot turned back toward the runway but was too low. He crash landed in a gravel quarry after clipping power… - [NTSB ATL85LA217](https://openairdocs.org/ntsb/ATL85LA217.md): Piper PA-28-180 · Franklin, NC · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N779VM · Substantial damage > While in cruise flt eng RPM decreased. Plt actions to recover RPM were unsuccessful and eng eventually quit. A forced landing was made to an empty fld. On roll out the acft hit a concealed ditch resulting in substantial damage. Later, exmination of the eng… - [NTSB SEA85FA162](https://openairdocs.org/ntsb/SEA85FA162.md): Beech B36TC · Idaho City, ID · Accident · 2 fatal · Field investigation · Final report · Jul 12, 1985 · N948ST · Destroyed > The plt failed to obtain a preflt wx briefing prior to departing both butte, MT, and salmon, ID. En route at FL180 he entered instrument and icing conditions which he attempted to avoid by climbing to FL200. During the climb, the plt reported encountering… - [NTSB NYC85LA169](https://openairdocs.org/ntsb/NYC85LA169.md): Piper PA-28-140 · Cherry Valley, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1985 · N5602U · Substantial damage > Durng a climb to cruise, theengine RPM dropped to 2000. The pilot check the carburetor heat and other instruments and did not find any abnormalities. The engine RPM dropped a second time to 1800 a sound described by the pilot as a loud band was heard and the… - [NTSB LAX85FA315](https://openairdocs.org/ntsb/LAX85FA315.md): Bell 206-B · Page, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 12, 1985 · N38942 · Destroyed > On July 12, 1984, a Bell 206B helicopter collided with a steel bridge 10 miles so of Page, AZ. The helicopter was being filmed in flt during the making of a movie. VMC existed at the time. The helicopter was destroyed and the plt and pax, an italian actor,… - [NTSB FTW85LA286](https://openairdocs.org/ntsb/FTW85LA286.md): Cessna T210N · College Station, TX · Accident · No injuries · Limited investigation · Final report · Jul 12, 1985 · N5203A · Substantial damage > About 25 minutes after takeoff from a planned intermediate stop, the right fuel tank ran dry. After switching tanks, theplt decided to divert to a nearby arpt to refuel. During the descent, the left fuel tank ran dry and the eng quit due to fuel exhaustion.… - [NTSB DEN85FA179](https://openairdocs.org/ntsb/DEN85FA179.md): Piper J3C-65 · Columbus, MT · Accident · 2 fatal · Field investigation · Final report · Jul 12, 1985 · N6817H · Substantial damage > After making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact. - [NTSB LAX85LA313](https://openairdocs.org/ntsb/LAX85LA313.md): Cessna 182 · Sawmill, AZ · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N5706B · Substantial damage > During the plt's preflight inspection of his acft, he removed the fuel caps to examine the quantity of fuel in the acft's tanks. Thereafter, he failed to securely refasten the caps. At 0700 MST the plt & his 2 pax departed for a planned flt from AZ to co. 56… - [NTSB SEA85IA160](https://openairdocs.org/ntsb/SEA85IA160.md): Cessna 207 · Bellevue, WA · Incident · No injuries · Incident investigation · Final report · Jul 10, 1985 · N1755U · Minor damage > A complete loss of power occurred during a CFR 135 passenger flight. The oil filter adapter was found to be safety wired in a position with 3/4' of threads visable. Causing a complete and sudden loss of oil and power. - [NTSB FTW85LA278](https://openairdocs.org/ntsb/FTW85LA278.md): Piper PA-28-181 · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1985 · N8203D · Substantial damage > The eng failed at about 2000 ft MSL while the acft was climbing to cruise flt. The plt attempted to turn back to the arpt but realized it was too FAR away. The plt then made a forced landing in a grass area adjacent to a large hwy at about a 45 deg angle to… - [NTSB SEA85LA158](https://openairdocs.org/ntsb/SEA85LA158.md): Rand/Robinson KR2 · Pullman, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 1985 · N82CG · Destroyed > The plt had been having numerous problems with his homebuilt acft's eng running rough before this flt. Shortly after takeoff a loss of pwr occurred. It was a hot day with the temp being 90 degs f or better. FAA inspectors found the tourque value to be… - [NTSB BFO85LA054](https://openairdocs.org/ntsb/BFO85LA054.md): Cessna 172-RG · Thurmont, MD · Accident · No injuries · Limited investigation · Final report · Jul 8, 1985 · CGFIE · Substantial damage > Upon encountering a low ceiling, precipitation, and haze at approximately 1500 feet MSL, the plt descended in order to locate a suitable landing area. The plt observed a grass airstrip below him, and executed a hard landing. The aircraft bounced once, and… - [NTSB DEN85LA183](https://openairdocs.org/ntsb/DEN85LA183.md): Cessna 172P · Rio Rancho, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1985 · N53410 · Substantial damage > During a pleasure flt, with his parents as pax, the plt decided to demonstrate a glide down to aprx 500 ft AGL. When he added power for recovery, he stalled the acft. Before complete recovery was possible, the acft struck the ground. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=338 ## 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=337 --- 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.