# 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 187 of 420 · 20,996 cases ## Cases, newest first - [NTSB DEN86LA095](https://openairdocs.org/ntsb/DEN86LA095.md): Smith, Ted Aerostar 601P Aerostar · Dickinson, ND · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1986 · N35DM · Substantial damage > While enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an… - [NTSB CHI86FA100](https://openairdocs.org/ntsb/CHI86FA100.md): Cessna 172M · Lafox, IL · Accident · 2 fatal · Field investigation · Final report · Mar 8, 1986 · N72MA · 2 aircraft · Destroyed > An instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was… - [NTSB LAX86LA135](https://openairdocs.org/ntsb/LAX86LA135.md): Robinson R-22 · El Toro, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1986 · N9072Z · Substantial damage > A helicopter crashed into a mountain slope east of El Toro, CA while on a business flt. While the acft approached the mountain peak the plt experienced an increase in the rate of descent and aborted the landing. During the go-around, at adecreased main rotor… - [NTSB ATL86FA085](https://openairdocs.org/ntsb/ATL86FA085.md): Beech BE-90 · Mount Pleasant, TN · Accident · No injuries · Field investigation · Final report · Mar 4, 1986 · N861K · Substantial damage > On final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal… - [NTSB NYC86LA082](https://openairdocs.org/ntsb/NYC86LA082.md): Cessna 182 · Pepperell, MA · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N8776T · Substantial damage > After descending to traffic pattern altitude. The throttle was advanced with no response from the engine. On flare to landing, pilot experienced sun glare, drifted to the right, and touched down in a snow bank. Nose gear dug in and aircraft flipped over onto… - [NTSB LAX86FA130](https://openairdocs.org/ntsb/LAX86FA130.md): Enstrom 280C · Ontario, CA · Accident · 2 fatal · Field investigation · Final report · Mar 1, 1986 · N5694R · Destroyed > Bfr deptg tucson, AZ on a return flt to long beach, CA, 2 student helicopter plts (the owners) were advised VFR flt was not rcmdd due to low ceiling/vis at the destn. Neither plt was endorsed for x-country flt. En route, they lndd/refueled at gila bend &… - [NTSB CHI86FA094](https://openairdocs.org/ntsb/CHI86FA094.md): Cessna 152 · Drayton Plaines, MI · Accident · 1 fatal · Field investigation · Final report · Mar 1, 1986 · N93604 · 2 aircraft · Destroyed > After a home built dragon fly gnd looped, other acft in the VFR traffic pattern were sent around, including a Cessna 152(C-152), N93604, flown by a student plt. Shortly after the dragon fly was clrd fm the rwy, Cessna 172 (C-172), N48003, entered the pattern,… - [NTSB CHI86LA091](https://openairdocs.org/ntsb/CHI86LA091.md): Cessna 210M · While Lake Twp., MI · Accident · No injuries · Limited investigation · Final report · Feb 28, 1986 · N761VX · Substantial damage > The acft was four miles from the arpt on an ILS apch when an eng failure was experienced. The acft was damaged during the forced landing on a frozen lake. Post accident eng teardown revealed the eng failure originated from movement of the #2 main bearing.… - [NTSB LAX86FA127](https://openairdocs.org/ntsb/LAX86FA127.md): Beech V35-B · Irvine, CA · Accident · 1 fatal · Field investigation · Final report · Feb 27, 1986 · N58SB · Destroyed > The pilot had executed the ILS rwy 19R approach and then requested a missed approach, stating that he 'had a localizer problem'. On the second attempt he was cleared to land and then was twice issued a low altitude alert. The pilot was further issued… - [NTSB BFO86FID02](https://openairdocs.org/ntsb/BFO86FID02.md): Beech BE65 · Wakefield, VA · Accident · No injuries · Final report · Feb 27, 1986 · N1QV · Substantial damage > The acft landed short of the rwy after loss of power on both engines. Contact with a dirt bank sheared the landing gear and the acft slid onto & down the rwy for about 436 ft before stopping. The plt said the fuel gauges were 1/4 on mains and 1/8 on avg… - [NTSB CHI86FA092](https://openairdocs.org/ntsb/CHI86FA092.md): Beech G18S · Janesville, WI · Accident · Serious injuries · Field investigation · Final report · Feb 26, 1986 · N723T · Destroyed > The aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC. - [NTSB BFO86FID01](https://openairdocs.org/ntsb/BFO86FID01.md): Cessna 172L · Gordonsville, VA · Accident · Minor injuries · Final report · Feb 23, 1986 · N7191Q · Destroyed > On February 23, 1986, at 1621 EST, a Cessna 172L, N7191Q collided with a tree during an attempted go-around at Gordonsville airport, Gordonsville, VA., while on a pleasure flight. Visual meteorological conditions prevailed at the time and no flight plan was… - [NTSB MKC86LA062](https://openairdocs.org/ntsb/MKC86LA062.md): Piper PA-31-325 · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Feb 21, 1986 · N111MM · Substantial damage > N111MM collided with trees during a night, circling app in IMC. The plt said he lost sight of the rwy momentarily during his turn to final. He rolled wings level and saw a tree ahead. As he rolled rt to avoid that tree his rt wing hit another tree. The acft… - [NTSB MIA86FA082](https://openairdocs.org/ntsb/MIA86FA082.md): Piper PA-44 · Panama City, FL · Accident · Minor injuries · Field investigation · Final report · Feb 21, 1986 · N2217F · Substantial damage > The air taxi flight had begun the instrument ILS approach and the pilot stated he obtained visual contact with the runway lighting system. He was starting to land when he lost all visual contact and initiated a missed approach. The aircraft then veered left… - [NTSB ATL86FA077](https://openairdocs.org/ntsb/ATL86FA077.md): Cessna 182P · Elyria, OH · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1986 · N1523M · Destroyed > The plt was cleared for and executed a rwy 17 ILS apch at night. Prior to beginning the apch he was informed that vis was 1/8 mile. Minimum for the apch was 1/2 mile. At the middle marker the plt rated pax in the right seat told the PIC that the rwy was not… - [NTSB FTW86FQG09](https://openairdocs.org/ntsb/FTW86FQG09.md): Air Tractor AT-400A · Hereford, TX · Accident · No injuries · Final report · Feb 19, 1986 · N23592 · Substantial damage > The plt reptd that as he was returning to the arpt, the eng lost power from a 'low fuel and/or rough Air' condition. Subsequently, the acft was damaged when it was landed on uneven terrain near a creek. Less than 1 gal of fuel was remaining in the acft. The… - [NTSB LAX86FA120](https://openairdocs.org/ntsb/LAX86FA120.md): Cessna 172M · Carlsbad, CA · Accident · 1 fatal · Field investigation · Final report · Feb 18, 1986 · N9253H · Substantial damage > After failing to see the runway on his first ILS approach in weather reported at IFR minimums for landing, the pilot was radar vectored for a second approach. According to controllers the approach appeared to be normal until the aircraft's radar target… - [NTSB CHI86LA090](https://openairdocs.org/ntsb/CHI86LA090.md): Cessna 402B · Rochester, MN · Accident · No injuries · Limited investigation · Final report · Feb 18, 1986 · N3940C · Substantial damage > During a ILS approach in freezing rain conditions the pilot entered a high sink rate he could not stop until ground contact. The acft touched down short of the rwy and all three landing gear collapsed. - [NTSB DEN86LA078](https://openairdocs.org/ntsb/DEN86LA078.md): Cessna 182 · Wray, CO · Accident · No injuries · Limited investigation · Final report · Feb 14, 1986 · N219M · Destroyed > According to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the… - [NTSB ATL86FA074](https://openairdocs.org/ntsb/ATL86FA074.md): Cessna 303 · Shippenville, PA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 1986 · N4877V · Destroyed > N4877V arrived over clarion county airport at about 2100 hours, and commenced a visual approach for landing. Marginal visual weather conditions prevailed at the time of the accident. The flight was observed by another pilot waiting on the ground for the… - [NTSB LAX86LA117](https://openairdocs.org/ntsb/LAX86LA117.md): Cessna 172P · Ontario, CA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1986 · N55386 · Substantial damage > The owner/plt (PIC) was on a flt for night & instrument currency requirements. He was flying the acft from the left front seat while a commercial plt (cp) was occupying the rgt front seat. Drg an ILS rwy 26L final apch at Ontario, CA, the PIC & cp discussed a… - [NTSB CHI86LA089](https://openairdocs.org/ntsb/CHI86LA089.md): Beech 95-B55 · Muncie, IN · Accident · No injuries · Limited investigation · Final report · Feb 12, 1986 · N5841S · Substantial damage > The pilot intentionally landed gear up after an electrical failure and the gear failed to extend normally. The alternator switches were found off after the accident. It was beginning to get dark with ceilings at 2200 ft. - [NTSB SEA86FA054](https://openairdocs.org/ntsb/SEA86FA054.md): Cessna 172N · Renton, WA · Accident · Serious injuries · Field investigation · Final report · Feb 9, 1986 · N738XX · Destroyed > The recently certificated private pilot was engaged in practice touch and go landings. Sometime after the second approach the throttle control rod became disconnected from the throttle cable and the pilot was unable to retard the throttle from a full power… - [NTSB DCA86IA017](https://openairdocs.org/ntsb/DCA86IA017.md): Boeing 727-223 · Harlingen, TX · Incident · No injuries · Incident investigation · Final report · Feb 8, 1986 · N871AA · Minor damage > While en route, the company dispatcher notified American flt 844 (via acars) that Harlingen (hrl) had unforecast fog & was 300' obscd with 1/2 mi vis. At 2335, as the flt bgn a dscnt fm FL 310, the same ceiling & vis were rprtd. However, as the flt was clrd… - [NTSB BFO86FA015](https://openairdocs.org/ntsb/BFO86FA015.md): Piper PA-32-260 · Lynchburg, VA · Accident · 3 fatal · Field investigation · Final report · Feb 8, 1986 · N9477C · Destroyed > The aircraft had departed elberton, Georgia at about 2043 hours on an IFR flight plan to Lynchburg, Virginia. After failing to descend out of 4000 feet during the first approach, N9477C was vectored around for a second ILS approach to runway 3. Since the… - [NTSB SEA86FA053](https://openairdocs.org/ntsb/SEA86FA053.md): Cessna 172XP · Napa, CA · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1986 · N736HV · Destroyed > Before taking off, the plt appeared to have difficulty following taxi instructions. He then took off without clearance against crossing traffic. When he returned to land, he was cleared for rgt traffic to rwy 18. The acft entered a left downwind for rwy 24… - [NTSB FTW86FRA09](https://openairdocs.org/ntsb/FTW86FRA09.md): Cessna 172P · Lake Jackson, TX · Accident · Serious injuries · Final report · Feb 3, 1986 · N52768 · Destroyed > The acft crashed during forced landing after a power loss. The acft eng quit, after a 4 hr x-country, during the lndg approach. The acft had been flown locally over an hour by another plt (crew). This made a cumulative flt time on the acft of over 5 hrs since… - [NTSB NYC86LA069](https://openairdocs.org/ntsb/NYC86LA069.md): Cessna 402 · New Bedford, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1986 · N4033Q · Destroyed > The plt experienced inadequate l eng manifold pres during a tkf attempt at newport. The tkf was aborted and afterwards the plt decided to ferry the acft to New Bedford for inspection. The eng were restarted and operation was good. The flt to New Bedford was… - [NTSB SEA86FA047](https://openairdocs.org/ntsb/SEA86FA047.md): Cessna TR182RG · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1986 · N2341S · Destroyed > The pilot was flying his Cessna TR182RG back to Reno cannon airport, a facility with a frequent mixture of light general aviation aircraft and heavy turbine air carrier operations. The pilot had acquired the majority of his terminal experience in and around… - [NTSB LAX86FUQ01](https://openairdocs.org/ntsb/LAX86FUQ01.md): Striplin Ranger · Lancaster, CA · Accident · Serious injuries · Final report · Jan 27, 1986 · N5128T · Destroyed > The acft crashed in a flat stalled attitude at a high sink rate after a power loss in an attempted go-around. The pilot had been instructed to stand-by for a go-around because of traffic. The plt continued his approach off-set to the north of the rwy, at 50… - [NTSB SEA86LA045](https://openairdocs.org/ntsb/SEA86LA045.md): Bellanca 1413-2 · Vancouver, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1986 · N74461 · Destroyed > A total loss of power occurred due to a previously burnt flex hose which blocked air from coming into the induction system. The aircraft was unable to reach the runway and struck trees before it came to rest on the roof top of a residence. - [NTSB LAX86LA096](https://openairdocs.org/ntsb/LAX86LA096.md): Luscombe 8F · Half Moon Bay, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1986 · N1507B · Substantial damage > The plt reported that on approach he was 'a little high & hot' for the 5000-FT-long rwy. He said that at midfield he was 100 ft. AGL & he decided to go around. Upon applying power only 700 RPM was obtained, so he then attempted to land the acft at the end of… - [NTSB FTW86LRG11](https://openairdocs.org/ntsb/FTW86LRG11.md): Cessna 172M · Mcallen, TX · Accident · No injuries · Final report · Jan 23, 1986 · N20889 · Substantial damage > The acft crashed into two trees during a forced landing after the eng lost pwr. The plt was in the process of lndg at an arpt when the controller asked him to make a 360 turn because of traffic and to use rwy 13 instead of 18. As the plt turned rt for a new… - [NTSB CHI86LA074](https://openairdocs.org/ntsb/CHI86LA074.md): Cessna L-19 · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Jan 23, 1986 · N48149 · Substantial damage > The pilot drained the fuel tanks until no evidence of water was present. Alcohol & 100LL was added prior to takeoff. In the traffic pattern engine power was lost. The runway was over flown & a collision with a fence insued during the forced landing. Water was… - [NTSB FTW86LA036](https://openairdocs.org/ntsb/FTW86LA036.md): Cessna 172N · Corpus Christi, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 22, 1986 · N738DC · Destroyed > The student was receiving dual instrument flt instruction. She had conducted several practice instrument apchs, all in VMC conditions. The last was an ILS to rwy 13 at Corpus Christi int'l arpt. It started in VMC conditions but entered clouds at about 550 ft.… - [NTSB FTW86LA039](https://openairdocs.org/ntsb/FTW86LA039.md): Socata MS Rallye 235C · Brenham, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 1986 · N355RA · Substantial damage > The right flap push rod experienced a progressive type failure from repeated excessive force being applied by the flap drive motor. The excessive force was caused by the flap rollers being neglected during maintenance to the extent that they became dry and… - [NTSB SEA86LA042](https://openairdocs.org/ntsb/SEA86LA042.md): Piper PA-22-108 · Ellensburg, WA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N5338Z · Substantial damage > A gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the… - [NTSB NYC86LA064](https://openairdocs.org/ntsb/NYC86LA064.md): Cessna 177RG · Farmingdale, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1986 · N34069 · Destroyed > The acft collided with trees in the bethpage state park during a rwy 14 ILS apch at republic airport, Farmingdale, NY. The plt had instructed his passenger, a private plt, to report when he had the apch lights in sight. The plt stated the apch was continued… - [NTSB ATL86LLT06](https://openairdocs.org/ntsb/ATL86LLT06.md): Piper PA-22 · Jasper, TN · Accident · Serious injuries · Final report · Jan 20, 1986 · N5904Z · Destroyed > The acft crashed into a house before striking the ground in an uncontrolled descent. The acft was approaching marion arpt for a landing when the plt lost control. The plt said that the stabilizer adjustment 'stripped'. The pilot was using the trim tab when… - [NTSB ATL86LA061](https://openairdocs.org/ntsb/ATL86LA061.md): Piper PA-23-250 · Rural Retreat, VA · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1986 · N14259 · Substantial damage > Pilot said first adf approach terminated by missed approach due to oscillating directional needle. On second approach acft broke out of clouds with trees in front of acft. It impacted a cloud obscured ridge 3.5 miles southeast of airport on a southerly… - [NTSB ATL86LA060](https://openairdocs.org/ntsb/ATL86LA060.md): Cessna 182Q · Carthage, MS · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N973JM · Substantial damage > While on final approach for landing the pilot advanced the throttle to adjust his final approach path and the engine lost power. The aircraft impacted the ground short of the runway and flipped inverted. The engine was later test run and performed to… - [NTSB DCA86AA014](https://openairdocs.org/ntsb/DCA86AA014.md): Boeing 727-225 · Loudon County, VA · Accident · No injuries · Final report · Jan 17, 1986 · N802EA · Substantial damage > The rt main lndg gear would not extend for lndg at wash natl arpt. The lndg was aborted and the crew attempted to correct the situation but were unsuccessful. An emergency gear-up lndg was made at dulles internatl arpt. The crew and passg evacuated without… - [NTSB CHI86LA069](https://openairdocs.org/ntsb/CHI86LA069.md): Beech BE-90C · Canton, OH · Accident · No injuries · Limited investigation · Final report · Jan 17, 1986 · N68PC · Substantial damage > After making a coupled ILS approach to 300 feet, the pilot stated he could not disconnect or override the autopilot. He subsequently landed hard and bounced, snapping the nose gear off. The aircraft came to rest on its nose with both propellers contacting the… - [NTSB SEA86FYA01](https://openairdocs.org/ntsb/SEA86FYA01.md): World Wide Industries Spit Fire #2 · Caldwell, ID · Accident · Serious injuries · Final report · Jan 15, 1986 · UNREG · Substantial damage > The pilot of this ultralight said there was a loss of engine RPM. The aircraft was then damaged during an off airport landing. The pilot was not injured but the passenger received serious injuries. This ultralight aircraft did not meet the criteria for… - [NTSB ATL86LA056](https://openairdocs.org/ntsb/ATL86LA056.md): Cessna 152 · Conway, SC · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1986 · N6235Q · Destroyed > During night flight instruction for takeoff and landing practice, the aircraft collided with trees off the approach end of the runway and impacted the ground 800 feet short of the runway. The runway had been recently extended and the trees off the end of the… - [NTSB ATL86FMG03](https://openairdocs.org/ntsb/ATL86FMG03.md): Cessna 441 · West Columbia, SC · Accident · Minor injuries · Final report · Jan 15, 1986 · N441CD · Destroyed > During final approach the plt noticed acft flying 'unusual' and elected go-around. During power-up, the acft lost power and a forced landing was made on a residential street near the arpt. The plt stated that he had inadvertenly placed the fuel selector in… - [NTSB SEA86LA037](https://openairdocs.org/ntsb/SEA86LA037.md): Cessna 150-L · Gig Harbor, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 11, 1986 · N6989G · Destroyed > A total loss of power occurred due to fuel exhaustion while in an extended traffic pattern due to landing traffic. An inadvertent stall occurred prior to touchdown. The left wing struck a pile of dirt which spun the aircraft around. The landing was… - [NTSB LAX86LA088](https://openairdocs.org/ntsb/LAX86LA088.md): Cessna 172N · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 11, 1986 · N733ZF · Substantial damage > The acft contacted trees and a building during a forced landing following a power loss while on final apch to land. Post accident inspection revealed a failure of the throttle cable housing at the swaged ball joint near the carburetor. This failure allowed… - [NTSB LAX86LA086](https://openairdocs.org/ntsb/LAX86LA086.md): Taylorcraft BC12-D · Buckeye, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 1986 · N95009 · Substantial damage > While on a personal flight to a privately owned airstrip, the acft collided with wires located at the west end of the airstrip while on final approach to runway 08. The pilot initially reported that he had misjudged the aircraft height and collided with the… - [NTSB DEN86MA061](https://openairdocs.org/ntsb/DEN86MA061.md): Cessna 425 · Granby, CO · Accident · 5 fatal · Major investigation · Final report · Jan 11, 1986 · N425SC · Destroyed > Drg arrival, the plt advised ARTCC that the destination arpt appeared to be covered with fog. She then canceled her IFR flt plan. According to ground witnesses, the acft made several passes over the arpt. Witnesses also rprtd that the horizontal visibility… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=188 ## 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=187 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.