# 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 332 of 718 · 35,889 cases ## Cases, newest first - [NTSB DEN86LA021](https://openairdocs.org/ntsb/DEN86LA021.md): Piper PA-18-150 · Buffalo, SD · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 1985 · N6854P · Substantial damage > According to officials, the plt was searching for hunters when the acft he was flying contacted the ground. Witnesses stated that blowing snow, low overcast clouds & visibility of less than 1/2 mi prevailed at the time of the acdnt. A blood sample was taken… - [NTSB MIA86FA028](https://openairdocs.org/ntsb/MIA86FA028.md): Piper PA-32-260 · Sorrento, FL · Accident · 3 fatal · Field investigation · Final report · Nov 9, 1985 · N4862S · Destroyed > The flt was on a VFR x-country at 9500 ft with ATC flt following. The non-instrument rated plt advised ATC that he was unable to maintain VFR & climbed to 11,000 ft. he again avised he was unable to maintain VFR & was going to descend. The acft was observed… - [NTSB FTW86FRD02](https://openairdocs.org/ntsb/FTW86FRD02.md): Cessna 172P · Monroe, LA · Accident · No injuries · Final report · Nov 8, 1985 · N52995 · Substantial damage > On November 7, 1985, at approximately 1740 CDT, Cessna 172P, registration no. N52995, sustained substantial damage. Pilot stated that he was in cruise configuration at 5,500 feet, when Lycoming engine model O-260-D2J, serial no. L-10724-39A, lost power. Pilot… - [NTSB FTW86FQG03](https://openairdocs.org/ntsb/FTW86FQG03.md): Cessna 172N · Westbrook, TX · Accident · No injuries · Final report · Nov 8, 1985 · N733SG · Substantial damage > The acft nosed over during a precautionary landing on rough terrain. The plt reported that at aprx 600 ft AGL, a gradualdecrease in RPM was experienced. Carb heat was applied for about 15 secs but was removed when the RPM decrease continued. A precautionary… - [NTSB CHI86LA039](https://openairdocs.org/ntsb/CHI86LA039.md): Cessna T210N · Doran, MN · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N5106C · Substantial damage > While in cruise flt at 3000 ft MSL at night, the acft struck a bird with the left wing. The plt experienced some control problems but was able to retain sufficient control to affect a safe landing. Post-flt inspection revealed substantial damage to the left… - [NTSB ATL86LA022](https://openairdocs.org/ntsb/ATL86LA022.md): Cessna 172F · Hazelhurst, MS · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N8852U · Substantial damage > During cruise flight the engine experienced a loss of power and the pilot applied carb heat. The engine operated normally with the carb heat on and when it was turned off the engine again ran rough. The pilot again turned on the carb heat and the engine ran… - [NTSB MKC86FA023](https://openairdocs.org/ntsb/MKC86FA023.md): Piper PA-38-112 · Orrick, MO · Accident · Serious injuries · Field investigation · Final report · Nov 5, 1985 · N2468F · Destroyed > The student plt was briefed to practice stalls, slow flight, 720-degree turns and simulated forced landings with specialinstructions for the plt not to go below 500 ft AGL on the simulated forced landings. During one simulated forced landing, the propeller… - [NTSB SEA86LA021](https://openairdocs.org/ntsb/SEA86LA021.md): Cessna 180D · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Nov 4, 1985 · N15721 · Substantial damage > A forced landing was made onto muskeg due to a total loss of power. The pilot had just completed a 180 degree turn away from a fog bank when the engine quit. The left fuel tank contained 7 1/2 gallons and the right fuel tank contained 1 1/2 quarts of fuel.… - [NTSB MKC86LA022](https://openairdocs.org/ntsb/MKC86LA022.md): Cessna 152 · Hughes, AR · Accident · No injuries · Limited investigation · Final report · Nov 4, 1985 · N68414 · Substantial damage > The training flt progressed normally until a loss of pwr forced the student pilot and instructor to make a forced landing to a plowed field short of theri destination airport. The subsequent landing substaintially damaged their aircraft. An engine inspection… - [NTSB MKC86LA021](https://openairdocs.org/ntsb/MKC86LA021.md): Mooney M20K · Spring Hill, KS · Accident · No injuries · Limited investigation · Final report · Nov 4, 1985 · N231KB · Substantial damage > The pilot of this aircraft was returning from a business flight when the engine failed. During the forced landing, the aircraft rolled through a fence and then impacted a pole with one wing. The pilot stated that one connecting rod came through the side of… - [NTSB ATL86LA016](https://openairdocs.org/ntsb/ATL86LA016.md): Boeing 737 · Charleston, WV · Accident · Serious injuries · Limited investigation · Final report · Nov 3, 1985 · N787N · No damage > The flight departed Washington at about 1040 en route to Charleston, WV under instrument flight rules. The flight proceeded without incident, with occasional light to moderate turbulence during the climb. As the flight climbed through 26,000 feet the aircraft… - [NTSB NYC86LA028](https://openairdocs.org/ntsb/NYC86LA028.md): Piper PA-32-300 · New York, NY · Accident · No injuries · Limited investigation · Final report · Nov 2, 1985 · N4007W · Substantial damage > According to the pilot, the purpose of the flight was to provide the student with night flying instruction. The preflight and run up revelaed no discrepancies and 10 quarts of oil were determined to be in the engine. The aircraft proceeded south along the… - [NTSB FTW86FA023](https://openairdocs.org/ntsb/FTW86FA023.md): Cessna 152 · Arcadia, LA · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1985 · N93527 · Destroyed > The instrument flight instructor and student experienced a directional gyro failure. They covered the instrument and requested a return to their departure point. The aircraft was not equipped to fly the published approach. They requested a descent to an… - [NTSB DEN86LA016](https://openairdocs.org/ntsb/DEN86LA016.md): Hiller UH-12E · Vernal, UT · Accident · No injuries · Limited investigation · Final report · Nov 1, 1985 · N400AH · Substantial damage > The plt stated he had just departed a site located on top of a mountain, which is approximately 12,200 ft MSL. The pilot said 30 seconds later, the helicopter lost partial power. Requiring him to make a force landing. The inspection of the turbocharger… - [NTSB FTW86FPA03](https://openairdocs.org/ntsb/FTW86FPA03.md): Piper PA-28-235 · Yantis, TX · Accident · Minor injuries · Final report · Oct 31, 1985 · N9348W · Destroyed > The acft contacted a tree and a large bale of hay during a forced landing following a loss of pwr. Post accident inspection disclosed 18 gallons of fuel remained in the left main tank and 3 gallons remained in the left wing tip tank. Both right wing fuel… - [NTSB LAX86LA030](https://openairdocs.org/ntsb/LAX86LA030.md): Cessna 150H · San Andreas, CA · Accident · No injuries · Limited investigation · Final report · Oct 30, 1985 · N22264 · Substantial damage > The acft nosed over during a forced landing in a fld aprx 2 miles west of calaveras county arpt. The post-accident wreckage examination disclosed no evidence of fuel in the fuel tanks. The student plt stated that he was on the final leg of a solo x-country… - [NTSB CHI86LA113](https://openairdocs.org/ntsb/CHI86LA113.md): Cessna 152 · Greenville, MI · Accident · No injuries · Limited investigation · Final report · Oct 29, 1985 · N68741 · Substantial damage > The plt experienced engine failure due to fuel starvation ten miles north of his destination. During the forced landing the prop and left wing were substantially damaged. The plt stated that when he ran out of fuel the right fuel guage read between 1/4 and… - [NTSB LAX86LA029](https://openairdocs.org/ntsb/LAX86LA029.md): Schweizer G-164B · Gila Bend, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 28, 1985 · N8487K · Substantial damage > After spraying a field and while enroute to the landing site, the acft engine backfired followed by a rapid loss of power. The plt negotiated an emergency landing on a private dirt road. During the landing roll-out, the aircraft left wing struck a tree… - [NTSB DEN86LA015](https://openairdocs.org/ntsb/DEN86LA015.md): Cessna T210NII · Sterling, CO · Accident · No injuries · Limited investigation · Final report · Oct 28, 1985 · N1728U · Substantial damage > The plt indicated he had the arpt in site when the eng failed due to fuel exhaustion. The investigation revea led the eng tach showed a total lapsed time of 4.9 hrs flown on this one fuel load. The perfomance charts for this particular flt indicates a max flt… - [NTSB ATL86LA013](https://openairdocs.org/ntsb/ATL86LA013.md): Mooney M20E · Meridian, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 1985 · N5959Q · Substantial damage > The non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended for a flight to chattanooga, TN. The pilot was unable to maintain VFR conditions and attempted a precision approach. While being… - [NTSB NYC86LA022](https://openairdocs.org/ntsb/NYC86LA022.md): Cessna 152 · Bangor, ME · Accident · No injuries · Limited investigation · Final report · Oct 27, 1985 · N69127 · Substantial damage > The acft experienced and eng pwr loss on the return leg of a x-country solo instructional flt. Carb heat was applied and Bangor apch control was notified of the eng problem. The plts attempts to restart the eng failed and a landing was made in a fld where the… - [NTSB MIA86LA020](https://openairdocs.org/ntsb/MIA86LA020.md): Cessna 172F · Fort Walton Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1985 · N5219F · Substantial damage > The acft collided with power lines & crashed to the ground during a forced landing necessitated by an eng failure. The x-country flt had been in the air for 4 hrs and 35 mins. The acft's fuel capacity is 40 gals & the plt stated that fuel consumption was aprx… - [NTSB LAX86FA024](https://openairdocs.org/ntsb/LAX86FA024.md): Champion 7ECA · Seal Beach, CA · Accident · 1 fatal · Field investigation · Final report · Oct 27, 1985 · N7547F · Substantial damage > Based upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,… - [NTSB CHI86FA017](https://openairdocs.org/ntsb/CHI86FA017.md): Bell 47G-5 · Plainfield, WI · Accident · 1 fatal · Field investigation · Final report · Oct 27, 1985 · N7840S · Destroyed > The acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due… - [NTSB ATL86MA011](https://openairdocs.org/ntsb/ATL86MA011.md): Beech 58P · Forsyth, GA · Accident · 2 fatal · Major investigation · Final report · Oct 27, 1985 · N583AM · Destroyed > The flt was normal until the plt was tracking inbnd on the atlanta (atl) 128 deg radial twd the husky intxn & was told to make a 360 deg turn for spacing. After aprx 270 deg of turn, the plt was clrd to turn back inbnd, join the atl 128 deg radial & cont to… - [NTSB MKC86FCA01](https://openairdocs.org/ntsb/MKC86FCA01.md): Bede BD-5B · Cape Girardeau, MO · Accident · 1 fatal · Final report · Oct 26, 1985 · N548BD · Destroyed > The owner/builder had hired the plt to test fly the acft on its initial flt. Shortly after takeoff, the plt transmitted that he had an eng problem. He was cleared for an immediate landing & entered a downwind for rwy 28. As he continued & was turning from a… - [NTSB FTW86LPA01](https://openairdocs.org/ntsb/FTW86LPA01.md): Cessna 150M · Arlington, TX · Accident · No injuries · Final report · Oct 26, 1985 · N704MA · Substantial damage > The acft nosed over over in a fld during a forced landing. The plt reported that the cockpit began filling with smoke shortly after takeoff. Shortly thereafter the eng quit. The acft traveled aprx 700 ft during the landing roll before the nose gear dug into… - [NTSB MKC86LA015](https://openairdocs.org/ntsb/MKC86LA015.md): Mooney MK21 · Warren, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1985 · N3399X · Substantial damage > At cruise level flt the plt rptd a malfunctioning engine. The plt was cleared to descend to an airport in the vicinity. The precautionary landing was initiated due to an oil pressure decline. Approaching for the landing the plt rptd the engine completely quit… - [NTSB MKC86FA017](https://openairdocs.org/ntsb/MKC86FA017.md): Silvaggio Cassutt 111M · Plattsburg, MO · Accident · Serious injuries · Field investigation · Final report · Oct 25, 1985 · N4AS · Substantial damage > The acft was level, in cruise when the plt noticed high eng temperatures. He stated that he started a shallow climb and headed for the nearest arpt. En route to nearest arpt, smoke came into the cockpit and the plt heard a loud noise that was accompanied by… - [NTSB LAX86FA025](https://openairdocs.org/ntsb/LAX86FA025.md): Cessna 182P · Sacramento, CA · Accident · No injuries · Field investigation · Final report · Oct 25, 1985 · N7371S · 2 aircraft · Substantial damage > As the Cessna 182P pilot flew through a control zone without establishing communications at an altitude of 3,500 ft, a Piper PA28 was beginning its approach for landing. The Piper's pilot was practicing instrument flight using a hood and a safety pilot. The… - [NTSB DEN86LA014](https://openairdocs.org/ntsb/DEN86LA014.md): Globe GC-1B · Albuquerque, NM · Accident · 1 fatal · Limited investigation · Final report · Oct 25, 1985 · N90333 · Substantial damage > The wife of the plt radioed her husband had become incapacitated. Two flt instructors departed in another acft to assist the non-rated wife, after being contacted by Albuquerque apch control. The flt instructors were able to assist the non-rated wife through… - [NTSB NYC86LA026](https://openairdocs.org/ntsb/NYC86LA026.md): Cessna 185 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 1985 · N8475Q · Destroyed > The floatplane experienced a pwr loss about 15 miles south of martha's vineyard VOR. The eng manifold pressure dropped and the RPM became erratic. The plt attempted to restart the eng using primary and emergency fuel pumps but the eng would not restart. The… - [NTSB FTW86LRG01](https://openairdocs.org/ntsb/FTW86LRG01.md): Bell 206B · Port O'Conner, TX · Accident · No injuries · Final report · Oct 23, 1985 · N376EH · Substantial damage > The acft rolled over after a forced lndg due to loss of power. The eng lost about 60 percent of its power during cruise at about 250 ft AGL. Post acc inspection showed that fuel line p/n 685481 b-nut had backed off the fuel control end of line 250C20 ipc. The… - [NTSB ATL86FLQ03](https://openairdocs.org/ntsb/ATL86FLQ03.md): Piper PA-28RT-201T · Hopkinsvile, KY · Accident · Minor injuries · Final report · Oct 23, 1985 · N8277Y · Substantial damage > The acft had electrical failure during an IFR flt and radio/radar contact was lost. The plt said he was in & out of the clouds during the final stages or the x-country flt. The cloud ceiling was about 800 ft where he finally descended & landed in a soybean… - [NTSB ATL86FA010](https://openairdocs.org/ntsb/ATL86FA010.md): Piper PA-34-220T · Hamilton, AL · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1985 · N8132L · Destroyed > At 1450 CDT, while the plt was cruising at 11,000', ARTCC broadcast info concerning SIGMET 17C, warning plts of thunder-storms with tops to FL 450. At 1613, radar data showed the acft at 11,300'. When asked about his alt, the plt replied he was in a cell &… - [NTSB ATL86FKG03](https://openairdocs.org/ntsb/ATL86FKG03.md): Cessna 182P · Hawkinsville, GA · Accident · No injuries · Final report · Oct 21, 1985 · N66RD · Destroyed > The acft caught fire during a forced lndg after losing eng power during cruise. The plt approached a hi-way for landing and smoke filled the cockpit. During rollout fire came thru the firewall and the plt evacuated the moving acft. The unoccupied acft… - [NTSB SEA86LA016](https://openairdocs.org/ntsb/SEA86LA016.md): Piper PA-20 · Ely, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 1985 · N1403C · Destroyed > The consensus of witnesses was that the plt & 2 pax had been awake all or most of the previous night & had consumed alcoholic beverages until at least 0100 PDT. One witness stated that the plt was 'cut off' from alcoholic drinks at 0100, but the 3 men… - [NTSB NYC86LA016](https://openairdocs.org/ntsb/NYC86LA016.md): Piper PA-28R-201T · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · Oct 20, 1985 · N43794 · Substantial damage > The acft collided with a large bird while in cruise flt. The leading edge of the ry wing was damaged. The acft was landed without further incident. - [NTSB LAX86LA018](https://openairdocs.org/ntsb/LAX86LA018.md): Champion 7ECA · Turlock, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1985 · N5059G · Substantial damage > The acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt… - [NTSB BFO86LA004](https://openairdocs.org/ntsb/BFO86LA004.md): Stinson 108-1 Voyager · The Plains, VA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1985 · N8422K · Substantial damage > While flying straight and level at 3100 feet MSL, over Virginia route 66 and route 245, the engine began to vibrate to the extent that the plt thought that it might separate from the airframe. The plt selected a field and set up an approach. On final, the plt… - [NTSB FTW86FA016](https://openairdocs.org/ntsb/FTW86FA016.md): Bell 222A · Charenton, LA · Accident · No injuries · Field investigation · Final report · Oct 17, 1985 · N5013H · Substantial damage > The helicopter had just completed a phase two check, twenty minutes into the flight the occupants heard a loud noise and a severe one-to-one vibration ensued. A successful emergency landing was performed. Examination revealed that one swash plate drive link… - [NTSB FTW86FA015](https://openairdocs.org/ntsb/FTW86FA015.md): Mitsubishi MU-2B-2D · El Paso, TX · Accident · 1 fatal · Field investigation · Final report · Oct 17, 1985 · N23CD · Destroyed > The plt canceled his IFR flt plan and attempted to fly VFR at a relatively low alt over mountainous terrain with low scattered clouds on a dark night. He reported a large lighted area as being downtown El Paso when in reality it was most likely coronado… - [NTSB ANC86LA004](https://openairdocs.org/ntsb/ANC86LA004.md): Cessna 206 · Tanana, AK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1985 · N35851 · Substantial damage > While en route, the eng lost power, so the plt made an emergency landing on a gravel bar. During the landing, the acft nosed over & came to rest in water. An exam revealed that the fuel sumps & lines were frozen & there was ice in the fuel pump. - [NTSB MKC86FA011](https://openairdocs.org/ntsb/MKC86FA011.md): Beech V35B · Sullivan, MO · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1985 · N18316 · Destroyed > The acft was observed going from level flt to straight up before stalling, turning over and spiraling straight down, at full throttle, toward the ground. Impact marks indicated a near vertical descent with initial impact on the nose of acft. Impact was in a… - [NTSB FTW86FA011](https://openairdocs.org/ntsb/FTW86FA011.md): Cessna 180 · Cisco, TX · Accident · 2 fatal · Field investigation · Final report · Oct 14, 1985 · N2368C · Destroyed > Non-instrument rated pvt pilot proceeded into instrument weather conditions. Control was lost and the aircraft impacted steep nose down in city limits. No record of a wx briefing being received by the pilot was found. No evidence of pre- impact failure or… - [NTSB SEA86LA008](https://openairdocs.org/ntsb/SEA86LA008.md): Piper PA-31-350 · Panaca, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1985 · N35533 · Substantial damage > A forced landing onto rough terrain was made due to fuel exhaustion. - [NTSB DEN86LA011](https://openairdocs.org/ntsb/DEN86LA011.md): Cessna 182P · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1985 · CGSPF · Destroyed > The plt stated that while on a return flt to calgary, alberta, Canada, over the mountainous terrain of glacier national park, he encountered a severe downdraft which forced the acft to the ground. The flt originated at kaispell, Montana. - [NTSB SEA86LA012](https://openairdocs.org/ntsb/SEA86LA012.md): Cessna 152 · Ontario, OR · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N24977 · Substantial damage > A forced landing occurred due to a total loss of power. Landing was accomplished onto a freshly plowed potato field where substantial damage occurred. No reason for the loss of power could be determined. - [NTSB NYC86LA010](https://openairdocs.org/ntsb/NYC86LA010.md): Mooney M20C · Ocean City, NJ · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N73SD · Substantial damage > The acft collided with a bird while descending for an apch to landing at Ocean City. Substantial damage resulted to the right horizontal stabilizer. The plt was able to maintain control of the acft with difficulty. A successful landing was accomlished.. - [NTSB NYC86FA006](https://openairdocs.org/ntsb/NYC86FA006.md): de Havilland DHC-6 · Homer City, PA · Accident · 1 fatal · Field investigation · Final report · Oct 12, 1985 · N3257 · Destroyed > The acft was observed flying at low altitude along about a 5 mile distance. Some witnesses described the acft altitude as just above treetops. Witness heard engine sounds and saw lights on the acft. The acft flight was on a southeast direction before it… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=333 ## 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=332 --- 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.