# 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 51 of 128 · 6,400 cases ## Cases, newest first - [NTSB MKC82DA151](https://openairdocs.org/ntsb/MKC82DA151.md): Bell 47G-2A · Washington, IA · Accident · No injuries · Final report · Aug 22, 1982 · N73205 · Substantial damage > The helicopter was being air taxied to the refueling location when it crashed. The pilot said he had lifted off and was about 6 ft AGL with about 20 KTS forward speed when he suddenly felt a snap and the cyclic went full left. The helicopter became… - [NTSB FTW82DA339](https://openairdocs.org/ntsb/FTW82DA339.md): North American AT-6A · Abilene, TX · Accident · Minor injuries · Final report · Aug 21, 1982 · N42BA · 2 aircraft · Minor damage > The pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6. - [NTSB FTW82DA337](https://openairdocs.org/ntsb/FTW82DA337.md): Cessna 177RG · Afton, TX · Accident · No injuries · Final report · Aug 18, 1982 · N50038 · Substantial damage > While en route, the piiot encountered severe weather and landed on a paved road. He stated that after about 2 hrs, the weather improved and he decided to taxi to an area where he could takeoff. While taxiing, the left wing struck a tree which pulled the… - [NTSB ATL82DA240](https://openairdocs.org/ntsb/ATL82DA240.md): Cessna 180 · Grand Bay, AL · Accident · Minor injuries · Final report · Aug 15, 1982 · N42GC · Substantial damage > Reportedly, the pilot was preparing to fly the aircraft, but the battery was dead, so he hand propped the engine to start it. According to the pilot's father, the aircraft was left unattended with the engine operating at idle speed. The pilot reported that he… - [NTSB NYC82DA196](https://openairdocs.org/ntsb/NYC82DA196.md): Piper PA-28-161 · Wilkes Barre, PA · Accident · No injuries · Final report · Aug 13, 1982 · N2962Q · Substantial damage > The student pilot stated that as he began to taxi, he proceeded about 35 ft and then the aircraft suddenly veered to the left as if the wheel had locked. He applied right rudder, then right brake. However, the aircraft struck a building and an automobile. - [NTSB NYC82DA192](https://openairdocs.org/ntsb/NYC82DA192.md): de Havilland DH-114 · Sidney, NY · Accident · No injuries · Final report · Aug 11, 1982 · N507FW · Substantial damage > While taxiing on the ramp the plt experienced a brake failure & the acft collided with several parked acft. The brake system is air operated & a small threaded rod with a small locking screw disconnected from the brake valve. - [NTSB LAX82DA295](https://openairdocs.org/ntsb/LAX82DA295.md): Aerospatiale SA-341G · Long Beach, CA · Accident · No injuries · Final report · Aug 10, 1982 · N118EF · Substantial damage > The helicopter was being used for dual flight instruction of several students. The instructor pilot (ip) stated that he held the controls while his second student exited and the third student got in and adjusted his seat and pedals. After performing the… - [NTSB DEN82DA157](https://openairdocs.org/ntsb/DEN82DA157.md): Cessna 172 · Grafton, ND · Accident · No injuries · Final report · Aug 7, 1982 · N8909V · 2 aircraft · Substantial damage > The pilot stated that when he began to taxi he noticed a Cessna 172 with its engine running in front of a hangar, about 500 feet ahead and to his left. Continuing his taxi, the pilot's attention was diverted by an aircraft on the right. When he looked forward… - [NTSB ATL82IA218](https://openairdocs.org/ntsb/ATL82IA218.md): Cessna 152 · Hampton, GA · Incident · No injuries · Incident investigation · Final report · Jul 29, 1982 · N714TA · Minor damage > During taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass… - [NTSB NYC82DA169](https://openairdocs.org/ntsb/NYC82DA169.md): North American T-6G · State College, PA · Accident · No injuries · Final report · Jul 25, 1982 · N6253C · Substantial damage > While taxiing in from landing the right landing gear collapsed resulting in substantial damage to the aircraft. Investigation revealed the right landing gear actuator rod failed. - [NTSB NYC82DA164](https://openairdocs.org/ntsb/NYC82DA164.md): Cessna 172N · Jamaica, NY · Accident · Minor injuries · Final report · Jul 24, 1982 · N9426E · Substantial damage > An airport operations agent, in a port authority automobile monitored ground control conversation with the pilot and offered to assist N9426E in locating the active runway. When approaching the lost aircraft's position the vehicle driver experienced sun glare… - [NTSB NYC82IA162](https://openairdocs.org/ntsb/NYC82IA162.md): Piper PA-38-112 · Westhampton Bea, NY · Incident · No injuries · Incident investigation · Final report · Jul 23, 1982 · N26005 · Minor damage > While taxiing in from landing during a left turn, the right main landing gear collapsed. - [NTSB ATL82DA205](https://openairdocs.org/ntsb/ATL82DA205.md): Beech J35 · Birmingham, AL · Accident · No injuries · Final report · Jul 20, 1982 · N2TP · Substantial damage > The pilot reported that he had received an instrument clearance before starting the engine and noted that the battery was weak. He reported that he decided to pull the propeller through and turned the ignition switch toward the off position. As the propeller… - [NTSB CHI82DA257](https://openairdocs.org/ntsb/CHI82DA257.md): Beech 36 · Ypsilanti, MI · Accident · No injuries · Final report · Jul 18, 1982 · N52GS · Substantial damage > After the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,… - [NTSB ATL82DA200](https://openairdocs.org/ntsb/ATL82DA200.md): Ercoupe 415-C · Richmond, KY · Accident · No injuries · Final report · Jul 14, 1982 · N37109 · Substantial damage > Pilot hand propped aircraft which broke tail tie-down rope and taxiied unattended into a runway light and a ditch about 175 feet from starting point. - [NTSB ATL82DA199](https://openairdocs.org/ntsb/ATL82DA199.md): Grumman G-164A · Wetumpka, AL · Accident · No injuries · Final report · Jul 13, 1982 · N7234 · Substantial damage > While taxiing onto the runway with a load of insecticide, the left main landing gear strut failed. The failure occurred about 2 inches from the fuselage attach point. - [NTSB ANC82DA061](https://openairdocs.org/ntsb/ANC82DA061.md): Cessna 180 · Soldotna, AK · Accident · No injuries · Final report · Jul 12, 1982 · N5276D · Substantial damage > After landing at a private airstrip the pilot taxied into a parked truck. The left wing of the aircraft was substantially damaged. - [NTSB LAX82DA248](https://openairdocs.org/ntsb/LAX82DA248.md): Beech 77 · Healdsburg, CA · Accident · No injuries · Final report · Jul 7, 1982 · N6702Y · Substantial damage > While taxiing past parked planes on the right, the student was distracted by a plane being towed out of a hangar on the left. The propeller of the BE-77 heavily damaged 8 ft of the right wing of a parked PA-28, N8118S. - [NTSB FTW82DA269](https://openairdocs.org/ntsb/FTW82DA269.md): Piper J3L-65S · New Orleans, LA · Accident · No injuries · Final report · Jul 5, 1982 · N24500 · Substantial damage > After landing the float plane on a bayou, the pilot started to taxi past an anchored barge on the waterway. The barge was used to support a shrimp net framework. While passing the barge, the right wing of the aircraft struck the framework and was damaged. - [NTSB FTW82DRJ19](https://openairdocs.org/ntsb/FTW82DRJ19.md): Boeing B-75 · Lufkin, TX · Accident · No injuries · Final report · Jun 27, 1982 · N59257 · 2 aircraft · Minor damage > N733BD was holding for the active runway when N59257 taxied into the tail of the aircraft. N733BD received substantial damage and N59257 received minor damage. - [NTSB LAX82FUM08](https://openairdocs.org/ntsb/LAX82FUM08.md): Bellanca 8GCBC · Jacumba, CA · Accident · No injuries · Final report · Jun 26, 1982 · N88049 · Substantial damage > After towing a glider, the pilot returned to the airport and landed. While taxiing, the left main gear collapsed and the left wing and propeller were damaged. An investigation revealed that the a landing gear attaching u-bolt, pn 1-10376, had failed. About… - [NTSB ANC82DA053](https://openairdocs.org/ntsb/ANC82DA053.md): Cessna 170B · Near Anchorage, AK · Accident · No injuries · Final report · Jun 26, 1982 · N3483D · Substantial damage > While on a fishing trip, the pilot landed on an abandoned oil exploration roadway. The pilot reported that he did not realize how narrow the roadway was until after he had landed and slowed the aircraft. He reported that he was not aware that the edges of the… - [NTSB FTW82DA247](https://openairdocs.org/ntsb/FTW82DA247.md): Cessna 172 · Houston, TX · Accident · No injuries · Final report · Jun 17, 1982 · N4920G · Substantial damage > After the student pilot returned from a cross-country. He taxied into the parking area, but noticed there were no parking spaces available. While making a 180 deg turn, the right wing struck a fence post. After hitting the post, the plane turned and the… - [NTSB FTW82DA208](https://openairdocs.org/ntsb/FTW82DA208.md): Piper PA-25-235 · Jayton, TX · Accident · No injuries · Final report · Jun 3, 1982 · N6996Z · Substantial damage > While taxiing out for takeoff with a full load of fuel and chemicals the left main wheel broke into three pieces. The axle sank into the surface of the runway causing the aircraft to swerve to the left, resulting in an overload condition on the right gear.… - [NTSB NYC82DA117](https://openairdocs.org/ntsb/NYC82DA117.md): Piper PA-22-108 · Syracuse, NY · Accident · No injuries · Final report · Jun 2, 1982 · N5621Z · Substantial damage > During a landing, the pilot slowed to taxi speed when the tower instructed him to expedite a turnoff onto a taxiway. While complying with this request and making a right turn, the pilot lost directional control. The aircraft veered off the right side of the… - [NTSB LAX82DA205](https://openairdocs.org/ntsb/LAX82DA205.md): Cessna 140 · Phoenix, AZ · Accident · No injuries · Final report · May 29, 1982 · N2256N · Substantial damage > A Mcdonnell Douglas DC-10 had landed and proceeded to the ramp area. As he entered the ramp and started toward gate 6, the green signal light changed to red and the pilot stopped with the DC-10'S tail pointed toward the parrallel taxiway beside runway 08R.… - [NTSB CHI82DA188](https://openairdocs.org/ntsb/CHI82DA188.md): Piper PA-34 · Springfield, IL · Accident · No injuries · Final report · May 27, 1982 · N1181X · Substantial damage > After landing the pilot attempted to taxi the aircraft back to the ramp area in heavy rain and reduced visibility. The aircraft taxied off the left side of the runway and struck two runway lights. - [NTSB MKC82DA084](https://openairdocs.org/ntsb/MKC82DA084.md): Cessna 152 · Ainsworth, NE · Accident · No injuries · Final report · May 19, 1982 · N5399B · Substantial damage > The pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots. - [NTSB LAX82DA180](https://openairdocs.org/ntsb/LAX82DA180.md): Cessna 172 · Bakersfield, CA · Accident · No injuries · Final report · May 17, 1982 · N6459D · Substantial damage > The student pilot had been cleared to land at meadows field but landed five miles to the south-southeast at Bakersfield airpark. Upon taxiing back to takeoff the left wing collided with a backhoe which was working alongside the runway installing a lighting… - [NTSB MKC82IA079](https://openairdocs.org/ntsb/MKC82IA079.md): Cessna 402B · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · May 13, 1982 · N2233Q · Minor damage > While taxiing in close to deplane his passengers, the commuter pilot pulled in behind a parked northwest orient 727. As he approached the rear of the 727, the pilot turned the Cessna 402B to the right so that the passenger door would be facing the gate. As… - [NTSB FTW82DA175](https://openairdocs.org/ntsb/FTW82DA175.md): Piper PA-32RT-300 · Pineville, LA · Accident · No injuries · Final report · May 13, 1982 · N36546 · Substantial damage > During taxi to the runway for takeoff, the right main gear dropped into an unmarked hole on the right edge of the taxiway resulting in substantial damage to the aircraft. - [NTSB NYC82FNA13](https://openairdocs.org/ntsb/NYC82FNA13.md): Beech E33 · Bedford, MA · Accident · No injuries · Final report · May 11, 1982 · N7457N · Substantial damage > The pilot was unable to start the aircraft with the electric starter when the battery had insufficient power to crank the engine. The pilot stated that he shut off the battery and alternator switches, turned off the magneto switch, and removed the keys. He… - [NTSB DEN82DA083](https://openairdocs.org/ntsb/DEN82DA083.md): Cessna 172 · Sturgis, SD · Accident · No injuries · Final report · May 10, 1982 · N5266J · Substantial damage > The pilot landed in an open field to go to an auction. When he taxied back downwind to start his takeoff, the wind was gusting to 28 knots. The pilot estimated that he was moving about 15 mph as he turned to head back into the wind. As he started a right… - [NTSB CHI82DA159](https://openairdocs.org/ntsb/CHI82DA159.md): Lake LA-4 · Dowagiac, MI · Accident · No injuries · Final report · May 9, 1982 · N8005E · Substantial damage > The pilot stated that while turning the aircraft during taxi to the shore the aircraft ran into the wake of a boat and skipped sideways. When the aircraft encountered a second wave the right wing struck the water shearing off the sponson and bending the wing. - [NTSB LAX82DA206](https://openairdocs.org/ntsb/LAX82DA206.md): Cessna 172 · Mojave, CA · Accident · No injuries · Final report · May 8, 1982 · N5111E · Substantial damage > While the pilot was boarding the aircraft, 2 linemen were holding the wings down. During taxi, the pilot was having difficulty controlling the aircraft. As the aircraft was turning to the runway heading, the wind raised the right wing, the spinning prop hit… - [NTSB FTW82DA166](https://openairdocs.org/ntsb/FTW82DA166.md): Cessna 172N · Lubbock, TX · Accident · No injuries · Final report · May 4, 1982 · N73795 · Substantial damage > During taxi a strong gust of wind lifted the tail of the aircraft and flipped it on its back. Thunderstorms were in the area with peak gusts to 53 knots. - [NTSB DEN82DA078](https://openairdocs.org/ntsb/DEN82DA078.md): Cessna 182M · Lovell, WY · Accident · No injuries · Final report · May 4, 1982 · N91682 · Substantial damage > After landing on a dirt road to talk to a sheep herder, the aircraft was taxied off the road. A gust of wind picked the tail of the aircraft up and turned the aircraft over. The pilot reported winds were from 135 degees at 20 knots gusting to 30 knots. - [NTSB NYC82FGT14](https://openairdocs.org/ntsb/NYC82FGT14.md): Christian Eagle II · Lancaster, PA · Accident · No injuries · Final report · Apr 29, 1982 · N3DY · Substantial damage > After taking off from runway 31, the pilot proceeded to an area where he performed inverted flight in an attempt to find a dime that may have been dropped in the cockpit. During his departure and arrival, he and a tower controller discussed and joked about… - [NTSB FTW82FPD10](https://openairdocs.org/ntsb/FTW82FPD10.md): Piper J3C-65 · Grand Prairie, TX · Accident · No injuries · Final report · Apr 25, 1982 · N70108 · Substantial damage > While the pilot was taxiing to the engine run-up area, his right wing struck the propeller of a Piper PA-24 (N7545P) that was positioned at the edge of the taxiway. The pilot believed that if he had been making sharper s-turns while taxiing, he would have… - [NTSB ATL82FLG11](https://openairdocs.org/ntsb/ATL82FLG11.md): Piper PA-34-200J · Columbia, SC · Accident · No injuries · Final report · Apr 17, 1982 · N82013 · Substantial damage > After landing at night, the pilot was cleared to a parking area. A lineman with wands responded to assist. While attempting to follow the signals from the lineman, the pilot taxied into another aircraft. - [NTSB ATL82DA102](https://openairdocs.org/ntsb/ATL82DA102.md): Piper PA-31 · Clemson, SC · Accident · No injuries · Final report · Apr 15, 1982 · N7570L · Substantial damage > During the preflight inspection the pilot noticed the hydraulically operated inboard main landing gear doors were open. Although realizing that they should be closed when the landing gear are fully extended, he pumped the doors up and taxied for takeoff.… - [NTSB CHI82DA118](https://openairdocs.org/ntsb/CHI82DA118.md): Cessna 172 · Marion, IL · Accident · No injuries · Final report · Apr 12, 1982 · N4178L · Substantial damage > The pilot reported that the wind was from 200 degrees at 22 gusting 30 knots. While taxiing eastbound from the runway, a gust of wind lifted the right wing and tail, and the aircraft nosed over. - [NTSB LAX82DUJ34](https://openairdocs.org/ntsb/LAX82DUJ34.md): Cessna 180K · Meadview, AZ · Accident · No injuries · Final report · Apr 7, 1982 · N2810K · Substantial damage > The flight had originated at north las vegas, NV. According to the pilot, he landed at an unprepared strip when his engine did not sound right, but it checked out on the ground. While at the unprepared strip, the right tire blew out when it struck a rock.… - [NTSB LAX82DA128](https://openairdocs.org/ntsb/LAX82DA128.md): Cessna 150 · Mendota, CA · Accident · No injuries · Final report · Apr 5, 1982 · N8760U · Substantial damage > The pilot stated he was looking out the left window for the taxiway when the aircraft ran off the runway into a soft field. - [NTSB DEN82DA071](https://openairdocs.org/ntsb/DEN82DA071.md): Cessna 172 · Westcliffe, CO · Accident · No injuries · Final report · Apr 4, 1982 · N1297U · Substantial damage > The pilot stated he was taxiing for takeoff when the wind lifted the tail of the aircraft and it nosed over. The wind was reported at 250 degrees, at 15 to 20 KTS. - [NTSB ATL82DA091](https://openairdocs.org/ntsb/ATL82DA091.md): Cessna 172 · Chantilly, VA · Accident · No injuries · Final report · Apr 4, 1982 · N5510D · Substantial damage > The pilot flew into an area of high forecast winds and altered his destination as a precaution. However, he failed to ask for or take precautionary measures after landing and the aircraft was blown over while taxiing. - [NTSB SEA82DYM14](https://openairdocs.org/ntsb/SEA82DYM14.md): Cessna 182 · Albany, OR · Accident · No injuries · Final report · Apr 3, 1982 · N2296G · Substantial damage > The pilot proceeded to the run-up area at the end of the runway. After making a run-up, he elected to taxi to refuel before taking off. He stated that he was making a turn when a gust of wind picked up his right wing. The aircraft then turned until it was in… - [NTSB MKC82DA053](https://openairdocs.org/ntsb/MKC82DA053.md): Cessna 205 · Hebron, NE · Accident · Minor injuries · Final report · Apr 2, 1982 · N8216Z · Substantial damage > After landing on runway 30 the pilot stated that he initiated a turn to taxi to his parking space when a gust of wind lifted the tail of the aircraft into the air and it nosed over. Winds were gusting to 35 knots. - [NTSB MIA82DA098](https://openairdocs.org/ntsb/MIA82DA098.md): Cessna 172 · Ormond Beach, FL · Accident · No injuries · Final report · Apr 2, 1982 · N23ER · Substantial damage > After landing the aircraft, one of six on a night cross-country flight, the pilot taxied back to the approach end of the runway for takeoff. N129ER was parked at the approach end awaiting takeoff sequence so the pilot of N23ER stopped about 30 yards behind it… - [NTSB CHI82IA112](https://openairdocs.org/ntsb/CHI82IA112.md): Rockwell Sabreliner 65 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Apr 2, 1982 · N23BX · Minor damage > The right engine was started as the passengers completed boarding. After the copilot secured the cabin door and took his seat, the pilot released the parking brake and control lock and applied power to taxi. When a turn was commanded the nosewheel steering… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=52 ## 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=51 --- 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.