# 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 407 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB CHI87LA008](https://openairdocs.org/ntsb/CHI87LA008.md): Cessna 177 · Waukesha, WI · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N3436T · Substantial damage > According to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land… - [NTSB CHI87LA006](https://openairdocs.org/ntsb/CHI87LA006.md): Cessna 120 · Decatur, IL · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N2896N · Substantial damage > The pilot stated that he was practicing crosswind landings on runway 24 when the airplane bounced twice. According to the pilot, he immediately added power and then lost directional control of the airplane and ground looped to the left. Following the ground… - [NTSB NYC87LA044](https://openairdocs.org/ntsb/NYC87LA044.md): Centrair 101A · Julian, PA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1986 · N40KG · Substantial damage > The pilot had decided to land following a 41 minute flt. The plt reported his airspeed was too fast during the landing apch and he over compensated which resulted in too slow of an airspeed. The glider touched down hard, became airborne and landed hard a… - [NTSB ANC87LA007](https://openairdocs.org/ntsb/ANC87LA007.md): Interstate S-1B1 · Eureka Creek, AK · Accident · 1 fatal · Limited investigation · Final report · Oct 21, 1986 · N46243 · Substantial damage > The pilot lost control of the aircraft on landing & it collided with a large metal sluice box that was located beside the runway. At the time of the accident, the wind was from the northeast & was gusty. The dirt ruway was frozen, rough &rutted. - [NTSB ANC87LA006](https://openairdocs.org/ntsb/ANC87LA006.md): Short Brothers SC7 · Nightmute, AK · Accident · No injuries · Limited investigation · Final report · Oct 21, 1986 · N406TH · Substantial damage > According to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to… - [NTSB LAX87LA022](https://openairdocs.org/ntsb/LAX87LA022.md): Piper PA-22-160 · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1986 · N9206D · Substantial damage > The acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of… - [NTSB CHI87DEM02](https://openairdocs.org/ntsb/CHI87DEM02.md): Leblanc Dragonfly · Lansing, MI · Accident · No injuries · Final report · Oct 20, 1986 · N4463L · Substantial damage > The home built acft was on a test flt & was being flown by a plt with only about 2.5 hrs of flt time in this make & model. During the landing, the acft touched down hard & began to porpoise. The canard & wooden prop were damaged during the occurrence. - [NTSB MKC87LA009](https://openairdocs.org/ntsb/MKC87LA009.md): Cessna 501 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Oct 19, 1986 · N2BT · Substantial damage > The PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further… - [NTSB FTW87LA006](https://openairdocs.org/ntsb/FTW87LA006.md): Cessna 177 · Jacksboro, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1986 · N29589 · Substantial damage > The pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts. - [NTSB ANC87LA005](https://openairdocs.org/ntsb/ANC87LA005.md): Taylorcraft BC-12D · Chickaloon Flat, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1986 · N39146 · Substantial damage > The pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired. - [NTSB MKC87LA008](https://openairdocs.org/ntsb/MKC87LA008.md): Luscombe 8E · Macon, MO · Accident · No injuries · Limited investigation · Final report · Oct 18, 1986 · N1690K · Substantial damage > The pilot stated that he encountered more severe crosswinds than planned upon landing and that he tried remedial action, including a rejected landing, but it came too late. The wind was blowing from the right on the landing roll as he shut down the engine and… - [NTSB MIA87IA011](https://openairdocs.org/ntsb/MIA87IA011.md): Cessna 310R · West Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Oct 18, 1986 · N2638N · Minor damage > While on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right… - [NTSB LAX87LA019](https://openairdocs.org/ntsb/LAX87LA019.md): Lake LA4-180 · Folsom, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1986 · N1118L · Substantial damage > During a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses… - [NTSB MKC87LA006](https://openairdocs.org/ntsb/MKC87LA006.md): Cessna 421C · Hot Springs, AR · Accident · No injuries · Limited investigation · Final report · Oct 17, 1986 · N49D · Substantial damage > The pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,… - [NTSB ATL87LA008](https://openairdocs.org/ntsb/ATL87LA008.md): Beech C23 · Middlefield, OH · Accident · No injuries · Limited investigation · Final report · Oct 17, 1986 · N5162M · Substantial damage > Student plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS… - [NTSB MIA87FA009](https://openairdocs.org/ntsb/MIA87FA009.md): Cessna 152 · Hattiesburg, MS · Accident · Serious injuries · Field investigation · Final report · Oct 16, 1986 · N24485 · Substantial damage > The student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he… - [NTSB NYC87LA019](https://openairdocs.org/ntsb/NYC87LA019.md): Piper PA-38 · Leroy, NY · Accident · No injuries · Limited investigation · Final report · Oct 15, 1986 · N60CS · Substantial damage > Flight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes. - [NTSB NYC87IA014](https://openairdocs.org/ntsb/NYC87IA014.md): Boeing 727-200 · Portland, ME · Incident · No injuries · Incident investigation · Final report · Oct 15, 1986 · N517PE · Minor damage > The cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which… - [NTSB MIA87LA008](https://openairdocs.org/ntsb/MIA87LA008.md): Cessna 210 · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Oct 15, 1986 · N7395E · Substantial damage > The plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in… - [NTSB MIA87LA007](https://openairdocs.org/ntsb/MIA87LA007.md): Waco YMF · Key West, FL · Accident · No injuries · Limited investigation · Final report · Oct 15, 1986 · N99Y · Substantial damage > The acft nosed over during landing roll. The professional plt stated that he was certain the brakes were off prior to takeoff and that he was sure he was not 'riding' the braked on landing. The plt stated that he thought the parking brake may have come on… - [NTSB DEN87LA005](https://openairdocs.org/ntsb/DEN87LA005.md): Piper PA-22-160 · Fort Morgan, CO · Accident · No injuries · Limited investigation · Final report · Oct 15, 1986 · N9748D · Substantial damage > The student plt had just been endorsed for his first supervised solo flt. He had successfully completed one landing and was attempting his second landing when the accident occurred. The plt said he lost directional control, touched down, and over corrected.… - [NTSB ANC87IA003](https://openairdocs.org/ntsb/ANC87IA003.md): Boeing 727-22C · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Oct 15, 1986 · N753AS · Minor damage > After departure, the flight crew retracted the landing gear and noticed a nose gear disagreement light. Upon arriving at Anchorage, the flight crew could not lower the nose gear through normal or manual means. The airplane landed with main gear extended and… - [NTSB NYC87LA018](https://openairdocs.org/ntsb/NYC87LA018.md): Beech E-90 · Beverly, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1986 · N195B · Substantial damage > The Beech king air E-90 was observed to break out of the clouds in a steep descent, land long and run off the departure end of the 4637 ft runway. The aircraft received substantial damage and the crew of 2 and 6 passengers received minor injuries. The… - [NTSB NYC87LA042](https://openairdocs.org/ntsb/NYC87LA042.md): Raven S60A · Montville, CT · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1986 · N2799Z · Substantial damage > While landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage. - [NTSB SEA87LA010](https://openairdocs.org/ntsb/SEA87LA010.md): Britten-Norman BN-2A-20 · Lower Loon, ID · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N25SA · Substantial damage > The plt diverted from his original destination due to weather. Upon landing at the alternate airport wiht a 7 knot tail wind, while using heavy braking on wet sod, the brakes locked. The acft veered to the right of the center placing the right main gear on… - [NTSB SEA87LA007](https://openairdocs.org/ntsb/SEA87LA007.md): Hughes 500-D · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N58239 · Substantial damage > During a practice autorotation a loss of power occurred. The pilot attempted engine recovery but was unable to resulting in a hard landing in which the main rotor blade flexed, severing the tail boom. The throttle linkage on the pilots side was found to have… - [NTSB NYC87LA016](https://openairdocs.org/ntsb/NYC87LA016.md): Piper PA-32 · Poughkeepsie, NY · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N42943 · Substantial damage > The Piper PA-32, landing with a 5 knot quartering tailwind from the right, ran off the left side of the runway and struck the windsock receiving substantial damage. The pilot and 2 passengers were not injured. The pilot reported that upon touchdown he felt… - [NTSB DEN87LA006](https://openairdocs.org/ntsb/DEN87LA006.md): Cessna 152 · Price, UT · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1986 · N93703 · Substantial damage > The student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft… - [NTSB CHI87DEE02](https://openairdocs.org/ntsb/CHI87DEE02.md): Piper PA-23-250 · Crestwood, IL · Accident · No injuries · Final report · Oct 9, 1986 · N6955Y · Substantial damage > The aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft. - [NTSB ATL87LA002](https://openairdocs.org/ntsb/ATL87LA002.md): Cessna 172P · East Liverpool, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1986 · N54067 · Substantial damage > Rwy repair was in progress. The rwy was closed & battery powered lights were left to mark a 5 inch deep ditch that crossed the runway. Arpt & rwy lights were left off. The FBO continued to rent acft for operations from the arpt. The plt departed on a 28 mi… - [NTSB SEA87LA006](https://openairdocs.org/ntsb/SEA87LA006.md): Piper PA-18-150 · Petersburg, AK · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N6191D · Substantial damage > The plt reported that while landing on a river the acft skidded on river silt. He stated he could not stop the acft which traveled to the FAR end of the river into 8 inch deep water where it nosed over. - [NTSB BFO87FA003](https://openairdocs.org/ntsb/BFO87FA003.md): Bellanca 8GCBC · Keysville, VA · Accident · Minor injuries · Field investigation · Final report · Oct 8, 1986 · N7100C · Substantial damage > The pilot made a tailwheel high touchdown on the 1850 foot grass strip. Shortly after touchdown, the nose dropped and, although the pilot said he moved the control stick fully aft, the propeller struck the ground, and the aircraft flipped inverted. - [NTSB ANC87LA002](https://openairdocs.org/ntsb/ANC87LA002.md): Teal TSC-1A2 · Lewis River, AK · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N87857 · Substantial damage > The plt stated that he landed the amphibious acft on the Lewis River with the gear in the extended position. Shortly after touchdown, the acft nosed over on its top. FAA records showed the plt had a total flying time of aprx 710 hrs. - [NTSB NYC87LA013](https://openairdocs.org/ntsb/NYC87LA013.md): Cessna 150 · So. Dayton, NY · Accident · No injuries · Limited investigation · Final report · Oct 7, 1986 · N50832 · Substantial damage > The student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged. - [NTSB MIA87FA004](https://openairdocs.org/ntsb/MIA87FA004.md): Smith, Ted Aerostar Aerostar 600 · Jacksonville, FL · Accident · No injuries · Field investigation · Final report · Oct 7, 1986 · N338NA · Substantial damage > Reportedly, during an ILS approach to land, the pilot did not use the company approved checklist and landed with the gear retracted. - [NTSB LAX87LA011](https://openairdocs.org/ntsb/LAX87LA011.md): Bellanca 7KCAB · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Oct 6, 1986 · N8727V · Substantial damage > A Bellanca 7KCAB lost control and veered off rwy 16. The CFI indicated that the aircraft veered right during landing roll. The student pilot applied left pedal and the aircraft swung left and ground looped. The aircraft dropped off the rwy shoulder, breaking… - [NTSB MKC87LA004](https://openairdocs.org/ntsb/MKC87LA004.md): Piper PA-24-250 · Seward, NE · Accident · No injuries · Limited investigation · Final report · Oct 5, 1986 · N5980P · Substantial damage > The plt reports that he was landing on his private grass strip which is 1600 x 60 ft. he said the grass on the edges was thicker then that in the middle. During landing roll the acft drifted to the lt and the lt wing collided with milo growing along the lt… - [NTSB ANC87LA001](https://openairdocs.org/ntsb/ANC87LA001.md): Piper PA-22 · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Oct 5, 1986 · N7427D · Substantial damage > After touchdown on the grass next to the runway, the pilot lost directional control of the aircraft and struck a snowbank. - [NTSB SEA87LA008](https://openairdocs.org/ntsb/SEA87LA008.md): Cessna 172N · Madras, OR · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N4693J · Substantial damage > On landing touchdown, aircraft nose tire blew out. The student pilot over-corrected with controls and power, causing the aircraft to balloon into the air and touch down a second time in a flat attitude, resulting in a hard landing. - [NTSB NYC87LA003](https://openairdocs.org/ntsb/NYC87LA003.md): Cessna 150 · Buxton, ME · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N94457 · Substantial damage > The pilot was making a short field landing at a private airstrip which was grass covered and wet. The pilot came in too high and long and once on the ground, skidded to a stop between two trees. - [NTSB LAX87LA001](https://openairdocs.org/ntsb/LAX87LA001.md): Bellanca 7ECA · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N4178Y · Substantial damage > The acft went out of control and ran off the rwy. The student plt indicated that on his first apch his altitude was too high and he was aligned to the left of the rwy. He initiated a go-around and made a second attempt. During the flare on his second apch the… - [NTSB FTW87LA001](https://openairdocs.org/ntsb/FTW87LA001.md): Piper PA-30 · Sulpher, LA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N7533Y · Substantial damage > The pilot landed long at a private grass airstrip and deliberately ground looped the aircraft to avoid overrunning the airstrip into a three foot ditch. The nose gear collapsed during the ground loop and the wings and main gears were damaged when the aircraft… - [NTSB BFO87LA001](https://openairdocs.org/ntsb/BFO87LA001.md): Piper PA-22-150 · Hillsville, VA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1986 · N6003D · Substantial damage > After touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of… - [NTSB NYC87LA001](https://openairdocs.org/ntsb/NYC87LA001.md): Piper PA-28RT-201 · Caldwell, NJ · Accident · No injuries · Limited investigation · Final report · Oct 1, 1986 · N8320A · Substantial damage > The pilot in command allowed the aircraft to become too low during a night simulated emergency (engine out) during an instructional flight. The aircraft contacted the tops of trees, became uncontrollable and crashed to the ground. - [NTSB LAX86LA359](https://openairdocs.org/ntsb/LAX86LA359.md): Cameron 0-77 · Tiburon, CA · Accident · No injuries · Limited investigation · Final report · Sep 30, 1986 · N2948G · Destroyed > After completing an aerial advertising flight across the san francisco bay, the plt attempted a landing on up-sloping terrain. The terrain was steeper than anticipated & the plt became distracted. The plt forgot to turn off the pilot light to the left burner.… - [NTSB DEN86LA262](https://openairdocs.org/ntsb/DEN86LA262.md): Beech 60 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Sep 30, 1986 · N3694D · Substantial damage > At touchdown, the plt applied brakes normally. He noticed softening of the left brake pedal and the acft turned right leaving the rwy and intersecting a taxiway at aprx a 30 degree angle. The taxiway had a six inch rise at the edge which caused the left main… - [NTSB MKC86FA197](https://openairdocs.org/ntsb/MKC86FA197.md): Rockwell NA-265-80 · Liberal, KS · Accident · No injuries · Field investigation · Final report · Sep 29, 1986 · N64 · Substantial damage > The right main landing gear downlock pin retracted just before or during touchdown. The airplane touched down 21 feet short of the runway. It traveled that 21 feet, traveled the full length of the 6999-foot runway, then traveled another one-fourth of a mile… - [NTSB NYC86LA243](https://openairdocs.org/ntsb/NYC86LA243.md): Beech BE-55 · Seneca Falls, NY · Accident · No injuries · Limited investigation · Final report · Sep 28, 1986 · N525TP · Substantial damage > The acft was landed gear up and was subsequently destroyed by fire. The plt admitted he forgot to lower the gear. It wasconfirmed during the post accident inspection that the gear selector was in the up position and the gear doors were closed. - [NTSB MKC86LA196](https://openairdocs.org/ntsb/MKC86LA196.md): Floyd R.Harris Eagle 2 · Joplin, MO · Accident · No injuries · Limited investigation · Final report · Sep 28, 1986 · N25FH · Substantial damage > Pilot was landing rwy 22 with winds from 190 at 12. Just before touchdown, a wind gust lifted acft to right, off side of the runway. Pilot started a go-around but discovered path of flight was toward tower and terminal bldg. Pilot aborted go-around and put… - [NTSB LAX86DVM07](https://openairdocs.org/ntsb/LAX86DVM07.md): Walter D. Burleson KR-2 · Hollister, CA · Accident · No injuries · Final report · Sep 28, 1986 · N50WB · Substantial damage > During a first proving flt for the experimental homebuilt, the pilot said the aircraft 'hit hard' during the landing, bounced and came down on the left wing and nose. According to the pilot, he had accrued less than an hour of flight time in the accident… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=408 ## 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=407 --- 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.