# 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 342 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC85LA089](https://openairdocs.org/ntsb/NYC85LA089.md): Ercoupe 415-D · Sussex, NJ · Accident · No injuries · Limited investigation · Final report · Mar 23, 1985 · N99677 · Substantial damage > The acft experienced a loss of eng pwr during climb shortly after takeoff and was substantially damaged during the forced landing which resulted. The plt reported the eng coughed and lost pwr, however, when the throttle was pumped, pwr returned. Pwr was then… - [NTSB NYC85LA086](https://openairdocs.org/ntsb/NYC85LA086.md): Cessna 182 · Fairfield, PA · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1985 · N97700 · Substantial damage > During flt, the acft had an electrical problem while flying in instrument (IFR) conditions. The plt reported that only the altimeter, airspeed indicator & mag compass were operating. He became spatially disoriented & the acft entered several dives & at least… - [NTSB LAX85LA186](https://openairdocs.org/ntsb/LAX85LA186.md): Cessna 182P · Gila Bend, AZ · Accident · No injuries · Limited investigation · Final report · Mar 23, 1985 · N52711 · Destroyed > While in cruise flt the acft's high voltage warning light illuminated and the alternator circuit breaker popped out. The plt reset the breaker which restored operation to the circuit. Later in the flt a fire erupted behind the instrumentpanal and soon… - [NTSB FTW85LA170](https://openairdocs.org/ntsb/FTW85LA170.md): Cessna 175 · Sonora, TX · Accident · No injuries · Limited investigation · Final report · Mar 23, 1985 · N6710E · Substantial damage > The acft was destroyed during a forced landing in rough terrain, following an eng failure in-flt. Investigation revealedthat the no. 3 connecting rod failed due to oil starvation. The rod oil passageway was found clogged with sludge and fine metal particles,… - [NTSB CHI85LA147](https://openairdocs.org/ntsb/CHI85LA147.md): Cessna T210M · Flora, IN · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1985 · N732RX · Destroyed > Pilot dept danville, IL no flt plan for indianapolis, IN enroute he encountered IFR conditions and reversed course. The pilot then lost all electrical power on acft. Flying north, pilot saw Flora muni thru breaks in overcast. Pumped gear down and only… - [NTSB LAX85FA181](https://openairdocs.org/ntsb/LAX85FA181.md): Beech B35D · Mojave, CA · Accident · 3 fatal · Field investigation · Final report · Mar 21, 1985 · N2176D · Destroyed > The left stabilizer assembly separated from the acft in-flt. The alt and airspeed at the time of the separation were not determined. Plts of acft flying in the area at about the time of the accident reported moderate to severe turbulenceand up and down drafts… - [NTSB CHI85IA145](https://openairdocs.org/ntsb/CHI85IA145.md): Cessna T210L · Peoria, IL · Incident · 1 fatal · Incident investigation · Final report · Mar 21, 1985 · N11KW · No damage > While in cruise flight the commercial rated pilot suffered a fatal heart attack. The non-rated passenger landed the aircraft safely. - [NTSB LAX85FA180](https://openairdocs.org/ntsb/LAX85FA180.md): Beech B-19 · Flagstaff, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1985 · N9734Q · Destroyed > After receiving numerous weather briefings, that reported instrument meteorological conditions and marginal visual meteorological conditions, the pilot tookoff into the dark night, for his return flight, over mountainous terrain. The aircraft impacted a… - [NTSB MKC85LA074](https://openairdocs.org/ntsb/MKC85LA074.md): Cessna 150M · Rolla, MO · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1985 · N714FT · Substantial damage > Due to the student plts miscalculation of the acft's rate of fuel consumption the acft ran out of fuel aprx 2 miles from the Rolla downtown arpt. The acft sustained substantial damage upon colliding with trees during the night forced landing. This was the… - [NTSB LAX85LA182](https://openairdocs.org/ntsb/LAX85LA182.md): Cessna P210N · Mountain Pass, CA · Accident · 2 fatal · Limited investigation · Final report · Mar 19, 1985 · N7748K · Destroyed > The non-instrument rated plt departed into a weather front. VFR flt was not recommended. Flt precautions existed for icing, turbulence & mt obscuration. The radar chart showed light to moderate rain with isolated thunderstorms. The acft was issued a clearance… - [NTSB LAX85FA179](https://openairdocs.org/ntsb/LAX85FA179.md): Stracener Experimental SX · Fremont, CA · Accident · 1 fatal · Field investigation · Final report · Mar 19, 1985 · N2297 · Destroyed > The acft was being leased to the atr plt by the registered owner. This was the plt's first flt in the acft. Weather conditions were conducive for carburetor icing. Just prior to takeoff the owner advised the plt that the acft was equipped with a low pressure… - [NTSB NYC85FA083](https://openairdocs.org/ntsb/NYC85FA083.md): Cessna 401A · Dorset, VT · Accident · 1 fatal · Field investigation · Final report · Mar 18, 1985 · N12CQ · Destroyed > The plt was about 30 miles from rutland when he radioed the arpt for weather info. He was informed that clouds were 1500 ft broken and 2700 ft overcast with snow, light fog and 5 miles visibility. The plt responded that he would call again when he got closer… - [NTSB LAX85FA178](https://openairdocs.org/ntsb/LAX85FA178.md): Cessna 150F · Lee Vining, CA · Accident · 1 fatal · Field investigation · Final report · Mar 18, 1985 · N8567G · Destroyed > The acft collided below the crest of an 8100 ft (MSL) mtn on a flt from mammoth-june lakes arpt (mmh), mammoth, CA, to reno, NV, while executing a left turn course reversal. There were no witnesses to the accident. Witnesses reported seeing the acft flying at… - [NTSB CHI85LA141](https://openairdocs.org/ntsb/CHI85LA141.md): Cessna T210L · Sauk Village, IL · Accident · No injuries · Limited investigation · Final report · Mar 18, 1985 · N94032 · Substantial damage > During a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.… - [NTSB MIA85LA124](https://openairdocs.org/ntsb/MIA85LA124.md): Cessna 172 · Big Pine Key, FL · Accident · No injuries · Limited investigation · Final report · Mar 17, 1985 · N1814Y · Substantial damage > The plt stated that while in cruise flt at about 1200 ft & 2300 RPM the eng lost pwr & the acft was ditched aprx 100 yards off shore in the ocean waters. The acft was found to have sufficient fuel in both tanks. The fuel selector was on, the fuel screen was… - [NTSB MIA85FA123](https://openairdocs.org/ntsb/MIA85FA123.md): Aronson Falco F8L · Gainesville, FL · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1985 · N545SF · Destroyed > The plt received a wx briefing & filed an IFR clnc, then departed VFR. Except for a hdwnd, the 1st part of the flt was normal. In the vcnty of macon, GA, the plt requested & received an IFR clnc. Later, he elected to divert to the gaines- ville rgnl arpt &… - [NTSB BFO85LA029](https://openairdocs.org/ntsb/BFO85LA029.md): Cessna 150H · South Hill, VA · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1985 · N23231 · Substantial damage > While on a solo cross country flight the student pilot became disorientated after about 60MIN of flt. He atmptd to call in the blind on guard. Freq. Both danville and roanok fss's responded to his calls but were unable to establish 2 way commo with the plt.… - [NTSB ATL85LA120](https://openairdocs.org/ntsb/ATL85LA120.md): Cessna 411 · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Mar 16, 1985 · N213CM · Substantial damage > The acft experienced a ttl electrical failure for unknown reasons. The plt descended and flew below low ceilings until and arpt was found. Attempts to lower the landing gear with the emerg hand crank failed. Low on fuel, he landed with gear up. The plt… - [NTSB SEA85LA076](https://openairdocs.org/ntsb/SEA85LA076.md): Weatherly 201B · Davenport, WA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N1263W · Substantial damage > A vibration started in the engine and while the plt was monitoring the engine gauges he noted a loss of all oil pressure. A landing was made on a field and during rollout the left main gear was torn off when it struck a mound of dirt. The acft then struck… - [NTSB MKC85LA075](https://openairdocs.org/ntsb/MKC85LA075.md): Beech V35B · Anton Chico, NM · Accident · No injuries · Limited investigation · Final report · Mar 15, 1985 · N4151S · Substantial damage > Pilot stated that he was on a VFR no-flight-plan-flight from meade, KS, to alburquerque, NM, when he saw a cloud bank ahead. While diverting around, he flew into haze that became clouds. Recovery from strong down and up drafts did substantial damage to wings,… - [NTSB LAX85LA173](https://openairdocs.org/ntsb/LAX85LA173.md): Beech H35 · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 1985 · N5539D · Substantial damage > The plt & pax departed phoenix sky harbor on a sales demo flt & landed nearby at falcon fld. During the return flt, the eng lost power as the plt began descending from 3800'. He noted there was no fuel flow, so he used the wobble pump. The plt said he was… - [NTSB DEN85FA097](https://openairdocs.org/ntsb/DEN85FA097.md): Mooney M20F · Deming, NM · Accident · 1 fatal · Field investigation · Final report · Mar 15, 1985 · N7414V · Destroyed > During preflt & inflt wx briefings, the plt was advised that mountains along his route were obscured by clouds & precip. Also, he was cautioned about moderate icing in clouds & precip at or above the freezing lvl. While en route, the plt obtained clearance to… - [NTSB MKC85LA071](https://openairdocs.org/ntsb/MKC85LA071.md): Cessna 152 · Norwalk, IA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N67399 · Substantial damage > Approaching des moines airport the plt rptd to approach control of eng problems and wanted to know what airport was close for an precautionary landing. An attempt was made to land at an airstrip 3 mi east of his present posn. Unable to land at the airstrip… - [NTSB MIA85LA118](https://openairdocs.org/ntsb/MIA85LA118.md): Piper PA-24-180 · Zephyrhills, FL · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N7639P · Substantial damage > The plt stated that he experienced a complete loss of power & upon making his emerg landing in a pasture, the acft struck fence posts, separating the right main landing gear. Investigation of the fuel system revealed there was no fuel in the left tank &… - [NTSB MKC85FA070](https://openairdocs.org/ntsb/MKC85FA070.md): Cessna T210R · Eli, NE · Accident · 2 fatal · Field investigation · Final report · Mar 12, 1985 · N6101U · Destroyed > There were no witnesses to the takeoff or the accident. A flt plan was not filed and no radar data on the flt was found. The owner of N6101U estimated the takeoff time to be 2130 CST, mar. 12 and the plt told the owner he was going to Utah. The wreckage of… - [NTSB BFO85FA026](https://openairdocs.org/ntsb/BFO85FA026.md): Cessna 182P · Laurel, MD · Accident · No injuries · Field investigation · Final report · Mar 11, 1985 · N52581 · Substantial damage > While on a return flight from morrisville,VT the acft lost pwr and the PIC elected to land in a cul-de-sac im a residential neighborhood. Investigation revealed that the acft contained less than 1 gallon of fuel. Both plts had dptd pxt 4 days prior and… - [NTSB ANC85LA053](https://openairdocs.org/ntsb/ANC85LA053.md): Cessna 207 · Mcgrath, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1985 · N9937M · Substantial damage > The acft contacted trees during a forced landing following an engine failure. Investigation revealed the crankshaft had failed for undetermined reasons. The enging had a total time of 1312 hrs since major overhaul. - [NTSB FTW85LA142](https://openairdocs.org/ntsb/FTW85LA142.md): Beech E18S · Pharr, TX · Accident · No injuries · Limited investigation · Final report · Mar 10, 1985 · N352B · Substantial damage > The plt took off at about 0600 CST on a local test flt following an eng change. He received a special VFR clearance from the control tower, but did not obtain an IFR clearance. At 0605, the wx at mcallen, TX was in part: 500 ft obscured, visibility 2 mi, wind… - [NTSB MIA85LA116](https://openairdocs.org/ntsb/MIA85LA116.md): Republic RC-3 · Lake Placid, FL · Accident · No injuries · Limited investigation · Final report · Mar 9, 1985 · N6294K · Destroyed > The plt heard a loud noise & noticed that a fire had immediately started in the eng compartment. He made an emergency landing on a nearby lake; however, the amphibious acft continued burning & was destroyed. An investigation revealed that the fire had started… - [NTSB BFO85FA025](https://openairdocs.org/ntsb/BFO85FA025.md): Piper PA-28-140 · Friendship, MD · Accident · Serious injuries · Field investigation · Final report · Mar 9, 1985 · N1859J · Substantial damage > The acft had departed woodbridge, VA, en route atlantic city, NJ, for the afternoon. As the acft approached the chesapeake bay in a climb the eng lost pwr. The plt was unable to restart the eng and was forced to land on pvt property. During the emergency… - [NTSB ATL85FA112](https://openairdocs.org/ntsb/ATL85FA112.md): Bell 206L · Dauphin Island, AL · Accident · 4 fatal · Field investigation · Final report · Mar 9, 1985 · N16841 · Destroyed > Plt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of… - [NTSB ATL85FA113](https://openairdocs.org/ntsb/ATL85FA113.md): Cessna 182 · Le Banon, VA · Accident · 2 fatal · Field investigation · Final report · Mar 8, 1985 · N5430B · Destroyed > The acft impacted trees and came to rest 400 ft downslope from the top of clinch mountain. The non-instrument rated plt departed sprinfield, MO, with a ceiling of aprx 300-400 ft AGL. The plt then landed at cookeville, TN, where he received a wx briefing and… - [NTSB MKC85FCA01](https://openairdocs.org/ntsb/MKC85FCA01.md): Piper PA-140 · Lemay, MO · Accident · Serious injuries · Final report · Mar 7, 1985 · N5741U · Destroyed > The acft sustained substantial damage during a forced landing following a loss of power. Post accident inspection of the acft revealed no fuel was present in either fuel tank and there was no evidence of fuel spillage at the accident site. - [NTSB NYC85LA074](https://openairdocs.org/ntsb/NYC85LA074.md): Aero Commander 680V · Kingstown, RI · Accident · No injuries · Limited investigation · Final report · Mar 6, 1985 · N111SK · Substantial damage > While en route at 12,500 ft, the plt noted a slight shudder & heard a 'wind noise' then the gear unsafe light illuminated. The plt slowed the acft to 135 KTS & tried recycling the gear, but the gear only dropped to the point where it would twist. All attempts… - [NTSB ATL85LA110](https://openairdocs.org/ntsb/ATL85LA110.md): Mooney M20F · Rock Hill, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 1985 · N6399Q · Substantial damage > During a VFR flt, the plt reported a severe vibration in the airframe. Pwr was reduced in an attempt to lessen the vibration and shortly thereafter, a total loss of pwr was experienced and the plt established a glide to the nearest landing area. During the… - [NTSB FTW85FA137](https://openairdocs.org/ntsb/FTW85FA137.md): Piper PA-23-250 · Foss, OK · Accident · 1 fatal · Field investigation · Final report · Mar 5, 1985 · N6310U · Destroyed > Inflt fire at rear of lft eng caused by fitting of inlet fuel line to eng driven fuel pump being more than 1 & 1/2 turns from finger tight plt was A&P mech and did maint on a/c and had helped install lft eng 19.8 hrs prior to accident. Lft wing separated… - [NTSB BFO85IA024](https://openairdocs.org/ntsb/BFO85IA024.md): Lockheed L-1011 · Patuxent River, MD · Incident · Minor injuries · Incident investigation · Final report · Mar 5, 1985 · CFTNE · Minor damage > While enroute fm ft lauderdale, FL to montreal, Canada, air Canada flt 087 requested to make an unscheduled lndg due to smoke in the rear of the acft. C-ftne was vectored to Patuxent RVR nas, Patuxent, MD and descended out of FL 370. The smoke was determined… - [NTSB LAX85LA165](https://openairdocs.org/ntsb/LAX85LA165.md): Cessna 172 · Orick, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1985 · N12486 · Destroyed > While in flt at 11,500 ft, the plt began a descent. As the acft reached 2500 ft, the eng began sputtering, then lost power. Subsequently, the acft collided with a wire fence as the plt was approaching to land in an open field. The plt reported that during the… - [NTSB FTW85LA147](https://openairdocs.org/ntsb/FTW85LA147.md): Cessna 152 · Andrews, TX · Accident · No injuries · Limited investigation · Final report · Mar 4, 1985 · N6457L · Substantial damage > Acft experienced a total pwr loss while in cruise flt. During the subsequent forced landing on a dirt road, the nose gear collapsed and the acft nosed over. Examination of the eng revealed severe damage as a result of a failure of the #4 exhaust valve. Due to… - [NTSB CHI85LA129](https://openairdocs.org/ntsb/CHI85LA129.md): Cessna U206G · Angola, IN · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1985 · N6173U · Substantial damage > The plt of the acft began to have difficulty holding alt shortly after level-off at 6000 ft MSL. He stated that it sounded like the eng was flooding. He began a forced descent to the nearest suitable airfield and crossed over the NDB for that field at 3000 ft… - [NTSB BFO85FA023](https://openairdocs.org/ntsb/BFO85FA023.md): Cessna 182 · Frederick, MD · Accident · Serious injuries · Field investigation · Final report · Mar 4, 1985 · N6388A · Destroyed > During cruise flt at 7500 ft the RPM started to decrease until the plt stated that 'it was just like you ran out of gas.' The acft collided with a wooden pwrline pole during the night forced lndg and came to rest inverted. Investigation revealed about 20… - [NTSB MKC85FA066](https://openairdocs.org/ntsb/MKC85FA066.md): Piper PA-23 · Cedar Rapids, IA · Accident · 3 fatal · Field investigation · Final report · Mar 3, 1985 · N1241P · Destroyed > Plt reported no forward vis due to ice on windshield. N1291P then diverted to cid which has rapcon. The temp at the surface was 32 degs f but was reported to be higher at 4,000 ft MSL. The flt climbed to 4,000 ft and began losing the ice but then reported… - [NTSB LAX85FA163](https://openairdocs.org/ntsb/LAX85FA163.md): Cessna 152 · Modesto, CA · Accident · 2 fatal · Field investigation · Final report · Mar 3, 1985 · N103ES · Destroyed > According to witnesses, the plt completed a short checkout and then boarded a female companion in the rented acft, took off and flew to a point 2.9 NM from the airport. The acft was observed by numerous ground witnesses to perform a 'series of wingovers, at… - [NTSB FTW85FA131](https://openairdocs.org/ntsb/FTW85FA131.md): Piper PA-34-220T · Stigler, OK · Accident · 4 fatal · Field investigation · Final report · Mar 3, 1985 · N8160K · Destroyed > The plt filed a VFR flt plan after the wx improved from IFR to VFR with a chance of thunderstorms en route. Ocnl mod turbulence below 5000 ft was forcast due to strong/gusty low lvl wnds. While the acft was en route, a gnd witness heard the engs rev up more… - [NTSB BFO85LA019](https://openairdocs.org/ntsb/BFO85LA019.md): Cessna 177 · Delaware City, DE · Accident · No injuries · Limited investigation · Final report · Mar 3, 1985 · N18038 · Substantial damage > The acft departed charleston, SC at about 1730 with 42 gals (5 hrs) of fuel on board for the planned 4 hr flt to smyrna, DE. Headwinds of 10 to 20 KTS were encountered en route, putting the flt in the smyrna area 45 mins late with only 15 mins of fuel… - [NTSB FTW85LA132](https://openairdocs.org/ntsb/FTW85LA132.md): Cessna A188B · Dequincy, LA · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1985 · N5752G · Destroyed > En route back to a private air strip, according to the plt, the engine failed. The engine re-started and ran for 2 to 3 seconds before stopping. The aerial application acft flew a forced ldg into pine trees coming to a stop suspended above the ground.… - [NTSB CHI85LA133](https://openairdocs.org/ntsb/CHI85LA133.md): Cessna 150L · Lebanon, IN · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N36TD · Substantial damage > The non-instrument rated plt made a forced landing in a muddy fld due to a low fuel state and IFR conditions. The acft nosed over upon touchdown. There was no record found of the plt having received a wx briefing. - [NTSB ATL85LA130](https://openairdocs.org/ntsb/ATL85LA130.md): Cessna 140 · Hawesville, KY · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N89128 · Substantial damage > The plt was on a flt from lordsburg, NM, to mansfield, OH, and could not find hancock county airport, Hawesville, KY. While searching for the airport the engine lost total power due to fuel exhaustion. The plt said that he planned to refuel at hancock co.… - [NTSB ANC85LA050](https://openairdocs.org/ntsb/ANC85LA050.md): Bell UH-1H · Moses Point, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1985 · N58RF · Substantial damage > Aprx 15 miles se of Moses Point the helicopter encountered deteriorating wx. A descent was made to 50 ft above the ice at an airspeed of about 50 KTS. At this time a white out condition was encountered and a right turn was initiated. The right skid contacted… - [NTSB MIA85LA110](https://openairdocs.org/ntsb/MIA85LA110.md): Rockwell 680E · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 1985 · N709G · Destroyed > A coast guard falcon acft was on scene when the acft ditched in the atlantic ocean due to fuel exhaustion. A life raft & marker were dropped by the coast guard acft. A search was conducted all day on 3/1/85 & was called off at sunset on on 3/2/85. The… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=343 ## 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=342 --- 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.