# 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 331 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC86LA050](https://openairdocs.org/ntsb/NYC86LA050.md): Piper PA-28-180 · Mt. Joy, PA · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N7177W · Substantial damage > Piper aircraft was in cruise flight from lancaster, PA to mt joy, PA. When an oil line apparently fractured. An emergecny landing was made in a field. During landing, the nose collapsed and the aircraft was substantially damaged. - [NTSB MIA86LA043](https://openairdocs.org/ntsb/MIA86LA043.md): Lake LA4-200 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N2969P · Substantial damage > The plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through… - [NTSB SEA86LA030](https://openairdocs.org/ntsb/SEA86LA030.md): Bell 47G-3B · Kimberly, ID · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 1985 · N73208 · Substantial damage > A forced landing with a rollover onto snow occurred due to the number 3 cylinder rod failing. - [NTSB MKC86FA033](https://openairdocs.org/ntsb/MKC86FA033.md): Piper PA-32-300 · Omaha, NE · Accident · Serious injuries · Field investigation · Final report · Dec 12, 1985 · N8895E · Substantial damage > N8895E was climbing through 2,800' MSL, 15 min after takeoff and when the pilot retarded the throttle to climb power, the eng quit. The pilot selected an open field for the forced landing but collided with trees during the approach. Examination of the eng… - [NTSB CHI86FA111](https://openairdocs.org/ntsb/CHI86FA111.md): Piper PA-46-310P · Evanston, IL · Accident · No injuries · Field investigation · Final report · Dec 12, 1985 · N4380A · Destroyed > The aircraft was on climbout on an IFR flight plan in VMC conditions when the engine failed. A restart was attempted and the engine ran for a minute or less. Subsequent attempts were unsuccessful. The aircraft was over lake Michigan and had insufficient… - [NTSB LAX86LA062](https://openairdocs.org/ntsb/LAX86LA062.md): Cessna 150K · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Dec 11, 1985 · N6347G · Substantial damage > The plt reported that 5 mins after takeoff the eng reduced to idle pwr, & attempts to restore full pwr were unsuccessful. The plt did state that brief periods of pwr obtained by using the hand primer. The acft was unable to maintain alt & was ditched about 25… - [NTSB LAX86FA063](https://openairdocs.org/ntsb/LAX86FA063.md): Cessna TR182 · Independence, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1985 · N737SG · Destroyed > While en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No… - [NTSB CHI86FA046](https://openairdocs.org/ntsb/CHI86FA046.md): Aerospatiale SA365N · Adrian, MI · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1985 · N5800H · Destroyed > The purpose of this flight was to pick up an injured patient and return him to a medical center. The weather was adequate for a VFR takeoff. However, enroute weather reports indicated fog and probable low ceilings. According to the single survivor of the… - [NTSB LAX86FA061](https://openairdocs.org/ntsb/LAX86FA061.md): Piper PA-28-201T · So. Lake Tahoe, CA · Accident · 3 fatal · Field investigation · Final report · Dec 9, 1985 · N2854R · Destroyed > Prior to departing on a VFR flt from south lake Tahoe, CA, to tracy, CA, the plt failed to obtain a wx briefing or file a flt plan. Wx at the arpt of departure was reported as scattered clouds at 1500 ft, broken ceiling conditions at an estimated 3000 ft,… - [NTSB NYC86FA049](https://openairdocs.org/ntsb/NYC86FA049.md): Cessna 340A · Peru, MA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1985 · N36888 · Destroyed > During IFR flight at 12000 feet both aircraft vacuum pumps failed. Aircraft descended in right turn off radar. Witnesses observed aircraft at low altitude above trees, circle, make steep left turn, climb and descend to ground. - [NTSB MIA86LA040](https://openairdocs.org/ntsb/MIA86LA040.md): Douglas C. Campbell Varieze · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Dec 8, 1985 · N111VE · Substantial damage > The plt stated that the acft lost power, & in an attempt to return to the arpt, the acft collided with a light pole & some orange trees, coming to rest on a canal bank. Post crash examination of the eng revealed that it failed because the #4 rod ass'y… - [NTSB LAX86LA059](https://openairdocs.org/ntsb/LAX86LA059.md): Mooney M20E · Selma, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1985 · N5516Q · Substantial damage > During cruise on a VFR x-country flt, the plt stated that the eng became rough with moderate vibration levels. After shutting down the eng, the plt made a forced landing in a fld, collided with gnd obstructions & collapsed all 3 landing gear. Examination of… - [NTSB FTW86LPA08](https://openairdocs.org/ntsb/FTW86LPA08.md): Cessna 152II · Frisco, TX · Accident · No injuries · Final report · Dec 8, 1985 · N4731H · Substantial damage > The student plt stated that he departed mckinney municipal arpt at aprx 1030 LCL en route to wichita falls, TX. He said he became disoriented while en route, but landed at wichita falls at aprx 1220 LCL. The plt did not refuel the acft. He then departed… - [NTSB ATL86FA037](https://openairdocs.org/ntsb/ATL86FA037.md): Piper PA-28-181 · Clover, SC · Accident · No injuries · Field investigation · Final report · Dec 7, 1985 · N5388F · Substantial damage > The aircraft experienced an engine failure during cruise flight and attempted an emergency landing in a field. During landing roll the aircraft collided with small trees on the FAR end of the field. Post-crash examination of the engine disclosed that the bolt… - [NTSB DEN86LA041](https://openairdocs.org/ntsb/DEN86LA041.md): Cessna 177B · Billings, MT · Accident · No injuries · Limited investigation · Final report · Dec 6, 1985 · N13717 · Substantial damage > The acft was damaged during a forced landing in a fld following a loss of pwr from fuel exhaustion. The plt stated that during the preflight he checked the fuel level by the gages and not visually. The gages indicated slightly over one-half full at that time. - [NTSB DEN86LA040](https://openairdocs.org/ntsb/DEN86LA040.md): Helio H-391B · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Dec 6, 1985 · N4101D · Substantial damage > According to personnel in the area, the plt radioed he had smoke in the cockpit and was returning to gallantin field, his departure point. Later, the plt transmitted that the eng lost total pwr and he was making a forced landing. During the investigation, it… - [NTSB CHI86FA041](https://openairdocs.org/ntsb/CHI86FA041.md): Cessna 320 · Ada, OH · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1985 · N5755X · Destroyed > The pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was… - [NTSB LAX86LA056](https://openairdocs.org/ntsb/LAX86LA056.md): Cessna P210R · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1985 · N5298A · Substantial damage > While descending from 9,500 to 5,000 ft MSL, the plt reported that the eng suddenly lost all power. The plt stated that he was unable to restart the eng & made an emergency landing at a nearby arpt. The plt, who had entered the downwind leg for the 8,251 foot… - [NTSB LAX86LA054](https://openairdocs.org/ntsb/LAX86LA054.md): Piper PA-22 · Deer Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1985 · N3334A · Substantial damage > Shortly after begining descent from 7,500 ft. m.s.l. the acft experienced a total loss of power. Prior to descent the plt richened the mixture and applied carb heat. The pilot radioed his position & situation to Deer Valley tower, Deer Valley, Arizona while… - [NTSB CHI86FA038](https://openairdocs.org/ntsb/CHI86FA038.md): Cessna T210M · Highland, MI · Accident · Minor injuries · Field investigation · Final report · Dec 4, 1985 · N1982M · Substantial damage > Fifteen minutes after takeoff an eng failure occurred. The plt force landed the acft in a fld but the roughness of the landing surface resulted in the nose and right main gear collapsed. Examination disclosed the exhaust vavle had failed in the #4 cylinder.… - [NTSB NYC86LA046](https://openairdocs.org/ntsb/NYC86LA046.md): Cessna 172RG · Mt. Lafayette, NH · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1985 · N5281U · Substantial damage > The acft, while in cruise flt en route to lyndonville, VT, encountered a severed downdraft and the plt was unable to penetrate or climb out of the descent. The acft continued to descend until impact with a mountain occurred. The acft contacted the terrain at… - [NTSB DEN86FA033](https://openairdocs.org/ntsb/DEN86FA033.md): Cessna 421B · Franktown, CO · Accident · Serious injuries · Field investigation · Final report · Dec 2, 1985 · N249JM · Substantial damage > The acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an… - [NTSB MIA86LA037](https://openairdocs.org/ntsb/MIA86LA037.md): Beech 60 · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N7080D · Destroyed > The plt stated that he experienced a loss of power in both engines, made an emerg landing in a cow pasture, & struck a cow on landing rollout. Due to the extent of post crash fire no determination could be made as to the nature of the malfunction of the… - [NTSB DEN86FA038](https://openairdocs.org/ntsb/DEN86FA038.md): Cessna C-182 · Gallup, NM · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1985 · N52599 · Destroyed > The plt departed las cruces, NM, on a VFR flt to Gallup,NM. Approx 23 miles from destination, in mountainous terrain, the non-instrument rated plt encountered unforecast snow storm conditons at night. While the plt was maneuvering toward the destination at a… - [NTSB CHI86FA035](https://openairdocs.org/ntsb/CHI86FA035.md): Beech BE 36 · Odell, IL · Accident · 2 fatal · Field investigation · Final report · Nov 29, 1985 · N3807Z · Destroyed > The plt departed on an IFR flight into known icing conditions after receiving three complete weather briefings clearly indicating the icing conditions with numerous plt reports of icing. Aprx 40 minutes after departure the plt reported he had about an inch of… - [NTSB NYC86LA043](https://openairdocs.org/ntsb/NYC86LA043.md): Cessna 172K · Bloomsburg, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1985 · N7506G · Substantial damage > The acft was on an IFR flt en route to allegheny county arpt at 6000 ft when an electrical failure occurred. The plt executed a precautionary landing in a muddy fld. The nose wheel caught in mud and the acft nosed over. Examination of the electrical system… - [NTSB CHI86IA034](https://openairdocs.org/ntsb/CHI86IA034.md): Boeing 747-251F · Glen Ellyn, IL · Incident · No injuries · Incident investigation · Final report · Nov 28, 1985 · N619US · Minor damage > During climb a bang was heard and the aircraft shuddered. The crew stated that the number three engine oil pressure and oil quantity indicated low. The fire warning light and bell activvated. The engine was shut down and the aircraft landed without further… - [NTSB CHI86FA033](https://openairdocs.org/ntsb/CHI86FA033.md): Piper PA-28-161 · Duluth, MN · Accident · 3 fatal · Field investigation · Final report · Nov 28, 1985 · N8082B · Destroyed > The pilot departed crystal lake for a flight to visit relatives for thanksgiving. He did not obtain a preflight weather briefing nor did he contact any ground facility during the flight. He was qualified to fly in VFR conditions only. The aircraft impacted… - [NTSB MIA86LA036](https://openairdocs.org/ntsb/MIA86LA036.md): Piper PA-23-160 · Dorado, PR · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N4444P · Substantial damage > The plt stated that after a brief local flight he was returning to isla grande arpt when he experienced a loss of power in both engines & made a forced landing on the beach near Dorado puerto rico. Post crash examination of the wreckage revealed that the two… - [NTSB LAX86LA047](https://openairdocs.org/ntsb/LAX86LA047.md): Piper PA-23-250 · Ukiah, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N123 · Substantial damage > While en route to sonoma county arpt, santa rosa, CA, the plt became concerned about the acft fuel state. The plt elected to divert to Ukiah arpt, Ukiah, CA, and while en route the acft experienced total pwr loss due to fuel starvation. During the forced… - [NTSB SEA86LA026](https://openairdocs.org/ntsb/SEA86LA026.md): Hughes 269C · Brooks, OR · Accident · No injuries · Limited investigation · Final report · Nov 24, 1985 · N58181 · Substantial damage > A total loss of power occurred due to the number 4 cylinder failing. A tail boom strike occurred during a hard landing in a parking lot, severing the tail boom. - [NTSB MIA86FA034](https://openairdocs.org/ntsb/MIA86FA034.md): Mooney M20J · Sarasota, FL · Accident · 1 fatal · Field investigation · Final report · Nov 24, 1985 · N201QN · Destroyed > Witnesses reported that shortly after takeoff from a touch and go landing the aircrafts engine sputtered and quit completely. As the pilot was attempting a forced landing the aircraft struck a tree causing the pilot to lose control. The aircraft struck the… - [NTSB ATL86LA030](https://openairdocs.org/ntsb/ATL86LA030.md): Beech A23-19 · Gurley, AL · Accident · No injuries · Limited investigation · Final report · Nov 24, 1985 · N5986S · Substantial damage > About 5 min into third flt of the day, the plt reported a loss of power. During the forced ldg roll out in a pasture field acft struck a ditch causing substantial dmg. Exam of engine revealed failed exh. Value. Eng had been operated 2341 hrs without overhaul. - [NTSB NYC86LA040](https://openairdocs.org/ntsb/NYC86LA040.md): Piper PA-23-250 · West Point, NY · Accident · No injuries · Limited investigation · Final report · Nov 23, 1985 · N54236 · Substantial damage > The acft was returning to university park arpt after passengers were dropped off at waterbury oxford arpt. Aprx 20 minutes into the flt, the acft collided with two birds. The left wing tip was damaged along with a portion of a section of the left wing 3 1/2… - [NTSB MIA86MA032](https://openairdocs.org/ntsb/MIA86MA032.md): Beech 58 · Boca Raton, FL · Accident · 6 fatal · Major investigation · Final report · Nov 23, 1985 · N3862Y · Destroyed > According to witnesses, the plt took off on rwy 4, then turned left toward the southwest & flew parallel with the rwy at a distance of about 1/4 to 1/2 mi. He leveled the acft at aprx 200' AGL, just below the clouds, until aprx abeam of midfield, then he… - [NTSB MIA86LA031](https://openairdocs.org/ntsb/MIA86LA031.md): Enstrom F-28F · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1985 · N86229 · Destroyed > The plt stated he felt the eng RPM decrease, so he opened up the throttle and lowered the collective. When these actionsdid not produce the desired RPM he tried to land in a plowed fld, the skids dug in the soft dirt and caused the helicopter to roll over.… - [NTSB DEN86FA028](https://openairdocs.org/ntsb/DEN86FA028.md): Piper PA-28RT-201T · Cheyenne Wells, CO · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1985 · N2925U · Destroyed > The plt obtained a wx briefing prior to departing apa. There was a cold frontal system moving down from the north but wx was forecast to be VFR for the remainder of the day. The plt and a plt-pax flew to jln where the plt-pax disembarked. The plt did not… - [NTSB CHI86LA032](https://openairdocs.org/ntsb/CHI86LA032.md): Rockwell 112 · Pekin, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1985 · N10285 · Substantial damage > Following a top overhaul of the engine a test flight was planned to break in the cylinders and rings. Prior to this flight the engine was operated for a short period on the ground then shut down and checked for oil leaks with negative results. The takeoff and… - [NTSB CHI86FA031](https://openairdocs.org/ntsb/CHI86FA031.md): Piper PA-28-161 · Washington Twp., IN · Accident · 2 fatal · Field investigation · Final report · Nov 21, 1985 · N2170X · Destroyed > The pilot and pax were returning from a xcountry flt. While on a long final approach the acft was witnessed to stall and fall off on the left wg. The acft then descended into a wooded area causing left wg separation and then impacted a creek bank. At the time… - [NTSB MIA86LA030](https://openairdocs.org/ntsb/MIA86LA030.md): Cessna 210M · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Nov 19, 1985 · N823AR · Substantial damage > While in cruise flight the pilot attempted to lower the landing gear and the right main landing gear would not extend. During this process the aircraft generator went off the line. The pilot attempted to manually lower the landing gear and extended the nose… - [NTSB LAX86LA043](https://openairdocs.org/ntsb/LAX86LA043.md): Hughes 369D · Kunia, Oahu, HI · Accident · No injuries · Limited investigation · Final report · Nov 19, 1985 · N58395 · Substantial damage > While cruising the plt detected a loss of engine power & elected to make a precautionary landing. During landing flare engine power was lost & the acft touched down hard & with excessive ground speed. Exam of the acft's fuel control valve governor failed to… - [NTSB LAX86FA042](https://openairdocs.org/ntsb/LAX86FA042.md): Piper PA 28-151 · Lebec, CA · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1985 · N43602 · Destroyed > After receiving a preflight wx briefing that forecast strong headwinds, over mountainous terrain, severe turbulence and pireps of severe turbulence on the proposed flt route. The instructor plt and his student instrument plt took off for a night IFR training… - [NTSB DEN86LA025](https://openairdocs.org/ntsb/DEN86LA025.md): Balloon Works Firefly 6B · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1985 · N4052K · Substantial damage > The plt stated that while on a Balloon flt, the blast valve, which operates the burner flame, stuck open during one of the burns. The plt attempted unsuccessfully to disengage the blast valve. When the plt could not stop the flame with the blast valve, he… - [NTSB LAX86LA041](https://openairdocs.org/ntsb/LAX86LA041.md): Cessna 177A · Springerville, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1985 · N30351 · Substantial damage > The plt stated that the eng oil pressure dropped to zero while the acft was in cruise flight. He selected an open field in which to make a precautionary landing. He said that as he approached the field the acft entered a downdraft. He stated he had reduced… - [NTSB FTW86LPJ03](https://openairdocs.org/ntsb/FTW86LPJ03.md): Cessna 182 · Goldsby, OK · Accident · No injuries · Final report · Nov 16, 1985 · N6001B · Destroyed > The plt stated the purpose of the flt was to drop parachute jumpers. The jumpers deplaned at 8500 ft MSL and the plt reduced pwr for a descent and landing at the arpt of departure. He stated he did not apply carb heat during the entire descent and he entered… - [NTSB ANC86FA009](https://openairdocs.org/ntsb/ANC86FA009.md): Piper PA-32-300 · Quinhagak, AK · Accident · 4 fatal · Field investigation · Final report · Nov 16, 1985 · N74DJ · Destroyed > The aircraft crashed on the frozen level tundra at night while on a part 135 air taxi flight from bethel to quinhagaki Alaska. The investigation revealled the commericial rated air taxi pilot did not have a 135 air taxi check ride or competency check. The… - [NTSB ATL86FA025](https://openairdocs.org/ntsb/ATL86FA025.md): Cessna 182Q · Edenton, NC · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1985 · N735SS · Substantial damage > The aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated… - [NTSB MKC86FA027](https://openairdocs.org/ntsb/MKC86FA027.md): Cessna 210K · Baxter Springs, KS · Accident · 4 fatal · Field investigation · Final report · Nov 13, 1985 · N5772J · Destroyed > After lndg at neosho, MO, the plt called the joplin fss at 1132 CST & reqd wx info for a flt to hays, KS. The specialistadvised that his wx computer was out of svc & suggested the plt contact another facility or call back in about 20 min. The plt indicated he… - [NTSB LAX86FA037](https://openairdocs.org/ntsb/LAX86FA037.md): Beech 35 · Avenal, CA · Accident · 1 fatal · Field investigation · Final report · Nov 11, 1985 · N50CN · Destroyed > The plt received a weather briefing (twice) and was advised each time that VFR flt along his route was not recommended. A witness observed the acft flying at a low alt below a cloud layer, when it made an abrupt left descending turn and crashed in a field.… - [NTSB LAX86FA038](https://openairdocs.org/ntsb/LAX86FA038.md): Grumman American AA-5B · Gold Run, CA · Accident · 3 fatal · Field investigation · Final report · Nov 10, 1985 · N28495 · Destroyed > The accident location and the departure airport is located in a mountainous area. The acft departed truckee-tahoe arpt (trk) to the northeast in marginal VFR conditions at sunset. The acft continued on a northeasterly heading for 18 miles and then turned to a… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=332 ## 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=331 --- 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.