# 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 148 of 281 · 14,038 cases ## Cases, newest first - [NTSB NYC85FA003](https://openairdocs.org/ntsb/NYC85FA003.md): Beech V35 · Middletown, PA · Accident · 1 fatal · Field investigation · Final report · Oct 6, 1984 · N4447V · Destroyed > About 2 weeks before the accident, the acft was forced landed in a pasture due to a loss of power. The plt made repairs to the aircraft & attempted to fly out of the pasture. Witnesses observed the left wing come in contact with the ground during takeoff,… - [NTSB DEN85FA002](https://openairdocs.org/ntsb/DEN85FA002.md): Hamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SD · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1984 · N127MW · Destroyed > The hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch… - [NTSB ANC84LA195](https://openairdocs.org/ntsb/ANC84LA195.md): Piper PA-18 · Tikchik Lodge, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1984 · N411X · Substantial damage > The plt attempted a takeoff from a 500 ft sand bar and during the takeoff roll the main landing gear struck soft spots. Realizing the acft was not going to become airborne he closed the throttle attempting to stop in the remaining distance. The acft left the… - [NTSB LAX84LA471](https://openairdocs.org/ntsb/LAX84LA471.md): Cessna 172N · Stockton, CA · Accident · No injuries · Limited investigation · Final report · Sep 28, 1984 · N738PS · Substantial damage > According to the pilot at 50 KTS rotation was attempted but unsuccessful. At 70 KTS the takeoff abort was initiated by reducing power. At that time the acft 'jumped' into the air at about a 45 degree nose up attitude. The pilot the pushed the yoke forward and… - [NTSB SEA84LA232](https://openairdocs.org/ntsb/SEA84LA232.md): Glasair None · Burns, OR · Accident · No injuries · Limited investigation · Final report · Sep 26, 1984 · N197RL · Substantial damage > During the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the… - [NTSB LAX84LA495](https://openairdocs.org/ntsb/LAX84LA495.md): Schweizer G164 · Tulare, CA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1984 · N10230 · Destroyed > The aircraft had a full load of fuel and chemicals on board for this takeoff. The pilot stated that the brakes locked on the takeoff ground run and reduced the aircrafts acceleration. A railroad cross tie barrier at the end of the runway made an on ground… - [NTSB ANC84LA188](https://openairdocs.org/ntsb/ANC84LA188.md): Maule M-4 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1984 · N12023 · Substantial damage > The plt stated that after he lifted the tail off the rwy the acft encountered a gust of wind and he lost control swerving into a ditch adjacent to the rwy. - [NTSB LAX84LA497](https://openairdocs.org/ntsb/LAX84LA497.md): Champion 7FC · Merced, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N7545B · Substantial damage > During takeoff the plt lost control of the acft. It veered off the rwy & collided with a dirt bank. The plt indicated that his wife may have unknowingly been applying pressure to the heel brakes during the attempted takeoff. - [NTSB CHI84LA403](https://openairdocs.org/ntsb/CHI84LA403.md): Cessna 150H · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N22667 · Substantial damage > The plt stated that during the takeoff roll, the window popped open. At about that time, the acft began traveling to the left side of the rwy, but the plt elected to continue the takeoff. While in a nose high attitude to takeoff, the aft fuselage contacted a… - [NTSB LAX84LA486](https://openairdocs.org/ntsb/LAX84LA486.md): Cessna 414A · Carlsbad, CA · Accident · No injuries · Limited investigation · Final report · Sep 20, 1984 · N2700S · Destroyed > The acft was on IFR departure in minimal weather conditions. On takeoff roll, a pwr loss occurred on the rt eng and the acft veered to the rt. PIC (owner) in left seat initiated aborted takeoff, but rt seat plt took control, continued takeoff and feathered… - [NTSB DEN84FA294](https://openairdocs.org/ntsb/DEN84FA294.md): Cessna A185F · Fort Peck, MT · Accident · 1 fatal · Field investigation · Final report · Sep 20, 1984 · CGZWQ · Substantial damage > Plt attempted to takeoff from a calm part of reservoir. The wave heights were estimated to be 4 to 6 feet. The arft struck several waves during the takeoff run. The rt wing tip dragged in the water causing the acft to nose over. The acft came to rest… - [NTSB ANC84LA184](https://openairdocs.org/ntsb/ANC84LA184.md): Piper PA-18A · Montague Island, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1984 · N8469D · Substantial damage > Plt was attempting takeoff from a sand bar which was not only soft but sloped to the right toward the water. On takeoff roll, the tailwheel was raised prematurely and directional control could not be maintained with rudder. The aircraft drifted downslope… - [NTSB LAX84LA482](https://openairdocs.org/ntsb/LAX84LA482.md): Globe GC-1B · Calistoga, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1984 · N80504 · Substantial damage > The starboard entrance hatch opened during takeoff roll. The pilot aborted the takeoff. The acft could not be stopped on the remaining rwy & collided with a ditch. The takeoff was attempted with a light tailwind on a unidirectional rwy. - [NTSB FTW84LA399](https://openairdocs.org/ntsb/FTW84LA399.md): Cessna 172N · Katy, TX · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N4858G · Substantial damage > Prior to the accident the CFI and student were in the acft when it rolled into a bean field while landing on a road which divided the field. After pushing the acft back onto the road a takeoff was attempted. Directional control was lostand the acft nosed over… - [NTSB DEN84FA278](https://openairdocs.org/ntsb/DEN84FA278.md): Piper PA-18 · Meadow Lake, NM · Accident · 2 fatal · Field investigation · Final report · Sep 16, 1984 · N5895D · Destroyed > According to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about… - [NTSB FTW84LA397](https://openairdocs.org/ntsb/FTW84LA397.md): Cessna 170B · Flatonia, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 15, 1984 · N4653C · Substantial damage > The plt stated he applied full power to the eng as he started his takeoff run on rwy 15. He applied forward pressure on the control yoke to raise the tail and the acft started to drift left. The rt wing hit a tree and the acft continued into a lake. - [NTSB SEA84LA227](https://openairdocs.org/ntsb/SEA84LA227.md): Bellanca 8GCBC · Kasaan Penninsu, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 1984 · N86922 · Substantial damage > Plt attempted takeoff from glassy water with a deer tied to the left float. The right float would not come up on the step to attain lift off. The pilot's decision to abort was too late to avoid a collision with rocks at the end of the lake. - [NTSB FTW84LA385](https://openairdocs.org/ntsb/FTW84LA385.md): Cessna A188B · Maysville, OK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N9560G · Destroyed > With aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The… - [NTSB DEN84LA287](https://openairdocs.org/ntsb/DEN84LA287.md): Cessna 140 · Belgrade, MT · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N2628N · Substantial damage > The plt stated that during the takeoff ground roll on the grass airstrip the engine did not seem to produce full power when 2/3 the way down the rwy. Plt applied brakes to abort the takeoff before the tailwheel was on the ground. The acft nosed over. - [NTSB ANC84LA172](https://openairdocs.org/ntsb/ANC84LA172.md): Maule M-5-235C · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N235LY · Substantial damage > According to the plt, he was taking off from a lake when he decided that he did not have sufficient room to clear trees in his flt path. He aborted the takeoff & the acft settled onto a gravel berm & slid into tundra. The plt believed that the accident would… - [NTSB ANC84LA170](https://openairdocs.org/ntsb/ANC84LA170.md): Cessna A185F-II · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N61556 · Substantial damage > The float plane plt began taking off from a small lake in calm wind & glassy water conditions. Realizing the situation was marginal, he reduced power to abort (before lifting off) & began a step turn to the left. The plt reported that the radius of the turn… - [NTSB CHI84LA387](https://openairdocs.org/ntsb/CHI84LA387.md): Mooney M20E · Lansing, IL · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N10SF · Substantial damage > The plt had just demonstrated the acft for sale and filed an IFR flt plan. Run up and pre-takeoff checks were rushed to beat void clearance time. Just before liftoff, plt noted sluggish acceleration but believed insufficient runway remained to successfully… - [NTSB DEN84LA283](https://openairdocs.org/ntsb/DEN84LA283.md): Cessna 140 · Butte, MT · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N77271 · Substantial damage > The plt taxied to rwy 11 and got out of the acft to check the wind. The rwy lights were not operating at the time. The pilot decided that rwy 11 was the most favorable rwy and the takeoff was attempted. The wind conditions at the time off the accident were… - [NTSB ANC84LA160](https://openairdocs.org/ntsb/ANC84LA160.md): Piper PA-28 · Chistochina, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N4362V · Substantial damage > The acft collided with a car during an aborted takeoff. The plt said that the acft would not attain flying speed so halfway down the rwy she aborted the takeoff. She also said that she and her passengers removed frost off the acft for about 25 minutes before… - [NTSB ANC84LA156](https://openairdocs.org/ntsb/ANC84LA156.md): Piper PA-24-180 · Chandalar Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N5023P · Substantial damage > The plt stated that during the takeoff roll aprx 1/2 way down the gravel strip, the acft went into brush off the side of the rwy. There were no reported mechanical malfunctions. - [NTSB SEA84LA214](https://openairdocs.org/ntsb/SEA84LA214.md): Cessna 180A · Scappoose, OR · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N601N · Substantial damage > The pilot stated that during the takeoff ground run, just prior to rotation, he 'took a sharp gust of wind from the left and ground looped the aircraft.' - [NTSB LAX84FUJ03](https://openairdocs.org/ntsb/LAX84FUJ03.md): Cessna T337E · Chandler, AZ · Accident · Serious injuries · Final report · Sep 1, 1984 · N1280M · Substantial damage > The plt reported that on the first attempt to rotate, the stall warning horn activated. The plt noticed the rear eng in an overboost cond so he retarded the throttle completely, then advanced it to below red line. He continued the takeoff and attempted to… - [NTSB ANC84LA162](https://openairdocs.org/ntsb/ANC84LA162.md): Piper PA-18-150 · Rohn River, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N9474D · Substantial damage > The acft would not lift off in the distance the plt thought. The density alt was near 1500 ft and the plt had 130 lbs in the rear seat and baggage area. The plt said that the acft bounced during the roll and then ground looped. - [NTSB MKC84LA266](https://openairdocs.org/ntsb/MKC84LA266.md): Beech BE 58 · Bridgeport, NE · Accident · No injuries · Limited investigation · Final report · Aug 31, 1984 · N9726S · Substantial damage > Plt initiated take-off from rough, 2800 ft sod strip in light wind conditions and known high density alt situation. Slight back yoke pressure was being used during takeoff roll to moderate effect of rough surface on nose gear. Additional back pressure was… - [NTSB ANC84LA151](https://openairdocs.org/ntsb/ANC84LA151.md): Maule M-6-235 · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1984 · N5651D · Substantial damage > The acft collided with an overhanging tree branch during a river takeoff. The plt was trying to negotiate a bend in the river while on the 'step' for takeoff. The plt said he had very limited experience in the model acft and it got light on the floats and… - [NTSB LAX84LUJ02](https://openairdocs.org/ntsb/LAX84LUJ02.md): Cessna 188A · Salome, AZ · Accident · No injuries · Final report · Aug 27, 1984 · N8138V · Substantial damage > The plt said his prop stirred up a cloud of dust during takeoff and in a state of reduced visibility he collided with a mound of dirt. The collision separated the left main landing gear from the acft. Subtantial damage was done to the acft. - [NTSB SEA84LA213](https://openairdocs.org/ntsb/SEA84LA213.md): Piper PA-22-150 · Shoshone, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1984 · N7249D · Substantial damage > The plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over. - [NTSB MIA84IA242](https://openairdocs.org/ntsb/MIA84IA242.md): Mcdonnell Douglas DC-9-51 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Aug 25, 1984 · N411EA · Minor damage > Just prior to V1 and rotation both left main landing gear tires failed. Takeoff was aborted and acft was stopped on rwy. Pax & crew deplaned without injury. Cause of tire failure could not be determined. - [NTSB NYC84LA296](https://openairdocs.org/ntsb/NYC84LA296.md): Cessna 172P · Manville, NJ · Accident · No injuries · Limited investigation · Final report · Aug 21, 1984 · N65665 · Substantial damage > Acft swerved on rwy before rotation and climbed aprx 10 feet before settling back on the rwy. Plt aborted the takeoff but was unable to stop before end of rwy. - [NTSB NYC84LA287](https://openairdocs.org/ntsb/NYC84LA287.md): Cessna 152 · Ellicottville, NY · Accident · No injuries · Limited investigation · Final report · Aug 19, 1984 · N4905B · Substantial damage > The plt started taking off from an unimproved, grass covered fld, but the acft would not accelerate above 50 KTS. He aborted the takeoff, but the acft continued off the end of the rwy where the nose gear was torn off & the left main gear & right wing tip were… - [NTSB NYC84LA282](https://openairdocs.org/ntsb/NYC84LA282.md): Cessna 150M · Claremont, NH · Accident · No injuries · Limited investigation · Final report · Aug 19, 1984 · N63351 · Substantial damage > After a dual instructional flt, practicing landings, the student tookoff on a solo flt. He made 2 takeoffs & landings without incident. On his 3rd takeoff, the acft began drifting to the left. The student said he applied right rudder to correct the situation,… - [NTSB DEN84LA264](https://openairdocs.org/ntsb/DEN84LA264.md): Piper PA-28-140 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Aug 18, 1984 · N6431R · Substantial damage > The acft collided with a rwy light during takeoff. The plt said the acft got to about 6 ft AGL for about 100 ft and whenthe plt pushed foward on the control column the acft settled back on the rwy. During the roll the horizontal stabilizer hit a rwy light.… - [NTSB CHI84LA357](https://openairdocs.org/ntsb/CHI84LA357.md): Grumman G-164A · Rice, MN · Accident · No injuries · Limited investigation · Final report · Aug 18, 1984 · N600T · Substantial damage > Pilot stated that during the takeoff roll the acft suddenly began to pull to the left. The pilot reduced power and applied right brake and rudder to correct but the left wing struck corn stalks. Examination of the acft after the accident revealed the left… - [NTSB ANC84FA140](https://openairdocs.org/ntsb/ANC84FA140.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Aug 18, 1984 · N9062M · Substantial damage > The plt stated that he was taking off to the southeast & the acft was on the step when a x-wind hit, lifting the right wing. He said the left wing then hit the water, spinning the acft to the left & the nose hit the water. The acft went over on its back &… - [NTSB NYC84LA273](https://openairdocs.org/ntsb/NYC84LA273.md): Piper PA-38-112 · New Castle, PA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1984 · N4332E · Destroyed > The certified flt instructor (CFI) stated that he was instructing a 10 hour student pilot. He continued to state that they were doing touch and go's and had applied power for the second takeoff when the aircraft began to veer to the right side of the rwy. The… - [NTSB NYC84LA272](https://openairdocs.org/ntsb/NYC84LA272.md): Cessna 152II · E. Windsor, CT · Accident · No injuries · Limited investigation · Final report · Aug 13, 1984 · N89980 · Destroyed > Plt failed to note inoperative airspeed indicator until well into takeoff run. When the defect was noted, takeoff abort procedures were performed but the acft continued beyond the airport boundary into a rough field and nosed over. Investigation revealed the… - [NTSB LAX84FA439](https://openairdocs.org/ntsb/LAX84FA439.md): Cessna 182RG · Prescott, AZ · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1984 · N6612S · Destroyed > As the acft proceeded on takeoff down the rwy, it exited the rwy on the left side over a berm into a wide shallow ditch area, then about 122 feet later the acft traveled back over the berm onto the rwy and took off. The nose then pitched up, the acft banked… - [NTSB MKC84LA253](https://openairdocs.org/ntsb/MKC84LA253.md): Cessna A188B · Plains, KS · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 1984 · N4906Q · Destroyed > The acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt… - [NTSB FTW84LA345](https://openairdocs.org/ntsb/FTW84LA345.md): Cessna A185F · Tomball, TX · Accident · No injuries · Limited investigation · Final report · Aug 12, 1984 · N802DM · Destroyed > Before takeoff 2 paxs boarded so the instructor could demonstrate to the student the effect that additional weight has on acft handling on water. According to the instructor the acft would not become airborne during takeoff. The acft overran the waterway,… - [NTSB NYC84LA268](https://openairdocs.org/ntsb/NYC84LA268.md): Piper PA-31-350 · Seven Springs, PA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N9202Y · Substantial damage > After refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to… - [NTSB FTW84LA346](https://openairdocs.org/ntsb/FTW84LA346.md): Aeronca 7AC · Fulshear, TX · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N85625 · Substantial damage > On the takeoff roll, a 'short duration cross control condition occurred' between the student and instructor pilots, resulting in the acft departing the right side of the runway, power was reduced but the acft rolled into a dirt bank and mud holes, collapsing… - [NTSB ATL84LA253](https://openairdocs.org/ntsb/ATL84LA253.md): Cessna 152 II · Clarksville, TN · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N67810 · Substantial damage > The 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the… - [NTSB ATL84FA252](https://openairdocs.org/ntsb/ATL84FA252.md): Boeing A75N1 · Cumming, GA · Accident · Minor injuries · Field investigation · Final report · Aug 11, 1984 · N1357N · Substantial damage > The acft experienced a partial pwr loss during takeoff. The pilot released the banner the acft was towing, made a left turn into a valley and collided with a ditch during a forced landing. Investigation revealed maintenance deficiencies in both the carburetor… - [NTSB MKC84LA244](https://openairdocs.org/ntsb/MKC84LA244.md): Cessna 172 · Osage City, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1984 · N444ZH · Substantial damage > The pilot stated that during an aborted takeoff, due to an engine power loss, he was not able to stop before running off the end of the 2600 foot long runway. He said that when he felt that the airplane was ready to fly he glanced down at instrument panel and… - [NTSB LAX84LA431](https://openairdocs.org/ntsb/LAX84LA431.md): Glasflugel H 301 B Libelle · Carefree, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1984 · N3012 · Substantial damage > The acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=149 ## 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=148 --- 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.