# 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 159 of 281 · 14,038 cases ## Cases, newest first - [NTSB CHI82DA274](https://openairdocs.org/ntsb/CHI82DA274.md): Cessna 188B · Loami, IL · Accident · No injuries · Final report · Jul 24, 1982 · N4970Q · Destroyed > The pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the… - [NTSB FTW82DA293](https://openairdocs.org/ntsb/FTW82DA293.md): Cessna A188B · Texline, TX · Accident · No injuries · Final report · Jul 23, 1982 · N53309 · Substantial damage > The pilot started to takeoff with a 145 gal spray load. Reportedly, the main gear dug into the surface of a plowed field during the takeoff roll and collapsed. - [NTSB MKC82DA129](https://openairdocs.org/ntsb/MKC82DA129.md): Texas Helicopter OH-13E · 10 Sw Of Milan, MO · Accident · No injuries · Final report · Jul 20, 1982 · N38117 · Substantial damage > The plt had reduced the spray load from 90 to 50 gals to compensate for the increase in density altitude. The winds were blowing lightly during previous takeoffs but were calm during this takeoff. As the helicopter hovered forward during the takeoff it failed… - [NTSB FTW82DA287](https://openairdocs.org/ntsb/FTW82DA287.md): Grumman G-164B · Humnoke, AR · Accident · No injuries · Final report · Jul 20, 1982 · N6689K · Substantial damage > The pilot reported that during takeoff, the left main gear got off the side of the rough airstrip and into a rice field. Subsequently, the plane flipped over. - [NTSB SEA82DA118](https://openairdocs.org/ntsb/SEA82DA118.md): Cessna 182C · Near Dixie, ID · Accident · No injuries · Final report · Jul 19, 1982 · N8548T · Destroyed > The pilot was taking off from a wet, sod airstrip when he elected to abort at about the midway point of the runway. While aborting, the aircraft hit a soft spot in the runway which sheared off the nose gear. Aircraft continued off end of runway and burned. - [NTSB FTW82DA284](https://openairdocs.org/ntsb/FTW82DA284.md): Beech 95-A55 · Jonestown, TX · Accident · No injuries · Final report · Jul 18, 1982 · N34RS · Substantial damage > The pilot stated that during the takeoff roll, he encountered a strong pull to the right. The aircraft departed the right side of the runway, went down an eight foot embankment, and was substantially damaged. After the accident, the wheels rolled freely and… - [NTSB ATL82DA201](https://openairdocs.org/ntsb/ATL82DA201.md): Cessna 182E · Taplin, WV · Accident · No injuries · Final report · Jul 17, 1982 · N9245X · Substantial damage > The pilot stated that the sod runway had just been mowed. During the takeoff roll, the left wheel pant became filled with cut grass and locked the wheel. Subsequently, the aircraft veered to the left. The pilot reported that the left wing contacted low trees… - [NTSB SEA82DA121](https://openairdocs.org/ntsb/SEA82DA121.md): Lake LA-4 · Newport, OR · Accident · No injuries · Final report · Jul 16, 1982 · N1216L · Substantial damage > The pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that… - [NTSB LAX82FA255](https://openairdocs.org/ntsb/LAX82FA255.md): Mitsubishi MU-2B · Schellville, CA · Accident · Minor injuries · Field investigation · Final report · Jul 14, 1982 · N27GP · Destroyed > At approximately 800 ft down the left side of the rwy the left eng experienced a power loss. The acft swerved off the left side of the rwy colliding with a drainage ditch & coming to rest inverted. Examination of the fuel control unit revealed that the… - [NTSB MKC82DA123](https://openairdocs.org/ntsb/MKC82DA123.md): Piper PA-28-140 · Conway Springs, KS · Accident · No injuries · Final report · Jul 11, 1982 · N555KC · Substantial damage > The pilot reported that the wind was from the southwest at 3 KTS, but 16 miles away at wichita, KS, it was from 310 degrees at 9 KTS. He selected runway 17, a sod, 2140 ft, private strip. He said that during the takeoff roll, the aircraft became light on the… - [NTSB MKC82FCJ04](https://openairdocs.org/ntsb/MKC82FCJ04.md): Piper PA-36 · North Platte, NE · Accident · 1 fatal · Final report · Jul 9, 1982 · N57738 · Substantial damage > The aircraft ran off the departure end of the runway during takeoff on a planned agricultural flight. After departing the runway, it continued for a distance through uncut wheat until it contacted a shallow washout and small bank, then flipped over. There… - [NTSB ANC82DA058](https://openairdocs.org/ntsb/ANC82DA058.md): Cessna 310 · Elim, AK · Accident · No injuries · Final report · Jul 9, 1982 · N7745Q · Substantial damage > According to the plt, he was at VMC when he saw the right eng fuel flow needle split away from the left fuel flow needle & the acft started to swerve right. The takeoff was aborted & the acft ran off the end of the rwy. The rwy was heavily rutted & acft had… - [NTSB LAX82FVG28](https://openairdocs.org/ntsb/LAX82FVG28.md): Miller Tufts T-3-160 · Placerville, CA · Accident · 1 fatal · Final report · Jul 6, 1982 · N1051K · Destroyed > The home built acft was of the plt's own design. It was a 4 place, low wing acft with a large canopy & smaller vert tail surfaces and was equipped with flaps, folding wings & fixed tail whl gear. The plt/designer was trying a new concept of lateral control by… - [NTSB SEA82IA101](https://openairdocs.org/ntsb/SEA82IA101.md): Douglas DC-9-31 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Jul 5, 1982 · N919RW · Minor damage > After a gate delay to load late passengers, the flight was cleared for takeoff on runway 28L. About 4 seconds after rotation speed was called, the stickshaker activated and the takeoff was aborted. A readout of the CVR indicated that the thrust reversers were… - [NTSB DEN82DA126](https://openairdocs.org/ntsb/DEN82DA126.md): Aerospatiale SA 315B · Big Piney, WY · Accident · No injuries · Final report · Jul 2, 1982 · N49532 · Substantial damage > The pilot stated that he felt a shudder while he was taking off with a long line attached. He began a descent, and when the helicopter was about 5 ft above the ground, the long line caught a tree. Subsequently, the helicopter pitched nose down and the rotor… - [NTSB ANC82DA057](https://openairdocs.org/ntsb/ANC82DA057.md): Britten-Norman BN-2A · Nome, AK · Accident · No injuries · Final report · Jul 2, 1982 · N39MN · Substantial damage > During the takeoff roll, a propeller blade tip failure occurred on the left engine. About 9 inches of the blade tip separated and entered the top side of the fuselage about 1 ft behind the pilot's head. The blade tip severed the throttle, fuel mixture,… - [NTSB CHI82DA229](https://openairdocs.org/ntsb/CHI82DA229.md): Clancy Skybaby · Grand Haven, MI · Accident · Minor injuries · Final report · Jul 1, 1982 · N211SB · Substantial damage > During the pilots fourth takeoff roll of the day the right wing began to drop and the aircraft drifted off the runway. Power was reduced and brakes applied but the aircraft overturned after encountering a soft sodded area. After the accident it was noted that… - [NTSB ATL82DA178](https://openairdocs.org/ntsb/ATL82DA178.md): Bellanca 7ECA · Ft. Meade, MD · Accident · No injuries · Final report · Jun 25, 1982 · N4214Y · Substantial damage > The pilot reported that the carburetor heat operated during an engine run-up before takeoff, and that he used the carburetor heat during each landing. During a touch-and-go, he lifted off at 65 KTS, but the plane settled and would not climb out of ground… - [NTSB DEN82DA114](https://openairdocs.org/ntsb/DEN82DA114.md): Schweizer SGS 1-34 · Colorado Spring, CO · Accident · No injuries · Final report · Jun 24, 1982 · N7642 · Substantial damage > During the takeoff roll, the canopy of the glider came open while the glider was being towed. The pilot attempted to close the canopy, and in doing so, the glider became airborne, then contacted the runway in a nose low attitude. Subsequently, the glider… - [NTSB DEN82FTC06](https://openairdocs.org/ntsb/DEN82FTC06.md): Bellance 7GCBC · Pinedale, WY · Accident · Serious injuries · Final report · Jun 23, 1982 · N57508 · Destroyed > During a running takeoff the pilot allowed the aircraft to lose control. The aircraft went off the runway, swerved, bounced into the air and nosed over. - [NTSB LAX82FUM07](https://openairdocs.org/ntsb/LAX82FUM07.md): Piper PA-36-285 · Imperial, CA · Accident · No injuries · Final report · Jun 22, 1982 · N9979P · Substantial damage > The pilot was unable to maintain airspeed and altitude after taking off from a wet and muddy runway. He closed the throttle and landed in a cotton field, but was unable to stop the aircraft before hitting a ditch. Reportedly, the previous (first) takeoff… - [NTSB DEN82DA105](https://openairdocs.org/ntsb/DEN82DA105.md): Piper PA-20 · Near Rawlins, WY · Accident · No injuries · Final report · Jun 19, 1982 · N3411A · Substantial damage > The pilot stated that he had landed on a blacktop road, but opted to takeoff on a gravel road because of the proximity of reflector posts to the wings. He stepped off the road and estimated that he had about 800 ft for takeoff. The density altitude was about… - [NTSB ATL82DA167](https://openairdocs.org/ntsb/ATL82DA167.md): Piper PA-28-161 · Atlanta, GA · Accident · Minor injuries · Final report · Jun 19, 1982 · N31883 · Destroyed > The student pilot was practicing touch-and-go landings in winds that were variable 330 to 340 degrees at 10 knots. During the second touch-and-go, the aircraft touched down normally. However, as it was accelerating for takeoff, the plane suddenly swerved to… - [NTSB NYC82DA127](https://openairdocs.org/ntsb/NYC82DA127.md): Cessna 182H · Fort Fairfield, ME · Accident · No injuries · Final report · Jun 18, 1982 · N8558S · Substantial damage > The pilot stated that the aircraft was slow to accelerate in loose gravel at the beginning of the takeoff roll. He reported that he rotated for takeoff before reaching his abort point about 1000 ft down the 2100 ft runway. He stated that the aircraft was not… - [NTSB DEN82DA109](https://openairdocs.org/ntsb/DEN82DA109.md): Cessna 152 · Grand Forks, ND · Accident · No injuries · Final report · Jun 18, 1982 · N6145Q · Substantial damage > The student pilot was practicing takeoffs and landings on his third supervised solo flight with a left quartering wind at 10 KTS. Upon landing, the student began his takeoff roll. Subsequently, the aircraft veered off the runway, traveled about 600 ft, and… - [NTSB FTW82DA231](https://openairdocs.org/ntsb/FTW82DA231.md): Southern Airmotive Corp Sac SAC · Graham, TX · Accident · No injuries · Final report · Jun 17, 1982 · N3800C · Destroyed > The pilot reported that he began a takeoff on runway 17 to ferry the aircraft from Graham to houston, TX. He reported that the wind was from 340 deg at 15 KTS. Reportedly, he had no previous flight time in this make and model of aircraft. The pilot stated… - [NTSB FTW82DA226](https://openairdocs.org/ntsb/FTW82DA226.md): Weatherly 201C · Lakewood, AR · Accident · No injuries · Final report · Jun 14, 1982 · N9044W · Substantial damage > The right main gear of the aircraft failed during the takeoff roll. The pilot stated that the gear failed after he had rolled about 150 ft. - [NTSB SEA82FYM19](https://openairdocs.org/ntsb/SEA82FYM19.md): Champion 7GCAA · Independence, OR · Accident · Minor injuries · Final report · Jun 13, 1982 · N9528S · Destroyed > The pilot reported that during a full stall landing, the aircraft veered to the left at the moment of touchdown. Full power was applied for a go-around, but reportedly, the pilot was unable to turn the aircraft back to the right toward the runway. After… - [NTSB CHI82DA205](https://openairdocs.org/ntsb/CHI82DA205.md): Volmer Sportsman · Pulaski, WI · Accident · Minor injuries · Final report · Jun 12, 1982 · N9011 · Destroyed > On his first flight of the aircraft during this calendar year, the pilot aborted his takeoff. On the second attempt he started to abort but the engine surged and the aircraft became airborne. He stated that he continued to have a problem with the engine and… - [NTSB LAX82DA212](https://openairdocs.org/ntsb/LAX82DA212.md): Cessna 185 · Anza, CA · Accident · No injuries · Final report · Jun 8, 1982 · N2205T · Substantial damage > The student, a rated pilot, and his instructor landed on an unimproved private strip which was at an elevation of about 4750 ft MSL. After landing, the pilots walked through the airstrip and discussed the condition of the strip. There was tall grass on the… - [NTSB FTW82DPA13](https://openairdocs.org/ntsb/FTW82DPA13.md): Cessna 152 · Mckinney, TX · Accident · No injuries · Final report · Jun 8, 1982 · N89551 · Substantial damage > The student pilot practicing touch and go landings lost control of the aircraft and swerved off the runway. The aircraft then contacted a fence and nosed over. - [NTSB ANC82DAA04](https://openairdocs.org/ntsb/ANC82DAA04.md): Cessna 170 · Chicken, AK · Accident · No injuries · Final report · Jun 8, 1982 · N4593C · Substantial damage > The student pilot reported that he made a pleasure/personal flight to an old hunting strip. He reported that it was a rough, gravel strip that was located on sloping terrain. Reportedly after landing, he waited for a rain storm with heavy wind to pass before… - [NTSB DEN82DA102](https://openairdocs.org/ntsb/DEN82DA102.md): Bellanca 8GCBC · Philip, SD · Accident · No injuries · Final report · Jun 6, 1982 · N86993 · Substantial damage > The pilot flew to an open field where he landed to work on a truck. While he was working on the truck, the wind increased to the point that he was afraid to leave the aircraft on the ground. When he got in the plane, the wind prevented him from turning and… - [NTSB ATL82IA154](https://openairdocs.org/ntsb/ATL82IA154.md): Beech 18 · Macon, GA · Incident · No injuries · Incident investigation · Final report · Jun 6, 1982 · N171DC · Minor damage > According to the pilot, the flight was being conducted under ferry flight provisions. The flight was issued a takeoff clearance for runway 05,with reported surface winds of 320 degrees at 10 knots. The copilot started the takeoff roll and was unable to… - [NTSB MKC82FA095](https://openairdocs.org/ntsb/MKC82FA095.md): Beech 65-90 · Wichita, KS · Accident · No injuries · Field investigation · Final report · Jun 4, 1982 · N190BT · Substantial damage > The plt detected a loss of eng torque at about rotation airspeed about 1700 ft down the rwy & the takeoff was aborted. The acft slid into a ditch off the end of the rwy collapsing the main gear. A functional check of the right eng fuel pump, P/N4V146R002,… - [NTSB ATL82FKQ13](https://openairdocs.org/ntsb/ATL82FKQ13.md): Cessna 182P · Winona, MS · Accident · Serious injuries · Final report · Jun 2, 1982 · N52562 · Substantial damage > The pilot stated that after a takeoff run, the controls locked and he could not pull the aircraft off of the runway. Subsequently, the plane collided with a dirt bank beyond the end of the runway, became inverted, and slid backwards. An inspection of the… - [NTSB SEA82FYM17](https://openairdocs.org/ntsb/SEA82FYM17.md): Piper PA-18 · Yamhill, OR · Accident · 1 fatal · Final report · Jun 1, 1982 · N7525K · Destroyed > During takeoff the aircraft veered off the right side of runway 8 and collided with a split rail fence. The aircraft then crossed a gravel road and struck a wire cattle fence catching on fire within seconds after coming to a stop. The winds were out of the… - [NTSB SEA82DA079](https://openairdocs.org/ntsb/SEA82DA079.md): Cessna 177 · Waldport, OR · Accident · No injuries · Final report · May 31, 1982 · N6777T · Substantial damage > The pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area. - [NTSB MIA82DA126](https://openairdocs.org/ntsb/MIA82DA126.md): Piper PA-38-112 · Ft. Pierce, FL · Accident · No injuries · Final report · May 31, 1982 · N9655T · Substantial damage > According to the student pilot, the nose gear collapsed during the takeoff roll after he applied back pressure for a climb attitude at about 60 to 62 knots. He stated that the aircraft did not want to climb, and simultaneously, the nose dropped. An… - [NTSB NYC82FNA14](https://openairdocs.org/ntsb/NYC82FNA14.md): Thurston Teal TSC-1A · Methuen, MA · Accident · 1 fatal · Final report · May 30, 1982 · N2002T · Substantial damage > The pilot was practicing takeoffs and landings on a river in an amphibian aircraft. After a landing, the pilot commenceda high speed taxi takeoff. When violent shaking started the pilot reduced power, pulled back the stick, and landed. The aircraft nosed… - [NTSB MIA82DA125](https://openairdocs.org/ntsb/MIA82DA125.md): Bell 47J-2A · Marathon, FL · Accident · No injuries · Final report · May 29, 1982 · N73268 · Destroyed > The pilot reported that an intermittent vibration was felt during the magneto check before takeoff. During a second magneto check at high power, the nose of the helicopter came up, a loud explosive noise was heard, and a fire erupted near the left fuel tank.… - [NTSB MIA82FKT10](https://openairdocs.org/ntsb/MIA82FKT10.md): Cessna 172RG · Labelle, FL · Accident · Minor injuries · Final report · May 27, 1982 · N5143V · Destroyed > The pilot and two passengers planned to depart on a flight to spot hogs for hunters. The aircraft was loaded with about 50 gallons of fuel and was near its maximum gross weight. Before takeoff, the pilot noted the wind. He reported that it was light and… - [NTSB FTW82DA198](https://openairdocs.org/ntsb/FTW82DA198.md): Bell 47D1 · Jonesboro, AR · Accident · No injuries · Final report · May 25, 1982 · N6851 · Destroyed > After loading 40 gallons of herbicide on the aircraft the pilot attempted to lift off the back of the loading truck. The takeoff was normal; however, as the helicopter cleared the truck, it was not able to sustain a hover. The pilot then executed a running… - [NTSB ATL82DA141](https://openairdocs.org/ntsb/ATL82DA141.md): Cessna 170A · Pettibois Islan, MS · Accident · No injuries · Final report · May 23, 1982 · N9196A · Substantial damage > The pilot stated that he landed safely on an island after noticing that the engine cowling started to work loose. He successfully repaired the problem but nosed over on the sandy surface during takeoff. - [NTSB MKC82DA086](https://openairdocs.org/ntsb/MKC82DA086.md): Piper PA-28-140 · Columbia, MO · Accident · No injuries · Final report · May 20, 1982 · N6527W · Substantial damage > Due to abnormal engine sounds the pilot elected to abort the takeoff. The aircraft could not be stopped on the remaining runway and rolled into a ditch. The pilot stated that during his preflight he was unable to remove all the water in the fuel by draining… - [NTSB ATL82FIJ03](https://openairdocs.org/ntsb/ATL82FIJ03.md): Bell 206B · Gate City, VA · Accident · Serious injuries · Final report · May 20, 1982 · N5002X · Substantial damage > This was an external load operation to move seismographic oil exploration equipment. The pilot flew to the loading zone with a 150 ft cable and an aluminum bucket. After arriving, he lowered the bucket and hovered while the bucket was loaded. The pilot then… - [NTSB ATL82DA147](https://openairdocs.org/ntsb/ATL82DA147.md): Piper J3C-65 · Charlotte, NC · Accident · No injuries · Final report · May 16, 1982 · N42102 · Substantial damage > The pilot stated that during takeoff roll he turned and reached for a bag that had started to fall out the door. The right wing of the aircraft struck the ground causing the aircraft to turn sideways and collapse the gear. - [NTSB ATL82DA136](https://openairdocs.org/ntsb/ATL82DA136.md): Cessna 150 · Buford, GA · Accident · Minor injuries · Final report · May 16, 1982 · N7588G · Substantial damage > The pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled… - [NTSB ANC82DAG25](https://openairdocs.org/ntsb/ANC82DAG25.md): Cessna 180C · Latouche Island, AK · Accident · No injuries · Final report · May 15, 1982 · N9366T · Substantial damage > A takeoff was initiated from a dry gravel strip in calm wind conditions. The pilot reported that just prior to lift-off, the main landing gear rolled over a 2 x 12 inch board that flipped up and struck the right elevator. Reportedly, a part of the elevator… - [NTSB FTW82DA177](https://openairdocs.org/ntsb/FTW82DA177.md): Grumman G-164A · Elreno, OK · Accident · No injuries · Final report · May 13, 1982 · N7843 · Destroyed > During takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=160 ## 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=159 --- 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.