# NTSB investigations: Taxi 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 44 of 128 · 6,398 cases ## Cases, newest first - [NTSB LAX86LA284](https://openairdocs.org/ntsb/LAX86LA284.md): Cessna 172P · Los Angeles, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1986 · N54203 · Substantial damage > The private plt had no prior experience at the Los Angeles intl. Arpt. & the plt was unknowledgeable of the existence of arpt motor vehicle traffic service roads. The plt was given an ATC clearance to taxi, & in the darkness the plt mistook a service road for… - [NTSB NYC86FHD01](https://openairdocs.org/ntsb/NYC86FHD01.md): Piasecki Acft. Helistat 97-34J · Lakehurst, NJ · Accident · 1 fatal · Final report · Jul 2, 1986 · N1897Z · Destroyed > The helistat, a hybrid a/c with 4 H-34 main fuselages attached to a frame along with a ZPG-2 helium filled envelope had just completed it first hover test flt successfully and landed. A pwr loss was noted on the no. 3 helicopter and the test was terminated… - [NTSB MKC86LA146](https://openairdocs.org/ntsb/MKC86LA146.md): Cessna T303 · Lake Ozark, MO · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N9571C · Substantial damage > The plt stated that the flt was uneventful until after landing when somebody instructed him, over the common traffic advisory frequency on his VHF radio, to park the acft at a new parking area, and he complied. This parking area was congested with extra acft… - [NTSB FTW86LA120](https://openairdocs.org/ntsb/FTW86LA120.md): Beech E18S · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N2001C · 2 aircraft · Minor damage > A swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.… - [NTSB ANC86LA086](https://openairdocs.org/ntsb/ANC86LA086.md): de Havilland DHC-2 · Bulchitna Lake, AK · Accident · No injuries · Limited investigation · Final report · Jun 23, 1986 · N67686 · Substantial damage > The airplane struck a wingtip on the water while step taxiing downwind attempting a left turn. - [NTSB CHI86FEP05](https://openairdocs.org/ntsb/CHI86FEP05.md): Beech C-23 · Milwaukee, WI · Accident · No injuries · Final report · Jun 18, 1986 · N66345 · Substantial damage > During taxi for takeoff the plt inadvertently taxied onto an access road and struck and unlit sign. The taxiway had been resurfaced and no taxi guide lines had been repainted. - [NTSB SEA86LA151](https://openairdocs.org/ntsb/SEA86LA151.md): Navion A · Boise, ID · Accident · No injuries · Limited investigation · Final report · Jun 13, 1986 · N5208N · Substantial damage > The pilot elected to land onto a road to pick up a passenger. The pilot failed to maintain adequate clearance from a wire fence to the right of the road and caught the right wing. - [NTSB ANC86LA068](https://openairdocs.org/ntsb/ANC86LA068.md): Aeronca 15 AC Sedan · Neal Lake, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 1986 · N1450H · Substantial damage > According to the pilot-in-command, while step taxiing for takeoff the airplane became airborne inadvertently with insufficient room to takeoff or turn. The pilot-in--command stated he closed the throttle and the airplane touched down on the lake. He was… - [NTSB DEN86LA156](https://openairdocs.org/ntsb/DEN86LA156.md): Cessna 180 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jun 6, 1986 · N3253D · Substantial damage > The student plt flew from alliance to Cheyenne on his solo x-country and flew locally at Cheyenne to make 3 landings at a twr controlled arpt. While he was in the pattern a cumulonimbus cloud moved into the vicinity of the arpt and the winds became gusty.… - [NTSB MKC86LA125](https://openairdocs.org/ntsb/MKC86LA125.md): Cessna 150L · Nevada, IA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1986 · N11753 · Substantial damage > Witnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes… - [NTSB ANC86LA064](https://openairdocs.org/ntsb/ANC86LA064.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · May 30, 1986 · N8519Y · Substantial damage > While high speed taxiing on a runway in gusting wind conditions, the pilot lost control of his airplane and it veered into a parked airplane adjacent to the runway. The pilot reported the wind was from 130 degrees at 15 gusting 25 knots. - [NTSB MIA86LA158](https://openairdocs.org/ntsb/MIA86LA158.md): Cessna 182A · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N6155B · Substantial damage > The plt stated that as he was taxiing the acft from landing, the nose gear became stuck in soft dirt. The propeller then struck the ground and the acft nosed over. - [NTSB DEN86LA134](https://openairdocs.org/ntsb/DEN86LA134.md): Cessna 172H · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · May 14, 1986 · N3749R · Substantial damage > The plt reported that after landing on rwy 24 he was back taxiing on rwy 06 when he encountered strong, gusty surface winds. He said he stopped and was looking for a place to tie down when a strong gust flipped the acft onto its back. Surface wind at the time… - [NTSB FTW86LA080](https://openairdocs.org/ntsb/FTW86LA080.md): Cessna 172M · Dallas, TX · Accident · No injuries · Limited investigation · Final report · May 3, 1986 · N13731 · Substantial damage > The pilot collided with a fence while taxiing on an airport access road, which he had mistaken for the taxiway. Although the pilot should have exercised better judgement, it has been determined that this same type of mishap has occurred before. After a… - [NTSB ANC86LA053](https://openairdocs.org/ntsb/ANC86LA053.md): Cessna 185 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N9706H · Substantial damage > The pilot stated that he was taxiing for takeoff on the frozen river when the left main gear broke through the ice. The aircraft's left wing and left gear were damaged. - [NTSB CHI86IA121](https://openairdocs.org/ntsb/CHI86IA121.md): Boeing 727-231 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Apr 17, 1986 · N64324 · No damage > While taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her… - [NTSB MIA86LA122](https://openairdocs.org/ntsb/MIA86LA122.md): Cessna 172M · Borinquen, PR · Accident · No injuries · Limited investigation · Final report · Apr 16, 1986 · N9194H · Substantial damage > The plt stated that after completing a local flt he landed on the rwy and noticed that the taxiway lights were inoperative where he wished to taxi. When he taxied off the rwy the propeller and landing gear struck a concrete culvert that was resting next to an… - [NTSB MIA86LA120](https://openairdocs.org/ntsb/MIA86LA120.md): Cessna T303 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N212ER · Substantial damage > While on a dual instructional flight both instructor and the student pilot noted a left brake failure on taxi to takeoff. The instructor attempted to utilize asymmetric power to steer the aircraft but could not control the turn. The aircraft ran off the edge… - [NTSB MKC86LA089](https://openairdocs.org/ntsb/MKC86LA089.md): Aerotek Pitts S-2A · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N51WJ · Substantial damage > The plt stated that after landing on rwy 28 the left gear folded while taxiing. The acft then fell onto its left wing. The plt reported the gear collapsed without warning. Examination of the gear support found a joint which was cold welded had failed. - [NTSB LAX86LA171](https://openairdocs.org/ntsb/LAX86LA171.md): Cessna 172D · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N2762U · Substantial damage > The acft wing struck a tree during taxi on a dirt road being used for takeoff. The CFI said that he did not make a survey to identify obstructions before the taxi for takeoff. The acft had landed on the road when the CFI could not regain eng power following a… - [NTSB FTW86LA055](https://openairdocs.org/ntsb/FTW86LA055.md): Cessna 172H · Bristow, OK · Accident · No injuries · Limited investigation · Final report · Mar 31, 1986 · N2826L · Substantial damage > The pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured. - [NTSB DEN86LA106](https://openairdocs.org/ntsb/DEN86LA106.md): Cessna 150J · Tioga, ND · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1986 · N51156 · Substantial damage > The plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was… - [NTSB NYC86IA093](https://openairdocs.org/ntsb/NYC86IA093.md): Boeing 727-231 · Boston, MA · Incident · Minor injuries · Incident investigation · Final report · Mar 27, 1986 · N52311 · No damage > Two of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft… - [NTSB ATL86FLT05](https://openairdocs.org/ntsb/ATL86FLT05.md): Piper PA-14 · Memphis, TN · Accident · No injuries · Final report · Mar 21, 1986 · N4276H · Substantial damage > The acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started… - [NTSB NYC86LA091](https://openairdocs.org/ntsb/NYC86LA091.md): Cessna 140 · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1986 · N2643N · Substantial damage > While taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over. - [NTSB LAX86LA141](https://openairdocs.org/ntsb/LAX86LA141.md): Cessna 172N · Apple Valley, CA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1986 · N739GB · Substantial damage > A Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had… - [NTSB MKC86LA066](https://openairdocs.org/ntsb/MKC86LA066.md): Ercoupe 415-C · Versailles, MO · Accident · No injuries · Limited investigation · Final report · Mar 9, 1986 · N3673H · Substantial damage > The plt reports that he was hand propping the eng. He said the eng did not start on the first attempt and he primed it a second time. On the second try the eng started and the acft got away from the plt, taxied about 75 ft and collided with trees. The plt… - [NTSB MIA86LA092](https://openairdocs.org/ntsb/MIA86LA092.md): Cessna 210J · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Mar 7, 1986 · N77WG · Substantial damage > The plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed. - [NTSB NYC86FA076](https://openairdocs.org/ntsb/NYC86FA076.md): Lockheed L-1011-385-1 · Jamaica, NY · Accident · Serious injuries · Field investigation · Final report · Feb 15, 1986 · N309EA · No damage > The no. 3 eng torched during a start attempt and resulted in a internal eng tailcone fire. Several paxs panicked upon seeing the torch flame/tailcone fire and between 30 to 50 paxs made an unauthorized evacuation of the acft via the L3 and L4 exits. Paxs… - [NTSB NYC86LA074](https://openairdocs.org/ntsb/NYC86LA074.md): Universal Aircraft Industries GC-1B · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Feb 12, 1986 · N80827 · 2 aircraft · Substantial damage > A Piper acft was standing in the runup area that is adjacent to taxiway A5. The plt of the globe acft taxied into the runup area and because the sun was in his eyes and the Piper was in his blind spot he ran into the Piper. - [NTSB CHI86LA085](https://openairdocs.org/ntsb/CHI86LA085.md): Cessna 401B · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Feb 9, 1986 · N777CS · Substantial damage > While taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated… - [NTSB NYC86LA070](https://openairdocs.org/ntsb/NYC86LA070.md): Piper PA-42-720 · Rochester, NY · Accident · No injuries · Limited investigation · Final report · Feb 3, 1986 · N777YP · Substantial damage > Piper aircraft collided with a parked Cessna aircraft while maneuvering into a parking space at Rochester-monroe airport after landing. The ramp was reported to be ice covered and sanded. - [NTSB MIA86LA068](https://openairdocs.org/ntsb/MIA86LA068.md): Aerospatiale 350-B · Las Piedras, PR · Accident · No injuries · Limited investigation · Final report · Jan 31, 1986 · N513HC · Substantial damage > Pilot stated that while flaring to enter a hover to reverse direction for takeoff the tail rotor guard struck the ground and separated. The helicopter was nosed over forward and as it was flared a second time the tail rotor struck the ground causing loss of… - [NTSB SEA86LA049](https://openairdocs.org/ntsb/SEA86LA049.md): de Havilland DHC-2 · Metlakatla, AK · Accident · No injuries · Limited investigation · Final report · Jan 30, 1986 · N127WA · 2 aircraft · Substantial damage > Wind was 070 degrees at 20 KTS with 6-12 inch sweels. N127WA was positioned at north side of dock for departure toward east. N1018H was holding at east side of dock. Deck hand cast off N127WA before plt started engine; acft began to drift back into dock. Plt… - [NTSB MKC86LA057](https://openairdocs.org/ntsb/MKC86LA057.md): Cessna 310R · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Jan 26, 1986 · N1905G · Substantial damage > The airplane was being taxied toward a parking spot in front of a hangar and the right brake failed and the left wing contacted the front of the hangar. - [NTSB MIA86LA061](https://openairdocs.org/ntsb/MIA86LA061.md): Piper PA-38-112 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N2361D · 2 aircraft · Substantial damage > The plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D. - [NTSB MKC86LA050](https://openairdocs.org/ntsb/MKC86LA050.md): Cessna 172 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Jan 12, 1986 · N8036B · Substantial damage > N8036B diverted to Des Moines for fuel after encountering strong head winds enroute. After landing on rwy 30R the plt turned off the rwy onto a taxiway that runs to the north. The plt then stopped to change radio frequencies. While the acft was stopped a… - [NTSB CHI86LA061](https://openairdocs.org/ntsb/CHI86LA061.md): Piper PA-22-150 · Mount Gilead, OH · Accident · No injuries · Limited investigation · Final report · Jan 11, 1986 · N3003Z · Substantial damage > According to the arpt manager, the plt was taxiing down the active in gusty wind conditions at a fairly rapid rate of speed. As the plt turned into the run-up pad area the acft nosed over. - [NTSB MKC86LA043](https://openairdocs.org/ntsb/MKC86LA043.md): Cessna 172N · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Jan 2, 1986 · N733NF · Substantial damage > The pilot had been at this airport 31 times since 1979. During his taxi to takeoff for a night flight, he mistook a service road for a taxiway. He taxied past one sign without seeing it but struck the second one. This is the third documented accident at this… - [NTSB DEN86LA048](https://openairdocs.org/ntsb/DEN86LA048.md): Cessna TU-206G · Denver, CO · Accident · No injuries · Limited investigation · Final report · Dec 18, 1985 · N7418N · Substantial damage > While gnd taxiing to a general aviation terminal after ldg, the pilot taxied behind and turned downwind into jet thrust from a B737 acft as it was being taxied from a passenger terminal enroute to rwy for takeoff. The acft was blown onto its nose and right… - [NTSB LAX86LA101](https://openairdocs.org/ntsb/LAX86LA101.md): Cessna 152 · Upland, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1985 · N64851 · Substantial damage > On December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was… - [NTSB DEN86LA047](https://openairdocs.org/ntsb/DEN86LA047.md): Piper PA-28R-201T · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Dec 8, 1985 · N37550 · Substantial damage > According to the plt, the right wing struck a fence while diverting off the taxiway centerline to make room for another oncoming acft. Contact with the fence resulted in a bent spar in the right wing. - [NTSB CHI86LA050](https://openairdocs.org/ntsb/CHI86LA050.md): Cessna 172RG · East Liverpool, OH · Accident · No injuries · Limited investigation · Final report · Dec 3, 1985 · N6208V · Substantial damage > According to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The… - [NTSB CHI86IA037](https://openairdocs.org/ntsb/CHI86IA037.md): Embraer EMB-110P1 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Dec 2, 1985 · N90427 · Minor damage > The acft suffered a failure of the left rear axle during taxi to takeoff. - [NTSB CHI86FA036](https://openairdocs.org/ntsb/CHI86FA036.md): Cessna 404 II · Chicago, IL · Accident · No injuries · Field investigation · Final report · Nov 29, 1985 · N167SA · Substantial damage > The tug driver with baggage cart failed to yield to a taxiing acft when crossing an active taxiway. It was dark nite. Acft had position/taxi lites on. Vehicle stop sign to taxi centerline is 70 ft. driver said he stopped at sign. Tug struck rt wg tip, wg… - [NTSB LAX86LA055](https://openairdocs.org/ntsb/LAX86LA055.md): Piper PA-32-300 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Nov 28, 1985 · N32998 · Substantial damage > After completing a nighttime business flight, the plt landed and taxied to parking. Enroute the plt attempted to taxi between two hangars and around a wash rack. The acft collided with an unmarked curb adjacent to the wash rack and the gear collapsed bending… - [NTSB DEN86LA032](https://openairdocs.org/ntsb/DEN86LA032.md): Piper PA-31-310 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Nov 26, 1985 · N537NB · Substantial damage > The plt stated that during the ground taxi after landing, the right main gear collapsed. During the investigation, it was determined the down lock mechanism was not engaged. Upon examination, it was determined that the main gear lock activator rod was… - [NTSB DEN86LA024](https://openairdocs.org/ntsb/DEN86LA024.md): Champion 7KCAB · Berthoud, CO · Accident · No injuries · Limited investigation · Final report · Nov 17, 1985 · N1832G · Substantial damage > The plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt… - [NTSB MIA86IA022](https://openairdocs.org/ntsb/MIA86IA022.md): Cessna 402B · St. Thomas · Incident · No injuries · Incident investigation · Final report · Oct 28, 1985 · N98685 · Minor damage > After landing the pilot made a 270 degree left turn to entera taxiway. After completion of the turn the left main landing gear began to wobble and then collapsed outwardinspection of the aircraft revealed that of six bolts which attach the left gear support… - [NTSB LAX86LA020](https://openairdocs.org/ntsb/LAX86LA020.md): Piper PA28-181 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1985 · N2491Y · Substantial damage > The plt said that after landing and turning onto the parallel taxiway, the engine quit. During an attempted re-start, fire was noticed coming from the engine compartment. The plt and his passenger evacuated the acft, and arpt personnel put out the fire. The… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=45 ## 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 = 250) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/250/cases?page=44 --- 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.