# 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 310 of 718 · 35,885 cases ## Cases, newest first - [NTSB FTW87FA177](https://openairdocs.org/ntsb/FTW87FA177.md): Aero Commander 520 · Carrollton, TX · Accident · Minor injuries · Field investigation · Final report · Jul 27, 1987 · N4164B · Destroyed > Acft was destroyed when it struck pwr lines and the grnd during a single eng go-around. Following a left eng shut down due to severe vibrations, the plt overflew one arpt to return to his home base. En route, he elected not to go to full pwr due to a 3 min… - [NTSB NYC87FA209](https://openairdocs.org/ntsb/NYC87FA209.md): Cessna 182 · Poestenkill, NY · Accident · 1 fatal · Field investigation · Final report · Jul 26, 1987 · N6313A · Destroyed > The non-instrument rated plt was on a flt to psn the acft for sky diving activities. As he was transiting the albany arpt radar svc area at 5500', radio and radar ctc were lost. Subsequently, the acft crashed in a steep dive and was demolished by impact. Psnl… - [NTSB MIA87LA215](https://openairdocs.org/ntsb/MIA87LA215.md): Cessna 172M · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1987 · N61897 · Substantial damage > The flt was aprx 43 miles west-northwest of freeport, Bahamas, en route to fort lauderdale, FL when the plt observed theengine oil pressure gauge indicating zero pressure. He reversed course back to freeport, contacted miami radio and gave his location. The… - [NTSB SEA87LA148](https://openairdocs.org/ntsb/SEA87LA148.md): Cessna 150G · Gresham, OR · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N2415J · Substantial damage > During the student pilot's long solo cross-crounty a loss of power occurred. During the forced landing the pilot overshot the intended field so he selected a nearby field. He overshot this field, flew between 2 trees at 20 feet AGL and descended to the… - [NTSB SEA87LA147](https://openairdocs.org/ntsb/SEA87LA147.md): Cessna T210K · Bellevue, WA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1987 · N5768J · Substantial damage > After tkof, the plt leveled at about 1500' & adjusted the pwr to a low cruise setting. A short time later, the eng bgn missing & subsequently lost all pwr. The plt followed the emerg procedures, but was unable to restart the eng. He manuevered the acft to… - [NTSB MKC87LA145](https://openairdocs.org/ntsb/MKC87LA145.md): Hiller 12E · Ulysess, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1987 · N67139 · Substantial damage > During a helicopter aerial application operation, acft suffered a main rotor system hub failure. PIC was unable to control the acft and an uncontrolled descent resulted. Acft struck the terrain and was substantially damaged and the PIC suffered minor… - [NTSB SEA87LA143](https://openairdocs.org/ntsb/SEA87LA143.md): Cessna 170B · Coeur D'Alene, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 1987 · N3063A · Substantial damage > On initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical… - [NTSB SEA87FA145](https://openairdocs.org/ntsb/SEA87FA145.md): Cessna T210N · Avery, ID · Accident · 2 fatal · Field investigation · Final report · Jul 21, 1987 · N6326Y · Destroyed > While in cruise at 15000 ft MSL, plt requested ATC deviation around tstm shown on acft stormscope. After passing, ATC gave vector to rejoin airway. Plt requested further deviation around another cell. Radio and radar contact were then lost. Investigation… - [NTSB MKC87LA143](https://openairdocs.org/ntsb/MKC87LA143.md): Schweizer G-164A · Lilbourn, MO · Accident · No injuries · Limited investigation · Final report · Jul 21, 1987 · N8911H · Destroyed > While returning from an aerial application flight, the aircraft's engine lost power and quit. The pilot made a forced landing in a soft field and nosed over. Post accident inspection revealed a cylinder was cracked. Several hours after the accident, the… - [NTSB LAX87LA275](https://openairdocs.org/ntsb/LAX87LA275.md): Piper PA-28-161 · Milpitas, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1987 · N91338 · Substantial damage > While climbing to cruise plt heard a loud knocking noise followed by 'violent vibrations' & a loss of power. Plt made a frcd lnding in a newly excavated construction site & went over an embankment. Inves revealed deformation of the #4 cylinder valve cover. #4… - [NTSB MKC87LA141](https://openairdocs.org/ntsb/MKC87LA141.md): Cessna 175C · Bear Creek, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 1987 · N8326T · Substantial damage > During a personal xc flt, plt experienced a partial loss of power followed by a total loss of power. During emergency ldg, pilot stated that he prematurely added full flaps, which resulted in too steep of a descent, causing acft to be short of intended… - [NTSB DEN87FA188](https://openairdocs.org/ntsb/DEN87FA188.md): Cessna 210 · Coaldale, CO · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1987 · N7444E · Substantial damage > The ATP rated pilot was an airline captain on a Boeing 727 aircraft. However, the pilot had accumulated a total of only 140 hours in single engine aircraft with 20 hours in the Cessna 210. Moderate to severe turbulence had been forecast and reported in the… - [NTSB ATL87LA216](https://openairdocs.org/ntsb/ATL87LA216.md): Piper PA-28-140 · Eubank, KY · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N1324T · Substantial damage > The plt reptd that he was planning a refuel stop at short airport near Eubank, KY. Short is a private strip and the owner stated that he did not have fuel available. The pilot reptd that when he was about five minutes away, the engine 'quit and he was unable… - [NTSB SEA87LA142](https://openairdocs.org/ntsb/SEA87LA142.md): Piper PA-28-140 · Ashland, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1987 · N95407 · Destroyed > Plt was proceeding VFR, no flt plan, no record of wx brief, northbound through siskiyou pass along I-5 from calif into Oregon about 1400 PDT. Plt reported suddenly in clouds, then saw trees. Acft collided with rising terrain 1/2 mile west of point where I-5… - [NTSB MKC87LA144](https://openairdocs.org/ntsb/MKC87LA144.md): Grumman G-164A · Forrest City, AR · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N7864 · Substantial damage > While doing a repositioning operation, with an ag acft, the engine quit, due to fuel exhaustion. The PIC said that a visual inspection of the fuel supply would have prevented the accident. He said that in an attempt to turn back to a dirt strip, the acft… - [NTSB CHI87LA170](https://openairdocs.org/ntsb/CHI87LA170.md): Cessna 182C · Clio, MI · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N8576T · Substantial damage > The plt stated he departed with 55 gals of fuel. After 3.5 hrs of level flt at 7500 ft MSL he declared fuel exhaustion to the FAA flint twr. He was 3-4 miles frm a suitable arpt but was too low on final to reach the rwy. He landed on a road and struck a pole… - [NTSB NYC87LA205](https://openairdocs.org/ntsb/NYC87LA205.md): Piper PA-12 · Spencer Lake, ME · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N4202M · Substantial damage > The flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued… - [NTSB NYC87LA131](https://openairdocs.org/ntsb/NYC87LA131.md): Piper PA-28-180 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N7684J · Substantial damage > About 5 min after taking off, the eng began running rough, then lost power & would not restart. Subsequently, the acft was damaged drg an emerg lndg in a potato field. The acft was moved before aviation inspectors arrived. No fuel was fnd in the fuel pumps,… - [NTSB SEA87IA139](https://openairdocs.org/ntsb/SEA87IA139.md): Beech 55 · Rigby, ID · Incident · No injuries · Incident investigation · Final report · Jul 15, 1987 · N321MB · Minor damage > During descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed… - [NTSB LAX87LA268](https://openairdocs.org/ntsb/LAX87LA268.md): Cessna 150G · Oakland, CA · Accident · No injuries · Limited investigation · Final report · Jul 15, 1987 · N3487J · Substantial damage > At the end of a cross country flt, the plt had just been cleared to land when the engine sputtered then quit. Unable to land at the arpt the plt made an emergency landing on a road where the acft collided with the terrain and nosed over. Inspection of the… - [NTSB LAX87FA267](https://openairdocs.org/ntsb/LAX87FA267.md): Cessna T210L · Marina Del Rey, CA · Accident · 4 fatal · Field investigation · Final report · Jul 15, 1987 · N7JT · Destroyed > Weather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.… - [NTSB ATL87FA212](https://openairdocs.org/ntsb/ATL87FA212.md): Piper PA-28 · Elberton, GA · Accident · Serious injuries · Field investigation · Final report · Jul 15, 1987 · N5502F · Substantial damage > The plt noted a progressive loss of pwr that began drg the climb to cruise. He diverted back toward the dep arpt & atmtdto restore pwr by activating the boost pump, moving the mixture to full rich, switching fuel tanks & applying carb heat. However, the eng… - [NTSB FTW87FA168](https://openairdocs.org/ntsb/FTW87FA168.md): Piper PA-28-181 · Jenks, OK · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1987 · N1976T · Substantial damage > Although it was determined that the engine failed due to fuel exhaustion, the exact sequence of events that led to this event was not determined. The pilot reported that the aircraft was out of fuel over the radio and no fuel was found in the aircraft. There… - [NTSB NYC87LA201](https://openairdocs.org/ntsb/NYC87LA201.md): Piper J3C-65 · Huntingdon, PA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1987 · N33576 · Substantial damage > The flight encountered poor visibility while at cruise altitude. The pilot decided not to continue flight and landed on a football field. During roll out, the right main gear fell into a drain hole to the side of the field causing the aircraft to turn right… - [NTSB MIA87FA205](https://openairdocs.org/ntsb/MIA87FA205.md): Bellanca 17-30A · Palatka, FL · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1987 · N93664 · Destroyed > Witnesses stated that they heard the acft's eng sounding rough just before it crashed into the trees. Another witness stated that he noticed that there were flames & smoke coming from the left side of the plane. A tail pipe assembly was found on the ramp at… - [NTSB LAX87FA264](https://openairdocs.org/ntsb/LAX87FA264.md): Ryan ST3KR · Firebaugh, CA · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1987 · N48777 · Destroyed > At about 1650 PDT, the plts of 2 Ryan ST3KR acft depd coalinga on a flt to los banos, CA. At about 1709 PDT, the plt of N48777 made a hand signal to the other plt, pointed toward the ground & entered 'a normal glide.' Subsequently, the plt of N48777… - [NTSB DEN87LA182](https://openairdocs.org/ntsb/DEN87LA182.md): Cessna 152 · New Rockford, ND · Accident · No injuries · Limited investigation · Final report · Jul 13, 1987 · N95876 · Substantial damage > The student plt was on a cross country flight. He noticed a drop in engine RPM. An engine vibration began and another aircraft reported seeing a smoke trail. The plt elected to make an off airport landing and selected a wheat field. The plt made an emergency… - [NTSB MKC87LA137](https://openairdocs.org/ntsb/MKC87LA137.md): Air Tractor AT301A · Baderville, MO · Accident · No injuries · Limited investigation · Final report · Jul 12, 1987 · N3169N · Destroyed > During an aerial application operation, the pilot experienced a violent engine vibration. He reduced power and attempted an emergency ldg. Acft nosed over on landing. The pilot exited aircraft through side window. Acft caught fire and was destroyed.… - [NTSB MKC87LA136](https://openairdocs.org/ntsb/MKC87LA136.md): Piper PA-28-140 · Ottawa, KS · Accident · No injuries · Limited investigation · Final report · Jul 12, 1987 · N5701U · Substantial damage > During a night flight the aircraft's engine lost partial power. The pilot elected to make a precautionary landing in a farm field. During landing the aircraft's right wing struck a fence. An engine teardown revealed a failed exhaust valve on the number 3… - [NTSB LAX87LA265](https://openairdocs.org/ntsb/LAX87LA265.md): Beech D18S · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N99CP · Substantial damage > The acft had not been flown for svrl years & was on a flt to ferry it to another location. While cruising at 7500', the plt decided to start using aux fuel. Shortly after moving the fuel selectors to the aux psn, both engs lost power & would not restart. The… - [NTSB DEN87LA179](https://openairdocs.org/ntsb/DEN87LA179.md): Cessna 175 · Kalispell, MT · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1987 · N9201B · Substantial damage > The pvt plt was on a x-country flight. The engine began running rough, made a 'bang' sound and lost partial power. Smoke entered the cockpit, oil pressure was lost and the plt initiated an emergency landing. The acft ldg gr struck powerlines on approach to a… - [NTSB DEN87FA178](https://openairdocs.org/ntsb/DEN87FA178.md): Piper PA-24-250 · Hayden, CO · Accident · 3 fatal · Field investigation · Final report · Jul 11, 1987 · N7858P · Destroyed > The plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a… - [NTSB CHI87DER09](https://openairdocs.org/ntsb/CHI87DER09.md): Great Lakes Adams 2T-1 · Bethel/Msp, MN · Accident · 1 fatal · Final report · Jul 10, 1987 · N23JA · Substantial damage > The amateur built aircraft impacted in an open farm field. Although witnesses did not agree on the altitude the aircraft was flying at, they all stated that the Great lakes 2T-1 was spinning before it collided with the ground. One witness indicated that the… - [NTSB SEA87LA163](https://openairdocs.org/ntsb/SEA87LA163.md): Cessna T-207 · Mccall, ID · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N6385H · Substantial damage > During climb out to cruise altitude the pilot noticed a drop in manifold pressure and a loss of oil pressure. The pilot was in the process of attempting to reach an airstrip when the oil pressure dropped to zero followed by a total loss of power. An off… - [NTSB NYC87IA199](https://openairdocs.org/ntsb/NYC87IA199.md): Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean) · Incident · No injuries · Incident investigation · Final report · Jul 9, 1987 · YV135 · 2 aircraft · No damage > A Mcdonnell Douglas DC-10 (viasa flt 800) & an Airbus A310 (pan am flt 221) were involved in a near collision while on intl flts ovr the Atlantic Ocean on (airway) amber 300. Both acft were operg under IFR & were in a non-radar environmentw/o drct radio ctc… - [NTSB DEN87FA177](https://openairdocs.org/ntsb/DEN87FA177.md): Cessna 152II · Parker, CO · Accident · Serious injuries · Field investigation · Final report · Jul 9, 1987 · N5269Q · Substantial damage > The instructor plt and his new student were on a local training flt when they encountered adverse wx. The instructor said that he attempted to turn back to the arpt but the winds forced the acft down until it impacted the ground. - [NTSB DEN87LA175](https://openairdocs.org/ntsb/DEN87LA175.md): Schempp-Hirth Nimbus II · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N71JD · Substantial damage > The pvt plt was flying in a national soaring contest. The glider was towed to 2000 feet AGL and released. The plt reported making a climbing right turn after release, however he noticed that the control stick was more aft than normal. As the flight… - [NTSB ATL87IA201](https://openairdocs.org/ntsb/ATL87IA201.md): Boeing 737-232 · Frankfort, KY · Incident · No injuries · Incident investigation · Final report · Jul 7, 1987 · N324DL · No damage > Thunderstorms and lightning in the vicinity of the arpt prevented adding fuel to the acft and resulted in a delayed departure. The lou VOR was out of service, and the flt was radar vectored until it was cleared direct to lex and for the apch. At the time of… - [NTSB FTW87LA162](https://openairdocs.org/ntsb/FTW87LA162.md): Grumman G-21A · Big Spring, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1987 · N322 · Substantial damage > During flt, the plt noted that the left fuel tank was almost empty and the right tank had gained fuel. He immediately switched from the both position to the right tank and started to work the wobble pump. The fuel continued to drop in the left tank and the… - [NTSB BFO87FA046](https://openairdocs.org/ntsb/BFO87FA046.md): Grumman AA-5B · Abingdon, VA · Accident · 1 fatal · Field investigation · Final report · Jul 6, 1987 · N19SM · Destroyed > Fss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the… - [NTSB ANC87LA091](https://openairdocs.org/ntsb/ANC87LA091.md): Dornier DO-27 · White Mountain, AK · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N777AX · Substantial damage > The pilot stated that while cruising at 2000 feet MSL the engine started to run rough. He made an emergency landing on the tundra. Examination of the engine revealed the number one and number two cylinders broke and separated in flight. - [NTSB NYC87LA196](https://openairdocs.org/ntsb/NYC87LA196.md): Cessna 150F · Roseville, PA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1987 · N7933F · Substantial damage > Witnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found. - [NTSB NYC87DNE03](https://openairdocs.org/ntsb/NYC87DNE03.md): Noble Falcon X-P · Wallingford, CT · Accident · No injuries · Final report · Jul 5, 1987 · N62JC · Substantial damage > The undetermined loss of engine power, and the pilot's poor aircraft handling during the resultant forced landing. - [NTSB DEN87LA169](https://openairdocs.org/ntsb/DEN87LA169.md): Piper PA-22-150 · Red Lodge, MT · Accident · No injuries · Limited investigation · Final report · Jul 5, 1987 · N5858D · Substantial damage > The plt stated that shortly after takeoff he intended to switch fuel to fullest tank but inadvertently put the fuel selector on off position. The engine failed. He did not have enough altitude or time to correct the situation and had to make a forced landing… - [NTSB FTW87FA156](https://openairdocs.org/ntsb/FTW87FA156.md): Aerospatiale AS-355-F1 · Venice, LA · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1987 · N5796M · Destroyed > One of the mechanics who performed maintenance on the aircraft main rotor head stated that he was not sure that he installed the retaining bolts which secured the vibration absorber assembly to the aircraft. Metallurgical analysis of the assembly indicated… - [NTSB NYC87DNC06](https://openairdocs.org/ntsb/NYC87DNC06.md): Enstrom F-28A · Mason, NH · Accident · 1 fatal · Final report · Jul 3, 1987 · N9271 · Destroyed > The loss of aircraft control after the tail rotor struck the trees and departed the aircraft. The pilot's poor judgement in flying in weather conditions beyond his capabilities was a factor. - [NTSB DEN87LA165](https://openairdocs.org/ntsb/DEN87LA165.md): Cessna 150-J · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Jul 3, 1987 · N60154 · Substantial damage > The plt and his son were returning home to Ogden. The plt reported to Ogden tower, 'I'm out of fuel.' The plt later stated, 'I landed in a field of two foot tall grass about five miles north of Ogden arpt. Prior to coming to a stop the acft struck a ditch… - [NTSB DEN87LA164](https://openairdocs.org/ntsb/DEN87LA164.md): Piper PA-28R-200 · Lordsburg, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1987 · N5032S · Substantial damage > While en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered… - [NTSB CHI87DET08](https://openairdocs.org/ntsb/CHI87DET08.md): Piper PA-28R-180 · Benton Harbor, MI · Accident · Serious injuries · Final report · Jul 3, 1987 · N7681J · Destroyed > While the aircraft was climbing to altitude the pilot tried to decrease power to cruise climb but had to reduce power more to control the propeller RPM. The pilot decreased the power once again and shortly after the engine stopped. The pilot then attempted to… - [NTSB LAX87LA251](https://openairdocs.org/ntsb/LAX87LA251.md): Cessna T210M · Tracy, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1987 · N761JM · Substantial damage > The aircraft collided with terrain after a total loss of power. The plt indicated that the eng failed at 3,500 ft MSL. The plt had flown for about 30 min with the fuel selector in the right tank position when the eng quit. He initially switched the fuel… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=311 ## 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=310 --- 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.