# NTSB investigations: Approach NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 206 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC84LA026](https://openairdocs.org/ntsb/NYC84LA026.md): Piper PA-28 · Hackettstown, NJ · Accident · No injuries · Limited investigation · Final report · Nov 13, 1983 · N4720L · Substantial damage > According to the plt, he made an extended pattern to keep spacing on a slower acft that was landing. He stated that he went thru the landing checklist & everything seemed normal. On final apch, the acft got a little low, but when the throttle was advanced,… - [NTSB ANC84FA017](https://openairdocs.org/ntsb/ANC84FA017.md): Bell 212 · Nuiqsut, AK · Accident · Serious injuries · Field investigation · Final report · Nov 13, 1983 · N3910Y · Substantial damage > The search & rescue flt had been dispatched from barrow to an acft accident site adjacent to the Nuiqsut arpt. Accordingto the plt, upon arriving at Nuiqsut at 300 ft AGL the visibility was 2-3 mi. They lined up with snow machines for a visual apch to the… - [NTSB ANC84FA016](https://openairdocs.org/ntsb/ANC84FA016.md): Maule M-4-210C · Nuiqsut, AK · Accident · 1 fatal · Field investigation · Final report · Nov 13, 1983 · N51418 · Substantial damage > The acft crashed during the approach to land at a fogged in arpt at night. Sometime between 2045 and 2100 yst an acft was heard overflying the arpt at Nuiqsut. The villager who heard the acft stated the noise decreased as though the acft was landing. He then… - [NTSB LAX84FA058](https://openairdocs.org/ntsb/LAX84FA058.md): Beech 56TC · San Diego, CA · Accident · 4 fatal · Field investigation · Final report · Nov 12, 1983 · N911SC · Destroyed > During arrival, the plt was cleared for an ILS apch to rwy 28R. About 3 min later, he commenced a missed apch & requested another ILS to rwy 28. At that time, the ATC controller advised the plt that the 5 preceding acft had made ILS apchs & all had executed… - [NTSB LAX84LA052](https://openairdocs.org/ntsb/LAX84LA052.md): Schweizer SGS 2-33A · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Nov 11, 1983 · N1239S · Substantial damage > After receiving an aero tow to 3,000 ft MSL & being released 5 mi from the departure arpt, the plt thermaled for about 5 min. He then descended to 2,300 ft MSL & turned back toward the arpt. He encountered 'heavy sink' had insufficient altitude to reach the… - [NTSB ATL84LA042](https://openairdocs.org/ntsb/ATL84LA042.md): Cessna 152 · Leesburg, VA · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 1983 · N6470Q · Destroyed > At about 1,000 ft AGL after takeoff from rwy 17 the eng cowling opened on the left side & began flapping. The CFI took control & returned to the arpt on a downwind for rwy 17. When she saw that the acft was too low to make the field, she turned off the fuel,… - [NTSB NYC84LA025](https://openairdocs.org/ntsb/NYC84LA025.md): Piper PA-28-140 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Nov 9, 1983 · N1323T · Substantial damage > The acft collided with approach lights during a landing approach. The plt executed a go-around and landed without further incident. The acft was damaged in the collision. An accident report was not filed by the plt. - [NTSB LAX84FA034](https://openairdocs.org/ntsb/LAX84FA034.md): Cessna 172N · Woodland, CA · Accident · Minor injuries · Field investigation · Final report · Nov 9, 1983 · N76073 · Substantial damage > The aircrew reported that as the acft was entering a left downwind to land on rwy 34, sparks, fire & smoke were observed emanating from the eng compartment. Reportedly, the instructor plt (CFI) assumed command of the acft, shut down the eng & attempted to… - [NTSB SEA84FA017](https://openairdocs.org/ntsb/SEA84FA017.md): Cessna A185F · 4nm W Of Boring, OR · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1983 · N53079 · Destroyed > The acft collided with 3 major objects, a tree, a house and a motor home during an attempted go-around. The pilot had attempted a landing on a soft short dirt road near his home. The length of the road was 462 ft. he landed 74 ft short ofmarkers at the… - [NTSB FTW84FA045](https://openairdocs.org/ntsb/FTW84FA045.md): Cessna 310L · Bartlesville, OK · Accident · 2 fatal · Field investigation · Final report · Nov 8, 1983 · N3256X · Destroyed > The acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly… - [NTSB MKC84LA015](https://openairdocs.org/ntsb/MKC84LA015.md): Cessna T337E · Kimball, NE · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1983 · N1272M · Substantial damage > The acft collided with the ground in a pancake stall mush during a forced landing half a mile from the arpt. The rear engine had stopped in flt and the plt decided on a precautionary landing after restarting the engine. During the final approach to land the… - [NTSB DEN84FA021](https://openairdocs.org/ntsb/DEN84FA021.md): Convair 580 · Sioux Falls, SD · Accident · Serious injuries · Field investigation · Final report · Nov 7, 1983 · N7517U · Minor damage > The acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the… - [NTSB LAX84LA050](https://openairdocs.org/ntsb/LAX84LA050.md): Cessna 150H · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 1983 · N23268 · Substantial damage > The acft was flown from San Jose, CA to an arpt near sutter creek, CA where the plt landed. Before taking off on the return flt, he visually checked the fuel, and according to him, the fuel was within 1/2 inch from the top of the tanks. No fuel was added… - [NTSB ATL84LA039](https://openairdocs.org/ntsb/ATL84LA039.md): Rand KR-2 · Greer, SC · Accident · 1 fatal · Limited investigation · Final report · Nov 6, 1983 · N25134 · Destroyed > According to a witness, the plt began an apch to rwy 9, but made a go-around, then maneuvered to land on rwy 27. The witness stated that during the turn to final apch for rwy 27, the acft descended rapidly in a nose down attitude until it disappeared behind… - [NTSB MKC84LA013](https://openairdocs.org/ntsb/MKC84LA013.md): Cessna 172 · Osage Beach, MO · Accident · No injuries · Limited investigation · Final report · Nov 3, 1983 · N55461 · Substantial damage > The plt reported that while he was making an instrument apch in heavy rain, there was a parial loss of eng power. He applied carburetor heat, but reported that the eng still did not provide full power. He continued the vor/dme apch. When he saw the rwy, he… - [NTSB NYC84LA018](https://openairdocs.org/ntsb/NYC84LA018.md): Piper PA-28-181 · Prospectville, PA · Accident · No injuries · Limited investigation · Final report · Nov 1, 1983 · N39955 · Substantial damage > The pilot said that as he turned final he was too high and to the right of the rwy so he slipped the acft to the left to line up. The left fuel tank, which he was using was very low on fuel. The aprch was too high so he decided to go around. As the acft was… - [NTSB SEA84LA014](https://openairdocs.org/ntsb/SEA84LA014.md): Cessna 180 · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Oct 31, 1983 · N4448P · Substantial damage > The plt reported that during the preflt, he thought the fuel gauges read full. He did not visually check the fuel tanks. After takeoff, the acft was aprx 2500 ft & 4 mi from the arpt, when the plt realize the plane had very little fuel on board. He turned… - [NTSB MKC84LA012](https://openairdocs.org/ntsb/MKC84LA012.md): Cessna 150F · Garnett, KS · Accident · No injuries · Limited investigation · Final report · Oct 29, 1983 · N8127F · Substantial damage > The acft collided with trees during final approach to land on a local night flight. The weather was VMC with a 12 mile visibility reported. The pilot reported that during final approach for a full stop landing the acft struck the tops of some trees which… - [NTSB ATL84FA031](https://openairdocs.org/ntsb/ATL84FA031.md): Embraer EMB110-P1 · Blountville, TN · Accident · Minor injuries · Field investigation · Final report · Oct 29, 1983 · N764 · Substantial damage > The acft was landed with the landing gear up. Post accident tests of the landing gear extension system showed that all operations were normal except for the main gear down-lock indications. When the crew lowered the gear for landing the nose gear and right… - [NTSB CHI84FEE01](https://openairdocs.org/ntsb/CHI84FEE01.md): Popelka BD-5 · Sugar Grove, IL · Accident · No injuries · Final report · Oct 27, 1983 · N99555 · Substantial damage > The acft had received an inspection on 9/8/83, before it was disassembled & transported from California to Illinois. On 10/27/83, the plt took off on a flt from sandwich to aurora, IL. While on a final apch to land at aurora, after a throttle reduction, the… - [NTSB LAX84LA035](https://openairdocs.org/ntsb/LAX84LA035.md): Enstrom F28F · Chino, CA · Accident · No injuries · Limited investigation · Final report · Oct 26, 1983 · N8621X · Substantial damage > The acft experienced an in-flt fire on the downwind leg of the traffic pattern during a flt test following routine maintenance. The plt stated that while flying at 500 ft AGL in the traffic pattern smoke began entering the cockpit. Allgauges and systems… - [NTSB MKC84LA006](https://openairdocs.org/ntsb/MKC84LA006.md): Piper PA31-350 · Chillicothe, MO · Accident · No injuries · Limited investigation · Final report · Oct 24, 1983 · N62898 · Substantial damage > During arrival, the plt attempted to lower the gear, but only 2 of the 3 would indicate down & safe. The plt was unable to extend the left gear, so he continued flying for aprx 1 hr to burn down fuel, then intentionally landed with the gear up. The landing… - [NTSB DEN84LA014](https://openairdocs.org/ntsb/DEN84LA014.md): Piper PA-28-180 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Oct 24, 1983 · N9317J · Substantial damage > The plt reported that during arrival, he was receiving vectors for an ILS when he entered a descent from 9000 to 8500 ft MSL. He entered clouds during the descent & applied carburetor (carb) heat immediately before entering the clouds. He said that the acft… - [NTSB ATL84FA028](https://openairdocs.org/ntsb/ATL84FA028.md): Cessna TU206G · Brentwood, TN · Accident · 2 fatal · Field investigation · Final report · Oct 23, 1983 · N7338G · Destroyed > The acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with… - [NTSB NYC84LA012](https://openairdocs.org/ntsb/NYC84LA012.md): Piper PA-25 · West Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Oct 22, 1983 · N6247Z · Substantial damage > The pilot said that prior to departure he visually checked the tanks, found fuel in the tanks and the fuel indicator working properly. On final aprch at destination, the engine stopped and the acft landed in trees aprx 2 miles short of the rwy. During post… - [NTSB FTW84FA028](https://openairdocs.org/ntsb/FTW84FA028.md): Mitsubishi MU-2B · Patterson, LA · Accident · 3 fatal · Field investigation · Final report · Oct 20, 1983 · N444PA · Destroyed > While descending into the Patterson area on an IFR flt plan, the plt was cleared to hold & was advised that he would be the #2 acft for an approach to the Patterson arpt. A few winutes later the plt asked how long the delay would be. He subsequently stated he… - [NTSB ATL84LA025](https://openairdocs.org/ntsb/ATL84LA025.md): Bell 206B · Nr. Mcadams, MS · Accident · No injuries · Limited investigation · Final report · Oct 20, 1983 · N2183P · Substantial damage > The helicopter was being used on an aerial right-of-way-burning flt. The plt reported that due to the terrain & obstacles, his attention was to the outside of the helicopter during the burning operation. After completing the burning operation for that flt, he… - [NTSB LAX84LA016](https://openairdocs.org/ntsb/LAX84LA016.md): Piper PA-28-180 · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Oct 17, 1983 · N9560J · Substantial damage > The plt stated that prior to departing lake havasu city he visually inspected the fuel tanks & observed that both tanks were slightly less than 1/2 full. Based on this observation he thought the acft had 20-30 gals of fuel which would be sufficient for the… - [NTSB FTW84FA020](https://openairdocs.org/ntsb/FTW84FA020.md): Grumman FM-2 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Oct 14, 1983 · N12371 · Destroyed > The plt had purchased the wwii fighter about a week before the accident & it had been flown several hours during the last few days before the accident. The plt intended to shoot touch-&-go's on this flt. After takeoff the acft was observed to remain in the… - [NTSB FTW84LA012](https://openairdocs.org/ntsb/FTW84LA012.md): Cessna 152 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Oct 11, 1983 · N67176 · Destroyed > While still several miles from addison, TX, the acft encountered the leading edge of a thunderstorm. Both occupants stated the acft encountered wind shear. Reportedly, the wind shear was so severe that it forced the acft down & it contacted the ground. A few… - [NTSB MKC84LA004](https://openairdocs.org/ntsb/MKC84LA004.md): Cessna 152 · Clear Lake, IA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1983 · N69035 · Substantial damage > The student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing… - [NTSB ANC84LA003](https://openairdocs.org/ntsb/ANC84LA003.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Oct 9, 1983 · N4702B · Substantial damage > The acft collided with a row of small trees during the approach to a private airstrip 26 miles south of Anchorage, AK. The pilot stated he should have made a much higher approach to the airstrip. - [NTSB MIA84LA010](https://openairdocs.org/ntsb/MIA84LA010.md): Cessna 210L · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Oct 8, 1983 · N1778X · Substantial damage > The acft landed gear up after the landing gear could be extended in flight. The plt stated during the app to St. Augustine attempts to lower the gear were unsuccessful. The gear doors would open and the hydraulic pump was working butthe gear would not extend.… - [NTSB CHI84LA017](https://openairdocs.org/ntsb/CHI84LA017.md): Cessna 177 · Wonder Lake, IL · Accident · No injuries · Limited investigation · Final report · Oct 8, 1983 · N30168 · Substantial damage > The acft veered off the rwy and into a fence during a crosswind landing. The landing was on rwy 9 and the wind was from 021 degrees at 5 KTS gusting to 22 KTS. The pilot had applied power for a go-around but not in time to prevent the touchdown. Then the acft… - [NTSB ATL84FU001](https://openairdocs.org/ntsb/ATL84FU001.md): CGS Hawk · New Kent, VA · Accident · Serious injuries · Final report · Oct 6, 1983 · UNREG · Destroyed > The plt & his partner had completed building the ultralight vehicle several days prior to the accident. Since then, the plt had flown it aprx 8 hrs. A witness observed the vehicle circle the arpt in what he indicated was a normal left traffic pattern for rwy… - [NTSB MKC84FA002](https://openairdocs.org/ntsb/MKC84FA002.md): Cessna 182R · Springfield, MO · Accident · 4 fatal · Field investigation · Final report · Oct 5, 1983 · N5191E · Destroyed > At 2346 CDT, Kansas city center provided the 2251 CDT Springfield wx & advsed the plt to expect vectors for an apch to rwy 1. Vectors were provided until 0006;50 CDT, when center advised that radar contact was lost, 3 mi south of the outer marker compass… - [NTSB CHI84LA008](https://openairdocs.org/ntsb/CHI84LA008.md): Cessna 172P · Lancaster, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1983 · N63425 · Substantial damage > The acft landed in a plowed field during an off arpt forced landing after power loss in the traffic pattern for landing. The arpt manager reported that when he reached the acft the carburetor heat was off. The pilot said she thought she usedit but was not… - [NTSB FTW84LA006](https://openairdocs.org/ntsb/FTW84LA006.md): Aeronca 7AC · Rayne, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1983 · N82147 · Substantial damage > The acft stalled during final approach and landed hard on the dirt airstrip. The CFI said he yelled 'add power' when he felt the acft buffet. The student plt reacted by pulling off the power and the acrt stalled to ground contact. - [NTSB NYC83FA260](https://openairdocs.org/ntsb/NYC83FA260.md): Cessna 170B · Livermore Falls, ME · Accident · 3 fatal · Field investigation · Final report · Oct 1, 1983 · N2429D · Destroyed > The acft collided with trees during a go-around at night in a ground fog. The plt had called his wife and discussed the weather. He decided on an alternate arpt if the weather created problems. He had flown into bowman field many times at night and knew the… - [NTSB LAX84LA001](https://openairdocs.org/ntsb/LAX84LA001.md): Cessna 172 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N8426X · Substantial damage > The acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed… - [NTSB CHI84LA006](https://openairdocs.org/ntsb/CHI84LA006.md): Cessna 150 · Neenah, WI · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N22774 · Substantial damage > The plt was not lined up with the rwy during final & executed a go-around. He applied full power, retracted flaps, & theacft dropped onto the rwy nose gear first. The student plt had 5 hrs of dual & was no endorsed for solo flt. - [NTSB ATL83LA006](https://openairdocs.org/ntsb/ATL83LA006.md): Cessna 150G · Glenville, WV · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N2857S · Substantial damage > Ground fog started developing as the flt approached its destination. During the vor-b approach to rwy 16 the plt spotted the rwy lights about a mile out & set up on left base to the rwy. The plt turned final but drifted left of base. The plt stated that due… - [NTSB MKC83LA227](https://openairdocs.org/ntsb/MKC83LA227.md): Schweizer SGS-2-33A · Warrensburg, MO · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1983 · N7776S · No damage > The glider landed short of the rwy hitting a rough hump which was an old fence line. The glider bounced & landed hard on the rwy. The pax was hospitalized for 4 days for observation & treatment. - [NTSB ATL83LA387](https://openairdocs.org/ntsb/ATL83LA387.md): Hughes 269A · Moultrie, GA · Accident · No injuries · Limited investigation · Final report · Sep 27, 1983 · N8751F · Substantial damage > The acft landed hard during an autorotational forced landing after engine stoppage. This was an aerial application flt in VMC weather. Reportedly the engine quit at 100 ft AGL over trees while the plt was trying to land to reload. After the power loss a hard… - [NTSB LAX83FVD07](https://openairdocs.org/ntsb/LAX83FVD07.md): Pilatus PC-6/C-H2 · Lodi, CA · Accident · No injuries · Final report · Sep 26, 1983 · N361F · Substantial damage > According to the pilot as he made an approach to land he advanced the power lever to gain more thrust but he felt that the propeller went into beta range due to play in the propeller control linkage. At aprx 50 feet AGL and 200 feet from the end of the… - [NTSB SEA83LA207](https://openairdocs.org/ntsb/SEA83LA207.md): Hughes 500C · Pelican, AK · Accident · No injuries · Limited investigation · Final report · Sep 25, 1983 · N9243F · Destroyed > The acft collided with glassy water during an approach to land in marginal weather on a dark night. The acft was damagedand sank but the occupants escaped with no injuries. The acft sank in water that is over 60 ft deep. The pilot stated that he should not… - [NTSB NYC83FU011](https://openairdocs.org/ntsb/NYC83FU011.md): CGS Hawk · Huntington Mill, PA · Accident · 1 fatal · Final report · Sep 25, 1983 · UNREG · Destroyed > Witnesses observed the home built, ultralight vehicle as the plt was making a turn from downwind to final apch. They reported that the bank angle became steep as the plt was making a left turn. Subsequently, the vehicle entered a nose down attitude & crashed… - [NTSB NYC83LA257](https://openairdocs.org/ntsb/NYC83LA257.md): Cessna 152 · Batavia, NY · Accident · No injuries · Limited investigation · Final report · Sep 24, 1983 · N49008 · Substantial damage > The plt stated that he was landing at the end of rwy 28 & a gust of wind yawed the acft. He applied full throttle for a go around, but the acft climbed only about 20 ft, then stalled & crashed. He reported the wind was from 280 deg at 13, gusting 20 KTS. - [NTSB NYC83FNE05](https://openairdocs.org/ntsb/NYC83FNE05.md): I.C.A. Brasov IS28B2 "LARK" · North Canaan, CT · Accident · Serious injuries · Final report · Sep 24, 1983 · N87RW · Substantial damage > Two witnesses observed the glider on a downwind that was, in their estimation, lower than normal. One witness reported observing the spoilers extended. The plt stated he extended the flaps on downwind, but had not used the spoilers. Duringthe turn to base… - [NTSB FTW83LA439](https://openairdocs.org/ntsb/FTW83LA439.md): Maule M-4-220C · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 1983 · N40310 · Substantial damage > The plt took off on a local banner towing flt at 1232 CDT. At about 1510 CDT, he returned & dropped the banner. As he was circling to land, the eng lost power. Subsequently, the acft was damage during a forced landing just short of the rwy. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=207 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=206 --- 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.