# 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 386 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX88LA223](https://openairdocs.org/ntsb/LAX88LA223.md): Cessna 152 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Jun 14, 1988 · N49792 · Substantial damage > While flying the third supervised solo, during the first landing, the pilot lost control of the airplane which veered off the runway. The airplane came to rest inverted. There were no reported mechanical failures or malfunctions with the airplane prior to the… - [NTSB SEA88IA108](https://openairdocs.org/ntsb/SEA88IA108.md): Boeing 727-200 · Seattle, WA · Incident · Minor injuries · Incident investigation · Final report · Jun 13, 1988 · N308AS · Minor damage > After the main gear touched down, thrust levers were placed in the idle reverse position. Once the aircraft's nose gear contacted the runway, braking and full reverse thrust was applied. The aircraft started to drift to the left of the runway centerline. The… - [NTSB MIA88LA189](https://openairdocs.org/ntsb/MIA88LA189.md): Cessna 402B · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Jun 13, 1988 · N7628Q · Substantial damage > The right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt. - [NTSB FTW88LA137](https://openairdocs.org/ntsb/FTW88LA137.md): Cessna 182D · Gilmer, TX · Accident · No injuries · Limited investigation · Final report · Jun 13, 1988 · N9087X · Substantial damage > The pilot said he made two approaches to runway 17 and two go-arounds. He said the wind then changed direction and he set-up for landing on runway 35. He said he should have gone around for the third time but instead he landed long, went through a fence and… - [NTSB SEA88LA111](https://openairdocs.org/ntsb/SEA88LA111.md): Piper PA-22-135 · Kelso, WA · Accident · No injuries · Limited investigation · Final report · Jun 12, 1988 · N1453A · Substantial damage > The plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and… - [NTSB FTW88LA121](https://openairdocs.org/ntsb/FTW88LA121.md): Lake LA-4-200 · Mico, TX · Accident · No injuries · Limited investigation · Final report · Jun 12, 1988 · N666BK · Substantial damage > The pilot said he was practicing water landings in the Lake. During a landing, the airplane started porpoising due to the wake of a passing boat. The airplane landed hard. The windsheild cracked and the pilot elected to take the airplane to the home airport… - [NTSB ATL88LA193](https://openairdocs.org/ntsb/ATL88LA193.md): Cessna 195A · Port Clinton, OH · Accident · No injuries · Limited investigation · Final report · Jun 12, 1988 · N1527D · Substantial damage > During touchdown, the pilot noted a vibration and the airplane veered to the left. He attempted to correct by applying right brake and rudder, but the airplane continued off the left side of the runway into the grass. The right landing gear strut failed at… - [NTSB NYC88LA164](https://openairdocs.org/ntsb/NYC88LA164.md): Boeing A75N1 · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Jun 11, 1988 · N2313 · Substantial damage > The pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a… - [NTSB NYC88LA187](https://openairdocs.org/ntsb/NYC88LA187.md): Stinson 108-1 · Robbinsville, NJ · Accident · No injuries · Limited investigation · Final report · Jun 10, 1988 · N97954 · Substantial damage > The acft ground looped during landing roll and collided with terrain off the runway. The acft was landed on rwy 29 with the wind from 180 degrees at 15 KTS, gusting to 25 KTS. The acft turned into the wind and ran off the rwy to the south after traveling 1/3… - [NTSB LAX88LA220](https://openairdocs.org/ntsb/LAX88LA220.md): Cessna 152 · Redding, CA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1988 · N25409 · Substantial damage > During a solo instructional flt, the pilot stated that he may have had his foot on the left rudder pedal on landing. When the airplane touched down it veered to the left off the runway and into a ditch. There were no reported mechanical failures or… - [NTSB ATL88LA192](https://openairdocs.org/ntsb/ATL88LA192.md): Piper PA-38-112 · Mccormick, SC · Accident · No injuries · Limited investigation · Final report · Jun 10, 1988 · N2609G · Substantial damage > The student pilot was on her second solo cross country flight. She had deptd donaldson center near greenville, SC and had flown to athens, ga where she had completed a touch and go landing. She then proceeded to Mccormick, SC and flew over the airport to… - [NTSB CHI88LA132](https://openairdocs.org/ntsb/CHI88LA132.md): Cessna 172 · Fairmont, MN · Accident · No injuries · Limited investigation · Final report · Jun 9, 1988 · N5317K · Substantial damage > The student pilot was attempting to land. Just prior to touchdown a gust of wind pushed the aircraft to the left of the runway. The pilot was unable to maintain control of the aircraft resulting in the aircraft encountering a stall and colliding with the… - [NTSB CHI88LA130](https://openairdocs.org/ntsb/CHI88LA130.md): Piper PA-24-250 · Bedford, IN · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N7151P · Substantial damage > The pilot landed beyond his intended touchdown point on the runway due to excessive airspeed during the approach to landing and touchdown. When the aircraft ran off the departure end of the runway the pilot elected to perform an intentional ground loop/swerve… - [NTSB ATL88LA189](https://openairdocs.org/ntsb/ATL88LA189.md): Cessna 152 · East Liverpool, OH · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N89059 · Substantial damage > The student pilot reported that he flared late during ldg. The airplane ballooned and started drifting to the right. The student added pwr and left rudder in an attempt to maintain control; he 'overcompensated' with left rudder input, and lost directional… - [NTSB LAX88LA208](https://openairdocs.org/ntsb/LAX88LA208.md): Piper PA-34-200T · Corona, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1988 · N2710M · Substantial damage > Company maintenance personnel had replaced the nose landing gear assy and had conducted retraction tests prior to releasing the acft for flt. After takeoff the lndg gear was retracted and the flt was conducted without incident until, upon entering the traffic… - [NTSB BFO88IA057](https://openairdocs.org/ntsb/BFO88IA057.md): Piper PA-31 · Morgantown, WV · Incident · 1 fatal · Incident investigation · Final report · Jun 7, 1988 · N811CM · No damage > The pilot died from coronary disease while practicing landings. - [NTSB BFO88LA053](https://openairdocs.org/ntsb/BFO88LA053.md): Cessna 172P · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Jun 6, 1988 · N65720 · Substantial damage > According to the plt, after touchdown the acft encountered a crosswind gust. The acft drifted left of the rwy where it collided with trees. The plt reported no mechanical malfunction. - [NTSB NYC88LA159](https://openairdocs.org/ntsb/NYC88LA159.md): Schweizer SGS-2-33 · Erwinna, PA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N1240S · Substantial damage > Accident was a loss of directional control during landing which followed a hard landing. Contributing was the improper use of spoiler control by the private pilot and the failure of the flight instructor to adequately supervise the actions of the private… - [NTSB MKC88LA109](https://openairdocs.org/ntsb/MKC88LA109.md): Cessna 182 · Dewitt, AR · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N97536 · Substantial damage > The pilot was attempting to land on his personal grass strip, which had trees at both ends. The acft hit hard, bounced, then slid to a stop. The nose gear was separated. - [NTSB SEA88LA105](https://openairdocs.org/ntsb/SEA88LA105.md): Cessna 175 · Olympia, WA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N90134 · Substantial damage > After reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of… - [NTSB LAX88LA210](https://openairdocs.org/ntsb/LAX88LA210.md): American AA-1 · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N6181L · Substantial damage > During the landing while on a solo (instructional) night cross country flight, the airplane touched down, bounced, and veered left. During the second bounce between the runway and the taxiway, the pilot added power. The airplane continued in a straight path… - [NTSB DEN88LA124](https://openairdocs.org/ntsb/DEN88LA124.md): Cessna A-185F · Phillipsburg, MT · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N94237 · Substantial damage - [NTSB DEN88LA118](https://openairdocs.org/ntsb/DEN88LA118.md): Cessna 180 · Gettysburg, SD · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N2123Z · Substantial damage > The commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right… - [NTSB ANC88LA066](https://openairdocs.org/ntsb/ANC88LA066.md): De Havilland DHC-3 · Eagle, AK · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N3125N · Substantial damage > The pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to… - [NTSB ANC88LA064](https://openairdocs.org/ntsb/ANC88LA064.md): Cessna 206 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N4571K · Substantial damage > The pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway. - [NTSB MIA88LA182](https://openairdocs.org/ntsb/MIA88LA182.md): Cessna 152 · Marco Island, FL · Accident · No injuries · Limited investigation · Final report · May 31, 1988 · N25516 · Substantial damage > While on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off… - [NTSB MIA88IA181](https://openairdocs.org/ntsb/MIA88IA181.md): Cessna P210N · Daytona Beach, FL · Incident · No injuries · Incident investigation · Final report · May 30, 1988 · N6330W · Minor damage > The plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the… - [NTSB CHI88LA122](https://openairdocs.org/ntsb/CHI88LA122.md): Cessna 152 · Romeoville, IL · Accident · No injuries · Limited investigation · Final report · May 30, 1988 · N68312 · Substantial damage - [NTSB SEA88LA102](https://openairdocs.org/ntsb/SEA88LA102.md): Beech B55 · Reno, NV · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N8567M · Substantial damage > The pilot was attempting to land on runway 25 with winds from 290 degrees at 17 knots. Just prior to flare, the aircraft encountered a gust of wind. The pilot lost control of the aircraft and landed hard on the right main gear. The right strut, wheel and… - [NTSB NYC88LA155](https://openairdocs.org/ntsb/NYC88LA155.md): Cessna 182A · Franconia, NH · Accident · Minor injuries · Limited investigation · Final report · May 29, 1988 · N6115B · Substantial damage > The pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and… - [NTSB NYC88DFA01](https://openairdocs.org/ntsb/NYC88DFA01.md): Lloyd Feary VJ-22 · Kingston, NY · Accident · No injuries · Final report · May 29, 1988 · N59262 · Substantial damage > The aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted… - [NTSB CHI88LA121](https://openairdocs.org/ntsb/CHI88LA121.md): Cessna R172K · Aurora, IL · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N736AF · Substantial damage > The pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial… - [NTSB BFO88LA052](https://openairdocs.org/ntsb/BFO88LA052.md): Cessna 177 · Milford, DE · Accident · Serious injuries · Limited investigation · Final report · May 29, 1988 · N35253 · Destroyed > The plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by… - [NTSB LAX88LA202](https://openairdocs.org/ntsb/LAX88LA202.md): Bellanca 7ECA · Sonoma, CA · Accident · Minor injuries · Limited investigation · Final report · May 28, 1988 · N4139Y · Substantial damage > Failure to adequately supervise the flight and recover from the student pilot's bounced landing. - [NTSB FTW88DRD06](https://openairdocs.org/ntsb/FTW88DRD06.md): Grumman G-164A · Abbeville, LA · Accident · No injuries · Final report · May 28, 1988 · N7203 · Substantial damage > The ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid… - [NTSB DEN88LA113](https://openairdocs.org/ntsb/DEN88LA113.md): Cessna 152 · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N67446 · Substantial damage > The student pilot was returning from a cross country training flight. At touchdown the acft bounced and began to porpoise. The nose gear collapsed and the plane nosed down. The FBO reported calm winds and dry rnwy conditions. - [NTSB LAX88LA219](https://openairdocs.org/ntsb/LAX88LA219.md): Cessna 182M · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · May 27, 1988 · N70618 · Substantial damage > At the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising… - [NTSB LAX88LA198](https://openairdocs.org/ntsb/LAX88LA198.md): Enstrom F28A · La Verne, CA · Accident · No injuries · Limited investigation · Final report · May 27, 1988 · N4898 · Substantial damage > The helicopter landed hard during a practice touchdown autorotation (auto). The helo remained in closed traffic for the purpose of practicing touchdown autos to a landing area adjacent to the aprt's rwy. There was also another helo in closed traffic using the… - [NTSB CHI88LA118](https://openairdocs.org/ntsb/CHI88LA118.md): Cessna 172M · Plainwell, MI · Accident · No injuries · Limited investigation · Final report · May 27, 1988 · N20389 · Substantial damage > During an unauthorized flight of unknown duration, by person(s) unknown, aircraft control was not maintained. The aircraft was observed by a witness to 'wobble' as it approached the runway. The witness then saw the aircraft 'crash' into the grass at the left… - [NTSB MKC88LA097](https://openairdocs.org/ntsb/MKC88LA097.md): Cessna 310K · Kansas City, KS · Accident · No injuries · Limited investigation · Final report · May 24, 1988 · N7011L · Substantial damage > During a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong… - [NTSB FTW88DRA13](https://openairdocs.org/ntsb/FTW88DRA13.md): Hudson Mustang II · Tomball, TX · Accident · No injuries · Final report · May 23, 1988 · N29WH · Substantial damage > The acft was substantially damaged when control was lost during the rollout after ldng with a 12 knot left crosswind. Following the loss of control, the acft veered left of the rwy, struck a rwy lt, hit a ditch, and flipped over. - [NTSB BFO88LA049](https://openairdocs.org/ntsb/BFO88LA049.md): Cessna 180 · Annapolis, MD · Accident · No injuries · Limited investigation · Final report · May 22, 1988 · N3173C · Substantial damage > During the landing rollout the aircraft drifted to the left. The left main wheel departed the pavement and encountered soft terrain. The aircraft groundlooped and nosed over. The pilot did not file an accident report. - [NTSB ATL88LA182](https://openairdocs.org/ntsb/ATL88LA182.md): Cessna 172F · Shellman, GA · Accident · Minor injuries · Limited investigation · Final report · May 21, 1988 · N8374U · Substantial damage > The plt was making a personal flt to a pvt uncharted airstrip on a coastal island. Approaching his destination, the plt cancelled his VFR flt plan with fss. The plt stated that he approached the soft 2500 foot strip high and ballooned at touchdown. He landed… - [NTSB FTW88LA107](https://openairdocs.org/ntsb/FTW88LA107.md): Cessna 172N · Graham, TX · Accident · No injuries · Limited investigation · Final report · May 19, 1988 · N4659G · Substantial damage > The student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident. - [NTSB ATL88LA177](https://openairdocs.org/ntsb/ATL88LA177.md): Piper PA-28-161 · Lebanon, OH · Accident · Minor injuries · Limited investigation · Final report · May 19, 1988 · N69161 · Substantial damage > The plt was making an apch for a full stop ldg with a quartering right tailwind. He stated that he had been previously told to always land on rwy 27 and takeoff from runway 09 at this apt. Witnesses indicated that the airplane touched down about half way down… - [NTSB FTW88LA105](https://openairdocs.org/ntsb/FTW88LA105.md): Cessna 172N · Plano, TX · Accident · Minor injuries · Limited investigation · Final report · May 18, 1988 · N4675G · Substantial damage > The student pilot was returning from practice in the local area and was attempting a landing with a left quartering headwind, with wind gusts. After touchdown, the airplane started to float and drifted to the left, off the runway. The pilot attempted a… - [NTSB MIA88LA171](https://openairdocs.org/ntsb/MIA88LA171.md): Cessna 172N · Miami, FL · Accident · No injuries · Limited investigation · Final report · May 16, 1988 · N734QP · Substantial damage > The plt stated that upon touchdown, the aircraft landed hard, bounced twice and ran off the side of the runway into the grass. - [NTSB CHI88LA114](https://openairdocs.org/ntsb/CHI88LA114.md): Piper PA-22-135 · Charlotte, MI · Accident · No injuries · Limited investigation · Final report · May 16, 1988 · N8800C · Substantial damage > During touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over. - [NTSB ATL88FA173](https://openairdocs.org/ntsb/ATL88FA173.md): Swearingen SA-226-TC · Atlanta, GA · Accident · No injuries · Field investigation · Final report · May 16, 1988 · N1013G · Substantial damage > During a visual approach to runway 27L, the airplane was landed gear up. Both the capt and f/o stated that the landing gear had been lowered over the outer marker and that they had observed three green lights and that the warning horn had not sounded prior to… - [NTSB SEA88LA096](https://openairdocs.org/ntsb/SEA88LA096.md): Cessna 172N · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N4723J · Substantial damage > After overflying the intended seaplane base landing area. The pilot, who had logged only 1 hour of fixed wing time in the previous 90 days, misjudged the necessary downwind leg length and landed with insufficient surface distance available to stop the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=387 ## 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=386 --- 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.