# 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 181 of 420 · 20,992 cases ## Cases, newest first - [NTSB FTW87LA026](https://openairdocs.org/ntsb/FTW87LA026.md): Cessna 152 · Durant, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1986 · N25532 · Destroyed > The student plt noted a partial power loss while practicing multiple touch-and-go landings. She stated that after she had turned on a downwind, she heard 'a different sound' from the eng and it appeared to lose power. During an apch for an off arpt landing,… - [NTSB MIA87FA041](https://openairdocs.org/ntsb/MIA87FA041.md): Cessna 320 · Panama City, FL · Accident · Serious injuries · Field investigation · Final report · Dec 2, 1986 · N1FD · Destroyed > While executing an ILS approach with aircraft radios that were not operating properly and using a hand held transceiver, the right engine failed due to a broken fuel pressure sensor wire, and the pilot lost control of the aircraft in IMC conditions and… - [NTSB FTW87LA024](https://openairdocs.org/ntsb/FTW87LA024.md): Mooney M20D · Kerrville, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1986 · N1970Y · Substantial damage > The pilot was unable to extend the landing gear in preparation for landing. Troubleshooting and several attempts to extend the gear failed. The pilot then made a 360 degree turn over the airport to lose altitude during which, he secured the engine and stopped… - [NTSB CHI87FA040](https://openairdocs.org/ntsb/CHI87FA040.md): Mooney M20E · Hanna City, IL · Accident · 4 fatal · Field investigation · Final report · Dec 2, 1986 · N9210M · Destroyed > The aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8… - [NTSB LAX87DUJ01](https://openairdocs.org/ntsb/LAX87DUJ01.md): Robinson R-22 · Tucson, AZ · Accident · Minor injuries · Final report · Nov 30, 1986 · N9006W · Destroyed > After 50 minutes of cruise flight, the pilot observed a decrease in oil pressure to zero and the illumination of the low oil pressure light. The pilot landed the helicopter and had an airframe and powerplant mechanic inspect the aircraft. There were no… - [NTSB LAX87FA057](https://openairdocs.org/ntsb/LAX87FA057.md): Cessna 172N · Santa Paula, CA · Accident · No injuries · Field investigation · Final report · Nov 28, 1986 · N2371E · 2 aircraft · Substantial damage > A Cessna 172 & a Dehavilland gipsy moth collided at 150 ft. AGL while on short final approach to the uncontrolled arpt. On base leg the plt flying the moth failed to observe & yield the right of way to the Cessna which was already established on the final… - [NTSB LAX87MA052](https://openairdocs.org/ntsb/LAX87MA052.md): Beech A36TC · Bakersfield, CA · Accident · 4 fatal · Major investigation · Final report · Nov 27, 1986 · N6750L · Destroyed > On an instructional flt, the student plt & instructor (CFI) made an ILS low apch to rwy 30R. Drg a go-arnd (missed apch)a twr ctlr obsvd a 'light trace of smoke' emanating fm the eng exhaust. Shortly thereafter, the acft 'banked hard to the left and appeared… - [NTSB NYC87FA038](https://openairdocs.org/ntsb/NYC87FA038.md): Piper PA-28-161 · Glen Mawr, PA · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1986 · N8130A · Destroyed > Drg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.… - [NTSB MIA87LA037](https://openairdocs.org/ntsb/MIA87LA037.md): Cessna 182E · Chiefland, FL · Accident · No injuries · Limited investigation · Final report · Nov 26, 1986 · N2945Y · Substantial damage > The plt stated that he was on final apch & attempted to go around due to gusting winds. He applied power, the eng quit & he collided with the trees at the end of the rwy. No determination could be made as to the malfunction of the eng as described by the plt. - [NTSB ATL87FA029](https://openairdocs.org/ntsb/ATL87FA029.md): Beech 35-B33 · Winston-Salem, NC · Accident · 4 fatal · Field investigation · Final report · Nov 26, 1986 · N9592Y · Destroyed > The flt departed rochester, NY, and received and IFR clearance. The flt and ATC handling were normal. The plt was cleared for the ILS rwy 33 apch to Winston-Salem, NC. The flt was established on the final apch but collided with trees about 2 miles southeast… - [NTSB LAX87LA049](https://openairdocs.org/ntsb/LAX87LA049.md): Cessna 150L · Fresno, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1986 · N11185 · Destroyed > During a solo instructional cross-country flight the engine quit while on the base leg at the Fresno airport. The pilot did not feel that he could make the runway due to an extended downwind and low altitude. The pilot decided to try and land in a plowed… - [NTSB BFO87DHD02](https://openairdocs.org/ntsb/BFO87DHD02.md): Hughes 369D · Newark, DE · Accident · No injuries · Final report · Nov 25, 1986 · N8670F · Substantial damage > The acft was being flown on a maintenance check flt. As the plt was returning to land, the eng lost power from fuel exhaustion. During an autorotative landing, the main rotor blades & tail boom were extensively damaged. The plt rprtd the fuel quantity gage… - [NTSB ANC87LA016](https://openairdocs.org/ntsb/ANC87LA016.md): Piper PA-22-20 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Nov 24, 1986 · N23CP · Substantial damage > The plt-in-command stated he was executing a shallow approach to runway 16 and prior to reaching the runway the engine stopped producing power. He further stated that during his descent he did not use any carburetor heat. The plt lost control of the airplane… - [NTSB MKC87LA024](https://openairdocs.org/ntsb/MKC87LA024.md): Cessna 177XP · Camden, AR · Accident · No injuries · Limited investigation · Final report · Nov 23, 1986 · N736UF · Substantial damage > The pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA. - [NTSB LAX87LA046](https://openairdocs.org/ntsb/LAX87LA046.md): Gulfstream AA-5B · Fullerton, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 1986 · N4520D · Substantial damage > A Gulfstream American AA-5B lost power and collided with a tree short of the runway while on an IFR training flight. The flight instructor had just switched fuel tanks when the engine began to run rough and then quit running. He was unable to restart the… - [NTSB FTW87LA019](https://openairdocs.org/ntsb/FTW87LA019.md): Cessna 337 · New Orleans, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1986 · N879SA · Substantial damage > During an instrument approach and the subsequent missed approach, both engines failed due to fuel starvation. It has been determined that as much as six gallons of fuel was contained in the auxillary tanks at the time of the accident but that none was… - [NTSB ATL87LA023](https://openairdocs.org/ntsb/ATL87LA023.md): Hughes 269C · Eden, NC · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N9665F · Substantial damage > Pilot related that he had placed the helicopter at triad for a 50 hour inspection. Aircraft reportedly defueled to dry tank. Six days later fuel truck log shows aircraft refueled with 23.2 gallons as payback. According to information furnished by owner and… - [NTSB CHI87LA019](https://openairdocs.org/ntsb/CHI87LA019.md): Cessna 172N · Bethalto, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1986 · N1631E · Destroyed > The pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach… - [NTSB ATL87FA021](https://openairdocs.org/ntsb/ATL87FA021.md): Cessna 210L · Buford, GA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1986 · N2192S · Substantial damage > According to the operator, cylinders had recently been replaced on the eng & plts had been instructed to operate the eng at 75% power with the mixture richer than normal during a break-in period. On this flt, the plt took off with a full load of fuel. As he… - [NTSB NYC87LA040](https://openairdocs.org/ntsb/NYC87LA040.md): Ercoupe 415-C · Stormville, NY · Accident · No injuries · Limited investigation · Final report · Nov 16, 1986 · N93523 · Substantial damage > The plt reported that during the landing apch, aprx 1/2 mile from touchdown, the acft descended below the visual glidepath. Recovery was attempted with the application of power, however, the acft mushed into a field short of the rwy. The acft rolled, struck a… - [NTSB NYC87LA034](https://openairdocs.org/ntsb/NYC87LA034.md): Mooney M20C · Jackman, ME · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1986 · N6863N · Substantial damage > The pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously… - [NTSB LAX87FA040](https://openairdocs.org/ntsb/LAX87FA040.md): Boeing A75N1 · Corona, CA · Accident · Serious injuries · Field investigation · Final report · Nov 15, 1986 · N621SR · 2 aircraft · Substantial damage > The plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second… - [NTSB LAX87LA053](https://openairdocs.org/ntsb/LAX87LA053.md): Schweizer SGS 2-33 · Perris, CA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N50CS · Substantial damage > A Schweizer sgs 2-33 glider collided with a drainage ditch after a forced landing two miles short of the airport. The glider lost lift and was unable to return to the airport due to power lines in the flight path. The pilot made a 180 degree turn and landed… - [NTSB LAX87LA035](https://openairdocs.org/ntsb/LAX87LA035.md): Schweizer SGS2-33A · Sun City, AZ · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N7558 · Substantial damage > While on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before… - [NTSB MKC87FA017](https://openairdocs.org/ntsb/MKC87FA017.md): Beech E18S · Texarkana, AR · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1986 · N149AA · Destroyed > The airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the… - [NTSB MIA87LA028](https://openairdocs.org/ntsb/MIA87LA028.md): Glasair Glasair · Ft. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1986 · N3241W · Substantial damage > The plt stated that while in the pattern, the engine started to run rough and then quit. He attempted to return to the runway, but the aircraft crashed into trees about one mile from the airport. No reason was found for the loss of power as described by the… - [NTSB ATL87FA017](https://openairdocs.org/ntsb/ATL87FA017.md): Cessna 210L · Montgomery, AL · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1986 · N59034 · Destroyed > The acft was flown for slightly less than 3 hrs on an instructional flt. The acft was reportedly nearly full of fuel before takeoff. Capacity is 89 gals. At max consumption of 22 gph the acft should have still had fuel available when the eng quit. During the… - [NTSB LAX87DJA02](https://openairdocs.org/ntsb/LAX87DJA02.md): Cessna 172N · Honolulu, HI · Accident · No injuries · Final report · Nov 7, 1986 · N6184D · Destroyed > The acft experienced a loss of engine power while descending during a practice instrument apch. The temperature was 81 degrees (f) with the dew point of 71 degrees (f). According to the icing probability chart, there is a possibility of serious carburetor… - [NTSB DEN87FA017](https://openairdocs.org/ntsb/DEN87FA017.md): Piper PA-32-301T · Cheyenne, WY · Accident · Serious injuries · Field investigation · Final report · Nov 7, 1986 · N8216V · Substantial damage > The plt and his two pax were on a VFR x-country to scottsbluff, NE, when IMC was encountered near grand junction, CO. The plt then called ATC and obtained an IFR clearance. The plt elected to land at Cheyenne, WY. Wx was reported to be 500 overcast, 1/4 mi… - [NTSB MIA87LA023](https://openairdocs.org/ntsb/MIA87LA023.md): Cessna 421C · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1986 · N37359 · Substantial damage > The flt had been cleared for a visual approach behind a Lockheed L-1011 aircraft and was warned to use caution against wake turbulence. The flight encountered the wake turbulence of the L-1011 at 1600 feet. Control could not be maintained and the aircraft… - [NTSB LAX87LA033](https://openairdocs.org/ntsb/LAX87LA033.md): Beech K35 · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 1986 · N399WM · Destroyed > At the end of a night cross country flight, the pilot attempted an instrument approach to the montgomery airport after being advised the weather was below basic VFR minimums. He was cleared for an ILS approach and reported that he had the runway in sight at… - [NTSB DEN87FA016](https://openairdocs.org/ntsb/DEN87FA016.md): Cessna 421C · Butte, MT · Accident · 1 fatal · Field investigation · Final report · Nov 6, 1986 · N421AR · Destroyed > Plt was attempting the vor-b instrument apch to Butte, MT arpt. Plt reported over the coppertown VORTAC inbound on the arpt. The procedure turn inbound course to the VORTAC is 124 degrees. The inbound course to the arpt is 094 degrees. The acft wreckage was… - [NTSB DCA87MA010](https://openairdocs.org/ntsb/DCA87MA010.md): Piper PA-23-150 · Tampa, FL · Accident · 1 fatal · Class 1 · Major · Final report · Nov 6, 1986 · N2185P · 2 aircraft · Destroyed > At aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At… - [NTSB NYC87LA008](https://openairdocs.org/ntsb/NYC87LA008.md): Cessna 152 · Haverhill, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 1986 · N49427 · Substantial damage > The student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full… - [NTSB LAX87LA032](https://openairdocs.org/ntsb/LAX87LA032.md): Learjet 24 · Lake Tahoe, CA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N711TJ · Substantial damage > At the end of a cross country flight, the pilot experienced light to moderate turbulence on short final while executing a down wind approach to the Lake Tahoe airport. Approximately 50 feet AGL over the runway, the aircraft exited the turbulence and touched… - [NTSB FTW87LA014](https://openairdocs.org/ntsb/FTW87LA014.md): Cessna 150H · Portland, TX · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N22968 · Substantial damage > The plt had initiated a go-around and was on a left crosswind when a loss of power occurred. A forced landing was made in 4 feet of water in the nueces bay. Post accident exam of the acft revealed both fuel tanks were empty. - [NTSB ATL87LA013](https://openairdocs.org/ntsb/ATL87LA013.md): Piper PA-38-112 · Winston-Salem, NC · Accident · No injuries · Limited investigation · Final report · Oct 31, 1986 · N2373G · Substantial damage > While conducting touch and go landings, N2373G lost power during a go-around. The flight was instructed to go-around due to another aircraft on runway 03. The pilot reversed his course toward runway 21. The aircraft crashed into trees short of runway 21.… - [NTSB CHI87DEM03](https://openairdocs.org/ntsb/CHI87DEM03.md): Ralley 3A · Gowen, MI · Accident · No injuries · Final report · Oct 30, 1986 · N3782W · Substantial damage > The pilot stated that the aircraft stalled while practicing an emergency landing. He also stated that he should have pulled up from the practice emergency procedure sooner. - [NTSB LAX87IA027](https://openairdocs.org/ntsb/LAX87IA027.md): Boeing 727-222 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Oct 29, 1986 · N7255U · 2 aircraft · No damage > Drg arr, united flt 282 (Boeing 727, N7255U) was vectored by Los Angeles (lax) TRACON for an ILS rwy 25L apch. While in a dscndg turn at 2100' MSL to intercept the ILS LOC at 2000', the capt saw a helicopter (hel) ahead & pulled up. He estdhis acft passed w/i… - [NTSB DEN87LA010](https://openairdocs.org/ntsb/DEN87LA010.md): Cessna 172M · Richardton, ND · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1986 · N9051H · Substantial damage > The plt attempted a landing on an unlighted dirt strip at dusk. He stated he intentionally flew low because it was getting dark. On final apch acft struck trees and then impacted the terrain, nosing over. - [NTSB BFO87FA004](https://openairdocs.org/ntsb/BFO87FA004.md): Piper PA-28R-200 · Mount Pleasant, MD · Accident · 2 fatal · Field investigation · Final report · Oct 26, 1986 · N4347X · Destroyed > The acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which… - [NTSB BFO87LA005](https://openairdocs.org/ntsb/BFO87LA005.md): Robinson R22B · Harborton, VA · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1986 · N24684 · Substantial damage > During an apch to land, the plt expereinced a loss of tail rotor effectiveness and the acft rotated to the right. The airspeed was reported as 30 mph with a descent rate of 150 fpm and the acft was less than 50 ft AGL. The acft then descended to a collision… - [NTSB CHI87FA010](https://openairdocs.org/ntsb/CHI87FA010.md): Beech 58 · Chicago, IL · Accident · Serious injuries · Field investigation · Final report · Oct 23, 1986 · N7305R · Destroyed > The pilot departed home base with an undetermined amount of available fuel, after being advised by the lineman/refueler of the uncertainty of the amount of fuel onboard. The pilot assumed the aircraft had been refueled the previous evening and departed on… - [NTSB ATL87FA007](https://openairdocs.org/ntsb/ATL87FA007.md): Piper PA-32R-300 · Nashville, TN · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1986 · N5260F · Destroyed > The flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach… - [NTSB MKC87DCQ01](https://openairdocs.org/ntsb/MKC87DCQ01.md): James Olivier Quickie · Harper, KS · Accident · 1 fatal · Final report · Oct 19, 1986 · N3241N · Destroyed > A witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls. - [NTSB ATL87FA006](https://openairdocs.org/ntsb/ATL87FA006.md): Cessna 140A · Hamilton, OH · Accident · No injuries · Field investigation · Final report · Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage > The Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft… - [NTSB ATL87DEG01](https://openairdocs.org/ntsb/ATL87DEG01.md): Cessna T210N · Cleves, OH · Accident · No injuries · Final report · Oct 19, 1986 · N6567Y · Substantial damage > The plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus… - [NTSB MKC87IA007](https://openairdocs.org/ntsb/MKC87IA007.md): Swearingen SA-226-TC · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Oct 17, 1986 · N251AM · Minor damage > During the approach, the right main landing gear would not extend by normal or emergency means. Airplane was intentionally landed with all landing gear retracted. Inspection indicated gear doors pulled closed farther than normal due to right main landing gear… - [NTSB CHI87FA004](https://openairdocs.org/ntsb/CHI87FA004.md): Piper PA-28-161 · Charleston, IL · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1986 · N8267W · 2 aircraft · Substantial damage > N8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy… - [NTSB SEA87LA012](https://openairdocs.org/ntsb/SEA87LA012.md): Let L-13 · Boulder City, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1986 · N2NV · Minor damage > The plt stated that a downdraft was encountered and an undershoot occurred while on base leg. A high sink rate developed and the plt did not take corrective action soon enough. The acft struck the ground, rolled a short distance through bushes, and across a… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=182 ## 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=181 --- 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.