# NTSB investigations: Initial climb 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 212 of 412 · 20,559 cases ## Cases, newest first - [NTSB SEA82DA134](https://openairdocs.org/ntsb/SEA82DA134.md): Maule M-5-210C · Klamath Falls, OR · Accident · No injuries · Final report · Jul 31, 1982 · N88JS · Substantial damage > Drg tkof, the plt ntoed a partial pwr loss & elected to make a prctnry lndg on the remaining rwy (length 10,300'). Whileaborting, he flared late & lndd hard. Water & products of corrosion were fnd in the gascolator. An investigation revealed the acft was… - [NTSB NYC82DA183](https://openairdocs.org/ntsb/NYC82DA183.md): Schweizer SGS-2-33A · Eighty Four, PA · Accident · No injuries · Final report · Jul 31, 1982 · N7774S · Substantial damage > The tow line released at 40 feet AGL in a glider tow launch. The glider pilot tried to land on the runway but landed adjacent to it and collided with a tree which ground-looped the glider. The tow hitch mechanism was broken off at the tubing cluster & was… - [NTSB NYC82DA177](https://openairdocs.org/ntsb/NYC82DA177.md): Cessna 150L · Williamson, NY · Accident · Minor injuries · Final report · Jul 31, 1982 · N6924G · Substantial damage > During a dual instructional flight the pilot experienced a power loss during takeoff while practicing touch and go landings. The aircraft was forced to land in an orchard and collided with trees. - [NTSB MKC82DA135](https://openairdocs.org/ntsb/MKC82DA135.md): Bell 47J-2 · Chesterfield, MO · Accident · No injuries · Final report · Jul 31, 1982 · N4070B · Substantial damage > The pilot stated that he took off and was going through translational lift at about 15 to 20 ft AGL when he heard a loud bang. He said the loud bang was accompanied by a power loss. An immediate descent was made and the helicopter was landed hard with a… - [NTSB LAX82FYM18](https://openairdocs.org/ntsb/LAX82FYM18.md): Piper PA-28RT-201 · San Carlos, CA · Accident · No injuries · Final report · Jul 31, 1982 · N2090W · Substantial damage > After landing at the airport, the pilot taxied to the transient parking area, parked and got a cup of coffee. He stated that he then made a quick preflight check, but did not visually inspect the fuel tanks. During the takeoff, the engine began to surge at… - [NTSB FTW82DA312](https://openairdocs.org/ntsb/FTW82DA312.md): Cessna 177 · Springer, NM · Accident · No injuries · Final report · Jul 31, 1982 · N30157 · Substantial damage > While en route on a flight from gallup, NM to dalhart, TX, the left fuel tank would not feed. The pilot made a precautionary landing on rough, grassy terrain with no damage. An examination revealed that the tab for the left filler cap was broken and the cap… - [NTSB CHI82DA287](https://openairdocs.org/ntsb/CHI82DA287.md): Beech A23A · Grantsburg, WI · Accident · No injuries · Final report · Jul 31, 1982 · N3683Q · Substantial damage > The pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an… - [NTSB ATL82FLT05](https://openairdocs.org/ntsb/ATL82FLT05.md): Varga 2180 · Arlington, TN · Accident · Serious injuries · Final report · Jul 31, 1982 · N5600M · Substantial damage > The pilot made a precautionary landing during a cross country flight due to low fuel. After deciding he had enough fuel to continue, the pilot elected to takeoff. During the initial climb the engine quit. An emergency landing was made in a cotton field. - [NTSB SEA82FAD01](https://openairdocs.org/ntsb/SEA82FAD01.md): Lake LA-4-200 · Ketchikan Intl., AK · Accident · 1 fatal · Final report · Jul 30, 1982 · N2708P · Destroyed > Departing under a special VFR clearance, the acft entered IMC within a period of approximately 15 secs after takeoff. The acft struck trees & the ground approximately 2 mi south of the airport. - [NTSB FTW82FPD17](https://openairdocs.org/ntsb/FTW82FPD17.md): Mooney M20 · Abilene, TX · Accident · Serious injuries · Final report · Jul 30, 1982 · N8393E · Destroyed > At about 50-75 ft AGL after takeoff the eng quit. Both tanks contained adequate fuel & no eng malfunctions were found. - [NTSB FTW82DA302](https://openairdocs.org/ntsb/FTW82DA302.md): Douglas DC-3C · El Paso, TX · Accident · Minor injuries · Final report · Jul 30, 1982 · N102BL · Substantial damage > Shortly after takeoff at about 800 ft AGL, the left engine oil temperate became high and reportedly there was a loss of oil pressure. The pilot reported that he then feathered the left engine and declared an emergency. On final approach, he did not get a safe… - [NTSB MKC82DA133](https://openairdocs.org/ntsb/MKC82DA133.md): Beech E-35 · Calamus, IA · Accident · No injuries · Final report · Jul 29, 1982 · N3476B · Substantial damage > While demonstrating the use of the acft's fuel system during eng runup, the plt mistakingly left the fuel selector on the fuselage aux tank which contained only a small amount of fuel. When the eng quit after lift-off, the plt moved the selector to the left… - [NTSB FTW82AA299](https://openairdocs.org/ntsb/FTW82AA299.md): Robertson C-414 · Lindale, TX · Accident · 12 fatal · Final report · Jul 29, 1982 · N110VM · Destroyed > 7-Seat acft took off with 4 adults & 8 children aboard. Acft rotated at about 2000 ft down rwy & climbed in a flat nose high attitude before settling into 30 ft trees about 4223 ft from point of lift-off. Acft oscillated violently 2 or 3 times in the pitch… - [NTSB CHI82DA277](https://openairdocs.org/ntsb/CHI82DA277.md): Cessna 172P · Bruce, WI · Accident · Minor injuries · Final report · Jul 28, 1982 · N53056 · Substantial damage > The pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and… - [NTSB FTW82DA296](https://openairdocs.org/ntsb/FTW82DA296.md): Lake LA-4 · Springdale, AR · Accident · No injuries · Final report · Jul 26, 1982 · N7635L · Substantial damage > During takeoff from a touch-and-go landing, the engine went to about idle power. During a forced landing, the left wing and nose collided with trees. Reportedly, the engine started developing full power just as the aircraft collided with trees. No mechanical… - [NTSB FTW82DA295](https://openairdocs.org/ntsb/FTW82DA295.md): Cessna 150L · Franklinton, LA · Accident · No injuries · Final report · Jul 26, 1982 · N5482Q · Substantial damage > During takeoff, the engine lost power when the aircraft was climbing through about 500 ft AGL. The instructor took the controls, made a shallow turn to a clearing, and landed in a field covered with underbrush and tree stumps. The plane was substantially… - [NTSB SEA82FYP10](https://openairdocs.org/ntsb/SEA82FYP10.md): Piper PA-22-150 · Tieton, WA · Accident · Serious injuries · Final report · Jul 25, 1982 · N8741D · Substantial damage > After takeoff, the pilot turned to the left, but then he was unable to clear trees while climbing over rising terrain. A witness that saw the plane turn after takeoff stated that most airplanes continue climbing over a nearby lake and gain altitude before… - [NTSB NYC82DA168](https://openairdocs.org/ntsb/NYC82DA168.md): Piper PA-18S · Moultonboro, NH · Accident · No injuries · Final report · Jul 25, 1982 · N64BC · Substantial damage > According to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was… - [NTSB NYC82DA166](https://openairdocs.org/ntsb/NYC82DA166.md): Cessna U206G · Batavia, NY · Accident · No injuries · Final report · Jul 25, 1982 · N8198G · Substantial damage > The aircraft had been parked at the genesee county airport since the fall of 1981. The accident flight was the first the aircraft had flown since the fall. As the aircraft cleared the end of the runway, and attained an altitude of approximately 300 feet, a… - [NTSB ATL82FA212](https://openairdocs.org/ntsb/ATL82FA212.md): Cessna 182A · Louisburg, NC · Accident · 4 fatal · Field investigation · Final report · Jul 25, 1982 · N5188D · Destroyed > Witnesses observed the takeoff roll as being unusually long. The acft never climbed much above 100-200 ft AGL, & struck trees 1/2 mi off the end of the rwy. The flaps were observed up during takeoff. Normal takeoff flap setting used by the club for carrying… - [NTSB ATL82DA210](https://openairdocs.org/ntsb/ATL82DA210.md): Cessna 182 · Mobile, AL · Accident · Minor injuries · Final report · Jul 25, 1982 · N735RF · Substantial damage > The pilot experienced a power loss during takeoff and made an emergency landing in a soft soybean field. The aircraft nosed over after landing. Water was found in the fuel in the left tank and carburetor. The pilot had also found water inthe left tank during… - [NTSB SEA82DYK10](https://openairdocs.org/ntsb/SEA82DYK10.md): Beech S35 · Mckenzie Bridge, OR · Accident · 2 fatal · Final report · Jul 24, 1982 · N7932K · Destroyed > The aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.… - [NTSB SEA82DA127](https://openairdocs.org/ntsb/SEA82DA127.md): Grumman G-164A · Burley, ID · Accident · No injuries · Final report · Jul 24, 1982 · N9532 · Destroyed > At about 20 ft AGL after takeoff the eng quit. The cause of the eng failure could not be determined. - [NTSB FTW82DA300](https://openairdocs.org/ntsb/FTW82DA300.md): Schleicher ASW-20 · Hempstead, TX · Accident · Minor injuries · Final report · Jul 24, 1982 · N13JR · Substantial damage > The pilot stated that the glider was assembled at the site. He reported that after becoming airborne, he obviously did not have pitch control. He released the tow rope at about 25 ft AGL and aborted. The glider landed hard on the fuselage, forward of the… - [NTSB ATL82FA208](https://openairdocs.org/ntsb/ATL82FA208.md): Beech B-60 · Sylva, NC · Accident · Minor injuries · Field investigation · Final report · Jul 24, 1982 · N6648X · Substantial damage > The aircraft crashed during takeoff after the pilot reported a loss of power on the left engine. The aircraft slid to a stop about 600 feet southeast of the departure end of runway 32. The pilots statement and physical evidence do not correlate. The prop… - [NTSB NYC82DA163](https://openairdocs.org/ntsb/NYC82DA163.md): Cessna 150H · Ansonia, CT · Accident · No injuries · Final report · Jul 23, 1982 · N7291S · Destroyed > The pilot flew to another local airport to practice touch and go landings. During the takeoff from the 1750 foot runway the aircraft stalled into the trees. The pilot stated that the aircraft settled into the tree tops when he maneuvered to avoid power lines. - [NTSB CHI82DA268](https://openairdocs.org/ntsb/CHI82DA268.md): Piper PA-38 · Antioch, IL · Accident · No injuries · Final report · Jul 23, 1982 · N2365P · Destroyed > The pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that… - [NTSB NYC82FGT16](https://openairdocs.org/ntsb/NYC82FGT16.md): Bucker Jungmann BU-131 · Tower City, PA · Accident · No injuries · Final report · Jul 22, 1982 · N55JG · Substantial damage > The engine lost power when the aircraft was about 50 ft AGL during takeoff and landed in a rolling field of crops. The plane contacted the ground in a right bank/nose down attitude and came to rest at the point of impact. The engine separated from the… - [NTSB FTW82FPJ17](https://openairdocs.org/ntsb/FTW82FPJ17.md): Piper 28-140 · Harrah, OK · Accident · 1 fatal · Final report · Jul 22, 1982 · N655FL · Destroyed > During takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the… - [NTSB FTW82FPG19](https://openairdocs.org/ntsb/FTW82FPG19.md): Cessna 150J · North Little Ro, AR · Accident · 1 fatal · Final report · Jul 22, 1982 · N60246 · Destroyed > After a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,… - [NTSB DEN82DA141](https://openairdocs.org/ntsb/DEN82DA141.md): American AA5B · Broomfield, CO · Accident · Minor injuries · Final report · Jul 22, 1982 · N28218 · Substantial damage > The pilot was conducting local area pleasure sightseeing flights when the aircraft failed to climb during a normal departure. She landed the aircraft in a plowed field. Investigation revealed the flight was conducted at a density altitude approximately 8,750… - [NTSB DEN82DA140](https://openairdocs.org/ntsb/DEN82DA140.md): Piper PA-22 · Glenburn, ND · Accident · Minor injuries · Final report · Jul 22, 1982 · N949A · Substantial damage > The pilot reported that the engine lost power at about 100 AGL during a night takeoff. The aircraft was examined after the crash and the fuel selector was found positioned on the right tank. The aircraft had remained upright during and after the crash and the… - [NTSB NYC82DA161](https://openairdocs.org/ntsb/NYC82DA161.md): Thorp T-18 · Connellsville, PA · Accident · Minor injuries · Final report · Jul 21, 1982 · N62RB · Destroyed > While the student was taking off, the engine began to vibrate violently at an altitude of about 300 to 400 ft AGL. The flight instructor (CFI) took control and initiated a turn back to the airport. He stated that due to the vibration, he had to reduce the… - [NTSB LAX82DA272](https://openairdocs.org/ntsb/LAX82DA272.md): Cessna 140 · Santa Ynez, CA · Accident · No injuries · Final report · Jul 21, 1982 · N90088 · Substantial damage > During practice landing the engine began to run rough and intermittently. The instructor attempted a downwind landing. Pulling up over a fence aircraft stalled and made a hard landing the aircraft then nosed over. The fuel cap vent was blocked which prevented… - [NTSB CHI82FA260](https://openairdocs.org/ntsb/CHI82FA260.md): Rotorway Scorpion TOO · Niles, OH · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1982 · N9239Z · Destroyed > The plt's wife stated that the helicopter was taken across the street to an open field where the plt conducted his flt in the acft. She had never seen him fly this acft over about 3 ft AGL. The helicopter was observed to jump as if lifted by a gust of wind &… - [NTSB DEN82FTM14](https://openairdocs.org/ntsb/DEN82FTM14.md): Osprey II · Ogden, UT · Accident · Serious injuries · Final report · Jul 20, 1982 · N50733 · Destroyed > The pilot reported that during takeoff, he experienced a 400 RPM drop in the engine speed. He began a right turn to land on runway 04, but reportedly, the engine then stopped. The pilot intended to land on the hull with the gear retracted; however, the plane… - [NTSB ATL82FKM06](https://openairdocs.org/ntsb/ATL82FKM06.md): Evans VP-1 · Greensboro, NC · Accident · 1 fatal · Final report · Jul 20, 1982 · N2260K · Substantial damage > The eng quit at about 100 ft AGL after takeoff. The acft struck the ground approximately 80 deg nose down. Inspection of the fuel strainer revealed the screen gasket bent double which would allow foreign matter to enter the carburetor. The fiberglass fuel… - [NTSB ATL82FA202](https://openairdocs.org/ntsb/ATL82FA202.md): Piper J3C-65 · Eastover, NC · Accident · Serious injuries · Field investigation · Final report · Jul 19, 1982 · N42098 · Substantial damage > At about 60 ft AGL the eng quit. Water & rust sediment were found in the gascolator & carburetor. - [NTSB LAX82DA266](https://openairdocs.org/ntsb/LAX82DA266.md): Beech A36 · Grand Canyon, AZ · Accident · No injuries · Final report · Jul 18, 1982 · N4600S · Substantial damage > The aircraft dragged a wingtip during an aborted takeoff and swerved off the runway. The density altitude was 8200 feet. The pilot said he could not maintain a climb so he lowered the landing gear to abort the takeoff and lost control of the aircraft. The… - [NTSB FTW82FQA22](https://openairdocs.org/ntsb/FTW82FQA22.md): Cessna 172N · Santa Fe, NM · Accident · 4 fatal · Final report · Jul 18, 1982 · N6215D · Destroyed > The acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857… - [NTSB SEA82DA114](https://openairdocs.org/ntsb/SEA82DA114.md): Mong Sport 1 · Battleground, WA · Accident · No injuries · Final report · Jul 17, 1982 · N610S · Substantial damage > The pilot tookoff from a rough turf field adjacent to a school after a parade featuring his plane. The day was hot and the field was short. The pilot was unable to clear 60 foot trees and impacted the ground. - [NTSB FTW82FPA15](https://openairdocs.org/ntsb/FTW82FPA15.md): Piper PA-22-150 · Marlin, TX · Accident · Serious injuries · Final report · Jul 17, 1982 · N8760D · Substantial damage > The pilot stated that after takeoff, at an altitude of approximately 200 feet AGL, the engine quit. While attempting to make a left turn the aircraft lost airspeed and altitude and collided with trees. Examination of the wreckage at the accident site revealed… - [NTSB CHI82DA253](https://openairdocs.org/ntsb/CHI82DA253.md): Cessna A185F · Lake Delton, WI · Accident · No injuries · Final report · Jul 17, 1982 · N8375Q · Substantial damage > The float equipped aircraft was being operated on its first flight of the day. After takeoff, the pilot noted a deterioration of power as he was climbing through about 400 ft AGL. He was unable to restore the power and could not maintain level flight. During… - [NTSB SEA82DA115](https://openairdocs.org/ntsb/SEA82DA115.md): Grumman AA-5A · Toketee, OR · Accident · Minor injuries · Final report · Jul 16, 1982 · N9692U · Destroyed > The pilot calculated the weight of his aircraft to be 90 pounds below the maximum gross weight. The airport density altitude was calculated to be approximately 5000 feet. The pilot stated that after takeoff the aircraft achieved an altitude of 50 to 100 feet… - [NTSB MIA82DA156](https://openairdocs.org/ntsb/MIA82DA156.md): Sikorsky H-19 · Lake Lady, FL · Accident · No injuries · Final report · Jul 16, 1982 · N95484 · Substantial damage > Shortly after takeoff, the engine lost power and an autorotative landing was made in a marshy area. During touchdown, the main rotor blades struck the tail boom. The engine became submerged in water and could not be tested due to the high moisture content in… - [NTSB DEN82DA136](https://openairdocs.org/ntsb/DEN82DA136.md): Cessna T188C · Starkweather, ND · Accident · No injuries · Final report · Jul 16, 1982 · N2087J · Substantial damage > The pilot reported that the aircraft fuel tank had run out of fuel, so he added 2 to 3 gallons of av-gas. He said he thought this would be enough fuel to ferry the the aircraft four miles. He took off, and upon reaching about 400 ft AGL, the engine lost… - [NTSB MKC82DA125](https://openairdocs.org/ntsb/MKC82DA125.md): Cessna 150G · Bonner Springs, KS · Accident · No injuries · Final report · Jul 15, 1982 · N3335J · Substantial damage > The aircraft was flown from a private airstrip at maximum gross weight and an uphill takeoff run. The pilot stated he could not maintain airspeed. During a turn to make an emergency landing the left wing contacted a utility wire and the aircraft was… - [NTSB LAX82FUG14](https://openairdocs.org/ntsb/LAX82FUG14.md): Grumman AA-5 · Bermuda Dunes, CA · Accident · Serious injuries · Final report · Jul 15, 1982 · N7115L · Substantial damage > Immediately after takeoff the eng lost power & the acft was unable to maintain level flt. The acft landed in sand Dunes and flipped over. During a subsequent eng run it was noted that the eng ran normally at low power settings but at takeoff power settings it… - [NTSB ANC82FA059](https://openairdocs.org/ntsb/ANC82FA059.md): Aerospatiale SA-318C · Skwentna, AK · Accident · No injuries · Field investigation · Final report · Jul 15, 1982 · N4966 · Substantial damage > The pilot reported that after takeoff, at an altitude of 200 feet, the aircraft began a moderate vibration. When the aircraft was leveled off and the power reduced, the vibration stopped. The pilot continued the flight and during a climb turn at approximately… - [NTSB FTW82DA286](https://openairdocs.org/ntsb/FTW82DA286.md): Air Tractor AT-301 · Rio Hondo, TX · Accident · No injuries · Final report · Jul 14, 1982 · N4448S · Substantial damage > Immediately after takeoff, the engine lost power and a forced landing was made in a field of tall cotton. After landing in the cotton field with four-foot-high stalks, the pilot as unable to maintain directional control and the plane was substantially… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=213 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=212 --- 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.