# NTSB investigations: Landing 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 381 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB SEA89LA009](https://openairdocs.org/ntsb/SEA89LA009.md): Taylorcraft 15A · Skykomish, WA · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1988 · N6651N · Substantial damage > The plt made an apch over tall trees to land on a 2050 ft strip. The acft touched down on wet turf with about 500 ft of rwy remaining. The plt was unable to stop the acft on the remaining rwy. Subsequently, it contd off the departure end & went into a large… - [NTSB MKC89LA003](https://openairdocs.org/ntsb/MKC89LA003.md): Cessna 172 · West Memphis, AR · Accident · No injuries · Limited investigation · Final report · Oct 9, 1988 · N734BK · Substantial damage > The pilot said he was unable to activate the runway lights on the designated frequencies during a night personal flight. He attempted to land without the aid of the runway lights, and touched down on the FAR end of the runway subsequently running off the end… - [NTSB DEN89FA010](https://openairdocs.org/ntsb/DEN89FA010.md): Piper PA-24-180 · Albuquerque, NM · Accident · Serious injuries · Field investigation · Final report · Oct 9, 1988 · N7228P · Destroyed > Plt-rated pax told plt, coronado arpt 'in sight'. Plt was suspicious because loran indicated arpt was 3 mi away but trusted former instrument student's judgment & landed at closed alameda arpt instead of coronado arpt. Coronado UNICOM had told plt 'multiple… - [NTSB CHI89LA006](https://openairdocs.org/ntsb/CHI89LA006.md): Beech 55B · Quincy, IL · Accident · No injuries · Limited investigation · Final report · Oct 9, 1988 · N8769R · Substantial damage > The pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise. - [NTSB ATL89LA011](https://openairdocs.org/ntsb/ATL89LA011.md): Cessna 177B · Hatteras, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1988 · N17223 · Substantial damage > The plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &… - [NTSB LAX89LA012](https://openairdocs.org/ntsb/LAX89LA012.md): Piper PA-28RT-201 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1988 · N8162T · Destroyed > The pilot stated that during the landing roll he lost directional control of the airplane and veered left of the runway centerline. The pilot stated that the left rudder was stuck in a fully deflected position and his attempt to add right rudder was… - [NTSB DEN89LA011](https://openairdocs.org/ntsb/DEN89LA011.md): Cessna 172N · Delta, UT · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1988 · N75666 · Substantial damage > On a x-country flt, the plt elected to make a refueling stop at Delta, UT. He transmitted on UNICOM freq & got no reply,but noted a light wind favoring rwy 30 & rwy 34. He elected to land on rwy 30. He said that on final apch, he looked fortraffic to rwy 34,… - [NTSB ATL89LA010](https://openairdocs.org/ntsb/ATL89LA010.md): Cessna 177 · Greensboro, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1988 · N29550 · Substantial damage > The plt had landed at southeast Greensboro earlier. He departed on rwy 35 and remained in closed traffic for landing. The td was made in the first 100 feet of the downsloped rwy at about 70 mph. The flaps were retracted and the plt reptd that a gust of wind… - [NTSB ATL89LA008](https://openairdocs.org/ntsb/ATL89LA008.md): North American T-6G · West Jefferson, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1988 · N7704C · Substantial damage > During a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem. - [NTSB LAX89LA011](https://openairdocs.org/ntsb/LAX89LA011.md): Cessna 195B · Porterville, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1988 · N2141C · Substantial damage > During a dual instructional flight, the pilot lost directional control of the airplane while landing. The airplane veered left. When the pilot corrected to the right, the left main landing gear collapsed. The airplane nosed over and came to rest on the right… - [NTSB ATL89LA009](https://openairdocs.org/ntsb/ATL89LA009.md): Cessna 182 · Lexington, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1988 · N736EK · Substantial damage > During final approach to rwy 26 a crosswind shifted to a tailwind. The plt rprtd a full flap/carb heat touchdown was made despite 14 knots airspeed. Insufficient rwy remained and full throttle was applied for go-around. Flaps and carb heat were not… - [NTSB ATL89LA007](https://openairdocs.org/ntsb/ATL89LA007.md): Piper PA-28-180 · Savannah, GA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1988 · N7769N · Substantial damage > While landing with a left x-wind, the acft veered to the left & went off the rwy. Subsequently, the nose gear collapsed in soft terrain. The plt thought tower personnel had told him the wind was from 030 deg at 9 KTS. A check of the transcript revealed that… - [NTSB SEA89LA008](https://openairdocs.org/ntsb/SEA89LA008.md): Piper PA-34-200T · Cashmere, WA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1988 · N75107 · Substantial damage > Plt landed short of hard surface, collapsing lndg gear. - [NTSB NYC89LA004](https://openairdocs.org/ntsb/NYC89LA004.md): Piper PA-38-112 · New Castle, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1988 · N2542D · Destroyed > The CFI and student plt were practicing touch and go landings. The CFI said the landing was long and the aircraft was not quite aligned with the rwy. By the time the aircraft was realigned and under control the CFI thought there was insufficient rwy to stop… - [NTSB MIA89LA005](https://openairdocs.org/ntsb/MIA89LA005.md): Republic RC-3 · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1988 · N3263G · Substantial damage > The pilot stated that he was having problems with the elevator trim and elected to land the amphibious acft in the bay. He acknowledged and witnesses observed him lower the landing gear prior to attempting to land on the water. The aircraft flipped inverted… - [NTSB LAX89LA007](https://openairdocs.org/ntsb/LAX89LA007.md): Hughes 269C · Fontana, CA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1988 · N1090Z · Substantial damage > The pilot was demonstrating a run-on landing for his passenger when the accident occurred. The pilot reported that he allowed the tail of the helicopter to get too low and it collided with the terrain. There were no mechanical difficulties reported prior to… - [NTSB DEN89LA006](https://openairdocs.org/ntsb/DEN89LA006.md): Pilgrim Steen Skybolt · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Oct 4, 1988 · N21SP · Substantial damage > The pvt plt in command and his atp-rated pax were ferrying the newly-purchased acft from FL to WA. They departed scottsbluff, NE, and were enroute to rock springs, WY, when the pax advised the plt insufficient VFR fuel reserves precluded continuing to rks.… - [NTSB DEN89LA005](https://openairdocs.org/ntsb/DEN89LA005.md): Balloon Works Firefly 7 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 4, 1988 · N3678E · Substantial damage > The commercial Balloon plt and one pax were participating in a Balloon fiesta. The acft took off from Albuquerque, on a local flight in light winds. At altitude, the Balloon encountered easterly winds that carried the Balloon southwest of Albuquerque, where a… - [NTSB DEN89LA003](https://openairdocs.org/ntsb/DEN89LA003.md): Piccard AX-6 · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1988 · N99US · Substantial damage > The commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,… - [NTSB ANC89LA004](https://openairdocs.org/ntsb/ANC89LA004.md): Piper J3C-65 · Eureka Lodge, AK · Accident · No injuries · Limited investigation · Final report · Oct 3, 1988 · N98109 · Substantial damage > The pilot was attempting to land at dusk on a snow covered, unlighted private airstrip. He stated that he was attempting to land as close to the landing threshold as possible to avoid a large bump in the middle of the runway. He misjudged his approach and… - [NTSB FTW89LA002](https://openairdocs.org/ntsb/FTW89LA002.md): Cessna 172 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N89745 · Substantial damage - [NTSB DEN89LA002](https://openairdocs.org/ntsb/DEN89LA002.md): Cessna TP206B · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N4732F · Substantial damage > The private plt was practicing landings in his acft. During takeoff ground run, while making a touch and go landing, the plt reported experiencing vibrations from both main gear and his acft departed the 5,000 x 50 ft rwy to the left. The plane traveled 100… - [NTSB BFO88LA087](https://openairdocs.org/ntsb/BFO88LA087.md): Beech B23 · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1988 · N9110T · Substantial damage > The plt said the acft bounced twice during the landing. The apch speed was 75 to 80 KTS. The left main gear collapsed on the second bounce. The nose gear collapsed on the final touchdown. The acft slid off the left side of he rwy. The plt reported no… - [NTSB SEA88LA192](https://openairdocs.org/ntsb/SEA88LA192.md): Cessna 207 · Center Island, WA · Accident · No injuries · Limited investigation · Final report · Sep 30, 1988 · N1651U · Substantial damage > The plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &… - [NTSB ATL88LA257](https://openairdocs.org/ntsb/ATL88LA257.md): Cessna 152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Sep 30, 1988 · N95156 · Substantial damage > The student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any… - [NTSB SEA88LA193](https://openairdocs.org/ntsb/SEA88LA193.md): Piper PA-28-160 · Renton, WA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N5896W · Substantial damage > The student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to… - [NTSB SEA88LA190](https://openairdocs.org/ntsb/SEA88LA190.md): Cessna 185F · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N4758E · Substantial damage > During landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt. - [NTSB NYC88LA245](https://openairdocs.org/ntsb/NYC88LA245.md): Piper PA-28-151 · Carlton Center, NY · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N43610 · Substantial damage > Plt stated he was landing to the west and touched down about half way down a 2,000 ft grass strip. The plt also said the grass was wet and the wheel braking was ineffective. The plt elected to keep the airplane on the ground due to obstacles at the end of the… - [NTSB MKC88LA180](https://openairdocs.org/ntsb/MKC88LA180.md): Ellis Quickie Q2 · Winfield, KS · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N39774 · Substantial damage > Witnesses said that after takeoff, the plt made one low level pass, then returned for landing. The plt rprtd that he intended to make a go-around, but that he may have pushed the elevator control forward instead of the throttle. Subsequently, the acft was… - [NTSB MIA88LA275](https://openairdocs.org/ntsb/MIA88LA275.md): Cessna 182N · Belleview, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1988 · N9051G · Substantial damage > After clearing transmission wires at the apch end of the rwy, the plt stated the acft was low & slow. Prior to touchdown she stated the acft stalled, then landed hard. The nose wheel collapsed during the touchdown. - [NTSB ANC88LA148](https://openairdocs.org/ntsb/ANC88LA148.md): Bell 212 · Deadhorse, AK · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N397EH · Destroyed > The pilot encountered a whiteout condition and elected to land on a frozen lake approximately 3 miles southwest of the airport. After touchdown on the ice, the helicopter broke the ice and rolled over on its back. The helicopter was destroyed by ground fire. - [NTSB MKC88LA181](https://openairdocs.org/ntsb/MKC88LA181.md): Beech 77 · Friendship, AR · Accident · No injuries · Limited investigation · Final report · Sep 28, 1988 · N67572 · Substantial damage > The CFI rprtd he was demonstrating an emergency landing to a pvt rated plt & confusion (about who was flying the acft) resulted in a commitment to land. The landing was made on a gravel road. During the roll-out, the acft veered into a ditch & was damaged. - [NTSB NYC88LA244](https://openairdocs.org/ntsb/NYC88LA244.md): Cessna 177 · Machias, ME · Accident · No injuries · Limited investigation · Final report · Sep 27, 1988 · N2839X · Substantial damage > The plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the… - [NTSB MKC88LA179](https://openairdocs.org/ntsb/MKC88LA179.md): Piper PA-12 · Bertrand, NE · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1988 · N3390M · Substantial damage > The plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,… - [NTSB FTW88DPA10](https://openairdocs.org/ntsb/FTW88DPA10.md): Bell 206L-1 · Fort Worth, TX · Accident · No injuries · Final report · Sep 25, 1988 · N1069Q · Substantial damage > The rated helicopter pilot was undergoing recurrent training with an instructor at a training field. During a practice autorotation to a landing, the helicopter went into a high sink rate with a low main rotor RPM. The helicopter touched down hard in a tail… - [NTSB CHI88LA245](https://openairdocs.org/ntsb/CHI88LA245.md): Cessna 150F · Baraboo, WI · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N381VU · Substantial damage > While landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing… - [NTSB CHI88FA244](https://openairdocs.org/ntsb/CHI88FA244.md): Piper PA-28 · Hutchinson, MN · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1988 · N6151W · Destroyed > Failure of the student rated pilot to use proper control inputs and procedures to regain and maintain control of the airplane while executing a go-around from a bounced landing. The pilots lack of total experience is a contributing factor in the cause. - [NTSB CHI88LA246](https://openairdocs.org/ntsb/CHI88LA246.md): Cessna 150G · Butler, IN · Accident · No injuries · Limited investigation · Final report · Sep 24, 1988 · N8570J · Substantial damage > During a solo flight, the student pilot attempted a landing on a neighbor's cow pasture. The student stated that he misjudged the approach to landing and landed long on the field. He was unable to adequately handle the aircraft and failed to get it stopped… - [NTSB SEA88LA187](https://openairdocs.org/ntsb/SEA88LA187.md): Cessna 210L · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N249CC · Substantial damage > The plt stated that on landing on the airstrip, which also serves as a roadway, he encountered a depression in the surface. The acft porpoised and departed the left side of the prepared surface. The plt added power and regained the prepared surface. He then… - [NTSB SEA88LA185](https://openairdocs.org/ntsb/SEA88LA185.md): Piper J3C-65 · Coeur D'Alene, ID · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N3647N · Substantial damage > When pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear. - [NTSB CHI88LA243](https://openairdocs.org/ntsb/CHI88LA243.md): Cessna 185F · Benson, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1988 · N3815Q · Destroyed > Witnesses reported that the aircraft bounced twice on the runway before the right wing tip struck the ground on the right side of the runway. The aircraft 'cartwheeled' and came to a rest on it's left side. - [NTSB CHI88LA241](https://openairdocs.org/ntsb/CHI88LA241.md): Cessna 550 · Fremont, MI · Accident · No injuries · Limited investigation · Final report · Sep 22, 1988 · N29TC · Substantial damage > The airplane ran off the end of the runway and struck an embankment after landing downwind from a VOR approach during heavy rain. Both pilots reported poor braking action and ineffectiveness of reverse thrust application after touchdown and during the landing… - [NTSB ANC88LA146](https://openairdocs.org/ntsb/ANC88LA146.md): Cessna 207A · New Koliganek, AK · Accident · No injuries · Limited investigation · Final report · Sep 22, 1988 · N1763U · Substantial damage > The pilot reported that he landed long on a rough 900' gravel strip. He was unable to stop the airplane before it went off the end of the runway and into the adjoining tundra. - [NTSB ANC88LA145](https://openairdocs.org/ntsb/ANC88LA145.md): Cessna 185F · Chip River, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1988 · N61500 · Substantial damage > The air taxi pilot was attempting to land on the snow covered tundra near his passenger's fish camp. The tundra had not yet frozen sufficiently to support the weight of the airplane, and the main landing gear quickly became mired in the soft soil, causing the… - [NTSB FTW88DPA08](https://openairdocs.org/ntsb/FTW88DPA08.md): North American TB-25N · Wichita Falls, TX · Accident · No injuries · Final report · Sep 19, 1988 · N9079Z · Substantial damage > During a period of light rain at dusk, the B-25 plt landed on a 4250 ft rwy. While landing, the acft touched down long & fast. Subsequently, it went off the departure end of the rwy & was damaged. - [NTSB NYC88LA239](https://openairdocs.org/ntsb/NYC88LA239.md): Cessna 152 · Mt.Holly, NJ · Accident · No injuries · Limited investigation · Final report · Sep 18, 1988 · N714YY · Substantial damage > Several landings and takeoffs were performed. On the last landing, the aircraft touched down first on the right main gear and then the left main gear. The pilot stated that the aircraft seemed to slide or skid to the right and continued onto the grassy area… - [NTSB FTW88DPA09](https://openairdocs.org/ntsb/FTW88DPA09.md): Aeronca 11AC · Athens, TX · Accident · Minor injuries · Final report · Sep 18, 1988 · N86311 · Substantial damage > After setting the aircraft down in the grass to the left of the runway, the pilot stated that a 40 mph wind gust picked the right wing up and set the aircraft on its nose. He attempted to keep the fuselage from tipping all the way over after disembarking;… - [NTSB ANC88LA144](https://openairdocs.org/ntsb/ANC88LA144.md): Maule M-5-235C · Porcupine Butte, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1988 · N56304 · Substantial damage > The plt rprtd he landed harder than he intended from about 3 to 5 ft above the ground. The right main gear collapsed & the acft veered to the right. Subsequently, the left main gear collapsed & the acft came to rest off the airstrip. - [NTSB LAX88LA318](https://openairdocs.org/ntsb/LAX88LA318.md): Cessna T310R · La Verne, CA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N5126J · Substantial damage > The pilot stated that he was troubleshooting a problem with the airplane's fuel flow system. During the preflight run-up, he noticed that the fuel flow gauge for the right engine was reading too high. He took off to see if he could make an inflight… - [NTSB DEN88LA206](https://openairdocs.org/ntsb/DEN88LA206.md): Cessna 172 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N97890 · Substantial damage > The student plt reported that he was making touch and go landings. During landing roll the crosswind lifted the right wing and caused the acft to drift to the left. The student plt said he attempted to correct the drift, to no avail. The left main wheel… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=382 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=381 --- 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.