# NTSB investigations: Enroute 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 371 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI83LA154](https://openairdocs.org/ntsb/CHI83LA154.md): Cessna 182RG · North Canton, OH · Accident · No injuries · Limited investigation · Final report · Mar 29, 1983 · N2260T · Substantial damage > The plt reported that he had filed an IFR flt plan to youngstown, OH, with a cruise alt of 9000 ft. after passing appleton, OH, he changed his destination to the akron muni arpt. During the apch, icing conditions were encountered. The plt reported that ice on… - [NTSB LAX83LA165](https://openairdocs.org/ntsb/LAX83LA165.md): Piper PA-32-300 · Gorman, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1983 · N4235R · Substantial damage > Encountering clouds enroute the plt descended to fly through the teton pass. After confirming a VFR check point, he commenced a climb. Shortly thereafter the acft struck a powerline. - [NTSB LAX83FVA02](https://openairdocs.org/ntsb/LAX83FVA02.md): Cessna 150F · Coulterville, CA · Accident · Serious injuries · Final report · Mar 28, 1983 · N8463G · Substantial damage > The pilot made two telephone calls to the fss requesting wx briefings for a VFR flt to medford, OR. He was provided with a summary of the current and forecast wx for his route and destination. He was advised that VFR flt was not recommended for that day. The… - [NTSB DEN83LA086](https://openairdocs.org/ntsb/DEN83LA086.md): Piper PA-18A-150 · Worland, WY · Accident · No injuries · Limited investigation · Final report · Mar 28, 1983 · N8977D · Substantial damage > The acft collided with a ditch and collapsed the landing gear during a forced landing after the engine quit during a ferry flight. The plt refueled the empty right fuel tank and topped-off the left tank with 3 gallons of fuel before the initial takeoff on the… - [NTSB MKC83FA081](https://openairdocs.org/ntsb/MKC83FA081.md): Piper PA-24-400 · Salem, MO · Accident · 1 fatal · Field investigation · Final report · Mar 27, 1983 · N8611P · Destroyed > The student plt departed dexter, MO at aprx dusk on a VFR, no-flt-plan flt to houston, MO. Time required for the flt would have been aprx 30 min (estimated). At 1900 CST, the bunker, MO city marshal reported that an acft flew over bunker so low that he… - [NTSB LAX83LA162](https://openairdocs.org/ntsb/LAX83LA162.md): Cessna 150G · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Mar 26, 1983 · N6319S · Substantial damage > The instructor plt (CFI) reported that while the student was practicing a full power climb, the eng began a smooth, but relatively rapid, decrease in power to about idle RPM or less. All attempts to restore power were to no avail. An emergency landing was… - [NTSB LAX83FUM05](https://openairdocs.org/ntsb/LAX83FUM05.md): Ware Teenie TWO · Escondido, CA · Accident · Serious injuries · Final report · Mar 26, 1983 · N68127 · Destroyed > The eng lost power while cruising at 3000 feet. The pilot determined that the engine power loss was due to a restricted fuel line just ahead of the gascolator. A restriction of the inlet port of the gasocalator resulted from electrolytic corrosion of a steel… - [NTSB LAX83FA160](https://openairdocs.org/ntsb/LAX83FA160.md): Mooney M20E · Cobb, CA · Accident · 1 fatal · Field investigation · Final report · Mar 26, 1983 · N2571W · Destroyed > The plt had left his acft at lakeport, CA for maintenance to be performed & barrowed Mooney M20E, N2571W. Before the plt took off, the owner heard him talking to someone about the wx, but no record of a wx briefing was found. While en route to palo alto, CA,… - [NTSB DEN83FA087](https://openairdocs.org/ntsb/DEN83FA087.md): Cessna T210M · Salt Lake City, UT · Accident · 3 fatal · Field investigation · Final report · Mar 26, 1983 · N6140B · Destroyed > Before departing phoenix, AZ, the plt obtained a wx briefing, was advised of forcasted icing conditions & was informed that the Salt Lake City (slc) VORTAC was out of service. While en route, at 0931, he received a wx update. The slc wx at that time was, in… - [NTSB ANC83FA059](https://openairdocs.org/ntsb/ANC83FA059.md): Cessna T-41B (R-172E) · Healy, AK · Accident · Minor injuries · Field investigation · Final report · Mar 26, 1983 · N65104 · Substantial damage > The plt reported that while cruising at 4000 ft MSL, the eng power began to fluctuate, then this was followed by a banging noise, rough eng operation & a decline in power output. He had turned to land into the wind when the eng power increased & stabilized.… - [NTSB LAX83LA157](https://openairdocs.org/ntsb/LAX83LA157.md): Cessna 401 · Near Globe, AZ · Accident · No injuries · Limited investigation · Final report · Mar 24, 1983 · N401G · Substantial damage > The pilot was cruising at 13000 feet MSL on a cross country when the engines lost power. The pilot had been using fuel from the main tanks for about 10 minutes after being on the aux. Tanks for the previous hour. The pilot restarted both engines on the aux.… - [NTSB LAX83FA166](https://openairdocs.org/ntsb/LAX83FA166.md): Beech A36TC · Sedona, AZ · Accident · 3 fatal · Field investigation · Final report · Mar 24, 1983 · N3863U · Destroyed > During preflt briefings, the plt was briefed to expect deteriorating wx conditions with associated flt precautions for mountain obscurement, icing & moderate turbulence. The wx briefings were complete, except due to an inoperative circuit, the 0654 prescott &… - [NTSB DEN83FA084](https://openairdocs.org/ntsb/DEN83FA084.md): Cessna 182 · Huntsville, UT · Accident · Serious injuries · Field investigation · Final report · Mar 24, 1983 · N9377X · Substantial damage > The afct collided with a tree and crashed during a go-around. The weather was IMC and the pilot and passenger were seriously injured. The pilot received a weather briefing and was told that VFR flt, on his intended route, was not recommended due to low… - [NTSB DCA83AA022](https://openairdocs.org/ntsb/DCA83AA022.md): Mitsubishi MU-2B-60 · Jeffersonville, GA · Accident · 4 fatal · Final report · Mar 24, 1983 · N72B · Destroyed > The acft was on the return portion of a round trip flt, hauling canceled bank checks. When they boarded before takeoff, the plt's wife, who was not a plt, occupied the r front seat & his 2 daughter's, ages 4 & 6, were in the passenger seats. Previous legs of… - [NTSB FTW83LA165](https://openairdocs.org/ntsb/FTW83LA165.md): Beech 200 · High Island · Accident · No injuries · Limited investigation · Final report · Mar 23, 1983 · N417EM · Substantial damage > The pilot stated that he was being vectored around thunderstorms when severe turbulence was encountered. The pilot was attempting to penetrate a line of thunderstorms about four mile wide when the turbulence was encountered. The course of penetration was… - [NTSB FTW83FA164](https://openairdocs.org/ntsb/FTW83FA164.md): Piper PA-24-260 · Salt Flat, TX · Accident · 3 fatal · Field investigation · Final report · Mar 23, 1983 · N8652P · Destroyed > Before departing tucson, the plt was advised of 2 marginal wx systems along his route. He took off at 1038 MST. At 1130,he contacted ATC & reported at 13,800'. From then until 1214, his alt varied between 10,000' & 16,000'. Radar contact was lost at 1228… - [NTSB LAX83FA154](https://openairdocs.org/ntsb/LAX83FA154.md): Bell 206 B III · Salinas, CA · Accident · 1 fatal · Field investigation · Final report · Mar 22, 1983 · N8163J · Destroyed > Purpose of flt was to transport a technician & his equipment to a mountain top to service a microwave antenna site. Cloud coverage precluded a landing at the site, but the plt was able to land in a clearing on the eastern ridge line about 100 yds below the… - [NTSB CHI83LA150](https://openairdocs.org/ntsb/CHI83LA150.md): Consolidated-Vultee 28-5ACF · Neilsville, WI · Accident · No injuries · Limited investigation · Final report · Mar 22, 1983 · N4760C · Substantial damage > The aircraft was crash landed in an open field after it had a power loss on #1 engine during cruise flight. The aircraft was on a geodetic survey flight which called for flight at 500 feet AGL. The pilot elected to land because the aircraft could not maintain… - [NTSB NYC83IA080](https://openairdocs.org/ntsb/NYC83IA080.md): Britten-Norman BN-2 Mark III · Blue Bell, PA · Incident · Minor injuries · Incident investigation · Final report · Mar 21, 1983 · N420WA · Minor damage > A deicer boot on a right propeller blade separated. It struck & broke a window. A tie strap was missing. There was no evidence of improper or inadequate bonding. - [NTSB LAX83FA153](https://openairdocs.org/ntsb/LAX83FA153.md): Cessna 170B · Near Pala, CA · Accident · 2 fatal · Field investigation · Final report · Mar 21, 1983 · N2462D · Destroyed > According to a friend of the plt, he (the plt) had watched wx infor on tv, on 3/20/83. To the friend's knowledge, the plt had never telephoned the FAA fss for a wx briefing or to file a flt plan. After the friend took the plt & his wife (who was also a plt)… - [NTSB LAX83LA151](https://openairdocs.org/ntsb/LAX83LA151.md): Boeing D75N1 · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Mar 20, 1983 · N59496 · Substantial damage > The acft nosed over during an emergency landing in an open field. The weather was VMC and no flt plan was filed. The pilot reported that during the ferry flt he flew past his destination arpt by misreading his sectional chart. Shortly after this he reversed… - [NTSB ATL83FA140](https://openairdocs.org/ntsb/ATL83FA140.md): Piper PA-28-140 · Crossville, TN · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1983 · N9600W · Destroyed > The aircraft crashed into hinch mt at the 2700 foot level during cruise flt in IMC weather. The pilot was informed during the initial and subsequent briefings that VFR flt was not recommended for his route. The first leg of the flight from new orleans to… - [NTSB MIA83LA097](https://openairdocs.org/ntsb/MIA83LA097.md): Stinson 10A · Defuniak Spring, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1983 · N32260 · Substantial damage > The engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there… - [NTSB MIA83IA098](https://openairdocs.org/ntsb/MIA83IA098.md): Cessna 402C · Near Taylor, FL · Incident · No injuries · Incident investigation · Final report · Mar 19, 1983 · N65PB · Minor damage > A propeller blade separated due to a fatigue failure. - [NTSB LAX83FA387](https://openairdocs.org/ntsb/LAX83FA387.md): Piper PA-28-151 · Trinity Center, CA · Accident · 2 fatal · Field investigation · Final report · Mar 19, 1983 · N41576 · Destroyed > The acft departed creswell, OR, sometime after 1800 PST on 3/19/83. At 2110 PST, the plt contacted portland flt watch by radio & stated that he was over roseburg, or at 9500 ft. he requested pireps of wx over the siskiyou mountains & into the san francisco… - [NTSB SEA83FA065](https://openairdocs.org/ntsb/SEA83FA065.md): Fairchild Hiller FH-1100 · Longview, WA · Accident · Serious injuries · Field investigation · Final report · Mar 18, 1983 · N26631 · Destroyed > Several persons saw the helicopter flying at a cruising altitude of about 200 to 300 ft, then enter a loop type of maneuver. They lost sight of the helicopter near the bottom of the maneuver before it crashed. The plt received serious head injuries & could… - [NTSB FTW83LA162](https://openairdocs.org/ntsb/FTW83LA162.md): Beech D-18S · Dfw Airport, TX · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N80017 · 2 aircraft · Substantial damage > N80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied… - [NTSB FTW83LA160](https://openairdocs.org/ntsb/FTW83LA160.md): Beech K35 · Torreon, NM · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N5395E · Substantial damage > The pilot, who was not certificated, stated that prior to departure he received a wx briefing by telephone from the fss. Enroute, after making several heading changes to avoid wx he found himself surrounded by low ceiling and precipitation. He decided to make… - [NTSB CHI83LA144](https://openairdocs.org/ntsb/CHI83LA144.md): Piper PA24-260 · Mansfield, OH · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 1983 · CGQYP · Substantial damage > During cruise flt at 8000 ft MSL, the eng lost oil pressure. The plt stated that smoke entered the cockpit & sparks were seen in the cowling area. Shortly after that, the eng seized. Radar vectors were obtain to the closest arpt; however, the plt was unable… - [NTSB LAX83IA147](https://openairdocs.org/ntsb/LAX83IA147.md): Douglas DC-9-10 · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Mar 17, 1983 · N9356 · No damage > During climb to 28,000 ft at 20,000 ft the auto-pilot disengaged and the crew reported that they could not move the control column to control pitch. The acft was operating in icing conditions at the time. The crew landed the acft by utilizing the trim control. - [NTSB MKC83IA078](https://openairdocs.org/ntsb/MKC83IA078.md): Aero Commander 680W · Kansas City, KS · Incident · No injuries · Incident investigation · Final report · Mar 16, 1983 · N200DT · Minor damage > The number 2 engine failed in cruise flight. Durng descent the landing gear failed to extend. The pilot landed intentional gear up in the sod area adjacent to the runway. - [NTSB CHI83LA140](https://openairdocs.org/ntsb/CHI83LA140.md): Beech 35-C33 · Princton, MN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N10HR · Substantial damage > The pilot said that at 6000 feet MSL the engine began to miss and got worse. He tried to correct the situation but could not. He requested and was given vectors to the princeton arpt. The arpt was closed at the time due to snow covered ruts on the rnwy and… - [NTSB MKC83FA076](https://openairdocs.org/ntsb/MKC83FA076.md): Robinson R-22 · St. Louis, MO · Accident · 2 fatal · Field investigation · Final report · Mar 14, 1983 · N9024Z · Destroyed > The helicopter was observed by several witnesses flying at 200-300 feet above the Mississippi river. As it wobbled and buffeted and rolled to the right. It was spinning and the tail rotor separated shortly followed by an explosion with a blueish/white smoke… - [NTSB LAX83FA138](https://openairdocs.org/ntsb/LAX83FA138.md): Mooney M20J · Chatsworth, CA · Accident · 2 fatal · Field investigation · Final report · Mar 14, 1983 · N8201V · Destroyed > The acft collided with powerlines 177 AGL during flt in adverse weather. About 2 miles from the site of the powerline collision the acft had collided with hilly terrain about 500 ft higher than the powerline. The pilot had received a weather briefing and… - [NTSB LAX83FVD06](https://openairdocs.org/ntsb/LAX83FVD06.md): Bell 206B · Escalon, CA · Accident · Minor injuries · Final report · Mar 13, 1983 · N90329 · Substantial damage > The helicopter collided with a small tree about 8 ft high during a forced landing at night after a power loss. The collision broke the tail boom and a hard landing caused the failure of a landing skid and damaged the main rotor. The plt had taken two friends… - [NTSB DEN83LA079](https://openairdocs.org/ntsb/DEN83LA079.md): Piper PA-12 · Coalville, UT · Accident · No injuries · Limited investigation · Final report · Mar 13, 1983 · N3743M · Substantial damage > The acft nosed over during an precautionary landing due to deteriorating weather. The plt had received a weather briefing. The wx conditions deteriorated enroute due to a snow storm and the plt elected to land on a private strip to await improved weather. The… - [NTSB CHI83FA135](https://openairdocs.org/ntsb/CHI83FA135.md): Piper PA-28-161 · Danvers, IL · Accident · 2 fatal · Field investigation · Final report · Mar 13, 1983 · N82026 · Destroyed > The aircraft crashed at night during IMC weather conditions on the return portion of a cross-country. The pilot had checked the weather outbound, but there was no record of a briefing for the return flight. The outbound flt was in early dusk. The return was… - [NTSB ANC83FAG05](https://openairdocs.org/ntsb/ANC83FAG05.md): Piper PA 28-140 · Chugiak, AK · Accident · Minor injuries · Final report · Mar 13, 1983 · N1642J · Substantial damage > The flt originated at anchorage, AK at aprx 1400 ast. While flying in the vicinity of knik glacier, some sheep were observed & the plt circled in the area 2 times. During the 2nd turn, the engine began running erratically. Reportedly, the plt applied… - [NTSB LAX83FA141](https://openairdocs.org/ntsb/LAX83FA141.md): Ryan Navion A · Fiddletown, CA · Accident · 2 fatal · Field investigation · Final report · Mar 12, 1983 · N444N · Destroyed > The acft crashed into hilly terrain while descending to enter the traffic pattern at the rancho murieta airport. The pilot had called sacramento fss to get assistance in locating this arpt which is about 11 NM from sacramento VOR on a bearing of about 65… - [NTSB MKC83LA079](https://openairdocs.org/ntsb/MKC83LA079.md): Rotec Rally 3 · Ultsses, KS · Accident · No injuries · Limited investigation · Final report · Mar 11, 1983 · N110RE · Substantial damage > This amateur-built aircraft was being flown at 200 feet AGL on a pleasure flight when the engine quit. The pilot made a forced landing in a soft field and the aircraft nosed over. The engine quit because the fuel cap was not vented. The capwas supplied with… - [NTSB LAX83IA140](https://openairdocs.org/ntsb/LAX83IA140.md): Mcdonnell Douglas DC 8-61 · Mina, NV · Incident · No injuries · Incident investigation · Final report · Mar 11, 1983 · N8076 · Minor damage > While established in a normal climb to curising altitude the#1 engine failed due to a failure of the first stage compressor wheel. The acft then diverted to reno NV and landed without further incident. - [NTSB LAX83LA132](https://openairdocs.org/ntsb/LAX83LA132.md): Cessna 150G · Oakland, CA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1983 · N4025J · Substantial damage > The student plt was on a solo x-country flt from haymond, CA to sonoma & grass valley, CA, then return to hayward. She reported that the en route time on the 1st 2 legs of the flt were increased slightly due to the wx. The acft was not refueled at either of… - [NTSB LAX83LA131](https://openairdocs.org/ntsb/LAX83LA131.md): Cessna T210N · Palm Springs, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1983 · N1766U · Substantial damage > The pilot had departed riverside with an estimated 28 gallons of fuel, 23 gallons in the left tank and about 5 gals in the right. He flew to Palm Springs on the left tank and began to let down from 11,500 feet. At 7,000 ft the engine quit. The pilot called… - [NTSB FTW83LA146](https://openairdocs.org/ntsb/FTW83LA146.md): Piper PA-20 · Martinsville, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1983 · N4944M · Substantial damage > Reportedly, the plt took off with 36 gallons of fuel on board, of which, 10 gals was automobile low lead fuel. The automobile fuel had been purchased from an off airport gasoline station, was transported to the acft in 5 gal cans, then added to the fuel tanks… - [NTSB ATL83FA133](https://openairdocs.org/ntsb/ATL83FA133.md): Grumman American AA-1B · Chesapeake, VA · Accident · Minor injuries · Field investigation · Final report · Mar 10, 1983 · N6266L · Substantial damage > The plt took off on rwy 4 & made a climbing left turn for a downwind departure. At aprx 900 ft, there was a partial loss of power to about idle RPM. The plt stated that he switched fuel tanks, applied carburetor heat & pumped the throttle, all to no avail. He… - [NTSB MIA83LA090](https://openairdocs.org/ntsb/MIA83LA090.md): Cessna 402C · Ft. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Mar 9, 1983 · N26506 · Destroyed > The acft was ditched in the atlantic ocean following engine failure. The pilot estamated fuel on board during pre-flightfrom the electronic fuel gauges. The acft flew 2 hrs and 16 minutes before the engines quit in a mode of fuel exhaustionwith surging prior… - [NTSB LAX83LA129](https://openairdocs.org/ntsb/LAX83LA129.md): Cessna 177B · Arvin, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1983 · N35105 · Substantial damage > While descending to land, the eng sputtered & quit. According to the plt, the fuel gages indicated the left tank was 1/4 full & the right tank was 1/8 full when the eng lost power. During an emergency landing on a roadway, the acft collided with poles & wires… - [NTSB LAX83FA144](https://openairdocs.org/ntsb/LAX83FA144.md): Cessna U2061 · Pt Reyes, CA · Accident · 2 fatal · Field investigation · Final report · Mar 9, 1983 · N1456M · Destroyed > The Cessna U2061, purchased that day by the occupants, collided with trees on a hillside 10 miles from pt. Reyes, CA. An eyewitness observed the aircraft flying into worsening weather at 500 AGL or lower under a thin cloud layer in the olema valley. During… - [NTSB FTW83FA144](https://openairdocs.org/ntsb/FTW83FA144.md): Cessna 172N · Mayflower, AR · Accident · 1 fatal · Field investigation · Final report · Mar 8, 1983 · N4505E · Destroyed > The acft collided with trees while flying in a westerly direction near Mayflower, AR. The acft was returning from a cross-country at night and was observed by a group of youths who said it was flying fast at low alt. As they watched, it descended to about… - [NTSB SEA83FA113](https://openairdocs.org/ntsb/SEA83FA113.md): Cessna 182Q · Mccall, ID · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1983 · N735VD · Destroyed > The acft impacted a rocky slope of a box canyon at the 6300 foot level. The weather was reported to be IMC with thunderstorms, overcast skies and the mountain tops obscured. The wreckage location was on a direct line between departure point and destination.… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=372 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=371 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.