# 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 209 of 412 · 20,559 cases ## Cases, newest first - [NTSB LAX83LA026](https://openairdocs.org/ntsb/LAX83LA026.md): Swearingen SA-226TC · San Francisco, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 1982 · N65SA · Substantial damage > Flight 238, was cleared for takeoff from runway 28L at San Francisco intl airport. While accelerating through V2 with the gear in upward transit at approximately 50 feet AGL, the red left engine fire warning light illuminated. The flight crew elected to abort… - [NTSB NYC83LA020](https://openairdocs.org/ntsb/NYC83LA020.md): Piper PA-28-140 · Greenville, PA · Accident · No injuries · Limited investigation · Final report · Nov 5, 1982 · N203CB · Substantial damage > Aircraft seemed to lose power after takeoff and pilot stall-mushed into trees. Aircraft then slid to ground and rolled inverted. - [NTSB MKC83LA013](https://openairdocs.org/ntsb/MKC83LA013.md): Cessna 182D · Bucklin, KS · Accident · No injuries · Limited investigation · Final report · Nov 5, 1982 · N7432N · Substantial damage > During takeoff, the engine lost power from fuel exhaustion and the pilot made a forced landing in a plowed field. While landing, the wheels dug into the soil and the aircraft nosed over. The pilot stated that he regularily flew another aircraft with a larger… - [NTSB CHI83LA034](https://openairdocs.org/ntsb/CHI83LA034.md): Piper PA-28-140 · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1982 · N56311 · Substantial damage > The newly purchased aircraft had just been delivered and the pilot elected to fly it a short period to check its operation. He performed one takeoff and landing, then started another takeoff. He reported that during the second takeoff, the engine lost power… - [NTSB ANC83LA011](https://openairdocs.org/ntsb/ANC83LA011.md): Beech 50 · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Nov 3, 1982 · N3582B · Substantial damage > Left engine lost power after takeoff. Pilot feathered left engine and returned to runway on one engine. Since he was overshooting he elected to land on grass wheels up to avoid overrun and collision with ditch. The following discrepancies were found: exhaust… - [NTSB CHI83LA031](https://openairdocs.org/ntsb/CHI83LA031.md): Piper PA-28-181 · Marshall, MN · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 1982 · N6246J · Destroyed > During a preflight weather briefing, the pilot was warned that VFR flight was not recommended. Also, a fixed base operator warned him of the weather (there were patches of ground fog). After takeoff, fog was encountered at about 200 to 500 ft AGL. During a… - [NTSB SEA83LA015](https://openairdocs.org/ntsb/SEA83LA015.md): Cessna 120 · Midvale, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1982 · N3177N · Substantial damage > Shortly after lift-off, the engine lost power. The pilot elected to make a forced landing in a plowed field near the end of the runway. The right main gear failed to clear the barbed-wire perimeter fence. Subsequently, the aircraft touched down in a yaw and… - [NTSB FTW83FRG02](https://openairdocs.org/ntsb/FTW83FRG02.md): Luscombe 8A · San Antonio, TX · Accident · Serious injuries · Final report · Oct 31, 1982 · N71557 · Destroyed > The pilot tookoff in gusty winds and accelerated to about 85 KTS. The aircraft then climbed steeply, stalled and crashed. - [NTSB FTW83FPG01](https://openairdocs.org/ntsb/FTW83FPG01.md): Cessna 177 · North Little Ro, AR · Accident · Serious injuries · Final report · Oct 31, 1982 · N29457 · Destroyed > Shortly after takeoff, the engine lost power. One witness stated that the engine did not completely quit. Another witness reported that it quit, but restarted and then operated with partial power. Reportedly, the aircraft remained in a nose high attitude,… - [NTSB FTW83FA027](https://openairdocs.org/ntsb/FTW83FA027.md): Piper PA-31-350 · Baton Rouge, LA · Accident · 3 fatal · Field investigation · Final report · Oct 31, 1982 · N41045 · Destroyed > The aircraft crashed and burned shortly after taking off in darkness on an IFR flight plan. The weather was reported as indefinite ceiling, zero obscuration, visibility 1/4 mi with fog, wind 120 deg at 5 KTS. A number of witnesses heard the aircraft, both… - [NTSB FTW83LA029](https://openairdocs.org/ntsb/FTW83LA029.md): Gulfstream G-164B · Pine Bluff, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 1982 · N8418K · Destroyed > Pilot just loaded seeds and tookoff when he noticed smoke and the engine lost power. During a forced landing the aircraft nosed over. Cause of power loss undetermined. - [NTSB CHI83LA029](https://openairdocs.org/ntsb/CHI83LA029.md): Flagg 13 · Lansing, IL · Accident · No injuries · Limited investigation · Final report · Oct 30, 1982 · N13625 · Substantial damage > The pilot stated he took off to the west and just after becoming airborne the engine lost power. The aircraft landed in a bean field. Examination of the fuel system revealed that the inlet fuel line to the fuel pump had rotted and large pieces of the interior… - [NTSB DCA83IA003](https://openairdocs.org/ntsb/DCA83IA003.md): Beech E90 · Wilmington, DE · Incident · No injuries · Incident investigation · Final report · Oct 28, 1982 · N213DS · Minor damage > The aircraft crashed shortly after taking off from the greater Wilmington airport, Wilmington, DE. The pilot stated that the left engine lost power at about 100 ft AGL, just as the landing gear was being retracted. He said the autofeather was armed, but the… - [NTSB CHI83LA027](https://openairdocs.org/ntsb/CHI83LA027.md): Bell 47D1 · Georgetown, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 28, 1982 · N929B · Substantial damage > The pilot started to takeoff from area that was difficult to exit. He relanded once. During the 2nd attempt to fly out, the helicopter collided with trees and crashed. The pilot was not rated in helicopters, but he said he had soloed. - [NTSB ATL83LA019](https://openairdocs.org/ntsb/ATL83LA019.md): Grumman G-164 · Adel, GA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1982 · N7231 · Destroyed > Following maintenance performed on the aircraft the pilot conducted a check flight. After takeoff the pilot discovered fuel splashing on the windshield and proceeded to abort the takeoff. Upon landing the pilot lost control of the aircraft. The aircraft… - [NTSB MKC83FCA01](https://openairdocs.org/ntsb/MKC83FCA01.md): Piper PA-28-161 · St. Charles, MO · Accident · 4 fatal · Final report · Oct 25, 1982 · N8184Y · Substantial damage > The acft crashed on the north boundary of the arpt within minutes after having been seen departing rwy 27. Dense ground fog prevailed at the crash site. Approximately 1-1/2 hours after the accident examination disclosd very heavy frost on all acft parked… - [NTSB LAX83FVM02](https://openairdocs.org/ntsb/LAX83FVM02.md): Beech F17D · Hollister, CA · Accident · Minor injuries · Final report · Oct 20, 1982 · N19473 · Substantial damage > The eng quit immediately after takeoff & the acft landed in an orchard. The fuel selector was found on the empty fuselage tank. The left wing auxillary tank was empty & the right wing auxillary tank was approximately full. - [NTSB MIA83LA016](https://openairdocs.org/ntsb/MIA83LA016.md): Cessna 172 · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Oct 19, 1982 · N12927 · Substantial damage > Upon landing, the pilot noticed he was too high and executed a go-around. On the next landing the aircraft veered left on the landing roll so the pilot again attempted a go-around. On liftoff the nosewheel hit the airport perimeter fence and the aircraft came… - [NTSB CHI83LA020](https://openairdocs.org/ntsb/CHI83LA020.md): Piper PA-32-260 · Vandalia, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1982 · N4740S · Substantial damage > The pilot estimated that he had 40 gal of fuel on board when he departed parkersburg, WV for new carlisle, OH. During a night arrival at new carlisle, he was unable to activate the runway lights by keying his microphone. Therefore, he diverted to Vandalia,… - [NTSB MIA83LA013](https://openairdocs.org/ntsb/MIA83LA013.md): Cessna 177RG · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Oct 17, 1982 · N1892Q · Substantial damage > During takeoff, the engine lost power at about 700 to 800 ft AGL while the plane was climbing. The pilot was unable to restart the engine. Subsequently, the aircraft crashed in an orange grove and was destroyed. An examination and partial teardown of the… - [NTSB LAX83FA012](https://openairdocs.org/ntsb/LAX83FA012.md): Beech C-45H · Taft, CA · Accident · 14 fatal · Field investigation · Final report · Oct 17, 1982 · N403SE · Destroyed > The aircraft was on a local flight involving a parachute jumping activity. In addition to the pilot, there were 12 parachutists and an observer on board. The pilot initiated his takeoff on runway 18. A witness stated that shortly after takeoff, the engine… - [NTSB DEN83FTA01](https://openairdocs.org/ntsb/DEN83FTA01.md): Aero Commander 100 · Red Lodge, MT · Accident · Serious injuries · Final report · Oct 17, 1982 · N5539M · Destroyed > After takeoff, the aircraft lost airspeed and started an uninitiated descent. The pilot was unable to power out of it and the aircraft contacted two buildings and a fence before stopping in an open field. The winds were from 200 degrees at 30 KTS, gusting to… - [NTSB ATL83LA011](https://openairdocs.org/ntsb/ATL83LA011.md): Tomcat MK68 · Cope, SC · Accident · No injuries · Limited investigation · Final report · Oct 15, 1982 · N9080T · Destroyed > Before starting his takeoff from a trailer, the pilot failed to insure that his helper had released the right rear tiedown chain. During lift-off, the helicopter raised the trailer about 2 to 3 ft before the chain. Broke. Simultaneously, the helicopter was… - [NTSB SEA83LA007](https://openairdocs.org/ntsb/SEA83LA007.md): Cessna 340 · Bellevue, WA · Accident · No injuries · Limited investigation · Final report · Oct 13, 1982 · N6GD · Substantial damage > According to the pilot, the right engine lost power at or shortly after rotation for takeoff. Reportedly, there was insufficient room to stop on the runway with a house near the end. He opted to continue the takeoff and fly to a safe landing area. He stated… - [NTSB ANC83LAA02](https://openairdocs.org/ntsb/ANC83LAA02.md): Cessna 150 · Nulato, AK · Accident · 2 fatal · Final report · Oct 11, 1982 · N714SQ · Destroyed > The acft struck trees 600 ft from the departure end of the rwy at a high rate of speed after taking off from the unlighted rwy at night. The plt's blood alcohol level was 31 mg% & the urine alcohol level 90 mg%. - [NTSB MKC83LA005](https://openairdocs.org/ntsb/MKC83LA005.md): Cessna 182 · Cuba, MO · Accident · No injuries · Limited investigation · Final report · Oct 10, 1982 · N5829B · Substantial damage > Pilot says aircraft lost power at 200 feet AGL. Forced landing resulted in collision with a tree stump. No reason for engine malfunction found. - [NTSB LAX83LVM01](https://openairdocs.org/ntsb/LAX83LVM01.md): Bell 47G2 · 5nm East Of Sal, CA · Accident · No injuries · Final report · Oct 10, 1982 · N5159B · Substantial damage > After takeoff, during an aerial application flight, the pilot felt a sudden jolt and the engine RPM revved then decayed very rapidly. The pilot made a hard landing and the main rotor severed the tail rotor. The aircraft was within the weight and balance… - [NTSB CHI83LA008](https://openairdocs.org/ntsb/CHI83LA008.md): Cessna T188C · Sparta, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 1982 · N2892J · Substantial damage > Witnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi… - [NTSB ATL83LA004](https://openairdocs.org/ntsb/ATL83LA004.md): Grumman G-164B · Rowland, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1982 · N48498 · Substantial damage > The aircraft was being ferried to a nearby airport for winter storage. Immediately after takeoff, the engine began running rough and RPM was lost. The pilot turned and landed in a plowed field where the aircraft nosed over during the landing roll. The pilot… - [NTSB FTW83LA008](https://openairdocs.org/ntsb/FTW83LA008.md): Hughes TH-55A · Balmorhea, TX · Accident · No injuries · Limited investigation · Final report · Oct 4, 1982 · N8045F · Substantial damage > A Hughes helicopter was damaged when it lost power during takeoff and was crashed into a tree to prevent it from rolling down a hill. The weather was VMC and no flight plan was filed. The pilot said the manifold pressure decayed FROM22 inches to 18 inches and… - [NTSB CHI83LA005](https://openairdocs.org/ntsb/CHI83LA005.md): Grumman AA-1C · Madison, IN · Accident · No injuries · Limited investigation · Final report · Oct 4, 1982 · N8055W · Substantial damage > After takeoff from a touch & go the eng lost power. The #1 cyl upper plug lead nut had backed off & the lead was found resting in the plug. The #2 & #4 cyl upper plug lead nuts had backed off & both leads were not in the spark plugs but were resting on the… - [NTSB ATL83LLQ01](https://openairdocs.org/ntsb/ATL83LLQ01.md): Beech 35 · Hazard, KY · Accident · Serious injuries · Final report · Oct 4, 1982 · N188CB · Destroyed > The pilot reported that the airport was located in a valley, and due to the terrain, it was necessary to takeoff on runway 17 with a quartering left tail wind. He reported that a mountain was located close to the runway centerline (to the right) as well as… - [NTSB ANC83LA003](https://openairdocs.org/ntsb/ANC83LA003.md): Piper PA-18 · Near King Salmo, AK · Accident · No injuries · Limited investigation · Final report · Oct 4, 1982 · N54247 · Destroyed > According to the pilot, he began taking off with a right quartering headwind. As the plane lifted off, a gust of wind was encountered and the aircraft moved sideward and down. Subsequently, the right main gear contacted the ground and separated. The nose then… - [NTSB MIA83LA002](https://openairdocs.org/ntsb/MIA83LA002.md): Cessna 182 · Cocoa, FL · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N2101R · Substantial damage > During takeoff, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot s-turned and landed on a clear area beside the runway to keep from going into a river. Subsequently, the nose gear collapsed and the aircraft flipped over.… - [NTSB LAX83LA007](https://openairdocs.org/ntsb/LAX83LA007.md): Beech A36TC · Santa Ana, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1982 · N66909 · Substantial damage > The pilot reported that the engine lost power after he had raised the gear during takeoff. He lowered the nose to avoid a stall and landed gear-up at and off the end of the runway. Reportedly, tower personnel observed black smoke trailing from the bottom of… - [NTSB LAX83FUG01](https://openairdocs.org/ntsb/LAX83FUG01.md): Cougar A · El Mirage, CA · Accident · Minor injuries · Final report · Oct 3, 1982 · N87DS · Destroyed > After takeoff, the engine lost power. The pilot made a forced landing on the desert. The aircraft encountered sand and nosed over. The homebuilt aircraft had a common bracket for throttle and mixture. Advancing the throttle would leaned the mixture. - [NTSB FTW83IA005](https://openairdocs.org/ntsb/FTW83IA005.md): Boeing 727-225A · Kenner, LA · Incident · No injuries · Incident investigation · Final report · Oct 3, 1982 · N817EA · No damage > The plt departed with a tail wind which exceeded the allowable component. Rotation was observed to have occurred at the departure threshold. The acft was estimated to be at 25 to 30 ft AGL when it was 1330 ft beyond the departure end of therunway. Two persons… - [NTSB CHI82DA368](https://openairdocs.org/ntsb/CHI82DA368.md): Lake LA-4 · Lancaster, OH · Accident · Minor injuries · Final report · Sep 30, 1982 · N39786 · Substantial damage > Pilot says aircraft lost power after takeoff. He made a forced landing in a cornfield. No malfunction found. - [NTSB NYC82FHA10](https://openairdocs.org/ntsb/NYC82FHA10.md): Navion G · Doylestown, PA · Accident · Serious injuries · Final report · Sep 28, 1982 · N2476T · Substantial damage > At approximately 75-100 ft the eng quit. The acft landed with the gear up & slid off the end of the rwy approximately 200-300 ft. the plt acknowledged taking off with the fuel selector on the empty left tip tank. - [NTSB ATL82FIG11](https://openairdocs.org/ntsb/ATL82FIG11.md): Cessna 177B · Forest Hill, MD · Accident · Serious injuries · Final report · Sep 28, 1982 · N11562 · Destroyed > After takeoff, the engine lost power and the aircraft crashed in a cornfield. The pilot turned left to avoid a congestedarea and made ground contact with the left wing first. The aircraft was demolished by impact and fire. The pilot says hehad a quarter of a… - [NTSB LAX82DA360](https://openairdocs.org/ntsb/LAX82DA360.md): Bell 47G-5 · Soledad, CA · Accident · No injuries · Final report · Sep 27, 1982 · N8562F · Substantial damage > The pilot experienced a power loss during lift-off. A hard landing was made. No reason for the malfunction was found. - [NTSB ATL82FKJ14](https://openairdocs.org/ntsb/ATL82FKJ14.md): Grumman G-164 · Bay Minnette, AL · Accident · Serious injuries · Final report · Sep 27, 1982 · N463RF · Destroyed > The pilot reported that during takeoff, he noticed extreme heat in the cockpit and the engine began to surge, then lose power. He landed on the remainder of the runway and stopped after running off the end. However, the engine was on fire and the plane was… - [NTSB LAX82DA358](https://openairdocs.org/ntsb/LAX82DA358.md): North American SNJ-6 · Santa Rosa, CA · Accident · No injuries · Final report · Sep 26, 1982 · N3579 · Substantial damage > Engine quit at 500 feet AGL after takeoff. Pilot turned back but overshot field. - [NTSB NYC82DA235](https://openairdocs.org/ntsb/NYC82DA235.md): Cessna TR-182 · Honesdale, PA · Accident · No injuries · Final report · Sep 25, 1982 · N9369R · Substantial damage > The aircraft experienced a power loss at 300 feet after takeoff and a forced landing was made with the wheels up in a plowed field. An investigation revealed that a seal around the carburetor air mixing box had come loose and an oil seal in the turbocharger… - [NTSB FTW82AA391](https://openairdocs.org/ntsb/FTW82AA391.md): Beech 58P · Midland, TX · Accident · 1 fatal · Final report · Sep 24, 1982 · N2027C · Destroyed > An intersection tkof was started nr the middle of rwy 25 with 2096 ft remaining. The plt stated the tkof was normal until he started making an initial pwr reduction to 34 inches and 2400 RPM. At that time, the l eng reportedly continuedto lose pwr and… - [NTSB FTW82DA387](https://openairdocs.org/ntsb/FTW82DA387.md): Maule M-5-235C · Edna, TX · Accident · No injuries · Final report · Sep 23, 1982 · N5631R · Substantial damage > The pilot took off with the fuel selector in the off position. The engine quit at 500 feet AGL. The pilot landed hard in a plowed field and the aircraft nosed over to an inverted position. The pilot and passenger were not hurt. - [NTSB SEA82DA171](https://openairdocs.org/ntsb/SEA82DA171.md): Piper PA-38-112 · Hillsboro, OR · Accident · No injuries · Final report · Sep 22, 1982 · N6377A · Substantial damage > The dual student was executing touch and go landings. During the takeoff, at an altitude of approximately 20 ft AGL, the instructor reduced power simulating an engine failure. The student pilot maintained a nose high attitude and the aircraft landed hard on… - [NTSB MKC82FCJ06](https://openairdocs.org/ntsb/MKC82FCJ06.md): Stinson 108-2 · Chadron, NE · Accident · Serious injuries · Final report · Sep 22, 1982 · N225C · Substantial damage > After departure, the pilot experienced a loss of power. The pilot made a forced landing in a field approximately one mile from the airport. Examination of the aircraft engine revealed that the mixture control was not attached at the carburetor and that the… - [NTSB FTW82DA390](https://openairdocs.org/ntsb/FTW82DA390.md): Helio H-295 · Waller, TX · Accident · No injuries · Final report · Sep 22, 1982 · N6453V · Substantial damage > A witness observed the aircraft depart from a hard surface runway. The aircraft remained close to the runway surface after lift-off and was observed to make an abrupt pull-up to a nose-high climb angle. The aircraft cleared wires then appeared to fall off to… - [NTSB DEN82DTM18](https://openairdocs.org/ntsb/DEN82DTM18.md): Cessna A185 · Huntington, UT · Accident · No injuries · Final report · Sep 22, 1982 · N6093E · Substantial damage > The aircraft struck trees with the left wing after takeoff. The pilot stated that he experienced a downdraft and that he was unable to recover altitude that was sufficient to clear the trees. The wind was reported to be from 270 degrees at 10 knots, gusting… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=210 ## 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=209 --- 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.