# 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 448 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DCA84AA018](https://openairdocs.org/ntsb/DCA84AA018.md): Mcdonnell Douglas DC-10-30 · Jamaica, NY · Accident · Serious injuries · Final report · Feb 28, 1984 · LNRKB · Substantial damage > During an ILS apch to rwy 4R with a tailwind, the acft (scandinavian flt 901) was being flown by the coplt. The acft was fast on final apch & was landed aprx 4700 ft beyond the apch end of the rwy at 36 KTS above the programmed touchdown speed. The aircrew… - [NTSB CHI84FA121](https://openairdocs.org/ntsb/CHI84FA121.md): Beech A36 · Wheeling, IL · Accident · 1 fatal · Field investigation · Final report · Feb 28, 1984 · N24187 · Destroyed > A go-around was initiated about midfield at what one witness estimated as 6 in above the rwy. The acft was between 20 and 50 ft above the trees when it rolled into a steep right angle of bank with the nose dropping simultaneously. Post crash fire destroyed… - [NTSB SEA84LA062](https://openairdocs.org/ntsb/SEA84LA062.md): Champion 7ECA · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N996MP · Substantial damage > According to the student plt, the winds were prevailing from the southeast at 5 to 10 KTS, but were shifting & gusting to 20 KTS. During a landing on rwy 5, the acft veered off the right side side of the rwy, then struck a ditch & nosed over. - [NTSB MKC84LA086](https://openairdocs.org/ntsb/MKC84LA086.md): Piper PA-28-181 · Jefferson City, MO · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N7734C · Substantial damage > The acft drifted left due to a crosswind during landing. The drift put the acft into snow which had been plowed along the rwy side. The collision pulled the acft off the rwy. - [NTSB LAX84LA202](https://openairdocs.org/ntsb/LAX84LA202.md): Cessna 152 · Emigrant Gap, CA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N25592 · Substantial damage > The student & instructor plt (CFI) were on a dual x-country flt. They proceeded to fly to an unattended arpt at Emigrant Gap, CA, which was at an elevation of 5284 ft. after arriving, they circled the arpt & made a low pass over the rwy. They saw tracks on… - [NTSB LAX84LA198](https://openairdocs.org/ntsb/LAX84LA198.md): Cessna 152 · Fair Oaks, CA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N24470 · Substantial damage > The student plt was on her second supervised solo. She reported that 'on her third landing, she misjudged the distance and undershot the runway.' - [NTSB ATL84LA110](https://openairdocs.org/ntsb/ATL84LA110.md): Cessna 337B · Athens, TN · Accident · No injuries · Limited investigation · Final report · Feb 26, 1984 · N2406S · Destroyed > The acft caught fire during landing when a gasoline can overturned and was ignited by a passenger trying to right it with a burning cigar in his hand. - [NTSB MKC84LA085](https://openairdocs.org/ntsb/MKC84LA085.md): Cessna 150L · Ft Riley, KS · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N10144 · Substantial damage > The student plt stated he landed hard, bounced and impacted the rwy again, collapsing the nose gear. - [NTSB MIA84LA124](https://openairdocs.org/ntsb/MIA84LA124.md): Piper PA-28R-200 · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N4869F · Substantial damage > During the 1st landing, the acft touched down at night, aprx half way down the rwy. The plt eleected to go around, then made a 2nd apch & landing. During the 2nd landing, the acft went off the end of the rwy & came to rest in water. The plt stated that… - [NTSB MIA84LA094](https://openairdocs.org/ntsb/MIA84LA094.md): Cessna 182G · Brandon, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1984 · N7388S · Substantial damage > The acft had been parked for about 2 mos with a partial fuel load. Prior to departure, 40 gal of auto fuel was added & both wing tank sumps & the gascolator were drained with only a minimal amount of water found. Shortly after takeoff, the eng lost power.… - [NTSB FTW84LA148](https://openairdocs.org/ntsb/FTW84LA148.md): Cessna 140 · Longview, TX · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N2491N · Substantial damage > The plt landed in an rough surface overrun area marked by painted tires as unusable. The right main gear collapsed after touchdown and the acft slid to a stop. The plt said he did not see the tires marking the overrun until after the accident. - [NTSB DEN84FA102](https://openairdocs.org/ntsb/DEN84FA102.md): Bell 206B-III · Coalville, UT · Accident · 1 fatal · Field investigation · Final report · Feb 25, 1984 · N16803 · Destroyed > The helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for… - [NTSB LAX84LA196](https://openairdocs.org/ntsb/LAX84LA196.md): Rockwell 112A · Yucca Valley, CA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1984 · N1318J · Substantial damage > Upon arrival at the uncontrolled arpt, neither the instructor (CFI) nor the student observed the arpt's wind sock. The acft was observed to touch down midway down the rwy & bounce once during the landing. As the acft neared the end of the rwy, the CFI… - [NTSB FTW84LA147](https://openairdocs.org/ntsb/FTW84LA147.md): Cessna 152 · Harrah, OK · Accident · No injuries · Limited investigation · Final report · Feb 24, 1984 · N65575 · Substantial damage > The plt landed at higher than normal speed, with initial contact about 400 ft down the runway. He stated that the acft was 'sailing' and attempts to decelerate were 'ineffective'. The nose gear collapsed when the acft hit in the middle road on the north end… - [NTSB CHI84LA117](https://openairdocs.org/ntsb/CHI84LA117.md): Cessna T-210N · Troy, MI · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 1984 · N9483Y · Substantial damage > The acft landed in soft grassy terrain alongside rwy 27, when the acft nosed over the nose gear collapsed. The plt was not aligned properly because the north side of the rwy lights were not operating and were notamed as being out of service since 2/19/84. - [NTSB SEA84LA059](https://openairdocs.org/ntsb/SEA84LA059.md): Cessna 172RGII · Grangeville, ID · Accident · No injuries · Limited investigation · Final report · Feb 22, 1984 · N6522R · Substantial damage > The acft ground looped during landing on an icy rwy and nosed over after leaving the rwy. The landing was made with a right quartering tailwind. - [NTSB FTW84LA149](https://openairdocs.org/ntsb/FTW84LA149.md): Cessna 150M · Boy'S Ranch, TX · Accident · No injuries · Limited investigation · Final report · Feb 22, 1984 · N150N · Substantial damage > The student plt was attempting to land on a freshly graded road. Shortly after touchdown the nose wheel hit a large rock and sheared off. - [NTSB DEN84LA097](https://openairdocs.org/ntsb/DEN84LA097.md): Swearingen SA26AT · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · Feb 22, 1984 · N17JJ · Substantial damage > The acft landed with the gear retracted. The plt reported that 'due to moderate low level turbulence, the landing gear handle did not reach the full down position.' He stated that his passenger was sick due to turbulence. - [NTSB CHI84LA304](https://openairdocs.org/ntsb/CHI84LA304.md): Cessna 152 · South Branch, MI · Accident · No injuries · Limited investigation · Final report · Feb 22, 1984 · N757TH · Substantial damage > The student plt was on a solo x-country flt. He reported that when he landed, the acft bounced twice. After the 2nd bounce, the nose gear collapsed & the acft nosed over. The plt reported that the grass strip was rough & not well maintained & that the ground… - [NTSB CHI84LA115](https://openairdocs.org/ntsb/CHI84LA115.md): Cessna 152 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Feb 22, 1984 · N5355P · Substantial damage > The student plt stated that the acft bounced on the first touchdown and then contacted the rwy with the nose gear. Afterthe nose gear collapsed the acft nosed over. - [NTSB ANC84MA037](https://openairdocs.org/ntsb/ANC84MA037.md): Embraer EM-110P1 · Cordova, AK · Accident · No injuries · Major investigation · Final report · Feb 22, 1984 · N103VA · Substantial damage > During a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It… - [NTSB LAX84LA190](https://openairdocs.org/ntsb/LAX84LA190.md): Mooney M20C · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Feb 21, 1984 · N6518U · Substantial damage > The plt reported that he failed to extend the landing gear prior to touchdown. Subsequently, the acft was damaged during a wheels up landing. - [NTSB NYC84LA095](https://openairdocs.org/ntsb/NYC84LA095.md): Cessna 182RG · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N3714C · Substantial damage > According to the plt after about an hour and 10 min flight he returned for landing. During the landing roll the acft skidded off the rwy onto soft dirt damaging the propeller and right wing tip. - [NTSB NYC84LA088](https://openairdocs.org/ntsb/NYC84LA088.md): Cessna 152 · Clarksville, MD · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N757NS · Substantial damage > According to the plt the acft ballooned during the landing flare. In an effort to recover the plt added power and pushed the nose down. The front strut hit the ground and broke, then the acft bounced and during the second landing the propeller struck the… - [NTSB MKC84LA080](https://openairdocs.org/ntsb/MKC84LA080.md): Cessna 150M · Norton, KS · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N714CH · Substantial damage > The solo student landed in a light crosswind on a rwy with patches of snow and ice. The acft slid sideways after bouncing and collided with a snowbank. - [NTSB MKC84LA079](https://openairdocs.org/ntsb/MKC84LA079.md): Cessna 152 · Independence, MO · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N25756 · Substantial damage > The acft made a steep approach with full flaps, hit hard, bounced and came down on the nose wheel. The nose wheel collapsed and the acft flipped over. The plt stated that he did not start the landing flare soon enough. - [NTSB LAX84LA186](https://openairdocs.org/ntsb/LAX84LA186.md): Beech BE-58 · Crescent City, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N4636S · Substantial damage > The acft landed 1000 ft down the wet rwy and continued off tend of the rwy before hitting a 18 inch dirt bank. The landing gear collapsed. The plt reported that the braking action was 'poor'. - [NTSB MKC84LA093](https://openairdocs.org/ntsb/MKC84LA093.md): Cessna 206 · Pine Bluff, AR · Accident · No injuries · Limited investigation · Final report · Feb 19, 1984 · N5026U · Substantial damage > The acft ran off the rwy and into a ditch during landing. After the accident it was found that the nose wheel steering needed rebushing and the nosewheel damper was also in need of repair for safe operation of the acft. - [NTSB LAX84LA191](https://openairdocs.org/ntsb/LAX84LA191.md): Cessna 180A · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1984 · N9764B · Substantial damage > Prior to takeoff, the plt had to push the acft out of mud where the right landing gear had sunk into the ground. He took off and flew for 1/2 an hour. The plt reported that during the landing, the right brake seemed to be frozen and the acft swerved to the… - [NTSB SEA84LA057](https://openairdocs.org/ntsb/SEA84LA057.md): Cessna 172N · Roseburg, OR · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N733VX · Substantial damage > The acft drifted left during the student pilots landing and collided with VASI lights. After the collision the acft nosed over. The CFI on the ground said the wind shifted just prior to the last landing. - [NTSB NYC84FA089](https://openairdocs.org/ntsb/NYC84FA089.md): Cessna 401A · Linden, NJ · Accident · No injuries · Field investigation · Final report · Feb 18, 1984 · N6252Q · Substantial damage > The main landing gear collapsed after landing. A CFI awaiting takeoff said that the approach and touchdown were normal with the gear down. As the acft rolled the left main gear collapsed and the acft gradually left the rwy and became miredin mud. Inspection… - [NTSB MIA84LA153](https://openairdocs.org/ntsb/MIA84LA153.md): Cessna 172 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N738SN · Substantial damage > The plt reported that when he arrived at the arpt to land, the wind was from 330 deg gusting to about 15 to 17 KTS. On final apch to land on rwy 27L, he decided to slip the acft & use a faster than normal speed to compensate for the wind & extra weight of the… - [NTSB MIA84LA087](https://openairdocs.org/ntsb/MIA84LA087.md): Beech B-58 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N21BR · Substantial damage > The acft landed with the right main gear & nose gear stuck in the retracted position, with the left main gear stuck in the extended position. Investigation revealed that the landing gear actuating rod had failed. - [NTSB MIA84LA085](https://openairdocs.org/ntsb/MIA84LA085.md): Beech 95-B55 · St Augustine, FL · Accident · No injuries · Limited investigation · Final report · Feb 17, 1984 · N1767W · Substantial damage > The acft landed with its left main gear jammed in the up position. Since the landing gear warning and indicating system indicated all normal the crew was unaware of the problem until the roll out. Investigation revealed that the left main gear actuating motor… - [NTSB DEN84LA092](https://openairdocs.org/ntsb/DEN84LA092.md): Cessna T-210 · Duchesne, UT · Accident · No injuries · Limited investigation · Final report · Feb 17, 1984 · N6479N · Substantial damage > The acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed. - [NTSB ATL84LKG04](https://openairdocs.org/ntsb/ATL84LKG04.md): Cessna 177B · Kennesaw, GA · Accident · Serious injuries · Final report · Feb 17, 1984 · N34627 · Destroyed > The acft bounced during landing and when it started to veer off the rwy the plt attempted a go-around. The acft collidedwith trees and came to rest in a small ditch. - [NTSB ATL84LA103](https://openairdocs.org/ntsb/ATL84LA103.md): Beech 19A · Mayersville, MS · Accident · No injuries · Limited investigation · Final report · Feb 17, 1984 · N5081T · Substantial damage > The plt circled the airstrip prior to landing and believed the landing area in suitable condition. During the landing right main landing gear mired in a soft spot and the landing gear collapsed. - [NTSB LAX84LA182](https://openairdocs.org/ntsb/LAX84LA182.md): Cessna 172M · Barbers Point, HI · Accident · No injuries · Limited investigation · Final report · Feb 16, 1984 · N5160R · Substantial damage > The acft was observed to land nose first, collapsing the nosewheel and sustaining subst damage. Investigation revealed that the acft was stalled from an altitude of 20 to 30 ft AGL. - [NTSB CHI84IA111](https://openairdocs.org/ntsb/CHI84IA111.md): Swearingen SA-26AT · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · Feb 16, 1984 · N175P · Minor damage > The plt was on a local flt to check the aileron rigging after maintenance had been performed on it. After taking off, he remained in the traffic pattern. On downwind, after extending the landing gear, he noted an unsafe right main gear indication. The plt… - [NTSB ATL84FKG02](https://openairdocs.org/ntsb/ATL84FKG02.md): Piper PA-60 · Atlanta, GA · Accident · No injuries · Final report · Feb 16, 1984 · N6070D · Substantial damage > While on final approach the plt noted an unsafe nose gear indication. Tower personnel were unable to determine gear position during a fly-by. During landing touchdown the nose gear collapsed. Investigation revealed the acft had a brokenbolt in the nose gear… - [NTSB MKC84LA082](https://openairdocs.org/ntsb/MKC84LA082.md): Mooney MK20B · Pocahontas, AR · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N74515 · Substantial damage > The acft landing gear retracted during landing. The plt reported that the manually activated gear handle popped out of the gear down position during the landing roll. The plt indicated that he thought the gear handle was positively in the down lock position. - [NTSB FTW84LA134](https://openairdocs.org/ntsb/FTW84LA134.md): Cessna 152 · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N6202M · Substantial damage > During landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed… - [NTSB ATL84LKG03](https://openairdocs.org/ntsb/ATL84LKG03.md): Cessna 152 · Albertville, AL · Accident · No injuries · Final report · Feb 15, 1984 · N6418B · Substantial damage > The acft ran off the left side of the rwy during landing and nosed over. The student plt said he was practicing touch and go landings solo and lost control of the acft. - [NTSB MKC84LA075](https://openairdocs.org/ntsb/MKC84LA075.md): Cessna 172P · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Feb 14, 1984 · N55277 · Substantial damage > The student plt was on the final leg of a x-country flt. While landing with a gusty x-wind, the acft veered off the rwy, encountered soft terrain & nosed over. - [NTSB MKC84LA074](https://openairdocs.org/ntsb/MKC84LA074.md): Piper PA-20 · Boonville, MO · Accident · Minor injuries · Limited investigation · Final report · Feb 13, 1984 · N4944M · Substantial damage > The acft nosed over after landing. The plt said that the arpt manager told him that 'there is a valley that funnels the wind and has blown other acft the same way'. The plt said the only way to avoid this condition is to land farther down the rwy. - [NTSB MKC84LA073](https://openairdocs.org/ntsb/MKC84LA073.md): Aeronca 7AC · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Feb 13, 1984 · N83032 · Substantial damage > The dual student allowed the acft to porpoise & yaw and lost control of the acft as it veered into a ditch. The CFI on board tried to correct the situation with rudder and throttle but was unsucessful in the attempt. - [NTSB ATL84LA098](https://openairdocs.org/ntsb/ATL84LA098.md): Cessna C-303 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Feb 13, 1984 · N9457C · Substantial damage > The acft overran the rwy and collided with a fence during a night landing. The flt was hampered by an inoperative heaterand a dome light that could not be turned off. The rwy suggested for use was short with a decommissioned VASI system. The plt said she… - [NTSB NYC84LA070](https://openairdocs.org/ntsb/NYC84LA070.md): Brantly Helicopter B-2B · Mt. Pleasant, PA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N2273U · Substantial damage > The plt flew to greensburg, where he brought the helicopter to a 2 ft hover and departed with a max performance climb. He stated the helicopter began to exhibit control irregularities which he described as 'a dutch roll wobble type of shuffle.' He continued… - [NTSB LAX84LA175](https://openairdocs.org/ntsb/LAX84LA175.md): Piper PA-20 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N3151Z · Substantial damage > The acft groundlooped and ran off the side of the rwy during landing. - [NTSB DEN84LA096](https://openairdocs.org/ntsb/DEN84LA096.md): Raven Rally RX7 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 1984 · N40995 · No damage > The student plt aboard the balloon suffered a broken leg during a landing. She had been briefed on the proper stance forlanding and the instructor thought she was in the proper position but later found out that the students left leg was broken above the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=449 ## 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=448 --- 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.