# 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 362 of 718 · 35,889 cases ## Cases, newest first - [NTSB DEN84FA016](https://openairdocs.org/ntsb/DEN84FA016.md): Cessna TU-206A · Loveland, CO · Accident · No injuries · Field investigation · Final report · Oct 23, 1983 · N4831F · Substantial damage > The acft lost part of one blade of the propeller during the climb to cruise phase of operation. The passengers were skydivers so they used their parachutes in an exit of the acft as the airframe started to vibrate. The plt made a successful landing on the… - [NTSB DEN84FA012](https://openairdocs.org/ntsb/DEN84FA012.md): Cessna T210G · Bountiful, UT · Accident · Serious injuries · Field investigation · Final report · Oct 23, 1983 · N6906R · Substantial damage > During flt at 11,000 ft, the plt noted that the fuel flow gage was 'wiggling' & the eng 'didn't sound real healthy.' He increased the mixture slightly & turned the aux fuel pump to 'low boost.' The fuel flow then stabilized 'pretty good.' The plt said that a… - [NTSB LAX84FA025](https://openairdocs.org/ntsb/LAX84FA025.md): Deley Starduster SA-100 · Wrightwood, CA · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1983 · N717MD · Substantial damage > The acft crashed in mountainous terrain in VMC weather. There is no record of radio communications with the acft on the day of the accident. The acft impacted a 30 degree upslope in a 25 degree nose down wings level attitude. Two witnesses said they observed… - [NTSB FTW84LA033](https://openairdocs.org/ntsb/FTW84LA033.md): Cessna 210 · Truth Or Cons, NM · Accident · No injuries · Limited investigation · Final report · Oct 22, 1983 · N7400E · Substantial damage > The plt reported that while the acft was cruising at 10,500 ft MSL, the eng lost power & he was unable to restart it. During an emergency landing, the nose gear hit a rock & collapsed. The acft was checked, but the eng could not be started, when 1st… - [NTSB ATL84FA026](https://openairdocs.org/ntsb/ATL84FA026.md): Piper PA-24-250 · Lake Hills, TN · Accident · 2 fatal · Field investigation · Final report · Oct 22, 1983 · N5763P · Substantial damage > While en route, the acft's radio transmitter became inop; however, the plt could receive transmissions & was provided vectors toward the destination arpt. After starting a descent near the destination, the eng lost power. Subsequently, the acft was ditched in… - [NTSB MIA84LA013](https://openairdocs.org/ntsb/MIA84LA013.md): Cessna 172M · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1983 · N1441U · Substantial damage > While the plt was descending near his destination, the eng lost power. Subsequently, the acft hit trees, a power line & a fence during a forced landing. A teardown of the eng & an exam of the fuel sys revealed no evidence of a preimpact, mechanical… - [NTSB LAX84IA023](https://openairdocs.org/ntsb/LAX84IA023.md): Cessna 414 · Van Nuys, CA · Incident · No injuries · Incident investigation · Final report · Oct 20, 1983 · N414JC · No damage > During climb to cruise the pilot stated the nose of the abruptly pitched up. He physically overpowered the forces and landed the acft. Examination of the acft & systems revealed no failures that would account for the pitch up. - [NTSB DEN84FA010](https://openairdocs.org/ntsb/DEN84FA010.md): Cessna 182F · Burke, SD · Accident · 2 fatal · Field investigation · Final report · Oct 20, 1983 · N3375U · Destroyed > Prior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look… - [NTSB DEN84IA007](https://openairdocs.org/ntsb/DEN84IA007.md): Boeing 727-222 · Pueblo, CO · Incident · No injuries · Incident investigation · Final report · Oct 19, 1983 · N70634 · No damage > The acft experienced an uncontrolled altitude deviation as a result of encountering cat at 27000 ft. it climbed at 6000 fpm to 3200 ft. the acft was 40 to 50 miles north & slightlybelow the jet core. No turbulence was forecast. - [NTSB NYC84FA009](https://openairdocs.org/ntsb/NYC84FA009.md): Bell 206B III · Hudson, NH · Accident · 1 fatal · Field investigation · Final report · Oct 18, 1983 · N5011N · Destroyed > The plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'… - [NTSB ATL84LA022](https://openairdocs.org/ntsb/ATL84LA022.md): Beech A36 · Greensboro, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 1983 · N38234 · Substantial damage > The acft lost power during the climb to cruise. The plt made a forced landing and collided with trees. The fuel selectorwas on the empty left tank. The right tank contained 20 gallons of fuel. The plt did not check the fuel selector prior to takeoff and did… - [NTSB MKC84LA009](https://openairdocs.org/ntsb/MKC84LA009.md): Piper PA-28R-200 · Carlisle, IA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1983 · N2825T · Substantial damage > The pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight. - [NTSB MKC84LA008](https://openairdocs.org/ntsb/MKC84LA008.md): Cessna P210N · Lawrence, KS · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1983 · N731HP · Substantial damage > The plt reported that prior to flt, the fuel gages indicated both tanks were full; however, he did not visually verify the quantity of fuel. During flt, in the vicinity of emporia, KS, the eng lost power while using fuel from the left tank. The plt changed… - [NTSB LAX84LA015](https://openairdocs.org/ntsb/LAX84LA015.md): Beech S35 · Laton, CA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1983 · N7916K · Substantial damage > While in lvl flt and cruise flt configuration the plt stated that the eng suddenly began to get rough he noted that when pwr was partially reduced the roughness terminated. When the mixture was leaned the eng died momentarily. He rptd that the eng RPM was… - [NTSB FTW84FA023](https://openairdocs.org/ntsb/FTW84FA023.md): Cessna 172M · Redfield, AR · Accident · 3 fatal · Field investigation · Final report · Oct 16, 1983 · N321HR · Destroyed > At aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,… - [NTSB SEA84LA010](https://openairdocs.org/ntsb/SEA84LA010.md): Cessna 172 · Mccall, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1983 · N738RD · Substantial damage > While en route, the plt entered a drainage area in mountainous terrain with the intent of crossing a ridge at the lowest point. As he continued in a canyon, he had a 500 ft/min climb rate & he believed he could easily clear the ridge. However, as he… - [NTSB FTW84LA025](https://openairdocs.org/ntsb/FTW84LA025.md): Beech C24R · Prairie Grove, AR · Accident · No injuries · Limited investigation · Final report · Oct 15, 1983 · N23PS · Substantial damage > The plt stated that about 15 min after takeoff, the radio & navigation equpment quit working. He decided to return to the arpt to land. However, when he tried to extend the gear, he could not get a safe gear down indication. There was heavy traffic, so he… - [NTSB LAX84LA013](https://openairdocs.org/ntsb/LAX84LA013.md): Luscombe 8A · Victorville, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1983 · N7113O · Substantial damage > The plt stated that the flt was proceeding smoothly until he veered off course to go around a restricted area & became slightly lost. When he was 5-1/2 mi se of george afb & 36 mi sw of his destination he noticed that the fuel gage was reading empty. Moments… - [NTSB LAX84FA012](https://openairdocs.org/ntsb/LAX84FA012.md): Cessna 210-5 (205) · Schurz, NV · Accident · 2 fatal · Field investigation · Final report · Oct 14, 1983 · N8370Z · Destroyed > The acft was on a crosscountry flight in VFR conditions. The non-instrument rated pilot encountered instrument conditions at night and lost control of the acft in flight. The post crash investigation revealed evidence of an inflight structural failure due to… - [NTSB DEN84FA011](https://openairdocs.org/ntsb/DEN84FA011.md): Cessna 182 · Hanksville, UT · Accident · 2 fatal · Field investigation · Final report · Oct 14, 1983 · N3254Y · Destroyed > There were two pilots aboard this acft which impacted in a steep nose down attitude on a plateau at 5000 ft MSL. Flight control continuity was established. The pilot was recently certificated & his class iii medical had expired. The second pilot held a… - [NTSB NYC84IA007](https://openairdocs.org/ntsb/NYC84IA007.md): McDonnell Douglas DC-10-10 · Atlantic Ocean (Atlantic Ocean) · Incident · Minor injuries · Incident investigation · Final report · Oct 12, 1983 · N123AA · No damage > The acft encountered moderate to severe turbulence as it seemed to pass through a cumulus cloud. Radar showed no buildups & there were no sigmets or airmets in effect. - [NTSB DCA84AA002](https://openairdocs.org/ntsb/DCA84AA002.md): Hawker Siddeley HS-748-2A · Pinckneyville, IL · Accident · 10 fatal · Final report · Oct 12, 1983 · N748LL · Destroyed > About 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft… - [NTSB SEA84IA008](https://openairdocs.org/ntsb/SEA84IA008.md): S.N.I.A.S. AS350D · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 11, 1983 · N350GT · No damage > The acft sustained a complete failure of the tail rotor drine shaft due to fatigue from stress corrosion precipitated byprevious damage at which time no logbook entry was recorded to indicate that the shaft had been inspected. - [NTSB NYC84FHM01](https://openairdocs.org/ntsb/NYC84FHM01.md): Piper PA-28-181 · Poughkeepsie, NY · Accident · Minor injuries · Final report · Oct 11, 1983 · N30460 · Destroyed > The acft collided with trees during a forced landing after the engine quit. The plt had let down through clouds during a descent for a vor-dme approach. The acft broke out of the clouds at 2500 ft, seeing the arpt the plt cancelled IFR. After getting rwy… - [NTSB MKC84FA005](https://openairdocs.org/ntsb/MKC84FA005.md): Bellanca 8KCAB · Sullivan, MO · Accident · 2 fatal · Field investigation · Final report · Oct 9, 1983 · N55008 · Destroyed > The acft collided with trees during an attempted go-around from a precautionary/forced landing. There were no radio calls from the pilot but evidence discovered in the engine tear down revealed internal problems. The magneto had broken and the oil pan… - [NTSB LAX84LA008](https://openairdocs.org/ntsb/LAX84LA008.md): Johnson Varieze · Pacifica, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 8, 1983 · N555EZ · Substantial damage > During flt, the eng lost power. Witnesses observed the plt make a forced landing on a shoreline. The acft touched down on beach sand, the main gear separated, then the fuselage skipped along the sand/surf for about 250 yds. Before stopping, it impacted a… - [NTSB FTW84FA014](https://openairdocs.org/ntsb/FTW84FA014.md): Cessna 195B · Alanreed, TX · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1983 · N3048B · Destroyed > A recovered flt log indicated a route of flt via tulsa, OK; klahoma city,OK; sayre,OK; amarillo, TX; then tucumcari,NM. While taxiing for takeoff at the departure arpt, the plt received a wx briefing along the route to Oklahoma city. The accident site was 44… - [NTSB DEN84FA019](https://openairdocs.org/ntsb/DEN84FA019.md): Piper PA-28-236 · Kim, CO · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1983 · N2174M · Destroyed > The acft collided with the ground in a wing down nose low attitude. The plt had been advised that VFR flt was not recommended for his route of flt. The non-instrument rated plt went anyway and encountered weather. In maneuvering to get below or out of the… - [NTSB MIA84FA004](https://openairdocs.org/ntsb/MIA84FA004.md): Sikorsky S-61N · West Palm Beach, FL · Accident · Serious injuries · Field investigation · Final report · Oct 7, 1983 · YV323 · Destroyed > While descending for a landing there was a separation of an outboard section of the main red rotor blade. An old crack was noted & the fracture was attributed to high stress low cycle fatigue damage initiating from corrosion pitting. - [NTSB FTW84LA018](https://openairdocs.org/ntsb/FTW84LA018.md): Cessna 182M · Aline, OK · Accident · No injuries · Limited investigation · Final report · Oct 7, 1983 · N91620 · Substantial damage > Before departing norman, OK, the plt obtained a wx briefing from the Oklahoma city fss. During that briefing, he was advised that VFR flt was not recommended. He then took off for dodge city, KS without filling a flt plan. However, en route, he encountered wx… - [NTSB CHI84LA014](https://openairdocs.org/ntsb/CHI84LA014.md): Piper PA-28R-180 · Waupaca, WI · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1983 · N7695J · Substantial damage > Plt had made missed approaches at wausau & mosinee. Plt informed artc that he had a fuel problem. While receiving vectors to Waupaca arpt the eng quit & the acft crashed into trees. Total time of flt was 4+33. The right tank fuel filler cap was loose & the… - [NTSB CHI84LA012](https://openairdocs.org/ntsb/CHI84LA012.md): Cessna 172E · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Oct 7, 1983 · N5728T · Substantial damage > The acft collided wih a pole and mail boxes during a forced landing after fuel exhaustion. The pilot was unalbe to find blur ash arpt and asked for assistance from Cincinnati approach. When the arpt was located after over 6 hours of flt time,the acrt ran out… - [NTSB ATL84LA014](https://openairdocs.org/ntsb/ATL84LA014.md): Piper PA-24-250 · Vicksburg, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1983 · N7691P · Substantial damage > The acft landed short of the rwy during a forced landing after the engine lost power during cruise flt. The plt reportedthat power was lost at 2000 ft 10 miles north of Vicksburg. He applied the fuel boost pump and successfully restarted the eng but it quit… - [NTSB SEA84LA003](https://openairdocs.org/ntsb/SEA84LA003.md): Cessna T210M · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1983 · N1817M · Substantial damage > After takeoff while on a right turnout from rwy 31L, & at about 1000 ft AGL, the eng quit. The plt returned to the arpt & elected to lower the gear when he knew rwy 13L could be reached. However the left main gear failed to lock prior to touchdown & the… - [NTSB SEA84FA005](https://openairdocs.org/ntsb/SEA84FA005.md): Hordemann RV-4 · Kootenai, ID · Accident · Serious injuries · Field investigation · Final report · Oct 5, 1983 · N488RV · Destroyed > According to the plt he was cruising at 11500 MSL when smoke started coming from the lower forward section of the cockpit and a fire developed around his feet. The engine was shut down and the fire subsided or went out. During the glide for landing the engine… - [NTSB LAX84FA005](https://openairdocs.org/ntsb/LAX84FA005.md): Cessna 175B · Burbank, CA · Accident · 1 fatal · Field investigation · Final report · Oct 5, 1983 · N8146T · Destroyed > Relatives expected the plt to return home on the evening of 10/4/83. When he did not return, relatives report the acft was overdue. The acft was found where it collided with a mountain at an elevation of about 3580 ft, 10 mi north of the destination arpt.… - [NTSB MIA84FA003](https://openairdocs.org/ntsb/MIA84FA003.md): Kimbal Dyke Delta JD2 · Punta Gorda, FL · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1983 · N55AK · Destroyed > The homebuilt acft was observed flying northeast ovr the east side of charlotte county arpt at abt 1000 ft. witnesses stated that the acft pitched downward and entered a spin into the ground. Wreckage examination revealed that the wing bonding material… - [NTSB DEN84LA003](https://openairdocs.org/ntsb/DEN84LA003.md): Bell 206B · Fort Bridger, WY · Accident · No injuries · Limited investigation · Final report · Oct 4, 1983 · N57556 · Substantial damage > The acft was enroute from a powder magazine to a staging area about 2 mi away during a seismic exploration operation. The plt stated that while 100-200 ft AGL he initiated a right turn of 60 deg of bank towards a bowl formed by low lying hills to observe a… - [NTSB ATL84LA015](https://openairdocs.org/ntsb/ATL84LA015.md): Cessna 310 · Madisonville, KY · Accident · No injuries · Limited investigation · Final report · Oct 4, 1983 · N4880B · Substantial damage > According to the plt, the acft was being flown on a return flt after being refueled at trenton, NJ. He reported that the acft held 100 gal of usable fuel & had consumed 70 gals on the initial flt on the same route. He reported that the ground speed & fuel… - [NTSB MIA84LA002](https://openairdocs.org/ntsb/MIA84LA002.md): Cessna 172 · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1983 · N4860F · Destroyed > While in a descending spiral the plt stated that the cockpit filled with smoke. He proceeded to turn off the electrical master switch. Shortly aft the eng failed and the acft was ditched in 480 ft of water. - [NTSB SEA84LA001](https://openairdocs.org/ntsb/SEA84LA001.md): Beech A23 · Burley, ID · Accident · No injuries · Limited investigation · Final report · Oct 2, 1983 · N4773J · Substantial damage > The plt was participating in an open course air race to jackpot, NV. He planned to make an en route stop at arco, ID to refuel. The wx forcast called for marginal conditions. The plt made a telephone call to arco & confirmed that the wx (at that time) was… - [NTSB LAX84FA002](https://openairdocs.org/ntsb/LAX84FA002.md): Cessna 182M · Snow Water Lake, NV · Accident · 2 fatal · Field investigation · Final report · Oct 2, 1983 · N92019 · Destroyed > The acft collided with the terrain in a high speed wings level descent at night after encountering weather and icing at flt level of 13000 ft. the plt was in contact with salt lake center until 5 minutes before radar contact was lost and gave no indication of… - [NTSB FTW84LA003](https://openairdocs.org/ntsb/FTW84LA003.md): Piper PA-28R-201T · Smithville, TX · Accident · No injuries · Limited investigation · Final report · Oct 2, 1983 · N2541Q · Substantial damage > During cruise at 8,500 ft MSL the eng quit. A night emergency landing was made at an arpt that the acft had just flown over. On final approach the plt could not see thru the windshield very well due to oil building up on the windshield. The plt held the gear… - [NTSB FTW83LA447](https://openairdocs.org/ntsb/FTW83LA447.md): Cessna 172M · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N9865Q · Substantial damage > Before takeoff, the plt visually checked the fuel. He believed there was sufficient fuel on board for the flt & reported that the fuel quantity gages agreed with his estimate. According to him, there was 25 to 30 gal of fuel on board when he took off & no… - [NTSB CHI84LA001](https://openairdocs.org/ntsb/CHI84LA001.md): Cessna 150 · Iron River, MI · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N8340M · Substantial damage > The plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over. - [NTSB CHI83LA448](https://openairdocs.org/ntsb/CHI83LA448.md): Hughes 369D · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Sep 30, 1983 · N5127X · Substantial damage > While the helicopter was cruising at about 500 ft AGL, the eng lost power. The plt turned into the wind & made an autorotative landing in a corn field. During the landing, the tail boom was severed by the main rotor blades. An exam revealed that the housing… - [NTSB MKC83FA225](https://openairdocs.org/ntsb/MKC83FA225.md): Beech 60 · Wichita, KS · Accident · No injuries · Field investigation · Final report · Sep 29, 1983 · N7277R · Destroyed > Shortly after takeoff, the left eng began to progressively lose power & was shut down. The aircrew notified Beech tower of the problem & reported they would like to return & land. The acft was observed on final apch to rwy 18 with the gear extended & the left… - [NTSB LAX83LA463](https://openairdocs.org/ntsb/LAX83LA463.md): Cessna 172N · Tulelake, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1983 · N6089F · Substantial damage > The plt reported that he made a low pass over the medicine lake area, then after circling for a few minutes, he climbed back to 7500 ft, established 2000 RPM & 70 KTS, & continued the flt. Appx 5 min later, he noticed that the trees appeared to be getting… - [NTSB CHI83LA447](https://openairdocs.org/ntsb/CHI83LA447.md): Piper PA-28-140 · Conneaut, OH · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N4511T · Substantial damage > The plt reported that while descending near his destination, the eng stopped & started 3 or 4 times, then would not restart. Just prior to that, he noted the right fuel gage indicated 8 gal & the left gage indicated 2 gal. He then landed 'in the rough' on a… - [NTSB ATL83LA384](https://openairdocs.org/ntsb/ATL83LA384.md): Cessna 172K · Brundidge, AL · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N79025 · Destroyed > While cruising at 2,000 ft the plt smelled fuel fumes & elected to make a precautionary landing. When within gliding distance of the arpt, he secured the eng with the mixture control & made an uneventful deadstick landing. After exiting the acft he noticed… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=363 ## 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=362 --- 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.