# 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 415 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MKC86LA095](https://openairdocs.org/ntsb/MKC86LA095.md): Cessna 150D · Marshfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N4169U · Substantial damage > The pilot stated that the approach speed was faster than normal due to erroneous airspeed indications. The aircraft floated upon flaring and the pilot raised the flaps. He states that the aircraft lost lift, bounced after a hard landing and subsequently… - [NTSB MIA86LA131](https://openairdocs.org/ntsb/MIA86LA131.md): Beech 95-B55 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N6272V · Substantial damage > Plt extended landing gear while in the landing flare. The aircraft settled onto the landing gear doors as the landing gear was extending which prevented the landing gear from extending. The aircraft then settled onto its belly and skidded off the runway. - [NTSB MIA86LA127](https://openairdocs.org/ntsb/MIA86LA127.md): Consolidated Aeronautics Lake LA-4-200 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N6155V · Substantial damage > The plt stated that on landing the acft started to porpoise. He lost control, the landing gear collapsed and the acft slid to a stop on the rwy. - [NTSB FTW86LA071](https://openairdocs.org/ntsb/FTW86LA071.md): Cessna TU206G · Tomball, TX · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N6272Z · Substantial damage > The pilot reported that he failed to flare the aircraft when he touched down during landing at Tomball, TX. The aircraft bounced twice and the nosewheel dug into the dirt strip causing the aircraft to noseover. - [NTSB CHI86LA125](https://openairdocs.org/ntsb/CHI86LA125.md): Piper PA-44-180 · Noblesville, IN · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N39693 · Substantial damage > Two successful takeoffs and landings had previously been completed during the training flight. On the approach for the third landing, the crew received a three-green indication, but after touchdown, the nose gear folded and the aircraft settled on its nose.… - [NTSB FTW86LA069](https://openairdocs.org/ntsb/FTW86LA069.md): Piper PA-28 · Keller, TX · Accident · No injuries · Limited investigation · Final report · Apr 21, 1986 · N8376R · Substantial damage > The pilot reported colliding with a ditch along side the runway at goode airport in Keller, TX, when he failed to maintain directional control on landing. There was substantial damage to the aircraft when the impact tore off the left strut, causing the left… - [NTSB CHI86LA123](https://openairdocs.org/ntsb/CHI86LA123.md): Cessna 182 · Augusta, WI · Accident · No injuries · Limited investigation · Final report · Apr 21, 1986 · N94586 · Substantial damage > The pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees… - [NTSB NYC86LA108](https://openairdocs.org/ntsb/NYC86LA108.md): Piper PA-28-181 · Matawan, NJ · Accident · No injuries · Limited investigation · Final report · Apr 20, 1986 · N47355 · Substantial damage > The local sightseeing flight departed marlboro airport at about 1300 hours and returned at about 1400 hours. Entered pattern downwind and flew a normal pattern and approach. During flare, the aircraft was hit by a gust of wind. After touchdown and during… - [NTSB MIA86LA128](https://openairdocs.org/ntsb/MIA86LA128.md): Adams A55 · Alachua, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1986 · N10600 · No damage > The plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg. - [NTSB ATL86FA116](https://openairdocs.org/ntsb/ATL86FA116.md): Cessna 150M · Gaston, SC · Accident · Minor injuries · Field investigation · Final report · Apr 19, 1986 · N714PU · 2 aircraft · Substantial damage > Two aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew… - [NTSB MIA86LA124](https://openairdocs.org/ntsb/MIA86LA124.md): Cessna 172N · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Apr 18, 1986 · N121SU · Substantial damage > The private pilot with a total of 36.2 hours of logged flight time, stated that she landed hard on the nose wheel and the nose strut failed during a full stop landing. - [NTSB FTW86LA067](https://openairdocs.org/ntsb/FTW86LA067.md): Piper PA-28-181 · Mt. Vernon, TX · Accident · No injuries · Limited investigation · Final report · Apr 17, 1986 · N2122L · Substantial damage > The pilot reported landing at above normal speed, when he lost control of the aircraft at touchdown. The aircraft then veered off the runway onto wet grass. Do to the slippery conditions, the aircraft began sliding until it collided with a fence 100 feet from… - [NTSB ANC86LA046](https://openairdocs.org/ntsb/ANC86LA046.md): Piper PA-18-150 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Apr 15, 1986 · N4482E · Substantial damage > The pilot stated that while doing a series of touch and go's, the aircraft veered on the runway; the pilot lost directional control of the aircraft causing the plane to nose over on its back. - [NTSB NYC86LA104](https://openairdocs.org/ntsb/NYC86LA104.md): Piper PA-32-300 · Doylestown, PA · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 1986 · N41AR · Substantial damage > The pilot made a long landing and ran off the end of the runway. After departing the runway, he ran through a fence and hit a dirt embankment. The pilot said when he realized he was going off the end of the runway, he stayed on the brakes rather than add… - [NTSB ATL86LA112](https://openairdocs.org/ntsb/ATL86LA112.md): Cessna 150 · Orangeburg, SC · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1986 · N714DC · Substantial damage > During landing the student pilot lost directional control of the aircraft in a crosswind and ran off the side of the runway and into a drainage ditch. - [NTSB ANC86LA044](https://openairdocs.org/ntsb/ANC86LA044.md): Cessna 120 · Lake George, AK · Accident · No injuries · Limited investigation · Final report · Apr 13, 1986 · N3008N · Substantial damage > The pilot stated that during a three point landing the main landing gear broke through a thin layer of ice into approximately six inches of snow and then the aircraft went over on its back. - [NTSB SEA86LA103](https://openairdocs.org/ntsb/SEA86LA103.md): Cessna 172 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N5786T · Substantial damage > The student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots. - [NTSB SEA86LA102](https://openairdocs.org/ntsb/SEA86LA102.md): Bellanca 7GCBC · Harlen, OR · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N88415 · Destroyed > The acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land. - [NTSB MKC86LA092](https://openairdocs.org/ntsb/MKC86LA092.md): Cessna 172P · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N63177 · Substantial damage > The plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of… - [NTSB LAX86LA174](https://openairdocs.org/ntsb/LAX86LA174.md): Cessna 172N · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N6235D · Substantial damage > The plt lost control of the acft during a touch and go maneuver and ran off the rwy. After touchdown the acft lifted back off the ground and drifted right. The acft then settled and touched down on the right shoulder of the rwy. The plt then noticed a… - [NTSB FTW86LQG14](https://openairdocs.org/ntsb/FTW86LQG14.md): Piper PA-36-400 · Semonole, TX · Accident · Minor injuries · Final report · Apr 12, 1986 · N2401Z · Substantial damage > The acft nosed over during landing. The plt stated that he landed straight in to the south in a 45 degree tailwind. The landing was made on a dirt strip after an aerial application flt. - [NTSB DEN86LA122](https://openairdocs.org/ntsb/DEN86LA122.md): RJB Skybolt A-1 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N42RJ · Substantial damage > The plt reported that the acft encountered a ridge on the rwy during the landing roll and swerved off the side. He said weather was not a factor. An FAA ops inspector examined the rwy after the acdnt and could not locate the reported ridge. - [NTSB CHI86LA124](https://openairdocs.org/ntsb/CHI86LA124.md): Hughes 269A · Lowell, MI · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N8059H · Substantial damage > The pilot had just completed two autorotations when he landed hard on the third. The main rotor flexed down severing the tailboom and tailrotor. Although the pilot had logged over 6000 hours flight time, he had only 51 hours total rotorcraft time. He had… - [NTSB DEN86LA114](https://openairdocs.org/ntsb/DEN86LA114.md): Aerotek PITTS-S-1S · Loveland, CO · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1986 · N14RN · Substantial damage > According to the plt, the acft encountered a tailwind during the landing roll. The plt said the acft nosed over onto its back when he applied brakes. The plt had indicated his total flt experience in this tail wheel acft to be aprx 4 hrs. - [NTSB CHI86FEE02](https://openairdocs.org/ntsb/CHI86FEE02.md): Cessna 182Q · Lansing, IL · Accident · Serious injuries · Final report · Apr 11, 1986 · N94531 · Substantial damage > While on the return flt to Lansing, IL, the plt checked the midway ATIS for info. He believed that just before landing at the Lansing muni arpt, the wind had shifted to the east. According to witnesses, the acft touched down on the last 1/3 of the 2432 ft… - [NTSB LAX86LA172](https://openairdocs.org/ntsb/LAX86LA172.md): Cessna 182 · Jackson, CA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N9875E · Substantial damage > The acft went out of control and collided with terrain during a landing roll on rwy 19. The plt stated that a gust of wind lifted the right wing during the landing roll and the acft departed the rwy and collided with a ditch. The plt reported that the winds… - [NTSB MIA86LA116](https://openairdocs.org/ntsb/MIA86LA116.md): Beech BE-95 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N17AT · Substantial damage > The acft had not been flown in over 2 yrs & the last annual inspection was performed 1-25-83. The acft had to be jump started due to a dead battery. During ldg roll-out, the gear collapsed. An exam of the bottom of the acft revealed damage consistent with the… - [NTSB LAX86LA166](https://openairdocs.org/ntsb/LAX86LA166.md): Piper PA-23-250 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N3872E · Substantial damage > The pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading. - [NTSB FTW86LA065](https://openairdocs.org/ntsb/FTW86LA065.md): Temco GC-1B · Del Rio, TX · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N2360B · Substantial damage > The student pilot was being instructed in the landing of a tail dragger aircraft, when he lost control of the aircraft at touchdown. The instructor failed to take corrective action when the student pilot inadvertently applied left brake, causing the aircraft… - [NTSB DEN86LA111](https://openairdocs.org/ntsb/DEN86LA111.md): Cessna 170B · St George, UT · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N2436D · Substantial damage > The plt stated the acft encountered a crosswind and ground looped during the landing touchdown. - [NTSB CHI86FA119](https://openairdocs.org/ntsb/CHI86FA119.md): Boeing 737-222 · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Apr 8, 1986 · N9054U · Substantial damage > The left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and… - [NTSB BFO86LA022](https://openairdocs.org/ntsb/BFO86LA022.md): Cessna 152II · Clinton, MD · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N757JZ · Substantial damage > The acft nosed over following a loss of control during touchdown. The student plt stated the acft bounced after touching down on all three landing gears. The pilot stated she may have panicked and pushed the control yoke forward. The acft touched down on the… - [NTSB MIA86LA114](https://openairdocs.org/ntsb/MIA86LA114.md): Cessna 177RG · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 7, 1986 · N35911 · Substantial damage > The plt stated that on final apch he extended the landing gear but on touchdown the gear completely collapsed. Post crash examination of the acft revealed that the alternator belt was loose allowing the battery to drain down enough so the electric hydraulic… - [NTSB SEA86LA094](https://openairdocs.org/ntsb/SEA86LA094.md): Grumman AA-5A · Aberdeen, ID · Accident · No injuries · Limited investigation · Final report · Apr 6, 1986 · N26792 · Substantial damage > The student plt was attempting to land on rwy 25 with a light x-wind form 040 degs at 5 KTS. The plt allowed the acft to drift to the left of the narrow rwy. As full pwr was added in an attempt to go-around, the acft struck the ground, veered left through a… - [NTSB MIA86LA118](https://openairdocs.org/ntsb/MIA86LA118.md): Piper PA-28R-200 · Umatilla, FL · Accident · No injuries · Limited investigation · Final report · Apr 6, 1986 · N2662R · Substantial damage > The plt reported that he flared the acft too high while landing. The acft stalled too soon and a hard landing resulted. - [NTSB CHI86LA116](https://openairdocs.org/ntsb/CHI86LA116.md): Cessna 172M · Seneca, IL · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 1986 · N6829H · Substantial damage > The plt was landing on a 2300 ft rwy with a 80 degree x-wind. The acft bounced hard on touchdown and the plt attempted a go-around with 25 degrees of flaps extended. The airspeed was deteriorating so the plt elected to re-land. During the roll-out the acft… - [NTSB LAX86LA168](https://openairdocs.org/ntsb/LAX86LA168.md): Cessna 140 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N89374 · Substantial damage > The purpose of the dual instructional flight was for the instructor pilot to check out a private pilot in the conventional gear Cessna 140 aircraft. After a series of uneventful full stop & touch & go landings, the student was directed to land. The CFI & a… - [NTSB CHI86LA118](https://openairdocs.org/ntsb/CHI86LA118.md): Cessna 411 · Bloomington, IN · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N3213R · Substantial damage > The plt rprtd that while while on final apch to rwy 35, the acft encountered 'extreme wind-shift' & was blown about 550' rgt of course with a 30 kt loss of airspeed (fm 130 to 100 KTS). He stated the acft lost about 300', then was blown back on course with an… - [NTSB ATL86LA106](https://openairdocs.org/ntsb/ATL86LA106.md): Aeronca 7AC · Hamilton, OH · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N84394 · Substantial damage > The plt made a low pass over the drag strip to check the wind. He climbed, made a 180 deg turn and attempted a normal landing. On roll out a wind gust was encountered which tipped the acft up on the right wheel. It veered off the hard surface into a guard… - [NTSB MKC86LA079](https://openairdocs.org/ntsb/MKC86LA079.md): Cessna 172 · Ness City, KS · Accident · No injuries · Limited investigation · Final report · Apr 4, 1986 · N9866G · Substantial damage > The pilot was landing to the north with a wind from the west-northwest at 15 knots, gusting to 20 knots. The pilot stated that he had full aileron into the wind and despite this action, the wing raised up by a strong gust and airplane flipped over to the… - [NTSB LAX86LA164](https://openairdocs.org/ntsb/LAX86LA164.md): Cessna 150H · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 3, 1986 · N50306 · Substantial damage > The pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the… - [NTSB LAX86LA150](https://openairdocs.org/ntsb/LAX86LA150.md): Cessna 172M · Rosamond, CA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1986 · N666BH · Substantial damage > The plt reported that he successfully touched down during conditions of a right, 90 deg. Crosswind. The plt stated that a gust was then encountered which 'weather cocked' his acft. As he attempted to realign the acft with the rwy the downwind wing contacted… - [NTSB CHI86IA115](https://openairdocs.org/ntsb/CHI86IA115.md): Boeing 757-251 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Apr 3, 1986 · N508US · Minor damage > N508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.… - [NTSB ATL86LA104](https://openairdocs.org/ntsb/ATL86LA104.md): Cessna 152 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · Apr 3, 1986 · N93589 · Substantial damage > During landing roll the student pilot lost directional control of the aircraft and collided with a tree adjacent to the runway. - [NTSB LAX86LA162](https://openairdocs.org/ntsb/LAX86LA162.md): Cessna 182J · Saint Johns, AZ · Accident · No injuries · Limited investigation · Final report · Apr 2, 1986 · N2691F · Substantial damage > The plt said his wx briefing indcd VFR conds along the route with ocnl thunderstorm (tstm) activity that might require diversion. As he was apchg the st Johns arpt, the plt saw tstms & ovrcst clds ahead & decided to land & wait for the wx to improve. The… - [NTSB SEA86LA091](https://openairdocs.org/ntsb/SEA86LA091.md): Cessna T210C · Boise, ID · Accident · No injuries · Limited investigation · Final report · Mar 31, 1986 · N3423F · Substantial damage > While attempting to land on a parallel runway, the aircraft encountered wake turbulence from a landing transport aircraft. The aircraft rolled and struck the ground hard. A successful go around was then made with an uneventful landing. The pilot was aware of… - [NTSB CHI86FEC03](https://openairdocs.org/ntsb/CHI86FEC03.md): Cessna U-206B · Tecumseh, MI · Accident · No injuries · Final report · Mar 31, 1986 · N3855G · Substantial damage > The acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing. - [NTSB MKC86LA076](https://openairdocs.org/ntsb/MKC86LA076.md): Bellanca 7GCBC · St.Charles, MO · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N5055G · Substantial damage > The PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which… - [NTSB DEN86LA109](https://openairdocs.org/ntsb/DEN86LA109.md): Taylorcraft BC12D · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N43139 · Substantial damage > The plt stated that he was performing touch & go landings. When the accident occurred. On the first landing a wind gust raised the right wing. The plt stated he 'tried to straighten out' the acft when it went off the right side of the rwy. The left main… - [NTSB ATL86FEI03](https://openairdocs.org/ntsb/ATL86FEI03.md): Cessna 170B · Columbia Stat., OH · Accident · Minor injuries · Final report · Mar 30, 1986 · N2894C · Substantial damage > The acft made a hard landing during which the left main gear was sheared off at the fuselage. Weather was not a factor. In the 90 days preceding this accident the plt had only flown 1 hour in this make & model of acft. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=416 ## 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=415 --- 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.