# NTSB investigations: Takeoff 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 160 of 281 · 14,038 cases ## Cases, newest first - [NTSB CHI82DA161](https://openairdocs.org/ntsb/CHI82DA161.md): Cessna 152 · Romeo, MI · Accident · No injuries · Final report · May 13, 1982 · N46341 · Substantial damage > The student pilot was practicing touch and go landings. On the third takeoff the aircraft veered to the left and the student was unable to correct. The aircraft continued into a soft field and nosed over. The wind was calm and the weather clear. - [NTSB FTW82DA233](https://openairdocs.org/ntsb/FTW82DA233.md): Cessna 172P · Chandeleur Isla, LA · Accident · No injuries · Final report · May 12, 1982 · N52049 · Substantial damage > While on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to… - [NTSB FTW82FQA19](https://openairdocs.org/ntsb/FTW82FQA19.md): Piper PA-16 · Albuquerque, NM · Accident · Minor injuries · Final report · May 11, 1982 · N5648H · Substantial damage > Both of the occupants were rated pilots and had just purchased the aircraft. They were ferrying the plane from new york state to California. The pilot reported that during takeoff, he lifted off near the mid-point of the runway and held a flat attitude to… - [NTSB NYC82DA093](https://openairdocs.org/ntsb/NYC82DA093.md): Piper PA-38-112 · Endicott, NY · Accident · No injuries · Final report · May 10, 1982 · N2483A · Substantial damage > During takeoff roll the aircraft veered to the left. The pilot stated that he applied right rudder and aileron into the wind, however; the aicraft continued to the left. The pilot then closed the throttle and the aircraft collided with runway lights causing… - [NTSB SEA82DA068](https://openairdocs.org/ntsb/SEA82DA068.md): de Havilland 2 · 15n Of Medford, OR · Accident · No injuries · Final report · May 9, 1982 · N1434Z · Substantial damage > The pilot started a downwind takeoff on runway 15 with 9 parachutists on board. The runway was unidirectional requiring takeoffs on runway 15 which sloped downhill. After beginning the takeoff roll, the pilot had difficulity in maintaining directional control… - [NTSB MKC82FCQ09](https://openairdocs.org/ntsb/MKC82FCQ09.md): Luscombe 8A · Fredonia, KS · Accident · 2 fatal · Final report · May 9, 1982 · N2248K · Destroyed > The aircraft crashed after taking off on a test flight. A witness reported that the aircraft was in a steep angle of climb, and the nose pitched down as the pilot was making a left turn. The witness reported that the pilot had been adjusting the magnetos… - [NTSB CHI82DA155](https://openairdocs.org/ntsb/CHI82DA155.md): Cessna 180 · Aurora, IL · Accident · No injuries · Final report · May 8, 1982 · N9388C · Substantial damage > On takeoff the aircraft veered off the side of the runway and struck a drainage ditch. The pilot reported a gust of wind caught the aircraft. - [NTSB LAX82DVG24](https://openairdocs.org/ntsb/LAX82DVG24.md): Boeing A75 · Maxwell, CA · Accident · Minor injuries · Final report · May 7, 1982 · N5050V · Substantial damage > During the takeoff roll from a local farm strip, the aircraft veered to the right and went off the runway. The pilot reported that the plane went into a small ditch and flipped over. No mechanical failures were reported. - [NTSB CHI82DA151](https://openairdocs.org/ntsb/CHI82DA151.md): Cessna 172A · Cissno Park, IL · Accident · No injuries · Final report · May 5, 1982 · N7709T · Substantial damage > During takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the… - [NTSB FTW82DA165](https://openairdocs.org/ntsb/FTW82DA165.md): Piper PA-18-150 · Marfa, TX · Accident · No injuries · Final report · May 3, 1982 · N7615Z · Substantial damage > During the takeoff roll for a dual instructional flight the aircraft began to veer to the left. The instructor was able to overpower the student on the rudder pedals but not the aft stick pressure. The aircraft lifted off then settled back to the runway in a… - [NTSB ATL82DA123](https://openairdocs.org/ntsb/ATL82DA123.md): Cessna 172E · Marietta, GA · Accident · No injuries · Final report · May 1, 1982 · N3715S · 2 aircraft · Substantial damage > The Boeing A75N1 (stearman) pilot reported that a long final approach was flown to allow room for a twin engine aircraft to land in front of him. He continued landing, but did not see a beige colored Cessna 172 on the runway. He reported that the visibility… - [NTSB LAX82DA153](https://openairdocs.org/ntsb/LAX82DA153.md): Cessna 182E · Markleeville, CA · Accident · No injuries · Final report · Apr 30, 1982 · N31825 · Substantial damage > During the takeoff roll of a touch and go landing the pilot stated that the aircraft abruptly swerved to the left and went off the runway. Substantial damage occurred when the aircraft collided with two trees. - [NTSB ANC82DAG19](https://openairdocs.org/ntsb/ANC82DAG19.md): Piper PA-18-150 · Birchwood, AK · Accident · No injuries · Final report · Apr 30, 1982 · N57617 · Substantial damage > After making one takeoff and landing, the pilot elected to do a short field takeoff. He held the brakes and applied full throttle. His right foot slipped off the right brake and the aircraft turned sharply to the left. During the turn, the aircraft went up on… - [NTSB FTW82DA154](https://openairdocs.org/ntsb/FTW82DA154.md): Piper PA-44-180 · Albuquerque, NM · Accident · No injuries · Final report · Apr 26, 1982 · N39669 · Substantial damage > The purpose of the flight was for the pilot-in-command to take his multi-engine airplane check ride. During the takeoff sequence, the examiner reduced power on one engine. The pilot decided there was insufficient runway remaining and aborted the takeoff. The… - [NTSB ANC82DAG18](https://openairdocs.org/ntsb/ANC82DAG18.md): Cessna 170 · Big Lake, AK · Accident · Minor injuries · Final report · Apr 25, 1982 · N170DM · Substantial damage > During a local flight, the pilot elected to land at the Big Lake airport. Before landing, he noted that weather was moving in from the northwest. Also, he noted that the wind sock was limp, but favored a landing to the west. He landed, and before taking off… - [NTSB NYC82DA075](https://openairdocs.org/ntsb/NYC82DA075.md): Pitts Special S-1C · Latrobe, PA · Accident · No injuries · Final report · Apr 21, 1982 · N1750 · Substantial damage > The pilot initiated a takeoff in winds that were gusting to 19 knots. As he raised the tail during the takeoff roll, the plane swerved right. The pilot stated that he overcorrected to the left. Subsequently, the plane departed the left side of the runway. The… - [NTSB MIA82DA100](https://openairdocs.org/ntsb/MIA82DA100.md): Piper PA-28-140 · Lake Wales, FL · Accident · No injuries · Final report · Apr 19, 1982 · N56826 · Substantial damage > During takeoff, three/fourths of the way down the runway, the pilot decided to abort because of a slow buildup of airspeed on the wet grass. The aircraft overran the runway colliding with a fence and a tree. - [NTSB LAX82DA138](https://openairdocs.org/ntsb/LAX82DA138.md): Robinson R-22 · Perris, CA · Accident · No injuries · Final report · Apr 17, 1982 · N9043E · Destroyed > After refueling with 12.9 gallons of fuel, the pilot took off with one passenger on board. The pilot stated that after lifting off with 104% prm, he began a normal shallow takeoff with 25 inches of manifold pressure. He reported reaching about 75 ft AGL and… - [NTSB ATL82DA107](https://openairdocs.org/ntsb/ATL82DA107.md): Cessna 150 · Jacksonville, NC · Accident · No injuries · Final report · Apr 17, 1982 · N6687G · Substantial damage > After rotation the airspeed would not accelerate past 60 mph during climbout. The instructor took over and after realizing that the aircraft would not climb above 10 feet attempted to land on the remaining 1/3 of the runway. The aircraft floated and ended up… - [NTSB ATL82DA106](https://openairdocs.org/ntsb/ATL82DA106.md): Beech B19 · College Park, MD · Accident · Minor injuries · Final report · Apr 17, 1982 · N1932W · Substantial damage > During the preflight the pilot noted the engine ran rough on the right magneto then smoothed out. The pilot departed the runway with the stall warning horn sounding and began a turn into the wind; however, due to buildings in his path he turned 360 degrees.… - [NTSB LAX82DA108](https://openairdocs.org/ntsb/LAX82DA108.md): Grum Amer AA-5B · Placerville, CA · Accident · Minor injuries · Final report · Apr 16, 1982 · N28867 · Substantial damage > When the pilot arrived at the airport, the top surfaces of the aircraft were covered with about two inches of snow. He stated that his preflight included a complete removal of the snow. However, he also stated that during the takeoff roll, there was a layer… - [NTSB ANC82FA037](https://openairdocs.org/ntsb/ANC82FA037.md): Maule M-4-220C · Homer, AK · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1982 · N40343 · Destroyed > The pilot departed Homer airport on a special VFR clearance after being advised numerous times that VFR flight was not recommended. Shortly after takeoff (8 minutes) the aircraft dove out of the clouds and crashed near the airport. The pilot was not… - [NTSB NYC82DA072](https://openairdocs.org/ntsb/NYC82DA072.md): Cessna 172N · Trenton, NJ · Accident · Minor injuries · Final report · Apr 15, 1982 · N4940G · Substantial damage > During a departure, the pilot initiated an intersection takeoff with about 4000 ft of runway remaining. He reported that the takeoff proceeded normally through lift-off to about 25 ft AGL. From there, the aircraft returned to the runway surface and bounced.… - [NTSB FTW82DA129](https://openairdocs.org/ntsb/FTW82DA129.md): Quickie · Cleveland, TX · Accident · No injuries · Final report · Apr 14, 1982 · N1225G · Substantial damage > After taking off with full power, the pilot turned left to a crosswind position. Shortly thereafter, he noticed a partial power loss and turned further left to a downwind. From this position, there was a powerline between him and the runway. He elected to… - [NTSB CHI82DA121](https://openairdocs.org/ntsb/CHI82DA121.md): Rand K.R.1 · Plymouth, MI · Accident · No injuries · Final report · Apr 14, 1982 · N2263D · Substantial damage > On takeoff roll the left upwind wing lifted and the pilot lost directional control. The aircraft swerved to the right and struck a parked bonanza, N5587D, causing substantial damage to both aircraft. Investigation revealed that the pilot attempted to takeoff… - [NTSB SEA82DA051](https://openairdocs.org/ntsb/SEA82DA051.md): Cessna 172N · Pocatello, ID · Accident · Minor injuries · Final report · Apr 11, 1982 · N1075F · Destroyed > The pilot stated that the aircraft encountered a gust of wind shortly after commencing takeoff roll which moved it directly across the runway. Initially the pilot maintained full power while attempting to regain control of the aircraft however shortly… - [NTSB MIA82DA094](https://openairdocs.org/ntsb/MIA82DA094.md): Piper PA-23-250 · Jacksonville, FL · Accident · No injuries · Final report · Apr 11, 1982 · N4881P · Substantial damage > Immediately after raising the gear handle during takeoff, the pilot heard a loud noise that he thought was an explosion. He aborted the takeoff and landed on the remaining runway without extending the gear. The loud noise occurred when the cabin door popped… - [NTSB CHI82DA119](https://openairdocs.org/ntsb/CHI82DA119.md): Piper PA-22-160 · Nova, OH · Accident · No injuries · Final report · Apr 11, 1982 · N3402Z · Substantial damage > The aircraft encountered a four inch snowdrift during takeoff roll from a sod strip. It nosed over and came to rest inverted. - [NTSB ANC82DA034](https://openairdocs.org/ntsb/ANC82DA034.md): Piper PA-32 · Montague Island, AK · Accident · No injuries · Final report · Apr 11, 1982 · N28582 · Substantial damage > During a takeoff from Montague Island, Alaska, the aircraft collided with snow and willows beyond the departure end of a small strip at mccleod harbor. The pilot reported that just as he started to rotate the aircraft for takeoff, the right gear encountered a… - [NTSB ANC82DA032](https://openairdocs.org/ntsb/ANC82DA032.md): Piper PA-32 · Akiachak, AK · Accident · No injuries · Final report · Apr 8, 1982 · N9304K · Substantial damage > The pilot began taking off on a soft runway with a left quartering crosswind. He stated that he was unable to get enough speed on the soft mud for a safe takeoff. He cut the power to abort, but was unable to stop on the remaining runway. The plane continued… - [NTSB LAX82DA127](https://openairdocs.org/ntsb/LAX82DA127.md): Grumman G-164 · Bakersfield, CA · Accident · No injuries · Final report · Apr 7, 1982 · N703Y · Substantial damage > On takeoff roll the right main tire blew causing the aircraft to veer to the right, leave the runway, and nose over in the soft mud. - [NTSB MKC82DA052](https://openairdocs.org/ntsb/MKC82DA052.md): Cessna 182RG · Gurley, NE · Accident · No injuries · Final report · Apr 5, 1982 · N1686R · Destroyed > During takeoff from a wheatfield the left gear hit a rut and the pilot lost control. The takeoff was aborted and the aircraft traveled across a road and through a fence. - [NTSB FTW82DA113](https://openairdocs.org/ntsb/FTW82DA113.md): Cessna 172N · Tomball, TX · Accident · No injuries · Final report · Apr 4, 1982 · N6374F · Substantial damage > The student pilot lost control of the aircraft during a practice touch and go landing. The aircraft swerved off the left side of runway into a plowed area and nosed down. - [NTSB CHI82DA109](https://openairdocs.org/ntsb/CHI82DA109.md): Cessna 180 · Nokomis, IL · Accident · No injuries · Final report · Apr 1, 1982 · N4936A · Substantial damage > During takeoff from a soft sod field the aircraft started gradually turning to the left. The pilot applied full right rudder then reduced power before the aircraft nosed over on its back. - [NTSB CHI82IA108](https://openairdocs.org/ntsb/CHI82IA108.md): Swearingen SA226TC · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 31, 1982 · N62Z · Minor damage > The aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose… - [NTSB DEN82DA051](https://openairdocs.org/ntsb/DEN82DA051.md): Cessna 182K · St. Ignatius, MT · Accident · No injuries · Final report · Mar 29, 1982 · N2478Q · Substantial damage > The pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally… - [NTSB ATL82FLA01](https://openairdocs.org/ntsb/ATL82FLA01.md): Piper PA-28-140 · Hoboken, GA · Accident · Serious injuries · Final report · Mar 23, 1982 · N5841U · Destroyed > The pilot reported that during takeoff, he accelerated to 68 mph, then realized he would be unable to clear trees. He stated that he closed the throttle and mixture, aimed the aircraft at an opening in the trees, and maintained a level attitude until impact.… - [NTSB FTW82IA095](https://openairdocs.org/ntsb/FTW82IA095.md): Cessna 402C · Chickasha, OK · Incident · No injuries · Incident investigation · Final report · Mar 16, 1982 · N6838A · Minor damage > A checkout was being performed with the PIC in the right seat and the trainee in the left seat. As power was increased for takeoff during a touch and go landing, the PIC heard the propellers strike the runway. The trainee lifted the aircraft off the ground,… - [NTSB LAX82FUQ11](https://openairdocs.org/ntsb/LAX82FUQ11.md): Cessna 172 · Lancaster, CA · Accident · No injuries · Final report · Mar 14, 1982 · N7498X · Destroyed > At 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The… - [NTSB SEA82DA036](https://openairdocs.org/ntsb/SEA82DA036.md): Piper PA-32-301T · Hailey, ID · Accident · No injuries · Final report · Mar 13, 1982 · N83764 · Substantial damage > After an engine run-up with the parking brake set, the first attempt to takeoff was aborted when the plane failed to accelerate satisfactorily. The brakes operated satisfactorily during the abort and a second run-up revealed no unusual engine indications.… - [NTSB MIA82DA071](https://openairdocs.org/ntsb/MIA82DA071.md): Cessna 182H · New Port Richey, FL · Accident · No injuries · Final report · Mar 13, 1982 · N8554S · Substantial damage > The pilot stated that moments after takeoff power was applied the seat retaining pins broke, the pilot's seat moved aft breaking the rear retainer leaving him unable to reach the control yoke. The aircraft swerved off the runway and collided with trees. The… - [NTSB CHI82DA087](https://openairdocs.org/ntsb/CHI82DA087.md): Cessna 182 · Lake Village, IN · Accident · No injuries · Final report · Mar 13, 1982 · N757XU · Substantial damage > The pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost… - [NTSB NYC82DA052](https://openairdocs.org/ntsb/NYC82DA052.md): Piper PA-38-112 · Allentown, PA · Accident · No injuries · Final report · Mar 12, 1982 · N2402C · Destroyed > The student pilot was practicing takeoffs and landings on runway 25 in crosswind conditions. The wind was from 330 degrees at 14 knots. On one of the landings, the aircraft bounced during touchdown. The pilot reportedly added a small amount of power for a… - [NTSB NYC82FNA11](https://openairdocs.org/ntsb/NYC82FNA11.md): Varga 2150A · Marlboro, MA · Accident · Minor injuries · Final report · Mar 10, 1982 · N8419J · Substantial damage > Snow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading… - [NTSB FTW82DA084](https://openairdocs.org/ntsb/FTW82DA084.md): Cessna U-206 · Angel Fire, NM · Accident · No injuries · Final report · Mar 10, 1982 · N3417L · Substantial damage > The aircraft was hit by a crosswind gust during the takeoff run. The aircraft went off the right side of the runway and collided with a snowbank. - [NTSB FTW82DA088](https://openairdocs.org/ntsb/FTW82DA088.md): Rockwell S-2R · Hughes, AR · Accident · No injuries · Final report · Mar 9, 1982 · N4987X · Substantial damage > The pilot attempted a downwind takeoff from a soft ag strip with a heavy load. After realizing that he would be unable to lift-off, the pilot initiated an abort. The aircraft continued off of the end of the strip and flipped over in a muddy terrain. - [NTSB FTW82FRG24](https://openairdocs.org/ntsb/FTW82FRG24.md): Beech E18S · Charlotte, TX · Accident · Minor injuries · Final report · Mar 8, 1982 · N700W · Substantial damage > The aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft. - [NTSB FTW82DA085](https://openairdocs.org/ntsb/FTW82DA085.md): Cessna 172M · Houston, TX · Accident · No injuries · Final report · Mar 7, 1982 · N1117U · Destroyed > During the demonstration of a short field takeoff the aircraft's tail lowered after encountering a moderate dip at a runway intersection. The tail tie-down ring snagged a runway light cable which had been uncovered by recent rains. The cable broke at one side… - [NTSB CHI82DA089](https://openairdocs.org/ntsb/CHI82DA089.md): Cessna 310 · Freemont, MI · Accident · No injuries · Final report · Mar 6, 1982 · N7661Q · Substantial damage > The student was a rated pilot on his first instructional flight in this aircraft. After a practice aborted takeoff, the student applied power to start another takeoff. At about this time, the aircraft veered to the right. The instructorapplied left rudder and… - [NTSB CHI82DA083](https://openairdocs.org/ntsb/CHI82DA083.md): Cessna 152 · Milwaukee, WI · Accident · No injuries · Final report · Mar 5, 1982 · N6125B · Substantial damage > The student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank. Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=161 ## 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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=160 --- 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.