# 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 314 of 718 · 35,885 cases ## Cases, newest first - [NTSB DEN87LA084](https://openairdocs.org/ntsb/DEN87LA084.md): Air Tractor AT-301 · Conrad, MT · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N23069 · Substantial damage > An ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original… - [NTSB MIA87LA126](https://openairdocs.org/ntsb/MIA87LA126.md): Piper PA-31-350 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N506ES · Substantial damage > During climb to cruise the pilot lost one blade of the three bladed right propeller, due to the failure of the hub. Examination of the propeller and engine revealed that the crankshaft counterweight bushings were not installed allowing a high frequency… - [NTSB LAX87DVW01](https://openairdocs.org/ntsb/LAX87DVW01.md): North American P51D · Ashfork, AZ · Accident · Minor injuries · Final report · Apr 3, 1987 · N1451D · Substantial damage > The North American P-51D experienced a total loss of engine power after cruising at 10,000 feet MSL for 45 minutes. Attempts to restart the engine were unsuccessful. The aircraft collided with some trees prior to coming to rest in an open field. The landing… - [NTSB ATL87FA104](https://openairdocs.org/ntsb/ATL87FA104.md): Piper PA-28R-201 · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Apr 3, 1987 · N47887 · Destroyed > The non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide. - [NTSB MIA87LA125](https://openairdocs.org/ntsb/MIA87LA125.md): North American B-25-J · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Apr 2, 1987 · N25NA · Substantial damage > The plt stated that he was in the vicinity of melbourne FL when the right engine failed. He secured the right engine and turned back towards new smyrna beach, but as he was nearing tico airport the left engine also failed. The pilot, realizing he was not… - [NTSB ATL87LA102](https://openairdocs.org/ntsb/ATL87LA102.md): Boeing 727-295 · Miami, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1987 · N1643 · No damage > An 84 year-old male pax got up from his seat shortly after takeoff and headed toward the aft lavatories. The seat belt and no smoking signs were still illuminated. The acft was at about 1000 ft AGL and in a steep climb attitude. The pax fell face forward… - [NTSB CHI87IA112](https://openairdocs.org/ntsb/CHI87IA112.md): Dassault-Breguet 50 · Cleveland, OH · Incident · No injuries · Incident investigation · Final report · Mar 31, 1987 · N52DC · No damage > An opnl error developed as a falcon 50, N52DC, was proceeding se toward the dryer VOR at FL290 & northwest flt 427 was proceeding westbound at the same alt toward the same fix (dryer VOR). When the full performance lvl (fpl) controller (ctlr) saw the… - [NTSB FTW87FA088](https://openairdocs.org/ntsb/FTW87FA088.md): Piper PA-28-181 · Marlin, TX · Accident · 1 fatal · Field investigation · Final report · Mar 30, 1987 · N8191V · Destroyed > The acft had been involved in pipeline patrol throughout its history of 7490 flt hrs. Just before the acdnt, the acft was observed in straight & lvl flt along a pipeline right-of-way. According to witnesses, the acft was at low alt when a wing separated & the… - [NTSB CHI87FA106](https://openairdocs.org/ntsb/CHI87FA106.md): Airbus Industrie A300B4-203 · Indianapolis, IN · Accident · Serious injuries · Field investigation · Final report · Mar 30, 1987 · N230EA · No damage > While cruising at ngt in clr air (well abv clds), eastern ai lines flt 477 was in light chop at FL 310 with the seat belt sign on. The captain stated that when the turbulence increased to a moderate cond, he made an announcement for the flt attendants (f/a's)… - [NTSB SEA87LA071](https://openairdocs.org/ntsb/SEA87LA071.md): Schweizer SGS 2-33A · Issaquah, WA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1987 · N33924 · Substantial damage > During a local training flight a downdraft was encountered. At about two miles from the airport the acft was at about 200 feet MSL. The instructor plt decided to land the acft on a field. On short final the acft struck a barbed wire fence prior to touchdown. - [NTSB LAX87LA161](https://openairdocs.org/ntsb/LAX87LA161.md): Bell 206B · Kona, HI · Accident · 1 fatal · Limited investigation · Final report · Mar 29, 1987 · N90153 · Destroyed > The pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the… - [NTSB BFO87LA028](https://openairdocs.org/ntsb/BFO87LA028.md): Piper PA-23-250 · Dover, DE · Accident · No injuries · Limited investigation · Final report · Mar 29, 1987 · N5216Y · 2 aircraft · Substantial damage > The rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of… - [NTSB LAX87LA158](https://openairdocs.org/ntsb/LAX87LA158.md): Thorp T-18 · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N26CK · Destroyed > While on a flt to practice aerobatics, the plt was flying at 3500' when he felt a cold liquid on his rgt leg & noted the odor of fuel in the cockpit. Moments later, flames erupted in the cockpit. The plt bailed out & the airplane crashed on the southeast… - [NTSB LAX87DUJ04](https://openairdocs.org/ntsb/LAX87DUJ04.md): Benson B-8M · Fountain Hills, AZ · Accident · 1 fatal · Final report · Mar 28, 1987 · N282A · Substantial damage > Witnesses stated that the homebuilt gyrocopter entered a steep climb and appeared to roll completely over. Halfway through the engine backfired and then quit. The aircraft went into a steep dive. The aircraft impacted the terrain near vertically. - [NTSB FTW87DQG01](https://openairdocs.org/ntsb/FTW87DQG01.md): Replica P51 · Midland, TX · Accident · No injuries · Final report · Mar 28, 1987 · N51JR · Substantial damage > Pilot reported prop surging in flt. During landing roll the pilot lost control, groundlooped and the main landing gear collapsed. Investigation could not reveal a reason for the prop surging. - [NTSB SEA87LA069](https://openairdocs.org/ntsb/SEA87LA069.md): Bellanca 17-30 · Medford, OR · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N4878V · Substantial damage > A total and sudden loss of power occurred at about 3,500 feet MSL during climb for cruise. The pilot made a 180 degree turn back to the airport. Since an undershoot was assured the pilot elected to land the aircraft on a field. During landing rollout at about… - [NTSB SEA87IA068](https://openairdocs.org/ntsb/SEA87IA068.md): Mcdonnell Douglas DC-10-10 · Tuba City, AZ · Incident · No injuries · Incident investigation · Final report · Mar 26, 1987 · N151AA · Minor damage > While engaged in cruise on a scheduled transcontinental flight from new york to los angeles, several stage 1 high pressure turbine rotor blades within the #1 engine separated without warning from their platforms. The initial separation was found to have… - [NTSB LAX87FA156](https://openairdocs.org/ntsb/LAX87FA156.md): Cessna 310Q · Half Moon Bay, CA · Accident · 2 fatal · Field investigation · Final report · Mar 26, 1987 · N7603Q · Destroyed > While flying northwest over water along the pacific coast on an IFR clnc, the plt rprtd to the sector controller (ctlr) 'we've got a problem.' The ctlr inquired about the nature of the problem. The plt then stated, 'going down fast, out of control.' The ctlr… - [NTSB DEN87LA074](https://openairdocs.org/ntsb/DEN87LA074.md): Balloon Works Firefly 7 · Park City, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1987 · N1521G · Substantial damage > The Balloon was landing in an open field and struck a rock. One pax had prepared for hard landing and one had elected to continue filming. The photographer was thrown forward out of the basket and the basket passed over him, coming to rest 50 feet away. - [NTSB CHI87LA103](https://openairdocs.org/ntsb/CHI87LA103.md): Cessna 172M · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Mar 26, 1987 · N19984 · Substantial damage > The plt's original destn was lexington, KY, however between bluefield, KY and lexington, he amended his destn to indianapolis, IN. The plt stated that fuel consumption was calculated as 7.1 gph, but he did not take into consideration the Cessna 172 time/fuel… - [NTSB MKC87IA066](https://openairdocs.org/ntsb/MKC87IA066.md): Cessna 172 · Neosho, MO · Incident · No injuries · Incident investigation · Final report · Mar 24, 1987 · N98763 · Minor damage > The acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn… - [NTSB LAX87FA153](https://openairdocs.org/ntsb/LAX87FA153.md): Beech V35B · Camp Pendleton, CA · Accident · 2 fatal · Field investigation · Final report · Mar 24, 1987 · N8888M · Destroyed > As the acft was nearing its destn at ngt, the plt contacted TRACON & reqd radar advisories & clnc into the terminal area. Radar contact was established when the acft was 6 mi nw of oceanside VOR at 1500' MSL. This placed the acft in a restricted area… - [NTSB LAX87LA155](https://openairdocs.org/ntsb/LAX87LA155.md): Piper PA-28-140 · Anza, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1987 · N2439T · Substantial damage > During a local sight seeing flt the plt entered a river valley in mountainous terrain at about 1,000 ft AGL. After about 5 miles, the plt decided to exit the narrowing valley with a climbing right turn over a ridge line. About 2/3 of the way up the slope, the… - [NTSB CHI87IA100](https://openairdocs.org/ntsb/CHI87IA100.md): Mcdonnell Douglas DC-9-82 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Mar 23, 1987 · N409AA · Minor damage > The aircraft landed uneventfully after the right engine failed during a descent. The shutdown occurred after failed antirotation pins allowed gas loads to drive normally stationary third stage vane clusters in the low pressure turbine area. Rotation of the… - [NTSB ATL87LA090](https://openairdocs.org/ntsb/ATL87LA090.md): Ercoupe 415-D · Cottondale, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 22, 1987 · N99436 · Substantial damage > The plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction. - [NTSB DEN87FA069](https://openairdocs.org/ntsb/DEN87FA069.md): Raven S-77A · Park City, UT · Accident · 1 fatal · Field investigation · Final report · Mar 21, 1987 · N40968 · Destroyed > While on a commercial pax sightseeing flt, the plt allowed a non-rated student plt to fly the balloon until it nearly collided with buildings. The plt took over the controls and applied maximum burner heating to avoid impact with the buildings, which resulted… - [NTSB ATL87LA089](https://openairdocs.org/ntsb/ATL87LA089.md): Piper PA-28R-200 · Darien, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1987 · N2948R · Substantial damage > During normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become… - [NTSB LAX87LA152](https://openairdocs.org/ntsb/LAX87LA152.md): Cessna 182Q · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1987 · N759V · Substantial damage > During a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was… - [NTSB SEA87LA066](https://openairdocs.org/ntsb/SEA87LA066.md): Cessna 172 · Lopez Island, WA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N64728 · Substantial damage > During cruise the acft engine quit due to fuel exhaustion. The pilot neglected to visually check the fuel tanks prior to departure, but rather relied on fuel gauges and his own estimation that enough fuel would be remaining to complete the flight. During… - [NTSB NYC87FA114](https://openairdocs.org/ntsb/NYC87FA114.md): Bell 47G · Wassaic, NY · Accident · 2 fatal · Field investigation · Final report · Mar 19, 1987 · N13766 · Destroyed > The Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No… - [NTSB LAX87LA160](https://openairdocs.org/ntsb/LAX87LA160.md): Balloon Works Barnes FF-8-24 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 19, 1987 · N3750D · Minor damage > During a local sightseeing flight, the pilot reported that upon lift-off the weather conditions were clear and calm. During the flight, however, the wind conditions had increased from a westerly direction at a velocity of 12 knots, gusting to 15. The pilot… - [NTSB CHI87FA099](https://openairdocs.org/ntsb/CHI87FA099.md): Bellanca 7ECA · Attica, IN · Accident · 1 fatal · Field investigation · Final report · Mar 19, 1987 · N5504L · Destroyed > After completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that… - [NTSB BFO87DIG02](https://openairdocs.org/ntsb/BFO87DIG02.md): Boeing 727-200 · Charleston, SC · Accident · Serious injuries · Final report · Mar 19, 1987 · XAHOH · No damage > The flight encountered clear air turbulence at FL 350 during cruise flight. The pilot said he was aware beforehand of existing turbulent conditions. According to the plt the seat belt sign was on, the flight attendant and passengers were asked to be seated.… - [NTSB LAX87LA150](https://openairdocs.org/ntsb/LAX87LA150.md): Cessna P210N · Elk Grove, CA · Accident · No injuries · Limited investigation · Final report · Mar 18, 1987 · N6446W · Substantial damage > During a local flight to check repairs to the aircraft cabin pressurization, the aircraft had descended from 8500 ft MSL to 2000 ft MSL when the engine began cutting out. Unable to maintain altitude to return to the airport, the pilot landed the aircraft in a… - [NTSB LAX87LA148](https://openairdocs.org/ntsb/LAX87LA148.md): Stinson 108-1 · Rio Vista, CA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1987 · N97115 · Substantial damage > The aircraft nosed over in soft soil after a forced landing. The aircraft's engine failed during the departure climb and the pilot was unable to restart it. The pilot accomplished a forced landing to a field. The aircraft nosed over when the nose gear became… - [NTSB FTW87LA082](https://openairdocs.org/ntsb/FTW87LA082.md): Boeing 737-300 · Midland, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1987 · N314SW · No damage > While penetrating a line of thunderstorms at 35,000 en route to Midland, TX, from dallas, TX, severe turbulence was encountered. One flight attendant had just sat down but had not fastened his seat belt and was thrown to the floor sustaining serious injuries. - [NTSB ANC87FA051](https://openairdocs.org/ntsb/ANC87FA051.md): Bell 206B-3 · Valdez, AK · Accident · 1 fatal · Field investigation · Final report · Mar 17, 1987 · N9AR · Substantial damage > The helicopter collided with transmission lines while on pipeline patrol, fatally injuring the pilot and seriously injuring the observer. The observer stated that he and the pilot had been flying towards a burning object on the snow near two snow machines… - [NTSB MKC87LA062](https://openairdocs.org/ntsb/MKC87LA062.md): Piper PA-32-300 · Mason City, IA · Accident · No injuries · Limited investigation · Final report · Mar 16, 1987 · N56285 · Substantial damage > The pilot stated that he had obtained a full weather briefing and an IFR clearance from grand marais, Minnesota to des moines, Iowa prior to departure; and that the flight was uneventful, except for stronger than forecasted headwinds aloft. Enroute, the pilot… - [NTSB FTW87FA078](https://openairdocs.org/ntsb/FTW87FA078.md): Piper PA-28-151 · Kerrville, TX · Accident · 3 fatal · Field investigation · Final report · Mar 16, 1987 · N6785F · Destroyed > The non-instrument pilot continued VFR flight into IMC conditions. The acft struck top of ridgeline while traveling at a high rate of speed and was demolished. No evidence of a pre-impact failure or malfunction of the acft was found. - [NTSB ATL87LA086](https://openairdocs.org/ntsb/ATL87LA086.md): Cessna 210L · Jeffersontown, KY · Accident · No injuries · Limited investigation · Final report · Mar 15, 1987 · N93022 · Destroyed > During IFR flight in VFR conditions the pilot reported low fuel situation to approach control. The aircraft was in the vicinity of several lighted airports at that time. The aircraft lost power and made forced landing at night in mountainous terrain where an… - [NTSB MIA87LA107](https://openairdocs.org/ntsb/MIA87LA107.md): Piper PA-24-250 · Meridian, MS · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 1987 · N6290P · Substantial damage > The pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and… - [NTSB NYC87FA109](https://openairdocs.org/ntsb/NYC87FA109.md): Cessna P210R · Block Island, RI · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1987 · N6434A · Destroyed > The aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,… - [NTSB CHI87LA097](https://openairdocs.org/ntsb/CHI87LA097.md): Piper PA-28R · Holland, MI · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N5140S · Substantial damage > During a local flight the aircraft's engine lost oil pressure. The engine continued to run for about two minutes and then totally seized. The pilot made a hard landing on 58th street in Holland (the only available landing area he could see in the dark night… - [NTSB MIA87LA103](https://openairdocs.org/ntsb/MIA87LA103.md): Cessna TR182 · No.Atlantic Oc (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Mar 10, 1987 · N737NM · Destroyed > The plt departed Canada on a north atlantic ferry flight to shannon ireland after jump starting the aircraft because he left the master switch on overnight. About 750 miles west of the irish coast the electical system failed and he could not transfer fuel… - [NTSB SEA87LA063](https://openairdocs.org/ntsb/SEA87LA063.md): Cessna 152 · Coburg, OR · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N68747 · Substantial damage > The student pilot was in the process of flying his long cross country flight in order to qualify for his private pilots certificate. Prior to reaching the home airport, the students instructor talked to him from the ground and advised the student not to land,… - [NTSB MIA87LA101](https://openairdocs.org/ntsb/MIA87LA101.md): Beech C24R · Milton, FL · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N18891 · Substantial damage > The acft crashed in a river aprx 1 mile west of his alternate landing location after the eng quit while descending for an apch, due to fuel exhaustion. - [NTSB FTW87LA075](https://openairdocs.org/ntsb/FTW87LA075.md): Piper PA-23-250 · George West, TX · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N178S · Substantial damage > Aircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board. - [NTSB CHI87LA094](https://openairdocs.org/ntsb/CHI87LA094.md): American AA5 · Flint, MI · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N5896L · Substantial damage > During a forced landing on an interstate highway about two miles from bishop airport, the aircraft collided with a signpost and a concrete bridge. The pilot had reported that he was out of fuel when he was about nine miles away from the airport. The pilot… - [NTSB MKC87LA058](https://openairdocs.org/ntsb/MKC87LA058.md): Cessna 175 · Tipton, MO · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1987 · N7135M · Substantial damage > The pilot stated that, fifteen minutes into the flight, while at cruise the engine oil pressure began dropping as the oil temperature rose. While attempting to reach sedalia, Missouri to perform a precautionary landing, oil began covering the aircraft's… - [NTSB FTW87LA074](https://openairdocs.org/ntsb/FTW87LA074.md): Cessna 182P · Refugio, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1987 · N4473M · Destroyed > Engine failure occurred on climb. The aircraft was destroyed during the forced landing. Teardown revealed that the no. 1 cylinder rocker arm shaft retainer ear had broken. The two lock bolts had backed out because they had not been safety wired. The no. 2… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=315 ## 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=314 --- 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.