# 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 327 of 718 · 35,889 cases ## Cases, newest first - [NTSB LAX86LA180](https://openairdocs.org/ntsb/LAX86LA180.md): Cessna 150K · Joshua Tree, CA · Accident · No injuries · Limited investigation · Final report · Apr 16, 1986 · N6398G · Substantial damage > The plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency… - [NTSB LAX86FA178](https://openairdocs.org/ntsb/LAX86FA178.md): Piper PA-28-181 · Beaumont, CA · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1986 · N28891 · Destroyed > When the non-instrument rated plt departed for the flt at about 2110 hrs, the wx conditions were marginal and deteriorating in the area. No record of a wx briefing was found. For unkn reasons, the plt was returning to the arpt after about 1 hr and 20 mns,… - [NTSB LAX86DVA06](https://openairdocs.org/ntsb/LAX86DVA06.md): Bell UH-1B · Chowchilla, CA · Accident · Minor injuries · Final report · Apr 16, 1986 · N910PD · Destroyed > While returning from a spraying operation the plt observed that the main transmission oil pressure gage indicated zero. The plt reported that the engine master caution did not illuminate and that the oil temperature gage was normal. The plt stated that he… - [NTSB SEA86LA105](https://openairdocs.org/ntsb/SEA86LA105.md): Bell 47G3B1 · Albany, OR · Accident · No injuries · Limited investigation · Final report · Apr 15, 1986 · N9417A · Substantial damage > The plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the… - [NTSB NYC86LA103](https://openairdocs.org/ntsb/NYC86LA103.md): Piper PA-28-140 · Hampden, ME · Accident · No injuries · Limited investigation · Final report · Apr 15, 1986 · N6264W · Substantial damage > After taking off, the plt initiated a climb & leveled off at 2500'. As he reduced power to cruise, the eng stopped running. All attempts to restart the eng were unsuccessful. Subsequently, the acft was damaged when the plt landed on rocky pasture land. Fuel… - [NTSB CHI86FER04](https://openairdocs.org/ntsb/CHI86FER04.md): Piper PA-28-181 · Brooklyn Center, MN · Accident · Serious injuries · Final report · Apr 14, 1986 · N84277 · Substantial damage > When the aircraft experienced a total power failure due to fuel exhaustion and the pilot determined that it was not possible to make a forced landing on an airport, the pilot elected to land on a highway. The pilot stated that when he was not able to land in… - [NTSB ATL86MA114](https://openairdocs.org/ntsb/ATL86MA114.md): Bell 206L-3 · Holliston, MA · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1986 · N302MC · 2 aircraft · Destroyed > The Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a… - [NTSB DEN86FA115](https://openairdocs.org/ntsb/DEN86FA115.md): Cessna 207A · Ogden, UT · Accident · Minor injuries · Field investigation · Final report · Apr 12, 1986 · N1721Q · Substantial damage > Acft was en route to slc where it was to be put on static display with other acft equipped with soloy-conversions (allison 250-C20S turboshaft engine installation). During descent through 12,000 ft into slc area eng flamed out and the prop auto-feathered. Plt… - [NTSB SEA86FA100](https://openairdocs.org/ntsb/SEA86FA100.md): Piper PA-28R-180 · Lone Pine, ID · Accident · 3 fatal · Field investigation · Final report · Apr 11, 1986 · N3714T · Destroyed > After an initial weather briefing the plt departed coeur dalene, Idaho, for his destination of Idaho falls, Idaho, with a planned passenger pickup at missoula, Montana. During the second leg of the flt he misnavigated while avoiding weather which resulted in… - [NTSB MKC86LA085](https://openairdocs.org/ntsb/MKC86LA085.md): Aero Commander S2R · Jackson, MO · Accident · No injuries · Limited investigation · Final report · Apr 11, 1986 · N5564X · Substantial damage > In cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after… - [NTSB SEA86FA098](https://openairdocs.org/ntsb/SEA86FA098.md): Piper PA-32-301T · Fort Hall, ID · Accident · 2 fatal · Field investigation · Final report · Apr 10, 1986 · N82238 · Destroyed > Radar track showed acft made normal climb on course from airport (elev 4488 ft MSL) to 9400 ft. MSL, then executed a left turn of about 90 degrees, climbing to 9700 ft MSL as shown by next-to-last radar tgt. 29 secs later, final radar tgt showed 6900 ft MSL.… - [NTSB DEN86LA113](https://openairdocs.org/ntsb/DEN86LA113.md): de Havilland DHC · Pembina, ND · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N713W · Substantial damage > The plt stated the eng quit because the fuel cap had not been properly secured and the fuel had siphoned out in flt. - [NTSB SEA86LA097](https://openairdocs.org/ntsb/SEA86LA097.md): Cessna 180K · Emigrant Pass, NV · Accident · No injuries · Limited investigation · Final report · Apr 9, 1986 · N644FM · Substantial damage > The plt was informed during a wx briefing that VFR flt was not recommended. The plt elected to takeoff regardless and encountered low ceilings and visibilities. While looking for an area of a highway to land the acft, pwr lines were contacted with the top of… - [NTSB SEA86FA096](https://openairdocs.org/ntsb/SEA86FA096.md): Piper PA-28-180 · East Wenatchee, WA · Accident · 1 fatal · Field investigation · Final report · Apr 9, 1986 · N42496 · Destroyed > The plt departed arpt in bottom of columbia river gorge on night VFR flt to spokane, WA. Five to six min after departure acft impacted terrain on lip of canyon wall. Plts reported moderate to severe turbulence near the bluff line before and after crash. The… - [NTSB DEN86FA112](https://openairdocs.org/ntsb/DEN86FA112.md): Cessna T-210N · Jay Em, WY · Accident · 3 fatal · Field investigation · Final report · Apr 9, 1986 · N6535N · Destroyed > The non-instrument rated plt took off on a VFR flt into an area of forecast adverse wx. Radar track of the acft at 9,700 feet MSL was lost in the vicinity of the accident site at 0930 MST, 4/9/86. The acft wreckage was located at 1155 MST, 4/10/86 and was… - [NTSB NYC86LA101](https://openairdocs.org/ntsb/NYC86LA101.md): Douglas DC-10-30 · Jamestown, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1986 · 00SLB · Minor damage > A sabena world airlines DC-10-30 descending from FL 410, enroute from detroit, mi to boston ma, encountered high altitude windshear as it was descending through FL 404. The pilot, passengers and flight attendents state that they felt vibrations prior to an… - [NTSB LAX86FA167](https://openairdocs.org/ntsb/LAX86FA167.md): Piper PA-23-250 · Mesa, AZ · Accident · Serious injuries · Field investigation · Final report · Apr 7, 1986 · N555KS · Substantial damage > While on the fourth leg of an IFR business flight from stow, Ohio to santa paula, California, the airplane experienced fuel exhaustion and crashed about 1 1/2 miles northeast of falcon field (ffz), Mesa, Arizona. The flight was being conducted under the… - [NTSB CHI86LA117](https://openairdocs.org/ntsb/CHI86LA117.md): Cessna 172-RG II · St Paul, MN · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 1986 · N9538B · Substantial damage > During climbout after t.o. and passing thru 4000 ft smoke began to enter the cabin. Plt declared an emergency and turned toward arpt. Eng then began to shake violently. Acft was cleared to ld but plt continued to a point four mi past base leg, attempted to… - [NTSB ATL86LA107](https://openairdocs.org/ntsb/ATL86LA107.md): Piper PA-32R-300T · Fort Deposit, AL · Accident · No injuries · Limited investigation · Final report · Apr 7, 1986 · N22370 · Substantial damage > Shortly after takeoff smoke and flames entered the cockpit. The pilot returned to the airport and landed hard damaging the firewall. Examination of the aircraft revealed that the turbo charger exhaust clamp broke and allowed hot exhaust gases to ignite a fire… - [NTSB MIA86FA113](https://openairdocs.org/ntsb/MIA86FA113.md): Beech 65-90 · Fort Pierce, FL · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1986 · N58KA · Substantial damage > Flt experienced loss of power in both engines due to fuel starvation. The pilots failed to operate fuel transfer switches to transfer fuel from the wing tanks into the nacelle tanks which feed the engines. The pilot in command had 16 total hours in the king… - [NTSB FTW86FA060](https://openairdocs.org/ntsb/FTW86FA060.md): Douglas DC-3C · El Paso, TX · Accident · No injuries · Field investigation · Final report · Apr 6, 1986 · N25CE · Substantial damage > The pilot reported that he was leveling off from climb when he experienced a prop runaway. He observed oil streaming from the left engine, but could not feather. Unable to maintain altitude with a windmilling prop, he performed a gear up emergency landing in… - [NTSB FTW86MA058](https://openairdocs.org/ntsb/FTW86MA058.md): Israel Aircraft Industries 1124A · Redwater, TX · Accident · 7 fatal · Major investigation · Final report · Apr 5, 1986 · N50SK · Destroyed > Airplane crashed during a uncontrolled descent, following a turbulence upset at FL370. The upset occurred as a result of clr air turb associated with a vip lvl 6 thunderstorm located within 7 miles of the last pos of the airplane. After the upset, the… - [NTSB MIA86LA111](https://openairdocs.org/ntsb/MIA86LA111.md): Cessna 150J · Boca Raton, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 1986 · N50845 · Substantial damage > The flt experienced a failure of the acft's eng while flying parallel to the beach and the acft was ditched in the atlantic ocean. Inspection of the acft after recovery revealed the foam air cleaner had been drawn into the carburetor air box and was blocking… - [NTSB MIA86FA112](https://openairdocs.org/ntsb/MIA86FA112.md): Piper PA-31-350 · Homestead, FL · Accident · No injuries · Field investigation · Final report · Apr 4, 1986 · N55WE · Substantial damage > The flt was nearing completion of a 4.2 hr x-country flt & was aprx 7 miles from the dest when both engs quit due to fuel exhaustion. A forced ldg was performed. The plt stated the acft had departed with a full fuel load of 182 gals. The acft owner stated… - [NTSB NYC86FNC02](https://openairdocs.org/ntsb/NYC86FNC02.md): Piper PA-11 · Brewer, ME · Accident · Serious injuries · Final report · Apr 2, 1986 · N5082H · Substantial damage > The plt had been using auto gas in this acft, however, he experienced water contamination problems and discontinued its use. He then found himself at an arpt needing fuel. The arpt only had auto gas available so the plt refueled the acft with auto gas. While… - [NTSB MKC86LA078](https://openairdocs.org/ntsb/MKC86LA078.md): Cessna 172 · Ava, MO · Accident · No injuries · Limited investigation · Final report · Apr 2, 1986 · N80751 · Substantial damage > The plt reports that the eng began to run rough and lose RPM while the acft was cruising at 2500 ft. he said he attempted emerg proc but the loss of RPM continued and he decided on an off-arpt landing. During the apch to the landing area the eng RPM dropped… - [NTSB CHI86FEC02](https://openairdocs.org/ntsb/CHI86FEC02.md): Cessna T210M · Highland, MI · Accident · Minor injuries · Final report · Apr 2, 1986 · N732KR · Substantial damage > The aircraft was in cruise when the engine started sputtering. According to the pilot, he switched tanks and the engine would start to run then miss, start to run then-miss, over and over again. The pilot stated that while this was happening he was losing… - [NTSB FTW86LA056](https://openairdocs.org/ntsb/FTW86LA056.md): Maule M-5-235C · West, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 1986 · N56366 · Substantial damage > The pilot reported having an engine failure at 2,500 feet while enroute to dallas, TX from mcallen, TX. He was unable to restart the engine and had to make an emergency landing in a field three miles West of West, TX. The aircraft received substantial damage… - [NTSB SEA86LA088](https://openairdocs.org/ntsb/SEA86LA088.md): Beech E-35 · Couger, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1986 · N2998B · Substantial damage > While at cruise, the pilot intentionally ran one fuel tank dry. When the pilot attempted a restart by use of the wobble pump, the aircraft's engine would not start. The pilot made a forced landing into trees for lack of a more suitable landing site. The… - [NTSB LAX86MA161](https://openairdocs.org/ntsb/LAX86MA161.md): Boeing 767-222 · San Fransisco, CA · Incident · No injuries · Major investigation · Final report · Mar 31, 1986 · N609UA · No damage > While climbing through 3000 feet AGL, during the initial climb phase of the flight, both engines flamed out. The crew was able to restart both engines and return to the airport of departure for an uneventful landing. - [NTSB LAX86LA159](https://openairdocs.org/ntsb/LAX86LA159.md): Balloon Works Firefly 8-24 · Pheonix, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1986 · N3694C · No damage > The Balloon collided with the terrain during a sight seeing tour. The plt noticed the dust signature of ground turbulent wx phenomena known as rotors or dust devils arpx 3 miles ahead. He elected to make an immediate precautionary landing and descended to an… - [NTSB SEA86LA089](https://openairdocs.org/ntsb/SEA86LA089.md): Hiller 12E · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N87595 · Destroyed > A catastrophic failure of the planetary gear of the transmission occurred about 51 flight hours after overhaul. During forced landing a hard landing occurred severing the tail boom. A fire then erupted. - [NTSB SEA86LA087](https://openairdocs.org/ntsb/SEA86LA087.md): Piper PA-22-150 · Warm Springs, OR · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N6958B · Substantial damage > A precautionary landing was made due to the pilot becoming lost, the aircraft's navigation radio not working, and low fuel. A gusting crosswind was present during landing. On rollout the aircraft's wing tip caught a fence and the aircraft nosed over. - [NTSB SEA86LA085](https://openairdocs.org/ntsb/SEA86LA085.md): Cessna 188-A · Warden, WA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N4736Q · Substantial damage > While at cruise, the pilot was distracted and had his head turned when he inadvertently flew into the ground. - [NTSB MIA86LA108](https://openairdocs.org/ntsb/MIA86LA108.md): Easley Pitts S2-E · Homestead, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1986 · N777GH · Substantial damage > While climbing through 600 feet after departure, the flight experienced loss of engine power. While returning to the airport altitude could not be maintained and the aircraft crashed short of the runway. Post crash inspection revealed the number 4 cylinder… - [NTSB LAX86FA160](https://openairdocs.org/ntsb/LAX86FA160.md): Beech C35 · Etiwanda, CA · Accident · 2 fatal · Field investigation · Final report · Mar 29, 1986 · N717D · Destroyed > The flt was receiving radar advisories & was routine until the acft was aprx 15 mi east of the destination arpt. After radar svc was terminated, the acft subsequently turned toward the northwest & flew into rising terrain at an elevation of about 3000 feet.… - [NTSB DEN86LA105](https://openairdocs.org/ntsb/DEN86LA105.md): Cessna 177B · Aztec, NM · Accident · Minor injuries · Limited investigation · Final report · Mar 29, 1986 · CGIJZ · Substantial damage > Plt and one pax departed eston, saskatchewan at 0600, en route to guaymas, Mexico for a vacation. Acft was refueled in billings, mt at 0900 and at grand junction, CO. Plt checked wx, filed VFR flight plan and departed grand junction at 1430, en route to… - [NTSB CHI86LA114](https://openairdocs.org/ntsb/CHI86LA114.md): Piper PA-22-150 · Plymouth, MI · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N3900P · Substantial damage > The eng quit during climb out shortly after takeoff. The plt switched tanks and tried a restart with no success. The acft then experienced a nose gear collapse and nosed over during a landing roll in a field. Investigation revealed the fuel line to the… - [NTSB CHI86FER02](https://openairdocs.org/ntsb/CHI86FER02.md): Monnett Moni · Winona, MN · Accident · Minor injuries · Final report · Mar 29, 1986 · N295MM · Substantial damage > The acft crash landed off the arpt due to a reported loss of power. The plt landed in a small field surrounded by hills. The acft sink rate during the landing was high and the acft was damaged. Inspection of the eng after the acc was not accomplished due to… - [NTSB FTW86FA054](https://openairdocs.org/ntsb/FTW86FA054.md): Cessna 150G · Salina, OK · Accident · 1 fatal · Field investigation · Final report · Mar 28, 1986 · N6306S · Destroyed > A night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that… - [NTSB CHI86FEX06](https://openairdocs.org/ntsb/CHI86FEX06.md): Piper PA-32-260 · Henryville, IN · Accident · Serious injuries · Final report · Mar 28, 1986 · N4804S · Destroyed > Shortly after leveling the acft off at 9000 ft MSL, the plt experienced an engine failure. During the subsequent forced landing the acft struck a tree and was further damaged during the forced landing roll. Metallurgical exam revealed the crankshaft failed… - [NTSB SEA86LA084](https://openairdocs.org/ntsb/SEA86LA084.md): Bob White AJ1 · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1986 · N363JW · Substantial damage > A loss of power occurred due to a failure of the fuel pump while at cruise. A forced landing was made onto a soft, farmers field where the aircraft nosed over during the landing roll. - [NTSB SEA86LA083](https://openairdocs.org/ntsb/SEA86LA083.md): Cessna 150K · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Mar 27, 1986 · N6355G · Substantial damage > While on final VFR approach to landing, total loss of power occurred. Acft landed short on rough terrain, collapsing the nose landing gear, and acft nosed over. Investigation found a quart of water in the fuel system. Acft had been parked outside three days… - [NTSB FTW86LA047](https://openairdocs.org/ntsb/FTW86LA047.md): Bell 206BIII · Gulf Of Mexico · Accident · No injuries · Limited investigation · Final report · Mar 26, 1986 · N3181Y · Substantial damage > The pilot failed to assure the cabin door was properly closed before flight, or the cabin door just popped open during flight, allowing an unsecured life vest to blow out the door and into the tail rotor blades. This resulted in the entire tail rotor assembly… - [NTSB FTW86FPJ07](https://openairdocs.org/ntsb/FTW86FPJ07.md): Schweizer G-164A · Red Rock, OK · Accident · No injuries · Final report · Mar 26, 1986 · N991X · Substantial damage > The acft nosed over during a forced lndg after a power loss. The plt was enroute to a spraying operation and attempted a landing in a pasture after the power loss. An on scene investigation revealed no discrepancies in the engine or fuel system. A successful… - [NTSB MIA86LA104](https://openairdocs.org/ntsb/MIA86LA104.md): Cessna 210E · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N4916U · Substantial damage > After departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct… - [NTSB MIA86FA103](https://openairdocs.org/ntsb/MIA86FA103.md): Piper PA-23-250 · Osteen, FL · Accident · Serious injuries · Field investigation · Final report · Mar 24, 1986 · N77TS · Substantial damage > Before the flt, the plt & pax were observed drinking alcoholic beverages on the way to the arpt. After much difficulty taxiing to the rwy, the flt was cleared for takeoff after entering the active rwy without clearance. After taking off, the acft was seen… - [NTSB NYC86FA092](https://openairdocs.org/ntsb/NYC86FA092.md): Aerospatiale AS350D · Philadelphia, PA · Accident · Minor injuries · Field investigation · Final report · Mar 23, 1986 · N512WW · Destroyed > A Aerospatiale helicopter an a-star under FAR 135 with pilot and 4 passengers onclimb out reaching an altitude of approx 100 to 150' AGL when pilot and passengers heard a loud bang acft lost power. Pilot attempted an auto rotation, due to low airspeed and… - [NTSB DEN86LA102](https://openairdocs.org/ntsb/DEN86LA102.md): Douglas C-47 · Steins, NM · Accident · No injuries · Limited investigation · Final report · Mar 23, 1986 · N37AP · Substantial damage > While en route, the left eng of the C-47 lost partial pwr as a result of a cracked cylinder. The crew stated the left eng was shut down and additional pwr was applied to the right eng to compensate for the increasing rate of descent. The crew stated a short… - [NTSB NYC86LA090](https://openairdocs.org/ntsb/NYC86LA090.md): Beech S35 · Laconia, NH · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1986 · N5629K · Substantial damage > During cruise flt, the acft eng failed & oil covered the windshield & side windows. Subsequently, the acft crash landed into wooded terrain while in a wings level attitude at low speed. Tests showed the eng crankshaft had failed from fatigue. The fatigue… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=328 ## 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=327 --- 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.