# NTSB investigations, 1983: 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 1 of 10 · 476 cases ## Latest cases - [NTSB MKC84LA052](https://openairdocs.org/ntsb/MKC84LA052.md): Piper PA-38 · Preston, IA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N2490G · Substantial damage > The student plt began a x-country ftw with no directional gtro installed. He stated that he had taken the acft with the advice of his instructor who believed that the magnetic compass would be satisfactory. On the 3rd leg of his x-country, he took the wrong… - [NTSB MKC84FA049](https://openairdocs.org/ntsb/MKC84FA049.md): Piper PA-38-112 · Floyd, IA · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1983 · N4457E · Substantial damage > The instructor plt (CFI) & student were on a dual instructional flt. According to witnesses, they were making 90 deg turns at about 1500 ft AGL, just prior to the accident. After turning from a heading of south to east, the acft entered a descent, then… - [NTSB LAX84LA126](https://openairdocs.org/ntsb/LAX84LA126.md): Cessna A150M · Castaic, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N7320A · Substantial damage > After the plt landed on an abandoned road, the aircraft went off the right side, near the end of the roadway, then went over an embankment & nosed over. He did not submit an accident report (NTSB form 6120.1). However, he told sheriff's deputies that he made… - [NTSB LAX84LA121](https://openairdocs.org/ntsb/LAX84LA121.md): Cessna 182F · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 1983 · N3222U · Substantial damage > The acft stalled into the side of a mountain about 75 ft below its crest. The plt reported that as it became apparent that the acft had insufficient altitude to clear the mountain the throttle was opened but the rpm's were not increased. The tachometer… - [NTSB FTW84LA106](https://openairdocs.org/ntsb/FTW84LA106.md): Cessna 182 · Corsicana, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 30, 1983 · N46N · Destroyed > The acft collided with wires shortly after takeoff as the plt maneuvered at low altitude. After the collision the acft flew for about 1/4 mile and crashed in an unimproved field on a farm. There was no passenger seat in the acft and the passenger was… - [NTSB MIA84FA051](https://openairdocs.org/ntsb/MIA84FA051.md): Grumman C-164 · South Bay, FL · Accident · 1 fatal · Field investigation · Final report · Dec 28, 1983 · N647U · Destroyed > As the acft initiated a turn to start dusting, it was observed to lose altitude rapidly & collide with the ground. The acft was 470 lbs over max gross takeoff weight. The area was affected by gusty winds from the south, & the plt's initial turn to the field… - [NTSB LAX84LA117](https://openairdocs.org/ntsb/LAX84LA117.md): Bell 206B III · Mountain City, NV · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1983 · N206JH · Substantial damage > The helicopter collided with the snow covered ground after the eng quit during a power-line patrol at about 30 ft AGL. The plt reported that the visibility was 1/2 mile with light snow falling. He also said he could see 4 to 7 of the supporting structures.… - [NTSB LAX84FA113](https://openairdocs.org/ntsb/LAX84FA113.md): Piper PA 24-260 · Fontana, CA · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1983 · N8761P · Destroyed > The acft collided with a electrical power line tower at night during IMC weather. The tower was struck at 40 ft AGL. Theplt received a weather briefing for this flt and VFR flt was not recommended. No flt plan was filed. Witesses heard the acft fly over at an… - [NTSB ATL84FA075](https://openairdocs.org/ntsb/ATL84FA075.md): Mooney M20F · Clemson, SC · Accident · 4 fatal · Field investigation · Final report · Dec 25, 1983 · N7076V · Destroyed > The acft crashed in a wooded area about 15 miles from its destination but about 16 miles north of a straight line between gainesville, ga and anderson, SC. One witness about 5 miles from the site saw an acft just before the time of the crash flying at about… - [NTSB MIA84FA049](https://openairdocs.org/ntsb/MIA84FA049.md): Piper PA-12 · Ft. Lauderdale, FL · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1983 · N7510H · Destroyed > The acft crashed on the arpt in a steep nose down attitude after dropping a banner it was towing. The plt waved to the ground personnel and turned in a 60 degree bank nose high turn. After 180 degrees of turn the acft stalled, the nosefell through and the… - [NTSB NYC84LA055](https://openairdocs.org/ntsb/NYC84LA055.md): Bell 47-G3B1 · Dummerston, VT · Accident · No injuries · Limited investigation · Final report · Dec 18, 1983 · N48316 · Substantial damage > The plt initiated a practice autorotation from about 600 ft AGL. Airspeed was about 55 KTS with low m/r RPM due to low gross weight. A moderate flare was initiated in an effort to increase rotor RPM, reducing the airspeed to 40 KTS. However, the application… - [NTSB MIA84FA047](https://openairdocs.org/ntsb/MIA84FA047.md): Rygg Volmer VJ22 · Oldmar, FL · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1983 · N15RK · Destroyed > Witnesses observed the acft flying in a northerly direction over tampa bay at a height of 25 to 50 ft above the surface. Moments before crashing, the acft made an abrupt descent & passed under a power line that spinned the northern neck of the bay.… - [NTSB NYC84FA058](https://openairdocs.org/ntsb/NYC84FA058.md): Beech T-34A · Stockton, NJ · Accident · 2 fatal · Field investigation · Final report · Dec 17, 1983 · N12EG · Destroyed > Prior to the accident, the acft was observed in aerobatic type maneuvers. According to one witness, he saw the acft enter a descent after it had completed a roll maneuver. It was still in a steep descent when he lost sight of the acft due to trees. The acft… - [NTSB ATL84FA068](https://openairdocs.org/ntsb/ATL84FA068.md): Cessna C-172M · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1983 · N4275R · Destroyed > The acrt crashed into a lake while making a low pass when the plt was distracted by a passenger door that would not stay latched. The acft collided while turning and the plt stated that he was trying to help the passenger close the door. He also stated that… - [NTSB LAX84FA101](https://openairdocs.org/ntsb/LAX84FA101.md): Beech 95-A55 · Tucson, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 11, 1983 · N1563Z · Destroyed > The acft crashed during a local multi-engine instructional flight. There were no known witnesses to the accident. Examination of the wreckage failed to reveal any pre-impact malfunction of the aircraft or engine. - [NTSB LAX84FA097](https://openairdocs.org/ntsb/LAX84FA097.md): Bell 206B III · Grand Canyon, AZ · Accident · Serious injuries · Field investigation · Final report · Dec 8, 1983 · N113ML · Destroyed > The helicopter struck a cable while flying about 25 ft AGL in the Grand Canyon. The acft was on an aerial observation to survey and acquaint a passenger with the Arizona strip wilderness district. Phoenix fss highly recommends that plts not fly down into the… - [NTSB FTW84LA089](https://openairdocs.org/ntsb/FTW84LA089.md): Cessna 150G · Clinton, OK · Accident · 1 fatal · Limited investigation · Final report · Dec 6, 1983 · N4012J · Destroyed > Three witnesses observed the acft flying low before it went out of sight behind trees. Two of them reported that the plt made 3 low fly-bys with the eng sounding normal, then they heard the acft impact in a field on the 3rd pass. An exam of the crash site… - [NTSB NYC84FA046](https://openairdocs.org/ntsb/NYC84FA046.md): Cessna 172H · Hershey, PA · Accident · 1 fatal · Field investigation · Final report · Dec 2, 1983 · N6246L · Substantial damage > Prior to takeoff the plt was advised that 'a storm was moving in.' The plt replied he knew that & was only going up for a short flt. Shortly after takeoff snow began to fall, & the acft was observed flying perpendicular to the rwy below traffic pattern… - [NTSB LAX84LA088](https://openairdocs.org/ntsb/LAX84LA088.md): Cessna 172N · Truckee, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1983 · N6134E · Destroyed > The acft collided with trees and the terrain while trying to fly through donner pass on a solo x-country. There was an overcast sky and the mountains were 8300 to 9100 ft high. The plt was quoted as stating that the acft did not climb as well as he… - [NTSB LAX84LA084](https://openairdocs.org/ntsb/LAX84LA084.md): Grumman G-164B · Madera, CA · Accident · No injuries · Limited investigation · Final report · Nov 30, 1983 · N31184 · Substantial damage > At about 75 ft AGL in a procedure turnaround the acft stalled & collided with orange trees. - [NTSB LAX84LA079](https://openairdocs.org/ntsb/LAX84LA079.md): Cessna 180 · Las Vegas, NV · Accident · 1 fatal · Limited investigation · Final report · Nov 28, 1983 · N91478 · Destroyed > While on a x-country flt, the acft collided with the crest of a 10,000 ft mountain. Witnesses stated that the plt had circled in the area prior to the accident. The accident reportedly occurred at dusk, but witnesses said the area to the north of the site was… - [NTSB NYC84LA040](https://openairdocs.org/ntsb/NYC84LA040.md): Piper PA-18 · Great Pond, ME · Accident · No injuries · Limited investigation · Final report · Nov 24, 1983 · N1473C · Substantial damage > The plt stated that he was going hunting in a bog with a stream running thru the area. Reportedly, he was making a low pass to check for rocks in the stream before landing when a deer jumped up beside the float plane. He stated that he was watching to see… - [NTSB FTW84FA075](https://openairdocs.org/ntsb/FTW84FA075.md): Gulfstream Peregrine · El Reno, OK · Accident · Serious injuries · Field investigation · Final report · Nov 23, 1983 · N600GA · Destroyed > At about 215 KTS the plt rolled the acft in order to evaluate newly installed ailerons. It had been noted earlier that a dead-band existed in the aileron neutral range that increased with airspeed. The plt stated that upon rollout the dead-band was stronger &… - [NTSB MIA84FA032](https://openairdocs.org/ntsb/MIA84FA032.md): Beech 95-B55 · Near Naples, FL · Accident · 2 fatal · Field investigation · Final report · Nov 19, 1983 · N1826Z · Destroyed > The plt, along with his safety plt, departed page field at 1401 to accomplish airwork. 1 min later the crew was questioned by the tower why they had not started a turn southbound. The safety plt responded 'I just pulled an engine onhim and he is going to… - [NTSB FTW84LA073](https://openairdocs.org/ntsb/FTW84LA073.md): Cessna 152II · Walters, OK · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 1983 · N46237 · Destroyed > The plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass. - [NTSB ATL84LA046](https://openairdocs.org/ntsb/ATL84LA046.md): Bell 47-G · Middle River, MD · Accident · No injuries · Limited investigation · Final report · Nov 18, 1983 · N64816 · Substantial damage > While practicing hovering about 2 ft AGL the student allowed the helicoper to start drifting aft & right. The right skid heel contacted the ground & the helicopter roll onto its right side. - [NTSB FTW84LA061](https://openairdocs.org/ntsb/FTW84LA061.md): Hughes 269C · Freer, TX · Accident · No injuries · Limited investigation · Final report · Nov 17, 1983 · N50638 · Substantial damage > The plt & 2 passengers were on a flt to look for deer in a pasture area. While in a turn after the last pass over the pasture, the eng lost power at aprx 150 ft AGL. The plt initiated an autorotative landing in an area of mesquite brush & bushes. He reported… - [NTSB FTW84LA059](https://openairdocs.org/ntsb/FTW84LA059.md): Piper PA-36 · Seminole, TX · Accident · No injuries · Limited investigation · Final report · Nov 16, 1983 · N9936P · Destroyed > About half way thru a turnaround maneuver, the plt noted a loss of eng power & noticed that the manifold pressure had dropped about 5 inches. Due to the proximity of power lines, he was unable level his wings. Also, before he could dump his load, the left… - [NTSB FTW84FA060](https://openairdocs.org/ntsb/FTW84FA060.md): Piper PA-38-112 · Lakeview, AR · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1983 · N2432K · Destroyed > The student plt had rented the acft to practice basic maneuvers prior to a flt scheduled the following day with his instructor to receive his endorsement for a check ride. Witnesses in the area observed the acft practicing stalls, & on the final maneuver, the… - [NTSB LAX84FU022](https://openairdocs.org/ntsb/LAX84FU022.md): Lazair Ultralight · Elsinore, CA · Accident · 1 fatal · Final report · Nov 15, 1983 · UNREG · Substantial damage > After purchasing the 2 eng ultralight, the plt modified it by installing 2 additional engs. These were 6 HP pioneer engsinstalled in the #1 & #4 positions. Just prior to the accident, witnesses observed the vehicle flying over the center ofa lake at aprx 250… - [NTSB FTW84FA050](https://openairdocs.org/ntsb/FTW84FA050.md): Piper PA-28-161 · Devers, TX · Accident · 3 fatal · Field investigation · Final report · Nov 14, 1983 · N8092Z · Destroyed > The acft collided with trees while maneuvering at a very low altitude after dark in a popular deer hunting area. The acft was observed rolling into steep bank with the eng 'revved up' then suddenly yawed toward the ground. The acft lights were on. - [NTSB LAX84LA061](https://openairdocs.org/ntsb/LAX84LA061.md): Schweizer SGS 1-26D · Lucerne Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1983 · N7796S · Substantial damage > The student plt was on his 1st solo launch using an auto tow & a nose hook. During the launch, the glider became airborne at about 42 mph. Thereafter, the student climbed successfully to an estimated alt of aprx 200 ft. at about that time, the student's… - [NTSB LAX84LA060](https://openairdocs.org/ntsb/LAX84LA060.md): Piper PA-28-140 · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1983 · N7015R · Substantial damage > The plt was practicing engine-out forced landings. While recovering at about 200 ft AGL he inadvertenly pulled out the mixture control causing the eng to shut down. There was insufficient altitude for a restart & the acft touched down in arough feild. - [NTSB MIA84FU007](https://openairdocs.org/ntsb/MIA84FU007.md): Wizard J3 · Miami, FL · Accident · 1 fatal · Final report · Nov 12, 1983 · UNREG · Destroyed > Several witnesses observed the ultralight vehicle flying in a southwesterly direction at about 1500 ft AGL. They reported that the plt had executed 5 or 6 stall maneuvers, followed by normal straight ahead recoveries. During the last stall, the acft was… - [NTSB LAX84LA059](https://openairdocs.org/ntsb/LAX84LA059.md): Luscombe 8A · Casa Grande, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1983 · N1186B · Destroyed > During a local flt, the acft collide with terrain while the aircrew were performing low alt maneuvers. One of the occupants was an instructor plt (CFI) & the other was a private plt. Neither claimed to be the plt in command, but the private plt was the… - [NTSB LAX84LA062](https://openairdocs.org/ntsb/LAX84LA062.md): Ayres Thrush Commander · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Nov 11, 1983 · N89610 · Substantial damage > The acft collided with the ground during a spraying mission after the engine reportedly lost power. The plt stated that he had a loss of power in a swath turn, slowed up and hit the ground. The acft engine was examined after the accident and found… - [NTSB LAX84FA055](https://openairdocs.org/ntsb/LAX84FA055.md): Aerotek Pitts S-2B · Elk Grove, CA · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1983 · N700ME · Destroyed > During an aerobatic flt, the plt-in-command was asked to demonstrate recovery from an inverted flat spin. The maneuver was initiated at aprx 5000 ft. after the acft made aprx 3/4 of an inverted turn, it rolled upright as the PIC started to 'feed in throttle.'… - [NTSB LAX84LA051](https://openairdocs.org/ntsb/LAX84LA051.md): Cessna 188 · Needles, CA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1983 · N9302K · Substantial damage > The plt reported that he took off aprx 10 to 15 min after sunset on an aerial application flt. During a turn to begin a swath run, he noticed an unexpected change in drift. As he was descending below the level of nearby power lines, there was a loss of… - [NTSB CHI84LA043](https://openairdocs.org/ntsb/CHI84LA043.md): Taylorcraft BC-12D · Gatzke, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1983 · N95180 · Substantial damage > The acft collided with the ground when the pilot attempted a low level turn. - [NTSB LAX84FU020](https://openairdocs.org/ntsb/LAX84FU020.md): Bradey Goldwing · Adelanto, CA · Accident · Serious injuries · Final report · Nov 6, 1983 · UNREG · Substantial damage > Reportedly, during a local flt, the ultralight vehicle entered a steep climb. After reaching appx 1000 ft AGL, it was observed to enter a flat spin, then crash. Witnesses reported that the eng sounded normal. One witness indicated that the plt performed… - [NTSB SEA84MA016](https://openairdocs.org/ntsb/SEA84MA016.md): de Havilland DHC-2 · Challis, ID · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1983 · N9006 · Destroyed > The plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the… - [NTSB CHI84FU001](https://openairdocs.org/ntsb/CHI84FU001.md): Quicksilver MX · Elwin, IL · Accident · 1 fatal · Final report · Nov 5, 1983 · UNREG · Destroyed > The plt possessed a student plt & 3rd class medical certificate. After takeoff, he circled over the airfield, then climbed to about 200 ft AGL. A high school classmate stated that the ultralight then entered a nose high attitude & appeared to enter a practice… - [NTSB ATL84LA040](https://openairdocs.org/ntsb/ATL84LA040.md): Cessna 150 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Nov 5, 1983 · N3055V · Substantial damage > The purpose of the flt was to take pictures over lake murray. The plt stated that after taking off, he proceeded over the lake, then descended & varied his altitude between 400 & 800 ft MSL, so the passenger could take pictures. Shortly after rounding a bend… - [NTSB ATL84FA045](https://openairdocs.org/ntsb/ATL84FA045.md): Robinson R22 · Gaithersburg, MD · Accident · No injuries · Field investigation · Final report · Nov 5, 1983 · N8414H · Substantial damage > During his 2nd solo flt in the Robinson R22, the plt performed 2 low 'g' maneuvers. The 1st maneuver was essentially the same as when he practiced it during a check-out flt. However, the 2nd maneuver produced a rapid right roll to aprx 60 deg of bank. The plt… - [NTSB LAX84FA047](https://openairdocs.org/ntsb/LAX84FA047.md): Cessna 172N · Elko, NV · Accident · 2 fatal · Field investigation · Final report · Nov 4, 1983 · N739YL · Destroyed > The acft crashed in mountainous terrain while on a deer spotting flt. There were no witnesses to the accident. About 8 hours after departure the acft was declared missing. The acft was found the following day at about 0730 hours by air search acft. Ground… - [NTSB CHI84FA035](https://openairdocs.org/ntsb/CHI84FA035.md): Cessna 150F · Portland, IN · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1983 · N8320G · Destroyed > The plt had just purchased the acft & flew a previous co-owner to montpelier, IN, where he landed at about dusk. The previous co-owner deplaned. He said that after the acft took off, he saw it turn to the west & depart toward marion. A short time later, the… - [NTSB NYC84FGM01](https://openairdocs.org/ntsb/NYC84FGM01.md): Piper PA-28-161 · Marshburg, PA · Accident · Minor injuries · Final report · Nov 2, 1983 · N8163P · Destroyed > After refueling at ithaca, NY, the plts of two Piper PA-28 acft departed as a flt of two. They had planned to continue their flt back to cincinnati, oh with another en route stop at columbus, OH. The non-instrument rated plt of N8163P was following the lead… - [NTSB LAX84LA041](https://openairdocs.org/ntsb/LAX84LA041.md): Continental Copters Tomcat Mark 5A · Castroville, CA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1983 · N9092T · Substantial damage > The helicopter landed hard during a forced landing after a power loss. The accident occurred on the last swath run. When the engine stopped the acft was 6 ft AGL. The pilot reported that the engine stopped from fuel starvation. On recommendation for… - [NTSB SEA84FA015](https://openairdocs.org/ntsb/SEA84FA015.md): Cessna 150K · Near Challis, ID · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1983 · N5631G · Destroyed > A witness at the Challis arpt observed the acft takeoff, then turn & depart toward the west. It was found the next day Near Challis creek about 16 mi west of Challis. Impact occurred in a relatively flat area in a narrow wooded valley, at an elevation of… - [NTSB NYC84LA017](https://openairdocs.org/ntsb/NYC84LA017.md): Cessna 152 · Skaneateles, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1983 · N89940 · Substantial damage > The pilot stated that after returning from a x-ctry flight he was unable to activate the arpt rwy lights. Low on fuel, the engine quit while he searched for a place to land. He executed a forced landing into an open field. The pilot statedhe should not have… Next page: https://openairdocs.org/ntsb-phases/450/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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/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.