# 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 394 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB NYC88LA001](https://openairdocs.org/ntsb/NYC88LA001.md): Beech B23 · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1987 · N4007T · Substantial damage > According to the plt, the winds were from the south-southwest at 15 to 20 KTS. He rprtd that drg the landing roll on rwy 22, he applied full right rudder against the prevailing wind, but the acft veered left with the application of brakes. Subsequently, it… - [NTSB FTW88LA001](https://openairdocs.org/ntsb/FTW88LA001.md): Mooney M20C · Bulverde, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1987 · N9231M · Substantial damage > On the second approach after a go-around, the aircraft landed approximately halfway down the 2850 ft runway. In an attempt to go around the pilot applied power. The aircraft started to climb but collided with the top of a tree causing the tail of the aircraft… - [NTSB DEN87LA248](https://openairdocs.org/ntsb/DEN87LA248.md): Cessna 182F · Colorado City, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1987 · N3155U · Destroyed > The plt made several circling approaches before landing. When he did land his acft, he said that he landed fast and long. He applied the brakes but went off the end of the rwy, hit an embankment, and nosed over. - [NTSB SEA87LA197](https://openairdocs.org/ntsb/SEA87LA197.md): Beech A100 · Gold Beach, OR · Accident · No injuries · Limited investigation · Final report · Sep 30, 1987 · N32RL · Destroyed > Shortly after the aircraft touched down on the runway, the right main gear collapsed. Despite the pilot's attempts to correct the situation with left rudder and braking, the aircraft veered to the right of the runway and collided with a building. Shortly… - [NTSB DEN87LA249](https://openairdocs.org/ntsb/DEN87LA249.md): Cessna 172P · Rangley, CO · Accident · No injuries · Limited investigation · Final report · Sep 30, 1987 · N62938 · Substantial damage > The student pilot was on his second supervised solo flight and was attempting a second landing on runway 24. The plt stated that the approach was normal and that the acft bounced on touchdown. The plt attempted to correct and the acft banked left. Power was… - [NTSB MKC87LA184](https://openairdocs.org/ntsb/MKC87LA184.md): Piper PA-28-180 · Ozark, MO · Accident · No injuries · Limited investigation · Final report · Sep 29, 1987 · N7275W · Substantial damage > During a ldg, the acft touched down long, ran off the end of the airstrip and struck a fence and then a ditch. The rwy was 2100 feet long, downsloping, and the grass surface was wet. - [NTSB CHI87LA225](https://openairdocs.org/ntsb/CHI87LA225.md): Boeing A75N1 · Rochester, IN · Accident · No injuries · Limited investigation · Final report · Sep 28, 1987 · N61V · Substantial damage > The tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over. - [NTSB LAX87LA348](https://openairdocs.org/ntsb/LAX87LA348.md): Cessna 175 · Camp Verde, AZ · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N7495M · Substantial damage > When both passengers became air sick the pilot decided to land on a dirt road. Upon touchdown, the pilot heard a loud pop and assumed that a tire had blown. Because of this, he used the brakes sparingly and could not stop the aircraft in time to avoid trees.… - [NTSB LAX87DVD05](https://openairdocs.org/ntsb/LAX87DVD05.md): Rotorway Scorpion 133 · Boonville, CA · Accident · No injuries · Final report · Sep 27, 1987 · N25059 · Destroyed > The plt said that when he was practicing quick stops & flares, the tail rotor struck the ground. The helicopter then yawed, touched down (right skid 1st) & rolled over. No preimpact mechanical failure or malfunction was rprtd. - [NTSB CHI87LA226](https://openairdocs.org/ntsb/CHI87LA226.md): Cessna 172 · Frankfort, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N5196K · Substantial damage > The student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.… - [NTSB CHI87LA223](https://openairdocs.org/ntsb/CHI87LA223.md): Piper PA-38-112 · Joliet, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N6320A · Substantial damage > The aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left… - [NTSB BFO87LA069](https://openairdocs.org/ntsb/BFO87LA069.md): Mooney M20E · Pocomoke City, MD · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N2613W · Substantial damage > While on final apch, the plt realized his touchdown point was farther down the rwy than usual, but he believed there was sufficient rwy & elected to cont the lndg. After touchdown, he applied brakes, but was unable to stop on the remaining rwy. Subsequently,… - [NTSB BFO87LA067](https://openairdocs.org/ntsb/BFO87LA067.md): Stinson SR8B · Lynchburg, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N16182 · Substantial damage > The pilot diverted to falwell airport due to deteriorating weather and uneven fuel consumption indication between the left and right fuel tanks. During the landing approach for runway 28 the pilot noted the upslope of the runway surface. The pilot misjudged… - [NTSB ATL87LA264](https://openairdocs.org/ntsb/ATL87LA264.md): Piper PA-38-112 · Winston Salem, NC · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N2488C · Substantial damage > The student pilot was performing touch and go landings as part of his supervised solo training. The aircraft landed hard and bounced twice before coming to rest with a collapsed nose gear. Examination of the airframe disclosed extensive crushing damage to the… - [NTSB MKC87LA180](https://openairdocs.org/ntsb/MKC87LA180.md): Piper PA-24-250 · Osage Beach, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1987 · N5279P · Substantial damage > While performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI… - [NTSB MKC87LA178](https://openairdocs.org/ntsb/MKC87LA178.md): Aero Commander 500B · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N192CA · Substantial damage > The pilot was on approach to Kansas City international when he was requested to slow down and follow another aircraft. He used his checklist and decided to leave the gear up until he was closer to the airport. On short final he extended the flaps but failed… - [NTSB MIA87LA263](https://openairdocs.org/ntsb/MIA87LA263.md): Cessna 411 · No.Atlantic Oc (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N39BJ · Substantial damage > The acft was ditched 35 miles southeast of cat island on a flt from georgetown to freeport, Bahamas for unknown reason(s). The acft has not been recovered. Attempts to contact the pilot & registered owner were to no avail. - [NTSB LAX87LA346](https://openairdocs.org/ntsb/LAX87LA346.md): Boeing A75N1 · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N68853 · Substantial damage > The pilot stated that the aircraft groundlooped during landing roll just as the tailwheel touched down. There were no reported mechanical problems and winds were light and variable. However, the pilot stated that he thought he felt a gustof wind. - [NTSB CHI87LA224](https://openairdocs.org/ntsb/CHI87LA224.md): Cessna 172L · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N3599F · Substantial damage > Aircraft landed hard, nose wheel first, and collapsed the nose landing gear tire. PIC was concerned about a sharp knocking noise in the rear of the aircraft that he heard after liftoff. The reason for the noise was not determined. He acknowledged that he… - [NTSB ANC87LA168](https://openairdocs.org/ntsb/ANC87LA168.md): Champion Aeronca TL · White Mountain, AK · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N3446 · Substantial damage > The pilot stated upon touchdown the airplane bounced and groundlooped. The acft had been landed on a gravel bar and the landing area was loose gravel and rocks. No malfunctions of the acft were reported. The plt stated that he thought that the bounced landing… - [NTSB NYC87LA269](https://openairdocs.org/ntsb/NYC87LA269.md): Ryan ST-3RR · Hamburg, NY · Accident · No injuries · Limited investigation · Final report · Sep 25, 1987 · N400AW · Substantial damage > According to the plt, when he arrived at the arpt, the winds were from 280 deg at 20 gusting 25 KTS. He believed that with the strong x-wind & gusts, it would be safer to land on sod beside the rwy. During the landing, the main gear sank into the sod & the… - [NTSB ATL87FA262](https://openairdocs.org/ntsb/ATL87FA262.md): Piper PA-31-350 · Demopolis, AL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1987 · N117EV · Destroyed > The plt of an aircraft carrying an estimated 317 kilos of cocaine was attempting to land at an apt which did not have a published instrument approach procedure in IMC. Witnesses estimated that the visibility was no more than 1/2 mile in fog about 45 min after… - [NTSB MIA87LA258](https://openairdocs.org/ntsb/MIA87LA258.md): Aero Commander 560-F · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1987 · N61BT · Substantial damage > The plt stated that he had just completed his third touch & go ldg when the gear collapsed while the acft was on the rwy. A plt/mechanic who assisted in removing the acft from the rwy stated that just after the accident, he peered into the cockpit & observed… - [NTSB BFO87DID04](https://openairdocs.org/ntsb/BFO87DID04.md): Bennetter-Stevens Starduster · Roanoke, VA · Accident · No injuries · Final report · Sep 23, 1987 · N36GP · Substantial damage > The plt went on an orientation flt in the home built starduster. Drg the lndg, the acft touched down at about 40 mph. The plt stated that as it slowed to about 25 mph, the 'right brake or something locked, plane pulled hard right, then up on nose & over on… - [NTSB ATL87LA265](https://openairdocs.org/ntsb/ATL87LA265.md): Cessna 172 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · Sep 23, 1987 · N733JZ · Substantial damage > During a practice landing the aircraft bounced three times which resulted in the failure of the nose gear structural support. The pilot said that he experienced gusty wind conditions prior to touchdown. The pilot did not properly compensate for or anticipate… - [NTSB LAX87LA349](https://openairdocs.org/ntsb/LAX87LA349.md): Cessna 172P · Santa Monica, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1987 · N5366K · Substantial damage > The student pilot, on his first supervised solo flight, executed two full stop landings without incident. On the next landing, the student pilot stated that the aircraft apparently caught a gust of wind and ballooned. He indicated that he over-corrected and… - [NTSB DEN87DTI02](https://openairdocs.org/ntsb/DEN87DTI02.md): Bakeng Deuce · Gillette, WY · Accident · No injuries · Final report · Sep 21, 1987 · N9659A · Substantial damage > The plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &… - [NTSB MKC87LA174](https://openairdocs.org/ntsb/MKC87LA174.md): Cessna 120 · Creighton, NE · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N2061V · Substantial damage > The flt dptd harvard, NE., with a dest of wausa, NE abt 1 hrs flying dist to the northeast. The departure commenced abt 1 hr and 40 min's prior to dark. The PIC stated he encountered strong headwinds along the route which delayed his progress. The acft… - [NTSB LAX87LA345](https://openairdocs.org/ntsb/LAX87LA345.md): Cessna 180K · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N2573K · Substantial damage > A Cessna 180K dragged its' wing tip during landing roll on runway 28R. The pilot indicated that he encountered a wind gust from the left raising the right wing. The pilot stated that he 'over corrected' in that when the gust subsided the aircraft rolled left… - [NTSB LAX87LA344](https://openairdocs.org/ntsb/LAX87LA344.md): Cessna 150 · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N91AV · Substantial damage > The student pilot lost control of the airplane during landing roll on rwy 30. He indicated that the winds were from 280 deg at 9 KTS gusting to 12 KTS. The airplane veered right departing the rwy. The nose gear subsequently collapsed in rough and uneven… - [NTSB LAX87LA343](https://openairdocs.org/ntsb/LAX87LA343.md): Piper PA-28-180 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N7896W · Substantial damage > A Piper PA-28-180 collided with a tree after veering off runway 15. The pilot indicated that he encountered a right crosswind during the landing roll and veered off the left side of the runway. The aircraft's left wing then struck a tree severing it from the… - [NTSB CHI87LA220](https://openairdocs.org/ntsb/CHI87LA220.md): Cessna 172RG · Pinckneyville, IL · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N9543B · Substantial damage > According to the instructor (CFI), he & the student confirmed the gear was extended & locked as they entered the traffic pattern. Flaps were extended & they contd in the pattern to practice a short field landing technique. Power was reduced after crossing… - [NTSB CHI87LA218](https://openairdocs.org/ntsb/CHI87LA218.md): Piper PA-28RT-201T · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N8315S · Substantial damage > The aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The… - [NTSB CHI87LA214](https://openairdocs.org/ntsb/CHI87LA214.md): Beech E55 · Green Bay, WI · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N146M · Substantial damage > The plt intended to land long on rwy 36L since he parked the acft near the north end of the field. He stated that he flew over the rwy at an alt of aprx 30 ft until near the intx with rwy 6/24, then he retarded the throttles & adjusted the trim for landing.… - [NTSB NYC87LA259](https://openairdocs.org/ntsb/NYC87LA259.md): Beech 23 · Montpelier, VT · Accident · No injuries · Limited investigation · Final report · Sep 18, 1987 · N2216L · Substantial damage > During a landing, the aircraft bounced and the student pilot attempted to correct the situation. However, the aircraft touched down and bounced again, then became uncontrollable. Subsequently, it veered off the left side of the runway and hit a parked Cessna… - [NTSB LAX87LA339](https://openairdocs.org/ntsb/LAX87LA339.md): Hughes 269C · Freemont, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1987 · N1101K · Substantial damage > The purpose of the flt was to provide instruction to a foreign national, who held a U.S. Private helicopter rating. The instructor (CFI) rprtd that during a practice autorotation, he announced twice for the student to flare as the helicopter was passing thru… - [NTSB MIA87IA246](https://openairdocs.org/ntsb/MIA87IA246.md): Piper PA-60 · W.Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Sep 16, 1987 · N9784Q · Minor damage > The plt stated that on landing after rolling about 1000 ft. the scissors on the right main landing gear strut disconnected causing the wheel assembly to rotate & skid. He then applied heavy left brake to keep the acft straight on the runway, but the main gear… - [NTSB MIA87FA248](https://openairdocs.org/ntsb/MIA87FA248.md): Boeing 727 · Tulsa, OK · Accident · No injuries · Field investigation · Final report · Sep 16, 1987 · N8857E · Substantial damage > The crew of the Boeing 727 aircraft on a domestic passenger flight initiated an approach to a runway with a known crosswind and tailwind component. On final approach the tower controllers re-stated the wind and issued a windshear warning. On short final at… - [NTSB LAX87LA342](https://openairdocs.org/ntsb/LAX87LA342.md): Cessna 152 · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1987 · N5107B · Substantial damage > While landing at the destination, the airplane bounced, then after it touched down the second time, the nose gear failed. During the landing roll-out, the airplane settled on its nose cowling. No previous airframe problem was evident. - [NTSB ANC87LA156](https://openairdocs.org/ntsb/ANC87LA156.md): Piper PA-12 · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1987 · N3666N · Substantial damage > The pilot stated that he was landing at an unimproved, off airport site when the main gear hit a hole during the landing roll and the aircraft nosed over. - [NTSB LAX87DUG09](https://openairdocs.org/ntsb/LAX87DUG09.md): Geiger Dragonfly · Chino, CA · Accident · No injuries · Final report · Sep 15, 1987 · N157JG · Substantial damage > At the end of a performance test flight, the plt stated that the acft was rotated to a landing attitude at a higher then normal altitude above the ground. The acft contacted the rwy and bounced three times, resulting in substantial damage. - [NTSB FTW87LA218](https://openairdocs.org/ntsb/FTW87LA218.md): Beech 58 · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1987 · N4274A · Substantial damage > The pilot failed to ensure that the landing gear was down and locked. The aircraft landed gear up and received substantial damage. The gear was lowered normally after the aircraft was lifted from the runway. - [NTSB NYC87LA248](https://openairdocs.org/ntsb/NYC87LA248.md): Cessna 150J · Brookline, NH · Accident · No injuries · Limited investigation · Final report · Sep 14, 1987 · N51085 · Destroyed > During an approach to land at night, the pilot saw deer on the runway that were facing his direction and moving to the right. He didn't see the deer until he had reached a point were a go-around would be unsafe for this runway. In an effort to avoid the deer,… - [NTSB DEN87LA240](https://openairdocs.org/ntsb/DEN87LA240.md): Cessna 177B · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Sep 14, 1987 · N34157 · Substantial damage > During the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop… - [NTSB FTW87LA216](https://openairdocs.org/ntsb/FTW87LA216.md): Cessna 172 · Edmond, OK · Accident · No injuries · Limited investigation · Final report · Sep 13, 1987 · N179FR · Substantial damage > The pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined. - [NTSB DEN87LA238](https://openairdocs.org/ntsb/DEN87LA238.md): Maule M-5-210TC · Moab, UT · Accident · No injuries · Limited investigation · Final report · Sep 13, 1987 · N5637D · Substantial damage > The pilot aborted his approach to runway 21 at canyon lands airport when he had 'indications of a crosswind.' The pilot radioed Moab UNICOM and reported he could not find the windsock and requested wind information. Moab UNICOM reported thewind was 'straight… - [NTSB ANC87LA155](https://openairdocs.org/ntsb/ANC87LA155.md): Cessna 182 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 1987 · N2192R · Substantial damage > The pilot stated that after touchdown on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. He also indicated that the strip was soft and the nose wheel dug in after touchdown. - [NTSB MIA87LA245](https://openairdocs.org/ntsb/MIA87LA245.md): Cessna 150M · Morriston, FL · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N714BN · Substantial damage > Drg a lndg on the student plt's 3rd solo flt, the acft ballooned after it touched down. The student stated that she failed to add power & the stall warning horn sounded. The acft then touched down hard & the nose gear failed. - [NTSB ATL87LA256](https://openairdocs.org/ntsb/ATL87LA256.md): Hughes 269A · Morristown, TN · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N8709F · Substantial damage > One CFI was demonstrating his procedures for autorotations with power recovery to his employer who was also a CFI. This was to insure standardization within the helicopter pilot school. The autorotation was entered from about 700 feet AGL to the departure… - [NTSB CHI87LA208](https://openairdocs.org/ntsb/CHI87LA208.md): Cessna 172PC · Jerseyville, IL · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N5343K · Substantial damage > The pilot and one passenger were returning from a local flight. It had become dark during their flight and as the pilot was approaching to land on runway 36 the landing gear of the aircraft struck a drainage ditch approximately 2-3 feet short of the runway.… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=395 ## 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=394 --- 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.