# 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 339 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC85FNA02](https://openairdocs.org/ntsb/NYC85FNA02.md): Mcpherson Evans VP-1 · Boxborough, MA · Accident · Serious injuries · Final report · Jun 11, 1985 · N106JM · Substantial damage > The pilot experienced an engine failure and allowed the airspeed to decrease until the aircraft stalled and spun to the ground. The cause of the engine failure was not determined. The pilot received serious injuries and the homebuilt aircraft received… - [NTSB MIA85LA189](https://openairdocs.org/ntsb/MIA85LA189.md): Lake LA-4-200 · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Jun 11, 1985 · CGIBB · Substantial damage > The plt stated that just after takeoff, at about 800 ft alt the eng lost pwr. He then made an emerg landing in a fld and the acft struck a ditch during the landing roll. Post accident examination revealed both magneto cases were cracked and the #1 cly fuel… - [NTSB FTW85LA255](https://openairdocs.org/ntsb/FTW85LA255.md): Piper PA-28-181 · Tahlequah, OK · Accident · No injuries · Limited investigation · Final report · Jun 11, 1985 · N1601S · Substantial damage > The plt stated the acft was in flt slightly more than three hrs after it was refueled, before fuel exhaustion occurred. The acft reportedly was leaned during the flt. Post accident examination revealed no evidence of any fuel system leaks. Reason for the fuel… - [NTSB SEA85LA132](https://openairdocs.org/ntsb/SEA85LA132.md): Grumman G-164A · Kendrick, ID · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N7997 · Substantial damage > The plt had finished spraying a field & was returning to the ag strip when the eng failed. He made an emerg landing in a barley field which was muddy & soft. During the landing roll, the wheels sank in the terrain & the acft nosed over. An exam revealed that… - [NTSB LAX85LA270](https://openairdocs.org/ntsb/LAX85LA270.md): Grumman G-164 · Biggs, CA · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N363Y · Substantial damage > The plt stated that while loading the acft with spray mix he looked at his fuel quantity gage and believed he had enough fuel for one more aerial application flt. The plt continued to state that shortly after liftoff the engine quit and a forced landing was… - [NTSB CHI85FEX02](https://openairdocs.org/ntsb/CHI85FEX02.md): Cessna 310C · Greenfield, IN · Accident · Serious injuries · Final report · Jun 9, 1985 · N1773H · Substantial damage > While en route, the l eng suddenly lost power & would not restart, so the plt feathered the l prop. After letting it cool aprx 5 min, he tried restarting it again, but still was unable. He stated he thought he then secured (feathered) the l eng. The plt… - [NTSB DEN85LA151](https://openairdocs.org/ntsb/DEN85LA151.md): Beech B35 · Chinook, MT · Accident · No injuries · Limited investigation · Final report · Jun 7, 1985 · N5099C · Substantial damage > About 10 min after takeoff, the acft was damaged during a forced landing after the eng began sputtering & then lost power. The plt reported that he made a normal takeoff with the cowl flaps open & the mixture rich. After climbing about 1100 ft (to 3500 ft… - [NTSB ATL85FA181](https://openairdocs.org/ntsb/ATL85FA181.md): Piper PA-32R-301T · Newnan, GA · Accident · Minor injuries · Field investigation · Final report · Jun 6, 1985 · N8215B · Substantial damage > The eng started running rough then quit. The plt landed in awarehouse parking lot between two rows of 40-45 foot trailers. Exam of the eng revealed that the sharp edges of the roll pin had worn through the centering spacer for the tach drive ass'y. which then… - [NTSB MKC85LA121](https://openairdocs.org/ntsb/MKC85LA121.md): Cessna A188B · Marvell, AR · Accident · No injuries · Limited investigation · Final report · Jun 3, 1985 · N4865Q · Substantial damage > Plt stated that the engine stopped producing power after a reduction to cruise power. Touchdown during the forced lanidng was hard. The engine ran satisfactorily during post crash testing and cause of the loss of power could not be determined. - [NTSB ATL85FA179](https://openairdocs.org/ntsb/ATL85FA179.md): Piper PA-28-140 · Kennesaw, GA · Accident · 3 fatal · Field investigation · Final report · Jun 3, 1985 · N8704N · Substantial damage > Prior to takeoff the plt and his brother-in-law added 20 gallons of automotive fuel to the acft fuel tanks. The level of the fuel, according to the brother-in-law, was below the filler neck tabs. After about three hrs of flt the plt radioed a mayday and… - [NTSB BFO85IA050](https://openairdocs.org/ntsb/BFO85IA050.md): Douglas DC-10-30F · Chantilly, VA · Incident · No injuries · Incident investigation · Final report · Jun 2, 1985 · N106WA · No damage > After climbing up to and leveling off at 37,000 feet, the crew of the DC-10-30F noticed that the york control of the captain and the first officer moved laterally independently of each other for approximately two inches. After making an unscheduled uneventful… - [NTSB DEN85LA146](https://openairdocs.org/ntsb/DEN85LA146.md): Piper PA-25-260-C · Ordway, CO · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N4926Y · Destroyed > The airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the… - [NTSB DEN85LA145](https://openairdocs.org/ntsb/DEN85LA145.md): Cessna 182 · Byers, CO · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N759QY · Substantial damage > Plt stated that he was 'in a rush to get home' after his extended trip. He continued to state 'I wanted to get home thatafternoon without another stop and I wanted the performance figures to show me that I could.' The plt executed an emerg landing after the… - [NTSB BFO85FA049](https://openairdocs.org/ntsb/BFO85FA049.md): Bell 222U · Milford, VA · Accident · No injuries · Field investigation · Final report · May 31, 1985 · N3180K · Substantial damage > The helo was in level cruise flt at 1500 ft and 115 KTS when the no. 2 eng chip light illuminated, accompanied by lowering oil pressure. The plt reduced pwr and started a rt turn to return to base when half way thru the turn a loud bang occurred followed by… - [NTSB ATL85LA176](https://openairdocs.org/ntsb/ATL85LA176.md): Cessna 172 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · May 31, 1985 · N5221F · Substantial damage > The plt reported that during a descent to 2100 ft, intermediate level offs were made at 5000, 4000, & 3000 ft. he stated that at 2200 ft, carb heat was removed & power was applied for the level off. However, when the throttle was advanced, the eng began… - [NTSB NYC85FNC04](https://openairdocs.org/ntsb/NYC85FNC04.md): Bell 206B · W. Brattleboro, VT · Accident · Serious injuries · Final report · May 30, 1985 · N23LV · Destroyed > The acft lost pwr during normal cruise. The plt attempted to autorotate into a clearing in the trees. Post accident exam discovered an air leak in the fuel control. The pressure compressor discharge (pcd) line 'b' nut was disconnected from the fuel control.… - [NTSB NYC85FHD02](https://openairdocs.org/ntsb/NYC85FHD02.md): Cessna 210F · Princeton, NJ · Accident · Serious injuries · Final report · May 29, 1985 · N5807F · Destroyed > The acft collided with trees & crashed after overflying mercer cty arpt on a special VFR clearance. The acft had descended to 900 ft to overfly mercer and was attempting to proceed VFR to Princeton arpt to land when it contacted trees and crashed. The wx was… - [NTSB NYC85FA138](https://openairdocs.org/ntsb/NYC85FA138.md): Mcdonnell Douglas DC-10-10 · Jamaica, NY · Accident · No injuries · Field investigation · Final report · May 28, 1985 · N108AA · Substantial damage > The forward one-third portion of the core cowl door on no. 3 engine separated in flight first striking the leading edge of the right wing, then puncturing the fuselage. Causing rapid decompression at FL 170. The core cowl door latches were not adjusted & core… - [NTSB MIA85FA178](https://openairdocs.org/ntsb/MIA85FA178.md): Airbus Industrie A-300B4-2C · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Field investigation · Final report · May 28, 1985 · N206EA · No damage > While established in cruise flight conditions the commercial airliner encountered an area of forecast thunderstorms. The captain elected to attempt to fly through the area. As the airliner was attempting to avoid the thunderstorms it encountered one rapid up… - [NTSB ATL85LA175](https://openairdocs.org/ntsb/ATL85LA175.md): Piper PA-28-140 · Athens, AL · Accident · No injuries · Limited investigation · Final report · May 28, 1985 · N8816N · Substantial damage > The acft lost pwr while en route from kenosha, WI, to decatur, AL, and attempted a forced landing on an ag strip. Duringthe landing roll the acft struck a truck which was parked in the middle of the runway. During post crash examination of the acft no fuel… - [NTSB SEA85LA123](https://openairdocs.org/ntsb/SEA85LA123.md): Cessna 150 · Wamic, OR · Accident · Minor injuries · Limited investigation · Final report · May 27, 1985 · N5914G · Substantial damage > A forced landing was made following a loss of pwr. The acft contacted two fences, a ditch then nosed over during the forced landing. Post accident inspection revealed no fuel in the carburetor float chamber or in the accelerator pump chambers. - [NTSB MKC85LA112](https://openairdocs.org/ntsb/MKC85LA112.md): Cessna 152 · Goddard, KS · Accident · Minor injuries · Limited investigation · Final report · May 27, 1985 · N95623 · Substantial damage > On a final leg of a x-country flt, the eng of the acft began to faulter finally quitting a few minutes later. The subsequent forced landing resulted in the acft nosing over. An inspection of the acft revealed a residual amt of fuel in the wing fuel tanks.… - [NTSB SEA85LA125](https://openairdocs.org/ntsb/SEA85LA125.md): Cessna 152 · Concord, CA · Accident · No injuries · Limited investigation · Final report · May 26, 1985 · N66942 · Substantial damage > The acft contacted power lines during a night forced landing following fuel exhaustion. The plt had flown from Concord, CA, to reno, NV, and was returning to Concord when the accident occurred. The plt was recently checked out in the acft and was used to… - [NTSB NYC85FHJ03](https://openairdocs.org/ntsb/NYC85FHJ03.md): Piper PA-28-161 · Lewisboro, NY · Accident · Minor injuries · Final report · May 24, 1985 · N2172N · Substantial damage > The acft nosed over on a golf course after striking trees during a forced lndg. The acft had lost power during climb to cruise. Post acc exam showed a failed exhaust valve - [NTSB FTW85LA233](https://openairdocs.org/ntsb/FTW85LA233.md): Mooney M20 · Hamilton, TX · Accident · Serious injuries · Limited investigation · Final report · May 24, 1985 · N853B · Destroyed > The plt stated the acft and engine assy had experienced execssive vibrations while in flt followed by the windshield being covered with oil immediately after the vibration started. The propeller assy had become loose from the engine mount and separated at… - [NTSB CHI85LA207](https://openairdocs.org/ntsb/CHI85LA207.md): Mooney M-20G · Bessemer, MI · Accident · No injuries · Limited investigation · Final report · May 24, 1985 · N3910N · Substantial damage > The pilot felt he had enough fuel for the planned trip. Prior to reaching his destination the engine lost power & would not restart using either fuel tank. The pilot failed to lower the landing gear prior to landing on a road. The acft struck a utility pole… - [NTSB BFO85LA031](https://openairdocs.org/ntsb/BFO85LA031.md): Cessna U206F · Piney Point, MD · Accident · Minor injuries · Limited investigation · Final report · May 24, 1985 · N1803Q · Substantial damage > While descending in IFR conditions near the destination, the eng lost power at an alt of about 3800 to 4000 ft. the plt requested vectors toward land & the nearest arpt; however, when it broke out of the clouds at about 1000 ft AGL, the acft was still over… - [NTSB SEA85FA233](https://openairdocs.org/ntsb/SEA85FA233.md): Cessna 172N · Remote, OR · Accident · 2 fatal · Field investigation · Final report · May 23, 1985 · N4871G · Destroyed > During a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx… - [NTSB FTW85FA230](https://openairdocs.org/ntsb/FTW85FA230.md): Piper PA-28-140 · Junction City, KS · Accident · 1 fatal · Field investigation · Final report · May 22, 1985 · N7053R · 2 aircraft · Destroyed > Army UH-1V and N7053R, a Piper PA-28, collided in mid air at 700 feet AGL. Both acft were in lvl flt. UH-1V was operating on a medical evacuation flt with a crew of four, one patient and two attendants. The UH-1V executed a successful autorotation with… - [NTSB ATL85FA171](https://openairdocs.org/ntsb/ATL85FA171.md): Piper PA-28-181 · Charleston, WV · Accident · 2 fatal · Field investigation · Final report · May 22, 1985 · N8460M · Destroyed > The acft collided with the terrain about 1 mile short of the rwy threshold during an IFR apprch on a dark night in IMC wx. The plt had been briefed on the wx and was given the ceiling at his destination as below VFR minimums. The non-instrument rated plt… - [NTSB ATL85LA188](https://openairdocs.org/ntsb/ATL85LA188.md): Cessna 172N · Monticello, GA · Accident · Minor injuries · Limited investigation · Final report · May 21, 1985 · N6201E · Destroyed > About 20 min after takeoff, while cruising at 5000 ft, the plt observed oil on the windshield & noted a decrease in oil pressure. He turned back toward the departure arpt & reduced the power in an attempt to prolong eng life. A short time later, the eng began… - [NTSB SEA85LA118](https://openairdocs.org/ntsb/SEA85LA118.md): Schweizer SGS 2-33A · Wenatchee, WA · Accident · Minor injuries · Limited investigation · Final report · May 20, 1985 · N65907 · Substantial damage > While returning to the arpt to land, the acft encountered strong downdrafts of 600 to 800 fpm. An off arpt landing was made and while turning from base to final, the left wing tip struck the ground. A groundloop then occurred. - [NTSB SEA85FA121](https://openairdocs.org/ntsb/SEA85FA121.md): Piper PA-23-250 · Blyn, WA · Accident · 4 fatal · Field investigation · Final report · May 20, 1985 · CFCTC · Destroyed > The acft impacted rising terrain at the 1860 ft level during an IFR flt in IMC conditions. The acft was reportedly to fly 'VFR on top' or IFR at 3000 plus ft enroute to portland. The plt was off course for destination when it impacted mt. Blyn. The acft trim… - [NTSB DEN85LA139](https://openairdocs.org/ntsb/DEN85LA139.md): Boeing A75N1 · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N49926 · Substantial damage > The plt reported that as he arrived at the destination (canyonlands, UT), there was a storm over the arpt, so he diverteded toward delta, CO. About 10 mi from delta, he encountered another storm, so he turned toward Grand Junction, CO. Before reaching the… - [NTSB CHI85LA202](https://openairdocs.org/ntsb/CHI85LA202.md): Taylorcraft BC-12D · Michigan City, IN · Accident · Minor injuries · Limited investigation · Final report · May 19, 1985 · N44345 · Substantial damage > Shortly after takeoff the acft experienced a total loss of power & made an emerg landing into a corn field. Investigation disclosed that there was no gas in the carburetor. The plt stated that there was about 10 gals in the acft prior to takeoff. No fuel was… - [NTSB CHI85LA201](https://openairdocs.org/ntsb/CHI85LA201.md): Cessna 150 · Durand, IL · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N50125 · Substantial damage > While on a night flight the acft experienced a complete loss of engine power. An emergency landing was made to a road. During the landing the right wing of the acft strucka street sign & power pole. The plt stated to the authorities that the acft had… - [NTSB SEA85LA119](https://openairdocs.org/ntsb/SEA85LA119.md): Cessna 150M · Santa Rosa, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1985 · N704UV · Substantial damage > While on a short local flight to a costal area and return. The engine lost some power. Carburetor heat was applied but no increase in power was noted. The plt then set up a glide with intentions of making a landing onto the beach area. At about 500 feet… - [NTSB DEN85LA135](https://openairdocs.org/ntsb/DEN85LA135.md): Cessna 172 · Loma, MT · Accident · No injuries · Limited investigation · Final report · May 18, 1985 · N6462D · Substantial damage > The acft contacted power lines which cross over the Missouri river. The lines are aprx 150-200 ft above the river on one side and aprx 45 ft above the river on the opposite side. The plt stated he was flying along the river at an alt of aprx 75 ft when… - [NTSB CHI85LA200](https://openairdocs.org/ntsb/CHI85LA200.md): Cessna 207 · Golden Valley, MN · Accident · Minor injuries · Limited investigation · Final report · May 18, 1985 · N91043 · Destroyed > Shortly after takeoff, on the last leg on it's flight, the engine of the air cargo acft started to sputter. The plt turned the fuel selector handlr from the left tank to another position & turned on the boost pump. The engine stopped running & the plt elected… - [NTSB ATL85FA165](https://openairdocs.org/ntsb/ATL85FA165.md): Piper PA-28-161 · Milledgeville, GA · Accident · Serious injuries · Field investigation · Final report · May 18, 1985 · N8289H · Substantial damage > Acft left home airport at 0400. Flt plan left with FBO indicated 6 hours to destination, no en route stops, and 4+30 hours fuel on board. Fuel consumption calculated, 4+36 hours endurance available. Acft flew 4+47 hours. The pilot told approach control acft… - [NTSB MKC85LA103](https://openairdocs.org/ntsb/MKC85LA103.md): Airship Industries Skyship · Columbus, KS · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · GSKSB · Substantial damage > In cruise flt nearing Columbus, Kansas the plt at the controls of the Airship experienced a pitching up of the Airship's nose. The elevator control did not respond to the plt input to counter the nose up pitch. Also noted was a loss of pressure from the rear… - [NTSB MIA85FKG02](https://openairdocs.org/ntsb/MIA85FKG02.md): Cessna 150H · Tallahassee, FL · Accident · Serious injuries · Final report · May 17, 1985 · N50239 · Substantial damage > The acft collided with wires during a forced landing off the arpt. The plt had called on the radio saying he was unable to make the arpt and was landing in a clearing. The acft ended up inverted after the collision with the wires. Post accident examination… - [NTSB ANC85FA085](https://openairdocs.org/ntsb/ANC85FA085.md): Cessna C-207A · Golovin, AK · Accident · 2 fatal · Field investigation · Final report · May 16, 1985 · N73635 · Substantial damage > According to the pilot-in-command, he was attempting to fly through a mountain saddle. As he turned towards the mountain and began his climb the weather deteriorated rapidly with ceilings zero, visibility zero and severe turbulence. The airplane struck the… - [NTSB SEA85FA113](https://openairdocs.org/ntsb/SEA85FA113.md): Cessna 177RG · Murphy, ID · Accident · 2 fatal · Field investigation · Final report · May 14, 1985 · N1815Q · Destroyed > Plt received a preflight wx brief indicating a recent frontal passage in the area with strong winds and trubulence associated with thundershowers along the initial route of flight until clear of the owyhee mountains. No flt plan was filed. Radar tracked the… - [NTSB ANC85LA084](https://openairdocs.org/ntsb/ANC85LA084.md): Piper PA-32-300 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · May 14, 1985 · N4080W · Substantial damage > While cruising at about 2000 ft, the top eng cowling came off, rupturing an eng oil line & breaking a hole in the left side of the windshield. Oil then covered the windshield. Due to the loss of oil, the plt shut down the eng & landed on a beach. During the… - [NTSB SEA85LA111](https://openairdocs.org/ntsb/SEA85LA111.md): Beech H-35 · Owyhee Reserv., ID · Accident · No injuries · Limited investigation · Final report · May 13, 1985 · N5425D · Substantial damage > The flt departed from boise, Idaho, on the left main fuel tank. Fifteen minutes into the flt the plt switched to the left auxiliary tank. Several minutes later, the engine ceased operating dispite the plts switching back to the left main fuel tank. An engine… - [NTSB ANC85IA083](https://openairdocs.org/ntsb/ANC85IA083.md): Cessna 207A · Cape Simpson, AK · Incident · No injuries · Incident investigation · Final report · May 13, 1985 · N9943M · Minor damage > # 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut. - [NTSB DEN85FA134](https://openairdocs.org/ntsb/DEN85FA134.md): Enstrom F-28F · Carrizozo, NM · Accident · 1 fatal · Field investigation · Final report · May 12, 1985 · N8618A · Substantial damage > The student pilot departed albiquerque, NM with less than full fuel tanks and a worn out eng driven fuel pump which allowed fuel to be pumped overboard. No flt plan was filed. During his VMC x-country flt, the eng failed and an unsuccessful autorotation… - [NTSB ATL85LA160](https://openairdocs.org/ntsb/ATL85LA160.md): Cessna 150J · Atkins, VA · Accident · Minor injuries · Limited investigation · Final report · May 12, 1985 · N51347 · Substantial damage > The acft nosed over during a forced landing following a loss of pwr which resulted from fuel exhaustion. On the day prior to the accident the acft had experienced a total electrical failure. The plt stated that on the day of the accident, he lowered a rope… - [NTSB NYC85FFJ02](https://openairdocs.org/ntsb/NYC85FFJ02.md): Rotec Engineering Rally 3 · Constantia, NY · Accident · No injuries · Final report · May 11, 1985 · N302RE · Substantial damage > The pilot and passenger in a rally 3 had been airborne for approximately 3 minutes when he experienced a engine failure. The pilot set up for a landing and eventually got the engine restarted. After flying close to the ground for about 1/4 mile he started… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=340 ## 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=339 --- 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.