# 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 48 of 128 · 6,398 cases ## Cases, newest first - [NTSB ATL84FA102](https://openairdocs.org/ntsb/ATL84FA102.md): Cessna 182RG II · Chantilly, VA · Accident · No injuries · Field investigation · Final report · Feb 9, 1984 · N1734R · Substantial damage > Plt stated he saw baggage tug at a stop, apparently holding, btw taxiways T-1 and T-2. Tug driver reported he stopped at the stop sign, looked left, looked right and observing no acft. He accelerated his vehicle and saw N1734R directly in front of him. He… - [NTSB SEA84FA048](https://openairdocs.org/ntsb/SEA84FA048.md): Sikorsky S-61L · Medford, OR · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1984 · N6981R · Destroyed > The plt deviated from the painted taxi line to avoid a parked fuel truck and collided with a hangar door. The main rotor hit the door and flying debris damaged 2 hangers,3 acft and 2 cars. - [NTSB LAX84LA157](https://openairdocs.org/ntsb/LAX84LA157.md): Bellanca 7KCAB · Santa Ana, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1984 · N7571F · Substantial damage > While taxiing after landing, a gust of wind overturned the acft. The winds were gusting to 40 KTS. - [NTSB LAX84IA147](https://openairdocs.org/ntsb/LAX84IA147.md): Piper PA-31-350 · Redding, CA · Incident · No injuries · Incident investigation · Final report · Jan 20, 1984 · N35479 · Minor damage > While taxiing to takeoff, smoke was noted in the cockpit area, shortly after the plt activated the heater ignition switch. The plt immediately stopped & secured the acft & assisted the passengers in deplaning. An exam of the janitrol heater, model B4050,… - [NTSB LAX84LA145](https://openairdocs.org/ntsb/LAX84LA145.md): Piper J-3 CUB · Lompoc, CA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1984 · N42077 · Substantial damage > During taxi from landing N42077 taxied into N6592B which had pulled to the right side of the taxiway and stopped to avoid the on-coming acft. The plt of N42077 stated to an FAA inspector that he 'used poor judgement in taxiing.' - [NTSB CHI84LA091](https://openairdocs.org/ntsb/CHI84LA091.md): Piper PA-34-220T · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jan 10, 1984 · N8424D · Substantial damage > The acft was being taxied from landing. At a service road intersection a baggage tug collided with the right wing. The acft lights were reportedly on at the time of the accident. The driver of the tug said he was not looking for a small acft on the taxiway,… - [NTSB MKC84LA061](https://openairdocs.org/ntsb/MKC84LA061.md): Piper J-3 · Battle Creek, NE · Accident · No injuries · Limited investigation · Final report · Jan 9, 1984 · N6839H · Substantial damage > The acft as taxiing on a hard packed snow covered field when the right main landing gear collapsed. Visual inspection did not show any signs of fatigue. Slight bending and overload separtion of the shock strut tubing was evident. - [NTSB CHI84FA076](https://openairdocs.org/ntsb/CHI84FA076.md): Beech BE-99 · Galesburg, IL · Accident · No injuries · Field investigation · Final report · Jan 3, 1984 · N317VA · Substantial damage > The main gear retracted while the acft was being taxied to the taxioff position. Investigation revealed that a landing gear maintenance valve PN22400-1, SN19 manufactured by airright inc had corroded and was allowing stray voltage to cyclethe landing gear… - [NTSB MIA84IA045](https://openairdocs.org/ntsb/MIA84IA045.md): Douglas DC-10-10 · West Palm Beach, FL · Incident · Minor injuries · Incident investigation · Final report · Dec 14, 1983 · N61NA · Minor damage > The acft experienced a failure of the right main landing gear truck while taxiing for takeoff. Metallurgical examinationrevealed stress corrosion which originated adjacent to the forward outboard longitudinal beam lubrication on hole. - [NTSB FTW84LA090](https://openairdocs.org/ntsb/FTW84LA090.md): Bell 222U · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N3177G · Substantial damage > The helicopter was parked on the ramp, facing east. When the plt called the tower for clearance, he requested a west departure. The plt received a clearance & was advised of traffic on the west ramp (behind the helicopter) & was instructed not to overfly the… - [NTSB ATL84LA062](https://openairdocs.org/ntsb/ATL84LA062.md): Piper PA-22-150 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Dec 6, 1983 · N7412D · Substantial damage > During a wx briefing, before takeoff, the plt was advised that the winds at Charlotte, NC were forcast to be from 230 at 13 gusting to 24 KTS. He was also advised to expect moderate to severe turbulence as well as high en route winds. While en route, he… - [NTSB ATL84FA057](https://openairdocs.org/ntsb/ATL84FA057.md): Piper PA-28R-200 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Nov 29, 1983 · N16AK · Substantial damage > After gompleting a preflt, the plt entered the acft & attempted to start the eng with the starter & on board battery. He stated that the eng turned slowly & would not start. After several attempts to make a normal start, the plt exited the acft, chocked the… - [NTSB MKC84LA066](https://openairdocs.org/ntsb/MKC84LA066.md): Piper PA-22-150 · Russellville, AR · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N7843D · Substantial damage > After landing, the plt taxied to the tie-down area. While turning into a tiedown postion, the right main gear hit a tire, surrounding a tie-down stake, & the acft nosed over. - [NTSB LAX84LA074](https://openairdocs.org/ntsb/LAX84LA074.md): Piper PA-28-181 · Redding, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 1983 · N3204Q · Substantial damage > The plt reported that when he tried to start the acft, the starter would not 'turn the eng.' Thinking that the oil had congealed, he exited the acft & 'pulled the prop.' At that time, the eng started & the plane began to move. The plt jumped on the right wing… - [NTSB FTW84LA080](https://openairdocs.org/ntsb/FTW84LA080.md): Cessna 180A · Portales, NM · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N5212D · Substantial damage > The plt had made a successful landing in an unimproved wheat field. The acft had stopped & as the plt was making a 180 deg turn back the wind caught a wing causing the acft to nose over onto its back. The plt stated that during the turn the right main gear… - [NTSB LAX84LA103](https://openairdocs.org/ntsb/LAX84LA103.md): Cessna 172 · Half Moon Bay, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N426SK · Substantial damage > The plt was taxiing to park when the right wing tip of his acft contacted the left wing tip of a Cessna 172RG, N6221R, that was parked beside the taxiway. According to the plt, the wing tip of the parked acft extended aprx 5 ft over the taxiway. - [NTSB LAX84LA069](https://openairdocs.org/ntsb/LAX84LA069.md): Cessna TU206E · Red Rock, AZ · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N1445M · Substantial damage > The acft taxied into a ditch after landing on a road at night. After the acft came to rest it was apparently intentionally burned. Sob & injuries are presumed. The landing site was marked by the placement of white cloths along the edges of the road. The acft… - [NTSB FTW84LA072](https://openairdocs.org/ntsb/FTW84LA072.md): Piper PA-28-140 · Cisco, TX · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N5764F · Substantial damage > The plt reported that while he was taxiing, after landing, he was focusing his attention on the radio, on the right side of the instrument panel, when the acft rolled off the rwy & into a ditch. During the occurrence, the nosewheel collapsed & the right wing… - [NTSB ATL84LA055](https://openairdocs.org/ntsb/ATL84LA055.md): Cessna T303 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N2302C · Substantial damage > During taxi for takeoff the pilot became disoriented and the acft collided with a ditch where construction of a new taxiway and old asphalt connected. The plt stated he could not determine the difference in the levels of the two surfaces. The taxiway was not… - [NTSB MKC84IA018](https://openairdocs.org/ntsb/MKC84IA018.md): Boeing 727-15C · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Nov 10, 1983 · N436EX · No damage > The pilot reported that after engine start the acft was directed by the tower to taxi for takeoff. The marshaller motioned him forward and he advanced the power to 65 percent to break away and then reduced it to idle. At no time was the pilot advised that an… - [NTSB CHI84IA041](https://openairdocs.org/ntsb/CHI84IA041.md): Boeing 727-200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Nov 8, 1983 · N898AA · Minor damage > During taxi from landing the left outboard wheel rim failed and bounced onto a highway causing damage to a vehicle the rim failed due to a per-existing fatigue crack. - [NTSB ATL84LA047](https://openairdocs.org/ntsb/ATL84LA047.md): Piper PA28-181 · Bessemer, AL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1983 · N83816 · Substantial damage > The acft collided with a station wagon while taxiing for takeoff during a purchaser demonstration flt. The prospective buyers were a husband and wife and the wife was occupying the left front seat with the CFI in the right seat. The CFI stated, that while… - [NTSB FTW84LA041](https://openairdocs.org/ntsb/FTW84LA041.md): Cessna 180K · Patterson, LA · Accident · No injuries · Limited investigation · Final report · Nov 1, 1983 · N2727K · Substantial damage > After landing, the plt was step taxiing the float plane around a slight curve in the canal. As the acft went around the curve, the sun was in the plt's eyes & he did not see a piling until it was directly ahead. He took evasive action, but the left wing… - [NTSB MKC84LA011](https://openairdocs.org/ntsb/MKC84LA011.md): Cessna 152 · Augusta, KS · Accident · No injuries · Limited investigation · Final report · Oct 27, 1983 · N46644 · Substantial damage > The acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no… - [NTSB LAX84IA036](https://openairdocs.org/ntsb/LAX84IA036.md): Beech 200 · San Francisco, CA · Incident · No injuries · Incident investigation · Final report · Oct 26, 1983 · N5KW · Minor damage > During taxi after landing the right wingtip hit a steel awning support. - [NTSB ATL84IA029](https://openairdocs.org/ntsb/ATL84IA029.md): Cessna 150M · Mobile, AL · Incident · No injuries · Incident investigation · Final report · Oct 23, 1983 · N9196U · Minor damage > The acft collided with a light pole while taxiing. The instructor pilot was preoccupied with locating a tie down spot. - [NTSB FTW84LA039](https://openairdocs.org/ntsb/FTW84LA039.md): Cessna 172 · Rockport, TX · Accident · No injuries · Limited investigation · Final report · Oct 15, 1983 · N75794 · Substantial damage > While the plt was taxiing towards the rwy at dusk to depart, the right wing tip of the acft hit the windshield of a parked fuel truck. - [NTSB FTW84LA019](https://openairdocs.org/ntsb/FTW84LA019.md): Piper PA-28-180 · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Oct 12, 1983 · N3092T · Substantial damage > The plt stated that while he was taxiing to takeoff, he misjudged his clearance from a 6 ft x 6 inch concrete block. The left brake housing hit the block which resulted in damage to the wing spar. He did not examine the acft until after the flt & was unaware… - [NTSB FTW84IA007](https://openairdocs.org/ntsb/FTW84IA007.md): Boeing B727-023 · Dfw Airport, TX · Incident · Minor injuries · Incident investigation · Final report · Oct 6, 1983 · N1972 · Minor damage > A brake fire resulting from a dragging brake the cause of which was not determined was the reason for an evacuation during taxi back to the ramp because of a brake discrepancy. The slide lost pressure which was attributed to a high heel shoe. - [NTSB CHI84LA039](https://openairdocs.org/ntsb/CHI84LA039.md): Piper PA-32R-300 · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Oct 6, 1983 · N47519 · Substantial damage > The acft was struck by a truck as it taxied on the ramp after landing. The fire department reported the truck left a 25 ft skid mark as it came out from an area of parked acft and struck N47519. - [NTSB SEA84LA004](https://openairdocs.org/ntsb/SEA84LA004.md): Cessna 180 · Silverdale, WA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N180TC · Substantial damage > The plt stated he was demonstrating how not to ground loop an airplane. When speed was built up on the taxiway, he applied brakes & the left brake failed. The left main gear & left wing folded. - [NTSB MKC83LA223](https://openairdocs.org/ntsb/MKC83LA223.md): Cessna 172 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Sep 27, 1983 · N21662 · Substantial damage > While taxiing off temporary rwy 22 the plt prematurely taxied into the taxiway leading to the air cargo ramp. In an effort to reach the general aviation ramp he turned onto a vehicle access road & the left wing struck a vehicular traffic warning sign. - [NTSB FTW83LA443](https://openairdocs.org/ntsb/FTW83LA443.md): Cessna 177RGII · Houston, TX · Accident · No injuries · Limited investigation · Final report · Sep 26, 1983 · N53070 · Substantial damage > The aircraft collided with a ditch while taxiing to the ramp following a night landing. The taxiway was unlighted & the plt stated the he 'simply turned too short onto the main taxiway.' Damage was limited to the left wing. - [NTSB NYC83IA252](https://openairdocs.org/ntsb/NYC83IA252.md): de Havilland DHC-6 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Sep 21, 1983 · N50RP · Minor damage > The acft encountered jet blast while taxiing behind a L-1011 acft which had not yet received taxi clearance & was still attached to the tug when the pass began. - [NTSB ATL83LA373](https://openairdocs.org/ntsb/ATL83LA373.md): Cessna 401A · Monroe, NC · Accident · No injuries · Limited investigation · Final report · Sep 19, 1983 · N401HW · Substantial damage > The left landing gear collapsed on the acft as it was being taxied into the ramp. After turning left into the hub area the landing gear horn sounded and the left gear collapsed, according to the plt. A flt instructor who witnessed the accident said the ACFT'3… - [NTSB ANC83FA178](https://openairdocs.org/ntsb/ANC83FA178.md): Bellanca 7GCBC · Fairbanks, AK · Accident · No injuries · Field investigation · Final report · Sep 19, 1983 · N68564 · Substantial damage > The acft collided with a sand bar and nosed over while step taxiing on a river during a training flt. The CFI said he could not see clearly from the rear seat and was not aware of the sand bar until it was struck. He did not file an accident report. The… - [NTSB MKC83LA221](https://openairdocs.org/ntsb/MKC83LA221.md): Cessna 182 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Sep 17, 1983 · N42966 · Substantial damage > The plt reported that after landing, she was taxiing to a ramp area when a gust of wind lifted the left wing & rolled the acft over on its top. The winds were reported from 190 deg at 20 gusting to 30 kt. - [NTSB NYC83LA243](https://openairdocs.org/ntsb/NYC83LA243.md): Cessna 140 · Fishers Island, NY · Accident · No injuries · Limited investigation · Final report · Sep 15, 1983 · N1856V · Substantial damage > The student plt stated that he had landed on rwy 07 & was taxing along the rwy to the tiedown area when he applied brakes & the acft nosed over. - [NTSB NYC83FU010](https://openairdocs.org/ntsb/NYC83FU010.md): Rotec Rally 3B · Franklin, MA · Accident · Serious injuries · Final report · Sep 11, 1983 · N116RE · Substantial damage > According to the plt, the registered ultralight acft was brought to a field during the morning to check out the control rigging & to familiarize him with the vehicle. There was no intention to fly the ultralight at that time. Later in the day, the plt was… - [NTSB FTW83LA433](https://openairdocs.org/ntsb/FTW83LA433.md): Cessna 182 · Monahans, TX · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N3447R · Substantial damage > N3447R collided with a hanger after the plt hand propped the unoccupied and unchocked acft. The plt stated that the acft's battery was too weak to turn it past the compression stroke. The plt got out to pull the prop through top dead center and it started.… - [NTSB CHI83LA422](https://openairdocs.org/ntsb/CHI83LA422.md): Boeing A75N1 · Galesburg, IL · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N49684 · Substantial damage > After landing at the Galesburg arpt, the plt was turning onto the taxiway when the acft ground looped in strong wind conditions. The left wing was substantially damaged during the mishap. - [NTSB DCA83AA037](https://openairdocs.org/ntsb/DCA83AA037.md): Swearingen SA226TC · Hot Springs, AR · Accident · No injuries · Final report · Aug 28, 1983 · N503SS · Substantial damage > Turning onto the rwy the coplt observed a flash behind his inst panel. He then received an elect shock to his right arm from the right console. A fire then erupted at the lower right hand corner of his inst panel. The crew & pax evacuated the acft. The… - [NTSB DEN83LA201](https://openairdocs.org/ntsb/DEN83LA201.md): Cessna 180 · Busby, MT · Accident · No injuries · Limited investigation · Final report · Aug 26, 1983 · N4596B · Substantial damage > According to the pilot he was making a downwind landing to avoid taxiing over rough ground any farther than necessary. After touchdown he travelled about 150 yards up the runway when a gust of wind picked up the tail and he lost control ending in a ground… - [NTSB SEA83LA182](https://openairdocs.org/ntsb/SEA83LA182.md): Piper PA28-140 · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N5097T · Substantial damage > The acft nosed over while taxiing unoccupied after being hand propped for a start by the pilot. The pilot stated that hewas unable to start the acft normally so he hand propped it with no one in the cockpit. The unoccupied acft taxied from the ramp across the… - [NTSB NYC83LA222](https://openairdocs.org/ntsb/NYC83LA222.md): Piper PA-22 Tripacer · Butler, PA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N600A · Substantial damage > The acft ran off the rwy into a 4 ft ditch and nosed over while taxiing. The plt said the 'brakes gave way' while he wastaxiing down rwy 17 after landing. When he realized the brakes were not holding he shut off the engine by the mixture control. To avoid… - [NTSB FTW83LA389](https://openairdocs.org/ntsb/FTW83LA389.md): Piper PA-28-161 · Bryan, TX · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N8115L · Substantial damage > The student plt was on a x-country flt to the college station easterwood arpt near Bryan, TX. When he arrived in the vicinity, he saw a nearby arpt, the Texas a&m flt test station. He stated that at about the same time, the eng missed momentarily, 2 times,… - [NTSB FTW83LA380](https://openairdocs.org/ntsb/FTW83LA380.md): Mooney M-20C · Midland, TX · Accident · No injuries · Limited investigation · Final report · Aug 15, 1983 · N6869U · Substantial damage > The acft collided with a fence post during taxi for takeoff. The acft was allowed to drift right of the center of the taxiway. The collision veered the acft to the right and damaged the wing. The accident occurred at dusk. - [NTSB ATL83LA323](https://openairdocs.org/ntsb/ATL83LA323.md): Bellanca 8-KCAB-150 · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1983 · N5500C · 2 aircraft · Substantial damage > Both aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that… - [NTSB CHI83LA373](https://openairdocs.org/ntsb/CHI83LA373.md): Piper PA-32R-301 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N29AM · Substantial damage > The pilot stated that he taxied southeast on runway 12L, then turned to taxi northwest on runway 34. During the turn, the left main gear went off the runway and into a hole in the sod. The width of runway 12L is 50 ft and the width of runway 34 is 100 ft. the… - [NTSB NYC83LA202](https://openairdocs.org/ntsb/NYC83LA202.md): Piper PA-32-260 · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N5533J · Substantial damage > After landing, the plt proceeded to taxi to the ramp area. While maneuvering within the ramp area, the plt taxied the acft into a construction zone. Reportedly, the right main wheel dropped into a rough area & resulted in substantial damage to the right wing… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=49 ## 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=48 --- 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.