# 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 150 of 281 · 14,038 cases ## Cases, newest first - [NTSB LAX84LA340](https://openairdocs.org/ntsb/LAX84LA340.md): Cessna 152 · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1984 · N4972B · Substantial damage > The student plt lost directional control on the takeoff roll, veered off the rwy & nosed over. Winds were reported as 160 deg at 10 KTS. - [NTSB CHI84LA219](https://openairdocs.org/ntsb/CHI84LA219.md): Piper PA-30 · Berrien Springs, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1984 · N8205Y · Substantial damage > The acft crashed shortly after takeoff near the end of the rwy. The sequence began when the plt noticied that acft acceleration was 'a bit slow' on the rwy. Then a noticable drop in RPM on the right engine occurred at about halfway down the 3100 ft rwy. The… - [NTSB LAX84LA331](https://openairdocs.org/ntsb/LAX84LA331.md): Pitts S2A · Redlands, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1984 · N6JP · 2 aircraft · Destroyed > The acft were to perform & the two plts agreed to a staggered takeoff with the 2nd plt counting to 5 prior to commencinghis takeoff. They positioned themselves abreast of each other on the rwy. The plt of N65P commenced her takeoff from the right side of the… - [NTSB NYC84IA192](https://openairdocs.org/ntsb/NYC84IA192.md): Boeing 727-31 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Jun 2, 1984 · N855TW · Minor damage > After takeoff flt attendant reported aft airstair partially open. Flt engineer checked & confirmed airstair open aprx 18 inches. Remedial action performed to no avail. Unscheduled landing performed without incident. As acft turned onto taxiway airstair… - [NTSB SEA84LA122](https://openairdocs.org/ntsb/SEA84LA122.md): Cessna 188B · Perrydale, OR · Accident · No injuries · Limited investigation · Final report · May 29, 1984 · N4918R · Substantial damage > The plt stated that while taking off from the 1,100 ft rough strip, the acft struck a bump causing it to become airborneprematurely. The acft then settled back onto tall wheat past the end of the strip & flipped inverted. - [NTSB ATL84FA187](https://openairdocs.org/ntsb/ATL84FA187.md): Piper PA-30 · Charlotte, NC · Accident · Serious injuries · Field investigation · Final report · May 29, 1984 · N7217Y · Destroyed > Plt departed rwy 18L and shortly thereafter reported to the tower that he had a stuck trim. The plt was cleared to land on rwy 18R. Witnesses observed the acft descend rapidly on downwind to approx 300 to 500 ft AGL and make a steep (90 to 120 degree) right… - [NTSB CHI84LA207](https://openairdocs.org/ntsb/CHI84LA207.md): Ercoupe 415 · Plainwell, MI · Accident · Minor injuries · Limited investigation · Final report · May 27, 1984 · N2622H · Substantial damage > The acft veered to the left side of a grass strip into taller grass which increased the drag on the left main gear. The acft swerved farther off path until a furrow was struck and the acft nosed over. Local winds were reported from 150 degrees at 8 KTS. The… - [NTSB CHI84LA206](https://openairdocs.org/ntsb/CHI84LA206.md): Ercoupe 415C · Sturtevant, WI · Accident · Serious injuries · Limited investigation · Final report · May 27, 1984 · N93939 · Substantial damage > According to the plt, he was making a hi speed taxi check when the acft lifted off to about 5 ft AGL. After lift-off, the acft began to go to the left. When the plt applied right rudder, the plane veered further left & crashed in an onion field. An exam of… - [NTSB SEA84LA120](https://openairdocs.org/ntsb/SEA84LA120.md): Cessna A185E · Refuge Cove, AK · Accident · No injuries · Limited investigation · Final report · May 26, 1984 · N2231T · Substantial damage > The plt stated in his report on form 6120.1 that the acft was on step during takeoff when the acft began a roll to the right. The right wing hit the water twice in spite of aileron control inputs to correct it. With the application of rudder and a power… - [NTSB NYC84LA188](https://openairdocs.org/ntsb/NYC84LA188.md): Rolladen-Schneider LS-4A · Pepperell, MA · Accident · No injuries · Limited investigation · Final report · May 26, 1984 · N245JD · Substantial damage > The glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a… - [NTSB NYC84LA182](https://openairdocs.org/ntsb/NYC84LA182.md): Piper PA-28 · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · May 22, 1984 · N33746 · Substantial damage > The pilot aborted his takeoff when he noted insufficient acceleration, but lost control of the aircraft, ran off the end of the runwaym thru a ditch and onto railroad tracks. - [NTSB NYC84LA175](https://openairdocs.org/ntsb/NYC84LA175.md): Piper PA-18 · Chatham, MA · Accident · No injuries · Limited investigation · Final report · May 21, 1984 · N9075H · Substantial damage > Directional control was lost during the takeoff ground roll with a slight quartering tailwind. Power was reduced but the acft traveled off the left side of the rwy where it collided with a tree. - [NTSB NYC84LA179](https://openairdocs.org/ntsb/NYC84LA179.md): Cessna 175 · Ticonderoga, NY · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N6709E · Substantial damage > A student plt performing touch and go landings observed another acft at the departure end of the rwy, facing him. Assuming a collision was immenent, the plt aborted the takeoff, but locked the brakes while trying to stop. The acft swerved off the rwy, the… - [NTSB NYC84FA202](https://openairdocs.org/ntsb/NYC84FA202.md): Bell 206B · Georgetown, DE · Accident · Serious injuries · Field investigation · Final report · May 20, 1984 · N75SP · Substantial damage > After performing police patrol activities, the aircrew landed, refueled the helicopter, then took off to practice autorotative landings. Two autorotative landings were made on rwy 22, then 2 more were made on an adjacent grass area. After the 2nd landing on… - [NTSB FTW84LA238](https://openairdocs.org/ntsb/FTW84LA238.md): Cessna 150H · Sunray, TX · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N22024 · Substantial damage > During initial climb, at an altitude of 8 to 10 ft AGL, the student plt reported experiencing 'turbulence like a down draft' & the acft settled back to the rwy. Believing that insufficient rwy remained to clear approaching power lines, the plt intentionally… - [NTSB NYC84LA176](https://openairdocs.org/ntsb/NYC84LA176.md): Cessna 172 · Sayville, NY · Accident · No injuries · Limited investigation · Final report · May 16, 1984 · N73748 · Substantial damage > About 6 min after departure the pilot experienced a total loss of power and advised the tower that he would be landing in the water. - [NTSB SEA84LA106](https://openairdocs.org/ntsb/SEA84LA106.md): Stinson 108-2 · Carson City, NV · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N9543K · Substantial damage > According to the plt, the wind was from 230 deg at 12 gusting 18 KTS. He said that he had just lifted the tailwheel when a 'dust devil' push the acft to the right of the rwy. The acft then struck sage brush & a barbed wire fence & nosed over. - [NTSB CHI84LA191](https://openairdocs.org/ntsb/CHI84LA191.md): Globe GC-1B · Columbus, OH · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N78204 · Substantial damage > The acft right main gear failed during takeoff roll when it passed over an arresting cable. It was reported that the tailwheel was damaged on a previous landing at rickenbacker afb when it passed over an arresting cable and had since been replaced.… - [NTSB MIA84FA165](https://openairdocs.org/ntsb/MIA84FA165.md): Consolidated Aeronautics Lake LA-4 · Fort Myers, FL · Accident · 1 fatal · Field investigation · Final report · May 11, 1984 · N1119L · Destroyed > The eng was heard 'popping' & misfiring during the takeoff roll. About 1 min later while climbing thru 400-500 ft, the plt reported an eng failure & was cleared to land on any rwy. The acft entered a left turn, stalled & spun into a parking lot. An exam of… - [NTSB CHI84LA182](https://openairdocs.org/ntsb/CHI84LA182.md): Beech E18S · Marion, IL · Accident · Minor injuries · Limited investigation · Final report · May 11, 1984 · N561S · Destroyed > The acft crashed after takeoff from rwy 29 at williamson county airport. The plt stated that she mismanaged the fuel system & that she 'probably tookoff on fumes.' She further stated that she should have told the company 'I'm to tired to make this flt.' - [NTSB MIA84LA167](https://openairdocs.org/ntsb/MIA84LA167.md): Cessna 172N · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N84FP · Substantial damage > The acft nosed over during takeoff after running off the left side of the rwy. The wind was reported from 50 degrees at 13 KTS gusting to 23 KTS prior to the accident. After the accident the wind was from 030 degrees at 14 KTS. - [NTSB CHI84LA183](https://openairdocs.org/ntsb/CHI84LA183.md): Cessna 182N · Minonk, IL · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N9268G · Substantial damage > The acft ran off the departure end of the rwy during an aborted takeoff. After the nose gear collapsed the acft nosed over. Investigation revealed that the plt lowered 10 deg of flaps instead of the recommended 20 deg for a soft field takeoff. He used about… - [NTSB MIA84FA157](https://openairdocs.org/ntsb/MIA84FA157.md): Cessna 310Q · Keystone Hgts, FL · Accident · Minor injuries · Field investigation · Final report · May 1, 1984 · N80GC · Substantial damage > The acft crashed while the plt was attempting to takeoff from rwy 10, which was not lighted. Tire marks showed that the acft had run off the rwy about 1200 from the threshold. After leaving the rwy, the acft collided with trees before coming to rest. Both… - [NTSB DEN84LA141](https://openairdocs.org/ntsb/DEN84LA141.md): Cessna 152 · Billings, MT · Accident · No injuries · Limited investigation · Final report · May 1, 1984 · N94156 · Substantial damage > During a crosswind takeoff the right wing began to raise just as the plt was thinking about rotating. This startled him & he aborted the takeoff. The acft departed the left side of the rwy & flipped over on its back. - [NTSB ATL84LA154](https://openairdocs.org/ntsb/ATL84LA154.md): Cessna 182P · Louisa, VA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N52790 · Substantial damage > The plt reported that the grass & ridges on the strip held the acft's speed down more than expected during the takeoff roll, so the plt decided to abort. The plt later stated that he could have made it safely, but his 'instinct' was stronger so he decided to… - [NTSB FTW84LA215](https://openairdocs.org/ntsb/FTW84LA215.md): Piper PA-28-140 · Shiro, TX · Accident · No injuries · Limited investigation · Final report · Apr 27, 1984 · N8695E · Substantial damage > The acft collided with a fence, ditch & trees during a touch-&-go landing on a short grass strip with obstructions at both ends. This was the students 4th solo attempt and according to the owner of the aviation training center touch-&-go landings are not… - [NTSB CHI84LA163](https://openairdocs.org/ntsb/CHI84LA163.md): William Freeman Glasair · Lambertville, MI · Accident · No injuries · Limited investigation · Final report · Apr 26, 1984 · N83BJ · Substantial damage > The plt stated that during takeoff, the acft weather vaned into the wind and the left main landing gear went off the rwy. When the acft hit soft plowed dirt after leaving the rwy, it nosed over. - [NTSB CHI84LA160](https://openairdocs.org/ntsb/CHI84LA160.md): Piper PA-28-161 · Bluffton, IN · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N83088 · Substantial damage > The plt was attempting a takeoff on a country road. He stated that during the takeoff he noticed the acft was not set-up for a short field takeoff so he decided to abort. During the takeoff abort the acft struck a tree alongside the road and the the acft… - [NTSB FTW84LA211](https://openairdocs.org/ntsb/FTW84LA211.md): Beech 35-C33 · Roundup, TX · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N6101V · Substantial damage > The plt stated after the accident that during the takeoff run the acft would not accelerate beyond 60 KTS. The plt aborted the takeoff and steered the acft into tall grass off the left side of the rwy in an effort to slow the acft at a faster rate. During the… - [NTSB CHI84LA158](https://openairdocs.org/ntsb/CHI84LA158.md): Cessna 152 · Athens, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1984 · N1300U · Substantial damage > The plt was performing a rolling takeoff after a touch and go landing. He said he forgot to raise the flaps and as the acft approached rotational speed it veered to the left. He could not correct with rudder and the acft went into a ditch where it nosed over. - [NTSB NYC84LA145](https://openairdocs.org/ntsb/NYC84LA145.md): Cessna A185F · Hazleton, PA · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N4925C · Substantial damage > According to the plt, he attempted to takeoff on rwy 28 with a variable wind from 180 deg at 9 KTS gusting to 19 KTS. After rolling about 200 ft, he gradually added power, but the acft began turning left, so he reduced the power. The acft straightened out,… - [NTSB ANC84LA058](https://openairdocs.org/ntsb/ANC84LA058.md): Fairchild C-119 · Venetie, AK · Accident · No injuries · Limited investigation · Final report · Apr 21, 1984 · N15509 · Destroyed > The plt was attempting a takeoff on an airstrip where braking action was considered good during the normal summer season. It was about 3000 ft in elevation & was snow covered most of the year, as on the day of the accident. The strip accomodated takeoffs to… - [NTSB CHI84LA156](https://openairdocs.org/ntsb/CHI84LA156.md): Cessna 172D · Bad Axe, MI · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N2472U · Substantial damage > After traveling 100-150 ft on the takeoff roll, the rgt brake seized & the acft veered sharply to the rgt. The acft departed the rwy & went into a muddy area where the nose gear collapsed & the acft nosed down. The plt reported that there were 200 ft long… - [NTSB SEA84LA091](https://openairdocs.org/ntsb/SEA84LA091.md): Hiller UH-12E · Buxton, OR · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N56BA · Substantial damage > The helicopter entered an uncontrolled right roll while lifting off from a trailer & struck the ground with the m/r. the plt reported the trailer was not level. - [NTSB MIA84LA138](https://openairdocs.org/ntsb/MIA84LA138.md): Cessna 152 · Clewiston, FL · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N4858M · Substantial damage > The instructor plt (CFI) stated that due to bad wx to the north, they elected to takeoff toward the south on rwy 14. He stated the wind was from 230 deg. The student started the takeoff with a slight x-wind. Shortly after lift-off, the CFI took the controls &… - [NTSB ANC84FA056](https://openairdocs.org/ntsb/ANC84FA056.md): Piper PA-20 · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Apr 14, 1984 · N7070K · Substantial damage > The acft veered during takeoff roll and left the right side of the rwy after about 200 ft of roll. The left main landinggear collapsed and separated from the acft. - [NTSB NYC84FA135](https://openairdocs.org/ntsb/NYC84FA135.md): Piper PA-34-200T · Johnstown, PA · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1984 · N33569 · Destroyed > The acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light… - [NTSB LAX84LA252](https://openairdocs.org/ntsb/LAX84LA252.md): Balloon Works Fire FLY 7 · Moorpark, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1984 · N3749W · Substantial damage > The plt reported that after completing the 2nd flt of the morning, he changed the fuel tank & acquired new passengers. He stated that during the 1st 2 flts, the Balloon had not drifted more than 100 yds from its point of lift-off. As the Balloon ascended on… - [NTSB FTW84FA189](https://openairdocs.org/ntsb/FTW84FA189.md): Aerospatiale AS 355F · W Cameron 540 · Accident · 4 fatal · Field investigation · Final report · Apr 5, 1984 · N5791Z · Destroyed > While the plt was taking off from an unmanned rig, the tail section of the helicopter contacted a rotating beacon support bracket on top of a crane structure. The crane structure was located below the elevation of the landing pad. The helicopter then crashed… - [NTSB DEN84LA123](https://openairdocs.org/ntsb/DEN84LA123.md): Bellanca 17-31ATC · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N4166B · Substantial damage > The plt was ferrying his recently purchased acft. During the takeoff, the acft rose momentarily, then settled back to the rwy. The plt said he then had a directional control problem and the acft went off the left side of the rwy. He blamed the rise and fall… - [NTSB NYC84LA123](https://openairdocs.org/ntsb/NYC84LA123.md): Cessna 172 · Reedsville, PA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N5261D · Substantial damage > The plt reported that at about the time he applied power to takeoff, the acft veered to the left. He stated that his efforts to return the acft to the centerline of the rwy did not work. Subsequently, the acft went thru a snowbank beside the rwy, then entered… - [NTSB MKC84LA113](https://openairdocs.org/ntsb/MKC84LA113.md): Piper PA24-250 · Osage City, KS · Accident · No injuries · Limited investigation · Final report · Mar 31, 1984 · N6293P · Substantial damage > During an aborted takeoff, executed due to an inoperative airspeed indicator, the acft swerved off the left side of the rwy across a ditch, damaging the left wing & main landing gear. A clogged pilot tube was the cause of the airspeed indication of zero mph.… - [NTSB FTW84LA183](https://openairdocs.org/ntsb/FTW84LA183.md): Cessna 180 · Rayville, LA · Accident · No injuries · Limited investigation · Final report · Mar 31, 1984 · N7516 · Substantial damage > During the takeoff the acft yawed left. The plt overcorrected causing the acft to yaw right & depart the right side of the rwy collapsing the left main landing gear. - [NTSB FTW84LA182](https://openairdocs.org/ntsb/FTW84LA182.md): Martin AM-1 (Mauler) · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Mar 31, 1984 · N5586A · Substantial damage > The plt was making a takeoff in this large single engine single seat acft after only 1 hour of experience. The plt said that the engine or propeller malfunctioned. The acft veered off the side of the rwy through a fence and struck 4 horses. An FAA inspector… - [NTSB ATL84LA136](https://openairdocs.org/ntsb/ATL84LA136.md): Cessna 172 E · Grayson, KY · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1984 · N3065U · Substantial damage > According to the plt, he encountered wx while on a x-country flt, got low on fuel while trying to get to an alternate arpt & made a precautionary landing in an open field. Later, he started to takeoff from a highway beside the field. During the takeoff roll,… - [NTSB DEN84LA117](https://openairdocs.org/ntsb/DEN84LA117.md): Bell 206B · Alpine, WY · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1984 · N2228W · Substantial damage > The plt stated on takeoff at an alt of 10 ft AGL a loss of power occurred. During the forced landing the left skid contacted either the pad or an object on the pad and the acft rolled over to the left. The plt stated that white out condition occurred during… - [NTSB CHI84LA138](https://openairdocs.org/ntsb/CHI84LA138.md): Cessna 152 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N68155 · Substantial damage > The plt stated that this was his first solo flt. During the first takeoff following a touch and go landing the acft wentoff the left side of the rwy and collided with a snowbank. After the collision the acft nosed over. - [NTSB MKC84LA094](https://openairdocs.org/ntsb/MKC84LA094.md): Piper PA-28-140 · Wilson, AR · Accident · No injuries · Limited investigation · Final report · Mar 23, 1984 · N565CA · Substantial damage > The acft nosed over during takeoff after hitting a soft spot in the rwy. The takeoff area was a private grass airstrip 1300 ft long. The plt said he had no control of the acft after hitting the soft dirt. - [NTSB LAX84LA228](https://openairdocs.org/ntsb/LAX84LA228.md): Cessna 150M · Holbrook, AZ · Accident · No injuries · Limited investigation · Final report · Mar 23, 1984 · N66390 · Substantial damage > The acft collided with a mound of rubble during an aborted takeoff. The takeoff was attempted uphill to avoid buildings and wires according to the plt. The density alt was 6200 ft. after the collision the acft nosed over. - [NTSB MKC84LA109](https://openairdocs.org/ntsb/MKC84LA109.md): Cessna 188B · Lake Village, AR · Accident · No injuries · Limited investigation · Final report · Mar 22, 1984 · N9541J · Substantial damage > As the acft began to rotate during takeoff one propeller blade was thrown 1000 ft behind the acft. The remaining blade and hub became unbalanced, twisting the engine at a 45 degree angle. Plt shut down the engine. Acft traveled off the left side of the rwy… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=151 ## 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=150 --- 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.