# 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 351 of 718 · 35,889 cases ## Cases, newest first - [NTSB ANC84FA131](https://openairdocs.org/ntsb/ANC84FA131.md): Piper PA-22 · Delta Junction, AK · Accident · No injuries · Field investigation · Final report · Aug 7, 1984 · N5793D · Substantial damage > The acft was damaged in an off arpt landing after the engine lost power. The plt stated the acft was operating on automotive fuel without the required supplemental type certificate. The acft was operating without the required annual inspection and the tbo had… - [NTSB FTW84LA341](https://openairdocs.org/ntsb/FTW84LA341.md): Mooney M20 · Thibodaux, LA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1984 · N3594H · Substantial damage > At 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the… - [NTSB ATL84IA246](https://openairdocs.org/ntsb/ATL84IA246.md): Mcdonnell Douglas DC-9-30 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Aug 6, 1984 · N956VJ · Minor damage > During the climb-out, a 15% decrease in the right eng epr was noted by the flt crew. This was followed by a loud bang & failure of the #2 eng. The #2 eng was shut down & the acft was flown back to the departure arpt. An initial exam revealed that the right… - [NTSB SEA85FA065](https://openairdocs.org/ntsb/SEA85FA065.md): Cessna 177A · Ely, NV · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1984 · N30394 · Destroyed > The acft collided with rising terrain during a night x-country. No flt plan was filed. Radio communications were normal during the short (40 mile) flt, until the plt was asked to change transponder codes. The transponder signal ceased instead. The crash site… - [NTSB DEN84LA260](https://openairdocs.org/ntsb/DEN84LA260.md): Bell 47G · West Glacier, MT · Accident · No injuries · Limited investigation · Final report · Aug 5, 1984 · N7965J · Substantial damage > Following in-flight power loss the pilot performed an autorotation to a forced landing on a highway. On touchdown, the main rotor made contact with a passing motor home. Investigation revealed no fuel on board, although the pilot calculated 0.6 hours of fuel… - [NTSB LAX84FA429](https://openairdocs.org/ntsb/LAX84FA429.md): Bellanca 7ECA · Julian, CA · Accident · 1 fatal · Field investigation · Final report · Aug 4, 1984 · N5516K · Destroyed > After takeoff several 360 deg climbing turns were made to gain alt to clear the mountain ridge. The ridge was approached at 4800 ft MSL with the plt expecting a thermal lift over the 5500 ft level which had been encountered many times before. At 4800 ft MSL… - [NTSB DEN84LA249](https://openairdocs.org/ntsb/DEN84LA249.md): Piper PA-32-260 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Aug 4, 1984 · N3392W · Substantial damage > After discharging sky divers, plt was concentrating on max rate of descent, eng pwr at idle, when fuel tank in use ran day. Pwr loss not noted until throttle applied for level off. Switch to usable fuel tank and restart attempt initiated with insufficient… - [NTSB CHI84LA338](https://openairdocs.org/ntsb/CHI84LA338.md): Piper PA-28-160 · Palmyra, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 1984 · N5086W · Destroyed > While on a personal flt the eng and airframe began to vibrate severely. The plt closed the throttle and turned eastward to land in a mint field. As he approached the field he applied power to clear a row of small houses, but during this maneuver struck a… - [NTSB CHI84LA329](https://openairdocs.org/ntsb/CHI84LA329.md): Gulfstream AA-5A · Wausau, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1984 · N26883 · Destroyed > Drg a x-country flt at 4500 ft, eng began sputtering. Plt adusted the mix; then applied carb heat, but rprtdly for only a short time. Eng contd operg, but at reduced pwr. Acft lost alt & dscndd into clds, but the plt was able to lvl at APRX500' AGL. He… - [NTSB CHI84FA374](https://openairdocs.org/ntsb/CHI84FA374.md): Piper PA-28-180F · Cable, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1984 · N3963R · Destroyed > The acft collided with trees & ground during IMC wx at night. The plt obtained a wx briefing at 1731 hrs CDT by phone from hibbing fss. He was advised that VFR flt was not recommended. No other wx briefing for this flt was recorded. Witnesses at the arpt of… - [NTSB ANC84LA130](https://openairdocs.org/ntsb/ANC84LA130.md): Bellanca 8GCBC · Aleknagik, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1984 · N7662S · Substantial damage > The acft crashed into trees short of a clearing during a forced landing following a prop failure. Post accident attemptsto identify the reasons for the failure were clouded by the impact damage. The acft was placarded warning against continuous high RPM… - [NTSB NYC84FNC07](https://openairdocs.org/ntsb/NYC84FNC07.md): Piper PA-32-260 · Brunswick, ME · Accident · Minor injuries · Final report · Aug 2, 1984 · N3474W · Substantial damage > The acft eng failed without warning at an alt of 2500 ft MSL. During the forced landing at nas Brunswick, the plt executed normal emergency procedures but was not successful in air-starting the acft. He stated that after having the 'abandoned field made' he… - [NTSB CHI84LA326](https://openairdocs.org/ntsb/CHI84LA326.md): Bede Bede 4 · Evansvile, IN · Accident · No injuries · Limited investigation · Final report · Aug 2, 1984 · N469JH · Substantial damage > The acft experienced a total power loss & the plt made a forced landing on a hwy median. The landing gear collapsed & the acft slid to a stop. Post accident inspection revealed that a large portion of the foam air filter had broken off & became lodged in the… - [NTSB ATL85FA039](https://openairdocs.org/ntsb/ATL85FA039.md): Piper PA-31-350 · Petros, TN · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1984 · N27948 · Destroyed > The flt departed ft. lauderdale, FL, on 8-2-84 at aprx 0815 EDT for cincinnati, OH. The acft wreckage was found on 11-17-84 on an up slope of big fodder stack mountain. The acft had contacted a 25 ft tall tree located 200 ft west of the main wreckage. The… - [NTSB ATL84LA240](https://openairdocs.org/ntsb/ATL84LA240.md): Eagle DW-1 · Franklin, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1984 · N8808B · Substantial damage > Flying cross-country on a special ferry permit (the aircraft's annual inspection had expired) the pilot reports a gradual decline in power occurred until altitude could no longer be maintained. A forced landing was accomplished on apublic road, but the pilot… - [NTSB DEN84MA247](https://openairdocs.org/ntsb/DEN84MA247.md): Cessna 421C · Fort Lupton, CO · Accident · 3 fatal · Major investigation · Final report · Aug 1, 1984 · N6231G · Destroyed > During a preflt wx briefing, the plt was advised of thunderstorms & intense rain showers on the route of flt. However, he filed an IFR flt plan & took off. During flt, the ATC controller advised the plt of a level 6 cell ahead & noted that he had no report on… - [NTSB CHI84LA323](https://openairdocs.org/ntsb/CHI84LA323.md): Fairchild BC12-D · Hessel, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 1984 · N94955 · Destroyed > Acft departed in VFR conditions for short x-country flt. No weather briefing was obtained. On initial encounter with deteriorating ceiling and visibility conditions, plt reduced altitude in attempt to maintain ground reference. Course reversal not initiated… - [NTSB FTW84LA353](https://openairdocs.org/ntsb/FTW84LA353.md): Cessna A188B · Driscoll, TX · Accident · No injuries · Limited investigation · Final report · Jul 31, 1984 · N9656G · Substantial damage > Acft experienced a propeller blade failure in flight followed by an engine failure due to the unbalanced forces. While making a forced landing the acft was landed hard. The acft was being flown to a field where aerial application was to be performed and had a… - [NTSB MKC84FA235](https://openairdocs.org/ntsb/MKC84FA235.md): Piper PA32R300 · Des Moines, IA · Accident · Serious injuries · Field investigation · Final report · Jul 30, 1984 · N1654H · Substantial damage > The acft eng began to 'shudder badly' upon reaching a cruise alt of 3500 ft MSL shortly after takeoff. The plt made a 180 deg course reversal to return to the arpt but reported to ATC he was unable to see outside the acft because oil was smeared on the acft.… - [NTSB FTW84FA331](https://openairdocs.org/ntsb/FTW84FA331.md): Cessna A185F · Del Rio, TX · Accident · 1 fatal · Field investigation · Final report · Jul 30, 1984 · N6102E · Destroyed > The non-instrument rated plt took of at night approximately 30 min prior to the accident. Ground scars indicated that the acft impacted the crest of a rocky hill while in a steep nose down, right wing low attitude. The elevation of the crash site was about… - [NTSB DEN84FA242](https://openairdocs.org/ntsb/DEN84FA242.md): Piper PA-28-181 · Park Valley, UT · Accident · 4 fatal · Field investigation · Final report · Jul 30, 1984 · N8445F · Destroyed > Newly certificated pvt plt departed on a moonless night for a VFR flt. Route of flt was over a desert like environment where there are no visual cues for attitude reference. Acft wreckage was found the following day. Acft impacted tundra inverted at a high… - [NTSB DEN84FQA01](https://openairdocs.org/ntsb/DEN84FQA01.md): Demick James A Rand KR2 · Grants, NM · Accident · No injuries · Final report · Jul 29, 1984 · N81JD · Substantial damage > The acft was landed dead stick on a black-top road after the eng lost oil press due to a large leak in an oil seal during cruise flt. During the lndg the left wg hit a sign post alongside a bridge and the wing tip plus the alieron were sheared off. The… - [NTSB FTW84LA328](https://openairdocs.org/ntsb/FTW84LA328.md): Cessna 152 · Floydada, TX · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N94453 · Substantial damage > The student plt became most while he was on the 2nd leg of a x-country flt. He finally determined his position, but exhausted his fuel before reaching an arpt. During a forced landing, the nose gear sank in soft terrain & the acft nosed over. - [NTSB DEN84LA245](https://openairdocs.org/ntsb/DEN84LA245.md): Consolidated-Vultee BT-13B · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N63697 · Substantial damage > As part of a group of a confederate air force acft the flight conducted public relations flyovers at several area arpts. Due to a low ldg gear strut N63697 did not land with the other acft after the flyovers. The plt planned to have the strut repaired upon… - [NTSB ANC84LA127](https://openairdocs.org/ntsb/ANC84LA127.md): North American Navion · Atigun Pass, AK · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N225G · Substantial damage > The acft encountered a downdraft while flying through a mountain Pass. The terrain would not allow the plt to make a 180DEG turn so he elected to land on a road with the landing gear retracted. - [NTSB ANC84LA123](https://openairdocs.org/ntsb/ANC84LA123.md): Cessna 180H · Chicken, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1984 · N3476Y · Substantial damage > While en route to dawson city, Canada, the plt encountered deteriorating wx. The clouds were near the tops of the ridges & the acft was beneath the cloud layer in a slow flt configuration. The plt said that he tried to make a 180 deg turn, but the acft… - [NTSB FTW84FA326](https://openairdocs.org/ntsb/FTW84FA326.md): Beech S35 · Bedias, TX · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1984 · N5685K · Destroyed > The non instrument rated plt penetrated a severe thunderstorm in which turbulence was labeled as severe or greater. There was no pre or in-flt wx briefing. The aircraft broke up in-flt and was consumed by post crash fire. Investigation revealed evidence of… - [NTSB DEN84LA240](https://openairdocs.org/ntsb/DEN84LA240.md): Cessna 310Q · Havre, MT · Accident · No injuries · Limited investigation · Final report · Jul 27, 1984 · CGONG · Substantial damage > During cruise flight with five adults and two infants on board, the pilot noted left engine oil pressure decreasing and a visible oil leak. Engine shutdown and propeller feather were accomplished but altitude could not be maintained. A forced landing was… - [NTSB FTW84LA323](https://openairdocs.org/ntsb/FTW84LA323.md): Boeing A75N1 · Wichita Falls, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1984 · N49680 · Substantial damage > The acft lost thrust and started a descent at full power during climbout. A forced landing was made in a residential area. Examination of the acft indicated that the prop blades had twisted to low pitch. One blade was twisted 180 degreesat the scene. Torques… - [NTSB DEN84LA239](https://openairdocs.org/ntsb/DEN84LA239.md): Aerospatiale 316B · Naturita, CO · Accident · No injuries · Limited investigation · Final report · Jul 26, 1984 · N4246 · Substantial damage > One of the axial compressor blades separated resulting in internal engine damage and loss of engine power. Examination of the blades showed evidence of corrosion beyond acceptable limits. The engine was not equipped with an air filter or particle separator.… - [NTSB SEA84LA183](https://openairdocs.org/ntsb/SEA84LA183.md): Cessna 150J · Burley, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1984 · N50618 · Substantial damage > The acft made a forced landing in a potato field and nosed over after the engine lost power. The plt said she used carburetor heat when the engine started running rough. The engine did not immediately improve but was running in surges from 1800-2200 RPM. The… - [NTSB DEN84LA238](https://openairdocs.org/ntsb/DEN84LA238.md): Bellanca 8GCBC · Selz, ND · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N88176 · Substantial damage > The plt smelled and saw smoke from the engine which began to lose power. An emergency landing was made on a narrow dirt road. After stopping the plt egressed and ran. He said that about 2 minutes later the fuel tanks blew. Post accident examination indicated… - [NTSB CHI84IA314](https://openairdocs.org/ntsb/CHI84IA314.md): Boeing 727-2M7 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Jul 25, 1984 · N721RW · No damage > The crew reported that they noticed a decrease in climb rate while over rapid city, SD, en route from msp to sfo at flt level 310. The plt noted fuel burn was aprx 1400 lbs ahead of schedule. In-flt inspection revealed that the inboard trailing edge flaps had… - [NTSB ATL84LA235](https://openairdocs.org/ntsb/ATL84LA235.md): Douglas DC-9-31 · Augusta, GA · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1984 · N8978E · No damage > During a turbulence encounter a pax standing in the rear of the cabin fell and suffered a fractured leg. The seat belt sign was illuminated for the entire flt. At the direction of the capt, in-flt service by the flt attendants was terminated. The injured pax… - [NTSB MIA84LA229](https://openairdocs.org/ntsb/MIA84LA229.md): Mcdonnell Douglas DC-8-51 · Key West, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 1984 · XAPIK · No damage > The captain reported that the seat belt sign was left on for the entire flt from Mexico city to miami. Aprx 50 mi from Key West, the flt began a descent from FL370. While descending thru about 11,500 ft, the acft encountered severe turbulence. At that time,… - [NTSB NYC84LA250](https://openairdocs.org/ntsb/NYC84LA250.md): Piper PA-22-150 · E. Hanover, NJ · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N2475P · Substantial damage > The acft made a forced landing shortly after takeoff when the engine lost power. At about 400 ft AGL the engine sputtered and stopped. The fuel tanks were switched by the plt and the engine made a slight pwr gain and quit again. A landing was made in a marshy… - [NTSB MIA84FA206](https://openairdocs.org/ntsb/MIA84FA206.md): Beech A36 · Zolfo Springs, FL · Accident · 5 fatal · Field investigation · Final report · Jul 22, 1984 · N6265X · Destroyed > During the pre-flt wx briefing, the non-instrument rated plt was advised of numerous thunderstorms along his proposed route of flt & that VFR flt was not recommended. While en route, he contacted miami center, requested flt following & was instructed to… - [NTSB LAX84LA410](https://openairdocs.org/ntsb/LAX84LA410.md): Cessna 152 · Salida, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N5531H · Substantial damage > Failure of the number 3 exhaust push rod caused the power loss. The CFI took control of the acft and performed a forced ldg on a private airstrip. Due to a higher than optimum approach the acft landed long, overran the end of the rwy and collided wiht trees. - [NTSB DEN84FTM02](https://openairdocs.org/ntsb/DEN84FTM02.md): Amateur Built Thorp T-18 · Salt Lake City, UT · Accident · Minor injuries · Final report · Jul 22, 1984 · N18GY · Substantial damage > The plt was on a x-country to Salt Lake City. Approaching Salt lake he saw thunderstorms in the area. At this point he said he had 1/4 of a tank of gas so he diverted to ogden then tried for morgan where he was waved off by 3 people on therwy. Plt then… - [NTSB CHI84LA306](https://openairdocs.org/ntsb/CHI84LA306.md): Cessna 150M · Newark, OH · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N66789 · Substantial damage > The pilot stated that the engine failed due to fuel starvation. The fuel selector is an on-off type. Examination of the aircraft revealed that the fuel vent was partially blocked by mud dobbers. - [NTSB NYC84LA248](https://openairdocs.org/ntsb/NYC84LA248.md): Piper PA-28-140 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N15963 · Substantial damage > The acft made a forced landing after the engine vibrated and lost power. The plt said that the fuel gages were checked and indicated 1/4 full. The plt said he switched fuel tanks but the engine did not improve its performance. The plt thenaccomplished the… - [NTSB MKC84LA224](https://openairdocs.org/ntsb/MKC84LA224.md): Cessna 150 · Kearney, NE · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N3635J · Substantial damage > Acft nosed over in a corn fld during a forced landing following a loss of pwr. No fuel was found on board the acft. Plt made one stop en route for fuel but was unable to obtain any services as the arpt was unattended. - [NTSB LAX84FA407](https://openairdocs.org/ntsb/LAX84FA407.md): Piper PA-32-300 · Goleta, CA · Accident · 3 fatal · Field investigation · Final report · Jul 21, 1984 · N8632N · Destroyed > The plt radioed to the santa barbara tower that he was 'without power' & was going to attempt to land in an open field. However, during the forced landing, the acft collided with trees aprx 50 ft short of the field. An exam of the eng revealed that the fuel… - [NTSB ANC84FA119](https://openairdocs.org/ntsb/ANC84FA119.md): Grumman G-21A · Ouzinkie, AK · Accident · 4 fatal · Field investigation · Final report · Jul 21, 1984 · N2021A · Destroyed > N2021A departed kodiak, AK, at 0904 AKDT under a special VFR clearance. Two other plts stated N2021A was then circling over monashka bay while waiting for the wx over the narrow strait to clear. At 0920 AKDT the plt of N2021A stated to one of the other plts… - [NTSB MKC84LA226](https://openairdocs.org/ntsb/MKC84LA226.md): Grumman G-164A · Steele, MO · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N48583 · Substantial damage > The pilot stated that after takeoff, at an altitude of 50 ft AGL he reduced the engine power. Shortly thereafter, the acft stalled and touched down on the rwy. He stated he applied excessive brake pressure to stop the acft and it nosed over on the rwy. - [NTSB LAX84LA406](https://openairdocs.org/ntsb/LAX84LA406.md): Cessna 172N · Wikieup, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1984 · N5001E · Substantial damage > The acft was serviced with a full load of fuel before the plt took off. About 1 hr after takeoff, the eng lost power as the throttle was advanced to climb over a mtn ridge. Subsequently, the acft was damaged during an emergency landing on rough terrain. No… - [NTSB DEN84LA228](https://openairdocs.org/ntsb/DEN84LA228.md): Piper PA-18-150 · Meeteetse, WY · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N6083A · Substantial damage > Plt reported flt was being conducted in mountainous terrain with fog patches in the area. Conditions conducive to carb ice existed. Calculated temp at flight altitude of 9000 ft MSL: 62 degs. Plt's estimate of temp: 50 degs. Closest reported dew pt: 57 degs.… - [NTSB DEN84LA221](https://openairdocs.org/ntsb/DEN84LA221.md): Piper 28RT-201T · Glendo, WY · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1984 · N8168Q · Substantial damage > The acft was damaged in a forced landing in a wooded area after the engine failed. The plt said that he was cruising at 7500 ft MSL when without warning the engine began making noises and then lost oil pressure. After the landing the enginewas examined at the… - [NTSB CHI84FA303](https://openairdocs.org/ntsb/CHI84FA303.md): Cessna 421 · Birchwood, WI · Accident · 3 fatal · Field investigation · Final report · Jul 20, 1984 · N14TC · Destroyed > During flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of… - [NTSB MIA84LA208](https://openairdocs.org/ntsb/MIA84LA208.md): Cessna 172N · Ocean Cay (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 1984 · N738PQ · Destroyed > Acft was ditched in the atlantic Ocean after power loss occurred. The wreckage was not recovered. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=352 ## 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=351 --- 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.