# 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 179 of 420 · 20,996 cases ## Cases, newest first - [NTSB ATL87DLT01](https://openairdocs.org/ntsb/ATL87DLT01.md): Schleicher ASK-21 · Eagleville, TN · Accident · No injuries · Final report · Apr 17, 1987 · N174KS · Substantial damage > During a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was… - [NTSB CHI87FA114](https://openairdocs.org/ntsb/CHI87FA114.md): Cessna 182G · West Point, IN · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1987 · N2382R · Destroyed > Drg an IFR arrival, the plt was clrd for an ILS rwy 10 apch. No radar facilities were available, but at 1026 EST, he rprtd he was established on the localizer. Aprx 4 min later, he declared a missed apch & was cleared back to the outer marker (om), then was… - [NTSB LAX87LA177](https://openairdocs.org/ntsb/LAX87LA177.md): Cessna T303 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1987 · N2225C · Substantial damage > A Cessna T303 collided w the LOC antenna aft a total loss of pwr in both engs while on final app to rwy 30. The plt indicated that the engs failed due to fuel exhaustion. The flt made 5 stops to pick-up and drop off cargo and is normally flown daily by… - [NTSB DCA87MA026](https://openairdocs.org/ntsb/DCA87MA026.md): Boeing 707-351C · Kansas City, MO · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1987 · N144SP · Destroyed > Drg arr, buffalo airways flt 721 was vectored for an ILS rwy 1 apch. Except for deviations to avoid tstms, dscnt to the terminal area was routine. At 2151:01, the flt was adzd it was 5 mi fm the outer marker (om), was given a final vector to intercept the ILS… - [NTSB MKC87FA078](https://openairdocs.org/ntsb/MKC87FA078.md): Lake LA-4-200 · Nixa, MO · Accident · 2 fatal · Field investigation · Final report · Apr 12, 1987 · N2847P · Destroyed > The normal procedure for operating at this airstrip was to always take off to the east and land to the west when winds were not excessive. Winds elsewhere in area were from southeast at 13 knots while at this strip, they were from the east at 30 knots. After… - [NTSB MKC87FA077](https://openairdocs.org/ntsb/MKC87FA077.md): Cessna 150-H · Council Bluffs, IA · Accident · 1 fatal · Field investigation · Final report · Apr 12, 1987 · N50223 · Destroyed > Acquaintances stated that the student pilot was very motivated in the pursuit of his private pilot certificate and that, on the day of the accident, he was looking forward to this first solo flight. According to his instructor-pilot, who also witnessed the… - [NTSB ATL87LA110](https://openairdocs.org/ntsb/ATL87LA110.md): Beech C23 · Branchville, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1987 · N6021X · Substantial damage > The plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind… - [NTSB ATL87LA109](https://openairdocs.org/ntsb/ATL87LA109.md): Cessna 150F · Branchville, AL · Accident · No injuries · Limited investigation · Final report · Apr 11, 1987 · N8960S · Substantial damage > The plt reported that the acft appeared to be 'hot' on final approach due to a tailwind, while ldg at the private airstrip. He initiated a go-around to avoid 50-60 ft trees at the FAR end of the rwy and made a climbing right turn. The stall warning system… - [NTSB NYC87DNE02](https://openairdocs.org/ntsb/NYC87DNE02.md): Sprague Christian Eagle II · North Adams, MA · Accident · 1 fatal · Final report · Apr 10, 1987 · N11GS · Destroyed > The christian eagle was coming in for a touch and go when it sank into trees, turned around and became involved in a postcrash fire. The acft was destroyed and the plt fatally injured. A pilot who preceded the accident aircraft said the winds were gusty and… - [NTSB DCA87MA024](https://openairdocs.org/ntsb/DCA87MA024.md): Lockheed L-382G · Travis Afb, CA · Accident · 5 fatal · Major investigation · Final report · Apr 9, 1987 · N517SJ · Destroyed > Crashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed… - [NTSB NYC87LA116](https://openairdocs.org/ntsb/NYC87LA116.md): Ercoupe 415D · Warwick, NY · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N2833H · Substantial damage > The flight was on approach for landing on runway 3 at Warwick airport when the engine started to sputter. The pilot continued to pump the throttle but overshot the runway and landed in a swamp. It was not determined what caused the loss of power to the engine. - [NTSB FTW87LA091](https://openairdocs.org/ntsb/FTW87LA091.md): Aeronca 7AC · Horizon City, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 1987 · N85397 · Destroyed > The pilot delayed in initiating recovery from a simulated forced landing. Then when the throttle was advanced from idle to full open the engine hesitated briefly and full power was restored too late to recover. A hard left bank was initiated to align the… - [NTSB SEA87LA076](https://openairdocs.org/ntsb/SEA87LA076.md): Piper PA-28-140 · Alkali Lake, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 1987 · N1770J · Substantial damage > During a windy crosswind approach the pilot lost control of the aircraft. The aircraft struck the ground short of the runway breaking off the nose gear and then nosing over inverted. - [NTSB SEA87LA073](https://openairdocs.org/ntsb/SEA87LA073.md): Cessna TU206-F · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 1987 · N71068 · Substantial damage > While on base leg a loss of power occurred. The student pilot selected right fuel tank and applied the fuel boost pump. A restart was not successful. The instructor pilot then took the controls of the aircraft. He selected a road to land on because there was… - [NTSB MIA87FA124](https://openairdocs.org/ntsb/MIA87FA124.md): Eagle C-7 · Ft. Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · Apr 2, 1987 · N7321R · Substantial damage > The balloon struck powerlines while attempting to locate a suitable ldg site. The plt stated that a gust of wind blew the balloon into the wires & he was unable to climb to avoid the wires prior to impact. The surface winds were from the north at about 8 KTS… - [NTSB ANC87MA057](https://openairdocs.org/ntsb/ANC87MA057.md): Cessna 402 · Anchorage, AK · Accident · 2 fatal · Major investigation · Final report · Apr 2, 1987 · N967JW · Substantial damage > The acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground… - [NTSB MKC87LA072](https://openairdocs.org/ntsb/MKC87LA072.md): Grumman-Schweizer G-164A · Dodge City, KS · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N48564 · Substantial damage > The pilot stated that the aircraft was operating normally when he established himself on final approach for rwy 32. Winds were from the northeast at 25 KTS, the pilot further stated, so he abandoned the approach and was in the process of circling the field… - [NTSB ATL87LA103](https://openairdocs.org/ntsb/ATL87LA103.md): Cessna 172D · Oliver Springs, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1987 · N2510Y · Substantial damage > The plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout… - [NTSB LAX87LA165](https://openairdocs.org/ntsb/LAX87LA165.md): Cessna T206F · Grand Canyon, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1987 · N9026B · Substantial damage > The plt said that on short final the acft began to drift off the left side of the rwy and control inputs to correct the drift had no effect. The plt added pwr to initiate a go around and he said that the 'airspeed suddenly dropped to 40 and we were in a stall… - [NTSB ANC87LA056](https://openairdocs.org/ntsb/ANC87LA056.md): Cessna 152 · Nikolai, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1987 · N67767 · Substantial damage > The student pilot stated that he was on a solo cross country flight when he reported that he was lost and low on fuel. He attempted an emergency landing but crashed 200 feet short of the runway. The flight instructor stated that the aircraft was out of fuel… - [NTSB FTW87NA086](https://openairdocs.org/ntsb/FTW87NA086.md): Learjet 24A · Eagle, CO · Accident · 3 fatal · Final report · Mar 28, 1987 · N31SK · Destroyed - [NTSB ATL87FA100](https://openairdocs.org/ntsb/ATL87FA100.md): Piper PA-34-200T · Georgetown, DE · Accident · 1 fatal · Field investigation · Final report · Mar 28, 1987 · N2221E · Destroyed > The plt was cleared for approach with instructions to close flt plan upon landing. Aprx thirty min later approach control called the fss and asked if the plt had been in contact. The reply was negative. No further action was taken by approach control.… - [NTSB MIA87LA119](https://openairdocs.org/ntsb/MIA87LA119.md): Piper PA-24 · Gainesville, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 1987 · N6143P · Substantial damage > The non instument rated private pilot filed an instrument flight plan for a 5 hour flight. The flight lasted 5 hours and 26 minutes when the pilot radioed controllers that he had run out of fuel and the engine failed. The aircraft crashed at the destination… - [NTSB ATL87LA093](https://openairdocs.org/ntsb/ATL87LA093.md): Schweizer SGS 2-33 · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Mar 22, 1987 · N2959H · Substantial damage > During the instructional flt to demonstrate emergency procedures, the instructor stated that he allowed the student to get too low on approach before he took corrective action. The aircraft collided with trees and subsequently the ground approx. 600 feet… - [NTSB NYC87LA113](https://openairdocs.org/ntsb/NYC87LA113.md): Piper PA-31T · Lawrence, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1987 · N200FD · Destroyed > The crew of the PA-31T cheyenne had made one missed approach and the co-pilot was calling out the altitudes to the pilot. The pilot's reply to the co-pilot was that he was just going to descend to 400 ft. the approach minimums were published for an mda of 660… - [NTSB MIA87LA115](https://openairdocs.org/ntsb/MIA87LA115.md): Cessna T210N · Oxford, MS · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1987 · N9504Y · Substantial damage > During final apch the eng quit. The plt then attempted to land the acft on a road, during which, it collided with trees. Inspection of the acft revealed that the adjusting screw on the eng driven fuel pump backed out aprx 8 turns. Bench test of the pump… - [NTSB ATL87LA094](https://openairdocs.org/ntsb/ATL87LA094.md): Barlow Quickie 2 · Stockbridge, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 1987 · N14QP · Destroyed > The homebuilt Q-2 was on final approach when it impacted the trees about 300 feet short of the touchdown point. There were no witnesses and the pilot has no memory of the accident. He reported that he does not recall any problem with the aircraft except the… - [NTSB CHI87DEC02](https://openairdocs.org/ntsb/CHI87DEC02.md): Cessna 172G · Linden, MI · Accident · Minor injuries · Final report · Mar 20, 1987 · N3630L · Substantial damage > The student pilot was attempting to land when he decided he was too high, and aborted the landing attempt. The engine failed to develop power despite throttle and mixture adjustments, and the pilot made a forced landing in a cornfield. Examination of the… - [NTSB FTW87LA077](https://openairdocs.org/ntsb/FTW87LA077.md): Bell 206B · Austin, TX · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N666TV · Substantial damage > Acft was damaged during a hard landing on a roof top heliport following a partial power loss as a result of an uncommanded engine deceleration. As the acft was 40' above and 40' out from the heliport pad, the power loss occurred and the plt stretched his… - [NTSB LAX87FA149](https://openairdocs.org/ntsb/LAX87FA149.md): Piper PA-24-250 · Jamestown, CA · Accident · 4 fatal · Field investigation · Final report · Mar 18, 1987 · N5393P · Destroyed > During the night cross country flt, the accident acft, in company with 2 others, was trying to land at the dest airport in hilly terrain. As the 3 acft approached the airport they encountered bkn to ovrcst conditions of about 400 ft AGL and vis of 2 mi in… - [NTSB MIA87LA113](https://openairdocs.org/ntsb/MIA87LA113.md): Kenny Deward B-8M · Escatawpa, MS · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 1987 · N1389X · Substantial damage > While practicing power off landings downwind the flight encountered a gust at which time the pilot lost control. The aircraft descended rapidly striking the ground and then cartwheeling. - [NTSB LAX87LA143](https://openairdocs.org/ntsb/LAX87LA143.md): Stinson 108-1 · Saugus, CA · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N8185K · Substantial damage > Upon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed… - [NTSB ATL87FA082](https://openairdocs.org/ntsb/ATL87FA082.md): Beech K35 · Arden, NC · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1987 · N621M · Destroyed > Plt departed charleston, SC for raleigh earlier in the day. While at raleigh he discussed pending legislation with assoc. He departed raleigh about 2228 EST in wx of indef 100 and 1/2 mile visibility. His destination was forecast to have occasional ceilings… - [NTSB MIA87LA100](https://openairdocs.org/ntsb/MIA87LA100.md): Cessna 337E · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N100LT · Substantial damage > The plt stated that on short final the auto-plt activated resulting in an uncontrolled 50-60 degree nose low left bank. The acft then veered from the apch path off the arpt property where it then collided with a vehicle & tree before coming to rest.… - [NTSB CHI87LA092](https://openairdocs.org/ntsb/CHI87LA092.md): Mooney M-20G · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N3960N · Substantial damage > While on downwind leg the pilot heard another aircraft call downwind. When he turned to final the other aircraft turned base. As he descended on final approach the other aircraft turned sharply inside the acft on final and landed. The following aircraft… - [NTSB CHI87DEP02](https://openairdocs.org/ntsb/CHI87DEP02.md): Cessna 182N · Wissota, WI · Accident · 1 fatal · Final report · Mar 8, 1987 · N92840 · Destroyed > While attempting a night landing, by use of car headlights, the aircraft struck wires and descended out of control into the terrain. Witnesses stated that the pilot seemed low during the final approach. The private airport was not lighted. - [NTSB CHI87LA091](https://openairdocs.org/ntsb/CHI87LA091.md): Beech BE 36 · Alma, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1987 · N12KT · Substantial damage > According to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The… - [NTSB CHI87LA090](https://openairdocs.org/ntsb/CHI87LA090.md): Cessna 150H · Hopkins, MI · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 1987 · N22793 · Substantial damage > The plt stated that 'everything was normal' on downwind and base, but that he experienced rough air and 'side to side motion' of the acft on final approach to rwy 27. According to the plt, he held an airspeed of 70 mph with 'some power' until he had the rwy… - [NTSB LAX87FA135](https://openairdocs.org/ntsb/LAX87FA135.md): Grumman American AA-5A · Tucson, AZ · Accident · 3 fatal · Field investigation · Final report · Mar 6, 1987 · N9917U · Destroyed > A witness observed the airplane entering downwind with smoke trailing behind it. The pilot communicated to UNICOM that: 'the engine has quit; I have to get down'. The witness then observed the airplane making a tighter-than- normal 'base to final' turn. The… - [NTSB ATL87LA079](https://openairdocs.org/ntsb/ATL87LA079.md): Cessna 182 · Waycross, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 1987 · N3871D · Destroyed > During a normal approach to a sod strip, the pilot reported that the gusty wind condition ceased and the acft stalled to the ground short of the intended landing area. The pilot was not able to recover from the sinking condition. The impact caused substantial… - [NTSB FTW87LA072](https://openairdocs.org/ntsb/FTW87LA072.md): Cessna P206B · Hooker, OK · Accident · No injuries · Limited investigation · Final report · Mar 5, 1987 · N4783F · Substantial damage > The pilot closed the throttle after crossing the approach end of the runway and while at 10 feet or less above ground level. He bled off airspeed to the point that the aircraft stalled and dropped to the surface, resulting in a hard landing with substantial… - [NTSB DCA87MA022](https://openairdocs.org/ntsb/DCA87MA022.md): CASA C-212-CC · Romulus, MI · Accident · 9 fatal · Major investigation · Final report · Mar 4, 1987 · N160FB · Destroyed > The capt made a steep, short, fast visual approach to the runway behind a departing DC-9. The evidence indicates the capt placed the power levers into beta mode to slow the aircraft rapidly and make a short field landing. An asymmetric thrust condition… - [NTSB MIA87LA095](https://openairdocs.org/ntsb/MIA87LA095.md): Ercoupe 415-C · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Feb 26, 1987 · N93977 · Substantial damage > The private pilot attempted to reduce throttle and land but the throttle control did not reduce the power. He then landed and attempted to use the brakes to stop the aircraft but it slid off the end of the runway into a ditch. Post accident examination of the… - [NTSB NYC87LA093](https://openairdocs.org/ntsb/NYC87LA093.md): Mooney M20J · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Feb 22, 1987 · N222NS · Substantial damage > During landing, the pilot came in high and fast, pilot stated that aircraft seemed to float down the runway and when the wheels touched down, the aircraft bounced. Bouncing for the third time, the pilot added full throttle and raised the flaps. However the… - [NTSB NYC87LA092](https://openairdocs.org/ntsb/NYC87LA092.md): Piper PA-22 · Tunkhannock, PA · Accident · No injuries · Limited investigation · Final report · Feb 22, 1987 · N3045Z · Substantial damage > The plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I… - [NTSB SEA87FA060](https://openairdocs.org/ntsb/SEA87FA060.md): Cessna 182 · North Bend, OR · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1987 · N3266Y · Destroyed > Plt was inbound to VORTAC in clouds for localizer approach to rwy 4. Wx at arpt reporting 1500 ft bkn. Plt expected to make missed approach to continue VFR to another arpt. Plt reported inbound in and out of clouds at 1300 ft. acft crashed 4 NM beyond arpt,… - [NTSB LAX87FA119](https://openairdocs.org/ntsb/LAX87FA119.md): Cessna 441 · Flagstaff, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1987 · N6858S · Destroyed > The acft was on an emerg med svc (ems/med-evac) flt with a plt & flt nurse aboard to transport a maternity patient fm Flagstaff to phoenix. Drg a ngt arrival, the plt bgn a vor-a apch in IMC, then he rprtd a problem with his avionics & elected to make a… - [NTSB MIA87LA090](https://openairdocs.org/ntsb/MIA87LA090.md): Cessna 172M · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N12198 · Substantial damage > The plt was attempting to go around after landing fast, due to a tail wind that was stronger that anticipated. Unable to climb, the acft was then blown off the rwy, collided with trees, & came to rest in the gulf of Mexico. - [NTSB MIA87LA087](https://openairdocs.org/ntsb/MIA87LA087.md): Cessna 172 M · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Feb 19, 1987 · N20350 · Substantial damage > The instructor plt stated that the flt was over San Juan bay aprx 2.5-3 miles from the arpt at aprx 700 feet when the eng began to run rough. The eng then quit. However it restarted momentarily. Realizing the flt would not reach the arpt the acft was then… - [NTSB MIA87FA086](https://openairdocs.org/ntsb/MIA87FA086.md): Piper PA-34-200T · Oxford, MS · Accident · 1 fatal · Field investigation · Final report · Feb 19, 1987 · N3571X · Destroyed > The acft struck an embankment about 5 feet below the crest & just short of the rwy while attempting to land at dusk & in reduced lighting conditions. The acft exploded & bounced out of the impact crater & came to rest about on the extended rwy centerline. An… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=180 ## 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=179 --- 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.