# 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 313 of 718 · 35,885 cases ## Cases, newest first - [NTSB MKC87LA100](https://openairdocs.org/ntsb/MKC87LA100.md): Cessna 188 · Ottawa, KS · Accident · No injuries · Limited investigation · Final report · May 1, 1987 · N9858V · Substantial damage > The acft was returning from an aerial application flt when the fuel line to the fuel filter disconnected. During the forced landing, the acft ran into a fence. The eng had been installed 100 flt hrs prior to the accident. - [NTSB DCA87MA029](https://openairdocs.org/ntsb/DCA87MA029.md): Cessna 340A · Orlando, FL · Accident · 4 fatal · Class 1 · Major · Final report · May 1, 1987 · N8716K · 2 aircraft · Destroyed > The two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt… - [NTSB MKC87LA098](https://openairdocs.org/ntsb/MKC87LA098.md): Cessna 172F · Blythville, AR · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N8800U · Substantial damage > The eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The… - [NTSB MIA87LA151](https://openairdocs.org/ntsb/MIA87LA151.md): Beech 95-C55 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N54552 · Substantial damage > Flt experienced complete loss of power in both engines due to fuel exhaustion. While attempting a forced landing at an airport the aircraft touched down 200 feet short of the runway and then rolled up onto the runway. The aircraft was substantially damaged in… - [NTSB LAX87FA196](https://openairdocs.org/ntsb/LAX87FA196.md): Piper PA-28-181 · Newhall, CA · Accident · 1 fatal · Field investigation · Final report · Apr 30, 1987 · N8444A · Substantial damage > At about 1440 PDT, the non-instrument rated plt depd antioch CA, on a flt to burbank, CA. No known in-flt communicationswere made until the plt contacted TRACON at 1725 PDT. At that time, he rprtd inbound at 7500' & requested a special VFR clnc to the arpt.… - [NTSB NYC87DNC05](https://openairdocs.org/ntsb/NYC87DNC05.md): Piper PA-18-135 · Greenville, ME · Accident · Minor injuries · Final report · Apr 28, 1987 · N114 · Destroyed > The pilot was taking off from a lake during windy conditions. The aircraft stalled shortly after takeoff. The aircraft was about 60 feet above the surface. The nose dropped and the aircraft impacted the water. The pilot reported that there was turbulence… - [NTSB MKC87LA096](https://openairdocs.org/ntsb/MKC87LA096.md): Rotorway Executive · Gerald, MO · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N4891H · Substantial damage > The stu PIC was solo on a x-country flt when the eng backfired. The stu entered autorotation with low rotor RPM which accelerated the descent rate. The stu flared before touchdown but did not level the helo in time to land. The tailboom struck the gnd and the… - [NTSB FTW87IA108](https://openairdocs.org/ntsb/FTW87IA108.md): Canadair CL-600 · Denton, TX · Incident · No injuries · Incident investigation · Final report · Apr 28, 1987 · N600KC · Minor damage > The aircraft's right engine, while in flight, lost a blade from its fourth stage turbine wheel due to metal fatigue. This resulted in varying degrees of damage throughout the entire engine and caused the engine to shut itself down while climbing through… - [NTSB DEN87LA113](https://openairdocs.org/ntsb/DEN87LA113.md): Beech A24R · Beulah, WY · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N9784L · Substantial damage > The acft lost power during a normal climb on a personal trip. The private plt noticed a drop in fuel flow pressure and smelled fuel. The plt then selected boost pump on but the pressure stayed low. The plt elected to make a forced landing and selected a… - [NTSB LAX87LA191](https://openairdocs.org/ntsb/LAX87LA191.md): Beech 95-55 · Monterey, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1987 · N9711R · Substantial damage > Just after take-off, the cabin door opened in flight. The plt attempted to reland but was unsuccessful due to weather conditions. The plt was vectored to another arpt, however, the plt never climbed to the assigned alt and was never in radar contact. The plt… - [NTSB ATL87LA126](https://openairdocs.org/ntsb/ATL87LA126.md): Piper PA-24-250 · Pinehurst, NC · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1987 · N7136P · Destroyed > The pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He… - [NTSB SEA87LA085](https://openairdocs.org/ntsb/SEA87LA085.md): Cessna 172N · Ritter Butte, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1987 · N1935F · Destroyed > During a cross country flt the plt noticed that he was gradually losing his communications radio and navigational instruments. Shortly afterwards the plt noticed that the fuel gauges were quickly approaching empty. Since hostile terrain was ahead the plt… - [NTSB NYC87LA130](https://openairdocs.org/ntsb/NYC87LA130.md): Stinson 108 · Rumford Point, ME · Accident · Serious injuries · Limited investigation · Final report · Apr 25, 1987 · N9119K · Substantial damage > While circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts… - [NTSB MKC87LA091](https://openairdocs.org/ntsb/MKC87LA091.md): Beech V35B · N Little Rock, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1987 · N1718W · Destroyed > The acft was on a short ferry flt when the fuel pressure decreased and could not be restored. During the final apch of the forced landing on a city street, the acft struck a ground wire and fell to the street. Due to the intense fire that followed, the reason… - [NTSB MIA87LA147](https://openairdocs.org/ntsb/MIA87LA147.md): Piper J-3 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N25863 · Substantial damage > The owners rprtd the acft was stolen on 4/25/87. The non-certificated plt rprtd that he had taken the acft without permission. Drg flt, the eng lost power, & subsequently, the plt made a forced lndg in the everglades about 9 mi west of the tamiami arpt. He… - [NTSB FTW87FA102](https://openairdocs.org/ntsb/FTW87FA102.md): Cessna T210L · Lufkin, TX · Accident · Serious injuries · Field investigation · Final report · Apr 24, 1987 · N4637Q · Destroyed > The pilot reduced power and was descending for a VFR straight-in approach when the engine quit. The pilot had the selector on the left tank with 4 to 5 gallons of fuel remaining in this tank. During the descent the fuel tank outlet line became unported… - [NTSB SEA87LA083](https://openairdocs.org/ntsb/SEA87LA083.md): Cessna 150L · Twin Falls, ID · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1987 · N21922 · Destroyed > During descent from cruise for landing the engine momentarily ran rough and then quit. The pilot attempted to land onto a road but struck a telephone pole in flight. The aircraft then descended onto the ground nose first. No reason for the engine failure… - [NTSB MKC87FA087](https://openairdocs.org/ntsb/MKC87FA087.md): Piper PA-32-300 · Ogden, IA · Accident · 2 fatal · Field investigation · Final report · Apr 22, 1987 · N44626 · Destroyed > The airplane was equipped for IFR flight. The pilot was not instrument rated. The pilot had been briefed earlier that VFR flight was not recommended. The pilot did not update the weather for this flight. The front of the airplane was buried seven feet in the… - [NTSB LAX87LA188](https://openairdocs.org/ntsb/LAX87LA188.md): Cessna TU206B · Temecula, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1987 · N3835G · Substantial damage > During an aerial survey flight, while on final approach to the arpt, the engine began running rough then quit. The plt was unable to land the acft at the arpt, therefore, a nearby dirt road was selected. During the landing roll the acft collided with the… - [NTSB ATL87FA122](https://openairdocs.org/ntsb/ATL87FA122.md): Beech D-55 · Leesburg, GA · Accident · 1 fatal · Field investigation · Final report · Apr 22, 1987 · N478MP · Destroyed > During a return flight at night, the aircraft crashed in an open field. The aircraft impacted the ground in a nose low attitude. The impact displaced the wing assembly rearward perpendicularly through the rear spar assembly. Both engine and propeller… - [NTSB MKC87LA086](https://openairdocs.org/ntsb/MKC87LA086.md): Cessna 150 · West Memphis, AR · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N704UU · Substantial damage > The acft was flown 1.6 hrs on a previous flt since being topped off with fuel. At the end of 2 hrs and 11 mins, during the accident flt, the eng quit. The fuel tanks were found to be empty with no broken fuel lines. During the post accident exam, it was found… - [NTSB ATL87LA120](https://openairdocs.org/ntsb/ATL87LA120.md): Cessna R182 · Owensboro, KY · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N5496T · Destroyed > Plt in cruise flt at 5500 ft about 30 min after dep fm paducah when he noted a small amount of black smoke coming from top of panel. The rear seat pax noted flames in the panel at the same time. The plt noted his position in relation to Owensboro and… - [NTSB ATL87LA119](https://openairdocs.org/ntsb/ATL87LA119.md): Bell UH-1B · Clarksville, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 1987 · N46884 · Destroyed > The pilot lost tail rotor control in cruise flight after the tail rotor drive shaft separated. The tail rotor system had sustained previous damage about 4 years prior to this accident when, while being operated as a public use aircraft, the helicopter skidded… - [NTSB ATL87LA118](https://openairdocs.org/ntsb/ATL87LA118.md): Beech A23-19 · Huron, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1987 · N2370W · Substantial damage > Soon after takeoff the aircraft experienced a loss of power and made a forced landing 200 feet short of the runway. The pilot reported a loss of fuel pressure. The FAA reported that the fuel aboard the aircraft had the smell and appearance of auto fuel. The… - [NTSB MIA87IA141](https://openairdocs.org/ntsb/MIA87IA141.md): Bell 222U · Oxford, MS · Incident · No injuries · Incident investigation · Final report · Apr 20, 1987 · N222HX · Minor damage > The pilot executed a precautionary landing after hearing a loud bang and experiencing a loss of the number 1 engine. Post accident examination revealed that the power turbine wheel blades had failed, and the wheel parts logjammed and penetrated the engine… - [NTSB MIA87LA139](https://openairdocs.org/ntsb/MIA87LA139.md): Cessna 152 · Melbourne, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1987 · N24511 · Substantial damage > The student pilot experienced an engine failure in flight and landed the aircraft in a pasture. He then restarted the engine and took off, after take off the engine failed two times and he restarted it. The engine failed the third time and he could not start… - [NTSB CHI87DEM06](https://openairdocs.org/ntsb/CHI87DEM06.md): Navion A · Baldwin, MI · Accident · Serious injuries · Final report · Apr 19, 1987 · N4961C · Substantial damage > After beginning a level off at aprx 6000 ft, the acft engine stopped. During the forced landing the acft crashed in a heavily wooded area aprx 1/2 mile west of the arpt. An examination of the wreckage revealed that both wing tanks were empty and the… - [NTSB SEA87IA084](https://openairdocs.org/ntsb/SEA87IA084.md): Smith, Ted Aerostar Aerostar 601P · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Apr 17, 1987 · N90518 · Minor damage > Aprx 422 flt hrs bfr the flt, the smith Aerostar 601P was modified iaw machen STC SA980NW. Drg level off at 16,500' MSL,blistering & discoloration were noted on the #1 eng nacelle. The plt shut down & feathered the #1 eng, then returned to the departure arpt… - [NTSB MIA87LA143](https://openairdocs.org/ntsb/MIA87LA143.md): Cessna 177 · Pickens, MS · Accident · No injuries · Limited investigation · Final report · Apr 17, 1987 · N29652 · Substantial damage > The plt reported that during cruise flt the eng RPM began to drop. He then applied carb heat, however, the eng then quit. A forced landing was made in a pasture. During the landing roll, the acft collided with barbed wire and a fence post. Post crash… - [NTSB MIA87FA135](https://openairdocs.org/ntsb/MIA87FA135.md): Piper PA-28-181 · Florida City, FL · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1987 · N6505C · Destroyed > The student plt had been authorized by his CFI to conduct a solo x-country training flt under daytime VFR conditions. He departed key west at 0330 EDT on the return portion of the flt. Neither his CFI nor his employer could offer an explanation for the 15 hr… - [NTSB ATL87IA114](https://openairdocs.org/ntsb/ATL87IA114.md): Cessna 340 · Myrtle Beach, SC · Incident · No injuries · Incident investigation · Final report · Apr 17, 1987 · N25RF · Minor damage > Plt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached… - [NTSB MIA87IA134](https://openairdocs.org/ntsb/MIA87IA134.md): Piper PA-28RT-201 · Grant, FL · Incident · No injuries · Incident investigation · Final report · Apr 16, 1987 · N539FT · Minor damage > The CFI closed the throttle & announced a simulated forced ldg. Moments later, he advanced the throttle to clear the engine & found it would not respond. A forced ldg was then performed in a field without further incident. A subsequent exam of the engine,… - [NTSB FTW87FA096](https://openairdocs.org/ntsb/FTW87FA096.md): Bell 222 · Ben Wheeler, TX · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1987 · N1074T · Destroyed > All six lower studs on drive hub assembly failed due to fatique. This disconnected all cyclic and collective controls. Tail boom then separated due to severe vibrations. Helicopter then collided with ground and was destroyed by post crash fire. The plts flt… - [NTSB DEN87LA097](https://openairdocs.org/ntsb/DEN87LA097.md): Mclachlan Moni · Tooele, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1987 · N96606 · Substantial damage > The private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an… - [NTSB LAX87LA174](https://openairdocs.org/ntsb/LAX87LA174.md): Grumman G-44A · Ventura, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1987 · N32BB · Destroyed > During a local pleasure flight, the pilot had reduced power and descended to a lower altitude to take pictures of a sailboat race. At approximately 200 feet the pilot made a descending right turn, then leveled off. The aircraft stalled and the pilot lowered… - [NTSB SEA87LA079](https://openairdocs.org/ntsb/SEA87LA079.md): Hughes 369HS · Yakima, WA · Accident · No injuries · Limited investigation · Final report · Apr 11, 1987 · N8313F · Substantial damage > Six miles from the airport, at cruise, the engine ceased operating due to fuel exhaustion. The plt had noticed the low fuel warning light on 10 minutes prior to the engine failure but elected to continue his flight. Autorotation was made from 1,000 feet AGL… - [NTSB LAX87IA176](https://openairdocs.org/ntsb/LAX87IA176.md): de Havilland DHC-6-300 · Agana (Pacific Ocean) · Incident · No injuries · Incident investigation · Final report · Apr 11, 1987 · N96RA · No damage > As the aircraft approached its home airport at Agana, guam the captain passed out. The first officer took over the controls and landed the acft without further incident. The cause of the incapacitation was not determined. - [NTSB DEN87LA094](https://openairdocs.org/ntsb/DEN87LA094.md): Hughes 269C · Scoffield, UT · Accident · No injuries · Limited investigation · Final report · Apr 11, 1987 · N9676F · Substantial damage > The plt and his brother were on a long cross country flt, through mountainous terrain. After one hour of flt and while flying at 8,000 feet the plt noticed a change in engine noise and the acft had a partial power loss. The plt elected to autorotate to a snow… - [NTSB FTW87IA097](https://openairdocs.org/ntsb/FTW87IA097.md): Beech 58 · Bridgeport, TX · Incident · No injuries · Incident investigation · Final report · Apr 10, 1987 · N6681L · Minor damage > During cruise flight, the aircraft's right engine caught fire. The pilot shutdown the engine and feathered the prop, extinguishing the fire. The pilot declared an emergency with ATC and landed safely at an alternate airport, with only minor damage to the… - [NTSB CHI87DER05](https://openairdocs.org/ntsb/CHI87DER05.md): Piper PA-25 · Henning, MN · Accident · Minor injuries · Final report · Apr 10, 1987 · N6384Z · Substantial damage > After experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of… - [NTSB CHI87DER04](https://openairdocs.org/ntsb/CHI87DER04.md): Piper PA-32-260 · Pine Center, MN · Accident · Minor injuries · Final report · Apr 10, 1987 · N56721 · Substantial damage > After noticing a loss in oil pressure, the pilot initiated an emergency landing in a swamp. The aircraft impacted trees and received substantial damage. The pilot reported minor injuries. Subsequent investigation revealed that the oil sump contained several… - [NTSB MIA87LA136](https://openairdocs.org/ntsb/MIA87LA136.md): Cessna 172N · Big Pine Key, FL · Accident · No injuries · Limited investigation · Final report · Apr 9, 1987 · N6328D · Substantial damage > The plt stated that during cruise flt the eng began to run rough. He then attempted to solve the problem to no avail. Unable to maintain alt he elected to land the acft on a road. While taxiing, both wings collided with street signs. Post crash examination of… - [NTSB NYC87IA118](https://openairdocs.org/ntsb/NYC87IA118.md): de Havilland DHC-7-102 · Wrightstown, NJ · Incident · Minor injuries · Incident investigation · Final report · Apr 8, 1987 · N42RA · 2 aircraft · Minor damage > Ransom flt 444 (DHC-7) rprtd a near collision with USAF C-141 (gleek 41) as flt 444 was at 5000' & gleek 41 was clbg to 7500' fm a combat aircrew training (cat) mnvr. Flt 444 was under IFR ctl of mcguire afb rapcon; gleek 41 was VFR, rcvg radar adzys fm… - [NTSB DEN87LA088](https://openairdocs.org/ntsb/DEN87LA088.md): Cessna 152 · Milford, UT · Accident · No injuries · Limited investigation · Final report · Apr 7, 1987 · N67880 · Substantial damage > N67880 experienced VOR receiver failure during a flt from ogden, UT to st. george, UT. The plt diverted to Milford, UT and another plt checked the receiver which functioned on the ground. The flt then departed Milford en route to st. george. Shortly after… - [NTSB CHI87DEP03](https://openairdocs.org/ntsb/CHI87DEP03.md): Erickson Sonerai 2L · Algoma, WI · Accident · No injuries · Final report · Apr 7, 1987 · N131DE · Destroyed > While in normal cruise flight the crankshaft failed at the propeller flange and the propeller departed the aircraft. The pilot executed a forced landing to a farm field. He was unable to flare successfully and lost control during landing. - [NTSB CHI87LA108](https://openairdocs.org/ntsb/CHI87LA108.md): Cessna 150H · Tinley Park, IL · Accident · No injuries · Limited investigation · Final report · Apr 6, 1987 · N50305 · Destroyed > Approximately 3 miles short of the destination arpt the plt stated that the engine quit. The acft was lined up with a road but due to heavy traffic the plt elected to stall the acft into nearby trees. Examination of the acft by the FAA following the accident… - [NTSB SEA87LA075](https://openairdocs.org/ntsb/SEA87LA075.md): Verbeek Rotorway · Redmond, WA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N32415 · Substantial damage > The plt stated that while at cruise the acft developed a vibration and noise, followed by a power los. The plt then entered into an autorotation and landed onto a rough field. The acft touched down hard and then rolled onto its side. During engine inspection… - [NTSB MKC87FA067](https://openairdocs.org/ntsb/MKC87FA067.md): Balloon Works Firefly 6 · Kansas City, MO · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1987 · N3695B · Substantial damage > The pilot stated that lift-off and climbout were normal but, shortly thereafter, the fuel pilot light began to fail continuously until the burner flamed out. The passengers were briefed and the chase vehicle was contacted by cb radio before the plt climbed up… - [NTSB MIA87LA128](https://openairdocs.org/ntsb/MIA87LA128.md): Piper PA-18-125 · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N9663H · Substantial damage > The plt reported that while towing a banner aprx 200-300 yards offshore at an alt of aprx 500 ft the eng sputtered, then quit. Attempts to restart it were unsuccessful. The banner was then released & the acft was ditched in the ocean. Post crash examination… - [NTSB LAX87LA169](https://openairdocs.org/ntsb/LAX87LA169.md): Cessna 182Q · Needles, CA · Accident · 2 fatal · Limited investigation · Final report · Apr 5, 1987 · N4828N · Destroyed > A Cessna 182Q collided with an unmarked 50 ft high cable over the Colorado river. The acft was observed flying below the level of the cable rocking its wings to boaters and sunbathers. One witness stated that the acft 'buzzed us, so low, I actually ducked,… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=314 ## 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=313 --- 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.