# NTSB investigations: Approach 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 208 of 420 · 20,992 cases ## Cases, newest first - [NTSB MKC83LA203](https://openairdocs.org/ntsb/MKC83LA203.md): Grumman American AA-5 · Junction City, KS · Accident · No injuries · Limited investigation · Final report · Aug 27, 1983 · N6191L · Substantial damage > During arrival, the plt noticed an isolated thunderstorm just to the west of the arpt. While on the approach, he noticed the wind sock indicating a southeast wind with little velocity. The plt stated that when he was on a short final approach, the wind… - [NTSB DEN83FTK05](https://openairdocs.org/ntsb/DEN83FTK05.md): Piper PA28-180C · Sturgis Muni., SD · Accident · Serious injuries · Final report · Aug 27, 1983 · N8426W · Destroyed > The acft crashed on the approach end to runway 11 during an aborted landing. The plt stated the acft was high so he applied full power and retracted the flaps. He said he retracted the flaps too fast and lost control of the acft. The nose gear was broken off,… - [NTSB SEA83LA183](https://openairdocs.org/ntsb/SEA83LA183.md): Cessna 175 · Chelan, WA · Accident · No injuries · Limited investigation · Final report · Aug 26, 1983 · N9450B · Substantial damage > The acft stalled into an apple orchard during an attempted go-around. The plt said he was being pushed by a crosswind and during the initial flare was unable to correct so he decided to go-around. During go-around the acft was to the leftof the rwy. The plt… - [NTSB LAX83FU013](https://openairdocs.org/ntsb/LAX83FU013.md): Midwest Microlites - Tomcat · Roseville, CA · Accident · Serious injuries · Final report · Aug 26, 1983 · UNREG · Substantial damage > According to the plt, he was attempting to land in a plowed field which was adjacent to a rice field. During the landing maneuver, the plt entered a left turn over the rice field. As he continued the turn over the plowed field, a thermal was encountered & the… - [NTSB DEN83LA200](https://openairdocs.org/ntsb/DEN83LA200.md): Bell 206L-1 · Tucker, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1983 · N3900B · Substantial damage > The helicopter was being used on a seismic data acquistion operation. While landing by a road in mountainous terrain at an elevation of aprx 8400 ft, the helicopter was observed to approach to a hover over the roadway. A considerable amount of dust was blown… - [NTSB MKC83FA201](https://openairdocs.org/ntsb/MKC83FA201.md): Grieme Skybolt · Atchison, KS · Accident · Serious injuries · Field investigation · Final report · Aug 25, 1983 · N798G · Substantial damage > The acrt crashed 200 ft short of the rwy when the engine failed to respond on a short final approach. The acft came to rest 100 ft below the rwy level. The landing gear was broken backward. The nose of the acrt was against a dirt bank. There was less than 1… - [NTSB NYC83LA223](https://openairdocs.org/ntsb/NYC83LA223.md): American AA-1 · Dunkirk, NY · Accident · No injuries · Limited investigation · Final report · Aug 24, 1983 · N5686L · Substantial damage > At aprx 0955 EDT, the plt took off from schenectady, NY with 24 gal of fuel on board. About 2 1/2 hrs later, while on a downwind to land at Dunkirk, NY, he applied carburetor heat & then the eng lost power. The carburetor heat was shut off & a restart was… - [NTSB FTW83LA392](https://openairdocs.org/ntsb/FTW83LA392.md): Aeronca O-58B · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 1983 · N57714 · Destroyed > Both occupants were confederate air force personnel. The plt-in-command (PIC) reminded the other occupant of wires in the area where the were flying on base leg. The other occupant replied, 'yes, I see them & think we will be above them.' He then replied,… - [NTSB LAX83LA401](https://openairdocs.org/ntsb/LAX83LA401.md): Piper PA-32-300 · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1983 · N3957X · Substantial damage > The acft encountered a downdraft during short final & touched down in sandy terrain a few feet short of the rwy. The right main landing gear failed as the acft struck the end of the asphalt rwy. The plt had been advised over UNICOM of a possible wind shear… - [NTSB NYC83FFA03](https://openairdocs.org/ntsb/NYC83FFA03.md): Beech V35A · Milton, NY · Accident · Serious injuries · Final report · Aug 21, 1983 · N980RP · Substantial damage > The flt originated at albany, NY & continued to saratoga, NY. Provincetown, MA, hyannis, MA, then returned to saratoga. The total flt time was aprx 3 hrs & was conducted using fuel solely from the left fuel tank. The apch to saratoga was from the southeast.… - [NTSB DEN83LA194](https://openairdocs.org/ntsb/DEN83LA194.md): Piper PA-12 · St. Xavier, MT · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N3351M · Substantial damage > The acft collided with a fence during an attempted go-around in a field which was estimated to be 500 ft long. The wind was calm and the density alt was calculated to be 4900 ft. after landing and rolling 300 ft the plt decided he would not be able to stop.… - [NTSB LAX83LA399](https://openairdocs.org/ntsb/LAX83LA399.md): Piper PA-28-R200 · Fresno, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 1983 · N4312X · Destroyed > The acft collided with a fence during the flare for landing and came to rest near the rwy threshold. The plt stated he got too low during the approach during a checkout from the previous owner. The PIC had over 400 hours of single engine time but none in this… - [NTSB FTW83LA388](https://openairdocs.org/ntsb/FTW83LA388.md): Piper PA-24-250 · Lindreth, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 1983 · N5230P · Substantial damage > The plt said he was approaching the rwy at 90 mph with full flaps and at 300 ft AGL he hit a downdraft. He added power and raised the nose but could not stop the descent. - [NTSB ATL83LA338](https://openairdocs.org/ntsb/ATL83LA338.md): Cessna 172 · Falls Of Rough, KY · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N2882L · Substantial damage > The acft collided with a power line during a G0-around. Investigation revealed the acft had rolled about 3/4 of the way down the 2700 ft rwy before a go-around was started. The collision occurred 850 ft beyond the departure end of the rwy 30 ft AGL and 400 ft… - [NTSB LAX83LA383](https://openairdocs.org/ntsb/LAX83LA383.md): Cessna 182Q · Trinity Center, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1983 · N735DZ · Substantial damage > The plt stated that during the apch, he let his airspeed get too slow & stalled the acft. Reportedly, he applied full power to go around as the acft began to rapidly lose alt. However, the acft touched down in a brushy area beside the rwy & nosed over. - [NTSB FTW83LA379](https://openairdocs.org/ntsb/FTW83LA379.md): Cessna 150 · Humble, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1983 · N3051S · Substantial damage > The acft landed short of the rwy during a forced landing after the engine quit on final approach. The acft landed in mudand nosed over. The acft had not flown since March and during pre-flight a mud dauber nest had to be removed from the pitot and two quarts… - [NTSB ATL83LA327](https://openairdocs.org/ntsb/ATL83LA327.md): Piper PA-28AT-201T · Basye, VA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1983 · N8242L · Substantial damage > The flt instructor (CFI) was giving the private plt a familiarization flt. During an apch to rwy 23 at Basye, VA, at dusk, the acft got low & the CFI instructed the plt to add power. However, when the throttle was advanced, the eng reportedly did not respond.… - [NTSB ATL83FU005](https://openairdocs.org/ntsb/ATL83FU005.md): Weedhopper JC-24 · Wiggins, MS · Accident · 1 fatal · Final report · Aug 16, 1983 · UNREG · Destroyed > Reportedly, the non-rated plt had no previous flt experience, but was briefed on the ultralight vehicle's operation, control response & other aspects, as well as the traffic pattern, direction, etc. During takeoff, the ultralight entereda dive after climbing… - [NTSB NYC83FA210](https://openairdocs.org/ntsb/NYC83FA210.md): Aerospatiale SA-360C · New York, NY · Accident · Minor injuries · Field investigation · Final report · Aug 14, 1983 · N8479U · Substantial damage > While on final apch to a heliport, the helicopter was at aprx 70 KTS & 100 ft AGL when the plt applied power to begin decelerating. As collective pitch was applied, he heard a series of banging noises which he described as similar to compress stalls.… - [NTSB FTW83LA375](https://openairdocs.org/ntsb/FTW83LA375.md): Schempp-Hirth Standard Cirrus · Lyons, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1983 · N303RH · Destroyed > While on the return portion of a round-robin x-country flt, the plt lost thermal lift & elected to land in a pasture. He gradually descended over the pasture & prepared to land. When the glider was about 30 ft AGL, the right wing tip struck the top of a tree,… - [NTSB FTW83LA374](https://openairdocs.org/ntsb/FTW83LA374.md): Schweizer SGS 1-26F · Caddo Mills, TX · Accident · No injuries · Limited investigation · Final report · Aug 14, 1983 · N2693H · Substantial damage > The student plt saw a small thunderstorm moving toward the arpt, so he returned to land before it arrived. He stated he was 2 to 3 min too late. While in the traffic pattern, he encountered turbulence, downdrafts & winds reportedly gusting to 30 KTS. As the… - [NTSB MKC83FA190](https://openairdocs.org/ntsb/MKC83FA190.md): Piper PA-28R-200 · Farley, MO · Accident · Serious injuries · Field investigation · Final report · Aug 13, 1983 · N32240 · Substantial damage > While on a VFR pleasure flight, at night the aircraft crashed in an open field. The landing gear was down and locked. The propeller was windmilling at touchdown but there was no indication that the engine was developing power. Examination of the engine… - [NTSB CHI83LA378](https://openairdocs.org/ntsb/CHI83LA378.md): Cessna T210M · Troy, MI · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N732NJ · Substantial damage > The acft collided with trees during a forced landing. The pilot stated he had used all the fuel in one tank. He continued flt to Troy-oakland advising detroit of his fuel state. Detroit approach vectored him to the arpt but the pilot claimed he could not… - [NTSB ANC83LA142](https://openairdocs.org/ntsb/ANC83LA142.md): Bellanca 7GCBC · Palmer, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1983 · N5215X · Substantial damage > The acft crashed during a go-around attempt to a mountain airstrip at 4000 ft MSL. According to the plt he thought his approach was too flat so he initiated a go-around at low alt and with 60 KTS indicated airspeed. The acft would not outclimb the rising… - [NTSB CHI83LU007](https://openairdocs.org/ntsb/CHI83LU007.md): Berwin Waspair Tomcat Tour · Oconomowoc, WI · Accident · Serious injuries · Final report · Aug 10, 1983 · UNREG · Substantial damage > The ultralight collided with a tree during a go-around. The acft encountered an updraft during the landing attempt and the pilot decided to go-around. The acft was not able to gain alt fast enough to clear a tree at the end of the field. The pilot was in… - [NTSB ANC83FA141](https://openairdocs.org/ntsb/ANC83FA141.md): Camair 480 · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Aug 10, 1983 · N231 · Substantial damage > After about 1 hr of flt time, both engs of the acft lost power as the plt was on a base leg of the traffic pattern for a landing. Subsequently, the plt was unable to reach the rwy & the gear collapsed while he was landing short of the rwy. Reportedly, the… - [NTSB NYC83FA203](https://openairdocs.org/ntsb/NYC83FA203.md): Piper PA-28-181 · Fishers Island, NY · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1983 · N6877J · Destroyed > The plt had called his home base & was told that fog was beginning to move shoreward & that the intended destination, (waterford, CT) would not remain VFR for long. The plts of N6877J & another acft chose to depart immediately. Before arriving, fog had moved… - [NTSB FTW83FA364](https://openairdocs.org/ntsb/FTW83FA364.md): Balloon Works Firefly AX-7 · Fort Worth, TX · Accident · No injuries · Field investigation · Final report · Aug 6, 1983 · N3609C · Substantial damage > The intended landing area was a parking lot. Adjacent to the lot was a one-story building on top of which a tv antenna about 20 ft above the roof top. In an effort to clear the antenna during the descent to the parking lot, the pltwas not aware of a set of… - [NTSB SEA83LA165](https://openairdocs.org/ntsb/SEA83LA165.md): Cessna T210L · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N5469V · Substantial damage > The plt stated that the fuel tanks were topped off on the day before he departed el monte, CA. He estimated that the acft had 534 lbs of fuel on board & consumed 80 pph during cruise at 9500 ft MSL. According to the plts operating manual, the acft had an… - [NTSB FTW83LA363](https://openairdocs.org/ntsb/FTW83LA363.md): Beech B50 · Corsicna, TX · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N271D · Substantial damage > The plt was unable to extend the nose gear prior to landing, so he elected to land with the gear retracted. While on final approach, he closed the mixtures & throttles and attempted to feather the props, but the left eng continued to windmill. He continued… - [NTSB FTW83LA360](https://openairdocs.org/ntsb/FTW83LA360.md): Piper PA-28R-180 · Afton, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 1983 · N4643J · Substantial damage > The acft landed 3 ft short of the rwy on an inclined concrete slope. The weather was VMC. At the approach to the rwy a concrete embankment slopes downward about 10 ft to a road. The acft hit on this embankment bounced and slid 75 ft down the rwy. Discussions… - [NTSB CHI83LA357](https://openairdocs.org/ntsb/CHI83LA357.md): Black KR1 · Franklin, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 1983 · N1369N · Destroyed > The acft was observed to touchdown on rwy 27; become airborne, climb out and turn toward the airport crashing 500 ft short of the rwy. FAA examination of the wreckage did not reveal any evidence of flight control failure/malfunction or pre-impact plt… - [NTSB CHI83IA360](https://openairdocs.org/ntsb/CHI83IA360.md): Piper PA31-310 · Mount Vernon, OH · Incident · No injuries · Incident investigation · Final report · Aug 4, 1983 · N9135Y · Minor damage > On final approach both engines failed. The pilot elected to land intentional gear up short of therunway. Less than 1 pint of fuel was found on board. - [NTSB SEA83LA164](https://openairdocs.org/ntsb/SEA83LA164.md): Cessna 150M · Port Orchard, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1983 · N3526V · Substantial damage > The acft stalled into trees during an attempted go-around after a simulated forced landing. This was a dual instructional flight. During the simulated landing maneuver the student located a grass strip and approached into the wind. At about 30-50 ft a… - [NTSB SEA83LA163](https://openairdocs.org/ntsb/SEA83LA163.md): Cessna 172M · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1983 · N80076 · Substantial damage > During arrival, the plt elected to land on an uphill rwy with a tail wind. She stated that she was high on final & side slipped until reaching the correct altitude while using the VASI lights for a reference. As she approached the rwy, the wind blew the acft… - [NTSB SEA83LA166](https://openairdocs.org/ntsb/SEA83LA166.md): Cessna 182E · Agness, OR · Accident · No injuries · Limited investigation · Final report · Aug 2, 1983 · N2840Y · Substantial damage > The pilot said that he overflew the rwy twice to look for cattle. On the third approach during short final cattle began crossing the rwy in use. The pilot maneuvered to use the other rwy and stalled at about 25 ft AGL. Due to the acft's low alt & high… - [NTSB CHI83FA346](https://openairdocs.org/ntsb/CHI83FA346.md): Piper J3C-65 · Lily Lake, IL · Accident · Serious injuries · Field investigation · Final report · Aug 2, 1983 · N27020 · Substantial damage > The plt reported that a neighbor had flown the acft earlier in the day & had problems adjusting the elevator trim when airborne. The plt stated that before takeoff, he checked the trim, but it worked normally, so he set it for cruise & made a normal takeoff.… - [NTSB ATL83LA308](https://openairdocs.org/ntsb/ATL83LA308.md): Cessna 310 · Greensboro, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 1983 · N39710 · Substantial damage > The acft landed short of the rwy after a loss of power in the engine occurred during the second approach attempt to the airport. According to the plt, emergency procedures were initiated, and an engine restart was attempted. When unable to restart the engine,… - [NTSB NYC83FA198](https://openairdocs.org/ntsb/NYC83FA198.md): Cessna 210H · Marlborough, CT · Accident · 3 fatal · Field investigation · Final report · Aug 1, 1983 · N1968X · Destroyed > The acft collided with trees and the ground during an approach to land on a foggy night at an arpt with no instrument approach facilities or control. The 67 year old plt had canceled his IFR flt plan at 2110 EDT. The accident occurred at 2115 EDT. The plt and… - [NTSB CHI83LA354](https://openairdocs.org/ntsb/CHI83LA354.md): Piper PA-22 · Juneau, WI · Accident · No injuries · Limited investigation · Final report · Jul 31, 1983 · N8632D · Substantial damage > The pilot stated that he made the approach at 85-90 mph with 40 degrees flaps and 1100 RPM. The winds were from 270 degrees at 10 KTS gusting to 20 KTS the acft started to sink on the short final and the pilot applied power and pulled back on the stick in an… - [NTSB ATL83LA301](https://openairdocs.org/ntsb/ATL83LA301.md): Beech C23 · Atlanta, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1983 · N6629J · Substantial damage > During arrival on a dark night, the plt flew past the arpt. After receiving a df-steer, he observed the arpt environment & descend to land on rwy 8R. His initial approach was high, so he circled as he descended toward the arpt. Reportedly, he lost sight of… - [NTSB SEA83LA161](https://openairdocs.org/ntsb/SEA83LA161.md): Cessna 182A · Sheridan, OR · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N6386B · Substantial damage > The acft lost power on final approach to land and made contact with a fence short of the rwy and nosed over. During preflt the pilot had omitted checking the fuel with a fuel strainer because he did not have one. During inspection the carburetor was found to… - [NTSB SEA83LA159](https://openairdocs.org/ntsb/SEA83LA159.md): Vangrunsven RV-3 · Twin Falls, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1983 · N17RV · Substantial damage > The home built plane was one of a flt of four acft that were being flown on a cross-country flt. While en route from hillsboro, or to Twin Falls, ID, the pilots had to divert around weather. As they were approaching Twin Falls, N17RV lost power from fuel… - [NTSB CHI83LA337](https://openairdocs.org/ntsb/CHI83LA337.md): Piper PA-28-180 · Youngstown, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1983 · N4260T · Destroyed > While on a x-country flt, the eng lost power before the acft arrived at the destination arpt. The plt switched fuel tanks, turned on the boost pump & restarted the eng, but aprx 1 min later power was lost again. There was insufficient altitude to glide to the… - [NTSB MKC83LA164](https://openairdocs.org/ntsb/MKC83LA164.md): Cessna 150 · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N6276G · Substantial damage > The student plt had made 2 landings at the arrowhead arpt, then returned to Creve Coeur arpt where he made a full stop landing. He took off again, and reportedly, applied carburetor heat on downwind. As he continued, he applied full flaps for the landing.… - [NTSB FTW83LA348](https://openairdocs.org/ntsb/FTW83LA348.md): Cessna 172 · Marshall, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1983 · N8095L · Substantial damage > The aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he… - [NTSB ATL83LA294](https://openairdocs.org/ntsb/ATL83LA294.md): Bell 206B · Nr Gatlinburg, TN · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1983 · N5733M · Destroyed > The plt reported that he was beginning his apch to a landing site at an elevation of 5200 ft when he felt a bump in the tail rotor pedals. The helicopter begun to spin to the right & the plt found he has no tail rotor control. An autorotative landing was made… - [NTSB LAX83LA358](https://openairdocs.org/ntsb/LAX83LA358.md): Laister LK10 · Jacumba, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1983 · N53619 · Substantial damage > The acft struck a bush during a landing short of the rwy. The instructor in the rear seat noted that the airspeed indicator at that position did not register below 60 mph by design. The instructor had no recent experience in this makeof acft and had no… - [NTSB NYC83FA188](https://openairdocs.org/ntsb/NYC83FA188.md): Cessna U206G · Brooklyn, NY · Accident · 4 fatal · Field investigation · Final report · Jul 22, 1983 · N5328X · 2 aircraft · Destroyed > A Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station… - [NTSB FTW83LA342](https://openairdocs.org/ntsb/FTW83LA342.md): Cessna 152 · Baytown, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1983 · N714XU · Substantial damage > While crossing the threshold for landing, the plt heard that another acft was departing from an intersecting rwy. The plt applied full power & the acft drifted left of the rwy. He raised the flaps & the acft settled. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=209 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=208 --- 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.