# 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 307 of 718 · 35,885 cases ## Cases, newest first - [NTSB FTW88FA006](https://openairdocs.org/ntsb/FTW88FA006.md): Cessna 172RG · Refugio, TX · Accident · 3 fatal · Field investigation · Final report · Oct 16, 1987 · N9693B · Destroyed > The plt continued VFR flt into wx that was IMC. The acft impacted the terrain in an extremely nose low attitude. There was no record of the pilot receiving any pre-flt or in flight weather briefings or forecasts for this flight. A witness reported normal… - [NTSB NYC88LA007](https://openairdocs.org/ntsb/NYC88LA007.md): Piper J3 · Island Falls, ME · Accident · 1 fatal · Limited investigation · Final report · Oct 14, 1987 · N92440 · Destroyed > The Piper J-3 cub experienced a power loss while cruising at an altitude described by witnesses as just above the trees. The aircraft was destroyed and the pilot was fatally injured. Examination of the engine disclosed that that fuel drain valve on the fuel… - [NTSB NYC88DHD01](https://openairdocs.org/ntsb/NYC88DHD01.md): Bell 206L · Trenton, NJ · Accident · No injuries · Final report · Oct 14, 1987 · N16736 · Substantial damage > The loss of engine power due to fuel starvation, and the pilot's poor aircraft handling during the autorotation. - [NTSB MIA88FA009](https://openairdocs.org/ntsb/MIA88FA009.md): Piper PA-23-250 · St. Thomas · Accident · 1 fatal · Field investigation · Final report · Oct 12, 1987 · N6475Y · Substantial damage > After departure, aprx 3 miles west of the arpt at St. Thomas, the plt reported to the tower that the flt was returning to land due to a loss of power from the left eng. He secured it, returned to land, & on short final, positioned the landing gear selector… - [NTSB LAX88LA013](https://openairdocs.org/ntsb/LAX88LA013.md): Cessna 150L · Guam (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1987 · N11939 · Destroyed > The pilot experienced a loss of engine power at 1500 feet MSL while on a flight in the marianas islands from saipan to Guam. The aircraft was ditched in ocean waters about 2 miles north of Guam and was not recovered. The occupants were rescued by a U.S. Navy… - [NTSB DEN88LA008](https://openairdocs.org/ntsb/DEN88LA008.md): Piper PA-28-140 · Lordsburg, NM · Accident · No injuries · Limited investigation · Final report · Oct 12, 1987 · N530FL · Substantial damage > The pilot said that he reduced the throttle during the descent to traffic pattern alt at the dusty acres arpt and when he pushed the throttle in, the throttle cable broke. The eng went to idle power and quit. The pilot executed an emergency landing on a… - [NTSB ATL88FA010](https://openairdocs.org/ntsb/ATL88FA010.md): Piper PA-28-161 · Greenville, SC · Accident · 2 fatal · Field investigation · Final report · Oct 12, 1987 · N84430 · Destroyed > The plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted… - [NTSB NYC88LA008](https://openairdocs.org/ntsb/NYC88LA008.md): Beech F-33A · Concord, NH · Accident · 1 fatal · Limited investigation · Final report · Oct 11, 1987 · N17985 · Destroyed > The plt obtained a telephone wx briefing then filed an IFR flt plan for a 1030 EDT departure fm Concord municipal airport. The plt rptd off Concord at 800 ft and climbing at 1047. Manchester departure control acknowledged, assigned a transponder code, and… - [NTSB LAX88LA012](https://openairdocs.org/ntsb/LAX88LA012.md): Piper PA-28-181 · Porterville, CA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1987 · N4120F · Substantial damage > During a normal descent, the engine lost all power. The pilot executed an emergency descent and force landed in a field. An examination of the aircraft wreckage revealed that there was no fuel in the fuel tanks. During a telephone interview, the pilot stated… - [NTSB LAX88FA014](https://openairdocs.org/ntsb/LAX88FA014.md): Piper PA-28-181 · Mount Baldy, CA · Accident · 3 fatal · Field investigation · Final report · Oct 11, 1987 · N47529 · Destroyed > Bfr tkof, the plt filed a VFR flt plan & rcvd a wx briefing which included an AIRMET. The AIRMET contained precautionaryinfo abt instrument conds (IMC), icing & mtn obscuration in calif. When the plt opened his flt plan with the fss, he wasagain briefed on… - [NTSB LAX88LA011](https://openairdocs.org/ntsb/LAX88LA011.md): Piper PA-28-161 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1987 · N4342B · Substantial damage > The non-instrument rated pilot became disoriented when he inadvertently flew into a layer of fog while making an enroute descent for landing at his destination. The aircraft collided with trees while the pilot was attempting to execute a climbing course… - [NTSB BFO88LA005](https://openairdocs.org/ntsb/BFO88LA005.md): Piper PA-28R-200 · Dares Beach, MD · Accident · No injuries · Limited investigation · Final report · Oct 10, 1987 · N55936 · Substantial damage > The plt stated that after climbing about 2000' & proceeding aprx 3 to 4 mi out over the chesapeake bay, the oil temp began to rise & the oil pressure decreased. He turned toward land, but the eng lost power. Subsequently, he was forced to land in a swampy… - [NTSB LAX88IA009](https://openairdocs.org/ntsb/LAX88IA009.md): Mcdonnell Douglas DC-9-82 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Oct 9, 1987 · N413AA · No damage > Failure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor… - [NTSB FTW88LA002](https://openairdocs.org/ntsb/FTW88LA002.md): Mooney M-20-J · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Oct 9, 1987 · N57257 · Substantial damage > Acft was substantially damaged when it collided with a road sign and the grnd during an off arpt emergency lndg following a complete eng failure during descent. Plt stated that about 20 mins out from his dest, the oil press decreased into the yellow arc, but… - [NTSB ATL88LA004](https://openairdocs.org/ntsb/ATL88LA004.md): Cessna 150L · Cordesville, SC · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N11838 · Substantial damage > The airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after… - [NTSB DEN88LA010](https://openairdocs.org/ntsb/DEN88LA010.md): Balloon Works Firefly 7 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 5, 1987 · N36988 · 2 aircraft · Substantial damage > Two balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally… - [NTSB MIA88LA004](https://openairdocs.org/ntsb/MIA88LA004.md): Cessna 180 · Church Hill, MS · Accident · No injuries · Limited investigation · Final report · Oct 4, 1987 · N9202T · Substantial damage > While in cruise flight at 1,000 ft, the eng lost power. The plt performed a forced landing in a soft field and during the landing roll, the acft hit a dirt bank, nosed over, and came to rest inverted. Post crash examination of the fuel system revealed that… - [NTSB LAX88LA002](https://openairdocs.org/ntsb/LAX88LA002.md): Avian Balloon Magnum IX · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 1987 · N1600P · Substantial damage > During the first takeoff attempt, a small portion of the balloon envelope caught fire and was quickly extinguished. The second takeoff attempt was successful. One passenger on the balloon said that the flight was very erratic ranging in altitude from 10 feet… - [NTSB ANC88LA003](https://openairdocs.org/ntsb/ANC88LA003.md): Cessna 172 · 45 Nw Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 3, 1987 · N3128L · Substantial damage > The pilot stated that he believed he ran out of fuel during the IFR flight. - [NTSB MIA88FA001](https://openairdocs.org/ntsb/MIA88FA001.md): Piper PA-23-250 · Everglades City, FL · Accident · 3 fatal · Field investigation · Final report · Oct 2, 1987 · N3RP · Destroyed > The non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about… - [NTSB MKC87LA183](https://openairdocs.org/ntsb/MKC87LA183.md): Cessna 401 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Sep 30, 1987 · N2UE · Substantial damage > The unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng… - [NTSB MKC87LA182](https://openairdocs.org/ntsb/MKC87LA182.md): Cessna 150K · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · Sep 30, 1987 · N6206G · Substantial damage > Nearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted. - [NTSB MIA87LA266](https://openairdocs.org/ntsb/MIA87LA266.md): Aero Commander 720 · 50 Nw San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1987 · N4100S · Substantial damage > Fifteen minutes after a northwest departure from san juan international arpt the plt reported that the flt was returning to land after securing the rt eng due to reported problems. Unable to maintain altitude the acft was ditched aprx 50 miles northwest of… - [NTSB NYC87LA263](https://openairdocs.org/ntsb/NYC87LA263.md): Cessna 182 · Kingston, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1987 · N7388S · Destroyed > During flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an… - [NTSB MIA87IA264](https://openairdocs.org/ntsb/MIA87IA264.md): Boeing 727-225 · Hampton, NY · Incident · No injuries · Incident investigation · Final report · Sep 29, 1987 · N8864E · 2 aircraft · No damage > A full performance level controller (fpl ctlr) at sector 31 of boston ARTCC was giving familiarization training to another fpl ctlr to familiarize the trainee with a new area that had been transferred from new york ARTCC to boston ARTCC. Sector 31 was… - [NTSB NYC87FA264](https://openairdocs.org/ntsb/NYC87FA264.md): Lockheed L-1011 · Bermuda, Bermuda · Accident · Serious injuries · Field investigation · Final report · Sep 28, 1987 · N317EA · Minor damage > Encounter with undetectable clear air turbulence. - [NTSB DEN87LA246](https://openairdocs.org/ntsb/DEN87LA246.md): Cessna 150K · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Sep 28, 1987 · N2554Q · Substantial damage > The student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.… - [NTSB SEA87LA196](https://openairdocs.org/ntsb/SEA87LA196.md): Cessna 150F · Mount Vernon, WA · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N8751S · Substantial damage > The aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain. - [NTSB SEA87FA194](https://openairdocs.org/ntsb/SEA87FA194.md): Hughes 369D · Seattle, WA · Accident · Minor injuries · Field investigation · Final report · Sep 27, 1987 · N8613F · Substantial damage > The plt rprtd that while he was in cruise flight at about 1000', the eng lost power. He initiated an autorotation to an athletic field in a city park. Drg his apch, he changed his planned touchdown point svrl times due to personnel on the field. He said that… - [NTSB NYC87LA268](https://openairdocs.org/ntsb/NYC87LA268.md): Piper PA-28 · Plymouth, VT · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1987 · N302RB · Destroyed > While cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped… - [NTSB MKC87LA179](https://openairdocs.org/ntsb/MKC87LA179.md): Jenkins Pitts S-1 · Orleans, NE · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N4365 · Substantial damage > The pilot stated that the aircraft was cruising at 2,000 ft (AGL) when the engine lost power. He turned toward the nearest suitable emergency airfield but the aircraft's rate of descent precluded this option. The pilot selected a road as alternate, but… - [NTSB LAX87LA347](https://openairdocs.org/ntsb/LAX87LA347.md): Cessna 182D · San Ramon, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N8711X · Substantial damage > After telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was… - [NTSB DEN87LA245](https://openairdocs.org/ntsb/DEN87LA245.md): Enstrom 280C · Bountiful, UT · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1987 · N5692D · Destroyed > While on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir. - [NTSB DEN87LA244](https://openairdocs.org/ntsb/DEN87LA244.md): Cessna 140 · San Ysidro, NM · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N76907 · Substantial damage > The plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and… - [NTSB SEA87LA193](https://openairdocs.org/ntsb/SEA87LA193.md): Cessna 340A · Tecopa, CA · Accident · No injuries · Limited investigation · Final report · Sep 24, 1987 · N2699S · Substantial damage > A dual engine failure occurred after the first reduction in power at about 200 feet AGL. The aircraft then descended to the ground. No mechanical reason for the loss of power could be determined. - [NTSB MIA87LA252](https://openairdocs.org/ntsb/MIA87LA252.md): Cessna 150M · Belle Glade, FL · Accident · No injuries · Limited investigation · Final report · Sep 23, 1987 · N704HB · Substantial damage > The student plt stated he was en route along the hillsborough canal when he enctrd a rain shower & retarded the power to 2000 RPM to dscnd. He stated that carb ice formed & the eng lost power. He made a forced landing on a dike. However, as the acft was… - [NTSB MIA87FA257](https://openairdocs.org/ntsb/MIA87FA257.md): Piper PA-32-300 · Geneva, FL · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1987 · N4010R · Destroyed > Flt experienced engine failure when the number six connecting rod separated from the crankshaft after failure of the connecting rod bearing. During an attempted forced landing during darkness the acft collided with trees and then crashed to the ground.… - [NTSB SEA87FA190](https://openairdocs.org/ntsb/SEA87FA190.md): Cessna T210L · Hailey, ID · Accident · 3 fatal · Field investigation · Final report · Sep 22, 1987 · N2545S · Destroyed > After dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No… - [NTSB MIA87LA253](https://openairdocs.org/ntsb/MIA87LA253.md): Cessna TU206F · Tavernier, FL · Accident · No injuries · Limited investigation · Final report · Sep 22, 1987 · N8741Q · Destroyed > The acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,… - [NTSB CHI87LA217](https://openairdocs.org/ntsb/CHI87LA217.md): Piper PA-32R-300 · Hillsdale, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1987 · N8799E · Destroyed > Tkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were… - [NTSB SEA87LA191](https://openairdocs.org/ntsb/SEA87LA191.md): Cessna P210N · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1987 · N4500K · Substantial damage > The aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The… - [NTSB MIA87LA254](https://openairdocs.org/ntsb/MIA87LA254.md): Grumman G-164B · Bristol, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1987 · N6647Q · Substantial damage > The eng began losing power as the plt was en route to spray a field. He was unable to maintain altitude, dumped the load of chemicals & prepared for an emerg landing. While he was attempting to reach an open field, the acft collided with 100 foot trees, then… - [NTSB ANC87FA165](https://openairdocs.org/ntsb/ANC87FA165.md): Piper PA-31-310 · Eldred Rock, AK · Accident · 5 fatal · Field investigation · Final report · Sep 21, 1987 · CGPAC · Destroyed > The flt was clrd on an IFR flt fm whitehorse to juneau, via V-428 to chill intxn, then drct to juneau. Chill intxn was located on V-428, 36 mi south of haines NDB on a bearing of 146 deg. On reaching haines NDB, the plt cancelled his IFR clnc & contd under… - [NTSB ANC87LA162](https://openairdocs.org/ntsb/ANC87LA162.md): Cessna 206G · 100mi S.Kng Slm, AK · Accident · No injuries · Limited investigation · Final report · Sep 19, 1987 · N756TT · Substantial damage > The aircraft experienced an engine power loss while in cruise flight and subsequently undershot a lake during the emergency landing. Examination of the engine revealed the number 2 bearing was found completely disintegrated and missing from its seat. Evidence… - [NTSB NYC87FA260](https://openairdocs.org/ntsb/NYC87FA260.md): Boeing 737 · Philadelphia, PA · Accident · Serious injuries · Field investigation · Final report · Sep 18, 1987 · N318AU · No damage > The acft was in a holding pattern at 11,000' in an area of thunderstorms & turbulence. Although the seat belt sign was on, two passengers (pax) went to the aft lavatory. As one of the pax was waiting & the other was exiting the lavatory, the acft encountered… - [NTSB MIA87LA251](https://openairdocs.org/ntsb/MIA87LA251.md): Cessna 152 · Plant City, FL · Accident · No injuries · Limited investigation · Final report · Sep 18, 1987 · N67896 · Substantial damage > The student plt stated the acft was cruising at 3000 ft, when the eng lost pwr. She selected a fld & made an emerg lndg. Drg the lndg roll, the acft went thru a barbed wire fence, hit a ditch, nosed over & came to rest inverted. The acft had flown a total of… - [NTSB NYC87FA257](https://openairdocs.org/ntsb/NYC87FA257.md): Boeing 727-200 · Pittsburgh, PA · Accident · Serious injuries · Field investigation · Final report · Sep 17, 1987 · N774AL · No damage > While descending out of flt lvl 270 for lndg, usair flight 10 encountered light to moderate turbulence. Prior to this this encounter, the capt advised all passengers and cabin crew to remain seated and to engage their seatbelts. A similar announcement was… - [NTSB MIA87LA249](https://openairdocs.org/ntsb/MIA87LA249.md): Mooney M20J · Macclenny, FL · Accident · No injuries · Limited investigation · Final report · Sep 16, 1987 · N201UX · Substantial damage > While en route at 8000', the eng lost power & the plt obtained vectors for an emerg landing at an arpt with a grass strip. Drg the roll-out, the left wing tip hit a hay wagon near the end of the rwy, then the acft veered & struck a hangar. An exam of the… - [NTSB DEN87LA241](https://openairdocs.org/ntsb/DEN87LA241.md): Cessna TU206G · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Sep 16, 1987 · N756HD · Destroyed > While cruising at 10,500 ft with the power set at 28 inches map & 2350 RPM, the eng suddenly lost pwr & began knocking. The plt noted a rapid drop in oil pressure & saw a 3-inch hole in the top of the eng cowling. He attempted to land on a highway, but was… - [NTSB NYC87LA255](https://openairdocs.org/ntsb/NYC87LA255.md): Piper PA-28-140 · Emmaus, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1987 · N15793 · Substantial damage > Drg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=308 ## 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=307 --- 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.