# 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 348 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI85FA014](https://openairdocs.org/ntsb/CHI85FA014.md): Cessna 172N · Hoopeston, IL · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1984 · N734ML · Destroyed > The plt landed short of destination & reported to fss that he did so because of thunderstorms in the area. After receiving a wx briefing the non-inst plt cancelled his VFR flt plan. One hour later the plt called fss & was re-briefed on the wx. The wx at his… - [NTSB LAX85LA011](https://openairdocs.org/ntsb/LAX85LA011.md): Cessna T210M · Gorman, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1984 · N6192B · Destroyed > The acft collided with high tension wires about 5 miles south of Gorman, CA. The plt stated that while enroute he 'stayed beneath' the prevailing broken cloud condition until entering the mountainous area at which time he saw a hole in the clouds & began to… - [NTSB DEN85FA009](https://openairdocs.org/ntsb/DEN85FA009.md): Bellanca 14-19-3A · Pinehill, NM · Accident · 1 fatal · Field investigation · Final report · Oct 12, 1984 · N8868R · Destroyed > Left wing failed inflight. Thunderstorms in area at time of crash. Pilot was enroute from California to new jersey, had been flying 4 hours, 18 minutes. Awake at least 7 hours. Transited 1 time zone. No record of weather briefing or flight plan filed. Pilot… - [NTSB ATL85LA009](https://openairdocs.org/ntsb/ATL85LA009.md): Cessna 150J · Brookhaven, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1984 · N61219 · Substantial damage > A total power loss occurred due to fuel exhaustion. During a forced landing, the plt stalled the acft while clearing over power lines, then the acft collided with trees as it descended out of control. A successful test run of the eng was performed.… - [NTSB CHI85FA013](https://openairdocs.org/ntsb/CHI85FA013.md): Harbaugh John T COUGAR-1 · St. Cloud, MN · Accident · 1 fatal · Field investigation · Final report · Oct 11, 1984 · N3227X · Destroyed > The homebuilt acft crashed while attempting an emergency lndg in a farmers field. The final turn to land was steepened to avoid a house. The acft flipped over and contacted the ground in an inverted, left wing & nose dwn attitude which resulted in a 180… - [NTSB ATL85FA007](https://openairdocs.org/ntsb/ATL85FA007.md): Piper PA-28-151 · Morgantown, NC · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1984 · N32828 · 2 aircraft · Destroyed > N2553A was in traffic pattern conducting touch and go landings. N32828 was maneuvering below the traffic pattern and was seen climbing in direction of N2553A. N32828 was flying westerly into the sun. N2553A was seen in a shallow left turn from crosswind to… - [NTSB MIA85LA004](https://openairdocs.org/ntsb/MIA85LA004.md): Beech 58 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Oct 10, 1984 · N9918A · Substantial damage > Plt noted decreasing oil press on right engine & diverted to suitable arpt for precautionary lndg. Plt received night vector to runway, arrived high for final approach and received tower clrnc for descending 360 degree turn to lose alt. During turn, right eng… - [NTSB LAX85MA012](https://openairdocs.org/ntsb/LAX85MA012.md): Bell 206B · Riverside, CA · Accident · 3 fatal · Major investigation · Final report · Oct 10, 1984 · N3U · Destroyed > The acft departed fullerton, CA (elev 96') at O958 PDT on a flt to big bear, CA (elev 6750'). There was no record of the plt obtaining a wx briefing. At aprx 1015, a witness heard the helicopter circling above the bottom of 'an early morning fog hanging over… - [NTSB ATL85IA005](https://openairdocs.org/ntsb/ATL85IA005.md): Bell 206B · Chamblee, GA · Incident · No injuries · Incident investigation · Final report · Oct 10, 1984 · N2756F · No damage > The plt attemped a descent and noticed the collective had locked up. Even with considerable pressure, he was unable to move the collective in either direction. He checked the system & made several remedial action attempts to no avail. An uneventful emerg… - [NTSB MKC85LA004](https://openairdocs.org/ntsb/MKC85LA004.md): Aeronca 7AC · Carlisle, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1984 · N84654 · Substantial damage > The acft collided with a piece of farm equipment during a force landing following engine failure. Investigation revealed that the plt was flying the acft to hazen, AR, to show it to his father when the engine failed. Examination of the wreckage failed to… - [NTSB NYC85LA005](https://openairdocs.org/ntsb/NYC85LA005.md): Bell 47G3-B1 · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N401GC · Substantial damage > Acft was climbing through a mountain saddle when the engine began to backfire and lose power. Plt entered autorotation & settled into trees on autorotative flare. Engine inspection revealed #3 cylinder intake valve springs broken. - [NTSB LAX85LA007](https://openairdocs.org/ntsb/LAX85LA007.md): Piper PA-24-250 · Essex, CA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1984 · N6481P · Substantial damage > The plt reported that he visually checked the quantity of fuel in the acft's fuel tanks prior to departure & that he apparently overestimated the amount in the tanks. Following the accident the plt reported that he opened the fuel caps to both tanks & they… - [NTSB LAX85LA005](https://openairdocs.org/ntsb/LAX85LA005.md): Beech H35 · Corning, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1984 · N3SE · Destroyed > Plt stated he departed sacramento earlier in the day with the tip tanks empty and the main and aux fuel tanks full (aprx 57 gallons usable fuel). He stated he used the left main fuel tank for 35 minutes and then switched to the right main tank for remaining… - [NTSB NYC85LA007](https://openairdocs.org/ntsb/NYC85LA007.md): Cessna 152II · Kinzua, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1984 · N5484M · Substantial damage > After demonstrating an approach to a simulated forced lndg, plt elected to climb through a saddle in rising terrain. After entering the saddle, plt realized that acft performance might not be sufficient to out climb terrain at full power. Acft collided with… - [NTSB FTW85FA006](https://openairdocs.org/ntsb/FTW85FA006.md): Cessna 152 · Monroe, LA · Accident · 2 fatal · Field investigation · Final report · Oct 6, 1984 · N4877H · Destroyed > Prior to dep the plt contacted the Monroe fss twice requesting a wx briefing. Both times VFR flt was not recommended due to IFR conditions with low ceilings en route and forecast fog at the dest. During the second call the plt stated that it was clear at the… - [NTSB FTW85LA009](https://openairdocs.org/ntsb/FTW85LA009.md): Cessna T210L · Rosenburg, TX · Accident · No injuries · Limited investigation · Final report · Oct 5, 1984 · N29618 · Substantial damage > Plt had altered route of flight twice to circumnavigate IFR wx, finally reversing course to land at an overflown VFR airport. Plt stated that as he headed to the the arpt the engine coughed and quit. Plt switched tanks and turned on boost pump. Engine ran… - [NTSB DEN85FA008](https://openairdocs.org/ntsb/DEN85FA008.md): Cessna 195A · Santa Fe, NM · Accident · 3 fatal · Field investigation · Final report · Oct 4, 1984 · N3086B · Destroyed > While en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,… - [NTSB NYC85FA001](https://openairdocs.org/ntsb/NYC85FA001.md): Bell 206L-1 · Reinholds, PA · Accident · No injuries · Field investigation · Final report · Oct 3, 1984 · N77AR · Substantial damage > Plt felt vibration in anti-torque pedals followed by a series of loud bangs coming from the tail section. Plt initiated precautionary landing during which tail rotor effectiveness. During the 'power off' run on landing main rotor blades contacted the tail… - [NTSB MKC85LA001](https://openairdocs.org/ntsb/MKC85LA001.md): Ayres S2R-R3S · Lepanto, AR · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N4014D · Substantial damage > As the pilot set climb power the acft began to settle. Full power was applied but the descent continued. The pilot dumped the chemical load and landed in a rice field. During recovery of the wreckage the flexible induction air duct partially collapsed… - [NTSB DEN85LA001](https://openairdocs.org/ntsb/DEN85LA001.md): Piper PA-24-250 · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N5758P · Substantial damage > The plt stated he was on a x-country flt and after aprx 1.5 hrs, the engine started to run rough. The plt attempted to correct the roughness and when he applied the carb heat, the engine quit. The plt turned off the carb heat but power could not be restored… - [NTSB ATL85LA001](https://openairdocs.org/ntsb/ATL85LA001.md): Piper J3C-65 · Milledgeville, GA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1984 · N38685 · Substantial damage > The plt departed for the intended destination, but was unable to find the arpt due to fog. After landing at another nearby arpt, he found no av-gas available. He then elected to return to his original destination, but experienced a total power loss due to… - [NTSB NYC84FNC10](https://openairdocs.org/ntsb/NYC84FNC10.md): Bell 47G-3B1 · Lincoln, NH · Accident · Serious injuries · Final report · Sep 30, 1984 · N8588F · Substantial damage > The acft was being used in a passenger sightseeing operation when shortly after takeoff the eng ceased to operate & the acft crashed into trees. Both passengers aboard the helicopter observed that the fuel gage indicated empty prior to the eng stopage. Exam… - [NTSB NYC84FA326](https://openairdocs.org/ntsb/NYC84FA326.md): Piper PA-34-220T · Turbotville, PA · Accident · 5 fatal · Field investigation · Final report · Sep 30, 1984 · N999YP · Destroyed > While the acft was en route, ATC advised the plt of VFR traffic at his one o'clock position at 12 mi on a nw heading. The plt acknowledged, but reported that he had no contact & said the wx was a little hazy. A short time later, ATC advised the traffic was… - [NTSB FTW84LA413](https://openairdocs.org/ntsb/FTW84LA413.md): Piper PA-38-112 · Rosenburg, TX · Accident · No injuries · Limited investigation · Final report · Sep 30, 1984 · N2416G · Substantial damage > The acft was subst damaged during a forced landing following a total loss of power. Investigation revealed the acft was on the return leg of a x-country when the student plt became lost & while searching for an arpt ran out of fuel. - [NTSB DEN84LA304](https://openairdocs.org/ntsb/DEN84LA304.md): Beech C24R · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · Sep 30, 1984 · N6703W · Substantial damage > Plt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were… - [NTSB DCA84IA001](https://openairdocs.org/ntsb/DCA84IA001.md): Boeing VC-137B-BN · Akron, OH · Incident · No injuries · Incident investigation · Final report · Sep 30, 1984 · USAF · 2 aircraft · No damage > A Boeing VC-137B-BN, USAF #58-6971, operating as air force 2 (AF-2), departed cleveland, OH, at about 1745 EDT on an IFR clearance. After departing cleveland, AF-2 was assigned an alt of 8000 ft MSL by cleveland departure control & was transfered to cleveland… - [NTSB SEA84IA233](https://openairdocs.org/ntsb/SEA84IA233.md): Boeing 747-200B · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Sep 29, 1984 · N613US · Minor damage > During climbout, passing thru 4000 ft MSL, the acft experienced a failure of the #2 engine. The crew reported hearing an explosive sound followed by a drop in fuel flow with N1 speed decreasing to 30% RPM on the #2 engine. The acft returned to Seattle for an… - [NTSB MIA84FA265](https://openairdocs.org/ntsb/MIA84FA265.md): Piper PA-31-350 · Bryceville, FL · Accident · 1 fatal · Field investigation · Final report · Sep 28, 1984 · N74982 · Destroyed > Flt departed in instrument meteorological conditions. After departure plt failed to maintain assigned headings several times and had to be corrected by ATC. After 15 mins of flight the plt reported he was having problems with the right engine and would like… - [NTSB LAX84LA499](https://openairdocs.org/ntsb/LAX84LA499.md): Grumman American AA1C · Molokai, HI · Accident · 1 fatal · Limited investigation · Final report · Sep 28, 1984 · N9541U · Destroyed > The student plt was on the last leg of his 1st x-country flt from honolulu, HI, to lanai, HI, to Molokai, HI, & return to honolulu. He departed Molokai at 1304 HST & at 1311, he reported abeam laau point. About 5 min later, the plt reported that he was 15 to… - [NTSB MIA84LA262](https://openairdocs.org/ntsb/MIA84LA262.md): Thomas Pitts Special S1-SP · Niceville, FL · Accident · No injuries · Limited investigation · Final report · Sep 27, 1984 · N44GP · Substantial damage > Due to failure of the engine throttle linkage the engine decelerated to idle power. The plt elected to perform a forced landing in a bayou. - [NTSB LAX84FA498](https://openairdocs.org/ntsb/LAX84FA498.md): Cessna 172Q · Prescott, AZ · Accident · Minor injuries · Field investigation · Final report · Sep 27, 1984 · N915ER · Destroyed > During a descent to the 5,042 ft elevation arpt the acft impacted the trees and mountainous terrain at the 7,000 ft level. According to the pilot, with the hooded student pilot at the controls, the flight began it's descent from 10,500 ft 30 miles from the… - [NTSB FTW84LA402](https://openairdocs.org/ntsb/FTW84LA402.md): Cessna T210N · San Augustine, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1984 · N6399Y · Destroyed > The pilot made a forced landing in a field while on a IFR flight after his engine failed. The aircraft landed short of the selected touchdown point, impacted trees and experienced a hard landing. It then caught fire and burned. Subsequent engine examination… - [NTSB FTW84FA408](https://openairdocs.org/ntsb/FTW84FA408.md): Cessna 172P · Webbers Falls, OK · Accident · 2 fatal · Field investigation · Final report · Sep 26, 1984 · N52270 · Destroyed > Acft struck electrical transmission line 80' above water while flying under the line during a wildlife survey. The acft's mission was to conduct a duck count along a river in a nat'l wildlife refuge which required low, slow maneuvering. The ex-ag pilot was… - [NTSB DEN84LA302](https://openairdocs.org/ntsb/DEN84LA302.md): Cessna 175 · Corona, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1984 · N6696E · Destroyed > At 0809 hrs, plt obtained telephone weather briefing & was advised VFR flt not recommended for intended route. At 1310 hrs, plt obtained second briefing, VFR flight again not recommended, no improvement expected prior to noon of following day. At 1428 hrs plt… - [NTSB ATL84FA298](https://openairdocs.org/ntsb/ATL84FA298.md): Beech V35B · Mc Cormick, SC · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1984 · N6740Z · Destroyed > N6740Z, a Beech V35B acft,separated in flt over mccormick, SC while operating in VFR conditions. The investigation failed to locate witnesses who observed the flt prior to & during the inflight separation. Witnesses on the ground heard the acft & observed… - [NTSB MIA84LA259](https://openairdocs.org/ntsb/MIA84LA259.md): Mooney M20C · Bimini, Bahamas · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 1984 · N6770U · Destroyed > The plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island. - [NTSB CHI84IA404](https://openairdocs.org/ntsb/CHI84IA404.md): Beech A36TC · Lafayette, IN · Incident · No injuries · Incident investigation · Final report · Sep 24, 1984 · N305MM · Minor damage > The plt reported that when he leveled off at 3000 ft MSL, the aux fuel boost switch was still on, so he switched it 'off.' When the switch was turned off, the eng began to run with a bit of vibration, so he returned the switch to 'on' & left it in that… - [NTSB ATL84LA293](https://openairdocs.org/ntsb/ATL84LA293.md): Grumman AA5-B · Luka, MS · Accident · No injuries · Limited investigation · Final report · Sep 24, 1984 · N74107 · Substantial damage > During normal cruise flight the number one cylinder exhaust valve head separated from the valve stem causing a significant power loss. The pilot set up a landing approach to a farm field. On final approach the pilot noticed that rough and rising terrain… - [NTSB CHI84LA401](https://openairdocs.org/ntsb/CHI84LA401.md): Bell 47G-3B1 · Miss.Pal.St.Pk, IL · Accident · No injuries · Limited investigation · Final report · Sep 23, 1984 · N90543 · Destroyed > The helicopter experienced a total loss of power aprx 2 minutes after takeoff. The plt performed an autorotation into trees as no suitable landing area was available. The 2 passengers on board stated the plt did not visually check the fuel quantity before… - [NTSB MKC84LA282](https://openairdocs.org/ntsb/MKC84LA282.md): Cessna T210M · Breckenridge, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1984 · N761YR · Substantial damage > On a VFR x-country flt the acft experienced an eng failure and the plt executed a night emergency landing into a soy bean field. Investigation revealed that a counterweight pin came out of the crankshaft counterweight due to a failure of a lock ring resulting… - [NTSB LAX84LA492](https://openairdocs.org/ntsb/LAX84LA492.md): Schweizer SGS 1-36 · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N3617U · Substantial damage > The plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with… - [NTSB FTW84LA405](https://openairdocs.org/ntsb/FTW84LA405.md): Cessna 152 · Ponder, TX · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N67833 · Substantial damage > Plt acknowledged initiation of flight into low ceiling and visibility conditions with no wx briefing. Shortly after takeoff, conditions deteriorated even more and acft entered thick fog. Breaking out momentarily, plt elected a precautionary lndg on a road.… - [NTSB FTW84FA404](https://openairdocs.org/ntsb/FTW84FA404.md): Cessna T210M · Colleyville, TX · Accident · 2 fatal · Field investigation · Final report · Sep 22, 1984 · N761LR · Destroyed > Plt and wife had flown to dallas (addison arpt) and spent evening with friends. Return flt initiated after midnight intolow clng and drizzle, about 12 mins later, wife contacted dallas (love fld) twr on emerg freq 121.5 and reported plt was sick and unable to… - [NTSB MIA84LA257](https://openairdocs.org/ntsb/MIA84LA257.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Sep 21, 1984 · N65484 · Substantial damage > The flt experienced eng failure and made a forced landing in a field, substantially damaging the aircraft. Post crash examination of the engine revealed the number three connecting rod separated from the crankshaft when the connecting rod bolts failed.… - [NTSB LAX84LA489](https://openairdocs.org/ntsb/LAX84LA489.md): Cessna 182D · Lincoln, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1984 · N9157X · Substantial damage > After a descent from 11,000 ft, the eng lost power at 3500 ft & would not restart. At that time, the plt noted that the fuel gages indicated the right tank was about 1/4 full & the left tank was empty. He landed in a rice field at night where the nose gear… - [NTSB FTW84LA407](https://openairdocs.org/ntsb/FTW84LA407.md): Beech 95-C55 · Dallas, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1984 · N5702V · Destroyed > The acft received subst damage during an emerg landing after loss of power in both left & right engines. The plt landed the acft in a river bed with the gear retracted during the hours of darkness. The acft was serviced with 10 gals of 100LL prior to… - [NTSB DEN84FA295](https://openairdocs.org/ntsb/DEN84FA295.md): Cessna 205 · Highwood, MT · Accident · 3 fatal · Field investigation · Final report · Sep 21, 1984 · N8435Z · Destroyed > At 0053 MDT, the plt radioed great falls fss & requested wx info. He was advised of IFR conditions & was provided the latest observation. The plt requested & was provided a special VFR clearance to depart to the east. He took off at 0100 MDT & reported over… - [NTSB ATL84LA284](https://openairdocs.org/ntsb/ATL84LA284.md): Piper PA-28R-201T · Henderson, KY · Accident · No injuries · Limited investigation · Final report · Sep 21, 1984 · N38765 · Substantial damage > The acft was damaged in an off arpt forced landing after the engine lost oil pressure, overheated and quit running. The plt said she checked the oil quantity at 7 1/2 qts before takeoff for the local flt. The engine overheated after about one hour of flt… - [NTSB CHI84LA394](https://openairdocs.org/ntsb/CHI84LA394.md): Beech A-24R · Evansville, IN · Accident · No injuries · Limited investigation · Final report · Sep 19, 1984 · N8033R · Substantial damage > Shortly after take off, plt experienced complete electrical failure, later traced to a broken field wire on the acft alternator terminal. Plt returned for landing & placed gear handle in down position. Gear failed to extend (electrically operated). Plt made… - [NTSB MIA84FA256](https://openairdocs.org/ntsb/MIA84FA256.md): Douglas DC3 · Boca Raton, FL · Accident · No injuries · Field investigation · Final report · Sep 18, 1984 · N143D · Substantial damage > Four hours and forty mins after takeoff aprx 6 miles from the dest aprt, both engs stopped running. Attempts to restart the engs were unsuccessful. Thinking they were out of fuel, the crew accomplished a forced landing in a wildlife refuge in 10 ft tall… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=349 ## 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=348 --- 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.