# 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 328 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC86LA088](https://openairdocs.org/ntsb/NYC86LA088.md): Piper PA-28-140 · Springvale, ME · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N4211T · Substantial damage > The Piper cherokee PA-28-140 lost power and made an off airport landing 15 minutes after takeoff. The pilot reported an oil line broke and he lost all engine oil. A mechanic reported that there was no indication in either the engine compartment or the bottom… - [NTSB NYC86LA086](https://openairdocs.org/ntsb/NYC86LA086.md): Taylorcraft BC12-D · Tioga, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1986 · N43529 · Substantial damage > The pilot decided to make an off airport landing after becoming confused as to his exact location. During the landing a wind from the right caught the aircraft and it drifted left into trees. The pilot stated he had VFR sectional charts with him at the time… - [NTSB LAX86MA151](https://openairdocs.org/ntsb/LAX86MA151.md): Boeing 727-231 · Cincinnati, OH · Incident · No injuries · Major investigation · Final report · Mar 22, 1986 · N64315 · 2 aircraft · No damage > Indianapolis ctr (ctlr-a) clrd sluff 11 (S-11), a flt of 4 ANG A-7'S, to clb to FL210. Later, ctlr-a told S-11 to chg freq (to york low sector, ctlr-b). S-11 chgd freq, but neither S-11 nor ctlr-b established rdo contact with each other until S-11 had contd… - [NTSB SEA86LA081](https://openairdocs.org/ntsb/SEA86LA081.md): Air Tractor 301 · Prescott, WA · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N5097S · Substantial damage > The brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine. - [NTSB ATL86IA100](https://openairdocs.org/ntsb/ATL86IA100.md): Boeing 737-200 · Nasville, TN · Incident · No injuries · Incident investigation · Final report · Mar 21, 1986 · N774N · 2 aircraft · No damage > A nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had… - [NTSB MIA86LA099](https://openairdocs.org/ntsb/MIA86LA099.md): Piper PA-23-250 · Ft. Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1986 · N4599P · Substantial damage > The plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.… - [NTSB SEA86IA080](https://openairdocs.org/ntsb/SEA86IA080.md): Piper PA-46-310P · Reno, NV · Incident · No injuries · Incident investigation · Final report · Mar 18, 1986 · N4360V · No damage > At FL250 the engine ceased operating due to a failed fuel pump. A restart was successful at 10,000 feet m.s.l. with an uneventful landing. This fuel pump (a model g) had a total time of three hours. It was a replacement for a model c fuel pump which had… - [NTSB ATL86LA099](https://openairdocs.org/ntsb/ATL86LA099.md): Piper PA-28R-180 · Crossville, TN · Accident · No injuries · Limited investigation · Final report · Mar 18, 1986 · N7613J · Substantial damage > On takeoff the plt saw an oil leak around the prop hub. The acft was returned to the airport and the prop governor oil tube fitting was found to be cracked. The part was replaced and the flt was continued. The part was checked during a later refueling stop… - [NTSB SEA86LA079](https://openairdocs.org/ntsb/SEA86LA079.md): Bell 47G-3B-1 · Overton, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1986 · N3067G · Substantial damage > The noncertificated plt rprtd that he had repaired the helicopter, then proceeded to make a local test flt. He rprtd that he took off in darkness after having a few beers. The plt chose to turn off the landing light shortly after takeoff. While at low… - [NTSB LAX86LA142](https://openairdocs.org/ntsb/LAX86LA142.md): Hiller 12E · Poterville, CA · Accident · No injuries · Limited investigation · Final report · Mar 16, 1986 · N90475 · Substantial damage > A Hiller 12E helicopter landed hard after an eng failure. The acft was enroute to another field site at aprx 100 ft AGL and 40 KTS IAS. The eng quit abruptly and the rotor RPM decayed 100 RPM. The acft was about 2,000 pounds gwt at the time of the accident… - [NTSB MIA86FA097](https://openairdocs.org/ntsb/MIA86FA097.md): Mcfarland Quickie 2 · Mulberry, FL · Accident · 2 fatal · Field investigation · Final report · Mar 15, 1986 · N335RM · Destroyed > Witnesses reported that the acft was flying at a lower than normal altitude and at full throttle when something broke off the acft. The acft then rolled to the right, went almost straight up and spiraled down striking the ground inverted. Post crash… - [NTSB LAX86FA140](https://openairdocs.org/ntsb/LAX86FA140.md): Beech A36TC · Woodfords, CA · Accident · 3 fatal · Field investigation · Final report · Mar 15, 1986 · N333AU · Destroyed > The wx deteriorated while the acft was cruising in IMC at 17,000 ft. moderate turbulence & icing conditions in the layered clouds were reported by other nearby flying acft. The plt informed ARTCC that he 'lost the autopilot,' & the acft's course began… - [NTSB ATL86LA094](https://openairdocs.org/ntsb/ATL86LA094.md): Shaffer KR-2 · Mobile, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 15, 1986 · N455JS · Substantial damage > The pilot lost control of the aircraft during cruise flight while attempting to close the cockpit canopy which inadvertently unlatched. The aircraft entered a spin and the pilot was unable to recover prior to ground impact. The aircraft was an experimental… - [NTSB ATL86IA098](https://openairdocs.org/ntsb/ATL86IA098.md): Cessna 404 · Mc Rae, GA · Incident · No injuries · Incident investigation · Final report · Mar 15, 1986 · N408EX · No damage > During cruise flight pilot heard loud bang from right engine and right propeller feathered. Aircraft was diverted and landed with no further damage and no injuries to the pilot. Subsequent teardown of engine revealed fractured connecting rod. Examination of… - [NTSB LAX86LA139](https://openairdocs.org/ntsb/LAX86LA139.md): Cessna A150K · Hanakuli, HI · Accident · No injuries · Limited investigation · Final report · Mar 13, 1986 · N8467M · Destroyed > The acft was ditched in pacific ocean after the eng quit. Recovered inboard portion of left wing showed gas tank cap missing. The ditching occurred 1 mile from shore and the occupants were picked up unharmed after 20 minutes in the water. The plt said the eng… - [NTSB NYC86LA083](https://openairdocs.org/ntsb/NYC86LA083.md): Cessna T210N · White Plains, NY · Accident · No injuries · Limited investigation · Final report · Mar 12, 1986 · N5217C · Substantial damage > During the flight the plt noted a full discharge on the ammeter and a open alternator circuit breaker after ATC reported loss of transpx signal. The circuit breaker would not reset. The low voltage light did not come on. He diverted the flight to White Plains… - [NTSB BFO86FA020](https://openairdocs.org/ntsb/BFO86FA020.md): Cessna 172H · Upper Marlboro, MD · Accident · No injuries · Field investigation · Final report · Mar 12, 1986 · N2780L · Substantial damage > Since the fuel gages in the acft were known not to be accurate, the plt measured the amount of fuel in each tank with a dipstick before departing. He determined that he had 18 gallons for the 2 hours of flying he planned to do and based on a fuel consumption… - [NTSB ATL86LA090](https://openairdocs.org/ntsb/ATL86LA090.md): Boeing 727-223 · Memphis, TN · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1986 · N877AA · No damage > American airlines flight 502 experienced a fire warning light illumination on no. 1 engine as the aircraft was climbing through 6000 feet. The pilot declared an emergency and returned to Memphis. Following the landing the pilot ordered a passenger emergency… - [NTSB FTW86FRG17](https://openairdocs.org/ntsb/FTW86FRG17.md): Cessna T210 · Ozona, TX · Accident · Minor injuries · Final report · Mar 11, 1986 · N6479Y · Substantial damage > The acft was damaged in an off-arpt lndg after the eng quit. The plt said there was plenty of fuel on board the acft which was being ferried to its owner after an eng change. The plt was unable to restart the eng which had vibrated so that the plt thought he… - [NTSB FTW86FRD10](https://openairdocs.org/ntsb/FTW86FRD10.md): Piper PA-28-140 · Krotz Springs, LA · Accident · Minor injuries · Final report · Mar 11, 1986 · N40820 · Substantial damage > The acft crashed into a road sign during a forced landing on a hiway following fuel exhaustion. The plt had made a x-country flt and only added ten gals of fuel for the return trip. His estimate of fuel remaining was inaccurate partly because the carburetor… - [NTSB DEN86FA098](https://openairdocs.org/ntsb/DEN86FA098.md): Piper PA-24-250 · Truth&Consequen, NM · Accident · 1 fatal · Field investigation · Final report · Mar 11, 1986 · N7410P · Destroyed > The plt took off on a night IFR flt after being briefed on adverse wx which included severe turbulence and moderate mixed icing conditions. The acft was not equipped for flt in icing conditions. Radio and radar contact with the flt was lost in the vicinity of… - [NTSB ATL86LA089](https://openairdocs.org/ntsb/ATL86LA089.md): Piper PA-28R-200 · Hanceville, AL · Accident · No injuries · Limited investigation · Final report · Mar 11, 1986 · N74HB · Substantial damage > While enroute to birmingham the pilot experienced a complete power failure when no. 2 cylinder separated from the engine assembly. The pilot attempted to make an emergency landing on interstate 65 near Hanceville, AL, and the aircraftcollided with an… - [NTSB LAX86LA137](https://openairdocs.org/ntsb/LAX86LA137.md): Mooney M-20C · Roll, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 1986 · N9694M · Substantial damage > The plt landed at gila bend municipal arpt for fuel. The refueling facilities were closed and the decision was made to proceed to yuma int'l arpt, about 113 miles east of gila bend arpt. The plt had flown the acft for about 4 hrs and 5 minutes prior to… - [NTSB ANC86LA034](https://openairdocs.org/ntsb/ANC86LA034.md): Bell 206B3 · Livengood, AK · Accident · No injuries · Limited investigation · Final report · Mar 10, 1986 · N9AT · Substantial damage > Helicopter experienced power loss while flying low level pipeline patrol, resulting in a hard landing and substantial damage to the acft. The governing pressure (pg) air line fitting was found loose on the power turbine fuel governor. - [NTSB ANC86IA033](https://openairdocs.org/ntsb/ANC86IA033.md): Cessna 207 · Barrow, AK · Incident · No injuries · Incident investigation · Final report · Mar 10, 1986 · N9943M · Minor damage > Engine failed and seized in flight. A forced landing and the snow covered tundra followed with no injuries & minor damage to the airplane. Engine teardown and exam revealed #3 cylinder wrist pin broken. - [NTSB FTW86LRD09](https://openairdocs.org/ntsb/FTW86LRD09.md): Piper PA-22-150 · Sulphur, LA · Accident · No injuries · Final report · Mar 9, 1986 · N3821P · Substantial damage > On March 9, 1986, at 0900 CST, Piper aircraft PA22-150, N3821P, registered to derrick d. smith, experienced a power failure due to fuel exhaustion. This was a pleasure flight in visual meteorological conditions. No flight plan was filed. The aircraft was… - [NTSB CHI86LA101](https://openairdocs.org/ntsb/CHI86LA101.md): Cessna 152 · Carmel, IN · Accident · No injuries · Limited investigation · Final report · Mar 9, 1986 · N93989 · Substantial damage > The student plt was on a x-country flt. He took off from an en route arpt with aprx 12 gal of fuel on board & was returning to his home base. Due to high winds at the destination arpt, the student diverted to an alternate arpt. While en route, the acft ran… - [NTSB BFO86FA018](https://openairdocs.org/ntsb/BFO86FA018.md): Hughes 500D · Mt. Crawford, VA · Accident · Serious injuries · Field investigation · Final report · Mar 9, 1986 · N8352F · Substantial damage > After refueling at shenandoah valley airport located near staunton, Virginia, the helicopter climbed to about 1800 feet MSL on a north heading. Approximately 15 minutes after departure a loud rumble was heard coming from the rear of the aircraft and the pilot… - [NTSB LAX86LA136](https://openairdocs.org/ntsb/LAX86LA136.md): Cessna 177B · Tehachapi, CA · Accident · No injuries · Limited investigation · Final report · Mar 7, 1986 · N18174 · Substantial damage > After determining the takeoff wt of the acft would be over the max gross, the plt asked the operator the day before the accident to drain 20 gals of fuel from the tanks.a plt who flew the acft prior to the accident flt said he flew for about one hour and did… - [NTSB DEN86FA092](https://openairdocs.org/ntsb/DEN86FA092.md): Cessna 177 · Anaconda, MT · Accident · 3 fatal · Field investigation · Final report · Mar 6, 1986 · N3476T · Destroyed > The sole surviving pax said the eng lost power during cruise flight over mountainous terrain. The plt attempted a forced landing but hit a tree and the acft crashed. Aprx 5 gals of automotive fuel were drained from wing tank. Fuel sample taken from plt's… - [NTSB LAX86LA134](https://openairdocs.org/ntsb/LAX86LA134.md): Burkhart Grob 102 · Tehachapi, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1986 · N102JC · Substantial damage > Grob 102 glider collided with trees 6 mi s of the apt. The plt was soaring 2 mi s of the apt at 5900 ft MSL and 6200 ft MSL in 'weak lift.' He elected to fly further s in the vic of a ridgeline with an elev approx 6000 ft MSL. Again the plt experienced 'weak… - [NTSB CHI86FA098](https://openairdocs.org/ntsb/CHI86FA098.md): Mitsubishi MU-2B-60 · Eola, IL · Accident · 5 fatal · Field investigation · Final report · Mar 5, 1986 · N513DC · Destroyed > Evidence shows co-pilot called, 'mayday, uncontrolled spin' after acft radar track showed decel from 180 to 120 KTS over 2 min period while maintaining constant 4000 ft crz alt. Constant alt consistent with autopilot/autotrim use, particularly in view of… - [NTSB SEA86FA071](https://openairdocs.org/ntsb/SEA86FA071.md): Cessna 182P · Tenino, WA · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1986 · N182FW · Destroyed > The non-instrument rated pilot departed for his destination without filing a flight plan nor obtaining a weather briefing. The flight was conducted in dark night and instrument meteorological conditions. Low ceilings prevailed in the vicinity of the accident.… - [NTSB CHI86FA096](https://openairdocs.org/ntsb/CHI86FA096.md): Boeing 747-122 · Honolulu, HI · Accident · Serious injuries · Field investigation · Final report · Mar 4, 1986 · N4729U · No damage > The scheduled passenger flight from Honolulu to chicago encountered clear air turbulence (cat) about 500 NM east of Honolulu while in cruise flight at flight level 330. The turbulence was unexpected, had not been forecast, and the fasten seat belt was not… - [NTSB MIA86FA091](https://openairdocs.org/ntsb/MIA86FA091.md): Swanningson Quickie · Deland, FL · Accident · 1 fatal · Field investigation · Final report · Mar 3, 1986 · N41Q · Destroyed > The acft was observed to takeoff & climb to about 300 ft, then roll to the left & descend to ground impact in an aprx 60 deg bank angle. The plt had stated that he was not feeling well just prior to departure, a witness stated that the plt had made several… - [NTSB LAX86FVD05](https://openairdocs.org/ntsb/LAX86FVD05.md): Cessna 182C · Oakland, CA · Accident · Serious injuries · Final report · Mar 3, 1986 · N9047T · Substantial damage > The acft contacted several vehicles during a forced landing following a loss of pwr shortly after takeoff. Post accident inspection of the acft revealed the carburetor bowl was 1/3 full of water. No other discrepancies were noted which would have resulted in… - [NTSB DEN86LA089](https://openairdocs.org/ntsb/DEN86LA089.md): Cessna 172F · Ephraim, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1986 · N7879U · Substantial damage > According to the plt, upon his arrival at the dest arpt, he could not activate the rwy lghts by radio, so he proceeded to the nearest arpt. He stated he could not find his alternate arpt beacon light, so he reversed direction and headed once more to his… - [NTSB SEA86LA069](https://openairdocs.org/ntsb/SEA86LA069.md): Cessna 172 · Concrete, WA · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N734LQ · Substantial damage > The pilot was flying only 50 feet AGL when the aircraft struck power lines. A successful landing was then accomplished at an airport. - [NTSB MIA86LA089](https://openairdocs.org/ntsb/MIA86LA089.md): Cessna 172G · New Smyrna, FL · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N3870L · Substantial damage > The flt had been cruising on the right fuel tank. During the descent, carb heat and rich mixture was selected. The eng quit and the plt selected both fuel tanks. Eng pwr was restored briefly during the descent, but not enough to sustain flt. A forced landing… - [NTSB CHI86IA099](https://openairdocs.org/ntsb/CHI86IA099.md): Douglas DC-10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 2, 1986 · N138AA · No damage > The flight engineer became incapacitated while enroute from frankfort, germany to Chicago, Illinois. Paramedics met the flight upon arrival at Chicago and the flight engineer was taken to a nearby hospital. The flight engineer died two days later without ever… - [NTSB BFO86LA017](https://openairdocs.org/ntsb/BFO86LA017.md): Piper PA-28-161 · Elkton, MD · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N8167R · Substantial damage > The acft experienced a loss of pwr during cruise. The student plt reported that carb heat was applied after the initial pwr loss without any change in RPM. He subsequently applied full throttle, but the acft was unable to maintain altitude and a forced ldg… - [NTSB LAX86LA132](https://openairdocs.org/ntsb/LAX86LA132.md): Aeronca 11-AC · Standfield, AZ · Accident · No injuries · Limited investigation · Final report · Mar 1, 1986 · N3236E · Substantial damage > An Aeronca chief collided with a telephone pole on landing roll on a dirt road after a forced landing due to fuel exhaustion. The pilot reported that he was delayed approximately 45 minutes awaiting takeoff clearance by ground control with the engine running.… - [NTSB FTW86LRG15](https://openairdocs.org/ntsb/FTW86LRG15.md): Balloon Works 8B · Round Rock, TX · Accident · Minor injuries · Final report · Mar 1, 1986 · N74176 · Substantial damage > The Balloon was damaged during landing in a wind of 15 KTS gusting to 40 KTS. The plt said that the surface wind increased during the flt. The Balloon was blown about 900 yds while dragging the basket across a grass field during the landing. - [NTSB BFO86FA016](https://openairdocs.org/ntsb/BFO86FA016.md): Cessna 182R · Manassas, VA · Accident · Minor injuries · Field investigation · Final report · Mar 1, 1986 · N9962H · Destroyed > Witnesses observed black smoke trailing from the aircraft shortly after liftoff and continue until ground impact. The pilot indicated that he first noticed an engine roughness about 100-200 feet in the air and thought it was similar to an engine that was… - [NTSB NYC86LA081](https://openairdocs.org/ntsb/NYC86LA081.md): Dassault DA-10 · Coatsville, PA · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 1986 · N821LG · Substantial damage > As the acft was climbing thru 19,000' at ngt, the #2 generator (gen) lgt came on. The flt crew noted there was no outputfm the #2 gen & it would not reset. They then checked the #1 gen voltage & noted it was 14 to 15 volts. The crew reducedthe elec load;… - [NTSB MIA86LA087](https://openairdocs.org/ntsb/MIA86LA087.md): Gulfstream 500S · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Feb 28, 1986 · 6YJHV · Substantial damage > The plt stated that upon departure from Opa Locka, FL he had a problem when he retracted the landing gear. Upon returning to the arpt, the gear would not extend so he elected to land with the gear up along side of rwy 36. The acft was placed on jacks after… - [NTSB MIA86LA086](https://openairdocs.org/ntsb/MIA86LA086.md): Cessna 337A · Key Biscayne, FL · Accident · No injuries · Limited investigation · Final report · Feb 28, 1986 · N5394S · Substantial damage > The acft had been flown for aprx 7 hrs and 15 mins during a flt from curacao, netherlands antilles. Nearing miami, both engs failed within a short time of each other and the plt performed a night ditching. The acft was not equipped with aux fuel tanks. The… - [NTSB SEA86LA067](https://openairdocs.org/ntsb/SEA86LA067.md): Gulfstream 690C · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Feb 27, 1986 · N840SM · Substantial damage > While at 4700 ft MSL, on a DME hold awaiting clearance for an ils/dme apch, severe turbulence was encountered. The plt was aware of turbulence in the area. - [NTSB LAX86LA129](https://openairdocs.org/ntsb/LAX86LA129.md): Cessna 172M · Springerville, AZ · Accident · No injuries · Limited investigation · Final report · Feb 27, 1986 · N61572 · Substantial damage > A Cessna 172M experienced a loss of power and collided with rough terrain on landing. The pilot indicated he was cruising at 9500 feet MSL (1500 to 2000 feet AGL) with an OAT of 40 degrees fahrenheit. The carb heat handle was in the 'off' position when the… - [NTSB ATL86FA082](https://openairdocs.org/ntsb/ATL86FA082.md): Beech A23 · Russellville, AL · Accident · 2 fatal · Field investigation · Final report · Feb 27, 1986 · N3536R · Substantial damage > Outboard half of one propeller blade separated during cruise flight. During the subsequent forced landing attempt the acft struck trees, severing the right wing, and crashed inverted. Front occupant seats separated from seat tracks. Examination of propeller… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=329 ## 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=328 --- 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.