# 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 47 of 128 · 6,398 cases ## Cases, newest first - [NTSB MKC84LA238](https://openairdocs.org/ntsb/MKC84LA238.md): Cessna 401 · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Aug 3, 1984 · N101SB · Substantial damage > While taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter… - [NTSB NYC84LA252](https://openairdocs.org/ntsb/NYC84LA252.md): Cessna 152 · Mansfield, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1984 · N49985 · 2 aircraft · Substantial damage > N49985 landed on rwy 32 and turned off rwy at midfield intersection. Acft came to full stop to retract flaps and turn off carb heat. Plt stated a check for other traffic who made at this time. Student plt began taxiing to ramp with landing light off, nav… - [NTSB FTW84LA307](https://openairdocs.org/ntsb/FTW84LA307.md): Cessna 152 · Eufaula, OK · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N6180Q · Substantial damage > While taxing from landing the plt was watching the clearance on the left side of the acft and the right wing contacted an unmarked utility pole. - [NTSB SEA84LA169](https://openairdocs.org/ntsb/SEA84LA169.md): Cessna 172NII · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N5280E · Substantial damage > While taxing on a ramp area the plts attention was diverted to adjusting the transponder code. The left wing of the acft contacted a moving fuel truck. - [NTSB NYC84LA232](https://openairdocs.org/ntsb/NYC84LA232.md): Robinson R22 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Jul 5, 1984 · N9077G · Substantial damage > After being directed to do so by the arpt mgr the pilot was air taxiing to parking when the main rotor blades contacted one main rotor blade of a parked bell 206. The pilot related that he assumed he would clear the 206 since he was watching the airport mgr… - [NTSB SEA84LA152](https://openairdocs.org/ntsb/SEA84LA152.md): Cessna T188C · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1984 · N1964J · Substantial damage > While taxiing to takeoff, the right main gear got into soft terrain off the right edge to the rwy. This pulled the acft to the right & the right wing struck an embankment. The right main gear collapsed & the right wing was buckled. - [NTSB MKC84LA187](https://openairdocs.org/ntsb/MKC84LA187.md): Cessna 172N · Gainsville, MO · Accident · No injuries · Limited investigation · Final report · Jun 28, 1984 · N1530E · Substantial damage > The pilot was taxiing the aircraft back to his hangar. Upon reaching the hangar he made a 180 degree turn to position the aircraft so he could push it backwards into the hangar. During the turn the left wing impacted a pole. - [NTSB NYC84LA219](https://openairdocs.org/ntsb/NYC84LA219.md): Lake LA-4-200 · Amityville, NY · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N6209V · Substantial damage > The acft sustained substantial damage during a step turn maneuver on the water. The student was briefed by the instructor prior to the flight and they proceeded to perform training maneuvers over the water. During the step turn maneuver, the instructor… - [NTSB CHI84LA261](https://openairdocs.org/ntsb/CHI84LA261.md): Cessna 172N · Kilbourne, IL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N734FP · Substantial damage > The student pilot stated that the nose wheel cocked in sand while taxing and the acft nosed over. - [NTSB MKC84LA171](https://openairdocs.org/ntsb/MKC84LA171.md): Cessna 150J · El Dorado, AR · Accident · No injuries · Limited investigation · Final report · Jun 14, 1984 · N51128 · Substantial damage > The acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft… - [NTSB CHI84LA229](https://openairdocs.org/ntsb/CHI84LA229.md): Piper PA-28-140 · Wauseon, OH · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N95478 · Substantial damage > While taxiing on the S0D for takeoff, the left wing hit a tree. - [NTSB DEN84LA174](https://openairdocs.org/ntsb/DEN84LA174.md): Cessna 152 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jun 9, 1984 · N5420P · Substantial damage > After receiving clearance to rwy 16L, the plt began taxiing thru a congested area where the taxiway & an arpt road were routed thru a hangar/parking area. In that area, the roadway was adjacent to the taxiway & to the right of the plt as he was taxiing. The… - [NTSB MKC84LA162](https://openairdocs.org/ntsb/MKC84LA162.md): Cessna U206G · Kansas City, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1984 · N9967M · Substantial damage > As a large jet was departing from the threshold of rwy 19, the plt of a Cessna 206, N9967M, was cleared onto the rwy to hold. Reportedly, the Cessna plt held short of the rwy until the jet had rolled about 1000 ft. as the Cessna was taxied onto the rwy, it… - [NTSB MKC84LA161](https://openairdocs.org/ntsb/MKC84LA161.md): Cessna 172P · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N93FR · Substantial damage > The acft nosed over while taxiing onto the rwy in high winds. The plt had received the ATIS weather that reported arpt surface winds from 190 degrees at 26 KTS gusting to 41 KTS. The plt taxied to the rwy and was turning to line up when the wind picked up one… - [NTSB MIA84IA177](https://openairdocs.org/ntsb/MIA84IA177.md): Grumman G-111 · West Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Jun 3, 1984 · N112FB · Minor damage > After a repositioning flt, the main gear collapsed. An exam of the hand pump selector control valve revealed that one of the two dump ports for thr flap position had a hydraulic leak. Reportedly, this allowed system pressure to retract the gear. The valve,… - [NTSB CHI84LA220](https://openairdocs.org/ntsb/CHI84LA220.md): Leblanc Dragon FLY · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Jun 2, 1984 · N4463L · Substantial damage > The acft inadvertently became airborne on a high speed taxi test. The plt lowered the nose resulting in a porpoise & thecanard was damaged. The acft had not been inspected or certified by the FAA. Examination revealed that the right wing had a higher angle of… - [NTSB NYC84LA205](https://openairdocs.org/ntsb/NYC84LA205.md): Piper PA-34-200T · Teterboro, NJ · Accident · Minor injuries · Limited investigation · Final report · May 31, 1984 · N33086 · 2 aircraft · Minor damage > A Piper PA-34-200T, N33086 & a Piper Aerostar 600, N8208T, were involved in an on-ground collision at night. IFR flt plans had been filed for both acft & the plts of both acft had begun taxiing for takeoff. According to the PA-34 plt, he had been cleared to… - [NTSB SEA85LA116](https://openairdocs.org/ntsb/SEA85LA116.md): Piper PA-18A-150 · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N6775B · Substantial damage > The pilot was returning from his third aerial tow. After releasing the tow rope while on the ramp, the plt was making clearing turns to avoid parked acft. The tow plane's parked unoccupied acft. The acft then pivoted into the mid portion of the right wing… - [NTSB NYC84LA172](https://openairdocs.org/ntsb/NYC84LA172.md): Cessna 305A · West Hampton, NY · Accident · Serious injuries · Limited investigation · Final report · May 13, 1984 · N49236 · No damage > The acft had just landed & the plt was taxiing to hook up to another glider when the acft became lodged n soft dirt. Two ground crewmembers came over to the acft. The plt stated that he told one of them to 'stay behind the strut while I shutdown'. He then… - [NTSB LAX84LA284](https://openairdocs.org/ntsb/LAX84LA284.md): Taylor Smith Mini DSA-1 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N53BT · 2 aircraft · Substantial damage > This acft landed in trail behind a lead acft (N53BT) and bounced on landing. During his recovery procedures he overtook and collided with the lead acft. - [NTSB MIA84LA159](https://openairdocs.org/ntsb/MIA84LA159.md): Piper J-3 · New Smyrna Bch, FL · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N98606 · Substantial damage > While the plt was taxing onto the rwy, the wind picked up the right wing & the acft was blown inverted. The winds were gusting 30 KTS. - [NTSB ATL84LA159](https://openairdocs.org/ntsb/ATL84LA159.md): Cessna 152 · Boaz, AL · Accident · No injuries · Limited investigation · Final report · May 3, 1984 · N93151 · Substantial damage > The acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt. - [NTSB CHI84LA172](https://openairdocs.org/ntsb/CHI84LA172.md): Taylorcraft BC12-D · Winona, MN · Accident · No injuries · Limited investigation · Final report · May 1, 1984 · N5184M · Substantial damage > After landing, the plt was turning left onto the taxiway when the wind lifted the right wing and tail of the acft. The acft nosed over. - [NTSB CHI84FA165](https://openairdocs.org/ntsb/CHI84FA165.md): Short Brothers SD3-30 · North Canton, OH · Accident · No injuries · Field investigation · Final report · Apr 27, 1984 · N330L · Substantial damage > Following normal lndg, plt executed 180-degree turn on runway, then taxied to gate. Normal gate arrival maneuver is a right 180-degree turn to present left side of acft to gate. As acft passed through about 135 degrees of this maneuver, hydraulic warning… - [NTSB ATL84LA157](https://openairdocs.org/ntsb/ATL84LA157.md): Piper PA-22-150 · Wilmington, NC · Accident · No injuries · Limited investigation · Final report · Apr 21, 1984 · N8092C · Substantial damage > While the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over. - [NTSB LAX84LA244](https://openairdocs.org/ntsb/LAX84LA244.md): Cessna 320 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N6185Q · Substantial damage > While taxing to the active rwy, the plt was aware of several holes in the taxiway. He made a turn to the left & entered a dirt area to assure that the acft would not enter the taxiway holes. However, in the dirt area, the nosewheel sunk into a water covered… - [NTSB MIA84IA147](https://openairdocs.org/ntsb/MIA84IA147.md): Grumman G-73T · Ft. Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Apr 17, 1984 · N2969 · Minor damage > After 2 unsuccessful attempts to 'ramp' the acft, plt took off again and flew to Ft. Lauderdale. Fly-by disclosed no nose landing wheel was present. Plt made landing on hard surface rwy. Metallurgical examination disclosed, nose gear strut assembly failed due… - [NTSB DEN84LA128](https://openairdocs.org/ntsb/DEN84LA128.md): Cessna 421C · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N6205X · Substantial damage > While taxiing after landing, the acft was in a left turn when the right main gear collapsed. The plt reported that all 3 gear indicated down & lock, both before & after the mishap. An exam of the right main gear actuator, pn 9910136-4, revealed that… - [NTSB MIA84LA135](https://openairdocs.org/ntsb/MIA84LA135.md): Cessna 172P · Deland, FL · Accident · No injuries · Limited investigation · Final report · Apr 13, 1984 · N92ER · 2 aircraft · Substantial damage > As a student plt in a Cessna 172P, N92ER, was taxiing to takeoff on a supervised solo flt, another student in a Cessna 172P, N78ER, was taxiing from landing. While passing, in opposite directions on a taxiway, the wing tips of the acft collided & both acft… - [NTSB DEN84LA126](https://openairdocs.org/ntsb/DEN84LA126.md): Piper PA-28-236 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N2940T · Substantial damage > The plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft. - [NTSB ATL84LA143](https://openairdocs.org/ntsb/ATL84LA143.md): Aeronca O-58A · Rutherfordton, NC · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N46513 · Substantial damage > After the eng was started, the plt added power to taxi. He reported that the eng then went to full power & he was unable to stop the plane or control its direction thru the use of brakes & flt controls. The plane struck 3 other parked acft before the plt… - [NTSB ATL84IA137](https://openairdocs.org/ntsb/ATL84IA137.md): Piper PA-34-200T · Parkersburg, WV · Incident · 2 fatal · Incident investigation · Final report · Mar 30, 1984 · N2827U · No damage > After an unscheduled landing due to the condition of a patient aboard the acft, the acft turned off a taxiway into the grass and stopped. Rescue personnel found the plt incapacitated from a heart attack and collapsed over the controls and the nurse… - [NTSB LAX84LA232](https://openairdocs.org/ntsb/LAX84LA232.md): Cessna 152 · Goleta, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1984 · N4717L · Substantial damage > Both acft had been cleared to the right side of taxiway 'a' after landing due to a convoy of emergency vehicles on a training mission. When cleared to continue to taxi after the convoy passed, N7655S taxied into N4717L from behind. - [NTSB ATL84LA128](https://openairdocs.org/ntsb/ATL84LA128.md): Cessna 337E · Tifton, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1984 · N86520 · Substantial damage > The acft reportedly was not tied down. The plt was hand propping the aft engine while the forward engine was running. In an attempt to board the acft the pilot was run over by the right main gear. The acft continued to travel until it collided with trees. - [NTSB NYC84LA121](https://openairdocs.org/ntsb/NYC84LA121.md): Aeronca 7AC · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1984 · N84074 · Substantial damage > After landing, as the plt was taxiing to the parking area, the acft hit a rwy identifier sign. The left horizontal stabilizer, elevator & rudder were damaged. The plt said the sign was painted black & was not clearly visible. Also, the sign was not of a… - [NTSB NYC84LA141](https://openairdocs.org/ntsb/NYC84LA141.md): Piper PA-23 · Lawrence, MA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1984 · N2080P · Substantial damage > As the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the… - [NTSB CHI84LA137](https://openairdocs.org/ntsb/CHI84LA137.md): Smith, Ted Aerostar 600 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Mar 23, 1984 · N9823Q · Substantial damage > The taxiway collapsed under the acft as the plt prepared for takeoff. The asphalt surface gave way due to sub-surface erosion and a four ft hole resulted. The acfts left main gear was sheared off. - [NTSB SEA84LA074](https://openairdocs.org/ntsb/SEA84LA074.md): Aeronca 7AC · Hailey, ID · Accident · No injuries · Limited investigation · Final report · Mar 22, 1984 · N85763 · Substantial damage > The student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing. - [NTSB LAX84LA226](https://openairdocs.org/ntsb/LAX84LA226.md): Cessna 172K · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Mar 21, 1984 · N78178 · Substantial damage > The acft was blown over as it turned crosswind in gusts up to 40 KTS. The plt said he was using the procedures for taxiing in wind conditions. The Cessna 172 is limited to a 15 kt crosswind component for takeoff. - [NTSB MKC84IA108](https://openairdocs.org/ntsb/MKC84IA108.md): Boeing 727-224 · Kansas City, MO · Incident · Minor injuries · Incident investigation · Final report · Mar 20, 1984 · N88706 · Minor damage > While taxiing to rwy 01 for takeoff, the plt noticed a snow removal vehicle operating in reverse, approaching his acft. He tried to maneuver to the rt to avoid a collision but the snow removal vehicle struck the leading edge of the lt wing. The driver of the… - [NTSB MIA84LA100](https://openairdocs.org/ntsb/MIA84LA100.md): Cessna 172 M · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N12497 · Substantial damage > The plt stated that the alternator was inop, so the acft had no electrical power. He decided to hand prop the eng to start it for a banner towing operation. He set the parking brake & started pulling the propeller thru by hand while the cockpit was… - [NTSB MKC84LA096](https://openairdocs.org/ntsb/MKC84LA096.md): Cessna 172P · Broken Bow, NE · Accident · No injuries · Limited investigation · Final report · Mar 7, 1984 · N52252 · Substantial damage > A gust of wind overturned the acft during taxi from landing. The wind was from 330 degrees at 24 KTS gusting to 34 KTS. - [NTSB NYC84LA100](https://openairdocs.org/ntsb/NYC84LA100.md): Piper PA-38-112 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N2583D · Substantial damage > While taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision. - [NTSB ATL84LA113](https://openairdocs.org/ntsb/ATL84LA113.md): Piper PA-12 · Rockingham, NC · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N92792 · Substantial damage > N92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost. - [NTSB LAX84LA203](https://openairdocs.org/ntsb/LAX84LA203.md): Cessna 172A · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1984 · N7168T · Substantial damage > The plt of the Cessna 172 requested clearance to rwy 30R & was cleared as requested. While taxiing, he was cautioned about turbulence behind a DC-9. The DC-9 plts were waiting to takeoff on rwy 30L. The Cessna plt started to pass as the DC-9 was cleared onto… - [NTSB MKC84LA095](https://openairdocs.org/ntsb/MKC84LA095.md): Cessna 182Q · Pleasanton, KS · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N735UY · Substantial damage > The plt stated that he taxied through mud and snow enroute to the rwy. He said when he applied rt rudder and brake the acft failed to respond. The left wing hit a pole. - [NTSB NYC84IA091](https://openairdocs.org/ntsb/NYC84IA091.md): Lockheed 382G · Groton, CT · Incident · No injuries · Incident investigation · Final report · Feb 24, 1984 · N15ST · Minor damage > After landing on rwy 33, and during taxi to the ramp, the lt wing tip of the acft struck a parked DC-3. - [NTSB MIA84FA084](https://openairdocs.org/ntsb/MIA84FA084.md): Douglas DC-3 · Miami, FL · Accident · No injuries · Field investigation · Final report · Feb 17, 1984 · N922CA · Substantial damage > While taxiing for takeoff, the coplt attempted to increase the pressure in the landing gear downline by placing the landing gear hydraulic handle in the down position. The coplt believed that he confused the procedure & pulled up on the landing gear lock… - [NTSB LAX84LA177](https://openairdocs.org/ntsb/LAX84LA177.md): Cessna 182L · Mammoth Lakes, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1984 · N3194R · Substantial damage > The plt reported that the acft was blown over as he taxied for takeoff. Also, he reported the wind to be from 200 degrees at 20 KTS. The recorded wind from 180 degrees at KTS gusting to 40 KTS. The maximum demonstrated crosswind component for this acft is 15… - [NTSB LAX84LA173](https://openairdocs.org/ntsb/LAX84LA173.md): Robinson R-22 · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N9026R · Substantial damage > The acc occurred when the prospective buyer plt started to pick up the rotorcraft with too much aft cyclic. The rt rear skid dug into the ground and the acft rolled over. Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=48 ## 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=47 --- 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.