# 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 205 of 420 · 20,992 cases ## Cases, newest first - [NTSB DEN84LA059](https://openairdocs.org/ntsb/DEN84LA059.md): Cessna 172P · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Jan 1, 1984 · N65680 · Substantial damage > The acft collided with the ground after the pilot flew into a fog bank on final for runway 29R. The pilot was non-instrument rated and had not received a weather briefing or filed a flt plan. The acft was only airborne for a aboutan hour. The weather was 200… - [NTSB MKC84LA050](https://openairdocs.org/ntsb/MKC84LA050.md): Cessna 210L · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N732DZ · Substantial damage > The acft departed toronto, Canada at 1927 CST. About 5 hrs & 1 min later, the eng lost power when the plt was on final apch for landing. Subsequently, the acft collided with a vehicle & a light pole when the plt made a forced landing on a snow-covered parking… - [NTSB LAX84FA125](https://openairdocs.org/ntsb/LAX84FA125.md): Striplin SKY Ranger · Lancaster, CA · Accident · 1 fatal · Field investigation · Final report · Dec 31, 1983 · N44223 · Destroyed > The plt was participating in certification tests of the acft. Witnesses stated that the plt had made a pass down the rwy & was on the downwind leg of the traffic pattern, at abuot 100 ft AGL, when the acft suddenly pitched down & crashed. An exam of the… - [NTSB SEA84FA030](https://openairdocs.org/ntsb/SEA84FA030.md): Piper PA-34-220T · Pocatello, ID · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1983 · N8362L · Destroyed > During arrival, the plt initiated an ILS apch to rwy 2L. At that time, the wx in part was 700 ft scattered to broken, 1300 to 1500 ft overcast,visibility 1 to 1 1/2 mi with light snow & fog. About 3 min after calling inbound on the apch, the plt initiated a… - [NTSB MIA84FA053](https://openairdocs.org/ntsb/MIA84FA053.md): Cessna 210M · West Palm Beach, FL · Accident · 3 fatal · Field investigation · Final report · Dec 30, 1983 · N761HZ · Destroyed > At 1926 the plt was cleared for the LOC bc arch for rwy 27R. At 1927 the acft acknowledged a clearance to land. 10 secs later the radar target disappeared. The plt was rescued at 2050 from the waters of the atlantic ocean about 1 mioff the Beach at West Palm… - [NTSB LAX84LA124](https://openairdocs.org/ntsb/LAX84LA124.md): Piper PA-28-181 · Shoshone, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 1983 · N2534U · Substantial damage > The acft landed long and in attempting a go-around crashed off the rwy on the arpt. The plt said she made her approach to rwy 34 at Shoshone CA and touched down slightly beyond the middle of the 2380 ft rwy in no wind conditions. She then attempted a… - [NTSB LAX84AA132](https://openairdocs.org/ntsb/LAX84AA132.md): Boeing 727-224 · New York, NY · Accident · No injuries · Final report · Dec 28, 1983 · N79750 · Substantial damage > During apch the crew was advised of a windshear on final apch of +10 to -15 KTS at 700 ft & 400 ft AGL. Winds were reported 170 deg at 26 KTS gusting to 40 KTS. The plt added 20 KTS to his v-ref speed of 132 KTS & selected auto-spoilerdeployment. Prior to… - [NTSB ATL84LA076](https://openairdocs.org/ntsb/ATL84LA076.md): Piper PA-22-108 · Edgewater, MD · Accident · No injuries · Limited investigation · Final report · Dec 26, 1983 · N5276Z · Substantial damage > A student plt started to fly the acft, but as she was moving on the rwy, she detected a misfiring of the eng that she reported as a popping sound. Therefore, she returned to the ramp area & shut down the eng. Her husband agreed to fly with her around the… - [NTSB NYC84FA059](https://openairdocs.org/ntsb/NYC84FA059.md): Beech A36 · Montoursville, PA · Accident · Serious injuries · Field investigation · Final report · Dec 25, 1983 · N66846 · Destroyed > During takeoff roll the overhead courtsey light flickered. As the acft lifted off the right front cabin door opened & the light remained on. The plt advised the tower he would be returning to land & entered a right downwind leg for rwy 27AT 500 ft AGL. The… - [NTSB LAX84LA115](https://openairdocs.org/ntsb/LAX84LA115.md): de Havilland DHC 7-102 · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1983 · N929HA · No damage > While on a five mile final apch to rwy 26R the dhc 7 encountered moderate turbulence and two cabin attendants sustained injuries. At 1506:02 hours HST a western airlines DC10 requested an s turn to lose altitude in order land on rwy 26L. Seven seconds later… - [NTSB DEN84LA048](https://openairdocs.org/ntsb/DEN84LA048.md): Cessna 421B · Aspen, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 23, 1983 · N768T · Substantial damage > The acft collided with the snow to the side and short of the rwy during the approach to land. The plt said the acft was blown off line and his vision was obscured by blowing snow. The acft hit REIL lights and stopped 760 ft short of the approach end of the… - [NTSB CHI84LA065](https://openairdocs.org/ntsb/CHI84LA065.md): Beech BE-200 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N90DF · Substantial damage > While receiving vectors for an ILS apch, the acft encountered rime icing conditions. The left windshield began icing over & would not clear when the plt adjusted the windshield heat from normal to high. Since the autopilot was engaged, he moved to the right… - [NTSB ATL84LA071](https://openairdocs.org/ntsb/ATL84LA071.md): Piper PA-32-260 · Indian Head, MD · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N5685V · Substantial damage > The plt stated that shortly after departing dca, he encountered a small amount of rain that froze on the aircraft's windshield. He continued on to his destination and again encounter freezing rain when turning from base to final. He elected to make a… - [NTSB LAX84LA135](https://openairdocs.org/ntsb/LAX84LA135.md): Schweizer SGS-2-33A · Mokuleia, HI · Accident · No injuries · Limited investigation · Final report · Dec 18, 1983 · N17SH · Substantial damage > The plt was rated for airplanes & helicopters, but did not have a glider rating. He had only 2.5 hrs in gliders, all of which was in this same make & model. During a solo instructional flt, he encountered a high sink while on a base turn to land. He stated… - [NTSB LAX84LA098](https://openairdocs.org/ntsb/LAX84LA098.md): Piper PA-28-181 · Livermore, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 1983 · N4513K · Destroyed > During arrival in IFR conditions, the plt was vectored for an ILS rwy 25 apch. At about 0909 PST, he was cleared for the apch & instructed to maintain 3000 ft until intercepting the localizer. A short time later, the controller instructed the plt to contact… - [NTSB ATL84LA066](https://openairdocs.org/ntsb/ATL84LA066.md): Cessna P206A · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 1983 · N4648F · Substantial damage > The acft undershot the rwy during landing. The weather was VMC but the landing was made one hour after official sunset. Visibility was reported as 10 miles. There were no problems reported with the arpt or acft except the plt during one radio call saying he… - [NTSB NYC84FA054](https://openairdocs.org/ntsb/NYC84FA054.md): Cessna 310R · Buffalo, NY · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1983 · N87291 · Destroyed > The acft collided with lake erie during ILS approach to rwy 05 at Buffalo, NY. The acft had been descended to 3000 ft and the plt reported turning inbound from dunkirk VOR to the ILS. He was cleared for the approach and told to report the outer marker to… - [NTSB FTW84LA096](https://openairdocs.org/ntsb/FTW84LA096.md): Cessna T210N · Port Arthur, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1983 · N4894C · Substantial damage > The acft crash landed in a muddy field about 1 mile from the arpt after the engine quit on final approach to land. The acft was examined after the accident and found to have an empty left fuel tank. The right tank contained 16 gallons of fuel. The plt stated… - [NTSB NYC84FA053](https://openairdocs.org/ntsb/NYC84FA053.md): Cessna R182 · Greenwich, CT · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1983 · N2254T · Destroyed > The acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the… - [NTSB NYC84FA052](https://openairdocs.org/ntsb/NYC84FA052.md): Cessna 425 · Newburgh, NY · Accident · 1 fatal · Field investigation · Final report · Dec 12, 1983 · N6774R · Destroyed > During arrival, there were indefinite delays at white plains, NY, so the plt diverted to Newburgh, NY. He was vectored for an ILS rwy 9 apch. While en route, the plt requested & was given the ILS freq, mins for the apch, the arpt elevation(491 ft MSL), the… - [NTSB NYC84FA047](https://openairdocs.org/ntsb/NYC84FA047.md): North American NA-265-40 · Coatesville, PA · Accident · No injuries · Field investigation · Final report · Dec 12, 1983 · N3298D · Substantial damage > During an IFR arrival, an ILS apch was made to rwy 29 in rain, turbulence & gusty wings. At aprx 400 ft AGL, the acft broke out of the clouds while on the localizer glide slope. The airspeed at that time was 8 KTS above the reference speed, but was… - [NTSB MIA84FA044](https://openairdocs.org/ntsb/MIA84FA044.md): Cessna 152 · Venice, FL · Accident · 1 fatal · Field investigation · Final report · Dec 12, 1983 · N94642 · Destroyed > This was the first flt for the prospective student plt. He stated that during the second trafic pattern over the gulf, the acft appeared to hit a gust of wind, pitched up, & entered a spin. Winds were gusting 27 KTS, & severe wx was forecast & arrived later… - [NTSB ATL84MA063](https://openairdocs.org/ntsb/ATL84MA063.md): Piper PA-34-200T · Lawrenceburg, TN · Accident · 4 fatal · Major investigation · Final report · Dec 12, 1983 · N66MZ · Destroyed > During the descent at Lawrenceburg the acft went into clouds at 3500 ft. at 1709 the acft was cleared for an NDB approach. Minimum alt for the approach is 1560 ft. field elevation is 936 ft. the acft was being tracked on radar and the last contact was about… - [NTSB ANC84LA022](https://openairdocs.org/ntsb/ANC84LA022.md): Cessna C-185A · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Dec 11, 1983 · N9706H · Substantial damage > The acft struck a snowbank during an attemped go-around. According to the plt there were no mechanical problems that contributed to the accident. The plt did not submit an accident report and attempts to reach him by telephone have been unsuccessful. The… - [NTSB NYC84FHM03](https://openairdocs.org/ntsb/NYC84FHM03.md): Homebuilt Spad Xiii · Montgomery, NY · Accident · No injuries · Final report · Dec 10, 1983 · N3772L · Substantial damage > The acft lost power about 1 mile from the arpt and the plt made a forced landing on a farm. The acft nosed over. The weather conditions were conducive to carburetor icing and this acft has no provision for carburetor heat control. - [NTSB MKC84FA033](https://openairdocs.org/ntsb/MKC84FA033.md): Beech TC-45J · Kansas City, KS · Accident · 1 fatal · Field investigation · Final report · Dec 5, 1983 · N704M · Destroyed > The acft was a Beech TC-45J that had been modified into a hamilton turboliner under STC SA-1821-WE. During arrival, the plt reported that he encountered moderate icing at 4000 ft. he made a localizer-only apch to rwy 35. An ATC specialist stated that they saw… - [NTSB MIA84FA039](https://openairdocs.org/ntsb/MIA84FA039.md): Paul S. Kerr Condor III 400 · Boca Raton, FL · Accident · Serious injuries · Field investigation · Final report · Dec 3, 1983 · N39584 · Substantial damage > The instructor plt (CFI) & student were practicing apchs in a 2-place/registered ultralight with single controls. Just prior to touchdown, the CFI told the student to go around. After initiating a climb, the acft encountered turbulence. The student… - [NTSB FTW84FA082](https://openairdocs.org/ntsb/FTW84FA082.md): Cessna 310K · Hodgen, OK · Accident · 1 fatal · Field investigation · Final report · Dec 3, 1983 · N310JD · Destroyed > The plt had purchased the acft at rexburg, id on the day of the accident. Reportedly, the previous owner had flown with the plt, before the plt departed rexburg, and said he had flown the acft very well. The previous owner stated that the DME was not… - [NTSB ATL84FA059](https://openairdocs.org/ntsb/ATL84FA059.md): Beech A36 · Gulfport, MS · Accident · 3 fatal · Field investigation · Final report · Dec 3, 1983 · N36MP · Destroyed > Prior to the approach the plt was advised that the wx was sky obscured & visibility 1/4 mi in fog. The plt acknowledged 'roger we'll come on in and give it a shot.' The acft collided with trees about 500 ft short of the middle marker. It was reported that the… - [NTSB DEN84LA032](https://openairdocs.org/ntsb/DEN84LA032.md): Piper PA-32R-300 · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Nov 30, 1983 · N5802V · Substantial damage > The plt stated that the approach into Rawlins was normal but while on short final he realized that the acft was too low. The acft was actually lower then the runway which is located on a plateau. He attempted to correct but lost airspeed and landed short. The… - [NTSB NYC84FA042](https://openairdocs.org/ntsb/NYC84FA042.md): Piper PA-34-200T · Bennington, VT · Accident · Serious injuries · Field investigation · Final report · Nov 29, 1983 · N2958R · Destroyed > The acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is… - [NTSB ATL84AA053](https://openairdocs.org/ntsb/ATL84AA053.md): Beech A36 · Armuchee, GA · Accident · 6 fatal · Final report · Nov 28, 1983 · N3801N · Destroyed > The acft collided with trees and higher terrain which was adjacent to the VOR approach path. The weather was described by witnesses as stormy with heavy rains and high winds. Some of the occupants of the accident acft were airsick according to the plts radio… - [NTSB NYC84LA041](https://openairdocs.org/ntsb/NYC84LA041.md): Cessna 152 · Marlborough, MA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1983 · N5520M · Substantial damage > The acft collided with trees during final approach to land. The acft was on a short final to rwy 32 at marborough when the left wheel and left wing struck tree tops a short way from the rwy threshold. The acft turned about 70 degrees to the left and collided… - [NTSB NYC84FA039](https://openairdocs.org/ntsb/NYC84FA039.md): American AA-1A · Wellsville, PA · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1983 · N81YB · Destroyed > Prior to the flt, the plt stated that he would be flying foraprx 1/2 hr. Aprx 25 min after takeoff, ground witnesses northeast of the arpt observed the acft on a westerly heading, turning toward the arpt. Shortly after that, they saw the acft in an… - [NTSB LAX84LA076](https://openairdocs.org/ntsb/LAX84LA076.md): Burkhart Grob G-103 · California City, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1983 · N62BG · Substantial damage > According to the plt, he was turning to final approach when the glider's left wing struck the ground. Reportedly, he had gotten 'too low & slow.' - [NTSB ATL84MA052](https://openairdocs.org/ntsb/ATL84MA052.md): Beech 58TC · Knoxville, TN · Accident · 4 fatal · Major investigation · Final report · Nov 27, 1983 · N2131L · Destroyed > During arrival, the plt checked in with Knoxville apch control & stated that he was proceeding to the downtown arpt for landing. At that time, the wx at mcghee-tyson arpt (aprx 10 mi ssw) was clear with 7 mi visibility. About 10 min later, the plt reported… - [NTSB ANC84LA020](https://openairdocs.org/ntsb/ANC84LA020.md): Piper PA-18 · Fort Yukon, AK · Accident · No injuries · Limited investigation · Final report · Nov 27, 1983 · N83278 · Substantial damage > The plt was approaching a lake for landing. He came over the lake & started what became a 270 deg turn toward the landing direction. At the end of the turn he tightened up the turn & the acft stalled. - [NTSB SEA84FA023](https://openairdocs.org/ntsb/SEA84FA023.md): Cessna 304A · Ephrata, WA · Accident · Serious injuries · Field investigation · Final report · Nov 26, 1983 · N98567 · Destroyed > The acft collided with a hilltop during a missed approach in IMC weather. The acft was on an IFR flt plan. The plt stated visual contact was EST at about 2000 ft MSL but ground features were masked in snow. When the plt did not see the airport at the proper… - [NTSB FTW84MA076](https://openairdocs.org/ntsb/FTW84MA076.md): Beech B100 · Midland, TX · Accident · 8 fatal · Major investigation · Final report · Nov 26, 1983 · N1910L · Destroyed > The acft crashed while completing a charter flt that began at 1220 CST on 11/25/83 to transport a tv sports film crew. The flt began at Midland, TX & proceeded to fort worth & wichita falls, TX, then began a return flt to Midland. During arrival, the plt… - [NTSB DEN84FA030](https://openairdocs.org/ntsb/DEN84FA030.md): Cessna 414 · Aurora, CO · Accident · 2 fatal · Field investigation · Final report · Nov 23, 1983 · N7724N · Destroyed > During wx briefings the plt was advised of icing conditions in the denver area. While approaching the denver area the plt radioed 'can you get me down, it's a little bit icy up here.' The plt was subsequently asked & was given a close turn onto the outer… - [NTSB MKC84FA029](https://openairdocs.org/ntsb/MKC84FA029.md): Aerospatiale AS350D · Sweet Springs, MO · Accident · Serious injuries · Field investigation · Final report · Nov 21, 1983 · N5778X · Substantial damage > The helicopter landed hard during a forced landing after a power loss during a ferry flt. The plt stated that at about 200 ft turning on a base leg for landing he heard a loud bang and the engine failed. A witness said he heard the engine die and saw the… - [NTSB DEN84LA028](https://openairdocs.org/ntsb/DEN84LA028.md): Cessna 170B · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Nov 21, 1983 · N3747C · Substantial damage > The acft landed hard just short of the rwy after the plt exprienced icing problems in flt. The airspeed indicator stopped working in flt so the plt was attempting a landing and says he also lost engine power at about 30 ft in the air during the flare for… - [NTSB LAX84FA064](https://openairdocs.org/ntsb/LAX84FA064.md): Cessna 210 · Grass Valley, CA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1983 · N7434E · Destroyed > During arrival, the plt was cleared for a vor-a apch to the Nevada county arpt. The apch controller advised the plt that he had failed to issue the required radar info for the final apch fix & instructed the plt to initiate a missed apch. Radar contact with… - [NTSB FTW84LA071](https://openairdocs.org/ntsb/FTW84LA071.md): de Havilland DHC-1 · Orange, TX · Accident · No injuries · Limited investigation · Final report · Nov 20, 1983 · N22DH · Substantial damage > According to the plt, the eng lost power as he made a throttle adjustment in the traffic pattern while turning from downwind to base. Subsequently, he allowed the acft to stall & land hard. Short of the rwy. The origin of the malfunction was not identified. - [NTSB CHI84LA048](https://openairdocs.org/ntsb/CHI84LA048.md): Piper PA-24-250 · Norwalk, OH · Accident · No injuries · Limited investigation · Final report · Nov 20, 1983 · N6159P · Substantial damage > The acft made a hard landing while on a cross-country flt. The plt stated that he encountered turbulence below 3000 ft MSL. During the he encountered wind shear which caused him to drop 40 ft onto the rwy. The acft manual states that 'in high wind conditions… - [NTSB NYC84LA034](https://openairdocs.org/ntsb/NYC84LA034.md): Cessna 150 · Shirley, NY · Accident · No injuries · Limited investigation · Final report · Nov 19, 1983 · N704MQ · Substantial damage > The acft collided with the ground during an aborted go-around. This was a supervised solo flt for practice touch and go landings. During the 1st landing attempt the plt flared too high and decided to go-around. Full power was added and as the pilot moved her… - [NTSB FTW84LA066](https://openairdocs.org/ntsb/FTW84LA066.md): Grumman AA-5A · Addison, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1983 · N26242 · Substantial damage > The plt reported that during an ILS apch to land, the eng lost power when the acft was about 1/4 mi from the threshold. He stated that he 'confirmed mixture rich, carb heat on, fuel pump on, fuel fullest tank.' The plt was unable to restart the eng. During an… - [NTSB NYC84LA031](https://openairdocs.org/ntsb/NYC84LA031.md): Beech B23 · West Dover, VT · Accident · No injuries · Limited investigation · Final report · Nov 18, 1983 · N7605R · Substantial damage > The plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still… - [NTSB CHI84LA045](https://openairdocs.org/ntsb/CHI84LA045.md): Mooney M-20K · Buffalo, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 18, 1983 · N9644B · Substantial damage > The acft collided with trees during an approach on a dark night. The weather was VMC and the plt canceled his IFR flt plan 15 miles east of the arpt. The plt approached the arpt in a normal VFR pattern but on final approach he got an illusion from the lights… - [NTSB ATL84FA044](https://openairdocs.org/ntsb/ATL84FA044.md): Piper PA-31-300 · Charlotte, NC · Accident · 1 fatal · Field investigation · Final report · Nov 15, 1983 · N6459L · Destroyed > The acft was first radar identified about 18 mi north of the arpt & was given radar vectors for a right downwind & base to rwy 36R. While on a downwind heading 150 deg, the plt was assigned a heading of 270 deg & was queried if the arpt wasin sight. The plt… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=206 ## 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=205 --- 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.