# 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 413 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB ANC86FA071](https://openairdocs.org/ntsb/ANC86FA071.md): Piper PA-18 · Girdwood, AK · Accident · Serious injuries · Field investigation · Final report · Jun 10, 1986 · N4418Z · Substantial damage > The instructor pilot gave the student pilot a forced landing while on left base to runway 19. The student continued the approach at approximately 200 feet noticed the rate of descent increasing. The student applied full power but the airplane continued to… - [NTSB MKC86LA127](https://openairdocs.org/ntsb/MKC86LA127.md): Cessna 172F · Jefferson City, MO · Accident · No injuries · Limited investigation · Final report · Jun 9, 1986 · N5695R · Substantial damage > The runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the… - [NTSB ANC86LA067](https://openairdocs.org/ntsb/ANC86LA067.md): Bellanca 7GCBC · Deshka River, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 1986 · N31285 · Substantial damage > The pilot stated while landing at an unimproved airstrip the aircraft's left main landing gear struck a bush causing the aircraft to ground loop. - [NTSB ATL86LA164](https://openairdocs.org/ntsb/ATL86LA164.md): Burkhart Grob G103 · Benton, TN · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1986 · N2135R · Substantial damage > The glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he… - [NTSB LAX86FVA08](https://openairdocs.org/ntsb/LAX86FVA08.md): Nelson/Nelson Varieze · Merced, CA · Accident · Serious injuries · Final report · Jun 7, 1986 · N615EZ · Destroyed > While on final approach witnesses observed the aircraft to be low and slow when the wing collided with a light stanchion (5' high). The left wing banked sharply to the left, hit the ground and the acft cartwheeled. The pilot reported no mechanical problems… - [NTSB BFO86FID07](https://openairdocs.org/ntsb/BFO86FID07.md): Cessna 172M · Lynchburg, VA · Accident · No injuries · Final report · Jun 6, 1986 · N20372 · Substantial damage > The accident occurred as the plt was attempting to land at an unfamiliar arpt during a x-country flt because a passenger was feeling ill. The rwy was 2900 ft long with a 5% upslope at mid-field. The plt stated he misjudged his alt and airspeed during the… - [NTSB SEA86LA136](https://openairdocs.org/ntsb/SEA86LA136.md): Cessna 185 · Boise, ID · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N9397N · Substantial damage > During rollout after landing, the pilot was asked by the tower to expedite clearing the runway due to landing traffic. As the aircraft had slowed, the pilot attempted a turnout when a groundloop occurred. A gust of wind precipitated the groundloop. The wind… - [NTSB FTW86LA105](https://openairdocs.org/ntsb/FTW86LA105.md): Maule M7-235 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N232T · Substantial damage > The plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop. - [NTSB BFO86LA033](https://openairdocs.org/ntsb/BFO86LA033.md): Cessna 152-II · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N94214 · Substantial damage > With the wind out of the east at about 10 knots, the student pilot touched down on the centerline of runway 32. Shortly thereafter, the aircraft swerved right and then left and the CFI attempted to take over the controls. She stated that she could not… - [NTSB ATL86LA268](https://openairdocs.org/ntsb/ATL86LA268.md): Stinson 108-1 · Roanoke, AL · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N8838K · Substantial damage > Reportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA… - [NTSB ANC86LA065](https://openairdocs.org/ntsb/ANC86LA065.md): Cessna 172 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 5, 1986 · N9747 · Substantial damage > The pilot stated that after the landing roll, directional control of the aircraft was lost causing the aircraft to exit the left side of the runway striking an airport sign. - [NTSB MIA86LA172](https://openairdocs.org/ntsb/MIA86LA172.md): Cessna 172N · Bartow, FL · Accident · No injuries · Limited investigation · Final report · Jun 4, 1986 · N5456D · Substantial damage > The plt stated that she landed hard on the nose wheel and the prop struck the ground, damaging the structure of the aircraft. - [NTSB SEA86LA138](https://openairdocs.org/ntsb/SEA86LA138.md): Rose A4C · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N14884 · Substantial damage > During landing roll the pilot lost directional control of the aircraft. The right main gear collapsed dragging the right wing. - [NTSB NYC86LA143](https://openairdocs.org/ntsb/NYC86LA143.md): Cessna 140 · Meriden, CT · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N2286N · Substantial damage > Directional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage. - [NTSB CHI86LA150](https://openairdocs.org/ntsb/CHI86LA150.md): Cessna 182F · Hillsboro, WI · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N3567Y · Substantial damage > The pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the… - [NTSB SEA86LA135](https://openairdocs.org/ntsb/SEA86LA135.md): Grumman G21A · Hobart Bay, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1986 · N37487 · Substantial damage > The pilot neglected to raise the landing gear after departing the airport. While landing onto water with the gear still down, the aircraft's nose broke off and the aircraft nosed over inverted and then sank. - [NTSB CHI86LA148](https://openairdocs.org/ntsb/CHI86LA148.md): Cessna 182K · Durand, WI · Accident · No injuries · Limited investigation · Final report · Jun 1, 1986 · N2669Q · Substantial damage > According to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge… - [NTSB CHI86FEM06](https://openairdocs.org/ntsb/CHI86FEM06.md): Cessna 170 · Houghton Lake, MI · Accident · No injuries · Final report · Jun 1, 1986 · N4155V · Substantial damage > This student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over. - [NTSB ATL86LA152](https://openairdocs.org/ntsb/ATL86LA152.md): Forney F-1 · Abbeville, SC · Accident · No injuries · Limited investigation · Final report · Jun 1, 1986 · N7567C · Substantial damage > The student plt reported that the acft's brake system was inoperative during ldg rollout. The acft ran off the end of the rwy end into a trash pile and collided with pine logs. - [NTSB LAX86LA239](https://openairdocs.org/ntsb/LAX86LA239.md): Cessna 150 · Gasquet, CA · Accident · No injuries · Limited investigation · Final report · May 31, 1986 · N22MS · Substantial damage > The pilot stated that, as he entered the traffic pattern, the windsock for runway 24 indicated about five knots of wind straight down the runway. He further stated that, as he was about to touch down, a sudden cross wind caused the aircraft to 'nose to the… - [NTSB ATL86LA154](https://openairdocs.org/ntsb/ATL86LA154.md): Piper PA-22 · Warren, OH · Accident · No injuries · Limited investigation · Final report · May 31, 1986 · N3564Z · Substantial damage > During a normal takeoff, the pilot decided to abort the takeoff after he determined that the aircraft was not accelerating as fast as he thought it should. After the aircraft touched down on the sod surface, the pilot proceeded toapply full braking. Since the… - [NTSB MIA86LA170](https://openairdocs.org/ntsb/MIA86LA170.md): Cessna 177RG · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · May 30, 1986 · N1888Q · Substantial damage > The plt stated that the landing gear indicator light showed the gear to be down & locked. When the acft touched down the landing gear collasped and the acft slid to a stop. Post crash examination of the landing gear showed it to operate normally in all modes.… - [NTSB NYC86LA139](https://openairdocs.org/ntsb/NYC86LA139.md): Globe GC-1B · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · May 29, 1986 · N80611 · Substantial damage > The flight departed Johnstown-cambria airport at about 1600 hours and returned at about 1700 hours. On landing, the pilot forgot to lower the landing gear and landed gear up. The aircraft slid to a stop and about five minutes later fire erupted. - [NTSB FTW86LA094](https://openairdocs.org/ntsb/FTW86LA094.md): Cessna 172N · Vega, TX · Accident · No injuries · Limited investigation · Final report · May 28, 1986 · N6352D · Destroyed > The pilot was practicing touch and go landings, when the aircraft began veering to the left after landing. He tried to apply full right rudder, but the aircraft continued to veer left off the runway. The pilot pulled the nose up to clear a tractor. The… - [NTSB CHI86LA145](https://openairdocs.org/ntsb/CHI86LA145.md): Cessna 182P · Platteville, WI · Accident · No injuries · Limited investigation · Final report · May 27, 1986 · N84118 · Substantial damage > The plt landed the acft on rwy 7 which was wet. Winds at the time were from 120 degs at 12 KTS. The plt stated that the wind caused the acft to skid and travel off the left side of the rwy. The acft nosed over after contacting soft soil alongside the rwy. - [NTSB ANC86LA063](https://openairdocs.org/ntsb/ANC86LA063.md): Cessna 140 · Bradley Ski, AK · Accident · No injuries · Limited investigation · Final report · May 27, 1986 · N1661V · Substantial damage > The pilot stated that after touchdown he lost control of the aircraft causing the plane to nose over on its back. At the time of the accident the wind was less than six knots. - [NTSB LAX86LA234](https://openairdocs.org/ntsb/LAX86LA234.md): Mooney M-18C · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · May 26, 1986 · N4146 · Substantial damage > The plt indicated that there was a gusty left crosswind present during landing. The acft drifted right off the 40 ft wide asphalt rwy and collided with a small ditch and dirt bank. The acft then nosed over into the arpt drainage ditch. - [NTSB FTW86LA090](https://openairdocs.org/ntsb/FTW86LA090.md): Cessna 152 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · May 26, 1986 · N94479 · Substantial damage > The student plt was practicing touch and go landings when he landed nose wheel first, causing the acft to bounce several times and veer off the rwy toward a ditch. The student plt, in his attempt to avoid the ditch, over compensated with the brakes and the… - [NTSB DEN86LA143](https://openairdocs.org/ntsb/DEN86LA143.md): Piper PA-18 · Decker, MT · Accident · Minor injuries · Limited investigation · Final report · May 26, 1986 · N4043E · Substantial damage > The plt attempted to make a downwind landing in a grass covered pasture, landed long and attempted to make a go-around. During the go-around with the flaps retracted the aircraft struck a wire fence and impacted a horse trailer. The aircraft was destroyed.… - [NTSB SEA86LA130](https://openairdocs.org/ntsb/SEA86LA130.md): Cessna 152 · Raymond, WA · Accident · No injuries · Limited investigation · Final report · May 25, 1986 · N6471M · Substantial damage > The pilot chose to land at an alternate airport to await improving weather. During a gusty crosswind, loss of directional control occurred during landing flare. The aircraft departed the runway to the left and nosed over inverted. - [NTSB MIA86LA169](https://openairdocs.org/ntsb/MIA86LA169.md): Cessna 172RG · Jackson, MS · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N4596V · Substantial damage > The plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell… - [NTSB LAX86LA232](https://openairdocs.org/ntsb/LAX86LA232.md): Cessna 172 · Huntington Bch, CA · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N172HW · Substantial damage > The acft contacted a parked car and a hangar following a loss of control during an attempted go-around. The plt reported the acft was high and fast on final apch. He selected full flaps and a nose up attitude to lose airspeed and alt. He flared the acft at 20… - [NTSB ATL86LA142](https://openairdocs.org/ntsb/ATL86LA142.md): Piper PA-28-161 · Statesville, NC · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N9778C · Substantial damage > The pilot allowed the aircraft to stall and touchdown short of the runway while competing in a power off spot landing competition. The pilot stated that the accident could have been prevented by simply adding power. - [NTSB ANC86LA060](https://openairdocs.org/ntsb/ANC86LA060.md): Cessna 180 · Iliamna, AK · Accident · 1 fatal · Limited investigation · Final report · May 23, 1986 · N52189 · Substantial damage > The pilot stated that at the time of the accident the wind was 30 knots gusting to 35 knots. After touchdown on the water, the pilot lost control of the aircraft causing the aircraft to nose over on its back and sink. - [NTSB MKC86LA116](https://openairdocs.org/ntsb/MKC86LA116.md): Champion 7KCAB · Crete, NE · Accident · No injuries · Limited investigation · Final report · May 22, 1986 · N5229X · Substantial damage > The plt of this tail-wheel acft attempted a landing on a rwy with a strong x-wind. After a go-around, he started an apch to a turf rwy that was better aligned with the wind but made a go-around when he thought the grass was too high. He then attempted another… - [NTSB ATL86LA139](https://openairdocs.org/ntsb/ATL86LA139.md): Mooney M20K · Peachtree City, GA · Accident · No injuries · Limited investigation · Final report · May 22, 1986 · N98544 · Substantial damage > The plt reported that the acft began to 'wheelbarrow' on the nose gear during the ldg roll. The acft veered off the rwy into a ditch. The plt said that he might not have had the pitch trim set correctly at touchdown. The acft flt manual before landing… - [NTSB MIA86LA164](https://openairdocs.org/ntsb/MIA86LA164.md): Cessna 152 · Stuart, FL · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N20SQ · Destroyed > The student plt was on his first supervised solo flt and was attempting his third landing. During the flare, the acft ballooned, nosed over and struck the rwy on the nose gear. The acft then burst into flames and was consumed by fire. Theplt was able to exit… - [NTSB ATL86LA136](https://openairdocs.org/ntsb/ATL86LA136.md): Beech A36 · Swansboro, NC · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N103SM · Substantial damage > The plt reported that the acft touched down about 700 ft down the 2700 ft sod rwy. The rwy was wet from rain and braking action was nil. The plt elected to stay on the rwy and continue braking efforts. The acft slid off the rwy end into a drainage ditch. The… - [NTSB ANC86LA059](https://openairdocs.org/ntsb/ANC86LA059.md): Taylorcraft TC-19 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · May 20, 1986 · N2002V · Substantial damage > The pilot stalled the acft during approach to a gravel bar and made a hard landing. The plt said that he needed to improve his proficiency at slow flying. - [NTSB NYC86LA137](https://openairdocs.org/ntsb/NYC86LA137.md): Schweizer SGS-2-32A · Kurtztown, PA · Accident · Serious injuries · Limited investigation · Final report · May 19, 1986 · N2979H · Substantial damage > After flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150… - [NTSB MKC86LA111](https://openairdocs.org/ntsb/MKC86LA111.md): Jackman Pitts S-1S · Montezuma, KS · Accident · No injuries · Limited investigation · Final report · May 19, 1986 · N39967 · Substantial damage > The pilot stated that as the aircraft touched down on the runway the left wing struck crops in a wheatfield which arrested the forward motion of the wing. According to th e pilot, the aircraft veered out of control into the wheatfield, cartwheeled twice, and… - [NTSB DEN86LA140](https://openairdocs.org/ntsb/DEN86LA140.md): Cessna 172B · Alamosa, CO · Accident · No injuries · Limited investigation · Final report · May 19, 1986 · N6990X · Substantial damage > The student plt had soloed that morning. After a short rest period he flew with his instructor. He then flew a second solo flt. The student plt made two landings. On the third approach the plt made a go-around. On the next approach the acft stalled close to… - [NTSB MKC86LA110](https://openairdocs.org/ntsb/MKC86LA110.md): Myers EAA BI-PLANE · Winfield, KS · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N1770B · Substantial damage > The pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the… - [NTSB LAX86LA230](https://openairdocs.org/ntsb/LAX86LA230.md): Cessna 172B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N7176T · Substantial damage > The acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear… - [NTSB BFO86LA025](https://openairdocs.org/ntsb/BFO86LA025.md): Cessna 340A · Washington, DC · Accident · Minor injuries · Limited investigation · Final report · May 17, 1986 · N6828P · Substantial damage > The acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The… - [NTSB ATL86LA134](https://openairdocs.org/ntsb/ATL86LA134.md): Piper PA-38 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N25737 · Substantial damage > During the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the… - [NTSB MIA86LA161](https://openairdocs.org/ntsb/MIA86LA161.md): Piper PA-28R-180 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · May 16, 1986 · N4986J · Substantial damage > While on final apch the acft was blown to the right of the rwy where the left wing struck a dirt mound. The acft then spun to the left and came to rest aprx 75 ft from the edge of the rwy. The plt stated that he decided to try and salvage the landing during… - [NTSB DEN86LA136](https://openairdocs.org/ntsb/DEN86LA136.md): Cessna 421C · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · May 15, 1986 · N21WL · Substantial damage > Acft was landing on rwy 17. Plt said he struck a rabbit with left main landing gear and lost all braking action on left side. Plt used right brake to decelerate but overran rwy end and struck dirt bank. - [NTSB SEA86LA124](https://openairdocs.org/ntsb/SEA86LA124.md): Cessna 206T · Murphy, ID · Accident · Minor injuries · Limited investigation · Final report · May 13, 1986 · N1046V · Substantial damage > The pilot attempted to land with excessive airspeed and altitude. A bounced landing occurred with a touchdown being more than 2/3 way down the runway. During VFR co-around, a departure stall was entered and the aircraft struck the ground with the left wing… - [NTSB MKC86LA105](https://openairdocs.org/ntsb/MKC86LA105.md): Beech A36 · Mountain Home, AR · Accident · No injuries · Limited investigation · Final report · May 13, 1986 · N2015K · Substantial damage > The PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=414 ## 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=413 --- 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.