# NTSB investigations: Initial climb 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 173 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI87LA011](https://openairdocs.org/ntsb/CHI87LA011.md): Cessna U206F · Grand Ledge, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 1986 · N1803Q · Substantial damage > The aircraft experienced engine failure during takeoff and nosed over in an open field. The pilot stated that he did his runup on the right fuel tank and took off on the left fuel tank. Inspection of the aircraft found water in the left fuel tank. The pilot… - [NTSB ANC87LA010](https://openairdocs.org/ntsb/ANC87LA010.md): Taylorcraft BC-12D · Unalakleet, AK · Accident · No injuries · Limited investigation · Final report · Oct 24, 1986 · N95248 · Substantial damage > The private pilot with 14 hours experience in this airplane did not recognize that the carburetor heat control was not functioning properly. He did not recall draining the airplane's fuel sumps after refueling from exposed fuel tanks prior to takeoff.… - [NTSB CHI87FA009](https://openairdocs.org/ntsb/CHI87FA009.md): Cessna 441 · West Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1986 · N241FW · Destroyed > The plt (a part time employee of the owner) was ferrying the acft for maintenance. Witnesses, who saw the plt bfr take- off, noted that his speech was slurred & that he seemed angry because a tug would not start. One witness characterized him as being 'very… - [NTSB ANC87FA009](https://openairdocs.org/ntsb/ANC87FA009.md): Artic Privateer S4 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Oct 23, 1986 · N67H · Substantial damage > The acft desceded to terrain impact and nosed over following a loss of control as it climbed out of ground effect during takeoff. The plt reported he and his passengerds 'roped' frost off of the acft wings and other control surfaces prior to takeoff. Post… - [NTSB MIA87LA012](https://openairdocs.org/ntsb/MIA87LA012.md): Ayres SR-2-600 · Glen Allan, MS · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N4011S · Substantial damage > Shortly after takeoff the pilot stated the engine failed and he executed a forced landing. Post accident examination revealed no fuel in the aircraft fuel system. - [NTSB ANC87LA008](https://openairdocs.org/ntsb/ANC87LA008.md): Hughes 300-269B · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N9332F · Substantial damage > The helicopter exhausted its fuel supply during climbout. During the ensuing autorotation landing, the rotor speed was allosed to decay and the helcopter spun at touchdown. It rolled over and failed the rotor blades. - [NTSB ATL87FKG01](https://openairdocs.org/ntsb/ATL87FKG01.md): Jere L. Rosser Rand KR-2 · Kennesaw, GA · Accident · 1 fatal · Final report · Oct 21, 1986 · N47JJ · Destroyed > During initial climb the aircraft was observed at a high angle of attack at low altitude before descending in a stall/spin collision with the ground. Witnesses at the aprt reported that the engine sounded rough during the taxi and takeoff roll. The plt had… - [NTSB CHI87DEM01](https://openairdocs.org/ntsb/CHI87DEM01.md): Brown Acro Sport II · Grand Haven, MI · Accident · 1 fatal · Final report · Oct 19, 1986 · N3045E · Destroyed > According to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a… - [NTSB ANC87LA004](https://openairdocs.org/ntsb/ANC87LA004.md): Piper PA-18-150 · King Salmon, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1986 · N1123 · Substantial damage > The pilot was cleared to taxi his airplane into position and to hold behind a cherokee six airplane. After the cherokee six departed, he was cleared for takeoff. Immediately after lift off at 10 to 15 feet above the runway, the pilot stated the airplane went… - [NTSB MIA87LA010](https://openairdocs.org/ntsb/MIA87LA010.md): Buhl LA-1 · Belleview, FL · Accident · No injuries · Limited investigation · Final report · Oct 16, 1986 · N320Y · Substantial damage > The plt stated that he had reached an alt of about 50 ft when the eng quit. He stated that while he was attempting to determine the cause of the problem, he stopped flying the acft & permitted a high sink rate to develop which was not arrested prior to the… - [NTSB FTW87LA005](https://openairdocs.org/ntsb/FTW87LA005.md): Cessna 150J · Lago Vista, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1986 · N5552G · Destroyed > The instructor (CFI) & student had planned a 30 min flt to practice touch-&-go landings. During the initial climb after the 3rd touch-&-go, the eng lost power from fuel exhaustion. The CFI stated that he measured the fuel supply with a ruler drg the preflt &… - [NTSB DEN87FA003](https://openairdocs.org/ntsb/DEN87FA003.md): Mitsubishi MU-2B-20 · Denver, CO · Accident · No injuries · Field investigation · Final report · Oct 12, 1986 · N3MU · Substantial damage > Acft had been repossessed and was being ferried from grand junction, CO, to chicago, IL, with en route stop at Denver, CO. After takeoff from Denver, landing gear would not retract. Plt made several attempts without success. He elected to return to Denver.… - [NTSB ATL87LA005](https://openairdocs.org/ntsb/ATL87LA005.md): Cessna 305C · Catherine, AL · Accident · Serious injuries · Limited investigation · Final report · Oct 11, 1986 · N720BC · Substantial damage > Plt had landed in a soybean field to participate in a dove hunt. Abt 1000 he decided to fly to another field near a restaurant for breakfast. He attempted a short field t.o. and at about 100 ft AGL, he stated that the eng quit with no warning. As a result of… - [NTSB FTW87LA004](https://openairdocs.org/ntsb/FTW87LA004.md): Cessna T210N · Caddo, TX · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N5167Y · Substantial damage > Private pilot in Cessna T210 attempted take off from soft, unimproved field, pilot and 1 passenger, 80 gallons fuel, crosswind component of 12 knots. Pilot rotated aircraft prematurely. Acft settled back to ground and became airborne with approximately 20 ft… - [NTSB DEN87LA004](https://openairdocs.org/ntsb/DEN87LA004.md): Piper PA-32R-301T · Grafton, ND · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N8125H · Substantial damage > Plt made forced landing on dirt road shortly after takeoff when the eng reportedly lost power. Plt extended landing gear but acft touched down before gear locked and left main landing gear collapsed. Left wing also struck a mailbox during rollout. Post… - [NTSB FTW87LA003](https://openairdocs.org/ntsb/FTW87LA003.md): Mooney M20F · Kerrville, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 1986 · N22KK · Destroyed > Drg the initial climb after takeoff, the eng lost power & the plt made a gear up lndg. A post acdnt exam revealed the eng intake air supply was blocked off by a ball of paper that had gotten into the open ram air intake valve. This resulted in the loss of… - [NTSB CHI87DEE01](https://openairdocs.org/ntsb/CHI87DEE01.md): Cessna 182E · Plainfield, IL · Accident · Minor injuries · Final report · Oct 5, 1986 · N3205Y · Substantial damage > According to the pilot he performed a 'thorough' fuel system preflight by draining three clear fuel specimens from each wing and the belly drains. Shortly after takeoff the engine quit due to water contamination of the fuel system. Following the accident a… - [NTSB SEA87LA002](https://openairdocs.org/ntsb/SEA87LA002.md): Cessna 172N · Roseburg, OR · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1986 · N734EP · Destroyed > The plt initiated the takeoff from a taxiway with a 100 ft obscured sky and 1/4 visibility in fog. The non-instrument rated plt was unable to maintain the rwy heading during initial climb. The acft drifted to the right of the taxiway and struck trees located… - [NTSB LAX87LA005](https://openairdocs.org/ntsb/LAX87LA005.md): Waco YKS-7 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1986 · N50RA · Substantial damage > The acft departed montgomery airport at abt 0954 hours. Shortly after departing the airport the engine began to cut-in and out. The plt contacted gillespie airport tower and requested to execute a precautionary landing and almost simultaneously the engine… - [NTSB DCA87AA002](https://openairdocs.org/ntsb/DCA87AA002.md): Lockheed 382G · Kelly Afb, TX · Accident · 3 fatal · Final report · Oct 4, 1986 · N15ST · Destroyed > After the acft landed at Kelly Afb, TX, on 10/2/86, there was a crew chg bfr it depd on the next flt. Drg the next take-off, the acft lifted off near the midpoint of rwy 15 (aprx 5775' fm the apch end). When it was at aprx 100' to 200' AGL,witnesses saw it go… - [NTSB LAX87LA002](https://openairdocs.org/ntsb/LAX87LA002.md): Piper PA-30 · Holbrook, AZ · Accident · No injuries · Limited investigation · Final report · Oct 3, 1986 · N12BX · Substantial damage > Just after takeoff, the right engine lost power at an altitude of approximately 450 feet. The right propeller was feathered, but the pilot was unable to maintain altitude. Subsequently, the aircraft collided with terrain about 3 miles south of the airport.… - [NTSB BFO87LA002](https://openairdocs.org/ntsb/BFO87LA002.md): Beech D-45 (T-34B) · Patuxent River, MD · Accident · No injuries · Limited investigation · Final report · Oct 3, 1986 · N662 · Substantial damage > The purpose of the flt. Was to check out the 11800 hour former naval aviator who stated he had previous experience in T-34B'S. The CFI, who had over 3000 hours, 173 in make and model but less as an instructor, stated he briefed the student on procedures and… - [NTSB NYC87FA002](https://openairdocs.org/ntsb/NYC87FA002.md): Cessna 152 · Lumberton, NJ · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1986 · N48925 · Destroyed > During a take off, the acft was observed in a nose high attitude. After reaching an altitude of about 300 ft AGL, it went into a steep dscnt & crashed in about a 70 deg nose low attitude. No preimpact part failure or malfunction was evident. Reportedly, the… - [NTSB FTW86LA173](https://openairdocs.org/ntsb/FTW86LA173.md): Piper PA-22-160 · Abbeville, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1986 · N3050Z · Substantial damage > The pvt plt took off on a pleasure flt with 1 pax on board. Drg the initial climb, the eng lost power at about 300 ft AGL. The plt then turned downwind & subsequently made a forced landing in a sugar cane field adjacent to the arpt. Drg the landing, the acft… - [NTSB ATL86LA267](https://openairdocs.org/ntsb/ATL86LA267.md): Air Tractor AT-301 · Town Creek, AL · Accident · No injuries · Limited investigation · Final report · Sep 29, 1986 · N44245 · Substantial damage > The pilot reported that the engine had developed a 'miss' and a precautionary landing was made near the cotton fields intended to be sprayed. Trouble-shooting and full power run-ups did not reveal any problems, therefore, the pilot elected to takeoff and… - [NTSB DEN86LA261](https://openairdocs.org/ntsb/DEN86LA261.md): Piper PA-28R-201 · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1986 · N3482M · Substantial damage > Plt and there pax were departing for a LCL flt. The plt stated after the accident that he leaned the mixture prior to takeoff. He also stated that he rotated the acft at 65 KTS, and during the climb the stall warning horn sounded. The plt attempted to remedy… - [NTSB BFO86FA049](https://openairdocs.org/ntsb/BFO86FA049.md): Piper PA-31-350 · Elkwood, VA · Accident · 1 fatal · Field investigation · Final report · Sep 28, 1986 · N59942 · Destroyed > The acft, which was stolen from the arpt, collided with the ground in a steep angle aprx one mile south of the arpt. Instrument meteorological conditions existed with local visibility less than one mile as reported by persons near the accident site. The plt… - [NTSB ANC86LAG06](https://openairdocs.org/ntsb/ANC86LAG06.md): Star Duster SA-100 · Anchorage, AK · Accident · Serious injuries · Final report · Sep 26, 1986 · N578A · Destroyed > Shortly after departure of a Boeing 747 jet, this aircraft was cleared for takeoff. At an altitude of 200 feet the pilot lost directional control of aircraft causing the aircraft to crash next to the runway. Just prior to takeoff the pilot was issued wake… - [NTSB CHI86FEC07](https://openairdocs.org/ntsb/CHI86FEC07.md): Piper PA-36-285 · Imlay City, MI · Accident · No injuries · Final report · Sep 22, 1986 · N65130 · Substantial damage > The pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end… - [NTSB ANC86LA162](https://openairdocs.org/ntsb/ANC86LA162.md): Piper PA-18-150 · Wood River, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N4421Z · Substantial damage > The pilot stated that after lift off the pilot lost control of the aircraft due to the left crosswind. - [NTSB ANC86LA161](https://openairdocs.org/ntsb/ANC86LA161.md): Piper PA-12 · Tutna Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N5461Y · Substantial damage > The pilot stated that just after lift off, a left crosswind forced the left wing up, causing the right float to strike the water. - [NTSB ATL86LA262](https://openairdocs.org/ntsb/ATL86LA262.md): Alexander AS-K13 · Tullahoma, TN · Accident · No injuries · Limited investigation · Final report · Sep 20, 1986 · N6877 · Substantial damage > During an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high… - [NTSB ATL86LA260](https://openairdocs.org/ntsb/ATL86LA260.md): Piper PA-23-250 · Montgomery, AL · Accident · No injuries · Limited investigation · Final report · Sep 20, 1986 · N6041Y · Substantial damage > During initial climb phase of an experimental flt from mgm, AL, the plt rpted that the left engine had failed and an attempt was made to feather the prop. The plt radioed dannelly tower that the acft was returning to the arpt. Then the plt rpted that the… - [NTSB ANC86LA160](https://openairdocs.org/ntsb/ANC86LA160.md): de Havilland DHC-3 · American River, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1986 · N83U · Substantial damage > After landing on a 1200 ft gravel bar, the plt paced off the available area, estimated the load to pick up, then loaded the acft. Due to the x-wind, he used less than takeoff flaps. He began taking off, but after lift-off, the acft 'seemed to hit a… - [NTSB LAX86FUJ06](https://openairdocs.org/ntsb/LAX86FUJ06.md): Forbes-Wolfram Special DSA-1M · St. Johns, AZ · Accident · No injuries · Final report · Sep 19, 1986 · N99QB · Substantial damage > The plt reported that persons over 5 ft 9 in tall experience limited right aileron control authority due to the small cockpit of the homebuilt experimental acft, which is used exclusively for air racing. The plt said the right knee of tall persons limits the… - [NTSB DEN86FA254](https://openairdocs.org/ntsb/DEN86FA254.md): Cessna 182Q · Ovid, CO · Accident · 2 fatal · Field investigation · Final report · Sep 18, 1986 · N735GN · Destroyed > The plt and his pax had flown to ogallala, NE, for boating and water skiing. The next day the plt called his wife who reminded him of an engagement that evening. The plt called the fss 5 different times and each time was told VFR flt was not recommended. He… - [NTSB LAX86LA353](https://openairdocs.org/ntsb/LAX86LA353.md): Cessna 152 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1986 · N4945H · Substantial damage > The plt & passenger, each weighing 185 pounds, planned a local flight in the rented Cessna 152. The acft's fuel tanks were full. The plt reported that during his pretakeoff engine run up no mechanical difficulties/malfunctions were observed. The plt also… - [NTSB ANC86LA142](https://openairdocs.org/ntsb/ANC86LA142.md): Piper PA-18 · Eureka, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1986 · N9656P · Substantial damage > Aircraft left the gravel strip and nosed over due to the rear seat passenger pushing on the right rear rudder pedal just as the aircraft became airborne. - [NTSB FTW86LA168](https://openairdocs.org/ntsb/FTW86LA168.md): Cessna T210M · Mc Alester, OK · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1986 · N7568M · Substantial damage > Sixty-six year old commercial pilot taking off from Mc Alester, OK airport. Pilot stated fuel pressure fluctuated followed by loss of power during initial climb. Pilot activated auxiliary fuel pumps and switched fuel tanks. Could not restore fuel pressure.… - [NTSB SEA86LA244](https://openairdocs.org/ntsb/SEA86LA244.md): Cessna 172 M · Red'S Horse Ran, OR · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N12135 · Destroyed > The pilot was attempting to depart an airstrip with a strong tail wind. 10 to 20 feet AGL the aircraft descended back onto the ground to the right of the airstrip, bounced, rolled through a wire fence and onto soft muddy terrain. The nose wheel dug into the… - [NTSB ATL86LA257](https://openairdocs.org/ntsb/ATL86LA257.md): Cessna 150L · Covington, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1986 · N10539 · Substantial damage > The plt landed at the airstrip on his fathers farm as the third stop of the day. He reported that during the attempted takeoff he hit a tree and stalled the acft. His student pilot certificate had been signed off for his first x-country flt the day prior to… - [NTSB ANC86FA152](https://openairdocs.org/ntsb/ANC86FA152.md): Piper PA-18-150 · Wasilla, AK · Accident · Serious injuries · Field investigation · Final report · Sep 13, 1986 · N3996P · Substantial damage > Float plane crashed into trees at end of lake just after takeoff. Witnesses reported hearing the engine backfire and sputter before it quit. Post accident examination of the engine failed to disclose mecanical failures/malfunctions. - [NTSB MKC86LA188](https://openairdocs.org/ntsb/MKC86LA188.md): Cessna 182 · Rolla, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1986 · N9161X · Substantial damage > The plt had taxied his acft to the upwind end of his pvt strip after landing and commenced his takeoff roll downwind. Shortly after becoming airborne, the acft stalled and descended out of control to the rwy. After the impact the acft was destroyed by a post… - [NTSB LAX86LA346](https://openairdocs.org/ntsb/LAX86LA346.md): Piper PA-32RT-300T · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1986 · N39695 · Substantial damage > The acft experienced a pwr loss during initial climb. During the ensuing forced lndg the acft collided with a utility pole. To #4 cyl fuel injector line had becom disconnected. The 915 hr eng had received an annual inspection 36 hrs prior to the acc. - [NTSB LAX86FVG08](https://openairdocs.org/ntsb/LAX86FVG08.md): Christen Industries Eagle II · Rio Vista, CA · Accident · 2 fatal · Final report · Sep 12, 1986 · N19DW · Destroyed > Witnesses reported the acft sounded normal during run-up and takeoff until it reached an alt btw 150-500 ft AGL at which time the eng quit. The acft then entered a turn back toward the arpt and descended to ground impact. Post accidentinspection revealed aprx… - [NTSB ANC86FA151](https://openairdocs.org/ntsb/ANC86FA151.md): Piper PA-18 · Christian Lake, AK · Accident · 1 fatal · Field investigation · Final report · Sep 12, 1986 · N150SG · Destroyed > The pilot-in-command of the float equipped airplane, overloaded the airplane beyond the aft limit of the center of gravity range. He took off without flaps and attempted to turn away from rising terrain. The airplane stalled and crashed. - [NTSB ATL86LA251](https://openairdocs.org/ntsb/ATL86LA251.md): Hughes 369HS/H-500 · Waterloo, AL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1986 · N9181F · Substantial damage > The acft lifted off the top of the support truck and started a takeoff with a partial load of chemicals to be applied to a logged over forest area. About 10-15 feet after lift off the plt detected a loss of rotor RPM. He was at the edge of a ravine with steep… - [NTSB ATL86LA250](https://openairdocs.org/ntsb/ATL86LA250.md): Taylorcraft BC12-D · Elkin, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1986 · N44215 · Substantial damage > Plt said he had been performing take offs and landings. Engine lost RPM at about 50 AGL. An attempt was made to land on the sod rwy which resulted in a hard landing and collapse of the right main landing gear. Plt said he suspected carburetor icing. Icing… - [NTSB FTW86LA164](https://openairdocs.org/ntsb/FTW86LA164.md): Hiller FH-1100 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N5068F · Substantial damage > The plt was conducting sight-seeing flts from a rodeo/fairground area. During a critical part of a takeoff, a tail rotor blade separated & the plt lost directional control. He attempted an autorotative landing. After spinning around about 3 times, the plt… - [NTSB ATL86LA252](https://openairdocs.org/ntsb/ATL86LA252.md): Cessna 177 · Harrodsburg, KY · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N3150T · Substantial damage > The plt reported experiencing a loss of power at an alt of aprx 100 ft AGL shortly after takeoff. A forced landing was made into a small field during which the nose gear collapsed. Cause of the power loss was not determined. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=174 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=173 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.