# NTSB investigations: Maneuvering 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 208 of 378 · 18,851 cases ## Cases, newest first - [NTSB DEN85LA050](https://openairdocs.org/ntsb/DEN85LA050.md): Piper PA-18 · Poplar, MT · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1984 · N3180Z · Substantial damage > According to the plt he was flying the acft 'low and slow' to look for deer when the accident occurred. He stated that he pulled the power back to glide down and observe wildlife and when he reapplied power there was severe hesitation and the eng did not pick… - [NTSB DEN85LA049](https://openairdocs.org/ntsb/DEN85LA049.md): Piper PA-18 · Cody, WY · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1984 · N1212A · Substantial damage > The student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's… - [NTSB ATL85FA067](https://openairdocs.org/ntsb/ATL85FA067.md): Robinson R-22 Alpha · Huntsville, AL · Accident · 2 fatal · Field investigation · Final report · Dec 25, 1984 · N8475K · Destroyed > A popping sound then a loud noise and a puff of smoke preceded the helicopter's fall to the ground, stated a 12 year old boy who said he saw the accident. Examination of the helicopter failed to disclose any trace of fire. However one main rotor blade… - [NTSB FTW85LA082](https://openairdocs.org/ntsb/FTW85LA082.md): Fairchild M-62A · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1984 · N48252 · Substantial damage > A total pwr loss was experienced while manuevering over an airport at about 250 ft AGL. The acft collided with rough terrain during the forced landing. Visual inspection of the acft fuel system indicated that the pwr loss was due to fuel exhaustion. - [NTSB SEA85FA034](https://openairdocs.org/ntsb/SEA85FA034.md): de Havilland DHC-3 Turbo · West Seattle, WA · Accident · Serious injuries · Field investigation · Final report · Dec 19, 1984 · N4247A · Substantial damage > Acft was performing test flt maneuvers when problems with the modified fuel system occurred. Ice blocking a fuel vent line caused a partial collapse of the main (engine feed) fuel cell which produced an errouneous fuel quantity reading. In addition, the main… - [NTSB LAX85FA074](https://openairdocs.org/ntsb/LAX85FA074.md): Cessna 152 · Petaluma, CA · Accident · 2 fatal · Field investigation · Final report · Dec 16, 1984 · N95337 · Destroyed > The acft departed on a local primary dual instructional flt at about 1030 hrs. The student was in a pre-solo phase & the lesson was to consist of a review of high airwork. The instructor (CFI) had recently become interested in & was working on aerobatics. At… - [NTSB ATL85LA057](https://openairdocs.org/ntsb/ATL85LA057.md): Cessna 182C · Johnson City, TN · Accident · No injuries · Limited investigation · Final report · Dec 15, 1984 · N8493T · Substantial damage > The acft crashed after a loss of eng power occurred when the plt was returning from transporting sky divers to altitude for a jump. The plt reported he ran the rt fuel tank out of fuel & failed to switch tanks. - [NTSB ATL85FA056](https://openairdocs.org/ntsb/ATL85FA056.md): Beech C23 · Athens, AL · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1984 · N2074X · Destroyed > The acft was observed doing training stall type maneuvers in the area shortly before the accident. It was then observed in a steep right descending turn, crossing a paved road at low alt and striking the ground with the right wing tip. The bottom of the acft… - [NTSB MKC85FA039](https://openairdocs.org/ntsb/MKC85FA039.md): Cessna 180K · Ft.Smith, AR · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1984 · N64011 · Destroyed > Witnesses along the Arkansas river observed the acft flying low over the river, in a northeasterly direction. As the acft approached a set of high voltage power lines that crossed the river aprx 85 ft above the water, it banked left and the rt wing struck the… - [NTSB MKC85LA034](https://openairdocs.org/ntsb/MKC85LA034.md): Cessna R172K · Almyra, AR · Accident · No injuries · Limited investigation · Final report · Dec 11, 1984 · N7392K · Substantial damage > Crossing over a road the pilot saw a friend's car and elected to turn around and fly back over the road. During the descending right turn, while looking at the vehicle on the road, the acft flew into the ground. - [NTSB LAX85FA066](https://openairdocs.org/ntsb/LAX85FA066.md): Barry Zielinski SNS 8 Hiperlt · Corona, CA · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1984 · N5303U · Destroyed > N5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar… - [NTSB MIA85LA056](https://openairdocs.org/ntsb/MIA85LA056.md): Sikorsky UH34J · Carrabelle, FL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1984 · N4556D · Substantial damage > The acft was conducting external load logging operations in a hover at aprx 175 ft AGL when the power loss occurred. According to the plt, the eng ran intermittently with black smoke coming out of the exhaust pipe before the eng failed totally. The… - [NTSB SEA85FA028](https://openairdocs.org/ntsb/SEA85FA028.md): Piper PA-44-180 · Gig Harbor, WA · Accident · 1 fatal · Field investigation · Final report · Dec 9, 1984 · N2104D · Destroyed > The plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were… - [NTSB NYC85FA039](https://openairdocs.org/ntsb/NYC85FA039.md): Mooney M20J · Montague, NJ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1984 · N1113X · Destroyed > The pilot of this aircraft was discharged from the hospital following a bladder biopsy about six hours prior to the accident. Although he was advised not to fly that day he elected to do so. He was engaged in buzzing a friends house when he collided with… - [NTSB LAX85LA063](https://openairdocs.org/ntsb/LAX85LA063.md): Hughes 269C · Boulevard, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1984 · N8663F · Substantial damage > Plt was executing low level photographic survey of valleys in mountainous terrain. Acft entered a narrow valley with steeply rising terrain ahead. When plt realized excessive rate of climb would be required to clear obstacles, he attempted a steep turn-around… - [NTSB FTW85LA074](https://openairdocs.org/ntsb/FTW85LA074.md): Bell 47D1 · Ardmore, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 1984 · N5226 · Substantial damage > The acft collided with power lines during a recovery from a practice autorotational landing. The instructor plt took control of the acft for recovery and did not see the wires. - [NTSB DEN85LA036](https://openairdocs.org/ntsb/DEN85LA036.md): Bell 205A-1 · Rifle, CO · Accident · No injuries · Limited investigation · Final report · Dec 5, 1984 · N5019N · Substantial damage > The helicopter was on a seismic operation when it lost eng power and was substantially damaged during the autorotative landing. The plt stated that when he came back on collective power the eng would enter severe compressor stalls. Post crash examination of… - [NTSB SEA85LA026](https://openairdocs.org/ntsb/SEA85LA026.md): Cessna 402C · Boise, ID · Accident · No injuries · Limited investigation · Final report · Dec 3, 1984 · N402NQ · Substantial damage > Descent was made to aprx 50 ft AGL to observe a herd of cattle. Acft contacted power lines cutting off the left wing tip. Flt continued and landing was made at Boise air terminal without incident. Plt stated he did not see wires. - [NTSB FTW85LA063](https://openairdocs.org/ntsb/FTW85LA063.md): American AA-1A · Spearman, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1984 · N100RJ · Substantial damage > Plt had pulled up form a low pass over cattle when eng quit. Plt cited probable carburetor icing but did not use carb heat. In turn to emergency landing area, acft speed decayed and acft mushed into ground, colliding with a ditch. - [NTSB DEN85FA035](https://openairdocs.org/ntsb/DEN85FA035.md): Cessna 182H · Provo, UT · Accident · 2 fatal · Field investigation · Final report · Dec 2, 1984 · N8580S · Destroyed > The left seat non-instrument pvt plt was being checked out in the flying club acft by a comm plt. The acft was being flown over Utah lake on a dark night, on final approach to runway 31 at the pvu arpt. While on final, the flying plt manuevered the acft for… - [NTSB MKC85FA031](https://openairdocs.org/ntsb/MKC85FA031.md): Aeronca 11AC · Council Bluffs, IA · Accident · Serious injuries · Field investigation · Final report · Dec 1, 1984 · N86120 · Substantial damage > The plt stated that he had been practicing landings and then climbed the acft to 5000 ft above the arpt. He flew around for awhile to cool off the eng and then he shutdown it down to practice restarts. After the first restart the eng was shut down a second… - [NTSB FTW85LA072](https://openairdocs.org/ntsb/FTW85LA072.md): Cessna 150 · Cisco, TX · Accident · No injuries · Limited investigation · Final report · Dec 1, 1984 · N5563G · Destroyed > While maneuvering in the bottom of a canyon searching for a lost child a total loss of power was experienced. During the forced landing the acft collided with trees and the ground coming to rest inverted after nosing over in the unimproved terrain. According… - [NTSB ATL85LA040](https://openairdocs.org/ntsb/ATL85LA040.md): Cessna 150H · Bumpass, VA · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1984 · N22741 · Substantial damage > VFR plt was using VOR airway navigation. He arrived in the vicinity of destination after dark and attempted to locate the arpt by flying a radial from the VOR; however, he used the 230 degree radial (published radial is 237 degrees). Further, the arpt is… - [NTSB MIA85FA037](https://openairdocs.org/ntsb/MIA85FA037.md): Piper PA-18-150 · Pembroke Pines, FL · Accident · Serious injuries · Field investigation · Final report · Nov 18, 1984 · N2443G · Destroyed > The plt had recently been checked out on banner towing operations & was on his 5th banner towing flt. After taking off from rwy 9R, he turned left, crossed to the left of rwy 9L to a left downwind & intended to continue in a left pattern for a banner pick-up… - [NTSB FTW85FA054](https://openairdocs.org/ntsb/FTW85FA054.md): Bellanca 17-31ATC · Allen, TX · Accident · 1 fatal · Field investigation · Final report · Nov 18, 1984 · N8222R · Substantial damage > The acft collided with the ground as the plt, who was not current for night/instrument flt, tried to maneuver beneath a low overcast on a dark night. Although seriously injured during the accident sequence, the plt was able to tell rescue workers that he 'was… - [NTSB CHI85LA049](https://openairdocs.org/ntsb/CHI85LA049.md): Piper PA-38-112 · Wild Rose, WI · Accident · No injuries · Limited investigation · Final report · Nov 18, 1984 · N2428L · Substantial damage > The plt stated that he was flying at 500 ft AGL over an open marsh that is surrounded by higher terrain covered with pine trees, looking for his father who was hunting in the area. The plt continued to state that he became preoccupied with trying to identify… - [NTSB SEA85LA019](https://openairdocs.org/ntsb/SEA85LA019.md): Cessna U206 · Dixie, ID · Accident · 3 fatal · Limited investigation · Final report · Nov 17, 1984 · N35699 · Destroyed > The acft crashed shortly after takeoff from yellow pine bar airstrip, witnesses observed the acft depart to the sw, enter a steep left turn immediately after liftoff, cross the river in a turn and impact the south bank abeam the airstrip. A ground fire broke… - [NTSB MIA85FA038](https://openairdocs.org/ntsb/MIA85FA038.md): Piper PA-36-300 · Fellsmere, FL · Accident · Serious injuries · Field investigation · Final report · Nov 17, 1984 · N3704E · Destroyed > Plt was completing downwind turn when acft began to settle. Plt failed to use full power or jettison the chemical load. As airspeed fell below minimum steady state control spd, acft mushed into grnd. - [NTSB LAX85LA043](https://openairdocs.org/ntsb/LAX85LA043.md): Cessna 150M · Ojai, CA · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N704ZC · Substantial damage > While simulating emerg procedures the plt added power and began a 180 deg turn to avoid colliding with trees. During the turn the right wing tip struck the rising terrain causing the acft to cartwheel to the ground inverted. - [NTSB CHI85FA050](https://openairdocs.org/ntsb/CHI85FA050.md): North American P-51D · New Haven, MI · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1984 · N51JL · Destroyed > The acft, a North American P51D, crashed into a potato field after striking an electrical wire running at a rt angle to the ground track, struck the ground, a building & disintegrated. The plt & owner of the acft was a 50 yr old ex-naval aviator with… - [NTSB SEA85LA020](https://openairdocs.org/ntsb/SEA85LA020.md): Hughes 369D · Kings Valley, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1984 · N58256 · Destroyed > The plt attempted to fly the acft away from the site of a proposed load drop before the drop was completed. The FAA inspectors said the sling did not release properly. When the plt attempted to depart the area the acft struck the groundin a nose low attitude.… - [NTSB DEN85FA027](https://openairdocs.org/ntsb/DEN85FA027.md): Bell 206B-11 · Bingham Canyon, UT · Accident · 4 fatal · Field investigation · Final report · Nov 15, 1984 · N1077T · Destroyed > Pilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills… - [NTSB LAX85FA042](https://openairdocs.org/ntsb/LAX85FA042.md): Cessna 172N · Jamul, CA · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1984 · N9405E · Destroyed > The certified flt instructor and private rated student pilot departed on a local instrument instructional flight. The aircraft departed at aprx 1715 and at 1750 an ELT signal was reported. The aircraft wreckage was located atop a hill at aprx the 2000 ft… - [NTSB FTW85FA050](https://openairdocs.org/ntsb/FTW85FA050.md): Hughes 269B · Clint, TX · Accident · 2 fatal · Field investigation · Final report · Nov 13, 1984 · N9336F · Destroyed > N9336F, crashed while on a training flt. The certified flt instructor & his student were killed. Investigation revealed that the main drive shaft thrust bearing had failed. A service bulletin dated 1968 mandated replacement of the bearing at 300 hr time in… - [NTSB DEN85FA028](https://openairdocs.org/ntsb/DEN85FA028.md): Champion 7ECA · Sevier, UT · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1984 · N5109T · Destroyed > The plt was en route from anchorage, Alaska to prescott, Arizona to be with his dying mother. Weather was described as windy, low ceilings, and approaching dusk when the a/c departed richfield, Utah. A/c was loaded with 284 lbs of cargo. A/c crashed on… - [NTSB FTW85FA045](https://openairdocs.org/ntsb/FTW85FA045.md): de Havilland DHC-1-22 · Abilene, TX · Accident · 2 fatal · Field investigation · Final report · Nov 12, 1984 · N95HP · Destroyed > Acft crashed while attempting an intentional low level acrobatic maneuver (left roll) over the rwy. Witnesses stated that the acft made a low pass (100-200' AGL) down the rwy & entered the roll. At the inverted position, the nose fell thru, but the maneuver… - [NTSB CHI85LA048](https://openairdocs.org/ntsb/CHI85LA048.md): Beech D-45 (T-34) · Bedford, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 12, 1984 · N5543 · Destroyed > The plt reported that during flt, he proceeded to fly along a river. After a time, he reversed course & began flying along the river in the opposite direction. He said that the flt back was at a lower alt & that the propeller contacted something in the water.… - [NTSB FTW85FA041](https://openairdocs.org/ntsb/FTW85FA041.md): North American SNJ-5 · Fairview, OK · Accident · 1 fatal · Field investigation · Final report · Nov 11, 1984 · N91047 · Destroyed > The acft was engaged in performing at an air show when recovery from a left aileron roll at aprx 300 ft AGL was completed to an upright attitude, however, the acft nose dropped and the acft turned 45 degrees to the right of the rwy heading. It then impacted… - [NTSB FTW85LA039](https://openairdocs.org/ntsb/FTW85LA039.md): Air Tractor AT-301 · Mission, TX · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N8523S · Substantial damage > After a loss of oil pressure the acft was landed downwind. During the precautionary landing across plowed furrows, the rt wing caught in the sugar cane crop and the acft turned to the rt, collapsing the left landing gear and damaging the left wing. The plts… - [NTSB MKC85FA017](https://openairdocs.org/ntsb/MKC85FA017.md): Piper PA18-150 · Omaha, AR · Accident · 1 fatal · Field investigation · Final report · Nov 6, 1984 · N284JD · Substantial damage > Witnesses stated that the acft was overflying a portion of tablerock lake near the marina that the plt had intentions of purchasing. The acft struck an unmarked power line that was strung aprx 85 ft above the lake. The acft collided with the water and sank.… - [NTSB MIA85LA024](https://openairdocs.org/ntsb/MIA85LA024.md): Bellanca 7ECA · Davie, FL · Accident · No injuries · Limited investigation · Final report · Nov 4, 1984 · N4110Y · Substantial damage > Plt stated he was practicing maneuvers and when he added pwr after one maneuver the eng did not develope 'full RPM.' He went through emergency procedures but could not effect a recovery of power so he elected to land. The field chosen was soft and wet. The… - [NTSB LAX85FA038](https://openairdocs.org/ntsb/LAX85FA038.md): Stinson Voyager 150 · Meadow Vista, CA · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1984 · N97638 · Destroyed > The acft collided with terrain while maneuvering northeast of auburn airport during a VFR personal flt. The plt advised sacramento TRACON that he had auburn arpt in sight. However, TRACON observed N97638 fly over & pass auburn arpt in a northerly direction &… - [NTSB FTW85LA035](https://openairdocs.org/ntsb/FTW85LA035.md): Beech 95-A55 · Sonora, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 3, 1984 · N1591S · Substantial damage > Pilot stated that he intended to land at Sonora, TX, but patchy ground fog obscured the arpt. He circled the aprt one time and then departed northward. He turned back to attempt another visual approach to the arpt when the aircraft struck a tree on the… - [NTSB CHI85LA040](https://openairdocs.org/ntsb/CHI85LA040.md): Cessna 150M · Wyatt, IN · Accident · No injuries · Limited investigation · Final report · Nov 3, 1984 · N704GX · Substantial damage > While practicing ground reference maneuvers at 800 ft AGL the engine power dropped from 2,500 to 1,500 RPM. During the forced landing rollout the nose gear collapsed when it contacted a dirt bank. Investigation revealed that the throttle control rod end bolt… - [NTSB FTW85FA034](https://openairdocs.org/ntsb/FTW85FA034.md): Bellanca 8KCAB · El Reno, OK · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1984 · N5064L · Destroyed > The acft was destroyed on impact with the ground after being observed by ground witnesses to go out of control during anaerobatic maneuver. There was a difference of opinions as to what happened. One witness described the ground collision having been from an… - [NTSB ATL85LA024](https://openairdocs.org/ntsb/ATL85LA024.md): Piper PA-25-235 · Lincoln, TN · Accident · No injuries · Limited investigation · Final report · Oct 30, 1984 · N9855P · Substantial damage > The acft was making a swath run spraying crops when the engine suddenly lost power with 200 yards of level field remaining for an emergency landing. After touchdown the plt turned the acft to avoid a collision with trees. During the turn the nose of the acft… - [NTSB DEN85FA026](https://openairdocs.org/ntsb/DEN85FA026.md): Cessna 340 · Las Vegas, NM · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1984 · N4001Q · Destroyed > The pilot was carrying illegal cargo (marijuana) in N4001Q. During a low high speed pass at night over an intended landing area,the aircraft struck rising terrain. There was approximately 800 lbs of marijuana on the aircraft. - [NTSB BFO85FA004](https://openairdocs.org/ntsb/BFO85FA004.md): de Havilland DH 82 Tiger Moth · Keyser'S Ridge, MD · Accident · 2 fatal · Field investigation · Final report · Oct 29, 1984 · N172VF · Destroyed > The flt was the final leg of a flt from winchester, VA that had been discontinued the day before due to adverse weather conditions. Two weather briefings were obtained on the day of the accident, both of which included the statement that VFR flight was not… - [NTSB LAX85LA035](https://openairdocs.org/ntsb/LAX85LA035.md): Bell 47-G2 · Castroville, CA · Accident · No injuries · Limited investigation · Final report · Oct 28, 1984 · N8404E · Substantial damage > At the beginning of a swath run a total loss of power occurred. During the hard forced landing, the main rotor blades severed the tail boom. The helicopter fuel tanks were found empty after the accident. - [NTSB NYC85FA014](https://openairdocs.org/ntsb/NYC85FA014.md): Cessna 150M · Providence, RI · Accident · 2 fatal · Field investigation · Final report · Oct 26, 1984 · N45397 · Destroyed > Acft collided with the waters of narragansett bay at a location aprx 1 mile from boys town arpt (destination of record),in water aprx 8 ft deep. The wx was IMC at departure (1845 EDT) and the ATP instrument rated plt had requested and been granted a special… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=209 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=208 --- 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.