# 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 198 of 420 · 20,992 cases ## Cases, newest first - [NTSB CHI85LA015](https://openairdocs.org/ntsb/CHI85LA015.md): Piper PA-16 · St. Cloud, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 1984 · N5221H · Substantial damage > The plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around. - [NTSB ATL85LA010](https://openairdocs.org/ntsb/ATL85LA010.md): Robinson R22 · Hueytown, AL · Accident · No injuries · Limited investigation · Final report · Oct 13, 1984 · N90218 · Destroyed > The acft crashed into a river while on final approach to land. The plt reported that he allowed engine RPM to drop and at the same time applied collective pitch. The acft struck the water in a steep descent. There was no report of any failures or malfunctions. - [NTSB ATL85FA008](https://openairdocs.org/ntsb/ATL85FA008.md): Cessna 150L · Cumming, GA · Accident · Serious injuries · Field investigation · Final report · Oct 11, 1984 · N1415Q · Destroyed > The arpt manager observed the acft start a go-around about 2 ft above the rwy with full wing flaps extended. Flaps remained full down as the acft attempted to climb before colliding with trees aprx 1/4 mi from the arpt. According to the plt, the go-around was… - [NTSB ATL85LA004](https://openairdocs.org/ntsb/ATL85LA004.md): Bellanca 7GCBC · Ozark, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1984 · N5065Z · Substantial damage > The student plt was on her fourth supervised solo flt. During the ground roll of her fourth landing the acft started to go left of the rwy centerline. The plt said she over corrected twice and ended up heading off the rwy toward a ditch. Inan attempt to… - [NTSB DEN85LA005](https://openairdocs.org/ntsb/DEN85LA005.md): Piccard AX6W · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1984 · N47DP · Minor damage > Plt stated he observed the wire about 3 secs before collision. Electrical short circuit severed load cables to basket, which fell to the ground, causing personnel injuries. Balloon envelope drifted away, finally coming to rest 150 mi from accident site. - [NTSB NYC85LA008](https://openairdocs.org/ntsb/NYC85LA008.md): Grumman American AA5A · Corinth, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1984 · N26759 · Substantial damage > During an aprx 45 min flight the plt became disoriented and flew an apch to a sod area that he mistakenly identified as his desired dest. During the apch the acft contacted wires causing the acft to descend out of control into a river. - [NTSB NYC85LA004](https://openairdocs.org/ntsb/NYC85LA004.md): Cessna 150H · Batavia, NY · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N50157 · Destroyed > Plt stated en route time was longer than anticipated. On arrival at destination, deep dusk conditions combined with haze, restricted ground reference cues. In addition, plt stated he misread the altimeter. Acft collided with trees 1 mile short of runway. Plt… - [NTSB CHI85FA005](https://openairdocs.org/ntsb/CHI85FA005.md): Cessna 310C · Allegan, MI · Accident · 1 fatal · Field investigation · Final report · Oct 7, 1984 · N9715Z · Destroyed > The non inst non multi-eng rated pvt plt/owner occupied the rt seat & employed the CFI for ferrying the newly purchased acft. From the start, the flt experienced comm difficulties & a compass system malfunction problem. ARTCC transcripts reveal that ATC was… - [NTSB ATL85FID01](https://openairdocs.org/ntsb/ATL85FID01.md): Cessna 172M · Norfolk, VA · Accident · Serious injuries · Final report · Oct 4, 1984 · N70554 · Substantial damage > The plt was making his landing apch behind a Boeing 727 and in front of a Boeing 737. Plt was requested by ATC to make a short apch but was also cautioned about wake turbulence. On final apch at aprx 50 ft AGL, N70554 rolled sharply into a 90 deg bank,… - [NTSB ATL85LA002](https://openairdocs.org/ntsb/ATL85LA002.md): Cessna 150L · So.Charleston, WV · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N10931 · Substantial damage > Shortly after takeoff while on the base leg at 900 ft AGL, the engine quit. Plt stated attempts to restart the engine failed. During the forced landing apch the acft collided with trees and a high tension wire. The acft spun around 180 deg and came to rest on… - [NTSB FTW85LA003](https://openairdocs.org/ntsb/FTW85LA003.md): Cessna 172 · Luling, LA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1984 · N5360D · Substantial damage > The plt stated that on final approach a gust of wind carried the acft to the right of the runway. Acft right wing struck a tree. Acft yawed right and contacted ground in uncontrolled flight. - [NTSB FTW84LA411](https://openairdocs.org/ntsb/FTW84LA411.md): Cessna 152 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Sep 30, 1984 · N64902 · Substantial damage > Student plt departed on supervised solo cross-country flt to specific destination and return. Instead, plt landed at unimproved field without required prior operator approval and embarked his wife as a passenger for a local flight. On return from local flt, a… - [NTSB ANC84FA194](https://openairdocs.org/ntsb/ANC84FA194.md): Piper PA-18 · Wasilla, AK · Accident · Serious injuries · Field investigation · Final report · Sep 30, 1984 · N1260A · Substantial damage > Acft contacted pine trees while turning base to final apch to land. Plt stated all he remembers is trying to activate the plt controlled rwy lights but never seeing them illuminate. Another plt who landed just prior to N1260A'S attempt stated the airstrip was… - [NTSB MIA84LA264](https://openairdocs.org/ntsb/MIA84LA264.md): Cessna 152 · La Belle, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1984 · N65457 · Substantial damage > The student plt was making a go-around because of a wind gust and said he added 'some power' and retracted the flaps butthe acft continued to drift left until it collided with the trees to the left of the rwy at about midfield. - [NTSB ANC84LA193](https://openairdocs.org/ntsb/ANC84LA193.md): Cessna 185 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1984 · N70123 · Substantial damage > Plt was returning to departure point because of poor wx and darkness. During apch plt could not clearly see landing area. Attempted go-around. Plt stated acft settled into bushes and was yawed into trees because he let too much airspeed bleed off. - [NTSB DEN84LA299](https://openairdocs.org/ntsb/DEN84LA299.md): Cessna T207A · Mexican Hat, UT · Accident · No injuries · Limited investigation · Final report · Sep 25, 1984 · N75870 · Substantial damage > Plt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed… - [NTSB ATL84FLT15](https://openairdocs.org/ntsb/ATL84FLT15.md): Piper PA-28-181 · Jackson, TN · Accident · No injuries · Final report · Sep 25, 1984 · N8325V · Substantial damage > During a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right… - [NTSB NYC84LA321](https://openairdocs.org/ntsb/NYC84LA321.md): Beech 58F · Titusville, PA · Accident · No injuries · Limited investigation · Final report · Sep 24, 1984 · N72053 · Destroyed > Plt stated that during final approach with a right quartering crosswind, the acft passed an opening in the trees to the right (former intersecting runway) and the sudden increase in crosswind component caused the acft to drift left. Plt stated he elected to… - [NTSB MKC84LA284](https://openairdocs.org/ntsb/MKC84LA284.md): Cessna 150 · Campbell, MO · Accident · No injuries · Limited investigation · Final report · Sep 24, 1984 · N222RF · Substantial damage > Plt stated that the acft was low on final apch and full pwr was added to go-around. The acft continued to settle until it contacted the rwy. The acft traveled off the left side of the rwy. After continuing through grass the acft contacted a steel angle iron… - [NTSB CHI84FA402](https://openairdocs.org/ntsb/CHI84FA402.md): Cessna 152 · Wheeling, IL · Accident · Serious injuries · Field investigation · Final report · Sep 24, 1984 · N757ZG · Destroyed > Witnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student… - [NTSB ATL84MA296](https://openairdocs.org/ntsb/ATL84MA296.md): Piper PA-31T3 · Atlanta, GA · Accident · Serious injuries · Major investigation · Final report · Sep 24, 1984 · N9193Y · Substantial damage > The normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to… - [NTSB NYC84LA320](https://openairdocs.org/ntsb/NYC84LA320.md): Aerospatiale SA-360C · New York, NY · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N49533 · Substantial damage > During approach to heliport, the plt heard two loud 'pops' from the engine. The plt activated the emergency floats and continued the approach. The plt stated that the 'popping', recognized as a compressor stall started again on final. He lowered the… - [NTSB NYC84FA319](https://openairdocs.org/ntsb/NYC84FA319.md): Sikorsky S-76A · Unionville, PA · Accident · Serious injuries · Field investigation · Final report · Sep 22, 1984 · N79K · Substantial damage > On approach, acft yawed right. Plt reduced power and executed emerg lndg. Before shutdown, it was noted the t/r was stationary while the main rotor continued to turn. Investigation revealed t/r drive shaft had separted due to thermal/mechanical damage… - [NTSB FTW84LA406](https://openairdocs.org/ntsb/FTW84LA406.md): Cessna 182A · Sand Springs, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1984 · N2000G · Destroyed > Acft was on final apch to land on return leg of x-country when eng began running rough and subsequently quit. Acft contacted trees short of the rwy. Plt stated a ttl of 5 gallons of fuel were drained from both fuel tanks collectively after the accident.… - [NTSB DEN84FA300](https://openairdocs.org/ntsb/DEN84FA300.md): Beech V35 · Missoula, MT · Accident · 3 fatal · Field investigation · Final report · Sep 21, 1984 · N3736Q · Destroyed > On sept 21, 1984, a Beech 35, N3736Q crashed into the side of a mountain 16 miles NE of Missoula, MT while on a VOR/DME8INSTRUMENT approach. The plt reported icing, turbulence, and intermittant vor-dme reception. The last reported altitude by the plt was 8500… - [NTSB MKC84LA280](https://openairdocs.org/ntsb/MKC84LA280.md): Piper PA-28R-200 · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1984 · N155DH · Substantial damage > Acft was on VFR final approach following a practice instrument flight. Commercial pilot with instrument rating in left seat flew instrument portion of flight and declined offer to land from instructor in right seat due to her lack of proficiency. On final… - [NTSB ATL84FA292](https://openairdocs.org/ntsb/ATL84FA292.md): Mooney M20J · Lanett, AL · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1984 · N201RT · Destroyed > Communications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds… - [NTSB NYC84FA314](https://openairdocs.org/ntsb/NYC84FA314.md): Piper PA-32R-300 · Linden, NJ · Accident · 6 fatal · Field investigation · Final report · Sep 17, 1984 · N478KT · Destroyed > Acft collided with utility pole during a night visual lndg. The pole is located about 583' from the rwy threshold and is 58' high. The pole was unmarked. The plt made 1 previous night lndg. At the arpt and 5 total lndgs at the arpt. The investigation did not… - [NTSB LAX84LA485](https://openairdocs.org/ntsb/LAX84LA485.md): Bellanca 17-30A · Bishop, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 1984 · N14728 · Substantial damage > The plt of the Bellanca said he saw a sailplane in front of him in the traffic pattern and pulled up to avoid a collision. The Bellanca stalled and even though it was partially recovered 500 ft before ground contact, the plt said he cut the engine and landed… - [NTSB ANC84FA175](https://openairdocs.org/ntsb/ANC84FA175.md): Cessna 180 · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Sep 17, 1984 · N9339C · Destroyed > The plt reported a ttl loss of power after being cleared to land on rwy 33 at merrill field. The acft contacted trees, a moving vehicle on 15th ave and an 8 ft high arpt fence during the forced landing. Examination of the acft eng failed to disclose any… - [NTSB MIA84LA255](https://openairdocs.org/ntsb/MIA84LA255.md): Piper PA-24-250 · Rockledge, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N7431P · Destroyed > The acft collided with a mound of dirt while executing a go-around at a private airstrip. The plt stated he selected rwy 27 based on winds reported at another airport and when the acft touched down about mid-point of the strip, 'I retracted flaps and applied… - [NTSB ATL84LA288](https://openairdocs.org/ntsb/ATL84LA288.md): Cessna 182 · Waynesboro, VA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N3257U · Substantial damage > The pilot stated that while on final approach the aircraft encountered a downdraft and was forced down short of the runway. Pilot suggested that he may have also encountered possible wind shear. - [NTSB ATL84LA287](https://openairdocs.org/ntsb/ATL84LA287.md): Cessna 152 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N757DN · Substantial damage > The plt departed deland, FL, for Columbus, GA, with an intended fuel stop at americus, GA. While en route from deland to americus the ceiling became lower than forecast and the plt made the decision to fly at 8500 ft MSL staying above the cloud layer. With… - [NTSB MIA84FA253](https://openairdocs.org/ntsb/MIA84FA253.md): Piper PA-28-161 · Culebra, PR · Accident · Serious injuries · Field investigation · Final report · Sep 15, 1984 · N2225Y · Destroyed > The plt was advised by other plts that a missed approach was not possible at this arpt on rwy 31. All other plts in the group landed on rwy 13. The accident plt elected 31 until he was on final with a tailwind and then started a go-around. The rising terrain… - [NTSB FTW84FA393](https://openairdocs.org/ntsb/FTW84FA393.md): Bell 206B II · Dallas, TX · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1984 · N49615 · Substantial damage > Acft made forced autorotative landing off arpt in a residential area which was congested. Acft developed a high sink rate in the autorotation and landed hard. The forced landing was due to fuel exhaustion. 45 gallons of fuel were added to the acft at 1226 CST… - [NTSB ATL84FA286](https://openairdocs.org/ntsb/ATL84FA286.md): Piper 602P · Dayton, TN · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1984 · N6897L · Destroyed > On arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen… - [NTSB FTW84LA388](https://openairdocs.org/ntsb/FTW84LA388.md): Cessna T210M · Austin, TX · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N761VP · Substantial damage > During arrival, the plt reduced power on base leg for for a landing. When he realized his airspeed was dissipating faster than normal, he advanced the throttle, but the eng did not respond. The plt then switched fuel tanks, turned on the boost pump & applied… - [NTSB SEA84LA225](https://openairdocs.org/ntsb/SEA84LA225.md): Cessna 150 · Bandon, OR · Accident · No injuries · Limited investigation · Final report · Sep 10, 1984 · N111HT · Substantial damage > The plt indicated that 15 minutes had been flown on the full fuel tank prior to the accident flight. The plt departed at 1330 on a siteseeing flt around the local area. After 3.7 hrs of flight, while on final approach to rwy 34, the engine quit. The plt… - [NTSB MKC84FA272](https://openairdocs.org/ntsb/MKC84FA272.md): Cessna 195A · Akron, IA · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1984 · N19JW · 2 aircraft · Destroyed > N19JW, a Cessna 195A and N8783X, a Cessna 182 departed mapleton, IA, at aprx 0805 on a VFR flt to Akron, IA, to attend a fly-in breakfast. The two acft did not travel the same route of flight to Akron, N19JW crossed over the midpoint of the arpt on crosswind… - [NTSB FTW84LA383](https://openairdocs.org/ntsb/FTW84LA383.md): Cessna 140A · San Antonio, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1984 · N5643C · Substantial damage > The plt attempted to land on an upsloping rwy with a quartering tailwind. Plts who landed just before the accident reported downdrafts and a strong x-wind experienced during the apch. During the go-around the airspeed decreased to 40 mph as the acft flew over… - [NTSB FTW84FA382](https://openairdocs.org/ntsb/FTW84FA382.md): Cessna 172N · Quinlan, TX · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1984 · N46ER · Destroyed > A witness reported that when the plt was landing, the acft descended on final apch, got too low & collided with electric power lines. The acft then nosed down & impacted the ground in a steep nose down attitude. - [NTSB CHI84LA384](https://openairdocs.org/ntsb/CHI84LA384.md): Harris Goldwing · Greenville, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 1984 · N3958C · Substantial damage > Plt was performing touch and go landings below 1100 ft overcast sky. Passing north end of field at 800 ft, plt noted rain shower at south end & elected to land to the south. During apch turn the left wing dropped abruptly to a near-inverted acft attitude. Plt… - [NTSB FTW84LA381](https://openairdocs.org/ntsb/FTW84LA381.md): Brantly Helicopter B-2B · Alvin, TX · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N2161U · Destroyed > The helicopter experienced an unexplained power loss. An emergency landing was attempted but the helicopter collided with a ditch. Lacking sufficient rotor RPM for efective control the helicopter nosed over. The plt was mailed an NTSB 6120.1 form to complete… - [NTSB ANC84FA166](https://openairdocs.org/ntsb/ANC84FA166.md): Piper PA-18-150 · Pilot Point, AK · Accident · 1 fatal · Field investigation · Final report · Sep 3, 1984 · N4012Z · Substantial damage > Acft departed denai, AK, at 0730 AKDT. When manuevering for a landing apch on dog salmon river acft stalled contacting dirt bank. Plt was carrying 8 5-gallon gasoline cans. 4 cans were still secured inside the acft after the accident. Only 3 of the cans were… - [NTSB LAX84FUG02](https://openairdocs.org/ntsb/LAX84FUG02.md): Phaneuf B8 MOD Gyro · Murrieta, CA · Accident · 1 fatal · Final report · Sep 2, 1984 · N8474 · Destroyed > A witness observed the gyrocopter circle the aprt. On the second time around, it dropped down low on the downwind leg and disappeared behind a small hill. He also stated the eng was running at full power and that he could hear the rotor blades strike the… - [NTSB MKC84LA267](https://openairdocs.org/ntsb/MKC84LA267.md): Cessna 150L · Marshall, MO · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N16220 · Substantial damage > The acft engine lost power while descending after 1 hr of flt. During the ensueing forced lndg the plt said he changed his selection of landing site because of an auto on the selected site (a highway). The acft was landed beside the road &a collision with a… - [NTSB ATL84FLT13](https://openairdocs.org/ntsb/ATL84FLT13.md): Piper PA-22 · Nashville, TN · Accident · Serious injuries · Final report · Aug 31, 1984 · N950A · Destroyed > The engine quit on final apch to the arpt as a result of fuel starvation. Sixteen gallons of fuel remained in the right fuel tank, but the left tank was selected. No fuel was found in the left tank. The acft collided with powerlines during the forced landing… - [NTSB ATL84FA274](https://openairdocs.org/ntsb/ATL84FA274.md): Cessna 402C · Albertville, AL · Accident · 2 fatal · Field investigation · Final report · Aug 31, 1984 · N55LP · Destroyed > Plt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the… - [NTSB NYC84FA293](https://openairdocs.org/ntsb/NYC84FA293.md): Cessna 150M · Meriden, CT · Accident · No injuries · Field investigation · Final report · Aug 26, 1984 · N45288 · 2 aircraft · Minor damage > A cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries. - [NTSB MIA84FA240](https://openairdocs.org/ntsb/MIA84FA240.md): Cessna 152 · Pembroke Pines, FL · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1984 · N48661 · Destroyed > One min and 20 seconds after being cleared for takeoff, the plt transmitted on tower freq that he was 'coming in for a landing.' The acft was observed to bank to the left, enter a steep descent from 200 to 300 ft AGL & crash. An intense post-crash fire… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=199 ## 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=198 --- 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.