# NTSB investigations, 1985: 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 1 of 4 · 192 cases ## Latest cases - [NTSB MKC86LA042](https://openairdocs.org/ntsb/MKC86LA042.md): Cessna 150 · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Dec 31, 1985 · N4649X · Substantial damage > The student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls… - [NTSB DEN86LA055](https://openairdocs.org/ntsb/DEN86LA055.md): Cessna 172RG · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · Dec 28, 1985 · N4849V · Substantial damage > According to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about… - [NTSB MIA86LA047](https://openairdocs.org/ntsb/MIA86LA047.md): Piper PA-38-112 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N2569L · Substantial damage > The instructor pilot simulated an engine failure after takeoff. The student pilot failed to lower the airplane nose to maintain flying speed. The instructor took over the controls and lowered the nose, but was unable to avert the hard landing and ensuing… - [NTSB MKC86LA038](https://openairdocs.org/ntsb/MKC86LA038.md): Cessna 140 · Coy, AR · Accident · No injuries · Limited investigation · Final report · Dec 21, 1985 · N3587V · Substantial damage > The pilot reports that the engine of N3587V was run at idle for an extended time before the takeoff was attempted. After several minutes, the engine died. It was restarted and the takeoff was commenced immediately. According to the pilot, the engine was… - [NTSB ATL86LA042](https://openairdocs.org/ntsb/ATL86LA042.md): Cessna 150L · Manning, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N19099 · Substantial damage > During takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury. - [NTSB DEN86LA046](https://openairdocs.org/ntsb/DEN86LA046.md): Cessna 206 · Hardin, MT · Accident · No injuries · Limited investigation · Final report · Dec 14, 1985 · N5173U · Destroyed > After ldg to the east on a snow covered dirt rwy, the pilot elected to t/o on an intersecting rwy to the south. He could not see the entire rwy surface from the position due to dwn slope from center of rwy. The acft impacted snowdrifts 40-50 mph on t/o gnd… - [NTSB MIA86LA042](https://openairdocs.org/ntsb/MIA86LA042.md): Beech E-18S · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Dec 13, 1985 · N43T · Substantial damage > The plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass. - [NTSB LAX86FA066](https://openairdocs.org/ntsb/LAX86FA066.md): Cessna 150 · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1985 · N7310X · Destroyed > The acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and… - [NTSB NYC86LA047](https://openairdocs.org/ntsb/NYC86LA047.md): Cessna 172 · East Moriches, NY · Accident · No injuries · Limited investigation · Final report · Dec 4, 1985 · N3530S · Substantial damage > The acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice. - [NTSB ATL86LA027](https://openairdocs.org/ntsb/ATL86LA027.md): Cessna 150M · Jacksonville, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 1985 · N45363 · Substantial damage > During the takeoff phase of a touch & go landing the student plt lost directional control of the acft and ran off the side of the rwy. The student plt was on his third solo training flight. - [NTSB DEN86LA027](https://openairdocs.org/ntsb/DEN86LA027.md): Piper PA-38-112 · Ft. Collins, CO · Accident · No injuries · Limited investigation · Final report · Nov 16, 1985 · N2601G · Substantial damage > The acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft… - [NTSB ATL86LA019](https://openairdocs.org/ntsb/ATL86LA019.md): Piper Aerostar 601P · Sylacauga, AL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1985 · N601PC · Substantial damage > During takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted. - [NTSB LAX86LA031](https://openairdocs.org/ntsb/LAX86LA031.md): Piper PA-28-181 · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N21491 · 2 aircraft · Minor damage > Near the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &… - [NTSB MIA86LA019](https://openairdocs.org/ntsb/MIA86LA019.md): Beech G35 · Destin, FL · Accident · No injuries · Limited investigation · Final report · Oct 26, 1985 · N4275D · Substantial damage > The acft veered off rwy 14 and struck a rwy light and small trees during an attempted x-wind takeoff. The plt stated that he thought the x-wind was from the right, however, the surface winds were reported as 050 at 9 KTS with gusts 12 to 15 KTS, a left x-wind. - [NTSB LAX86LUG01](https://openairdocs.org/ntsb/LAX86LUG01.md): Texas Helicopter M74A · Daggett, CA · Accident · No injuries · Final report · Oct 19, 1985 · N51862 · Substantial damage > The plt stated he had just lifted off for a fertilizer spreading operation with an external load bucket, when the eng had a partial pwr loss at 100 ft AGL. A descent was started and the bucket was disengaged. However, while the plt was attempting to land the… - [NTSB LAX86LA017](https://openairdocs.org/ntsb/LAX86LA017.md): Piper PA-28-140 · Chino Valley, AZ · Accident · No injuries · Limited investigation · Final report · Oct 15, 1985 · N9660W · Substantial damage > When the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing… - [NTSB ATL86LA005](https://openairdocs.org/ntsb/ATL86LA005.md): Hughes 269C · Chapman, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1985 · N7451F · Destroyed > During an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason… - [NTSB ANC86LA013](https://openairdocs.org/ntsb/ANC86LA013.md): Piper PA-18 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · Oct 8, 1985 · N9960Q · Substantial damage > The acft cartwheeled after dragging the right wing during an attempted takeoff from a gravel strip. The plt reported the takeoff was attempted to the west with a 10 to 15 mph left x-wind. Another person in the area when the accident occurred stated the wind… - [NTSB SEA86LA003](https://openairdocs.org/ntsb/SEA86LA003.md): Cessna 150 · Burton Lake, OR · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N50120 · Substantial damage > The acft failed to become airborne on the soft, short, rough cinder covered airstrip probably due to a combination of density altitude and poor plt technique. The acft struck a berm at the end of the runway where it nosed over. The plt was also departing… - [NTSB LAX86LA005](https://openairdocs.org/ntsb/LAX86LA005.md): Willie II · Blythe, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1985 · N7919 · Substantial damage > On oct 5, 1985 a Willie ii homebuilt crashed on takeoff after its left main landing gear collapsed. VMC existed at the time and no flt plan was filed. The ac sustained substantial damage and the two occupants received minor injuries. The winds were from 050.… - [NTSB ANC86LAG01](https://openairdocs.org/ntsb/ANC86LAG01.md): Cessna 140 · Beluga, AK · Accident · No injuries · Final report · Oct 4, 1985 · N2181N · Substantial damage > The student plt attempted takeoff from am unimproved, overgrown river bed. He stated he paced off the distance availablefor takeoff and it was too short, however, he decided to takeoff anyway. The acft impacted alders and a stream bank just as it was lifting… - [NTSB ANC86LAG03](https://openairdocs.org/ntsb/ANC86LAG03.md): Piper PA-18A-150 · Homer, AK · Accident · No injuries · Final report · Oct 3, 1985 · N3992P · Substantial damage > The landing gear axle failure was due to the oversize tires that were installed on the aircraft. - [NTSB SEA86LA001](https://openairdocs.org/ntsb/SEA86LA001.md): Cessna 172P · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N53432 · Substantial damage > Directional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over. - [NTSB CHI86LA001](https://openairdocs.org/ntsb/CHI86LA001.md): Cessna 152 · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Oct 1, 1985 · N5331P · Substantial damage > According to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft… - [NTSB NYC85LA251](https://openairdocs.org/ntsb/NYC85LA251.md): Piper PA-28-180 · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1985 · N2335R · Substantial damage > During an attempted takeoff on a 2439 ft rwy, the plt was unable to apply back elevator pressure thus the acft was prevented from becoming airborne. The acft traveled off the end of the rwy where it contacted a fence and trees. Inspection of the acft… - [NTSB ATL85LA287](https://openairdocs.org/ntsb/ATL85LA287.md): Hughes 269A · Winchester, KY · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N9308F · Substantial damage > The accident occurred as the student pilot was attempting to takeoff for hover training. As the pilot was applying collective torque, the student said, he lost control and crashed. There were no system malfunctions or failures reported. - [NTSB LAX85LA406](https://openairdocs.org/ntsb/LAX85LA406.md): Cessna 152 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1985 · N64981 · Substantial damage > The acft was observed to turn to the left during the takoeff ground roll on rwy 32R at buchanan airport, Concord, California and exit the rwy environment. The certificated private plt reported that shortly after applying full power the acft 'swerved' to the… - [NTSB FTW85LA356](https://openairdocs.org/ntsb/FTW85LA356.md): Cessna 182A · Sanderson, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1985 · N9937B · Substantial damage > On landing, the plt noticed a quantity of brush on the rwy, however, he did not think it would be an obstacle to his intended takeoff and therefore did not remove it. During takeoff, the left main gear struck the brush causing the plt to lose control of the… - [NTSB DEN85LA248](https://openairdocs.org/ntsb/DEN85LA248.md): Piper PA-18 · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1985 · N7467D · Substantial damage > While practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a… - [NTSB SEA85LA223](https://openairdocs.org/ntsb/SEA85LA223.md): Cessna A185F · Eastsound, WA · Accident · No injuries · Limited investigation · Final report · Sep 23, 1985 · N61298 · Substantial damage > During takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights. - [NTSB MIA85FA261](https://openairdocs.org/ntsb/MIA85FA261.md): Aerofab Lake LA-4-250 · Medley, FL · Accident · Serious injuries · Field investigation · Final report · Sep 23, 1985 · N1401K · Substantial damage > The non seaplane rated plt whose airman certificate was under suspension. Attempted a downwind take-off from an intermediate point on the lake's surface. The plt stated he thought the non seaplane rated plt/pax attempted to abort the take-off by closing the… - [NTSB SEA85LA221](https://openairdocs.org/ntsb/SEA85LA221.md): Cessna 170B · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N1930C · Substantial damage > The plt was attmepting to depart rwy 02 and the wind was from 300 degs at 15 KTS gusting to 20 KTS. Directional control of the acft was not maintained and it veered off the side of the rwy during the takeoff ground run. - [NTSB NYC85LA246](https://openairdocs.org/ntsb/NYC85LA246.md): Piper PA-24-180 · Bayport, NY · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N7505P · Substantial damage > According to the CFI, the student raised the nose of the acft too early during takeoff. This resulted in the acft becoming airborne prematurely. The student was unable to climb out of ground effect and the decision to abort the takeoff was made. The acft… - [NTSB MIA85LA259](https://openairdocs.org/ntsb/MIA85LA259.md): Cessna C-152 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N49873 · 2 aircraft · Substantial damage > The plt stated that he was hovering at an altitude of about three feet. Approximately 100 feet north of the rwy. When an out-of-control Cessna 152 tore off their right landind skid. The helicopter landed safely using a wooden dolly for support of the right… - [NTSB MKC85LA218](https://openairdocs.org/ntsb/MKC85LA218.md): Cessna 210N · Mullen, NE · Accident · No injuries · Limited investigation · Final report · Sep 18, 1985 · N5278A · Substantial damage > The takeoff was being made from a hay meadow that was soft due to recent rains. The property owner said the field was 1/4 mi long. The density alt was calculate to be 5600 ft. the plt said the acft did not attain takeoff speed & that it collided with a fence… - [NTSB LAX85FVA05](https://openairdocs.org/ntsb/LAX85FVA05.md): Beech E-33 · Coalinga, CA · Accident · No injuries · Final report · Sep 16, 1985 · N3493A · Substantial damage > The acft dragged the tail and crashed in a plowed field about 1/4 mile east of the takeoff rwy. The plt said the acft became 'squirrely' on the rwy and went left off the rwydespite her application of rt rudder tracks showed that the acft left rwy after 250 ft… - [NTSB ANC85LA178](https://openairdocs.org/ntsb/ANC85LA178.md): Cessna 180 · Tutna Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N2490C · Substantial damage > The plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to… - [NTSB MIA85LLD03](https://openairdocs.org/ntsb/MIA85LLD03.md): Brokaw Bullet · Eustis, FL · Accident · No injuries · Final report · Sep 14, 1985 · N520BJ · Substantial damage > The acft contacted a ditch during an attempted takeoff on a taxiway. The plt reportedly decided to use the taxiway for takeoff rather than the rwy because of the soft rwy conditions which resulted from recent rains. During takeoff the leftmain gear contacted… - [NTSB MKC85LA215](https://openairdocs.org/ntsb/MKC85LA215.md): Cessna 421B · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Sep 13, 1985 · N88DM · Substantial damage > During the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run… - [NTSB CHI85IA369](https://openairdocs.org/ntsb/CHI85IA369.md): Fokker F27-500 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 9, 1985 · N242MA · Minor damage > At about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &… - [NTSB ANC85LA173](https://openairdocs.org/ntsb/ANC85LA173.md): Taylorcraft BL-65 · Rainey Pass, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1985 · N27696 · Substantial damage > The plt was taking off on a strip of tundra about 1000 ft long in calm wind conditions. During the takeoff roll, he lost directional control & the acft ground looped & was damaged. No mechanical problems were reported. - [NTSB MKC85LA211](https://openairdocs.org/ntsb/MKC85LA211.md): Cessna 172N · Bridgeport, NE · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1985 · N2920E · Substantial damage > N2920E was taking off on a 2,800 ft long, turf rwy. There was a lt crosswind of 12 KTS and the density alt was 5,000 ft. the plt said the acft encountered a dip in the rwy and swerved to the lt momentarily. He said he regained directional control but then… - [NTSB MIA85IA246](https://openairdocs.org/ntsb/MIA85IA246.md): Douglas DC-8-71 · West Palm Bch, FL · Incident · No injuries · Incident investigation · Final report · Sep 8, 1985 · N1300L · Minor damage > During take off roll the #4 engine failed causing catostrophic destruction of the engine. During subsequent examination the left vgv actuator pin was found to be missing. Without this pin the vgv ARM8 are aysemetrically driven. The vgv arms were found broken… - [NTSB LAX85FA385](https://openairdocs.org/ntsb/LAX85FA385.md): Jonas Humming Bird · Tucson, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1985 · N14GJ · Substantial damage > The experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the… - [NTSB LAX85LA387](https://openairdocs.org/ntsb/LAX85LA387.md): Cessna 170B · Buckeye, AZ · Accident · No injuries · Limited investigation · Final report · Sep 5, 1985 · N1659D · Substantial damage > The plt attempted to depart on soft silt & sand. During the takeoff roll the acft wheels sank into the soft terrain necessatating differential braking to maintain directional control. As the acft approached a ditch the plt forced the acft airborne. The acft… - [NTSB FTW85LA342](https://openairdocs.org/ntsb/FTW85LA342.md): Cessna A185F · Port Sulphur, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1985 · N5513E · Destroyed > The plt stated he initiated his water takeoff run on a canal which had a left bend. When he rounded the bend he observed a 15-20 foot high piling (post) in the middle of the canal and a peninsula of land about 300 yards beyond the piling. He steered to the… - [NTSB FTW85LA337](https://openairdocs.org/ntsb/FTW85LA337.md): Piper PA-28-181 · Westbrook, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1985 · N8043C · Substantial damage > There were no known eye witnesses to the accident. Available evidence reveals that the pilot most probably made a successful landing in the remotely located field and rolled to a stop. The sheriff reported that the engine oil was drained onto the ground at… - [NTSB ATL85LA267](https://openairdocs.org/ntsb/ATL85LA267.md): Bryan HP-14 · Aiken, SC · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N5DB · Substantial damage > Plt reported that sailplane was positioned for a tow in tall grass beside the rwy. He said that during the takeoff the left wing was slowed by the tall grass allowing the right wing to accelerate. The sailplane yawed left and rolled left until 90 degrees to… - [NTSB ANC85LA166](https://openairdocs.org/ntsb/ANC85LA166.md): Maule M-5 · Cape Yakataga, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N51566 · Substantial damage > The plt reported that he started to depart from a gravel strip, then elected to abort the takeoff. While rolling on the ground, the acft hit a 'wash-out' which bent a structural tube on the landing gear assembly. - [NTSB CHI85FEP04](https://openairdocs.org/ntsb/CHI85FEP04.md): PZL-Bielsko SZD-45A Ogar · Ft. Atkinson, WI · Accident · Serious injuries · Final report · Aug 31, 1985 · N35AS · Substantial damage > Witnesses reported seeing the acft shortly after takeoff at an alt of aprx 40 to 50 ft AGL. At this time, according to witnesses, the eng slowed down, the acft turned left and dove into the terrain. No mechanical failure/malfunction was discovered during an… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?year=1985&page=2 ## 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 year(c."eventDate") = 1985 AND 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?year=1985 --- 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.