# 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 354 of 718 · 35,889 cases ## Cases, newest first - [NTSB FTW84FA243](https://openairdocs.org/ntsb/FTW84FA243.md): Cessna 177B · Kinner, LA · Accident · 1 fatal · Field investigation · Final report · May 27, 1984 · N13871 · Substantial damage > The plt stated he lost eng pwr after departing the new orleans int'l arpt. The flt was unable to return to the arpt. The acft crashed in the waters of lake pontchartraih about 1 mile from the arpt. The wreckage was located and marked with a buoy. Due to high… - [NTSB ANC84LA077](https://openairdocs.org/ntsb/ANC84LA077.md): Piper PA-12 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · May 27, 1984 · N7663H · Substantial damage > The acft nosed over during a forced landing after the engine lost power. The plt said that the engine failed due to carburetor icing. Examination of the eng revealed no mechanical failure or malfunction. - [NTSB SEA84LA118](https://openairdocs.org/ntsb/SEA84LA118.md): Varga 2150-A · Mountain Home, ID · Accident · Minor injuries · Limited investigation · Final report · May 26, 1984 · N4611V · Substantial damage > The student plt became lost on the last leg of his x-country, solo flt. He final determined that his position was over boise, ID, about 35 mi from his destination. He turned to follow railroad tracks. About 15 min later, the eng ceased operating due to fuel… - [NTSB FTW84LA245](https://openairdocs.org/ntsb/FTW84LA245.md): Piper PA-22-150 · Tallulah, LA · Accident · Minor injuries · Limited investigation · Final report · May 26, 1984 · N6958D · Destroyed > The acft caught fire shortly after takeoff and the plt landed in a wheat field. The nosewheel dug into the soft field and the acft nosed over. This acft has been the subject of recommendations on worn and deteriorated fuel lines. The pltsdescription of his… - [NTSB FTW84FA242](https://openairdocs.org/ntsb/FTW84FA242.md): Beech BE35G · Wewoka, OK · Accident · 1 fatal · Field investigation · Final report · May 26, 1984 · N215D · Destroyed > The plt was not current in IMC operations nor was the acft certified for instrument lft. After obtaining a wx briefing which forecast a chance of thunderstorms along his route, the plt departed on a x-country. En route the plt contacted Oklahoma city efas and… - [NTSB ATL84FA184](https://openairdocs.org/ntsb/ATL84FA184.md): Beech A36 · Fayette, AL · Accident · 1 fatal · Field investigation · Final report · May 26, 1984 · N1836D · Destroyed > The acft collided with the ground in a near vertical nose down attitude after being observed by witnesses to pitch down during cruise flt. This acft & plt flew earlier in the day with an instructor who had to recover control of the acft after the plt allowed… - [NTSB DEN84LA164](https://openairdocs.org/ntsb/DEN84LA164.md): Cessna 210E · Livingston, MT · Accident · No injuries · Limited investigation · Final report · May 25, 1984 · N2373F · Substantial damage > While on a visual flight plan flight the non-instrument rated plt operated his unpressurized Cessna 210 above the clouds and up to an altitude of 16500 feet MSL. The plt stated that just after passing, 'crazy peak', he encountered extreme turbulence and the… - [NTSB CHI84LA204](https://openairdocs.org/ntsb/CHI84LA204.md): Cessna 210L · Middleton, WI · Accident · Minor injuries · Limited investigation · Final report · May 25, 1984 · N93009 · Substantial damage > Pwr loss experienced during normal cruise flt. Plt received vector to nearest airport. There was no evidence of attempt to regain power. On approach to airport, plt extended lndg gear. Resultant drag factor increased glide angle to extent plt felt clearance… - [NTSB MIA84FA169](https://openairdocs.org/ntsb/MIA84FA169.md): Cessna 152 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Field investigation · Final report · May 22, 1984 · N68760 · Destroyed > The student was on the 3rd leg of a solo, x-country flt. On the 2nd leg, he asked for a df steer to reach the arpt. During lunch, he discussed the situation with his instructor, who was at the arpt with another student. The solo student departed at 1455 EDT,… - [NTSB NYC84FA178](https://openairdocs.org/ntsb/NYC84FA178.md): Cessna 210E · Glen Burnie, MD · Accident · 1 fatal · Field investigation · Final report · May 21, 1984 · N432MD · Destroyed > Before the flt, the plt was observed performing maintenance in the eng compartment. He was known to do some of his own maintenance which included stopping an oil gasket leak by using a sealer. While climbing after takeoff, he turned back to the departure… - [NTSB MKC84LA142](https://openairdocs.org/ntsb/MKC84LA142.md): Piper PA-28R-201T · North Platte, NE · Accident · No injuries · Limited investigation · Final report · May 21, 1984 · N8250H · Substantial damage > While in cruise flt the plt noticed a loss of electrical power. A diversion was made to North Platte, NE, where the plt hoped to have the electrical problem fixed. Numerous attempts were made to lower the landing gear but to no avail and a gear up landing… - [NTSB ANC84FA072](https://openairdocs.org/ntsb/ANC84FA072.md): Piper PA-28-235 · Egegik, AK · Accident · No injuries · Field investigation · Final report · May 21, 1984 · N8767W · Destroyed > The acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off… - [NTSB SEA84FA111](https://openairdocs.org/ntsb/SEA84FA111.md): Stinson 108-3 · Portland, OR · Accident · 4 fatal · Field investigation · Final report · May 20, 1984 · N20Q · Destroyed > The plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they… - [NTSB FTW84FA237](https://openairdocs.org/ntsb/FTW84FA237.md): Beech G35 · Tulsa, OK · Accident · 1 fatal · Field investigation · Final report · May 20, 1984 · N4239D · Destroyed > A witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static… - [NTSB ATL84LA176](https://openairdocs.org/ntsb/ATL84LA176.md): Cessna 172N · Leeds, AL · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N734ZP · Substantial damage > The plt made a flt of about 30 min to practice landings, then landed to pick up 2 passengers. About 10 min after taking off on the 2nd flt, he began having symptoms of a medical problem. He said he felt hot & the air felt stagnant & stale. The vents & a… - [NTSB LAX84LA308](https://openairdocs.org/ntsb/LAX84LA308.md): Cessna 150 · Kernville, CA · Accident · Minor injuries · Limited investigation · Final report · May 19, 1984 · N63357 · Destroyed > After takeoff, the plt took a direct route (heading 150 deg) & began climbing to 7500 ft to cross over a 6300 ft pass. He encountered strong winds from the northeast & stated that he 'experienced severe downdrafts caused by mountain waves.' The plt initiated… - [NTSB ATL84LA175](https://openairdocs.org/ntsb/ATL84LA175.md): Piper PA-18-150 · Franklin, NC · Accident · No injuries · Limited investigation · Final report · May 19, 1984 · N2396J · Substantial damage > During flt, the eng lost power. The plt chose a small clearing for a forced landing, but just before touching down, the acft contacted an aluminum roofed shed & an electrical wire, then crash landed. An exam of the acft revealed no preimpact mechanical… - [NTSB DEN84LA153](https://openairdocs.org/ntsb/DEN84LA153.md): Grumman G-164A · Wiggins, CO · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N9822 · Substantial damage > While en route to a field for aerial application, an oil mist appeared on the windshield of the acft. Shortly after that, the eng progressively lost power & the plt made a forced landing in a pasture. During the landing roll, the acft hit a hole in the ground… - [NTSB LAX84LA296](https://openairdocs.org/ntsb/LAX84LA296.md): Ginn Thorp T-18 · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · May 17, 1984 · N11HG · Substantial damage > The acft lost power and nosed over during a forced landing on desert terrain. An inspection of the engine showed that the automotive type filter had disintegrated and had been ingested in the carburetor. The filter was 4 years old. After the filter was… - [NTSB CHI84IA196](https://openairdocs.org/ntsb/CHI84IA196.md): McDonnell Douglas DC-10-40 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · May 17, 1984 · N150US · Minor damage > During climb from FL330 to FL370 the 1st officer saw sparks and smoke coming from the left side panel under his glare shield. Cockpit lights were turned off and smoke stopped. Flt returned to Minneapolis and landed without incident. Inspection of the acft… - [NTSB ATL84FA173](https://openairdocs.org/ntsb/ATL84FA173.md): Boeing 727 · Covington, KY · Accident · Serious injuries · Field investigation · Final report · May 17, 1984 · N723RW · No damage > After leveling at FL330, the #2 eng fire warning light & bell activated. The crew followed the published procedures, shut down the eng & used a fire bottle. They then diverted to cincinnati & made a precautionary landing. After landing, fire dept personnel… - [NTSB FTW84LA234](https://openairdocs.org/ntsb/FTW84LA234.md): Canadair CL-600 · Clarksville, TX · Accident · Serious injuries · Limited investigation · Final report · May 16, 1984 · N215RL · Minor damage > Cruising at FL350, N215RL encountered wake turbulance from a descending 'heavy' Boeing 767. The resultant upset caused an uncontrolled loss of 11,000 ft in 10 to 15 seconds before the crew was able to recover. The acft was not damaged but an unrestrained pax… - [NTSB ANC84LA071](https://openairdocs.org/ntsb/ANC84LA071.md): Bell 206L-1 · Mt Mckinley Vil, AK · Accident · No injuries · Limited investigation · Final report · May 16, 1984 · N1078N · Substantial damage > The helicopter experienced an engine failure while cruising at about 600 ft AGL. The pilot made a forced landing during which the main rotor blades collided with trees. Examination of the aircraft fuel system revealed that the check valves located in the fuel… - [NTSB SEA84LA108](https://openairdocs.org/ntsb/SEA84LA108.md): Cessna 182P · Douglas Island, AK · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N13193 · Destroyed > The plt reported a complete loss of power with oil visible on the left side of the windscreen. The plt was unable to glide to land and the acft was ditched in deep water about 100 yds from shore. The acft was not recovered. - [NTSB CHI84IA197](https://openairdocs.org/ntsb/CHI84IA197.md): de Havilland DHC-7-102 · Battle Creek, MI · Incident · No injuries · Incident investigation · Final report · May 15, 1984 · N708ZW · No damage > While cruising at 7000 ft MSL, the 1st officer was trimming the rudder, using the rotary switch on the center console, when he felt a 'snap' inside the switch. After that, the switch would rotate freely between the stops. The acft began yawing left & right… - [NTSB CHI84FA194](https://openairdocs.org/ntsb/CHI84FA194.md): Beech A36 · Schaumburg, IL · Accident · Minor injuries · Field investigation · Final report · May 15, 1984 · N9451Q · Substantial damage > The plt reported that he lost partial engine power during climb and decided to return to the arpt. He said the engine changed power output when he used the electric fuel pump but he left it off. During final approach, not having declared an emergency, he had… - [NTSB ANC84LA069](https://openairdocs.org/ntsb/ANC84LA069.md): Stinson 108-3 · Soldotna, AK · Accident · Serious injuries · Limited investigation · Final report · May 15, 1984 · N6807M · Substantial damage > The acft was established in normal cruise when the engine quit. The pilot attempted restarts with negative results. The acft made a forced landing and collided with trees. Post accident examination revealed water in the fuel tanks & lines. - [NTSB CHI84LA186](https://openairdocs.org/ntsb/CHI84LA186.md): Hughes 500D · Rensselaer, IN · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N8352F · Substantial damage > Hard forced landing made after loss of pwr at cruise alt of 500 ft AGL. Main rotor blades contacted tail boom. Examination disclosed fuel pump gears showed signs of corrosion. Gear teeth and end faces were severly etched and pitted. Bronze particles were… - [NTSB ANC84FA067](https://openairdocs.org/ntsb/ANC84FA067.md): Bell 206B · Palmer, AK · Accident · No injuries · Field investigation · Final report · May 13, 1984 · N90191 · Substantial damage > The helicopter was being used to re-supply fire fighters by the division of forestry. En route back to the staging area the acft struck unmarked lines 85 ft above the valley floor. Poles supporting the lines were obscured by vegetation and were 224 ft apart.… - [NTSB DEN84LA150](https://openairdocs.org/ntsb/DEN84LA150.md): Cessna 182M · Nucla, CO · Accident · Serious injuries · Limited investigation · Final report · May 12, 1984 · N71429 · Substantial damage > Plt stated, 'I made one pass on low boundry spreading 100% of seed and began a climbing left turn to make a pass from high side down east boundry. I reached altitude of approximately 300 ft AGL (above ground level) and attempted to pass over telephone draw… - [NTSB FTW84LA226](https://openairdocs.org/ntsb/FTW84LA226.md): Hiller UH-12E · Cedar Hill, TX · Accident · Minor injuries · Limited investigation · Final report · May 11, 1984 · N46RJ · Destroyed > During the initial night flight after an oil change & annual inspection, the helicopter experienced a total power plant failure. An autorotation was performed & the helicopter struck a building prior to coming to rest. Inspection of the wreckage revealed… - [NTSB ATL84FA169](https://openairdocs.org/ntsb/ATL84FA169.md): Cessna 310R · Clarkson, KY · Accident · 2 fatal · Field investigation · Final report · May 11, 1984 · N5253J · Destroyed > The acft crashed after an in-flt separation of various components of the airframe. Post accident evidence provided by the failed parts gave a graphic picture of the in-flt seq which was supplemented by a witness who saw & heard the acft in its final dive.… - [NTSB ANC84FA065](https://openairdocs.org/ntsb/ANC84FA065.md): Cessna TP206D · Homer, AK · Accident · No injuries · Field investigation · Final report · May 11, 1984 · N346RN · Substantial damage > The eng quite once, but the plt was able to restart it by turning on the boost pump. He landed at 2 different arpts after the initial failure, once to refuel & drain the fuel tanks & once to check the fuel lines & components under the cowling. Aprx 1 hr after… - [NTSB MKC84LA135](https://openairdocs.org/ntsb/MKC84LA135.md): Gulfstream American AA5A · Pleasant Hill, MO · Accident · Minor injuries · Limited investigation · Final report · May 9, 1984 · N26320 · Substantial damage > The acft nosed over during a forced landing after the engine failed. Investigation revealed an exhaust valve had failed and imbedded itself in a spark plug hole. It was determined that this was a fatigue failure. - [NTSB LAX84LA285](https://openairdocs.org/ntsb/LAX84LA285.md): Navion A · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · May 9, 1984 · N212L · Substantial damage > The pilot reported a gradual loss of power leading to complete engine failure. A forced landing was accomplished in a city street, with damage to the wing at collision with a street sign. Although the aircraft was serviced with automotive gasoline, the engine… - [NTSB FTW84FU006](https://openairdocs.org/ntsb/FTW84FU006.md): Mitchell T-10R263 · Horizon City, TX · Accident · 2 fatal · Final report · May 9, 1984 · UNREG · Destroyed > The ultralight departed west Texas arpt at about 1700 MDT for a local instructional flt with 2 persons on board. It was last seen flying at about 1800 MDT a short distance west of the arpt. When it did not return at 2100 MDT, the arpt manager notified the… - [NTSB MKC84LA134](https://openairdocs.org/ntsb/MKC84LA134.md): Beech BE23 · Richmond, KS · Accident · No injuries · Limited investigation · Final report · May 8, 1984 · N6112N · Substantial damage > While in cruise on a ferry flight the engine lost power and would only develop partial power. The power degraded to the point that insuficient power was available to maintain flight. The pilot landed in a field and substantial damage occured. Post accident… - [NTSB LAX84FA283](https://openairdocs.org/ntsb/LAX84FA283.md): Piper PA-22 · West Covina, CA · Accident · No injuries · Field investigation · Final report · May 7, 1984 · N9718D · Destroyed > While returning to the arpt & towing a banner, smoke entered the cockpit & a small fire began buring, forward of the left/lower part of the firewall. The plt turned the acft to land in a field. He opened the right cabing door, all air vents & the window on… - [NTSB ATL84FA164](https://openairdocs.org/ntsb/ATL84FA164.md): Bellanca 17-30A · Painter, VA · Accident · Serious injuries · Field investigation · Final report · May 7, 1984 · N11JJ · Destroyed > After encountering low ceilings, the plt attempted a precautionary ldg. Upon realizing lights from the ground were on a house, a go-around was initiated with a climbing left turn. The acft then flew into trees one fourth to one half mile from the house. - [NTSB MKC84FA281](https://openairdocs.org/ntsb/MKC84FA281.md): Mooney M20C · New Blaine, AR · Accident · 1 fatal · Field investigation · Final report · May 6, 1984 · N9322V · Destroyed > Despite a wx briefing forecasting IMC and discouraging VFR flight, the non-instrument rated plt departed aprx 1 hour before the accident. Impact occurred in wooded rising terrain at an elevation of about 1,957 ft MSL at an aprx nose down attitude of 4 degs.… - [NTSB NYC84LA152](https://openairdocs.org/ntsb/NYC84LA152.md): Cessna 337D · New Paltz, NY · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N86094 · Substantial damage > About 5 mins after departing the arpt, the front eng began to gradually lose power. The plt turned back toward the arpt & adjusted the fuel selector to various settings. The front eng continued to lose power and the rear eng began losing power. Subsequently,… - [NTSB MKC84LA132](https://openairdocs.org/ntsb/MKC84LA132.md): Cessna 175 · Imperial, NE · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N7261M · Destroyed > While en route, the plt tried to circumnavigate an area of bad wx. He was in & out of rain & finally decided to reverse course. He said he inadvertently flew into a thunderstorm & lost control of the acft due to turbulence. The acft entered a steep dive, &… - [NTSB MKC84FA131](https://openairdocs.org/ntsb/MKC84FA131.md): Piper PA-28-180 · Sheldon, IA · Accident · 2 fatal · Field investigation · Final report · May 4, 1984 · N3761R · Destroyed > At about 1015 CDT, while en route, the plt radioed a fss & requested the Kansas city wx. VMC conditions were reported at Kansas city, but the plt was informed of an AIRMET, which provide a caution of low ceilings & reduce visibilities across his route of flt.… - [NTSB MIA84IA160](https://openairdocs.org/ntsb/MIA84IA160.md): Embraer EMB-110P1 · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 4, 1984 · N132EM · Minor damage > The plt reported that during a descending turn at aprx 8000 ft & 200 KTS, the acft encountered turbulence & a lateral gust. He stated that this caused the acft to roll into about a 70 deg bank. He initiated a recovery, but the acft had gotten in a 20 deg nose… - [NTSB DEN84FA143](https://openairdocs.org/ntsb/DEN84FA143.md): Cessna T210N · Farmington, NM · Accident · 1 fatal · Field investigation · Final report · May 4, 1984 · N4774U · Substantial damage > Fuel exhaustion occurred in normal cruise flt after plt determined consumption precluded reaching destination and requested emergency straight-in to nearest airport. Forced landing executed on highway, wing struck a parked, occupied vehicle. Plt accustomed to… - [NTSB ATL84IA160](https://openairdocs.org/ntsb/ATL84IA160.md): Douglas DC-9-32 · Mount Vernon, IL · Incident · No injuries · Incident investigation · Final report · May 4, 1984 · N923L · No damage > Kansas city ARTCC (zkc) had cleared ozark flt 709 (a DC-9, N923L) to cruise at FL270. While proceeding ese near the edgeof the zkc area, the DC-9 converged on zorro 11 (a flt of 3 F-4'S). The F-4'S had been cleared by indianaplolis ARTCC (zid) to proceed… - [NTSB ATL84FA158](https://openairdocs.org/ntsb/ATL84FA158.md): Bell 206B · Trammel, VA · Accident · Serious injuries · Field investigation · Final report · May 3, 1984 · N99LC · Destroyed > The acft collided with static wires attached to an electrical transmission line while cruising at low alt, crashed and burned near hwy 63. The plt was thrown from the acft before it burned. The plt said he never saw the wire he hit. He had been employed as a… - [NTSB FTW84LA217](https://openairdocs.org/ntsb/FTW84LA217.md): Hughes 500D · New Braunfels, TX · Accident · No injuries · Limited investigation · Final report · May 2, 1984 · N5063G · Substantial damage > Despite adverse wx which forced the plt to stop once enroute to his dest the flt was continued. Directional control was lost when the tail rotor contacted the terrain separating both tail rotor blades from the acft and torsionally shearing the tail rotor… - [NTSB SEA84LA100](https://openairdocs.org/ntsb/SEA84LA100.md): Cessna T210L · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · May 1, 1984 · N93186 · Substantial damage > According to the plt's calculations, the acft should have had enough fuel on board for 8.4 hrs of flt. However, after about 5.6 hrs of flt time, the eng lost power from fuel exhaustion. The acft was damaged during a wheels-up landing. The plt said that the… - [NTSB FTW84FA216](https://openairdocs.org/ntsb/FTW84FA216.md): Sikorsky S-76A · High Isl Blk595 · Accident · No injuries · Field investigation · Final report · May 1, 1984 · N763AL · Substantial damage > During cruise flight at 500 ft over gulf waters, the left engine sustained a massive, uncontained, explosive failure. Sharpnel penetrated the right engine, which failed from damage. Sharpnel also penetrated the ac and DC junction boxes, causing complete… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=355 ## 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=354 --- 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.