# 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 449 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB CHI84LA108](https://openairdocs.org/ntsb/CHI84LA108.md): Cessna 172P · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N62244 · Substantial damage > The acft veered off the rwy during landing. The plt tried to straighten the acft with rudder pressure but the acft continued off the rwy into a gully of snow. - [NTSB SEA84LA052](https://openairdocs.org/ntsb/SEA84LA052.md): Cessna 152II · Minden, NV · Accident · No injuries · Limited investigation · Final report · Feb 11, 1984 · N25807 · Substantial damage > The acft landed fast and during subsequent bouncing the nose gear broke off. This student plt had only about 3 hours of solo flt experience. - [NTSB LAX84LA201](https://openairdocs.org/ntsb/LAX84LA201.md): Piper PA-28R-201T · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Feb 11, 1984 · N4552Q · Substantial damage > Completing a night instrument private pilot biennial flight reivew, the acft was issued landing clearance for rwy 28L. On short final the pvt plt began to align the acft to land on rwy 28R which was closed for maintenance & not illuminated. The instructor plt… - [NTSB ATL84LA097](https://openairdocs.org/ntsb/ATL84LA097.md): Cessna C-172 · Carolina Beach, NC · Accident · No injuries · Limited investigation · Final report · Feb 11, 1984 · N733NU · Substantial damage > The plt reported a normal landing roll until he reached the end of the hard-packed clay surface and rolled into sand. The acft mired in and nosed over. This was the pilot's first landing at this arpt. - [NTSB FTW84LA132](https://openairdocs.org/ntsb/FTW84LA132.md): Grumman G-164A · Heidenheimer, TX · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N5407 · Substantial damage > The plt landed in the field he was spraying to tell the flagman he was quitting for the day. During landing roll the right main gear dug into the soft dirt and the acft nosed over. - [NTSB DEN84LA114](https://openairdocs.org/ntsb/DEN84LA114.md): Bellanca 7GCAA · Monte Vista, CO · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N7625S · Substantial damage > The acft landed on a snow covered private airstrip and nosed over. The plt said that the 4 inch deep snow caused the acft to go over on its top. - [NTSB ATL84LA094](https://openairdocs.org/ntsb/ATL84LA094.md): Beech F33A · Marion, SC · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N34CN · Substantial damage > The plt stated he was involved in a discussion with the company president, who was on board, during the landing apch and he failed to use the checklist. The acft was landed gear up. It was later determined the gear up warning horn was inop. - [NTSB LAX84LA200](https://openairdocs.org/ntsb/LAX84LA200.md): Beech 95-B55 · Lk Havasu City, AZ · Accident · No injuries · Limited investigation · Final report · Feb 9, 1984 · N771WN · Substantial damage > The plt reported that the acft encountered a flock of 'large water birds' on short final. While abruptly maneuvering the acft to avoid the birds, the acft impacted hard on the rwy. The plt also stated that his landing was directly into the clear setting sun. - [NTSB MIA84LA073](https://openairdocs.org/ntsb/MIA84LA073.md): Cessna 152 · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Feb 8, 1984 · N5310M · Substantial damage > According to the instructor/witness, the student plt lost control of the acft during a cross-wind landing. The acft bounced off the rwy into the dirt and flipped over. - [NTSB LAX84LA169](https://openairdocs.org/ntsb/LAX84LA169.md): Shuey Glassaire · Chico, CA · Accident · No injuries · Limited investigation · Final report · Feb 8, 1984 · N464ED · Substantial damage > The acft groundlooped during landing and ran off the rwy. The landing gear collapsed and ruptured the wing tanks. The plt stated that he thought the fuel shifted in his'homebuilt'as he tried to do a 3 point landing. - [NTSB NYC84LA082](https://openairdocs.org/ntsb/NYC84LA082.md): Piper PA-600 · Newark, NJ · Accident · No injuries · Limited investigation · Final report · Feb 7, 1984 · N8073J · Substantial damage > The acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main… - [NTSB MKC84LA100](https://openairdocs.org/ntsb/MKC84LA100.md): Beech F90 · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Feb 7, 1984 · N1842N · Substantial damage > While en route to Jonesboro, the plt was informed the rwy and taxiway lights were inop. When he asked fss if the arpt was closed the reply was, 'negative, land at your own risk.' The plt lined up with what he thought was rwy 05 but in actuality it was a… - [NTSB SEA84LA049](https://openairdocs.org/ntsb/SEA84LA049.md): Cessna A185F · Winslow, WA · Accident · No injuries · Limited investigation · Final report · Feb 6, 1984 · N4504N · Substantial damage > During a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent… - [NTSB NYC84LA083](https://openairdocs.org/ntsb/NYC84LA083.md): Cessna 150H · Leonardtown, MD · Accident · No injuries · Limited investigation · Final report · Feb 6, 1984 · N50308 · Substantial damage > The student plt was on his 1st supervised solo flt. During a landing, the acft encountered a x-wind & was blown off the centerline of the rwy. The student added power to go around. However, he said that he failed to lower the nose & the acft stalled. During… - [NTSB DEN84LA087](https://openairdocs.org/ntsb/DEN84LA087.md): Texas Helicopter 205 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Feb 5, 1984 · N78851 · Substantial damage > The plt reported that he landed on rwy 15 with a wind from O90 deg at 20 gusting 30 KTS. After touchdown, the acft began veering to the left. The plt applied right rudder & right brake, but the left wheel dropped off the left side of the rwy & went into mud.… - [NTSB NYC84LA084](https://openairdocs.org/ntsb/NYC84LA084.md): Piper PA-38-112 · Easton, PA · Accident · No injuries · Limited investigation · Final report · Feb 4, 1984 · N91332 · Substantial damage > The student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover. - [NTSB FTW84LA129](https://openairdocs.org/ntsb/FTW84LA129.md): Piper PA-22-135 · Lamkin, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 4, 1984 · N3343A · Substantial damage > The acft nose gear dug into the soft sod rwy and collapsed. After the nose gear collapsed the acft nosed over and slid inverted for about 100 ft. the FAA coordinator said the plt apparently forced the nose down while trying to maintain directional control.… - [NTSB DEN84LA082](https://openairdocs.org/ntsb/DEN84LA082.md): Piper PA-18-150 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 4, 1984 · N57528 · Substantial damage > The acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes. - [NTSB CHI84LA100](https://openairdocs.org/ntsb/CHI84LA100.md): Cessna 172E · Lk In The Hills, IL · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 1984 · N3631S · Substantial damage > The plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing. - [NTSB ATL84LA091](https://openairdocs.org/ntsb/ATL84LA091.md): Cessna 404 · Covington, KY · Accident · No injuries · Limited investigation · Final report · Feb 2, 1984 · N402EX · Substantial damage > A fire ignited in the right engine on the landing roll. The fire source was near the point where the fuel supply line connects to the engine driven fuel pump. The acft was on its first revenue flight after the right engine was changed, atwhich time the… - [NTSB FTW84LA124](https://openairdocs.org/ntsb/FTW84LA124.md): Cessna 152 · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Feb 1, 1984 · N94467 · Substantial damage > The acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed. - [NTSB DCA84AA016](https://openairdocs.org/ntsb/DCA84AA016.md): Learjet 24 · Avalon, CA · Accident · 6 fatal · Final report · Jan 30, 1984 · N44GA · Destroyed > The acft departed on a sales demo flt to monterey, CA with potential buyers aboard. En route, the destination was changed to Avalon, CA. UNICOM advised the crew of the wind direction & speed on downwind. Witnesses reported the acft was slightly hi on final,… - [NTSB NYC84LA080](https://openairdocs.org/ntsb/NYC84LA080.md): Cessna 172RG · Marietta, PA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1984 · N9508B · Substantial damage > The acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over. - [NTSB NYC84LA079](https://openairdocs.org/ntsb/NYC84LA079.md): Swearingen SA-226T · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1984 · N99JW · Substantial damage > The plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound. - [NTSB MKC84LA068](https://openairdocs.org/ntsb/MKC84LA068.md): Cessna 152 · Augusta, KS · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N24531 · Substantial damage > The acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear. - [NTSB MKC84LA067](https://openairdocs.org/ntsb/MKC84LA067.md): Cessna 170B · Jasper, AR · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N1681D · Substantial damage > The plt landed the acft on private property to visit relatives. During the landing the acft groundlooped and collapsed the left main landing gear. The plt reported that the winds were from 290 degrees at 18 KTS and gusty. Rugged terrain surrounded the area of… - [NTSB CHI84LA106](https://openairdocs.org/ntsb/CHI84LA106.md): Cessna 152 · Detroit Lakes, MN · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N25469 · Substantial damage > The acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The… - [NTSB CHI84LA098](https://openairdocs.org/ntsb/CHI84LA098.md): Cessna 152 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N4888H · Substantial damage > During a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots. - [NTSB NYC84LA075](https://openairdocs.org/ntsb/NYC84LA075.md): Cessna 150E · Brewer, ME · Accident · No injuries · Limited investigation · Final report · Jan 27, 1984 · N8941U · Substantial damage > The acft was on a local pre-solo takeoff and landing practice flight. Several landings were made with the student pilot adjusting for wind conditions below a tree line. On the last landing the CFI reported that the acft moved quickly to theright and started… - [NTSB ATL84LA086](https://openairdocs.org/ntsb/ATL84LA086.md): Cessna 152 · Snowville, VA · Accident · No injuries · Limited investigation · Final report · Jan 26, 1984 · N94251 · Substantial damage > The acft crash landed in a pasture during a go-around attempt after a demonstration forced landing. The go-around was delayed and the terrain rose faster than the acft ascent rate. Since there was a powerline in the way the CFI elected to land the acft. - [NTSB FTW84LA119](https://openairdocs.org/ntsb/FTW84LA119.md): Bell 206L-1 · Cedar Hill, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1984 · N3904N · Destroyed > Purpose of the flt was to check for oil leaks after maintenance was performed. Shortly after takeoff, at an alt of 50 to 100 ft AGL, the plt noticed a '2 per rev vibration' and decided to land in a field. When aprx 5 ft AGL the plt felt what he described as a… - [NTSB MKC84LA064](https://openairdocs.org/ntsb/MKC84LA064.md): Mitsubishi MU 2B-20 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1984 · N123AX · Substantial damage > The acft landed in a crosswind on a snow and ice covered rwy. During landing, directional control was lost and the acft collided with a snowbank. The plt stated he attempted to use propeller reversing for braking and the acft started to slide to the left. - [NTSB MIA84LA066](https://openairdocs.org/ntsb/MIA84LA066.md): Piper PA-28 · Plymouth, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1984 · N157DB · Substantial damage > The acft was landed hard at higher than normal airspeed. The plt stated that he came in'too high and too fast'and when he landed he'broke the nose wheel'. Investigation revealed that the plt did not possess any aeronautical certificates or ratings. He had… - [NTSB LAX84LA159](https://openairdocs.org/ntsb/LAX84LA159.md): Beech D55 · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1984 · N873LB · Substantial damage > According to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it… - [NTSB LAX84LA154](https://openairdocs.org/ntsb/LAX84LA154.md): Bellanca 7ECA · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1984 · N5026S · Substantial damage > The plt reported that a gust of wind pushed up the left wing & the acft veered off the rwy. The acft then went down a shallow grade & impacted bushes. He reported the wind was from 330 deg at 10 gusting 18 KTS. - [NTSB CHI84LA095](https://openairdocs.org/ntsb/CHI84LA095.md): Cessna C-172P · Macomb, IL · Accident · No injuries · Limited investigation · Final report · Jan 24, 1984 · N66978 · Substantial damage > The acft swerved off the rwy into a ditch during a crosswind landing. The wind was from 180 degrees at 10 KTS. The plt said that he lost directional control of the acft because of the wind. - [NTSB MIA84LA065](https://openairdocs.org/ntsb/MIA84LA065.md): Beech 58 · Ft.Myers, FL · Accident · No injuries · Limited investigation · Final report · Jan 23, 1984 · N9382Q · Substantial damage > The acft was rolling on the rwy after a smooth landing when the left tire blew out and the left landing gear collapsed. The acft swerved to the left into the wind and slid off the left side of the rwy. According to the plt, the wind was from 090 deg at 18… - [NTSB MKC84LA063](https://openairdocs.org/ntsb/MKC84LA063.md): Cessna 152 · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Jan 22, 1984 · N6377B · Substantial damage > The acft bounced during a touch and go landing. The plt was unable to control the bouncing and the acft received damage to the nose gear, propeller and wing tips. - [NTSB SEA84IA042](https://openairdocs.org/ntsb/SEA84IA042.md): Cessna CE500 · Yakima, WA · Incident · No injuries · Incident investigation · Final report · Jan 20, 1984 · N25 · Minor damage > The acft made a hard landing while on a training flt. According to the instructor plt, 'during the landing flare, we were descending very gradually as the airspeed continued to dissipate.' Late in the flare the angle of attack indicator was approaching the… - [NTSB LAX84LA143](https://openairdocs.org/ntsb/LAX84LA143.md): Cessna 206 · Santa Cruzi Il, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1984 · N733VQ · Substantial damage > The acft overran the landing area and nosed over. The landing area was on grassy rolling terrain which was downhill fromthe touchdown point. Winds from stations in the area were from a westerly component and the landing was to the east. - [NTSB CHI84LA089](https://openairdocs.org/ntsb/CHI84LA089.md): Grumman AA-1A · Hawley, MN · Accident · No injuries · Limited investigation · Final report · Jan 18, 1984 · N9248L · Substantial damage > The acft ran into a snowbank during the landing roll and flipped over. The plt stated that the right brake pedal cylinder froze but this could not be confirmed during the investigation. - [NTSB ANC84LA032](https://openairdocs.org/ntsb/ANC84LA032.md): Cessna 207A · Deering, AK · Accident · No injuries · Limited investigation · Final report · Jan 18, 1984 · N9950M · Substantial damage > While in the traffic pattern for a night landing, the plt noticed the village agent's truck positioned about 2/3 down the rwy facing north. The plt assumed the truck was indicating the landing direction. During the landing roll, the plt noticed the truck on… - [NTSB MIA84IA062](https://openairdocs.org/ntsb/MIA84IA062.md): Beech D18S · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Jan 17, 1984 · N348W · Minor damage > The acft landed gear up at the Jacksonville, airport. Exam of the gear ext system revealed no malfunctions or failures. - [NTSB SEA84LA043](https://openairdocs.org/ntsb/SEA84LA043.md): Raven Rally RX7 · Aibirm, WA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N57090 · Substantial damage > The plt stated that the wind shifted during landing and the balloon touched down hard and lifted off again. With power lines ahead a decision was made to cross over but the balloon struck the lines. Several cables were burned through and the balloon was torn… - [NTSB NYC84LA069](https://openairdocs.org/ntsb/NYC84LA069.md): Stinson 108-1 · Annapolis, MD · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N9229K · Substantial damage > The plt landed faster than normal and lost control of the acft on the icy rwy. The plt said he over-corrected with left rudder and the acft went off the rwy and slid on a frozen field collapsing the right main gear. - [NTSB LAX84LA146](https://openairdocs.org/ntsb/LAX84LA146.md): Beech C-24-R · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N974V · Substantial damage > A rear seated passg reported that when the acft was about 50 ft AGL he heard the stall warning buzzer sound. Several seconds later acft hit the rwy in a near level attitude. The landing was described by the passgs as 'on the hard side.' Investigation revealed… - [NTSB LAX84LA141](https://openairdocs.org/ntsb/LAX84LA141.md): Cessna 310 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jan 15, 1984 · N8926Z · Substantial damage > The right main landing gear collapsed as the acft was being taxied to the ramp. The plt reported that the acft was traveling about 30 mph during entry into the taxi turn-off area at the time of the accident. Failure occurred in theright rear trunion pin. - [NTSB SEA84LA038](https://openairdocs.org/ntsb/SEA84LA038.md): Piper PA28R-200 · Newport, OR · Accident · No injuries · Limited investigation · Final report · Jan 14, 1984 · N55624 · Substantial damage > The acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown… - [NTSB CHI84LA086](https://openairdocs.org/ntsb/CHI84LA086.md): Piper PA-38-112 · Waukegan, IL · Accident · No injuries · Limited investigation · Final report · Jan 14, 1984 · N23781 · Substantial damage > The student plt said he lost too much airspeed during a no power approach and made a hard landing. After a bounce, the acft hit on the nose gear and it collapsed. The acft skidded off the rwy into a snowbank. - [NTSB NYC84LA068](https://openairdocs.org/ntsb/NYC84LA068.md): Cessna 150 · Seneca Falls, NY · Accident · No injuries · Limited investigation · Final report · Jan 12, 1984 · N8108U · Substantial damage > During the landing rollout the acft hit an icy patch of rwy and at the same time encountered a gusty crosswind. The acftskidded into a snowbank and nosed over. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=450 ## 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=449 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.