# NTSB investigations: Landing 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 410 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DEN86LA220](https://openairdocs.org/ntsb/DEN86LA220.md): Grumman G-164A · Center, CO · Accident · No injuries · Limited investigation · Final report · Aug 5, 1986 · N5324 · Substantial damage > The plt reported that he was landing on a 50 ft wide dirt strip and allowed the acft to drift to the left during the landing roll. The left wing collided with wheat growing along the left side of the strip and the acft swerved further to the left. During the… - [NTSB DEN86LA218](https://openairdocs.org/ntsb/DEN86LA218.md): Cessna 172P · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 5, 1986 · N55297 · Substantial damage > According to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a… - [NTSB CHI86FA199](https://openairdocs.org/ntsb/CHI86FA199.md): Cessna 177 · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Aug 5, 1986 · N17204 · 2 aircraft · Substantial damage > A spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to… - [NTSB SEA86LA191](https://openairdocs.org/ntsb/SEA86LA191.md): Cessna T210 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Aug 4, 1986 · N139BB · Substantial damage > During landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was… - [NTSB NYC86LA197](https://openairdocs.org/ntsb/NYC86LA197.md): Cessna 152 · Harrisburg, PA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1986 · N93454 · Substantial damage > The student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then… - [NTSB ANC86LA121](https://openairdocs.org/ntsb/ANC86LA121.md): Cessna U206 · Egegik, AK · Accident · No injuries · Limited investigation · Final report · Aug 4, 1986 · N9188M · Substantial damage > The pilot stated that during the landing rollout on the gravel bar he lost control of the aircraft causing the plane to nose over on its back. - [NTSB SEA86LA189](https://openairdocs.org/ntsb/SEA86LA189.md): Luscombe 8A · Rosalia, WA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N1886B · Substantial damage > During climb out the acft entered a departure stall. The acfts left wing dropped and the acft came to rest 90 degrees from its departure heading. This acft has no stall warning system. - [NTSB LAX86LA316](https://openairdocs.org/ntsb/LAX86LA316.md): Schweizer SGS-1-35 · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N34180 · Substantial damage > A Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose… - [NTSB CHI86LA196](https://openairdocs.org/ntsb/CHI86LA196.md): Piper PA-20-115 · Mosinee, WI · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · CGHGF · Substantial damage > Following departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg… - [NTSB SEA86LA190](https://openairdocs.org/ntsb/SEA86LA190.md): Cessna T210L · Elko, NV · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N5118Q · Substantial damage > During landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the… - [NTSB MIA86LA225](https://openairdocs.org/ntsb/MIA86LA225.md): Piper PA-24-250 · Crestview, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N7992P · Substantial damage > While on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was… - [NTSB MIA86LA223](https://openairdocs.org/ntsb/MIA86LA223.md): Beech J35 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N57UT · Substantial damage > The plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment. - [NTSB LAX86FVD09](https://openairdocs.org/ntsb/LAX86FVD09.md): Jaks Volksplane VP-2 · Ukiah, CA · Accident · No injuries · Final report · Aug 2, 1986 · N3CJ · Substantial damage > At the end of a local flight, during the landing roll, the plt was distracted and allowed the acft to veer to the right side of the rwy. The plt applied the brakes when the left main landing gear collapsed. - [NTSB CHI86FA191](https://openairdocs.org/ntsb/CHI86FA191.md): Hawker Siddeley DH-125-1A · Bedford, IN · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1986 · N50HH · Destroyed > The plt canceled IFR 8 miles from the arpt to continue on a visual apch and landing. Witnesses stated a strong thunderstorm had just passed over the arpt. Wind info issued to the plt by UNICOM were west at 20 KTS. Witnesses observed the acft apch rwy 31 and… - [NTSB ATL86LA215](https://openairdocs.org/ntsb/ATL86LA215.md): Maule M-7-235 · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Aug 2, 1986 · N56616 · Substantial damage > The plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down… - [NTSB LAX86LA310](https://openairdocs.org/ntsb/LAX86LA310.md): Cessna 140 · Oroville, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1986 · N77326 · Substantial damage > A Cessna 140 nosed over in a ditch after aborting a takeoff. The plt indicated he was practicing stop and go landings. During the last landing the right brake was inadvertently applied and the acft veered to the right off the rwy. The plt initiated a… - [NTSB ATL86LA214](https://openairdocs.org/ntsb/ATL86LA214.md): Cessna 150F · Lenoir, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1986 · N8757G · Substantial damage > The student plt was executing full stop landings then making a take off after each landing. He was attempting his fourth landing when the acft bounced, he applied power to try to regain control of the acft. The nose gear collapsed upon touch down, the strut… - [NTSB DEN86LA217](https://openairdocs.org/ntsb/DEN86LA217.md): Piper PA-28-181 · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Jul 30, 1986 · N8272Y · Substantial damage > The plt was landing on a 3100 ft dirt rwy, at an arpt with mtns nearby. He said that just before landing, the acft encountered a downdraft at about 100 ft AGL & 'the bottom fell out.' Subsequently, the acft landed hard & the rgt main lndg gear failed. There… - [NTSB CHI86LA190](https://openairdocs.org/ntsb/CHI86LA190.md): Beech B-19 · Manchester, MI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1986 · N6517R · Substantial damage > The pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown. - [NTSB ANC86LA117](https://openairdocs.org/ntsb/ANC86LA117.md): Cessna 185E · Tetlin, AK · Accident · No injuries · Limited investigation · Final report · Jul 30, 1986 · N1613M · Substantial damage > Acft left rwy and crashed during attempted go-around with 10 to 25 knot crosswind. Pilot stated that engine did not develop full power. Examination and test run of engine did not reveal any mechanical failures/malfunctions. - [NTSB SEA86LA183](https://openairdocs.org/ntsb/SEA86LA183.md): Cessna 182 · East Sound, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 29, 1986 · N71131 · Substantial damage > During landing roll at about 25 mph the pilot applied both brakes. A short time thereafter the right brake pedal went to the floor. Despite the pilot's application of hard left brake and rudder, the acft veered to the left into a drainage ditch. The nose gear… - [NTSB FTW86LA140](https://openairdocs.org/ntsb/FTW86LA140.md): American AA-1 · Roanoke, TX · Accident · No injuries · Limited investigation · Final report · Jul 29, 1986 · N5753L · Destroyed > The pilot took off during darkness on an early morning flt & arrived at the destn arpt prior to sunrise. He was unable to activate the rwy lights, but since the ground features could be seen, he elected to land. During the landing, the acft touched down… - [NTSB NYC86LA192](https://openairdocs.org/ntsb/NYC86LA192.md): Maule M-5-235 · Wolfeboro, NH · Accident · No injuries · Limited investigation · Final report · Jul 28, 1986 · N396X · Substantial damage > While landing, the aircraft bounced slightly & the plt lost directional control. The aircraft veered left over the runway edge onto a soft shoulder, nosed over & was damaged. - [NTSB LAX86LA306](https://openairdocs.org/ntsb/LAX86LA306.md): Cessna 195 · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1986 · N3899V · Substantial damage > The aircraft owner stated that the purpose of the flight was to obtain 5 hours of transition training in the tail dragger and accomplish a bfr. After departure the CFI had the pilot perform airwork maneuvers enroute to the Ramona area. The pilot said that a… - [NTSB MIA86LA220](https://openairdocs.org/ntsb/MIA86LA220.md): Cessna T337H · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N1343L · Substantial damage > Witnesses reported the pilot arrived for the flight carrying a glass from a local bar, was uncoordinated and appeared intoxicated. After much difficulty in taxiing to the runway, he finally took off. On arrival at Marathon, FL, the pilot failed to extend the… - [NTSB FTW86FPA25](https://openairdocs.org/ntsb/FTW86FPA25.md): Thorpe T18 · Mckinney, TX · Accident · No injuries · Final report · Jul 27, 1986 · N7JA · Substantial damage > The acft was landed on a closed rwy where it collided with steel posts embedded in the rwy. The plt had questioned a Cessna plt who made a go-around in front of him about the status of the rwy and wad advised it was closed. The plt saw the flag & an 'x' but… - [NTSB CHI86LA188](https://openairdocs.org/ntsb/CHI86LA188.md): Bellanca 17-30 · Winneconne, WI · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N4865V · Substantial damage > While landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed. - [NTSB CHI86LA184](https://openairdocs.org/ntsb/CHI86LA184.md): Piper PA-28-181 · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · Jul 27, 1986 · N2185B · Substantial damage > While flaring to land, the aircraft had excessive speed and ballooned. Subsequently, it bounced twice, then began to veer to the left. The pilot performed a go-around. During the initial portion of the go-around, the left wing struck a runway edge identifier… - [NTSB FTW86LA139](https://openairdocs.org/ntsb/FTW86LA139.md): Cessna 182A · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1986 · N5088D · Substantial damage > The pilot touched down long but with adequate runway remaining. However, he delayed brake application and as a result was still going too fast to turn off at the end of the runway. Collision with the runway end barrier occurred. - [NTSB CHI86LA182](https://openairdocs.org/ntsb/CHI86LA182.md): Piper PA-28-161 · Dodgeville, WI · Accident · No injuries · Limited investigation · Final report · Jul 26, 1986 · N80510 · Substantial damage > According to the pilot, his brakes failed and he was unable to stop before going off the end of the runway and over a 30 foot embankment. During an inspection, the brakes and braking system were found to be free of any defects and in proper working order.… - [NTSB LAX86FVG06](https://openairdocs.org/ntsb/LAX86FVG06.md): Amateur Built Barnett J3 · Yuba City, CA · Accident · No injuries · Final report · Jul 25, 1986 · N504P · Substantial damage > The landing accident occurred after the pilot had made high speed taxi tests along the runway with three liftoffs. After the third liftoff, the pilot said that he found himself too high. He stated that he reduced power and pushed forward on the control stick.… - [NTSB CHI86LA187](https://openairdocs.org/ntsb/CHI86LA187.md): Piper PA-31T1 · Charlevoix, MI · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N2317V · Substantial damage > According to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot… - [NTSB ATL86LA211](https://openairdocs.org/ntsb/ATL86LA211.md): Piper PA-28-180 · Sandusky, OH · Accident · No injuries · Limited investigation · Final report · Jul 25, 1986 · N9011J · Substantial damage > The pilot reported that he diverted and landed to reassess the weather before continuing his flight. He said the wind was from the southwest at eight KTS. Just before touchdown on runway 27, the aircraft yawed left and landed while in a crab. The airplane… - [NTSB MKC86LA161](https://openairdocs.org/ntsb/MKC86LA161.md): Grumman G-164B · Lewisville, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1986 · N6997K · Substantial damage > The PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft. - [NTSB DEN86LA206](https://openairdocs.org/ntsb/DEN86LA206.md): Troutman Quickie Q2 · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Jul 24, 1986 · N21LT · Substantial damage > The plt, flying a homebuilt quickie Q2, attempted a ldg on rwy 22 with winds of 20K, gusting to 30K out of 250 degrees. After touchdown the acft weather vaned into the wind. The acft left the rwy, flipped over and was substantially damaged. - [NTSB ATL86LA209](https://openairdocs.org/ntsb/ATL86LA209.md): Champion 7E6A · Alliance, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1986 · N982G · Substantial damage > During the second landing attempt, the pilot lost directional control and ground looped. The aircraft was substantially damaged and the pilot received minor injuries. The pilot did not report any aircraft problems. The pilot had completed a student pilot solo… - [NTSB NYC86LA195](https://openairdocs.org/ntsb/NYC86LA195.md): Beech A24R · Tunkhannock, PA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1986 · N1RJ · Substantial damage > During a landing in calm wind conditions, the acft bounced, became airborne again & touched down further down the 2000' rwy. The plt applied brakes & 'dumped' the flaps for max braking, but to no avail. The acft slid off the grass rwy & subsequently went over… - [NTSB NYC86LA194](https://openairdocs.org/ntsb/NYC86LA194.md): Cessna 172 M · Olcott, NY · Accident · No injuries · Limited investigation · Final report · Jul 23, 1986 · N9263H · Substantial damage > The pilot flying a Cessna 172M with three passengers on board made a landing on a 2500 ft grass runway. This was his first landing on a grass runway. He touched down fast and became airborne, recovered, and became airborne again. His airspeed was too slow to… - [NTSB LAX86LA300](https://openairdocs.org/ntsb/LAX86LA300.md): Taylorcraft 19 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N43876 · Substantial damage > The plt applied the brakes heavily during the landing roll. As the aircraft slowed to approximately 5 mph it nosed over on its back. - [NTSB CHI86LA177](https://openairdocs.org/ntsb/CHI86LA177.md): Cessna 150 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N63069 · Substantial damage > The student plt had been practicing touch and go landings for aprx 1 hour. On the accident landing, the acft veered to the left. The plt overcorrected and the acft began to travel off the right side of the rwy. While attempting a go-around the acft's wing… - [NTSB LAX86FA297](https://openairdocs.org/ntsb/LAX86FA297.md): Piper PA-18-150 · Corona, CA · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1986 · N83380 · Destroyed > The pilot stated to fire personnel that as he approached touchdown, the sun got in his eyes and a cross wind pushed him off the right side of his private airstrip. The aircraft landed hard on the right wheel, veered off the right side of the runway,… - [NTSB CHI86LA176](https://openairdocs.org/ntsb/CHI86LA176.md): Cessna 150 · Allegan, MI · Accident · No injuries · Limited investigation · Final report · Jul 21, 1986 · N6768F · Substantial damage > Grass steip measures 1800 feet by 45 feet. Seven-foot tall corn stalks surround both sides of airstrip. The aircraft veered off center, to the left, during touchdown. Left wing contacted corn stalks, causing aircraft to cartwheel. - [NTSB FTW86LA136](https://openairdocs.org/ntsb/FTW86LA136.md): Cessna 305C · Stamford, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1986 · N4493H · Substantial damage > The pilot was receiving instruction on touch and go landings, in a tail wheel equipped aircraft, when he lost control on touchdown and ground looped the aircraft. The instructor was late with corrective action. - [NTSB ANC86FA111](https://openairdocs.org/ntsb/ANC86FA111.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jul 20, 1986 · N7156Z · Substantial damage > The acft was not properly aligned with the rwy during landing touchdown. The acft touched down in a crab attitude. It then ground looped and came to rest on the left wing tip and nose. - [NTSB SEA86LA175](https://openairdocs.org/ntsb/SEA86LA175.md): Cessna 152 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Jul 19, 1986 · N68723 · Substantial damage > Student pilot, with about 2 hours solo time, was making touch and go's. during the last landing the aircraft was observed to make several bouncing contacts with the runway before the nose gear collapsed. - [NTSB DEN86LA202](https://openairdocs.org/ntsb/DEN86LA202.md): Piper PA-38-112 · Minot, ND · Accident · No injuries · Limited investigation · Final report · Jul 19, 1986 · N2355A · Substantial damage > According to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went… - [NTSB CHI86FEP06](https://openairdocs.org/ntsb/CHI86FEP06.md): Patton Pitts S-1C · Hartford, WI · Accident · No injuries · Final report · Jul 19, 1986 · N3507 · Substantial damage > The plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off… - [NTSB FTW86LA131](https://openairdocs.org/ntsb/FTW86LA131.md): Beech B-100 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N6354H · Substantial damage > The pilot was unable to get a green light for the left main gear prior to landing and finally had to make an emergency landing on the nose and right main gear. The aircraft was substantially damaged when it veered off the runway on the landing roll out.… - [NTSB ATL86LA198](https://openairdocs.org/ntsb/ATL86LA198.md): Beech A23-24 · Lake City, SC · Accident · No injuries · Limited investigation · Final report · Jul 18, 1986 · N6116N · Substantial damage > During landing roll the pilot noticed that the aircraft began to veer off the runway. He initiated a go-around in order to assess the problem. It was determined that the nose wheel had malfunctioned. During the landing roll the aircraft veered off the runway… - [NTSB MIA86LA212](https://openairdocs.org/ntsb/MIA86LA212.md): Piper PA-44-180 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1986 · N257ER · Substantial damage > The plt stated that on final approach he forgot to put the landing gear down. He then landed gear up, & the acft slid to a stop. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=411 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=410 --- 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.