# 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 316 of 718 · 35,889 cases ## Cases, newest first - [NTSB MIA87FA080](https://openairdocs.org/ntsb/MIA87FA080.md): Piper PA-28-161 · Venice, FL · Accident · 3 fatal · Field investigation · Final report · Feb 1, 1987 · N3655M · Destroyed > Aircraft was seen maneuvering at between 200 and 300 feet in attempts to locate a lost radio controlled model airplane. As the aircraft completed 2 and one half turns it leveled out and began a climb to the north at which time it collided with a 504 foot… - [NTSB LAX87FA102](https://openairdocs.org/ntsb/LAX87FA102.md): Cessna 172P · Cuyama, CA · Accident · 2 fatal · Field investigation · Final report · Jan 31, 1987 · N62127 · Destroyed > The plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd… - [NTSB FTW87LA055](https://openairdocs.org/ntsb/FTW87LA055.md): Cessna 175 · Jacksonville, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1987 · N175RF · Substantial damage > The pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for… - [NTSB DEN87LA049](https://openairdocs.org/ntsb/DEN87LA049.md): Piper PA-28-181 · Taos, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 1987 · N6913L · Substantial damage > The non-instrument rated plt inadvertently flew into IMC wx; snow, fog, freezing temperatures and low visibility, in mountainous terrain. He made a forced landing on a trail due to lowering visibility, 15 miles southwest of the destination arpt. The terrain… - [NTSB CHI87FA069](https://openairdocs.org/ntsb/CHI87FA069.md): Cessna 210N · Bedford Park, IL · Accident · 1 fatal · Field investigation · Final report · Jan 30, 1987 · N4968C · Destroyed > Just bfr tkof fm rwy 22L on a ngt IFR flt, the plt was clrd to clb & maint 2000' & to contact chicago dep ctl (TRACON). About 1 min later, he called TRACON & rprtd he was clbg thru 900' for 2000'. This call was in a normal tone of voice & was the last… - [NTSB SEA87FA051](https://openairdocs.org/ntsb/SEA87FA051.md): Cessna 150J · Vancouver, WA · Accident · 2 fatal · Field investigation · Final report · Jan 29, 1987 · N50922 · Destroyed > Aircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for… - [NTSB FTW87LA049](https://openairdocs.org/ntsb/FTW87LA049.md): Piper PA-31 · Medford, OK · Accident · No injuries · Limited investigation · Final report · Jan 28, 1987 · N76ND · Substantial damage > The acft experienced a double eng failure as a result of fuel exhaustion during descent to the destination aprt. The plt attempted to divert to a nearby arpt during the descent, but both engs quit before he had the rwy assured. The subsequent attempted forced… - [NTSB DEN87LA047](https://openairdocs.org/ntsb/DEN87LA047.md): Cessna 182L · La Junta, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1987 · N3439R · Substantial damage > The engine quit during cruise flt at 8,500 feet MSL. During the emergency landing to unsuitable terrain, the acft nosed over. The plt had flown 5 hours on this flt. The long range fuel tanks had been installed with the filler ports inboard, limiting the total… - [NTSB DEN87FA061](https://openairdocs.org/ntsb/DEN87FA061.md): Cessna T210L · Nucla, CO · Accident · 4 fatal · Field investigation · Final report · Jan 28, 1987 · N1721X · Destroyed > The acft was on an IFR flt to an arpt without an instrument approach procedure. ATC cleared the flt to descend to 12,000 ft, the IFR mea for the area, at 30 NM NE of the arpt. At approx 3 min prior to the mishap, the plt was issued a cruise clearance at… - [NTSB LAX87LA097](https://openairdocs.org/ntsb/LAX87LA097.md): Cessna 152 · Glendora, CA · Accident · No injuries · Limited investigation · Final report · Jan 26, 1987 · N65560 · Substantial damage > During a local pleasure flight, the engine lost power and the pilot made a forced landing on a golf course. Visual inspection of the fuel tanks revealed that both tanks were empty and no fuel drained from the sumps. No mechanical failure or malfunction with… - [NTSB ATL87LA066](https://openairdocs.org/ntsb/ATL87LA066.md): Cessna 337D · Savannah, GA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1987 · N10MM · Destroyed > The pilot was flying a donated aircraft in support of a program to document the activities of wright whales off the coast of the carolina's and Georgia. The plt had been with the owner on a previous flt, when problems developed while switching to/and/or from… - [NTSB CHI87IA067](https://openairdocs.org/ntsb/CHI87IA067.md): Boeing 727-122 · Fort Wayne, IN · Incident · No injuries · Incident investigation · Final report · Jan 25, 1987 · N7015U · Minor damage > Aircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft… - [NTSB NYC87LA067](https://openairdocs.org/ntsb/NYC87LA067.md): Cessna 152 · Boyertown, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1987 · N10VF · Substantial damage > Student pilot on a solo cross-country flight experienced fuel exhaustion, landed in a field and collided with a stonewall. The aircraft was substantially damaged and the pilot received minor injuries. - [NTSB NYC87LA065](https://openairdocs.org/ntsb/NYC87LA065.md): Beech 95-A55 · Babylon, NY · Accident · No injuries · Limited investigation · Final report · Jan 24, 1987 · N9555Y · Destroyed > The Beech baron had been cruising at altitude for approximately 2 hours when it started a descent with the OAT well below freezing. During the descent the pilot attempted to add power and there was no response. The pilot turned on the boost pumps to high and… - [NTSB NYC87FA063](https://openairdocs.org/ntsb/NYC87FA063.md): Mooney M20C · Highgate, VT · Accident · 1 fatal · Field investigation · Final report · Jan 20, 1987 · N3496X · Destroyed > According to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the… - [NTSB NYC87FA061](https://openairdocs.org/ntsb/NYC87FA061.md): Piper PA-32-260 · Westerly, RI · Accident · No injuries · Field investigation · Final report · Jan 20, 1987 · N3293W · 2 aircraft · Minor damage > The Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just… - [NTSB MIA87LA077](https://openairdocs.org/ntsb/MIA87LA077.md): Cessna 152 · Key West, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1987 · N757DW · Substantial damage > The plt failed to calculate fuel consumption for the intended route of flt prior to takeoff. Aprx 55 minutes into the flt the eng quit due to fuel exhaustion. The acft was then ditched in the gulf of Mexico. - [NTSB DCA87MA020](https://openairdocs.org/ntsb/DCA87MA020.md): Piper PA-31-350 · Independence, MO · Accident · 6 fatal · Class 1 · Major · Final report · Jan 20, 1987 · N60SE · 2 aircraft · Destroyed > The two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt… - [NTSB LAX87FA093](https://openairdocs.org/ntsb/LAX87FA093.md): Cessna 177RG · S Lake Tahoe, CA · Accident · 4 fatal · Field investigation · Final report · Jan 19, 1987 · N123DJ · Destroyed > After departing at night from south lake Tahoe, CA, the plt contacted ARTCC & requested radar flt following. A short time later, he declared an emergency & said he was reversing course with a loss of eng power. Radar & radio contact with the acft were lost as… - [NTSB ATL87IA062](https://openairdocs.org/ntsb/ATL87IA062.md): Dornier DO228 · Cleveland, OH · Incident · No injuries · Incident investigation · Final report · Jan 19, 1987 · N88FB · Minor damage > A piece of ice penetrated a pax cabin window immediately forward of the rt engine prop arc and the ice strike plate. The acft mfr subsequently issued a service bulletin recommending the replacement of the standard windows installed forward of the prop arc(s)… - [NTSB LAX87FA087](https://openairdocs.org/ntsb/LAX87FA087.md): Cessna 208 · Cima, CA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1987 · N9613F · Destroyed > While on a day/vfr flt from ontario, CA to las vegas, NV, the acft collided with mountainous terrain near the top of a 6500' peak. Radar data showed that aprx 20 min before the acdnt, the acft began a gradual dscnt from about 10,000'. No preimpact part… - [NTSB ANC87FA023](https://openairdocs.org/ntsb/ANC87FA023.md): Cessna 207A · Kenai, AK · Accident · 1 fatal · Field investigation · Final report · Jan 14, 1987 · N9395M · Destroyed > Wx conds on the day of the acdnt were rprtd to be extremely variable. Initially, when the plt obtained a wx briefing, VFR flt was not rcmdd. Later, the wx improved & the plt elected to proceed on the flt. While en route, he enctrd snow showers & dscndd to… - [NTSB MIA87LA073](https://openairdocs.org/ntsb/MIA87LA073.md): Cessna 310J · Straights Of Fl, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1987 · N1204V · Substantial damage > The plt stated that the flt departed grand caymen, on January 12, 1987, at aprx 1600 EST. Aprx 3 hrs into the flt the c.h.t & exhaust temperatures hit red line on the left eng following a loss of oil pressure. He secured the eng & then noticed fuel being… - [NTSB MIA87LA072](https://openairdocs.org/ntsb/MIA87LA072.md): Cessna 150L · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Jan 13, 1987 · N10732 · Substantial damage > The plt stated that he was forced to land in a field due to a drop in eng RPM, & the inability to maintain alt. On touchdown, the acft collided with trees, after which the nose gear collapsed, the acft nosed over, & came to rest inverted. Investigation… - [NTSB LAX87LA082](https://openairdocs.org/ntsb/LAX87LA082.md): Mooney M20C · Spring Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1987 · N6864U · Substantial damage > A Mooney M20C collided with an automobile during landing roll after landing on a road. The plt indicated that while cruising at 3,500 ft MSL he noticed the eng oil pressure fall to zero. The constant speed propellor simultaneously went to low pitch, followed… - [NTSB LAX87FA116](https://openairdocs.org/ntsb/LAX87FA116.md): Beech 35 · Monrovia, CA · Accident · 1 fatal · Field investigation · Final report · Jan 11, 1987 · CFHRR · Destroyed > After receiving his preflight wx briefing at 0715 hrs, the plt tookoff at 1436 hrs on a x-country flight. There is no evidence that the pilot requested or received a current wx briefing prior to the accident. After the acft was provided flight following… - [NTSB CHI87LA062](https://openairdocs.org/ntsb/CHI87LA062.md): Mooney M20J · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Jan 10, 1987 · N5632H · Substantial damage > After requesting clearance to Kalamazoo county airport (azo) due to icing problems, the plt was given radar vectors to the ILS runway 35 approach. Four minutes later the plt stated that it was 'probably going to be a dead stick landing.' When asked what he… - [NTSB ATL87MA057](https://openairdocs.org/ntsb/ATL87MA057.md): Bell 206L-1 · Pollockville, NC · Accident · 4 fatal · Major investigation · Final report · Jan 9, 1987 · N5004Q · Destroyed > The emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought… - [NTSB MKC87LA039](https://openairdocs.org/ntsb/MKC87LA039.md): Cessna 120 · Salem, AR · Accident · No injuries · Limited investigation · Final report · Jan 8, 1987 · N72516 · Substantial damage > The airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure… - [NTSB MIA87FA069](https://openairdocs.org/ntsb/MIA87FA069.md): Cessna T210F · Tallahassee, FL · Accident · 1 fatal · Field investigation · Final report · Jan 7, 1987 · N6184R · Destroyed > Plt/owner was informed by mechanics that the acft fuel tanks had water contamination on two occurrences prior to test flights. The plt reported he ahd had water contamination and believed the fuel caps were leaking. New caps were ordered to be installed at… - [NTSB MIA87IA068](https://openairdocs.org/ntsb/MIA87IA068.md): Boeing 727-223 · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Jan 6, 1987 · N6819 · Minor damage > The regularly scheduled air carrier flight was climbing to altitude when the engine oil pressure and quantity dropped to zero on the #3 engine; it was shut down. Shortly thereafter, the #1 engine oil pressure dropped to zero. It was reduced to idle and the… - [NTSB MKC87FA036](https://openairdocs.org/ntsb/MKC87FA036.md): Cessna 152 · Berryman, MO · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1987 · N67580 · Destroyed > The acft flew into trees and terrain in normal cruise flt. There were no problems found with the acft during post acc invest. The autopsy and toxicology revealed no evidence that could be considered as casual. Wx was not considered to be a problem. The flt… - [NTSB DEN87FA041](https://openairdocs.org/ntsb/DEN87FA041.md): Cessna T210M · Albuqerque, NM · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1987 · N6577B · Destroyed > The plt elected to takeoff from abq international arpt during the passage of a severe wx system. Although his departure was successful his flt path was heading toward the mountains east of abq. He was observed turning north up a canyon. Shortly after turning,… - [NTSB LAX87LA074](https://openairdocs.org/ntsb/LAX87LA074.md): Cessna 182F · Wickenburg, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1987 · N3587U · Substantial damage > During a pleasure cross-country flight, the engine quit approximately 2 miles west of the Wickenburg airport and the pilot made a forced landing off the arpt in a field. Examination of the aircraft revealed that the fuel selector was positioned to the right… - [NTSB FTW87LA044](https://openairdocs.org/ntsb/FTW87LA044.md): Bellanca 17-30 · Lufkin, TX · Accident · No injuries · Limited investigation · Final report · Jan 4, 1987 · N66590 · Substantial damage > A private pilot substantially damaged his aircraft while attempting an emergency landing following a engine failure due to fuel exhaustion in the right main tank. The pilot switched to a full tank but failed to use the fuel boost pump during the attempted… - [NTSB DEN87LA040](https://openairdocs.org/ntsb/DEN87LA040.md): Cessna T210N · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Jan 4, 1987 · N2WF · Substantial damage > Plt and two pax departed limon, CO, at 1000 for return trip to center, CO. At 1030 plt switched to the right fuel tank, ten min later eng lost power and plt made forced landing west of Pueblo, CO. Plt claimed right fuel gauge was faulty. Plt later said he… - [NTSB MIA87MA064](https://openairdocs.org/ntsb/MIA87MA064.md): Cessna T210N · Jasper, FL · Accident · 6 fatal · Major investigation · Final report · Jan 1, 1987 · N5498A · Destroyed > Drg flt in an area of IFR conditions & rain showers, the plt reqd & recd clnc to dscnd from 9000' to 7000'. Later, he recd clnc for further dscnt to 5000'. After a freq chg at 2237 EST, the plt inquired about radar indcns of adverse wxahead. The ctlr adzd… - [NTSB NYC87LA055](https://openairdocs.org/ntsb/NYC87LA055.md): Cessna 150 · Yorktown Hgts, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1986 · N9195U · Substantial damage > The acft en route from gaithesburg, Maryland to brookhaven, new york, experienced fuel exhaustion and was forced landed in a rough meadow and was substantially damaged. - [NTSB CHI87FA058](https://openairdocs.org/ntsb/CHI87FA058.md): Piper PA-31T · Merrillville, IN · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1986 · N74NL · Destroyed > The acft was enroute to the chicago midway arpt. While letting down to 16000 ft the pilot reported he was shutting down the right eng. ARTCC cleared the acft to 5000 ft. ten minutes later ARTCC lost radio transponder and mode c contact. 15 minutes later the… - [NTSB CHI87DEP04](https://openairdocs.org/ntsb/CHI87DEP04.md): Mooney M20F · Greenwood, WI · Accident · No injuries · Final report · Dec 30, 1986 · N9627M · Substantial damage > The aircraft lost engine power during a descent due to a loose throttle linkage and the pilot was forced to make an emergency landing in a field. On landing roll the aircraft struck a reflector post with the right wing. - [NTSB CHI87FA057](https://openairdocs.org/ntsb/CHI87FA057.md): Piper PA-32-301 · Wheeling, IL · Accident · No injuries · Field investigation · Final report · Dec 29, 1986 · N8281Y · Substantial damage > The pilot attempted flight although pirep's for icing had been issued during weather briefing from fss and aircraft was not equipped for icing conditions. Shortly after takeoff, pilot reported to ATC problems with aircraft flight instruments and then reported… - [NTSB NYC87LA052](https://openairdocs.org/ntsb/NYC87LA052.md): Taylorcraft BC12-D · Broadalbin, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1986 · N43239 · Substantial damage > The pilot of a Taylorcraft BC-12D experienced a loss of power while cruising. He selected a field for a landing, however he was short and struck a tree on final. The aircraft received substantial damage and the pilot and passenger received serious injuries.… - [NTSB NYC87LA056](https://openairdocs.org/ntsb/NYC87LA056.md): Piper PA-28-181 · Leominster, MA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1986 · N8720C · Substantial damage > The Piper PA-28-181 departed on a cross country flight with full tanks (48 gal) according to the pilot. Enroute the pilot experienced a power loss at night after flying for 3.9 hours. The pilot landed in a residential area and struck a house on landing roll.… - [NTSB LAX87LA070](https://openairdocs.org/ntsb/LAX87LA070.md): Raven S55A/AX7 · Peoria, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 1986 · N5561P · Minor damage > Prior to lift-off the pilot noted that the wind conditions were calm. During the flight, the surface winds began to increase. The pilot prepared his passengers for a high wind landing and began to lightly vent off hot air. The balloon began descending at… - [NTSB LAX87FA071](https://openairdocs.org/ntsb/LAX87FA071.md): Piper PA-28R-201 · Gorman, CA · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1986 · N50U · Destroyed > The aircraft descended into mountainous terrain during a night cross-country flight. The surviving pilot stated that he was attending to paperwork and when he looked up he turned on the landing light in time to see trees just prior to impact. He further… - [NTSB FTW87LA038](https://openairdocs.org/ntsb/FTW87LA038.md): Cessna 150 · Loreauville, LA · Accident · No injuries · Limited investigation · Final report · Dec 27, 1986 · N5788E · Substantial damage > A private pilot substantially damaged his aircraft while attempting a landing in a field following a engine failure due to water contamination in the fuel system. - [NTSB CHI87LA055](https://openairdocs.org/ntsb/CHI87LA055.md): Piper J3C-65 · Harrison Twp., WI · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1986 · N37926 · Destroyed > During cruise flt the plt attempted to add power and carb heat with no immediate response in eng power. The plt then tried to make an emergency landing in a field but did not have sufficient altitude and airspeed. The acft collided with trees. The plt… - [NTSB DEN87LA034](https://openairdocs.org/ntsb/DEN87LA034.md): Bellanca 8GCBC · Ovid, CO · Accident · No injuries · Limited investigation · Final report · Dec 25, 1986 · N1068E · Substantial damage > The plt saw smoke from engine compartment on climb to cruise. He made a forced landing after cirling the field. During landing roll, the plt applied excessive braking and the acft nosed over. There was a post accident fire. - [NTSB SEA87LA041](https://openairdocs.org/ntsb/SEA87LA041.md): Douglas C-54/DC-4 · Pacific Ocean, WA · Accident · No injuries · Limited investigation · Final report · Dec 24, 1986 · N96361 · Substantial damage > The plt reptd that he ditched his DC-4 in the Pacific Ocean on the evening of December 23 after experiencing an uncontrollable no. 3 eng fire at the conclusion of a tng flt. The ditching occurred in dark night conditions with minimal 10 foot swells having a… - [NTSB ATL87LA049](https://openairdocs.org/ntsb/ATL87LA049.md): Piper PA-34-200T · Mobile, AL · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1986 · N3577U · Substantial damage > The plt had suspected a hydraulic problem prior to departure when hydraulic fluid was found on the hangar floor. The acft was flown to a nearby arpt for repairs. The acft then departed and aprx 1 hr into the flt a heater problem was experienced. The plt… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=317 ## 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=316 --- 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.