# 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 50 of 128 · 6,398 cases ## Cases, newest first - [NTSB LAX83LA126](https://openairdocs.org/ntsb/LAX83LA126.md): Cessna 120 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 6, 1983 · N1958V · Substantial damage > The plt reported he was taxiing in winds that were moderate & gusting. While taxiing, he made s-turns & positioned the controls to compensate for the wind. As he approached the run-up area, he reduced power to slow down. At about that time, the nose suddenly… - [NTSB ANC83LA048](https://openairdocs.org/ntsb/ANC83LA048.md): Douglas DC-6A · Nuiqsut, AK · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N6587C · Substantial damage > The captain reported that the acft moved faster at idle pwr because the cargo had been offloaded. When he checked the brakes halfway down the taxiway he found that the brakes would not slow the acft on glare ice and snow. The flt engineer began reversing the… - [NTSB NYC83LA065](https://openairdocs.org/ntsb/NYC83LA065.md): Cessna 150K · Wilmington, DE · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N5898G · Substantial damage > A C-130 aircrew was cleared to taxi to the run-up area at the north end of the arpt for a run-up. At that time, the wind was reported from 360 deg at 8 KTS. The C-130 crew stopped on the run-up pad facing the wind & began a run-up. In the meantime, a Cessna… - [NTSB LAX83LA113](https://openairdocs.org/ntsb/LAX83LA113.md): Cessna U206G · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N6525X · Substantial damage > The acft was blown onto its nose & wing while taxiing on the ramp. According to tower personnel the wind had been variable from 200 to 300 deg with some gusts as high as 35K. - [NTSB ATL83LA108](https://openairdocs.org/ntsb/ATL83LA108.md): Cessna 172 · Marietta, GA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N35594 · Substantial damage > The aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they… - [NTSB FTW83AA104](https://openairdocs.org/ntsb/FTW83AA104.md): Cessna 550 · Houston, TX · Accident · No injuries · Final report · Feb 7, 1983 · N100VV · 2 aircraft · Substantial damage > After landing on rwy 31L, the aircrew of N100VV requested clearance to turn off to the right at midfield onto rwy 22. The request was approved & the aircrew was instructed to use caution for a cherokee proceeding from the opposite direction. The plt of N100VV… - [NTSB SEA83FA054](https://openairdocs.org/ntsb/SEA83FA054.md): Piper PA-34-200T · Seattle, WA · Accident · No injuries · Field investigation · Final report · Feb 5, 1983 · N2859M · Substantial damage > The aircraft collided with another parked aircraft while taxiing to takeoff. The time was dawn and the taxiway lights were on. The taxiing pilot allowed his aircraft to stray and collided with a parked PA-34. Both aircraft were damaged substantially. The… - [NTSB CHI83LA100](https://openairdocs.org/ntsb/CHI83LA100.md): Piper PA-28-180 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Feb 5, 1983 · N40793 · Substantial damage > The acft collided with a parked acft on the ramp. The student pilot started the acft on a snow covered icy ramp at nightthe parking brakes were set but when the engine started the acft taxied into another acft. After the accident the brakesof the acft were… - [NTSB FTW83IA094](https://openairdocs.org/ntsb/FTW83IA094.md): Boeing B-737-200 · Lubbock, TX · Incident · No injuries · Incident investigation · Final report · Jan 20, 1983 · N68SW · No damage > During taxi to takeoff the acft slid off the taxiway into the snow and became stuck. The taxiway was covered with snow &ice. - [NTSB LAX83IA073](https://openairdocs.org/ntsb/LAX83IA073.md): Boeing 747-123 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Jan 16, 1983 · N9664 · Minor damage > The left main landing gear collapsed while the acft was taxiing for takeoff. Dissambly revealed that the outer cylinder was shattered & metallurgical examination revealed abrasive grinding & environmetally accelerated fatigue prior to rapidfracture. - [NTSB FTW83LA083](https://openairdocs.org/ntsb/FTW83LA083.md): Piper PA-28R-200 · Bandera, TX · Accident · No injuries · Limited investigation · Final report · Jan 9, 1983 · N32978 · Substantial damage > The pilot stated that after a normal landing, he taxied to the end of the runway in order to allow another aircraft to land. He than taxied about 70 ft off the runway into a grass turnaround/taxi area where the aircraft hit an 18 inch deep hole with the left… - [NTSB LAX83FUJ11](https://openairdocs.org/ntsb/LAX83FUJ11.md): Douglas A26C · Phoenix, AZ · Accident · No injuries · Final report · Jan 4, 1983 · N25GH · Substantial damage > The left gear retracted. The modification of the acft for experimental use reduced access to the rudder trim control with the gear selector in the down position. With the selector in neutral, it was possible to apply loads to the gear which removed the gear… - [NTSB LAX83LUG12](https://openairdocs.org/ntsb/LAX83LUG12.md): Piper J-3 · Rubidoux, CA · Accident · No injuries · Final report · Dec 31, 1982 · N26170 · Substantial damage > Pilot taxiing to ramp when gust of wind blew aircraft over. Wind was variable, gusting 25 k. - [NTSB FTW83LA071](https://openairdocs.org/ntsb/FTW83LA071.md): Cessna T337G · Pampa, TX · Accident · No injuries · Limited investigation · Final report · Dec 25, 1982 · N15U · Substantial damage > The plt stated he ran the battery down while trying to start the engs. After obtaining a battery charger & a long extension cord he charged the battery & was able to start the engs. While he was returning the charger to the hangar the acft rolled into a… - [NTSB SEA83LA031](https://openairdocs.org/ntsb/SEA83LA031.md): Cessna 172L · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N3880Q · Substantial damage > After landing, the pilot began taxiing to the parking area. While taxiing, he came to an area where he tried to taxi between a fuel truck and a Beech baron. The pilot stated that he misjudged the distance between his right wing tip and the fuel truck and the… - [NTSB DEN83LA026](https://openairdocs.org/ntsb/DEN83LA026.md): Boeing 737-291 · Denver, CO · Accident · No injuries · Limited investigation · Final report · Dec 10, 1982 · N7346F > During a "power-back" operation from the terminal gate, a ground signal person and two wing walker were used in accordance with procedures. After reverse thrust was applied and the aircraft was rolling backwards. The signal person communicated an emergency… - [NTSB ATL83LA051](https://openairdocs.org/ntsb/ATL83LA051.md): Bellanca 8KCAB · Atkinson, NC · Accident · No injuries · Limited investigation · Final report · Dec 5, 1982 · N57423 · Substantial damage > The pilot decided to land on a private strip due to strong gusty winds and thunderstorms. The pilot landed without incident and began to back taxi on the runway when the left main landing gear went into a mud hole off the side of the runway. The aircraft… - [NTSB NYC83LA036](https://openairdocs.org/ntsb/NYC83LA036.md): Fokker F-27-100 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Nov 30, 1982 · N141PM · Substantial damage > Aircraft collided with a power cart as taxi to takeoff began. - [NTSB NYC83LA031](https://openairdocs.org/ntsb/NYC83LA031.md): Cessna 172RG · Middletown, PA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1982 · N5223V · Substantial damage > After landing the tower directed the pilot to back taxi on the runway. After clearing the runway the pilot taxied straight ahead with proper control deflections for a 10 degree strong wind behind the left wing. A strong gusty wind was encountered causing the… - [NTSB ANC83LA016](https://openairdocs.org/ntsb/ANC83LA016.md): Cessna 180 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Nov 22, 1982 · N2974C · Substantial damage > During a power-on taxi turn the pilot reported he was about to strike a 6-FT embankment. The pilot added full power and flaps and the aircraft left the water, flew over an embankment, but the skis caught bushes on top of the bank. The landing gear was… - [NTSB MKC83LA029](https://openairdocs.org/ntsb/MKC83LA029.md): Cessna 172M · Warrenburg, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1982 · N64029 · Substantial damage > Pilot had to taxi 4000 feet on runway. Aircraft became airborne, hit ground, and nosed over during this time. One witness said aircraft looked like it was taking off & stalled. Pilot said he was only going 20 mph. - [NTSB CHI83LA039](https://openairdocs.org/ntsb/CHI83LA039.md): Piper PA-28-151 · New Hudson, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1982 · N7730C · No damage > The pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception… - [NTSB ATL83LA026](https://openairdocs.org/ntsb/ATL83LA026.md): Cessna 172N · Loris, SC · Accident · No injuries · Limited investigation · Final report · Nov 7, 1982 · N2896E · Substantial damage > While taxiing from ramp left wingtip struck a van parked in the tie-down area. - [NTSB MKC83LA015](https://openairdocs.org/ntsb/MKC83LA015.md): Cessna 172P · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Nov 4, 1982 · N65685 · Substantial damage > Pilot taxiing to takeoff went on a roadway instead of a taxiway and collided with a sign post. The taxiway was marked by signs and yellow paint lines on surface where pilot became disoriented and left taxiway to follow road. - [NTSB ATL83LA022](https://openairdocs.org/ntsb/ATL83LA022.md): Beech B90 · Winston-Salem, NC · Accident · No injuries · Limited investigation · Final report · Nov 1, 1982 · N711GD · Substantial damage > The pilot was on a flight to deliver the aircraft for routine maintenance. He stated that he lost right braking action as he was approaching the maintenance hanger. He attempted to maintain directional control with propeller reversing, but the left wing hit… - [NTSB NYC83LA044](https://openairdocs.org/ntsb/NYC83LA044.md): Piper PA-18-150 · Little Ferry, NY · Accident · No injuries · Limited investigation · Final report · Oct 31, 1982 · N3593P · Substantial damage > Student pilot step-taxiing from landing collided with a submerged object in the river and damaged the float. The river was at low tide. - [NTSB CHI83LA028](https://openairdocs.org/ntsb/CHI83LA028.md): Piper PA-30 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Oct 29, 1982 · N7850Y · Substantial damage > The pilot taxiied onto 8 foot culvert after landing. Pilot complained of taxiway markings and lighting. He also said he never saw the culvert. - [NTSB NYC83IA013](https://openairdocs.org/ntsb/NYC83IA013.md): Piper J3C-65 · Augusta, ME · Incident · No injuries · Incident investigation · Final report · Oct 25, 1982 · N25973 · 2 aircraft · Minor damage > The student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite… - [NTSB LAX83FUG04](https://openairdocs.org/ntsb/LAX83FUG04.md): Cessna 402B · Upland, CA · Accident · No injuries · Final report · Oct 24, 1982 · N7856Q · Substantial damage > The pilot stated that after he landed and turned off the runway to taxi, he heard a loud report (explosion) from the right wing. He evacuated the aircraft and found the skin separated from the top and bottom leading edge of the right wing. Soot was found… - [NTSB LAX83LA017](https://openairdocs.org/ntsb/LAX83LA017.md): Cessna 182 · Deer Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1982 · N1496M · Destroyed > Pilot could not get aircraft started so he got out and pulled prop. Engine started and with no one aboard the aircraft taxiied into two parked aircraft. - [NTSB ATL83LA015](https://openairdocs.org/ntsb/ATL83LA015.md): Piper PA-23-250 · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Oct 20, 1982 · N62721 · Substantial damage > The pilot set the parking brake after starting the aircraft and diverted his attention to the checklist. When he looked up the aircraft was moving. The pilot attempted to stop the aircraft by both pushing the toe brakes and pulling the parking brake. The… - [NTSB MKC83LA011](https://openairdocs.org/ntsb/MKC83LA011.md): Cessna 172PII · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Oct 19, 1982 · N63648 · Substantial damage > Pilot made three go-arounds because of gusty winds. While taxiing to tiedown downwind the wind blew the aircraft over. Winds gusting to 25 KTS. - [NTSB CHI83LA021](https://openairdocs.org/ntsb/CHI83LA021.md): Swearingen SA227-AC · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 17, 1982 · N173MA · Substantial damage > The left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft. - [NTSB MKC83LA007](https://openairdocs.org/ntsb/MKC83LA007.md): Smith Miniplane Mini · Lexington, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1982 · N28M · Destroyed > During taxi for takeoff the pilot smelled fuel fumes in the cockpit and noticed fuel leakage under the fuel tank, located above the pilots leg. The pilot then parked the aircraft and shutdown the engine. A fire started after he deplaned and consumed the… - [NTSB SEA83LA005](https://openairdocs.org/ntsb/SEA83LA005.md): Beech C35 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1982 · N5894C · Substantial damage > While hand propping to start, the engine went to full power. The pilot gained access to the controls as the aircraft began to move against the locked brakes. However, he was unable to stop the plane before it hit a Beech 58P, N3664G. The pilot reported that… - [NTSB FTW83LA014](https://openairdocs.org/ntsb/FTW83LA014.md): Cessna 414A · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Oct 11, 1982 · N6599C · Substantial damage > After takeoff, the pilot was unable to get an up-and-locked indication after attempting to retract the landing gear. He extended the gear and got a safe indication (down-and-locked). He returned to the airport and landed. While taxiing off the runway, the… - [NTSB ATL83LA007](https://openairdocs.org/ntsb/ATL83LA007.md): Beech S35 · Macon, GA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1982 · N6138V · Substantial damage > After landing and coming to a stop on the runway, the pilot made a 180 degree turn to proceed to a taxiway and began cleaning up the cockpit. During the turn, the gear collapsed. The pilot stated that he inadvertently raised the gear handle instead of the… - [NTSB LAX83LA021](https://openairdocs.org/ntsb/LAX83LA021.md): Cessna 150 · Peoria, AZ · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N6319S · Substantial damage > While taxiing to the ramp the aircraft's left wing struck a chain link fence causing substantial damage to the aircraft. - [NTSB ANC83IA001](https://openairdocs.org/ntsb/ANC83IA001.md): Piper PA-32-300 · Near Port Heide, AK · Incident · No injuries · Incident investigation · Final report · Oct 3, 1982 · N4025W · Minor damage > According to the pilot, he was back taxiing along a beach after landing and while attempting to make a turn the nose gear collapsed. On examination, the pilot found that a bolt in the nose gear steering mechanism had failed due to excessive wear. This allowed… - [NTSB LAX83LA004](https://openairdocs.org/ntsb/LAX83LA004.md): Piper PA-28-140 · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1982 · N7537R · Substantial damage > While taxiing for takeoff the aircraft's left wing struck the nose of a Cessna 337, N547SE, which spun to the left and damaged a Piper PA-28, N8163E. The pilot stated that the Cessna 337 was 3 1/2 feet beyond alignment with other aircraft and extended into… - [NTSB CHI82DA353](https://openairdocs.org/ntsb/CHI82DA353.md): Piper PA-23-250 · Fort Wayne, IN · Accident · No injuries · Final report · Sep 16, 1982 · N642MS · Substantial damage > Plt taxied off rwy onto grass to give way to landing traffic. Paved taxiways are not available & 50 ft either side of runway is used for taxiing with the grass being kept mowed. Before he was able to taxi back onto the paved rwy the ground gave way & the nose… - [NTSB MKC83LA012](https://openairdocs.org/ntsb/MKC83LA012.md): Cessna 150 · Nichols, IA · Accident · No injuries · Limited investigation · Final report · Sep 13, 1982 · N51183 · Substantial damage > The pilot taxiied into a soft spot on his private airstrip which raised the wing. The wind got under the wing and flipped the aircraft over. - [NTSB NYC82DA231](https://openairdocs.org/ntsb/NYC82DA231.md): Piper PA-38-112 · Pomona, NJ · Accident · No injuries · Final report · Sep 9, 1982 · N2441A · Substantial damage > While taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck. - [NTSB CHI82DA346](https://openairdocs.org/ntsb/CHI82DA346.md): Piper PA-23-250 · Holland, MI · Accident · No injuries · Final report · Sep 8, 1982 · N54847 · Substantial damage > Pilot taxiing to takeoff collided with fuel pumps. - [NTSB MKC82DA172](https://openairdocs.org/ntsb/MKC82DA172.md): Ercoupe 415C · Andover, KS · Accident · No injuries · Final report · Sep 7, 1982 · N99088 · Substantial damage > Pilot reported he was taxiing and turned to avoid animals. Aircraft then collided with a tree. He had given two other versions verbally of how the damage occurred. - [NTSB SEA82DYK12](https://openairdocs.org/ntsb/SEA82DYK12.md): Cessna 210 · Rosenburg, OR · Accident · No injuries · Final report · Sep 2, 1982 · N727FK · Substantial damage > The pilot attempted to hand start the aircraft due to a weak battery. The pilot told passenger to hold the brakes and assumed the passenger knew how, because of his many hours of flight time (as a passenger). When the engine started the aircraft began to move… - [NTSB ATL82DA253](https://openairdocs.org/ntsb/ATL82DA253.md): Piper PA-34 · Campbellsville, KY · Accident · No injuries · Final report · Aug 26, 1982 · N6850J · Substantial damage > While taxiing to a hangar the left wheel went off the taxiway causing the left gear to collapse. - [NTSB MIA82DA178](https://openairdocs.org/ntsb/MIA82DA178.md): Douglas C-47 · Charlotte Amali · Accident · No injuries · Final report · Aug 23, 1982 · N87629 · Substantial damage > The pilot reported normal braking pressure failed while taxiing on the ramp. He attempted to steer clear of other aircraft, but collided with two parked DC-3 aircraft. No determination of the nature of the braking problem was made. - [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. Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=51 ## 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=50 --- 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.