# 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 43 of 128 · 6,400 cases ## Cases, newest first - [NTSB MIA87LA140](https://openairdocs.org/ntsb/MIA87LA140.md): Piper J3C-65 · Zellwood, FL · Accident · No injuries · Limited investigation · Final report · Apr 19, 1987 · N33592 · Substantial damage > The plt stated that after landing he allowed the coplt to taxi the acft though he followed him through on the controls due to his lack of experience on tailwheel acft. The acft veered off the left side of the rwy and before control could be re-established by… - [NTSB ATL87LA117](https://openairdocs.org/ntsb/ATL87LA117.md): Piper PA-28-181 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Apr 17, 1987 · N2183D · Substantial damage > While taxiing for takeoff on a local flight, the aircraft collided with a parked fuel truck. The pilot said he saw the parked truck and attempted to taxi between it and some parked aircraft. The pilot said he misjudged the clearance and the left wing struck… - [NTSB NYC87LA117](https://openairdocs.org/ntsb/NYC87LA117.md): Beech 1900 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1987 · N811BE · Substantial damage > During taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged. - [NTSB FTW87LA092](https://openairdocs.org/ntsb/FTW87LA092.md): Cessna 402B · Altus, OK · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N402BC · Substantial damage > A 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the… - [NTSB MKC87IA070](https://openairdocs.org/ntsb/MKC87IA070.md): Agusta A109 · Lincoln, NE · Incident · No injuries · Incident investigation · Final report · Mar 30, 1987 · N4GH · Minor damage > The PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard… - [NTSB CHI87LA105](https://openairdocs.org/ntsb/CHI87LA105.md): Aeronca 15AC · Hibbing, MN · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N1156H · Substantial damage > The plt stated that while taxiing on the north taxiway, for takeoff on runway 31, a 'gust of wind caught the tail abruptly and caused plane to veer to the left and strike corner of hangar.' The acft collided with the hangar nose first. - [NTSB NYC87LA115](https://openairdocs.org/ntsb/NYC87LA115.md): Piper PA-31-350 · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N40958 · Substantial damage > During taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged. - [NTSB DEN87LA070](https://openairdocs.org/ntsb/DEN87LA070.md): Cessna 152 · Carlsbad, NM · Accident · No injuries · Limited investigation · Final report · Mar 22, 1987 · N6285Q · Substantial damage > The student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over. - [NTSB DEN87LA067](https://openairdocs.org/ntsb/DEN87LA067.md): Piper PA-31-350 · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N3529W · 2 aircraft · Minor damage > The plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance. - [NTSB ANC87LA055](https://openairdocs.org/ntsb/ANC87LA055.md): Piper PA-18 · Girdwood, AK · Accident · No injuries · Limited investigation · Final report · Mar 18, 1987 · N1472C · Substantial damage > The pilot stated that during taxi for takeoff he lost directional control of the aircraft causing the aircraft to exit the taxiway and strike a snowbank. - [NTSB NYC87IA106](https://openairdocs.org/ntsb/NYC87IA106.md): Boeing 727-225A · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Mar 11, 1987 · N802EA · Minor damage > As EA32 taxied from a stopped position on taxiway na between the outer and inner to the eastern ramp, a U.S. Postal tractor with an empty box traveling NE failed to yield to the aircraft and they collided on the service road and taxiway na. - [NTSB ANC87LA040](https://openairdocs.org/ntsb/ANC87LA040.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Feb 23, 1987 · N4687C · Substantial damage > The pilot successfully landed his ski equipped tailwheel airplane on a frozen lake in gusty wind conditions but lost control of the airplane while attempting to taxi from upwind to downwind. The airplane struck its left wing and elevator on the lake ice and… - [NTSB CHI87LA089](https://openairdocs.org/ntsb/CHI87LA089.md): Cessna 182F · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Feb 21, 1987 · N3513U · Substantial damage > While the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture… - [NTSB DEN87IA056](https://openairdocs.org/ntsb/DEN87IA056.md): Piper PA-31 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Feb 14, 1987 · N7559L · No damage > While taxiing from a cargo ramp for takeoff on an IFR flt, the acft taxied off the ramp into the infield on the arpt and came to rest with the engines running. Ramp personnel boarded the acft, shut the engines down and summoned medical help for the plt who… - [NTSB ANC87LA035](https://openairdocs.org/ntsb/ANC87LA035.md): Piper PA-18 · Clear, AK · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N102TC · Substantial damage > The pilot of the ski equipped airplane stated he taxied too fast after landing and damaged the airplane after the right ski toed into a large snow drift on rough surface ice. - [NTSB NYC87LA081](https://openairdocs.org/ntsb/NYC87LA081.md): Cessna 172 · Beaver Falls, PA · Accident · No injuries · Limited investigation · Final report · Feb 6, 1987 · N6539E · Substantial damage > The pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged. - [NTSB CHI87LA075](https://openairdocs.org/ntsb/CHI87LA075.md): Aeronca 11AC · Dodgeville, WI · Accident · No injuries · Limited investigation · Final report · Feb 5, 1987 · N86079 · Substantial damage > While taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots. - [NTSB MIA87IA078](https://openairdocs.org/ntsb/MIA87IA078.md): British BAC 1-11 201 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Jan 28, 1987 · N101EX · Minor damage > After landing the auxiliary power unit was started and the number one engine was shutdown. The aircraft then began to pressurize and fill with smoke. An emergency evacuation was ordered by the captain through L-1 and R-1 doors. The slide at R-1 did not work… - [NTSB DEN87LA045](https://openairdocs.org/ntsb/DEN87LA045.md): Cessna 172B · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Jan 24, 1987 · N8224X · Substantial damage > Student plt obtained wx briefing from fort worth fss and filed VFR flt plan for x-country flt from plainview, tex, to Roswell, NM, via hobbs, NM,. Plt landed at Roswell, refueled, and filed return VFR flt plan. He did not obtain updated wx briefing. Cold… - [NTSB LAX87LA083](https://openairdocs.org/ntsb/LAX87LA083.md): Cessna 172K · Lanai, HI · Accident · No injuries · Limited investigation · Final report · Jan 12, 1987 · N7459 · Substantial damage > The Cessna 172K nosed over in strong winds while taxiing for departure on rwy 3. The plt indicated that he was 'back taxiing' on rwy 3 when the wind 'got under wing, then under tail, and plane turned upside down.' The plt also indicated that the winds were… - [NTSB SEA87LA044](https://openairdocs.org/ntsb/SEA87LA044.md): de Havilland Beaver DHC-2 · Shoal Cove, AK · Accident · No injuries · Limited investigation · Final report · Jan 8, 1987 · N1018H · Substantial damage > The DHC-2 air taxi acft had landed at Shoal Cove, AK and was step taxiing to th float plane dock. During the taxi the acfts left wing contacted a wire cable attached to an 'a' frame across the path of the acft. The cable had been put up the day before and was… - [NTSB ATL87LA056](https://openairdocs.org/ntsb/ATL87LA056.md): Cessna 172G · New Philadelphi, OH · Accident · No injuries · Limited investigation · Final report · Dec 23, 1986 · N380LA · Substantial damage > The acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination… - [NTSB MIA87IA054](https://openairdocs.org/ntsb/MIA87IA054.md): Boeing 747-121 · Miami, FL · Incident · Minor injuries · Incident investigation · Final report · Dec 21, 1986 · N75IPA · No damage > During taxi for takeoff the captain of the air carrier became partially incapacitated. The first officer took over and the flight taxied back to the gate. The captain was evacuated to a local hospital where he was treated with glucose for hypoglycemia and… - [NTSB ATL87LA048](https://openairdocs.org/ntsb/ATL87LA048.md): Beech D-17-S · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N217SD · Substantial damage > Following a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation… - [NTSB SEA87LA037](https://openairdocs.org/ntsb/SEA87LA037.md): Cessna T310Q · Medford, OR · Accident · No injuries · Limited investigation · Final report · Dec 17, 1986 · N7581Q · Substantial damage > During turn off from the runway to the taxiway the left main gear collapsed. The runway and taxiway were icy and wet. Examination of the landing gear indicated an overload failure. - [NTSB ATL87IA027](https://openairdocs.org/ntsb/ATL87IA027.md): British Aerospace BA-31 · Louisville, KY · Incident · No injuries · Incident investigation · Final report · Nov 26, 1986 · N823JS · Minor damage > While taxiing for takeoff, a jetstream 31 operating as a commuter carrier to dayton, Ohio, collided with the fourth baggage cart of a four car train. The visibility on the ramp was reduced due to rain and fog. The baggage cart driver stated that he was… - [NTSB NYC87LA037](https://openairdocs.org/ntsb/NYC87LA037.md): Piper J3 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · Nov 23, 1986 · N58380 · 2 aircraft · Substantial damage > While taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred. - [NTSB LAX87LA042](https://openairdocs.org/ntsb/LAX87LA042.md): Cessna 120 · Columbia, CA · Accident · No injuries · Limited investigation · Final report · Nov 17, 1986 · N4085N · Substantial damage > At the beginning of a local pleasure flight, the pilot lost control of the aircraft while practicing high speed taxiing for directional control for takeoffs and landings. Upon reaching liftoff speed, the power was reduced to idle. The aircraft swerved to the… - [NTSB CHI87LA025](https://openairdocs.org/ntsb/CHI87LA025.md): Piper PA-34-220T · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N8161K · Substantial damage > Upon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved… - [NTSB MKC87LA021](https://openairdocs.org/ntsb/MKC87LA021.md): Piper PA-28-180 · Chillicothe, MO · Accident · No injuries · Limited investigation · Final report · Nov 8, 1986 · N55505 · Substantial damage > The PIC rptd that he was taxiing out fm the ramp area to the runup area of the airport to prepare for takeoff. He stated he had noticed ground equipment operating on the arpt as he taxied out. He had also stated that the windshield had become fogged during… - [NTSB FTW87LA008](https://openairdocs.org/ntsb/FTW87LA008.md): Hughes 269C · Monahans, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1986 · N8970F · Destroyed > The acft was destroyed during a forced landing following a partial loss of pwr after liftoff from a trailer. The acft settled back down onto the front of the trailer and subsequently rolled over. The eng continued to run following the roll over. The plt… - [NTSB ANC87IA011](https://openairdocs.org/ntsb/ANC87IA011.md): Cessna 402C · Kivalina, AK · Incident · No injuries · Incident investigation · Final report · Oct 8, 1986 · N1233T · Minor damage > The roll pin and safety wire which retain the main landing gear forward trunnion pin were broken and the forward trunnion pin on the right main landing gear was found 'backed out', thereby releasing the right main landing gear trunnion. - [NTSB MKC86LA200](https://openairdocs.org/ntsb/MKC86LA200.md): Cessna 182A · Lexington, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1986 · N6175B · Substantial damage > The student plt had taken the acft without the owner's permission & taxied onto a sod rwy. He rprtd that the acft almost became mired in mud on the sod rwy, so he added full power. The acft accelerated forward rapidly and the student lost control. The acft… - [NTSB MIA86LA257](https://openairdocs.org/ntsb/MIA86LA257.md): Piper PA-28-161 · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Sep 28, 1986 · N40070 · Substantial damage > During taxi after landing the pilot taxied on a parallel roadway that had aircraft parked on it. The left wing of the aircraft struck two parked aircraft causing minor damage to them. The taxiing aircraft sustained substantial damage. - [NTSB DEN86LA260](https://openairdocs.org/ntsb/DEN86LA260.md): Piper PA-18-150 · Wright, WY · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N7289K · Substantial damage > Acft was taxiing for takeoff from driveway on private ranch. Plt said there was strong x-wing gusting from left to right. Plt said he was holding right rudder when wind velocity decreased. Wing tip struck post beside driveway, acft turned right, and rolled… - [NTSB CHI86IA231](https://openairdocs.org/ntsb/CHI86IA231.md): Mitsubishi MU-300IA · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 25, 1986 · N19R · Minor damage > After landing the corporate jet was cleared to taxi to the general aviation ops to deplane pax. A food service truck crossing the taxiway failed to yield the right of way. The acft was unable to stop before the left wing struck the rear of the vehicle. - [NTSB CHI86IA225](https://openairdocs.org/ntsb/CHI86IA225.md): Boeing 727-25 · Evansville, IN · Incident · No injuries · Incident investigation · Final report · Sep 18, 1986 · N8107N · No damage > After the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254… - [NTSB LAX86LA356](https://openairdocs.org/ntsb/LAX86LA356.md): Piper PA-28-161 · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1986 · N2116J · Substantial damage > The private plt landed her acft & began taxiing toward a parking area. The driver of an acft fuel service truck observed the approaching acft, & he brought his truck to a complete stop in an authorized area for truck traffic. He was clear of the taxiway. The… - [NTSB LAX86LA354](https://openairdocs.org/ntsb/LAX86LA354.md): Cessna 152 · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1986 · N95010 · Substantial damage > The student pilot was taxiing to the run-up area when his left wing struck the corner of a hangar. The pilot stated he was paying attention to the right wing which was close to another aircraft at the time. - [NTSB ANC86LA155](https://openairdocs.org/ntsb/ANC86LA155.md): Piper PA-22 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N1712P · Substantial damage > During the taxi to takeoff phase a strong gust of wind lifted the left wing causing the airplane to flip over on its back. - [NTSB ATL86LA256](https://openairdocs.org/ntsb/ATL86LA256.md): Cessna 310J · Bessemer, AL · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N3105L · Substantial damage > While taxiing for takeoff the plt attempting to taxi between two rows of parked acft. He used the left brake to maneuver the acft between the rows and could not stop the turn by using the right brake. The acft continued in the turn and struck a parked Cessna… - [NTSB ANC86LA164](https://openairdocs.org/ntsb/ANC86LA164.md): Cessna 195A · Willow, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1986 · N9342A · Substantial damage > The pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure. - [NTSB MKC86LA178](https://openairdocs.org/ntsb/MKC86LA178.md): Cessna 172 · Emporia, KS · Accident · 1 fatal · Limited investigation · Final report · Aug 26, 1986 · N3791R · Minor damage > The acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the… - [NTSB DEN86LA239](https://openairdocs.org/ntsb/DEN86LA239.md): Piper PA-23E-250 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N900TS · Substantial damage > The acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear… - [NTSB FTW86LA155](https://openairdocs.org/ntsb/FTW86LA155.md): Cessna 172A · Gainesville, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N7261T · Substantial damage > The pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain… - [NTSB ANC86IA137](https://openairdocs.org/ntsb/ANC86IA137.md): Cessna 207A · Togiak, AK · Incident · No injuries · Incident investigation · Final report · Aug 24, 1986 · N1472M · Minor damage > After landing the airplane was taxiing to park and the pilot noticed the steering becoming stiff. He stopped the airplane and examined the nose gear and found it to have pivoted forward with the wheel coming to rest against the nose cowling. The mechanic… - [NTSB DEN86IA235](https://openairdocs.org/ntsb/DEN86IA235.md): Lockheed L-1011-385-1 · Denver, CO · Incident · Minor injuries · Incident investigation · Final report · Aug 22, 1986 · N31001 · No damage > Twa flt 735 landed at Denver stapleton arpt. During the taxi to the passenger terminal, a fire erupted in the tailpipe of the left engine. The flt crew executed the emergency evacuation procedures. Fire was extinguished. With no damage to the acft or engine.… - [NTSB ANC86FA126](https://openairdocs.org/ntsb/ANC86FA126.md): Cessna 185 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Aug 16, 1986 · N1802R · 2 aircraft · Minor damage > The plts of Cessna 185 (C-185), N1802R, & Cessna 180 (C-180), N9418C, received clearance fm ground control to taxi to rwy 32 via taxiway-n (twy-n). Both acft were tailwheel (conventional gear) equipped. As the C-185 was proceeding along twy-n, the C-180 plt… - [NTSB DEN86LA230](https://openairdocs.org/ntsb/DEN86LA230.md): Cessna A188B · Langdon, ND · Accident · No injuries · Limited investigation · Final report · Aug 10, 1986 · N2417J · Substantial damage > While ground taxiing for takeoff the acft left main gear brake failed. During the ensuing right ground loop the left main gear collapsed and the left wing impacted the asphalt taxiway. - [NTSB ANC86FA118](https://openairdocs.org/ntsb/ANC86FA118.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Aug 1, 1986 · N2913C · 2 aircraft · Minor damage > A ground control (gnd ctl) trainee clrd Cessna 152 (C-152), N757WV, to taxi to rwy 6, then relinquished the gnd ctl psn to a full performance level (fpl) ctlr, who had just signed on duty. The fpl ctlr was aware of the lctn & taxi destn of the C-152, the fpl… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=44 ## 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=43 --- 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.