# 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 197 of 378 · 18,851 cases ## Cases, newest first - [NTSB FTW86FRG24](https://openairdocs.org/ntsb/FTW86FRG24.md): Grumman G-164 · La Feria, TX · Accident · No injuries · Final report · Jun 5, 1986 · N552Y · Destroyed > As the plt was making a swath run, he started to cross under power lines, but saw the profile view of a road marker. When he pulled up to avoid the road marker, the acft struck the wires, rolled to the left & collided with the ground. - [NTSB FTW86LA100](https://openairdocs.org/ntsb/FTW86LA100.md): Bellanca 7GCAA · Thomas, OK · Accident · No injuries · Limited investigation · Final report · Jun 4, 1986 · N8580V · Destroyed > Shortly after takeoff at an alt of aprx 200 ft AGL, the plt attempted a snap-roll. The plt was unable to recover after the intended 1 roll and the maneuver continued for 1 1/2 rolls. The plt was able to level the wings but the acft contacted the terrain in a… - [NTSB DEN86LA151](https://openairdocs.org/ntsb/DEN86LA151.md): Bell 206B · Portal, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1986 · N59495 · Substantial damage > The plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side. - [NTSB MIA86LA171](https://openairdocs.org/ntsb/MIA86LA171.md): Air AT301 · Darling, MS · Accident · No injuries · Limited investigation · Final report · Jun 2, 1986 · N8569S · Destroyed > The plt stated that during an aerial application swath run he attempted to go around a telephone wire. The acft stalled, hit the ground and was destroyed by post crash fire. - [NTSB ATL86FA156](https://openairdocs.org/ntsb/ATL86FA156.md): MBB BO-105C · Peterson, AL · Accident · 3 fatal · Field investigation · Final report · Jun 2, 1986 · N114BH · Destroyed > The EMS helicopter was heard and observed as it flew at low altitude down the river. A witness saw it dip down then attempt to climb just prior to the collision with power lines across the river. The helicopter broke the wires but was stopped and came apart… - [NTSB ATL86FA155](https://openairdocs.org/ntsb/ATL86FA155.md): Beech 95-B55 · Elizabethtown, KY · Accident · 1 fatal · Field investigation · Final report · Jun 2, 1986 · N3001S · Destroyed > Acft observed in level flt in IMC just below EST 500 foot ovc. EST viz about 3/4 mi. Lt wing struck 15/16 inch dia steel guy cable 534 feet AGL shearing outer 118 in. Acft impacted earth fill dam 1169 ft from 650 feet tall tv antenna. Tower. Top of tower… - [NTSB MKC86FA123](https://openairdocs.org/ntsb/MKC86FA123.md): Cessna 140 · Des Arc, AR · Accident · 3 fatal · Field investigation · Final report · Jun 1, 1986 · N89247 · 2 aircraft · Destroyed > Numerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the… - [NTSB ATL86LA153](https://openairdocs.org/ntsb/ATL86LA153.md): Cessna 150M · Franklin, NC · Accident · No injuries · Limited investigation · Final report · Jun 1, 1986 · N8109U · Destroyed > Fifty two hr pvt plt flying over lake in mountainous terrain started climb out toward destination. Elevation of lake about 3000 ft. ambient temp about 90 f. plt could not climb a/c at an angle to clear rising terrain. Flew a/c into trees. - [NTSB SEA86FA137](https://openairdocs.org/ntsb/SEA86FA137.md): Bell UH-1L · Wenatchee, WA · Accident · 1 fatal · Field investigation · Final report · May 31, 1986 · N4964N · Destroyed > N4964N, a Bell UH-1L, was being operated in logging ops by an experienced, military trained plt who possessed 6000 hrs of flt experience in model. While lifting a sling load gnd crew rptd smoke from the tail rotor area. Plt released sling load & acknowledged… - [NTSB MKC86LA121](https://openairdocs.org/ntsb/MKC86LA121.md): Aero Commander S-2R · Pocahontas, AR · Accident · No injuries · Limited investigation · Final report · May 31, 1986 · N8896Q · Substantial damage > The pilot stated that this was his third flight of the morning with a full load of fertilizer. Reportedly, he was in the process of aerial application, when the engine quit. He made a forced landing on a short field road. He further stated that the ground… - [NTSB LAX86MA238](https://openairdocs.org/ntsb/LAX86MA238.md): Aerospatiale AS-355F-1 · Kameula, HI · Accident · Minor injuries · Major investigation · Final report · May 31, 1986 · N909CH · Substantial damage > The plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the… - [NTSB FTW86FA096](https://openairdocs.org/ntsb/FTW86FA096.md): Meyers 200B · Krum, TX · Accident · 1 fatal · Field investigation · Final report · May 31, 1986 · N34397 · Destroyed > The retired airline captain was returning to a retirement party for another airline captain. He began a barrel roll from a relatively low pass over the party, but collided with the ground on pull out. Alcohol was not a factor. - [NTSB DEN86FA146](https://openairdocs.org/ntsb/DEN86FA146.md): Bauer'S Mitchell Wing U-2 · Cheyenne, WY · Accident · 1 fatal · Field investigation · Final report · May 31, 1986 · N3967S · Destroyed > This was an experimental amateur-built acft. Witnesses reported seeing the acft in a steep right bank when the eng lost power. The acft was then seen to stall and enter a right spin. Witnesses said the plt recovered but entered a second stall and dove… - [NTSB ATL86LA151](https://openairdocs.org/ntsb/ATL86LA151.md): Cessna 120 · Magnolia, KY · Accident · Serious injuries · Limited investigation · Final report · May 31, 1986 · N76730 · Substantial damage > The plt was using the acft to drop a tool to a mechanic friend and was flying at low alt toward rising terrain to verify the location where the tool fell. Witnesses said that when the plt exited the acft after the accident he stated he was too low, too slow,… - [NTSB SEA86LA134](https://openairdocs.org/ntsb/SEA86LA134.md): Ayres S2R · Hamer, ID · Accident · No injuries · Limited investigation · Final report · May 29, 1986 · N4000A · Substantial damage > During aerial application the engine ceased operating and a small fire erupted. During forced landing the landing gear was torn off and the fuselage became twisted. After landing, the fire continued for a short period of time. Postaccident eng teardown… - [NTSB MIA86LA168](https://openairdocs.org/ntsb/MIA86LA168.md): Bell 47-D1 · Panama City Bch, FL · Accident · Minor injuries · Limited investigation · Final report · May 29, 1986 · N10065 · Substantial damage > The pilot had intended to hover the helicopter and allow a 'clown' to touch the skids while a photographer recorded the event looking upward to give the appearance that the 'clown' was hanging from the skid. The 'clown' grabbed the left rear skid and the… - [NTSB FTW86FPA18](https://openairdocs.org/ntsb/FTW86FPA18.md): Eagle Eagle DW-1 · Howe, TX · Accident · 1 fatal · Final report · May 28, 1986 · N8814G · Substantial damage > The acft appeared to stall during a sharp pull-up and turn during a test flt after a low pass over the airstrip. The plt was testing the spray equipment and made the low pass so the ground observer could see the spray pattern. No malfunctions in equipment… - [NTSB ATL86LA146](https://openairdocs.org/ntsb/ATL86LA146.md): Hughes 300/269B · Marshville, NC · Accident · Minor injuries · Limited investigation · Final report · May 28, 1986 · N9460F · Substantial damage > During an instructional flight, a power recovery was attempted at the completion of a practice autorotation. Power was applied and the engine lost power. The autorotation was completed to the preselected practice field and the helicopter rolled over after a… - [NTSB NYC86FNC03](https://openairdocs.org/ntsb/NYC86FNC03.md): Piper J-3 · Milan, NH · Accident · 1 fatal · Final report · May 25, 1986 · N6498H · Destroyed > The pilot was flying a 'drunken farmer' routine at a airshow. He was observed in the air to begin a descent from which he did not recover. The pilot was fatally injured in the crash and the aircraft destroyed. No mechanical or physical reason for the crash… - [NTSB FTW86FA091](https://openairdocs.org/ntsb/FTW86FA091.md): Aerotek Pitts S2A · Santa Fe, TX · Accident · 2 fatal · Field investigation · Final report · May 24, 1986 · N80004 · Destroyed > A short occurred in the aircraft's electrical system distracting the owner/pilot occupying the back seat of the aircraft. This seat was not equipped with a second lap restraint. The aircraft was observed, by witnesses, to enter a spin which went inverted. The… - [NTSB CHI86FEV02](https://openairdocs.org/ntsb/CHI86FEV02.md): Jerry Cox Goldwing · Mattoon, IL · Accident · Serious injuries · Final report · May 24, 1986 · N85JC · Substantial damage > The acft was circling a racetrack at a relatively low alt, described as between 800-1500 ft AGL, with the eng throttled back. During a subsequent steep bank to the left while accelerating the left wing failed and the acft crashed into the trees. - [NTSB ATL86FKG09](https://openairdocs.org/ntsb/ATL86FKG09.md): Pitts S-1 · Atmore, AL · Accident · 1 fatal · Final report · May 24, 1986 · N83JW · Substantial damage > The acft crashed almost vertically from aprx 250/300 ft AGL after rolling inverted at the completion of a double snap roll to the rt. The acft slowed during the rolls and appeared to be too slow to control the stopping of the rolls. The acft continued to roll… - [NTSB NYC86FA133](https://openairdocs.org/ntsb/NYC86FA133.md): Mooney M20K · West Milford, NJ · Accident · 3 fatal · Field investigation · Final report · May 23, 1986 · N97299 · Destroyed > While on an IFR flight the aircraft entered an area of thunderstorms, lost control of the aircraft and crashed. In an attempt to circumnavigate the storms the plt inadvertently entered a storm and collided with the ground in an uncontrolled descent. The plts… - [NTSB CHI86FER09](https://openairdocs.org/ntsb/CHI86FER09.md): Piper PA-22-150 · Lino Lakes, MN · Accident · 1 fatal · Final report · May 23, 1986 · N5710D · Destroyed > This aircraft was overloaded on takeoff with extra fuel, camping equipment, a passenger, an outboard motor, tools and the like. In addition the center of gravity was probably out of safe limits. An additional factor affecting takeoff and turn performance was… - [NTSB FTW86LRD13](https://openairdocs.org/ntsb/FTW86LRD13.md): Grumman G164B · Morse, LA · Accident · No injuries · Final report · May 22, 1986 · N665OQ · Substantial damage > The acft settled into power lines and stalled into the ground during a spray operation. The plt had turned downwind to line up for his spray run. The acft started descending and even though power was applied as load was jettisoned the acfts tail wheel snagged… - [NTSB FTW86LRD12](https://openairdocs.org/ntsb/FTW86LRD12.md): Grumman G-164A · Branch, LA · Accident · No injuries · Final report · May 21, 1986 · N5407 · Substantial damage > Shortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower. - [NTSB SEA86FA121](https://openairdocs.org/ntsb/SEA86FA121.md): Cessna 152 · Mead, WA · Accident · 2 fatal · Field investigation · Final report · May 20, 1986 · N6161M · 2 aircraft · Destroyed > Both acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for… - [NTSB FTW86LRG21](https://openairdocs.org/ntsb/FTW86LRG21.md): Grumman G-164B · Port O'Connor, TX · Accident · No injuries · Final report · May 20, 1986 · N6740Q · Substantial damage > Acft flipped over on touchdown during an emergency landing in a cultivated field following a partial power loss during a swath run at 30 ft AGL. Investigation revealed that the no. 1 cyl exhaust valve push rod had failed. Exact cause of the push rod failure… - [NTSB ATL86LA138](https://openairdocs.org/ntsb/ATL86LA138.md): Bell 47G-3B · Red Bay, AL · Accident · No injuries · Limited investigation · Final report · May 19, 1986 · N73269 · Substantial damage > The pilot had completed a dispensing operation and was returning to the ag staging area to refuel. As the helicopter hovered towards the parked refueling vehicle, the main rotor blades struck a metal structure attached to the truck. The pilot stated that the… - [NTSB LAX86FJA06](https://openairdocs.org/ntsb/LAX86FJA06.md): Bell 206B · Maui, HI · Accident · 2 fatal · Final report · May 18, 1986 · N244WC · Destroyed > The acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was… - [NTSB ANC86LA058](https://openairdocs.org/ntsb/ANC86LA058.md): Hiller 12-C · Palmer, AK · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N49983 · Substantial damage > The pilot stated that he drew too much rotor pitch for the h.p. available. The helicopter lost control and rolled over on its side. - [NTSB SEA86FA126](https://openairdocs.org/ntsb/SEA86FA126.md): Lake LA-4-250 · Blue River, OR · Accident · 4 fatal · Field investigation · Final report · May 17, 1986 · N1403A · Destroyed > Several witnesses reported seeing the acft flying near the eugene arpt at an alt of 400 to 500 ft AGL. The acft was heading toward the Blue River. The acft was then seen flying over the Blue River forest ranger station aprx 7 minutes prior to the accident. At… - [NTSB LAX86LA225](https://openairdocs.org/ntsb/LAX86LA225.md): Cessna 150D · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N6013T · Substantial damage > The acft collided with a 60 foot tall pine tree while maneuvering over a residential area. The pilot indicated that he was heading west at 750 feet above the ground with 30 degrees of flaps at approximately 60 mph airspeed with fifty percent power applied. He… - [NTSB ATL86LA130](https://openairdocs.org/ntsb/ATL86LA130.md): Cessna 150M · Littleton, NC · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N328M · Substantial damage > PIC made low pass to let friend know he would land at airport for prearranged meeting. PIC reported he was low and slow. When go-around was attempted acft controls were mushy and acft would not climb. Later pilot commented he thought he was on the backside of… - [NTSB ATL86FA133](https://openairdocs.org/ntsb/ATL86FA133.md): Cessna 172 · Douglasville, GA · Accident · 1 fatal · Field investigation · Final report · May 17, 1986 · N6839A · Destroyed > The acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness… - [NTSB DEN86FTK01](https://openairdocs.org/ntsb/DEN86FTK01.md): Bellanca 7GCBC · Huron, SD · Accident · Serious injuries · Final report · May 16, 1986 · N53756 · Substantial damage > The acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred. - [NTSB MKC86LA109](https://openairdocs.org/ntsb/MKC86LA109.md): Aero Commander S2R · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N5648X · Destroyed > During an agricultural spray maneuver back to a field the PIC was fertilizing, the PIC stated he allowed the acft to become too slow and the aircraft descended into trees which bordered the field. The PIC stated he should have been flying with a lighter load… - [NTSB MKC86LA108](https://openairdocs.org/ntsb/MKC86LA108.md): Grumman G-164A · Tekamah, NE · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N6630 · Substantial damage > The pilot stated that as he was finishing his run spraying pine trees and was pulling up when the engine lost power. The right wings struck trees and the aircraft nosed over during the forced landing. - [NTSB CHI86FEE03](https://openairdocs.org/ntsb/CHI86FEE03.md): Beaupre Elfering Quickie · Waukegan, IL · Accident · No injuries · Final report · May 12, 1986 · N134BE · Substantial damage > The acft crash landed in a cultivated part of the arpt after the eng quit during takeoffs & landings. The acft climbed to about 400 ft AGL and started a turn when the eng stopped. The acft was glided to an alfalfa field on the arpt. The acft was damaged… - [NTSB ANC86FA055](https://openairdocs.org/ntsb/ANC86FA055.md): Enstrom F28C · Turnagain, AK · Accident · 1 fatal · Field investigation · Final report · May 12, 1986 · N51726 · Destroyed > The helicopter was observed flying along the highway at a low altitude and it then struck some high power transmission lines, fell to the ground and burned upon impact. The transmission lines were 283 feet above the road surface and spanned a distance of 1127… - [NTSB SEA86LA122](https://openairdocs.org/ntsb/SEA86LA122.md): Cessna 182P · Smiths Ferry, ID · Accident · Serious injuries · Limited investigation · Final report · May 10, 1986 · N91184 · Destroyed > The plt was returning to home base from a business flight on which he delivered parts to company personnel. The acft was observed flying down the north fork of the river at low altitude with its wings dipping. Aprx one mile after entering the canyon, the acft… - [NTSB NYC86FGM02](https://openairdocs.org/ntsb/NYC86FGM02.md): Continental Copters OH13H Tomcat Mark 5A · Indiana, PA · Accident · Minor injuries · Final report · May 10, 1986 · N41830 · Substantial damage > The acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off… - [NTSB BFO86FID08](https://openairdocs.org/ntsb/BFO86FID08.md): Milliken Gyrocopter B-80 · Suffolk, VA · Accident · 1 fatal · Final report · May 10, 1986 · N202M · Destroyed > According to a plt witness the accident plt was attempting to compensate for an increase in wind velocity when the accident occurred. The witness stated the plt entered a steep dive to compensate for the increase lift followed by the gyrocopter ballooning due… - [NTSB ATL86FA126](https://openairdocs.org/ntsb/ATL86FA126.md): Piper PA-28-180 · Ludlow, PA · Accident · 1 fatal · Field investigation · Final report · May 10, 1986 · N999HT · Destroyed > An acft fitting the description of the acdt acft was observed entering the lake arm about 7 1/2 mi n of the acdt site. The acft was observed to pull up to clear pwr lines across the lake arm about 2 1/2 mi n of the acdt site. The acft was observed to fly into… - [NTSB MKC86FPG03](https://openairdocs.org/ntsb/MKC86FPG03.md): Schweizer Grumman G-164B · Harrisburg, AR · Accident · Serious injuries · Final report · May 9, 1986 · N8493K · Destroyed > The plt reported that while spraying a fld with propanil and penoxalin the wind shifted from the southeast to the northeast allowing the chemicals to cover the windshield thus reducing the plt's forward vision. This in combination with sun glare, resulted in… - [NTSB ATL86LMG07](https://openairdocs.org/ntsb/ATL86LMG07.md): Bell UH-1B · Wrightsville, NC · Incident · No injuries · Final report · May 8, 1986 · N158HP · Minor damage > The plt reported that he was about to descend from a high hover to land in an open field adjacent to a hotel parking lot when the tips of both main rotor blades contacted a light pole. The plt maneuvered away from the pole and landed in the open field.… - [NTSB ANC86LA054](https://openairdocs.org/ntsb/ANC86LA054.md): Piper PA-32-300 · Atmautluak, AK · Accident · Minor injuries · Limited investigation · Final report · May 5, 1986 · N4246T · Substantial damage > The air taxi pilot planned six hours of night flying with a five minute fuel reserve at his destination. When he saw that he would be unable to reach the destination, he diverted toward atmautlauk. However, the acft ran out of fuel as the plt was maneuvering… - [NTSB NYC86LA118](https://openairdocs.org/ntsb/NYC86LA118.md): Schweizer SGS 1-26 · Mt. Graylock, MA · Accident · Serious injuries · Limited investigation · Final report · May 4, 1986 · N1140S · Substantial damage > The pilot was practicing simulated cross country passes on a ridge at an altitude of 150 ft AGL on the windward side of a ridge in a Schweizer sgs 1-26 sailplane. The pilot encountered a roll condition from which he lost control, was unable to recover and… - [NTSB MIA86FA142](https://openairdocs.org/ntsb/MIA86FA142.md): Cessna 172N · Starkville, MS · Accident · Serious injuries · Field investigation · Final report · May 3, 1986 · N4838G · Destroyed > Witnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a… - [NTSB MIA86LA141](https://openairdocs.org/ntsb/MIA86LA141.md): Bellanca 7KCAB · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N90985 · Substantial damage > During a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=198 ## 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=197 --- 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.