# 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 330 of 718 · 35,889 cases ## Cases, newest first - [NTSB FTW86LA040](https://openairdocs.org/ntsb/FTW86LA040.md): Cessna 152 · Flynn, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 1986 · N714UU · Substantial damage > The engine lost power while in cruise flight about 9 miles short of the pilot's planned destination. He made a forced landing in an open field. After rolling about 75 feet the airplane wheels bogged in and it flipped inverted. The owner of the aircraft, Mr.… - [NTSB FTW86LA038](https://openairdocs.org/ntsb/FTW86LA038.md): Cessna 172G · Spring, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 1986 · N3373B · Substantial damage > The pilot continued VFR flight into IFR weather conditions which he had encountered near his destination during the last few moments of his approximate four hour, night, cross-country flight. He then turned back to houston intercontinental airport to land. He… - [NTSB CHI86MA071](https://openairdocs.org/ntsb/CHI86MA071.md): Bell 206B · Ellendale, MN · Accident · 3 fatal · Major investigation · Final report · Jan 21, 1986 · N1498W · Destroyed > The purpose of the flt was to take a news crew to a location to cover a story. The news crew had attempted to hire another helicopter, but that operator refused due to forcast low visibility. This plt, however, agreed to fly. Altho he was certified for… - [NTSB SEA86LA044](https://openairdocs.org/ntsb/SEA86LA044.md): Boeing 727-214 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1986 · N545PS · No damage > After activation of no 1 engine fire warning signals a second time, flt crew declared emerg and returned for lndg. Fuel dump was seen by some grnd observers as smoke trail and this was reported to flt crew. Acft waiting takeoff report that no smoke or fire… - [NTSB LAX86LA095](https://openairdocs.org/ntsb/LAX86LA095.md): Cessna 172 · Woodland, CA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1986 · N6421E · Substantial damage > The pilot reported that he experienced a loss of power shortly after leveling off at about 1,000 MSL. The power loss was smooth and rapid. During the subsequent forced landing roll-out, the acft nosed over onto its back. Post accident investigation disclosed… - [NTSB DEN86LA067](https://openairdocs.org/ntsb/DEN86LA067.md): Piper PA-22-150 · Cedar City, UT · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1986 · N5950D · Substantial damage > The plt stated that while in cruise flt, a loud noise was heard followed by air entering the cockpit. The plt said he initially reduced pwr, not knowing what the problem was. According to the plt, when no visual problem with the aircraft was found, he added… - [NTSB CHI86LA073](https://openairdocs.org/ntsb/CHI86LA073.md): Piper PA-32-260 · Mechanicsburg, OH · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N3414W · Substantial damage > The plt was on a personal flt when IMC was encountered. The plt elected to climb to a clear area above the IMC when the acft became totally 'socked in.' A 180 deg turn was made, vertigo was experienced and control of the acft was lost. An emergency descent… - [NTSB CHI86LA072](https://openairdocs.org/ntsb/CHI86LA072.md): Beech A23A · Hastings, MI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N6900Q · Substantial damage > The pilot estimated he had 13 gallons of fuel on board for the estimated fifty minute flight. He estimated his fuel burn at nine gallons per hour giving him an hour and twenty five minute fuel endurance. He ran out of fuel an hour and twenty five minutes… - [NTSB ATL86FA058](https://openairdocs.org/ntsb/ATL86FA058.md): Cessna 310G · Ragland, AL · Accident · 4 fatal · Field investigation · Final report · Jan 18, 1986 · N8983Z · Destroyed > The acft with sputtering engs was heard circling overhead in low overcast skies. The horizontal tail surfaces separated in-flt and came to rest aprx 450 ft from the main wreckage in mountainous terrain. The student plt had no instrument experience. The acft… - [NTSB ATL86FA057](https://openairdocs.org/ntsb/ATL86FA057.md): Cessna 210M · Tucker, GA · Accident · Serious injuries · Field investigation · Final report · Jan 18, 1986 · N761AH · Destroyed > During a night VFR flt the acft experienced a total loss of power and made a forced landing in a small parking lot in a business area. When rescue personnel asked the plt what had happened he stated that the acft ran out of fuel. Inspection of the wreckage… - [NTSB LAX86FA092](https://openairdocs.org/ntsb/LAX86FA092.md): Cessna T210N · Indio, CA · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1986 · N222CL · Destroyed > The plt was on a 21 mi flt fm his home arpt to thermal, CA, to practice takeoffs & lndgs. Bfr departing, he successfullyread back a VFR clnc to fly out of the palm springs trsa. Shortly after takeoff, while en route twd the se (twd the sun,which was 22 deg… - [NTSB FTW86FA035](https://openairdocs.org/ntsb/FTW86FA035.md): Beech M-35 · Valley View, TX · Accident · 3 fatal · Field investigation · Final report · Jan 17, 1986 · N7BU · Destroyed > The non-instrument rated pvt plt received a wx briefing that called for marginal VFR to IFR conditions throughout his route of flt. Destination wx was briefed as 700' ovc, vis 2 miles in haze and fog and the en route wx was considerably worse. Several… - [NTSB DEN86FA066](https://openairdocs.org/ntsb/DEN86FA066.md): Beech V35B · Leadville, CO · Accident · 2 fatal · Field investigation · Final report · Jan 17, 1986 · N6735T · Destroyed > The plt departed pueblo, Colorado on a VFR flt toward an approaching frontal wx system. Radar data showed the acft climbed to an altitude of 18,200 ft MSL, with erratic maneuvering in the vicinity of accident site. The wreckage was located at 13,200 ft MSL in… - [NTSB ATL86FA062](https://openairdocs.org/ntsb/ATL86FA062.md): Cessna 337G · Blairsville, GA · Accident · 5 fatal · Field investigation · Final report · Jan 17, 1986 · N53615 · Destroyed > Acft was flown VFR from ravenna, Ohio en route to atlanta, GA. It departed ravenna about 0930 01/17 & failed to arrive at its destination. Family reported acft missing. Air force rescue center notified at 2020 01/19. Cap commenced air search 01/20, hampered… - [NTSB LAX86LA091](https://openairdocs.org/ntsb/LAX86LA091.md): Bell 206B-3 · Waimea, HI · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1986 · N3179X · Substantial damage > While on a local flt, the plt descended to aprx 500 ft AGL and flew the helicopter along a coastal area. He reported the helicopter suddenly lost power and he initiated an autorotative landing to the beach where the helicopter 'had a hard landing.' An exam… - [NTSB CHI86LA066](https://openairdocs.org/ntsb/CHI86LA066.md): Cessna 150G · Pelican Rapids, MN · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1986 · N2495J · Substantial damage > The exhaust valve rocker arm #1 cylinder failed in flight. The student pilot descended and landed in a wooded area. After over flying a frozen lake occupied by fishermen. The rocker arm exhibited evidence of fatigue. - [NTSB MKC86LA049](https://openairdocs.org/ntsb/MKC86LA049.md): Cessna 150B · Gove, KS · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1986 · N7381X · Substantial damage > After takeoff fm the private airstrip near Gove, Kansas, the aircraft was witnessed to descend towards the ground until impact. The witness to the accident, who is a plt and the owner of the airstrip, stated that after the acft clrd the airstrip environment… - [NTSB MKC86FPG01](https://openairdocs.org/ntsb/MKC86FPG01.md): Beech F33A · West Memphis, AR · Accident · Serious injuries · Final report · Jan 11, 1986 · N20537 · Substantial damage > The acft crashed into the ground after striking trees during a forced lndg. The acft had experienced a loss of power during cruise after 4 and 1/2 hrs of flt. Post acc investigation showed that the rt main fuel tank was almost empty of fuel and the left main… - [NTSB CHI86LA062](https://openairdocs.org/ntsb/CHI86LA062.md): Navion A · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Jan 11, 1986 · N4000G · Substantial damage > Ten minutes after takeoff the plt heard a loud bang followed by a loss of eng pwr. The right main gear separated during the forced landing in a rough field. Examination disclosed the piston had separated from the wrist pin causing the #5 cylinder to separate… - [NTSB LAX86LA083](https://openairdocs.org/ntsb/LAX86LA083.md): Cessna 150M · Ukiah, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 1986 · N63660 · Substantial damage > The acft's eng lost pwr during a normal descent during a night x-country flt and the acft crashed during the ensuing forced landing attempt. Fire department personnel reported that the right wing fuel tank was empty and the left wing fuel tank contained one… - [NTSB LAX86FA084](https://openairdocs.org/ntsb/LAX86FA084.md): Piper PA-28-181 · Livermore, CA · Accident · 2 fatal · Field investigation · Final report · Jan 8, 1986 · N8283T · Destroyed > The aircraft crashed shortly after takeoff about a mile from the departure airport. IFR conditions prevailed at the accident site; however, the non-instrument rated pilot had told his wife that the weather was clear when he telephoned her from the airport… - [NTSB SEA86LA036](https://openairdocs.org/ntsb/SEA86LA036.md): Cessna 140 · Ione, OR · Accident · No injuries · Limited investigation · Final report · Jan 5, 1986 · N1920V · Substantial damage > The pilot attempted to fly his newly purchased aircraft a distance of 3 miles from one local airstrip to another for the purpose of hangaring it. A ceiling of 500 feet overcast with 5 miles visibility fog and freezing rain were present. The windscreen iced up… - [NTSB SEA86FA035](https://openairdocs.org/ntsb/SEA86FA035.md): Piper PA28-151 · Kelso, WA · Accident · 2 fatal · Field investigation · Final report · Jan 5, 1986 · N43552 · Destroyed > Enroute to dest. Plt diverted to nearby airfield due deteriorating weather. One hr later, telephone weather brief for continued flt to dest was VFR not recommended. Less than 2 hrs. Later, with no further brief, acft departed. A following acft revsd course… - [NTSB MKC86LA045](https://openairdocs.org/ntsb/MKC86LA045.md): Piper PA-28-140 · Creve Ceour, MO · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1986 · N4349J · Substantial damage > After takeoff fm the arpt the plt stated the acft eng ran rough and he applied carb heat to help the engine run better after application of carb heat the engine quit. The plt made a forced landing back to the airport finally touching down on a taxiway between… - [NTSB FTW86LRA03](https://openairdocs.org/ntsb/FTW86LRA03.md): Cessna 172F · Saratoga, TX · Accident · No injuries · Final report · Jan 5, 1986 · N8267U · Destroyed > Pilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were… - [NTSB MIA86FA055](https://openairdocs.org/ntsb/MIA86FA055.md): Cessna 210L · Lake City, FL · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1986 · N73SN · Destroyed > Prior to departure on a VFR flight from Florida to Michigan the non-instrument rated plt did not obtain a weather briefing. 53 minutes after departure the pilot contacted jacksonville ARTCC and reported he had flown VFR into the clouds and was having trouble… - [NTSB FTW86FRD04](https://openairdocs.org/ntsb/FTW86FRD04.md): Cessna 150J · Belle Chasse, LA · Accident · No injuries · Final report · Jan 4, 1986 · N50560 · Substantial damage > The acft nosed over during a forced landing following a loss of power. The flt was begun an hour before the acc with the intention of staying in local area. The wx was minimal VMC at the time of takeoff and suddenly became IMC when fog rolled in. The plt was… - [NTSB MIA86LA054](https://openairdocs.org/ntsb/MIA86LA054.md): Cessna 150L · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Jan 2, 1986 · N7692G · Substantial damage > The plt stated that while enroute to ft. lauderdale executive arpt his eng began to run rough. He made a forced landing in a field & on landing rollout, the nose gear collapsed. Post crash examination of the eng revealed that the #1 intake valve was stuck in… - [NTSB MIA86FA053](https://openairdocs.org/ntsb/MIA86FA053.md): Cessna 172M · St. Marys, GA · Accident · 1 fatal · Field investigation · Final report · Jan 2, 1986 · N21760 · Destroyed > Drg a ngt x-country flt, the non-instrument rated plt contacted apch control & rprtd he was 'sort of lost in the fog.' He obtained wx info & elected to divert to waycross, GA. Shortly thereafter, the acft collided with trees on uneven terrain & crashed.… - [NTSB FTW86LQG07](https://openairdocs.org/ntsb/FTW86LQG07.md): Raven Rally RX-7 · Lockney, TX · Accident · Serious injuries · Final report · Jan 1, 1986 · N2796C · No damage > The student pilot stated that he did not checked the wind forecast when he called for a weather briefing about four hours before the accident. The surface winds increased to 30 gusting 40 KTS while he was airborne. He reported that when he landed, he was not… - [NTSB DCA86AA012](https://openairdocs.org/ntsb/DCA86AA012.md): Douglas DC-3 · Dekalb, TX · Accident · 7 fatal · Final report · Dec 31, 1985 · N711Y · Destroyed > At 1708:48, while cruising at 6000', a pilot of N711Y advised ATC, 'I think I'd like to turn around, head for texarkana here, I've got a little problem.' He was provided a vector & advised of closest airports. Shortly after, he stated he would be unable to… - [NTSB SEA86FA033](https://openairdocs.org/ntsb/SEA86FA033.md): Mooney M20K · Des Moines, WA · Accident · 4 fatal · Field investigation · Final report · Dec 30, 1985 · N1152T · Destroyed > The weather briefer informed the pilot that VFR was not recommended due to current/forecast condtions. The non instrument rated pilot then filed a VFR flight plan responding that he was IFR rated and would file inflight if necessary. Witnesses reported… - [NTSB DEN86FA232](https://openairdocs.org/ntsb/DEN86FA232.md): Cessna T210L · Salina, UT · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1985 · N27CF · Destroyed > The non-instrument rated plt did not obtain a wx briefing nor file a flight plan. He and his wife took off from bullfrog basin airport, glen canyon, UT, en route to heber city, UT, on 12-30-85. Acft did not arrive. Civil air patrol search was conducted from… - [NTSB CHI86FEI01](https://openairdocs.org/ntsb/CHI86FEI01.md): Monnet Moni · Perry, OH · Accident · Minor injuries · Final report · Dec 30, 1985 · N685TC · Substantial damage > After initiating a 180 deg turn, the plt heard a 'thump' and noted a low vibration. The acft then pitched down abruptly and entered an inverted spin to ground contact. The plt stated an in flight structural failure of the tail section had occurred which… - [NTSB LAX86LA076](https://openairdocs.org/ntsb/LAX86LA076.md): Mooney M20F · San Manuel, AZ · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N234GA · Substantial damage > During cruise at 10,500 ft MSL on a night x-country flt, the plt said the eng ran rough with moderate vibration levels. Plt declared an emergency with abq ARTCC, who vectored the acft to an unlighted airstrip. The plt said he had difficultyin seeing the rwy… - [NTSB CHI86LA053](https://openairdocs.org/ntsb/CHI86LA053.md): Cessna 150 · Glidden, WI · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1985 · N8687S · Substantial damage > The aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function… - [NTSB MKC86LA041](https://openairdocs.org/ntsb/MKC86LA041.md): Beech M35 · Council Bluffs, IA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1985 · N9730R · Substantial damage > The acft made a gear-up forced lndg off the arpt after a loss of power during a business flt. The acft had only been airborne for about 15 minutes. Post accident investigation discovered that the acft fuel was contaminated with water. - [NTSB LAX86LA075](https://openairdocs.org/ntsb/LAX86LA075.md): Piper PA-34T-22OT · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Dec 26, 1985 · XBDRL · Substantial damage > During a trans border VFR x-country flt, the plt noticed 'oil spirting from the left engine' with smoke, & he shut it down. An emergency was declared by the Tucson ATCT, who cleared the acft to land straight in on rwy 29L. Tower personnel observed the acft… - [NTSB FTW86LPJ04](https://openairdocs.org/ntsb/FTW86LPJ04.md): Cessna 150F · Tulsa, OK · Accident · No injuries · Final report · Dec 26, 1985 · N8535G · Substantial damage > The acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel… - [NTSB FTW86FRG10](https://openairdocs.org/ntsb/FTW86FRG10.md): Mooney M20C · San Antonio, TX · Accident · Minor injuries · Final report · Dec 26, 1985 · N7025V · Destroyed > The acft was destroyed during a forced landing. While en route over the San Antonio area the plt noticed a few drops of what he believed to be precipitation on the windshield. Shortly thereafter, it was determined the drops on the windshield were oil. The… - [NTSB ATL86LA048](https://openairdocs.org/ntsb/ATL86LA048.md): Cessna 172 · Kings Mountain, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1985 · N7300A · Substantial damage > The acft had been moored on an open ramp in extremely cold tempertures. During preflight the plt found that the fuel strainer drain would not close and one wing tank drain would not open. A mechanic attempted to repair the leaking strainer but could not stop… - [NTSB DEN86FA054](https://openairdocs.org/ntsb/DEN86FA054.md): Bell 206-L3 · Monument Valley, UT · Accident · 1 fatal · Field investigation · Final report · Dec 25, 1985 · N10UB · Destroyed > The helicopter contacted power lines and the terrain during an attempted takeoff from a hospital after a cancelled med-evac flt. The hospital is located in a box canyon surrounded by high terrain and power lines. The plt was aware of the power line that… - [NTSB FTW86FRG09](https://openairdocs.org/ntsb/FTW86FRG09.md): Robinson R22 HT · Sonora, TX · Accident · Serious injuries · Final report · Dec 23, 1985 · N9074U · Substantial damage > The helicopter contacted the terrain in an uncontrolled descent after colliding with power lines during a climbing turn to the west. The plt reported he could not see the power lines because of glare from the setting sun. - [NTSB DEN86LTM01](https://openairdocs.org/ntsb/DEN86LTM01.md): Cessna 172 · Brigham City, UT · Accident · Serious injuries · Final report · Dec 22, 1985 · N64005 · Destroyed > The acft contacted mountainous terrain during a descent through fog. The plt stated that on the return flt from malad, ID, he began following a mountain range which he believed would take him back to ogden. However, the range guided him southwest of the… - [NTSB CHI86MA052](https://openairdocs.org/ntsb/CHI86MA052.md): Cessna 177B · Brooklyn, MI · Accident · 6 fatal · Major investigation · Final report · Dec 22, 1985 · N34046 · Destroyed > The pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet… - [NTSB NYC86LA051](https://openairdocs.org/ntsb/NYC86LA051.md): Piper PA-28R-201 · Bristol, CT · Accident · No injuries · Limited investigation · Final report · Dec 21, 1985 · N61260 · Substantial damage > The acft was on a return flight back to teterboro when an eng failure occurred for unknown reasons. The plt requested vectors to the nearest arpt which was robertson but he was not able to reach it. A forced landing resulted in an open fld during which the… - [NTSB MKC86FA037](https://openairdocs.org/ntsb/MKC86FA037.md): Bell 206L · Ainsworth, NE · Accident · 3 fatal · Field investigation · Final report · Dec 21, 1985 · N110LG · Destroyed > This med-evac helicopter was being positioned to pick up a patient. The plt obtained a wx briefing which included a forecast for a chance of marginal VMC along the planned route, although at the time of the briefing the dest weather was VMC. The flt departed… - [NTSB LAX86FA069](https://openairdocs.org/ntsb/LAX86FA069.md): Piper PA-24-260 · Newport Beach, CA · Accident · 1 fatal · Field investigation · Final report · Dec 19, 1985 · N9044P · Destroyed > The plt contacted coast TRACON (terminal radar control) & requested VFR traffic advisories to torrence. At aprx 0747 psthe declared an emergency, said the eng had quit & requested vectors to the john wayne/orange county arpt. The controllerprovided a hdg to… - [NTSB LAX86LA068](https://openairdocs.org/ntsb/LAX86LA068.md): Piper PA-24-250 · Canoga Park, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1985 · N6740P · Substantial damage > While the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest… - [NTSB DEN86LA050](https://openairdocs.org/ntsb/DEN86LA050.md): Beech V-35B · Wibaux, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1985 · N24198 · Destroyed > The plt stated that light snow was falling at the arpt at the time of departure. The pax stated after the accident that the plt encountered clouds at their cruise alt of about 6000 ft. he continued to state that the acft made a shallow descent at first… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=331 ## 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=330 --- 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.