# NTSB investigations, 1983: 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 1 of 18 · 885 cases ## Latest cases - [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… - [NTSB ANC84LA024](https://openairdocs.org/ntsb/ANC84LA024.md): Cessna 402A · Kotlik, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 1983 · N4511Q · Substantial damage > During arrival, the plt landed on the frozen river, which was being used in lieu of the Kotlik airstrip. The landing area on the river was aprx 5000 ft long. After touchdown during the landing, some small children had run onto the departure end of the landing… - [NTSB CHI84LA056](https://openairdocs.org/ntsb/CHI84LA056.md): Cessna A185F · Bad Axe, MI · Accident · No injuries · Limited investigation · Final report · Dec 12, 1983 · N7560H · Substantial damage > During arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The… - [NTSB FTW84LA093](https://openairdocs.org/ntsb/FTW84LA093.md): Vickers Type 668 Varsity · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Dec 11, 1983 · N65338 · Substantial damage > The acft was on a flt from the El Paso intl arpt to the west Texas arpt. A hard landing was made causing all three landing gear to collapse, folded the left wing aft just inboard of the eng & twisted the entire right wing about 30 deg leading edge down.… - [NTSB NYC84LA051](https://openairdocs.org/ntsb/NYC84LA051.md): Cessna C172N · Meriden, CT · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N104CT · Substantial damage > The acft collided with a dirt pile and nosed over during landing. According to the plt, he landed too FAR down the rwy, attempting an abort and the acft flipped over. - [NTSB LAX84LA100](https://openairdocs.org/ntsb/LAX84LA100.md): Cessna A 188 A · Cantua Creek, CA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N5636J · Substantial damage > The acft collided with a pick-up truck during a landing on a private airstrip. The truck driver became distracted while driving alongside the dirt rwy and reported that he did not see the arriving acft. - [NTSB LAX84LA099](https://openairdocs.org/ntsb/LAX84LA099.md): Beech 58TC · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1983 · N2058K · Substantial damage > After making an ILS localtizer-only apch in heavy rain, the plt landed the acft long. When the acft touched down, the plt thought there was sufficient rwy remaining. However, he reported that he encountered hydroplaning conditions & was unable to stop on the… - [NTSB NYC84LA049](https://openairdocs.org/ntsb/NYC84LA049.md): Piper PA-28-140 · Prospectville, PA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1983 · N1412X · Substantial damage > The plt stated that he inadvertently flared too high during his landing on rwy 32. The stall warning horn sounded and the left wing stalled. He said he added power but the aircraft did not respond to flt controls and flew left into trees. - [NTSB NYC84IA048](https://openairdocs.org/ntsb/NYC84IA048.md): Mcdonnell Douglas DC-10-10 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Dec 8, 1983 · N103AA · Minor damage > The acft experienced a complete truck beam failure after touchdown. Metallurgical examination revealed a crack near the right rear truck pivot pin lubrication hole which showed propagation to the lower end of the grease hole on the mating surface. Grease hole… - [NTSB LAX84LA102](https://openairdocs.org/ntsb/LAX84LA102.md): Beech V35B · St. Johns, AZ · Accident · No injuries · Limited investigation · Final report · Dec 8, 1983 · N66876 · Substantial damage > About 10 min after takeoff the pax door opened & the plt elected to make a precautionary landing at St. Johns. Unaware that the wind was calm, the plt selected rwy 20, which is 3400 ft long, rather than RWY31, which is 5300 ft long, because when he departed… - [NTSB LAX84LA111](https://openairdocs.org/ntsb/LAX84LA111.md): Cessna 172G · Macdoel, CA · Accident · No injuries · Limited investigation · Final report · Dec 7, 1983 · N6070R · Substantial damage > The acft collided with trees during landing rollout. The plt said he thought the wind was 'southerly at about 20 kts'. He stated that while flaring for landing on rwy 15 a stront gust estimated at 40 KTS was encountered & the acft drifted off the 40 ft wide… - [NTSB MKC84LA035](https://openairdocs.org/ntsb/MKC84LA035.md): Rockwell 114 · Council Bluffs, IA · Accident · No injuries · Limited investigation · Final report · Dec 6, 1983 · N5858N · Substantial damage > According to the plt, he landed on rwy 13, which was icy, and encountered a right x-wind. Subsequently, the acft drifted to the left, the left main gear hit a snowbank & the acft ground looped. The plt reported that the right wing hit snow & was damaged. He… - [NTSB ATL84FIA02](https://openairdocs.org/ntsb/ATL84FIA02.md): Piper PA-28R-180 · Manassas, VA · Accident · No injuries · Final report · Dec 6, 1983 · N3859T · Substantial damage > The plt reported that during a night landing, the right main gear failed & the acft went off the right side of the rwy. An FAA investigator reported that the acft had touched down hard during the landing. - [NTSB FTW84LA088](https://openairdocs.org/ntsb/FTW84LA088.md): Cessna 152 · Plano, TX · Accident · No injuries · Limited investigation · Final report · Dec 5, 1983 · N89551 · Substantial damage > During a touch-&-go landing, the acft bounced back in teh air after touching down. At that time, the sudent plt reacted by pushing forward on the control yoke. The acft then impacted, nose down, & the nose gear collapsed. - [NTSB DEN84LA040](https://openairdocs.org/ntsb/DEN84LA040.md): Cessna P206C · Tremonton, UT · Accident · No injuries · Limited investigation · Final report · Dec 5, 1983 · N8669Z · Substantial damage > Before takeoff, the plt obtained a wx briefing & filed a flt plan, but did not ask for NOTAMS. He was unaware that the destination arpt was notamed as closed until after the flt. He said that during arrival, he 'discovered an unplowed but apparently used… - [NTSB FTW84LA098](https://openairdocs.org/ntsb/FTW84LA098.md): Piper PA-15 · Bulverde, TX · Accident · No injuries · Limited investigation · Final report · Dec 4, 1983 · N4309H · Substantial damage > The acft collided with a ditch during landing rollout after loss of control and a groundloop. According to the plt the landing was normal on a 2850 ft strip. The acft groundlooped at slow speed and went into a ditch off the right side of rwy 16. This flt was… - [NTSB MKC84LA032](https://openairdocs.org/ntsb/MKC84LA032.md): Cessna 152 · David City, NE · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N89812 · Substantial damage > The instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.… - [NTSB LAX84LA091](https://openairdocs.org/ntsb/LAX84LA091.md): Let L-13 · Jacumba, CA · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N711KR · Substantial damage > The acft collided with a bush and groundlooped short of the rwy. The wind was unusually strong and the glider plt stated he misjudged its effect and should have flown the base leg closer. The acft landed short of the rwy and ground looped. - [NTSB FTW84LA087](https://openairdocs.org/ntsb/FTW84LA087.md): Balloon Works Firefly 7 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N4061P · Substantial damage > The plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?year=1983&page=2 ## 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 year(c."eventDate") = 1983 AND 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?year=1983 --- 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.