# 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 309 of 718 · 35,885 cases ## Cases, newest first - [NTSB ATL87FA234](https://openairdocs.org/ntsb/ATL87FA234.md): Piper PA-28-140 · Aurora, NC · Accident · 1 fatal · Field investigation · Final report · Aug 19, 1987 · N5561U · Destroyed > The pilot ditched the aircraft after running out of fuel while en route to bayboro,NC. The flight had departed earlier in the day and had flown to melfa,VA. The pilot did not fuel the aircraft before starting the flight and over flew several possible… - [NTSB MKC87FA163](https://openairdocs.org/ntsb/MKC87FA163.md): Beech 35 · Excelsior Spgs, MO · Accident · Serious injuries · Field investigation · Final report · Aug 18, 1987 · N3204V · Destroyed > According to witnesses, the pilot declared an emergency over the radio stating that the eng was losing power and that she was attempting an emerg lndg at Excelsior springs arpt. The pilot stated that she initiated a go-around, after the rwy was assured, due… - [NTSB DEN87LA221](https://openairdocs.org/ntsb/DEN87LA221.md): Piper PA-28R-180 · Steamboat Sprin, CO · Accident · No injuries · Limited investigation · Final report · Aug 17, 1987 · N7494J · Destroyed > N7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He… - [NTSB DEN87FA219](https://openairdocs.org/ntsb/DEN87FA219.md): Cessna 182P · Milner, CO · Accident · 3 fatal · Field investigation · Final report · Aug 17, 1987 · N1359S · Destroyed > The plt was on a flt fm green bay, WI to steamboat spgs (sbs), CO, with stops at sioux city & cheyenne (cys). At 2245, he contacted denver fss, stated he was on final apch to sbs & said the rwy lgts had gone out. He then asked for the freqfor 'putting them… - [NTSB BFO87LA055](https://openairdocs.org/ntsb/BFO87LA055.md): Cessna 150L · Danville, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1987 · N11872 · Substantial damage > The accident occurred during an instructional x-country flt from chesapeake, VA. To south boston, VA. To ashland, VA. With a return to chesapeake. Prior to departure, the student plt performed the acft preflt and informed the CFI that the acft was topped off.… - [NTSB SEA87FA165](https://openairdocs.org/ntsb/SEA87FA165.md): Fleet 16B · Bellevue, WA · Accident · 1 fatal · Field investigation · Final report · Aug 16, 1987 · N41871 · Destroyed > The pilot executed an emergency landing on a golf course after a power loss which he attributed to carburetor ice. Subsequent to the landing the aircraft was fueled with 10 gallons of automotive gasoline. The fuel was checked for water at the strainer drain… - [NTSB NYC87LA235](https://openairdocs.org/ntsb/NYC87LA235.md): Piper PA-28-151 · Lakewood, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 1987 · N41994 · Destroyed > While returning to the arpt aft flying for abt 30 mins, the eng lost pwr. The plt attempted to restart the eng by checking the fuel tank gauges, carb heat, mags, etc but with no success. During the forced lndg, the acft was stalled into trees. No fuel was… - [NTSB MKC87LA162](https://openairdocs.org/ntsb/MKC87LA162.md): Maxfield Pitts S-1S · Meade, KS · Accident · No injuries · Limited investigation · Final report · Aug 16, 1987 · N900K · Substantial damage > Shortly after takeoff, while depg to the se, the eng seized. All of the surrounding terrain consisted of plowed fields, so the plt tried to glide back to the arpt; however, he had insufficient speed & alt to get aligned with the rwy. Drg the lndg, the acft… - [NTSB LAX87LA301](https://openairdocs.org/ntsb/LAX87LA301.md): Cessna 152 · Madera, CA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1987 · N65451 · Substantial damage > After the aircraft was flown for 3 hours and 30 minutes the engine failed. The aircraft entered a forced landing approach to an open field. The aircraft landed hard and nosed over onto its back. Ground witnesses who were on scene shortly after the accident… - [NTSB DEN87LA217](https://openairdocs.org/ntsb/DEN87LA217.md): Rockwell 200D · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Aug 14, 1987 · N2909T · Substantial damage > The pilot stated that he was on a ferry flight to Ogden, UT and experienced smoke in the cockpit shortly after deprt. The pilot executed a straight in visual approach to runway 34 and before he was able to stop the aircraft a fire erupted. The aircraft was… - [NTSB ATL87LA233](https://openairdocs.org/ntsb/ATL87LA233.md): Cessna 150H · Lumberton, NC · Accident · No injuries · Limited investigation · Final report · Aug 14, 1987 · N23193 · Substantial damage > The eng lost power and the plt attempted an off arpt landing. The acft nosed over during the landing roll. Records indicated that the acft had been refueled two days prior to the accident. Since that time it had been flown three and one tenth hours prior to… - [NTSB BFO87LA054](https://openairdocs.org/ntsb/BFO87LA054.md): Mooney M20C · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · Aug 13, 1987 · N6801U · Substantial damage > The plt refueled the acft at princeton, NJ, bfr departing on a flt to linden, NJ, then continued on to laurel, MD. He believed that he had positioned the fuel selector to the rgt fuel tank & said that he had used fuel out of the same tank until he arrived at… - [NTSB ANC87LA121](https://openairdocs.org/ntsb/ANC87LA121.md): Cessna 170 · Mi.70 Glenn Hwy, AK · Accident · No injuries · Limited investigation · Final report · Aug 13, 1987 · N4091V · Substantial damage > The pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the… - [NTSB SEA87FA162](https://openairdocs.org/ntsb/SEA87FA162.md): Hughes 369D · Ketchikan, AK · Accident · 2 fatal · Field investigation · Final report · Aug 12, 1987 · N58318 · 2 aircraft · Destroyed > N58318 (Hughes 369, under contract with us geological survey) was inbnd fm se to lnd at Ketchikan-temsco heliport (6Z4) as N73WS (Cessna 185 amphibian) was depg se fm Ketchikan intl arpt (ktn). Ktn & 6Z4 were located in tongass narrows withmtns NE & sw. Rprtd… - [NTSB LAX87LA289](https://openairdocs.org/ntsb/LAX87LA289.md): Cessna 170A · Independence, CA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1987 · N9039A · Substantial damage > During a cross country flight, the plt stated that en route the engine suddenly lost partial power. The plt made a 180 degree turn to try an emergency landing at a nearby airport, however, the plt realized that he would be short of the rwy. The plt landed the… - [NTSB LAX87IA304](https://openairdocs.org/ntsb/LAX87IA304.md): Boeing 737 · Santa Monica, CA · Incident · No injuries · Incident investigation · Final report · Aug 12, 1987 · N754UA · No damage > The plts of a Boeing 737 reported that a near-collision occurred aprx 2.5 miles east of the Santa Monica VOR while they were descending through an altitude of about 7400 ft MSL. The coplt saw the other acft first & took immediate evasive action. He estimated… - [NTSB FTW87FA198](https://openairdocs.org/ntsb/FTW87FA198.md): Bell 206B · Pledger, TX · Accident · No injuries · Field investigation · Final report · Aug 12, 1987 · N33PW · Substantial damage > While cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main… - [NTSB FTW87FA197](https://openairdocs.org/ntsb/FTW87FA197.md): Piper PA-32R · Mexia, TX · Accident · No injuries · Field investigation · Final report · Aug 12, 1987 · N8159S · Substantial damage > The plt noticed smoke in the cockpit & started to make a precautionary lndg at Mexia, TX, which was nearby. However, drg the dscnt to lnd, the smoke dissipated, so he elected to cont to the destn. Drg the climb back to alt, smoke reappeared & was followed by… - [NTSB NYC87LA224](https://openairdocs.org/ntsb/NYC87LA224.md): Ercoupe 415-C · York, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1987 · N99236 · Substantial damage > The Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the… - [NTSB FTW87LA191](https://openairdocs.org/ntsb/FTW87LA191.md): Cessna 150K · Mansfield, TX · Accident · No injuries · Limited investigation · Final report · Aug 9, 1987 · N6287G · Substantial damage > The student pilot experienced fuel exhaustion and made a forced landing a few miles short of his planned destination. His preflight trip planning, which was approved by his flight instructor, if followed correctly would have been adequate for successful… - [NTSB MKC87LA160](https://openairdocs.org/ntsb/MKC87LA160.md): North American Navion · Chillicothe, MO · Accident · No injuries · Limited investigation · Final report · Aug 8, 1987 · N8569H · Substantial damage > The PIC was ferrying the navion to a distant location to undergo an annual insp. Abt 20 min into the flt, the PIC rptd experiencing eng pblms. The PIC was able to fly to a nearby arpt for a precautionary lndg. Instead of making the lndg the PIC went around to… - [NTSB LAX87FA298](https://openairdocs.org/ntsb/LAX87FA298.md): Cessna 150M · Newport Beach, CA · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1987 · N704PG · Substantial damage > On a dark night beneath a scattered to broken marine layer of stratus clouds the plt made a low altitude pleasure flight 1/4 mi off shore. The acft entered a gradual descent, collided with the ocean and the plt drowned. - [NTSB DEN87FA213](https://openairdocs.org/ntsb/DEN87FA213.md): Piper PA28-140 · Last Chance, CO · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1987 · N5994U · Destroyed > While on a cross country flt the plt encountered IFR conditions and was neither trained nor qualified to fly IFR. Attempts by ATC to assist the plt and route the flt to an arpt were unsuccessful. The plt lost control of the acft and crashed in a field, the… - [NTSB CHI87IA188](https://openairdocs.org/ntsb/CHI87IA188.md): Boeing 727-233 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 8, 1987 · CGYNE · 2 aircraft · No damage > Air Canada flt 839 (Boeing 727, c-gyne) was depg Chicago o'hare intl arpt as Cessna 650 (citation), N20AT, was depg palwaukee (pwk) arpt, about 8 mi north of o'hare. Both flts tkof with IFR flt plans. Bfr the citation tkof, the pwk twr ctlr ctcd the TRACON… - [NTSB NYC87LA219](https://openairdocs.org/ntsb/NYC87LA219.md): Mooney M20C · Mclean, NY · Accident · No injuries · Limited investigation · Final report · Aug 7, 1987 · N3457X · Substantial damage > The aircraft had flown for about 1-1/2 hours when the pilot began a descent from 12000 feet for an approach. However at 3500 feet, the engine suddenly went from normal cruise to idle. An emergency landing was made in a corn field and the aircraft was… - [NTSB FTW87FA190](https://openairdocs.org/ntsb/FTW87FA190.md): Cessna 206G · Georgetown, TX · Accident · No injuries · Field investigation · Final report · Aug 7, 1987 · N8873Q · Substantial damage > Teardown of the aircraft engine revealed that the engine counterweight vibration damper assembly was out of tolerance. This allowed excessive engine vibration which resulted in failure of the camshaft drive gear and total engine failure. The pilot executed a… - [NTSB ATL87LA228](https://openairdocs.org/ntsb/ATL87LA228.md): Cessna 152 · New Albany, OH · Accident · No injuries · Limited investigation · Final report · Aug 7, 1987 · N6341B · Substantial damage > The airplane nosed over during a forced ldg in a soft field. The CFI reported that he had initiated a simulated engine power loss at about 2200 ft AGL by either pulling the mixture control or by turning off the fuel selector; he could not recall specifically… - [NTSB SEA87FA158](https://openairdocs.org/ntsb/SEA87FA158.md): Cessna 150J · Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1987 · N51358 · Destroyed > The student plt planned a x-country flt for 3.6 hrs. After 3.9 hrs of flt, fuel exhaustion occurred as the acft was apchg the destn arpt. The plt declared an emergency, but was unable to glide to the arpt. Witnesses observed the acft on an apch to a vacant… - [NTSB CHI87LA189](https://openairdocs.org/ntsb/CHI87LA189.md): Aeronca 15AC · St Bonifacius, MN · Accident · No injuries · Limited investigation · Final report · Aug 6, 1987 · N1135H · Substantial damage > The plt had just purchased the acft & had obtained a ferry permit to fly it to another arpt. He reached the vicinity of the destn & called the tower, but did not see the arpt. Aprx 15 min later, when he was sure he had passed the arpt, he made a 180 deg turn… - [NTSB CHI87FA187](https://openairdocs.org/ntsb/CHI87FA187.md): Piper PA-28 · Fairwater, WI · Accident · No injuries · Field investigation · Final report · Aug 6, 1987 · N6793J · Substantial damage > When the plt attempted to add pwr to level off from a dscnt, the eng did not respond. He then applied carb heat & tried to restart the eng, but to no avail. During an emerg landing, the acft touched down with a tailwind, struck a fence & skidded to a stop in… - [NTSB LAX87LA294](https://openairdocs.org/ntsb/LAX87LA294.md): Bell 47D-1 · Taft, CA · Accident · No injuries · Limited investigation · Final report · Aug 5, 1987 · N917B · Substantial damage > The plt rprtd the eng lost power at about 300' AGL after the helicopter had flown aprx 2.7 hrs without refueling. He initiated an autorotative landing; however, before touchdown, the main rotor blades contacted & severed the tail boom. An exam revealed the… - [NTSB LAX87DUG06](https://openairdocs.org/ntsb/LAX87DUG06.md): Curtiss JN-4 · Riverside, CA · Accident · Minor injuries · Final report · Aug 5, 1987 · N3712 · Substantial damage > During a business flight, the engine experienced a loss of engine power. The pilot made a forced landing in an open area where during the touchdown, the aircraft was substantially damaged. The plt stalled the acft while still several ft off the ground. The… - [NTSB SEA87LA154](https://openairdocs.org/ntsb/SEA87LA154.md): Cessna 150M · Austin, NV · Accident · No injuries · Limited investigation · Final report · Aug 4, 1987 · N8771U · Destroyed > The plt was flying up a canyon when he realized the canyon was closing & he had no way of turning around. He was unable to outclimb rising terrain. Subsequently, the acft crashed into several small pine trees & was extensively damaged. The density alt at the… - [NTSB LAX87FA291](https://openairdocs.org/ntsb/LAX87FA291.md): Navion A · Hawthorne, CA · Accident · Minor injuries · Field investigation · Final report · Aug 4, 1987 · N4388K · Substantial damage > During a pleasure cross country flt, the eng sputtered then regained full pwr. The plt turned toward a nearby arpt and was cleared to land. En route to the arpt the engine lost full power. When the pilot thought he could make the rwy he extended the landing… - [NTSB LAX87FA290](https://openairdocs.org/ntsb/LAX87FA290.md): de Havilland DHC-6 · Palmdale, CA · Accident · No injuries · Field investigation · Final report · Aug 4, 1987 · N931MA · 2 aircraft · Substantial damage > A Dehavilland DHC-6, N931MA, operating as transworld express flt 7591 (twe 7591) & a Cessna 172N, N737EV, collided abt 10 miles west/southwest of Palmdale, CA at abt 5500 ft MSL. Twe 7591 was descending on a 355 deg mag heading; N737EV was level and was… - [NTSB MKC87LA154](https://openairdocs.org/ntsb/MKC87LA154.md): Piper PA-32RT · Oelwein, IA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1987 · N36646 · Substantial damage > During a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a… - [NTSB DEN87LA206](https://openairdocs.org/ntsb/DEN87LA206.md): Bell 206B · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 3, 1987 · N5001Q · Substantial damage > During cruise flt a partial power failure occurred requiring a full emerg autorotative landing to be conducted to an uneven dirt area. Following touchdown the acft slid forward and the tail rose causing the main rotor to contact the tail boom severing the… - [NTSB NYC87LA217](https://openairdocs.org/ntsb/NYC87LA217.md): Robinson R22 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Aug 2, 1987 · N9078Z · Destroyed > Before flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost… - [NTSB CHI87DEV03](https://openairdocs.org/ntsb/CHI87DEV03.md): Piper PA-22 · Roanoke, IL · Accident · No injuries · Final report · Aug 2, 1987 · N7958A · Substantial damage > After developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was… - [NTSB NYC87FA215](https://openairdocs.org/ntsb/NYC87FA215.md): Cessna 182Q · Sparta, NJ · Accident · 4 fatal · Field investigation · Final report · Aug 1, 1987 · N735DS · Destroyed > The acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was… - [NTSB FTW87FA183](https://openairdocs.org/ntsb/FTW87FA183.md): Piper PA-24-250 · Kokomo, IN · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1987 · N7841P · Destroyed > The plts preflt wx briefing revealed marginal VFR & IFR wx along his proposed route, with a precaution for thunderstorms. An IFR flt plan was filed and the acft departed. Later during flt the plt was radioed info about a convective SIGMET that contained a… - [NTSB MKC87LA152](https://openairdocs.org/ntsb/MKC87LA152.md): Aero Commander Callair A9-B · Osgood, MO · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N7726V · Substantial damage > During an aerial application operation, pilot experienced partial power loss and vibration, followed by a loud explosive sound and total loss of power. An emergency ldg was made followed by a nose over. Postaccident inspection revealed the entire propeller… - [NTSB MKC87LA150](https://openairdocs.org/ntsb/MKC87LA150.md): Piper PA-25-235 · Columbus, NE · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N7532Z · Substantial damage > The PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a… - [NTSB FTW87LA185](https://openairdocs.org/ntsb/FTW87LA185.md): Cessna 150M · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N150RG · Destroyed > The acft impacted the terrain near the Sallisaw, Oklahoma airport. Visual meteorological conditions prevailed at the time of the accident. The pilot stated that the engine quit and he attempted a forced landing to a field. However, the pilot stated that the… - [NTSB ATL87DKG05](https://openairdocs.org/ntsb/ATL87DKG05.md): Schweizer G-164A · Summerdale, AL · Accident · No injuries · Final report · Jul 30, 1987 · N8881H · Substantial damage > The pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine… - [NTSB MIA87LA216](https://openairdocs.org/ntsb/MIA87LA216.md): Piper PA-23-160 · St Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Jul 29, 1987 · N22GM · Substantial damage > After climbing abv 3000' drg an instrnl flt, the instructor (CFI) had the student lower the gear & flaps to a takeoff configuration & slow the acft below VMC (72 KTS). The CFI then shut off fuel to the left eng. The student followed the correct procedures to… - [NTSB NYC87LA220](https://openairdocs.org/ntsb/NYC87LA220.md): Aerospatiale AS350D · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1987 · N350AP · Substantial damage > The flight was enroute from Nantucket to hyannis when the pilot heard a loud bang followed by a severe vibration, loss of power to the main rotor system, and a loss of hydraulic pressure. The helicopter made an autorotative landing in water about 25 feet in… - [NTSB NYC87DNE04](https://openairdocs.org/ntsb/NYC87DNE04.md): Piper PA-28-180 · Groton, CT · Accident · 1 fatal · Final report · Jul 27, 1987 · N9558J · Substantial damage > Shortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly… - [NTSB MKC87FA148](https://openairdocs.org/ntsb/MKC87FA148.md): Watts 532 Elite · Davenport, IA · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1987 · N5352 · Substantial damage > Witnesses located 1/4 mi north of the accident site, observed the gyrocopter departing the Davenport, IA airport and turning to the southwest. While in cruise flight the witnesses observed the aircraft moving in an up and down motion prior to what appeared to… - [NTSB FTW87FA179](https://openairdocs.org/ntsb/FTW87FA179.md): Stinson 108-3 · Kirbyville, TX · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1987 · N744C · Destroyed > The pilot approached the Kirbyville airport in preparation for landing, witnesses stated that smoke was observed coming from the engine area. The aircraft impacted 30 foot pine trees, & control was lost. The aircraft struck a large tree approximately 5 feet… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=310 ## 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=309 --- 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.