# 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 363 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC83LA258](https://openairdocs.org/ntsb/NYC83LA258.md): Cessna 172G · Woodford, VT · Accident · No injuries · Limited investigation · Final report · Sep 27, 1983 · N3692L · Destroyed > According to the pilot weather was clear at time of departure with clouds at about 4000-4500 feet but clr above. He entered a break in the clouds and began following a road. As the weather began closing in from above and the road became curvy, the pilot had… - [NTSB FTW83FA441](https://openairdocs.org/ntsb/FTW83FA441.md): Cessna 172E · Leesville, LA · Accident · 3 fatal · Field investigation · Final report · Sep 27, 1983 · N3058U · Destroyed > Earlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted… - [NTSB CHI83FA445](https://openairdocs.org/ntsb/CHI83FA445.md): Cessna 182B · Constantine, MI · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1983 · N2531G · Destroyed > The non-instrument rated plt was on a x-country flt on a dark night. During the flt, the acft crashed in a corn field. Just prior to the initial impact, there was aprx a 15 deg descending angle cut thru the corn in the direction of flt & a 30 deg angle cut to… - [NTSB CHI83FA441](https://openairdocs.org/ntsb/CHI83FA441.md): Piper PA-28-161 · Bethany, IL · Accident · 2 fatal · Field investigation · Final report · Sep 26, 1983 · N8236U · Destroyed > Prior to this flt, the plt had contacted a fss & inquired about the wx. He was advised that VFR flt to terre haute, IN, was not recommended. He took off at about 1830 CDT. The plt again contacted the fss & inquired about the wx at burlington, IA &… - [NTSB ATL83LA382](https://openairdocs.org/ntsb/ATL83LA382.md): Aero Commander A-9 · Andalusia, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1983 · N8031V · Substantial damage > After spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt… - [NTSB CHI83LA439](https://openairdocs.org/ntsb/CHI83LA439.md): Cessna 206 · Eveleth, MN · Accident · No injuries · Limited investigation · Final report · Sep 25, 1983 · N7169Q · Substantial damage > While returning from a fishing trip in ontario, Canada, the plt landed at crane lake, MN, where he cleared customs & had 10 gal of fuel added to the right fuel tank. He then flew to Eveleth, MN, aprx 90 mi away. From Eveleth, he proceed toward ely lake, MN.… - [NTSB CHI83FA440](https://openairdocs.org/ntsb/CHI83FA440.md): Ercoupe 415-C · Raymond, IL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1983 · N3184 · Destroyed > During a wx briefing at 1433 CDT, the plt was advised to expect 500 ft ceilings, 2 mi visibilities, rain showers & thunderstorms. He then took off from bismark, MO with no flt plan. Reportedly, wx was encountered during the flt which deteriorated as he… - [NTSB ATL83LA381](https://openairdocs.org/ntsb/ATL83LA381.md): Aerotek S-2A · Dublin, GA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1983 · N15KP · Substantial damage > The plt landed at eastman, GA, where he planned to refuel, while en route from milton, FL to sumter, SC. Fuel was not available, so he departed for swainsboro, GA. However, he decided that would be too FAR, and planned instead, to land at Dublin which was 30… - [NTSB MKC83LA224](https://openairdocs.org/ntsb/MKC83LA224.md): Beech A36 · Oberlin, KS · Accident · No injuries · Limited investigation · Final report · Sep 24, 1983 · N797CC · Substantial damage > The plt stated he was flying near his relatives' house when he switched fuel tanks and the eng began running rough. The plt suspected the magnetos since they had recently been serviced. The plt switched fuel tanks again with the boost pumpson and the engine… - [NTSB MIA83LA238](https://openairdocs.org/ntsb/MIA83LA238.md): Stinson 108-1 · Clermont, FL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1983 · N8898K · Substantial damage > During flt, the eng began running rough & oil began leaking & spreading onto the windshield. The eng subsequently failed & the plt selected an area for a forced landing, during the landing, the acft contacted trees & was damaged. An investigation revealed… - [NTSB CHI83IA442](https://openairdocs.org/ntsb/CHI83IA442.md): Cessna 172RG · Shell Lake, WI · Incident · No injuries · Incident investigation · Final report · Sep 24, 1983 · N4963V · No damage > The number 4 exhaust pushrod failed in flight for an undetermined reason. - [NTSB SEA83FA204](https://openairdocs.org/ntsb/SEA83FA204.md): Lake LA-4-200 · Eastsound, WA · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1983 · N1251L · Destroyed > The acft collided with the glassy water during a low alt maneuver. The acft was observed by witnesses to descend from about 100 ft in a flat attitude,touch down,skim along the water then the nose pitched down and the acft nosed over. The occupants were… - [NTSB MKC83LA222](https://openairdocs.org/ntsb/MKC83LA222.md): S.N.I.A.S. AS350D · Cape Girardeau, MO · Accident · No injuries · Limited investigation · Final report · Sep 23, 1983 · N5786B · Substantial damage > The plt reported that during flt, he heard a grinding noise, then the helicopter pitched up & to the left. He reduced power & noticed that the tail rotor was inoperative. During a run-on landing approach, the helicopter begun to yaw, then before touchdown, it… - [NTSB MIA83IA237](https://openairdocs.org/ntsb/MIA83IA237.md): Piper PA 28-180 · Verna, FL · Incident · No injuries · Incident investigation · Final report · Sep 23, 1983 · N7032W · Minor damage > Acft made an emergency due to powerplant failure. Access to the wreckage was never gained. - [NTSB LAX83FA456](https://openairdocs.org/ntsb/LAX83FA456.md): Mooney M20K · Patterson, CA · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1983 · N231GJ · Destroyed > During a x-country flt, the acft crashed into rising terrain in a semi-box canyon in the diablo range. The crash site was at an elevation of aprx 1200 ft MSL. The canyon tops ranged from 1500 to 1700 ft. according to a farmer residing 2 mi west of the… - [NTSB NYC83FA253](https://openairdocs.org/ntsb/NYC83FA253.md): Beech 58 · Arkville, NY · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1983 · N6657R · Destroyed > Prior to taking off, the plt advised company personnel that he planned to fly vfr-on-top at 8500 ft MSL. He planned to depart at 1400 EDT, but did not specify his route of flt. When the acft did not arrive, a search was initiated, it was found where it had… - [NTSB LAX83FA455](https://openairdocs.org/ntsb/LAX83FA455.md): Piper PA 28-140 · Lake Genevieve, CA · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1983 · N4297T · Destroyed > During cruise flight the acft encountered a downdraft while flying in mountainous terrain. The pilot lost control of the acft & it crashed. The pilot was student pilot rated only & had not been endorsed for this flight. He also was carrying a passenger who… - [NTSB LAX83LA452](https://openairdocs.org/ntsb/LAX83LA452.md): Aero Commander 100 · Palm Springs, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1983 · N3636X · Substantial damage > While en route, the plt encountered deteriorating wx. He was an instrument plt, but had chosen not to file & fly under IFR due to terrain, wx, low performance of the acft & lack of pitot heat. The plt noted a ceiling at 5500 ft MSL when he crossed banning… - [NTSB LAX83LA450](https://openairdocs.org/ntsb/LAX83LA450.md): Cessna 182 · Joshua Tree, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1983 · N5437B · Destroyed > The plt reported that he was flying under a 2000 ft MSL cloud layer while en route from san carlos, CA to glendale, AZ. He flew into a valley & the clouds began closing in. He then made a 180 deg turn, but the clouds had closed in behind him. He attempted a… - [NTSB SEA83LA193](https://openairdocs.org/ntsb/SEA83LA193.md): Anderson Starduster TOO SA300 · Lynnwood, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1983 · N44HA · Substantial damage > The plt reported that during flt, there was a change in the engine sound which was followed by a drop in fuel pressure. The plt started to look for a place to land when a total loss of power occurred. He elected to land on a football field. However, after… - [NTSB LAX83FA442](https://openairdocs.org/ntsb/LAX83FA442.md): Cessna 150H · Venice, CA · Accident · No injuries · Field investigation · Final report · Sep 18, 1983 · N22697 · Substantial damage > The acft ditched in the ocean after losing power while towing a banner. The pilot stated that the eng quit while the acft was over land. He turned toward the ocean and managed to start the engine 2 times for a brief period while descending. The propeller… - [NTSB CHI83LA430](https://openairdocs.org/ntsb/CHI83LA430.md): Cessna U206F · Garden Prairie, IL · Accident · No injuries · Limited investigation · Final report · Sep 18, 1983 · N8449Q · Substantial damage > While en route, the fuel pressure dropped, and subsequently, the eng lost power completely. During a landing in a corn field, the acft was damaged. An investigation revealed that the fuel line had separated at the flow divider. Reportedly, the eng had been… - [NTSB NYC83FA248](https://openairdocs.org/ntsb/NYC83FA248.md): Cessna U-206FG · Jones Beach, NY · Accident · 4 fatal · Field investigation · Final report · Sep 17, 1983 · N50807 · No damage > The acft ditched in the ocean about 4 miles se of Jones Beach, NY following eng power failure. The 4 occupants drowned. The plt was going from Washington,DC to westhampton Beach, NY, the acft was last refueled before its departure from westhampton Beach on… - [NTSB FTW83FA430](https://openairdocs.org/ntsb/FTW83FA430.md): MBB BO-105S · Grand Chenier, LA · Accident · 2 fatal · Field investigation · Final report · Sep 15, 1983 · N3456T · Destroyed > The acft departed an offshore platform at 1510 for a 13 min flt to Grand Chenier. On 9/20 the wreckage was recovered from the floor of the gulf. The bottom left side of the fuselage revealed evidence of high impact forces with the water. There was no evidence… - [NTSB ANC83LA173](https://openairdocs.org/ntsb/ANC83LA173.md): Piper PA-12 · Kenai, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1983 · N2430M · Destroyed > The acft collided with a ridgeline when the pilot attempted to fly through a pass. The pass was crested at about 3600 ftsurrounded by elevations of over 8000 ft MSL. The pilot stated that he was attempting to get through merrill pass because of hunters that… - [NTSB ANC83LA172](https://openairdocs.org/ntsb/ANC83LA172.md): Hiller-Soloy UH12E · Cape Yakataga, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1983 · N3324F · Substantial damage > The helicopter rolled over during a forced landing on a beach after the engine quit. Discussions with the plt owner of the company verified that the acft had run out of fuel. The owner had warned his pilots to visually check fuel on the helicopters due to… - [NTSB SEA83FA096](https://openairdocs.org/ntsb/SEA83FA096.md): Stinson 108-2 · Quilcene, WA · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1983 · N9408K · Destroyed > The acft collided with trees at the 2800 ft level of a mountain after the pilot encountered IMC weather. The weather wasvmc in the area but the mountain ranges had been forecast to be obscured in weather. The pilot had received a weather briefing. The acft… - [NTSB CHI83FA428](https://openairdocs.org/ntsb/CHI83FA428.md): Sikorsky S-76A · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Sep 14, 1983 · N521AC · Destroyed > While cruising at 2000 ft MSL & 150 KTS, the crew heard a loud noise, and simultaneously, the helicopter yawed aprx 30 to 40 deg to the right & pitched nose down. The aircrew began an autorotation & activated the emergency floats. The helicopter continued in… - [NTSB ANC83LA170](https://openairdocs.org/ntsb/ANC83LA170.md): Cessna 206 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 13, 1983 · N8273G · Substantial damage > The acft collided with wires and crashed tail first inverted during a forced landing after the engine stopped. The plt said he was descending from 1200 ft to 600 ft for ft hood segment when engine quit. The weather ws VMC. The plt tried to make it to mud… - [NTSB MIA83LA230](https://openairdocs.org/ntsb/MIA83LA230.md): Cessna C-150 · Culebra Island, PR · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1983 · N11207 · Substantial damage > The pilot stated that while on his long cross country flight the engine started to lose pwr. He then felt a vibration and the prop stopped the acft was ditched near the shore of Culebra Island. It was calculated that the acft flew abt 3 hours and 30 minutes.… - [NTSB LAX83LA437](https://openairdocs.org/ntsb/LAX83LA437.md): Bellanca 7GCBC · Santa Barbara, CA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1983 · N8741V · Substantial damage > While circling an area near Santa cruise island, CA. During aerial fish spotting operations, the acft eng began to lose pwr. As the acft apchd the island the eng sustained a complete pwr loss and nosed over drng the ensuing forced lndg. An eng exam revealed… - [NTSB DCA83IA040](https://openairdocs.org/ntsb/DCA83IA040.md): Beech B-24R · Potomac, MD · Incident · No injuries · Incident investigation · Final report · Sep 12, 1983 · N9196S · Minor damage > The acft made a forced landing in a field of rye grass after the engine lost power. Investigation revealed that a connecting rod had failed. An FAA inspection revealed that the connecting rod retaining bolts were not properly torqued during a recent major… - [NTSB FTW83LA428](https://openairdocs.org/ntsb/FTW83LA428.md): Cessna 180A · Stake Island · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1983 · N5030E · Substantial damage > The plt stated, that while flying over gulf waters he forgot to set his altimeter and thought he was at 200 ft when the acft contacted the water. The float were ripped off and the acft sank in about 10 ft of water. The plt and passenger held onto the float… - [NTSB DEN83FA217](https://openairdocs.org/ntsb/DEN83FA217.md): Bell 206L-1 · Price, UT · Accident · No injuries · Field investigation · Final report · Sep 10, 1983 · N3900Q · Substantial damage > The plt took off with an 800 lb sling load & used 100% torque to expedite clearing power lines. When clear of the lines, he started a climbing turn & reduced the torque to about 80%. At aprx 300 ft AGL & 50 to 60 KTS, the eng began surging which caused the… - [NTSB SEA83FA208](https://openairdocs.org/ntsb/SEA83FA208.md): Cessna 182N · Kalispell, MT · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1983 · N92368 · Destroyed > The pilot's failure to maintain clearance from the terrain while attempting to maneuver back to the departure airport after encountering icing conditions. Factors include icing conditions, mountainous terrain, and low ceilings. - [NTSB FTW83LA425](https://openairdocs.org/ntsb/FTW83LA425.md): Beech A36 · Daisetta, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N18BR · Substantial damage > Before takeoff, the plt was briefed on the wx, including SIGMET 20C, which called for imbedded thunderstorms. While en route, he deviated around an area of wx & was provided vectors to avoid storm cells. In the vicinity of Daisetta, TX, the controller… - [NTSB DEN83FA214](https://openairdocs.org/ntsb/DEN83FA214.md): Cessna R172K · Silverton, CO · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1983 · N758PB · Destroyed > The plt departed longmont, CO at about 0520 MDT. At 0617 MDT, he contacted the denver en route flt advisory service & received wx info. The location of the acft at that time was not determined. No further radio communications were received from the plt. A… - [NTSB NYC83FA235](https://openairdocs.org/ntsb/NYC83FA235.md): Piper PA-28RT-201T · Andover, NJ · Accident · Minor injuries · Field investigation · Final report · Sep 6, 1983 · N9LH · Substantial damage > As the acft was climbing thru about 7000 ft on a hot day, the eng abruptly lost power. Several attempts were made to restart the eng, but to no avail. While attempting to restart, the plt noted that the fuel flow indication was at or near zero & the boost… - [NTSB MIA83FA223](https://openairdocs.org/ntsb/MIA83FA223.md): Cessna T-210N · Gainesville, FL · Accident · Minor injuries · Field investigation · Final report · Sep 6, 1983 · N6482Y · Substantial damage > The acft collided with a ditch during a forced landing after engine failure in flt. The plt stated that during the climbto cruise the engine quit. He attempted to restart it once and then executed a forced landing. Examination of the acft wreckage revealed… - [NTSB LAX83FA424](https://openairdocs.org/ntsb/LAX83FA424.md): Piper PA-32-301T · San Marcos, CA · Accident · 4 fatal · Field investigation · Final report · Sep 6, 1983 · N8196J · Destroyed > At aprx 2209 PDT, the plt departed fresno, CA on a night, VFR, x-country flt. He cancelled his VFR flt plan at 0009 PDT & landed at ramona, CA at 0012. After landing, he called his wife to inquire about the wx at palomar, CA. She looked out the window &… - [NTSB FTW83LA429](https://openairdocs.org/ntsb/FTW83LA429.md): British BAC 1-11 · Green Canyon172 · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1983 · YS17C · No damage > While established in cruise flight deviating around an area of thunderstorms the aircraft experienced an encounter with turbulence that caused 1 serious and 2 minor injuries - [NTSB SEA83FA198](https://openairdocs.org/ntsb/SEA83FA198.md): Bell 205A-1 · Elk Rock, WA · Accident · Serious injuries · Field investigation · Final report · Sep 5, 1983 · N58034 · Destroyed > The acft was climbing thru about 800 ft AGL, when the plt noted a severe shudder & vibration. He lowered the collective, then noticed that the N2 & rotor RPM were pegged at 110%. As he reapplied the collective to stop the overspeed, he noted a loss of thrust… - [NTSB CHI83LA415](https://openairdocs.org/ntsb/CHI83LA415.md): Cessna 150G · Paris, IL · Accident · No injuries · Limited investigation · Final report · Sep 5, 1983 · N6227S · Substantial damage > The student plt was on his 1st solo x-country flt. On the 1st leg of the flt, he became disoriented, experienced fuel exhaustion & landed in a soybean field. During the landing, the acft nosed over when the gear encountered the tall beans. The student… - [NTSB SEA83FA197](https://openairdocs.org/ntsb/SEA83FA197.md): Cessna U206F · Juneau, AK · Accident · Serious injuries · Field investigation · Final report · Sep 4, 1983 · N8173Q · Destroyed > The plt reported that while on a sightseeing flt, he proceeded up the taku inlet northbound. From there, he continued up over the taku glacier while climbing to aprx 5300 ft MSL.thereafter, he turned to proceed down the mendenhall glacier & begun a descent.… - [NTSB NYC83LA232](https://openairdocs.org/ntsb/NYC83LA232.md): Cessna 120 · Punxsutawney, PA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N77321 · Substantial damage > According to the pilot when he entered the aircraft he found that the master switch had been left on and the battery wasdown. He flew around the airport for about 45 min, to recharge the battery prior to departing for his destination. He arrived at his… - [NTSB MKC83LA212](https://openairdocs.org/ntsb/MKC83LA212.md): West-Heckman BABY-ACE · Easton, MO · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N2308S · Substantial damage > The plt reported that he took off from tarkio, MO on a return flt to plattsburg, MO with 1/2 to 3/4 of a tank of auto fuel. He encountered strong head winds, and subsequently, noticed that the fuel gage was registering empty. At about that time, the eng lost… - [NTSB MKC83LA211](https://openairdocs.org/ntsb/MKC83LA211.md): Mooney M20C · Bloomfield, IA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N4057N · Substantial damage > While en route, the plt encountered a progressive, partial power loss. At 1st the eng began running rough, then the manifold pressure dropped to 15 inches (18 inches had been set for cruise). He heard a clicking noise & started a descent from his cruise alt… - [NTSB LAX83FA420](https://openairdocs.org/ntsb/LAX83FA420.md): Hughes 369HS · Ventura, CA · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1983 · N8500N · Destroyed > The helicopter was observed descending 'straight down' & 'nose first.' The wreckage was located about 200 yds offshore in about 30 ft of water. Witnesses stated that it was dark & hazy. They were able to see the acft lights, but not the stars. The plt did not… - [NTSB CHI83LA413](https://openairdocs.org/ntsb/CHI83LA413.md): Kuster KR-2 · New Lisbon, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1983 · N39JK · Substantial damage > The acft made a forced landing in a cornfield after a loss of power during flt. The acft had been flying about 30 minutes. Post accident examination of the engine revealed a fuel leak around the mixture control linkage shaft. The fuelexhaustion was atttibuted… - [NTSB ATL83LA353](https://openairdocs.org/ntsb/ATL83LA353.md): Bellanca 7GCAA · Dayton, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1983 · N88223 · Substantial damage > The acft was modified to tow banners & was being used for that purpose. After the acft had been flown about 3 hrs & 20 min, the plt took off on his 4th banner tow flt. He stated that he had used the fuel gages to estimate the amount of fuel remaining. The… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=364 ## 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=363 --- 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.