# 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 199 of 420 · 20,992 cases ## Cases, newest first - [NTSB MIA84FA241](https://openairdocs.org/ntsb/MIA84FA241.md): Cessna 152 · Valdosta, GA · Accident · 4 fatal · Field investigation · Final report · Aug 25, 1984 · N25853 · 2 aircraft · Destroyed > The two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.… - [NTSB LAX84FU032](https://openairdocs.org/ntsb/LAX84FU032.md): Ultralight UFM East Riser · Cloverdale, CA · Accident · 1 fatal · Final report · Aug 25, 1984 · UNREG · Substantial damage > The Ultralight was observed by witnesses on the downwind leg of the traffic pattern for landing. The acft was flying level at about 300 ft AGL when it started a series of roller-coaster maneuvers which increased into a steep ascent and nose over followed by a… - [NTSB CHI84LA360](https://openairdocs.org/ntsb/CHI84LA360.md): Beech B-24-R · Independence, WI · Accident · No injuries · Limited investigation · Final report · Aug 25, 1984 · N2217L · Substantial damage > The acft collided with trees near the departure end of the field during an attempted go-around. A passenger reported that the go-around was initiated at about 100 ft AGL, 1/2 way down the fld. The plt said the fld was in a valley, it wasa hot (reported temp… - [NTSB ATL84LA270](https://openairdocs.org/ntsb/ATL84LA270.md): Universal Stinson 108-3 · Reidsville, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1984 · N6771M · Substantial damage > The accident occurred on a low approach to a sloping airstrip with power lines at the uphill end. A go-around was commenced from a low pass, but insufficient climb performance was available, and a pull-up to clear the obstruction resulted in a stall/mush into… - [NTSB NYC84FHJ02](https://openairdocs.org/ntsb/NYC84FHJ02.md): Cessna 305A · East Moriches, NY · Accident · No injuries · Final report · Aug 24, 1984 · N5291G · Substantial damage > At the completion of a banner tow flt the banner was released and a climbing right turn to downwind was initiated. A loss of power was experienced on downwind. Unable to return to the arpt to land, a forced landing was made in a wooded area. Investigators… - [NTSB NYC84FA294](https://openairdocs.org/ntsb/NYC84FA294.md): Cessna 414 · Wallingford, VT · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1984 · N18SM · Destroyed > The plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of… - [NTSB SEA84LA212](https://openairdocs.org/ntsb/SEA84LA212.md): Taylorcraft BC12-D · Medford, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1984 · N5153M · Substantial damage > The pilot had been advised by his CFI to avoid using this airstrip during midday due to thermal disturbances. During power-off approach, updrafts were encountered and a right turn out for go-around was initiated; however, power was not added. The aircraft… - [NTSB MIA84LA237](https://openairdocs.org/ntsb/MIA84LA237.md): Cessna 150 · Ft. Pierce, FL · Accident · No injuries · Limited investigation · Final report · Aug 23, 1984 · N704XH · Substantial damage > The student plt on first solo flt misjudged his alt and landed the acft about 30 ft short of the rwy in the grass. This was his instructors assessment of the accident. - [NTSB LAX84FU031](https://openairdocs.org/ntsb/LAX84FU031.md): Calypso N/A · Chula Vista, CA · Accident · 1 fatal · Final report · Aug 23, 1984 · UNREG · Destroyed > Operator/company personnel had been flying the calypo ultralight for about 2 hrs when the marketing director was approached by a plt who wanted to fly the vehicle. They noted that the plt had been teaching students in an eipper ultralight. Company personnel… - [NTSB CHI84LU010](https://openairdocs.org/ntsb/CHI84LU010.md): Pioneer Flightstar · Westfield, IN · Accident · Serious injuries · Final report · Aug 22, 1984 · UNREG · Destroyed > The ultralight dove into the ground from about 100 ft AGL while in the traffic pattern. The plt at first interview said the engine quit. Later, the plt's father said he was told by the plt that the vehicle just stalled. Witnesses heard the engine running and… - [NTSB ATL84LA263](https://openairdocs.org/ntsb/ATL84LA263.md): Rotorway Scorpion 133 · West Hamlin, WV · Accident · 1 fatal · Limited investigation · Final report · Aug 20, 1984 · N4230S · Destroyed > Acft was observed proceeding over open field used as air strip in level flt, aprx 130 ft AGL, at 50 KTS. At end of field acft began left turn, nose dropped to steep descent attitude which continued to ground impact. Post-mortem showed triple-bypass surgery… - [NTSB NYC84LA283](https://openairdocs.org/ntsb/NYC84LA283.md): Ercoupe 415-E · Charlestown, RI · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1984 · N2328H · Substantial damage > While on final approach, the left main gear contacted some brush and becoming entangled in vines followed by the propeller becoming entangled. The propeller stopped and the aircraft swung around 180 degrees coming to rest about 500 ft from the grass runway. - [NTSB CHI84LU009](https://openairdocs.org/ntsb/CHI84LU009.md): Quicksilver MX · Aurora, IL · Accident · Serious injuries · Final report · Aug 19, 1984 · UNREG · Destroyed > The plt was practicing power-off, simulated forced landing patters over farm fields. During a turn at aprx 200 ft AGL, the ultralight decelerated to a very slow speed & subsequently stalled. The plt was unable to recover from the stall before the ultralight… - [NTSB CHI84FA352](https://openairdocs.org/ntsb/CHI84FA352.md): Piper PA-28-235 · Put In Bay, OH · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1984 · N8635W · Destroyed > The pilot attempted a go-around when he saw an aircraft still on the runway. Witnesses saw the aircraft approach the runway and just before touchdown, make a sharp rt turn to go-around. The aircraft made a sharp right turn, describedas the wings being 90… - [NTSB SEA84LA202](https://openairdocs.org/ntsb/SEA84LA202.md): Cessna 210N II · Elko, NV · Accident · No injuries · Limited investigation · Final report · Aug 18, 1984 · N4674U · Substantial damage > Fuel exhaustion occurred on final approach to destination airport. The nose landing gear contacted the top of the chain link airport perimeter fence breaking a connector and allowing the nose gear to retract. The main gear were not damaged. On landing roll… - [NTSB NYC84LA281](https://openairdocs.org/ntsb/NYC84LA281.md): Piper PA-28-180 · White Marsh, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1984 · N44325 · Destroyed > The acft was descended for aprx 7 miles at low power & slow rate for the landing at White Marsh arpt. The descent started at 2800 ft & continued straight in to rwy 27. At about 200 yds from the rwy & at 200 ft AGL the plt decided he needed power to land… - [NTSB FTW84LU008](https://openairdocs.org/ntsb/FTW84LU008.md): Mattison MAC MU-200 · Orange, TX · Accident · Serious injuries · Final report · Aug 18, 1984 · UNREG · Destroyed > According to law enforcement officers, who responded to the scene, the plt of the ultralight vehicle was attempting to land in a field when he encountered a x-wind & initiated a go-around. During the go-around, the vehicle struck a 30 ft tree while in a left… - [NTSB CHI84LA356](https://openairdocs.org/ntsb/CHI84LA356.md): Cessna 150L · Palmyra, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1984 · N18683 · Destroyed > Plt entered landing pattern after maintenance ferry flt, checked lighted wind indicator & evaluated wind as calm. Plt executed tight, close-in base due to electric billboard drag factor & noted strong wind blowing acft away from runway. Acft began to lose… - [NTSB NYC84LA286](https://openairdocs.org/ntsb/NYC84LA286.md): Cessna 172 · Islip, NY · Accident · No injuries · Limited investigation · Final report · Aug 17, 1984 · N739SF · Substantial damage > Communications with twr indicate plt intended to touch down as close to the end of the runway as possible. Acft touched down 20 yds short of hard surface in gravel. Rwy NOTAM stated 18 in depression at threshhold edge. - [NTSB FTW84LA350](https://openairdocs.org/ntsb/FTW84LA350.md): Piper PA-32-260 · Minden, LA · Accident · No injuries · Limited investigation · Final report · Aug 17, 1984 · N3962W · Substantial damage > During a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink. - [NTSB FTW84FA372](https://openairdocs.org/ntsb/FTW84FA372.md): Cessna 402 · Dfw Airport, TX · Accident · No injuries · Field investigation · Final report · Aug 17, 1984 · N19DA · Substantial damage > According to the plt, a rwy change accepted late in the apch required a steep turn and rapid descent. At aprx 400 ft AGL both throttles were advanced but neither eng responsed. The acft landed in unimproived terrain short of the rwy collapsing the left main… - [NTSB ATL84LA259](https://openairdocs.org/ntsb/ATL84LA259.md): Cessna 210L · Conway, SC · Accident · No injuries · Limited investigation · Final report · Aug 17, 1984 · N29276 · Substantial damage > The acft crashed into trees and after a loss of power during final apch. Plt reported the acft had 70 gallons of avgas onboard at departure from Conway, SC, at 0900 EDT. The proposed flt from Conway to florence, SC, and back to Conway was a distance of 72 NM.… - [NTSB BFO84FU003](https://openairdocs.org/ntsb/BFO84FU003.md): Ultralight Flight Phantom · South Boston, VA · Accident · Serious injuries · Final report · Aug 14, 1984 · UNREG · Destroyed > The plt arrived at the arpt about 1530 for a demo flt & possible purchase of a phantom Ultralight. The FBO had the plt fly a C-152 from the right seat to familiarize the plt to fly with the control stick on the right & the throttle on the left since this is… - [NTSB NYC84FA269](https://openairdocs.org/ntsb/NYC84FA269.md): Piper PA-46-310P · Richmond, NH · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1984 · N4323G · Destroyed > The plt was flying inbound for the ILS rwy 02 apch via the gardner VOR transition. While on the transition, the acft descended below the 4000 ft MSL min alt to 2600 ft MSL. The plt was alerted by ATC. He responded that his chart read 3000 ft. the acft then… - [NTSB CHI84LA347](https://openairdocs.org/ntsb/CHI84LA347.md): Lindsay Davis Benson B8M · Gross Ile, MI · Accident · No injuries · Limited investigation · Final report · Aug 13, 1984 · N4453D · Substantial damage > The student pilot was in the airport traffic pattern when he noticed the eng cylinder head temp exceeding the red line. He attempted to lower the temp by reducing the eng RPM but could not maintain alt. The pilot maneuvered the acft toward the airport and at… - [NTSB SEA84FA196](https://openairdocs.org/ntsb/SEA84FA196.md): Piper PA-22-160 · Bonners Ferry, ID · Accident · 1 fatal · Field investigation · Final report · Aug 12, 1984 · N9050D · Destroyed > The plt took off with 3 adult passengers & a 2 yr old child on board & flew aprx 1.3 hrs. Just prior to the accident, he reported on a left downwind for rwy 20. As the plt continued the apch, the acft was observed over the rwy at aprx 100' AGL, reportedly at… - [NTSB NYC84FA274](https://openairdocs.org/ntsb/NYC84FA274.md): Piper PA-24-260 · Sydney, NY · Accident · 1 fatal · Field investigation · Final report · Aug 12, 1984 · N9232P · Destroyed > During a night arrival, the plt was cleared for a vor/circling apch to the sidney muni arpt. The published apch was from the hancock VOR with a northerly heading to the arpt of 354 deg. Subsequently, the acft crashed & burned on wooded terrain about 1 mi… - [NTSB CHI84LA337](https://openairdocs.org/ntsb/CHI84LA337.md): Piper PA-28-161 · Manchester, OH · Accident · No injuries · Limited investigation · Final report · Aug 12, 1984 · N3573C · Substantial damage > The accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport… - [NTSB ANC84LA135](https://openairdocs.org/ntsb/ANC84LA135.md): Cessna 170B · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Aug 12, 1984 · N4691C · Substantial damage > The plt was trying to land on a gravel oil drilling pad. The acft landed short of the pad and collided with a beam. After a bounce and a yaw the acft touched down again and the rt main landing gear failed. The plt said his selection of landing area was poor. - [NTSB SEA84FYK01](https://openairdocs.org/ntsb/SEA84FYK01.md): Cessna 172N · Creswell, OR · Accident · Serious injuries · Final report · Aug 11, 1984 · N3278E · Destroyed > The acft collided with wires during an attempted go-around. The plt stated that he had made one go-around and on the 2NDLANDING attempt he landed hard in gusty wind & bounced. During the 2nd go-around he collided with wires & crashed. - [NTSB MKC84LA246](https://openairdocs.org/ntsb/MKC84LA246.md): Cessna 305A · Blakesburg, IA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N6735Q · Substantial damage > The acft mushed into tall corn off the end of the rwy during an attempted go-around. The plt said he landed long on the 2170 ft turf rwy in calm air and did not think he could stop so a go-around was initiated. He said a seat belt interfered with the… - [NTSB LAX84LA433](https://openairdocs.org/ntsb/LAX84LA433.md): Cessna T210M · Coulterville, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1984 · N210AV · Substantial damage > The plt reported that on his apch to land, the sink rate became greater than anticipated & the right main gear hit the top of a fence. Subsequently, the right main gear collapsed & the acft veered off the rwy & hit an embankment. - [NTSB LAX84FVM02](https://openairdocs.org/ntsb/LAX84FVM02.md): Grumman American AA-5B · Monterey, CA · Accident · Minor injuries · Final report · Aug 11, 1984 · N1544R · Substantial damage > The acft collided with hilly terrain aprx 6 miles east of the arpt during the second attempted ILS rwy 10 apch. The plt stated that communication and navigation problems were experienced during the flt. He also stated he changed fuel tanks every 1/2 hr during… - [NTSB FTW84FA343](https://openairdocs.org/ntsb/FTW84FA343.md): Cessna 150J · Justin, TX · Accident · Serious injuries · Field investigation · Final report · Aug 10, 1984 · N60660 · Destroyed > The acft collided with a power line and nosed over during an attempt to recover from a simulated forced landing. The cfireportedly 'cleared' the engine during the approach but when she took over and added power to climb she claimed the engine did not fully… - [NTSB ATL84LA254](https://openairdocs.org/ntsb/ATL84LA254.md): Piper PA-31-350 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1984 · N66AU · Substantial damage > The pilot reportedly set up a high rate of descent on final approach so that he could land the aircraft near the approach end of the rwy to avoid excessive braking on the wet rwy. The pilot descended the aircraft below the glide slope provided by the VASI and… - [NTSB ATL84FA247](https://openairdocs.org/ntsb/ATL84FA247.md): Cessna 172H · Ellijay, GA · Accident · Serious injuries · Field investigation · Final report · Aug 8, 1984 · N3272L · Destroyed > The student pilot and passenger were on unauthorized flight in the local area at 0145 when the accident occured. According to the student pilot he had returned from a local flt, picked up a pax, departed again and had flown for 30 to 45 mins before returning… - [NTSB MIA84LA220](https://openairdocs.org/ntsb/MIA84LA220.md): Cessna T188C · Pelham, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1984 · N3310J · Destroyed > The acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings. - [NTSB ATL84LA244](https://openairdocs.org/ntsb/ATL84LA244.md): Piper PA-38-112 · Liberty, NC · Accident · No injuries · Limited investigation · Final report · Aug 6, 1984 · N9549T · Substantial damage > The instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve… - [NTSB NYC84FNC08](https://openairdocs.org/ntsb/NYC84FNC08.md): Zappia Gabriel J QUICKIE-2 · Augusta, ME · Accident · Serious injuries · Final report · Aug 4, 1984 · N56U · Destroyed > The pilot stated that he noticed he was unexpectedly low on fuel. As he approached the Augusta, Maine airport. He radioed the Augusta fss and transmitted the fact. Shortly thereafter the engine quit and the pilot executed an emergency landing in a wooded… - [NTSB FTW84LA339](https://openairdocs.org/ntsb/FTW84LA339.md): Schleicher ASW12 · Georgetown, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1984 · N6135 · Destroyed > On final apch the plt encountered a 20 to 40 mph gust & subsequent 600 fpm downdrafts. Unable to reach the clear zone atthe apch end of the rwy. The plt attempted to stall into a tree but caught the left wing and slid down the side of the tree impacting the… - [NTSB CHI84LA333](https://openairdocs.org/ntsb/CHI84LA333.md): Piper PA-22-108 · Bloomington, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 1984 · N5881Z · Substantial damage > Plt departed on local flt shortly before the twr closed. Plt recalled final twr transmission included altimeter setting which was a significant change on his instrument. On return to the arpt, 35 mins after departure, fog and haze had reduced visibility to… - [NTSB NYC84LA261](https://openairdocs.org/ntsb/NYC84LA261.md): Teal TSC 1A · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Aug 3, 1984 · N2002T · Substantial damage > The acft struck the tail of an acft as it was beginning to proceed in a go-around. The plt said he was unaware of the collision with the parked acft until the subsequent landing. The collision was the result of the acft in flt drifting downwind off the rwy… - [NTSB BFO84FU002](https://openairdocs.org/ntsb/BFO84FU002.md): American Aerolights Eagle XL · Smithfield, VA · Accident · 1 fatal · Final report · Jul 31, 1984 · UNREG · Substantial damage > The plt of the ultralight vehicle, a student, was in radio contact with his instructor thru use of a portable hand-held UHF transceiver. About 10 min after takeoff, the instructor asked him to return to the airstrip for a practice power off landing. During… - [NTSB CHI84LA318](https://openairdocs.org/ntsb/CHI84LA318.md): Cessna 172 · Urbana, OH · Accident · No injuries · Limited investigation · Final report · Jul 29, 1984 · N3891S · Substantial damage > The pilot stated after the accident that he arrived at his flight planned destination 15 minutes early so he continued the flight an additional hour. The plt experienced an eng failure while on final apch to the rwy at the revised destination arpt. The plt… - [NTSB LAX84LA419](https://openairdocs.org/ntsb/LAX84LA419.md): Luscombe 8A · Laveen, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 1984 · N45743 · Substantial damage > During flt on the downwind leg of the traffic pattern the plt inadvertantly knocked the ignition switch to the 'off' position. Since the prop stopped and the acft was not equipped with a starter, the acft engine could not be restarted. The acft landed 20 ft… - [NTSB CHI84LA316](https://openairdocs.org/ntsb/CHI84LA316.md): Cessna 150H · Menomonie, WI · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N6707S · Substantial damage > The plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing. - [NTSB CHI84FU007](https://openairdocs.org/ntsb/CHI84FU007.md): Collins Fisher FP-202 · Ludington, MI · Accident · 1 fatal · Final report · Jul 28, 1984 · UNREG · Destroyed > The ultra-light was constructed by the pilot and two other persons. This group had no previous experience in aircraft construction. This was the third known flight for this aircraft. It had been flown two days prior to the accident and an adjustment to the… - [NTSB SEA84LA184](https://openairdocs.org/ntsb/SEA84LA184.md): Heveron Sandpiper 83B · Mcminnville, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 1984 · N4751N · Substantial damage > A student pilot lost control of an ultralight vehicle when he encountered a local gusty wind condition at 200' AGL and collided with the ground in an uncontrolled descent. The ultralight was built for registration as an experimental aircraft, but… - [NTSB ATL84LA236](https://openairdocs.org/ntsb/ATL84LA236.md): Cessna T210L · Toccoa, GA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1984 · N30237 · Substantial damage > Plt made a forced landing in a grove of trees 1 1/2 miles north of the arpt after reporting an engine failure due to fuel exhaustion. Plt stated adequate fuel was on board to complete the flt however, an en route course deviation was made to avoid various… - [NTSB NYC84IA271](https://openairdocs.org/ntsb/NYC84IA271.md): Boeing 727-232 · Buffalo, NY · Incident · No injuries · Incident investigation · Final report · Jul 26, 1984 · N518PE · Minor damage > During the departure from newark, NJ, the aircrew noted a vibration which ceased after the gear was retracted. The crew suspected that a tire was out-of-round or a gear door was vibrating & continued the flt. During the apch to Buffalo, NY, the vibration… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=200 ## 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=199 --- 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.