# 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 45 of 128 · 6,398 cases ## Cases, newest first - [NTSB LAX86LA019](https://openairdocs.org/ntsb/LAX86LA019.md): Beech 24R · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1985 · N9323S · Substantial damage > The acft collided with a ditch during taxi to takeoff. The plt was taxiing into the sun and went into the ditch when the taxiway turned to the rt. The plt said he was blinded by the rising sun. - [NTSB MKC86LA005](https://openairdocs.org/ntsb/MKC86LA005.md): Cessna 172N · Salina, KS · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N1587E · Substantial damage > The pilot did not top off the fuel tanks before departing lincoln, NE for pratt, KS. Enroute winds necessitated a fuel stop at Salina, KS. These same winds flipped over the airplane as it was turning off the runway to taxi in. - [NTSB MIA85LA257](https://openairdocs.org/ntsb/MIA85LA257.md): Piper PA-24-260 · Leesburg, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 1985 · N9213P · Substantial damage > The pilot stated he was taxiing on a smooth asphalt taxiway in preparation for takeoff when the landing gear collapsed. A post- accident examination of landing gear failed to reveal any malfunction or failure that would have precluded normal operation of the… - [NTSB ANC85LA174](https://openairdocs.org/ntsb/ANC85LA174.md): Cessna C-206 · Big River, AK · Accident · No injuries · Limited investigation · Final report · Sep 10, 1985 · N9963M · Substantial damage > The pilot-in-command was attempting to taxi through shallow water to reach the takeoff point. As the airplane's floats came up on step a gust of wind from the left rear caused the airplane to weather vance and struck the streams bank. The stream was very… - [NTSB BFO85IA074](https://openairdocs.org/ntsb/BFO85IA074.md): Mcdonnell Douglas DC-10-10 · Washington, DC · Incident · Minor injuries · Incident investigation · Final report · Sep 8, 1985 · N1842U · Minor damage > Northwest flight 78 (NW78), a B-757, was parked at gate 17 facing east with mobile passenger lounge (mpl) docked at L1 door. United 52, a DC-10, taxied in easterly direction by left side of NW78, then turned right to southeasterly heading to follow lead-in… - [NTSB ANC85LA180](https://openairdocs.org/ntsb/ANC85LA180.md): Cessna 180-J · Egegik, AK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1985 · N420SB · Substantial damage > Acft nosed over while taxiing for takeoff from a dry lake bed. He was taxiing with a 35 to 40 kt tailwind. - [NTSB CHI85LA362](https://openairdocs.org/ntsb/CHI85LA362.md): Beech A36 · Mankato, MN · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N1450R · Substantial damage > The plt of this acft attempted to start the eng twice with acft battery and a ground pwr unit without success. He then tied the tail down with a rope and had started the eng. After the eng started, the tie down rope broke and the acft taxied by itself into… - [NTSB MIA85IA238](https://openairdocs.org/ntsb/MIA85IA238.md): Aeronca 7AC · Ft. Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Aug 26, 1985 · N1760E · Minor damage > The plt stated that while taxing for takeoff the acft encountered a gust of wind. Nosed over & the propeller & right wing tip struck the ground. - [NTSB LAX85LA364](https://openairdocs.org/ntsb/LAX85LA364.md): Cessna 152 · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1985 · N4807B · Substantial damage > Following an uneventful flt,the pilot taxied towards his parking area. He said as he looked to his right for a parking space the acfts left wing impacted a hanger and the acft turned left nosing into the hanger door. - [NTSB MKC85LA167](https://openairdocs.org/ntsb/MKC85LA167.md): Cessna 152 · Queen City, MO · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N67911 · Substantial damage > The plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post. - [NTSB MIA85FA215](https://openairdocs.org/ntsb/MIA85FA215.md): Piper PA-32-260 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1985 · N3714W · Substantial damage > The acft was taxiing northbound on the north-south taxiway and collided with the vehicle moving westbound along the east-west access road. The access road is a designated non-movement area under the control of the puerto rico port authority. The plt stated he… - [NTSB SEA85LA189](https://openairdocs.org/ntsb/SEA85LA189.md): Beech 35-C33 · Scappoose, OR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N5891J · Substantial damage > During taxi from landing while in a turn, th epilot inadvert ently selected gear up. He owns a similar airplane and had borrowed this aircraft. His aircraft gear and flap contr ols are in the opposite position of this aircraft's. he intended to raise the… - [NTSB SEA85LA165](https://openairdocs.org/ntsb/SEA85LA165.md): Cessna 172 · Pacatello, ID · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N2396E · Substantial damage > After landing the plt was instructed by the tower to expedite off the rwy and taxiway due to a jet following close behind. During taxi from the taxiway to the ramp, the plt was paying particular attention to his right wing tip to avoid parked acft. The acft… - [NTSB MKC85LA156](https://openairdocs.org/ntsb/MKC85LA156.md): Cessna 152 · Harrison, AR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1985 · N68777 · Substantial damage > After an en route stop, on a x-country flt, the student plt was taxiing to takeoff again. While proceeding northbound with a left x-wind, the plt applied braking action to slow the acft for a turn. At about that time, the acft veered to the right, went down… - [NTSB FTW85LA291](https://openairdocs.org/ntsb/FTW85LA291.md): Cessna A185F · Patterson, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1985 · N9905N · Substantial damage > The acft was substantially damaged when it was rammed by a speed boat after it had landed on a canal and was water taxiing to its tie down area. The boat came out of a crossing canal at high speed and struck the amphib in the area of the left float. The boat… - [NTSB ATL85LA207](https://openairdocs.org/ntsb/ATL85LA207.md): Cessna 150 · Geneva, AL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1985 · N1734Q · Substantial damage > During instructional flight acft collided with trees after takeoff. Instructor said flaps would not retract while in go around. Acft owner told FAA inspector instructor told him flaps would not retract after final landing. Fuse was then replaced with no… - [NTSB DEN85LQA03](https://openairdocs.org/ntsb/DEN85LQA03.md): Piper PA-18A · Tucumcari, NM · Accident · No injuries · Final report · Jul 4, 1985 · N1754A · Substantial damage > On July 4, 1985, at 1400 MDT, a Piper PA-18, N1754A, registered to ted w. stallings, departed the designated taxiway and collided with a culvert at Tucumcari municipal airport, Tucumcari, new Mexico. The aircraft was being taxied for thepurpose of a local… - [NTSB DEN85LA211](https://openairdocs.org/ntsb/DEN85LA211.md): Cessna 172L · Lordsburg, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1985 · N4349Q · Substantial damage > The plt said he had encountered moderate turbulence while en route & his passengers became air sick. He decided to land at the nearest suitable arpt. The landing was made without incident. However, while taxiing to the ramp, the aircraft encountered what one… - [NTSB MKC85LA145](https://openairdocs.org/ntsb/MKC85LA145.md): Taylorcraft BC12-D · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1985 · N95162 · Substantial damage > While taxiing to takeoff, the plt was proceeding between 2 rows of hangars. He stated that he was having a problem with the acft transceiver & was adjusting it for taxi instructions. At about that time, the right wing tip of the acft struck the tail rotor of… - [NTSB FTW85LA280](https://openairdocs.org/ntsb/FTW85LA280.md): Piper PA-28RT-201T · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N8473X · Substantial damage > Plt was taxiing to parking ramp/hangar after landing and following lineman's signals. He turned off the angling taxiway too soon and the nose and right main gears fell into a hole/low area off the edge of the taxiway. The propeller and right wing struck the… - [NTSB MKC85LA144](https://openairdocs.org/ntsb/MKC85LA144.md): Piper PA-28-140 · Hays, KS · Accident · No injuries · Limited investigation · Final report · Jun 29, 1985 · N98343 · Substantial damage > The plt started the eng & was preparing to taxi from the parking area when he reached back to retrieve a flashlight from his flt case. At that time, the acft began slowly rolling forward. When the plt returned his attention to the front, he applied brakes.… - [NTSB DEN85FTM04](https://openairdocs.org/ntsb/DEN85FTM04.md): Kokes Scorpion 133 · Grand Junction, CO · Accident · No injuries · Final report · Jun 29, 1985 · N45877 · Substantial damage > A group of plts were preparing for an airshow flyby. As a formation of airplanes were being taxied to rwy 29, the plt of a home built scorpion 133 helicopter, N45877, was cleared to air taxi across rwy 29 & proceed to rwy 22. As the helicopter plt was… - [NTSB CHI85LA255](https://openairdocs.org/ntsb/CHI85LA255.md): Piper PA-28-181 · Kankakee, IL · Accident · No injuries · Limited investigation · Final report · Jun 26, 1985 · N6897C · Substantial damage > The aircraft while clearing the runway, shot wide of the taxiway taxiing onto the grass and into a culvert which was difficult to see resulting in substantial damage to the aircraft. - [NTSB SEA85LA150](https://openairdocs.org/ntsb/SEA85LA150.md): de Havilland DHC-2 · Gustavis, AK · Accident · No injuries · Limited investigation · Final report · Jun 25, 1985 · N64395 · Substantial damage > While taxiing the float plane in a gusty x-wind, the wind & water current drifted the acft toward a parked boat. Subsequently, the left wing tip struck the boat & was damaged. But there was no damage to the boat. - [NTSB NYC85LA154](https://openairdocs.org/ntsb/NYC85LA154.md): McCulloch J-2 · Cortland, NY · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1985 · N4328G · Substantial damage > According to the pilot, the rotor blade contacted the tail rudders because of insufficient rotor speed. The rotor bladeswere thrown out of track and the gyroplane lost control. The insufficient rotor RPM was due to a rotor or pulley belt stripping. - [NTSB CHI85LA248](https://openairdocs.org/ntsb/CHI85LA248.md): Cessna 172 · East Alton, IL · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N8486X · Substantial damage > The acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the… - [NTSB MKC85LA135](https://openairdocs.org/ntsb/MKC85LA135.md): Piper J3C-65 · York, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1985 · N92253 · Substantial damage > The plt reported that he had completed a landing & had come to a near stop, then he applied power & was on the brakes for control. He stated that the left brake locked & the acft went off the rwy into hi weeds & rough terrain. There was no damage due to… - [NTSB CHI85LA238](https://openairdocs.org/ntsb/CHI85LA238.md): Piper PA-22-108 · Starbuck, MN · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N5355Z · Substantial damage > Plt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over. - [NTSB CHI85LA232](https://openairdocs.org/ntsb/CHI85LA232.md): Piper J-3 · Gaylord, MI · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N6544H · Substantial damage > The plt attempt to take the float plane across a lake in wind that was from 270 deg at 20 gusting 40 KTS. Subsequently, the acft capsized & was damaged. In a revised statement, the plt reported that he was 'sailing' (letting the wind blow the acft) across the… - [NTSB CHI85LA225](https://openairdocs.org/ntsb/CHI85LA225.md): Cessna 175B · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · Jun 6, 1985 · N8243T · Substantial damage > The plt was unaware that the taxiway did not continue to the approach end of rwy 28. He failed to see the turn in the taxiway and the acft continued off the end of the taxiway where it contacted a ditch. The taxiway was not lit (nor was it required to be). It… - [NTSB MKC85FCQ03](https://openairdocs.org/ntsb/MKC85FCQ03.md): Cessna 172RG · Wichita, KS · Accident · 1 fatal · Final report · Jun 4, 1985 · N7190C · Minor damage > The acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter… - [NTSB CHI85FA210](https://openairdocs.org/ntsb/CHI85FA210.md): Hughes 300 · Joliet, IL · Accident · Minor injuries · Field investigation · Final report · May 26, 1985 · N404Z · Destroyed > The helicopter experienced extreme vertical vibrations while landing from a hover. Inadvertent ground contact during uncontrolled oscillations resulted in destruction of the helicopter. - [NTSB LAX85LA258](https://openairdocs.org/ntsb/LAX85LA258.md): Piper PA-28-160 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N5O17W · Substantial damage > The plt had just purchased the acft & this was the first time he had taxied it from the left seat. This plt taxied from the parking ramp up a slight grade an across a taxiway. He reported that when he 'looked up', he observed that the acft was heading toward… - [NTSB FTW85LA218](https://openairdocs.org/ntsb/FTW85LA218.md): Cessna 421 · Mckinney, TX · Accident · No injuries · Limited investigation · Final report · May 10, 1985 · N888K · Substantial damage > After landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The… - [NTSB LAX85FA238](https://openairdocs.org/ntsb/LAX85FA238.md): Beech V35A · Santa Monica, CA · Accident · No injuries · Field investigation · Final report · May 4, 1985 · N4RW · Destroyed > After deptg & climbing to 4500', the plt & his plt rated pax noted a fuel odor & returned to the arpt to land. Bfr lndg,the plt called the tower (twr), but didn't advise twr psnl of the fuel odor or of a psbl prblm. As the acft was turning off the rwy, fire &… - [NTSB ATL85FKG05](https://openairdocs.org/ntsb/ATL85FKG05.md): Piper PA-31 · Atlanta, GA · Accident · No injuries · Final report · May 2, 1985 · N902BH · Substantial damage > On may 2, 1985, at 0714 EDT, a Piper PA-31, N902BH, regisered to paul m. furnee, was struck by a ground vehicle while taxiing for take off at hartsfield international airport, Atlanta, Georgia on an airtaxi cargo flight. Instrument meteorological conditions… - [NTSB MIA85LA157](https://openairdocs.org/ntsb/MIA85LA157.md): Cessna T310R · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Apr 24, 1985 · N2638N · Substantial damage > The plt stated that while taxiing in from landing & upon exicuting a right turn into the ramp the right main landing gear collapsed. Inspection of the landing gear revealed that the aft push pull retract rod failed at the rod end allowing the collapse of the… - [NTSB CHI85FA170](https://openairdocs.org/ntsb/CHI85FA170.md): Beech E18S · Janesville, WI · Accident · No injuries · Field investigation · Final report · Apr 21, 1985 · N68V · Substantial damage > On April 20,1985 at approx. 2100HRS local time a Beechcraft model E185 N68Y owned and operated by blackhawk airways inc. was conducting a normal runup in preparation for a flight from Janesville, WI. (Jvl) to chicago IL. (Ord). At the completion of the of the… - [NTSB ANC85LA064](https://openairdocs.org/ntsb/ANC85LA064.md): Piper PA-18 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N91003 · Substantial damage > The acft was occupied by the owner/plt, a 42 yr old student plt seated in the front seat, and a 41 yr old private plt, a career police officer of the anchorage police force, who was seated in the rear seat of this 2 seat acft. The seats were in a tanden… - [NTSB BFO85IA035](https://openairdocs.org/ntsb/BFO85IA035.md): Boeing 737-217 · Chantilly, VA · Incident · No injuries · Incident investigation · Final report · Apr 13, 1985 · N434PE · Minor damage > Approx 25MIN aft lndg,flt 168 was cleared for tkof on rwy 30 at dulles intl arpt. Abt 1MIN later the crew called for an aborted tkof because the #2 epr appeared slow to spool up. Aft taxiing back and running up the engines, flt 168 atmptd a second tkof. Dfdr… - [NTSB SEA85LA087](https://openairdocs.org/ntsb/SEA85LA087.md): Cessna 182 · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1985 · N5438B · Substantial damage > During taxi from landing a gust of wind pushed the acft from behind onto soft ground where it nosed over. - [NTSB NYC85FA097](https://openairdocs.org/ntsb/NYC85FA097.md): Cessna 421B · Johnson City, NY · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1985 · N5407J · Destroyed > After a heavy snow shower passed over the airport, the accident acft attempted a departure. Immediately after takeoff the plt transmitted that he was coming back to land. The acft crashed shortly thereafter, 1 mile southwest of the airport. Ground witnesses… - [NTSB FTW85LA166](https://openairdocs.org/ntsb/FTW85LA166.md): Cessna TU206G · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Mar 28, 1985 · N6282X · Substantial damage > Acft being taxiied to ramp after landing with wind 27 KTS gusting to 42 KTS. A gust of wind lifted the right wing and the acft nosed over. - [NTSB MIA85FA122](https://openairdocs.org/ntsb/MIA85FA122.md): Piper J3C-85 · Winter Haven, FL · Accident · 1 fatal · Field investigation · Final report · Mar 16, 1985 · N6716H · Minor damage > While taxiing back to the seaplane ramp after landing the acft struck a small fishing boat causing fatal injuries to the boats sole occupant. The acft was being taxied at high speed on the step and s turns where being made to clear the area due to the plt not… - [NTSB LAX85LA176](https://openairdocs.org/ntsb/LAX85LA176.md): Bellanca 14-19 · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · Mar 16, 1985 · N8870R · Substantial damage > The plt pulled the prop through by hand after attempts to start the acft failed. The unoccupied acft started and traveled aprx 200 ft before contacting the left wing of another acft. Inspection revealed the 'p' lead on the left magneto was not grounded. The… - [NTSB CHI85FA138](https://openairdocs.org/ntsb/CHI85FA138.md): Beech 58 · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1985 · N1889L · Destroyed > The Beech 58 plt was returning at ngt when traffic was very light. After lndg, the acft was retained on local control (lc) freq for the plt's convenience. The plt requested clnc to the twa hangar & was cleared on the most expeditious route. This route went… - [NTSB ATL85LA117](https://openairdocs.org/ntsb/ATL85LA117.md): Cessna 150J · Decatur, AL · Accident · No injuries · Limited investigation · Final report · Mar 13, 1985 · N60649 · Substantial damage > During eng start the acft accelerated into two parked acft causing substantial damage. The plt stated that the toe brakes were ineffective. Post crash investigation failed to disclose a preexisting failure or malfunction which may haverendered the brakes inop. - [NTSB ATL85LA115](https://openairdocs.org/ntsb/ATL85LA115.md): Enstrom F-28A · Jacksonville, NC · Incident · No injuries · Limited investigation · Final report · Mar 9, 1985 · N9248 · Minor damage > The plt lost directional control of the acft while attempting to air taxi the helicopter to another position on the ramp. - [NTSB ATL85LA108](https://openairdocs.org/ntsb/ATL85LA108.md): Cessna 172H · Bessemer, AL · Accident · No injuries · Limited investigation · Final report · Mar 6, 1985 · N5105G · Substantial damage > The plt was taxiing to the rwy on a narrow taxiway when the left wing struck a t hangar support post. - [NTSB ATL85FA109](https://openairdocs.org/ntsb/ATL85FA109.md): Mooney M20J · Chattanooga, TN · Accident · Serious injuries · Field investigation · Final report · Mar 5, 1985 · N4757H · Substantial damage > The plt was attempting to disengage the starter pinion gear by rocking the prop up & down by hand. The eng inadvertently started & the acft rolled across the ramp at a high rate of speed & collided with two automobiles & a chain link fence before coming to… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=46 ## 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=45 --- 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.