# 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 140 of 281 · 14,038 cases ## Cases, newest first - [NTSB MIA87LA029](https://openairdocs.org/ntsb/MIA87LA029.md): Cessna 152 · Polarville, MS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1986 · N89543 · Substantial damage > The plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft… - [NTSB CHI87LA020](https://openairdocs.org/ntsb/CHI87LA020.md): Cessna 310R · Belvidere, IL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1986 · N6096C · Substantial damage > During takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to… - [NTSB DEN87LA015](https://openairdocs.org/ntsb/DEN87LA015.md): Bellanca 7GCAA · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Nov 4, 1986 · N5057U · Substantial damage > The student plt lost control on takeoff, departed the runway to the left and collided with a sewage pond. - [NTSB FTW87LA012](https://openairdocs.org/ntsb/FTW87LA012.md): Beech P-35 · Clarendon, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1986 · N8532M · Destroyed > The plt was attempting a takeoff with a 12 kt quartering tailwind when the accident occurred. Immediately following rotation and gear retraction, the acft settled and impacted the terrain. - [NTSB FTW87LA010](https://openairdocs.org/ntsb/FTW87LA010.md): Piper PA-28-161 · Lake Dallas, TX · Accident · No injuries · Limited investigation · Final report · Oct 29, 1986 · N8289N · Substantial damage > During a local flt, the plt elected to make a touch-&-go landing on a 2800 ft rwy at Lake Dallas, TX. He said that the acft touched down on the 1st quarter of the rwy, then he lowered the nose, retracted the flaps & applied full power to takeoff. However, he… - [NTSB SEA87LA013](https://openairdocs.org/ntsb/SEA87LA013.md): Cessna 180K · Burlington, WA · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N64212 · Substantial damage > Plt was taking off in fog from wet grass strip. Acft swerved left, plt unable to arrest with opposite rudder and brake, collided with fence. Abort not attempted. - [NTSB LAX87LA024](https://openairdocs.org/ntsb/LAX87LA024.md): Cessna 182M · Gila Bend, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 1986 · N91797 · Substantial damage > The acft veered off the rwy during takeoff ground run and nosed over. The plt inidcated that during the takeoff his seat slid rearward and he was unable to reach the throttle or the rudder pedals. The acft departed the rwy to the left into vegetated desert… - [NTSB LAX87LA023](https://openairdocs.org/ntsb/LAX87LA023.md): Cessna 152 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Oct 22, 1986 · N67752 · Substantial damage > During a first solo instructional flight, the pilot was taking off from his third touch-and-go when at an altitude of approximately 10 feet AGL the right wing was suddenly rose. The aircraft then veered to the left. The left main gear then collided with a… - [NTSB DEN87FA007](https://openairdocs.org/ntsb/DEN87FA007.md): Piper PA-24-250 · Crosby, ND · Accident · 4 fatal · Field investigation · Final report · Oct 22, 1986 · N8271P · Destroyed > Crosby municipal arpt was notam'd closed due to rwy construction and resurfacing. The plt and paxs were employees of the engineering company participating in the arpt construction. The plt of N8271P had landed on the closed rwy earlier in the day. The rwy was… - [NTSB NYC87FA021](https://openairdocs.org/ntsb/NYC87FA021.md): Piper PA-28-235 · Jamestown, NY · Accident · 2 fatal · Field investigation · Final report · Oct 18, 1986 · N33808 · Destroyed > The non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to… - [NTSB NYC87FA020](https://openairdocs.org/ntsb/NYC87FA020.md): Cessna 182E · Fishers Island, NY · Accident · 2 fatal · Field investigation · Final report · Oct 16, 1986 · N2830Y · 2 aircraft · Destroyed > A Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally… - [NTSB LAX87FA017](https://openairdocs.org/ntsb/LAX87FA017.md): Bell 206B-3 · Lompoc, CA · Accident · 2 fatal · Field investigation · Final report · Oct 16, 1986 · N3182V · Destroyed > The helipad deck at the stern of the barge was covered with a loosely secured rope net and witnesses reported that as the helicopter lifted up to a hover the net came up 'caught on the rear of the left skid.' The acft was seen to hover for a moment with the… - [NTSB NYC87FA015](https://openairdocs.org/ntsb/NYC87FA015.md): Cessna 185 · Greenville, ME · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1986 · N61438 · Substantial damage > Th plt stated that the acft encountered crosswinds of 20 KTS gusting to 30 KTS as the acft was coming off the step during liftoff in the open lake. The acft's right wing was forced down, the right float struck the water which resulted in the right wing… - [NTSB SEA87LA009](https://openairdocs.org/ntsb/SEA87LA009.md): Cessna 165 · Emmett, ID · Accident · No injuries · Limited investigation · Final report · Oct 12, 1986 · N25468 · Substantial damage > Directional control was lost during takeoff roll and a groundloop occurred. This was the pilots first flight in a tail wheel aircraft. - [NTSB DEN87LA001](https://openairdocs.org/ntsb/DEN87LA001.md): Cessna 177RG · Glenwood Spring, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1986 · N33215 · Destroyed > While on takeoff the acft became airborne, settled back onto the rwy, ran off the end of the rwy into a 150 foot deep river gorge, and impacted in the river. - [NTSB LAX87LA007](https://openairdocs.org/ntsb/LAX87LA007.md): Cessna 180 · Lucerne Valley, CA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1986 · N1750C · Substantial damage > The pilot stated that the wind had been light and variable with intermittent gusts and on the take-off roll as the nose of the aircraft suddenly swung 30 degrees to the left and he was unable to compensate with right rudder. The right wing tip then dug into… - [NTSB BFO87DID01](https://openairdocs.org/ntsb/BFO87DID01.md): Piper PA-28RT-201 · Lynchburg, VA · Accident · No injuries · Final report · Oct 4, 1986 · N3005V · Substantial damage > While on the takeoff roll, the acft collided with a deer. The plt rprtd that he had accelerated to 50 KTS & was about 1000 ft down the rwy when the deer ran in front of the - [NTSB LAX87LA003](https://openairdocs.org/ntsb/LAX87LA003.md): Cessna 152 · Torrance, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1986 · N24285 · Substantial damage > A Cessna 152 went out of control during takeoff ground run and then collided with a dirt bank and nosed over. The student plt indicated that he was practicing touch and go landings when the accident occurred. He had just applied takeoff power after landing… - [NTSB ANC86LA167](https://openairdocs.org/ntsb/ANC86LA167.md): de Havilland DHC-2 · Fognak Island, AK · Accident · No injuries · Limited investigation · Final report · Oct 1, 1986 · N5354G · Substantial damage > On takeoff, the right door popped open. The pilot reached across to pull the door closed and lost directional control of the aircraft. The aircraft then struck a tree near the bank of the lake. - [NTSB LAX86FUG06](https://openairdocs.org/ntsb/LAX86FUG06.md): Cessna 188 · Thermal, CA · Accident · No injuries · Final report · Sep 30, 1986 · N70240 · Substantial damage > The plt lost directional control of the acft during his 4th takeoff from the rutted rwy surface. The tail wheel slipped into a rut on the rwy and the acft veered to the right where it contacted 8-10 ft tall brush. The acft traveled through the brush,… - [NTSB FTW86LA174](https://openairdocs.org/ntsb/FTW86LA174.md): Beech TC-45J · Laredo, TX · Accident · No injuries · Limited investigation · Final report · Sep 30, 1986 · N706M · Substantial damage > Just after the plt began the takeoff roll, the right main landing gear collapsed. An exam revealed that overload failure of the right main landing gear trunion tube had occurred. There was evidence that the overload resulted from either a previous hard… - [NTSB ATL86LLT09](https://openairdocs.org/ntsb/ATL86LLT09.md): Beech 35A · Nashville, TN · Accident · No injuries · Final report · Sep 27, 1986 · N676B · Substantial damage > The student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his… - [NTSB ANC86LA166](https://openairdocs.org/ntsb/ANC86LA166.md): Piper PA-18 · Pilot Point, AK · Accident · No injuries · Limited investigation · Final report · Sep 27, 1986 · N4371A · Substantial damage > The Pilot reported that he lost control of the airplane during the takeoff run on a dirt road. The accident occurred as the plane was going around a curve in the roadway. - [NTSB CHI86LA232](https://openairdocs.org/ntsb/CHI86LA232.md): Mcculloch J-2 · Rush City, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1986 · N90563 · Destroyed > Just after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the… - [NTSB CHI86FA235](https://openairdocs.org/ntsb/CHI86FA235.md): Fairchild SA-266TC · Galesburg, IL · Accident · No injuries · Field investigation · Final report · Sep 25, 1986 · N327BA · Substantial damage > All landing gear on the aircraft prematurely retracted during takoff rotation. The captain aborted the takeoff and the aircraft slid to a stop on the runway. Subsequent gear retraction tests revealed no mechanical malfunctions within the landing gear system.… - [NTSB SEA86LA246](https://openairdocs.org/ntsb/SEA86LA246.md): Grumman AA5 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 15, 1986 · N28987 · Substantial damage > The plt had been waiting in line for takeoff on runway 16 for over an hour, due to traffic departing air races. When cleared to depart, winds were 300 deg at 15 KTS, gusting to 22 KTS. Plt elected to attempt takeoff, became momentarily airborne with stall… - [NTSB NYC86LA236](https://openairdocs.org/ntsb/NYC86LA236.md): Cessna 172N · Pedricktown, NJ · Accident · No injuries · Limited investigation · Final report · Sep 14, 1986 · N738HZ · Substantial damage > Flight encountered a gust of wind on takeoff, ran off the left side and collided with a sewer ditch. The aircraft flipped over and received substantial damage. - [NTSB FTW86FPA27](https://openairdocs.org/ntsb/FTW86FPA27.md): Piper PA-25-235 · Marlin, TX · Accident · Minor injuries · Final report · Sep 13, 1986 · N7759Z · Destroyed > The plt reported the eng quit during a right turn after takeoff at an alt of aprx 200 ft AGL. The acft crashed in a heavily wooded area aprx 1/4 mile west of the arpt. Cause of the eng failure was not determined. - [NTSB CHI86LA223](https://openairdocs.org/ntsb/CHI86LA223.md): Piper PA-24-180 · Danville, IN · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N7277P · Substantial damage > The aircraft veered off the left side of the gravel runway during the takeoff ground roll. The pilot stated that the airstrip was surrounded by cornstalks, and that on the left side of the airstrip, there was deep loose gravel. Reportedly, the loose gravel… - [NTSB ANC86LA147](https://openairdocs.org/ntsb/ANC86LA147.md): de Havilland DHC-2 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 1986 · N100KL · Substantial damage > The pilot was unable to avoid a large floating log in his water lane path during takeoff. He struck the log, lost control of the airplane and crashed. - [NTSB SEA86IA240](https://openairdocs.org/ntsb/SEA86IA240.md): Cameron D-50 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Sep 7, 1986 · GBMCT · Minor damage > The acft plt and gnd crew were conducting gnd handling and mooring procedures. The plan was to ascend about 10 ft AGL over the fld. The fld was in a depression surrounded by tall trees and se of a 400 ft AGL radio twr. During lift off the gnd crew held the… - [NTSB DEN86MA241](https://openairdocs.org/ntsb/DEN86MA241.md): Cessna 441 · Lander, WY · Accident · 7 fatal · Major investigation · Final report · Aug 29, 1986 · N2727A · Destroyed > On 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.… - [NTSB ATL86FEK06](https://openairdocs.org/ntsb/ATL86FEK06.md): Sunburst N/A · Lima, OH · Accident · No injuries · Final report · Aug 29, 1986 · UNREG · Destroyed > According to the plt, the ultralight was being taxied when a gust of wind caused it to become airborne. The plt elected to fly around the traffic pattern and return for a landing, however, while airborne it was noted the ailerons were locked in the left bank… - [NTSB ATL86FA227](https://openairdocs.org/ntsb/ATL86FA227.md): Cessna 421C · Nashville, TN · Accident · No injuries · Field investigation · Final report · Aug 25, 1986 · N5299J · Substantial damage > During a normal takeoff the pilot experienced a dual engine failure about 10 feet above the runway. The pilot stated that he landed on the remaining runway and attempted an 80 degree left turn onto taxiway 'c'. The aircraft failed to negotiate the turn at the… - [NTSB NYC86LA217](https://openairdocs.org/ntsb/NYC86LA217.md): Champion 7ECA · Lakewood, NJ · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N5238X · Substantial damage > The flight encountered a strong gust of crosswind while taking off. The pilot was unable to correct and lost control of the aircraft at which time the aircraft ran off the rwy and nosed over. - [NTSB ANC86LA128](https://openairdocs.org/ntsb/ANC86LA128.md): Cessna 185-F · Caribou Lake, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1986 · N3367R · Substantial damage > The aircraft settled back on the water and the pilot lost control of the aircraft causing it to nose over on its back. - [NTSB LAX86LA325](https://openairdocs.org/ntsb/LAX86LA325.md): Luscombe 8E · Fallbrook, CA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1986 · N2568K · Substantial damage > The acft went out of control during the takeoff ground run on rwy 18 and collided with the terrain. The plt indicated he lost control while attempting a rolling takeoff after taxiing into position on the rwy without stopping. He stated he normally stopped the… - [NTSB ATL86FA222](https://openairdocs.org/ntsb/ATL86FA222.md): Mooney M20C · Hillsville, VA · Accident · Serious injuries · Field investigation · Final report · Aug 16, 1986 · N3986N · Destroyed > The plt, also an A&P and IA, had flown the acft on the previous day and noted RPM at 2500 on initial climb. On the accident flt, the acft was loaded to near max gross weight and takeoff was attempted at a density alt of 4810 ft MSL. The acft used about 3/4 of… - [NTSB ANC86LA129](https://openairdocs.org/ntsb/ANC86LA129.md): Cessna T-210 · Alexander Lodge, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1986 · N219RG · Substantial damage > During the takeoff roll on a dirt airstrip the pilot lost directional control of the aircraft causing the aircraft to exit the right side of the runway and nose over on its back. - [NTSB ATL86FKG10](https://openairdocs.org/ntsb/ATL86FKG10.md): Grumman American G-164A · Quitman, GA · Accident · Minor injuries · Final report · Aug 15, 1986 · N31185 · Substantial damage > Shortly after takeoff a loss of pwr was experienced. The plt attempted to land in a cotton field but the landing gear contacted a stump short of the field. The acft then contacted a ditch and nosed over. Post accident inspection revealed the supercharger… - [NTSB SEA86LA205](https://openairdocs.org/ntsb/SEA86LA205.md): Mooney M20 · Quincey, WA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1986 · N9517M · Substantial damage > The pilot stated he had mad a normal landing on a paved city street in a housing dvelopment thinking that it was the Quincey municipal airport. After the pilot realized he ahd made a mistake a take off was attempted. During the take off the pilot aborted the… - [NTSB NYC86LA209](https://openairdocs.org/ntsb/NYC86LA209.md): Cessna 150 · Springfield, VT · Accident · No injuries · Limited investigation · Final report · Aug 12, 1986 · N6455G · Substantial damage > The plt lost directional control of the acft during takeoff run. The acft traveled off the side of the rwy into tall grass and nosed over. The plt stated that he may have pressed the brake pedal inadvertently instead of the rudder. - [NTSB MIA86LA234](https://openairdocs.org/ntsb/MIA86LA234.md): Beech F-33-C · Live Oak, FL · Accident · No injuries · Limited investigation · Final report · Aug 12, 1986 · N58MC · Substantial damage > Plt noted approaching thunderstorm to east and elected to depart to the west due to the current wind being calm. During the takeoff roll a sudden gust from the left rear caused the pilot to loose directional control and the aircraft went off the left side of… - [NTSB SEA86LA204](https://openairdocs.org/ntsb/SEA86LA204.md): Bell 206L-1 · Grangeville, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1986 · N1083Z · Destroyed > The helicopter plt was on an emergency medical service (ems/medivac) flt to transport survivors from an airplane accident. He landed at night on a ridge about 1/4 mi from the airplane crash site. At about 2400 MDT, the plt attempted to takeoff from the… - [NTSB ANC86LA123](https://openairdocs.org/ntsb/ANC86LA123.md): Champion 7GCBC · Kuskatan River, AK · Accident · No injuries · Limited investigation · Final report · Aug 7, 1986 · N1163E · Substantial damage > During the takeoff roll on a River gravel bar, the pilot lost directional control of the aircraft causing the aircraft to nose over on its back. - [NTSB NYC86LA202](https://openairdocs.org/ntsb/NYC86LA202.md): Learjet 55 · Rutland, VT · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 1986 · N921FP · Destroyed > The lear 55 taxied out for takeoff and inadvertently attempted a takeoff on the wrong runway. When he realized his mistake, he aborted the takeoff because he knew the runway length was significently less than his required field length. Insufficient runway… - [NTSB LAX86LA313](https://openairdocs.org/ntsb/LAX86LA313.md): Cessna 152 · Apple Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1986 · N757QR · Substantial damage > A Cessna 152 overran rwy 36 and nosed over on the overrun area. The student plt indicated that he attempted the takeoff from mid-field on rwy 36 without taking into account the density alt. He also stated that he attempted to abort the takeoff after reaching… - [NTSB ANC86LA120](https://openairdocs.org/ntsb/ANC86LA120.md): Navion D-16 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1986 · N50TA · Substantial damage > The left fuel valve was in the off position at the time of the takeoff. The pilot attempted to lift-off below the recommended VMC speed. The pilot lost control of the aircraft causing the aircraft to exit the left side of the runway into a lake. - [NTSB FTW86FA142](https://openairdocs.org/ntsb/FTW86FA142.md): Bell 206B · Watson, OK · Accident · Serious injuries · Field investigation · Final report · Aug 4, 1986 · N33W · Substantial damage > Pilot of Bell 206B conducting forestry operations experienced problem with fire dispensing apparatus being slung beneath aircraft while returning to helipad for fuel. Pilot landed, released external load, and got out of aircraft to release electrical… - [NTSB CHI86LA186](https://openairdocs.org/ntsb/CHI86LA186.md): Schweizer SGS 2-33A · Mattoon, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1986 · N65901 · Substantial damage > The glider was being towed for takeoff behind a tow plane. According to the glider instructor, the initial acceleration appeared normal. As the tow plane and the glider neared the end of the runway, the glider instructor believed the tow plane was… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=141 ## 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=140 --- 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.