# NTSB investigations: Enroute 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 317 of 718 · 35,885 cases ## Cases, newest first - [NTSB LAX87FA066](https://openairdocs.org/ntsb/LAX87FA066.md): Mooney M20K · Flagstaff, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1986 · N4004H · Substantial damage > The pilot encountered clouds and temperatures below freezing during a cross country flight at 17,500 feet above mean sea level. The engine failed shortly after the encounter with the weather. The pilot was unable to restart the engine during the forced… - [NTSB FTW87FA032](https://openairdocs.org/ntsb/FTW87FA032.md): Cessna 340A · Tomball, TX · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1986 · N8CD · Destroyed > The pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on… - [NTSB MIA87LA050](https://openairdocs.org/ntsb/MIA87LA050.md): Cessna 336 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 17, 1986 · N1SN · Substantial damage > Plt stated the rear engine failed while in cruise flight and while making an emergency landing he approached the runway too fast. The aircraft touched down approximately two thirds of the way down the runway and when it could not be stopped the aircraft was… - [NTSB MIA87LA051](https://openairdocs.org/ntsb/MIA87LA051.md): Cessna 150L · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Dec 16, 1986 · N11842 · Substantial damage > The plt experienced a slow deceleration of eng RPM followed by a total loss of power. The eng could not be restarted and a forced landing was made. Post accident exam of the eng, eng accessories, and airframe fuel system revealed no evidence to indicate… - [NTSB ANC87FA021](https://openairdocs.org/ntsb/ANC87FA021.md): Boeing 727-222 · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Dec 16, 1986 · N7635U · Minor damage > About 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt… - [NTSB FTW87FA031](https://openairdocs.org/ntsb/FTW87FA031.md): Cessna 172K · El Reno, OK · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1986 · N736XP · Destroyed > Private pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was… - [NTSB CHI87FA050](https://openairdocs.org/ntsb/CHI87FA050.md): Cessna 182P · Durand, IL · Accident · 1 fatal · Field investigation · Final report · Dec 15, 1986 · N21016 · Destroyed > Student pilot collided with terrain while attempting to remain in visual contact with the ground during very low light and in very heavy ground fog during a cross country flight. The pilot rushed his departure in an attempt to get home before dark and there… - [NTSB CHI87LA049](https://openairdocs.org/ntsb/CHI87LA049.md): Piper PA-22-150 · Mcgrath, MN · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N9198D · Substantial damage > After descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After… - [NTSB LAX87LA048](https://openairdocs.org/ntsb/LAX87LA048.md): Piper PA-32R-300 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1986 · N2209Q · Substantial damage > A Piper pa 32R-300 landed short of the rwy after a loss of power. The plt reported during the climb that he turned on the heater and the windshield turned black obscuring outside vision. The plt also indicated that there was a 'pungent odor' at the same time.… - [NTSB MIA87FA048](https://openairdocs.org/ntsb/MIA87FA048.md): Cessna 182P · St. Cloud, FL · Accident · Serious injuries · Field investigation · Final report · Dec 12, 1986 · N182LM · Substantial damage > The private pilot stated that prior to takeoff she did not check the fuel supply, and initiated an IFR flight. About 20 minutes into the flight the engine failed at 5000 ft MSL. During the subsequent forced landing attempt the aircraft struck a fence and a… - [NTSB CHI87DEX04](https://openairdocs.org/ntsb/CHI87DEX04.md): Aero Commander 500B · Hagerstown, IN · Accident · Serious injuries · Final report · Dec 12, 1986 · N116CA · Destroyed > The pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and… - [NTSB NYC87LA012](https://openairdocs.org/ntsb/NYC87LA012.md): Enstrom 280C · Newport, RI · Accident · 1 fatal · Limited investigation · Final report · Dec 11, 1986 · N647H · Substantial damage > Aircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available. - [NTSB LAX87LA062](https://openairdocs.org/ntsb/LAX87LA062.md): Piper PA-28-235 · Hayward, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1986 · N1429H · Substantial damage > A Piper PA-28-235 collided with a dirt bank after a loss of power while on a night VFR pleasure flight. The plt indicated that aprx 3 min after takeoff while cruising at 1,400 ft MSL the engine RPM abruptly decreased to idle. The fuel selector control was… - [NTSB CHI87IA047](https://openairdocs.org/ntsb/CHI87IA047.md): Fairchild SA226TC · Paducah, KY · Incident · No injuries · Incident investigation · Final report · Dec 11, 1986 · N323BA · Minor damage > Just after the beginning of a descent for landing a rudder cable failed completely, rendering the rudder inoperative. The aircraft landed uneventfully. Metallurgical analysis revealed that the cable wore severely until it failed. Following an examination of… - [NTSB CHI87FA048](https://openairdocs.org/ntsb/CHI87FA048.md): Piper PA-28R-200 · N. Manitou Isl., MI · Accident · 2 fatal · Field investigation · Final report · Dec 11, 1986 · N32693 · Substantial damage > The plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake. - [NTSB ATL87LA040](https://openairdocs.org/ntsb/ATL87LA040.md): Hughes 269C · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Dec 10, 1986 · N58188 · Substantial damage > While flying at 300' to 500' AGL on a cable patrol flt, the plt heard a loud loise. The rotor RPM started to decay & the eng RPM increased sharply. The plt initiated an autorotation to a parking lot, but had to maneuver to avoid trees & a vehicle. The… - [NTSB MIA87FA046](https://openairdocs.org/ntsb/MIA87FA046.md): Hughes 369HS · Zephyrhills, FL · Accident · 2 fatal · Field investigation · Final report · Dec 9, 1986 · N8390F · Destroyed > A witness stated that she heard the eng on the helicopter quit. She looked out her window and watched the helicopter hit the ground, bounce, hit again, flip over and the tail broke off. The helicopter then burst into flames and exploded. Exam of the eng… - [NTSB FTW87LA030](https://openairdocs.org/ntsb/FTW87LA030.md): Cessna 305A · Mason, TX · Accident · No injuries · Limited investigation · Final report · Dec 9, 1986 · N5211G · Destroyed > Private pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and… - [NTSB SEA87MA035](https://openairdocs.org/ntsb/SEA87MA035.md): Cessna TU206G · Jean, NV · Accident · 6 fatal · Major investigation · Final report · Dec 7, 1986 · N732ZF · Destroyed > While en route at night on an IFR flt plan, the acft ran out of fuel. Subsequently, the plt was provided vectors toward a hiway for a forced lndg. However, before reaching the area of the hiway, the acft crashed on rising terrain at an elev of about 4000 ft.… - [NTSB LAX87LA059](https://openairdocs.org/ntsb/LAX87LA059.md): Cessna 152 · Davis, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1986 · N25592 · Substantial damage > A Cessna 152 nosed over in a rough plowed field after a partial loss of power while on a night VFR pleasure flight. The pilot indicated that he was on a date with his girl friend and offered to demonstrate negative gravity to her. He slowed the aircraft and… - [NTSB FTW87FA029](https://openairdocs.org/ntsb/FTW87FA029.md): Piper PA-28R-200 · Petersburg, TX · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1986 · N4475F · Destroyed > Acft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given… - [NTSB MIA87LA044](https://openairdocs.org/ntsb/MIA87LA044.md): Cessna 150K · Apollo Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1986 · N6330G · Substantial damage > While in cruise flt at 600 feet a sudden loss of engine power occurred. Attempts to restart the engine were unsuccessful and the aircraft was ditched. Post accident examination of the engine revealed no evidence of mechanical failure or malfunction. The icing… - [NTSB MIA87LA042](https://openairdocs.org/ntsb/MIA87LA042.md): Cessna T210L · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1986 · N130LJ · Destroyed > The eng lost power while the acft was in cruise flt at 6000' over the atlantic ocean, aprx 6 hrs & 32 min after takeoff. Subsequently, the acft was ditched in the ocean when the eng could not be restarted. The acft then sank & was not recovered. Calculations… - [NTSB FTW87LA028](https://openairdocs.org/ntsb/FTW87LA028.md): Piper PA-28R-180 · Montgomery, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1986 · N3171R · Substantial damage > A private pilot check ride was interrupted by a forced landing on a golf course after having experienced severe vibrations and a loss of power. During the forced landing the acft collided with a 10 ft tall tree and nosed down to terrain impact. Investigation… - [NTSB FTW87LA027](https://openairdocs.org/ntsb/FTW87LA027.md): Cessna 150K · Georgetown, TX · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N5809G · Destroyed > The plt experienced a loss of pwr due to fuel exhaustion during the x-country flt. The plt elected to divert to Georgetown, TX, during the flt to refuel. The engine quit aprx 4 to 6 miles north of the aprt. The plt attempted to make the arpt with inadequate… - [NTSB ATL87MA035](https://openairdocs.org/ntsb/ATL87MA035.md): Bell 206L-1 · Jamestown, TN · Accident · 4 fatal · Major investigation · Final report · Dec 3, 1986 · N3898U · Destroyed > The helicopter was being used in an emerg med svc/med-evac (EMS) opn. At 0230, the plt obtained a partial wx briefing. He was advised of flt prctns for IFR wx thru-out the area with low ceilings, fog, precip & mtns obscd. The flt departed nashville at 0245 &… - [NTSB NYC87LA043](https://openairdocs.org/ntsb/NYC87LA043.md): Piper PA-28-161 · Pine Bush, NY · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1986 · N8297Y · Substantial damage > The CFI and student were practicing a simulated eng failure when the accident occurred. At 1700 ft MSL, during the simulated emergency descent, the CFI applied full throttle to terminate the simulation and eng pwr could not be regained. During the forced… - [NTSB MKC87FA027](https://openairdocs.org/ntsb/MKC87FA027.md): Cessna 177RG · Colby, KS · Accident · 1 fatal · Field investigation · Final report · Nov 30, 1986 · N7692U · Destroyed > The non-instrument rated pilot filed an IFR flight plan after being briefed. There was freezing drizzle to the west that was moving toward the departure area. The airplane took off into a low ceiling with near freezing temperature. Pilot attempted to climb to… - [NTSB LAX87LA058](https://openairdocs.org/ntsb/LAX87LA058.md): Cessna 182L · Oceano, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 30, 1986 · N66CF · Destroyed > Witnesses stated that while the acft was climbing after takeoff, it appeared to be lower than normal. One witness rprtd that the eng sounded as if it was running rough. Another witness stated that the acft had begun making a left turn when he saw flames… - [NTSB ATL87LA033](https://openairdocs.org/ntsb/ATL87LA033.md): Mooney M20G · Painesvile, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1986 · N3683N · Substantial damage > The plt reported a complete engine failure while conducting a pleasure flt. Following the failure, the plt attempted to restart the engine, but failed. At this point the acft was about two miles south of casement arpt. The reported winds were gusting to 25… - [NTSB ATL87IA032](https://openairdocs.org/ntsb/ATL87IA032.md): Mooney M20F · Columbus, GA · Incident · No injuries · Incident investigation · Final report · Nov 30, 1986 · N3782N · Minor damage > Plt rpted he was descending in IMC for instrument approach when eng quit, restarted for 30 sec after switching fuel tanks, and quit again. Acft broke out of clouds about 700 feet, plt landed on interstate. Eng exam showed alternate air door seal blocking… - [NTSB MKC87LA026](https://openairdocs.org/ntsb/MKC87LA026.md): Piper PA-32-300 · Harrison, AR · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1986 · N4031R · Substantial damage > The routine business flt had progressed normally until approaching bentonville, Arkansas. The PIC rptd his eng ran rough for a very brief period and quit. Emerg procedures were conducted but a restart was impossible. Only 1.5 hrs of flt had transpired since… - [NTSB DEN87FA023](https://openairdocs.org/ntsb/DEN87FA023.md): Beech A36TC · Steamboat Sprgs, CO · Accident · 5 fatal · Field investigation · Final report · Nov 29, 1986 · N36TS · Destroyed > Plt and four paxs were returning home from a ski vacation. A witness at the arpt observed a normal takeoff and saw the acft turn towards an area of high terrain located approximately 1.5 miles from the Steamboat arpt. The witness observed N36TS continue on a… - [NTSB CHI87LA045](https://openairdocs.org/ntsb/CHI87LA045.md): Hiller UH-12B · Capac, MI · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N48209 · Substantial damage > Ten minutes after takeoff and just prior to letdown from 350 feet AGL a main rotor blade drag strut failed due to progressive fatigue through a threaded portion of the strut. Only partial control of the helicopter was possible after the failure. The pilot… - [NTSB NYC87DGM01](https://openairdocs.org/ntsb/NYC87DGM01.md): Mooney M20F · Eighty Four, PA · Accident · Serious injuries · Final report · Nov 28, 1986 · N6314Q · Substantial damage > The pilot reported experiencing a rise in the acft's EGT and a loss of power during cruise flt. A forced landing was made during which the acft contacted trees. Examination of the fuel system showed that both the main fuel screen and the micro screen in the… - [NTSB CHI87LA037](https://openairdocs.org/ntsb/CHI87LA037.md): Mooney M20K · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Nov 28, 1986 · N3691H · Substantial damage > Following an engine power loss due to fatigue of the #1 cylinder, the plt force landed the acft on a highway. The highway was the only available landing area, according to the plt. On landing rollout, the plt was forced to swerve the acft off the paved… - [NTSB ATL87LA031](https://openairdocs.org/ntsb/ATL87LA031.md): Piper PA-28-140 · Waynesboro, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1986 · N32106 · Substantial damage > The plt called apch control & asked for vectors to the nearest field & said he was low on fuel. Vectors were provided but the eng lost power & the acft was damaged during a landing in a wooded area. An investigation revealed the acft had been flying for aprx… - [NTSB MIA87LA039](https://openairdocs.org/ntsb/MIA87LA039.md): Navion H · Ft. Pierce, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1986 · N2507T · Substantial damage > The plt stated that while en route to boca raton, FL, he experienced complete electrical failure near labelle, FL. He continued inbound but when in the boca raton area, encountered other traffic and because of the congestion decided to fly north along the… - [NTSB MIA87IA038](https://openairdocs.org/ntsb/MIA87IA038.md): Beech BE-95-55 · Ft. Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Nov 27, 1986 · N5WE · No damage > The private pilot suffered a massive heart attack in cruise flight shortly after take-off. The pilots wife who held an expired private pilots certificate took over and landed successfully. The pilot was pronounced deceased upon arrival at a local hospital. No… - [NTSB CHI87DEX03](https://openairdocs.org/ntsb/CHI87DEX03.md): Cessna 172N · Raymond, OH · Accident · 3 fatal · Final report · Nov 27, 1986 · N4767E · Destroyed > The accident aircraft impacted in an open field shortly after a predawn departure from an unattended airport. IMC prevailed an no flight plan was in effect. In a conversaton held the day before with a local pilot the pilot of the accident aircraft stated his… - [NTSB MKC87LA025](https://openairdocs.org/ntsb/MKC87LA025.md): Cessna 150 · Nevada, MO · Accident · No injuries · Limited investigation · Final report · Nov 26, 1986 · N5976T · Substantial damage > The PIC preflighted his acft prior to departure, but the preflight did not include refueling the acft which contained about 8 gallons of fuel. Normally the 8 gallons of fuel would have been sufficient to reach the destination arpt which was 21 statute miles… - [NTSB ATL87FA030](https://openairdocs.org/ntsb/ATL87FA030.md): Piper Aerostar 601P · Clinton, NC · Accident · 4 fatal · Field investigation · Final report · Nov 26, 1986 · N122FP · Destroyed > While en route on an IFR flt plan at FL180, the plt acknowledged instructions to dscnd to 16,000'. Later, the radar controller (cltr) noticed the acft had deviate fm course & was not replying with mode 'c' alt info. The ctlr reqd alt info & the plt responded,… - [NTSB MKC87LA023](https://openairdocs.org/ntsb/MKC87LA023.md): Cessna 150J · Colby, KS · Accident · No injuries · Limited investigation · Final report · Nov 25, 1986 · N60046 · Substantial damage > The pilot stated that he departed his private airstrip, low on fuel, intending to refuel at the next stop where he was to conduct a business transaction. Unable to secure fuel there, and showing one quarter of a tank on each fuel gauge, he departed for Colby… - [NTSB MIA87LA036](https://openairdocs.org/ntsb/MIA87LA036.md): Piper PA-34-200T · Isabela, PR · Accident · 2 fatal · Limited investigation · Final report · Nov 25, 1986 · N888MD · Destroyed > The acft was reported missing while on a personal flight from san juan PR to aguadilla PR. The plts last radio contact was with aguadilla tower requesting an alternate arpt to land because they were in heavy rain. The coast guard initiated a search and found… - [NTSB ATL87MA028](https://openairdocs.org/ntsb/ATL87MA028.md): Bell 206B · Cincinnati, OH · Accident · 2 fatal · Major investigation · Final report · Nov 25, 1986 · N59610 · Destroyed > The owner/operator (oper) of a flying service provided acft for broadcasting stations in the area. A radio station had contracted with the oper to provide a helicopter (helo, N59610) & a plt to take a news rprtr on a local traffic watch. The oper rprtd that… - [NTSB LAX87LA047](https://openairdocs.org/ntsb/LAX87LA047.md): Piper PA-28-180 · Merced, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1986 · N8474W · Substantial damage > During the return leg of a round robin cross country, the aircraft experienced a loss of power approximately 10 miles from the destination airport. About 15 minutes earlier, the pilot had deliberately run the left fuel tank dry. At that time, the right tank… - [NTSB MKC87FA022](https://openairdocs.org/ntsb/MKC87FA022.md): Piper PA-28-181 · Summersville, MO · Accident · 1 fatal · Field investigation · Final report · Nov 23, 1986 · N4326P · Destroyed > The PIC had flown his acft fm springfield, MO to olathe, Kansas to have some repair work accomplished and was to return that same day. The PIC never returned to springfield. The PIC had flown to salem, ill where witnesses stated they observed that he was… - [NTSB LAX87LA352](https://openairdocs.org/ntsb/LAX87LA352.md): Cessna 180K · Lakeport, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 23, 1986 · N66039 · Destroyed > The plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was… - [NTSB LAX87LA051](https://openairdocs.org/ntsb/LAX87LA051.md): Cessna 152 · Waipahu, HI · Accident · No injuries · Limited investigation · Final report · Nov 22, 1986 · N5327M · Substantial damage > The plt dragged both wings through a sugar cane crop during landing roll on a gravel road after a partial loss of power. The engine had 4040 total hours and had been previously overhauled 1655 hours prior. The plt indicated that the eng had a top overhaul… - [NTSB FTW87FA021](https://openairdocs.org/ntsb/FTW87FA021.md): Mooney M20E · Arcola, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1986 · N9347M · Destroyed > The plt departed Arcola, TX, VFR, on rwy 10, made a 180 degree left climbing turn and entered clouds at about the boundary line on the west side of the arpt. The radar operator stated the acft continued westbound one to two miles beyond the arpt then entered… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=318 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=317 --- 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.