# 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 400 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX87LA211](https://openairdocs.org/ntsb/LAX87LA211.md): Great Lakes 2T-1A-2 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N5762G · Substantial damage > A Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located… - [NTSB NYC87LA159](https://openairdocs.org/ntsb/NYC87LA159.md): Piper PA-28-235 · Toms River, NJ · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N9443W · Substantial damage > The flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings. - [NTSB NYC87LA149](https://openairdocs.org/ntsb/NYC87LA149.md): Cessna 172 · Atlantic City, NJ · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N734EM · Substantial damage > According to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a… - [NTSB NYC87LA148](https://openairdocs.org/ntsb/NYC87LA148.md): Cessna 182 · Honeoye Falls, NY · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N6298A · Substantial damage > The acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved… - [NTSB MIA87LA159](https://openairdocs.org/ntsb/MIA87LA159.md): Cessna 120 · Oklawaha, FL · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N2106V · Substantial damage > The plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main… - [NTSB LAX87LA206](https://openairdocs.org/ntsb/LAX87LA206.md): Cessna T182 · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · May 16, 1987 · N9545H · Substantial damage > At the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became… - [NTSB ATL87LA141](https://openairdocs.org/ntsb/ATL87LA141.md): Cessna 150 · China Grove, NC · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N704EA · Substantial damage > During a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a… - [NTSB ATL87LA139](https://openairdocs.org/ntsb/ATL87LA139.md): Piper PA-30 · Raleigh, NC · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N7937Y · Substantial damage > The pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the… - [NTSB ANC87FA070](https://openairdocs.org/ntsb/ANC87FA070.md): Cessna 150 · Birchwood, AK · Accident · No injuries · Field investigation · Final report · May 16, 1987 · N66286 · Substantial damage > The pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop. - [NTSB CHI87LA128](https://openairdocs.org/ntsb/CHI87LA128.md): Cessna 152 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · May 15, 1987 · N92140 · Substantial damage > The plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after… - [NTSB SEA87LA094](https://openairdocs.org/ntsb/SEA87LA094.md): Cessna 182B · Orvado, NV · Accident · No injuries · Limited investigation · Final report · May 14, 1987 · N4848D · Substantial damage > During landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted. - [NTSB NYC87LA147](https://openairdocs.org/ntsb/NYC87LA147.md): Cessna 152 · Edgartown, MA · Accident · No injuries · Limited investigation · Final report · May 14, 1987 · N24806 · Substantial damage > The plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was… - [NTSB ANC87LA069](https://openairdocs.org/ntsb/ANC87LA069.md): Fairchild C-119L · Shageluk, AK · Accident · No injuries · Limited investigation · Final report · May 14, 1987 · N8504X · Substantial damage > The airplane was destabilized by a slight vertical air movement on approach. The pilot touched the airplane down short of the runway proper, collapsing the landing gear before sliding off the strip into adjacent tundra. - [NTSB CHI87LA127](https://openairdocs.org/ntsb/CHI87LA127.md): Cessna 152 · Waukesha, WI · Accident · No injuries · Limited investigation · Final report · May 13, 1987 · N5286P · Substantial damage > According to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to… - [NTSB DEN87LA123](https://openairdocs.org/ntsb/DEN87LA123.md): Cessna 150 · Akron, CO · Accident · No injuries · Limited investigation · Final report · May 12, 1987 · N8649G · Substantial damage > The student plt had just purchased N8649G and had decided to fly it. He had not been endorsed for solo flt. After a successful takeoff and a short cross-country flt, he returned to the Akron aprt for landing. During the attempted landing, control of the acft… - [NTSB FTW87LA124](https://openairdocs.org/ntsb/FTW87LA124.md): Cessna T210N · Tahlequah, OK · Accident · No injuries · Limited investigation · Final report · May 11, 1987 · N5342A · Substantial damage > The right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars. - [NTSB ANC87LA068](https://openairdocs.org/ntsb/ANC87LA068.md): Cessna 305 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · May 11, 1987 · N5233G · Substantial damage > The pilot attempted a landing on the beach. After the landing roll the aircraft struck a sand bar causing the aircraft to nose over on its back. - [NTSB SEA87LA095](https://openairdocs.org/ntsb/SEA87LA095.md): Piper PA-20-115 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · May 10, 1987 · N7732K · Substantial damage > During landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L. - [NTSB FTW87LA117](https://openairdocs.org/ntsb/FTW87LA117.md): Cessna 152 · Okmulgee, OK · Accident · No injuries · Limited investigation · Final report · May 10, 1987 · N4922P · Substantial damage > During a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage. - [NTSB SEA87LA161](https://openairdocs.org/ntsb/SEA87LA161.md): Grumman AA1B · Ocean Shores, WA · Accident · No injuries · Limited investigation · Final report · May 9, 1987 · N6296L · Substantial damage > The plt landed his acft onto a golf course which had been the previous site for the airport. The airport had been closed since December 1985 and relocated close by. The pavement at the old airport had been replaced by sod. During landing roll, the aircraft… - [NTSB SEA87IA093](https://openairdocs.org/ntsb/SEA87IA093.md): Stinson 108-1 · Idaho Falls, ID · Incident · No injuries · Incident investigation · Final report · May 9, 1987 · N9016K · Minor damage > During a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut… - [NTSB DEN87LA122](https://openairdocs.org/ntsb/DEN87LA122.md): Beausoleil Acro Sport · Englewood, CO · Accident · No injuries · Limited investigation · Final report · May 9, 1987 · N1717 · Substantial damage > The commercial plt was flying his experimental acro sport 1 in the local area. After about an hour of acrobatic practice, he returned for landing to his home arpt. The plt accepted rwy 28 due to heavy traffic. The winds were reported as 050 degrees at 8… - [NTSB CHI87LA125](https://openairdocs.org/ntsb/CHI87LA125.md): Cessna 120 · Lebanon, IN · Accident · No injuries · Limited investigation · Final report · May 9, 1987 · N2224N · Destroyed > While landing on runway 18, pilot lost directional control and veered off left side of runway into a gully. The pilot stated prior to landing he received winds reported from 220 degrees at 11 knots through ATIS. - [NTSB FTW87LA114](https://openairdocs.org/ntsb/FTW87LA114.md): Ayres S2R-1820 · Ville Platte, LA · Accident · No injuries · Limited investigation · Final report · May 7, 1987 · N4025P · Substantial damage > After landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage. - [NTSB ATL87LA133](https://openairdocs.org/ntsb/ATL87LA133.md): Beech E-55 · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · May 6, 1987 · N713DM · Substantial damage > The plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then… - [NTSB NYC87LA141](https://openairdocs.org/ntsb/NYC87LA141.md): Cessna 172K · Palmyra, PA · Accident · No injuries · Limited investigation · Final report · May 5, 1987 · N78506 · Substantial damage > Student pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the… - [NTSB FTW87FA111](https://openairdocs.org/ntsb/FTW87FA111.md): Bell 206B · Ft. Worth, TX · Accident · No injuries · Field investigation · Final report · May 4, 1987 · N5754A · Substantial damage > While demonstrating a low level 180 degree autorotation to a rated pilot, the CFI undershot his intended touchdown point. In an attempt to reach his selected touchdown point, the pilot allowed the rotor RPM to decay and the aircraft developed a high sink… - [NTSB NYC87LA140](https://openairdocs.org/ntsb/NYC87LA140.md): Piper PA-22-20 · Allaire, NJ · Accident · Minor injuries · Limited investigation · Final report · May 3, 1987 · N3618Z · Substantial damage > During landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged. - [NTSB MIA87LA156](https://openairdocs.org/ntsb/MIA87LA156.md): Douglas DC-6A · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · May 3, 1987 · N43867 · Substantial damage > The plt stated that they had made a normal landing and on rollout experienced severe vibration from a nose wheel shimmy. The vibration resulted in substantial damage to the horizontal stabilizer spar attach points. - [NTSB LAX87LA201](https://openairdocs.org/ntsb/LAX87LA201.md): Piper PA-38-112 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N25111 · Substantial damage > During and instructional flight on short and soft field landings, the pilot reported that during the landing roll an unobserved dust devil hit the aircraft. The aircraft was raised approximately 60 ft AGL. The instructor was unable to regain control and the… - [NTSB DEN87LA129](https://openairdocs.org/ntsb/DEN87LA129.md): Boeing A75N1 · Mandan, ND · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N75546 · Substantial damage > The pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was… - [NTSB CHI87LA121](https://openairdocs.org/ntsb/CHI87LA121.md): Beech 58P · Evansville, IN · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N6401H · Substantial damage > During landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and… - [NTSB FTW87LA112](https://openairdocs.org/ntsb/FTW87LA112.md): Boeing E75N1 · Arcola, TX · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N1346M · Substantial damage > During landing roll the aircraft swerved to the right. The pilot applied the left brake and the aircraft nosed over inverted causing substantial damage. The pilot stated that the left brake locked. The reason for the brake seizure is undetermined. - [NTSB CHI87DEP05](https://openairdocs.org/ntsb/CHI87DEP05.md): Johnson Quickie 2 · Eau Claire, WI · Accident · Serious injuries · Final report · Apr 30, 1987 · N3262P · Substantial damage > The pilot was attempting to land the experimental aircraft when he lost control and impacted on the rwy. This was the first time the pilot had flown this aircraft. The pilot stated the aircraft 'refused to flare properly.' - [NTSB ATL87DKG03](https://openairdocs.org/ntsb/ATL87DKG03.md): Cessna 310D · Athens, GA · Accident · No injuries · Final report · Apr 30, 1987 · N6752T · Substantial damage > The acft was reportedly stalled about 30 ft above the rwy and a hard ldg was made. The multi-eng rated plt was practicing short-field ldgs under the instruction of a CFI in preparation for obtaining commercial certificate. The acft wings and fuselage… - [NTSB SEA87LA087](https://openairdocs.org/ntsb/SEA87LA087.md): Cessna 310L · Chiloquin, OR · Accident · No injuries · Limited investigation · Final report · Apr 29, 1987 · N808AA · Substantial damage > The aircraft departed the end of the runway during landing roll. The aircraft then went down an embankment and through a fence. The right main gear collapsed with the aircraft turning 90 degrees before coming to rest. A tailwind was present during landing.… - [NTSB NYC87LA134](https://openairdocs.org/ntsb/NYC87LA134.md): Robinson R-22 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · Apr 29, 1987 · N9070F · Substantial damage > During an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the… - [NTSB DEN87LA115](https://openairdocs.org/ntsb/DEN87LA115.md): Beech A23-24 · Roosevelt, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1987 · N4745J · Substantial damage > During landing, as the acft neared the taxiway leading to the parking ramp, the plt applied brakes and the acft veered to the off the rwy. The plt then applied pwr in an attempt to takeoff. The acft paralleled the rwy for a short distance and after crossing a… - [NTSB ATL87LA129](https://openairdocs.org/ntsb/ATL87LA129.md): Beech 95-B55 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Apr 29, 1987 · N3240Y · Substantial damage > The aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He… - [NTSB MIA87LA149](https://openairdocs.org/ntsb/MIA87LA149.md): Aeronca 11AC · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N3167E · Substantial damage > Pilot made a hard landing at which time the left main gear collapsed. The aircraft then ground looped and ran off the runway. Post crash examination of the left main gear revealed it collapsed when a support brace rusted through from the inside of the tube.… - [NTSB FTW87LA110](https://openairdocs.org/ntsb/FTW87LA110.md): Law OSPREY-2 · Minden, LA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N55889 · Substantial damage > Pilot stated that he flared about ten feet too high and landed hard collapsing the main gear followed by the aircraft sliding off the runway and colliding with a ditch where substantial damage occurred. - [NTSB ATL87LA128](https://openairdocs.org/ntsb/ATL87LA128.md): Maule MX-7-180 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N5670C · Substantial damage > The pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full… - [NTSB ANC87LA063](https://openairdocs.org/ntsb/ANC87LA063.md): Cessna 185 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N2223T · Substantial damage > The pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to nose over on its back. - [NTSB SEA87LA088](https://openairdocs.org/ntsb/SEA87LA088.md): Piper PA-28-180 · Blakely Island, WA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N5185L · Substantial damage > The plt landed with excess airspeed past the first third of the downhill runway. The aircraft bounced and the pilot added a little power. The aircraft then struck the runway with the nose gear. Since the plt feared going off the end of the runway into the… - [NTSB SEA87LA086](https://openairdocs.org/ntsb/SEA87LA086.md): Cessna 152 · Renton, WA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N6312P · Substantial damage > During touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear. - [NTSB MKC87LA097](https://openairdocs.org/ntsb/MKC87LA097.md): Piper PA-38-112 · Marshfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N2595B · Substantial damage > The PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy… - [NTSB FTW87LA104](https://openairdocs.org/ntsb/FTW87LA104.md): Cessna 182 · Midland, TX · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N34S · Substantial damage > During a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position. - [NTSB ATL87LA131](https://openairdocs.org/ntsb/ATL87LA131.md): Beech 95-B55 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N5824S · Substantial damage > The plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt… - [NTSB ATL87LA127](https://openairdocs.org/ntsb/ATL87LA127.md): Cessna 172N · Union Grove, NC · Accident · No injuries · Limited investigation · Final report · Apr 27, 1987 · N4678G · Substantial damage > The plt reported that he was attempting to make a soft-field ldg in a plowed field at a friend's farm. He had not landed there previously. After initial touchdown was made on the main ldg gear, the nosewheel dug into a rise in the terrain and the airplane… - [NTSB MIA87LA148](https://openairdocs.org/ntsb/MIA87LA148.md): Cessna 172 · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N217JA · Substantial damage > While landing, the acft floated down the rwy as the result of excessive airspeed during the apch. The plt continued to flare the acft, & as the airspeed bled off, the wings stalled, resulting in a hard landing. The acft then began to propoise, & on the third… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=401 ## 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=400 --- 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.