# 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 174 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL88FA073](https://openairdocs.org/ntsb/ATL88FA073.md): Cessna P210N · Huntsville, AL · Accident · Serious injuries · Field investigation · Final report · Jan 3, 1988 · N6438W · Destroyed - [NTSB DEN88LA041](https://openairdocs.org/ntsb/DEN88LA041.md): Piper PA-18-125 · Riverton, WY · Accident · Serious injuries · Limited investigation · Final report · Dec 26, 1987 · N211T · Substantial damage > The instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an… - [NTSB ATL88FA069](https://openairdocs.org/ntsb/ATL88FA069.md): Cessna 172M · Warner-Robins, GA · Accident · Serious injuries · Field investigation · Final report · Dec 26, 1987 · N13609 · Substantial damage > The non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually… - [NTSB ATL88FA068](https://openairdocs.org/ntsb/ATL88FA068.md): Piper PA-28RT-201 · Rutherfordton, NC · Accident · 4 fatal · Field investigation · Final report · Dec 25, 1987 · N2869C · Destroyed > The pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.… - [NTSB LAX88LA076](https://openairdocs.org/ntsb/LAX88LA076.md): Cessna 210K · Chowchilla, CA · Accident · No injuries · Limited investigation · Final report · Dec 24, 1987 · N8221M · Substantial damage > During a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the… - [NTSB MKC88FA032](https://openairdocs.org/ntsb/MKC88FA032.md): Cessna 402C · Chadron, NE · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1987 · N105GP · Destroyed > The acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the… - [NTSB MIA88IA068](https://openairdocs.org/ntsb/MIA88IA068.md): Beech 99 · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Dec 21, 1987 · N6724D · Minor damage > The commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.… - [NTSB LAX88LA072](https://openairdocs.org/ntsb/LAX88LA072.md): Cessna 172 · Fallbrook, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 20, 1987 · N7970B · Destroyed > The plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy… - [NTSB FTW88FA038](https://openairdocs.org/ntsb/FTW88FA038.md): Piper PA-28R-200 · Burnet, TX · Accident · 1 fatal · Field investigation · Final report · Dec 19, 1987 · N33007 · Destroyed > The pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL… - [NTSB MKC88LA030](https://openairdocs.org/ntsb/MKC88LA030.md): Cessna 150H · Siloam Springs, AR · Accident · No injuries · Limited investigation · Final report · Dec 18, 1987 · N23303 · Substantial damage > When the airplane was on downwind, the pilot thought he was pulling on the carburetor heat. The pilot attempted to apply power on final and found the engine was windmilling. The pilot found he had pulled the mixture instead of the carburetor heat. During the… - [NTSB BFO88FA010](https://openairdocs.org/ntsb/BFO88FA010.md): Swearingen SA-226 · Chantilly, VA · Accident · Serious injuries · Field investigation · Final report · Dec 18, 1987 · N23AZ · Substantial damage > The acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use… - [NTSB FTW88LA040](https://openairdocs.org/ntsb/FTW88LA040.md): Hughes 269A-1 · Eldorado, TX · Accident · No injuries · Limited investigation · Final report · Dec 17, 1987 · N8945F · Substantial damage > While the pilot was attempting to land in a clearing, the main rotor blades contacted a tree causing the aircraft to descend uncontrolled for about 40 feet. The helicopter struck the ground in a nose low attitude causing damage to the skids, bubble, rotor… - [NTSB MKC88FA027](https://openairdocs.org/ntsb/MKC88FA027.md): British Aerospace BAE-3101 · Joplin, MO · Accident · Serious injuries · Field investigation · Final report · Dec 14, 1987 · N331PX · Destroyed > The capt stated that he had planned the approach at a higher-than-normal airspeed and altitude due to a reported low level windshear. At 400 feet AGL the acft entered a light downdraft but the crew corrected the descent profile with power. At 200 feet AGL the… - [NTSB ATL88LA057](https://openairdocs.org/ntsb/ATL88LA057.md): Beech D35 · Monroe, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 1987 · N3441B · Substantial damage > The Beech D35 was landing at a private airstrip from which it had departed fifteen minutes earlier. The final approach was to the south, into the sun. On short final the pilot looked down to verify that the gear was down. He looked outside again just in time… - [NTSB ANC88FA019](https://openairdocs.org/ntsb/ANC88FA019.md): Cessna 402B · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Dec 9, 1987 · N969JW · Substantial damage > Drg arr in hvy traffic, reeve flt 726 (Boeing 727) & wilburs flt 304 (Cessna 402B, N969JW) recd radar adzys for visual apchs to rwys 6L & 6R, respectively. Subsequently, both flts were clrd to lnd. At 1555:04, the LCL twr ctlr transmitted that the wnd at the… - [NTSB FTW88FA036](https://openairdocs.org/ntsb/FTW88FA036.md): Bell 412 · Galveston, TX · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1987 · N3910U · Destroyed > The acft landed hard in the gulf of Mexico during an autorotation that was entered following the separation of the 90 degree gearbox. The gearbox (with tail rotor blades) separated due to an imbalance. However, the gearbox was not recovered during the… - [NTSB FTW88FA035](https://openairdocs.org/ntsb/FTW88FA035.md): Lockheed 250 TRI-GEAR · Dallas, TX · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1987 · N400NY · Destroyed > The right engine of the aircraft failed three times in flight. After the last failure near the middle marker the pilot feathered the propeller. The aircraft collided with power lines and the ground about 400 yards short of runway 31 at the redbird airport.… - [NTSB DEN88FA033](https://openairdocs.org/ntsb/DEN88FA033.md): Piper PA-28R-200 · San Jose, CA · Accident · 3 fatal · Field investigation · Final report · Dec 5, 1987 · N9309N · Destroyed > Several min after takeoff, the plt noted a loss of oil pressure & elected to return to the arpt. As he was returning, the eng began to overspeed, but he controlled the RPM by retarding the throttle. The wind was from 150 deg at 10 KTS. The plt was clrd to… - [NTSB FTW88IA037](https://openairdocs.org/ntsb/FTW88IA037.md): Boeing 727-243 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Dec 3, 1987 · N571PE · Minor damage > Improper drilling of the cross hole in the slat track bearing bolt, which led to its failure from fatigue cracking. - [NTSB MIA88LA050](https://openairdocs.org/ntsb/MIA88LA050.md): Cessna A185F · Naples, FL · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N60925 · Substantial damage > The plt stated that the flt was low and slow on final apch. As a result the main landing gear collided with a dirt bank located short of the rwy. The gear then collapsed and the acft slid to a stop. - [NTSB LAX88LA063](https://openairdocs.org/ntsb/LAX88LA063.md): Cessna 177 · San Carlos, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1987 · N2313Y · Substantial damage > The plt added pwr on final approach and later stated that the eng seemed to be losing pwr. He said he noticed that the fuel selector was l of ctr abt 1/2 inch, ctrd it and added carb heat, however the eng still quit. The acft was too low to land on the rwy so… - [NTSB ATL88LA047](https://openairdocs.org/ntsb/ATL88LA047.md): Piper PA-28-181 · Northport, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 1987 · N8121T · Substantial damage > Before reaching the arpt, the eng lost power. Subsequently, the acft was damaged during an emerg landing on an embankment about 1.5 mi short of rwy 29. Only about 1 cup of fuel was found in each fuel tank. The plt thought there was about 12 gal of fuel… - [NTSB SEA88LA025](https://openairdocs.org/ntsb/SEA88LA025.md): Piper PA-22-108 · Cornelius, OR · Accident · No injuries · Limited investigation · Final report · Nov 27, 1987 · N4523Z · Substantial damage > The pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The… - [NTSB LAX88FA058](https://openairdocs.org/ntsb/LAX88FA058.md): Cessna T210N · Fullerton, CA · Accident · Minor injuries · Field investigation · Final report · Nov 27, 1987 · N7627N · Destroyed > While on final appr to runway 24 at Fullerton arpt, the pilot experienced a total engine power loss. The airplane's alt was insufficient to land on the runway & the plt elected to land in an open area adjacent to the arpt. The airplane's left wing collided… - [NTSB ATL88FA046](https://openairdocs.org/ntsb/ATL88FA046.md): Cessna 152 · Oliver Springs, TN · Accident · 1 fatal · Field investigation · Final report · Nov 27, 1987 · N98BS · Destroyed > The plt had deptd from a small airport nr kingston, TN mid afternoon and had landed at another about 30 nmi to the NE. He remained on the ground 30-45 min departing between 1530-1545. According to info gathered, the aircraft was observed to fly over the oak… - [NTSB NYC88FA045](https://openairdocs.org/ntsb/NYC88FA045.md): Cessna T210N · Skaneateles, NY · Accident · 4 fatal · Field investigation · Final report · Nov 26, 1987 · N5136Y · Destroyed > Prior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to… - [NTSB DEN88LA028](https://openairdocs.org/ntsb/DEN88LA028.md): Cessna 150L · Aberdeen, SD · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N1380Q · Substantial damage > The private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported… - [NTSB DCA88MA005](https://openairdocs.org/ntsb/DCA88MA005.md): Beech 1900C · Homer, AK · Accident · 18 fatal · Major investigation · Final report · Nov 23, 1987 · N401RA · Destroyed > Drg arr, the acft (ryan flt 103) crashed short of rwy 3. The fuselage stayed intact drg impact, but the belly structure was compressed & vertical deceleration forces exceeded the design capability of the seats. Rescue psnl had difficulty shutting off the… - [NTSB ATL88LA042](https://openairdocs.org/ntsb/ATL88LA042.md): Cessna 182C · Hazel Green, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 1987 · N8504T · Substantial damage > The airplane hit a tree and crashed about 300 yds short of the rwy while on final appch to land. The plt indicated that he became preoccupied with the airspeed indicator and allowed the airplane to descend below the proper glide path. The plt had less than 1… - [NTSB MKC88FA019](https://openairdocs.org/ntsb/MKC88FA019.md): Piper PA-32R · Fayetteville, AR · Accident · 2 fatal · Field investigation · Final report · Nov 20, 1987 · N3578G · Destroyed > The airplane was cleared to land while on downwind. Tower saw lights and said airplane appeared to be flying around hill north of airport. Investigation revealed airplane had turned left and impacted trees below the top of the hill. - [NTSB CHI88LA028](https://openairdocs.org/ntsb/CHI88LA028.md): Bellanca 7GCAA · Belle Plaine, MN · Accident · No injuries · Limited investigation · Final report · Nov 19, 1987 · N2716Z · Substantial damage > After the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in… - [NTSB NYC88LA043](https://openairdocs.org/ntsb/NYC88LA043.md): Piper PA-32-300 · Montoursville, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 16, 1987 · N9055F · Destroyed > After takeoff, the plt remained in the traffic pattern to practice takeoffs & landings. He made a touch-&-go, then rprtd on a right downwind for another landing. He acknowledged a clearance to continue, but moments later, an ELT signal began transmitting.… - [NTSB MIA88LA038](https://openairdocs.org/ntsb/MIA88LA038.md): Piper PA-28RT-201 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1987 · N539FT · Substantial damage > During an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear… - [NTSB NYC88LA037](https://openairdocs.org/ntsb/NYC88LA037.md): Piper PA-28-140 · Jeannette, PA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1987 · N8450F · Substantial damage > The aircraft suffered an engine failure during approach and crashed short and to the right of the runway. The acft then nosed over. Post acc investigation and engine exam by the FAA revealed no reason for the eng malfunction. - [NTSB SEA88LA018](https://openairdocs.org/ntsb/SEA88LA018.md): Piper PA-24-400 · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Nov 11, 1987 · N400TT · Substantial damage > The plt was attempting to land close to the approach end of the rwy. He made the approach with full flaps at 85 mph the rate of descent became excessive and before recovery was affected the acft collided with a fence near the rwy threshold. The acc site was… - [NTSB FTW88LA026](https://openairdocs.org/ntsb/FTW88LA026.md): Piper PA-18-150 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Nov 11, 1987 · N876Q · Substantial damage > The plt reported that the acft was no. 3 in the pattern for landing on rwy 17. He said carb heat was applied on downwind and eng power was used until the acft was on a 3 mi final. At that point pwr was reduced and a glide was established. A short time later… - [NTSB LAX88LA036](https://openairdocs.org/ntsb/LAX88LA036.md): Cessna 150F · Carmel Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 1987 · N6920F · Substantial damage > The plt & passenger were on a flt to an arpt with a 2475' rwy & a displaced threshold of 665'. The plt rprtd that when he entered the apch to lnd on rwy 11, the acft was higher than necessary. He contd the apch, but when the acft had not touched down, after… - [NTSB ATL88FA032](https://openairdocs.org/ntsb/ATL88FA032.md): Beech 95C-55 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Nov 9, 1987 · N616G · Substantial damage > Acft was being positioned to begin cargo revenue flt. As acft turned final and ldg gear handle was put in down position PIC noted dimming of all lights & communications were lost. PIC unaware gear were still retracted until prop tips contacted rwy. During… - [NTSB NYC88LA034](https://openairdocs.org/ntsb/NYC88LA034.md): Cessna 170B · Shirley, MA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1987 · N8128A · Substantial damage > During final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back. - [NTSB FTW88FA024](https://openairdocs.org/ntsb/FTW88FA024.md): Cessna 140 · Bryan, TX · Accident · Serious injuries · Field investigation · Final report · Nov 8, 1987 · N72137 · Destroyed > The student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch… - [NTSB CHI88LA019](https://openairdocs.org/ntsb/CHI88LA019.md): Cessna 150H · Cumberland, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1987 · N6501S · Destroyed > At 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could… - [NTSB CHI88LA020](https://openairdocs.org/ntsb/CHI88LA020.md): Cessna 152 · New Hudson, MI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1987 · N46065 · Substantial damage > The student pilot was on his first solo flight. Before turning onto final approach to land, he noticed another aircraft ahead, already on final approach. The student decided to s-turn for spacing, but while maneuvering, altitude was lost. Subsequently, he saw… - [NTSB ATL88LA030](https://openairdocs.org/ntsb/ATL88LA030.md): Hiller UH-12B · Newnan, GA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1987 · N922TE · Substantial damage > The tail rotor 90 degree gearbox mounting flange fractured during apch to land, while the helicopter was at about 75 ft AGL. The gearbox subsequently separated from the helicopter. The plt initiated an autorotation. The helicopter rolled over on ldg.… - [NTSB MIA88LA026](https://openairdocs.org/ntsb/MIA88LA026.md): Learjet 35A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Nov 4, 1987 · N888DJ · Substantial damage > The acft made a hard ldg during heavy rain & after being advised of wind shear. The crew stated that at one point, the acft was thrown into a 60 deg bank with airspeed fluctuations plus or minus 20 KTS about 400 to 600 ft AGL. The plt stated that at 100 to… - [NTSB NYC88LA026](https://openairdocs.org/ntsb/NYC88LA026.md): Piper PA-22-108 · Argyle, NY · Accident · No injuries · Limited investigation · Final report · Nov 1, 1987 · N5502Z · Substantial damage > The flight was returning to cheney farm field for landing when the pilot came in too high and fast. He added power, banked left and started a go around. At this time the engine backfired and started missing. During the emergency landing in a pasture the… - [NTSB NYC88LA021](https://openairdocs.org/ntsb/NYC88LA021.md): Taylorcraft F21B · Montgomery, NY · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 1987 · N4419C · Destroyed > The aircraft was on approach for landing on runway 26 at orange county airport. However the aircraft collided with a tree about 200 yards from the runway threshold just outside of the airport boundary. - [NTSB FTW88LA022](https://openairdocs.org/ntsb/FTW88LA022.md): Cessna 150 · San Angelo, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1987 · N3449J · Substantial damage > While on a long final approach the aircraft ran out of fuel. The pilot made a forced landing in a field. During landing roll the nose gear collapsed, the main landing gear came off, and both wings were damaged. The pilot stated that he could have avoided the… - [NTSB MIA88LA021](https://openairdocs.org/ntsb/MIA88LA021.md): Parrish Dragonfly · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1987 · N41GK · Substantial damage > While on short final approach the flight encountered a wind gust which caused the left canard to drop. The landing gear on the left canard then struck the raised lip of the runway causing substantial damage. The aircraft came to rest on the runway. - [NTSB MIA88IA020](https://openairdocs.org/ntsb/MIA88IA020.md): Boeing 727-214 · St Croix · Incident · No injuries · Incident investigation · Final report · Oct 28, 1987 · N375PA · 2 aircraft · No damage > Paa flt was on visual apch and in contact with apch control who informed flt of two acft ahead also on visual apch. The controller offered vectors to clear traffic. Paa flt elected to continue current heading. The two preceding acft were on twr freq giving… - [NTSB DEN88FA016](https://openairdocs.org/ntsb/DEN88FA016.md): Beech A-36 · Mitchell, SD · Accident · 3 fatal · Field investigation · Final report · Oct 26, 1987 · N1257E · Destroyed > The acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=175 ## 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=174 --- 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.