# NTSB investigations: Approach 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 186 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC86LA106](https://openairdocs.org/ntsb/NYC86LA106.md): Taylorcraft BC12-D · W. Milford, NJ · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N43543 · Substantial damage > On approach to Milford airport, the flight collided with power lines and crashed. The pilot made a missed approach then on second approach collided with wires, the pilot stated that it was dark and he did not see the wires until it was too late. - [NTSB MIA86LA121](https://openairdocs.org/ntsb/MIA86LA121.md): Cessna 340 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N1707G · Substantial damage > While on a combination company business and training flight, the instructor seated in the right seat of the aircraft commanded the other pilot to execute a VFR go-around on short final. The other pilot added power to both engines and noted that the right… - [NTSB DEN86LA117](https://openairdocs.org/ntsb/DEN86LA117.md): Cessna 172H · Crossroads, NM · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N2896L · Substantial damage > According to the plt, he was attempting to underfly powerlines over a public road during landing, when the aircraft contacted an unseen wire and crashed. - [NTSB BFO86FA023](https://openairdocs.org/ntsb/BFO86FA023.md): Piper PA-28R-200 · Camp Springs, MD · Accident · Minor injuries · Field investigation · Final report · Apr 14, 1986 · N32613 · Substantial damage > During a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.… - [NTSB CHI86FA120](https://openairdocs.org/ntsb/CHI86FA120.md): Luscombe 8B · Pittsford, MI · Accident · 2 fatal · Field investigation · Final report · Apr 13, 1986 · N28914 · Destroyed > The pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft… - [NTSB SEA86LA104](https://openairdocs.org/ntsb/SEA86LA104.md): Cessna 172N · Pioche, NV · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N734JP · Substantial damage > While on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet… - [NTSB MKC86LA087](https://openairdocs.org/ntsb/MKC86LA087.md): Ercoupe 415-C · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N2578H · Substantial damage > The plt reports that a wind squall passed over the arpt as he was landing. He said the acft encountered windshear at about 100 ft AGL on final apch and began to sink. The plt added pwr but could not stop the sink and the acft landed in a plowed field about 20… - [NTSB LAX86LA173](https://openairdocs.org/ntsb/LAX86LA173.md): Cessna 182A · Death Valley, CA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N5925B · Substantial damage > The acft collided with terrain after a loss of pwr 50 yards short of the rwy. The plt stated he used various fuel selector positions while en route. Upon entry into the traffic pattern on a right downwind, the left tank was selected. On final apch the plt… - [NTSB FTW86LA064](https://openairdocs.org/ntsb/FTW86LA064.md): Taylorcraft L-2 · Graham, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1986 · N50639 · Substantial damage > Witnesses stated the aircraft stalled during a sharp right bank at approximately 150 feet. The propeller exhibited no signs of rotation at impact. The engine was dissassembled in an attempt to determine the apparent failure. No evidence of pre-impact failure… - [NTSB ATL86LA111](https://openairdocs.org/ntsb/ATL86LA111.md): Schweizer SGS 1-26A · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N2760R · Substantial damage > The pilot misread his altimeter and misjudged his altitude while in the traffic pattern for landing at the private gliderport. The glider collided with powerlines on the approach end of the runway and crashed short of the runway surface. - [NTSB CHI86FEP03](https://openairdocs.org/ntsb/CHI86FEP03.md): Steinorth Extra Long EZ · Kenosha, WI · Accident · Minor injuries · Final report · Apr 11, 1986 · N123AE · Substantial damage > During an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt… - [NTSB ATL86LA109](https://openairdocs.org/ntsb/ATL86LA109.md): Piper PA-32-300 · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Apr 11, 1986 · N4087W · Substantial damage > After takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil… - [NTSB SEA86LA099](https://openairdocs.org/ntsb/SEA86LA099.md): Morley Avid Flyer · Spokane, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 1986 · N318M · Destroyed > While on a five-mile final, a total loss of power occurred. A loose right magneto contacting the flywheel magnet and shorting the electrical system was found. In an attempt to miss a river in the approach path to the runway, the pilot attempted a 180 degree… - [NTSB LAX86LA170](https://openairdocs.org/ntsb/LAX86LA170.md): Piper PA-28-151 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N9237K · Substantial damage > The acft collided with terrain after a complete loss of pwr while on final apch. Post accident exam of the acft disclosed no fuel in either the main tanks nor in the carburetor fuel line. The plt indicated on his plt/operator accident report the right and… - [NTSB FTW86LA062](https://openairdocs.org/ntsb/FTW86LA062.md): Cessna 152 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Apr 9, 1986 · N69054 · Substantial damage > A student pilot, practicing touch and go landings, attempted a go-around. The pilot did not maintain sufficient airspeed before the aircraft stalled and collided with the runway. - [NTSB LAX86LA169](https://openairdocs.org/ntsb/LAX86LA169.md): Piper PA-28-181 · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Apr 8, 1986 · N5889V · Substantial damage > During a solo instructional flight the student plt attempted to land on a 3910-foot-long rwy which had its landing threshold displaced by 550 feet. The wind was light & variable, & the student plt was low on short final approach. The acft collided with the… - [NTSB SEA86IA095](https://openairdocs.org/ntsb/SEA86IA095.md): Raven RX-7 · Beaverton, OR · Incident · No injuries · Incident investigation · Final report · Apr 7, 1986 · N27980 · Minor damage > The pilot misjudged obstacle clearance during his descent for landing. The balloon's envelope was then impaled on a light pole. Flt time was not reported by the plt. - [NTSB MKC86FA082](https://openairdocs.org/ntsb/MKC86FA082.md): Hiller UH-12B · Fall River, KS · Accident · Serious injuries · Field investigation · Final report · Apr 7, 1986 · N5307V · Destroyed > The helicopter flew through the tops of trees next to a plowed field and impacted almost straight down in the plowed field and nosed over to the inverted position. The pilot stated that he had intended to land in the field and allowed the airspeed and main… - [NTSB DEN86LA110](https://openairdocs.org/ntsb/DEN86LA110.md): Cessna 150L · Falcon, CO · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1986 · N1580Q · Substantial damage > The plt stated the acft contacted a powerline pole during a go-around. The powerline pole is located aprx one-half mile off the departure end of rwy 33. According to the plt, the pole is unmarked and unlighted. The accident occurred during night hrs with no… - [NTSB CHI86FEM04](https://openairdocs.org/ntsb/CHI86FEM04.md): Perkins Viking Dragonfly · Lansing, MI · Accident · No injuries · Final report · Apr 6, 1986 · N192AP · Substantial damage > On his first flight in this type of homebuilt the pilot encountered what he said was windshear on final approach for his first landing. He added power and the aircraft pitched up 30 degrees. He pushed down on the stick and the aircraft pitched down violently.… - [NTSB MKC86FA080](https://openairdocs.org/ntsb/MKC86FA080.md): Cessna 150F · Hannibal, MO · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1986 · N8917S · Substantial damage > The student plt was attempting to land with a right crosswind component in excess of 15 knots. He used a crab angle on final but as the acft apch the rwy he applied rudder. He said, with full rudder the acft was still not aligned with the rwy and he decided… - [NTSB FTW86LA061](https://openairdocs.org/ntsb/FTW86LA061.md): Piper PA-28-235 · Springtown, TX · Accident · No injuries · Limited investigation · Final report · Apr 5, 1986 · N9019W · Substantial damage > The pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.… - [NTSB MIA86FA110](https://openairdocs.org/ntsb/MIA86FA110.md): Piper PA-28R-201 · Ocklawaha, FL · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1986 · N742JM · Destroyed > The pvt plt refueled his acft the night before the flt and was observed to drain only the firewall strainer. The morning of the flt he did not drain any drains. About half way to his destination an eng pwr loss was experienced, he declared an emergency and… - [NTSB SEA86LA090](https://openairdocs.org/ntsb/SEA86LA090.md): Piper PA-24-250 · Fallon, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1986 · N6282P · Destroyed > While on final apch to the arpt, the acft's eng ceased operating due to fuel exhaustion. The acft was damaged during a hard forced landing on a baseball fld. - [NTSB NYC86FA096](https://openairdocs.org/ntsb/NYC86FA096.md): Piper PA-24-180 · Somers, CT · Accident · 5 fatal · Field investigation · Final report · Mar 31, 1986 · N6599P · Destroyed > The acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the… - [NTSB ATL86FKG08](https://openairdocs.org/ntsb/ATL86FKG08.md): Joachim Hoehne Pazmany PL-4A · Canton, GA · Accident · Minor injuries · Final report · Mar 30, 1986 · N3942U · Destroyed > The acft struck a powerline wire during an attempted go-around after a bounced landing. The plt aborted the landing and turned left at low alt until impact with a wire occurred at a distance of about 300 ft left of the rwy and 1200 ft from the approach end.… - [NTSB FTW86LA053](https://openairdocs.org/ntsb/FTW86LA053.md): Cessna 172 · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N7341A · Substantial damage > The pilot stated that on approach into an unfamiliar airstrip he encountered turbulence and a tail wind. He attempted a go-around at a low altitude with full flaps. Before sufficient airspeed could be reached and flaps retracted, the aircraft collided with… - [NTSB DEN86LA107](https://openairdocs.org/ntsb/DEN86LA107.md): Rolladen-Schneider L53 · Colorado Spring, CO · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1986 · N96JH · Substantial damage > The acft was making a landing due to an approaching thunderstorm. On final, the glider encountered moderate to severe turbulence and at 300 ft AGL, the glider was forced onto the ground by a microburst. - [NTSB FTW86FA049](https://openairdocs.org/ntsb/FTW86FA049.md): Spencer Pitts S-1 · Mckinney, TX · Accident · Serious injuries · Field investigation · Final report · Mar 28, 1986 · N66D · 2 aircraft · Substantial damage > As a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts… - [NTSB SEA86LA082](https://openairdocs.org/ntsb/SEA86LA082.md): Socata MS894A · Wasco, OR · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 1986 · N54BF · Substantial damage > The plt stated that he encountered a wind shear on final. At the time of the accident the wind was recorded to be from the south/southeast at two knots with peak winds at four knots. When the plt noticed that his airspeed had deteriorated to 50 mph, he went… - [NTSB FTW86LA048](https://openairdocs.org/ntsb/FTW86LA048.md): Beech H35 · Talihina, OK · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N5531D · Substantial damage > Acft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power… - [NTSB DEN86FA103](https://openairdocs.org/ntsb/DEN86FA103.md): I.C.A. Brasov IS-28B2 · Cedar City, UT · Accident · 2 fatal · Field investigation · Final report · Mar 24, 1986 · N32907 · Substantial damage > The plt and pax were returning from a LCL flt. Two fss specialists observed the glider on final approach to rwy 20. They stated that the acft completed two 360 degree turns with 90 degrees of bank. The glider was in the third 360 degree turn when the… - [NTSB CHI86FA108](https://openairdocs.org/ntsb/CHI86FA108.md): Piper PA-46-310P · Boyne Falls, MI · Accident · 2 fatal · Field investigation · Final report · Mar 23, 1986 · N43769 · Destroyed > After the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical… - [NTSB MKC86LA073](https://openairdocs.org/ntsb/MKC86LA073.md): Piper PA-28-181 · Oil Trough, AR · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N30561 · Substantial damage > The PIC found himself low on fuel with an indication of only 5 gallons in each tank. He passed over an arpt with fueling facilities available but diverted to batesville, Arkansas, which lay 48 miles beyond his present posn. The PIC stated that he attempted a… - [NTSB MKC86LA071](https://openairdocs.org/ntsb/MKC86LA071.md): Piper PA-28-151 · Neosho, MO · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N1017X · Substantial damage > The pilot stated that he had descended from 5500 feet MSL to 2000 feet MSL with the throttle at idle and without using carburetor heat. When he advanced the throttle, the engine did not respond and he attempted a forced landing. The airplane impacted trees,… - [NTSB ANC86LA039](https://openairdocs.org/ntsb/ANC86LA039.md): Cessna 172-G · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N5892B · Substantial damage > The plt stated that during the return from a x-country flt the acft ran out of fuel one-half mile from the rwy. Post acc exam revealed that both fuel tanks were empty. - [NTSB LAX86LA149](https://openairdocs.org/ntsb/LAX86LA149.md): Cessna T210N · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 1986 · N5256A · Substantial damage > The pilot was practicing instrument approaches and reported to the control tower that he had experienced a loss of engine power. During the attempted forced landing, the aircraft struck power lines and crashed inverted in a river bed two miles west of the… - [NTSB FTW86LA072](https://openairdocs.org/ntsb/FTW86LA072.md): Cessna R172K · Waco, TX · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N758KU · Substantial damage > The pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at… - [NTSB ANC86FA037](https://openairdocs.org/ntsb/ANC86FA037.md): de Havilland DHC-4A · Lime Village, AK · Accident · 2 fatal · Field investigation · Final report · Mar 20, 1986 · N539Y · Destroyed > Witnesses observed the acft on final approach with its gear down then the nose pitched up. The acft rolled left and crashed into trees. The acft's cockpit, cabin, engine nacelles, cargo and portions of the wings were destroyed by post-impact fire. Post… - [NTSB NYC86FHA02](https://openairdocs.org/ntsb/NYC86FHA02.md): Gulfstream American AA-1 · Pottstown, PA · Accident · Serious injuries · Final report · Mar 16, 1986 · N224Y · Substantial damage > The acft collided with an embankment short of the intended rwy. A CFI waiting on the taxiway for clearance to takeoff stated that the acft appeared to be ok about 200 ft from the threshold of the rwy. Then it appeared to slip to the left and turn 90 degrees… - [NTSB MIA86IA098](https://openairdocs.org/ntsb/MIA86IA098.md): Boeing 727 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Mar 16, 1986 · N8861E · Minor damage > During arrival at ft lauderdale, the aircrew attempted to extend the gear, but at first, they were unable to get a safe 'down' indication for the rgt main gear. After about one hour, they were able to insure that both main gear had extended& were locked. They… - [NTSB NYC86FA084](https://openairdocs.org/ntsb/NYC86FA084.md): Piper PA-28-181 · Williamstown, NJ · Accident · 1 fatal · Field investigation · Final report · Mar 14, 1986 · N8259E · Destroyed > The plt executed VOR rwy 09 apch to the arpt at night and during low visibility conditions that ranged from 100 to 400 feet due to fog. The acft first collided with a house, followed by two parked cars and then main impact with a second house. The accident… - [NTSB DCA86AA021](https://openairdocs.org/ntsb/DCA86AA021.md): Embraer EMB-110P1 · Alpena, MI · Accident · 3 fatal · Final report · Mar 14, 1986 · N1356P · Destroyed > Drg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a… - [NTSB ATL86FA092](https://openairdocs.org/ntsb/ATL86FA092.md): Piper PA-23 · Toledo, OH · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1986 · N3124P · No damage > N3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a… - [NTSB SEA86FA075](https://openairdocs.org/ntsb/SEA86FA075.md): Stinson 108-2 · La Conner, WA · Accident · Serious injuries · Field investigation · Final report · Mar 11, 1986 · N388C · Destroyed > Plt was on approach for water landing in a canal used during previous summer for floatplane ops at dusk. Plt was looking for a specific boat moored in canal as landing mark, extended approach path beyond normal touchdown point. Acft struck telephone cable… - [NTSB MIA86LA094](https://openairdocs.org/ntsb/MIA86LA094.md): Piper PA-32R · Captiva, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1986 · GPZS · Substantial damage > The plt stated that she was making a low final approach to the 2200 ft grass strip & lost lift as the acft passed below & behind the treeline. The plt's husband, also a plt, occupying the right front seat, stated that his wife may have been somewhat… - [NTSB DEN86LA095](https://openairdocs.org/ntsb/DEN86LA095.md): Smith, Ted Aerostar 601P Aerostar · Dickinson, ND · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1986 · N35DM · Substantial damage > While enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an… - [NTSB CHI86FA100](https://openairdocs.org/ntsb/CHI86FA100.md): Cessna 172M · Lafox, IL · Accident · 2 fatal · Field investigation · Final report · Mar 8, 1986 · N72MA · 2 aircraft · Destroyed > An instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was… - [NTSB LAX86LA135](https://openairdocs.org/ntsb/LAX86LA135.md): Robinson R-22 · El Toro, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1986 · N9072Z · Substantial damage > A helicopter crashed into a mountain slope east of El Toro, CA while on a business flt. While the acft approached the mountain peak the plt experienced an increase in the rate of descent and aborted the landing. During the go-around, at adecreased main rotor… - [NTSB ATL86FA085](https://openairdocs.org/ntsb/ATL86FA085.md): Beech BE-90 · Mount Pleasant, TN · Accident · No injuries · Field investigation · Final report · Mar 4, 1986 · N861K · Substantial damage > On final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=187 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=186 --- 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.