# 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 215 of 378 · 18,851 cases ## Cases, newest first - [NTSB LAX84FU027](https://openairdocs.org/ntsb/LAX84FU027.md): Mitchell TU-10 · Perris, CA · Accident · 2 fatal · Final report · May 13, 1984 · UNREG · Destroyed > The purpose of the flt was for one instructor plt (CFI) to check out the other CFI in the ultralight vehicle. Reportedly, many witnesses watched as the acft climbed to aprx 3000 ft AGL. The aircrew then performed a series of rolls to the left & right. The… - [NTSB FTW84FA224](https://openairdocs.org/ntsb/FTW84FA224.md): Aeronca 11BC · Hamilton, TX · Accident · Serious injuries · Field investigation · Final report · May 13, 1984 · N4081E · Destroyed > The acft stalled at 1500-2000 ft AGL and collided with a fence and the ground during recovery attempts. The plt said theacft was intentionally stalled but the spin was not expected. The acft was estimated to be aprx 47 lbs over max gross weight. The flt had… - [NTSB MKC84LA136](https://openairdocs.org/ntsb/MKC84LA136.md): Cessna A188B · Lepanto, AR · Accident · Minor injuries · Limited investigation · Final report · May 12, 1984 · N731VM · Substantial damage > The acft lost power during an aerial application flt & crashed during a forced landing. An investigation revealed that the magnetos were not in an airworthy condition at the time of the accident. The acft had been operated 338 hrs since the last 100 hr… - [NTSB NYC84FA170](https://openairdocs.org/ntsb/NYC84FA170.md): I.C.A. Brasov IS-29D2 · Collegeville, PA · Accident · 1 fatal · Field investigation · Final report · May 11, 1984 · N29DT · Destroyed > According to a witness who ran the wing of the glider during takeoff, at 250 to 300 ft AGL the tow acft turned left but the glider maintained rwy heading. Shortly thereafter the tow line released at the glider-end and the glider initiated a right turn. After… - [NTSB MIA84FA166](https://openairdocs.org/ntsb/MIA84FA166.md): Bell UH-1B · Clermont, FL · Accident · 1 fatal · Field investigation · Final report · May 10, 1984 · N2252A · No damage > The plt was not aware that two ground attendants were riding the cable during a logging operation when there was an accidental cable release & the attendants fell to the ground. Examination of the acfts hook did not reveal a system failure or malfunction.… - [NTSB MIA84FA164](https://openairdocs.org/ntsb/MIA84FA164.md): Mooney M-18C · Sugar Loaf Key, FL · Accident · 1 fatal · Field investigation · Final report · May 10, 1984 · N487M · Destroyed > The acft was observed making several passes over a friends house. At the end of the third pass during, a climbing left turn, the right wing separated from the acft. Inspection of the wreckage revealed wood rot in the main wing spar. The last known inspection… - [NTSB LAX84LA294](https://openairdocs.org/ntsb/LAX84LA294.md): Hiller UH-12E (Soloy) · Delano, CA · Accident · Minor injuries · Limited investigation · Final report · May 10, 1984 · N90461 · Substantial damage > The helicopter experienced an inflt failure of an eng mount, pn 63181-5, which bent the collective control rod & forced the the collective pitch into the up position. The helicopter then settled into the grapes it was spraying & made a hard landing. An… - [NTSB FTW84LA228](https://openairdocs.org/ntsb/FTW84LA228.md): Rockwell S-2R · Bay City, TX · Accident · 1 fatal · Limited investigation · Final report · May 10, 1984 · N8481V · Substantial damage > While spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed… - [NTSB FTW84LA225](https://openairdocs.org/ntsb/FTW84LA225.md): Grumman G164A · Fenton, LA · Accident · No injuries · Limited investigation · Final report · May 7, 1984 · N48377 · Destroyed > The acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at… - [NTSB CHI84FA180](https://openairdocs.org/ntsb/CHI84FA180.md): Colonial C-2 · Stone Lake, WI · Accident · 1 fatal · Field investigation · Final report · May 7, 1984 · N281B · Minor damage > The plt had flown to little sissabagama lake where he owned a cabin. A witness had observed the last 3 mins of flt but not the actual impact with the water. The acft was later found inverted in 15 ft of water 300 ft from a shore. Plt was found 150 ft from the… - [NTSB FTW84FA220](https://openairdocs.org/ntsb/FTW84FA220.md): Pitts Special S-1 · La Marque, TX · Accident · 1 fatal · Field investigation · Final report · May 5, 1984 · N31DF · Destroyed > The plt was scheduled to perform aerobatics in an air show. While maneuvering at about 300 ft AGL, the acft entered a nose high, steep left turn, stalled, then entered a 2 turn spin to the left. The plt recovered in a nose low, wings level attitude, but the… - [NTSB CHI84LA177](https://openairdocs.org/ntsb/CHI84LA177.md): Cessna 150H · Boyd, MN · Accident · Minor injuries · Limited investigation · Final report · May 5, 1984 · N50022 · Destroyed > The acft was circling a field at about 400 to 500 ft AGL in at least a 40 degree bank when it stalled. The pilot added power and lowered the nose, as the acft was recovering from the stall it impacted the ground and nosed over. - [NTSB ATL84LA163](https://openairdocs.org/ntsb/ATL84LA163.md): Piper PA-25-235 · Jesup, GA · Accident · Minor injuries · Limited investigation · Final report · May 5, 1984 · N90856 · Destroyed > The plt reported he was spraying water and at the end of a swath run when he turned off the spray and pulled up, the engine lost power. The acft collided with trees during the forced landing. No mechanical discrepencies or malfuntions were found after the… - [NTSB FTW84LA222](https://openairdocs.org/ntsb/FTW84LA222.md): Beech A36TC · Marble Falls, TX · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N321TJ · Destroyed > During arrival, the plt descended from 10,500 ft to 2300 ft, then circled a house 3 times before turning toward the arpt. As he rolled the wings level & was preparing to call the arpt, the eng lost power. He was unable to start the eng, so he elected to make… - [NTSB FTW84LA219](https://openairdocs.org/ntsb/FTW84LA219.md): Cessna 180B · Galveston, TX · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N5190E · Destroyed > The a/c was being flown at about 300 ft over the bay and the pilot and passenger were looking for fish. When the pilot made a turn to fly in a downwind direction the aircraft started to stall. The pilot stated that he advanced the throttle but the engine did… - [NTSB NYC84FA157](https://openairdocs.org/ntsb/NYC84FA157.md): Cessna A152 · Bethlehem, PA · Accident · 1 fatal · Field investigation · Final report · May 2, 1984 · N8135L · Destroyed > The acft crashed while spinning from low alt. The acft was observed by witnesses doing aerobatics at low alt. At the topof loop or vertical climb the acft did a hammerhead stall under power and went into a spin. It appeared to one witness as if the plt was… - [NTSB LAX84LA278](https://openairdocs.org/ntsb/LAX84LA278.md): Christen Eagle Stallins 195 · Knights Landing, CA · Accident · Minor injuries · Limited investigation · Final report · May 2, 1984 · N195RS · Substantial damage > The acft crashed during a series of aerobatic practice maneuvers. The plt reported that during the positive and negative'g' maneuvers he 'apparently passed out.' - [NTSB DEN84FA142](https://openairdocs.org/ntsb/DEN84FA142.md): Hughes 369D · Meeker, CO · Accident · Serious injuries · Field investigation · Final report · May 2, 1984 · N1090A · Substantial damage > During slow (35-40 KTS) cruise flt at about 50 ft AGL in mountainous terrain for wildlife survey, pwr loss occurred. Auto systems briefly restored pwr, followed by a ttl loss. Plt executed emergency autorotation into trees on sloping terrain. Investigation… - [NTSB MIA84LA158](https://openairdocs.org/ntsb/MIA84LA158.md): Boeing A75L300 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · May 1, 1984 · N65676 · Substantial damage > The acft lost power while the plt was towing a banner over water. He was unable to restart the eng & subsequesntly ditched the acft in the ocean near Daytona Beach, FL. The plt elected to keep the banner attached to the acft to keep the plane from flipping… - [NTSB LAX84LA273](https://openairdocs.org/ntsb/LAX84LA273.md): Bell UH-1B · Salinas, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1984 · N57HP · Destroyed > While spraying a field of artichokes, the plt had made 1 pass southbound & started another northbound. He began the swath run by descending over power lines, then tried to climb & clear rising terrain beyond the lines. However, the helicopter continued… - [NTSB SEA84LA097](https://openairdocs.org/ntsb/SEA84LA097.md): Grumman G-164A · Hermiston, OR · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N4897 · Substantial damage > During a beginning swath run, the plt was making a left skidding turn to follow the edge of a circular field. He stated that the acft encountered a downdraft which raised the right wing. Subsequently, the left wing contacted the ground & the acft crashed. - [NTSB MKC84FU002](https://openairdocs.org/ntsb/MKC84FU002.md): Rally Rotec 2B · Carroll, IA · Accident · Serious injuries · Final report · Apr 28, 1984 · UNREG · Substantial damage > The ultralight was seen maneuvering at low alt in the vicinity of the accident. The plt circled his brother's house at low alt and then pulled up abruptly to avoid rising terrain. In the abrupt maneuver, the plt lost control of the ultralight and impacted the… - [NTSB MIA84FA156](https://openairdocs.org/ntsb/MIA84FA156.md): Murphy-Charles PJ-1 (Adventure) · Merritt Island, FL · Accident · Serious injuries · Field investigation · Final report · Apr 28, 1984 · N1181D · Destroyed > While the plt was maneuvering on final approach to land on rwy 11, the eng lost power. Subsequently, the acft crash landed in the backyard of a residence. The plt received serious injuries & could not recall details of the accident. No preimpact part failure… - [NTSB MKC84LA128](https://openairdocs.org/ntsb/MKC84LA128.md): Hiller UH-12E · Pocahontas, AR · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N9740C · Destroyed > The acft crashed after an engine failure during a swath run at an alt of 20 ft AGL. Examination of the engine revealed 3 dowel pins and 6 screws which hold the starter drive gear and the accessory drive gear had sheared. Metallurgical exam revealed that dowel… - [NTSB SEA84LA093](https://openairdocs.org/ntsb/SEA84LA093.md): Piper PA-25-235D · Heppner, OR · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N9866P · Destroyed > The plt reported that he was making a turn below the lee side of a ridge line at an alt of about 30 ft AGL. The acft reportedly encountered a downdraft & settled into the ground. During this occurrence, the landing gear collapsed, but no other major damage… - [NTSB LAX84FU026](https://openairdocs.org/ntsb/LAX84FU026.md): Teratorn Tierra II · Chico, CA · Accident · 1 fatal · Final report · Apr 22, 1984 · UNREG · Destroyed > The ultralight was being test flown after alterations to the acft & its flight control system. The plt put the acft through some maneuvers and during one of them, described by witnesses as a chandelle, the acft nosed down & crashed intothe ground. The acft… - [NTSB FTW84LA208](https://openairdocs.org/ntsb/FTW84LA208.md): Cessna 172N · Mullin, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1984 · N5454J · Destroyed > The acft was observed by witnesses to have been flying very low, paralleling highway 84. A set of railroad tracks parallel the highway. Between the rr tracks and hwy is a power line. The witnesses saw the left wing contact the pwr line and the acft roll to… - [NTSB FTW84FA206](https://openairdocs.org/ntsb/FTW84FA206.md): North American AT-6D · Cypress, TX · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1984 · N10605 · Destroyed > The acft crashed while spinning after only a few minutes flt. The acft had just been flown by another plt for aprx 20 minutes just prior to the accident flt. This plt/owner said the acft operated in a trouble free manner. During the accident flt the plt made… - [NTSB CHI84LA157](https://openairdocs.org/ntsb/CHI84LA157.md): Piper PA-25-235 · Morrow, OH · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N6733Z · Substantial damage > About 10 min. After takeoff on an aerial application flt the acft's eng lost pwr. The plt made a forced landing in a corn field & during rollout collided with a tree. According to the plt, the acft's eng blew its right rear cylinder because its hold down… - [NTSB MIA84LA142](https://openairdocs.org/ntsb/MIA84LA142.md): Gulfstream-Schweizer G-164B · Arecibo, PR · Accident · No injuries · Limited investigation · Final report · Apr 17, 1984 · N8232K · Substantial damage > During a swath run over a rice field, the plt noted a partial loss of power & a rapid deceleration of the acft. As he looked in the cockpit momentarily, the acft settled & the main gear hit a levi & separated. The plt then pulled up, turned to the left & made… - [NTSB LAX84FA256](https://openairdocs.org/ntsb/LAX84FA256.md): Cessna L-19E · Ontario, CA · Accident · No injuries · Field investigation · Final report · Apr 16, 1984 · N4431D · Destroyed > The plt stated that during descent he used 'left wing down, nose yawed right, slipping.' The fuel selector was positioned to the left fuel tank. A thousand flt slip the acft engine lost power. During the emergency corrective actionthe plt did not use the… - [NTSB MIA84FA139](https://openairdocs.org/ntsb/MIA84FA139.md): Rockwell 114A · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Apr 14, 1984 · N5942N · Destroyed > The acft took off from rwy 27. Several witnesses stated the acft appeared unusually slow during the initial climb. The plt reported to the tower he had a problem & was going to 'come around.' The acft entered a right turn and appeared to stop climbing at 200… - [NTSB LAX84FA255](https://openairdocs.org/ntsb/LAX84FA255.md): Folke Wulf 1903A · Livermore, CA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1984 · N190W · Destroyed > The acft crashed after stalling during the initial climb after takeoff. The plt had called on the radio to say he was 'going to come back around.' When asked by the tower if he wwas declaring an emergency he did not answer. The acft reportedly was making a… - [NTSB LAX84LA254](https://openairdocs.org/ntsb/LAX84LA254.md): Boeing A75N1 · Scaggs Island, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 1984 · N3387 · Substantial damage > During a local flt, the acft crashed on the side of a levee while maneuvering. Both plts were seriously injured & neither of them could recall details of the flt. An exam of the crash site revealed the plane was traveling nearly parallel with the levee when… - [NTSB MIA84LA134](https://openairdocs.org/ntsb/MIA84LA134.md): Bell 47D1 · Berlin, GA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1984 · N586T · Destroyed > The plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report. - [NTSB MIA84FU004](https://openairdocs.org/ntsb/MIA84FU004.md): Unknown Easy Riser · Snead, FL · Accident · Serious injuries · Final report · Apr 12, 1984 · UNREG · Substantial damage > The ultralight collided with a high tension wire and crashed. The plt said he made a low pass to look at an auto and didnot see the wire in time to avoid the collision. - [NTSB FTW84LA195](https://openairdocs.org/ntsb/FTW84LA195.md): Cessna 150 · Papalote, TX · Accident · No injuries · Limited investigation · Final report · Apr 11, 1984 · N19557 · Substantial damage > The acft collided with a powerline while making a low pass over a local residence during a solo training flt. The plts recommendation for prevention is to 'use common sense.' - [NTSB FTW84LA194](https://openairdocs.org/ntsb/FTW84LA194.md): Grumman G-164A · Beaumont, TX · Accident · No injuries · Limited investigation · Final report · Apr 11, 1984 · N9978 · Destroyed > The acft stalled during a turn around between swath runs. The pilot stated that he was unable to recover because there was not sufficient alt. - [NTSB CHI84LA152](https://openairdocs.org/ntsb/CHI84LA152.md): Piper PA-28-161 · Hoffman Estates, IL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1984 · N8400B · Substantial damage > The acft nosed over in a plowed field after the plt made an off-arpt landing. The plt said he was practicing turns around a point when he noticed a loss of alt and a sputtering of the engine. Since he was low he decided to land. (Therewas a sod strip 1/2 mile… - [NTSB FTW84LA192](https://openairdocs.org/ntsb/FTW84LA192.md): Rockwell A-9B · Lamont, OK · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N7776V · Substantial damage > The plt reported that between swath runs, his attention was directed to swath marks on the ground, then he tried to determine how much chemical was remaining in the hopper. At about 100 ft AGL, while in a 50 deg left bank, he heard 'the eng slow down' & felt… - [NTSB ATL84LA138](https://openairdocs.org/ntsb/ATL84LA138.md): Robinson R22A · Woodbridge, VA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1984 · N8415X · Substantial damage > The CFI stated that while hovering with a prospective student pilot using the cyclic control, the student pushed rapidlyforward on the cyclic control. The instructor pilot (CFI) attempted to regain control but the acft struck a tree and crashed. - [NTSB MIA84LA127](https://openairdocs.org/ntsb/MIA84LA127.md): Bucker Flugzeugbau Jungmann · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Apr 2, 1984 · N1947G · 2 aircraft · Minor damage > The plts of a Bucker jungmann, N1947G, & a pitts S-2B, N5302M, were practicing for an airshow. They began a maneuver called a 'mirror fly-by' in which the Bucker was rolled upside down & the pitts was flown underneath it. Due to the air flow over the wings… - [NTSB DEN84LA120](https://openairdocs.org/ntsb/DEN84LA120.md): Gulfstream 500 Commander · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 1984 · N3274Q · Substantial damage > A non-rated person stole the aerocommander, added 10 gallons of fuel to the empty tanks took off and both engines failed. The acft landed on hwy 85, the gear collapsed on landing and the acft came to rest in a ditch. Post accident investigation revealed only… - [NTSB ANC84LA049](https://openairdocs.org/ntsb/ANC84LA049.md): Cessna 206 · Mcgrath, AK · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1984 · N756XB · Destroyed > According to the plt, he flew over a frozen lake, then encountered reduced visibility down to about 1/8 mi. He made a 180 deg turn, but lost all referecne to the terrain during the turn. Shortly after completing the turn, he was proceeding eastbound & was… - [NTSB CHI84FA142](https://openairdocs.org/ntsb/CHI84FA142.md): Cessna 175 · Portage, MI · Accident · 3 fatal · Field investigation · Final report · Mar 27, 1984 · N6733E · Destroyed > During a return flt to traverse city, MI, the acft was observed flying at 'tree top' & 'roof height'. In the vicinity of the crash site, the acft was observed maneuvering. It entered a dive a tree top level, then made a sweeping 270 deg turn to about 500 ft… - [NTSB CHI84LU002](https://openairdocs.org/ntsb/CHI84LU002.md): Birdman Enterprises Chinook · Mecosta, MI · Accident · Serious injuries · Final report · Mar 26, 1984 · UNREG · Substantial damage > The acft stalled during a forced landing and the right wing struck the ground. The plt stated that on his first takeoff full power was not obtained and a turn of 180 degrees was initiated to return to the airstrip. The engine failed completely on downwind and… - [NTSB NYC84FA118](https://openairdocs.org/ntsb/NYC84FA118.md): Bellanca 7KCAB · E. Hanover, NJ · Accident · 1 fatal · Field investigation · Final report · Mar 25, 1984 · N11678 · Destroyed > The acft was observed as it made a low pass over the end of the rwy, then pull up in a roll and/or vertical maneuver. One witness said that on the downward side of the maneuver, the acft appeared to stall or shudder. Before recovering, the acft impacted in a… - [NTSB LAX84FA227](https://openairdocs.org/ntsb/LAX84FA227.md): Aero Commander A-98 · Woodbridge, CA · Accident · Serious injuries · Field investigation · Final report · Mar 23, 1984 · N7643V · Destroyed > The plt said the acft stalled as he was performing a left climbing turn during aerial application. The acft spun down hitting some oak tree limbs on its way to the ground. The plt had applied all but 200 lbs of his 1450 pounds of ammoniumsulfate. - [NTSB NYC84FA114](https://openairdocs.org/ntsb/NYC84FA114.md): Piper PA-31-350 · Oneonta, NY · Accident · 5 fatal · Field investigation · Final report · Mar 22, 1984 · N27886 · Destroyed > The acft crashed in a wooded area after the loss of eng power. The wx was VMC. The plt made a missed approach after trying to land on rwy at Oneonta, at 1838 hrs. Later the plt radioed that he was unable to 'pick up' the kring beacon. Boston center vectored… - [NTSB CHI84LA133](https://openairdocs.org/ntsb/CHI84LA133.md): Piper PA-32-260 · St. Ignace, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1984 · N4343X · Substantial damage > The pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=216 ## 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=215 --- 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.