# 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 308 of 718 · 35,885 cases ## Cases, newest first - [NTSB ATL87LA259](https://openairdocs.org/ntsb/ATL87LA259.md): Cessna 150G · Concord, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1987 · N2280J · Destroyed > While on climbout, the stu plt switched radios to the dest UNICOM freq. Unable to contact anyone on that freq, the departure arpt freq was reselected. No contact was established on this freq so the stu plt attempted to rtrn to the arpt. The haze was very… - [NTSB ANC87LA159](https://openairdocs.org/ntsb/ANC87LA159.md): Piper PA-18 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1987 · N4370A · Substantial damage > The engine stopped producing power but continued to windmill. The pilot was able to glide to a gravel bar and intentionally groundlooped to avoid hitting obstructions. The pilot stated he believed the aircraft ran out of fuel. - [NTSB NYC87LA253](https://openairdocs.org/ntsb/NYC87LA253.md): Cessna 172D · Scottdale, PA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1987 · N2467U · Substantial damage > During a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to… - [NTSB LAX87FA337](https://openairdocs.org/ntsb/LAX87FA337.md): Piper Aerostar 601P · Corona, CA · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1987 · N902RG · Destroyed > The airplane was refueled before it dept on the accd flight; the pilot did not supervise the fueling. Shortly after takeoff, the plt advised the ontario dept controller that both engines were experiencing a power loss and that he suspected jet fuel… - [NTSB NYC87FA250](https://openairdocs.org/ntsb/NYC87FA250.md): Piper PA-28-236 · Gaylordsville, CT · Accident · 1 fatal · Field investigation · Final report · Sep 12, 1987 · N2186B · Destroyed > The pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air… - [NTSB FTW87FA214](https://openairdocs.org/ntsb/FTW87FA214.md): Beech 58P · Austin, TX · Accident · 4 fatal · Field investigation · Final report · Sep 12, 1987 · N1158T · Destroyed > The plt rcvd a full wx briefing at 0540 CDT & a wx update at 0737 when he filed an IFR flt plan. The flt was without incident with a final cruise alt of 16,000' until 1055:43, when the plt reqd a 'left turn for deviation.' About 3 min later, the ctlr noticed… - [NTSB CHI87LA211](https://openairdocs.org/ntsb/CHI87LA211.md): Cessna 172K · Jefferson, WI · Accident · No injuries · Limited investigation · Final report · Sep 12, 1987 · N84352 · Substantial damage > The aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.… - [NTSB NYC87FA249](https://openairdocs.org/ntsb/NYC87FA249.md): Piper PA-28-180 · Riverhead, NY · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1987 · N15917 · Destroyed > The Piper PA-28-180 experienced a power loss due to fuel exhaustion while flying over the long island sound. The pilot was unable to reach shore prior to ditching. The ditching was successful and both occupants exited the aircraft without injuries. After… - [NTSB LAX87LA333](https://openairdocs.org/ntsb/LAX87LA333.md): Aeronca Champ 7AC · Victorville, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1987 · N85022 · Substantial damage > While climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the… - [NTSB ATL87FA255](https://openairdocs.org/ntsb/ATL87FA255.md): Cessna 402C · Atlanta, GA · Accident · Serious injuries · Field investigation · Final report · Sep 11, 1987 · N4630N · Minor damage > During climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.… - [NTSB DEN87FA234](https://openairdocs.org/ntsb/DEN87FA234.md): Piper PA-12-150 · Anaconda, MT · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1987 · N7695H · Destroyed > Both plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently… - [NTSB FTW87LA212](https://openairdocs.org/ntsb/FTW87LA212.md): Cessna 152 · Roby, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1987 · N4868B · Substantial damage > After aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on… - [NTSB DEN87FA231](https://openairdocs.org/ntsb/DEN87FA231.md): Cessna 310J · Delta, UT · Accident · Serious injuries · Field investigation · Final report · Sep 7, 1987 · N3037L · Substantial damage > Plt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when… - [NTSB NYC87FA244](https://openairdocs.org/ntsb/NYC87FA244.md): Piper PA-28-235 · Altoona, PA · Accident · 2 fatal · Field investigation · Final report · Sep 6, 1987 · N8692W · Destroyed > The aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near… - [NTSB FTW87LA211](https://openairdocs.org/ntsb/FTW87LA211.md): Cessna 152 · College Station, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1987 · N48140 · Substantial damage > The plt was on a x-country flt from addison to College Station, TX, but diverted to livingston, TX, due to 'time constraint.' The arpt at livingston was unattended. At aprx 1615 CDT, he took off & contd to College Station. However, during the flt, he became… - [NTSB ANC87FA146](https://openairdocs.org/ntsb/ANC87FA146.md): Cessna U206E · Harding Glacier, AK · Accident · 2 fatal · Field investigation · Final report · Sep 6, 1987 · N9407G · Substantial damage > The private pilot and his non-pilot adult male passenger were flying from modesto, CA, to soldotna, AK, for a hunting trip. The pilot, who had approximately 164 hours total flight time at the time of the accident, and who had no prior flying experience in… - [NTSB NYC87LA246](https://openairdocs.org/ntsb/NYC87LA246.md): Piper PA-28 · Harrisburg, PA · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N3023M · Substantial damage > The aircraft engine lost power while descending for a landing. The plt stated that when he advanced the throttle the engine quit completely. During lndg alongside a turnpike, the nose wheel collapsed and the prop was damaged. Investigation revealed that the… - [NTSB LAX87LA324](https://openairdocs.org/ntsb/LAX87LA324.md): Cessna 172N · Lee Vining, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1987 · N6122G · Destroyed > While flying over mountainous terrain. The pilot inadvertently followed the wrong road & went into a box canyon area. He stated the visibility was about 5 miles & he did not see the upcoming rising elevation. Eventually, he got into a situation were the acft… - [NTSB FTW87FA208](https://openairdocs.org/ntsb/FTW87FA208.md): Cessna 208 · Bulverde, TX · Accident · Minor injuries · Field investigation · Final report · Sep 5, 1987 · N807LA · Substantial damage > After leveling at 5500', the standby power annunciator light illuminated, followed by loss of oil pressure. The plt turned back toward the arpt, but there was a progressive loss of eng power & the prop went to a feathered psn. Drg an emerg landing at night,… - [NTSB CHI87LA203](https://openairdocs.org/ntsb/CHI87LA203.md): Cessna 152 · New Lenox, IL · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N67447 · Substantial damage > The accident occurred on a local training flight. At 3500 ft MSL the eng failed. The student plt landed at a near-by arpt but bounced on touchdown, veered off the rnwy and nosed over. Eng exam disclosed broken primary venturi in carb. - [NTSB BFO87FA062](https://openairdocs.org/ntsb/BFO87FA062.md): Cessna 172P · Cabin, WV · Accident · 2 fatal · Field investigation · Final report · Sep 5, 1987 · N65721 · Destroyed > The plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to… - [NTSB DEN87FA230](https://openairdocs.org/ntsb/DEN87FA230.md): Cessna 170B · Cedar City, UT · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1987 · N3541D · Destroyed > While on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon. - [NTSB DEN87DTE05](https://openairdocs.org/ntsb/DEN87DTE05.md): Piper PA-25-235 · Center, CO · Accident · No injuries · Final report · Sep 4, 1987 · N6796Z · Destroyed > The plt reported that the eng lost power while the acft was en route to spray a field. There was no suitable terrain for a forced landing and the plt landed the aircraft in a soft, cultivated field and nosed over. Examination of the eng revealed burned and… - [NTSB ATL87DEI12](https://openairdocs.org/ntsb/ATL87DEI12.md): Tomishin W-8 · Painesville, OH · Accident · No injuries · Final report · Sep 4, 1987 · N3992A · Substantial damage > The plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the… - [NTSB NYC87LA245](https://openairdocs.org/ntsb/NYC87LA245.md): Piper PA-28-140 · Montgomeryville, PA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N596SP · Substantial damage > While climbing through about 1500' after takeoff, the engine began to lose power. The pilot turned back toward the airport, but subsequently all power was lost & the aircraft was damaged during a landing in a corn field. A post- accident examination revealed… - [NTSB LAX87LA323](https://openairdocs.org/ntsb/LAX87LA323.md): Cessna 140 · Gorman, CA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N224MK · Substantial damage > A Cessna 140 nosed over during the landing roll after a precautionary landing to a paved access road. The plt indicated that the oil pressure and oil temp began to drop for unknown reasons while in cruise flt. The plt stated he was unable to determine the… - [NTSB BFO87LA061](https://openairdocs.org/ntsb/BFO87LA061.md): Cessna 172 · Tappahannock, VA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N78505 · Substantial damage > The acft was at 1500 MSL when a 300 RPM loss of power occurred. The plt sighted a private landing strip and he decided to make a precautionary landing on it. During the landing roll on the 62 ft wide grass strip the l wing struck corn stalks in an adjacent… - [NTSB ANC87LA135](https://openairdocs.org/ntsb/ANC87LA135.md): Piper PA-12 · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Sep 3, 1987 · N4451M · Substantial damage > The pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong… - [NTSB NYC87IA258](https://openairdocs.org/ntsb/NYC87IA258.md): Beech 99 · Portland, ME · Incident · Minor injuries · Incident investigation · Final report · Sep 2, 1987 · N204BH · No damage > The acft was cruising at 2500 ft with no passengers on board. The co-pilot went into the cabin and noticed a loud hissing noise around the main cabin door. He checked the handle and locking pins and noticed the door was locked. He told the captain who… - [NTSB MIA87IA237](https://openairdocs.org/ntsb/MIA87IA237.md): Boeing 727-223 · Tampa, FL · Incident · Minor injuries · Incident investigation · Final report · Sep 2, 1987 · N844AA · Minor damage > During descent the B727 crew noted the fire warning light illuminate on the #1 engine. They discharged 2 fire bottles into the engine but the warning light remained illuminated. They declared an emergency and landed at their destination. An emergency… - [NTSB MIA87FA239](https://openairdocs.org/ntsb/MIA87FA239.md): Cessna 421 · Coral Springs, FL · Accident · 1 fatal · Field investigation · Final report · Sep 2, 1987 · N421DT · Destroyed > The acft had been abandoned in the Bahamas for aprx 7 months. A plt, with no known flt time in a Cessna 421, flew it to ft lauderdale. Except to avoid clds, he made the flt at a low alt & airspeed. When asked why, he said he was trying to save the engs. The… - [NTSB LAX87LA322](https://openairdocs.org/ntsb/LAX87LA322.md): Government Aircraft Fact Nomad 24A · Lanai, HI · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N37808 · Substantial damage > When the flt was aprx 15 mi west of Lanai on a cargo flt from honolulu to hilo, HI, the plt observed the fuel gauges oscillating erratically toward the low side. He diverted toward Lanai to refuel. However, when the flt was abt 9 mi westof Lanai, the left eng… - [NTSB CHI87LA200](https://openairdocs.org/ntsb/CHI87LA200.md): Aero Commander 690 · Appleton, WI · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N9168N · Substantial damage > The plt rprtd that after the acft was at cruise flt, there was a rapid loss of hydraulic pressure. He returned to the dep arpt, but was unable to get the left main gear to lock down. Subsequently, the left main gear collapsed when the acft was landed. An… - [NTSB ATL87FA257](https://openairdocs.org/ntsb/ATL87FA257.md): Beech V-35B · Hilton Head, SC · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1987 · N6591S · Destroyed > PIC said he had wx brief. Noted tstms ovr atlantic & fog at arpt. Stated he would hold ovr ocean until arpt clr. Acft track on radar was into area of tstms ovr ocean followed by mode c altitude deviations and loss of radar contact. Acft recovered from ocean.… - [NTSB LAX87LA320](https://openairdocs.org/ntsb/LAX87LA320.md): Cessna 172N · Sonora, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1987 · N737SL · Substantial damage > During a pleasure flt the engine suddenly lost partial power. The plt made a forced landing in a parking lot where the aircraft touched down and collided with a fence that borders the lot. The engine was inspected and test run for approx 20 minutes at… - [NTSB ATL87LA245](https://openairdocs.org/ntsb/ATL87LA245.md): Piper PA-25 · Myrtle Beach, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1987 · N6094Z · Substantial damage > After about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage… - [NTSB ANC87LA136](https://openairdocs.org/ntsb/ANC87LA136.md): Piper PA-18 · High Lake, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 1987 · N9775D · Substantial damage > The pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second… - [NTSB NYC87FA240](https://openairdocs.org/ntsb/NYC87FA240.md): Piper PA-28RT-201T · Kings Point, NY · Accident · 1 fatal · Field investigation · Final report · Aug 28, 1987 · N3025W · Destroyed > N3025W departed on a ferry flight with an unsecured, temporarily installed fuselage fuel tank. A computed c.g. at takeoff showed the aircraft about.9 inches aft of the aft limit. The aircraft had climbed to 7000 feet when the controller saw the aircraft… - [NTSB MKC87LA167](https://openairdocs.org/ntsb/MKC87LA167.md): Piper PA-28-140 · Hot Springs, AR · Accident · No injuries · Limited investigation · Final report · Aug 26, 1987 · N5683U · Substantial damage > The pilot fueled the aircraft with 20 gallons of 100LL for his flight to Hot Springs, AR. Forty miles from Hot Springs the left fuel tank indicated empty and the pilot switched to the right tank. Approximately 10 miles from Hot Springs, the engine quit and… - [NTSB MIA87LA233](https://openairdocs.org/ntsb/MIA87LA233.md): Ayres S2R-600 · Leland, MS · Accident · No injuries · Limited investigation · Final report · Aug 26, 1987 · N4002K · Substantial damage > While in cruise flight en route to a field for aerial application the engine lost power when the number one cylinder cracked between the spark plug holes. While maneuvering to land at a sod airstrip altitude could not be maintained and the left spray boom… - [NTSB ATL87LA241](https://openairdocs.org/ntsb/ATL87LA241.md): Cessna 172 · Baxley, GA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N4275F · Substantial damage > During a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at… - [NTSB DEN87FA226](https://openairdocs.org/ntsb/DEN87FA226.md): Cessna 172RG · Cubero, NM · Accident · 1 fatal · Field investigation · Final report · Aug 24, 1987 · N5247V · Destroyed > The plt rcvd a wx briefing prior to departure. VFR flt was not recommended by the briefer. N5247V departed at 2005 hrs and at 2200 hrs the plt radioed abq ARTCC that he was descending from 9000 ft to 7500 ft to avoid wx. ARTCC radar track was lost shortly… - [NTSB ANC87LA127](https://openairdocs.org/ntsb/ANC87LA127.md): Piper PA-18 · Merrill Pass, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1987 · N8288Z · Substantial damage > The aircraft engine failed in cruise flight. During the landing roll the airplane struck a ditch and nosed over. Examination of the aircraft and the statements from the pilot, revealed the aircraft ran out of fuel during the return trip to the airport. - [NTSB MIA87LA230](https://openairdocs.org/ntsb/MIA87LA230.md): Grumman American AA-5 · Vega Baja, PR · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N100UA · Substantial damage > The plt stated that he had descended from 4500 ft to get out of the clouds & at 1300 ft, the eng became rough. He stated the RPM dropped from 2300 to 1000. He also stated that he did not use carb heat prior to or during the descent. The plt stated that when… - [NTSB FTW87FA206](https://openairdocs.org/ntsb/FTW87FA206.md): Cessna U206G · Lissie, TX · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1987 · N4745U · 2 aircraft · Destroyed > The Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16… - [NTSB ATL87LA239](https://openairdocs.org/ntsb/ATL87LA239.md): Cessna 152 · Lewisburg, KY · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N5270B · Substantial damage > Student PIC flew solo x-country. About 30 minutes after dpting enroute stop engine quit. He rptd checking fuel prior to departure. Flt school policy was to refuel at enroute stop which was not done. Acft was landed in a field and hit a fence during landing… - [NTSB MIA87LA228](https://openairdocs.org/ntsb/MIA87LA228.md): North American AT-6D · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1987 · N3771M · Substantial damage > The plt stated that he was inbound to sandy creek airport when he heard a loud bang and lost power. On landing rollout in a field the aircraft hit some sod, flipped over & came to rest inverted. Post crash examination of the engine revealed an internal blower… - [NTSB SEA87LA173](https://openairdocs.org/ntsb/SEA87LA173.md): Cessna 172 · Burns, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1987 · N2007Y · Substantial damage > A loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil… - [NTSB MIA87LA227](https://openairdocs.org/ntsb/MIA87LA227.md): Cessna 182P · Highland Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 20, 1987 · N1591M · Substantial damage > The plt stated that they were at 1000 ft aprx 2 miles off shore en route to palm Beach international when the engine lost power & they ditched the acft in the ocean about 40 ft off the Beach. The salvage personnel stated that the left wing contained aprx 10… - [NTSB FTW87LA202](https://openairdocs.org/ntsb/FTW87LA202.md): Piper PA-28-181 · Bridgeport, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 1987 · N6895J · Substantial damage > The engine quit during cruise flight at 5500 feet MSL but restarted when the pilot switched fuel tanks. He then headed for the nearest airport which was at Bridgeport, TX. While on final approach for landing the engine stopped again and would not restart. A… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=309 ## 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=308 --- 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.