# 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 196 of 378 · 18,851 cases ## Cases, newest first - [NTSB MIA86FA199](https://openairdocs.org/ntsb/MIA86FA199.md): Robinson R22 · Islamorada, FL · Accident · Serious injuries · Field investigation · Final report · Jul 4, 1986 · N2385X · Destroyed > Witnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling. - [NTSB DEN86LA188](https://openairdocs.org/ntsb/DEN86LA188.md): Piper J-3 · Ashland, MT · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N40660 · Substantial damage > Plt did not possess a plt certificate or medical certificate. The plt stated that he fueled the acft with the 'last gas in the storage tank.' The plt preflighted the acft and took off. Shortly after takeoff the engine lost power. The plt executed a landing in… - [NTSB CHI86FEX09](https://openairdocs.org/ntsb/CHI86FEX09.md): Cessna 150F · Marion, IN · Accident · Serious injuries · Final report · Jul 4, 1986 · N8602G · Destroyed > The plt rprtd that while circling around farm fields, he entered a turn & was looking behind the acft when it entered a power-on stall, then began to spin. Rprtdly, the acft was in a nose high attitude when it stalled. The plt stopped the rotation & was… - [NTSB CHI86FEM10](https://openairdocs.org/ntsb/CHI86FEM10.md): Piper PA-25-235 · Ionia, MI · Accident · Minor injuries · Final report · Jul 4, 1986 · N4811Y · Substantial damage > During initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially… - [NTSB ANC86LA100](https://openairdocs.org/ntsb/ANC86LA100.md): Piper PA-18 · Sparrovahn, AK · Accident · No injuries · Limited investigation · Final report · Jul 3, 1986 · N5472H · Substantial damage > The plt reported a total loss of pwr occurred while maneuvering over an area to observe the terrain. A forced landing was made on a gravel bar during which the acft nosed over. In his recommendation on how the accident could have been prevented, the plt… - [NTSB DEN86LA182](https://openairdocs.org/ntsb/DEN86LA182.md): Piper PA-25-235 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N7131Z · Substantial damage > During the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made. - [NTSB SEA86LA161](https://openairdocs.org/ntsb/SEA86LA161.md): Cessna T-188-C · Othello, WA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1986 · N9574J · Destroyed > An engine failure for unknown reasons occurred during an aerial application maneuver. A forced landing was accomplished onto very rough, rocky terrain where the aircraft was destroyed during the landing sequence. - [NTSB SEA86LA159](https://openairdocs.org/ntsb/SEA86LA159.md): Piper PA-25-260 · Rexburg, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1986 · N9621P · Destroyed > During an aerial application turn the aircraft encountered a severe downdraft. Although the pilot lowered the nose of the aircraft, leveled the wings, added full power and dumped his chemical load, he was unable to climb. The aircraft then struck the ground… - [NTSB SEA86LA158](https://openairdocs.org/ntsb/SEA86LA158.md): Ayres S2RT34 · Jordan Valley, OR · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 1986 · N4013D · Destroyed > Witnesses observed at acft make a 2-5 foot pass over water going north, a 180 degree turn and a 2 foot AGL run to south. The acfts left main landing gear touched water bouncing the right wing on water. Acft pitched up, rolled inverted and crashed on south… - [NTSB NYC86FHA03](https://openairdocs.org/ntsb/NYC86FHA03.md): Thomas Pitts S-1T · Avoca, PA · Accident · No injuries · Final report · Jun 28, 1986 · N83TJ · Substantial damage > During a ribbon cutting ceremony at the wilkes-barre/scranton air show, the acft had a temporary engine failure while inverted 20 feet above the terrain. The acft impacted on the rwy, slid 500 feet inverted, turned over and stopped upright. - [NTSB SEA86LA154](https://openairdocs.org/ntsb/SEA86LA154.md): Cessna A188B · Boise, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 1986 · N9779G · Destroyed > The purpose of the flight was to spray thirty gallons of rinse water to clear the spray tanks of chemical. While maneuvering the acft struck power lines and then struck the ground. The acft slid for about 20 feet and then nosed over inverted. - [NTSB FTW86LRG27](https://openairdocs.org/ntsb/FTW86LRG27.md): Ayres S2R-600 · Tivoli, TX · Accident · No injuries · Final report · Jun 27, 1986 · N8905Q · Substantial damage > On June 27,1987 at approximately 1700 CDT, an Ayres S2R-600 impacted the terrain approximately 5 miles east of Tivoli, TX while conducting agriculture spraying operations. The right wing of the aircraft contacted the ground causing the aircraft to cartwheel… - [NTSB DEN86LA176](https://openairdocs.org/ntsb/DEN86LA176.md): Cessna T188 · Kimball, SD · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N2507J · Substantial damage > According to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged. - [NTSB SEA86LA153](https://openairdocs.org/ntsb/SEA86LA153.md): Piper PA-25-235 · Pullman, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1986 · N6490Z · Destroyed > After takeoff during a 180 degree turn the aircraft developed a rapid rate of sink which the pilot was unable to arrest. While attempting to dump 140 pounds of water, the aircraft struck power lines and then struck the ground inverted. The aircraft was then… - [NTSB MKC86LA134](https://openairdocs.org/ntsb/MKC86LA134.md): Grumman G-164B · Wellman, IA · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1986 · N48532 · Substantial damage > The PIC stated that during the last 3rd of his procedure turnaround the acft descended to just below the powerlines at the edge of the field he was spraying. The acft struck the powerlines with the main landing gear which nosed the acft over. Full power was… - [NTSB MIA86FLT01](https://openairdocs.org/ntsb/MIA86FLT01.md): Amateur Built Eenie TWO · Waynesboro, MS · Accident · Serious injuries · Final report · Jun 26, 1986 · N6009 · Substantial damage > The acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not… - [NTSB DEN86LA174](https://openairdocs.org/ntsb/DEN86LA174.md): Schweizer G-164A · La Moure, ND · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N6838Q · Substantial damage > According to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground. - [NTSB FTW86LRD20](https://openairdocs.org/ntsb/FTW86LRD20.md): Piper PA-25-235 · Marksville, LA · Accident · Serious injuries · Final report · Jun 23, 1986 · N7321Z · Substantial damage > The pilot delayed in his pullup from a spray swath run until there was insufficient time and distance to clear the line of trees at the end of the field. Airspeed decreased rapidly during the pullup. Tree impact occurred and the pilot was unable to recover… - [NTSB FTW86FPA23](https://openairdocs.org/ntsb/FTW86FPA23.md): Cessna A188B · Malone, TX · Accident · 1 fatal · Final report · Jun 23, 1986 · N9737J · Destroyed > The acft crashed before beginning a spraying operation after making a low pass over the field to alert a workman. According to one witness, a young bicyclist, the acft was turning around and began 'flopping' before it disappeared behind a hill. The field… - [NTSB CHI86FET02](https://openairdocs.org/ntsb/CHI86FET02.md): Piper PA-28-180 · Syracuse, IN · Accident · 1 fatal · Final report · Jun 23, 1986 · N8226W · Destroyed > The acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent… - [NTSB NYC86FNC04](https://openairdocs.org/ntsb/NYC86FNC04.md): Rolladen-Schneider LS-4A · Rochester, VT · Accident · 1 fatal · Final report · Jun 22, 1986 · N430RH · Substantial damage > The pilot was participating in a x-country soaring race. Aprox 15 miles from destination and for unknown reasons, the pilot experienced in flight collision with terrain. There was no evidence of pre-impact malfunction or failure. The pilot was certificated… - [NTSB DEN86LA171](https://openairdocs.org/ntsb/DEN86LA171.md): Piper PA-25-235 · Cope, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1986 · N7723Z · Substantial damage > The plt reports that the eng quit during a pull-up at the end of a swath run. A forced landing in a field straight ahead was attempted but the field had been cultivated recently and was soft. After a short ground roll the gear dug in and the acft nosed over.… - [NTSB LAX86FA260](https://openairdocs.org/ntsb/LAX86FA260.md): Cessna 152 · Marysville, CA · Accident · 2 fatal · Field investigation · Final report · Jun 21, 1986 · N4873H · Destroyed > At 0203 PDT, there was an electrical power outage when a Cessna 152, N4873H, collided with a power line that crossed the feather river near Marysville, CA. The acdnt occurred as a student plt was flying over the river at low alt with a passenger aboard at… - [NTSB ATL86FA178](https://openairdocs.org/ntsb/ATL86FA178.md): Cessna 120 · Marlton, NJ · Accident · 2 fatal · Field investigation · Final report · Jun 21, 1986 · N89789 · Destroyed > About 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver… - [NTSB DEN86LA167](https://openairdocs.org/ntsb/DEN86LA167.md): Piper PA-25-235 · South Heart, ND · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N8768L · Substantial damage > According to the plt, during a swath run (agricultural spraying), the eng quit & a forced landing was accomplished. During the interview, the plt stated the eng quit due to fuel exhaustion. - [NTSB CHI86FEM09](https://openairdocs.org/ntsb/CHI86FEM09.md): Cessna 172I · Nunica, MI · Accident · 2 fatal · Final report · Jun 20, 1986 · N46074 · Destroyed > The acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike. - [NTSB MKC86FCJ02](https://openairdocs.org/ntsb/MKC86FCJ02.md): Cessna A188B · Bridgeport, NE · Accident · 1 fatal · Final report · Jun 19, 1986 · N84729 · Destroyed > During an agricultural spray run, the aircraft collided with a utility pole, leaving part of the spary boom wrapped around the pole, and pieces of flap, wing, and fuel bladder nearby. The aircraft then impacted the ground about 1000 ft from the pole & was… - [NTSB MIA86FA185](https://openairdocs.org/ntsb/MIA86FA185.md): Ayres S2R-1820 · Dundee, MS · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1986 · N4023P · Destroyed > The ag acft was flying low over a water covered muddy rice field when the eng stopped running. The plt then jettisoned the load of fertilizer & entered a steep right turn. Subsequently, the aircraft struck the ground on the right wing & nose, then… - [NTSB DEN86LA164](https://openairdocs.org/ntsb/DEN86LA164.md): Piper PA-25-260 · Toston, MT · Accident · No injuries · Limited investigation · Final report · Jun 18, 1986 · N82539 · Substantial damage > The plt reports that he took off from an ag strip about a mile from the fld being treated and was making a turn-around after his second swath run when the acft began to settle. He dumped his chem but the acft continued to settle and impacted the ground. The… - [NTSB DEN86FA165](https://openairdocs.org/ntsb/DEN86FA165.md): Beech A36 · Mosquero, NM · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1986 · N333RS · Destroyed > The acft was observed flying at low altitude when it pitched up at a steep angle, climbed about 400 ft, rolled off on left wing, descended into the ground, exploded and burned. Post accident exam revealed the landing gear was retracted but the flaps were… - [NTSB DCA86AA028](https://openairdocs.org/ntsb/DCA86AA028.md): de Havilland DHC-6-300 · Grand Canyon, AZ · Accident · 25 fatal · Final report · Jun 18, 1986 · N76GC · 2 aircraft · Destroyed > At about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the… - [NTSB FTW86LA111](https://openairdocs.org/ntsb/FTW86LA111.md): Ayres S-2R · Liverpool, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 1986 · N8935Q · Substantial damage > The pilot was involved in a aerial application flt when the acft stalled during a turn. The pilot stated he had too much weight to execute the turn at the airspeed selected. The airspeed was aprx 10 KTS above stall speed at the time of the downwind turn. He… - [NTSB CHI86FER11](https://openairdocs.org/ntsb/CHI86FER11.md): Bell 47G-5 · Brooten, MN · Accident · Serious injuries · Final report · Jun 17, 1986 · N8122J · Destroyed > According to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective… - [NTSB ANC86FA078](https://openairdocs.org/ntsb/ANC86FA078.md): Cessna 207A · Saint Marys, AK · Accident · 1 fatal · Field investigation · Final report · Jun 17, 1986 · N9699M · Destroyed > The pilot stalled the airplane while making a steep turn to avoid high voltage power lines. The airplane caught fire on impact and the air taxi pilot subsequently died of extensive thermal injuries. The plt was flying in formation with another acft at low… - [NTSB MIA86MA182](https://openairdocs.org/ntsb/MIA86MA182.md): Hughes 369HE · Jacksonville, FL · Accident · 2 fatal · Major investigation · Final report · Jun 16, 1986 · N9045F · Destroyed > A LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft… - [NTSB LAX86FUG03](https://openairdocs.org/ntsb/LAX86FUG03.md): Bensen-Jansen B-8M · Adelanto, CA · Accident · 1 fatal · Final report · Jun 16, 1986 · N2522 · Destroyed > The acft collided with power lines crossing the airstrip at midfield and crashed on the rwy. A witness stated that the plt had been briefed on the pwr lines prior to the flt. - [NTSB MIA86FA181](https://openairdocs.org/ntsb/MIA86FA181.md): Robinson R22 HP · Lk Buena Vista, FL · Accident · 1 fatal · Field investigation · Final report · Jun 14, 1986 · N8400C · Destroyed > Motorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue… - [NTSB CHI86FEM07](https://openairdocs.org/ntsb/CHI86FEM07.md): Cessna 188B · Bay City, MI · Accident · No injuries · Final report · Jun 14, 1986 · N53140 · Destroyed > During an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly… - [NTSB SEA86LA146](https://openairdocs.org/ntsb/SEA86LA146.md): Piper PA-36-300 · Moore, ID · Accident · No injuries · Limited investigation · Final report · Jun 13, 1986 · N3742E · Destroyed > During an aerial application turn a rapid rate of descent developed. The pilot released the chemical load at about 100 feet AGL and the aircraft continued to descend to the ground even though the pilot leveled the wings and initially lowered the nose. The… - [NTSB CHI86LA153](https://openairdocs.org/ntsb/CHI86LA153.md): Piper PA-36-375 · Breckenridge, MN · Accident · No injuries · Limited investigation · Final report · Jun 13, 1986 · N6184A · Substantial damage > Aircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision. - [NTSB SEA86FA144](https://openairdocs.org/ntsb/SEA86FA144.md): Sanders Starduster TWO · Mead, WA · Accident · 2 fatal · Field investigation · Final report · Jun 12, 1986 · N118JB · Destroyed > A witness reported seeing the aircraft perform a series of loop maneuvers. At the top of the last loop, the acft rolled upright then rolled into a near vertical right spin which continued to ground impact. The pilot had no history ofspin recovery practice in… - [NTSB DEN86LA162](https://openairdocs.org/ntsb/DEN86LA162.md): Grumman G-164 · Wessington, SD · Accident · No injuries · Limited investigation · Final report · Jun 12, 1986 · N751Y · Substantial damage > According to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground. - [NTSB MIA86LA175](https://openairdocs.org/ntsb/MIA86LA175.md): Ayres S2R · Graceville, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1986 · N5630X · Destroyed > A witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he… - [NTSB CHI86LA149](https://openairdocs.org/ntsb/CHI86LA149.md): Piper J3 · Brodhead, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1986 · N98739 · Substantial damage > The plt was making a low pass over a friend's house. He was waving to the people on the ground and when he looked up he was too close to a tree to avoid hitting it. The plane then descended to the ground. - [NTSB NYC86LA150](https://openairdocs.org/ntsb/NYC86LA150.md): Aerosport Scamp · Columbia, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 1986 · N1031M · Substantial damage > The aircraft crashed shortly after takeoff due to insufficient airspeed and altitude gain. - [NTSB FTW86FPJ08](https://openairdocs.org/ntsb/FTW86FPJ08.md): Air Tractor AT-301 · Blackwell, OK · Accident · Serious injuries · Final report · Jun 7, 1986 · N23539 · Destroyed > The acft crashed after a turn while spraying a field. The acft caught fire after the impact but the plt escaped. - [NTSB DEN86LA157](https://openairdocs.org/ntsb/DEN86LA157.md): Piper PA-25 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Jun 7, 1986 · N6190Z · Substantial damage > Plt stated that he was unfamiliar with the geographical area on this flt. He also stated, 'I was paying attention to the pwr lines and road and did not realize the hill out front was as high as it was...I attempted to turn back out, but with downwind it blew… - [NTSB ATL86LA166](https://openairdocs.org/ntsb/ATL86LA166.md): Cessna A188B · Magnolia Spring, AL · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1986 · N9105R · Substantial damage > During a spray run the plt attempted to climb over a tall tree, the acft failed to clear the tree which was contacted with the right wing. The acft then crash landed in a field. The acft was observed to stagger during several turns earlier in the operation.… - [NTSB LAX86LA242](https://openairdocs.org/ntsb/LAX86LA242.md): Hiller UH-12E · Thermal, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 1986 · N8503W · Destroyed > The helicopter collided with terrain during a maneuvering turn while applying a pesticide to a cultivated field. The acft was seen on the pass just prior to the accident and the acft appeared to be lower than usual. The acft was destroyed by post-impact fire. - [NTSB FTW86FRG25](https://openairdocs.org/ntsb/FTW86FRG25.md): Aero Commander S2R · La Feria, TX · Accident · 1 fatal · Final report · Jun 5, 1986 · N8813Q · Destroyed > The acft contacted guy wires which supported a 1000 ft high television tower. Impact with the wires occurred at an alt of aprx 300 ft. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=197 ## 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=196 --- 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.