# 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 418 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MIA86LA065](https://openairdocs.org/ntsb/MIA86LA065.md): Piper PA-32-300 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Jan 24, 1986 · N2947U · Substantial damage > The plt stated that on his landing rollout he lost control of the acft & veered off the left side of rwy 9L collapsing the nose gear. - [NTSB FTW86LRA05](https://openairdocs.org/ntsb/FTW86LRA05.md): Cessna 172 · Tomball, TX · Accident · No injuries · Final report · Jan 24, 1986 · N98523 · Substantial damage > The acft veered off the left side of the rwy during landing. The nose wheel dug into mud and the acft nosed over. The plt said he was unable to correct the violent turn to the left. - [NTSB MIA86LA063](https://openairdocs.org/ntsb/MIA86LA063.md): Cessna 310J · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Jan 23, 1986 · N12DS · Substantial damage > The pilot/owner reported that he had the left main landing gear repaired twice previously due to left gear collapses upon landing. He also stated that he had just picked up the aircraft from the mechanic performing the last repair. When upon the first landing… - [NTSB CHI86LA076](https://openairdocs.org/ntsb/CHI86LA076.md): Cessna 177 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jan 23, 1986 · N3244T · Substantial damage > The student pilot flared too high, damaging the aircraft upon touchdown. - [NTSB NYC86LA063](https://openairdocs.org/ntsb/NYC86LA063.md): Luscombe 8B · Turin, NY · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N25119 · Substantial damage > The personal flight from oswego, NY to Turin, NY was uneventful and without problems. However while landing in soft snow, the right ski dug into the soft snow. The landing gear failed and the aircraft nosed over onto its back and was substantially damaged.… - [NTSB FTW86LA037](https://openairdocs.org/ntsb/FTW86LA037.md): Boeing A75N1 · Yukon, OK · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N4935N · Substantial damage > The left brake locked after the aircraft rolled a short distance during landing. Aircraft slowed until about 20 mph forward speed and then flipped inverted and stopped. Post accident examination revealed the brake shoe return spring on the left brake was… - [NTSB NYC86LA073](https://openairdocs.org/ntsb/NYC86LA073.md): Piper PA-28-161 · West Dover, VT · Accident · No injuries · Limited investigation · Final report · Jan 17, 1986 · N8360W · Substantial damage > During the landing roll on ice covered runway the aircraft ran off the departure end of the runway and collided with a snow bank. - [NTSB NYC86LA062](https://openairdocs.org/ntsb/NYC86LA062.md): Cessna 172 · Durhamville, NY · Accident · No injuries · Limited investigation · Final report · Jan 16, 1986 · N5456T · Substantial damage > The flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided… - [NTSB DEN86LA065](https://openairdocs.org/ntsb/DEN86LA065.md): Piper PA-28R-200 · Sterling, CO · Accident · No injuries · Limited investigation · Final report · Jan 16, 1986 · N33535 · Substantial damage > According to the plt, during the checkride for his commercial plt certificate, the flt examiner gave him a simulated electrical failure & turned the landing lights off. The plt stated that during the night landing flare, he lost visual reference with the rwy… - [NTSB BFO86LA013](https://openairdocs.org/ntsb/BFO86LA013.md): Piper PA-28-161 · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Jan 16, 1986 · N4325V · Substantial damage > The student pilot stated that uneven braking during landing caused the aircraft to swerve off the side of the runway. He further added that he applied full power shortly thereafter due to the fact that the aircraft was heading for a ditch. The aircraft… - [NTSB SEA86LA040](https://openairdocs.org/ntsb/SEA86LA040.md): Cessna 501 · North Bend, WA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1986 · N414CB · Substantial damage > While on final the fss gave the pilot the current winds and the favored runway. The pilot was attempting to land the aircraft on runway 04 with a right gusting quartering tail wind and wet runway. Hydroplaning occurred and the pilot elected to go-around when… - [NTSB SEA86LA038](https://openairdocs.org/ntsb/SEA86LA038.md): Cessna 150-M · Mead, WA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1986 · N714AQ · Substantial damage > The pilot was attempting to land on the runway which was covered with 11 inches of snow. The main gear dug into the snow and the right wing tip caught turning the aircraft sideways. - [NTSB CHI86LA065](https://openairdocs.org/ntsb/CHI86LA065.md): Cessna 152 · Warren, MN · Accident · No injuries · Limited investigation · Final report · Jan 14, 1986 · N95636 · Substantial damage > The pilot overflew the runway & observed some snow on the left hand side of the runway. During the landing the aircraft drifted to the left, collided with a finger drift & nosed over. - [NTSB MKC86LA051](https://openairdocs.org/ntsb/MKC86LA051.md): Beech V35 · Bassett, NE · Accident · No injuries · Limited investigation · Final report · Jan 13, 1986 · N376B · Substantial damage > While landing his acft at Bassett, Nebraska the plt rptd a gust of wind hit the acft fm behind and he lost directional control veering off into a snow bank. The plt stated that two witnesses who were walking near the rwy told him no wind was blowing when the… - [NTSB DEN86LA064](https://openairdocs.org/ntsb/DEN86LA064.md): Cessna 172P · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jan 13, 1986 · N51238 · Substantial damage > The acft contacted a snowbank following a loss of directional control during landing. This was the plt's first landing on his second solo flt. Previous to this landing, the student had been practicing landing on rwy 17 with his CFI. - [NTSB NYC86LA059](https://openairdocs.org/ntsb/NYC86LA059.md): Cessna 152 · Bennington, VT · Accident · No injuries · Limited investigation · Final report · Jan 12, 1986 · N49653 · Substantial damage > After flying in the Bennington, Vermont area for awhile, the pilot decided to land for refueling. On landing the flight encountered strong gusty winds. The aircraft was pushed off to the side of the runway, before pilot could correct for the wind. The… - [NTSB MIA86LA058](https://openairdocs.org/ntsb/MIA86LA058.md): Mooney M20F · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Jan 12, 1986 · N9326V · Substantial damage > The plt stated that when he extended his landing gear all seemed normal except he did not get a green light, he recycled the gear with the same result & then flew by the tower & they stated that the gear appeared to be down, but upon touchdown after a ground… - [NTSB FTW86FPA14](https://openairdocs.org/ntsb/FTW86FPA14.md): Piper PA-32-300T · Saginaw, TX · Accident · No injuries · Final report · Jan 11, 1986 · N82072 · Substantial damage > Pilot long departed big spring, Texas with two passengers VFR to Saginaw airport, Saginaw, Texas. The pilot was flying to mwl, VOR 065 radial, descending to pattern altitude at Saginaw airport. The pilot said he had not been to that airport previously. Heavy… - [NTSB MKC86LA047](https://openairdocs.org/ntsb/MKC86LA047.md): Piper PA-32R-300 · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Jan 9, 1986 · N38127 · Substantial damage > The plt stated he mistook an ice and snow covered area for a taxiway and turned off past the actual taxiway. The acft struck a snowbank which collapsed the nosegear. The blue taxiway light was out. This light marks the edge of taxiway. The taxiway was free of… - [NTSB ATL86IA054](https://openairdocs.org/ntsb/ATL86IA054.md): Boeing 727-232 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Jan 9, 1986 · N403DA · Minor damage > The aircrew rprtd that when the landing gear was retracted after takeoff, the l main gear indicated unsafe & there was an unsafe door indication. They recycled the gear, but observed the same indications. The gear handle was then put in the neutral psn & the… - [NTSB CHI86LA060](https://openairdocs.org/ntsb/CHI86LA060.md): Cessna 172M · Anderson, IN · Accident · No injuries · Limited investigation · Final report · Jan 6, 1986 · N8521X · Substantial damage > The acft touched down hard on the nose gear during a x-wind landing. The plt reported the acft dropped to the rwy from an alt of aprx 10 ft AGL. Reported winds at the time of the accident were from 240 degs at 15 KTS gusting to 23 KTS. - [NTSB BFO86FA012](https://openairdocs.org/ntsb/BFO86FA012.md): Cessna R182 · Leesburg, VA · Accident · No injuries · Field investigation · Final report · Jan 6, 1986 · N6375T · Substantial damage > The acft dptd dca with 4508,70GAL fuel,and 43LBS equipmt on board which computed out to be 26LBS over max gross. It was flown directly to Leesburg,VA where the winds were generally out of the west and there was the potential for windshear w/i 2000AGL. Both… - [NTSB DEN86LA063](https://openairdocs.org/ntsb/DEN86LA063.md): Cessna 150H · West Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jan 4, 1986 · N23148 · Substantial damage > According to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt. - [NTSB CHI86MA056](https://openairdocs.org/ntsb/CHI86MA056.md): Mcdonnell Douglas DC-10-10 · Detroit, MI · Incident · No injuries · Major investigation · Final report · Jan 3, 1986 · N101AA · No damage > N101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step… - [NTSB CHI86LA057](https://openairdocs.org/ntsb/CHI86LA057.md): Israel Aircraft Industries 1124A · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jan 3, 1986 · N420W · Substantial damage > On the second approach to rwy 22R the private pilot (in the left seat) attempted to land. The right main gear hit hard and the acft bounced coming down on the left wing tip. The acft then hit on its right main gear, then the left main gear. The right main… - [NTSB MKC86LA044](https://openairdocs.org/ntsb/MKC86LA044.md): Piper PA-28R-180 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jan 1, 1986 · N4682J · Substantial damage > The pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He… - [NTSB CHI86LA055](https://openairdocs.org/ntsb/CHI86LA055.md): Cessna 170A · Grygla, MN · Accident · No injuries · Limited investigation · Final report · Dec 31, 1985 · N3828V · Substantial damage > The aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The… - [NTSB MKC86LA040](https://openairdocs.org/ntsb/MKC86LA040.md): Beech C23 · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · Dec 30, 1985 · N67248 · Substantial damage > The aircraft landed on runway 13 because the n-s runway was covered with ice. The wind was from 220 degrees at 16, gusts to 24 knots. The aircraft bounced twice during the landing and drifted left. The aircraft encountered snow along the left side of the… - [NTSB CHI86LA059](https://openairdocs.org/ntsb/CHI86LA059.md): Cessna 180J · Hibbing, MN · Accident · No injuries · Limited investigation · Final report · Dec 30, 1985 · N180HS · Substantial damage > The plt landing in a direct 90 deg x-wind, lost directional control, struck a snowbank and nosed over inverted. - [NTSB NYC86LA056](https://openairdocs.org/ntsb/NYC86LA056.md): Piper PA-28-140 · Frankfort, NY · Accident · No injuries · Limited investigation · Final report · Dec 29, 1985 · N9949W · Substantial damage > The plt diverted to Frankfort-highland en route from his original destination of utica, NY, because of IFR weather at utica. The plt stated that as the nose wheel settled to the rwy during touchdown, it dug into snow on the rwy and the acft nosed over. It was… - [NTSB DEN86LA057](https://openairdocs.org/ntsb/DEN86LA057.md): Cessna 172P · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1985 · N96321 · Destroyed > The acft drifted off the runway during the flare/touchdown phase of ldg due to plt failure to correct for a 20 kt xwind condition. The plt attempted to make a go-around at a low a/s and with ldg flaps (25 degrees) extended, resulting in loss of control and… - [NTSB CHI86LA054](https://openairdocs.org/ntsb/CHI86LA054.md): Beech G18S · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Dec 29, 1985 · N100VE · Substantial damage > The aircraft collided with a snowbank while goundlooping after landing at the completion of a cargo flight from chicago ill. The winds were calm. The pilot stated that he needed to take timely and sufficient action. - [NTSB NYC86LA054](https://openairdocs.org/ntsb/NYC86LA054.md): Cessna 150K · Marlboro, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1985 · N5915J · Substantial damage > The acft encountered what the plt described as a strong gust of wind on landing. The plt stated he experienced a wind shift of aprx 45 degs. The acft touched down fast and during subsequent bouncing the nose gear collapsed. The winds, according to the plt,… - [NTSB ANC86LA021](https://openairdocs.org/ntsb/ANC86LA021.md): Cessna 180 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Dec 27, 1985 · N3186D · Substantial damage > The plt stated, during a touch and go landing he lost directional control of the acft and a ground loop resulted. - [NTSB NYC86LA053](https://openairdocs.org/ntsb/NYC86LA053.md): Piper PA-28-235 · Mttituck, NY · Accident · No injuries · Limited investigation · Final report · Dec 26, 1985 · N9409W · Substantial damage > Pilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft… - [NTSB DEN86LA052](https://openairdocs.org/ntsb/DEN86LA052.md): Gulfstream American AA-1A Yankee · Cloudcroft, NM · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1985 · N9201L · Substantial damage > The plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg… - [NTSB DEN86LA053](https://openairdocs.org/ntsb/DEN86LA053.md): Cessna 172A · Anthony, NM · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N7451T · Substantial damage > The plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained… - [NTSB ATL86LA047](https://openairdocs.org/ntsb/ATL86LA047.md): Cessna 177RG · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N1603H · Substantial damage > The aircraft landed hard resulting in substantial damage to the aircraft. This was following a final approach which was flown high and fast. The aircraft was observed to stall approximatel 10 ft above the runway and land on the nose gear. - [NTSB ANC86LA019](https://openairdocs.org/ntsb/ANC86LA019.md): Bellanca 7GCAA · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N9533S · Substantial damage > The pilot stated that during the touch and to landing, the aircraft stalled approximately 20 feet in the air. The pilot was trying the slow the aircraft down for a short field landing when it stalled. - [NTSB FTW86FPA10](https://openairdocs.org/ntsb/FTW86FPA10.md): Bell BH206L-1 · Hurst, TX · Accident · No injuries · Final report · Dec 20, 1985 · N1069Q · Substantial damage > The instructor plt was demonstrating an autorotation from the 'top of the height-velocity' curve. The CFI zeroed the airspeed and entered the autorotation at an alt of aprx 400 ft AGL. The acft touched down hard, spreading the skids, severing the tail boom… - [NTSB DEN86LA051](https://openairdocs.org/ntsb/DEN86LA051.md): Cessna 172N · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N7609F · Substantial damage > According to the student plt he made a normal apch to landing. The runway had not been cleared of snow to its full width. The acft's left wheel touched the snow pulling the acft off the rwy and the acft flipped over. - [NTSB CHI86LA051](https://openairdocs.org/ntsb/CHI86LA051.md): Fairchild SA226TC · Cleveland, OH · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N334BA · Substantial damage > The crew obtained visual contact with the rw evironment 100 ft above dh. During the landing roll the a/c traveled along the left edge of the runway until it collided with a snow bank. The runway was covered with patches of ice and packed snow. - [NTSB ANC86LA018](https://openairdocs.org/ntsb/ANC86LA018.md): Cessna 185 · Aleknagik, AK · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N4520F · Substantial damage > The pilot stated that on landing at a frozen lake he lost control of the aircraft causing the plane to ground loop. The aircraft then struck a snow bank on the beach. - [NTSB MIA86LA046](https://openairdocs.org/ntsb/MIA86LA046.md): Beech C-18S · Deland, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 1985 · N64463 · Substantial damage > The pilot in the right seat was making his first landing in that make and model of aircraft. During the landing roll he tried to raise the wing flaps lever. Instead, he raised the landing gear lever causing the landing gear to retract. - [NTSB LAX86LA071](https://openairdocs.org/ntsb/LAX86LA071.md): Cessna 152 · Arbuckle, CA · Accident · No injuries · Limited investigation · Final report · Dec 19, 1985 · N4946H · Substantial damage > The 35-HR student plt was authorized to fly on a solo instructional flight to the colusa county arpt. But, for 'personal reasons' the student disobeyed his CFI & landed at an uncharted, gravel, private airstrip. During landing roll out the student failed to… - [NTSB ANC86LA017](https://openairdocs.org/ntsb/ANC86LA017.md): Cessna C-177RG · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Dec 17, 1985 · N2191Q · Substantial damage > While performing slow flight maneuvers, the student applied power with no response. Various combinations of controls produced no further response from the engine. The instructor and student completed a forced landing in a furrowed clearing at night. - [NTSB MKC86LA035](https://openairdocs.org/ntsb/MKC86LA035.md): Piper PA-28RT-201 · Aurora, MO · Accident · No injuries · Limited investigation · Final report · Dec 16, 1985 · N83956 · Substantial damage > The pilot stated there was patches of snow and ice on the runway surface a snow on the sides and as he pulled up the flaps, the airplane veered right, off the runway. He said that after he got the airplane back on the runway, it ground- looped to the left and… - [NTSB ATL86LA043](https://openairdocs.org/ntsb/ATL86LA043.md): Piper PA-31T · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · Dec 16, 1985 · N4445K · Substantial damage > During landing roll the landing gear collapsed and the acft skidded to a stop on the rwy. The acft was substantially damaged and the plt was not injured. A witness stated that he observed the landing gear in the down position while the acft was in the traffic… - [NTSB ANC86LA015](https://openairdocs.org/ntsb/ANC86LA015.md): Douglas DC-3C · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Dec 16, 1985 · N777YA · Substantial damage - [NTSB DEN86LA045](https://openairdocs.org/ntsb/DEN86LA045.md): Cessna 150L · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N19409 · Substantial damage > According to the CFI, during a touch & go landing, the student allowed the acft to drift to the left side of the rwy where it contacted a snow bank. The CFI stated she failed to correct for the drift soon enough to prevent the accident. The landing was being… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=419 ## 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=418 --- 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.