# 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 41 of 128 · 6,398 cases ## Cases, newest first - [NTSB ANC88FA056](https://openairdocs.org/ntsb/ANC88FA056.md): Cessna U206 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · May 14, 1988 · N4844X · Substantial damage > A deaf-mute adult male, who has a history of mental health problems, and who was a mental health ward of the state of Alaska at the time of the accident, entered a Cessna 206 airplane equipped with amphibious floats without permission while it was parked on… - [NTSB CHI88LA112](https://openairdocs.org/ntsb/CHI88LA112.md): Piper PA-28-140 · Sault Ste Marie, MI · Accident · No injuries · Limited investigation · Final report · May 7, 1988 · N15372 · Substantial damage > During taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,… - [NTSB DEN88LA103](https://openairdocs.org/ntsb/DEN88LA103.md): Cessna 172G · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N6059R · Substantial damage > The private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of… - [NTSB LAX88LA170](https://openairdocs.org/ntsb/LAX88LA170.md): Cessna 150F · Hayfork, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N6742F · Substantial damage > After landing and taxiing to parking, the pilot heard a noise, the pilot exited the airplane and noticed a fire in the engine compartment area. The airplane was consumed by fire shortly thereafter. - [NTSB NYC88LA134](https://openairdocs.org/ntsb/NYC88LA134.md): Beech C17B · Butler, PA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1988 · N47024 · Substantial damage > After landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed. - [NTSB ATL88IA144](https://openairdocs.org/ntsb/ATL88IA144.md): Cessna 152 · York, SC · Incident · No injuries · Incident investigation · Final report · Apr 15, 1988 · N93802 · Minor damage > The acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he… - [NTSB FTW88LA089](https://openairdocs.org/ntsb/FTW88LA089.md): Cessna 172K · Houston, TX · Accident · No injuries · Limited investigation · Final report · Apr 11, 1988 · N7116G · Substantial damage > The high-wing, tricycle gear airplane was taxiing out in winds gusting to 29 knots from about 320 degrees. While the airplane was heading 250 degrees, it was overturned to the inverted position. Owner's manual does not list any restrictions for maximum… - [NTSB BFO88LA040](https://openairdocs.org/ntsb/BFO88LA040.md): Cessna 340 · Pineville, WV · Accident · No injuries · Limited investigation · Final report · Apr 7, 1988 · N340FB · Substantial damage > The pilot failed to maintain clearance from obstacles while taxiing the aircraft. - [NTSB ATL88LA133](https://openairdocs.org/ntsb/ATL88LA133.md): Cessna 152 · Macon, GA · Accident · No injuries · Limited investigation · Final report · Apr 7, 1988 · N49409 · Substantial damage > The acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions. - [NTSB CHI88LA094](https://openairdocs.org/ntsb/CHI88LA094.md): Cessna 172M · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Apr 6, 1988 · N64508 · Substantial damage > The pilot had just landed at the airport for refueling and was instructed by the tower to do a 180 degree turn on the runway and then make a left turn on the first taxiway. The pilot executed the 180 degree turn and while attempting to turn left (crosswind)… - [NTSB MIA88LA141](https://openairdocs.org/ntsb/MIA88LA141.md): Cessna T-188C · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1988 · N2185J · Substantial damage > While taxiing from landing after a maintenance test flight, the rt main wheel assy separated from the rt landing gear strut. The acft then went off the taxiway & came to rest in the grass. Examination of the rt landing gear revealed that the spring strut… - [NTSB FTW88LA088](https://openairdocs.org/ntsb/FTW88LA088.md): Aeronca 7AC · Bonham, TX · Accident · No injuries · Limited investigation · Final report · Apr 3, 1988 · N2044E · 2 aircraft · Substantial damage > One airplane was taxiing out for departure at the same time two others were coming in to land. The first airplane landed and did a 180 on the runway to taxi back to the parking area. This required the second airplane to go-around. The airplane taxiing in… - [NTSB DCA88IA044](https://openairdocs.org/ntsb/DCA88IA044.md): Mcdonnell Douglas DC-10-40 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Mar 30, 1988 · N154US · Minor damage > The improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.… - [NTSB CHI88IA088](https://openairdocs.org/ntsb/CHI88IA088.md): Boeing 727-251 · Detroit, MI · Incident · Minor injuries · Incident investigation · Final report · Mar 28, 1988 · N277US · No damage - [NTSB CHI88LA085](https://openairdocs.org/ntsb/CHI88LA085.md): Bellanca 8GCBC · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N5044G · Substantial damage > Fifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the… - [NTSB MKC88LA068](https://openairdocs.org/ntsb/MKC88LA068.md): Cessna 172G · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Mar 24, 1988 · N72PF · Substantial damage > The pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180… - [NTSB ATL88LA122](https://openairdocs.org/ntsb/ATL88LA122.md): Cessna 310Q · Donalsonville, GA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N7765Q · Destroyed > The pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued… - [NTSB FTW88LA079](https://openairdocs.org/ntsb/FTW88LA079.md): Aerotek Pitts S-2A · La Porte, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1988 · N31441 · 2 aircraft · Minor damage > A pitts S-2A taxing from landing collided with a Cessna 150 that was stopped on the taxiway waiting as #2 for takeoff. The pitts CFI said the duel student, a private plt, was taxing the pitts from the rear seat. The Cessna was seen by the pitts plts during… - [NTSB NYC88LA106](https://openairdocs.org/ntsb/NYC88LA106.md): Cessna 172 · Old Town, ME · Accident · No injuries · Limited investigation · Final report · Mar 11, 1988 · N89219 · Substantial damage > Following rollout from a normal landing in strong winds, and during a left turn onto the taxiway, the wing of the aircraft was lifted up by a quartering tailwind and flipped over. - [NTSB SEA88LA056](https://openairdocs.org/ntsb/SEA88LA056.md): Cessna 172 · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1988 · N98525 · Substantial damage > The student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then… - [NTSB ATL88IA107](https://openairdocs.org/ntsb/ATL88IA107.md): Boeing 737-232 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Mar 10, 1988 · N310DA · Minor damage - [NTSB MIA88LA124](https://openairdocs.org/ntsb/MIA88LA124.md): Hughes 269A · Opa Locka, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1988 · N8755F · Destroyed > Student pilot lost control of helicopter during aerial taxi. The helicopter made ground contact and entered into ground resonance. When the instructor attempted to regain control of the helicopter he found the student frozen on the controls preventing him… - [NTSB NYC88LA097](https://openairdocs.org/ntsb/NYC88LA097.md): Beech 1900 · Albany, NY · Accident · No injuries · Limited investigation · Final report · Feb 27, 1988 · N7243R · Substantial damage > The Beech 1900 was taxiing out at night under the control of a ground taxi director and two wing walkers when its tail made contact with the tail of parked and unoccupied B-737. Both pilots said they did not see a stop signal from the taxi director. The wing… - [NTSB ATL88LA093](https://openairdocs.org/ntsb/ATL88LA093.md): Ercoupe 415C · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · Feb 17, 1988 · N3631H · Substantial damage > When the pilot was unable to find assistance to remove the nose wheel chock from the aircraft, he applied enough power to jump the chock. He was unable to retard the throttle before colliding with a parked aircraft and striking a concrete wall. - [NTSB ANC88LA031](https://openairdocs.org/ntsb/ANC88LA031.md): Cessna 170 · Healy, AK · Accident · No injuries · Limited investigation · Final report · Feb 15, 1988 · N2601D · Substantial damage > The pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the plane to strike a small tree next to a snow covered taxiway. - [NTSB SEA88LA048](https://openairdocs.org/ntsb/SEA88LA048.md): Cessna 172P · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · N52794 · Substantial damage > Plt was following taxi line and failed to note parked acft left wing intruding into taxi lane. Contact between left wing tips resulted. - [NTSB CHI88LA063](https://openairdocs.org/ntsb/CHI88LA063.md): Cessna 152 · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · N49540 · Substantial damage > While taxiing for takeoff the aircraft experienced a nose over when it contacted a snowbank. The instructor stated that she allowed the student pilot to taxi too fast and was unable to take control of the aircraft soon enough to avoid hitting the snowbank. - [NTSB ANC88LA030](https://openairdocs.org/ntsb/ANC88LA030.md): Cessna 207 · Brevig Mission, AK · Accident · No injuries · Limited investigation · Final report · Feb 12, 1988 · N9950M · Substantial damage > The pilot stated that while taxiing on the ramp perpendicular to the wind direction, a strong wind gust lifted the right wing and tail of the aircraft. The aircraft slowly turned over on its back. - [NTSB MKC88LA049](https://openairdocs.org/ntsb/MKC88LA049.md): Piper PA-34-200T · Burlington, IA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1988 · N2230D · Substantial damage > While taxiing out on a snow covered taxiway, during an air taxi operation, the aircraft struck an unmarked, unlighted, snow covered drainage hole, with the left landing gear. Substantial damage occurred to the left engine nacelle, the left wing spar, and the… - [NTSB DEN88LA053](https://openairdocs.org/ntsb/DEN88LA053.md): Piper PA-18-150 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Jan 14, 1988 · N1879P · Substantial damage > The commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31… - [NTSB DEN88LA048](https://openairdocs.org/ntsb/DEN88LA048.md): Rotorway Executive · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Jan 9, 1988 · N7007B · Destroyed > The plt contacted ground control & was cleared to taxi from a hangar on the south end of the arpt to a hangar on the north end via twy-a. twy-a was located 400' west & parallel to rwy 17/35. The plt said he was air taxiing the helicopter just above the… - [NTSB MIA88LA084](https://openairdocs.org/ntsb/MIA88LA084.md): Douglas C-118A · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jan 6, 1988 · HRAKZ · Substantial damage > The plt stated that while taxiing in the ramp area he turned the aircraft to park it & inadvertantly struck the horizontal stabilizer of a parked aircraft. - [NTSB MIA88IA079](https://openairdocs.org/ntsb/MIA88IA079.md): Cessna U206G · Key West, FL · Incident · No injuries · Incident investigation · Final report · Dec 29, 1987 · N4820R · Minor damage > While water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was… - [NTSB MIA88IA072](https://openairdocs.org/ntsb/MIA88IA072.md): Boeing 727-231 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Dec 27, 1987 · N54344 · Minor damage > Plt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc… - [NTSB MIA88LA076](https://openairdocs.org/ntsb/MIA88LA076.md): Crusenberry Windwagon · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1987 · N5223C · Substantial damage > While on a high speed taxi test the acft inadvertently became airborne. While looking out the rt side of the acft the plt rolled it into a rt bank. He then leveled the wings after which the acft stalled, touched down and separated the main landing gear wheels… - [NTSB MIA88LA075](https://openairdocs.org/ntsb/MIA88LA075.md): Boeing 727-200 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N705AA · 2 aircraft · Substantial damage > N705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA. - [NTSB NYC88LA060](https://openairdocs.org/ntsb/NYC88LA060.md): Beech 58 · Flushing, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1987 · N58MH · Substantial damage > As the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to… - [NTSB NYC88LA063](https://openairdocs.org/ntsb/NYC88LA063.md): Piper PA-28-161 · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Dec 24, 1987 · N32560 · Substantial damage > The aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage. - [NTSB LAX88LA073](https://openairdocs.org/ntsb/LAX88LA073.md): Cessna 195A · Burbank, CA · Accident · No injuries · Limited investigation · Final report · Dec 21, 1987 · N4026A · 2 aircraft · Minor damage > While holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did… - [NTSB SEA88LA030](https://openairdocs.org/ntsb/SEA88LA030.md): Piper PA-23-160 · Aurora, OR · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N3275P · 2 aircraft · Substantial damage > A single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft… - [NTSB LAX88LA069](https://openairdocs.org/ntsb/LAX88LA069.md): Cessna 172N · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N734YZ · Substantial damage > The surface wind was strong when the pilot began taxiing for takeoff. He did not obtain a preflight weather briefing for the flight. As the aircraft taxied from behind a hangar the strong wind lifted one of the wings and the aircraft rolled over on its back. - [NTSB ANC88LA018](https://openairdocs.org/ntsb/ANC88LA018.md): Piper PA-18 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1987 · N1237A · Substantial damage > The pilot stated that he was taxiing for takeoff when he lost directional control of the aircraft causing the right main ski to break through the ice; the aircraft then ground looped. - [NTSB CHI88LA032](https://openairdocs.org/ntsb/CHI88LA032.md): Cessna 180 · Carlton, MN · Accident · No injuries · Limited investigation · Final report · Dec 5, 1987 · N2957C · Substantial damage > The plt rprtd that the left main gear collapsed as he started to taxi from the ramp area on a smooth grass surface. When the gear collapsed, the left wing dropped to the ground & was substantially dmgd. The plt rprtd the left gear leg had broken off 2 inches… - [NTSB NYC88LA048](https://openairdocs.org/ntsb/NYC88LA048.md): Piper PA-28-150 · Middletown, PA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1987 · N32307 · Substantial damage > After landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the… - [NTSB LAX88IA064](https://openairdocs.org/ntsb/LAX88IA064.md): Boeing 737-300 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Dec 1, 1987 · N4571M · No damage > Delta flt 1605 landed on rwy 25L. After crossing rwy 25R, the local controller instructed the flt to contact the gnd controller. The ground controller instructed the flt to turn west on the outer taxiway. The capt became disorientated and inadvertently… - [NTSB ATL88LA039](https://openairdocs.org/ntsb/ATL88LA039.md): Piper PA-34-200 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N41298 · Substantial damage > The rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using… - [NTSB NYC88DNE01](https://openairdocs.org/ntsb/NYC88DNE01.md): Lamb Commander Elite · Meriden, CT · Accident · 1 fatal · Final report · Nov 4, 1987 · N501JL · Substantial damage > The pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers. - [NTSB MIA88LA027](https://openairdocs.org/ntsb/MIA88LA027.md): Learjet 35A · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Nov 4, 1987 · N900JE · Substantial damage > During taxi up to hangar under direction of lineman after arrival the flt experienced loss of hydraulic pressure and brakes. The plt could not activate the emergency brakes prior to rolling into the hangar and colliding with two acft prior to coming to rest.… - [NTSB DEN88LA019](https://openairdocs.org/ntsb/DEN88LA019.md): Cessna 152 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Nov 4, 1987 · N49209 · Substantial damage > The recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow… - [NTSB NYC88LA020](https://openairdocs.org/ntsb/NYC88LA020.md): Agusta 109A · Spring Valley, NY · Accident · No injuries · Limited investigation · Final report · Oct 30, 1987 · N109AM · Substantial damage > The helicopter had been refueled and the pilot was attempting to ground taxi. Prior to turning the aircraft around to taxi to a parking area the helicopter went into ground resonance as soon as the aircraft was moved. Collective was lowered, the engine… Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=42 ## 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=41 --- 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.