# 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 355 of 718 · 35,889 cases ## Cases, newest first - [NTSB ATL84LA156](https://openairdocs.org/ntsb/ATL84LA156.md): Cessna 182 · Burlington, NC · Accident · No injuries · Limited investigation · Final report · May 1, 1984 · N6128B · Substantial damage > The acft nosed over during a forced landing after the engine lost power. The plt said the fuel gauges were reading 1/4 to 1/2 full just before the engine quit. No fuel was found in the acft after the accident. The engine performed normally after refueling. - [NTSB SEA84LA096](https://openairdocs.org/ntsb/SEA84LA096.md): Hughes 369D · Toutle, WA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1984 · N779FA · Substantial damage > Plt was operating helicopter at 120 ft AGL with the aux fuel pump on when a ttl loss of pwr occurred. Autorotation was entered but a hard landing resulted in the main rotor blades cutting off the tail boom. Investigation revealed a fuel sample taken from the… - [NTSB LAX84FA275](https://openairdocs.org/ntsb/LAX84FA275.md): Rolladen-Schneider LS3 · Warner Springs, CA · Accident · 1 fatal · Field investigation · Final report · Apr 29, 1984 · N811 · Destroyed > The sailplane was found in a nose down attitude amoung 10 to 15 foot ribbon-wood shrubs approx 250 ft wnw of the departure end of a small airstrip. Both wings were found displaced forward with the rt one forming a straight line extension forward fm the… - [NTSB FTW84FPJ01](https://openairdocs.org/ntsb/FTW84FPJ01.md): Piper PA-22 · Byron, OK · Accident · 2 fatal · Final report · Apr 29, 1984 · N3564A · Destroyed > The acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured. - [NTSB DEN84LA139](https://openairdocs.org/ntsb/DEN84LA139.md): Aerospatiale 316B · Near Dillon, CO · Accident · No injuries · Limited investigation · Final report · Apr 29, 1984 · N608RM · Substantial damage > When the plt took off from a mountainous ski area, light to moderate snow was falling & the winds were coming up the valley at 5 to 10 KTS. During the flt, he encountered an estimated 35 kt upslope wind as he was proceeding on the upwind side of a ridge at an… - [NTSB CHI84FA169](https://openairdocs.org/ntsb/CHI84FA169.md): Cessna 172RG · Woodbury, MN · Accident · 4 fatal · Field investigation · Final report · Apr 29, 1984 · N6446V · Destroyed > The acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near… - [NTSB NYC84MA151](https://openairdocs.org/ntsb/NYC84MA151.md): Piper PA-60-601P · Cockeysville, MD · Accident · 2 fatal · Major investigation · Final report · Apr 28, 1984 · N6079R · Destroyed > On the day of departure the plt had received a 30 min familiarization flt upon completion of the superstar conversion. Emphasis was directed to eng gages, fuel flow & counter, & power settings. The flt was flown at 5,500 ft. the plt then obtained a wx… - [NTSB MIA84LA155](https://openairdocs.org/ntsb/MIA84LA155.md): American AA-1A · Lake Harbor, FL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N9391L · Substantial damage > The plt adjusted the mixture twice during his descent from 2500 ft MSL. The second adjustment killed the engine and a forced landing was made in a sugar cane field. Post accident examination revealed that the engine mixture control cable was broken. A… - [NTSB CHI84LA167](https://openairdocs.org/ntsb/CHI84LA167.md): Cessna 152 · Marine City, MI · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · CGDPP · Substantial damage > The plt departed london, ontario with 14 gal of fuel on board. He became disoriented & flew over sarnia which he mistookfor detroit. He stated that he waited too long before contacting anyone for help. When he finally called selfridge approach & was being… - [NTSB CHI84LA166](https://openairdocs.org/ntsb/CHI84LA166.md): Grumman AA5A · Cudahy, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1984 · N26404 · Substantial damage > The acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were… - [NTSB ATL84LA149](https://openairdocs.org/ntsb/ATL84LA149.md): Mooney 21 · Centre, AL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N141RG · Substantial damage > While in cruise flt the engine failed. The pilot executed a forced landing, and the acft sustained substantial damage during the landing sequence. Examination of the acft revealed no fuel in the tanks, lines, or pump. The acft had flown about 5 hours since… - [NTSB MIA84LA154](https://openairdocs.org/ntsb/MIA84LA154.md): Piper PA-32-301 · Marco, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1984 · N81701 · Destroyed > The flt departed fort myers, FL at 0550 & arrived at key west, FL at 0655. The flt then departed key west at 0710 for the return flt. At 0722, the plt reported to ARTCC that he was experiencing eng failure & could get no fuel pressure. The acft was ditched 29… - [NTSB LAX84FA374](https://openairdocs.org/ntsb/LAX84FA374.md): Piper PA-28R-200 · Lone Pine, CA · Accident · 2 fatal · Field investigation · Final report · Apr 27, 1984 · N56981 · Destroyed > When the acft did not return from a x-country flt, a search was initiated. However, the acft was not found until hikers discovered the wreckage on 6/29/84. Impact occurred at about the 9000 ft level in mountainous terrain. The outer wing panels & horizontal… - [NTSB FTW84LA213](https://openairdocs.org/ntsb/FTW84LA213.md): Aerospatiale AS 315B · Hartshorn, OK · Accident · No injuries · Limited investigation · Final report · Apr 27, 1984 · N3835W · Substantial damage > The helicopter sustained substantial damage during an autorotative landing following an explosion in the engine compartment. While in level flight at 1000 ft AGL, the plt heard a loud screech from the engine area followed by a loud bang. A wingman observed 10… - [NTSB CHI84LA164](https://openairdocs.org/ntsb/CHI84LA164.md): Cessna 177A · Bloomer, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1984 · N30609 · Substantial damage > Plt failed to visually check fuel tanks after they were refueled. On the second leg of a x-country fuel exhaustion occurred. The acft nosed over during the forced landing on soft terrain. - [NTSB ATL84FA151](https://openairdocs.org/ntsb/ATL84FA151.md): Piper PA-32-260 · Maynardville, TN · Accident · 5 fatal · Field investigation · Final report · Apr 27, 1984 · N5502J · Destroyed > The acft crashed in an uncontrolled state after the airframe failed in flt. Witnesses observed the acft spinning out of the clouds with parts of the airframe separating as it descended. The weather had been described to the plt in 2 wx briefings. At the time… - [NTSB MKC84LA129](https://openairdocs.org/ntsb/MKC84LA129.md): Cessna 172M · 5n 0lin, IA · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1984 · N5010R · Substantial damage > While cruising at 3,000 ft MSL the eng ran rough. The flt noticed zero oil pressure. As he turned toward a bean field the eng failed. The acft collided with a ditch & nosed over. The eng was disassembled & an estimated 3-4 qts of oil were in the eng case. The… - [NTSB FTW84LA212](https://openairdocs.org/ntsb/FTW84LA212.md): Cessna 150M · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N45387 · Substantial damage > While returning to arpt the pilot experienced a rough running eng with a drop in RPM. There was insufficient power to maintain flt and an emergency landing was made on a highway. The acft was damaged during the hard landing. An exam of the eng revealed that… - [NTSB DEN84LA138](https://openairdocs.org/ntsb/DEN84LA138.md): Piper PA-36-375 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N2371Y · Substantial damage > The acft had recently been sold & was being ferried to the buyer in Oklahoma. After a refueling stop at the coronado arpt, the plt took off & proceeded northeast to avoid rotor clouds associated with the sandia mountains about 8 mi east of Albuquerque, NM.… - [NTSB MIA84LA150](https://openairdocs.org/ntsb/MIA84LA150.md): Grumman AA-1B · Panama City, FL · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N1496R · Substantial damage > The plt stated he encountered head winds stronger than forecast & the acft ran out of fuel. He made a forced landing in what appeared to be a cleared field. During the landing roll, the acft hit a ditch & nosed over. The plt indicated that the surface of the… - [NTSB LAX84LA269](https://openairdocs.org/ntsb/LAX84LA269.md): Cessna U206F · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N9591G · Substantial damage > Acft departed at 0950 hrs with 55 to 60 gals of fuel on board. At 1219 hrs the acft was cruising at 6500 ft when total power loss occurred. The pilot attempted a forced landing on rwy 28 at modesta city arpt. Pilot was unable to fly the acft to the arpt and… - [NTSB MIA84FA146](https://openairdocs.org/ntsb/MIA84FA146.md): Douglas DC-8-63 · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Apr 23, 1984 · N940JW · Minor damage > The acft encountered inflight turbulence while descending into Miami. Four people were taken to local hospitals. A flt attendant & two pax were treated & release. One pax remained in the hospital for 12 days due to back injuries. The flt attendants indicated… - [NTSB DEN84LA134](https://openairdocs.org/ntsb/DEN84LA134.md): Helio H-295 · Dulce, NM · Accident · No injuries · Limited investigation · Final report · Apr 23, 1984 · N269L · Substantial damage > The plt was crossing a mountain ridge at 250 feet when a downdraft was encountered on the downwind side of the ridge. The plt then banked and returned to the upwind slope but still was unable to maintain altitude. The acft collided with trees and stabilizer… - [NTSB MIA84LA145](https://openairdocs.org/ntsb/MIA84LA145.md): Piper J3C-65 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N37967 · Substantial damage > The acft was cruising at 1000 ft MSL when the eng lost power. Subsequently, the acft was ditched in lake okeechobee. Theplt stated that after the acft was recovered from the lake, fuel was found in the fuel tank. Also, he stated 'appears vent on fuel tank cap… - [NTSB LAX84LA265](https://openairdocs.org/ntsb/LAX84LA265.md): Piper PA-24-260 · Quincy, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N9218P · Substantial damage > The plt was unable to start the eng & obtained the service of a mechanic. The mechanic decided that the problem was in the ignition switch & disconnected the p-leads with the belief that this would make the mags continually 'hot.' However, with the p-leads… - [NTSB MIA84LA148](https://openairdocs.org/ntsb/MIA84LA148.md): Cessna 172 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N51184 · Destroyed > The plt reported that shortly after leveling at 5,500 ft MSL, he leaned the mixture, & a few minutes later, the eng lostpartial power. All attempts to restore power were to no avail; the eng developed only about 1600 RPM. The flt entered a 300 fpm rate of… - [NTSB DCA84AA022](https://openairdocs.org/ntsb/DCA84AA022.md): Mitsubishi MU-2B-60 · Burlington, CT · Accident · 1 fatal · Final report · Apr 20, 1984 · N466MA · Destroyed > The acft was flown earlier in the day for a sales demonstration. On the return flt, when the landing gear were lowered, the plt thought he heard a noise emitting from the gear, although cockpit indications were normal. The acft landed at johnnycake arpt & was… - [NTSB SEA84FA090](https://openairdocs.org/ntsb/SEA84FA090.md): Bowen-Powell BP-1 · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1984 · N123BP · Destroyed > Witnesses observed the acft enter a right turn at about 1000 to 1500 ft AGL. The turn steepened into a tight spiral, & subsequently, the acft crashed in a steep nose down attitude. The plt was wearing a parachute & bailed out; however, the parachute became… - [NTSB LAX84FA460](https://openairdocs.org/ntsb/LAX84FA460.md): Piper PA-28-161 · Bakersfield, CA · Accident · 1 fatal · Field investigation · Final report · Apr 18, 1984 · N38916 · Destroyed > The non-instrument rated plt departed imperial, CA on 4/18/84 at about 1845 PST. Two people reported that at 2100 to 2200 PST, they saw an acft circling in the area of cummings mountain, about 10 mi south of the accident site, but because the mountain tops… - [NTSB FTW84LA204](https://openairdocs.org/ntsb/FTW84LA204.md): Beasley, Gerald L. Varieze · Purcell, OK · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1984 · N26VE · Destroyed > The plt reported that he started the eng by using fuel from the 2.5 gal aux tank, then he moved the fuel selector to the 'both' position. He took off at about 0600 CST & climbed to cruise at 5500 ft MSL. While en route, a short time later, the eng 'sputtered… - [NTSB NYC84FA142](https://openairdocs.org/ntsb/NYC84FA142.md): Beech 58 · Bentley Creek, PA · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1984 · N806Q · Destroyed > The last radio call made by the plt was at 0658 EST when he reported level at 8000 ft. radar data at 0708 EST, showed the acft changing heading from 327 to 335 degrees, alt decreased from 8000 to 5000 ft and ground speed increased from 179 to 188 KTS.… - [NTSB LAX84FA259](https://openairdocs.org/ntsb/LAX84FA259.md): Beech A23-24 · Bowman, CA · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1984 · N5676S · Destroyed > On a flt from fair oaks, CA, to reno, NV, a flt of about 1 hr 15 mins, the acft experienced a total power loss. The plt asked the pax to select the other fuel tank. The selctor handle was not attached to the valve. But the pax located the handle and turned… - [NTSB SEA84FA088](https://openairdocs.org/ntsb/SEA84FA088.md): Cessna 150L · Diamond Lake, OR · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1984 · CGHLW · Destroyed > The acft was on a flt from sacramento, CA to vancouver, british columbia, via red bluff, klammath falls, eugene, portland & seattle. During a wx briefing at 0545 PST, the non-instrument rated plt was advised that VFR flt was not recommended. However, he filed… - [NTSB CHI84IA155](https://openairdocs.org/ntsb/CHI84IA155.md): Swearingen SA226TC · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Apr 16, 1984 · N163MA · Minor damage > A gear up landing was performed after the crew was unable to extend the rgt main gear thru normal & emerg procedures. An exam of the acft disclosed the rgt main gear door aft hinge bolt was slightly bent & difficult to rotate in its bushing. The bushing &… - [NTSB CHI84FA153](https://openairdocs.org/ntsb/CHI84FA153.md): Mooney M20C · Gary, IN · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1984 · N7899V · Destroyed > VFR plt received 2 wx briefings, filed an IFR flt plan and departed in night IFR conditions. Aprx 1 min after contacting chicago ARTCC plt reported he was having 'problems.' Aprx 1 min later plt reported, 'nine nine victor, I'm breaking up.' Acft wreckage was… - [NTSB ANC84LA057](https://openairdocs.org/ntsb/ANC84LA057.md): Cessna 180 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1984 · N4747U · Destroyed > The plt encountered IMC wx conditions & elected to make a water landing. Also, he stated that he encountered a white-out condition just prior to landing. Shortly after touching down, the acft struck a sand bar & nosed over. - [NTSB MIA84IA140](https://openairdocs.org/ntsb/MIA84IA140.md): Boeing 747-121 · Martinique · Incident · No injuries · Incident investigation · Final report · Apr 14, 1984 · N751PA · Minor damage > While climbing through FL200 crew experienced a loss of #4 hydraulic system pressure, illumination of the red 'gear door' and 'left wing door open' lights, a medium freq vibration and heard a loud rushing sound. Flt diverted to miami, FL, where landing was… - [NTSB LAX84FA253](https://openairdocs.org/ntsb/LAX84FA253.md): Sturges BD-5B · Mckinleyville, CA · Accident · 1 fatal · Field investigation · Final report · Apr 13, 1984 · N42273 · Destroyed > After the acft took off, witnesses observed it enter a left turn, pitch nose up, then enter a rolling/vertical descent & impact at the edge of a surf. An exam of the wreckage & eng revealed no evidence of a preimpact/part failure or malfunction. A test plt… - [NTSB MKC84LA122](https://openairdocs.org/ntsb/MKC84LA122.md): Beech BE23 · Little Rock, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1984 · N67134 · Substantial damage > The acft crashed into trees during a forced landing. Examination of the acft fuel system after the accident showed less than 1 gallon of fuel in the right tank and about 15 gallons in the left tank. The acft was operated the entire flton the right tank and… - [NTSB LAX84LA249](https://openairdocs.org/ntsb/LAX84LA249.md): Champion 7GCAA · Fort Bidwell, CA · Accident · No injuries · Limited investigation · Final report · Apr 9, 1984 · N6726N · Substantial damage > According to the plt the wx blocked several of the mountain passes along the route of flight. When the wx continued to deteriorate the plt landed in a field. The main gear 'dug-in and the acft flipped on it's back.' - [NTSB LAX84FA251](https://openairdocs.org/ntsb/LAX84FA251.md): Grumman AA-5A · Kamuela, HI · Accident · 4 fatal · Field investigation · Final report · Apr 9, 1984 · N26413 · Destroyed > The acft with 4 occupants on board was being used on a sight-seeing flt to mauna loa volcano. The plt was in radio contact with hilo tower from 1503 to 1506 HST. He indicated concern about the clouds & decided not to proceed to the volcano. When the acft… - [NTSB SEA84LA080](https://openairdocs.org/ntsb/SEA84LA080.md): Schweizer SGS1-26C · Mount Vernon, WA · Accident · No injuries · Limited investigation · Final report · Apr 8, 1984 · N4450N · Destroyed > The sailplane encountered deteridrating thermals & elected to make an off airport landing as he did not think he could reach the airport. He overshot the selected field in his attempt to miss some wires at the apch end of the field despitethe use of spoilers… - [NTSB NYC84LA134](https://openairdocs.org/ntsb/NYC84LA134.md): Hughes 269A · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N8817F · Substantial damage > While in flt, the helicopter yawed & the eng RPM increased. The plt retarded the throttle to idle, lowered the collective & initiate an autorotation. While attempting to reach a suitable landing area, the plt kept his speed up to avoid buildings. However,… - [NTSB LAX84LA245](https://openairdocs.org/ntsb/LAX84LA245.md): Beech E18S · Buellton, CA · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N8711 · 2 aircraft · Substantial damage > These acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the… - [NTSB ANC84LA053](https://openairdocs.org/ntsb/ANC84LA053.md): Beech BE-18D · Egegik, AK · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N719MS · Destroyed > The plt stated the engines loss power as a result of snow ingestion and carburetor icing upon entering clouds. According to the plt, he entered the clouds at 9000 ft MSL and encountered heavy snow. He remained IMC until approximately 100-300 ft AGL when he… - [NTSB SEA84FA078](https://openairdocs.org/ntsb/SEA84FA078.md): Beech N35 · Baker, OR · Accident · 2 fatal · Field investigation · Final report · Apr 6, 1984 · N1270Z · Destroyed > The plt encountered airframe icing while en route during a x-country flt. He had filed an instrument flt plan to boise, ID, but en route, he changed destinations twice, 1st to ontario, OR, then later to Baker, ID. At 1820 PDT, he reported icing & turbulence… - [NTSB LAX84LA243](https://openairdocs.org/ntsb/LAX84LA243.md): Cessna A150K · Chico, CA · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N8334M · Substantial damage > When the acft was about 7 mi from its destination, the eng lost power & the plt elected to land on an access road. During the landing roll, the left wing hit the top of a fence & the acft veered left. The nosewheel then struck a curb & the acft nosed over.… - [NTSB DEN84LA124](https://openairdocs.org/ntsb/DEN84LA124.md): Bell 206B · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N5743H · Substantial damage > While climbing, there was a heavy smell of fuel. At aprx 150 ft AGL on a precautionary landing, the eng quit. The helicopter impacted hard, collapsing the skids, & the main rotor blades sheared of the tail boom. During an investigation, the fuel hose b-nut… - [NTSB ATL84FA141](https://openairdocs.org/ntsb/ATL84FA141.md): Cessna 182Q · Nw.Of Abingdon, VA · Accident · 2 fatal · Field investigation · Final report · Apr 6, 1984 · N96578 · Destroyed > The acft crashed into a mountain at the 4000 ft level about 100 ft below the crest en route to chattanooga, TN. The plt had received a pre-flt telephonic briefing that was considered current and appropriate for the flt without any special remarks. At… - [NTSB ANC84FA051](https://openairdocs.org/ntsb/ANC84FA051.md): Beech F33A · Houston, AK · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1984 · N2036B · Destroyed > The acft collided with the ground in a near vertical dive. Prior to the accident, witnesses heard the eng at hi power until moments before impact. They reported the wx was cloudy & cool with light rain beginning to fall, mixed with snow. They reported the… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=356 ## 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=355 --- 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.