# 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 360 of 718 · 35,889 cases ## Cases, newest first - [NTSB ATL84LA070](https://openairdocs.org/ntsb/ATL84LA070.md): Piper PA-28-181 · Waverly, KY · Accident · No injuries · Limited investigation · Final report · Dec 21, 1983 · N2767M · Substantial damage > About 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his… - [NTSB MKC84LA042](https://openairdocs.org/ntsb/MKC84LA042.md): Piper PA-32-260 · Schuyler, NE · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N43302 · Substantial damage > While descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was… - [NTSB MKC84LA041](https://openairdocs.org/ntsb/MKC84LA041.md): Cessna 310 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N809AA · Substantial damage > The plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the… - [NTSB CHI84LA072](https://openairdocs.org/ntsb/CHI84LA072.md): Beech BE-77 · Covington, IN · Accident · No injuries · Limited investigation · Final report · Dec 20, 1983 · N3706W · Substantial damage > The acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained… - [NTSB SEA84LA027](https://openairdocs.org/ntsb/SEA84LA027.md): Cessna 150F · Prosser, WA · Accident · No injuries · Limited investigation · Final report · Dec 17, 1983 · N6841F · Substantial damage > According to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control… - [NTSB CHI84FA063](https://openairdocs.org/ntsb/CHI84FA063.md): Cessna 150M · Stockwell, IN · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1983 · N63398 · Destroyed > The plt had been wx briefed & filed a flight plan at the lafayette fss. About 1 hr later he returned to the fss & asked if the fss had heard him calling on 119.6. He was advised that he had not been heard. The plt stated he would try to call when airborne. On… - [NTSB MKC84LA038](https://openairdocs.org/ntsb/MKC84LA038.md): Piper PA-32-260 · Sikeston, MO · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N321HF · Substantial damage > The acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed… - [NTSB FTW84LA099](https://openairdocs.org/ntsb/FTW84LA099.md): Hiller UH-12C · Imperial, TX · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N63MC · Substantial damage > The plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by… - [NTSB ANC84LA025](https://openairdocs.org/ntsb/ANC84LA025.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Dec 16, 1983 · N2894Z · Substantial damage > The plt reported that during flt, he encountered freezing rain. Although he applied carburetor heat, the eng ceased operating. During a forced landing, the right main gear collapsed & the right outboard wing panel was damaged. The plt reported that freezing… - [NTSB MKC84LA037](https://openairdocs.org/ntsb/MKC84LA037.md): Piper PA-32-300 · Garnett, KS · Accident · No injuries · Limited investigation · Final report · Dec 15, 1983 · N4026R · Substantial damage > While enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.… - [NTSB DEN84FA225](https://openairdocs.org/ntsb/DEN84FA225.md): Piper PA-32 · Alma, CO · Accident · 3 fatal · Field investigation · Final report · Dec 14, 1983 · N47403 · Destroyed > The plt, his brother & his sister-in-law were on a flt to attend his mother's funeral. Before taking off, the pilot received a wx briefing & was advised that VFR flt was not recommended. The plt then asked for wx reports for a southerly route & he was advised… - [NTSB FTW84LA097](https://openairdocs.org/ntsb/FTW84LA097.md): Beech A-36 · Harrison, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1983 · N2149L · Substantial damage > The acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the… - [NTSB ATL84FA064](https://openairdocs.org/ntsb/ATL84FA064.md): Piper PA-24-260B · Mcdonald, TN · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1983 · N8981P · Destroyed > The plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both… - [NTSB ANC84LA023](https://openairdocs.org/ntsb/ANC84LA023.md): Piper PA-32R-301 · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Dec 12, 1983 · N3575A · Substantial damage > The plt stated that shortly after reaching cruise altitude the eng failed. A forced landing was made on tundra covered by encrusted snow & ice nad the gear collapsed. During the on-scene investigation the fuel injector was found to allow only a small amount… - [NTSB NYC84LA050](https://openairdocs.org/ntsb/NYC84LA050.md): Bellanca 7GCBC Citabria · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N5041N · Substantial damage > The acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied… - [NTSB MIA84FA042](https://openairdocs.org/ntsb/MIA84FA042.md): Piper PA-22 · Port Richie, FL · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1983 · N3719 · Destroyed > The acft crashed into trees during a night forced landing after the engine quit. The surviving passenger said he had metthe two plts in a bar where they drank beer. They later went to the arpt and flew x-country about 70 miles to eat & have more beer. They… - [NTSB FTW84LA092](https://openairdocs.org/ntsb/FTW84LA092.md): Cessna 175 · Washington, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 10, 1983 · N7666M · Destroyed > About 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the… - [NTSB FTW84LA091](https://openairdocs.org/ntsb/FTW84LA091.md): Cessna 152 · Winslow, AR · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 1983 · N67863 · Destroyed > During a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had… - [NTSB CHI84FA058](https://openairdocs.org/ntsb/CHI84FA058.md): Cessna 207 · Put-In-Bay, OH · Accident · 4 fatal · Field investigation · Final report · Dec 10, 1983 · N208JP · Substantial damage > The plt & 3 passengers took off at night on an over water flt to an island in lake erie to provide help to a heart patient. No flt plan was filed & no record of a wx briefing was found. Reportedly, after takeoff, the acft disappeared in a cloud or haze. Also… - [NTSB SEA84FA101](https://openairdocs.org/ntsb/SEA84FA101.md): Cessna T210M · East Sound, WA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1983 · N761PW · Destroyed > The acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in… - [NTSB LAX84FA096](https://openairdocs.org/ntsb/LAX84FA096.md): Piper PA-28-161 · Danville, CA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1983 · N2862C · Destroyed > The acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly… - [NTSB CHI84LA055](https://openairdocs.org/ntsb/CHI84LA055.md): Cessna 310L · West Lafayette, IN · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 1983 · N2222F · Substantial damage > The plt was unable to start the eng with the batteries & made a start by using an APU. About 10 min after taking off, he noticed an off flag on the HSI. A further check was made & he discovered the left alternator was not functioning. He then checked the… - [NTSB MKC84FA034](https://openairdocs.org/ntsb/MKC84FA034.md): Cessna 21ON · Wentzville, MO · Accident · Serious injuries · Field investigation · Final report · Dec 6, 1983 · N5209C · Substantial damage > The acft was landed with the landing gear partially extended during a forced landing after an engine failure. The plt delayed the extension of the gear because of the condition of the landing area. Examination of the engine showed a failure of the #2… - [NTSB NYC84LA045](https://openairdocs.org/ntsb/NYC84LA045.md): Maule M-5 · Somersworth, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1983 · N62042 · Substantial damage > The acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and… - [NTSB FTW84FA084](https://openairdocs.org/ntsb/FTW84FA084.md): Piper PA-22-108 · Pawnee, OK · Accident · 2 fatal · Field investigation · Final report · Dec 4, 1983 · N4579Z · Destroyed > The acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft… - [NTSB CHI84FA054](https://openairdocs.org/ntsb/CHI84FA054.md): Beech 77 · Sidney, OH · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1983 · N37253 · Destroyed > The aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported… - [NTSB LAX84LA092](https://openairdocs.org/ntsb/LAX84LA092.md): Schweizer I-26D · Black Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N7740S · Substantial damage > The glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft… - [NTSB FTW84FA083](https://openairdocs.org/ntsb/FTW84FA083.md): Bellanca 17-30A · Hebbronville, TX · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1983 · N4097B · Destroyed > The flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised… - [NTSB DEN84FA038](https://openairdocs.org/ntsb/DEN84FA038.md): Bell 206B · Ft. Morgan, CO · Accident · Serious injuries · Field investigation · Final report · Dec 3, 1983 · N1078V · Substantial damage > The helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the… - [NTSB LAX84FA087](https://openairdocs.org/ntsb/LAX84FA087.md): Piper PA-32-260 · Holtville, CA · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1983 · N3206W · Destroyed > The plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time… - [NTSB FTW84LA081](https://openairdocs.org/ntsb/FTW84LA081.md): Bell 206L-1 · Ardmore, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1983 · N2005A · Substantial damage > The plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying… - [NTSB DEN84LA036](https://openairdocs.org/ntsb/DEN84LA036.md): Bell 205A-1 · Cokeville, WY · Accident · No injuries · Limited investigation · Final report · Dec 2, 1983 · N1084N · Substantial damage > The plt reported that snow had been falling regularily for the previous few days before the flt. He departed the staging area with 12 drill crew members. At that time, the visibility was 2 to 3 mi & a ceiling of 800 to 1000 ft. the plt flew 9 of the… - [NTSB DEN84FA031](https://openairdocs.org/ntsb/DEN84FA031.md): Champion 7GC · Douglas, WY · Accident · 1 fatal · Field investigation · Final report · Nov 29, 1983 · N7697E · Destroyed > The plt took off on an aerial observation flt to spot cattle in a mountainous area. When he failed to return, a search was initiated. The plane was found in a valley between 2 mountain ranges. An investigation revealed that the acft had crashed while in a… - [NTSB MIA84FA036](https://openairdocs.org/ntsb/MIA84FA036.md): Piper PA-24-260 · Kathleen, FL · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1983 · N9094P · Destroyed > The acft impacted in a swampy area in a fast dive which separated about 6 ft of the left wing. The acft was being vectored on radar when it suddenly began to steer erratically and go off the radar scope. The plt had radioed that he 'must have gone over some… - [NTSB NYC84FA038](https://openairdocs.org/ntsb/NYC84FA038.md): Cessna 172P · Silver Greek, NY · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1983 · N96268 · 2 aircraft · Destroyed > The two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft… - [NTSB FTW84FA077](https://openairdocs.org/ntsb/FTW84FA077.md): Cessna 172L · Simpson, LA · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1983 · N2899G · Destroyed > The acft collided with the ground in a steep nose down altitude at a high rate of speed after the plt encounterd low ceiling and rain during a x-country flt. In attempting to fly IFR and follow radar vectors the non-instrument rated plt lost countrol of his… - [NTSB FTW83LA078](https://openairdocs.org/ntsb/FTW83LA078.md): Bell 206L-1 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Nov 27, 1983 · N2070Z · Substantial damage > After transporting a patient & 2 crewmembers, the plt took off from a medical center helipad to obtain fuel at a nearby arpt. Shortly after departing, a partial loss of power was encountered. The plt started to land on a road, but saw a car & turned to avoid… - [NTSB ATL84FA054](https://openairdocs.org/ntsb/ATL84FA054.md): Piper PA-28-180 · Lexington, TN · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1983 · N5396L · Destroyed > The acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who… - [NTSB LAX84LA082](https://openairdocs.org/ntsb/LAX84LA082.md): Beech BE-35 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N200CF · Substantial damage > The acft collided with a sign during a forced landing on a street. There was some damage to the right wing. The plt stated that he thought he had ample fuel for the flt. He also stated that the fueling facility was closed at the arpt at time of his departure.… - [NTSB ATL84LA051](https://openairdocs.org/ntsb/ATL84LA051.md): Cessna 172P · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N64791 · Substantial damage > The acft ditched in a reservoir at night after a power loss. The plt was descending to land, in preparation for the landing the plt switched fuel tanks on the selector valve to what he thought was both tanks position. Shortly after thisthe engine quit. The… - [NTSB NYC84FA037](https://openairdocs.org/ntsb/NYC84FA037.md): Beech H18 · Allentown, PA · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1983 · N105PE · Destroyed > While en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;… - [NTSB LAX84LA072](https://openairdocs.org/ntsb/LAX84LA072.md): Bensen B8M · Rocklin, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · UNREG · Substantial damage > The plt was operating his home built, non-registered gyrocopter as an ultralight vehicle. Reportedly, the eng lost power during flt, and subsequently, the gyrocopter was damaged during a forced landing. According to the plt, he encountered carburetor icing… - [NTSB LAX84FA073](https://openairdocs.org/ntsb/LAX84FA073.md): Beech J-35 · Ontario, CA · Accident · Minor injuries · Field investigation · Final report · Nov 25, 1983 · N8337D · Destroyed > The acft forced landed in a vineyard where the nose gear dug in and the acft nosed over. The flt stated that climbing through 5000 ft MSL the power went to idle and then to zero. All fuel tanks were filled prior to departure & the left main tank was selected… - [NTSB LAX84FA071](https://openairdocs.org/ntsb/LAX84FA071.md): Piper PA-24-250 · Oceanside, CA · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1983 · N6295T · Destroyed > Before takeoff, the plt received a wx briefing & was advised to expect IFR conditions in the vicinity of Oceanside, CA & that moderate turbulence existed below 20,000 ft. after takeoff, he obtained an IFR clearance to climb & cruise at 6000 ft. at about 2005… - [NTSB DCA84AA008](https://openairdocs.org/ntsb/DCA84AA008.md): Lockheed L-1011 · Charleston, SC · Accident · Serious injuries · Final report · Nov 25, 1983 · CFTNJ · Minor damage > During flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of… - [NTSB CHI84LA050](https://openairdocs.org/ntsb/CHI84LA050.md): Piper PA-28R-200 · Zanesville, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1983 · N41873 · Substantial damage > After departing Zanesville, OH, the acft was at 2500 ft MSL when the eng began to 'knock'. The cockpit filed with smoke & the eng began to lose oil. The plt turned back to land at the arpt. He reported that the eng continued to run until the acft was about… - [NTSB ATL84FA058](https://openairdocs.org/ntsb/ATL84FA058.md): Cessna 414A · Waynesville, NC · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1983 · N6623C · Destroyed > After departure at 1417 CST, radar track showed the acft climbing to & maintaining 7,600 ft until about 1733 EST & 28-30 mi north of the knoxville VOR. The acft then descended & crossed the snowbird VOR at about 6,700 ft. there were several up & down altitude… - [NTSB NYC84LA036](https://openairdocs.org/ntsb/NYC84LA036.md): Cessna 172 · Ft. Plain, NY · Accident · No injuries · Limited investigation · Final report · Nov 22, 1983 · N734YA · Substantial damage > The flt departed bedford, ma at about 1300. Upon arriving in the area of the destination arpt, the plt had difficulty inlocating the arpt. After seeing what he thought was a wind sock, he landed in a farmer's field. He was told that this was the original… - [NTSB FTW84MA069](https://openairdocs.org/ntsb/FTW84MA069.md): Cessna 210N · El Paso, TX · Accident · 4 fatal · Major investigation · Final report · Nov 22, 1983 · N4742P · Destroyed > N4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The… - [NTSB FTW84FA068](https://openairdocs.org/ntsb/FTW84FA068.md): Mooney M20J · El Paso, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1983 · N201TH · Destroyed > The acft collided with the ground at 4380 ft MSL. The plt had called the control tower in El Paso and advised that he was at 8500 ft and would have to start descending due to weather in the area. The plt was VFR and no flt plan had been filed. He was advised… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=361 ## 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=360 --- 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.