# NTSB investigations: Landing 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 450 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB FTW84LA117](https://openairdocs.org/ntsb/FTW84LA117.md): Cessna 120 · Jayton, TX · Accident · No injuries · Limited investigation · Final report · Jan 12, 1984 · N3014N · Substantial damage > The acft nosed over during landing. The plt said he was trying to correct a veer in the tail wheel acft and may have inadvertantly used the right brake. - [NTSB LAX84LA139](https://openairdocs.org/ntsb/LAX84LA139.md): Great Lakes 2T-1A-2 · Montague, CA · Accident · No injuries · Limited investigation · Final report · Jan 11, 1984 · N35131 · Substantial damage > The acft veered off the rwy and nosed over during landing. The plt acknowledged that there was no wind and the acft was 'flying ok.' He said he just lost control and ground looped. - [NTSB FTW84LA112](https://openairdocs.org/ntsb/FTW84LA112.md): Beech 65-90 · Okemah, OK · Accident · No injuries · Limited investigation · Final report · Jan 10, 1984 · N85NL · Substantial damage > The plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy. - [NTSB DEN84LA072](https://openairdocs.org/ntsb/DEN84LA072.md): Bellanca 17-30A · Angel Fire, NM · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1984 · N93656 · Substantial damage > After making a x-country flt from Oklahoma city, ok to Angel Fire, NM, the plt landed on a snow covered rwy at an elevation of 8382 ft. during the landing, the acft bounced, drifted to the left side of the rwy, then hit a 3-1/2 ft snowbank. The plt reported… - [NTSB DEN84LA068](https://openairdocs.org/ntsb/DEN84LA068.md): Cessna 172 · Custer, SD · Accident · No injuries · Limited investigation · Final report · Jan 9, 1984 · N64253 · Substantial damage > The acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy. - [NTSB MKC84LA059](https://openairdocs.org/ntsb/MKC84LA059.md): Cessna 172M · Elkader, IA · Accident · No injuries · Limited investigation · Final report · Jan 8, 1984 · N73043 · Substantial damage > The acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow… - [NTSB SEA84IA037](https://openairdocs.org/ntsb/SEA84IA037.md): Boeing 727-223 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jan 7, 1984 · N876AA · Minor damage > The capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving… - [NTSB FTW84LA110](https://openairdocs.org/ntsb/FTW84LA110.md): Cessna 182 · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · XBCPH · Substantial damage > Xb-cph, a foreign registered acft, was observed by the tower operator, to dive toward the rwy & pull up before starting to porpoise. The acft subsequently impacted the rwy striking the propeller & causing substantial airframe damage. Efforts to locate the plt… - [NTSB CHI84LA080](https://openairdocs.org/ntsb/CHI84LA080.md): Piper PA-28-140 · Waverly, OH · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · N4953F · Substantial damage > While landing on a 2000 ft rwy at Waverly, OH, the brakes were not effective, so the plt elected to go-around. During the go-around, the acft hit a fence at the end of the rwy. The plt continued flt to the ross county arpt & landed. An exam of the brakes… - [NTSB CHI84LA078](https://openairdocs.org/ntsb/CHI84LA078.md): Piper PA-28-140 · Holland, MI · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · N6372W · Substantial damage > The acft contacted a snowbank during landing. After the collision the acft nosed over. The plt stated that the winds forced the acft off the centerline of the rwy into the unplowed area of snow. - [NTSB CHI84LA077](https://openairdocs.org/ntsb/CHI84LA077.md): Cessna 172 · Holland, MI · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · N739BV · Substantial damage > The plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over. - [NTSB ATL84LA079](https://openairdocs.org/ntsb/ATL84LA079.md): Cessna 150G · Charlottesville, VA · Accident · Minor injuries · Limited investigation · Final report · Jan 7, 1984 · N2462J · Substantial damage > The plt reported that he started to lose control during the landing and added power to go-around. He said he pulled backon the controls and inadvertantly raised the flaps after he was already losing altitude. After touchdown, the acft flipped over. - [NTSB FTW84LA108](https://openairdocs.org/ntsb/FTW84LA108.md): Piper PA-28-236 · Del Rio, TX · Accident · No injuries · Limited investigation · Final report · Jan 6, 1984 · N8117Z · Substantial damage > During landing on a 4000 ft sod ranch strip the plt ran off the rwy into a raving and collapsed the landing gear. The plt said he landed in a crab and ran off the rwy. The owner on form 6120.1 stated that it was plt error, that the plt missed the rwy and ran… - [NTSB DEN84LA067](https://openairdocs.org/ntsb/DEN84LA067.md): Cessna 210 · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Jan 6, 1984 · N9654T · Substantial damage > The plt stated he touched down too hard, bounced & that he over-corrected causing the acft to land hard again collapsingthe nose gear. - [NTSB MKC84LA057](https://openairdocs.org/ntsb/MKC84LA057.md): Young-Losey Q-2 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Jan 4, 1984 · N82YL · Substantial damage > The acft collided with a rwy marker after bouncing during a power off landing. The acft was descended from 500 ft power off to a touchdown. The tailwheel acft bounced about 20 ft into the air. The acft went for the rwys edge and slid to a stop in the grass. - [NTSB NYC84FA064](https://openairdocs.org/ntsb/NYC84FA064.md): Canadair CL44D4 · East Boston, MA · Accident · No injuries · Field investigation · Final report · Jan 2, 1984 · N104BB · Substantial damage > The acft landed with the right main landing gear in the retracted position. The crew was unable to lower the right main gear by the normal or emergency methods. Inspection after the accident revealed that the main hydraulic line. Pn 44-75087-98 was broken… - [NTSB CHI84LA074](https://openairdocs.org/ntsb/CHI84LA074.md): Piper PA-18-150 · Sauk Rapids, MN · Accident · No injuries · Limited investigation · Final report · Jan 2, 1984 · N82667 · Substantial damage > The plt stated that while landing on a snow covered field one of the landing skis broke when it struck a dirt mound below the snow. The acft cartwheeled and flipped over. - [NTSB CHI84LA075](https://openairdocs.org/ntsb/CHI84LA075.md): Piper J-4E · White Bear Lake, MN · Accident · No injuries · Limited investigation · Final report · Jan 1, 1984 · N37996 · Substantial damage > The ski-equipped acft suffered landing gear failure during a landing on a snow covered turf rwy. The landing gear separated when an attach point failed. The plt gave fatigue failure as a reason for the failure. - [NTSB DEN84LA058](https://openairdocs.org/ntsb/DEN84LA058.md): Piper PA-32-260 · Ekalaka, MT · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N4830S · Substantial damage > The plt stated that during touchdown the acft hit an area of patchy snow & the acft veered off the rwy into a snowbank. - [NTSB DEN84LA057](https://openairdocs.org/ntsb/DEN84LA057.md): Maule M-5-220C · Holyoke, CO · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N51637 · Substantial damage > The acft ran off the rwy during landing and nosed over. The plt stated that the accident occurred during a landing on rwy 17. The wind was reported as from the southwest at four KTS. The plt stated that the glide path and airspeed were good on final approach.… - [NTSB CHI84LA070](https://openairdocs.org/ntsb/CHI84LA070.md): Piper PA-28-181 · Hebron, OH · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N4506W · Substantial damage > The plt reported that when he landed on an ice covered rwy, he delayed using brakes. When he did use the brakes, he was unable to decelerate sufficiently. He elected not to attempt a go-around, since there were tall trees near the end of the rwy. The acft… - [NTSB DEN84LA056](https://openairdocs.org/ntsb/DEN84LA056.md): Cessna 180 · Florissant, CO · Accident · No injuries · Limited investigation · Final report · Dec 30, 1983 · N3389D · Substantial damage > The acft collided with a snowbank during landing. The rwy had only been plowed to a width of about 16 ft according to the plt. This was a privately owned strip and the plt/owner said he instructed his maintenance man/ranch mgr to plow therwy to minimum width.… - [NTSB DEN84LA055](https://openairdocs.org/ntsb/DEN84LA055.md): Cessna 152 · Hudson, CO · Accident · No injuries · Limited investigation · Final report · Dec 30, 1983 · N49786 · Substantial damage > After returning from a maintenance test flt, the plt made a normal apch to land on a snow covered rwy. According to the plt & his passenger, the acft touched down along the right side of the rwy in snow. The plane then veered to the right & nosed over. No… - [NTSB SEA84LA029](https://openairdocs.org/ntsb/SEA84LA029.md): Piper PA18-A · Rome, OR · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N1829A · Substantial damage > The acft nosed over in the snow during an enroute landing while on a cross country. The plt had landed at this arpt a week before. In the meanwhile there had accumulated 14 inches of snow on the rwy. During the rollout in this snow the acft suddenly stopped… - [NTSB MKC84LA048](https://openairdocs.org/ntsb/MKC84LA048.md): Cessna 402B · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N7947Q · Substantial damage > The acft skidded sideways during landing on an icy rwy. The nose gear collapsed sideways when it collided with a snowbank at the rwys edge. There were no injuries. - [NTSB LAX84LA120](https://openairdocs.org/ntsb/LAX84LA120.md): Bellanca 7ECA · Murrieta, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1983 · N90973 · Substantial damage > The acft nosed over during landing rollout. The plt reported the acft speed on final was 80 mph which is faster than normal. The acft touched down about 900 ft down the 2682 ft rwy. The landing was on rwy 15 and the wind was from 045 degrees at 4 KTS. The plt… - [NTSB LAX84IA119](https://openairdocs.org/ntsb/LAX84IA119.md): Boeing 707-123B · Oakland, CA · Incident · No injuries · Incident investigation · Final report · Dec 29, 1983 · N2773 · Minor damage > The acft experienced a strong shimmy & vibration on takeoff which was attributed to deep ruts in the snow. After landingon deceleration the vibration became so severe that the plt stopped on the rwy centerline & ordered an evacuation. It was determined that… - [NTSB DEN84LA054](https://openairdocs.org/ntsb/DEN84LA054.md): Beech 65-90 · Hayden, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1983 · N276VM · Substantial damage > The acft overran the rwy end during a night IMC landing. The plt stated 'the descent was steep' and 'I first touched down 1/2 way down the 7000-FT rwy.' He also stated that, 'I decide to plant the acft on the rwy so I could get on the reversers and get it… - [NTSB SEA84LA028](https://openairdocs.org/ntsb/SEA84LA028.md): Cessna A-185F II · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Dec 26, 1983 · N8344Q · Substantial damage > The acft collided with a hidden snow berm while landing on a snow covered rwy. The new snow was 2 to 3 inches deep over a compacted snow base. The rwy was plowed to a width of 30 to 35 ft with 3 ft berms. The plt stated that he encountered a whiteout during… - [NTSB MKC84LA045](https://openairdocs.org/ntsb/MKC84LA045.md): Piper PA-28-140 · Iowa Falls, IA · Accident · No injuries · Limited investigation · Final report · Dec 26, 1983 · N9565W · Substantial damage > The acft swerved and collided with a snowbank alongside the rwy during landing. The pilot stated that she hit some snow and ice on the rwy and when the acft started to slide she lost control. The acft turned left and when the left wing hit the snowbank the… - [NTSB MKC84LA044](https://openairdocs.org/ntsb/MKC84LA044.md): Piper PA-28-180 · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · Dec 25, 1983 · N55890 · Substantial damage > The plt stated that during her arrival at Manhattan, KS, the rwy had patches of snow & was surrounded by snow covered terrain. Just prior to landing, she became aware of a snowbank at the apch end of the rwy. She took evasive action, but the right main gear… - [NTSB FTW84FA102](https://openairdocs.org/ntsb/FTW84FA102.md): Bell 47G-2A-1 · Hughes, AR · Accident · 1 fatal · Field investigation · Final report · Dec 24, 1983 · N124CD · Destroyed > The plt & observer were on a flt to rescue 2 duck hunters, stranded in a boat that became stuck in ice, 500 to 600 ft from shore. After removing the rgt door, they planned to pick up 1 hunter at a time on the rgt skid while the observer held onto him thru the… - [NTSB DEN84LA060](https://openairdocs.org/ntsb/DEN84LA060.md): Cessna 425 · Big Piney, WY · Accident · No injuries · Limited investigation · Final report · Dec 24, 1983 · N6884G · Substantial damage > Prior to departure the plt telephoned the FBO at Big Piney arpt. He was advised of the poor wx conditions that existed at the arpt & was also advised not to land at the arpt. The acft was later observed to land at Big Piney arpt, touch down on the snow… - [NTSB DEN84FA047](https://openairdocs.org/ntsb/DEN84FA047.md): Piper 602P · Rock Springs, WY · Accident · No injuries · Field investigation · Final report · Dec 23, 1983 · N6894P · Substantial damage > The acft swerved off the snow-covered rwy during landing. The snow plow equipment operator was unable to keep the rwy clear due to strong winds. Finger drifts developed soon after each plowing. Two foot snow banks existed on either side of the rwy. The snow… - [NTSB FTW84LA101](https://openairdocs.org/ntsb/FTW84LA101.md): Aeronca 7DC · Bellville, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 1983 · N82243 · Substantial damage > The plt stated he landed 'a little long & a little fast.' The acft then drifted off the paved rwy into grass & soft terrain. The right wheel dug into the ground & the acft nosed over onto its back at the line of rwy lights. - [NTSB LAX84LA108](https://openairdocs.org/ntsb/LAX84LA108.md): Bell 47G · El Cajon, CA · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N4475 · Substantial damage > During a demonstration to show his student how to autorotate fm a 2 ft height AGL the instructor reduced pwr and inadvertently applied fwd cyclic. The front portion of the skids hit the gd followed by the main rotor blades. Helicopter then rocked backwards,… - [NTSB DEN84FA045](https://openairdocs.org/ntsb/DEN84FA045.md): Convair 440 · Rock Springs, WY · Accident · No injuries · Field investigation · Final report · Dec 20, 1983 · N73162 · Substantial damage > Combs airways, flt 709, collided with a snow bank during the landing roll at sweetwater county aprt. The capt reported that 'immediately after touchdown, the acft veered left, struck a snow bank, then veered to the right 180 deg coming to rest on the rwy… - [NTSB DCA84AA012](https://openairdocs.org/ntsb/DCA84AA012.md): Douglas DC-9-31 · Sioux Falls, SD · Accident · 1 fatal · Final report · Dec 20, 1983 · N994Z · Substantial damage > During landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy… - [NTSB ATL84LA069](https://openairdocs.org/ntsb/ATL84LA069.md): Cessna 152 · Rock Hill, SC · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N69069 · Substantial damage > The student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran… - [NTSB ANC84FA026](https://openairdocs.org/ntsb/ANC84FA026.md): Boeing 747-200F · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Dec 19, 1983 · J8151 · Substantial damage > At 2359 the local controller cleared the flt to land on rwy 6R. At 0001 the ground controller cleared a state-operated pick-up truck onto rwy 6R for a tapley run. The ground controller stated that he requested clearance from the local controller to allow the… - [NTSB DEN84LA044](https://openairdocs.org/ntsb/DEN84LA044.md): Cessna 152 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Dec 18, 1983 · N93271 · Substantial damage > The acft collided with a snow bank during landing and nosed down. This was the student's first solo landing. The studentthought the landing was all right except that the acft kept going to the left in spite of right rudder. Some power was still on the acft.… - [NTSB CHI84LA061](https://openairdocs.org/ntsb/CHI84LA061.md): Piper PA-38-112 · Hayward, WI · Accident · No injuries · Limited investigation · Final report · Dec 18, 1983 · N25687 · Substantial damage > The acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted… - [NTSB MKC84LA039](https://openairdocs.org/ntsb/MKC84LA039.md): Cessna 150 · Clinton, MO · Accident · No injuries · Limited investigation · Final report · Dec 17, 1983 · N17297 · Substantial damage > The plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.… - [NTSB CHI84LA062](https://openairdocs.org/ntsb/CHI84LA062.md): Cessna 152 · Peoria, IL · Accident · No injuries · Limited investigation · Final report · Dec 17, 1983 · N48544 · Substantial damage > The student plt elected to make a touch & go landing on a rwy covered with loose snow & patches of ice. He reported that when he added power during his 1st touch & go, the acft veered to the left & subsequently collided with a snowbank. - [NTSB ATL84LA067](https://openairdocs.org/ntsb/ATL84LA067.md): Cessna 182P-SYLANE · Damascus, GA · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N84223 · Substantial damage > The plt, an auctioneer, had rented the acft to fly to a farm where he was to conduct an auction. Previously, he had inspected the intended landing area, a soy bean field, & thought it would be satisfactory for a landing. When he arrived & landed, the main… - [NTSB MIA84LA046](https://openairdocs.org/ntsb/MIA84LA046.md): Beech 35 · Lake City, FL · Accident · No injuries · Limited investigation · Final report · Dec 15, 1983 · N444D · Substantial damage > The plt landed with the nose gear partially extended. The plt reported that he heard a crack while the landing gear was retracting after takeoff. He put the gear handle back down and continued to Lake City. After flying several low passes, the control tower… - [NTSB DEN84FA042](https://openairdocs.org/ntsb/DEN84FA042.md): Mooney M20J · Bismarck, ND · Accident · Serious injuries · Field investigation · Final report · Dec 15, 1983 · N1151N · Substantial damage > The plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl… - [NTSB CHI84IA060](https://openairdocs.org/ntsb/CHI84IA060.md): Mcdonnell Douglas DC-8-61 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 14, 1983 · N914CL · Minor damage > A DC-8-61 operated by capitol air inc experienced a partial failure of the left main gear on the landing roll. The rear portion of the left main landing gear bogie & both rear tires were separated. Components of the left landing gear were submitted to… - [NTSB LAX84LA426](https://openairdocs.org/ntsb/LAX84LA426.md): Piper PA-31-350 · San Carlos, AZ · Accident · No injuries · Limited investigation · Final report · Dec 13, 1983 · N3110M · Substantial damage > During a night landing on a road, the acft was damaged when it hit a berm. According to customs officials. The plt had circled while ground personnel placed rows of lights adjacent to the road, then he landed. There was evidence that illegal drugs had been… - [NTSB CHI84LA059](https://openairdocs.org/ntsb/CHI84LA059.md): Cessna 310 · Brainerd, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1983 · N37252 · Substantial damage > After making a vor/dme apch, the plt circled to land on rwy 23 in wx conditions of light snow & fog. The terrain & rwy were covered with snow. The plt tried to contact Brainerd UNICOM to have the rwy lights turned up, but he received no response. He could… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=451 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=450 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.