# NTSB investigations: Takeoff 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 157 of 281 · 14,038 cases ## Cases, newest first - [NTSB ATL83FA063](https://openairdocs.org/ntsb/ATL83FA063.md): Mitsubishi MU-2B · Louisville, KY · Accident · Serious injuries · Field investigation · Final report · Dec 15, 1982 · N5589S · Substantial damage > A takeoff was initiated from a 3539 ft wet/upsloping rwy. The gross wt of the acft was about 9300 lbs (300 lbs under themax gross wt). The plt stated the acft accelerated, but never reach '107.' After using about 2700 ft, the plt decided to abort the takeoff,… - [NTSB NYC83LA042](https://openairdocs.org/ntsb/NYC83LA042.md): Cessna T303 · Newburgh, NY · Accident · No injuries · Limited investigation · Final report · Dec 11, 1982 · N9742T · Substantial damage > Simulated engine-out emergencies were being practiced. During takeoff the CFI failed the right eng. The student hesitated & the acft swerved to the right. The CFI was unsuccessful in gaining directional control & the acft ran off the rwy into a ditch. - [NTSB MKC83LA037](https://openairdocs.org/ntsb/MKC83LA037.md): Cessna 195B · Lewellen, NE · Accident · No injuries · Limited investigation · Final report · Dec 8, 1982 · N3091B · Substantial damage > Pilot collided with a dirt mound during takeoff from a field and groundlooped the aircraft. Landing gear collapsed. - [NTSB MIA83IA043](https://openairdocs.org/ntsb/MIA83IA043.md): Boeing 727-225 · Sarasota, FL · Incident · No injuries · Incident investigation · Final report · Dec 6, 1982 · N8871Z · Minor damage > Catastrophic failure of the nr 2 engine occurred drg tkof roll. Tkof was aborted and the aircraft was stopped on the runway. There was no fire although engine parts penetrated the engine case and cowling severing coil and hydraulic lines and electrical wires… - [NTSB DEN83LA030](https://openairdocs.org/ntsb/DEN83LA030.md): Cessna 182F · Olathe, CO · Accident · No injuries · Limited investigation · Final report · Dec 5, 1982 · N3273U · Substantial damage > Aircraft ran off end of runway during takeoff during abort. Pilot heard stall warning and aborted takeoff. He also said he forgot 10 degrees of flaps. - [NTSB FTW83LA050](https://openairdocs.org/ntsb/FTW83LA050.md): Cessna 185 · Venice, LA · Accident · No injuries · Limited investigation · Final report · Dec 2, 1982 · N1829R · Substantial damage > Pilot making water takeoff pass piers collided with a tug that appeared out of a slip. Aircraft sank. - [NTSB SEA83LA026](https://openairdocs.org/ntsb/SEA83LA026.md): Stinson 108-2 · Hood River, OR · Accident · No injuries · Limited investigation · Final report · Dec 1, 1982 · N9415K · Substantial damage > The aircraft was heavily loaded and took longer than normal for takeoff. The acceleration was marginal. At the end of the runway, when the pilot pulled up over the wires, the airspeed decayed. The pilot maneuvered to avoid houses and large trees and flew into… - [NTSB MIA83FA036](https://openairdocs.org/ntsb/MIA83FA036.md): Boeing 707-323C · Miami, FL · Accident · No injuries · Field investigation · Final report · Nov 27, 1982 · HK284 · Substantial damage > According to the flight crew, a loud explosion was heard a few seconds after reaching takeoff power and the takeoff was aborted. While taxiing, the tower informed the flight crew that flames were coming from the no. 4 engine. The aircrew stopped the aircraft… - [NTSB SEA83LA025](https://openairdocs.org/ntsb/SEA83LA025.md): Piper PA-32R-300 · Gustavus, AK · Accident · No injuries · Limited investigation · Final report · Nov 26, 1982 · N6104J · Substantial damage > The pilot reported that slush accumulation on the runway prevented the aircraft from reaching takeoff speed. He aborted the takeoff and with braking action "nil" slid off the end of the runway. Gustavus airport is owned and operated by the state of Alaska and… - [NTSB FTW83LA038](https://openairdocs.org/ntsb/FTW83LA038.md): Piper PA-28-151 · Sanderson, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1982 · N5914F · Destroyed > The pilot became disoriented and made a precautionary landing on a highway. After verifying his location the pilot tookoff, made a sharp pullup to avoid a roadside reflector, settled back to the road surface and hit a pole. The pilot veered off the highway… - [NTSB DCA83AA005](https://openairdocs.org/ntsb/DCA83AA005.md): Cessna 551 · Mountain View, MO · Accident · 3 fatal · Final report · Nov 18, 1982 · N2CA · Destroyed > The plt called from home at 0909 for an IFR clearance which became valid until 0930. He said he needed 15 min to get to the arpt. The call ended at 0914. The chief plt preflighted the acft while the plt was enroute to the arpt. The plt arrived between 0920 &… - [NTSB CHI83LA041](https://openairdocs.org/ntsb/CHI83LA041.md): Cessna 150 · Middletown, OH · Accident · No injuries · Limited investigation · Final report · Nov 18, 1982 · N714PW · Substantial damage > The student pilot was practicing touch-and-go landings on her second solo flight. As she applied power to takeoff (after landing), the aircraft veered to the left. It continued into a muddy/sodded area, struck a shallow ditch and nosed over. - [NTSB MKC83LA021](https://openairdocs.org/ntsb/MKC83LA021.md): Cessna 150J · Wahoo, NE · Accident · No injuries · Limited investigation · Final report · Nov 16, 1982 · N61128 · Substantial damage > Plt thought he heard an unusual noise just after lift-off & aborted. The acft ran off the end of the rwy & overturned. The owner examined the acft & was unable to determine the source of the noise. The plt later stated he didn't know what the noise was, &… - [NTSB DEN83LA031](https://openairdocs.org/ntsb/DEN83LA031.md): Piper PA28-180 · Leadville, CO · Accident · No injuries · Limited investigation · Final report · Nov 15, 1982 · N8385W · Substantial damage > The aircraft was taking off in snow with wheel pants installed. The pants filled with snow and plane pulled to left. In attempt to recover directional control and get back on the runway the aircraft hit the asphalt ridge on the edge of the runway separating… - [NTSB ATL83FA033](https://openairdocs.org/ntsb/ATL83FA033.md): Cessna 411A · Plymouth, NC · Accident · No injuries · Field investigation · Final report · Nov 13, 1982 · N4411W · Destroyed > The pilot attempted a takeoff on a wet turf runway and lost control of the aircraft. The aircraft left the runway and collided with trees. Sometime later the aircraft caught fire. The pilot did not cut the switches off. The origin or destination of the flight… - [NTSB DEN83LA018](https://openairdocs.org/ntsb/DEN83LA018.md): Cessna 172 · St. Ignatius, MT · Accident · No injuries · Limited investigation · Final report · Nov 12, 1982 · N733UE · Substantial damage > According to the pilot, the passenger door opened before lift off. He attempted to brake the aircraft in wet snow and ice and slid off the end of the runway into a ditch. The investigation revealed the aircraft had a past history of the entry door latch… - [NTSB DEN83LA017](https://openairdocs.org/ntsb/DEN83LA017.md): Mitsubishi MU-2B-60 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Nov 11, 1982 · N274MA · Substantial damage > The aircraft was being repositioned for an air taxi operation. The pilot began taking off on a slush covered runway. He reported that as the aircraft accelerated, the nosewheel began to sling water and slush off the runway and onto the windshield. He raised… - [NTSB CHI83LA035](https://openairdocs.org/ntsb/CHI83LA035.md): Cessna 172 · Port Hope, MI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1982 · N5301D · Substantial damage > The pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The… - [NTSB SEA83LA020](https://openairdocs.org/ntsb/SEA83LA020.md): Cessna T210G · Mccall, ID · Accident · No injuries · Limited investigation · Final report · Nov 6, 1982 · N6807R · Substantial damage > The pilot reported that when he applied back pressure to raise the nose for takeoff, the aircraft felt sluggish, so he released some back pressure to gain airspeed. The pilot reported he then heard a loud metallic "bang" and stated that a vibration started in… - [NTSB DEN83LA015](https://openairdocs.org/ntsb/DEN83LA015.md): Cessna T210 · Holly, CO · Accident · No injuries · Limited investigation · Final report · Nov 6, 1982 · N732FM · Substantial damage > The pilot stated that during takeoff a piece of wood was picked up by a wheel and tossed against the elevator jamming itand causing him to lose control. While out of control he thought he impacted the ground. A farmers irrigation pipe one quarter mile from… - [NTSB DEN83LA013](https://openairdocs.org/ntsb/DEN83LA013.md): Beech G35 · Cut Bank, MT · Accident · No injuries · Limited investigation · Final report · Nov 6, 1982 · N4253D · Substantial damage > The pilot started to takeoff on runway 31 with a wind from 270 deg at 20 KTS. During the takeoff roll, the aircraft veered and went off the left side of the runway. The pilot stated that after about 400 to 500 ft in the takeoff roll, the "plane veered right… - [NTSB CHI83LA030](https://openairdocs.org/ntsb/CHI83LA030.md): Piper PA-38-112 · Boonville, IN · Accident · No injuries · Limited investigation · Final report · Oct 31, 1982 · N91358 · Substantial damage > On takeoff the pilot reported the aircraft would not climb but kept settling back to the ground. The left wing hit a fence post and the aircraft nosed over. - [NTSB ANC83IA007](https://openairdocs.org/ntsb/ANC83IA007.md): de Havilland DHC-3 · Homer, AK · Incident · No injuries · Incident investigation · Final report · Oct 27, 1982 · N3904 · Minor damage > After removing the floats and reinstalling the wheels on the aircraft, the pilot received permission to take off on a roadway bridge thats spans beluga lake. The purpose of the flight was to ferry the plane to nearby Homer airport. On takeoff, the aircraft… - [NTSB MIA83LA021](https://openairdocs.org/ntsb/MIA83LA021.md): Piper PA-28-161 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 1982 · N330FT · Substantial damage > According to the pilot, he lost directional control while taking off on runway 06R. The aircraft veered off the left side of the runway and collided with VASI lights. The wind was reported to be from 002 deg at 13 KTS. - [NTSB LAX83FUG05](https://openairdocs.org/ntsb/LAX83FUG05.md): E.L. Craig Craigcraft · Chino, CA · Accident · No injuries · Final report · Oct 21, 1982 · N1320 · Substantial damage > The acft veered off the left side of the rwy & collided with a camera tripod. - [NTSB LAX83LA015](https://openairdocs.org/ntsb/LAX83LA015.md): Taylorcraft BC12-65 · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Oct 18, 1982 · N29719 · Substantial damage > The pilot began taking off in calm wind conditions. He reported that when he almost reached the airspeed for takeoff, the aircraft veered to the right. Subsequently, the aircraft hit a brush pile and a fence and was damaged. - [NTSB DCA83IA002](https://openairdocs.org/ntsb/DCA83IA002.md): Douglas DC-9-30 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Oct 18, 1982 · N536TX · Minor damage > The aircraft's right nose landing gear tire tread separated during the takeoff roll. The tread separation resulted in damage to the ground shift mechanism, nose gear door, taxi light and the ee compartment door. The flight returned to the departure airport.… - [NTSB MKC83LA010](https://openairdocs.org/ntsb/MKC83LA010.md): Beech E17L · Mcconnell Afb, KS · Accident · No injuries · Limited investigation · Final report · Oct 16, 1982 · N15846 · Substantial damage > As the aircraft accelerated through 40 mph during the takeoff roll, a passenger advised the pilot that the cabin door was unlocked. The pilot reduced the engine power to idle, reached back and closed the door. While latching the door, the aircraft swerved to… - [NTSB LAX83LA013](https://openairdocs.org/ntsb/LAX83LA013.md): Piper PA-18 · Oceanside, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1982 · N7873D · Destroyed > While attempting a touch and go from a wheel landing the pilot lost directional control and collided with a parked aircraft and a chain fence, finally nosing over. The pilot said he did not use enough right rudder during the roll. The parked aircraft, N5515B,… - [NTSB CHI83LA019](https://openairdocs.org/ntsb/CHI83LA019.md): Piper PA-23-250 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 15, 1982 · N6803A · Substantial damage > The landing gear retracted at 64 mph during the takeoff roll. The takeoff was aborted and the aircraft slid on its fuselage. The landing gear systems all operated normally when checked after the accident. - [NTSB LAX83LVD02](https://openairdocs.org/ntsb/LAX83LVD02.md): Cessna 172 · Gualala, CA · Accident · No injuries · Final report · Oct 11, 1982 · N29150 · 2 aircraft · Substantial damage > Cessna 172, N29150, & Piper PA-28, N8465Y, were both departing from a pvt, unctld arpt at the same time, but from opposite drctns on the same rwy. Th rwy was crowned in the center which prevented line-of-sight to acft on opposite ends. Each plt stated that he… - [NTSB FTW83LA012](https://openairdocs.org/ntsb/FTW83LA012.md): Cessna 152 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1982 · N89023 · Destroyed > While practicing touch & go landings the student plt lost directional control, ran off the side of the rwy into a ditch collapsing the nose gear & turning over. - [NTSB ATL83FA008](https://openairdocs.org/ntsb/ATL83FA008.md): Cessna 177RG · Montgomery, AL · Accident · No injuries · Field investigation · Final report · Oct 9, 1982 · N45696 · Substantial damage > After advancing the throttle about 1/2 of its travel to commence the takeoff roll, the plt heard a loud explosion & felt a violent shaking of the acft. The eng quit & the acft swerved to the right side of the rwy. Post crash examinationrevealed that one… - [NTSB SEA83LA012](https://openairdocs.org/ntsb/SEA83LA012.md): Cessna 206 · 40 Nm Wnw Salmo, ID · Accident · No injuries · Limited investigation · Final report · Oct 8, 1982 · N5183U · Substantial damage > The pilot began a takeoff from a runway covered with about six inches of wet snow and slush in calm wind conditions. He reported that during the takeoff, the right main wheel settled back to the runway and encountered an area of soft snow and slush. The… - [NTSB SEA83LA004](https://openairdocs.org/ntsb/SEA83LA004.md): Beech J35 · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1982 · N3053C · Substantial damage > While on the takeoff roll, the engine was slow to accelerate, and just prior to rotation, it coughed and sputtered. The takeoff was abandoned, but the pilot was unable to stop the aircraft on the remaining runway. The aircraft penetrated the perimeter fence… - [NTSB ANC83FA005](https://openairdocs.org/ntsb/ANC83FA005.md): Cessna 206 · Flat, AK · Accident · No injuries · Field investigation · Final report · Oct 4, 1982 · N9049G · Substantial damage > The pilot made a forced landing shortly after takeoff. He stated that the aircraft lost power, but nothing was found to substantiate this. There was snow on the short runway. The pilot neglected to take a fuel sample before takeoff. - [NTSB MIA83LA003](https://openairdocs.org/ntsb/MIA83LA003.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N93286 · Substantial damage > The student pilot was practicing touch-and-go landings. After touching down on his first landing, he configured the aircraft for takeoff. Immediately after applying power, he observed another plane (unknown make & model) landing from the opposite direction.… - [NTSB ANC83LA002](https://openairdocs.org/ntsb/ANC83LA002.md): Rockwell International Stinson 108 · Near Sparrevohn, AK · Accident · No injuries · Limited investigation · Final report · Oct 2, 1982 · N97451 · Substantial damage > The pilot stated that after shooting a moose in the morning, quartering the animal and carrying the meat to the an unimproved landing/takeoff area he walked back to his cabin for his aircraft. Upon his return, he landed and loaded 2 quarters into the back… - [NTSB SEA83LA001](https://openairdocs.org/ntsb/SEA83LA001.md): Piper PA-12 · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Sep 30, 1982 · N2343M · Substantial damage > The plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard… - [NTSB MKC82DA177](https://openairdocs.org/ntsb/MKC82DA177.md): Piper PA32RT-300 · Excelsior Sprin, MO · Accident · No injuries · Final report · Sep 30, 1982 · N39591 · Substantial damage > Pilot did not attain enough airspeed and aborted takeoff too late to stop before going off end of runway into bushes, damaging landing gear. - [NTSB FTW82DRG38](https://openairdocs.org/ntsb/FTW82DRG38.md): Cessna 170B · San Marcos, TX · Accident · No injuries · Final report · Sep 30, 1982 · N8088A · Substantial damage > Acft swerved off rwy during takeoff. Ex-military plt retired in 1965, check out in aero club tricycle gear acft on 8/28/82 with subsequent 72 hrs all in tricycle gear acft. Plt stated he had not flown conventional gear acft since the 1950'S. There was no… - [NTSB CHI82DA369](https://openairdocs.org/ntsb/CHI82DA369.md): Piper PA-25-180 · Baldwin, WI · Accident · No injuries · Final report · Sep 30, 1982 · N6140Z · Substantial damage > The pilot attempted to takeoff from a 1200 ft alfalfa field with a load of seed but was unable to obtain flying speed. By the time he realized the situation, there was not enough room to stop. He reported that he released the back pressure until he was near… - [NTSB ATL82DA286](https://openairdocs.org/ntsb/ATL82DA286.md): Piper PA-32RT-300T · Athens, GA · Accident · No injuries · Final report · Sep 27, 1982 · N39603 · Substantial damage > The pilot initiated an intersection takeoff with 1400 ft of runway remaining. After starting the takeoff, he elected to abort; however, the aircraft continued off the end of the runway and collided with obstacles. The performance charts showed that a 3000 lb… - [NTSB ATL82FLJ09](https://openairdocs.org/ntsb/ATL82FLJ09.md): Wainscott Scamp B · Holly Springs, NC · Accident · No injuries · Final report · Sep 25, 1982 · N177RW · Substantial damage > The pilot called ahead before landing at the airport and was told that the grass runway was usable. After landing, he initiated a takeoff from the soft, grass runway. According, to the pilot, the grass was uncut and was too high for a departure of his type of… - [NTSB CHI82IA364](https://openairdocs.org/ntsb/CHI82IA364.md): Cessna 152 · Pontiac, MI · Incident · No injuries · Incident investigation · Final report · Sep 23, 1982 · N24236 · 2 aircraft · Minor damage > The pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was… - [NTSB LAX82DA350](https://openairdocs.org/ntsb/LAX82DA350.md): Luscombe 8E · Ramona, CA · Accident · Minor injuries · Final report · Sep 21, 1982 · N45486 · Destroyed > The pilot stated that during takeoff, the aircraft tail was raised too soon and that the aircraft torqued left. The aircraft was subsequently lifted off the runway prematurely and stalled. - [NTSB FTW82DA384](https://openairdocs.org/ntsb/FTW82DA384.md): North American AT-6D · Houston, TX · Accident · No injuries · Final report · Sep 19, 1982 · N29944 · Destroyed > The aircraft began to drift left during takeoff. The pilot decided to lift off and correct the drift in the air. He corrected with right bank and the wing dragged on the ground the aircraft cartwheeled in the grass adjacent to the runway and came to rest… - [NTSB CHI82DA362](https://openairdocs.org/ntsb/CHI82DA362.md): Cessna 172 · Park Forest, IL · Accident · No injuries · Final report · Sep 19, 1982 · N5605J · Substantial damage > The pilot stated there was a partial loss of power during the takeoff roll. He reported that there was insufficient runway remaining to stop when the power loss occurred. The available airspeed was used to "hop" over a 3-foot embankment, but the nose gear,… - [NTSB ANC82DAG58](https://openairdocs.org/ntsb/ANC82DAG58.md): Thurston TSC-1A · Homer, AK · Accident · No injuries · Final report · Sep 19, 1982 · N2019T · Substantial damage > During a water takeoff, the aircraft impacted a large wave unexpectedly. Witnesses stated that the aircraft was thrown to a height of approximately 12 feet. The pilot stated that the airspeed was about 40 to 45 knot's at the time of impact with the wave. He… - [NTSB LAX82DUQ18](https://openairdocs.org/ntsb/LAX82DUQ18.md): Cessna 172N · Burbank, CA · Accident · No injuries · Final report · Sep 18, 1982 · N634NH · Substantial damage > Pilot doing touch and go cut off carb. Heat waited for full flap retraction then added power for takeoff. When plane did not climb out of ground effect he closed throttle, landed, and ground looped into wall to avoid blast fence head on. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=158 ## 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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=157 --- 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.