# 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 408 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MIA86LA256](https://openairdocs.org/ntsb/MIA86LA256.md): Cessna 152 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Sep 27, 1986 · N757EQ · Substantial damage > The student pilot while on his third supervised solo flight in the traffic pattern veered left off the runway during a touch and go landing. The aircraft crossed the infield area and struck a parked aircraft. Post accident inspection of the aircraft braking… - [NTSB MIA86LA254](https://openairdocs.org/ntsb/MIA86LA254.md): Cessna 172P · Live Oak, FL · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N54759 · Substantial damage > The student plt stated that after he landed on a wet rwy, he was unable to stop & the acft continued off the end. Before stopping, the acft collided with a fence. According to the operator, the student had landed well beyond the normal touchdown area of the… - [NTSB DCA86IA001](https://openairdocs.org/ntsb/DCA86IA001.md): McDonnell Douglas DC-9-51 · Raleigh-Durham, NC · Incident · No injuries · Incident investigation · Final report · Sep 26, 1986 · N402EA · Minor damage > Drg arrival, the flt crew made a visual apch to rwy 23L in calm wind conds. Flt crew statements indicated that when they were on final apch at about 100 ft AGL, the acft was on the proper glidepath for landing. However the resulting grnd contact was harder… - [NTSB DEN86LA258](https://openairdocs.org/ntsb/DEN86LA258.md): North American AT-6G · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Sep 25, 1986 · N66TY · Substantial damage > Plt made two unsuccessful attempts to land on rwy 26 but discontinued each approach because of unfavorable winds. Winds were reported to be 220 deg at 20 KTS with gusts to 30 KTS. Plt then made two unsuccessful attempts to land on rwy 17L. On third attempt… - [NTSB ANC86LA165](https://openairdocs.org/ntsb/ANC86LA165.md): Cessna A185F · Hanning Bay, AK · Accident · No injuries · Limited investigation · Final report · Sep 25, 1986 · N4611E · Substantial damage > The pilot reported that during a landing, the airplane encountered a strong, gusty crosswind just after touchdown, then nosed over. The wind was reported to be from the northwest at 5 KTS with gusts and light turbulence. - [NTSB DEN86LA253](https://openairdocs.org/ntsb/DEN86LA253.md): Champion 7ECA · Hurricane, UT · Accident · No injuries · Limited investigation · Final report · Sep 24, 1986 · N1634G · Substantial damage > Upon making a normal landing the aircraft groundlooped to the right, impacting with an embankment. Aircraft became airborne again and touched down in soft earth, nosed over and substantially damaged the aircraft. No injuries occurred on this VFR training… - [NTSB MKC86LA192](https://openairdocs.org/ntsb/MKC86LA192.md): Beech E55 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Sep 23, 1986 · N9043V · Substantial damage > The plt rprtd that this was a positioning flt for a 100 hr inspn & that the acft was having electrical problems thru-out the flt. According to him, he extended the flaps & put the gear handle in the down position as he made a VOR apch at night; however, the… - [NTSB DEN86LA257](https://openairdocs.org/ntsb/DEN86LA257.md): Beech V35 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N50BD · Substantial damage > The plt landed hard at the abq municipal arpt. The plt said he had runaway trim causing loss of control. The pax felt the plt lost control due to temporary physical incapacitation. Exam of the flt control system revealed no evidence of a flt control system… - [NTSB DEN86FA256](https://openairdocs.org/ntsb/DEN86FA256.md): Cessna 185C · Broomfield, CO · Accident · Serious injuries · Field investigation · Final report · Sep 21, 1986 · N2674Z · Substantial damage > Plt stated that he made an 'extra smooth landing' on rwy 11L and during the landing roll the right main landing gear collapsed. Examination of landing gear mounting bolt revealed evidence of an overload failure. The engineer that examined the bolt, nut, and… - [NTSB CHI86FEV05](https://openairdocs.org/ntsb/CHI86FEV05.md): Nord Stampe SV4C · Lacon, IL · Accident · No injuries · Final report · Sep 21, 1986 · N73NS · Substantial damage > The plt lost control of the acft during the landing roll, & subsequently, one of the main landing gear collapsed. He stated that he applied the left 'drag brake' (a braking device activated during the last portion of rudder travel) & overcorrected to the… - [NTSB ATL86LA263](https://openairdocs.org/ntsb/ATL86LA263.md): Piper PA-31-325 · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N4505V · Substantial damage > Following a normal touchdown and landing, the pilot lost directional control and the aircraft veered off the left side of runway. The pilot stated that he was unable to correct the directional problem after the aircraft departed the runwaysurface. Examination… - [NTSB ANC86LA163](https://openairdocs.org/ntsb/ANC86LA163.md): Piper PA-18 · Windy Fork Rive, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1986 · N202T · Substantial damage > The pilot lost control of the aircraft and nosed over during landing on a gravel bar. The pilot stated that the airplane nosed over because he stood on the brakes hard during the landing roll to prevent traveling into the river. The plt could not be contacted… - [NTSB MKC86LA198](https://openairdocs.org/ntsb/MKC86LA198.md): Cessna 150G · Weeping Water, NE · Accident · No injuries · Limited investigation · Final report · Sep 20, 1986 · N3832J · Substantial damage > The pilot stated that the grass runway threshold dropped off at the lip giving an impression of being too high on final approach. The aircraft struck the incline three feet short of the runway lip, buckling the nose gear. The aircraft slid to a stop off to… - [NTSB MKC86LA194](https://openairdocs.org/ntsb/MKC86LA194.md): Cessna 172M · Arkansas City, KS · Accident · No injuries · Limited investigation · Final report · Sep 20, 1986 · N80282 · Substantial damage > The plt was landing on his private sod strip which had tall grass along the edges. During the landing roll, he attempted to pick up some papers that had fallen on the cockpit floor. When he looked back up, the acft had drifted to the left. The left wing… - [NTSB MKC86LA191](https://openairdocs.org/ntsb/MKC86LA191.md): Barnes AX-7 · Creston, IA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 1986 · N2054F · No damage > The pilot of the hot air balloon made a landing that was hard enough to break her right ankle. The pilot stated the accident possibly could have been avoided if she had been wearing hightop shoes with laces. - [NTSB FTW86LA170](https://openairdocs.org/ntsb/FTW86LA170.md): Ryan PT-22 · Kerrville, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1986 · N48331 · 2 aircraft · Substantial damage > While arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the… - [NTSB DEN86LA255](https://openairdocs.org/ntsb/DEN86LA255.md): Beech B58 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Sep 19, 1986 · N9025V · Substantial damage > The pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps. - [NTSB LAX86LA341](https://openairdocs.org/ntsb/LAX86LA341.md): Piper PA-28-180 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N9560J · Substantial damage > At the end of the first leg of a solo cross-country flight the plt experienced a hard landing and the acft porpoised. On the second bounce the plt added power. The acft then bounced a third time collapsing the nose gear. - [NTSB CHI86LA227](https://openairdocs.org/ntsb/CHI86LA227.md): Bellanca 17-30A · Grosse Ile, MI · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N28208 · Substantial damage > The pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway. - [NTSB ANC86LA158](https://openairdocs.org/ntsb/ANC86LA158.md): Cessna 207A · Mountain Villag, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1986 · N9736M · Substantial damage > The airline transport pilot who is also a certificated airframe and powerplant mechanic elected to defer brake repairs until the end of the flying day. The fatigued right brake line failed before the end of the day's flying activity. During lndg the brakes… - [NTSB MKC86LA190](https://openairdocs.org/ntsb/MKC86LA190.md): Beech A36 · Horton, KS · Accident · No injuries · Limited investigation · Final report · Sep 16, 1986 · N1810S · Substantial damage > Drg arrival, the plt noted an 'x' on rwy 35, so he tansitioned to a downwind for rwy 33. At that time, the windsock showed a direct left x-wind for the 1860 ft turf rwy which had a fence across the apch end. The acft touched down about 400 to 500 ft down the… - [NTSB DEN86LTM03](https://openairdocs.org/ntsb/DEN86LTM03.md): Quickie Q-2 · Grand Junction, CO · Accident · No injuries · Final report · Sep 16, 1986 · N39204 · Substantial damage > The plt reported that the acft entered a porpoise during landing. While attempting to add power the eng quit. The landing gear then broke off and the acft entered a ground loop and ran off the rwy. The plt notes that the acft has a tendency to bounce during… - [NTSB LAX86LA351](https://openairdocs.org/ntsb/LAX86LA351.md): Cessna 195 · Porterville, CA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1986 · N3879V · Substantial damage > After a normal landing the pilot said he began to apply moderate brake pressure to make the mid-field taxiway turn off and felt what he described as 'a light jerk in the left gear' followed by a 'snapping sound which occurred two or three times.' The pilot… - [NTSB NYC86LA242](https://openairdocs.org/ntsb/NYC86LA242.md): Cessna 172 · Seven Springs, PA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N733CP · Substantial damage > Pilot came in long and high for landing, attempted to land then decided to abort due to insufficient runway remaining. The aircraft continued off the end of the runway. - [NTSB LAX86LA350](https://openairdocs.org/ntsb/LAX86LA350.md): Cessna 172 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N7181G · Substantial damage > The pilot attempted a crosswind landing at the end of a pleasure cross country flight. A loss of directional control occurred on short final and the aircraft drifted right of the runway. A go-around was attempted without success and the aircraft rolled off… - [NTSB CHI86LA229](https://openairdocs.org/ntsb/CHI86LA229.md): Piper PA-28-181 · Greenwood, IN · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N3072L · Substantial damage > The brake pads on the aircraft were allowed to wear beyond their limits. When the brakes were applied, the right brake cylinder moved out past its limit and released the o-ring. This resulted in a loss of brake fluid from the right brake. All of this happened… - [NTSB CHI86LA222](https://openairdocs.org/ntsb/CHI86LA222.md): Cessna 310G · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N8996Z · Substantial damage > The left main gear collapsed and the acft veered off the left side of the runway during the landing roll at an groundspeed of aprx 30 KTS. Inspection of the landing gear disclosed a bent push pull tube. - [NTSB CHI86FEE07](https://openairdocs.org/ntsb/CHI86FEE07.md): Murphy LONG-EZE · Princeton, IL · Accident · Minor injuries · Final report · Sep 14, 1986 · N21VE · Substantial damage > The pilot stated that he held the aircraft in a crabbed attitude throughout the touchdown phase of landing to compensate for a crosswind condition. On touchdown the nose and main landing gear collapsed and the aircraft slid on its belly for approximately 330… - [NTSB BFO86LA046](https://openairdocs.org/ntsb/BFO86LA046.md): Balloon Works FF-7 · Roanoke, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1986 · N7423H · Minor damage > The hot air Balloon was involved in an air show flight event. While enroute to the airport the plt stated that he encountered winds that forced him to land short of the arpt. During the lndg apch he became distracted by spectators on the ground who were in… - [NTSB ANC86LA156](https://openairdocs.org/ntsb/ANC86LA156.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N82064 · Substantial damage > Pilot lost control of aircraft after touchdown on runway due to strong crosswind gust, causing right wing tip to hit ground. - [NTSB MIA86LA248](https://openairdocs.org/ntsb/MIA86LA248.md): Piper PA-34-200 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N1421T · Substantial damage > The plt stated that his landing apch was high. The acft touched down too fast and the plt veered the acft off the left side of the rwy to avoid contacting a fence at the end of the rwy. The acft traveled into soft dirt and the landing gear collapsed. - [NTSB ANC86LA154](https://openairdocs.org/ntsb/ANC86LA154.md): Piper PA-18 · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N2665P · Substantial damage > The plt rprtd that he had flown to the strip a long time ago & did not know that it had deteriorated. During the landing, the acft ran into holes. Subsequently, the main gear & one lift strut were damaged. - [NTSB LAX86LA352](https://openairdocs.org/ntsb/LAX86LA352.md): Piper PA-28-180 · Likely, CA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1986 · N8085W · Substantial damage > The airplane departed san jose airport (sjc), san jose, CA on a business flight in an area near Likely, CA. The pilot intentionally landed on an open dirt area to obtain a soil sample. During the landing roll-out the airplane's left main gear separated after… - [NTSB ANC86LA153](https://openairdocs.org/ntsb/ANC86LA153.md): Fairchild 24-J · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 1986 · N20617 · Substantial damage > After touchdown on a gravel bar the pilot lost directional control of the aircraft causing the aircraft to ground loop to the left. - [NTSB ANC86LA150](https://openairdocs.org/ntsb/ANC86LA150.md): Bellanca 8GCBC · Bradley Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1986 · N86992 · Substantial damage > During the landing roll the pilot lost directional control of the aircraft causing the aircraft to veer to the right and nosed over on its back. The plt was landing off the arpt on a sand/gravel bar and due to the rough and uneven nature of the terrain was… - [NTSB LAX86LA345](https://openairdocs.org/ntsb/LAX86LA345.md): Cessna 150 · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1986 · N112LN · Substantial damage > At the end of one leg of a solo cross-country flight the student pilot experienced a hard landing which resulted in a porpoise on the rwy. The pilot did not realize the severity of the initial bounce and tried to re-flare the aircraft without adding power.… - [NTSB NYC86LA233](https://openairdocs.org/ntsb/NYC86LA233.md): Robinson R22 · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1986 · N9033B · Substantial damage > On a student pilot's third solo supervised flight, the pilot placed the throttle in detent, became confused, and autorotated into trees. - [NTSB ANC86LA145](https://openairdocs.org/ntsb/ANC86LA145.md): Piper PA-18 · Big River, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1986 · N287T · Substantial damage > The pilot attempted a touch and go landing to evaluate a questionable landing area. The area was too soft for a touch and go. The acft became mired in mod and nosed over. - [NTSB MIA86LA247](https://openairdocs.org/ntsb/MIA86LA247.md): Cessna 140 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1986 · N73087 · Substantial damage > The accident occurred while practicing takeoffs and landings in a grass area adjacent to the asphalt runway. The aircraft contacted soft mud during the landing roll and nosed over. - [NTSB MKC86LA186](https://openairdocs.org/ntsb/MKC86LA186.md): Cessna 140 · Festus, MO · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1986 · N89208 · Minor damage > The student plt was on his 2nd solo flt & was practicing stop & go landings. He said that during a landing, he applied brakes before the left main landing gear was on the rwy. The acft swerved to the right & the left main gear collapsed. The plt received a… - [NTSB ATL86LA244](https://openairdocs.org/ntsb/ATL86LA244.md): Cessna A188B · Screven, GA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1986 · N9351R · Substantial damage > The plt was making a landing on an unpaved road near the aerial application site. He reported that the spray boom contacted peanut vines causing the acft to ground loop. The plt stated that he 'might have had a small bank to the right' at the time. The wind… - [NTSB ANC86LA144](https://openairdocs.org/ntsb/ANC86LA144.md): Champion 8GCBC · Big Delta, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N8575V · Substantial damage > The plt attempted to land on a gravel bar during a hunting flt. He failed to see a wash/ditch on the bar and the right main gear collapsed upon contacting it. The acft then rolled inverted. - [NTSB LAX86LA337](https://openairdocs.org/ntsb/LAX86LA337.md): Bellanca 7KCAB · Poston, AZ · Accident · No injuries · Limited investigation · Final report · Sep 4, 1986 · N68573 · Substantial damage > At the end of a local practice flight the plt overflew the rwy and observed the wind sock. She noted the speed and direction to be 5 KTS from the north and elected to land downwind for easy access to the fuel tanks located on the south end. On touchdown, the… - [NTSB ATL86LA241](https://openairdocs.org/ntsb/ATL86LA241.md): Cessna 150 · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · Sep 4, 1986 · N3410J · Substantial damage > The pilot reported that during a practice landing he flared too high off the runway surface. The pilot lowered the nose, causing the nosewheel to strike the runway. The pilot lost control and the acft skidded off the left side, down an embankment and flipped… - [NTSB ANC86LA143](https://openairdocs.org/ntsb/ANC86LA143.md): Cessna TU206A · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1986 · N942SA · Substantial damage > The pilot forgot to retract the landing gear on the amphibous floats after taking off from a gravel runway. He landed on a lake with the wheels extended and the airplane turned over. - [NTSB MKC86LA185](https://openairdocs.org/ntsb/MKC86LA185.md): Cessna 152 · Onawa, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 1986 · N45986 · Substantial damage > The student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged. - [NTSB DEN86LA244](https://openairdocs.org/ntsb/DEN86LA244.md): Cessna 172 · Aztec, NM · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N63302 · Substantial damage > The student plt was returning to the arpt after a local flt when the accident occurred. The plt aborted the first landing attempt on rwy 04. During the second landing attempt, the acft ran off the left side of the rwy, struck a dirt bank and nosed over. The… - [NTSB CHI86FER18](https://openairdocs.org/ntsb/CHI86FER18.md): Shanks/Becker Acro Sport · New Richmond, WI · Accident · No injuries · Final report · Sep 1, 1986 · N2263V · Substantial damage > According to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide. - [NTSB ANC86LA159](https://openairdocs.org/ntsb/ANC86LA159.md): Cessna 180B · Clear, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1986 · N3539E · Substantial damage > The plt & passenger were on a hunting trip & had selected a clearing on a brush covered hillside for a landing. The clearing had been previously used as an airstrip. While on final apch to land at dusk, the plt lost sight of the touchdown area due to darkness… - [NTSB NYC86LA223](https://openairdocs.org/ntsb/NYC86LA223.md): Cessna 152 · Willimantic, CT · Accident · No injuries · Limited investigation · Final report · Aug 31, 1986 · N5088Q · Substantial damage > The plt made an approach to runway 36 too fast and long. Aircraft touched down hard, the plt lost control and the aircraft bounced a few times before nosing over. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=409 ## 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=408 --- 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.