# NTSB investigations: Approach 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 190 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL86FA001](https://openairdocs.org/ntsb/ATL86FA001.md): Cessna 172 · Chapel Hill, NC · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1985 · N2765U · Destroyed > N2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The… - [NTSB DEN85IA250](https://openairdocs.org/ntsb/DEN85IA250.md): Boeing 727-100 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Sep 30, 1985 · N721PC · Minor damage > During gear extn for lndg, the flt crew noted a 'loud & very noticeable jolting of the acft.' Shortly thereafter, they also noticed that a portion of the right main gear had punctured the upper surface of the rgt wing. The crew then declared an emergency &… - [NTSB ATL86LMG01](https://openairdocs.org/ntsb/ATL86LMG01.md): Cessna 310R · Rocky Mount, NC · Accident · No injuries · Final report · Sep 30, 1985 · N1771G · Substantial damage > The acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt… - [NTSB NYC85LA254](https://openairdocs.org/ntsb/NYC85LA254.md): Schweizer SGS 2-33A · Preble, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1985 · N33920 · Substantial damage > A Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed… - [NTSB CHI85LA389](https://openairdocs.org/ntsb/CHI85LA389.md): Douglas Maselink XTC · Caledonia, MI · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N5272M · Substantial damage > The acft struck power lines while on apch for landing. The plt stated that he did not see the power lines; however, witnesses reported they warned the plt of the electrical lines prior to the accident. - [NTSB NYC85LA253](https://openairdocs.org/ntsb/NYC85LA253.md): Cessna C-170A · Marathon, NY · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N5709C · Substantial damage > During an approach to land on a 1600 ft private grass airstrip the plt noticed the acft was too high. The landing attempt was continued until the plt thought there would not be sufficient runway to stop the acft. A go around was initiated and the tail wheel… - [NTSB DEN85LA249](https://openairdocs.org/ntsb/DEN85LA249.md): Cessna TU206G · Evanston, WY · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 1985 · N5322U · No damage > The plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The… - [NTSB ATL85FA285](https://openairdocs.org/ntsb/ATL85FA285.md): Beech A36 · Lafayette, GA · Accident · 2 fatal · Field investigation · Final report · Sep 27, 1985 · N136BS · Destroyed > The acft crashed in a trailer parking lot after a steep left turn & uncontrolled descent. The acft impacted the ground in a nose low attitude. The rt wing had struck a parked trailer prior to the nose striking the ground. The acc occurred about 1/4 mile from… - [NTSB ATL85LA284](https://openairdocs.org/ntsb/ATL85LA284.md): Cessna 150F · Holly Springs, MS · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1985 · N8760S · Destroyed > The stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he… - [NTSB ATL85FA283](https://openairdocs.org/ntsb/ATL85FA283.md): Beech D18S · Huntington, WV · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1985 · N25Q · Destroyed > The acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of… - [NTSB ANC85MA183](https://openairdocs.org/ntsb/ANC85MA183.md): Boeing 737-2X6C · Unalaska, AK · Accident · Minor injuries · Major investigation · Final report · Sep 25, 1985 · N674MA · Substantial damage > Acft was dispatched to rstrctd arpt with a 3900' rwy & notamed: 3' stndg wtr on north end of rwy. SIGMET was in effect for mod to svr turbc blo 10,000' due to strong low lvl wnd & assoc wndshear. Capt made a shallow ovrwtr apch to rwy 12, which had a nr vert… - [NTSB DCA85AA037](https://openairdocs.org/ntsb/DCA85AA037.md): Beech B99 · Grottoes, VA · Accident · 14 fatal · Final report · Sep 23, 1985 · N339HA · Destroyed > Acft arr fm the NE, crossed ovr the arpt in IMC conds & contd twd the sw to the initial apch fix (iaf) for an ILS rwy 4 apch. The iaf was ovr the outer marker (om), 4.2 mi sw of the arpt. As the acft deptd the iaf, it contd outbnd twd the sw on an imprecise… - [NTSB DEN85FA246](https://openairdocs.org/ntsb/DEN85FA246.md): Cessna 172R · Santa Rosa, NM · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1985 · N758UA · Destroyed > The student plt was on his first x-country. His last solo flt was approx two months prior to accident. Witnesses saw acft on a rt downwind for rwy 26. The plt was told a left traffic patter was in use. The acft was observed to be flying slow at a low alt, on… - [NTSB ATL85MA282](https://openairdocs.org/ntsb/ATL85MA282.md): Gates Learjet 35A · Auburn, AL · Accident · 2 fatal · Major investigation · Final report · Sep 22, 1985 · N873LP · 2 aircraft · Destroyed > Drg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion… - [NTSB ATL85LLT11](https://openairdocs.org/ntsb/ATL85LLT11.md): Cessna T210L · Elizabethton, TN · Accident · No injuries · Final report · Sep 19, 1985 · N2045S · Destroyed > During a dual instructional flt the eng stopped due to fuel starvation during a go-around. During the attempted restart, the instructor failed to switch fuel tanks. The acft touched down in a fld and ran into a wooded area which separated both wings from the… - [NTSB NYC85LA242](https://openairdocs.org/ntsb/NYC85LA242.md): Cessna 172 · Ware, MA · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1985 · N738SA · Destroyed > The student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy. - [NTSB CHI85FA379](https://openairdocs.org/ntsb/CHI85FA379.md): Gulfstream 500-S · Cloquet, MN · Accident · 1 fatal · Field investigation · Final report · Sep 17, 1985 · N8139P · Destroyed > The pilot expected the weather to be below minimums but flew the approach anyway. He did not have a second pilot on board per company rules. The aircraft collided with trees about 3 miles from the approach end of runway 17. - [NTSB DEN85LA242](https://openairdocs.org/ntsb/DEN85LA242.md): Cessna 172 M · Wray, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1985 · N61788 · Substantial damage > The student pilot was on her first solo flight. She stated that she was attempted her first landing and while on approach to the runway shw decided that it 'wasn't quite right.' She executed a go-around but the aircraft struck the ground and cartwheeled. - [NTSB NYC85LA235](https://openairdocs.org/ntsb/NYC85LA235.md): Piper PA-38-112 · Madison, CT · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N2387P · Substantial damage > While on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy… - [NTSB ATL85LA277](https://openairdocs.org/ntsb/ATL85LA277.md): Piper PA-22-125 · Shinnston, WV · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N909A · Substantial damage > The plt reported that he initiated a normal apch to land on rwy 27. However, when he flared, he failed to stop the descent. Subsequently, the acft landed hard just short of the rwy. During the landing, the nose gear collapsed & the acft nosed over. - [NTSB CHI85LA378](https://openairdocs.org/ntsb/CHI85LA378.md): Schweizer 134 · Hampshire, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1985 · N7627 · Substantial damage > The pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground. - [NTSB MIA85FA253](https://openairdocs.org/ntsb/MIA85FA253.md): Cessna 152 · Panama City, FL · Accident · No injuries · Field investigation · Final report · Sep 13, 1985 · N4894B · 2 aircraft · Substantial damage > The plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and… - [NTSB LAX85LA389](https://openairdocs.org/ntsb/LAX85LA389.md): Cessna 150E · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1985 · N3926U · Substantial damage > While practicing stop and go takeoffs and landings, the solo student plt flared too high on the second landing and lost directional control. The plt applied power to negotiate a go around. The nose ptiched up and the acft stalled. The acft contacted the gnd… - [NTSB SEA85LA209](https://openairdocs.org/ntsb/SEA85LA209.md): Cessna 180 · Issaquah, WA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1985 · N7694A · Substantial damage > The acft landed nose down short of the rwy during a forced landing following fuel starvation. Investigation disclosed the main fuel line was blocked by pieces of the primer valve piston 'o' ring which had deteriorated due to the continuouuse of automotive… - [NTSB MIA85LA250](https://openairdocs.org/ntsb/MIA85LA250.md): Cessna 152 · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Sep 9, 1985 · N25590 · Substantial damage > The plt stated that while attempting a touch & go landing he lost control of the acft & landed in a muddy area on the north side of the rwy. - [NTSB LAX85LA386](https://openairdocs.org/ntsb/LAX85LA386.md): Peterson J-4 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Sep 8, 1985 · N29899 · Substantial damage > The student pilot stated that he observed a tow airplane and a glider on the runway as he turned onto the final aproach to land. He said that he continued his approach and when the tow aircraft and glider failed to take off he attempted to turn off the… - [NTSB FTW85LA354](https://openairdocs.org/ntsb/FTW85LA354.md): Schweizer SGS 1-26C · Rockdale, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1985 · N126P · Substantial damage > The pilot observed and cleared serveral obstructions in the approach path of his intended landing area. However, he did not see one small and unmarked electrical power line until too late to take evasive action. This line was about 30 feet above ground level… - [NTSB MIA85FA247](https://openairdocs.org/ntsb/MIA85FA247.md): Cessna 150 · Pensacola, FL · Accident · No injuries · Field investigation · Final report · Sep 7, 1985 · N6177K · 2 aircraft · Substantial damage > The commercial plt & CFI departed from gulfport, ms on a night VFR x-country flt to gulf shores. Al. The flt landed at foley, al after the plt mistook foley for gulfshores 10 mi south. The flt departed again & was advised by ATC to fly a heading of 170 deg… - [NTSB SEA85LA207](https://openairdocs.org/ntsb/SEA85LA207.md): Stolt-Adams Starduster SA101 · Yerington, NV · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N3635G · Substantial damage > While attempting to land the plt allowed the acft to become too low on short final. The plt did not add pwr soon enough and an undershoot occurred. - [NTSB DEN85LA237](https://openairdocs.org/ntsb/DEN85LA237.md): Cessna 172P · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N52456 · Substantial damage > The pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage. - [NTSB ATL85LA268](https://openairdocs.org/ntsb/ATL85LA268.md): Piper PA-24-250 · Florence, SC · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N7991P · Substantial damage > The plt was unable to extend the landing gear & performed a gear-up landing. Post accident examination revealed that the nose gear door was restricting the movement of the landing gear due to improper repair of the landing gear door attachment. - [NTSB LAX85LA379](https://openairdocs.org/ntsb/LAX85LA379.md): Piper PA-28-180 · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1985 · N9950B · Substantial damage > The stop at the airport was a planned fuel stop on a flt from conroe, TX to bullhead city, AZ. The flt departed controe,TX about 12 hours prior to the accident. Witnesses saw the acft make two 'high & very erratic' aborted approaches prior to impacting in the… - [NTSB CHI85LA367](https://openairdocs.org/ntsb/CHI85LA367.md): Raven AX-9 · Blaine, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 1985 · N4196N · Substantial damage > The one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a… - [NTSB FTW85LA339](https://openairdocs.org/ntsb/FTW85LA339.md): Cessna 150B · Drumright, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1985 · N1257Y · Destroyed > The pilot's landing approach was long and fast. The aircraft touched down but the pilot decided he would be unable to stop on the remaining runway and intiated a go-around. He then realized he would not be able to clear trees beyond the end of the runway. He… - [NTSB MKC85LA202](https://openairdocs.org/ntsb/MKC85LA202.md): Cessna 172M · Kahoka, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1985 · N64264 · Substantial damage > The plt stated that as he turned final, the airspeed increased and he could not slow down so the acft touched down fast. When he attempted a last minute go-around, the acft hit a concrete filled metal pole, went off the end of the rwy, across a street and… - [NTSB DEN85LA238](https://openairdocs.org/ntsb/DEN85LA238.md): Cessna 182D · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N707UR · Substantial damage > The pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c. - [NTSB DEN85LA232](https://openairdocs.org/ntsb/DEN85LA232.md): Cessna P210N · Hayden, CO · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N4780K · Substantial damage > Plt said eng began surging during descent from curise alt. After adjusting boost pump, throttle, and mixture, surging ceased. Plt said he dropped flaps and lowered landing gear at 2000 ft AGL and 5 mi from arpt. Eng began to surge again. Adjustment of… - [NTSB DEN85LA231](https://openairdocs.org/ntsb/DEN85LA231.md): Piper PA-28-181 · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1985 · N5418F · Substantial damage > The pilot stated after the accident that he had approximately 1/2 full tanks of fuel when he departed the airport on a local night flight. He stated that he flew burning fuel from the left fuel tank. The pilot was returning to the airport after a flight of… - [NTSB ANC85LA167](https://openairdocs.org/ntsb/ANC85LA167.md): Piper PA-14 · Cape Yakataga, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N5188H · Substantial damage > The plt elected to land on a sandy/gravel area about 600 ft long & 100 ft wide which was located between hills that were 100 to 150 ft high. During a x-wind apch, the acft's rate of descent began increasing. The plt applied full power to arrest the descent,… - [NTSB NYC85LA256](https://openairdocs.org/ntsb/NYC85LA256.md): Swearingen 226T · Hamilton, NY · Accident · No injuries · Limited investigation · Final report · Aug 30, 1985 · N92RC · Substantial damage > The aircraft was on approach for landing at Hamilton, new york when the cross power levers were pulled back to flight idle. The left prop went into beta mode stalling the left wing at about 8 feet above the runway. The aircraft rolled about 20 degrees to the… - [NTSB NYC85LA229](https://openairdocs.org/ntsb/NYC85LA229.md): Cessna 182J · Danville, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1985 · N3319F · Substantial damage > During an apch, the acft was configured with full flaps & was trimmed for 65 KTS. At about 150 feet from the desired touchdown point, the plt reduced power to land. Momentarily after that, the stall warning horn sounded & the acft fell 10 to 20 ft, impacting… - [NTSB MIA85LA240](https://openairdocs.org/ntsb/MIA85LA240.md): Cessna 310B · Hawthorne, FL · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N543GT · Destroyed > While on a x-country flt the plt stated that the autoplt was erratic, hot and smoking. The plt further stated that he continued to use the autoplt. At about 1000 ft on final apch the autoplt failed for unknown reasons and the acft nosed down. The acft crashed… - [NTSB CHI85LA366](https://openairdocs.org/ntsb/CHI85LA366.md): Bellanca 8KCAB · Germantown, OH · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N53982 · Substantial damage > On return to the airfield, the acft lost pwr in the turn to final apch. The plt turned to an unprepared fld in order to avoid obstacles. During the landing roll the acft struck a fence post and fence. The plt stated the accident could have been avoided by… - [NTSB CHI85FEP03](https://openairdocs.org/ntsb/CHI85FEP03.md): Roger W. Stigen EAA Biplane SR-1 · Sprimg Greem, WI · Accident · Serious injuries · Final report · Aug 27, 1985 · N3541 · Destroyed > Eaa bi plane N3541, piloted by john boatright, and registered to freeborn county aircraft inc., albert lea, Minnesota, sustained substantial damage during a landing approach to runway 27 at the lone rock airport at approximately 1900 CDT on August 26, 1985.… - [NTSB LAX85LA369](https://openairdocs.org/ntsb/LAX85LA369.md): Cessna 152 · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Aug 26, 1985 · N67488 · Substantial damage > At the conclusion of a local solo instructional flt, the plt lost control during a go around attempt and crashed off the left side of the runway. While approaching the airport, the plt said the UNICOM advised the winds as light and variable. On short final… - [NTSB DCA85AA035](https://openairdocs.org/ntsb/DCA85AA035.md): Beech 99 · Auburn, ME · Accident · 8 fatal · Final report · Aug 26, 1985 · N300WP · Destroyed > Drg arr, aprx 12 mi south of the final apch fix (faf), flt 1808 was clrd for an ILS rwy 4 apch. Aprx 3 min later, ATC controller (ctlr) noted acft was tracking east of the localizer (LOC) course. He asked if the flt was rcvg the ILS LOC. Capt replied 'not yet… - [NTSB LAX85LA366](https://openairdocs.org/ntsb/LAX85LA366.md): Piper PA38-112 · San Martin, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1985 · N25660 · Substantial damage > The acft stalled & collided with the ground during an attempted go-around. The plt was a student on her 1st solo ftl. During the maneuver the flaps remained fully extended and the plt tried to turn rt at slow airspeed. - [NTSB LAX85FA368](https://openairdocs.org/ntsb/LAX85FA368.md): Duce Project Bakeng Duce · St. Helena, CA · Accident · 2 fatal · Field investigation · Final report · Aug 25, 1985 · N113CP · Destroyed > According to witnesses, the plt had attempted a landing on the private ranch airstrip and a go around was performed. The acft then reversed direction and descended, striking a 6 foot high metal fence post before coming to rest. The acft was destroyed by post… - [NTSB FTW85LA333](https://openairdocs.org/ntsb/FTW85LA333.md): Cessna 305A · League City, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1985 · N6393T · Destroyed > The plt, while setting up for an aerial banner tow pick up, failed to properly divide his attention between his flt duties and observing another acft which was also in the traffic pattern. He allowed the acft to stall without sufficientalt to recover before… - [NTSB ATL85LKG11](https://openairdocs.org/ntsb/ATL85LKG11.md): Let L-13 · Huntsville, AL · Accident · Minor injuries · Final report · Aug 24, 1985 · N99954 · Substantial damage > The commercial plt was in training for a glider rating & was on a supervised solo flt to practice a landing. During the traffic pattern, he rolled out hi on final & extended the spoilers to adjust to the desired glide path, then retracted the spoilers to the… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=191 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=190 --- 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.