# 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 427 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB ATL85LA183](https://openairdocs.org/ntsb/ATL85LA183.md): Hughes 369HS · Aiken, SC · Accident · No injuries · Limited investigation · Final report · Jun 7, 1985 · N9146F · Substantial damage > During a landing, the eng lost power & the helicopter touched down hard. The plt stated that prior to the 15 min flt, the fuel gage was indicating 125 lbs of fuel & at the accident site it indicated 90 lbs of fuel. A post crash inspection of the fuel system… - [NTSB SEA85LA131](https://openairdocs.org/ntsb/SEA85LA131.md): Piper PA-18-150 · Brentwood, CA · Accident · No injuries · Limited investigation · Final report · Jun 6, 1985 · N6995B · Substantial damage > On the student plts seventh attempted landing, directional control was lost and a groundloop occurred. The student plt had less than two hours of total pilot in command time. - [NTSB DEN85LA149](https://openairdocs.org/ntsb/DEN85LA149.md): Beech V35B · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Jun 5, 1985 · N908V · Substantial damage > N904V, a privately owned B-35, skidded off to the side of a runway during landing. The plt said that he inadvertently activated the gear up switch instead of the flap switch. The right landing gear collapsed causing the plt to lose control of acft. - [NTSB CHI85LA223](https://openairdocs.org/ntsb/CHI85LA223.md): Piper PA-31-T · Rochester, IN · Accident · No injuries · Limited investigation · Final report · Jun 5, 1985 · N777YR · Substantial damage > When the plt reduced power & flared, the acft touched down short of the rwy. The acft sustained substanitial damage when the landing gear struck the edge of the raised rwy surface. - [NTSB DEN85FTE02](https://openairdocs.org/ntsb/DEN85FTE02.md): Cessna 180K · Atlantic City, WY · Accident · Serious injuries · Final report · Jun 4, 1985 · N66771 · Substantial damage > The acft nosed over during an attempted landing on a narrow curved roadway in a mining pit. Witnesses reported the acft made a steep descent, touched down on the road and almost immediately departed the road. The acft entered an area of large boulders, nosed… - [NTSB NYC85LA144](https://openairdocs.org/ntsb/NYC85LA144.md): Cessna 305A · Toughkenamon, PA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N5288G · Substantial damage > The acft ground looped during a landing roll on a sod rwy. The plt stated that during the landing roll, it felt as if the right main gear contacted a knoll of grass resulting in the acft ground looping to the right. - [NTSB LAX85LA266](https://openairdocs.org/ntsb/LAX85LA266.md): Stinson 108-1 · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N97935 · Substantial damage > While en route, the plt noted thunderstorms & towering cumulus clouds over the tehachapi mountains & elected to divert to Hesperia. He stated that all fields within range had 'severe winds and storms closing.' He said that during the landing at Hesperia,… - [NTSB DEN85LA148](https://openairdocs.org/ntsb/DEN85LA148.md): Aeronca 7AC · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N8362H · Substantial damage > On June 1, 1985, an Aeronca 7AC, piloted by a private plt, ground looped while making a touch and go landing at sky park airport, Bountiful, UT. The plt stated that he lost control of the airplane. The winds were reported to be calm. - [NTSB CHI85LA224](https://openairdocs.org/ntsb/CHI85LA224.md): Stearman E-75 · Lake Odessa, MI · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N65688 · Substantial damage > Upon landing the aircraft veered to the right. Power & left rudder were applied, however, the aircraft continued to the right. Power was reduced but the aircraft continued to the right. The aircraft nosed over after coming in contact with a soft, plowed… - [NTSB ANC85LA089](https://openairdocs.org/ntsb/ANC85LA089.md): Cessna 172 · Soldotna, AK · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N65928 · Substantial damage > The acft sustained substantial damage when the pilot lost control of the acft and nosed over on its back. The weather was VMC but the pilot said he encountered a gust and crosswind during landing. - [NTSB MKC85LA119](https://openairdocs.org/ntsb/MKC85LA119.md): Piper PA-28-236 · Concordia, KS · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N627WB · Substantial damage > The student plt was making a night flt. He received wind information from an arpt 48 miles from the destination but used an indication from lighted wind indicator. Plt made a go around because the ground speed was fast. During the next attempt, he landed, ran… - [NTSB FTW85LA252](https://openairdocs.org/ntsb/FTW85LA252.md): Grumman G-164A · Kaplan, LA · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N7371 · Substantial damage > The left brake failed during the landing roll. The acft veered to the right of the rwy and ground looped. During the groundloop, the left tire blew and the tail wheel spring bolt assembly failed. Cause of the brake failure was not determined. - [NTSB FTW85FPA03](https://openairdocs.org/ntsb/FTW85FPA03.md): Mooney M20 · Fort Worth, TX · Accident · No injuries · Final report · Jun 1, 1985 · N872B · Destroyed > The acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating… - [NTSB ANC85LA088](https://openairdocs.org/ntsb/ANC85LA088.md): Cessna A185F · Alaktak, AK · Accident · No injuries · Limited investigation · Final report · Jun 1, 1985 · N61500 · Substantial damage > The acft collideded with a snow bank and nosed over during a landing attempt on a frozen lake. The plt stated that 'my rt ski hit a pressure ridge or broke through crust; whichever, the acft abrurtly pitched down, contacting the ice and continuing over onto… - [NTSB MIA85IA182](https://openairdocs.org/ntsb/MIA85IA182.md): Piper Aztec PA-23-250 · Vero Beach, FL · Incident · No injuries · Incident investigation · Final report · May 31, 1985 · N63845 · Minor damage > While in the traffic pattern, the cfi's attention was diverted as he attempted to assist ATC with some radio frequency info. While being so distracted, he permitted the student to land the acft with the gear up. - [NTSB LAX85LA265](https://openairdocs.org/ntsb/LAX85LA265.md): Mooney M20J · Rialto, CA · Accident · No injuries · Limited investigation · Final report · May 31, 1985 · N3721H · Substantial damage > At the conclusion of a nearly 5 hours long non stop flight from NM to CA, the pilot attempted to land at an uncontroll-ed airport. The pilot acknowledged that the aircraft's finalapproach speed was excessive, and after the aircraft toucheddown it bounced off… - [NTSB CHI85LA217](https://openairdocs.org/ntsb/CHI85LA217.md): Cessna 150M · Merrill, WI · Accident · No injuries · Limited investigation · Final report · May 31, 1985 · N66069 · Substantial damage > The plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps. - [NTSB LAX85LA264](https://openairdocs.org/ntsb/LAX85LA264.md): Beech 65-A90 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N22WC · Substantial damage > While landing the right main landing gear of the aircraft seperated when the upper torque knee link failed. After the gear separated the aircraft skidded off the right side of the runway coming to rest in a grass area. Metallurgical examination of the failed… - [NTSB FTW85LA239](https://openairdocs.org/ntsb/FTW85LA239.md): Hughes 300 · Lake Worth, TX · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N9660F · Substantial damage > While undergoing helicopter transition training from the previous owner, who holds no instructor certificate, the new owner's son had been practicing pwr recovery autorotations. The eng failed to respond to application of throttle, and a full autorotative… - [NTSB FTW85LA236](https://openairdocs.org/ntsb/FTW85LA236.md): Grumman G-164A-600 · Dalhart, TX · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N36RA · Substantial damage > The plt had accumulated 12 hrs experience in this model acft. He stated the acft bounced on the rough airstrip, and he applied too much brake on the next touchdown. The acft nosed over, damaging the top wing and empennage. - [NTSB CHI85FA218](https://openairdocs.org/ntsb/CHI85FA218.md): Cessna 425 · Dayton, OH · Accident · Serious injuries · Field investigation · Final report · May 29, 1985 · N2079A · Substantial damage > The acft involved was experimentally configured with 4-bladed props and was on a test flt to determine handling characteristics following a throttle chop to idle power at 50 ft AGL. This maneuver had been accomplished twice on the test flt without incident.… - [NTSB MIA85LA184](https://openairdocs.org/ntsb/MIA85LA184.md): Cessna 337G · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · May 28, 1985 · N53633 · Substantial damage > The plt stated that while practicing an actual single eng landing, he forgot to lower the landing gear. He heard the gear warning horn but said that he thought it was his radar alimeter sounding. He admitted that actual single eng landings should not be… - [NTSB ANC85LA087](https://openairdocs.org/ntsb/ANC85LA087.md): Stinson 108-3 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · May 28, 1985 · N6175M · Substantial damage > While landing with a gusty x-wind, the acft bounced, the left wing dragged the ground & the acft went off the rwy. The plt stated that due to the x-wind & his foot slipping off of the rudder pedal, he was unable to maintain directional control. - [NTSB ATL85LA174](https://openairdocs.org/ntsb/ATL85LA174.md): Piper PA-12 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · May 27, 1985 · N2378M · Substantial damage > During the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged. - [NTSB NYC85LA135](https://openairdocs.org/ntsb/NYC85LA135.md): Gulfstream 681 · Millville, NJ · Accident · No injuries · Limited investigation · Final report · May 25, 1985 · N911JM · Substantial damage > The plt reported that when the landing gear was lowered during the apch, the right main gear light did not illuminate, however, the 'in-transit' light went out. He also reported, the gear warning horn stopped sounding and the hydraulic pressure was normal.… - [NTSB CHI85LA221](https://openairdocs.org/ntsb/CHI85LA221.md): Cessna 170B · Waseca, MN · Accident · No injuries · Limited investigation · Final report · May 25, 1985 · N1676D · Substantial damage > The plt stated that on final apch the x-wind correction was good and he had a 45 deg wind from the right at aprx 15 KTS with gusts to 20 KTS. During the flare, the acft ballooned and landed in a right yaw. The plt stated that he then added pwr and left rudder… - [NTSB CHI85LA208](https://openairdocs.org/ntsb/CHI85LA208.md): Cessna 150L · Necedah, WI · Accident · No injuries · Limited investigation · Final report · May 25, 1985 · N5481Q · Substantial damage > After a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into… - [NTSB ANC85FA086](https://openairdocs.org/ntsb/ANC85FA086.md): Piper PA-18-150 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · May 24, 1985 · N7786D · Substantial damage > Acft lost control during landing & groundlooped. The plt stated the heel of his shoe slipped off the brake pedal when an attempt to apply the brakes was made. - [NTSB DEN85LA140](https://openairdocs.org/ntsb/DEN85LA140.md): Champion 7FC · Watkins, CO · Accident · Minor injuries · Limited investigation · Final report · May 23, 1985 · N781VY · Destroyed > A witness stated the acft veered aprx 30 degs during the landing roll and was heading toward the north edge of the rwy when full pwr was added to abort the landing. The acft took off and traveled over a grass and wheat field, which borders the rwy, with the… - [NTSB NYC85LA133](https://openairdocs.org/ntsb/NYC85LA133.md): Cessna 172 · Erie, PA · Accident · No injuries · Limited investigation · Final report · May 22, 1985 · N8703B · Substantial damage > The acft ballooned during landing and drifted to the side of the rwy where it made ground contact in a drainage area. The acft bounced and came down hard before coming to a stop. The plt said he was high on appraoch & lowered full flaps. The acft was not… - [NTSB FTW85LA231](https://openairdocs.org/ntsb/FTW85LA231.md): Piper PA-24-250 · Austin, TX · Accident · No injuries · Limited investigation · Final report · May 22, 1985 · N6665P · Substantial damage > The plt stated he felt the gear extend and the corresponding decrease in airspeed when the gear was lowered during the apch. He stated he thought he observed a green gear down indication and he did observe the shadow of the extended gear on the ground as the… - [NTSB CHI85LA205](https://openairdocs.org/ntsb/CHI85LA205.md): Piper PA-28-235 · Valparaiso, IN · Accident · No injuries · Limited investigation · Final report · May 22, 1985 · N8521N · Substantial damage > Acft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident. - [NTSB MKC85LA109](https://openairdocs.org/ntsb/MKC85LA109.md): Beech 35-B33 · Calamus, IA · Accident · Minor injuries · Limited investigation · Final report · May 21, 1985 · N3EM · Substantial damage > During arrival, the plt landed on a 1700 ft turf rwy which sloped downhill to the north & had a 30 ft power line located near the apch end. Reportedly, the acft touched down 572 ft from the departure end, then continued off the rwy & hit a dirt bank next to a… - [NTSB BFO85LA047](https://openairdocs.org/ntsb/BFO85LA047.md): Cessna 152 · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · May 21, 1985 · N6529L · Substantial damage > The plt prefldd the acft iaw a checklist and did not note any abnormalities. Following a normal tkof the plt remained in the traffic pattern, experiencing no complications until touchdown. The winds recorded at bwi were out of 220 degrees at 8 knots. The plt… - [NTSB NYC85LA130](https://openairdocs.org/ntsb/NYC85LA130.md): Maule M-5-235C · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · May 20, 1985 · N5640C · Substantial damage > The personal transportation flight took off from allegheny co. ariport and made one landing back at the airport. The flight then departed the airport and made a landing on the water with the wheels down causing the aircraft to tip o ver onto its back. - [NTSB MKC85FCJ01](https://openairdocs.org/ntsb/MKC85FCJ01.md): Robinson R22 · Gladstone, NE · Accident · Serious injuries · Final report · May 20, 1985 · N8386B · Destroyed > The acft made a hard off arpt landing in an unlighted farm field on a dark night. The acft'dropped in' from about 50 ft AGL in a vertical descent. After ground contact the acft rolled over to the right. No mechanical malfunctions were noted during the… - [NTSB FTW85LA227](https://openairdocs.org/ntsb/FTW85LA227.md): Beech 58P · Abilene, TX · Accident · No injuries · Limited investigation · Final report · May 20, 1985 · N95BH · Substantial damage > The plt stated he made a normal landing and the gear folded during the rollout. Another plt who was waiting at the end of the rwy for takeoff observed the landing and stated the landing gear was extended too late and was still in transit (not fully down) when… - [NTSB SEA85LA191](https://openairdocs.org/ntsb/SEA85LA191.md): Piper PA-24-250 · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N6927P · Substantial damage > The plt mistakenly landed on a pvt airstrip and during a x-wind landing made a go around due to a gust of wind. The acft struck a dirt berm with the right wing and the right main gear. - [NTSB NYC85LA129](https://openairdocs.org/ntsb/NYC85LA129.md): Cessna 180J · Hooksett, NH · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N52197 · Substantial damage > The plt was ferrying the acft to a fld where floats were to be installed. While on the apch, the acft encountered a crosswind and drifted 20 ft off the intended centerline. The acft touched down and rolled about 110 ft before colliding with a small bush and… - [NTSB NYC85LA127](https://openairdocs.org/ntsb/NYC85LA127.md): Cessna C152 · Newry, PA · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N94221 · Substantial damage > The student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the… - [NTSB CHI85LA216](https://openairdocs.org/ntsb/CHI85LA216.md): Piper PA-32T-300 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N39628 · Substantial damage > The pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs. - [NTSB CHI85LA203](https://openairdocs.org/ntsb/CHI85LA203.md): Cessna 140A · Owosso, MI · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N3797V · Substantial damage > The plt-in-command allowed the passenger in the right seat, a rated plt, to land the acft. This plt lost directional control during the landing roll & the acft ground looped. During the second ground loop the right main landing gear axle separated from the… - [NTSB FTW85LA226](https://openairdocs.org/ntsb/FTW85LA226.md): Piper PA-34-200 · Crowell, TX · Accident · No injuries · Limited investigation · Final report · May 18, 1985 · N55800 · Destroyed > The pilot landed with a light tail wind on a 3200 ft rwy which slopes downward. The brakes faded and became ineffective due to heavy application. A go-around was attempted; however, flying speed was not obtained and the acft impacted the ground about 200 ft… - [NTSB SEA85LA114](https://openairdocs.org/ntsb/SEA85LA114.md): Bellanca 7ECA · Rio Vista, CA · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N2899Z · Substantial damage > The instructor plt (CFI) reported that during a bounced landing recovery, the student plt held the acft in a 3-point attitude above the rwy. As airspeed decayed, the (CFI) took control & added full power. However, the right wing dropped & grazed rising… - [NTSB NYC85LA132](https://openairdocs.org/ntsb/NYC85LA132.md): Piper PA-22-150 · Batavia, NY · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N7523D · Substantial damage > The commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,… - [NTSB NYC85LA126](https://openairdocs.org/ntsb/NYC85LA126.md): Piper PA-31-350 · Potsdam, NY · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N3548V · Substantial damage > The pilot received a weather breifing and filed an IFR flight plan with massena flight service station. The flight was uneventful and the aircraft was cleared for the NDB approach at Potsdam by boston center. When the airport was in sight, the pilot cnacelled… - [NTSB FTW85LA228](https://openairdocs.org/ntsb/FTW85LA228.md): Cessna 182M · Chickasha, OK · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N71351 · Substantial damage > The acft bounced during landing and the student plt allowed the acft to porpoise. The nose gear, engine firewall and propeller were damaged. This was the student's first solo flt. His last 2.7 hrs of dual flt instruction consisted of 18 practice touch and go… - [NTSB MKC85LA102](https://openairdocs.org/ntsb/MKC85LA102.md): Cessna R182 · Monticello, AR · Accident · Minor injuries · Limited investigation · Final report · May 16, 1985 · N737LE · Substantial damage > Plt selected grassy area on arpt for landing. The grassy area was more closely aligned with the surface winds than the available runways. The grassy area has a utility line across the apch end and a ditch on the departure end. The landing was long and hot and… - [NTSB MIA85LA175](https://openairdocs.org/ntsb/MIA85LA175.md): Cessna 152 · Jekyll Island, GA · Accident · No injuries · Limited investigation · Final report · May 16, 1985 · N6418Q · Substantial damage > The student plt was on her 1st supervised solo. During a touch-&-go landing, the acft veered off the left side of the rwy & subsequently hit a culvert. The student said that after she landed, she applied too much left rudder. - [NTSB FTW85LA225](https://openairdocs.org/ntsb/FTW85LA225.md): Cessna 150M · Moran, TX · Accident · No injuries · Limited investigation · Final report · May 16, 1985 · N63613 · Substantial damage > The student plt attempted to make a precautionary landing due to his immediate need to use the bathroom. There were no acft problems involved. The student used 'soft field landing' techniques and touched down on soft ground for an off arpt landing. When the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=428 ## 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=427 --- 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.