# 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 329 of 718 · 35,889 cases ## Cases, newest first - [NTSB SEA86FA066](https://openairdocs.org/ntsb/SEA86FA066.md): Piper PA34-200T · Antelope, OR · Accident · 2 fatal · Field investigation · Final report · Feb 26, 1986 · N8305C · Destroyed > Plt was operating VFR on top at 11000 feet, commenced descent to destination 34 miles out. Plt rpted field in sight 16 miles out, passing 6500 ft, cancelled flight plan. Acft impacted ridge at 4100 feet MSL 7 miles from destination. Dark night conds existed,… - [NTSB MIA86FA085](https://openairdocs.org/ntsb/MIA86FA085.md): Piper PA-32-300 · St. Cloud, FL · Accident · 1 fatal · Field investigation · Final report · Feb 26, 1986 · N4081R · Destroyed > The acft was on a VFR flt, the wx was clear with an almost full moon when the acft crashed in a fld. There was no evidence of an airframe, flt control system, eng or propeller malfunction or failure. The autopsy & toxicological studies revealed no pre impact… - [NTSB LAX86LA128](https://openairdocs.org/ntsb/LAX86LA128.md): Ryan ST3KR · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Feb 26, 1986 · N51122 · Substantial damage > The owner of the acft reported that he had just purchased the aircraft and was being checked out at the time of the accident. Shortly after departing cma and upon reaching 1200 ft MSL, the engine lost power. Unable to maintain altitude the check pilot assumed… - [NTSB LAX86LA124](https://openairdocs.org/ntsb/LAX86LA124.md): Cessna 150J · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1986 · N60816 · Substantial damage > The pilot stated that he overflew his destination airport while on a night cross-country flight. He turned around and was proceeding back when the engine quit 20 miles short of his intended destination. The aircraft hit a ditch during the ensuing forced… - [NTSB ATL86LLT07](https://openairdocs.org/ntsb/ATL86LLT07.md): Cessna 152 · Dyersburg, TN · Accident · Serious injuries · Final report · Feb 25, 1986 · N93472 · Destroyed > The acft collided with trees on the edge of a 5000 ft open field during a precautionary landing after the student plt on his first solo x-country became lost & confused. He landed off arpt even though he still had about 3 hrs fuel. Wx was not threatening and… - [NTSB SEA86LA064](https://openairdocs.org/ntsb/SEA86LA064.md): Bell 206B · Mount Baldy, ID · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 1986 · N16800 · Destroyed > The pilot allowed the aircraft to enter into instrument meteorological conditions. The artificial horizon was inoperative as well as the turn portion of the turn and bank. A tree was struck with the aircraft then striking the ground. - [NTSB FTW86FPA17](https://openairdocs.org/ntsb/FTW86FPA17.md): Cessna 421 · Alvord, TX · Accident · Serious injuries · Final report · Feb 22, 1986 · N8155Q · Substantial damage > The acft collided with tree tops and sheared the landing gear during a forced landing off arpt. The left eng had been feathered due to loss of oil from a ruptured oil hose between the oil pump & filter. The rt eng was not developing full power because of an… - [NTSB ATL86MA080](https://openairdocs.org/ntsb/ATL86MA080.md): Beech G18S · Copperhill, TN · Accident · 1 fatal · Major investigation · Final report · Feb 22, 1986 · N74FA · Destroyed > The plt was alerted at 0100 for 0200 flt fm kenosha to milwaukee, WI to pick up cargo for a flt to atlanta, GA. At 0310,the acft deptd milwaukee in VFR. En route, the plt obtained wx & an IFR clnc. Some of his rdo xmsns were not standard. At 0433, he complied… - [NTSB SEA86LA065](https://openairdocs.org/ntsb/SEA86LA065.md): Cessna 206G · Icy Point, AK · Accident · No injuries · Limited investigation · Final report · Feb 21, 1986 · N747BE · Substantial damage > A precautionary landing was made due to deteriorating weather. Landing was accomplished onto a frozen slough. During touch down during high gusty crosswinds the aircraft veered right with the right gear breaking through the ice. The aircraft bounced up onto… - [NTSB SEA86LA063](https://openairdocs.org/ntsb/SEA86LA063.md): Navion A · White Salmon, WA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1986 · N340H · Destroyed > During IFR cruise, a loss of power occurred. The pilot complied with emergency procedures for power loss but when he reached down to switch the fuel tank selector he lost control of the aircraft and entered into a nose down unusual attitude, descending at the… - [NTSB LAX86LA121](https://openairdocs.org/ntsb/LAX86LA121.md): Mooney MK-20 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Feb 20, 1986 · N8135E · Destroyed > A Mooney mk 20 collided with the runway surface after an engine failure. The engine failed on climb at about 1500 feet AGL and would not restart. The aircraft returned to the airport and landed downwind. The landing gear collapsed and the aircraft skidded off… - [NTSB SEA86LA060](https://openairdocs.org/ntsb/SEA86LA060.md): Cessna 340 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Feb 19, 1986 · N7774Q · Substantial damage > The aircraft encountered airframe icing on a descent for a VOR approach. 1/8 to 1/4 inch of ice was present during landing. The pilot allowed a stall to occur prior to touch down with a hard landing resulting. - [NTSB MIA86FA081](https://openairdocs.org/ntsb/MIA86FA081.md): Consolidated Aeronautics Lake LA-4-200 · Auburndale, FL · Accident · Serious injuries · Field investigation · Final report · Feb 19, 1986 · N6221V · Destroyed > The plt stated that just after passing lakeland, FL, his eng RPM began to fluctuate. He selected his aux fuel tanks but the RPM continued to deteriorate. He elected to make his forced landing on a small lake but not having enough alt to turn & land into the… - [NTSB DEN86FA077](https://openairdocs.org/ntsb/DEN86FA077.md): Cessna P210N · Dulce, NM · Accident · 3 fatal · Field investigation · Final report · Feb 17, 1986 · N5196W · Substantial damage > The plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the… - [NTSB LAX86LA123](https://openairdocs.org/ntsb/LAX86LA123.md): Globe Swift GC-1B · Upland, CA · Accident · No injuries · Limited investigation · Final report · Feb 16, 1986 · N80561 · Substantial damage > On February 16, 1986 at 1515 PST, a swift GC-1B, N80561, collided with terrain after a forced landing. After t/o at approximately 400 feet AGL the engine began to run rough and the aircraft would not maintain altitude. Traffic on the rwy prevented an on apt… - [NTSB ATL86LA075](https://openairdocs.org/ntsb/ATL86LA075.md): Beech V35B · Lake Lure, NC · Accident · No injuries · Limited investigation · Final report · Feb 16, 1986 · N11JK · Substantial damage > The plt contacted approach control for VFR staging to airport and radar service. The plt later indicated a forced landing was necessary due to fuel exhaustion. The plt calculated full fuel tanks for flt but failed to recall two local flights that were made… - [NTSB MKC86FA059](https://openairdocs.org/ntsb/MKC86FA059.md): Swearingen SA226TC · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Feb 15, 1986 · N252AM · Substantial damage > During a climb to cruise, the pilot-in-command declared an emergency & requested to dscnd & return to the arpt. The landing was uneventful. An exam of the left prop revealed that 1 of its 3 blades had failed at the butt end & had separated. Subsequently, the… - [NTSB MIA86LA077](https://openairdocs.org/ntsb/MIA86LA077.md): Cessna 152 · Ft. Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 1986 · N772WA · Substantial damage > The flt was cruising at 2000 ft with the mixture leaned for cruise. A descent to 1000 ft was made by reducing power. Shortly after leveling off, the engine began to lose power and max RPM available was 1700. The plt said he pumped the throttle several times… - [NTSB SEA86FA056](https://openairdocs.org/ntsb/SEA86FA056.md): McDonnell Douglas 369D · Cougar, WA · Accident · 3 fatal · Field investigation · Final report · Feb 11, 1986 · N609PD · Destroyed > The helicopter departed the landing area after a night photography session across the valley floor from the Mt. St. Helens volcano. Prior to departure the plt reported the weather was closing in and getting 'nasty'. Wx conditions as reported prior to… - [NTSB ATL86LA073](https://openairdocs.org/ntsb/ATL86LA073.md): Cessna U206B · Columbia, TN · Accident · No injuries · Limited investigation · Final report · Feb 11, 1986 · N3403L · Substantial damage > Soon after departure the plt experienced a severe vibration throughout the acft. Eng pwr was retarded and the vibration subsided. The plt then noticed aileron control problems and noticed the left wing tip was moving up and down. An emergency landing was made… - [NTSB ANC86MA027](https://openairdocs.org/ntsb/ANC86MA027.md): Cessna 207 · Nome, AK · Accident · 3 fatal · Major investigation · Final report · Feb 11, 1986 · N9468M · Destroyed > The acft departed during a break in the wx after having waited for a special VFR departure. His departure radio call was the last communication from the flt. The wx remained marginal with icing in the clouds and freezing drizzle. The acft was on a flt to… - [NTSB LAX86LUQ02](https://openairdocs.org/ntsb/LAX86LUQ02.md): Rutan Varieze · Los Almos, CA · Accident · No injuries · Final report · Feb 10, 1986 · N36RJ · Substantial damage > The acft collided with a fence during a forced landing on a hiway after the engine lost power while cruising at 6500 ft MSL. The plt had refueled with 10 gals of fuel at santa barbara, CA his last departure point. Post acc exam showed the fuel tanks, lines… - [NTSB LAX86LA110](https://openairdocs.org/ntsb/LAX86LA110.md): Piper PA-23-250 · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1986 · N5300Y · Destroyed > On feb 9, 1986 at 1717 PST a Piper PA-23, N5300Y, ditched approximately 460 NM sw of sfo, CA. The flt originated from hnl, HI. In flt fuel leak was discovered after 7 hrs of flight. Fuel vapors were seen contrailing off both wings. The plt attempted to… - [NTSB CHI86LA084](https://openairdocs.org/ntsb/CHI86LA084.md): Cessna 207 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Feb 10, 1986 · N18SA · Substantial damage > After preheating the eng the plt took off and during climb the cabin filled with smoke and the eng stopped. A forced landing was made on a city street during which the left wing contacted a sign pole. Post accident teardown of the eng disclosed that an oil… - [NTSB ATL86LA072](https://openairdocs.org/ntsb/ATL86LA072.md): Piper PA-28-181 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 9, 1986 · N39663 · Substantial damage > While on a personal cross-country flight the aircraft experienced a complete loss of power and made an emergency landing on a road 2.5 miles east of the airport. The pilot stated that the aircraft ran out of fuel. - [NTSB ATL86LA070](https://openairdocs.org/ntsb/ATL86LA070.md): Cessna 210 · Alma, GA · Accident · Minor injuries · Limited investigation · Final report · Feb 9, 1986 · N4981U · Substantial damage > The pilot reported that the engine quit during his descent from the 2000 foot cruise altitude. The aircraft examination failed to disclose any system malfunction or failure. The pilot stated that his preflight indicated that there was about 1/2 and 1/3 tanks… - [NTSB LAX86LA111](https://openairdocs.org/ntsb/LAX86LA111.md): Piper PA-28-140 · Joshua Tree, CA · Accident · No injuries · Limited investigation · Final report · Feb 8, 1986 · N9974W · Substantial damage > On feb 28 1986, at 0830 PST, a Piper PA-28 collided with a Tree after a forced landing. IMC prevailed at the time. A/c flew into deteriorating weather conditions enroute and climbed to 11,000 feet MSL to get above it. During the climb IMC was encountered.… - [NTSB LAX86LA112](https://openairdocs.org/ntsb/LAX86LA112.md): Cessna TU206G · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Feb 7, 1986 · N5340X · Substantial damage > While returning from grand canyon, AZ, 14 CFR 135 sightseeing flt to scottsdale, AZ, the plt reported the acft experienced a power loss; all other instrument indications were normal. The plt enriched the mixture and changed fuel tanks but to no avail. The plt… - [NTSB LAX86FA107](https://openairdocs.org/ntsb/LAX86FA107.md): Piper PA-28-181 · Fort Bragg, CA · Accident · 4 fatal · Field investigation · Final report · Feb 7, 1986 · N8338N · Destroyed > After arriving at the mendocino county arpt, at about 1630 PST, the plt & pax obtained a car & went to mendocino for dinner. Drg the evening, they consumed svrl drinks & had a bottle of wine with their dinner, then went back to the arpt. Altho it was a dark… - [NTSB CHI86IA083](https://openairdocs.org/ntsb/CHI86IA083.md): Boeing 727-22 · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Feb 6, 1986 · N7059U · Minor damage > The flight crew was unable to lower the nose wheel landing gear through either the normal or backup systems. The airplane subsquently made a nose gear up landing resulting in minor damage to the airplane. An examination of the nose gear drag brace assembly… - [NTSB NYC86LA072](https://openairdocs.org/ntsb/NYC86LA072.md): Cessna 150 · Naugatuck, CT · Accident · Serious injuries · Limited investigation · Final report · Feb 4, 1986 · N6007G · Substantial damage > A student pilot preflighted Cessna 150, departed the airport and performed a few touch and go landings before leaving the area and following the merrit parkway in Connecticut. The pilot stated that the engine was not running smooth. The pilot landed at cross… - [NTSB MIA86FA071](https://openairdocs.org/ntsb/MIA86FA071.md): Cessna 401 · Parkland, FL · Accident · No injuries · Field investigation · Final report · Feb 4, 1986 · N900PC · Substantial damage > The plt stated that due to a miscalculation of his fuel supply, his loss of power was a result of fuel exhaustion. - [NTSB NYC86LA071](https://openairdocs.org/ntsb/NYC86LA071.md): Mooney M20J · Johnstown, PA · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1986 · N1144P · Destroyed > The flight was enroute from louisville Kentucky to Connecticut. While cruising at 9000 ft an engine power loss was experienced. An emergency was declared. The ATC set up an ILS approach to runway 33 at Johnstown, PA. However the pilot could not maintain… - [NTSB MKC86LA147](https://openairdocs.org/ntsb/MKC86LA147.md): Piper PA-32-300 · West Alton, MO · Accident · No injuries · Limited investigation · Final report · Feb 3, 1986 · N56685 · Substantial damage > The plt stated that during preflight he confirmed that the acft needed fuel. After refueling was completed, the plt stated, there was a considerable amount of water in the fuel samples. The plt, also an A&P, tried to clear the fuel system of trapped water. He… - [NTSB LAX86LA104](https://openairdocs.org/ntsb/LAX86LA104.md): Pitts S-1 · Julian, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 1986 · N7JB · Substantial damage > A Pitts S-1 nosed over on landing roll in rough terrain after an engine failure. The plt indicated due to faulty and poor wx briefings the flight was detoured from the primary and alternate routes and the aircraft ran out of fuel. The plt had contacted fss on… - [NTSB MKC86FCQ01](https://openairdocs.org/ntsb/MKC86FCQ01.md): Kuhn Sonerai II · Sedgwick, KS · Accident · Serious injuries · Final report · Feb 2, 1986 · N23BK · Substantial damage > The plt noticed eng oil on the cockpit canopy during the local flt and decided to make a precautionary landing. The landing was made in a wheat field where the acft contacted a fence. The nose gear then collapsed and the acft nosed over. Post accident… - [NTSB MIA86LA070](https://openairdocs.org/ntsb/MIA86LA070.md): Let L-13 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Feb 2, 1986 · N26TS · Substantial damage > The pilot stated that he encountered sinking air & was unable to make the arpt. He also stated that he was operating east of the arpt & that a seabreeze wind from the west existed at the time of the accident. The effective glide ratio of a glider is reduced… - [NTSB DEN86FA071](https://openairdocs.org/ntsb/DEN86FA071.md): Cessna 180 · Kalispell, MT · Accident · 1 fatal · Field investigation · Final report · Feb 2, 1986 · N2874K · Destroyed > The plt received a wx briefing and filed an IFR flt plan to Boeing field, seattle, WA. He departed Kalispell, MT, at 1135 MST. When the plt arrived in the spokane area, he obtained wx reports for seattle and decided to turn around and return to Kalispell. Wx… - [NTSB CHI86LA081](https://openairdocs.org/ntsb/CHI86LA081.md): Cessna 150M · Marengo, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 1986 · N2942V · Destroyed > The plt was relying on his loran c for navigation when he decided to alter his destination to Delaware municipal arpt due to adverse winds and turbulence. He had been checking his charts for obstructions when the acft collided with trees in a wooded area… - [NTSB SEA86LA051](https://openairdocs.org/ntsb/SEA86LA051.md): Cessna 182 · Sandy, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 1986 · N2085R · Substantial damage > A total loss of power occurred due to a complete loss of oil. During engine teardown it was found that the oil filter adapter had slipped past the threads in the oil pump housing. The aircraft had the oil filter adapter replaced as well as the o ring on… - [NTSB SEA86FA052](https://openairdocs.org/ntsb/SEA86FA052.md): Cessna 195 · Black Diamond, WA · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1986 · N4339N · Destroyed > Radar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.… - [NTSB LAX86FA102](https://openairdocs.org/ntsb/LAX86FA102.md): Piper PA-28-161 · Bridgeport, CA · Accident · 2 fatal · Field investigation · Final report · Jan 30, 1986 · N2134M · Substantial damage > Drg flt over mountainous terrain, the plt encountered instrument meteorological conditions along his route of flt. A witness observed the acft flying at about 200 ft AGL under a cloud layer, then it disappeared in a snow shower. A search was initiated & the… - [NTSB DCA86AA017](https://openairdocs.org/ntsb/DCA86AA017.md): Cessna P210N · Keflavik, Iceland · Accident · 2 fatal · Final report · Jan 29, 1986 · N4906K · Destroyed > At 1146 gmt, N4906K deptd on a 5 hr flt to narssarssuaq, greenland with an estd 7 hrs of fuel. When the plt rprtd 60 mi sw of greenland, the destn vis was below IFR min & the ceiling at the altn arpt was below the mda. The plt elected to cont to reykjavik,… - [NTSB CHI86LA080](https://openairdocs.org/ntsb/CHI86LA080.md): Champion Citabria 7GCBC · Ely, MN · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1986 · N1856G · Substantial damage > During a descent from 1000 ft AGL to 200 ft AGL to photograph wildlife the pilot applied carb heat. When he advanced the throttle at 200 ft to level off the engine did not respond. The aircraft then settled into trees. Temperature at the time was -5 deg f.,… - [NTSB CHI86FA077](https://openairdocs.org/ntsb/CHI86FA077.md): Mooney M20C · Loogootee, IN · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1986 · N9307V · Destroyed > Plt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine… - [NTSB LAX86FA099](https://openairdocs.org/ntsb/LAX86FA099.md): Cessna 172A · Strathmore, CA · Accident · 1 fatal · Field investigation · Final report · Jan 26, 1986 · N7672T · Destroyed > Upon returning to his home airport, the non-instrument rated pilot was unable to see the runway due to heavy fog covering the area. He entered a right descending turn in an attempt to descend under the fog. The aircraft collided with orange trees… - [NTSB FTW86LRA07](https://openairdocs.org/ntsb/FTW86LRA07.md): Bell 206L-1 · Sabine Pass, TX · Accident · Serious injuries · Final report · Jan 25, 1986 · N5748Y · No damage > Acft encountered deteriorating weather enroute from shore to an oil rig that was under tow in the gulf of Mexico. Upon encountering IMC conditions, the plt climbed to 600' AGL for better obstacle clearance and turned back toward the beach. During a subsequent… - [NTSB DEN86LA073](https://openairdocs.org/ntsb/DEN86LA073.md): Eipper Quicksilver MX II · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Jan 23, 1986 · UNREG · Substantial damage > The plt stated that while returning to the airfield, the eng quit as a result of fuel starvation. The plt was not certified and the aircraft was unregistered. - [NTSB ATL86FA063](https://openairdocs.org/ntsb/ATL86FA063.md): Beech 95-B55 · Anniston, AL · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1986 · N7948K · Destroyed > The acft was observed flying through the base of the low level cloud layer prior to its impact on the side of a mountain. The plt was not instrument rated, had not filed a flt plan nor obtained a wx briefing. The impact point was several hundred ft below the… - [NTSB MIA86LA062](https://openairdocs.org/ntsb/MIA86LA062.md): Rockwell 112TC · Atlantic Ocean (Atlantic Ocean) · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 1986 · N4535W · Destroyed > The aircraft was in cruise flight when the pilot reported an engine failure. The pilot executed a forced landing to the Atlantic Ocean and the aircraft sank, and was not recovered. The cause of the engine failure is undetermined. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=330 ## 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=329 --- 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.