# 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 384 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB SEA88LA141](https://openairdocs.org/ntsb/SEA88LA141.md): Cessna 152 · Ft. Lewis, WA · Accident · No injuries · Limited investigation · Final report · Jul 29, 1988 · N24995 · Substantial damage > The pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire… - [NTSB CHI88LA184](https://openairdocs.org/ntsb/CHI88LA184.md): Piper J-3 · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Jul 29, 1988 · N92483 · Substantial damage > During a dual instructional flight for the purpose of practicing takeoffs and landings with a pre-solo student, the instructor pilot failed to maintain adequate aircraft control and visual lookout, and the aircraft departed the right side of the runway,… - [NTSB CHI88FA178](https://openairdocs.org/ntsb/CHI88FA178.md): Sonerai IIL · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Jul 28, 1988 · N398 · Substantial damage - [NTSB CHI88FA177](https://openairdocs.org/ntsb/CHI88FA177.md): Quickie Q-2 · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Jul 28, 1988 · N48BH · Substantial damage > The plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the… - [NTSB ANC88LA099](https://openairdocs.org/ntsb/ANC88LA099.md): Piper PA-14 · Kustatan River, AK · Accident · No injuries · Limited investigation · Final report · Jul 28, 1988 · N5135H · Substantial damage > The private pilot was attempting to land his Piper PA-14 airplane at a remote beach fishing site in gusty crosswind conditions. He reportedly encountered a wind gust upon touch down, lost directional control and struck an abandoned hunting shack and an… - [NTSB MKC88LA139](https://openairdocs.org/ntsb/MKC88LA139.md): Grumman G164-B · Gould, AR · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N54JS · Substantial damage > The pilot said that while returning from an aerial application operation, he lost directional control during the ldg. He veered off the concrete runway, into the soft, tall grass border, and nosed over. - [NTSB MKC88LA138](https://openairdocs.org/ntsb/MKC88LA138.md): Cessna 172 · Lamar, MO · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N29168 · 2 aircraft · Substantial damage > The plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming… - [NTSB ANC88LA098](https://openairdocs.org/ntsb/ANC88LA098.md): Cessna 180A · Northway, AK · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N5327D · Substantial damage > The commercially certificated pilot was landing at Northway, AK., when the airplane ground-looped to the left. He reportedly had also ground-looped the same airplane when he landed at whitehorse, Canada, just prior to the landing at Northway. A post-accident… - [NTSB ANC88LA097](https://openairdocs.org/ntsb/ANC88LA097.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N8653Y · Substantial damage > The private pilot and his passenger were uninjured when their Piper PA-18 (super cub) ground-looped while landing at Anchorage international airport, Anchorage, AK. The pilot stated that the right main landing gear tire 'grabbed' when it touched the paved… - [NTSB CHI88LA175](https://openairdocs.org/ntsb/CHI88LA175.md): Beech 35R · Manito, IL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1988 · N3016V · Substantial damage > Drg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just… - [NTSB MIA88LA238](https://openairdocs.org/ntsb/MIA88LA238.md): Piper PA-44-180 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N2197K · Substantial damage > The CFI stated they had completed 2 touch & go ldgs without incident. On the next, the acft 'suddenly yawed to the left & the side load must have weakened the gear as the gear warning horn began to sound indicating the gear was no longer down & locked'. He… - [NTSB LAX88LA291](https://openairdocs.org/ntsb/LAX88LA291.md): Cessna T210K · Huntington Bch, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N8273M · Substantial damage > During the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an… - [NTSB LAX88LA270](https://openairdocs.org/ntsb/LAX88LA270.md): Cessna 152 · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N68342 · Substantial damage > The student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed. - [NTSB DEN88LA174](https://openairdocs.org/ntsb/DEN88LA174.md): Cessna 172M · Gillette, WY · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N5266J · Substantial damage > The student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of… - [NTSB DEN88LA166](https://openairdocs.org/ntsb/DEN88LA166.md): Krall Dragonfly · Mitchell, SD · Accident · No injuries · Limited investigation · Final report · Jul 25, 1988 · N42JK · Substantial damage > Drg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but… - [NTSB CHI88DEX10](https://openairdocs.org/ntsb/CHI88DEX10.md): Williams Waco · Madison, IN · Accident · No injuries · Final report · Jul 24, 1988 · N810TW · Substantial damage > The plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the… - [NTSB MKC88LA122](https://openairdocs.org/ntsb/MKC88LA122.md): Rockwell S2R · Brinkley, AR · Accident · No injuries · Limited investigation · Final report · Jul 23, 1988 · N4080X · Substantial damage > During the take-off roll for an aerial application operation, the pilot said he lost his left wheel braking capability. He continued the take-off, flew to the farm field to be treated, applied the load, then returned to a near by alternate landing strip… - [NTSB MIA88LA235](https://openairdocs.org/ntsb/MIA88LA235.md): Cessna 172M · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1988 · N12840 · Substantial damage > After a normal lndg, during the lndg roll at aprx 50-55 mph, the acft rolled through a 1-2' deep puddle of water. The acft slowed & at aprx 35 mph, the rt main lndg gear slowly began rotating aft. The acft came to rest supported by the rt horizontal… - [NTSB CHI88LA172](https://openairdocs.org/ntsb/CHI88LA172.md): Aeronca 7AC · Greenfield, IN · Accident · No injuries · Limited investigation · Final report · Jul 23, 1988 · N83430 · Substantial damage > During a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,… - [NTSB ANC88LA095](https://openairdocs.org/ntsb/ANC88LA095.md): Cessna 207A · Kongiganak, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 1988 · N1773U · Substantial damage > The aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this… - [NTSB CHI88LA173](https://openairdocs.org/ntsb/CHI88LA173.md): Piper J-3 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Jul 22, 1988 · N25WF · Substantial damage > While practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90… - [NTSB MIA88IA230](https://openairdocs.org/ntsb/MIA88IA230.md): Piper PA-34-200T · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Jul 21, 1988 · N47506 · Minor damage > Shortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.… - [NTSB FTW88LA135](https://openairdocs.org/ntsb/FTW88LA135.md): Piper PA-24-260 · La Grange, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1988 · N8949P · Substantial damage > The pilot said he flew over the airport and found the winds favored a landing on runway 18. He said he descended to the downwind leg, and when he added power, the engine would not respond. However, he said the engine continued to run. He decided to make an… - [NTSB NYC88LA172](https://openairdocs.org/ntsb/NYC88LA172.md): Cessna 150 · Massena, NY · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N704HT · Substantial damage > The student pilot on a crosscountry flight to Massena, new york stated that during the landing approach he felt that he was too low and when he tried to correct, the aircraft bounced. On the second touchdown the nose gear collapsed and the aircraft slid off… - [NTSB ANC88DAG06](https://openairdocs.org/ntsb/ANC88DAG06.md): Air Command 532 Elite · Palmer, AK · Accident · No injuries · Final report · Jul 18, 1988 · N1925 · Substantial damage > During landing approach an excessive rate of descent developed very near the runway. The gyroplane landed hard. After the hard landing the pilot reported that he pulled the control column to its aft position abruptly. The small tail wheel struck the runway… - [NTSB FTW88LA133](https://openairdocs.org/ntsb/FTW88LA133.md): Cessna 310B · Ruston, LA · Accident · No injuries · Limited investigation · Final report · Jul 17, 1988 · N295C · 2 aircraft · Minor damage > Both airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310… - [NTSB MIA88LA222](https://openairdocs.org/ntsb/MIA88LA222.md): Cessna 150G · Keystone Height, FL · Accident · No injuries · Limited investigation · Final report · Jul 16, 1988 · N3983J · Substantial damage > While on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over… - [NTSB LAX88LA261](https://openairdocs.org/ntsb/LAX88LA261.md): Cessna 185E · Lone Pine, CA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1988 · N23FB · Substantial damage > The plt rpted that the engine cylinder temperature was very high as he crossed mountainous terrain. He elected to make a downwind precautionary landing to a short airstrip with a high density altitude. The acft touched down beyond the normal touchdown zone,… - [NTSB CHI88LA168](https://openairdocs.org/ntsb/CHI88LA168.md): Enstrom 280FX · Menominee, MI · Accident · No injuries · Limited investigation · Final report · Jul 16, 1988 · N280FX · Substantial damage > During a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid… - [NTSB DEN88LA159](https://openairdocs.org/ntsb/DEN88LA159.md): Boeing A75N1 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N772WM · Substantial damage - [NTSB LAX88LA255](https://openairdocs.org/ntsb/LAX88LA255.md): General Balloon AX-6 · Pilot Hill, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1988 · N2614M · No damage > During a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds… - [NTSB CHI88IA165](https://openairdocs.org/ntsb/CHI88IA165.md): Mcdonnell Douglas MD80 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 14, 1988 · N253A · No damage - [NTSB CHI88LA166](https://openairdocs.org/ntsb/CHI88LA166.md): Gulfstream Aerospace G-21-G · Elyria, OH · Accident · No injuries · Limited investigation · Final report · Jul 13, 1988 · N77AQ · Substantial damage - [NTSB MIA88LA219](https://openairdocs.org/ntsb/MIA88LA219.md): Rockwell S-2R · Palm City, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N8502V · Substantial damage > The plt stated that he landed long on a dirt and grass road. During landing roll, he applied heavy brakes to stop the acft. The acft swerved to the left. He unsuccessfully tried to regain control. The a/c went down an embankment and the left wing dug into a… - [NTSB LAX88LA253](https://openairdocs.org/ntsb/LAX88LA253.md): Cessna T210L · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N60856 · Substantial damage > During the landing roll, the right brake failed to hold. The airplane veered to the left, off the runway and collided with a runway light. Inspection of the brake revealed that there was no fluid in the system. No leaks were discovered during the exam of the… - [NTSB DEN88LA154](https://openairdocs.org/ntsb/DEN88LA154.md): Piper PA-18 · Cody, WY · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N6083A · Substantial damage > During landing on a ranch road while on a business flight the plt struck a pile of gravel placed on the road to facilitate road repairs. The aircraft flipped over and caused substantial damage to the vertical stabilizer, horizontal stabilizer, propeller and… - [NTSB ANC88LA089](https://openairdocs.org/ntsb/ANC88LA089.md): Piper PA-22 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N2747P · 2 aircraft · Substantial damage > Witnesses stated that acft #1 (N2747P,a Piper PA-22), flew a right downwind about 200 feet above the ground and then made a steep descending turn toward the runway. Acft #1 landed and struck acft #2 (N9102D, a Piper PA-18) while both were on the runway. The… - [NTSB CHI88LA164](https://openairdocs.org/ntsb/CHI88LA164.md): Cessna 210M · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jul 10, 1988 · N210WP · Substantial damage > The pilot reported that he was on his way back from another local airport. He thought that he had lowered the gear when he had entered the traffic pattern. The aircraft landed gear up. Post-accident exam disclosed no mechanical failures or system malfunctions… - [NTSB CHI88FA162](https://openairdocs.org/ntsb/CHI88FA162.md): Cessna 172M · Holland, MI · Accident · 1 fatal · Field investigation · Final report · Jul 10, 1988 · N80943 · Destroyed > Pilot's inadequate aircraft handling during the approach to landing and landing flare phase of flight. The pilot's failure to recognize and avoid a situation from which it was impossible-due to the weight of the aircraft, the amount of power available from… - [NTSB BFO88LA066](https://openairdocs.org/ntsb/BFO88LA066.md): Balloon Works AX-8 · Purcellville, VA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1988 · N7108 · Minor damage > The pilot landed the hot air Balloon at an excessive descent rate which resulted in a hard landing. Wind gust are a contributing factor. - [NTSB ANC88LA088](https://openairdocs.org/ntsb/ANC88LA088.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 10, 1988 · N4346B · Substantial damage > After touchdown on the airstrip the pilot lost control of the airplane. The airplane bounced. The airplane then exited the left side of the runway into a row of trees. - [NTSB SEA88LA133](https://openairdocs.org/ntsb/SEA88LA133.md): de Havilland DHC-2 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N67679 · Substantial damage > On the first leg of the scheduled float plane flight the plt had landed on lake union to embark addl pax. As the acft decelerated 'off the step,' a power boat converged on acft path. Plt made rudder input to avoid collision and wingtip contacted water. - [NTSB FTW88IA129](https://openairdocs.org/ntsb/FTW88IA129.md): Embraer EMB-110P1 · Abilene, TX · Incident · No injuries · Incident investigation · Final report · Jul 9, 1988 · N91DA · Minor damage > The airplane touched down on the main wheels, bounced, then touched down on the runway with all three landing gear retracted with the gear doors closed. During the investigation, no electrical, mechanical, or hydraulic malfunctions could be found. The landing… - [NTSB DEN88LA155](https://openairdocs.org/ntsb/DEN88LA155.md): Cessna 152 · Aurora, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1988 · N67712 · Substantial damage > This was the student pilot's first solo landing. She said the acft drifted to the left of the centerline during the landing roll and she attempted to correct with right rudder. However, the acft continued to the left and ran off the left side of the rwy. The… - [NTSB DEN88LA150](https://openairdocs.org/ntsb/DEN88LA150.md): Piper PA-28R-201T · Erie, CO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N135E · Substantial damage - [NTSB ANC88LA085](https://openairdocs.org/ntsb/ANC88LA085.md): Maule M6-235 · Egegik, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 9, 1988 · N5647Y · Substantial damage > After touchdown on the beach, the aircraft struck a three-wheeled scooter (atv). The atv was substantially damaged and the driver of the atv, an eleven year old boy, died a few days later. The atv passenger, a eight year old girl, received minor injuries.… - [NTSB SEA88LA124](https://openairdocs.org/ntsb/SEA88LA124.md): Cessna 152 · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1988 · N4590P · Substantial damage > Plt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover. - [NTSB MKC88LA130](https://openairdocs.org/ntsb/MKC88LA130.md): Beech A-36 · Marion, IA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1988 · N25496 · Substantial damage > While attempting to land after one go-around. Witnesses said the acft touched down beyond the half way point on the 2300 foot sod runway. He appeared to be high and fast according to witnesses. The pilot said he might have mistaken the threshold and landed… - [NTSB MIA88LA218](https://openairdocs.org/ntsb/MIA88LA218.md): Cessna 150F · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · Jul 8, 1988 · N8691S · Substantial damage > The student pilot was on a solo instructional flight. The winds were reported to him as a 20-30 degree crosswind at 15 knots gusting to 20. The student pilot lost control of the acft. The right wing contacted the runway, then the acft nosed over. The pilot… - [NTSB CHI88LA161](https://openairdocs.org/ntsb/CHI88LA161.md): Cessna 170B · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Jul 8, 1988 · N8048A · Substantial damage Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=385 ## 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=384 --- 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.