# 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 153 of 281 · 14,038 cases ## Cases, newest first - [NTSB MKC83FU007](https://openairdocs.org/ntsb/MKC83FU007.md): Airmass Sunburst · Goddard, KS · Accident · Serious injuries · Final report · Sep 11, 1983 · UNREG · Substantial damage > The plt landed in a vacant field, aprx 1500 ft long, surrounded by a row of trees. Before initiating a takeoff, he made a ground reconnaissance of the area. The field was covered with grass aprx 6 to 9 inches tall & was oriented on a north-south direction.… - [NTSB NYC83LA240](https://openairdocs.org/ntsb/NYC83LA240.md): Beech 58P · Lebanon, NH · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N64200 · Destroyed > According to the plt there was a sudden power fluctuation at(rotation speed). The plt then aborted the takeoff but couldnot stop the acft before departing the rwy. - [NTSB DEN83LA211](https://openairdocs.org/ntsb/DEN83LA211.md): Piper PA-18 · Breckenridge, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1983 · N2621K · Substantial damage > After landing on a private arpt that was closed to public use, the plt was prohibited from using it to takeoff again. He received permission from the owner of a gravel plt to use his 'haul road' which was located next to the arpt. The elevation of the road… - [NTSB ATL83LA362](https://openairdocs.org/ntsb/ATL83LA362.md): Beech 58 · Chamblee, GA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N333TQ · Substantial damage > The acft ran off the departure end of the rwy after an aborted takeoff due to a cabin door opening. The CFI said that more than half the rwy remained when the throttles were retarded and the right door popped open at 91 mph. One attempt was made to close the… - [NTSB MKC83LA218](https://openairdocs.org/ntsb/MKC83LA218.md): Cessna 188B · Catron, MO · Accident · No injuries · Limited investigation · Final report · Sep 8, 1983 · N4889Q · Substantial damage > The acft went out of control during the takeoff roll from a farm field. The plt states that as the roll began the left wing started to drop and the acft began turning left. The plt tried to correct with right brake but was unable to make a correction. The… - [NTSB LAX83LA428](https://openairdocs.org/ntsb/LAX83LA428.md): Cessna 172N · Novato, CA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1983 · N2333E · Substantial damage > The plt stated that he attempted to takeoff in strong x-wind conditions. During the takeoff roll, the acft veered off the right side of the rwy. After unsuccessfully trying to get back onto the rwy, the plt aborted the takeoff. However, the acft continued… - [NTSB SEA83LA200](https://openairdocs.org/ntsb/SEA83LA200.md): Maule M-4 · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N4623T · Substantial damage > The plt reported that he was practicing touch-and-go landings with a friend that was a certified flt instructor (CFI). After a landing, the friend indicated his desire to fly the acft. The plt offered to let his friend fly it from the left seat. The friend… - [NTSB CHI83LA404](https://openairdocs.org/ntsb/CHI83LA404.md): Mockrud Volksplane · Cottage Grove, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1983 · N4244R · Destroyed > The owner of the new home built acft had given the plt permission to taxi the plane, but not to takeoff. The plt stated that he inadvertently became airborne while making a high speed taxi check, then the eng lost power. A witness stated that the acft became… - [NTSB DEN83LU004](https://openairdocs.org/ntsb/DEN83LU004.md): Starflight Starfire · Grand Junction, CO · Accident · Serious injuries · Final report · Aug 30, 1983 · UNREG · Minor damage > According to the pilot, he was trying to get the feel of the vehicle and was taking it about 1 foot off the ground before setting it back down. On the final takeoff, the wind lifted the acft up to about 15-20 feet and it stalled. As the pilot was attempting… - [NTSB FTW83LA403](https://openairdocs.org/ntsb/FTW83LA403.md): Cessna 140 · Hitchcock, TX · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N3625V · Substantial damage > The acft nosed over during takeoff. The flt said that the rwy was 50 ft wide but had been mowed only to a width of 20 ftthe plt allowed the acft to drift into the high grass alongside the rwy. The acft continued off the rwy and nosed over in tail grass.… - [NTSB ATL83LA343](https://openairdocs.org/ntsb/ATL83LA343.md): Smith, Ted Aerostar 600-A · Florala, AL · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N139TS · Destroyed > The pilot stated that during takeoff roll he experienced a power surge but the engine did not quit. He aborted the takeoff by reducing power on both engines and applying brakes. This resulted in the aircraft swerving off the right side of the runway, rolling… - [NTSB SEA83LA184](https://openairdocs.org/ntsb/SEA83LA184.md): Cessna 180 · Colburn, ID · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N3239D · Substantial damage > The acft collided with a fence and a ditch during an overrun while landing. The pilot reported he took off with the pitot tube cover on and had flown 7 miles to a private airstrip. The strip was reported to be about 1300 ft long. The pilot stated he landed… - [NTSB LAX83LA418](https://openairdocs.org/ntsb/LAX83LA418.md): Cessna 172P · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N62038 · Substantial damage > The student & his instructor plt had made 2 takeoffs & landings, then the instructor deplaned & the student prepared to takeoff on a solo flt. According to the student, he made the pretakeoff checks, which included setting the trim. As the acft accelerated… - [NTSB CHI83LA400](https://openairdocs.org/ntsb/CHI83LA400.md): Piper PA-28-181 · Blair, WI · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N3576R · Substantial damage > The acft collided with a fence during an aborted takeoff. The student was on a solo training flt when the accident occurred. This was the first takeoff of the flt. The field was soft and the pilot decided to abort the takeoff during the ground roll. He was… - [NTSB CHI83LA396](https://openairdocs.org/ntsb/CHI83LA396.md): Cessna 172 · Princeton, IL · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N12862 · Substantial damage > The turf rwy was wet from recent rains. The plt stated that during takeoff, the acft had accelerated to near the rotation speed when it was slowed by a soft spot in the rwy near mid field. At the same point, an upslope portion of the rwy was encountered & the… - [NTSB SEA83LA194](https://openairdocs.org/ntsb/SEA83LA194.md): Enstrom 280C · N. Hailey, ID · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N999TP · Substantial damage > The plt reported that during takeoff from a county road (elevation 5500 ft), he allowed the RPM to drop 'below green.' Reportedly, he had a choice of either setting the helicopter down on the road or flying down a slope to gain airspeed. He elected to land on… - [NTSB NYC83LA227](https://openairdocs.org/ntsb/NYC83LA227.md): Cessna 152 · Brockport, NY · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N48903 · Substantial damage > The CFI and student plt had conducted about 4 touch & go landings prior to the CFI authorizing a first solo takeoff. According to the CFI, at about 1/3 of the way down the runway, the acft drifted to the left onto the grass and continued until contact with a… - [NTSB CHI83FU010](https://openairdocs.org/ntsb/CHI83FU010.md): Teratorn Tierra · Pepin, WI · Accident · 1 fatal · Final report · Aug 24, 1983 · UNREG · Destroyed > The plt had recently purchased & assembled the ultralight vehicle. The person who sold him the ultralight said that he saw the vehicle on the night before. According to him, it 'looked like he had it together all right.' He said it was his impression the plt… - [NTSB LAX83LA407](https://openairdocs.org/ntsb/LAX83LA407.md): Grumman G-164B · Poston, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1983 · N6757Q · Substantial damage > During takeoff from the unlighted strip the acft went off the right side. The right main landing gear went into the softsandy shoulder & the acft flipped over. - [NTSB MIA83LA211](https://openairdocs.org/ntsb/MIA83LA211.md): Cessna 188 · Jay, FL · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N9261G · Substantial damage > The plt reported that he tried to take off on a hot day with a heavy lord, but the acft would not perform sufficiently to climb over a drainage terrace at the departure end of the rwy. The acft bumped the drainage terrace & continued flying, but would not… - [NTSB FTW83LA391](https://openairdocs.org/ntsb/FTW83LA391.md): Grumman G-164B · Lissie, TX · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N48516 · Substantial damage > The acft ran into a ditch during takeoff and collapsed the landing gear. The plt said he was steering around some mud holes when the wing became entangled in high grass alongside the rwy. The acft groundlooped off the rwy into a ditch. The wings and landing… - [NTSB MIA83FA208](https://openairdocs.org/ntsb/MIA83FA208.md): Condor II · Perrine, FL · Accident · Serious injuries · Field investigation · Final report · Aug 19, 1983 · N103HL · Substantial damage > The plt was on a flt to test a new liquid cooled eng & its radiator size & location. On previous flts, he had noted inadequate cooling. Company personnel had moved the radiator to improved its efficiency. On the previous flt, the plt noted that the temp gage… - [NTSB LAX83LA404](https://openairdocs.org/ntsb/LAX83LA404.md): Cessna P21O · Goldfield, NV · Accident · No injuries · Limited investigation · Final report · Aug 19, 1983 · N4818K · Substantial damage > The acft collided with a cattle guard during an attempted takeoff from a road. The plt elected the road rather than the airstrip which was made of gravel and was wet and muddy. He stated that there was about 4000 ft of flat straight road available and he set… - [NTSB ATL83LA329](https://openairdocs.org/ntsb/ATL83LA329.md): Cessna A 152 · Lynchburg, VA · Accident · No injuries · Limited investigation · Final report · Aug 19, 1983 · N47281 · Substantial damage > The acft ran off the rwy and collided with a ditch during takeoff. The student pilot was practicing touch and go landings. During one running takeoff after full power was applied the plt noticed that full flaps were still extended. While retracting the flaps… - [NTSB ANC83LA149](https://openairdocs.org/ntsb/ANC83LA149.md): Cessna T-207A · Atmautluak, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 1983 · N73789 · Substantial damage > The plt stated that during the takeoff roll, his seat slid backwards & he was unable to reach the controls. Subsequently, the acft veered to the right, departed the rwy & went into a shallow pond. The plt reported that the seat latch malfunctioned & was… - [NTSB MKC83LA195](https://openairdocs.org/ntsb/MKC83LA195.md): Cessna 150L · S. Sioux City, NE · Accident · No injuries · Limited investigation · Final report · Aug 17, 1983 · N1911F · Substantial damage > The plt reported that during a touch-and-go landing on rwy 14 with a southerly wind at 8 KTS, he touched down about 1/4 of the way down the rwy with 20 deg of flaps. The temp was 93 deg & the density altitude was aprx 3800 ft. the plt did not raise the flaps… - [NTSB LAX83FA390](https://openairdocs.org/ntsb/LAX83FA390.md): Piper PA-28-181 · Santa Rosa, CA · Accident · 2 fatal · Field investigation · Final report · Aug 17, 1983 · N5698V · Destroyed > The non-instrument rated plt & a passenger took off from the arpt at dawn before the control tower was in operation. The takeoff was at 0549 PDT in IMC conditions. Shortly after taking off, the acft crashed. One witness stated that he heard the acft takeoff… - [NTSB CHI83LA385](https://openairdocs.org/ntsb/CHI83LA385.md): Cessna 150 · Savanna, IL · Accident · No injuries · Limited investigation · Final report · Aug 17, 1983 · N11279 · Destroyed > The plt reported the winds were from 160 deg at 7 KTS & that he back taxied on rwy 14 to takeoff. He reported that during the takeoff roll, he encountered a right x-wind, & when he was aprx 2/3 of the way down the rwy, the acft veered to the left. After… - [NTSB FTW83LA382](https://openairdocs.org/ntsb/FTW83LA382.md): Grumman G-164C · Newport, AR · Accident · No injuries · Limited investigation · Final report · Aug 16, 1983 · N6677K · Destroyed > The acft caught fire during takeoff roll and continued to burn after the aborted takeoff. Prior to this flt the operatorhad experienced difficulty with the carburator on this engine. On this flt the acft was being ferried for carburetor maintenance. During… - [NTSB CHI83LA384](https://openairdocs.org/ntsb/CHI83LA384.md): Piper PA-38-112 · Blue Island, IL · Accident · No injuries · Limited investigation · Final report · Aug 15, 1983 · N2527N · Substantial damage > Acft ran off side of rwy & the left wing collided with corn stalks causing the acft to spin 180 deg. - [NTSB ANC83LA147](https://openairdocs.org/ntsb/ANC83LA147.md): Piper PA-18-150 · Eagle, AK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1983 · N4894A · Substantial damage > The pilot stated that he felt the engine did not develop full power during takeoff, possibly due to formation of carburetor ice during rain showers. Instead of aborting, he continued and the acft struck trees on the departure. - [NTSB LAX83LA380](https://openairdocs.org/ntsb/LAX83LA380.md): Cessna 172P · Jean, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1983 · N52023 · Substantial damage > The plt took off from the mccarran intl arpt, las vegas, NV & flew to another arpt in the local area at Jean, NV to practice soft field takeoff & landing techniques. During his 1st soft field takeoff, he over rotated the acft & the tail cone contacted the… - [NTSB CHI83LA376](https://openairdocs.org/ntsb/CHI83LA376.md): Beech S35 · Austin, MN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N5732K · Substantial damage > The plt started to takeoff on rwy 35 with a wind from 300 deg at 19, gusting 25 KTS. During the takeoff roll, the right door popped open & the acft veered to the left. Reportedly, the plt intended to continue the takeoff (to circle, land & fix the door).… - [NTSB LAX83LA379](https://openairdocs.org/ntsb/LAX83LA379.md): Alon A2 · Afton, CA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N6512Q · Substantial damage > During an aerial observation mission, the passenger became ill, so the plt elected to land on a hard-packed strip across a plowed field. After landing, he walked over the area. Except for a rut at about midfield, he perceived there would be no problem in… - [NTSB MKC83LA183](https://openairdocs.org/ntsb/MKC83LA183.md): Beech M35 · Sioux City, IA · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N555M · Substantial damage > The plt stated that the landing gear switch was down when he started tha takeoff roll. When the acft had accelerated to aprx 50 mph during the takeoff roll, the landing gear retracted/collapsed, nose wheel first, followed by the main gear. The plt stated that… - [NTSB MKC83LA182](https://openairdocs.org/ntsb/MKC83LA182.md): Cessna 152 · Benton, KS · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N67621 · Substantial damage > The acft collided with a ditch during an aborted takeoff. The pilot said the takeoff was on rwy 34 which is 2600 ft longthe density alt was 4000 ft. the acft accelerated to 60 KTS but still was not lifting off. As the acft approached the departure end of the… - [NTSB DEN83LA186](https://openairdocs.org/ntsb/DEN83LA186.md): Cessna 180 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N2590K · Substantial damage > The acft groundlooped during takeoff. The plt stated that he incorrectly assumed a 14 kt headwind when the tower gave the 'winds light at fourteen' after previously assigning rwy light. After applying power he realized that he had a x-wind and cut the power.… - [NTSB NYC83FA204](https://openairdocs.org/ntsb/NYC83FA204.md): Beech S35 · Wiscasset, ME · Accident · 2 fatal · Field investigation · Final report · Aug 7, 1983 · N193H · Destroyed > The acft was observed taking off on a foggy night with a low overcast sky condition. Shortly after taking off, the plane was observed to turn at low alt, then enter a nose down attitude. The acft crashed & the non-instrument rated plt & passenger were fatally… - [NTSB FTW83LA367](https://openairdocs.org/ntsb/FTW83LA367.md): Cessna 140 · Alamagordo, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1983 · N1866V · Substantial damage > After topping the acft with fuel, the plt took of from the 4200 ft high rwy, toward the mountains. The density alt at that time was about 6700 ft. during the takeoff, the plt rotated at 50 mph, then accelerated in ground effect to 70 mph. He then started to… - [NTSB NYC83FU008](https://openairdocs.org/ntsb/NYC83FU008.md): Goldwing None · Broadalbin, NY · Accident · 1 fatal · Final report · Aug 6, 1983 · UNREG · Destroyed > The owner/builder/plt had recently constructed the home built ultralight vehicle. According to friends, he most likely had never ridden in an airplane & he believed it was possible to build & fly the ultralight with no instruction. According to the owner of a… - [NTSB CHI83LA364](https://openairdocs.org/ntsb/CHI83LA364.md): Cessna 177RG · Lansing, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 1983 · N53122 · Substantial damage > The acft had just been given an annual inspection & the plt was on the 1st flt back to the home arpt. He reported that before takeoff, he noted that the eng would not idle below 850 RPM. He elected to continue with the flt. During the takeoff roll, he pulled… - [NTSB DEN84LA185](https://openairdocs.org/ntsb/DEN84LA185.md): Piper 601P · Billings, MT · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N363VA · Substantial damage > Before starting the flt, the acft was loaded with full fuel, 5 adult passengers & aprx 45 lbs of baggage. The elevation & temp at the arpt were 3606 ft & 93 deg. The plt said he did not calculate the weight & balance or density altitude limits for this flt… - [NTSB DEN83LA182](https://openairdocs.org/ntsb/DEN83LA182.md): Helio Courier H-295 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 4, 1983 · N6484V · Substantial damage > Before starting his takeoff, the plt waited for other acft in the pattern to make touch-and-go landings. Immediately before & during his attempted takeoff, the plt saw 2 national guard helicopters hovering over a sod area, west of rwy 34. Reportedly, the 1st… - [NTSB CHI83FER01](https://openairdocs.org/ntsb/CHI83FER01.md): Goodyear FG1D · Crystal, MN · Accident · No injuries · Final report · Aug 3, 1983 · N62290 · Substantial damage > The plt reported that during the takeoff roll, there was a slight loss of manifold pressure. This was followed by a loud 'misfire', a futher loss of manifold pressure & a drop in the eng RPM. With an estimated 2000 ft of rwy remaining, he elect to abort &… - [NTSB MKC83LA170](https://openairdocs.org/ntsb/MKC83LA170.md): Monke Rotec Rally 3 · Nickerson, NE · Accident · No injuries · Limited investigation · Final report · Jul 31, 1983 · N3231B · Destroyed > The acft was a registered, home built, 2 place, ultralight vehicle. The passenger was the plt's friend who was building his own ultralight & wanted to ride along to get a general feeling of how to land this type of acft. The plt reported that the temp was 86… - [NTSB MKC83FA171](https://openairdocs.org/ntsb/MKC83FA171.md): Aeronca 11CC · Orange City, IA · Accident · Serious injuries · Field investigation · Final report · Jul 31, 1983 · N4368E · Substantial damage > The aircraft had completed a landing in a field and the pilot was attempting a takeoff from the stopping point. The aircraft did not become airborne and ran for aprx 100 feet across a boggy swamp and impacted a four foot high dirt bank. - [NTSB FTW83LA355](https://openairdocs.org/ntsb/FTW83LA355.md): Piper PA-28-161 · Cashion, OK · Accident · No injuries · Limited investigation · Final report · Jul 31, 1983 · N5999V · Substantial damage > The plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30… - [NTSB LAX83LA363](https://openairdocs.org/ntsb/LAX83LA363.md): Cessna 206 · Clifton, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1983 · N920RB · Substantial damage > The acft collided with soft terrain and nosed over during an attempted takeoff. Custom officials said the acft was being tracked on radar. The plt of the accident acft saw the customs acft after he landed and attempted to takeoff, lost control and nosed over… - [NTSB LAX83LA324](https://openairdocs.org/ntsb/LAX83LA324.md): Boeing IB75A · Tracy, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1983 · N61202 · Substantial damage > According to the operator, the pilot lost directional control about 1200 ft down the rwy, lifted off prematurely and was unable to clear trees in an almond orchard at the end ofthe rwy. Initial impact occurred 120 ft north of the rwy centerline. - [NTSB CHI83LA331](https://openairdocs.org/ntsb/CHI83LA331.md): Piper PA-28-140 · Charlotte, MI · Accident · No injuries · Limited investigation · Final report · Jul 25, 1983 · N71SA · Substantial damage > During the takeoff portion of a night touch-and-go, the acft collided with a deer that ran into the acft. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=154 ## 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=153 --- 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.