# 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 158 of 281 · 14,038 cases ## Cases, newest first - [NTSB ANC82DAA16](https://openairdocs.org/ntsb/ANC82DAA16.md): Piper 18 · Kotzebue, AK · Accident · No injuries · Final report · Sep 16, 1982 · N345BG · Substantial damage > The pilot attempted a takeoff from a rough dirt strip approximately 1000 feet in length. The wind was blowing from the east and the takeoff was to the southwest due to the downhill slope of the runway. The aircraft lifted off at an unknown airspeed… - [NTSB ATL82IA281](https://openairdocs.org/ntsb/ATL82IA281.md): Piper PA-34-22OT · Montgomery, AL · Incident · No injuries · Incident investigation · Final report · Sep 15, 1982 · N220HB · Minor damage > The pilot stated that a normal runup was completed before takeoff. During the takeoff roll, the aircraft accele- rated through 75 knots when a loud bang was heard from the left side. The takeoff was aborted and a rollout accomplished. Examination of the left… - [NTSB DEN82AA191](https://openairdocs.org/ntsb/DEN82AA191.md): Mitsubishi MU-2B-25 · Hayden, CO · Accident · 6 fatal · Final report · Sep 12, 1982 · N66U · Destroyed > A maint supervisor & 2 plts noted that the l eng did not respond normally while being started. Aft starting, the plt taxied to rwy 10 for an IFR departure. Since the twy did not extend to the end of the rwy, the plt of another acft waited on the twy, just… - [NTSB SEA82DA160](https://openairdocs.org/ntsb/SEA82DA160.md): Cessna 152 · Bonners Ferry, ID · Accident · No injuries · Final report · Sep 11, 1982 · N67323 · Substantial damage > After refueling, the pilot attempted to takeoff from a field. The first takeoff attempt was aborted. During the second takeoff roll the aircraft nose gear struck a ditch, causing the aircraft to nose over. - [NTSB DEN82FTE27](https://openairdocs.org/ntsb/DEN82FTE27.md): Vari-Eze · Pagosa Springs, CO · Accident · No injuries · Final report · Sep 10, 1982 · N123EZ · Substantial damage > Due to an approaching thunderstorm from the west, the pilot elected to make a takeoff on runway 04 with a quartering tail wind. The surface was wet and there was about a 20 ft rise in the last half of the runway. The runway was 5600 ft long, but its elevation… - [NTSB ANC82DA088](https://openairdocs.org/ntsb/ANC82DA088.md): Piper PA-32-260 · Naknek, AK · Accident · No injuries · Final report · Sep 10, 1982 · N3884W · Substantial damage > At the point of rotation the acft struck a large puddle of water causing a reduction in speed. The acft continued down the rwy approximately another 150 ft at 5 ft AGL when it became evident that further flight was impossible. The takeoff was aborted & the… - [NTSB ANC82DA086](https://openairdocs.org/ntsb/ANC82DA086.md): Cessna 170 · Near Anchorage, AK · Accident · No injuries · Final report · Sep 10, 1982 · N2584V · Substantial damage > Pilot tried stop landing on sandbar he had done touch and go landings on. Sand was soft and flying speed not attained before curve in sandbar during takeoff attempt. Pilot could not negotiate turn and continued into river. - [NTSB ANC82DA087](https://openairdocs.org/ntsb/ANC82DA087.md): Cessna 185F · Naknek, AK · Accident · No injuries · Final report · Sep 9, 1982 · N80124 · Substantial damage > The pilot made a takeoff downwind in gusty conditions on a lake with marginal capabilities. Surrounding terrain makes wind swirling eddies. The aircraft lost lift and impacted on the bank of the lake in alder brush. - [NTSB SEA82DA157](https://openairdocs.org/ntsb/SEA82DA157.md): Ercoupe 415C · Kingston, WA · Accident · No injuries · Final report · Sep 7, 1982 · N2932H · Destroyed > Pilot thought he could not clear power lines and trees after takeoff so he aborted takeoff & slid 250 ft off the runway, nosing over. The pilot mentioned that it was hot & there was a slight tailwind. This was the first time the pilot has used the airstrip. - [NTSB DEN82DA187](https://openairdocs.org/ntsb/DEN82DA187.md): Cessna 150 · Faith, SD · Accident · No injuries · Final report · Sep 7, 1982 · N8127S · Substantial damage > The pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a… - [NTSB ANC82DA085](https://openairdocs.org/ntsb/ANC82DA085.md): Bellanca 7GCBC · Mt. Range, AK · Accident · No injuries · Final report · Sep 7, 1982 · N62972 · Substantial damage > Downhill takeoff into gusty crosswind raised wing which pilot could not control with aileron. Wing dragged and aircraft nosed over after 200 foot roll. - [NTSB SEA82FYA11](https://openairdocs.org/ntsb/SEA82FYA11.md): Beech C24R · Galena, ID · Accident · Serious injuries · Final report · Sep 6, 1982 · N18894 · Substantial damage > Prior to takeoff the mixture was leaned to compensate for the high density altitude. The arpt is at an elevation of 7,160 ft MSL. The acft rolled the 5,075 ft length of the rwy & may have become airborne prior to striking fences at the end of the rwy. The… - [NTSB DEN82DA188](https://openairdocs.org/ntsb/DEN82DA188.md): Piper PA-24-180 · Pueblo, CO · Accident · Serious injuries · Final report · Sep 6, 1982 · N7291P · Substantial damage > The aircraft landed at rueblo, CO for fuel on a return flight to Texas. After landing, the pilot asked a female attendant if there were any liquor stores open. The pilot returned to the airport about 1/2 hour later and observed the pilot carrying a brown… - [NTSB FTW82DA368](https://openairdocs.org/ntsb/FTW82DA368.md): Bellanca 8GCBC · Katy, TX · Accident · No injuries · Final report · Sep 5, 1982 · N4167Y · 2 aircraft · Minor damage > N1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to… - [NTSB LAX82DA331](https://openairdocs.org/ntsb/LAX82DA331.md): Piper 601P · Burbank, CA · Accident · No injuries · Final report · Sep 4, 1982 · N3642Y · Substantial damage > During lift-off the right engine failed. The takeoff was aborted & the plt swerved the acft to avoid a blast fence at the end of the rwy. The left main landing gear failed & the acft collided with the fence. Maintenance records revealed a total of 12… - [NTSB MIA82DA188](https://openairdocs.org/ntsb/MIA82DA188.md): Cessna 188T · Jay, FL · Accident · No injuries · Final report · Sep 2, 1982 · N4790Q · Substantial damage > During takeoff the aircraft lost power at rotation, settled onto the runway, overran the end and flipped over. The pilot had borrowed fuel for this flight and when some was put in a pickup truck the truck would not idle and had no power. An attempt to get the… - [NTSB ANC82FAA14](https://openairdocs.org/ntsb/ANC82FAA14.md): Cessna 402 · Fairbanks, AK · Accident · No injuries · Final report · Sep 2, 1982 · N3299Q · Substantial damage > The plt reported that during taxi there was a light trace of dew on the windshield. The passenger stated that during the initial application of takeoff power the windshield became fogged & completely obscured forward visibility. The plt's attention was also… - [NTSB ANC82DAA17](https://openairdocs.org/ntsb/ANC82DAA17.md): Piper PA-18 · 20 Ese North Po, AK · Accident · No injuries · Final report · Sep 2, 1982 · N83593 · Substantial damage > After previously landing at an off-airport hunting site, the plt & pax started cutting the brush to clear a suitable area for takeoff. Due to the approaching night, the plt considered the area to be suitable. Drg takeoff the left wingtip struck some brush. - [NTSB LAX82DA325](https://openairdocs.org/ntsb/LAX82DA325.md): Cessna 188 · Casa Grande, AZ · Accident · No injuries · Final report · Aug 31, 1982 · N1562M · Substantial damage > The pilot initiated his takeoff with a light quartering tail wind from a 2300 ft runway that was covered with tall grass. The temperature and elevation were 95 deg and about 1500 ft, respectively. He reported that the plane accelerated slowly, but was about… - [NTSB CHI82DA316](https://openairdocs.org/ntsb/CHI82DA316.md): Beech G18S · Chicago, IL · Accident · No injuries · Final report · Aug 31, 1982 · N38RM · Substantial damage > During takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they… - [NTSB FTW82DA352](https://openairdocs.org/ntsb/FTW82DA352.md): Grumman AA-1 · Pearland, TX · Accident · Minor injuries · Final report · Aug 29, 1982 · N5788L · Substantial damage > The pilot reported that during an engine run-up, before takeoff, the engine ran rough on one magneto. He did not state which. He reported that after the engine was leaned, the roughness disappeared and a takeoff was made. He stated that after lift off, thrust… - [NTSB LAX82DA319](https://openairdocs.org/ntsb/LAX82DA319.md): Piper PA-28-140 · Twenty-Nine Pal, CA · Accident · No injuries · Final report · Aug 28, 1982 · N5624U · Substantial damage > While preparing to takeoff, the pilot taxied to a position near the midpoint of runway 8/26 where it intersected with a 750 ft taxiway. At that point, the taxiway angled toward the south-southwest to the north end of runway 17/35. The pilot mistook the… - [NTSB FTW82DA354](https://openairdocs.org/ntsb/FTW82DA354.md): Grumman G-164A · Columbia, LA · Accident · No injuries · Final report · Aug 25, 1982 · N8390 · Substantial damage > During takeoff, the left wing of the aircraft contacted the cotton that was growing on the left side of the runway. The pilot reported that he could not lift the wing out of the cotton. When he reduced the power, the aircraft turned left and slid sideways.… - [NTSB FTW82DA344](https://openairdocs.org/ntsb/FTW82DA344.md): Cessna 401A · Silver City, NM · Accident · No injuries · Final report · Aug 23, 1982 · N9867F · Substantial damage > The aircraft was being flown to check it after some minor maintenance had been performed. During the takeoff roll at about 84 KTS, the pilot noted a drop in the fuel flow to the right engine, followed by a loss of power on the right side. He aborted the… - [NTSB LAX82IA309](https://openairdocs.org/ntsb/LAX82IA309.md): Mcdonnell Douglas DC-10-30F · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Aug 22, 1982 · N104WA · Minor damage > At rotation, the fire bell and the #2 engine fire warning light came on and the crew noted a power loss on the #2 engine. The takeoff was continued, the engine secured and the fire bottles discharged. The fire continued to burn. The aircraft circled and made… - [NTSB NYC82DA205](https://openairdocs.org/ntsb/NYC82DA205.md): Cessna 150M · Ceres, NY · Accident · No injuries · Final report · Aug 20, 1982 · N714EY · Destroyed > The pilot made a precautionary landing on a private airstrip to await passage of thunderstorms. Two plus hours later, a takeoff was attempted and aborted. The aircraft contacted a ditch and nosed over. No flaps were used for short field takeoff. Braking was… - [NTSB MKC82DA154](https://openairdocs.org/ntsb/MKC82DA154.md): Piper PA-25-235 · Fisk, MO · Accident · No injuries · Final report · Aug 20, 1982 · N8787L · Destroyed > The pilot was taking off from a small ag strip when his left wing went into milo growing beside the strip. Subsequently, the aircraft spun around and flipped over. This was the pilot's tenth takeoff on that day. He reported that the wind was from the… - [NTSB MIA82DA173](https://openairdocs.org/ntsb/MIA82DA173.md): Air & Space 18A · Orlando, FL · Accident · Minor injuries · Final report · Aug 20, 1982 · N6140S · Destroyed > During takeoff, the gyrocopter lifted off to only about 3 ft, instead of the usual 10 to 15 ft. it then settled back to the runway and encountered a ground resonant condition. The pilot stated that once the wheels were carrying the weight, the blades would… - [NTSB DEN82DA169](https://openairdocs.org/ntsb/DEN82DA169.md): Quicksilver Mxii · Broomfield, CO · Accident · Serious injuries · Final report · Aug 20, 1982 · N3149Z · Substantial damage > Reportedly, the pilot made an intersection takeoff from about midfield on runway 02. He stated that he took off at rotation speed plus 2 KTS. The passenger reported that they reached about 40 ft AGL, then lost lift and begun to settle. As the two-place… - [NTSB FTW82DA329](https://openairdocs.org/ntsb/FTW82DA329.md): Cessna 152 · Santa Fe, NM · Accident · No injuries · Final report · Aug 15, 1982 · N67834 · Substantial damage > The student pilot was on his first supervised solo flight. During a touch-and-go landing, when power was added for takeoff, at about 50 KTS, he lost control of the aircraft departed the runway, it struck a bush and nosed over. - [NTSB LAX82DA303](https://openairdocs.org/ntsb/LAX82DA303.md): Cessna 172N · Pine Springs, AZ · Accident · Minor injuries · Final report · Aug 14, 1982 · N5357J · Substantial damage > Plt stated he landed at what he thought was his destination arpt. The field was soft & an attempted takeoff was unsuccessful. He then taxied to an adjacent paved road & a second takeoff was attempted. The main landing gear went off the shoulder & the acft… - [NTSB LAX82DA298](https://openairdocs.org/ntsb/LAX82DA298.md): Cessna 152 · Livermore, CA · Accident · No injuries · Final report · Aug 14, 1982 · N48886 · Substantial damage > The student pilot was departing on a solo cross-country flight. He lost control of the aircraft on the takeoff roll, hit a ditch and nosed over. The aircraft owner, who was also his instructor, stated that a moderate crosswind existed during the takeoff roll.… - [NTSB CHI82DA309](https://openairdocs.org/ntsb/CHI82DA309.md): Cessna 152 · Boyceville, WI · Accident · No injuries · Final report · Aug 12, 1982 · N25325 · Substantial damage > Solo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over. - [NTSB FTW82DA349](https://openairdocs.org/ntsb/FTW82DA349.md): Cessna 172N · Antoine, AR · Accident · No injuries · Final report · Aug 10, 1982 · N75548 · Substantial damage > The pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch. - [NTSB MKC82DA139](https://openairdocs.org/ntsb/MKC82DA139.md): Piper PA-20 · Scottsbluff, NE · Accident · No injuries · Final report · Aug 9, 1982 · N1970A · Substantial damage > During takeoff, the pilot raised the tail at about 50 mph and the aircraft veered to the left. Despite the pilot's countermeasures, it departed the left side of the runway. The right gear then collapsed and the right wing and propeller were damaged. An… - [NTSB FTW82DA321](https://openairdocs.org/ntsb/FTW82DA321.md): Cessna 152 · Iredell, TX · Accident · No injuries · Final report · Aug 9, 1982 · N6279M · Substantial damage > The student pilot originally took off at temple, TX and proceeded to mcgregor, TX to practice touch-and-go landings. After departing mcgregor to return to temple, he became lost. After about two hours, he landed in a pasture and received directions to temple.… - [NTSB NYC83LA017](https://openairdocs.org/ntsb/NYC83LA017.md): Piper PA-20 · Burlington, CT · Accident · No injuries · Limited investigation · Final report · Aug 8, 1982 · N1836A · Substantial damage > The pilot began taking off on runway 19 with a right crosswind. Reportedly, a strong gust of wind was encountered and the aircraft veered off the left side of the runway. It headed toward the opening of a culvert that went under the runway. To avoid the… - [NTSB DEN82FTC09](https://openairdocs.org/ntsb/DEN82FTC09.md): Bell 47G-3B-L · Kaycee, WY · Accident · 1 fatal · Final report · Aug 8, 1982 · N8529F · Destroyed > The pilot was having cooling fan problems, some blades had broken. He landed in a canyon stayed overnight to cool engine and planned to fly to top of the canyon to get repairs. After takeoff, the helicopter had climbed almost level with the top of the canyon… - [NTSB MIA82DA164](https://openairdocs.org/ntsb/MIA82DA164.md): Piper PA-38 · Vero Beach, FL · Accident · No injuries · Final report · Aug 7, 1982 · N2406D · Substantial damage > The pilot was on an instructional flight when he flew to andther airport to practice grass field landings. According to the 1450 EDT weather report from Vero Beach, the wind was from 110 degrees at 10 KTS and the temperature was 90 degrees. During a… - [NTSB NYC82DA191](https://openairdocs.org/ntsb/NYC82DA191.md): Piper PA-38-112 · Poestenkill, NY · Accident · No injuries · Final report · Aug 6, 1982 · N2361K · Substantial damage > During a touch & go the plt retracted the flaps & applied full power, but the acft seemed sluggish in gaining speed. The plt applied brakes & cut the throttle, but the acft ran off the end of the rwy coming to rest at the edge of a swamp. - [NTSB DEN82IA154](https://openairdocs.org/ntsb/DEN82IA154.md): Boeing 737-291 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Aug 6, 1982 · N7356F · Minor damage > The captain said he felt a "thump" and the aircraft slumped to the left as it was rotated for takeoff. At this point, the aircrew were committed to continue the takeoff which accomplished successfully. A low pass was made for tower personnel to check the… - [NTSB CHI82DA297](https://openairdocs.org/ntsb/CHI82DA297.md): Lake LA-4-200 · Standard Rock, MI · Accident · No injuries · Final report · Aug 2, 1982 · N6164V · Destroyed > After landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage. - [NTSB MKC82DA134](https://openairdocs.org/ntsb/MKC82DA134.md): Cessna R172K · Hansell, IA · Accident · No injuries · Final report · Jul 31, 1982 · N758AG · Substantial damage > The pilot reported that during the takeoff roll, he was blinded by the sun and allowed the aircraft to drift into tall corn beside the runway. Subsequently, the aircraft nosed over. - [NTSB MKC82FCD09](https://openairdocs.org/ntsb/MKC82FCD09.md): Hughes 269B · Tipton, IA · Accident · Serious injuries · Final report · Jul 29, 1982 · N9357F · Substantial damage > The helicopter crashed during takeoff on a flight to pollenate corn. The pilot reported that he made a running takeoff across the runway. He stated that the helicopter became airborne at the north edge of the runway, but started to settle as it went over the… - [NTSB DEN82FTM15](https://openairdocs.org/ntsb/DEN82FTM15.md): Oar Acapella · Woods Cross, UT · Accident · No injuries · Final report · Jul 28, 1982 · N360CB · Substantial damage > The pilot reported that as he was lifting the nose wheel during takeoff when the left tire encountered 1 to 2 inches of water and broken pavement. He stated that the plane veered left and he applied full right rudder to recover, then the aircraft went off the… - [NTSB ANC82DA062](https://openairdocs.org/ntsb/ANC82DA062.md): Hughes 369D · Near Bornite, AK · Accident · 1 fatal · Final report · Jul 28, 1982 · N820Y · Destroyed > Two workers were transported to a mine drilling site where the helicopter was landed on a man-made heli-pad. The heli-pad was an area about 50 ft long and 12 ft wide that had been cut into the side of a rocky hill. After off-loading the workers, the pilot… - [NTSB ATL82DA216](https://openairdocs.org/ntsb/ATL82DA216.md): Cessna 150G · Huntsville, AL · Accident · Minor injuries · Final report · Jul 27, 1982 · N3124J · Substantial damage > The pilot landed long and fast and pushed the flap lever to an up position for takeoff. The flap lever is spring loaded to the neutral position. When the flaps did not come up the pilot pushed the switch again and the flaps started up. As the runway end was… - [NTSB DEN82DA145](https://openairdocs.org/ntsb/DEN82DA145.md): Cessna 152 · Woods Cross, UT · Accident · No injuries · Final report · Jul 26, 1982 · N758YP · Substantial damage > The student pilot stated that during the takeoff roll, he discovered the airspeed indicator was not operating. Also, he said that he accumulated excessive ground speed and made a decision to abort the takeoff. The aircraft was damaged when the pilot was… - [NTSB ANC82DA069](https://openairdocs.org/ntsb/ANC82DA069.md): Aeronca Champ 7EC · Lake Clark, AK · Accident · No injuries · Final report · Jul 26, 1982 · N4314C · Destroyed > During takeoff the aircraft contacted willow trees which swerved the aircraft farther into brush. The pilot aborted the takeoff and braked to a stop. Engine fire started which consumed the aircraft. - [NTSB MKC82DA132](https://openairdocs.org/ntsb/MKC82DA132.md): Cessna 150 · Davenport, IA · Accident · No injuries · Final report · Jul 24, 1982 · N9270U · Substantial damage > Unauthorized persons stole money and aircraft keys and attempted a takeoff in a Cessna 150 from a taxiway. The aircraft collided with a runway light and stalled after flying a few hundred feet. The parties involved have not been identified. Injury index is… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=159 ## 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=158 --- 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.