# 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 398 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX87LA256](https://openairdocs.org/ntsb/LAX87LA256.md): Piper PA-28-181 · Huron, CA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1987 · N8273P · Substantial damage > At the end of a cross country flight,the plt applied the brakes on touch down. The acft veered to the left and the plt applied the right brake, however, the left main landing gear went off the edge of the rwy. The acft went out of control, exited the rwy and… - [NTSB ANC87LA089](https://openairdocs.org/ntsb/ANC87LA089.md): Cessna 180 · Matanuska Glaci, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1987 · N2995T · Substantial damage > The pilot stated that upon touchdown on the glacier the surface was cluster snow. The aircraft rolled about 150 feet and nosed over on its back. - [NTSB SEA87LA198](https://openairdocs.org/ntsb/SEA87LA198.md): Cessna 150A · Tacoma, WA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1987 · N9815J · Substantial damage > While lndg, the plt decided to go around. He stated the acft floated as he applied pwr & the pwr increased to about 2400 RPM. He raised the nose slightly & retracted the electrically operated flaps from 35 to zero deg. He said he established a climb to about… - [NTSB SEA87LA134](https://openairdocs.org/ntsb/SEA87LA134.md): Cessna 182 · Sprague River, OR · Accident · No injuries · Limited investigation · Final report · Jul 3, 1987 · N2625Q · Substantial damage > A hard, flat, bounced landing occurred collapsing the nose gear and damaging the firewall. - [NTSB SEA87LA130](https://openairdocs.org/ntsb/SEA87LA130.md): Cessna 206 · Olympia, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1987 · N55FS · Substantial damage > During landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the… - [NTSB FTW87LA157](https://openairdocs.org/ntsb/FTW87LA157.md): Cessna 172L · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 3, 1987 · N3980Q · Substantial damage > While lndg, the student plt had flared the acft in a rgt x-wind with gusts to 13 KTS. Subsequently, the acft drifted left & the left main gear went into soft mud. The acft then veered to the left and was damaged. - [NTSB DEN87LA174](https://openairdocs.org/ntsb/DEN87LA174.md): Raven S77A · Silverthorne, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1987 · N41986 · No damage > The commercial balloon pilot was conducting passenger flights. A landing was being made on a parking lot with ten knots of wind and gusts to twenty knots. Just at touchdown a light gust caught the balloon and dragged it one hundred feet. One passenger chose… - [NTSB ATL87LA196](https://openairdocs.org/ntsb/ATL87LA196.md): Cessna 175 · Sebring, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1987 · N7659M · Substantial damage > Plt and his two pax had spent most of the day at barber apt preparing for the fireman's bbq to be held later. In late afternoon, they decided to take a flt around the area. During the flt, it was decided to land at the tri-city apt. Witnesses reptd that the… - [NTSB ANC87LA092](https://openairdocs.org/ntsb/ANC87LA092.md): Piper J-3 · Lake Creek, AK · Accident · No injuries · Limited investigation · Final report · Jul 2, 1987 · N3691K · Substantial damage > The pilot stated he touchdowned on a gravel bar and shortly after touchdown he lost control of the aircraft causing the aircraft to nose over on its back. - [NTSB ANC87LA088](https://openairdocs.org/ntsb/ANC87LA088.md): Piper PA-18-180 · Pingo Ridge, AK · Accident · No injuries · Limited investigation · Final report · Jul 2, 1987 · N4408Z · Substantial damage > The pilot stated that after touchdown he lost control of the aircraft causing the aircraft to nose over on its back. - [NTSB LAX87LA266](https://openairdocs.org/ntsb/LAX87LA266.md): Cessna 152 · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N24233 · Substantial damage > The student plt rprtd that he entered the traffic pattern to practice takeoffs & landings. He said that drg his 1st apch, he relaxed pressure on the left rudder pedal & the acft began to yaw. He then pulled aft on the yoke to avoid touching down sideways &… - [NTSB FTW87LA155](https://openairdocs.org/ntsb/FTW87LA155.md): Cessna 152 · Farris, OK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N49131 · Substantial damage > The plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged. - [NTSB BFO87LA044](https://openairdocs.org/ntsb/BFO87LA044.md): Cessna 150H · Hot Springs, VA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N23106 · Substantial damage > On the second leg of a cross-country flight from annapolis, MD to albuquerque, NM, the pilot became disoriented and was unable to locate ingalls airport in Hot Springs, VA. The pilot realized he was low on fuel and decided to make a precautionary landing on a… - [NTSB MIA87LA193](https://openairdocs.org/ntsb/MIA87LA193.md): Stinson 108-1 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 29, 1987 · N8399K · Substantial damage > While on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear… - [NTSB MIA87IA192](https://openairdocs.org/ntsb/MIA87IA192.md): Cessna 310J · Sarasota, FL · Incident · No injuries · Incident investigation · Final report · Jun 29, 1987 · N3120L · Minor damage > During the landing roll the rt main landing gear collapsed after which the acft slid off the rwy, collided with a taxiway light & came to rest. Insp of the rt main landing gear revealed that the downlock spring failed which prevented the gear from fully… - [NTSB LAX87LA254](https://openairdocs.org/ntsb/LAX87LA254.md): Beech C90 · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1987 · N2030W · Substantial damage > The pilot indicated that the left main gear collapsed during landing rollout. The pilot did not respond to the following questions, when asked during a telephone interview, 'when was the gear placed down? And what did the gear safe indicator lights indicate… - [NTSB ATL87LA192](https://openairdocs.org/ntsb/ATL87LA192.md): Navion H · New Ellenton, SC · Accident · No injuries · Limited investigation · Final report · Jun 28, 1987 · N2525T · Substantial damage > Previously, the acft had been involved in a gear-up lndg & was out of svc while it was being repaired. Drg that time the annual inspn expired. A special airworthiness certificate was obtained to ferry the acft to the sizemore arpt for the annual inspn. Drg… - [NTSB SEA87LA126](https://openairdocs.org/ntsb/SEA87LA126.md): Cessna 180A · Dallas, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1987 · N5270D · Substantial damage > The pilot inadvertently landed with a quartering gusting tailwind. On landing rollout the aircraft nosed over inverted. - [NTSB LAX87LA253](https://openairdocs.org/ntsb/LAX87LA253.md): Beech C23 · Brownsville, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N5161M · Substantial damage > During a cross country flt, the plt over flew the rwy once for a visual wind speed and direction check. During the first approach the acft was too high so the plt went around. On the second approach, during the flare, the acft stayed airborne down most of the… - [NTSB DEN87LA160](https://openairdocs.org/ntsb/DEN87LA160.md): Cessna 182RG · Deming, NM · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N6124T · Substantial damage > During the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a… - [NTSB BFO87LA043](https://openairdocs.org/ntsb/BFO87LA043.md): Cessna 195A · Cambridge, MD · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N9321A · Substantial damage > After purchasing the acft in atl, the plt, who held an a & p certificate, inspected and flew the acft in the local area bfr departing on a ferry flt to rockland, ME. Drg lndg at his first fuel stop, the acft swerved to the rt and the plt intentionally… - [NTSB NYC87LA189](https://openairdocs.org/ntsb/NYC87LA189.md): Piper PA-60 · Doylestown, PA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1987 · N14HR · Substantial damage > Upon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and… - [NTSB FTW87LA154](https://openairdocs.org/ntsb/FTW87LA154.md): Great Lakes 2T-1A-2 · Baytown, TX · Accident · No injuries · Limited investigation · Final report · Jun 26, 1987 · N3564L · Substantial damage > Drg the lndg roll, the acft started to drift to the left, so the plt corrected with right rudder. He said he over- controlled, then applied left rudder & brake, followed by right rudder & brake. Subsequently, the situation became aggravated until both main… - [NTSB ATL87IA191](https://openairdocs.org/ntsb/ATL87IA191.md): Swearingen SA-226TC · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Jun 26, 1987 · N256AM · No damage > There was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr… - [NTSB ATL87LA190](https://openairdocs.org/ntsb/ATL87LA190.md): Cessna A188B · Dyersburg, TN · Accident · No injuries · Limited investigation · Final report · Jun 25, 1987 · N2828J · Substantial damage > Drg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi… - [NTSB ATL87LA186](https://openairdocs.org/ntsb/ATL87LA186.md): Cessna 152 · Dothan, AL · Accident · No injuries · Limited investigation · Final report · Jun 25, 1987 · N45994 · Substantial damage > The comm plt held a helicopter rating and was training for his private pilot single-engine-land rating. He had flown approximately 10 hours in fixed wing aircraft with 6 hours as PIC. The pilot had completed two landings and on the thirdapproach stated he was… - [NTSB NYC87LA185](https://openairdocs.org/ntsb/NYC87LA185.md): Piper PA-34 · Southbridge, MA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N4348T · Substantial damage > During landing roll, a failure of a tire tube caused a flat tire and control of the aircraft was lost. When the tire was dismantled, the inner tube was found to be defective at the joint seam. Total time on the acft and tire WAS407 hrs. The acft had a 100 hr… - [NTSB NYC87LA184](https://openairdocs.org/ntsb/NYC87LA184.md): Cessna 152 · Butler, PA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N93304 · Substantial damage > The student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged. - [NTSB ATL87LA183](https://openairdocs.org/ntsb/ATL87LA183.md): Cessna 140 · Falmouth, KY · Accident · No injuries · Limited investigation · Final report · Jun 23, 1987 · N89784 · Substantial damage > The pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the… - [NTSB LAX87LA244](https://openairdocs.org/ntsb/LAX87LA244.md): Nord 3202 · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1987 · N32RM · Substantial damage > During a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail… - [NTSB ATL87LA181](https://openairdocs.org/ntsb/ATL87LA181.md): Cessna 172B · Belton, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1987 · N8105X · Substantial damage > The pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface… - [NTSB ATL87LA180](https://openairdocs.org/ntsb/ATL87LA180.md): Lockheed L-382-30 · Dayton, OH · Accident · No injuries · Limited investigation · Final report · Jun 22, 1987 · N20ST · Substantial damage > The flight experienced separation of the nose landing gear during the landing roll. Investigation showed that the failure was related to the progression of a preexisting crack on the nose landing gear strut assembly. The probelms with the nose landing gear… - [NTSB SEA87LA120](https://openairdocs.org/ntsb/SEA87LA120.md): Piper PA-18-135 · Yakima, WA · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N27039 · Substantial damage > While on landing roll in gusty crosswind conditions, the aircraft swerved off the runway and ground looped. - [NTSB FTW87LA148](https://openairdocs.org/ntsb/FTW87LA148.md): Cessna 182 · Alice, TX · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N5496E · Substantial damage > The pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical… - [NTSB DEN87LA155](https://openairdocs.org/ntsb/DEN87LA155.md): Cessna 172 · Paradise, UT · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N7121A · Substantial damage > The plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father… - [NTSB NYC87LA182](https://openairdocs.org/ntsb/NYC87LA182.md): Maule M-4 · Wellsville, NY · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N40354 · Substantial damage > The flight experienced a violent shimmy upon t/d and the acft veered to the right. The pilot made a go-around and experienced the same condition on the second t/d. on the third t/d, the pilot landed but was only able to maintain control of the acft until it… - [NTSB ATL87LA178](https://openairdocs.org/ntsb/ATL87LA178.md): Maule M-7-235 · Augusta, GA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N5667F · Substantial damage > The aircraft was on its first flight from the factory. The pilot was checked out in the aircraft on the day prior to theaccident flight. Witnesses reported the aircraft touched down and lifted off several times. The pilot stated the aircraft got away from him… - [NTSB MKC87LA171](https://openairdocs.org/ntsb/MKC87LA171.md): Cessna TU206G · West Plains, MO · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N4881U · Substantial damage > During ldg phase of operation, PIC was unable to stop the acft before striking a fence on the overrun. Plt stated a rain shower had just passed through which left the dirt surface slick and muddy. He stated that he was unable to obtain effective braking due… - [NTSB LAX87LA237](https://openairdocs.org/ntsb/LAX87LA237.md): Grumman AA-5 · Rimrock, AZ · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N5438L · Substantial damage > The aircraft overran the runway while on a personal VFR cross-country flight. The pilot indicated that he attempted a go-around after a poor approach and that the terrain off the end of the runway rose faster than the aircraft could climb. A witness observed… - [NTSB FTW87LA147](https://openairdocs.org/ntsb/FTW87LA147.md): Beech B36TC · Barnhart, TX · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N69309 · Substantial damage > Upon landing the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted bushes and rough terrain causing the aircraft to nose over. - [NTSB ATL87LA176](https://openairdocs.org/ntsb/ATL87LA176.md): Cessna 172P · Marion, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1987 · N52575 · Substantial damage > The acft overran the rwy end while the student plt was attempting a no-flap ldg. The acft impacted a berm at the end of the rwy and subsequently came to rest in a creek. The student plt reported that the acft had initially touched down about mid-field on the… - [NTSB ANC87LA082](https://openairdocs.org/ntsb/ANC87LA082.md): Taylorcraft BC-12D · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 1987 · N95695 · Substantial damage > The student pilot stated that during a landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. - [NTSB CHI87LA152](https://openairdocs.org/ntsb/CHI87LA152.md): Piper PA-28-161 · Muncie, IN · Accident · No injuries · Limited investigation · Final report · Jun 18, 1987 · N9174M · Substantial damage > After landing on rwy 32 the acft veered to the left, crossing a parallel taxiway and striking a taxiway light. The plt stated that the acft then became airborne before striking a terrain depression, at which time the nosewheel sheared off and the propeller… - [NTSB ATL87LA171](https://openairdocs.org/ntsb/ATL87LA171.md): Luscombe 8A · London, OH · Accident · No injuries · Limited investigation · Final report · Jun 18, 1987 · N1029K · Substantial damage > The pilot was making a planned refueling stop at madison county airport. He stated he made a normal pattern entry, approach and landing. During the roll out the aircraft groundlooped to the right and departed the runway. Investigation revealed no preimpact… - [NTSB CHI87LA150](https://openairdocs.org/ntsb/CHI87LA150.md): Hughes 300C · Aurora, IL · Accident · No injuries · Limited investigation · Final report · Jun 17, 1987 · N3625B · Substantial damage > While the student & instructor (CFI) were on an instructional flt, a decision was made to practice an autorotation & simulated tail rotor failure. Rprtdly, a smooth touchdown was made, but the helicopter began to vibrate. The CFI electedto get the helicopter… - [NTSB ANC87DAG03](https://openairdocs.org/ntsb/ANC87DAG03.md): Denney FOX 1 · Palmer, AK · Accident · No injuries · Final report · Jun 17, 1987 · N4987 · Substantial damage > The pilot stated that after touchdown on the sand bar the aircraft struck an open ditch. The pilot lost directional control of the aircraft causing the plane to nose over on its back. - [NTSB NYC87LA173](https://openairdocs.org/ntsb/NYC87LA173.md): Piper PA-38-112 · Canastota, NY · Accident · No injuries · Limited investigation · Final report · Jun 15, 1987 · N2477B · Substantial damage > A student pilot was performing tkofs and lndgs when after touchdown on the third landing, he lost directional control of the aircraft. After atmptg to salvage the lndg, the pilot initiated a go-around but the left wing stalled and the aircraft impacted on the… - [NTSB SEA87LA117](https://openairdocs.org/ntsb/SEA87LA117.md): Schweizer SGS 1-36 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N3616F · Substantial damage > While soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno… - [NTSB SEA87LA116](https://openairdocs.org/ntsb/SEA87LA116.md): Piper PA-28-160 · Odessa, WA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N5458W · Substantial damage > During landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over. - [NTSB MIA87LA183](https://openairdocs.org/ntsb/MIA87LA183.md): Piper PA-38 · Miramar, FL · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N2537N · Substantial damage > The student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=399 ## 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=398 --- 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.