# 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 211 of 412 · 20,559 cases ## Cases, newest first - [NTSB ANC82DA078](https://openairdocs.org/ntsb/ANC82DA078.md): Piper PA-32-300 · Egegik, AK · Accident · No injuries · Final report · Aug 30, 1982 · N1084X · Destroyed > After lift-off from a soft muddy strip the plt encountered a 30 knot crosswind eddying behind a building he was passing & settled into alder trees beyond the departure end of the strip. - [NTSB DEN82DA177](https://openairdocs.org/ntsb/DEN82DA177.md): Schweizer 84 · Aspen, CO · Accident · No injuries · Final report · Aug 29, 1982 · N5742S · Substantial damage > At low altitude after takeoff, the aircraft hit turbulence and the tow rope broke. The pilot reversed course and attempted to return to the airport. Having insufficient altitude, he landed on a railroad track and collided with bushes. The left wing canopy and… - [NTSB CHI82DA327](https://openairdocs.org/ntsb/CHI82DA327.md): Hughes 269B · Medina, OH · Accident · No injuries · Final report · Aug 28, 1982 · N9307F · Destroyed > The pilot stated that shortly after takeoff, at about 800 feet AGL he felt a violent vibration lasting for 2 or 3 seconds. He reentered the downwind leg to the airport and experienced the vibration again. The aircraft then entered an uncontrollable spiral to… - [NTSB SEA82FA149](https://openairdocs.org/ntsb/SEA82FA149.md): Cessna T207A · Boise, ID · Accident · Minor injuries · Field investigation · Final report · Aug 27, 1982 · N7306U · Destroyed > Before takeoff, the pilot filed a company flight plan for a VFR flight from Boise to salmon, ID. He reported that during initial climb, the engine surged, then seemed to return to normal operation. He reduced the power to 33 inches of manifold pressure and… - [NTSB FTW82FQG20](https://openairdocs.org/ntsb/FTW82FQG20.md): Piper PA-22-150 · Clovis, NM · Accident · Serious injuries · Final report · Aug 27, 1982 · N4827A · Substantial damage > The eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor… - [NTSB ANC82DA080](https://openairdocs.org/ntsb/ANC82DA080.md): Piper PA-32 · Near Dillingham, AK · Accident · No injuries · Final report · Aug 26, 1982 · N7989C · Substantial damage > The pilot began taking off down slope in calm wind conditions with six passengers on board. Reportedly, the 1380 ft runway was mostly dry, but was muddy in places, except the last 100 ft contained standing water. The aircraft had barely lifted off prior to… - [NTSB ANC82DAG46](https://openairdocs.org/ntsb/ANC82DAG46.md): Cessna 172 · Quinhagak, AK · Accident · No injuries · Final report · Aug 25, 1982 · N53145 · Substantial damage > The pilot reported that he landed on a gravel bar about 900 ft long with a passenger to go fishing. Later, he took off to the west with a slight head wind. Near the end of the gravel bar was a tree with branches sticking out of the water. As the pilot took… - [NTSB ANC82DAG43](https://openairdocs.org/ntsb/ANC82DAG43.md): Piper PA-20 · Eagle River, AK · Accident · No injuries · Final report · Aug 24, 1982 · N7773K · Substantial damage > The eng lost power about 750 ft after a water takeoff. There was insufficient landing room on the lake & the acft hit a dike. The pilot stated he fuels the acft from 5 gallon cans due to nonavaiability of aviation fuel at fire lake. Approximately 2 cups of… - [NTSB LAX82FA313](https://openairdocs.org/ntsb/LAX82FA313.md): Maule M-6-235 · 5nm Sw Of Mcnea, AZ · Accident · 4 fatal · Field investigation · Final report · Aug 23, 1982 · N56493 · Destroyed > Immediately after takeoff the acft was observed in a right turn with an abnormally nose high attitude. The acft appearedto stall & slide toward the left wing. Before a recovery could be completed the left wing & nose hit simultaneously at a 45 deg angle in… - [NTSB ANC82DAG50](https://openairdocs.org/ntsb/ANC82DAG50.md): Cessna 150 · Kodiak, AK · Accident · No injuries · Final report · Aug 23, 1982 · N60460 · Substantial damage > The pilot took off from a gravel bar that was surrounded by higher terrain. Reportedly, the wind was calm until after lift-off, then a strong crosswind was encountered as the plane cleared higher terrain. The pilot reported that the plane was hit by the… - [NTSB MKC82FA153](https://openairdocs.org/ntsb/MKC82FA153.md): Lawson Special DG-1 · Ozark, MO · Accident · Serious injuries · Field investigation · Final report · Aug 22, 1982 · N922 · Substantial damage > The accident occurred during a fly-in. Several hundred spectators were at the arpt. The acft lifted off rwy 18 in a nose-high attitude, the left wing dipped down & the acft settled back to the ground in a nose-high attitude. The acft impacted about 50 ft east… - [NTSB LAX82DA315](https://openairdocs.org/ntsb/LAX82DA315.md): Piper PA-30 · Santa Catalina, CA · Accident · No injuries · Final report · Aug 22, 1982 · N7956Y · Destroyed > The aircraft lost right engine power following departure from Santa Catalina. Unable to climb the aircraft to airport altitude the pilot decided to proceed over the open sea to san clemente. About 19 miles from the island the pilot stated he switched fuel… - [NTSB SEA82DA147](https://openairdocs.org/ntsb/SEA82DA147.md): Maule BEE DEE M-4 · Yakima, WA · Accident · Minor injuries · Final report · Aug 21, 1982 · N4170C · Substantial damage > The pilot reported that just as he became airborne, an uncontrollable left roll developed. The left wing contacted the ground and the aircraft cartwheeled. An investigation revealed that the aileron balance and control cables were reversed to the aileron… - [NTSB LAX82DA317](https://openairdocs.org/ntsb/LAX82DA317.md): Piper PA-12 · Phoenix, AZ · Accident · No injuries · Final report · Aug 21, 1982 · N98931 · Destroyed > The aircraft collided with trees during takeoff from a 900 foot, dirt strip. The weather was VFR. The temperature was 102 degrees. No accident report was filed. The pilot had an expired medical certificate. - [NTSB CHI82DA347](https://openairdocs.org/ntsb/CHI82DA347.md): Bell 47G-4A · Near Brooten, MN · Accident · No injuries · Final report · Aug 20, 1982 · N4090G · Substantial damage > The pilot had been engaged in a spraying operation for 2.5 hrs when he returned and landed on a flat bed type trailer to service the helicopter. After the hopper was serviced with 60 gal of herbicide, the pilot began his take off. He stated that just after… - [NTSB CHI82DA314](https://openairdocs.org/ntsb/CHI82DA314.md): Cessna 177 · Minford, OH · Accident · Serious injuries · Final report · Aug 20, 1982 · N30845 · Substantial damage > The aircraft had just recently received an annual inspection. Before taking off on a local flight, the fuel tanks were topped off. The pilot reported that the preflight run-up was satisfactory, and during the takeoff roll, the engine developed full power.… - [NTSB NYC82DA204](https://openairdocs.org/ntsb/NYC82DA204.md): Cessna 195A · Wallingford, CT · Accident · No injuries · Final report · Aug 19, 1982 · N4433C · Substantial damage > The pilot reported that when he preflighted the aircraft, the fuel tanks were full. Fuel was drained from each wing and the fuselage low point with no indication of water. During takeoff, engine power was lost at an altitude of about 150 ft as the manifold… - [NTSB SEA82DA151](https://openairdocs.org/ntsb/SEA82DA151.md): Aeronca 7AC · 7nm So. Of Sale, OR · Accident · No injuries · Final report · Aug 18, 1982 · N82219 · Substantial damage > Immediately after a soft field takeoff the pilot executed a right turn into a quartering tailwind condition in an effort to avoid trees beyond the upwind end of the field. The pilot reported that during this turn the aircraft stalled and struck the ground in… - [NTSB LAX82FA305](https://openairdocs.org/ntsb/LAX82FA305.md): Cessna T210L · Buena Park, CA · Accident · No injuries · Field investigation · Final report · Aug 17, 1982 · N732JP · Substantial damage > Reportedly, the eng began losing power after takeoff at aprx 300 ft AGL, after the plt retracted the landing gear & flaps. The eng then stopped & the plt was forced to land. While descending, the acft struck power lines. During touchdown, it collided with 2… - [NTSB FTW82DA334](https://openairdocs.org/ntsb/FTW82DA334.md): Grumman G164A · Marianna, AR · Accident · No injuries · Final report · Aug 17, 1982 · N5364 · Substantial damage > The pilot stated that shortly after lift off the engine backfired and lost power. He reported that the engine did not completely quit and there was no visible smoke, flame or oil coming from the engine. Due to his low altitude and heavy load the pilot elected… - [NTSB ATL82DA241](https://openairdocs.org/ntsb/ATL82DA241.md): Cessna A188A · Florala, AL · Accident · No injuries · Final report · Aug 17, 1982 · N9916G · Substantial damage > The pilot reported that as he was climbing through about 30 to 40 ft AGL, the aircraft suddenly went to the right as the flaps were being retracted. In an effort to counteract the lateral movement, the pilot applied left aileron and rudder which started the… - [NTSB ANC82DA075](https://openairdocs.org/ntsb/ANC82DA075.md): Enstrom F-28F · Near Sutton, AK · Accident · Minor injuries · Final report · Aug 17, 1982 · N5698E · Substantial damage > The pilot had approached and landed on a bluff to discharge his two passengers. However, before discharging the passengers, he decided to takeoff and find a better landing area. When the helicopter was about 10 to 20 ft from the takeoff point, but… - [NTSB ANC82DA073](https://openairdocs.org/ntsb/ANC82DA073.md): Cessna 185 · Near Skwentna, AK · Accident · No injuries · Final report · Aug 16, 1982 · N79SC · Substantial damage > The pilot of the float plane began his takeoff from a narrow river with a left turn at the lift-off point. After becoming airborne and while turning, the right wing struck a branch. The pilot stated that the aircraft came to rest in the trees, upside down.… - [NTSB CHI83DA308](https://openairdocs.org/ntsb/CHI83DA308.md): Von Berg VEE BEE 4 · Saginaw, MI · Accident · Minor injuries · Final report · Aug 14, 1982 · N4VB · Substantial damage > The pilot of the home built aircraft was making a high speed taxi run when the aircraft inadvertently became airborne. The plane climbed to about 100 ft AGL and then the engine lost power. During landing, the aircraft was substantially damaged. The pilot… - [NTSB ATL82FLQ09](https://openairdocs.org/ntsb/ATL82FLQ09.md): Cessna 150 · Prestonburg, KY · Accident · Serious injuries · Final report · Aug 14, 1982 · N1410Q · Destroyed > Immediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid… - [NTSB FTW82FQA25](https://openairdocs.org/ntsb/FTW82FQA25.md): Beech P35 · Albuquerque, NM · Accident · Minor injuries · Final report · Aug 13, 1982 · N1555Z · Substantial damage > After takeoff engine reportedly lost power. The pilot flew it between trees but one wing was separated in the collision with a tree during the forced landing. No reason for the power loss was found. - [NTSB ANC82DA071](https://openairdocs.org/ntsb/ANC82DA071.md): Piper PA-12 · Polly Creek, AK · Accident · No injuries · Final report · Aug 13, 1982 · N2701M · Substantial damage > The pilot landed on the beach near the mouth of Polly Creek to go fishing. After fishing for several hours. He noticed fuel leaking from the filler cap on the left main tank. This occurred when fuel cross-flowed from the right auxiliary tank. The pilot turned… - [NTSB FTW82FPM15](https://openairdocs.org/ntsb/FTW82FPM15.md): Beech H35 · Tulsa, OK · Accident · 2 fatal · Final report · Aug 12, 1982 · N4800Y · Destroyed > Aircraft lost power during takeoff. Pilot tried to turn back to airport in a left bank described as 60 to 90 degrees. Aircraft stalled and crashed about 1300 feet east of takeoff point. During the investigation the fuel pump was placed on a flow bench & on… - [NTSB CHI82FA304](https://openairdocs.org/ntsb/CHI82FA304.md): Hiller UH12L4 · Wisconsin Dells, WI · Accident · Serious injuries · Field investigation · Final report · Aug 12, 1982 · N3748Z · Substantial damage > During climb, at about 200 ft AGL, the m/r lost RPM. During autorotation the eng RPM increased beyond the red line when the plt added power. The helicopter made a hard landing in a residential area. Inspection of the mercury clutch revealed that the exterior… - [NTSB NYC82FA193](https://openairdocs.org/ntsb/NYC82FA193.md): Cessna 180H · Porter, ME · Accident · 2 fatal · Field investigation · Final report · Aug 11, 1982 · N2800T · Substantial damage > The acft was taking off from a pond which is about 4,200 ft at its longest length. A power line extends across the pond about 2,000 ft from the south end. The acft was observed to takeoff to the north remaining on the water while passing under the wires. The… - [NTSB MKC82DA141](https://openairdocs.org/ntsb/MKC82DA141.md): Cessna 140 · West Plains, MO · Accident · Minor injuries · Final report · Aug 10, 1982 · N2319V · Substantial damage > The pilot was practicing short field takeoffs and maneuvered to clear a 50 foot barrier. He stalled the aircraft and was unable to recover before impacting the ground, nose and right wing first. - [NTSB LAX82FVG30](https://openairdocs.org/ntsb/LAX82FVG30.md): Piper PA-36-285 · Malin, OK · Accident · Serious injuries · Final report · Aug 10, 1982 · N9925P · Substantial damage > Power loss during takeoff resulted in forced landing. Aircraft collided with canal bank. Cylinder had broken rings. Both plugs were badly oil fouled. One plug would not fire & the other fired intermittently. - [NTSB CHI82DA299](https://openairdocs.org/ntsb/CHI82DA299.md): Quickie Quickie · Youngstown, OH · Accident · No injuries · Final report · Aug 10, 1982 · N336RM · Substantial damage > During takeoff, the home built aircraft struck the tops of trees near the departure end of the 3300 ft runway. The pilot stated that the aircraft climbed very slowly and was barely able to climb at a greater rate than the upslope of the runway. The elevation… - [NTSB CHI82DA298](https://openairdocs.org/ntsb/CHI82DA298.md): Quickie · Greenville, MI · Accident · No injuries · Final report · Aug 9, 1982 · N39QB · Substantial damage > During the preflight inspection. The laminar-flow wing and canard were carefully wiped free of a heavy deposit of dew. All items of inspection were satisfactory. The engine was warmed up while taxiing to the runway. It was noted that beads of moisture were… - [NTSB NYC82DA186](https://openairdocs.org/ntsb/NYC82DA186.md): Piper PA-22-160 · Barnstead, NH · Accident · No injuries · Final report · Aug 8, 1982 · N3627Z · Substantial damage > The pilot stated he lost power during takeoff and landed in trees off the end of the runway. - [NTSB FTW82FPJ19](https://openairdocs.org/ntsb/FTW82FPJ19.md): Cessna 172M · Overbrook, OK · Accident · Serious injuries · Final report · Aug 8, 1982 · N46172 · Destroyed > The pilot stated that he began his takeoff from the very beginning of the runway, and that on rotation, the engine seemed to lose power. He stated that he observed the tachometer and saw that the engine was dropping below 1500 RPM. Subsequently, the aircraft… - [NTSB DEN82DA156](https://openairdocs.org/ntsb/DEN82DA156.md): Cessna 172M · Fairburn, SD · Accident · No injuries · Final report · Aug 8, 1982 · N19889 · Substantial damage > The aircraft tookoff with 4 occupants, baggage and 50 gallons of fuel. The density altitude was 4,963 feet. After takeoff, the pilot could not maintain altitude and stalled the aircraft into a field of high grass. The flaps were not used. - [NTSB ATL82DA232](https://openairdocs.org/ntsb/ATL82DA232.md): Cessna 150 · Horrell Hill, SC · Accident · No injuries · Final report · Aug 8, 1982 · N18019 · Substantial damage > Pilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff. - [NTSB ATL82DA231](https://openairdocs.org/ntsb/ATL82DA231.md): Hughes 369HS · Wrightsville Bc, NC · Accident · No injuries · Final report · Aug 8, 1982 · N4265P · Substantial damage > The pilot reported that he initiated a downwind takeoff in a 10 kt wind and started a climb over water. Reportedly, the helicopter began to spin to the right as it reached an altitude of about 50 ft AGL and 20 KTS. The pilot allowed the helicopter to rotate… - [NTSB SEA82DA136](https://openairdocs.org/ntsb/SEA82DA136.md): Cessna T207 · Dixie, ID · Accident · No injuries · Final report · Aug 6, 1982 · N1627U · Destroyed > The pilot took off with 4 passengers after waiting 4 hours for the air temperature to cool. The takeoff seemed normal, but over the river at about 50 feet AGL, the aircraft began to sink. It impacted rough terrain on the FAR side of the river. The airport… - [NTSB NYC82DA187](https://openairdocs.org/ntsb/NYC82DA187.md): Schleicher ASW-20 · Unionville, PA · Accident · Serious injuries · Final report · Aug 6, 1982 · N20KG · Destroyed > While being towed during takeoff, the pilot moved the flaps from the neutral #3 to the positive #4 setting and the nose of the glider pitched up. The pilot realized there was no elevator control, the flaps were moved to the #1 (negative) setting and the two… - [NTSB LAX82FA290](https://openairdocs.org/ntsb/LAX82FA290.md): Beech 95-B55 · Palo Verde, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1982 · N1UR · Destroyed > The acft took off from a road near the plt's home. It was observed to go around a pickup truck parked alongside the road & then lift off. The acft climbed, turned right briefly & then went wings level. It then started a right descending turn into the ground.… - [NTSB ATL82FA229](https://openairdocs.org/ntsb/ATL82FA229.md): Piper PA-32-260 · Raleigh, NC · Accident · Serious injuries · Field investigation · Final report · Aug 5, 1982 · N4076W · Destroyed > Shortly after takeoff the acft caught fire. The plt attempted to turn back to the arpt but the eng lost power & the acftcould not maintain altitude. The acft crashed into a heavily wooded state park. The #5 cylinder exhaust pipe was found separated & was not… - [NTSB ATL82FID12](https://openairdocs.org/ntsb/ATL82FID12.md): Benson B8M · Suffolk, VA · Accident · Minor injuries · Final report · Aug 4, 1982 · NONE · Substantial damage > The pilot stated that he was practicing high speed taxi with occasional lift off and landing. He stated that on this lift off the aircraft was approximately 25 feet off the ground when he lost control. - [NTSB ANC82DAG39](https://openairdocs.org/ntsb/ANC82DAG39.md): Cessna 180 · Rush Lake, AK · Accident · Minor injuries · Final report · Aug 4, 1982 · N3125C · Destroyed > The float-equipped acft failed to clear rising terrain after taking off from Rush Lake. The pilot stated that the enginewas developing full power. - [NTSB ANC82DA065](https://openairdocs.org/ntsb/ANC82DA065.md): Maule M-4-210C · Eagle River, AK · Accident · No injuries · Final report · Aug 4, 1982 · N9872M · Substantial damage > The pilot reported that he preflighted the float plane, pumped the floats, and checked for water. After the engine start, taxi, and pretakeoff checks, he set the flaps at the first notch. He aborted his first takeoff run and taxied back for a longer run. The… - [NTSB ANC82DAG38](https://openairdocs.org/ntsb/ANC82DAG38.md): Cessna 172K · 44mi Nw Mccarth, AK · Accident · Minor injuries · Final report · Aug 2, 1982 · N84345 · Substantial damage > Shortly after liftoff from a short gravel strip the aircraft settled back onto the rough terrain and crashed. - [NTSB MIA82DA162](https://openairdocs.org/ntsb/MIA82DA162.md): Mooney M20F · Orlando, FL · Accident · No injuries · Final report · Aug 1, 1982 · N9109V · Substantial damage > The pilot reported that rain had occurred on the previous night and there was water on the 2430 ft grass runway. He reported that during rotation, the aircraft hit the water and lost airspeed. Subsequently, the aircraft failed to gain sufficient altitude to… - [NTSB CHI82DA288](https://openairdocs.org/ntsb/CHI82DA288.md): Piper PA-28-180 · Rockford, IL · Accident · No injuries · Final report · Aug 1, 1982 · N5286L · Substantial damage > The aircraft began to settle or mush after takeoff so the pilot made a landing in a school yard. Post accident examination failure to reveal any evidence of engine malfunction although pilot claimed he lost power. The aircraft was about 80 lbs. Below maximum… - [NTSB ATL82DA222](https://openairdocs.org/ntsb/ATL82DA222.md): Beech C23 · Greer, SC · Accident · Serious injuries · Final report · Aug 1, 1982 · N1831F · Substantial damage > The student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=212 ## 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=211 --- 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.