# 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 361 of 718 · 35,889 cases ## Cases, newest first - [NTSB LAX84FA068](https://openairdocs.org/ntsb/LAX84FA068.md): Piper PA-28-236 · Wikieup, AZ · Accident · 4 fatal · Field investigation · Final report · Nov 21, 1983 · N4291R · Destroyed > Before taking off, the plt obtained 2 wx briefings & was advised that VFR flt was not recommended. He departed at 1730. Several requests were made for en route wx from las vegas flt watch. At 1945, the plt declared an emergency & indicated that he was lost.… - [NTSB FTW84LA070](https://openairdocs.org/ntsb/FTW84LA070.md): Piper PA28RT-201T · Cameron, TX · Accident · No injuries · Limited investigation · Final report · Nov 21, 1983 · N2124N · Destroyed > The acft collided with trees during a forced landing after engine failure. During post accident examination the clamp which secures the turbocharger inlet tube to the engine exhaust was found to be off the threads of the bolt and were not damaged and the nut… - [NTSB FTW84LA067](https://openairdocs.org/ntsb/FTW84LA067.md): Cessna 172M · Okmulgee, OK · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 1983 · N80110 · Destroyed > According to the plt, the eng was not producing sufficient power to maintain alt in normal cruise. Also, he reported that 'extra power' was required on final apch for landing at the destination arpt. He further stated that he was unable 'to cut power to idle'… - [NTSB NYC84FA033](https://openairdocs.org/ntsb/NYC84FA033.md): Aero Commander 500B · Franklin, PA · Accident · 6 fatal · Field investigation · Final report · Nov 20, 1983 · N6226X · Destroyed > Before departing youngstown, OH, the plt filed 2 IFR flt plans, 1 for a flt to plattsburgh, NY, the other for a return flt from plattsburgh back to youngstown. After a 2 hr & 10 min flt to plattsburgh, 70 gal of fuel was added, but the person who serviced the… - [NTSB CHI84FA049](https://openairdocs.org/ntsb/CHI84FA049.md): Piper PA-28-161 · Dexter, MI · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1983 · N8162D · Destroyed > At 2135 EST, the plt called the lansing fss & requested a wx forcast for the detroit city arpt & winds aloft. He was briefed, but he did not file a flt plan, sometime after 2200 EST, he took off form mason, MI on a passenger flt to ann arbor, MI. At 2252, the… - [NTSB NYC84FA032](https://openairdocs.org/ntsb/NYC84FA032.md): Beech K35 · Stockholm, NJ · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1983 · N106Q · 2 aircraft · Destroyed > At 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34… - [NTSB FTW84FA064](https://openairdocs.org/ntsb/FTW84FA064.md): Cessna T210N · Nageezi, NM · Accident · 3 fatal · Field investigation · Final report · Nov 18, 1983 · N4888Y · Destroyed > Before takeoff, the plt was informed of a segmet which forcasted occasional severe rime or mixed icing from the freezing level at 8000 ft up thru 20,000 ft & moderate to severe turbulence below 18,000 ft. also, embedded thunderstorms, lightning & thunder were… - [NTSB CHI84LA046](https://openairdocs.org/ntsb/CHI84LA046.md): Piper PA-28-180 · Northfield, MN · Accident · Minor injuries · Limited investigation · Final report · Nov 18, 1983 · N15255 · Destroyed > The plt stated that while enroute at an alt of 3000 ft MSL the eng failed. He also stated that all attempts to restart the eng failed so he proceeded to make an emergency landing. Investigation revealed a manufacturing defect in the left magneto; the body… - [NTSB MKC84LA024](https://openairdocs.org/ntsb/MKC84LA024.md): Aero Commander 100 · Sargent, NE · Accident · No injuries · Limited investigation · Final report · Nov 16, 1983 · N3630X · Substantial damage > The pilot became dioriented on a flight from hastings, NE enroute to Sargent, NE. He decided to land on a county road west of Sargent. During the landing the acft right wing tip struck a pole and the acft tipped up on its nose. - [NTSB MKC84LA020](https://openairdocs.org/ntsb/MKC84LA020.md): American AA1 · Wiota, IA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1983 · N5762L · Substantial damage > The acft was in cruise flt at aprx 2500 ft when the eng lost power. The plt was able to restart the eng, but it ran only momentarily, then quit again. The best available place for a forced landing was a muddy, plowed field. During the landing roll, the acft… - [NTSB CHI84LA040](https://openairdocs.org/ntsb/CHI84LA040.md): Piper PA-28-140 · Mankato, MN · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 1983 · N6128W · Destroyed > The plt received 2 wx briefings before the flt & was advised that VFR flt was not recommended. Prior to departing, the 50 gal fuel sys was serviced with 35 gal of fuel. The plt reported that during the flt, he descended the acft thru a hole in the clouds… - [NTSB SEA84FA020](https://openairdocs.org/ntsb/SEA84FA020.md): Jodel-Bernier Jodel F-11 · Inkom, ID · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1983 · N49842 · Destroyed > The acft crashed during a forced landing attempt after the engine quit. The pilot reported the engine stopped while in cruise flt. It started and stopped and started a 2nd time but would not maintain flt. The pilot turned toward a hayfieldfor landing. The… - [NTSB NYC84LA028](https://openairdocs.org/ntsb/NYC84LA028.md): Beech C35 · Martha'S Vineyard, MA · Accident · No injuries · Limited investigation · Final report · Nov 13, 1983 · N1882D · Substantial damage > The plt had departed Martha'S Vineyard arpt & was climbing over lagoon pond (a large body of salt water) at aprx 900 ft AGL when the eng lost power. The plt decided the arpt was too FAR away for an emergency landing & there were trees in the area, so he… - [NTSB FTW84FA049](https://openairdocs.org/ntsb/FTW84FA049.md): Piper PA-23-250 · Waco, TX · Accident · Serious injuries · Field investigation · Final report · Nov 13, 1983 · N989EB · Destroyed > The acft had climbed to about 7,500 ft when the plt encountered an overspeeding left eng. He turned back toward Waco & feathered the left prop. While receiving emergency vectors to an arpt the right eng quit. While breaking out of the overcast the plt saw a… - [NTSB MKC84LA025](https://openairdocs.org/ntsb/MKC84LA025.md): Piper PA-31-310 · Kirksville, MO · Accident · No injuries · Limited investigation · Final report · Nov 12, 1983 · N9117Y · Substantial damage > After taking off & climbing to 2000 ft, the plt heard a 'thud.' He reduced power & detected no mechanical or control problem & continued to kirkville, MO. After landing, damage & evidence of a bird strike were found on the leading edge of the right wing. - [NTSB LAX84FA065](https://openairdocs.org/ntsb/LAX84FA065.md): Mooney M20A · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · Nov 12, 1983 · N8110E · Destroyed > The acft crashed into a mountain side at some time prior to 0900 on 11/12/83 when the ELT signal was 1st reported, via satellite. Before the flt, the student plt was last seen in bakersfield, CA at about 0100 that morning. A rescue mission was delayed due to… - [NTSB DCA84AA006](https://openairdocs.org/ntsb/DCA84AA006.md): Boeing 727-225A · Miami, FL · Accident · Serious injuries · Final report · Nov 12, 1983 · N812EA · Substantial damage > After departing Miami & climbing through 10,900 ft the #3 right main landing gear tire exploded causing massive damage to systems a & b hydraulic lines which resulted in a loss of a & b hydraulic systems. The acft returned to Miami & the crew was unable to… - [NTSB MKC84FA019](https://openairdocs.org/ntsb/MKC84FA019.md): Piper PA-28-161 · Albion, NE · Accident · 2 fatal · Field investigation · Final report · Nov 11, 1983 · N2220Y · Destroyed > The acft collided with a tv transmitter tower guy wire. Witnesses stated that clouds were obscuring the top of the 1,134 ft tall tower. The acft was about 750 ft AGL when the collision occurred. The tower was not equipped with high intensity obstruction… - [NTSB MIA84LA028](https://openairdocs.org/ntsb/MIA84LA028.md): Grumman American AA-5B · Okeechobee, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1983 · N123EF · Substantial damage > The plt reported that during flt, the eng had a partial loss of power. He attempted to divert to an arpt. He was able to get on final apch, but when he saw he could not reach the runway, he turned away from the lights & a building for an emergency landing.… - [NTSB LAX84FA057](https://openairdocs.org/ntsb/LAX84FA057.md): Piper PA-38-112 · Inglewood, CA · Accident · Serious injuries · Field investigation · Final report · Nov 11, 1983 · N2570V · Destroyed > The student said that the eng lost power & he initiated an emergency landing. He switched fuel tanks, applied carburetor heat & checked the magnetos. However, before landing, the eng restarted & the student applied full power & began to climb, not realizing… - [NTSB FTW84LA048](https://openairdocs.org/ntsb/FTW84LA048.md): Beech E55 · Terrell, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 1983 · N911J · Substantial damage > During a flt, late at night, the plt turned on the heater. About 40 to 45 mi north of the leona VOR, he reportedly engaged the autoplt & began working on the flt logs. About 50 mi further north, the acft flew into a field in a wings level attitude. The plt… - [NTSB ANC84LA015](https://openairdocs.org/ntsb/ANC84LA015.md): Stinson 108 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Nov 10, 1983 · N97155 · Substantial damage > After takeoff the eng lost 50% of its power & a forced landing was made in trees. The plt believed the eng failure was due to water/ice in fuel. - [NTSB SEA84LA019](https://openairdocs.org/ntsb/SEA84LA019.md): Morton B8M · Shelton, WA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1983 · N37860 · Substantial damage > The acrt collided with fir trees, about 18 feet tall, during an off-arpt forced landing after a power loss. The plt suspected carburetor ice. He said the engine began to run rough and RPM dropped to about 1200/1500 RPM. When he was unable to clear the trees… - [NTSB FTW84FA047](https://openairdocs.org/ntsb/FTW84FA047.md): Aero Commander 520 · Clines Corners, NM · Accident · 2 fatal · Field investigation · Final report · Nov 9, 1983 · N4116B · Destroyed > The non-instrument rated plt was on ferry flt from bartlesville, ok to ontario, CA. An en route stop was made at tucumcari, NM, where the acft was refueled & 14 qts of oil was added to the left eng. The line boy who serviced the acft saw no visible oil leaks… - [NTSB LAX84AA054](https://openairdocs.org/ntsb/LAX84AA054.md): Westland Helicopters 30-100 · Long Beach, CA · Accident · Serious injuries · Final report · Nov 8, 1983 · N5830T · Destroyed > At 4,000 ft MSL directional control was lost. Witnesses observed the helicopter descending through the localized cloud layer in a left high-rotation turn, with the pitch attitude varying & its rate of descent 'very fast.' The helicopter then collided with… - [NTSB ATL84LA041](https://openairdocs.org/ntsb/ATL84LA041.md): Piper PA-32R-300 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Nov 7, 1983 · N1750H · Substantial damage > While en route, the acft's ammeter went to a zero reading, and subsequently, a complete electrical failure occurred. Prior to landing, the plt attempted to lower the landing gear by letting it freefall, in accordance with recommended procedures. The gear… - [NTSB MKC84FA016](https://openairdocs.org/ntsb/MKC84FA016.md): Stinson 108 · Angora, NE · Accident · Serious injuries · Field investigation · Final report · Nov 6, 1983 · N39468 · Substantial damage > The plt reported that the eng began running rough, then quit while he was flying over an area of rough terrain. He reported that as he was making a forced landing, the acft came in contact with a washed out ditch, cartwheeled & hit a fence. An exam of the eng… - [NTSB MKC84FA014](https://openairdocs.org/ntsb/MKC84FA014.md): Cessna 210M · Greensburg, KS · Accident · 5 fatal · Field investigation · Final report · Nov 6, 1983 · N732SB · Destroyed > At 1619 CST, the non-instrument rated plt called the dodge city fss & requested the current dodge city wx. He was given the current & forcasted wx. He took off at 1825 & at 1846, he called the la junta radio & requested an update on the dodge city wx as well… - [NTSB LAX84FA049](https://openairdocs.org/ntsb/LAX84FA049.md): Piper 601P · Helendale, CA · Accident · No injuries · Field investigation · Final report · Nov 6, 1983 · N9774Q · Substantial damage > The pilot stated that during cruise flight the right engine manifold pressure fell to zero. The engine was feathered and set up for single engine performance but the acft continued to descend. Suitable airports were flown over during the descent and the acft… - [NTSB DEN84FU001](https://openairdocs.org/ntsb/DEN84FU001.md): Eipper Quicksilver E · Fargo, ND · Accident · Serious injuries · Final report · Nov 6, 1983 · UNREG · Destroyed > The non-rated plt had taken ground & dual flt instruction in ultralight flying & had soloed earlier that day. He then took off & flew east, away from the designated ultralight training area. Just prior to the accident, witnesses driving east on an interstate… - [NTSB CHI84FA037](https://openairdocs.org/ntsb/CHI84FA037.md): Cessna 152 II · Decatur, MI · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1983 · N5528L · Destroyed > The acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was… - [NTSB MIA84IA024](https://openairdocs.org/ntsb/MIA84IA024.md): Beech BE-33A · Near Avon Park, FL · Incident · No injuries · Incident investigation · Final report · Nov 5, 1983 · N5483U · Minor damage > While in cruise flight the engine failed due to a failure ofthe crankshaft. The crankshaft was not examined to determinewhy it failed. The pilot executed a forced landing to an open field. - [NTSB LAX84FU018](https://openairdocs.org/ntsb/LAX84FU018.md): Mitchell T10 · Sparks, NV · Accident · 2 fatal · Final report · Nov 4, 1983 · UNREG · Destroyed > Ground witnesses observed the ultralight vehicle in straight & level flt. According to them, the vehicle began a pitch oscillation, then went into a steep, right descending spiral until it struck the ground. Another plt, who was flying in the vicinity… - [NTSB ATL84FA033](https://openairdocs.org/ntsb/ATL84FA033.md): Cessna 172F · Brunswick, GA · Accident · 1 fatal · Field investigation · Final report · Oct 31, 1983 · N5236F · Destroyed > The acft was observed entering a cloud layer about 500 ft AGL after takeoff. Another witness observed the acft's navigational lights in a circling motion as the acft plunged to the ground. - [NTSB CHI84LA032](https://openairdocs.org/ntsb/CHI84LA032.md): Cessna 150 · La Crosse, WI · Accident · No injuries · Limited investigation · Final report · Oct 30, 1983 · N23183 · Substantial damage > The acft was ditched in lake onalaska after the engine quit about 1 mile short of destination. After the accident the acft was pulled from the lake and examined. The 3 FAA inspectors who examined the acft verified that there was not enough fuel in the acft to… - [NTSB FTW84FA034](https://openairdocs.org/ntsb/FTW84FA034.md): Ercoupe 415-C · Longview, TX · Accident · 2 fatal · Field investigation · Final report · Oct 29, 1983 · N99096 · Destroyed > As the acft was flying toward the arpt, about 1 mi away, a witness heard a loud pop or bang & then no further eng sound. The plt attempted to climb above some tall trees about 300 yds from the end of the rwy, but impacted the tops of the trees. The #1 conrod… - [NTSB NYC84LA015](https://openairdocs.org/ntsb/NYC84LA015.md): Short Brothers SD3-30 · Middletown, PA · Accident · 1 fatal · Limited investigation · Final report · Oct 28, 1983 · N26288 · No damage > After takeoff on a flt to Washington, DC, the aircraft was climbing thru about 3500 ft when a person (riding as a passenger) moved to the right rear door, opened it & departed the acft. Prior to the flt, an associate, who was an acft refueler, saw the person… - [NTSB NYC84FA016](https://openairdocs.org/ntsb/NYC84FA016.md): Bellanca 17-31 ATC · Littleton, MA · Accident · 2 fatal · Field investigation · Final report · Oct 28, 1983 · N6586V · Destroyed > Ground witnesses observed the right wing separate in flight, the acft bank sharply to the right entered a spiral dive and crashed into a wooded lot in a residential area. Investigation revealed that the right wing separation occurred when the front spar lower… - [NTSB DEN84FA017](https://openairdocs.org/ntsb/DEN84FA017.md): Aerospatiale SE 3180 · Salt Lake City, UT · Accident · No injuries · Field investigation · Final report · Oct 28, 1983 · N544 · Destroyed > The helicopter crashed during a landing on the crest of a mountain. The french helicopter unlike American helicopters has a main rotor that rotates clockwise. To compensate for increased torque the plt must use right pedal instead of leftpedal. The plt in… - [NTSB CHI84LA030](https://openairdocs.org/ntsb/CHI84LA030.md): Piper PA-32-260 · Warsaw, IN · Accident · No injuries · Limited investigation · Final report · Oct 28, 1983 · N15419 · Substantial damage > The acft collapsed the landing gear during a forced landing following eng failure. The acft had been flown 5.5 hours before landing 3 miles NE of the intended refueling stop. The pilot had passed ft wayne at flt time of 5+ hours with about 10 gallons of fuel… - [NTSB NYC84LA014](https://openairdocs.org/ntsb/NYC84LA014.md): Schweizer SGS 1-34 · North Conway, NH · Accident · No injuries · Limited investigation · Final report · Oct 27, 1983 · N7629 · Substantial damage > According to the pilot, the glider was towed to 2000 feet and released, in lift. Flt was in lift for about 30 minutes when a strong sink was suddenly encountered. The glider crashed into trees. - [NTSB FTW84FA032](https://openairdocs.org/ntsb/FTW84FA032.md): Cessna 182Q · Columbus, NM · Accident · 1 fatal · Field investigation · Final report · Oct 27, 1983 · N735CP · Destroyed > The non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500… - [NTSB ATL84FLT01](https://openairdocs.org/ntsb/ATL84FLT01.md): Cessna 152 · Clifton, TN · Accident · Serious injuries · Final report · Oct 27, 1983 · N48825 · Substantial damage > According to the plt, he was descending from 8500 ft to 2500 ft when the eng quit without warning at aprx 4500 ft. he stated that he made a 'mayday' call & attempted to make an emergency landing in a field. However, the acft hit some trees at the edge of the… - [NTSB MKC84FA010](https://openairdocs.org/ntsb/MKC84FA010.md): Convair 340 · St. Louis, MO · Accident · No injuries · Field investigation · Final report · Oct 26, 1983 · N30DR · Substantial damage > While in a climb after takeoff, the aircrew encountered an eng problem (which was reported as detonation) & requested clearance to return to the departure arpt. The flt was vectored for a right traffic pattern to rwy 24. The plt reported he was at 2000 ft MSL… - [NTSB LAX84FA032](https://openairdocs.org/ntsb/LAX84FA032.md): Bell 206L-3 · Grand Canyon, AZ · Accident · No injuries · Field investigation · Final report · Oct 25, 1983 · N38903 · Substantial damage > While on a non-revenue business flt, the plt noted a partial loss of power with the N1 dropping to 70% RPM & the torque decreasing to 10%. He was unable to restore power & subsequently made a forced landing in the Grand Canyon. The landing was made on an… - [NTSB FTW84LA031](https://openairdocs.org/ntsb/FTW84LA031.md): Cessna 172RG · Monticello, AR · Accident · No injuries · Limited investigation · Final report · Oct 25, 1983 · N5092U · Substantial damage > During flt, the plt detected smoke in the cabin. Thinking that an electrical malfunction was the source, he secured the electrical master switch & used the battery. A precautionary landing was made at Monticello, AR. During the landing, the right main gear… - [NTSB ANC84LA011](https://openairdocs.org/ntsb/ANC84LA011.md): Piper PA-20 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Oct 25, 1983 · N6946K · Substantial damage > The eng quit & the plt ditched in skilak lake. The plt later stated that during the repair work after the accident he found the mixture contol dislodged from the carburetor. - [NTSB CHI84FA028](https://openairdocs.org/ntsb/CHI84FA028.md): Beech BE90C · Fort Wayne, IN · Accident · 1 fatal · Field investigation · Final report · Oct 24, 1983 · N4TS · Destroyed > At 1604 EST, the acft departed Fort Wayne on a ferry flt. IFR conditions prevailed & the plt had filed an IFR flt plan. While climbing after takeoff, the plt passed his assigned alt of 2500 ft MSL & flew to 4200 ft. also, he failed to turn to his initial… - [NTSB CHI84FA027](https://openairdocs.org/ntsb/CHI84FA027.md): Mooney M20E · Newark, IN · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1983 · N7144U · Destroyed > The acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi… - [NTSB LAX84FA029](https://openairdocs.org/ntsb/LAX84FA029.md): Mooney M20F · Indian Springs, NV · Accident · No injuries · Field investigation · Final report · Oct 23, 1983 · N6912 · Substantial damage > At 5,500 ft altitude the eng began slowly losing power. Unable to maintain altitude, the plt made a gear up landing in rough terrain. Examination of the eng revealed no discrepaniies. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=362 ## 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=361 --- 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.