# 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 434 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB FTW85LA067](https://openairdocs.org/ntsb/FTW85LA067.md): Mitsubishi MU-2B-35 · Robert Lee, TX · Accident · No injuries · Limited investigation · Final report · Dec 2, 1984 · N112SK · Substantial damage > The acft was on ferry flt with a planned stop at Robert Lee arpt. Prior to touchdown, during the flare, the plt saw 3 OR4 deer in the middle of the runway. He banked to the left and prior to adding power to go-around, the acft settled to the ground next to… - [NTSB LAX85LA055](https://openairdocs.org/ntsb/LAX85LA055.md): Cessna 152 · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1984 · N4974B · Substantial damage > Student plt stated, while landing a 45 deg x-wing picked up the wing and flipped acft over. Plt was on a solo x-country flt. - [NTSB CHI85LA061](https://openairdocs.org/ntsb/CHI85LA061.md): Stinson 108-2 · Sterling, IL · Accident · No injuries · Limited investigation · Final report · Dec 1, 1984 · N9370K · Substantial damage > The acft ground looped & cartwheeled while landing during a personal flt. The plt lacked experience in tailwheel type acft. - [NTSB MIA85LA049](https://openairdocs.org/ntsb/MIA85LA049.md): Piper PA-38-112 · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Nov 30, 1984 · N25705 · Substantial damage > Student plt had successfully completed two touch and go landings. On the third landing the acft touched down hard in a three point attitude. A go-around was accomplished and on the last landing, the nose gear collapsed. - [NTSB CHI85LA063](https://openairdocs.org/ntsb/CHI85LA063.md): Cessna 310R · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Nov 30, 1984 · N98995 · Substantial damage > Plt stated that the acft had picked up ice during the descent. He continued to state that he broke out of the clouds at 1600 ft and the windshield was covered with ice. He was able to clear a small area at the bottom of the windshield with the alcohol deice.… - [NTSB MIA85LA048](https://openairdocs.org/ntsb/MIA85LA048.md): Hughes 269C · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1984 · N8993F · Substantial damage > The student plt stated that he was practicing a 'run on' landing. The acft was on the ground and the weight shifted foward on the skid, the right skid dug into soft sod and rolled over. The plt had accumucated a total time of 20 hrs of flt time. - [NTSB LAX85LA053](https://openairdocs.org/ntsb/LAX85LA053.md): Donald W Devine Executive · Tracy, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1984 · N4853A · Destroyed > The homebuilt helicopter crashed while on an unauthorized solo flight. The plt stated that after he completed building the helicopter he acquired proficiency by operating the eng & hovering about in his 3 acre backyard. He said he had flown for about 45 mins… - [NTSB CHI85LA057](https://openairdocs.org/ntsb/CHI85LA057.md): Piper PA-28RT-201 · Blaine, MN · Accident · No injuries · Limited investigation · Final report · Nov 26, 1984 · N8336V · Destroyed > Investigation revealed that the plt landed the acft on rwy 35 with winds from 130 degrees at 15 KTS gusting to 23 KTS. The acft departed the end of the 4900 ft rwy where the left fuel tank was ruptured and a fire erupted. - [NTSB ATL85LA046](https://openairdocs.org/ntsb/ATL85LA046.md): Bell 206B · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1984 · N2756F · Substantial damage > The plt reported that he was conducting 'self refresher autorotation' practice with a student plt in the front left seat to observe. He stated that several autorotations were completed without incident. However, on the final attempt the acft settled through… - [NTSB NYC85LA034](https://openairdocs.org/ntsb/NYC85LA034.md): Cessna 172P · Madison, CT · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N89929 · Substantial damage > Plt stated that as he lowered nose gear to runway following initial touchdown on mains, acft nose continued to drop. Control inputs were not effective. Investigation revealed the nose gear ass'y failed in overload. Based on fuel remaining on board and… - [NTSB MIA85LA045](https://openairdocs.org/ntsb/MIA85LA045.md): Piper PA-32R-301 · Cross City, FL · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N8248D · Substantial damage > Plt stated that after touchdown as braking was initiated the acft began to pull to the left. Right brake was applied with no correcting effect. The acft ran off the left side of the runway and the landing gear collapsed. Post crash exam of brakes revealed no… - [NTSB LAX85LA049](https://openairdocs.org/ntsb/LAX85LA049.md): Pennington-Eaa Biplane P2P · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1984 · N54JP · Substantial damage > The plt reported that during the takeoff phase of a touch-&-go landing he observed sparks coming from the eng's air intake & experienced a loss of power. He pulled off all power & made a hard landing on the rwy. Actc specialists on duty in the tower stated… - [NTSB LAX85FA050](https://openairdocs.org/ntsb/LAX85FA050.md): Cessna 305A · Los Alamitos, CA · Accident · No injuries · Field investigation · Final report · Nov 24, 1984 · N5197G · Substantial damage > The acft nosed over during landing roll. Plt stated he had just completed a glider tow mission and that on touchdown the tail wheel began to shimmy excessively. The acft lifted off and settled back on the rwy, at which time the tail wheel shimmy became worse… - [NTSB MKC85LA025](https://openairdocs.org/ntsb/MKC85LA025.md): Mooney M20F · Rolla, MO · Accident · No injuries · Limited investigation · Final report · Nov 23, 1984 · N6852V · Substantial damage > The student pilot was attempting to land on rwy 09. The wind was rpted to be 180 at 5 KTS. The plt stated that he landed fast and long on the 2,535 ft long rwy. He continued to state that he began braking and realized that he would run off the end of the rwy.… - [NTSB DEN85LA031](https://openairdocs.org/ntsb/DEN85LA031.md): Cessna 150E · Wallsburg, UT · Accident · No injuries · Limited investigation · Final report · Nov 23, 1984 · N2528J · Substantial damage > The acft swerved off the rwy and nosed over after colliding with a dirt bank and a ditch. The plt said that at touchdownon the gravel ranch strip he felt a bump and the acft veered to the edge of the rwy. He added that power was applied forthe go-around but… - [NTSB DEN85LA030](https://openairdocs.org/ntsb/DEN85LA030.md): Luscombe 8E · Oaks, ND · Accident · No injuries · Limited investigation · Final report · Nov 22, 1984 · N2759K · Substantial damage > Plt stated that immediately after touchdown, the right wheel seemed to drag. Right drift was initially corrected by use of opposite aileron to reduce weight on right wheel and rudder for directional control. However, as the acft slowed weight settled on the… - [NTSB ANC85LA020](https://openairdocs.org/ntsb/ANC85LA020.md): Embraer EMB-110 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Nov 20, 1984 · N39174 · Substantial damage > The acft sustained substantial damage when the landing gear collapsed during landing. Tests conducted by the acft operator and acft manufacturer failed to provide any reason for the gear collapse. Both plts stated the gear was down and locked upon touchdown. - [NTSB SEA85LA021](https://openairdocs.org/ntsb/SEA85LA021.md): Cessna 180J · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Nov 19, 1984 · N56BK · Substantial damage > The acft sank after a hard landing on water. The plt reported that the acft bounced during landing and the wind got under the upwind wing and rolled the acft. The wind was reported as 18 KTS with gusts to 25 KTS. - [NTSB NYC85LA030](https://openairdocs.org/ntsb/NYC85LA030.md): Piper PA-28RT-201T · Antrim, NH · Accident · No injuries · Limited investigation · Final report · Nov 19, 1984 · N4379N · Substantial damage > Plt stated, a wind shift occurred on short final resulting in a sudden uncontrollable yaw to the left. Right aileron and full power was added, however, the acft contacted trees before recovery was made. - [NTSB LAX85LA046](https://openairdocs.org/ntsb/LAX85LA046.md): Mooney M20J · Tulelake, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1984 · N5689K · Substantial damage > The plt stated that he was conducting touch and go landings on a road when the left wing struck a 4X4 in wooden speed limit sign post. - [NTSB SEA85LA033](https://openairdocs.org/ntsb/SEA85LA033.md): Cessna 175 · Indian Meadows, ID · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N7380M · Substantial damage > Landed long and acft slid off end of rwy on compact snow and ice contacting a snow berm near end of rwy. - [NTSB CHI85LA051](https://openairdocs.org/ntsb/CHI85LA051.md): Cessna 182H · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N8530S · Substantial damage > Plt stated he was unable to activate the runway lights by radio so visual cues of arpt bldgs were used to line up with runway. Acft lndg/taxi light was inoperative. Plt did not realize he had undershot the approach turn and was, IN fact, lined up to the left… - [NTSB ANC85LA022](https://openairdocs.org/ntsb/ANC85LA022.md): Piper PA-18A 150 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N8678D · Substantial damage > According to the plt, he was making an approach over trees that were ten ft high. After passing the trees he 'chopped' the power & the acft landed hard. He noticed the fuselage was buckled just forward of the vertical fin when he exited the acft. - [NTSB NYC85LA028](https://openairdocs.org/ntsb/NYC85LA028.md): Cessna 150G · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Nov 15, 1984 · N3210J · Substantial damage > While practicing a landing, the acft bounced & touched down hard on the nosewheel. The nose gear collapsed & the right wing & prop were damaged. - [NTSB CHI85LA090](https://openairdocs.org/ntsb/CHI85LA090.md): Beech 58 · Hayward, WI · Accident · No injuries · Limited investigation · Final report · Nov 15, 1984 · N1807W · Substantial damage > The acft sustained subst damage after uncontrolled contact with the rwy during landing. Investigation revealed that the landing was inadvertently attempted at a time when the winds shifted to a direct x-wind with gusts to 35 KTS. - [NTSB MIA85IA032](https://openairdocs.org/ntsb/MIA85IA032.md): Piper PA-34-200 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Nov 13, 1984 · N1053U · Minor damage > The nose cear collapsed during a landing. An exam disclosed that the hydraulic actuator firewall mounting bracket had failed prior to complete extension of the nose gear. Piper service bulletin, sb 413, related to this problem; however, no logbook entry was… - [NTSB MKC85LA020](https://openairdocs.org/ntsb/MKC85LA020.md): Piper PA-38-112 · Burlington, IA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1984 · N2454B · Substantial damage > According to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the… - [NTSB FTW85LA047](https://openairdocs.org/ntsb/FTW85LA047.md): Cessna 152 · Edinburg, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1984 · N94387 · Substantial damage > Following a bounced landing, plt attempted a go-round, but inadvertenly raised the flaps. The acft settled into a plowed field adjacent to the runway and nosed over. - [NTSB ATL85LA033](https://openairdocs.org/ntsb/ATL85LA033.md): Cessna 182RG · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Nov 12, 1984 · N4773S · Substantial damage > Pilot landed the aircraft with the landing gear in the up position. Examination of the landing gear after the accident revealed no evidence of mechanical malfunction or failure that would have prevented normal gear operation. - [NTSB FTW85LA046](https://openairdocs.org/ntsb/FTW85LA046.md): Reed Bandit 1 · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Nov 11, 1984 · N51957 · 2 aircraft · Substantial damage > The homebuilt acft, N52957, was observed to land hard, collapse the landing gear & slide into N3376V holding short of the rwy at an intersecting taxiway. - [NTSB NYC85LA026](https://openairdocs.org/ntsb/NYC85LA026.md): Piper PA-28-181 · Waterford, CT · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N3772M · 2 aircraft · Substantial damage > N3772M (acft 'a') was on lndg roll on runway 15 when N19091 (acft 'b') initiated taxi across the runway. Acft 'a' swerved to avoid collision but inadequate clrnc was available. Right wing of acft 'a' collided with left wing of acft 'b'. Plt of acft 'b' stated… - [NTSB NYC85FGM01](https://openairdocs.org/ntsb/NYC85FGM01.md): Cessna 172P · West Mifflin, PA · Accident · Serious injuries · Final report · Nov 10, 1984 · N97594 · Destroyed > Acft landed long with excessive speed. Plt attempted a go-around but was unable to obtain sufficient flying speed before reaching the end of the rwy which drops off into a steep embankment. When the acft reached the end of the rwy ground effect was lost and… - [NTSB MIA85LA030](https://openairdocs.org/ntsb/MIA85LA030.md): Let L-13 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N8208 · Substantial damage > According to the plt, a downdraft was encountered on base leg causing the acft to descend and decelerate. Unable to reach the rwy the glider landed in an orchard. - [NTSB ATL85LA032](https://openairdocs.org/ntsb/ATL85LA032.md): Boeing 75 · Rustburgh, VA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1984 · N5506A · Substantial damage > The pilot stated that he was landing on the 1,100 foot long runway to the south with a 16 knot tailwind. The plt continued to state that while on final apch the aircraft had an excessive rate of sink. The plt added full power in an attempt to arrest the… - [NTSB FTW85LA049](https://openairdocs.org/ntsb/FTW85LA049.md): Cessna 152 · Denver City, TX · Accident · No injuries · Limited investigation · Final report · Nov 9, 1984 · N64975 · Substantial damage > Plt cited gust on landing caused acft to drift to right, plt visual acuteness reduced by landing into setting sun. Corrective control input of left aileron was excessive, causing left wing to drop to ground contact. Acft pivoted about left wing tip and came… - [NTSB FTW85LA048](https://openairdocs.org/ntsb/FTW85LA048.md): Cessna 170B · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Nov 9, 1984 · N2333D · Substantial damage > When advised of high winds at destination, plt diverted to en route alternate on arrival at alternate, plt was advised of 60 degree crosswind with gusts to 40 mph. Plt had 21 hrs experience in conventional (tailwheel) acft. On landing touchdown, gusts lifted… - [NTSB CHI85LA045](https://openairdocs.org/ntsb/CHI85LA045.md): Cessna 152 · Alton, IL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N94494 · Substantial damage > While on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy… - [NTSB ATL85LA029](https://openairdocs.org/ntsb/ATL85LA029.md): Cessna 152 · Reidsville, NC · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N93152 · Substantial damage > The plt was making a full stop landing and after bouncing a few times the acft nosed over. The plt said the acft porpoised and his attempts to recover were unsuccessful. The winds were calm and no mechanical malfunctions were reported. - [NTSB ATL85LA027](https://openairdocs.org/ntsb/ATL85LA027.md): Cessna 180J · Harmony, NC · Accident · No injuries · Limited investigation · Final report · Nov 7, 1984 · N7723K · Substantial damage > The commercial plt being checked in a tail wheel equipped acft by a CFI on board made 2 successful landings. During the 3rd landing roll, the acft nosed over. The student said that he applied 'heavy' braking during an attempted downslope, short field landing… - [NTSB FTW85LA036](https://openairdocs.org/ntsb/FTW85LA036.md): Robinson R22 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Nov 5, 1984 · N8360A · Substantial damage > According to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI… - [NTSB NYC85LA021](https://openairdocs.org/ntsb/NYC85LA021.md): Piper PA-32-300 · Oxford, CT · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N38996 · Substantial damage > After entering the traffic pattern for the selected runway, plt was informed of surface wind conditions and elected to continue and execute a downwind landing. Upon touchdown, plt raised flaps to assist braking action. During roll-out the plt decided… - [NTSB MKC85LA014](https://openairdocs.org/ntsb/MKC85LA014.md): Cessna 150 · Oxford, IA · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N3510V · Substantial damage > Due to a lower than optimum glide path and turbulence, the acft landed about 100 ft short of the rwy. All 3 landing gear collapsed in the unimproved terrain. - [NTSB LAX85LA039](https://openairdocs.org/ntsb/LAX85LA039.md): Piper PA-32-301 · Sanger, CA · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N8152Z · Substantial damage > Upon touchdown, the left main landing gear contacted a pothole in the rwy aprx 175 ft from the threshold. Skid marks from the left main tire were seen on the rwy beginning at that point along with metal scrappings from the gear. Shortly thereafter, skid marks… - [NTSB MIA85FA022](https://openairdocs.org/ntsb/MIA85FA022.md): Piper PA-30 · Jasper, FL · Accident · Serious injuries · Field investigation · Final report · Nov 3, 1984 · N777WM · Destroyed > Due to a low fuel state the plt elected to make a precautionary landing on a road. Power lines and poles forced the plt to land in unimproved terrain next to the road. During touch down the left wing struck a dirt bank. Exam of the wreckage revealed that 3… - [NTSB CHI85LA038](https://openairdocs.org/ntsb/CHI85LA038.md): Cessna 310C · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Nov 3, 1984 · N6709T · Substantial damage > The plt reported that the landing was normal but the acft settled to the rwy with the gear up while the selector was in the down position. Post accident examination failed to reveal any malfunction of the retraction/extension assembly. - [NTSB MKC85LA015](https://openairdocs.org/ntsb/MKC85LA015.md): Piper PA-24-250 · Aurora, MO · Accident · No injuries · Limited investigation · Final report · Nov 2, 1984 · N5274P · Substantial damage > The acft was landed gear up. The student plt put the gear down on downwind and then on a pre-landing check on final apchthe student retracted the gear. The CFI said the warning horn never sounded and she did not notice that the gear was up. - [NTSB ATL85LA025](https://openairdocs.org/ntsb/ATL85LA025.md): Smith, Ted Aerostar Aerostar 600A · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Nov 1, 1984 · N90609 · Substantial damage > During final approach the pilot was unable to lower the nose gear therefore he landed with the nose gear retracted. Post crash examination revealed that the nose steering actuating bolt was fractured. The facture surfaces exhibited signatures of a progressive… - [NTSB MKC85LA011](https://openairdocs.org/ntsb/MKC85LA011.md): Cessna 310J · Chanute, KS · Accident · No injuries · Limited investigation · Final report · Oct 31, 1984 · N3074L · Substantial damage > During the landing roll the left main landing gear collapsed. Examination of the acft after the accident revealed several mechanical discrepancies. The only gear related problem noted was the landing gear limit switches were out of adjustment but it could not… - [NTSB LAX85FUG01](https://openairdocs.org/ntsb/LAX85FUG01.md): Cessna 195 · Riverside, CA · Accident · No injuries · Final report · Oct 31, 1984 · N3879V · Substantial damage > The acft nosed over during a landing roll following a loss of control. - [NTSB MIA85IA021](https://openairdocs.org/ntsb/MIA85IA021.md): Piper PA-60 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Oct 30, 1984 · N79CM · Minor damage > The acft swerved left off the rwy during the landing roll. An exam of the left main landing gear strut revealed that the collar had failed permitting the lower portion of the landing gear strut to shift. The shift was transmitted tothe tire causing it to… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=435 ## 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=434 --- 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.