# 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 383 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX88IA295](https://openairdocs.org/ntsb/LAX88IA295.md): Mcdonnell Douglas DC9-51 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Aug 20, 1988 · N689HA · Minor damage > The aircrafts encounter with the engine exhaust flow and related turbulence from a heavy Boeing 747, which crossed the approach end of the runway about 1 minute and ten seconds prior to the incident. - [NTSB DEN88LA188](https://openairdocs.org/ntsb/DEN88LA188.md): Cessna T210F · Ennis, MT · Accident · No injuries · Limited investigation · Final report · Aug 19, 1988 · N6132R · Substantial damage > While on a landing rollout, the left main gear strut failed & separated from the acft. The plt said he held the acft straight for about 600 ft, then it veered to the left & went off the rwy. Subsequently, the left wing & left horizontal stabilizer were… - [NTSB DEN88LA187](https://openairdocs.org/ntsb/DEN88LA187.md): Cessna 152 · Leadville, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 19, 1988 · N93538 · Substantial damage > The student plt was lost during a solo cross country instructional flight. After landing and refueling at Leadville, Colorado, he attempted to fly through a mountain pass towards his destination. He climbed the acft to 12,000 and tried to continue the climb.… - [NTSB CHI88DEC06](https://openairdocs.org/ntsb/CHI88DEC06.md): Sackett J2 · Deckerville, MI · Accident · Minor injuries · Final report · Aug 19, 1988 · N33131 · Destroyed > The pilot's poor judgement and misjudged perceptions while practicing takeoffs and landings in an unfamiliar aircraft. The pilot executed a hard landing, touching down short of the runway and collapsing the landing gear. The aircraft skidded to a stop on the… - [NTSB NYC88LA221](https://openairdocs.org/ntsb/NYC88LA221.md): Boeing A75N1 · Wellsville, PA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1988 · N7772J · Substantial damage > A private plt on a local flight made a stopover landing on runway 28. The plt reported that during the landing flare, he was temporarily blinded by the setting sun directly in the flight path. At touchdown the airplane weathervaned into the right crosswind,… - [NTSB DEN88LA190](https://openairdocs.org/ntsb/DEN88LA190.md): Cessna 177RG · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Aug 18, 1988 · N53049 · Substantial damage > The commercial plt was practicing short field landings from the right seat on a 7,498 x 100 ft asphalt rwy. The plt said he encountered a thermal at 10 ft AGL and stalled the airplane. He reported that the acft hit harder than he expected and bounced twice.… - [NTSB CHI88DEM10](https://openairdocs.org/ntsb/CHI88DEM10.md): Grumman G-164B · Schoolcraft, MI · Accident · No injuries · Final report · Aug 18, 1988 · N48417 · Substantial damage > The pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.… - [NTSB DEN88LA184](https://openairdocs.org/ntsb/DEN88LA184.md): Cessna A185F · Medicine Bow, WY · Accident · No injuries · Limited investigation · Final report · Aug 17, 1988 · N2450J · Substantial damage > The pvt plt returned to his ranch strip & landed to the ene with a x-wind from the right. Drg the lndg roll, the acft began to go to the right. The plt corrected with left pedal, but subsequently, the acft ground looped to the left & nosed over. An exam of… - [NTSB MKC88LA158](https://openairdocs.org/ntsb/MKC88LA158.md): Grumman G-164B · Humphrey, AR · Accident · No injuries · Limited investigation · Final report · Aug 16, 1988 · N8405K · Substantial damage > While attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed… - [NTSB MIA88IA255](https://openairdocs.org/ntsb/MIA88IA255.md): Piper PA-44-180 · Vero Beach, FL · Incident · No injuries · Incident investigation · Final report · Aug 16, 1988 · N2193V · Minor damage > The CFI & his pvt plt-rated multi eng student were conducting touch & go ldgs in preparation for the multi-eng rating. The CFI stated that one of the ldgs was harder than usual, but not overly hard. On the next aprch, they noticed the rt gear indicator was… - [NTSB CHI88LA208](https://openairdocs.org/ntsb/CHI88LA208.md): Beech C55 · Cahokia, IL · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N19RE · Substantial damage > While on a maintenance test hop after annual inspection, the pilot failed to insure that the landing gear was extended before touchdown. The pilot stated that the gear handle was placed in the gear down position, and that no gear warning horn sounded during… - [NTSB CHI88LA204](https://openairdocs.org/ntsb/CHI88LA204.md): Cessna 152 · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N94954 · Substantial damage > On landing the aircraft bounced resulting in a porpoise. The nose gear collapsed rendering substantial damage to the aircraft. - [NTSB CHI88DEM09](https://openairdocs.org/ntsb/CHI88DEM09.md): Hulliberger Starduster II · White Cloud, MI · Accident · No injuries · Final report · Aug 15, 1988 · N939H · Substantial damage > Unauthorized pilot failed to maintain adequate control of the homebuilt aircraft during the landing roll. The aircraft veered off the right side of the runway, and the left wing struck the ground. - [NTSB CHI88LA211](https://openairdocs.org/ntsb/CHI88LA211.md): Piper PA-28-140 · Hobart, IN · Accident · No injuries · Limited investigation · Final report · Aug 14, 1988 · N95472 · Substantial damage > While on a solo instructional flight for the purpose of practicing crosswind takeoffs and landings, the student pilot failed to adequately compensate for the crosswind and experienced a loss of directional control shortly after the aircraft touched down. The… - [NTSB ANC88LA109](https://openairdocs.org/ntsb/ANC88LA109.md): Piper PA-32 · Kwethluk, AK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1988 · N32062 · Substantial damage > The pilot lost directional control of the aircraft while landing. At the time of accident the wind was from 180 degrees at 15 knots gusting 20 knots. The airplane landed on runway 25; after touchdown the airplane departed the right side of the runway into an… - [NTSB CHI88LA207](https://openairdocs.org/ntsb/CHI88LA207.md): Piper PA-28R-201 · Dodgeville, WI · Accident · No injuries · Limited investigation · Final report · Aug 13, 1988 · N47804 · Substantial damage > During an attempted landing in gusty wind, the pilot failed to maintain directional control, got blown off to the left side of the runway and experienced a tail strike. The pilot attempted to abort the landing, but was unable to climb out of ground effect,… - [NTSB CHI88IA200](https://openairdocs.org/ntsb/CHI88IA200.md): Aerospatiale ATR-42-300 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 12, 1988 · N426MQ · No damage - [NTSB MIA88LA253](https://openairdocs.org/ntsb/MIA88LA253.md): Cessna 172D · Tupelo, MS · Accident · No injuries · Limited investigation · Final report · Aug 11, 1988 · N2344U · Substantial damage > The private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially… - [NTSB LAX88LA284](https://openairdocs.org/ntsb/LAX88LA284.md): Cessna 150M · Gila Bend, AZ · Accident · No injuries · Limited investigation · Final report · Aug 11, 1988 · N704GJ · Substantial damage > At the end of a cross country flight, the pilot overflew the runway looking for the wind sock. Unable to locate the sock, the pilot made an approach for landing. The pilot did not realize until too late that he was landing the airplane with a 10 knot… - [NTSB ANC88LA108](https://openairdocs.org/ntsb/ANC88LA108.md): Piper PA-18 · Chandalar River, AK · Accident · No injuries · Limited investigation · Final report · Aug 9, 1988 · N8066C · Substantial damage > After touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back. - [NTSB CHI88LA196](https://openairdocs.org/ntsb/CHI88LA196.md): Cessna 320E · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N222L · Substantial damage > Drg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose… - [NTSB ANC88LA112](https://openairdocs.org/ntsb/ANC88LA112.md): Piper PA-12 · Galena, AK · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N7964H · Substantial damage > The student pilot lost directional control of the airplane during landing on the tundra. During the rollout the airplane nosed over on its back. The pilot could not be found to accomplish the required accident report. - [NTSB SEA88LA146](https://openairdocs.org/ntsb/SEA88LA146.md): Cessna 182 · Veradale, WA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N71035 · Destroyed > The pilot stated a high sink rate developed on final approach which he was unable to arrest with power. Acft landed hard and short, contacting a 3-FT berm at end of grass strip. During roll-out, flames were noted in aft cabin area. Occupants exited and acft… - [NTSB NYC88LA205](https://openairdocs.org/ntsb/NYC88LA205.md): Cocks Starduster SA-300 · Stormville, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1988 · N34BC · Substantial damage > The pilot of a starduster SA-300 was on a local flight when he landed at an uncontrolled airport which had been notamed closed and had an x on the approach end of the runway. The pilot said a vehicle obscured the approach end during the approach and then left… - [NTSB MKC88DCD02](https://openairdocs.org/ntsb/MKC88DCD02.md): Prairie Flyers Tierra II · Prairie City, IA · Accident · Serious injuries · Final report · Aug 7, 1988 · N823PF · Destroyed > The pilot was attempting to land in a hayfield and decided to abort the landing due to rough condition of field. As he pushed the throttle forward, the engine faltered and the plane touched down. The aborted landing was continued due to speed and… - [NTSB MIA88FA248](https://openairdocs.org/ntsb/MIA88FA248.md): Mooney M20G · Lantana, FL · Accident · Serious injuries · Field investigation · Final report · Aug 7, 1988 · N4103N · Substantial damage > Plt attempted to land with a left quartering tail wind. The aircraft landed hard and bounced several times. The plt initiated a go-around and during climbout from the go-around the pilot initiated a steep left turn with 30 to 40 degrees of bank and with a… - [NTSB FTW88LA144](https://openairdocs.org/ntsb/FTW88LA144.md): Bellanca 7ECA · Kingsland, TX · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N57430 · Substantial damage > The tail-dragger touched down on the left gear, then the right gear. The pilot applied power for a go-around but he said he then cut it off because he was going to be going so close to the hangar. The airplane went off the left side of the runway and… - [NTSB CHI88LA194](https://openairdocs.org/ntsb/CHI88LA194.md): Cessna 150K · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N5796G · Substantial damage > Hard landing made by the student pilot resulting in a nose gear failure due to overload forces and the aircraft flipping over on its back. - [NTSB LAX88LA281](https://openairdocs.org/ntsb/LAX88LA281.md): Cessna 172P · Imperial, CA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N53571 · Substantial damage > During a solo instructional flt, while landing, a gust of wind raised one wing, putting weight on main wheel and one nose wheel. The pilot regained control; however, the airplane veered off the runway and nosed over in the soft dirt. - [NTSB FTW88DPJ09](https://openairdocs.org/ntsb/FTW88DPJ09.md): Cessna 152 · Skiatook, OK · Accident · No injuries · Final report · Aug 6, 1988 · N53321 · Substantial damage > The student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient… - [NTSB DEN88LA177](https://openairdocs.org/ntsb/DEN88LA177.md): Rossi Pitts S-1S · Butte, MT · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N59J · Destroyed - [NTSB CHI88LA197](https://openairdocs.org/ntsb/CHI88LA197.md): Cessna 310RII · Noblesville, IN · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N98980 · Substantial damage > During the landing roll, shortly after touchdown and brake application, the left main landing gear collapsed due to the failure of the drag brace. The pilot was unable to maintain directional control of the aircraft and it veered off the left side of the… - [NTSB LAX88LA280](https://openairdocs.org/ntsb/LAX88LA280.md): Bellanca 7ECA · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1988 · N8662V · Substantial damage > All of the pilot's prior flight training was done in tailwheel type aircraft. The pilot had made four full stop landings during the pattern practice instructional session and he said that he experienced directional control problems during each of the… - [NTSB DEN88LA175](https://openairdocs.org/ntsb/DEN88LA175.md): Braswell Scirroco MJ5-K2 · Hurricane, UT · Accident · No injuries · Limited investigation · Final report · Aug 4, 1988 · N6XY · Substantial damage > The plt said he made a short flt to check out a mag. The eng performed satisfactorily and he landed. Upon touchdown one of the main landing gear collapsed and the tailwheel equipped acft ground looped. The plt said a gear downlock failed. The FAA… - [NTSB BFO88LA072](https://openairdocs.org/ntsb/BFO88LA072.md): Piper PA-30-160R · Chantilly, VA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1988 · N7866Y · Substantial damage > The instr & stu plt were doing a practice landing on rwy 27 at the front royal airport when the acft landed hard and bounced about 20 ft high. A go around was made, however, the landing gear would not retract. After two flyovers of the arpt it was confirmed… - [NTSB SEA88LA142](https://openairdocs.org/ntsb/SEA88LA142.md): Cessna 152 · Auburn, WA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N4651P · Substantial damage > The student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter. - [NTSB MIA88FA244](https://openairdocs.org/ntsb/MIA88FA244.md): Cessna 150M · Pahokee, FL · Accident · Serious injuries · Field investigation · Final report · Aug 3, 1988 · N63354 · Destroyed > The acft crashed while the plt was attempting a touch and go landing at Pahokee airport, Pahokee FL. The plt stated that when he landed on runway 17, the acft bounced. As he was attempting a go around, he lost control. The acft stalled, broke left, and… - [NTSB DEN88LA173](https://openairdocs.org/ntsb/DEN88LA173.md): Cessna 195B · Watkins, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1988 · N195RC · Substantial damage > The new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another… - [NTSB CHI88LA189](https://openairdocs.org/ntsb/CHI88LA189.md): Cessna 152 · Eau Claire, WI · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N93411 · Substantial damage - [NTSB ANC88LA103](https://openairdocs.org/ntsb/ANC88LA103.md): Piper PA-18 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N1192C · Substantial damage > The private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,… - [NTSB MIA88LA243](https://openairdocs.org/ntsb/MIA88LA243.md): Cessna 180J · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1988 · N9962N · Substantial damage > The plt stated that he was attempting a wheel landing. On rollout he 'hit' the brakes. The acft nosed over and came to rest inverted. - [NTSB ATL88LA224](https://openairdocs.org/ntsb/ATL88LA224.md): Piper PA-38-112 · Reidsville, NC · Accident · No injuries · Limited investigation · Final report · Aug 2, 1988 · N26045 · Substantial damage > The student plt rprtd that while landing, the airplane began to veer to the left. Subsequently, it ran off the left side of the rwy & into a ditch. A crosswind was blowing from the left at the time. The operator rprtd that tire marks from the nose & right… - [NTSB MIA88IA240](https://openairdocs.org/ntsb/MIA88IA240.md): Mcdonnell Douglas MD-88 · Pensacola, FL · Incident · No injuries · Incident investigation · Final report · Aug 1, 1988 · N924DL · No damage > The captain stated that he crossed the final approach fix at 3000 feet, continued the approach, touched down at 140 knots at the end of the touchdown zone, but could not stop the acft and ran off the end of runway 16. According to tower personnel and… - [NTSB ATL88LA223](https://openairdocs.org/ntsb/ATL88LA223.md): Piper PA-34-200T · Laurens, SC · Accident · No injuries · Limited investigation · Final report · Aug 1, 1988 · N8191J · Substantial damage > The plt rprtd that when he landed, everything seemed normal until he was lowering the nose to the rwy drg the landing roll. At that time, the left wing began to settle. At first, he thought the left tire was going flat, but the settling continued.… - [NTSB ANC88LA102](https://openairdocs.org/ntsb/ANC88LA102.md): Piper PA-18 · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Aug 1, 1988 · N8580D · Substantial damage > The private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.… - [NTSB CHI88LA182](https://openairdocs.org/ntsb/CHI88LA182.md): Piper PA-38-112 · Flint, MI · Accident · No injuries · Limited investigation · Final report · Jul 31, 1988 · N2539G · Substantial damage > While on a solo instructional flight for the purpose of practicing takeoffs and landings, the student pilot executed a hard landing. The aircraft bounced; when it touched down again, the nose gear collapsed and the aircraft skidded to a stop on the runway. - [NTSB CHI88LA181](https://openairdocs.org/ntsb/CHI88LA181.md): Cessna 152 · Belleville, MI · Accident · No injuries · Limited investigation · Final report · Jul 31, 1988 · N69120 · Substantial damage > During a solo instructional flight for the purpose of practicing touch and gos, the student pilot experienced a loss of control when the aircraft bounced after a hard landing. The pilot failed to perform remedial action as the aircraft continued to porpoise… - [NTSB CHI88DEE08](https://openairdocs.org/ntsb/CHI88DEE08.md): Townson Starduster SA100 · Monee, IL · Accident · No injuries · Final report · Jul 31, 1988 · N9119R · Substantial damage > Pilot failing to maintain control of the airplane during landing touchdown and roll out. - [NTSB NYC88LA199](https://openairdocs.org/ntsb/NYC88LA199.md): Cessna 172L · No. Kingstown, RI · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1988 · N19699 · Substantial damage > The failure of the boston center controller to adequately understand the pilot-in-command's request and to assess the gravity of the situation. - [NTSB LAX88DVG09](https://openairdocs.org/ntsb/LAX88DVG09.md): Schweizer G-164B · Robbins, CA · Accident · No injuries · Final report · Jul 30, 1988 · N3633C · Substantial damage > During landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=384 ## 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=383 --- 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.