# NTSB investigations: Maneuvering 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 203 of 378 · 18,851 cases ## Cases, newest first - [NTSB ANC85LA143](https://openairdocs.org/ntsb/ANC85LA143.md): Piper PA-22 · Mccarthy, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 1985 · N2566A · Substantial damage > The plt stated that while executing a 180 deg right turn the acft drifted 50 ft to the east of rwy 19 where it struck a row of trees. The acft continued in a steep descending turn. The acft stalled and crashed into a wooded area. - [NTSB MIA85LA224](https://openairdocs.org/ntsb/MIA85LA224.md): Bell TH-13T · Quitman, GA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N31FG · Substantial damage > Pilot stated that after completing a left turn at the end of a cotton field, the aircraft yawed sharply to the left and the yaw could not be controlled with cyclic control. Another left turn at the oppsite end of the field the aircraft again yawed to the… - [NTSB LAX85LA336](https://openairdocs.org/ntsb/LAX85LA336.md): Bell 206 B3 · Arroyo Grande, CA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1985 · N90328 · Substantial damage > While hovering and slinging an external load over rough terrain the eng chip light illuminated. The plt immediately positioned the acft to release the load and the eng began making a 'whining' noise. Several seconds later all eng power was lost. The plt… - [NTSB SEA85LA187](https://openairdocs.org/ntsb/SEA85LA187.md): Grumman 164A · Shelley, ID · Accident · No injuries · Limited investigation · Final report · Jul 30, 1985 · N5186 · Substantial damage > The safety broke in the carburetor and the seat backed out causing fuel starvation. The carburetor had been overhauled 350 hours prior to the accident. - [NTSB DEN85LA207](https://openairdocs.org/ntsb/DEN85LA207.md): Cessna 205 · Pueblo, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1985 · N1818Z · Substantial damage > The plt/owner departed Pueblo, CO, on a VFR pleasure flt to California. During the flt the plt encountered IMC and elected to return to Pueblo. Witnesses observed the plt making low passes over his parent's home in west Pueblo just prior to impacting rolling… - [NTSB LAX85LA332](https://openairdocs.org/ntsb/LAX85LA332.md): Gulfstream-Schweizer Gulfstream AM G-164B · Poston, AZ · Accident · No injuries · Limited investigation · Final report · Jul 29, 1985 · N8133K · Substantial damage > The plt reported weather conditions during the night aerial application flt were 'clear and winds of 15 KTS with gusts to 20 KTS. After three unsuccessful attempts to line up for the spray run, the plt said he allowed the acft to 'get too low and slow' while… - [NTSB LAX85FUM01](https://openairdocs.org/ntsb/LAX85FUM01.md): Aerotek Pitts S-2A · Ramona, CA · Accident · 2 fatal · Final report · Jul 29, 1985 · N56PS · Destroyed > On July 28, 1985 at approximately 1820 hours, a pitts S-2A, N56PS, owned and operated by william l. travis, crashed on a hillside on the 192 deg radial, 12.8 nautical miles from the julian VOR. The flight was for the purpose of aerobatics. The aircraft was… - [NTSB CHI85FA316](https://openairdocs.org/ntsb/CHI85FA316.md): Cessna 172G · Plain City, OH · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1985 · N4202L · Destroyed > The plt had just taken off from his pvt strip for the fourth flt of the day when witnesses heard the eng quit. The acft had been flown 3.4 hrs since the last refueling. The acft was being operated on a mixture of avgas and automotive fuel with no STC. The… - [NTSB ATL85LA226](https://openairdocs.org/ntsb/ATL85LA226.md): Grumman G-164A · Athens, AL · Accident · No injuries · Limited investigation · Final report · Jul 29, 1985 · N10AA · Substantial damage > During an aerial application flight the aircraft lost power due to fuel exhaustion. The pilot made an emergency landing in a corn field. The pilot stated that he visually checked the fuel prior to take off and it appeared as if there was enough fuel to… - [NTSB ANC85LA137](https://openairdocs.org/ntsb/ANC85LA137.md): Piper PA-18 · Drift River, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1985 · N14159 · Substantial damage > Apln crashed on gravel bar after wing tip hit ground during low alt turn. The unlicesed plt stated that he WA s in his second 360 deg turn & hit his own wake turbulence. - [NTSB ANC85FA138](https://openairdocs.org/ntsb/ANC85FA138.md): Cessna 172M · Red Devil, AK · Accident · 4 fatal · Field investigation · Final report · Jul 29, 1985 · N12904 · Destroyed > Shortly after the plt took off on a ngt flt to bethel, the acft crashed just north of the east/west rwy in a nose down attitude & on a southwesterly heading. The acft was destroyed during impact, but contd sliding aprx 35 yds to the north edge of the rwy,… - [NTSB NYC85LA197](https://openairdocs.org/ntsb/NYC85LA197.md): Luscombe 8A · Coventryville, NY · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N45564 · Substantial damage > During a local flt over Coventryville, NY, the plt decided to overfly and observe a building. The plt made one pass and was about to make another when the eng began to lose pwr. While planning to land in a nearby fld, the eng regained pwr and the plt… - [NTSB MKC85LA173](https://openairdocs.org/ntsb/MKC85LA173.md): Piper PA-25-235 · Norcatur, KS · Accident · No injuries · Limited investigation · Final report · Jul 28, 1985 · N4772Y · Substantial damage > The acft had been spraying for 40 minutes at 2500 ft MSL with a density alt of aprx 4600 ft when it stalled during a turnaround. It then impacted an electric pwr pole followed by the terrain. - [NTSB MKC85FA169](https://openairdocs.org/ntsb/MKC85FA169.md): Piper PA-18 · North Loup, NE · Accident · 2 fatal · Field investigation · Final report · Jul 27, 1985 · N9973Q · Destroyed > The acft was observed flying low over the ground in the vicinity of where it eventually crashed. A witness aprx 1/2 mi from the crash site noticed the plane flying low over a corn field as though the student plt was practicing ag-acft type swath runs. (The… - [NTSB CHI85FA315](https://openairdocs.org/ntsb/CHI85FA315.md): Christopher D. Brown Gyroplane · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Jul 26, 1985 · N46Z · Destroyed > The pilot was practicing low altitude maneuvers, adjacent to the runway. When he turned to make a downwind, at the southeast end of the runway, he impacted with the terrain. Witnesses stated that they observed the gyroplane making steep turns at a low… - [NTSB ATL85LKG08](https://openairdocs.org/ntsb/ATL85LKG08.md): Schweizer AG CAT · Samson, AL · Accident · No injuries · Final report · Jul 26, 1985 · N3629K · Substantial damage > The acft was damaged in a forced lndg after a pwr loss during a swath run. During the ldg a pwr line was struck and the acft was pulled sideways which caused a groundloop and resulted in damages. Lyon flying services of welsh la dismantled the eng & found no… - [NTSB SEA85LA177](https://openairdocs.org/ntsb/SEA85LA177.md): Cessna 172 · Mitchell, OR · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N734WW · Substantial damage > A go-around was attempted and the pilot was unable to outclimb rising terrain. The field elevation was over 3400 feet and the temperature was above 90 degrees. The pilot made a turn to avoid terrain and stalled. The density altitude was around 7,800 feet. - [NTSB CHI85FEP02](https://openairdocs.org/ntsb/CHI85FEP02.md): Neyman-Pietenpol GN-2 · Brodhead, WI · Accident · Serious injuries · Final report · Jul 25, 1985 · N13708 · Destroyed > The acft was observed making steep turns at about 500 ft AGL just prior to the acdnt. One witness stated that the airspeed was decaying during these turns & the acft stalled while in a steep bank. Reportedly, the acft began spinning, then the plt stopped the… - [NTSB DEN85LTG04](https://openairdocs.org/ntsb/DEN85LTG04.md): Piper PA-25 · Antler, ND · Accident · No injuries · Final report · Jul 24, 1985 · N6083Z · Substantial damage > The left wing of the acft received substantial damage when it contacted trees during a pull-up at the end of a swath run. The plt then flew the acft to a fld aprx 1 mile away and a precautionary landing was made. - [NTSB BFO85FA062](https://openairdocs.org/ntsb/BFO85FA062.md): Piper J3C-65 · Oakland, MD · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1985 · N70336 · Destroyed > The acft had been observed on the day of this flt and on the 'past couple of days' to be flying low and very slow at tree top level. Ground witnesses heard the sounds of the crash but could not see the acft at the time. The acft impactedthe ground in a near… - [NTSB BFO85FA061](https://openairdocs.org/ntsb/BFO85FA061.md): Cessna 152 · Mechanicsville, MD · Accident · Serious injuries · Field investigation · Final report · Jul 23, 1985 · N24787 · Substantial damage > After completing several low altitude passes over the family business, the student pilot extended 10 degrees of flaps and pulled the power back to slow the airplane in order to lengthen his viewing time. According to the pilot, after the accident, at between… - [NTSB DEN85LA195](https://openairdocs.org/ntsb/DEN85LA195.md): Schweizer G-164B-600 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Jul 22, 1985 · N6825K · Substantial damage > The plt was crop spraying a field in a Schweizer ag-cat acft when the left landing wire broke. The plt returned to Riverton, WY. During the landing roll, in attempt to stop the acft as soon as possible, he inadvertently applied the brakes too hard, causing… - [NTSB NYC85FA185](https://openairdocs.org/ntsb/NYC85FA185.md): Bellanca 8KCAB · Fall River, MA · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1985 · N5504B · Destroyed > Witnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a… - [NTSB CHI85LA310](https://openairdocs.org/ntsb/CHI85LA310.md): Enstrom 280C · Milford, MI · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N556H · Substantial damage > The pilot made a 'steep approach' to a hover over a boat channel and then ld in the yard of a residence. He then picked up a 270 id pax flew a short flt and was refueled with 25 gals of fuel. After another short flt the pilot returned to the channel and… - [NTSB LAX85LA323](https://openairdocs.org/ntsb/LAX85LA323.md): Bell 206B · Soda Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 1985 · N7910J · Substantial damage > On July 19,1985 a Bell 206B lost control while maneuvering near Soda Springs,CA.the aircraft was substantially damaged and the two pilots sustained serious injuries. The repoted he was maneuvering at 30 mph looking for sheep in mountainous terrain when he… - [NTSB ANC85LA126](https://openairdocs.org/ntsb/ANC85LA126.md): Champion 7KCAB · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N9045L · Substantial damage > The pilot-in-command made a low pass over the airstrip from south to north and UP0N reaching the departure end began a right hand turn at 50 to 75 foot above ground level. Upon reaching 30 to 40 degrees angle of bank, he lost control of the airplane.… - [NTSB SEA85FA171](https://openairdocs.org/ntsb/SEA85FA171.md): Piper J3-C-65 · Goose Prairie, WA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 1985 · N70691 · Destroyed > The acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during… - [NTSB MIA85LA214](https://openairdocs.org/ntsb/MIA85LA214.md): Bell 47D1 · Moultrie, GA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N586T · Substantial damage > The plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom. - [NTSB ATL85LA219](https://openairdocs.org/ntsb/ATL85LA219.md): Hiller UH-12E · Pickens, SC · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N40296 · Substantial damage > The plt had completed application of a herbicide and was returning to his temp opns area 1/2 mi distant when the engine quit about 50 ft AGL. Plt flared the helicopter on the 45 deg downslope and tailbeem/rotor contacted ground. The fuel gauge ind 18 gals… - [NTSB LAX85LA321](https://openairdocs.org/ntsb/LAX85LA321.md): Piper PA-28-235 · Monterey, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 17, 1985 · N15548 · Destroyed > The pilot took off on a training flight to practice holding over a VOR intersection 12 miles off shore. Approximately 12MINUTES after take off the pilot declared 'mayday,rough engine', to the Monterey,calfornia control tower control specialist. The control… - [NTSB LAX85LA320](https://openairdocs.org/ntsb/LAX85LA320.md): Grumman G-164A · Durham, CA · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N7853 · Destroyed > During an ag flight in which a compound containing sulfur dust was being sprayed a fire began in the acft's spray apparatus. The cockpit filled with heavy smoke & the plt made a successful forced ldg in the underlying field. The fire spread & eventually… - [NTSB FTW85LA288](https://openairdocs.org/ntsb/FTW85LA288.md): Bell 47G-5 · Crane, TX · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N8197J · Destroyed > The helicopter was being operated from a flat bed trailer. The plt stated he had lifted to a 3 foot hover when the eng stopped. The helicopter suddenly rotated about 45 degs before he could stop it. The plt attempted to make an autorotation touchdown but was… - [NTSB CHI85LA290](https://openairdocs.org/ntsb/CHI85LA290.md): Hughes 269A · Oconomowoc, WI · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N8877F · Substantial damage > The helicpoter contacted a corn crop and came to rest inverted during an aerial application flt. The plt stated, 3 passes were made over the fld being sprayed and after a turn to begin the 4th pass, the helicopter settled with pwr contacting the crop. - [NTSB CHI85FA292](https://openairdocs.org/ntsb/CHI85FA292.md): Cessna 170A · Olney, IL · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1985 · N1223D · Substantial damage > The aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and… - [NTSB LAX85LVM04](https://openairdocs.org/ntsb/LAX85LVM04.md): Larry Robbins Bakeng Duce · Gilroy, CA · Accident · Serious injuries · Final report · Jul 14, 1985 · N3957D · Substantial damage > The acft crashed after circling a ground fire at about 500 ft AGL. The plt said that she was watching the grnd fire when suddenly the acft dropped to the left. She added power and applied opposite rudder but the acft did not recover. She does not remember… - [NTSB CHI85FA284](https://openairdocs.org/ntsb/CHI85FA284.md): Eipper MX Super · Almont, MI · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1985 · N23MX · Destroyed > Witnesses reported the acft was in an inverted flight aprx 60 to 70 ft AGL before it entered a split 's' maneuver and descended to ground impact. The plt was performing aerobatics in an airshow when the accident occurred. The plt's aerobatic waiver had… - [NTSB DEN85LA187](https://openairdocs.org/ntsb/DEN85LA187.md): Piper PA-28-181 · Kiowa, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1985 · N3030Z · Substantial damage > The acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at… - [NTSB DEN85FA186](https://openairdocs.org/ntsb/DEN85FA186.md): Piper PA-28-161 · Aspen, CO · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1985 · N2443Y · Destroyed > CFI and student departed Aspen, Colorado, on a dual x-country flt. The density altitude at the time of departure was calculated to be 9954 feet. The CFI directed student to fly up a canyon in an area of rising terrain. The CFI took control of acft and was… - [NTSB MKC85LA152](https://openairdocs.org/ntsb/MKC85LA152.md): Bell 47G · Pella, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1985 · N75273 · Substantial damage > The purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a… - [NTSB FTW85LA281](https://openairdocs.org/ntsb/FTW85LA281.md): Weatherly 201B · Rosharon, TX · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N2938W · Substantial damage > The plt stated he failed to switch fuel selector to the left tank prior to takeoff (right tank empty). The engine quit abruptly at low altitude. Plt switched to left tank but could not regain engine power prior to hard landing in cotton field. - [NTSB DEN85LTG03](https://openairdocs.org/ntsb/DEN85LTG03.md): Piper PA-25-235 · Kramer, ND · Accident · No injuries · Final report · Jul 10, 1985 · N9538P · Substantial damage > The acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt. - [NTSB CHI85LA283](https://openairdocs.org/ntsb/CHI85LA283.md): Air Tractor AT301 · Roseau, MN · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N23702 · Substantial damage > The aircraft had been airborne about 15 min engaged in ag spray operations when the pilot described hearing a loud band. Engine power decreased to idle. Pilot ld in soft soil and nosed over inverted. Exam disclosed #2 piston had failed. - [NTSB CHI85LA280](https://openairdocs.org/ntsb/CHI85LA280.md): Hughes 269A1A · Coal Valley, IL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N8951F · Substantial damage > During an aerial application run the plt reported a 'split second loss of power.' He lost directional control of the helicopter and it settled into tall corn. Impact resulted in loss of the main rotor blades, severence of the tail cone and separation of the… - [NTSB LAX85FA311](https://openairdocs.org/ntsb/LAX85FA311.md): Cessna 152 · Marana, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 8, 1985 · N5204P · Destroyed > The passenger had just purchased property at the accident site and intended to take aerial video tape footage of the property. Witnesses saw the plt and passenger board the acft with video camera and recorder. After departue, the acft flew directly to the… - [NTSB ANC85LA123](https://openairdocs.org/ntsb/ANC85LA123.md): Cessna 185F · Egegik, AK · Accident · No injuries · Limited investigation · Final report · Jul 8, 1985 · N8700Z · Substantial damage > Engine failed at 200 ft AGL, due to fuel starvation. Plt attempted to reach lake, & crashed in trees at edge of lake. - [NTSB ANC85LA121](https://openairdocs.org/ntsb/ANC85LA121.md): Robinson R-22A · Summit Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N8530J · Substantial damage > Helicopter struck glassy water lake during a low alt turn. Plt/flt instructor said he became disoriented during the turn, after he looked inside the helicopter briefly to check the rotor RPM. Accident occured during a bright night. - [NTSB NYC85LA159](https://openairdocs.org/ntsb/NYC85LA159.md): MBB GMBO-105C · Pittsburgh, PA · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1985 · N83CJ · Destroyed > The air ambulance helicopter landed hard and rolled over after collidding with a fence. The helicopter had taken off to a hover position and was making a pedal turn in preparation for a climb. Collective was increased but RPM decreased and the acft began to… - [NTSB DEN85LA182](https://openairdocs.org/ntsb/DEN85LA182.md): Cessna 182-R · Telluride, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1985 · N9837H · Destroyed > The plt said that he maneuvered the near max gwt acft in close proximity to a ski slope and 'I didn't leave myself an exit.' The plt then applied full power in an attempt to outclimb the rising terrain but impacted a knoll. Density altitude was computed to be… - [NTSB CHI85LA275](https://openairdocs.org/ntsb/CHI85LA275.md): Bell 47G-3B-1 · Donaldson, MN · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N7856S · Substantial damage > When the plt applied pwr to level off while entering a spray the eng did not produce sufficient pwr to stop the descent. He attempted a run on landing but the uneven terrain caused substantial damage to the helicopter. Inspection of the eng revealed the… - [NTSB LAX85LA305](https://openairdocs.org/ntsb/LAX85LA305.md): Hiller UH-12E · Gonzales, CA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N161HA · Substantial damage > While cruising during an ag flight the acft's eng began losing pwr. At the time the acft was about 50 ft AGL & was travelling at 50 mph. The plt made a forced ldg onto a nearby plowed fld. Upon touchdown the rt skid dug into a furrow & the acft rolled over.… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=204 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=203 --- 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.