# 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 373 of 718 · 35,889 cases ## Cases, newest first - [NTSB FTW83FA108](https://openairdocs.org/ntsb/FTW83FA108.md): Beech A36TC · Addison, TX · Accident · 1 fatal · Field investigation · Final report · Feb 10, 1983 · N37365 · Destroyed > The non-instrument rated, student plt used another person's name while filing an instrument flt plan. When he contacted ground control for departure, he was advised that the arpt had just become IFR. After some confusion concerning canceling & filing flt… - [NTSB MKC83FA065](https://openairdocs.org/ntsb/MKC83FA065.md): Cessna TR182 · Garwin, IA · Accident · 2 fatal · Field investigation · Final report · Feb 9, 1983 · N6144T · Destroyed > During a briefing for a flt to western Oklahoma, the plt was advised that IMC wx was forcasted along the route. He changed his destination to waterloo, IA & was advised of IMC in that area also. While en route, the acft crashed in a field covered with snow.… - [NTSB LAX83FA096](https://openairdocs.org/ntsb/LAX83FA096.md): Aerospatiale AS 350 Astar · Pacoima, CA · Accident · No injuries · Field investigation · Final report · Feb 9, 1983 · N3605T · Substantial damage > The main rotor blades separated the tail boom during a forced landing following a total loss of power. The plt stated the acft was equipped with an experimental engine torque and temperature limiting device and this flt was to collect data concerning its… - [NTSB CHI83IA105](https://openairdocs.org/ntsb/CHI83IA105.md): Gates Learjet LR-25 · Wilkes Barre, PA · Incident · No injuries · Incident investigation · Final report · Feb 9, 1983 · N4PN · No damage > Acft autopilot/autotrim system failed to disengage due to a malfunction of the engage switch which occurred only in cold environment. - [NTSB LAX83FA095](https://openairdocs.org/ntsb/LAX83FA095.md): Cessna T210N · Gorman, CA · Accident · 4 fatal · Field investigation · Final report · Feb 7, 1983 · N1244U · Destroyed > The plt received a wx briefing before takeoff, but did not file a flt plan. Aprx 35 min later, the acft was observed flying low over interstate highway 5 near the Gorman VOR & tejon pass. A patrolman that saw the acft estimated that it crossed aprx 25 ft over… - [NTSB FTW83LA105](https://openairdocs.org/ntsb/FTW83LA105.md): Cessna T210M · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Feb 7, 1983 · N732KS · Substantial damage > The plt received a weather briefing & filed an IFR flt plan prior to the flt. Reportedly, the fss specialist did not advise the plt of a pertinent forcast for moderate icing in clouds & precipitation up to 18,000 ft. the forecast was available to the… - [NTSB DEN83FA056](https://openairdocs.org/ntsb/DEN83FA056.md): Navion G · Leadville, CO · Accident · 2 fatal · Field investigation · Final report · Feb 7, 1983 · N91774 · Destroyed > The acft crashed into a mountain at the 12000 ft level in bad weather during a cross-country flt. Before takeoff the pilot had been advised of adverse weather enroute with VFR flt not recommended. He said he would fly out to check the weather and return if it… - [NTSB LAX83FA091](https://openairdocs.org/ntsb/LAX83FA091.md): Cessna 177RG · Las Vegas, NV · Accident · 3 fatal · Field investigation · Final report · Feb 6, 1983 · N1547H · Destroyed > The acft collided with a mountain during a night cross-country. The weather was VMC at takeoff but became IMC later nearthe mountains. A VFR flight plan was filed but never opened. The pilot continued flight into an area of known IMC conditions. He had… - [NTSB ATL83FA099](https://openairdocs.org/ntsb/ATL83FA099.md): Piper PA-28-180 · Lascassas, TN · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1983 · N8366W · Destroyed > The acft crashed in a field about 8 miles after a night takeoff in IMC weather. No flt plan was filed. The pilot had received several briefings. During his final briefing the possibility of icing was discussed. The takeoff time was ABOUT2030 hrs. The… - [NTSB NYC83FA062](https://openairdocs.org/ntsb/NYC83FA062.md): Piper PA-28-151 · Newbury, MA · Accident · No injuries · Field investigation · Final report · Feb 5, 1983 · N6845J · Substantial damage > After takeoff, the plt leveled at 2500 ft & after cruising for about 20 min, descended to 1500 ft MSL. Shortly after leveling at 1500 ft, there was a slight reduction in engine RPM. The plt stated that he applied carburetor heat, but the RPM continued to… - [NTSB ATL83LA096](https://openairdocs.org/ntsb/ATL83LA096.md): Cessna 150M · Greensboro, NC · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1983 · N3032V · Destroyed > The acft was damaged during a forced landing in a plowed field after the engine quit. The student pilot was on a solo cross-country and had landed once during the flight but did not refuel the acft. The student had increased his flight time on the 1st leg of… - [NTSB SEA83FA052](https://openairdocs.org/ntsb/SEA83FA052.md): Maule M-5-220C · Near Asotin, WA · Accident · Serious injuries · Field investigation · Final report · Feb 4, 1983 · N51599 · Destroyed > While flying in the vicinity of the snake river, the engine lost power. Emergency landing areas were limited. The plt elected to land on a road Near the river. While in a right turn to line up with the road, the acft collided with a single power line, then… - [NTSB LAX83FA090](https://openairdocs.org/ntsb/LAX83FA090.md): Beech 58 · Indio, CA · Accident · 2 fatal · Field investigation · Final report · Feb 4, 1983 · N1586W · Destroyed > The plt & passenger had flown from bermuda dunes to yucca valley, CA on a business flt. Reportedly, they terminated their business early because wx was building over the mountains between yucca valley & bermuda dunes. While on the return trip, the plt… - [NTSB CHI83IA103](https://openairdocs.org/ntsb/CHI83IA103.md): Embraer EMB-110 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Feb 4, 1983 · N1356P · Minor damage > The acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the… - [NTSB NYC83FA060](https://openairdocs.org/ntsb/NYC83FA060.md): Aero Commander 680FL P · Sunbury, PA · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1983 · N12LF · Destroyed > At aprx 0928 EST, the plt obtained a fss wx briefing by telephone. He was briefed on conditions of low ceilings, fog, light rain, drizzle, snow & blowing snow along his route. However, he did not ask about icing conditions & the briefing did not include a flt… - [NTSB MKC83FA060](https://openairdocs.org/ntsb/MKC83FA060.md): Piper PA-28R-201T · Salem, MO · Accident · 1 fatal · Field investigation · Final report · Jan 31, 1983 · N99SJ · Destroyed > During the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt… - [NTSB SEA83LA046](https://openairdocs.org/ntsb/SEA83LA046.md): Cessna 150H · Yakima, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1983 · N22824 · Destroyed > Aircraft lost power during night cross-country and was landed on a highway. During landing the aircraft collided with a pickup truck a tree and a fence. The aircraft had run out of fuel. - [NTSB CHI83LA095](https://openairdocs.org/ntsb/CHI83LA095.md): Cessna 140 · Richview, IL · Accident · No injuries · Limited investigation · Final report · Jan 29, 1983 · N2377V · Substantial damage > The acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no… - [NTSB LAX83LA084](https://openairdocs.org/ntsb/LAX83LA084.md): Cessna 210L · Ocotillo Wells, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1983 · N210DK · Substantial damage > The acft was on a night sightseeing flight when the engine quit. The fuel selector was on the left tank and the left tank was empty. The pilot switched tanks but the engine did not restart. The acft impacted the desert in a skid with left wing low. Post… - [NTSB LAX83FA083](https://openairdocs.org/ntsb/LAX83FA083.md): Mitsubishi MU-2B-60 · Scottsdale, AZ · Accident · 6 fatal · Field investigation · Final report · Jan 28, 1983 · N440MA · Destroyed > The acft diverted from Scottsdale AZ to a flt course to sedona because of thunderstorms & high winds at Scottsdale, but after a radio conversation with Scottsdale twr, the plt decided to reroute to land at Scottsdale. The plt did not read back the weather… - [NTSB DEN83LA054](https://openairdocs.org/ntsb/DEN83LA054.md): Cessna 207 · Jamestown, ND · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1983 · N1597U · Substantial damage > While en route, the plt encountered freezing rain and climbed to aprx 3500 ft to be on top of all weather. When he throttled back, the engine began surging and would not produce enough power for level flight. The pilot knew that the ground level in that area… - [NTSB DEN83FA053](https://openairdocs.org/ntsb/DEN83FA053.md): Cessna T210N · Minersville, UT · Accident · 4 fatal · Field investigation · Final report · Jan 28, 1983 · CGRFV · Destroyed > The acft impacted in a near vertical attitude near the top of a mountain & adjacent to a highway where witnesses had observed the acft flying at very low altitues under a low ceiling. There was no record of a preflight wx briefing or inflight advisories. No… - [NTSB LAX83FA438](https://openairdocs.org/ntsb/LAX83FA438.md): Piper PA-32R-301 · Redlands, CA · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1983 · N8139D · Destroyed > At 0638 PST, the plt received a wx briefing on a flt to sacramento, CA, and was advised that VFR was not recommended. At 0800, he received another briefing & filed a VFR flt plan to palm springs, CA. During flt, he advised palm springs tower that if he could… - [NTSB MIA83FA064](https://openairdocs.org/ntsb/MIA83FA064.md): Piper PA-31 · Miami Lakes, FL · Accident · No injuries · Field investigation · Final report · Jan 26, 1983 · N9003Y · Destroyed > The plt & a prospective buyer/passenger were on a local demonstration flt. Prior to this flt, the acft had been parked for nearly 1 yr. Since the last annual inspection on 1/12/82, it had been flown only 66 hrs. During the preflt, the plt found the fuel tanks… - [NTSB SEA83FYM04](https://openairdocs.org/ntsb/SEA83FYM04.md): Mooney M20K · Dufur, OR · Accident · No injuries · Final report · Jan 24, 1983 · N97429 · Substantial damage > The aircraft collided with an irrigation pipe line and fence during rollout of a forced landing after engine failure. The engine stopped while the aircraft was cruising en route. The pilot remained in radio contact throughout the emergency and landed in a… - [NTSB LAX83IA080](https://openairdocs.org/ntsb/LAX83IA080.md): Boeing 767-231 · San Diego, CA · Incident · No injuries · Incident investigation · Final report · Jan 24, 1983 · N602TW · Minor damage > While descending thru 12,000 ft aprx 40 mi east of San Diego, CA, the left overwing evacuation slde annunciator light illuminated. The slide separated from the acft aprx 7 mi east of the arpt. No flt control problems were noted. Integrity of the sys was found… - [NTSB CHI83FA089](https://openairdocs.org/ntsb/CHI83FA089.md): Cessna 172 · Rockford, IL · Accident · No injuries · Field investigation · Final report · Jan 24, 1983 · N61558 · Destroyed > The acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted… - [NTSB LAX83LUQ01](https://openairdocs.org/ntsb/LAX83LUQ01.md): Cessna 152 · Castaic, CA · Accident · 2 fatal · Final report · Jan 23, 1983 · N25061 · Destroyed > About 3 hrs after he took off, the plt called burbank tower & advised he was lost & was at 4000 ft, heading southbound. Tower personnel advised him to contact burbank apch control on 121.5, but received no acknowledgement. A few minutes later, a helicopter… - [NTSB CHI83FA090](https://openairdocs.org/ntsb/CHI83FA090.md): Piper PA-22-20 · Siren, WI · Accident · 2 fatal · Field investigation · Final report · Jan 23, 1983 · N3925P · Destroyed > Witnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg… - [NTSB FTW83FA097](https://openairdocs.org/ntsb/FTW83FA097.md): Bell 206L-3 · Goliad, TX · Accident · 2 fatal · Field investigation · Final report · Jan 21, 1983 · N3899U · Destroyed > The helicopter collided with trees and the ground in an attempt to reverse directions at low alt & at night after encountering weather. The plt had received a weather briefing and knew the weather was bad with low ceilings and fog. Heradioed he could make it… - [NTSB ATL83FLJ01](https://openairdocs.org/ntsb/ATL83FLJ01.md): Piper PA-28-140 · Robersonville, NC · Accident · 3 fatal · Final report · Jan 20, 1983 · N98302 · Destroyed > The acft collided with trees during an attempted emergency landing. The acft was 5 miles form an airport. The pilot had called on UNICOM and said he was lost and had partial power loss. He asked if anyone could hear him and he didnot believe he could make the… - [NTSB CHI83FA086](https://openairdocs.org/ntsb/CHI83FA086.md): Piper PA-32-300 · Monroe, WI · Accident · Minor injuries · Field investigation · Final report · Jan 19, 1983 · N5818F · Destroyed > While cruising at 4,000 ft MSL the eng quit. During a forced landing on rolling farm terrain both main landing gear separated. The acft then slid through a barbed wire fence & caught fire. Metallurgical examination revealed a fatigue failure of the idle set… - [NTSB LAX83LA074](https://openairdocs.org/ntsb/LAX83LA074.md): Aero Commander 500 · Dixon, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1983 · N6239B · Substantial damage > Reportedly, the acft was on an air taxi cargo flt, operated by air express, hayward, CA. The acft reportedly departed reno, NV without a flt plan for a flt to sacramento & hayward, cal. While en route, the acft had an electrical failure. The plt stated that… - [NTSB CHI83LA085](https://openairdocs.org/ntsb/CHI83LA085.md): Bell 206B · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Jan 17, 1983 · N59426 · Substantial damage > The Bell 206 helicopter experienced fuel exhaustion during approach for landing at a helipad. During autorotation the pilot moved left to avoid a pickup truck on the off ramp of I-75 and collided with a light pole at about 10 feet AGL. The aircraft yawed… - [NTSB MIA83LA060](https://openairdocs.org/ntsb/MIA83LA060.md): Cessna 336 · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Jan 16, 1983 · N1737Z · Substantial damage > The acft ditched in shallow water 1/2 mi south of Key Largo, FL while on a flight from zephyrhills, FL to marathon FL. On 1/13 a flt plan was filed for the acft for a flt from kingston jamaica to tampa FL. It departed kinston at 0810 with ETA tampa at 1610.… - [NTSB CHI83LA084](https://openairdocs.org/ntsb/CHI83LA084.md): Cessna 182 · Wheaton, IL · Accident · No injuries · Limited investigation · Final report · Jan 16, 1983 · N3318F · Substantial damage > While in cruise flight at 2500' AGL the carburetor ice warning light came on. The pilot applied carburetor heat and the light went out. After the light went out the pilot returned the heat to 'off.' The pilot repeated the above sequence and when the light… - [NTSB CHI83LA083](https://openairdocs.org/ntsb/CHI83LA083.md): Cessna 150 · Campbell, MN · Accident · No injuries · Limited investigation · Final report · Jan 16, 1983 · N9218U · Substantial damage > The pilot made a forced landing on a country road during a cross-country flight. During the ground roll the acft left the road and collided with a ditch collapsing the nose gear. The two occupants were not injured. The pilot started this flight the previous… - [NTSB LAX83LA072](https://openairdocs.org/ntsb/LAX83LA072.md): Piper PA-38-112 · Barstow, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 1983 · N2422A · Substantial damage > The acft was damaged in an off arpt precautionary landing after an encounter with weather. The student pilot had left onthe second leg of a cross-country flt without checking the weather over the remaining route. Enroute he decided the weather was bad and… - [NTSB FTW83FA092](https://openairdocs.org/ntsb/FTW83FA092.md): Cessna 150 · Midland, TX · Accident · No injuries · Field investigation · Final report · Jan 15, 1983 · N45528 · Substantial damage > The acft nosed over during an emergency landing after an engine failure. The landing was made off arpt in a cotton fieldthe nose gear dug in and the acft nosed over. The engine was torn down after the accident and it was discovered that the #3 connecting rod… - [NTSB CHI83LA082](https://openairdocs.org/ntsb/CHI83LA082.md): Maule M4-180C · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Jan 15, 1983 · N2062U · Substantial damage > The aircraft experienced power failure during slow descent to enter traffic pattern after a test hop. A landing was accomplished in an open snow covered field. During the roll-out in the 18 inch deep snow the aircraft nosed over. Preliminary examination of… - [NTSB CHI83LA081](https://openairdocs.org/ntsb/CHI83LA081.md): Cessna 172 RG · Green Bay, WI · Accident · Serious injuries · Limited investigation · Final report · Jan 14, 1983 · N9916B · Substantial damage > The acft collided with the ground during an ILS approach. The weather was IMC at the time and an IFR flt plan was filed. The pilot was instrument rated and had received a weather briefing which forecast icing and freezing drizzle. The pilot told the weather… - [NTSB ANC83FA032](https://openairdocs.org/ntsb/ANC83FA032.md): Bell 206B · Cordova, AK · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1983 · N74PR · Destroyed > The helicopter was on a rescue/recovery flt for the Alaska state troopers with the plt & a state trooper on board. They departed in variable wx conditions to rescue the plt of another acft. Reportedly, snow was falling in the search area & the winds were… - [NTSB MIA83LA070](https://openairdocs.org/ntsb/MIA83LA070.md): Piper PA-32-260 · Culebra, PR · Accident · No injuries · Limited investigation · Final report · Jan 11, 1983 · N20FH · Destroyed > The flight had departed st. thomas, VI at 0900 on a VFR flight plan to roosevelt roads after discharging passengers in st. thomas. While enroute in cruise at 1800 MSL the engine failed. He turned toward the island of Culebra and when all efforts to restart… - [NTSB FTW83IA084](https://openairdocs.org/ntsb/FTW83IA084.md): Bell 222 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Jan 11, 1983 · N23021 · No damage > The helicopter developed a severe vibration while in flt. The pilot executed an emergency landing with no further acft damage. An examination of the acft revealed that the walking beam assembly located between the swash plate and rotor pitch link had failed.… - [NTSB MKC83LA052](https://openairdocs.org/ntsb/MKC83LA052.md): Beech 200 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Jan 10, 1983 · N1847A · Substantial damage > During an emergency forced landing on a highway the aircraft collided with a sign. The aircraft had run out of fuel on final approach to Springfield, MO. The aircraft was enroute from white plains, NY. To tulsa, OK. The pilot departed white plains with less… - [NTSB LAX83LJA04](https://openairdocs.org/ntsb/LAX83LJA04.md): Piper PA-28-151 · Near Honolulu, HI · Accident · Minor injuries · Final report · Jan 10, 1983 · N32658 · Destroyed > The plt & passengers departed on a sight-seeing flt to view a volcano on the island of Hawaii via kona, HI & return. The fuel tanks had been topped off before departure, & reportedly, there was sufficient fuel for the flt. Except for difficulties in starting… - [NTSB CHI83LA078](https://openairdocs.org/ntsb/CHI83LA078.md): Mooney M20A · Ashkum, IL · Accident · No injuries · Limited investigation · Final report · Jan 9, 1983 · N8343E · Substantial damage > The pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds… - [NTSB ATL83MA084](https://openairdocs.org/ntsb/ATL83MA084.md): Beech D55 · Cherry Point, NC · Accident · 7 fatal · Class 1 · Major · Final report · Jan 9, 1983 · N7142N · 2 aircraft · Destroyed > The two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area… - [NTSB SEA83LA209](https://openairdocs.org/ntsb/SEA83LA209.md): Bellanca 14-19-3 · Goldendale, WA · Accident · 2 fatal · Limited investigation · Final report · Jan 8, 1983 · N8807R · Destroyed > The pilot's inadequate preflight and in-flight planning, which resulted in flight into adverse weather conditions and clearance from trees not maintained. Factors contributing to the accident included the clouds, low ceilings, and turbulence. - [NTSB SEA83LA039](https://openairdocs.org/ntsb/SEA83LA039.md): Boeing 727 · Near Yakima, WA · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 1983 · N292WA · No damage > During a climb to cruise, one passenger was injured when turbulence was encountered at about 20,500 ft MSL. The injured passenger was a 73 year old male, a retired priest and the only passenger not seated and wearing a seatbelt. As he exited the restroom, the… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=374 ## 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=373 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.