# 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 412 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB NYC86LA163](https://openairdocs.org/ntsb/NYC86LA163.md): Cessna 152 · Oxford, MA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N757JC · Substantial damage > The plt rprtd he encountered a gust of wind & a wind shift during the flare to land. Subsequently, he lost directional control & the acft went off the side of the rwy, collided with a man-made pyramid of stone & rotated upside down. The plt rprtd the winds… - [NTSB DEN86LA180](https://openairdocs.org/ntsb/DEN86LA180.md): Mathew M. Kerr Starduster TOO · Roundup, MT · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N159MK · Substantial damage > During the telephone interview, the plt stated the acft landed hard, collapsing the right main gear & broke the right wing spar. - [NTSB DEN86LA178](https://openairdocs.org/ntsb/DEN86LA178.md): Cessna 182F · Joliet, MT · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N2BC · Substantial damage > According to the plt, horses ran in front of him during landing and he was forced to make evasive maneuvers. During the evasive maneuvers, the acft ground looped and was substantially damaged. - [NTSB DEN86LA177](https://openairdocs.org/ntsb/DEN86LA177.md): Cessna 182P · Sheridan, WY · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N9099M · Substantial damage > A loss of directional control occurred during landing roll and the acft departed the left side of the grass/dirt landing strip. The acft then traveled down a slight embankment and collided with a wire fence and fence posts. - [NTSB CHI86LA163](https://openairdocs.org/ntsb/CHI86LA163.md): Beech 58 · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N29CP · Substantial damage > The plt stated his left brake failed during landing roll on the 3,200 ft long rwy. The landing was made with a 20 deg right quartering 10 knot tailwind. To prevent running off the departure end of the rwy in to a 50 ft dropoff, the plt ground looped the acft… - [NTSB ANC86FA092](https://openairdocs.org/ntsb/ANC86FA092.md): Cessna 180H · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 28, 1986 · N180SR · Substantial damage > The pilot and the owner of the airplane serviced the brakes prior to takeoff. When they returned from a local flight, the right brake was inoperative during the landing roll-out. The airplane groundlooped to the left, then went off the left edge of the… - [NTSB MIA86LA192](https://openairdocs.org/ntsb/MIA86LA192.md): Cessna 172N · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N733ML · Substantial damage > The plt stated that he landed long on the wet grass rwy. As he attempted to stop, the acft slid off the side of the rnwyinto a ditch, severing the nose gear & collapsing the left main landing gear. - [NTSB LAX86LA267](https://openairdocs.org/ntsb/LAX86LA267.md): Bellanca 14-19-2 · Mammoth, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N7687B · Substantial damage > The plt lost control of the acft & it collided with terrain during a landing to rwy 27. The plt indicated that the winds were from 190 deg at 15 gusting 20 KTS. Reportedly, he landed on rwy 27 with an indicated airspeed of 80 mph. During the landing roll, a… - [NTSB FTW86LPJ10](https://openairdocs.org/ntsb/FTW86LPJ10.md): Grumman G-164 · Hooker, OK · Accident · No injuries · Final report · Jun 27, 1986 · N788Y · Substantial damage > The pilot stated that the aircraft flipped over when he landed in soft dirt on his recently extended private landing strip. - [NTSB CHI86LA237](https://openairdocs.org/ntsb/CHI86LA237.md): Pitts S2A · Peru, IL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N70JJ · Substantial damage > Pilot elected to land on runway 18 because the windsock was indicating wind to be fromthe south. Upon touchdown in the first third of the runway the aircraft skipped slightly. Pilot chose to try to stop rather than attempt a go-around and applied heavy… - [NTSB ATL86LA185](https://openairdocs.org/ntsb/ATL86LA185.md): Piper PA-34-200 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N57308 · Substantial damage > The flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed… - [NTSB ANC86LA091](https://openairdocs.org/ntsb/ANC86LA091.md): Cessna 170A · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N9033A · Substantial damage > The relatively inexperienced private pilot attempted to land his airplane on a gravel beach as the tide was receding. He failed to maintain directional control and the airplane was substantially damaged in the ensuing ground loop. - [NTSB ANC86LA087](https://openairdocs.org/ntsb/ANC86LA087.md): Cessna 305/L-19 · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Jun 26, 1986 · N68396 · Substantial damage > The non-certificated flight instructor failed to respond in time to improper control input by the student. The airplane ground looped and went on its nose sustaining substantial damage. - [NTSB NYC86LA173](https://openairdocs.org/ntsb/NYC86LA173.md): Enstrom F-28A · New York, NY · Accident · No injuries · Limited investigation · Final report · Jun 25, 1986 · N149Q · Substantial damage > The plt performed a go-around due to excessive groundspeed during the first landing attempt. The plt reported that as he applied upward collective to terminate the second landing apch over the helipad, the helicopter descended rapidly. The helicopter… - [NTSB MKC86LA141](https://openairdocs.org/ntsb/MKC86LA141.md): Cessna 182 · Siloam Springs, AR · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N2367G · Substantial damage > The PIC was practicing touch and go landings, and decided to change rwys for his final landing. The PIC stated he landed long on the 1650 foot turf rwy, but went off the end. The PIC stated he should have added pwr and made a go around. The PIC was late in… - [NTSB FTW86LA121](https://openairdocs.org/ntsb/FTW86LA121.md): Piper PA-28-140 · Georgetown, TX · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N3737K · Substantial damage > The instructor pilot was demonstrating night landings to his student pilot, when the aircraft veered to the right on touchdown. The instructor thought his student was on the right rudder, but failed to override him by applying left rudder. The next morning… - [NTSB NYC86LA157](https://openairdocs.org/ntsb/NYC86LA157.md): Piper PA-28-140 · Bally, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1986 · N5592U · Destroyed > The pilot landed on ruwnay 34 in winds he estimated to be from 270 degrees at 10-15 knots. He stated that at touchdown, the left wing was caught by a gust and raised. The aircraft drifted right. The pilot stated there was sufficent runway to continue the… - [NTSB LAX86LA265](https://openairdocs.org/ntsb/LAX86LA265.md): Cessna 150M · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jun 23, 1986 · N704KZ · Substantial damage > After completing a solo instructional flight the 80-HR student plt landed. During rollout the plt inadvertently applied excessive brake & rudder pressure to the left pedal. The plt lost directional control of the acft & it veered off the rwy. The acft… - [NTSB DEN86LA192](https://openairdocs.org/ntsb/DEN86LA192.md): Piper PA-38 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Jun 23, 1986 · N2465B · Substantial damage > The student & instructor (CFI) were practicing touch-&-go lndgs. The CFI rprtd that drg a lndg, when the acft was aprx 6 inches above the rwy, the student suddenly applied full left rudder. The acft yawed sharply to the left & the CFI attempted corrective… - [NTSB MKC86LA130](https://openairdocs.org/ntsb/MKC86LA130.md): Cessna 180 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N3166D · Substantial damage > A witness stated that the he observed the acft in a normal approach for landing but that it appeared slow. The witness observed the left wing drop just before the acft was to touchdown to the rwy. Tire scuff marks were seen by the witness on the rwy near… - [NTSB LAX86LA270](https://openairdocs.org/ntsb/LAX86LA270.md): Schweizer SGS 1-26C · Aguanga, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1986 · N3885A · Substantial damage > A Schweizer sgs 1-26C glider collided with a wire fence while the plt was landing on a closed airstrip. The closed strip was marked with x's. several fences were stretched across the airstrip to control livestock. The pilot indicated that during flt, he had… - [NTSB LAX86LA264](https://openairdocs.org/ntsb/LAX86LA264.md): Piper J-3 · Columbia, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N21677 · Substantial damage > The acft nosed over in soft ground during landing roll after veering off rwy 17. The plt indicated that the right brake pedal was jammed by 1/2 inch carpet that had been installed in the acft. The acft veered off the right side of the rwy 17. When the plt… - [NTSB LAX86LA262](https://openairdocs.org/ntsb/LAX86LA262.md): Beech 95-C55 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N7860L · Substantial damage > The pilot stated that, on the landing roll, the right main landing gear collapsed and the right wing was damaged as a result of contact with the runway. The mechanic who examined the aircraft stated that the right landing gear failed to lock, however he was… - [NTSB LAX86LA261](https://openairdocs.org/ntsb/LAX86LA261.md): Cessna 150M · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N63437 · Substantial damage > While practicing takeoffs and landings on an authorized solo instructional flight the student pilot ballooned and began to porpoise down the runway. On the third nose gear contact with the runway the nose gear collapsed. - [NTSB DEN86LA169](https://openairdocs.org/ntsb/DEN86LA169.md): Piper PA-28-235 · Last Chance, CO · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N8844W · Substantial damage > The plt said while on landing roll a cross wind drifted N8844W off right hand side of rwy on a farm strip. Lost control in soft dirt and nosed over. The vehicle was substantially damaged, and the plt was uninjured. - [NTSB MIA86LA186](https://openairdocs.org/ntsb/MIA86LA186.md): Cessna U206F · Ft. Myers, FL · Accident · No injuries · Limited investigation · Final report · Jun 21, 1986 · N1372V · Substantial damage > The private pilot had just completed a short no-radio night flight and during the landing roll the nose gear wheel assembly separated from the aircraft. Examination revealed that the wrong nuts had been installed on the wheel assembly at the last annual… - [NTSB FTW86LA117](https://openairdocs.org/ntsb/FTW86LA117.md): Cessna 172K · Weatherford, TX · Accident · No injuries · Limited investigation · Final report · Jun 21, 1986 · N84839 · Substantial damage > The pilot reported losing control of the acft during touchdown due to the crosswind. The landing was being made on runway 16 and there was a 7 kt wind from 200 degrees. - [NTSB CHI86LA160](https://openairdocs.org/ntsb/CHI86LA160.md): Beech V35B · Mackinac Island, MI · Accident · No injuries · Limited investigation · Final report · Jun 21, 1986 · N18393 · Substantial damage > After making two go-arounds the aircraft's landing gear collapsed as the aircraft porpoised on the runway during the third landing attempt. - [NTSB MIA86LA222](https://openairdocs.org/ntsb/MIA86LA222.md): Bell 47G3B1 · Cleveland, MS · Accident · No injuries · Limited investigation · Final report · Jun 20, 1986 · N53SP · Substantial damage > The pilot stated that when he took off, the acft was overweight and he was unable to remain airborne. He attempted a running landing, the skids dug in and collapsed causing the spray boom to swing forward and break the bubble canopy. - [NTSB LAX86LA258](https://openairdocs.org/ntsb/LAX86LA258.md): Cessna 152 · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1986 · N68916 · Substantial damage > The acft landed hard on runway 21. The certified flight instructor indicated that during the landing flare of a full flap landing the student pilot allowed the aircraft to yaw 45 degs off the runway heading. The CFI immediately initiated a go-around by… - [NTSB CHI86LA158](https://openairdocs.org/ntsb/CHI86LA158.md): Cessna 182P · Gary, IN · Accident · No injuries · Limited investigation · Final report · Jun 19, 1986 · N20735 · Substantial damage > The student pilot was on a supervised solo flight. According to him, he closed the throttle over the threshold due to excessive speed and the plane floated for some distance as he brought the control column back. The nose of the aircraft then dropped and the… - [NTSB ATL86FA176](https://openairdocs.org/ntsb/ATL86FA176.md): Piper PA-28-180 · Columbus, GA · Accident · Serious injuries · Field investigation · Final report · Jun 19, 1986 · N103EF · Substantial damage > Just as the aircraft flared for landing, a gust of wind struck the airport. The pilot and passengers reported that the aircraft ballooned up several feet, and the right wing dipped. The pilot got the wings level and attempted to perform a go-around. The… - [NTSB ATL86LA175](https://openairdocs.org/ntsb/ATL86LA175.md): Beech C-23 · Fuquay-Varina, NC · Accident · No injuries · Limited investigation · Final report · Jun 18, 1986 · N6046Z · Substantial damage > The flt was a practical flt test for a commercial plt certificate. At aprx 3,000 ft the plt examiner initiated a simulated forced landing. The applicant spiraled to a modified downwind and base leg. The applicant said everything was fine until on final apch… - [NTSB LAX86LA256](https://openairdocs.org/ntsb/LAX86LA256.md): Cessna 140 · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1986 · N89403 · Substantial damage > The plt lost control of the acft during landing. A witness stated that when the acft was about one-fourth of the way down the rwy, it began porpoising and then flipped over on its back. - [NTSB BFO86FA036](https://openairdocs.org/ntsb/BFO86FA036.md): Piper PA-28-160 · Michellville, MD · Accident · Serious injuries · Field investigation · Final report · Jun 17, 1986 · N5444W · Substantial damage > After circling around the airport, trying to raise somebody on UNICOM to find out wind conditions at the field, the pilot noted the lighted windsock indicator and elected to land to the north. The aircraft was observed to land long on the 2420 foot runway,… - [NTSB CHI86FET03](https://openairdocs.org/ntsb/CHI86FET03.md): Edward R. Merkner MUSTANG-II · Valparaiso, IN · Accident · No injuries · Final report · Jun 16, 1986 · N9021A · Substantial damage > After three apparent hard touch-&-go landings, the left main landing gear collapsed on the fourth & final landing. The pilot stated that there were no mechanical malfunctions of the aircraft prior to the accident. - [NTSB LAX86LA246](https://openairdocs.org/ntsb/LAX86LA246.md): Bellanca Kcab · Taft, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N8780 · Substantial damage > The citabrea bounced on landing and ground looped on the runway. The pilot indicated that on touchdown the aircraft bounced. Throttle was advanced and on the second touchdown the aircraft veered left. The left wing rose placing the aircraft on the right main… - [NTSB FTW86LA110](https://openairdocs.org/ntsb/FTW86LA110.md): Cessna 152 · Mineola, TX · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N25512 · Substantial damage > The student pilot was practicing touch and go landings when he lost control of the acft on landing. He stated he lost directional control due to windy conditions. However, winds in the area were reported to be calm. The aircraft veered off the runway damaging… - [NTSB CHI86LA154](https://openairdocs.org/ntsb/CHI86LA154.md): Glasflugel Club Libelle 205 · St. Elmo, IL · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N8HD · Substantial damage > There was a loss of thermal activity while the glider plt was on a x-country flt. During an off arpt lndg, the wingtip of the sailplane struck weeds. Subsequently, the acft ground looped & was damaged. - [NTSB ANC86LA076](https://openairdocs.org/ntsb/ANC86LA076.md): Piper PA-12 · Egegik, AK · Accident · No injuries · Limited investigation · Final report · Jun 15, 1986 · N3598M · Substantial damage > The pilot stated that after touchdown he lost directional control of the aircraft causing the plane to nose over. At the time of the accident there was a direct crosswind. - [NTSB NYC86LA151](https://openairdocs.org/ntsb/NYC86LA151.md): Cessna 172 · Arcade, NY · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N13605 · Substantial damage > The pilot landed on a wet runway that sloped slightly downhill. He stated that the aircraft touched down about 800 feet down the runway in winds that were from the west at 1 to 3 mph. The brakes were ineffective on the wet turf. Subsequently, the aircraft… - [NTSB MIA86LA183](https://openairdocs.org/ntsb/MIA86LA183.md): Air Tractor AT-301 · Vaiden, MS · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N23930 · Substantial damage > The plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest… - [NTSB LAX86LA257](https://openairdocs.org/ntsb/LAX86LA257.md): Cessna 182L · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N3496R · Substantial damage > A acft collided with a gravel pile after overrunning the 2,070 ft asphalt rwy. The plt indicated that the wind sock at the arpt was indicating a variable wind direction from 200 deg to 230 deg. The plt elected to land on rwy 12. He stated he would have had… - [NTSB ATL86LA172](https://openairdocs.org/ntsb/ATL86LA172.md): Beech BE-58 · Dillon, SC · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N2034Z · Substantial damage > During landing roll, the plt reported, the rwy surface was wet and he was unable to stop the acft before departing the paved surface. According to published landing procedures, the plt would have needed aprx 1439 ft of paved surface for the landing roll. The… - [NTSB ANC86LA075](https://openairdocs.org/ntsb/ANC86LA075.md): Cessna 180 · Tanunak, AK · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N3887C · Substantial damage > The plt stated that after touchdown he lost directional control of the acft which resulted in a ground loop and nose over. - [NTSB ANC86FA074](https://openairdocs.org/ntsb/ANC86FA074.md): Maule M-5-235C · Volkmar Lake, AK · Accident · 1 fatal · Field investigation · Final report · Jun 13, 1986 · N413X · Substantial damage > After touchdown the pilot lost directional control of the aircraft causing the right wingtip to strike the water. The aircraft then rolled over and sank. The PIC was operating the aircraft and carrying passengers with only student pilot certificate. - [NTSB LAX86LA250](https://openairdocs.org/ntsb/LAX86LA250.md): Boeing A75N1 · Colusa, CA · Accident · No injuries · Limited investigation · Final report · Jun 12, 1986 · N68467 · Substantial damage > The plt was practicing takeoffs and landings when the acft's landing gear caught a berm on short final and the acft nosed over. The plt stated that there was no mechanical failure or malfunction of the acft. - [NTSB BFO86LA035](https://openairdocs.org/ntsb/BFO86LA035.md): Piper PA-23-250 · Mt. Holly, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1986 · N6264Y · Substantial damage > The nose gear was sheared off when the acft contacted a ditch during an overrun landing. Upon arriving at the pvt airstrip the plt circled the rwy and decided it was suitable for landing. Touchdown was made 400 ft down the rwy and normal deceleration was… - [NTSB CHI86LA152](https://openairdocs.org/ntsb/CHI86LA152.md): Piper PA-28-181 · Belleville, MI · Accident · No injuries · Limited investigation · Final report · Jun 10, 1986 · N5369F · Substantial damage > The plt aware she was ld on a 1750' wet grass strip elected to ld over high tension lines in calm wind. Pilot made two approaches and ld on third. Pilot aware of poor braking action turned off ignition. Acft ran off end of rwy and struck a ditch. - [NTSB ANC86IA069](https://openairdocs.org/ntsb/ANC86IA069.md): Piper PA-31-350 · Nulato, AK · Incident · No injuries · Incident investigation · Final report · Jun 10, 1986 · N41078 · Minor damage > A witness on the ground watched the airplane fly the landing pattern for landing and at no time did he see the landing gear extend. He watched the airplane until it passed below the tree line. Testing of the hydro-mechanical and electrical systems did not… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=413 ## 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=412 --- 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.