# 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 205 of 378 · 18,851 cases ## Cases, newest first - [NTSB DEN85LA154](https://openairdocs.org/ntsb/DEN85LA154.md): Callair A-9 · Riverton, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1985 · N8280H · Substantial damage > During an aerial application turn-around maneuver, the eng lost power. The plt stated that he immediately changed the fuel selector & turned on the boost pump, but the acft was too low for the eng to have time to restore power. The eng had been using fuel… - [NTSB SEA85LA128](https://openairdocs.org/ntsb/SEA85LA128.md): de Havilland DH 82A Tiger Moth · Orland, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1985 · N99108 · Destroyed > The plt reported that during a loop, the eng lost power, then the acft entered an inverted spin. He said that he had gotten out of the inverted spin & was recovering from a regular spin when the acft struck the ground. According to a witness, the plt entered… - [NTSB FTW85FA245](https://openairdocs.org/ntsb/FTW85FA245.md): Cessna 140 · Tioga, TX · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1985 · N3180N · Destroyed > Witnesses observed the acft apchg from the northwest at an estimated alt of about 100 ft AGL. As it passed their position, the plt rolled into a steep (90 deg) right bank, then roll back out. The witnesses reported that after the acft rolled out of the bank,… - [NTSB SEA85LA193](https://openairdocs.org/ntsb/SEA85LA193.md): Eagle DW-1 · Orovada, NV · Accident · No injuries · Limited investigation · Final report · Jun 3, 1985 · N8804F · Substantial damage > After completing his last spray run, the plt began a turn. During the turn, the eng lost power, then restarted & lost power again. Attempts to restart the eng were to no avail. Since the acft was still at a very low alt (aprx 50 ft), an emerg landing was… - [NTSB NYC85FHM01](https://openairdocs.org/ntsb/NYC85FHM01.md): Schweizer SGS-1-35 · Middletown, NY · Accident · No injuries · Final report · Jun 2, 1985 · N9JK · Substantial damage > The acft landed off the arpt after the plt lost alt in a spin. The plt was afraid that the glider would land short in trees so he landed on a highway. The hard lndg damaged the acft. - [NTSB DEN85LA147](https://openairdocs.org/ntsb/DEN85LA147.md): Intermountain Mfg. Callair A-9 · Michigan, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1985 · N3569G · Substantial damage > The plt elected to fly the newly purchased acft around the airstrip to test the spray sys. Shortly after taking off, the eng stopped running while the acft was over a slough. The plt was unable to glide the acft to suitable terrain, & subsequently, the acft… - [NTSB MKC85FA120](https://openairdocs.org/ntsb/MKC85FA120.md): Cessna 152 · Albert, KS · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1985 · N6426B · Destroyed > While maneuvering to reverse directions the acft stalled descending and impacting the ground in a steep dive. The plt was on the final leg of his cross-country flt. - [NTSB MKC85LA115](https://openairdocs.org/ntsb/MKC85LA115.md): Hughes 269C · West Liberty, IA · Accident · No injuries · Limited investigation · Final report · May 29, 1985 · N8976F · Substantial damage > On a downwind swath run the helicopter experienced an eng failure and the plt entered an autorotation. The plt then made a hard landing which resulted in substantial damage. Inspection of the engine revealed that the nut which retains the gear to crankshaft… - [NTSB MKC85FA114](https://openairdocs.org/ntsb/MKC85FA114.md): Bell OH-13E · Jonesboro, AR · Accident · Serious injuries · Field investigation · Final report · May 29, 1985 · N29WL · Substantial damage > The plt reported that the eng quit due to fuel exhaustion. He attempted to land straight ahead on soft terrain, but the helicopter rolled over. During the accident sequence, the main rotor blades struck the tail boom & scattered parts ahead of & to the rgt of… - [NTSB LAX85FA262](https://openairdocs.org/ntsb/LAX85FA262.md): Cessna TU-206E · San Manuel, AZ · Accident · 2 fatal · Field investigation · Final report · May 29, 1985 · N1475M · Destroyed > This plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed. - [NTSB DEN85LA144](https://openairdocs.org/ntsb/DEN85LA144.md): Continental Copters Tomcat Mark 5A/OH13H · Freeman, SD · Accident · Minor injuries · Limited investigation · Final report · May 29, 1985 · N9081T · Substantial damage > The plt said he had completed 4 to 5 swath runs (crop spraying mission). During a turning manuever with a left quatering tail wind, full left pedal,full pwr,the helicopter had a high sink rate until grd impact. - [NTSB LAX85FA259](https://openairdocs.org/ntsb/LAX85FA259.md): Globe GC-1B · Moorpark, CA · Accident · 1 fatal · Field investigation · Final report · May 27, 1985 · N80970 · Destroyed > Acft crashed while being maneuvered in a canyon. Post crash inspection of the propeller revealed no evidence of rotation at impact. One-half gal of automotive fuel was found in the left wing tank and no fuel was found in the right wing tank. Some fuel lines… - [NTSB CHI85FA211](https://openairdocs.org/ntsb/CHI85FA211.md): Steens Skybolt · New Baden, IL · Accident · 1 fatal · Field investigation · Final report · May 27, 1985 · N64AB · Destroyed > Witnesses stated the acft made a low pass down the rwy (20 to 30 ft AGL) at an airspeed of aprx 200 mph. The acft then entered a steep climb and at about 100 at AGL, the acft rolled to the right. The acft lost alt during the roll and descended to ground… - [NTSB ATL85FA173](https://openairdocs.org/ntsb/ATL85FA173.md): Cessna R182 · Seneca, SC · Accident · 1 fatal · Field investigation · Final report · May 27, 1985 · N7161S · Destroyed > During flt, the plt was observed to make a low pass over lake keowee near a friend's houseboat. The owner of the houseboat stated that the acft was flying low off his right side when the acft struck the water. Another witness also saw the acft flying at… - [NTSB SEA85FA124](https://openairdocs.org/ntsb/SEA85FA124.md): Cessna 177 · Selma, OR · Accident · 3 fatal · Field investigation · Final report · May 26, 1985 · N2276Y · Destroyed > The acft was on a cap search mission with a plt & 2 observers on board. While searching, the plt was flying relatively low & slow over wooded, mountainous terrain. A witness observed the acft enter a bowl or box canyon type area at or below his eye level. The… - [NTSB MIA85LA177](https://openairdocs.org/ntsb/MIA85LA177.md): Piper PA-18 · St.Petersburg, FL · Accident · Minor injuries · Limited investigation · Final report · May 26, 1985 · N1211A · Substantial damage > The pilot was assigned an aircraft with a recently overhauled engine to tow a banner. He preflighted, started and ran-up the engine 3 times. Each time the engine ran rough and lost RPM on magneto checks. After each occurrence, companymaintenance personnel… - [NTSB DEN85FTK01](https://openairdocs.org/ntsb/DEN85FTK01.md): Boeing A75 · Tea, SD · Accident · Serious injuries · Final report · May 26, 1985 · N555 · Substantial damage > The owner/plt-in-command (PIC) took off on a local flt with another occupant in the front seat. The front seat occupant was a commercial, single-eng, multi-eng plt with an instructor rating, but he had no previous experience in A75 acft. While in flt, the PIC… - [NTSB CHI85FA209](https://openairdocs.org/ntsb/CHI85FA209.md): Heekin B-8-M · Williamsburg, OH · Accident · 1 fatal · Field investigation · Final report · May 25, 1985 · N3250M · Destroyed > Witness reported hearing a loud bang and seeing the main rotor blades stopped. The gyrocopter was then observed rotating slowly in a clockwise direction to ground impact. The wooded prop (engine driven) was demolished with portions of it found up to 300 ft… - [NTSB ATL85FLT06](https://openairdocs.org/ntsb/ATL85FLT06.md): Cessna 150F · Jeffersonville, KY · Accident · 1 fatal · Final report · May 25, 1985 · N7717F · Substantial damage > The acft collided with the ground in a steep nose down attitude while banking to the left. The acft was in the process of making an approach to land in an off arpt pasture which was not normally used for acft operations. No mecanical reasons for the accident… - [NTSB NYC85FGM04](https://openairdocs.org/ntsb/NYC85FGM04.md): Bell 206B · New Baltimore, PA · Accident · Serious injuries · Final report · May 22, 1985 · N9901K · Substantial damage > The acft collided with a power line during aerial application operations. There was no malfunction of equipment prior to the accident. The helicopter descended into trees & was damaged. The plt said that he was looking for a cut off marker in the form of a… - [NTSB CHI85LA204](https://openairdocs.org/ntsb/CHI85LA204.md): Bell 47G-2A · Mantua, OH · Accident · No injuries · Limited investigation · Final report · May 22, 1985 · N73219 · Substantial damage > During an aerial application flt, the plt banked the helicoper to fly around a utility pole; however, the main rotor blades contacted the pole. The helicopter then descended, landed on its skids & sustained substantial damage. The plt stated that the gusty… - [NTSB NYC85FA131](https://openairdocs.org/ntsb/NYC85FA131.md): Cessna TR-182 · Grand Island, NY · Accident · 3 fatal · Field investigation · Final report · May 21, 1985 · N756ZM · Destroyed > The flt had been on a local sightseeing tour over the niagara falls. The plt then stated that he was going to give his pax a demonstration of how fast the acft appears to be traveling when it is close to the water. The plt then began a left descending turn… - [NTSB DEN85LA137](https://openairdocs.org/ntsb/DEN85LA137.md): Piper PA-36 · Claire City, SD · Accident · Minor injuries · Limited investigation · Final report · May 21, 1985 · N2382Y · Substantial damage > The acft collided with power lines during an aerial application flt. The power lines were located in the middle of the field being sprayed and during the last spray run, while flying into the sun, the acft contacted the lines. - [NTSB SEA85FA120](https://openairdocs.org/ntsb/SEA85FA120.md): Cessna 205 · Chewelah, WA · Accident · 3 fatal · Field investigation · Final report · May 20, 1985 · N125ZL · Destroyed > The acft was observed flying up a canyon at low altitude while climbing at an angle equivalent to the surrounding terrain slope. Shortly thereafter the acft encountered steeply upsloping terrain and began impacting trees in a left wing high and nose up… - [NTSB MKC85LA107](https://openairdocs.org/ntsb/MKC85LA107.md): Ayres S2R-600 · Harrisburg, AR · Accident · No injuries · Limited investigation · Final report · May 20, 1985 · N4017W · Destroyed > Plt reports that the lt wing of N4017N hit a dike in a ricefield while he was making a trim swath. There were no indications of equipment malfunction. - [NTSB LAX85LVA03](https://openairdocs.org/ntsb/LAX85LVA03.md): Bell 47-G5 · Lindsay, CA · Accident · Minor injuries · Final report · May 20, 1985 · N1316X · Substantial damage > The acft made a forced landing in a beet field following a noise in the eng or transmission. After he heard a noise the plt auto-rotated and during the hard landing the acft was damaged. - [NTSB SEA85FYM02](https://openairdocs.org/ntsb/SEA85FYM02.md): Ringsdorf-Mcconnell VARI-EZE · Eugene, OR · Accident · Serious injuries · Final report · May 19, 1985 · N37993 · Destroyed > The acft has a fuselage fuel tank which holds only two gallons as well as two wing fuel tanks. The pilot departed the airport on the fuselage tank and the engine ceased operating before he realized he needed to change the fuel selector. An unsuccessful… - [NTSB LAX85FVA02](https://openairdocs.org/ntsb/LAX85FVA02.md): Cessna 172 · Santa Nella, CA · Accident · Serious injuries · Final report · May 19, 1985 · N5982A · Destroyed > Witnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact. - [NTSB ATL85LA166](https://openairdocs.org/ntsb/ATL85LA166.md): Schweizer SGS-233 · Chester, SC · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N5724S · Substantial damage > The instructor pilot cut loose from the tow plane at 200 ft AGL during takeoff to simulate a rope break. The acft collided with trees while circling to land. CFI stated that student plt was too slow in returning to land on the rwy. - [NTSB MKC85LA104](https://openairdocs.org/ntsb/MKC85LA104.md): Schweizer G-164A · Searcy, AR · Accident · No injuries · Limited investigation · Final report · May 18, 1985 · N8710H · Destroyed > The plt reports that the eng lost power during a spray pass and each time he advanced the throttle in an effort to regain power the eng backfired. The plt made a forced landing in a nearby field and the acft hit a ditch, nosed over and burned. The eng was… - [NTSB FTW85LRA02](https://openairdocs.org/ntsb/FTW85LRA02.md): Air Tractor AT301 · Anahuac, TX · Accident · Serious injuries · Final report · May 17, 1985 · N1361E · Substantial damage > The acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt. - [NTSB CHI85FA198](https://openairdocs.org/ntsb/CHI85FA198.md): Bell 47G-2 · Burlington, MI · Accident · 1 fatal · Field investigation · Final report · May 16, 1985 · N3755J · Substantial damage > The helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right. - [NTSB MIA85FA170](https://openairdocs.org/ntsb/MIA85FA170.md): Silvaire Luscombe 8A · Astatula, FL · Accident · 1 fatal · Field investigation · Final report · May 15, 1985 · N71909 · Destroyed > The plt (PIC) & his plt rated friend were practicing what the PIC described as simulated crop dusting. After completing a low pass over a field, the PIC made a steep pull up to turn around. He reported that the acft then stalled & crashed. A witness stated… - [NTSB CHI85LA197](https://openairdocs.org/ntsb/CHI85LA197.md): Hughes 269 · Stonington, IL · Accident · No injuries · Limited investigation · Final report · May 15, 1985 · N7485F · Destroyed > After completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft… - [NTSB LAX85FA253](https://openairdocs.org/ntsb/LAX85FA253.md): Cessna 177B · Ojai, CA · Accident · 2 fatal · Field investigation · Final report · May 13, 1985 · N17239 · Destroyed > Witnesses observed the acft enter a box canyon in level flt at an alt below the tops of the surrounding ridges. The eng pwr sounds were reported as 'normal' by the witnesses. Shortly after the acft disappeared behind a ridge, the witnesses saw black smoke… - [NTSB FTW85FA220](https://openairdocs.org/ntsb/FTW85FA220.md): Cessna 182RG · Odessa, TX · Accident · 2 fatal · Field investigation · Final report · May 13, 1985 · N737ZL · Destroyed > While flying at approx 100' AGL, the acft struck a 5/8' static line on a newly constructed powerline. The cable was not yet anchored, except with pulley's on each tower and had about two miles of slack. The wire engaged the left front eng cowl and 1 prop… - [NTSB ANC85LA109](https://openairdocs.org/ntsb/ANC85LA109.md): Cessna 207 · Emmonak, AK · Accident · No injuries · Limited investigation · Final report · May 12, 1985 · N9975M · 2 aircraft · Minor damage > The pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the… - [NTSB NYC85FA120](https://openairdocs.org/ntsb/NYC85FA120.md): Cessna 210M · Morrisville, NY · Accident · 2 fatal · Field investigation · Final report · May 11, 1985 · N761MC · Destroyed > Shortly after t/o the pilot experienced a rough running engine, continued maneuvering at a low altitude and the engine quit due to undetermined cause. The pilot attempted to stretch the glide to an open field and stalled the aircraft, which mushed into the… - [NTSB MIA85LA168](https://openairdocs.org/ntsb/MIA85LA168.md): Bellanca 7GCBC · Stuart, FL · Accident · No injuries · Limited investigation · Final report · May 11, 1985 · N41699 · Substantial damage > The plt stated that after releasing his banner, he made a steep right bank & the acft stalled & collided with the ground. He reported that the winds were variable. Aprx 30 south, the 1335 wind was from 040 deg at 12 KTS. - [NTSB ANC85LA080](https://openairdocs.org/ntsb/ANC85LA080.md): Piper PA-18-150 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · May 11, 1985 · N4621Y · Substantial damage > The pilot in command stated he was flying in whiteout conditions when he observed an island pass by the right side of the airplane. He started a right turn and the right wing struck the lake ice surface. He stated he did not realize he was that low. - [NTSB NYC85LA121](https://openairdocs.org/ntsb/NYC85LA121.md): Cessna 150M · Hancock, MA · Accident · Serious injuries · Limited investigation · Final report · May 10, 1985 · N3550V · Substantial damage > The acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find… - [NTSB NYC85LA111](https://openairdocs.org/ntsb/NYC85LA111.md): Cessna R172K · Glen Campbell, PA · Accident · No injuries · Limited investigation · Final report · May 10, 1985 · N736FG · Substantial damage > During flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.… - [NTSB FTW85FPJ02](https://openairdocs.org/ntsb/FTW85FPJ02.md): Robinson R-22A · Mcalester, OK · Accident · No injuries · Final report · May 8, 1985 · N8556C · Substantial damage > The plt was using the helicopter to round up cattle. One cow charged the helicopter and struck the tail rotor. The helicopter pitched nose down, the main rotor blade struck the ground. The helicopter came to rest in an upright position. - [NTSB FTW85FA211](https://openairdocs.org/ntsb/FTW85FA211.md): Cessna 310H · Avinger, TX · Accident · 1 fatal · Field investigation · Final report · May 8, 1985 · N1013Q · Substantial damage > The pilot stated he was flying low over the lake surface. He felt a decelaration to the right and the next thing he was in the water. Witnesses saw the aircraft over the lake at a low altitude and saw the right wing impact the water and cartwheel to the right… - [NTSB CHI85LA191](https://openairdocs.org/ntsb/CHI85LA191.md): Cessna A188B · Virden, IL · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N731VR · Destroyed > During aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground. - [NTSB ATL85LA156](https://openairdocs.org/ntsb/ATL85LA156.md): Piper PA-25-260C · Ashburn, GA · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N4796Y · Destroyed > The plt was on a flt to clean the spray boom by flying down the center of the airstrip & dispensing a cleaning substance thru the spray boom. He made one pass down the strip, then entered a pull-up to the right. He stated that he then turned back to the left… - [NTSB MKC85LA099](https://openairdocs.org/ntsb/MKC85LA099.md): Piper PA-25-235 · Bridgeport, NE · Accident · No injuries · Limited investigation · Final report · May 7, 1985 · N7655Z · Substantial damage > Pilot was making a trial flight with thought of possible purchase of the ag operation. Pilot made forced landing after fuel supply was exhausted. Pilot decided against purchase and departed the area. Pilot has not been located or identified. - [NTSB MKC85LA096](https://openairdocs.org/ntsb/MKC85LA096.md): Aero Commander S2R · Grady, AR · Accident · No injuries · Limited investigation · Final report · May 7, 1985 · N1754S · Substantial damage > Ag airplane was being flown on a spray run when the left wing hit a tree. Impact with tree and ground demolished the airplane. Pilot was wearing helmet and seat belt and shoulder harness was fastened. The pilot was not injured. - [NTSB LAX85LA246](https://openairdocs.org/ntsb/LAX85LA246.md): Cessna 172H · Bullhead City, AZ · Accident · Minor injuries · Limited investigation · Final report · May 7, 1985 · N8188L · Substantial damage > The plt reported that while he was flying & looking for 'wild animals at the base of the mountain' the acft's eng lost power. The acft descended & when it was close to the ground eng power was reacquired. The plt further reported that there was 'severe'… - [NTSB SEA85LA107](https://openairdocs.org/ntsb/SEA85LA107.md): Hiller UH-12E · Fall Creek, OR · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N28872 · Substantial damage > The helicopter sustained substantial damage during a forced landing following a loss of power. According to the plt, the helicopter was refueled aprx 1 hr flt time prior to the accident. Cause of the power loss was not determined. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=206 ## 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=205 --- 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.