# 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 49 of 128 · 6,398 cases ## Cases, newest first - [NTSB MKC83LA185](https://openairdocs.org/ntsb/MKC83LA185.md): De Havilland DHG-6-300 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Aug 1, 1983 · N723CA · Substantial damage > As the aircraft was being parked, the outer portion of the right wing contacted the awning on a building. - [NTSB ANC83FA134](https://openairdocs.org/ntsb/ANC83FA134.md): Cessna 150 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jul 29, 1983 · N6446K · Substantial damage > The acft during taxi to takeoff in a wind of 11 KTS gusting to 19 KTS suddenly went off the taxiway into a 30 ft deep open ditch. This was a dual instructional flt and there was apparently no mechanical malfunctions even though the CFI stated that this acft… - [NTSB ATL83LA296](https://openairdocs.org/ntsb/ATL83LA296.md): Cessna T210N · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N6190C · 2 aircraft · Substantial damage > Cessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated… - [NTSB ANC83LA129](https://openairdocs.org/ntsb/ANC83LA129.md): Cessna C-180D · Barrow, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1983 · N6439X · Substantial damage > The pilot stated that he was taxiing downriver, downwind in order to get around two bends in the river to a straight section where a takeoff could be made. The left float of the aircraft struck a sandbar, causing the aircraft to roll end over end. - [NTSB ATL83LA311](https://openairdocs.org/ntsb/ATL83LA311.md): Piper PA-28R-200 · Cornelia, GA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1983 · N5088S · Substantial damage > The left main gear reportedly jumped a partially obscured curb during a turn around at the end of the rwy after landing. The curb had been installed for erosion control for water runoff. The left wing and landing gear of the acft were damaged. - [NTSB LAX83LA359](https://openairdocs.org/ntsb/LAX83LA359.md): Cessna TR182RG II · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1983 · N757KE · Destroyed > The acft caught fire during taxi after an aborted takeoff. During the takeoff roll the plt noticed a vibration and a slight pulling to the left. The brakes and engine had been checked with nothing noted but the plt decided to abort. He let the acft roll to a… - [NTSB NYC83IA182](https://openairdocs.org/ntsb/NYC83IA182.md): Cessna 172XP · Mechanicville, NY · Incident · No injuries · Incident investigation · Final report · Jul 19, 1983 · N8123V · Minor damage > After starting the engine and taxiing forward the pilot stated he pushed the trottle by mistake and the acft moved rapidy forward and struck a parked acft. - [NTSB MKC83IA159](https://openairdocs.org/ntsb/MKC83IA159.md): Boeing 727-231A · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jul 16, 1983 · N54352 · Minor damage > During taxi, while being guided by a ground marshallers the tail of the acft hit the tail of another acft. - [NTSB NYC83LA174](https://openairdocs.org/ntsb/NYC83LA174.md): Cessna 150M · Atlantic City, NJ · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N6416K · Substantial damage > After preflight and while the student plt was waiting for the CFI to board the acft he started the eng. The acft began to roll forward. The student, being unfamiliar with acft, could not stop the acft prior to colliding with the parked Cessna 182Q. - [NTSB ATL83LA319](https://openairdocs.org/ntsb/ATL83LA319.md): Beech 55 · Cornelia, GA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1983 · N8821M · Substantial damage > The acft collided with a grass-covered curbing at the edge of a taxiway as the pilot attempted to clear the rwy. At thisarpt the rwy is also used as a taxiway. While using the rwy to taxi for takeoff a radio call was heard reporting a landing acft so the… - [NTSB LAX83IA316](https://openairdocs.org/ntsb/LAX83IA316.md): Boeing 727-200 · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · Jul 2, 1983 · N88708 · Minor damage > During taxi into the terminal the acft left wing hit a parked tow truck boom. The tow truck was not authorized to be parked in the clear zone due to its height. - [NTSB NYC83LA155](https://openairdocs.org/ntsb/NYC83LA155.md): Cessna TU-206G · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1983 · N9858Z · Substantial damage > The float acft nosed over during taxi for takeoff. The pilot had picked up this acft 2 days before in farmingdale NY where a set of floats had been installed. He flew to Block Island to pick up 4 passengers and baggage. During downwind taxi for takeoff… - [NTSB MIA83IA165](https://openairdocs.org/ntsb/MIA83IA165.md): Mcdonnell Douglas DC-9-51 · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Jun 26, 1983 · N405EA · Minor damage > Smoke was observed coming from under the right rear lavatory door during the taxi from landing. The fire was not contained within the waste receptacle. Source of the fire could not be determined. - [NTSB CHI83LA270](https://openairdocs.org/ntsb/CHI83LA270.md): Grumman G-164A · Paris, IL · Accident · No injuries · Limited investigation · Final report · Jun 20, 1983 · N952X · 2 aircraft · Substantial damage > The plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned… - [NTSB DEN83LA138](https://openairdocs.org/ntsb/DEN83LA138.md): Cessna 182Q · Afton, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1983 · N4763N · 2 aircraft · Destroyed > The pitts special and a Cessna 182 collided on an active rwy the pitts was landing and the Cessna was taxiing down the rwy for refueling. The Cessna had made a radio call leaving the hanger area but did not make one prior to actually goingonto the rwy. The… - [NTSB ATL83FKG09](https://openairdocs.org/ntsb/ATL83FKG09.md): Grumman American AA-5A · Dobbins Afb, GA · Accident · No injuries · Final report · Jun 8, 1983 · N26116 · Substantial damage > The student plt was taxiing for takeoff when she applied right brake where a right turn was needed, however, the acft did not turn as it should. The instructor plt then took control of the acft. He applied right brake, then both brakes, but had negative… - [NTSB ANC83LA091](https://openairdocs.org/ntsb/ANC83LA091.md): Bell 205A-1 · Deadhorse, AK · Accident · No injuries · Limited investigation · Final report · Jun 7, 1983 · N17AL · Substantial damage > The helicopter collided with a pole and landed hard during air taxi to position the acft. The pilot had just off loaded passengers and was alone in the helicopter. A witness said the pilot hovered too close to the pole and both rotor bladesmade contact. The… - [NTSB NYC83LA133](https://openairdocs.org/ntsb/NYC83LA133.md): DG 400 · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N430LT · Substantial damage > The motorized glider was taxiing when the left wing tip caught in high grass and the acft veered to the left and penetrated a barbed wire fence. - [NTSB ANC83LA083](https://openairdocs.org/ntsb/ANC83LA083.md): Artic S-1B2 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · May 30, 1983 · N64AT · Substantial damage > The acft nosed over while taxiing for takeoff on a sand bar. The plt stated that he was demonstrating handling characteristics of the acft on sand and gravel to his passenger. The acft passed over a large hummock and settled into soft sand where it nosed… - [NTSB SEA83LA125](https://openairdocs.org/ntsb/SEA83LA125.md): Cessna 150 · Kelso, WA · Accident · No injuries · Limited investigation · Final report · May 28, 1983 · N6222R · Substantial damage > The plt hand-propped the acft with a non-plt at the controls. The acft was then taxied to the fuel pumps & fueled. The acft was then hand-propped again with no chocks used. The non-plt was at the controls. The acft started to move, & the plt climbed into the… - [NTSB ATL83LA199](https://openairdocs.org/ntsb/ATL83LA199.md): SIAI-Marchetti FN333 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · May 26, 1983 · N591W · Destroyed > The acft was being taxied in from landing when the engine quit. The pilot cranked the engine to restart, an explosion was heard and flames appeared in the cabin area. The pilot evacuated the acft as flames totally destroyed it. The engineis mounted above and… - [NTSB MKC83IA115](https://openairdocs.org/ntsb/MKC83IA115.md): Lockheed L-1011-385-1 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · May 25, 1983 · N31013 · Minor damage > While taxiing to the gate the number 1 engine struck a baggage cart in an area normally occupied by aircraft. The pilotsundivided attention was to the signalman. - [NTSB NYC83LA124](https://openairdocs.org/ntsb/NYC83LA124.md): Piper PA-22 · Olean, NY · Accident · No injuries · Limited investigation · Final report · May 23, 1983 · N3777A · Substantial damage > The acft nosed over during taxi after landing when the acft went off the runway into soft dirt. The student pilot had completed a cross-country flight without incident. After landing during taxi at Olean, NY the pilot applied brakes and the acft swerved to… - [NTSB DEN83IA119](https://openairdocs.org/ntsb/DEN83IA119.md): Boeing 727-31H · Colorado Spring, CO · Incident · No injuries · Incident investigation · Final report · May 23, 1983 · N840TW · Minor damage > While starting to taxi from the gate for departure, the acftstruck the jetway with the left wing. The captian stated that he was following the ground guide. The ground guide stated that this was the first time he had guided an acft & he had never recieved any… - [NTSB ATL83IA197](https://openairdocs.org/ntsb/ATL83IA197.md): Boeing B-737-222 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · May 23, 1983 · N752N · No damage > A malfunctioning relay resulted in overheating of an air conditioning pack causing the evacuation of the acft prior to takeoff. - [NTSB NYC83LA131](https://openairdocs.org/ntsb/NYC83LA131.md): Cessna 182B · Taunton, MA · Accident · No injuries · Limited investigation · Final report · May 21, 1983 · N2632G · Substantial damage > The acft collided with a small rock during taxi from landing. As the pilot taxied back to the ramp area along a dirt taxiway he observed three people standing in the way. The pilot taxied onto the grass to avoid the people and while still taxiing the acft… - [NTSB MKC83FA112](https://openairdocs.org/ntsb/MKC83FA112.md): Boeing 727-100 · St. Louis, MO · Accident · No injuries · Field investigation · Final report · May 20, 1983 · N40483 · Substantial damage > The acft was scheduled as Continental flt 415 & was departing from eastern airlines gate 14A. While departing from the gate, the aircrew turned left to avoid a DC-9 parked at gate 14, then turned right to a yellow taxi line. While maneuvering, the left wing… - [NTSB ATL83LA191](https://openairdocs.org/ntsb/ATL83LA191.md): Enstrom F-28C · Wise, VA · Accident · No injuries · Limited investigation · Final report · May 20, 1983 · N654H · Substantial damage > The plt reported that he had stayed in the local area & had been practicing slow hover over the grass beside the rwy. There was a paved ramp that he had to cross, each time he went from one end of the rwy to the other. He said when he came to this area, he… - [NTSB NYC83LA118](https://openairdocs.org/ntsb/NYC83LA118.md): Piper PA-28R-200 · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N2308T · Substantial damage > Acft collided with taxiway sign collapsing the right landing gear. - [NTSB FTW83LA224](https://openairdocs.org/ntsb/FTW83LA224.md): Cessna 180K · Houma, LA · Accident · No injuries · Limited investigation · Final report · May 6, 1983 · N61666 · Substantial damage > The plt was step taxiing on the intracoastal canal when he attempted a right turn. This resulted in a left rear crosswind which resulted in the left wing to striking a tree on the canal bank. - [NTSB CHI83LA199](https://openairdocs.org/ntsb/CHI83LA199.md): Beech B-60 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · May 4, 1983 · N821BE · Substantial damage > The acft collided with another parked and unoccupied acft while parking. The tail of the moving Beechcraft was damaged substantially. Damage to the parked acft was minor. The weather was VMC but a light rain was falling. - [NTSB MIA83LA130](https://openairdocs.org/ntsb/MIA83LA130.md): Globe GC1B · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1983 · N81MA · Substantial damage > The acft groundlooped and collapsed the landing gear after the rt brake failed during taxi from landing. The pilot said he had installed new brake pads and had spent time taxiing to wear them in. After completing one takeoff and landing theacft was being… - [NTSB FTW83IA193](https://openairdocs.org/ntsb/FTW83IA193.md): Douglas DC-8-63F · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Apr 16, 1983 · N773FT · No damage > The captain said he was asked to expedite the takeoff because of traffic on short final so he advanced the throttles to partial power to make a rolling takeoff. The acft's nose wheel crossed the centerline of the runway to the right and the captain corrected… - [NTSB ATL83FU001](https://openairdocs.org/ntsb/ATL83FU001.md): Wizard J-3 · Wetumpka, AL · Accident · No injuries · Final report · Apr 9, 1983 · UNREG · Substantial damage > The plt reported having about 0.4 hour of experience in this new ultralight vehicle. The nosewheel of the vehicle was not steerable & there were no brakes on the main gear. Therefore, the plt relied on the rudder for ground steering. At slow speed, air from… - [NTSB SEA83LA071](https://openairdocs.org/ntsb/SEA83LA071.md): Taylorcraft BC12-D · Everett, WA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1983 · N44025 · Substantial damage > The pilot collided with a parked aircraft while taxiing for takeoff. The weather was VMC and the taxiways were clear. The pilot said the right wing of his aircraft struck the left wing of the parked aircraft and the moving aircraft swung around into the other… - [NTSB SEA83LA069](https://openairdocs.org/ntsb/SEA83LA069.md): Continental Copters Mkiii · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1983 · N73865 · Substantial damage > While repositioning the helicopter from the ground onto a trailer the acft rolled over when the right skid caught onto the trailer. - [NTSB LAX83LA171](https://openairdocs.org/ntsb/LAX83LA171.md): Cessna 195A · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Mar 31, 1983 · N1537H · 2 aircraft · Substantial damage > The aircrews of a Cessna 195A, N1537H, & a Beech V35B, N2084L, were cleared to rwy 30 from different positions on the parking area. The Cessna plt was instructed to use the 'shortest route, no delay please.' As the acft were taxied on separate routes, they… - [NTSB FTW83LA173](https://openairdocs.org/ntsb/FTW83LA173.md): Anderson, Greenwood 51 · Tomball, TX · Accident · No injuries · Limited investigation · Final report · Mar 31, 1983 · N51AG · Substantial damage > The plt was taxiing from the ramp & attempted to turn left onto a taxiway. The nose gear steering was not sufficient to make the turn, so he applied left brake. However, the left brake did not operate since the master cylinder was void of brake fluid. The… - [NTSB MKC83IA083](https://openairdocs.org/ntsb/MKC83IA083.md): Boeing 727-222 · Des Moines, IA · Incident · No injuries · Incident investigation · Final report · Mar 30, 1983 · N7441U · Minor damage > The right leading edge slat was damaged when the acft taxied onto a closed & thusly marked taxiway. The closed taxiway was not shown as closed on the charts and no NOTAM was issued. The sky ws obscured & visibility was 1/2 mile in fog. - [NTSB LAX83LA164](https://openairdocs.org/ntsb/LAX83LA164.md): Cessna 210C · Holbrook, AZ · Accident · No injuries · Limited investigation · Final report · Mar 27, 1983 · N3628Y · Substantial damage > According to the plt, he applied power to taxi after starting the eng. He stated that after the acft began moving, he tried to apply left braking action to negotiate a left turn. However, according to him, the left brake failed to operate & the acft continued… - [NTSB LAX83LA156](https://openairdocs.org/ntsb/LAX83LA156.md): Cessna 120 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1983 · N72548 · Substantial damage > According to the pilot during rollout after landing he was making a right turn into a taxiway when a ground loop occurred. The left main gear was sheared during the ground looped and the left wing broke at the strut. - [NTSB MKC83IA200](https://openairdocs.org/ntsb/MKC83IA200.md): Douglas DC-3 · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Mar 24, 1983 · N38941 · Minor damage > On taxi for takeoff the acft left propeller struck a parked unoccupied acft. - [NTSB NYC83LA081](https://openairdocs.org/ntsb/NYC83LA081.md): Cessna 210D · Farmingdale, NJ · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1983 · N3727Y · Substantial damage > While taxiing to rwy 32 the plt attempted to stop after completion of a turn, but the brakes would not stop the acft. The plt used right rudder to avoid parked acft but was unable to maintain directional control. The acft went down an embankment, nosed over &… - [NTSB MKC83LA080](https://openairdocs.org/ntsb/MKC83LA080.md): Mooney M20F · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Mar 22, 1983 · N3386X · Substantial damage > The aircraft sustained damage when the left main and nose gears collapsed while the pilot was taxiing in from landing. The aircraft landed on runway 31 and had begun a right turn onto a taxiway when the nose gear and then the left main gear retracted. The… - [NTSB CHI83LA147](https://openairdocs.org/ntsb/CHI83LA147.md): Cessna 150 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Mar 20, 1983 · N704WN · Substantial damage > The student plt was on a supervised, solo, x-country flt from mosinee, WI, to Oshkosh, WI, green bay, WI, then return to mosinee. The first leg of the flight was flown with no problem. Before takeoff at oshkosk, the student was taxiing southbound with a left… - [NTSB LAX83IA149](https://openairdocs.org/ntsb/LAX83IA149.md): Boeing 747 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Mar 19, 1983 · 9VSQQ · 2 aircraft · Minor damage > N323EA was stopped 44 ft prior to the final turn off point for it's gate allowing the tail to extend 21 ft beyond the limit line. 9VSQQ was taxiing at 'pilots discretion' along the taxiway centerline when an attempt was made to pass behind N323EA at a 90 deg… - [NTSB FTW83LA161](https://openairdocs.org/ntsb/FTW83LA161.md): Piper PA-28-180 · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N6501J · Substantial damage > The pilot said he was waiting for an acft to clear the rwy. As he started to turn downfield for takeoff he pushed the throttle in, advancing the power instead of retarding it. The aircraft crossed the runway at an angle, became airborne and hit a tree. The… - [NTSB FTW83LA154](https://openairdocs.org/ntsb/FTW83LA154.md): Cessna 152 · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N6146Q · Substantial damage > The student plt landed at an en route airport after completing the second leg of a solo cross-country flt. He stated that after landing, he taxied to a hanger in order to rest before departure. While preparing to depart, he taxied & stopped short of runway 31… - [NTSB ATL83LA136](https://openairdocs.org/ntsb/ATL83LA136.md): Cessna 152 · Jasper, AL · Accident · No injuries · Limited investigation · Final report · Mar 13, 1983 · N6243M · Substantial damage > As the acft was taxiing on rwy 9 for a takeoff on rwy 27 the left main gear dropped off the rwy into soft terrain. The plt attempted to taxi back onto the rwy by turning the nose gear to get a better edge. Nevertheless, both the nose &left gear left the rwy &… - [NTSB ANC83LA054](https://openairdocs.org/ntsb/ANC83LA054.md): Piper PA-28R-180 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Mar 9, 1983 · N17243 · Substantial damage > The acft taxied into a pile of ice after landing. According to an Alaska state trooper that assisted in the investigation, the pilot turned 45 degrees to the right and departed the runway 150 feet short of the taxiway. The sun was bright, and according to the… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=50 ## 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=49 --- 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.