# 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 209 of 420 · 20,992 cases ## Cases, newest first - [NTSB CHI83AA326](https://openairdocs.org/ntsb/CHI83AA326.md): Aero Commander 685 · Cleveland, OH · Accident · 6 fatal · Final report · Jul 20, 1983 · N3711T · Destroyed > While turning from downwind to base leg, the acft was observed descending rapidly in a steep bank. Witnesses reported smoke was trailing from the acft. The acft crashed in an industrial area. An exam of the right eng revealed that the exhaust-to-turbo… - [NTSB MKC83LA160](https://openairdocs.org/ntsb/MKC83LA160.md): Rockwell 112A · Kansas City, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1983 · N1459J · Destroyed > The pilot said the right cabin door came open after takeoff and he reentered the traffic pattern to land. He was cleared to land on rwy 21 but the aircraft overshot final approach, stalled and landed in the grass. It then collided with a fence and crossed a… - [NTSB LAX83FA346](https://openairdocs.org/ntsb/LAX83FA346.md): Varieze 1 · Mojave, CA · Accident · 1 fatal · Field investigation · Final report · Jul 19, 1983 · N69EZ · Destroyed > The plt purchased the acft a week before the accident. The day before the accident the plt stated to rutan aircraft factory personnel that he had never flown this type of acft in the past & was afraid of the acft. On the day of the accident witnesses observed… - [NTSB FTW83LA339](https://openairdocs.org/ntsb/FTW83LA339.md): Hackett/Mckown KR-2 · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1983 · N3924N · Substantial damage > The plt/owner stated that the home built acft had poor forward visibility, was not equipped with flaps & required a high apch speed. Also, he said it tended to float after flaring to land & had poor brakes. Additionally, the arpt elevation was 5270 ft & the… - [NTSB ATL83LA283](https://openairdocs.org/ntsb/ATL83LA283.md): Cessna 310 · Wheeling, WV · Accident · No injuries · Limited investigation · Final report · Jul 19, 1983 · N3066L · Substantial damage > During the apch, the plt was unable to get a safe down indication for the right main gear. He changed the light bulb & still did not get a safe indication. A tower flyby was made, but the tower operator was unable to confirm if the right gear was locked. To… - [NTSB FTW83LA338](https://openairdocs.org/ntsb/FTW83LA338.md): Cessna 150M · Garland, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1983 · N4549Q · Destroyed > The plt-in-comand (PIC) & the designated flt examiner (fe) were on a flt to give the PIC a commercial plt flt exam. During a simulated forced landing apch, the PIC spiraled the acft down to the proposed landing spot. The proper check list procedures were… - [NTSB CHI83FA319](https://openairdocs.org/ntsb/CHI83FA319.md): Bellanca 17-30 · Hibbing, MN · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1983 · N4831V · Destroyed > Prior to departure, the plt obtained a wx briefing & was advised to check back before departing to see if anything had developed. Reportedly, he took off at 0815 CDT, and at 0831 CDT, he radioed the Hibbing fss for wx info. The fss specialist advised that the… - [NTSB DEN83LA181](https://openairdocs.org/ntsb/DEN83LA181.md): Cessna 182 · Forsyth, MT · Accident · No injuries · Limited investigation · Final report · Jul 17, 1983 · N5479B · Substantial damage > The flt originated at cambridge, id with a planned refueling stop at billings, MT. The plt stated the acft was 'topped off' at cambridge before takeoff. En route, southerly winds were encountered which drifted the acft north, so a refueling stop was made at… - [NTSB SEA83LA150](https://openairdocs.org/ntsb/SEA83LA150.md): Gulfstream American AA-1A · Sekiu, WA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N9357L · Substantial damage > The acft collided with a fence during an attempted go-around after a loss of directional control during the approach. The pilot stated that a crosswind carried the acft to the rt of the runway which necessitated the go-around. He further stated his airspeed… - [NTSB ATL83FA277](https://openairdocs.org/ntsb/ATL83FA277.md): Aero Commander 680 · Jacksonville, AL · Accident · No injuries · Field investigation · Final report · Jul 15, 1983 · N6256D · Substantial damage > Before takeoff, the acft had aprx 40 gal of fuel in the main tanks & 10 gal was added to each of the auxiliary tanks. The plt took off in hazy conditions for a short flt of apprx 10 min. While on downwind for a landing, he switched from the auxiliary to the… - [NTSB FTW83LA337](https://openairdocs.org/ntsb/FTW83LA337.md): Beech C23 · Longview, TX · Accident · No injuries · Limited investigation · Final report · Jul 13, 1983 · N60104 · Substantial damage > The acft crashed during a forced landing after the engine quit on the downwwind leg of the traffic pattern. The flt had taken off shortly before with one tank almost full and one almost empty. The fuel selector valve was found in the 'off' position after the… - [NTSB CHI83LA315](https://openairdocs.org/ntsb/CHI83LA315.md): Schweizer 1-36 · Ionia, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1983 · N36193 · Substantial damage > The glider struck the ground on the nose during the appraoac. The plt stated that nose pitch oscillations were due to his overcontrolling the glider because of his lack of experience in the glider's pitch sensitivity. - [NTSB ATL83FA271](https://openairdocs.org/ntsb/ATL83FA271.md): Piper J3C-65 · Remington, VA · Accident · Serious injuries · Field investigation · Final report · Jul 13, 1983 · N27111 · Destroyed > About 15 min after takeoff, the eng lost power while the acft was on the downwind leg for a landing on a private strip. Subsequently, the acft hit the tops of two trees, crashed & came to rest aprx 100 yards south of the rwy. An exam of the wreckage did not… - [NTSB LAX83FUA05](https://openairdocs.org/ntsb/LAX83FUA05.md): Cessna 150 · Long Beach, CA · Accident · No injuries · Final report · Jul 12, 1983 · N6554S · Substantial damage > While turning downwind in a closed pattern the eng lost power. The acft crash landed in a risidential street & struck power lines & poles. A portion of the sponge material attached to the carburetor inlet screen had become detached & lodged in the throat of… - [NTSB ATL83LA274](https://openairdocs.org/ntsb/ATL83LA274.md): Cessna 150M · Muscle Shoals, AL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1983 · N66185 · Substantial damage > The acft made a hard landing and nosed over during an attempted go-around. The acft according to the pilot was operatingat nearly max gross weight and the density alt was 2300 ft. he tried a go-around with full flaps extended. A turn was made to avoid… - [NTSB LAX83FU010](https://openairdocs.org/ntsb/LAX83FU010.md): Mitchell A-10 · Porterville, CA · Accident · 1 fatal · Final report · Jul 11, 1983 · UNREG · Destroyed > After takeoff, the plt of the ultralight vehicle climbed to an altitude of 700 ft AGL in the pattern & turned downwind. According to the plt's partner, the ultralight began a dutch roll type of maneuver, and after several oscillations, the vehicle stalled &… - [NTSB NYC83FNE04](https://openairdocs.org/ntsb/NYC83FNE04.md): Bede BD-5B · Westfield, MA · Accident · 1 fatal · Final report · Jul 10, 1983 · N83SK · Substantial damage > The acft crashed short of the rwy during an attempted landing. There were some confusing and garbled transmissions and some mistaken instructions from the tower during the problem experienced by the accident plt. This plt did not make it clear that he had an… - [NTSB CHI83LA304](https://openairdocs.org/ntsb/CHI83LA304.md): Piper PA28-140 · Middle Bass Isl, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1983 · N33544 · Substantial damage > The acft collided with wires during a go-around attempt. The pilot reported that as he approached at about 10-15 ft AGL some people walked onto the rwy. He added full power and while gaining control of the acft it collided with the wires and crashed into the… - [NTSB ATL83LA266](https://openairdocs.org/ntsb/ATL83LA266.md): Schweizer SGS-2-33A · Warrenton, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1983 · N2743H · Substantial damage > The pilot collided with a tree while landing in windy conditions. The pilot had flown one dual flt on this day and then went up for a 39 minute solo flt. Upon her return she was low on downwind so she made a close in base but drifted to theright on final in… - [NTSB MIA83FA178](https://openairdocs.org/ntsb/MIA83FA178.md): Gilbert L. Houston Moni · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Jul 8, 1983 · N64GM · Destroyed > The plt made a local flt from the indian river aerodrome to the new hibiscus arpt. According to witnesses at new hibiscus, the acft was in a nose hi attitude when they saw it turn onto base & final apch. After turning final, the acft entered a spin, turning… - [NTSB DEN83LA160](https://openairdocs.org/ntsb/DEN83LA160.md): Cessna 182C · Salt Lake City, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1983 · N8935T · Substantial damage > The acft landed short of the rwy after a power loss at about 100 ft AGL on final approach. The weather was VMC with the temperature at 80 degrees f and the dewpoint 42 degrees f. the pilot had started a let down at 11,500 ft to descend 5700FT for landing.… - [NTSB ATL83LA256](https://openairdocs.org/ntsb/ATL83LA256.md): Piper PA-25-235B · Weaver, AL · Accident · No injuries · Limited investigation · Final report · Jul 6, 1983 · N7649Z · Substantial damage > After making 5 swath runs which expended about 1/2 of his load, the plt stated his fuel gage read 5 gals. He diverted to mcminn arpt to refuel. On final the eng quit & the acft touched down in the muddy overrun. The wheels sank in the mudshearing off the main… - [NTSB NYC83LA166](https://openairdocs.org/ntsb/NYC83LA166.md): Rotec/Botsford Rally 3 · Kirkville, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1983 · N104RE · Substantial damage > The 2 place ultralight acft was on final apch to land when the propeller began to freewheel on the propeller shaft. The eng continued to operate & respond to throttle inputs, but the propeller did not produce thrust. The ultralight began to lose altitude… - [NTSB LAX83FUG16](https://openairdocs.org/ntsb/LAX83FUG16.md): Eiriavion PIK 20E · Hemet, CA · Accident · No injuries · Final report · Jul 4, 1983 · N83FU · Substantial damage > The acft made a hard landing off the runway surface after the engine lost power during a go-around. This was a motor glider and the pilot said he planned this missed approach go-around maneuver prior to his approach. At about 400 ft AGL he applied full… - [NTSB ATL83FMG02](https://openairdocs.org/ntsb/ATL83FMG02.md): Cessna 150 · Monroe, NC · Accident · Serious injuries · Final report · Jul 4, 1983 · N6728G · Destroyed > The acft crashed into trees during a night landing attempt. The student pilot was taking a friend to a grass unlighted 2200 ft airstrip for a night landing. A friend in an automobile was shining her car lights on the rwy. The pilot made anunsuccessful attempt… - [NTSB LAX83LA318](https://openairdocs.org/ntsb/LAX83LA318.md): Piper PA-28-180 · Clearlake, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N7593W · Destroyed > The acft crashed in a flat area covered with 6 ft bushes after the engine quit during a go-around. The engine had quit on the downwind and started again after the plt switched tanks. The acft was high on final and after go-around was initiated the engine quit… - [NTSB ATL83FA249](https://openairdocs.org/ntsb/ATL83FA249.md): Hamilton T-28R-2 · Martinez, GA · Accident · 2 fatal · Field investigation · Final report · Jul 2, 1983 · N182U · Destroyed > The acft was 1 of 2 that made a low pass over rwy 24. After the pass, the plt made a right turn, establishing the acft in a right traffic pattern for rwy 24. According to 1 witness, while the acft was turning on a right base, intermittent bursts of dark smoke… - [NTSB FTW83FA310](https://openairdocs.org/ntsb/FTW83FA310.md): Beech A36 · Enid, OK · Accident · 2 fatal · Field investigation · Final report · Jul 1, 1983 · N23684 · Destroyed > Prior to takeoff the plt was advised the winds were from 180 deg at 20 KTS gusting to 27 KTS. During takeoff from rwy 17THE plt advised the tower that he was 'bringing it around to land on 30.' When asked if he was experiencing any difficulties the plt… - [NTSB NYC83LA159](https://openairdocs.org/ntsb/NYC83LA159.md): Cessna 150 · Nashua, NH · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1983 · N11394 · Substantial damage > The student plt was practicing full flap landings during a solo flt. While on a final approach to land, she observed another acft taxiing on the end of the rwy. So she elected to go around. At that time, the acft was about 25 to 30 ft AGL. Reportedly, she… - [NTSB FTW83LA309](https://openairdocs.org/ntsb/FTW83LA309.md): Ercoupe 415-C · Elk City, OK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1983 · N93624 · Substantial damage > The acft landed short of the rwy during a night landing following a x-country. The plt stated that he was on the approach to land and attempted to add power. The engine sputtered without an increase in power. The acft touched down 5 ft short of the rwy… - [NTSB LAX83FA310](https://openairdocs.org/ntsb/LAX83FA310.md): Douglas DC-4-C55B · Kahului, HI · Accident · No injuries · Field investigation · Final report · Jun 29, 1983 · N300JT · Substantial damage > During arrival, a descent was begun from 8000 to 7000 ft MSL at 0151 HST. At 0155 HST, the aircrew was cleared for a visual apch from 7000 ft MSL & a rapid descent was started with 20 deg of flaps & aprx 25 inches map (manifold pressure). The acft was… - [NTSB SEA83FU005](https://openairdocs.org/ntsb/SEA83FU005.md): Pterodactyl Ascender II · Sumner, WA · Accident · 1 fatal · Final report · Jun 28, 1983 · UNREG · Destroyed > Reportedly, a father & his 14 yr old son had been receiving ground & taxi instruction, and had received 'crow-hop' practice in the previous few weeks. On 6/27/83, the vehicle became airborne with the son on board. He flew it in a pattern around the open field… - [NTSB MIA83FA168](https://openairdocs.org/ntsb/MIA83FA168.md): Beech V35A · Lehigh Acres, FL · Accident · Serious injuries · Field investigation · Final report · Jun 28, 1983 · N485B · Destroyed > According to the pilot he started to make a go around after he realized that he would not be able to stop the aircraft on the wet runway. He failed to gain sufficient altitude to clear the trees just beyond the airport boundary. He said he landed at the… - [NTSB FTW83FA299](https://openairdocs.org/ntsb/FTW83FA299.md): Aero Commander 680-F · Norman, OK · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1983 · N6139X · Destroyed > The acft crashed after starting a go-around or aborted landing at normal ok. The acft was on a x-country from dallas to wichita. There was no radio communication with the acft after it was cleared to land. The approach looked ok but on short final the acft… - [NTSB NYC83LA156](https://openairdocs.org/ntsb/NYC83LA156.md): Piper PA-28-181 · Shelter Island, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1983 · N5615V · Substantial damage > The acft crashed off the departure end of the rwy in a swamp during an attempted go-around. The pilot said the approach was normal but that the acft floated more than normal. A go-around was initiated. The pilot could not remember if the acft touched down but… - [NTSB ANC83LA105](https://openairdocs.org/ntsb/ANC83LA105.md): Piper J-3 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1983 · N87822 · Substantial damage > The pilot stated that he approached the river on final at 60 mph in a 5 degree bank to follow the curve of the water. When he dropped below trees at about 50 ft AGL the left wing stalled. He added full power and lowered the nose but the left wing hit the… - [NTSB NYC83FA157](https://openairdocs.org/ntsb/NYC83FA157.md): Cessna 150L · Hackensack, NJ · Accident · Minor injuries · Field investigation · Final report · Jun 26, 1983 · N10049 · Destroyed > According to the student's flt instructor (CFI), he (the CFI) had informed ground control that the student was going to be on his 1st solo flt & was going to fly once around the pattern. Reportedly, this radio call was made before the CFI deplaned after dual… - [NTSB NYC83LA152](https://openairdocs.org/ntsb/NYC83LA152.md): Piper PA-24-250 · Millbrook, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1983 · N6438P · Substantial damage > The plt reported that on final apch, the acft began an unexpected descent below the intended glide path. Reportedly, full power was applied to reduce the dwscent, but the acft touched down aprx 20 ft short of the rwy on an upgrade. The acft bounced in the… - [NTSB CHI83FA279](https://openairdocs.org/ntsb/CHI83FA279.md): Smith, Ted Aerostar 601A · Celina, OH · Accident · 1 fatal · Field investigation · Final report · Jun 24, 1983 · N727NM · Destroyed > When the plt arrived at the destination arpt, there was construction on the rwy, about 2500 ft from the apch end. He contacted UNICOM & was advised that the rwy was closed, but was told he could land on the grass beside the rwy. The plt responded that the… - [NTSB LAX83LA299](https://openairdocs.org/ntsb/LAX83LA299.md): Piper PA-28R-180 · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1983 · N7449J · Substantial damage > The acft made a hard landing while on an instructional flt. On the seventh approach for landing the nose gear green light did not come on. The CFI continued the approach while tapping on the bulb. When he decided to go around the acft had descended so low… - [NTSB ATL83LA239](https://openairdocs.org/ntsb/ATL83LA239.md): Cessna 150M · Ashland, VA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1983 · N63143 · Substantial damage > The acft bounced, went off the runway and nosed over during landing. The student pilot was on a supervised solo flight and was practicing touch and go landings. During this landing he made a hard landing and bounced back into the air. The student attempted to… - [NTSB ATL83FA237](https://openairdocs.org/ntsb/ATL83FA237.md): Lockheed L-18 · Millhaven, GA · Accident · 2 fatal · Field investigation · Final report · Jun 23, 1983 · N333FB · Destroyed > The acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around… - [NTSB NYC83LNC07](https://openairdocs.org/ntsb/NYC83LNC07.md): Bölkow B-1 · Groton, VT · Accident · Minor injuries · Final report · Jun 22, 1983 · N911CW · Substantial damage > The plt was on a x-country flt of aprx 100 miles. She reported that on the last leg of the flt, a lack of 'lift' was encountered & an off arpt landing was initiated. While on final apch to land in a field, the glider struck a telephone wire aprx 30 ft AGL.… - [NTSB LAX83FA295](https://openairdocs.org/ntsb/LAX83FA295.md): Cessna 172G · Huntington Bch, CA · Accident · Serious injuries · Field investigation · Final report · Jun 22, 1983 · N4655L · Destroyed > The plt-in-command (PIC) & student plt were on an aerial photography flt when the PIC noticed a loss of eng oil pressure. They saw meadowlark arpt & began an emergency apch. The PIC stated that she relinquished her PIC duties to the student because she… - [NTSB CHI83LA276](https://openairdocs.org/ntsb/CHI83LA276.md): Beech C24R · Saint Cloud, MN · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1983 · N6718M · Substantial damage > Shortly after takeoff, the plt's door came open. He tried to close it, but was unable, so he turned back toward the arpt to land. While making a turn before landing, the eng lost power. Shortly after that, the acft started falling to the right & crashed. An… - [NTSB MIA83FU004](https://openairdocs.org/ntsb/MIA83FU004.md): Eipper Quicksilver MX · Williston, FL · Accident · 1 fatal · Final report · Jun 21, 1983 · UNREG · Destroyed > The plt of the ultralight vehicle took off from an open field near his residence. Witnesses near the crash site stated that they observed the ultralight approach an open field for a landing. As the plt was in a left descending turn to the field, the… - [NTSB CHI83LA274](https://openairdocs.org/ntsb/CHI83LA274.md): Cessna 150 · Wadsworth, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1983 · N714NN · Substantial damage > The CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled. - [NTSB FTW83LA289](https://openairdocs.org/ntsb/FTW83LA289.md): Beech 95-B55 · Pineville, LA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1983 · N7712R · Substantial damage > Prior to landing, the plt moved the gear switch to the extend position & noted that the gear indicated down. However, the left main gear did not extend. While landing with the left gear retracted, the acft settled on the left wing & prop. The acft spun 180… - [NTSB NYC83FU006](https://openairdocs.org/ntsb/NYC83FU006.md): Eastern Ultralight Snoop · Norton, MA · Accident · Serious injuries · Final report · Jun 19, 1983 · UNREG · Substantial damage > The non-rated plt had purchased the ultralight vehicle about 1 month prior to the accident. He had completed aprx 8 hrs of taxi & low flts along a grass rwy. Earlier on the day of the accident, he had made 2 flts & reportedly had accumulated 1 hr of flt time… - [NTSB MIA83FU003](https://openairdocs.org/ntsb/MIA83FU003.md): Eipper Quicksilver · Lake Worth, FL · Accident · Serious injuries · Final report · Jun 19, 1983 · UNREG · Destroyed > The ultralight collided with a tree while on final approach to land in an open area. This was the pilot's first flt in an ultralight acft. He said that the accident happened when he made an improper weight shift in an effort to avoid a collision with the… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=210 ## 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=209 --- 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.