# 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 430 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DEN85IA109](https://openairdocs.org/ntsb/DEN85IA109.md): Cessna 185F · Jackson, WY · Incident · No injuries · Incident investigation · Final report · Apr 3, 1985 · N57PL · Minor damage > The plt of N57PL was attempting a landing in a strong crosswind in VFR conditions. During the landing roll, the left main landing gear tire blew out causing the acft to ground loop. - [NTSB ATL85LA127](https://openairdocs.org/ntsb/ATL85LA127.md): Cessna A188B · Prentiss, MS · Accident · No injuries · Limited investigation · Final report · Apr 3, 1985 · N4884Q · Substantial damage > There was no wind as the plt took off to proceed to an ag site; however, by the time he arrived, the wind had begun to blow. Reportedly, he landed downwind on a rural road in winds that were from the southwest at 10 gusting to 15 KTS. The plt stated that he… - [NTSB LAX85LA191](https://openairdocs.org/ntsb/LAX85LA191.md): Cessna 414 · Eagle Mountain, CA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1985 · XBDED · Substantial damage > According to the riverside county California sheriff's department the acft touched down left gear first and experienced a blowout or gear failure on the right gear. The acft ran off the right side of the rwy, skidded across a dirt berm partially separating… - [NTSB LAX85FVG01](https://openairdocs.org/ntsb/LAX85FVG01.md): Cessna 152 · Lower Lake, CA · Accident · No injuries · Final report · Apr 2, 1985 · N4602L · Substantial damage > The acft contacted trees while attempting to land at hoberg airstrip. - [NTSB LAX85FA193](https://openairdocs.org/ntsb/LAX85FA193.md): Cessna 150M · Fullerton, CA · Accident · Minor injuries · Field investigation · Final report · Apr 2, 1985 · N8190U · Substantial damage > Gnd witness & the student plt rptd upon touchdown the acft began to bounce. After several bounces the plt began to go-around upon reaching midfield. After lift off the acft began to sink and collided with the arpt boundary fence. When executing the go-around… - [NTSB FTW85LA172](https://openairdocs.org/ntsb/FTW85LA172.md): Mooney M20A · Austin, TX · Accident · No injuries · Limited investigation · Final report · Apr 2, 1985 · N8121E · Substantial damage > The 86 hr private plt landed at a ranch and ran off the end of the rwy into rough terrain. A go around was not attempted. - [NTSB DEN85LA108](https://openairdocs.org/ntsb/DEN85LA108.md): Maule M-5-210C · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Apr 2, 1985 · N332X · Substantial damage > The plt of a Maule lost directional control during an attempted landing at a dirt strip near ft collings, CO. The wind was from the west at a full landing stall attitude when a gust of wind picked the rt wg up causing the left wing to contact the ground.… - [NTSB DEN85LA107](https://openairdocs.org/ntsb/DEN85LA107.md): Piper PA-28-181 · Kemmerer, WY · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1985 · N1085H · Substantial damage > On April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to… - [NTSB MKC85LA081](https://openairdocs.org/ntsb/MKC85LA081.md): Ehlers Starduster ESA300 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Apr 1, 1985 · N11HE · Substantial damage > The plt stated that during the landing roll he noticed an acft landing behind his and therefore veered his acft to the right of rwy 36 traveling about 45 mph. During the maneuver the plt felt the right gear give and the acft consequently ground looped twice… - [NTSB LAX85LVA01](https://openairdocs.org/ntsb/LAX85LVA01.md): Piper PA28-236 · Porterville, CA · Accident · No injuries · Final report · Mar 31, 1985 · N43504 · Substantial damage > While on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose… - [NTSB LAX85FA188](https://openairdocs.org/ntsb/LAX85FA188.md): Cessna 172N · Anza, CA · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1985 · N738UZ · Substantial damage > After making two previous takeoffs and one landing in an overloaded airplane the pilot landed about 1000 feet down a 3200 foot runway. When the aircraft failed to decelerate quickly enough and the pilot attempted a go-around toward rising terrain. The… - [NTSB MIA85IA137](https://openairdocs.org/ntsb/MIA85IA137.md): Cessna 402C · Ft. Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Mar 30, 1985 · N2719T · Minor damage > The acft veered off the left side of rwy 9R on landing. Inspection of the acft revealed that the torque link washers on the left main landing gear had failed allowing the wheel assembly to rotate causing the loss of directional control. No record of… - [NTSB DEN85LA098](https://openairdocs.org/ntsb/DEN85LA098.md): Cessna 402C · Aspen, CO · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N2711X · Substantial damage > The plt was given instructions by the Aspen twr controller to land on rwy 15. He was requested to make a short final to the rwy because of approaching traffic. The pilot stated that he landed slightly left of the rwy ctr line. The acft skidded to left and the… - [NTSB ATL85LA128](https://openairdocs.org/ntsb/ATL85LA128.md): Varieze Duncan/Varieze · Ocracoke, NC · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N9329A · Substantial damage > During landing, the tab which connects the landing gear cross tube failed allowing the right gear to collapse. The acft has an experimental certificate. The failure appeared to be due to design limitations. - [NTSB ATL85LA126](https://openairdocs.org/ntsb/ATL85LA126.md): Piper PA-32-260 · Blairsville, GA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N3744W · Substantial damage > During flt, the plt encountered unfavorable winds & rain, then became concerned about his fuel supply. He diverted to Blairsville & was landing when a gust of wind blew the acft side ways. The plt re-aligned the acft with the rwy, but it suddenly dropped &… - [NTSB MKC85LA079](https://openairdocs.org/ntsb/MKC85LA079.md): Cessna 188 · Osage City, KS · Accident · No injuries · Limited investigation · Final report · Mar 29, 1985 · N9959G · Substantial damage > The plt was practicing landing at the airport when during the landing roll on the third attempt at landing the acft swerved off the rwy. The acft ground looped after departing the rwy and sustained substantial damage. The plt rptd the brakes grabbed… - [NTSB CHI85LA150](https://openairdocs.org/ntsb/CHI85LA150.md): Cessna 152 · Richmond, IN · Accident · No injuries · Limited investigation · Final report · Mar 29, 1985 · N48241 · Substantial damage > While on a solo training flt the student plt allowed the acft to bounce during touchdown. The acft then became airborne & stalled while several feet above the rwy. During the ensuing hard landing the nose gear strut collapsed & the acft veered to the left… - [NTSB LAX85LVD01](https://openairdocs.org/ntsb/LAX85LVD01.md): Piper PA-24-250 · Navato, CA · Accident · No injuries · Final report · Mar 28, 1985 · N6012P · Substantial damage > The acft was landed gear up. The plt stated that as he retarded the throttle to land the lndg gear warning sounded. He applied power but the acft touched down with a scraping noise. He does not remember seeing a green lite for gear dwn indication.… - [NTSB LAX85LA189](https://openairdocs.org/ntsb/LAX85LA189.md): Cessna 172G · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Mar 27, 1985 · N3757L · Substantial damage > Instructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned… - [NTSB BFO85LA030](https://openairdocs.org/ntsb/BFO85LA030.md): Cessna 182G · Bridgewater, VA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1985 · N2318R · Substantial damage > Due to excess altitude, during his 1st apch to land, the plt executed a go-around. The 2nd apch resulted in proper altitude, but high airspeed. Crosswind conditions & gusts up to 22 KTS existed at the time & touchdown occurred aprx half way down the 2755 ft… - [NTSB NYC85LA091](https://openairdocs.org/ntsb/NYC85LA091.md): Piper PA-28-180 · Clearfield, PA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1985 · N55369 · Substantial damage > The acft veered off the rwy and collided with a drainage ditch during touchdown. The plt stated that during the apch to the arpt, the acft flew over a coal stripping mine which produced turbulence and resulted in a touchdown without proper alignment with the… - [NTSB MIA85LA133](https://openairdocs.org/ntsb/MIA85LA133.md): Hughes 269C · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Mar 26, 1985 · N58208 · Substantial damage > The instructor plt (CFI) reported that while practicing a taxi/hover autorotation, the helicopter settled onto a soft area in the turf. He reported that the student over-controlled with right anti-torque pedal & the helicopter settled in a left skid. The CFI… - [NTSB FTW85LA179](https://openairdocs.org/ntsb/FTW85LA179.md): Piper PA-31 · Eagle Lake, TX · Accident · No injuries · Limited investigation · Final report · Mar 25, 1985 · N23L · Destroyed > On or about 3/25/85, the acft was landed on a short private strip. During the landing, it overran the strip, then collided with a dirt bank & a tree. The plt abandoned the acft. Neither he nor the new owner could be found. There was evidence that the acft had… - [NTSB CHI85LA148](https://openairdocs.org/ntsb/CHI85LA148.md): Piper PA-20-125 · Zionsville, IN · Accident · No injuries · Limited investigation · Final report · Mar 25, 1985 · N7629K · Substantial damage > The plt stated that she flared slightly high upon landing, causing the acft to bounce. Once the acft was on the ground again it began to drift to the left side of the rwy. To correct for this drift, the plt applied right rudder, however, she overcorrected… - [NTSB NYC85LA090](https://openairdocs.org/ntsb/NYC85LA090.md): Cessna L-19 · Perkasie, PA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N5234G · Substantial damage > Cessna L-19,a practice flight of takeoffs and landings for glider tow operation for philidelphia glider council encounter a wind shift on landing. The student pilot over corrected and the aircraft ground looped. The instuctor pilot at this time took control… - [NTSB LAX85LA223](https://openairdocs.org/ntsb/LAX85LA223.md): General Balloon AX-6 · Panamint Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 1985 · N2614K · Minor damage > The plt reported that he was landing on desert terrain in nearly calm air when a 'strong thermal wind pushed the balloon 90 degrees from the direction of track.' Subsequently, the balloon landed hard & was dragged about 150 ft across the desert. While… - [NTSB FTW85LA161](https://openairdocs.org/ntsb/FTW85LA161.md): Cessna 150F · Fritch, TX · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N6928F · Substantial damage > The student pilot touched down short of the rwy while attempting to land downwind. He then attempted a go-around but lost control due to inadequate airspeed. The aircraft banked to the right and struck the tail section of a parked airplane and crashed. - [NTSB MKC85FA076](https://openairdocs.org/ntsb/MKC85FA076.md): Swearingen SA226TC · Hot Springs, AR · Accident · No injuries · Field investigation · Final report · Mar 23, 1985 · N508SS · Substantial damage > The first officer was making the landing and the acft bounced during touchdown. The captain's right hand, which had beennear the floor to the right of his seat, bumped the landing gear selector to the up position as the captain reached for the yoke. The… - [NTSB LAX85FA185](https://openairdocs.org/ntsb/LAX85FA185.md): Swearingen SA 226TC · Los Angeles, CA · Accident · Serious injuries · Field investigation · Final report · Mar 23, 1985 · CGYRD · Substantial damage > On this leg of the flt, the 1st officer (fo) was flying the acft while the captain (capt) was monitoring & conducting ATC communications. Reportedly, the aircrew had followed the checklist during arrival; however, the acft was landed withthe gear retracted.… - [NTSB FTW85LA162](https://openairdocs.org/ntsb/FTW85LA162.md): North American AT-6G · Frederick, OK · Accident · No injuries · Limited investigation · Final report · Mar 23, 1985 · N9035Z · Substantial damage > The passenger heard a loud mechanical noise from the tail of the aircraft during rollout from a touch-and-go landing. The pilot was unable to maintain directional control, the aircraft ground looped, the main landing gear collapsed, and the wings were… - [NTSB NYC85LA085](https://openairdocs.org/ntsb/NYC85LA085.md): Boeing JB-75 · Marston Mills, MA · Accident · No injuries · Limited investigation · Final report · Mar 22, 1985 · N3993P · Substantial damage > The acft nosed over after contacting an utility pole during an overrun landing. The acft touched down aprx 1/2 way down the rwy and the plt applied brakes, however, braking action was poor because of the wet grass rwy. The acft skidded off the end of the rwy… - [NTSB DEN85LA101](https://openairdocs.org/ntsb/DEN85LA101.md): Piper PA 18-150 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Mar 21, 1985 · N2582S · Substantial damage > On March 21, 1985, a Piper pa 18 ground looped on landing rollout at gran Forks, ND. The instructor stated the aircraft accident occurred when he was checking out another flight instructor in the tailwheel airplane. During the landing roll out the airplane… - [NTSB DEN85FA099](https://openairdocs.org/ntsb/DEN85FA099.md): Cessna 182J · Erie, CO · Accident · 2 fatal · Field investigation · Final report · Mar 21, 1985 · N3354F · Destroyed > Reportedly, the plt had called the arpt office (UNICOM) & was advised that rwy 15/33 was closed. At about the time N3354F was arriving, a military helicopter landed on rwy 27. The plt asked a passenger to tell him which way the wind sock was blowing & she… - [NTSB MIA85LA125](https://openairdocs.org/ntsb/MIA85LA125.md): Cessna 152 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1985 · N69109 · Substantial damage > The student pilot was practicing touch-&-go landings on rwy 11. Due to a wind shift, the active rwy was changed to rwy 4. The student stated that during his 1st pattern for a landing on rwy 4, his apch was high & fast. As the acft touched down, he lost… - [NTSB MKC85LA073](https://openairdocs.org/ntsb/MKC85LA073.md): Cessna T210M · Joplin, MO · Accident · No injuries · Limited investigation · Final report · Mar 18, 1985 · N732XD · Substantial damage > The acft nose gear collapsed after a hard bounced landing. The plt stated that she touched down hard on the main gear then bounced and relanded on main and nose gear. During the 2nd touchdown the nose gear collapsed. The plt and her one-year-old daughter were… - [NTSB DEN85FTI03](https://openairdocs.org/ntsb/DEN85FTI03.md): Hilliard B-8-M · Clinton, MT · Accident · No injuries · Final report · Mar 18, 1985 · N8036T · Substantial damage > The gyrocopter inadvertently became airborne during a high speed taxi run. The plt reported that at an alt of aprx 10-15 ft AGL he 'cut the engine speed to idle, and pulled the joystick fully back to land.' This action put the gyrocopter in a nose high… - [NTSB CHI85LA142](https://openairdocs.org/ntsb/CHI85LA142.md): Cessna 172RG · Portland, IN · Accident · No injuries · Limited investigation · Final report · Mar 17, 1985 · N9584B · Substantial damage > Upon landing the nose gear was down & locked, but both main gear collapsed. The plt was not certain if a down & locked indication was received before touchdown. During a gear retraction/extension test after the accident, the gear operated normally. Also, the… - [NTSB NYC85LA084](https://openairdocs.org/ntsb/NYC85LA084.md): Cessna 172P · Princeton, NJ · Accident · No injuries · Limited investigation · Final report · Mar 16, 1985 · N62541 · Substantial damage > The acft experienced nose gear damage following a loss of control during touchdown. The plt stated the acft touched down on the main gear and bounced as the nose gear was being lowered. After the acft porpoised several times the plt was able to regain control… - [NTSB SEA85LA075](https://openairdocs.org/ntsb/SEA85LA075.md): Bellanca 7GCBC · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N5033W · Substantial damage > The acft bounced during landing and adequate recovery was not made. The acft came to rest inverted. - [NTSB CHI85LA136](https://openairdocs.org/ntsb/CHI85LA136.md): Cessna 172N · Crystal Lake, IL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N3421E · Substantial damage > The plt reported that as he lowered the nosewheel to the rwy during the landing roll, the acft veered to the right. As the right main gear went off the side of the rwy, it entered soft terrain which pulled the acft further to the right. Subsequently, the nose… - [NTSB SEA85LA074](https://openairdocs.org/ntsb/SEA85LA074.md): Grumman 164A · Ritzville, WA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N8495 · Substantial damage > During landing the acft caught a gust of wind and drifted right of the runway. The plt attempted to correct by use of rudder and aileron, but was unsuccessful. The acft then nosed ver. - [NTSB LAX85LA172](https://openairdocs.org/ntsb/LAX85LA172.md): Cessna 152 · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N95491 · Substantial damage > According to the plt she flared too late and was too close to the left side of the 50 ft wide rwy at touchdown. The acft veered left on the lndg roll and the left main gear struck a snowbank. The plt tried to steer out of the snowbank but the nose gear also… - [NTSB DEN85LA095](https://openairdocs.org/ntsb/DEN85LA095.md): Cessna 310 · Angel Fire, NM · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N5515G · Substantial damage > The acft touched down 1500 ft short of the rwy and the nose gear collapsed. The taxiways were rough and soft yellow chevrons were painted on the taxiways, at the apch end of the rwy. The plt stated that he was concentrating on the apch and did not see the… - [NTSB ATL85LA123](https://openairdocs.org/ntsb/ATL85LA123.md): Cessna 182P · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N76RF · Substantial damage > The plt lost directional control during ldg when the acft encountered wind gusts and was blown off the rwy. - [NTSB ANC85LA057](https://openairdocs.org/ntsb/ANC85LA057.md): Curtiss C-46R · Nulato, AK · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N7848B · Substantial damage > The acft continued off the end of the rwy and contacted a snow berm during the landing roll. The plt reported the rwy braking action as poor. - [NTSB SEA85LA078](https://openairdocs.org/ntsb/SEA85LA078.md): Piper PA-32-300 · Fish Lake Valle, NV · Accident · No injuries · Limited investigation · Final report · Mar 13, 1985 · N2965A · Substantial damage > During landing roll the acft veered sharply to the left and struck an irrigation sprinkling system. The operator discovered that the valve stem to the tire had broken and the plt had landed with a flat tire. - [NTSB LAX85LA171](https://openairdocs.org/ntsb/LAX85LA171.md): Piper PA-44-180T · Woodland, CA · Accident · No injuries · Limited investigation · Final report · Mar 13, 1985 · N8322T · Substantial damage > The instructor (CFI) was preparing his student for a multiengine, private plt, flt test. The purpose of the lesson was to demonstrate a precautionary landing following a simulated loss of power after takeoff. At an alt of about 100 ft AGL, the CFI retarded… - [NTSB SEA85LA073](https://openairdocs.org/ntsb/SEA85LA073.md): Cessna 172 · Soda Springs, ID · Accident · No injuries · Limited investigation · Final report · Mar 12, 1985 · N8553X · Substantial damage > The plt made a precautionary landing due to an iced up pitot tube. The plt landed with excess speed and was unable to stop the acft before it overran the end of the rwy. It struck a snow bank and then flipped inverted. - [NTSB MIA85LA115](https://openairdocs.org/ntsb/MIA85LA115.md): Piper PA-28-140 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Mar 11, 1985 · N44480 · Destroyed > The plt stated that when he smelled smoke in the cabin, he landed & taxied to the ramp area, then a fire erupted. An investigation revealed the fire started where an electrical short occurred near the APU plug (in the area of the aft baggage compartment). - [NTSB ATL85LA114](https://openairdocs.org/ntsb/ATL85LA114.md): Bellanca 7KCAB · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Mar 11, 1985 · N53726 · Substantial damage > The plt landed long on the rwy & at excessive speed. In an attempt to stop the acft she applied brakes & the acft flipped upside down. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=431 ## 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=430 --- 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.