# 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 293 of 718 · 35,885 cases ## Cases, newest first - [NTSB ATL89LA028](https://openairdocs.org/ntsb/ATL89LA028.md): Cessna T210M · Sheperdsville, KY · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1988 · N732WC · Destroyed > The pilot had flown a Cessna 172 to tampa to pick up a Cessna T210M for a flight to louisville, KY. The 210 had been previously flown to tampa from ft. myers by the owner. After a preflight in which the pilot said he visually verified that the fuel tanks were… - [NTSB MKC89LA020](https://openairdocs.org/ntsb/MKC89LA020.md): Piper PA-28-235 · Leon, IA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1988 · N9246W · Substantial damage > While cruising about 3000 feet AGL during a personal flight, the engine had a complete power failure. A successful emergency ldg was made on a farm hay field with no damage incurred. Shortly after the ldg, smoke was observed coming from the engine… - [NTSB NYC89FA022](https://openairdocs.org/ntsb/NYC89FA022.md): Cessna 207 · Monoghan, PA · Accident · 1 fatal · Field investigation · Final report · Nov 5, 1988 · N91036 · Destroyed > Evidence indicates that the airplane flew straight into the side of a 1320 ft mountain at the 1280 ft level. The recommended minimum flight altitude for this designated mountainous area, at night, is 3500 ft. there was no evidence of any mechanical problems. - [NTSB ATL89FA024](https://openairdocs.org/ntsb/ATL89FA024.md): Piper PA-28R-201T · Bridgeport, WV · Accident · 1 fatal · Field investigation · Final report · Nov 5, 1988 · N39550 · Substantial damage > The plt was cleared to execute a visual approach to rwy 21 and was issued the current alt setting of 29.60' hg. The approach was made under dark night and gusty crosswind conditions to a lighted runway in rural mountainous/hilly terrain. During final approach… - [NTSB NYC89LA020](https://openairdocs.org/ntsb/NYC89LA020.md): Cessna 185 · Ebensburg, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1988 · N4023Y · Destroyed > The acft experienced a total loss of power and crashed in trees near Ebensburg, PA. A teardown inspection revealed extensive preimpact damage to the engine. The #3 main bearing had failed, causing the interruption of oil supply to the #4 and 5 bearings and… - [NTSB NYC89LA072](https://openairdocs.org/ntsb/NYC89LA072.md): Boeing B-747-123 · Bridgetown, Bahamas · Accident · Serious injuries · Limited investigation · Final report · Nov 3, 1988 · N9674 · No damage > The failure of the flight attendant to notice that the elevator was not present as she entered the elevator shaft and prior to closing the door. - [NTSB LAX89FA032](https://openairdocs.org/ntsb/LAX89FA032.md): Piper PA-28R-200 · Anaheim, CA · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1988 · N9467N · Substantial damage > Five minutes after departure and during normal cruise flight, the certified flight instructor noticed a prop overspeed. He immediately pulled back on the prop control to reduce engine r.p.m. and instructed the student, a private pilot, to divert to the… - [NTSB DEN89IA028](https://openairdocs.org/ntsb/DEN89IA028.md): Beech S-35 · Matheson, CO · Incident · No injuries · Incident investigation · Final report · Nov 3, 1988 · N977KM · Minor damage > The private plt and a friend were enroute for a hunting trip. Thirty miles east of a refueling stop, the pilot heard a loud knock. Oil covered the windscreen and the engine seized. The plt looked out the side window vent to select a forced landing area. A… - [NTSB SEA89FA015](https://openairdocs.org/ntsb/SEA89FA015.md): Beech 65 · Elko, NV · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1988 · N9AG · Destroyed > Approx 10 min after t/o, the pilot stated he was returning to land due to a problem. On final the acft rolled inverted and descended nose down into a residence. Engine exam revealed a failed supercharger intermediate drive shaft gear resulting in loss of… - [NTSB MIA89MA023](https://openairdocs.org/ntsb/MIA89MA023.md): Rockwell 1121A · Oak Grove, PA · Accident · 3 fatal · Major investigation · Final report · Nov 2, 1988 · N44 · Destroyed > Failure of the pilot in command to observe the rapid accretion of ice on the airplane due to his attention being diverted. - [NTSB LAX89FA030](https://openairdocs.org/ntsb/LAX89FA030.md): Cessna 421A · Cabazon, CA · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1988 · N3385Q · Destroyed > The pilot's poor decision and misjudgement of distance. The separation of the cylinder, failure of the propeller to feather, and impact with wires and a residence were factors in the accident. - [NTSB ATL89FA222](https://openairdocs.org/ntsb/ATL89FA222.md): Piper PA-28-181 · Alexander City, AL · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1988 · N8211P · Substantial damage > On 10/31/88, the plt obtained wx info & filed an IFR flt plan fm vero beach, FL, to huntsville, AL. At aprx 1513 EST, hectcd ATC & rprtd climbing thru 1500' for 3000'. About 2.4 hrs later, he rprtd a loss of eng pwr. Vectors were provided toward an arpt, but… - [NTSB LAX89DUG01](https://openairdocs.org/ntsb/LAX89DUG01.md): Klob-Gordon TWIN-STAR · Lake Elsinore, CA · Accident · Serious injuries · Final report · Oct 30, 1988 · N50913 · Substantial damage > During a pleasure flight, the pilot reduced the engine power to talk to the passenger. When the pilot applied power, the engine did not respond. The airplane was glided to a nearby airport; however, the airplane landed short. The pilot verbally reported there… - [NTSB BFO89LA005](https://openairdocs.org/ntsb/BFO89LA005.md): Piper PA-28R-200 · Dover, DE · Accident · No injuries · Limited investigation · Final report · Oct 29, 1988 · N2074T · Substantial damage > After takeoff the plt began a cruise climb to 5500 ft. he rprtd that when the acft reached 5200 ft, he noticed oil spraying from underneath the front of the eng cowling. The oil eventually covered the windscreen. The plt diverted toward a nearby arpt, but the… - [NTSB MIA89LA017](https://openairdocs.org/ntsb/MIA89LA017.md): Cessna 172N · Houston, MS · Accident · No injuries · Limited investigation · Final report · Oct 28, 1988 · N21ER · Substantial damage > During normal cruise flt a portion of one propeller blade separated. The plt landed the acft in a field & during the landing roll, the acft collided with a haystack. Examination of the propeller blade revealed it separated at blade station 28.5. Metallurgical… - [NTSB FTW89LA010](https://openairdocs.org/ntsb/FTW89LA010.md): Hughes 269C · Dickens, TX · Accident · No injuries · Limited investigation · Final report · Oct 27, 1988 · N7463F · Destroyed > The pilot was inspecting a herd of cattle when he thought the helicopter was developing a problem with the engine and main rotor. He started an autorotation, lost tail rotor control, and went into a left spin which continued to contact with the ground.… - [NTSB DEN89LA021](https://openairdocs.org/ntsb/DEN89LA021.md): Cessna 175 · Fort Peck, MT · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1988 · N7403M · Substantial damage > The plt enctrd hvy snow at night & turned back to find a nearby landing strip that he was familiar with. He recognized a ranch house associated with the strip, but was unable to find the landing area. He began to circle in hopes that someone would turn on the… - [NTSB NYC89LA019](https://openairdocs.org/ntsb/NYC89LA019.md): Beech 60 · Norwood, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 1988 · N8PX · Destroyed > The pilot had just climbed to 2500 feet when the right engine started to sputter. When he placed the fuel selector in crossfeed, both engines quit. The pilot elected to land in a field leading to substantial damage to the nose, wings, and tail section of the… - [NTSB MKC89FA014](https://openairdocs.org/ntsb/MKC89FA014.md): Taylorcraft BC-12D · Lenexa, KS · Accident · Serious injuries · Field investigation · Final report · Oct 25, 1988 · N39231 · Substantial damage > The PIC had been drinking alcoholic beverages before the flt and had taken the prescription anti-depresion drug pamelor. In combination, the adverse side-effects of the drug are magnified. The PIC decided to fly instead of drive to visit a friend working the… - [NTSB MKC89IA012](https://openairdocs.org/ntsb/MKC89IA012.md): Saab-Scania 340A · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Oct 24, 1988 · N347AM · Minor damage > The a.c. generator mounted on the left engine failed and resulted in an in-flight fire. The captain elected to shut down the left engine and divert the flight to the Springfield, Missouri regional airport. A single engine precautionary landing was completed… - [NTSB FTW89LA008](https://openairdocs.org/ntsb/FTW89LA008.md): Cessna 172 · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 1988 · N7185Q · Destroyed > The airplane had been flown for 2.2 hours since refueling when this pilot started his flight. This pilot flew the airplane for 2.5 hours and the engine quit. During the forced landing, the airplane impacted a power pole and power lines, and then the terrain.… - [NTSB MKC89LA015](https://openairdocs.org/ntsb/MKC89LA015.md): Cessna 172 · Blue Springs, MO · Accident · No injuries · Limited investigation · Final report · Oct 22, 1988 · N50932 · Substantial damage > The plt said, while cruising over a water reservoir at about 500 feet AGL, he collided with two waterfowl, believed to be geese. One struck the wing tip, the other near the wing root. Acft control remained constant with no control problems encountered, and… - [NTSB FTW89FA006](https://openairdocs.org/ntsb/FTW89FA006.md): Mooney M20E · Longview, TX · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1988 · N79373 · Destroyed > The airplane was in cruise flight when the pilot transmitted that he had smoke in the cockpit. 53 seconds later contact was lost. The nose and left wing were slightly down when the acft struck trees and terrain at high speed. Fire started several minutes… - [NTSB CHI89LA015](https://openairdocs.org/ntsb/CHI89LA015.md): Cessna 175A · Wyoming, MN · Accident · No injuries · Limited investigation · Final report · Oct 22, 1988 · N7063E · Substantial damage - [NTSB MIA89LA013](https://openairdocs.org/ntsb/MIA89LA013.md): Piper PA-23-250 · Tupelo, MS · Accident · No injuries · Limited investigation · Final report · Oct 21, 1988 · N6877Y · Substantial damage > The operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running… - [NTSB DEN89FA020](https://openairdocs.org/ntsb/DEN89FA020.md): Piper PA-60-601P · Laketown, UT · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1988 · N6069U · Destroyed > The plt departed salt lake city on a pleasure flt to bear lake to overfly a home that he owned. Witnesses near the acc site stated they saw the acft circle over the house and then depart the area over a ridge of mtns. The acft turned out over the lake and was… - [NTSB DEN89FA019](https://openairdocs.org/ntsb/DEN89FA019.md): Bell 206L-3 · Deckers, CO · Accident · 2 fatal · Field investigation · Final report · Oct 19, 1988 · N99TV · Destroyed > While on a corporate flt thru a canyon in marginal wx conds, the helicopter collided with the static portion of a power transmission line & crashed. The acdnt occurred where a 2,554 ft span of the power line crossed the south platte river. The power line… - [NTSB DEN89DTM01](https://openairdocs.org/ntsb/DEN89DTM01.md): Mickelson Mark V · Ogden, UT · Accident · 1 fatal · Final report · Oct 19, 1988 · N555KM · Destroyed > Total loss of engine power for reasons undetermined which resulted in a forced landing. The pilot inadvertently stalled the aircraft during the forced landing, and that is considered a factor in the accident. - [NTSB ATL89LA014](https://openairdocs.org/ntsb/ATL89LA014.md): Rockwell 114 · Palma, KY · Accident · No injuries · Limited investigation · Final report · Oct 19, 1988 · N4753W · Substantial damage > The pilot reported a complete engine failure while descending to traffic pattern altitude. The attempts to restart the engine failed. The pilot crashed in a field. The investigation disclosed an internal magneto timing of 30 and 27 degrees respectively. The… - [NTSB DEN89FA017](https://openairdocs.org/ntsb/DEN89FA017.md): Piper PA-28-140 · Garfield, CO · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1988 · N3913K · Destroyed - [NTSB ATL89FA015](https://openairdocs.org/ntsb/ATL89FA015.md): Cessna 177A · La Follette, TN · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1988 · N30470 · Destroyed > The plt departed knoxville in VFR conds. There was an area of IFR wx to the north & northwest of knoxville. The wx was forecast to be marginal along his route of flt. The plt rprtd he wanted to depart knoxville on a heading of 360 deg & would be at 2500'. The… - [NTSB NYC89FA013](https://openairdocs.org/ntsb/NYC89FA013.md): Bell 206L-1 · Wallingford, CT · Accident · Serious injuries · Field investigation · Final report · Oct 16, 1988 · N555GC · Destroyed > The acft lost power and crashed in a tractor trailer parking lot, destroying the helicopter and causing serious injuries to the pilot and one passenger. The investigation revealed an improper fuel flow switch, which had no check valve protection installed on… - [NTSB LAX89FA014](https://openairdocs.org/ntsb/LAX89FA014.md): Piper PA-32-300 · Sedona, AZ · Accident · 5 fatal · Field investigation · Final report · Oct 16, 1988 · N4113R · Destroyed > Total failure of the magneto's impulse coupling which resulted in a shearing of the crankshaft's idler gear teeth and the crankshaft dowel pin. - [NTSB FTW89FA007](https://openairdocs.org/ntsb/FTW89FA007.md): Piper PA-31-350 · Edinburg, TX · Accident · No injuries · Field investigation · Final report · Oct 16, 1988 · N91BB · Destroyed > Acft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's… - [NTSB CHI89LA010](https://openairdocs.org/ntsb/CHI89LA010.md): Piper PA-28-151 · Fairview Hts., IL · Accident · No injuries · Limited investigation · Final report · Oct 16, 1988 · N4545F · Substantial damage > Fuel exhaustion due inaccurate fuel consumption calculations. - [NTSB CHI89FA009](https://openairdocs.org/ntsb/CHI89FA009.md): Mooney M20J · Ludington, MI · Accident · 2 fatal · Field investigation · Final report · Oct 16, 1988 · N58155 · Destroyed > The pilot in command failed to maintain proper altitude utilizing basic flight instruments while experiencing a loss of gyro instruments. - [NTSB SEA89LA012](https://openairdocs.org/ntsb/SEA89LA012.md): Laycock Baby Great Lakes · Graham, WA · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 1988 · N8519K · Substantial damage > Eng lost pwr while in cruise on local flt. Plt attempted to return to field but contacted trees during emerg descent to forced lndg. Investigation revealed presence of water in fuel system. Fuel sediment bowl was automotive type with aviation drain installed.… - [NTSB MKC89LA005](https://openairdocs.org/ntsb/MKC89LA005.md): Piper PA-28-151 · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1988 · N5378F · Substantial damage > While conducting a part 135 air taxi operation, the pilot said his engine began running rough about 7 miles from his destination apt. Emergency procedures were initiated and a call to the control tower declaring an emergency was made. Unable to reach the apt,… - [NTSB DEN89LA014](https://openairdocs.org/ntsb/DEN89LA014.md): Beech 58 · Garfield, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1988 · N31135 · Substantial damage > N31135 was being ferried to japan from wichita with an enroute stop in oakland, CA. The acft was equipped with cabin mounted ferry tanks. The plt stated that he switched from the acft fuel tanks to the ferry tank and about 20 minutes later the right eng quit.… - [NTSB ATL89DLT02](https://openairdocs.org/ntsb/ATL89DLT02.md): Schweizer SGU-2-22E · Benton, TN · Accident · No injuries · Final report · Oct 15, 1988 · N9847E · Destroyed > As the student pilot was attempting a dual aerial tow flight at 100 feet AGL, he experienced difficulty in staying behind the tow plane. The instructor took over the controls and while applying full right aileron noted no aileron movement. At 300 feet AGL the… - [NTSB CHI89LA011](https://openairdocs.org/ntsb/CHI89LA011.md): Piper PA-24-180 · Alexandria, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 1988 · N8088P · Substantial damage > Poor judgement of the plt by flying while physically impaired from consumption of alcohol, his improper inflight planning/decision, and fuel exhaustion from his inadequate supply of fuel. The light conditions at night and uneven terrain (highway median) were… - [NTSB ATL89DLT01](https://openairdocs.org/ntsb/ATL89DLT01.md): Cameron AIR Command · Hixson, TN · Accident · 1 fatal · Final report · Oct 14, 1988 · N169WC · Destroyed > Witnesses observed the gyrocopter oscillating in the pitch axis as it passed overhead in cruise flight. A 'white or shiny' object departed the gyrocopter. The aircraft then rolled right, descended and collided with the trees and ground, inverted. One… - [NTSB SEA89FA010](https://openairdocs.org/ntsb/SEA89FA010.md): Piper PA-28-180 · Sun Valley, ID · Accident · 1 fatal · Field investigation · Final report · Oct 12, 1988 · N8975J · Destroyed > The pilot flew into a box canyon at a low altitude above the ground near 9000 ft MSL. While attempting to climb over a ridgeline, the aircraft stalled, entered a spin, and descended nose down until impact with the ground. - [NTSB ATL89MA012](https://openairdocs.org/ntsb/ATL89MA012.md): Aerospatiale ATR-42-300 · Yardley, PA · Incident · No injuries · Major investigation · Final report · Oct 12, 1988 · N17810 · 2 aircraft · No damage > Bfr tkof, corrected flt plan was put in ATC computer for airforce 1 (AF1) to take nonstandard rte to newark. After tkof,AF1 was vctrd nw with handoff to NY ARTCC (zny), then east via Yardley (ard) to newark; 15 mi west of ard, zny initiatedhandoff to NY… - [NTSB NYC89LA011](https://openairdocs.org/ntsb/NYC89LA011.md): Cessna 172 · Lancaster, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1988 · N9108B · Substantial damage > The pilot of the Cessna 172 was returning solo from atlantic city when the aircraft ran out of fuel. He landed in a corn field and the aircraft flipped over. Examination of the wreckage revealed no fuel in the aircraft. The plt said he fueled the acft with 20… - [NTSB FTW89LA003](https://openairdocs.org/ntsb/FTW89LA003.md): Cessna 140 · Fairfax, OK · Accident · Serious injuries · Limited investigation · Final report · Oct 11, 1988 · N11191 · Substantial damage > The plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the… - [NTSB CHI89LA004](https://openairdocs.org/ntsb/CHI89LA004.md): Piper PA-28-181 · Indianapolis, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1988 · N8112T · Destroyed > The pilot and his family of three were returning from a vacation in Florida. They made a fuel stop at columbus, Georgia, then tried to fly non-stop from there to kokomo, Indiana. About 50 miles short of the intended destination, the engine lost power due to… - [NTSB ANC89LA007](https://openairdocs.org/ntsb/ANC89LA007.md): Cessna 207 · Perde Bay, AK · Accident · No injuries · Limited investigation · Final report · Oct 10, 1988 · N9965M · Substantial damage > The pilot experienced a power loss during cruise flight and during his descent the engine stopped producing power. He landed on the tundra and the airplane was substantially damaged. An engine teardown revealed that the number 4 piston was burned past… - [NTSB DEN89LA013](https://openairdocs.org/ntsb/DEN89LA013.md): Raven S-60A · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1988 · N3592C · Substantial damage > The plt, with two pax aboard a hot air balloon, participated in the 1988 Albuquerque, NM international balloon fiesta. The plt said he received a wx briefing and then departed in VFR wx conditions. After aprx 45 min of flt, the plt said he encountered… - [NTSB CHI89LA012](https://openairdocs.org/ntsb/CHI89LA012.md): Cessna 182 · Sparta, IL · Accident · No injuries · Limited investigation · Final report · Oct 9, 1988 · N4717D · Substantial damage Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=294 ## 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=293 --- 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.