# 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 162 of 412 · 20,559 cases ## Cases, newest first - [NTSB LAX88LA203](https://openairdocs.org/ntsb/LAX88LA203.md): Bell 206B · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · May 30, 1988 · N83203 · Destroyed > During a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin… - [NTSB NYC88LA156](https://openairdocs.org/ntsb/NYC88LA156.md): Piper PA-28-140 · W. Peru, ME · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N54368 · Destroyed > The cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.… - [NTSB NYC88LA150](https://openairdocs.org/ntsb/NYC88LA150.md): Cessna 305A · Colts Neck, NJ · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N5202G · Substantial damage > Loss of power due ot vapor lock of the aircraft engine and an off airport landing and collision with an object. - [NTSB FTW88LA111](https://openairdocs.org/ntsb/FTW88LA111.md): Cessna 210D · New Roads, LA · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N3799Y · Destroyed > The airplane had not had an annual inspection and had not been flown for over a year. The pilot stated he found no contamination during the draining of the fuel sumps. Shortly after takeoff, the engine started sputtering and eventually stopped. During the… - [NTSB NYC88LA154](https://openairdocs.org/ntsb/NYC88LA154.md): Bellanca 8GCBC · Kensington, NH · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N7672S · Substantial damage > Upon reaching the destination airport, the pilot decided to do a few touch and go landings. The aircraft touched down about 600 feet downfield at about 45-50 mph. The pilot reported that with application of full throttle, the engine hesitated. The aircraft… - [NTSB BFO88FA051](https://openairdocs.org/ntsb/BFO88FA051.md): Cessna 150F · Petersburg, VA · Accident · 2 fatal · Field investigation · Final report · May 28, 1988 · N6699F · Destroyed > The plt was being accompanied by a 182 during the flt from NC to tangier island. Both acft landed at Petersburg. A passenger in the 182 had become ill. After refueling and spending a short time at Petersburg, both acft departed for tangier island with the… - [NTSB ATL88LA187](https://openairdocs.org/ntsb/ATL88LA187.md): Cessna 150F · Mc Kenzie, AL · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N7067F · Destroyed > The plt reported that he attempted to takeoff from a pasture that was 'too short'. The airplane began to settle shortly after t/o and one of the MLG wheels struck a short post in the pasture. The airplane hdg was altered and the airplane crashed into a fence.… - [NTSB MKC88FA098](https://openairdocs.org/ntsb/MKC88FA098.md): Beech A-23-19 · Big Island, AR · Accident · 1 fatal · Field investigation · Final report · May 27, 1988 · N3618Q · Destroyed > Incapacitation of the pilot due to a medical event which resulted in loss of aircraft control. - [NTSB LAX88LA200](https://openairdocs.org/ntsb/LAX88LA200.md): Cessna 175C · Santa Rosa, CA · Accident · Serious injuries · Limited investigation · Final report · May 27, 1988 · N8384T · Substantial damage - [NTSB DEN88FA112](https://openairdocs.org/ntsb/DEN88FA112.md): Taylorcraft BC12-D · Albuquerque, NM · Accident · Serious injuries · Field investigation · Final report · May 27, 1988 · N43411 · Destroyed > The pilot and his passenger decided to make a local personal flight. The pilot said he saw a squall line approaching the airport, but thought he could get off the ground before it arrived. He took off and started a left crosswind turn. A gust of wind lifted… - [NTSB BFO88FA050](https://openairdocs.org/ntsb/BFO88FA050.md): Enstrom F-28A · Middletown, DE · Accident · No injuries · Field investigation · Final report · May 27, 1988 · N9209 · Substantial damage > Shortly after takeoff, at an alt of aprx 400 ft, a loud bang was heard and the helicopter developed a moderate to severe vibration. The CFI took control of the helicopter and initiated an autorotation. The helicopter contacted small tree branches and landed… - [NTSB ATL88LA180](https://openairdocs.org/ntsb/ATL88LA180.md): Stinson 108-2 · Avon, OH · Accident · Serious injuries · Limited investigation · Final report · May 27, 1988 · N8563K · Substantial damage > The acft was on initial climb out when the eng quit. The acft was at an estimated altitude of 100 ft and over trees at the time of the power loss. The plt attempted to return to the airstrip. The acft landed hard in a nose down position off to the side of the… - [NTSB MKC88LA103](https://openairdocs.org/ntsb/MKC88LA103.md): Grumman G-164A · Grubbs, AR · Accident · No injuries · Limited investigation · Final report · May 26, 1988 · N4237 · Destroyed > The pilot stated that he experienced a total loss of engine power shortly after takeoff from an agriculture strip near Grubbs, Arkansas. The pilot executed a forced landing into a flooded rice field. Visual meteorological conditions prevailed at the time of… - [NTSB ANC88FA063](https://openairdocs.org/ntsb/ANC88FA063.md): Cessna 206 · Dillingham, AK · Accident · 4 fatal · Field investigation · Final report · May 25, 1988 · N4882U · 2 aircraft · Destroyed > A Cessna 206 airplane and an aerospatiale AS350D helicopter collided in midair one-half mile south of the Dillingham airport, Dillingham, AK. Both aircraft had been communicating with the Dillingham flight service station and had received the appropriate… - [NTSB LAX88LA201](https://openairdocs.org/ntsb/LAX88LA201.md): Cessna 172N · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · May 24, 1988 · N5083D · Substantial damage > Just after takeoff the engine experienced a loss of power. A forced landing was made off the airport in a lake.. The airplane partially sank. The engine was removed to a maintenance facility for examination. No preexisting malfunctions or mechanical failures… - [NTSB FTW88DRA12](https://openairdocs.org/ntsb/FTW88DRA12.md): Grumman G-164A · Winnie, TX · Accident · Minor injuries · Final report · May 24, 1988 · N5374 · Substantial damage > Acft was substantially damaged when it struck a ditch and flipped over after settling to the ground following t/o from a pvt ag strip. The plt stated that during the t/o, the wind shifted to a quartering tailwind and that he attempted to dump his load because… - [NTSB DCA88MA059](https://openairdocs.org/ntsb/DCA88MA059.md): Embraer EMB-110P · Lawton, OK · Accident · Serious injuries · Major investigation · Final report · May 24, 1988 · N65DA · Destroyed > None submitted - [NTSB FTW88LA108](https://openairdocs.org/ntsb/FTW88LA108.md): Cessna 172P · Roanoke, TX · Accident · No injuries · Limited investigation · Final report · May 23, 1988 · N52119 · Substantial damage > The student pilot failed to maintain directional yaw axis control of the aircraft during the crosswind take off. - [NTSB CHI88LA115](https://openairdocs.org/ntsb/CHI88LA115.md): Cessna 172 · North Liberty, IN · Accident · Minor injuries · Limited investigation · Final report · May 22, 1988 · N5848A · Substantial damage > While departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose… - [NTSB SEA88LA099](https://openairdocs.org/ntsb/SEA88LA099.md): Brown 1911 Bellanca · Carson City, NV · Accident · No injuries · Limited investigation · Final report · May 21, 1988 · N10317 · Substantial damage > The purpose of the flight was to test a new type of propeller which had just been installed on the aircraft. The pilot noticed prior to rotation an increase in the RPM. At rotation the nose up pitch was excessive. The pilot lowered the nose of the aircraft to… - [NTSB NYC88LA162](https://openairdocs.org/ntsb/NYC88LA162.md): Cessna 150 · Poland, NY · Accident · No injuries · Limited investigation · Final report · May 21, 1988 · N6078T · Substantial damage > Student pilot stated that on his last takeoff after doing many practice touch and gos from his private strip at his farm, his stall warning came on. When he tried to push the yoke down (forward), it was jammed. He said a small twig had jammed the elevator. He… - [NTSB MKC88LA095](https://openairdocs.org/ntsb/MKC88LA095.md): Beech 23 · Independence, MO · Accident · No injuries · Limited investigation · Final report · May 21, 1988 · N2378L · Substantial damage > The PIC planned a local flt to practice touch and go lndgs. On an earlier flt the PIC had switched the fuel selector to what he thought was the fullest tank. As the subsequent flt progressed, the PIC again selected what he considered to be the fullest tank as… - [NTSB CHI88LA116](https://openairdocs.org/ntsb/CHI88LA116.md): Champion 7GCBC · La Crosse, WI · Accident · Minor injuries · Limited investigation · Final report · May 21, 1988 · N9686S · Substantial damage - [NTSB ANC88FA062](https://openairdocs.org/ntsb/ANC88FA062.md): De Havilland DHC-2 · Anchorage, AK · Accident · 1 fatal · Field investigation · Final report · May 21, 1988 · N1435Z · Destroyed > The airplane had undergone extensive maintenance which included work on the control column. The upper half of the control column was replaced with a throw-over yoke and the aileron system was rerigged. The pilot-in-command picked up the airplane after it was… - [NTSB CHI88LA117](https://openairdocs.org/ntsb/CHI88LA117.md): Piper PA-28R-200 · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · May 20, 1988 · N55786 · Substantial damage - [NTSB FTW88DRD04](https://openairdocs.org/ntsb/FTW88DRD04.md): Grumman G-164A · Rayne, LA · Accident · Minor injuries · Final report · May 19, 1988 · N8657H · Substantial damage > The pilot had made seven previous takeoffs in that airplane, that day, on the same airstrip. On this one, the OAT was 93 degrees f. the elevation was 10 feet MSL and the density altitude was 2300 feet. The airplane was 388 pounds overweight and the CG was.5… - [NTSB ATL88LA178](https://openairdocs.org/ntsb/ATL88LA178.md): Piper PA-18-150 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · May 19, 1988 · N39932 · Substantial damage > The plt was practicing touch and go ldgs on rwy 23 when he lost control of the airplane just after takeoff when it encountered a gust of wind. The rt wing contacted the terrain adjacent to the runway and the airplane flipped over. - [NTSB LAX88LA183](https://openairdocs.org/ntsb/LAX88LA183.md): Piper PA-38-112 · Reedley, CA · Accident · No injuries · Limited investigation · Final report · May 16, 1988 · N23415 · Substantial damage > The aircraft climbed to about 800 feet AGL after takeoff when the engine began to run rough. The pilot said that the engine then 'quit and restart(ed)' several times. He said that insufficient power was available to remain airborne and he attempted a landing… - [NTSB NYC88LA142](https://openairdocs.org/ntsb/NYC88LA142.md): Balloon Works Firefly 7 · Red Creek, NY · Accident · Serious injuries · Limited investigation · Final report · May 14, 1988 · N1502K · No damage > While the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about… - [NTSB BFO88LA048](https://openairdocs.org/ntsb/BFO88LA048.md): Cessna 172RG · Mathew, VA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N6449R · Substantial damage > The plt stated he did a soft field takeoff using 10 degs of flaps. The acft lifted off at about 55 to 60 KTS but according to the plt, was unable to climb out of groundeffect. Since he was too FAR down the rwy to abort the takeoff the plt increased pitch to… - [NTSB NYC88LA138](https://openairdocs.org/ntsb/NYC88LA138.md): Piper PA-28RT-201 · Millbrook, NY · Accident · Serious injuries · Limited investigation · Final report · May 13, 1988 · N2819J · Substantial damage > The aircraft departed runway 17 at sky acres airport and after reachng an altitude of about 100 feet, witnesses observed the engine cowling extended vertically, partially attached. The pilot said he was unable to return to the departure airport, and the… - [NTSB MIA88LA169](https://openairdocs.org/ntsb/MIA88LA169.md): Boeing HP-B-377 · Miami, FL · Accident · Serious injuries · Limited investigation · Final report · May 13, 1988 · HI468 · No damage > According to company personnel, as the acft rotated for takeoff, one generator tripped off the line. Then as the landing gear was selected up, the other three generators simultaineously tripped off. The acft was flown on an extended pattern while the crew… - [NTSB ATL88LA172](https://openairdocs.org/ntsb/ATL88LA172.md): Piper PA-18-150 · Mocksville, NC · Accident · No injuries · Limited investigation · Final report · May 13, 1988 · N9674P · Substantial damage > The floatplane student pilot lost control of the aircraft during a practice glassy water take off. The floatplane instructor did not take control soon enough and the aircraft stalled and struck the water. - [NTSB DEN88DTI01](https://openairdocs.org/ntsb/DEN88DTI01.md): Judge Q2 · Cut Bank, MT · Accident · No injuries · Final report · May 12, 1988 · N31DJ · Substantial damage > The acdt occurred on the arpt when the plt decided to abort the flt shortly after takeoff. The plt said that after takeoff the acft did not seem to accelerate properly so he decided to land. The takeoff had been made on a 5300 ft long rwy which has a 600 ft… - [NTSB BFO88FID03](https://openairdocs.org/ntsb/BFO88FID03.md): Piper PA-38-112 · Chesapeake, VA · Accident · Serious injuries · Final report · May 12, 1988 · N2601C · Destroyed > The pilot was doing touch & go landings. During climbout engine power loss occurred at an estimated 300 ft AGL. The pilot radioed mayday and a witness stated he heard the stall horn during the transmission. Afterwards the acft pitched down and spun to the… - [NTSB ATL88LA169](https://openairdocs.org/ntsb/ATL88LA169.md): Cessna 182 · Raeford, NC · Accident · Serious injuries · Limited investigation · Final report · May 10, 1988 · N5678B · Substantial damage > The airplane lost power shortly after takeoff, at 100-200 ft AGL. A witness reported hearing the engine backfire several times before it lost power completely. The airplane crashed shortly thereafter, as the pilot was attempting to return to the arpt. Exam of… - [NTSB ATL88FA168](https://openairdocs.org/ntsb/ATL88FA168.md): Hughes 269A · Ozark, AL · Accident · 1 fatal · Field investigation · Final report · May 9, 1988 · N1038Y · Substantial damage > Three months prior to the accident a mechanic repaired the left magneto. He reinstalled it and timed it with the right magneto. Both magnetos were found to have advanced timing. Internal examination showed discrepancies which would lead to electrical… - [NTSB LAX88DUJ04](https://openairdocs.org/ntsb/LAX88DUJ04.md): Starr Bumble BEE II · Marana, AZ · Accident · Serious injuries · Final report · May 8, 1988 · N89WS · Destroyed > The airplane was on its first flight since being certified. The pilot had overhauled the engine 2.5 hours prior to the flight. During the climb the engine lost power. The airplane rolled to the left and collided with a utility pole then the ground. The pilot… - [NTSB FTW88LA096](https://openairdocs.org/ntsb/FTW88LA096.md): Piper PA-22-135 · Pawnee, OK · Accident · Serious injuries · Limited investigation · Final report · May 8, 1988 · N1424C · Destroyed > Aircraft's flight envelope was exceeded. - [NTSB DEN88DTE04](https://openairdocs.org/ntsb/DEN88DTE04.md): Grumman G-164A · Vona, CO · Accident · No injuries · Final report · May 7, 1988 · N8518H · Substantial damage > The pilot said the wind was calm when he got in the aircraft before takeoff. He said that when the aircraft reached about 50 feet AGL, after takeoff, he encountered a tailwind. The aircraft settled and collided with the ground. The ground was soft and the… - [NTSB CHI88LA108](https://openairdocs.org/ntsb/CHI88LA108.md): Hughes 269B · Minneapolis, MN · Accident · Minor injuries · Limited investigation · Final report · May 7, 1988 · N9487F · Substantial damage > The pilot was executing a downwind takeoff, the winds reportedly gusting to 25 knots, loaded with two passengers, when just after takeoff the pilot stated the helicopter experienced a loss of power. The pilot then attempted to execute an autorotation, but… - [NTSB CHI88DEE04](https://openairdocs.org/ntsb/CHI88DEE04.md): Cessna 205 · Moline, IL · Accident · Minor injuries · Final report · May 7, 1988 · N647MA · Destroyed > During initial climb on a pleasure flight the airplane experienced a loss of fuel pressure and then total engine failure. The airplane nosed over during the subsequent off airport landing. Post accident examination of the engine driven fuel pump revealed… - [NTSB NYC88DFJ01](https://openairdocs.org/ntsb/NYC88DFJ01.md): Hurd/Drifter XP503 · Baldwinsville, NY · Accident · Minor injuries · Final report · May 6, 1988 · N29CH · Substantial damage > The plt rprtd that during a preflt, he noted the fuel tank was about 1/4 full. He rprtd that as he was taking off, the acft was climbing thru about 200 ft AGL, when the eng lost power. From that position, he was unable to rtrn to the arpt or glide to an open… - [NTSB MKC88LA083](https://openairdocs.org/ntsb/MKC88LA083.md): Hyde Quickee · Creve Coeur, MO · Accident · Minor injuries · Limited investigation · Final report · May 2, 1988 · N263Q · Substantial damage > The plt, flying the unfamiliar homebuilt canard type acft for the first time, said shortly after takeoff the acft began to buffet and sink. The acft then entered a steep bank and continued sinking until it struck the terrain. Corrective attempts by the plt to… - [NTSB FTW88LA095](https://openairdocs.org/ntsb/FTW88LA095.md): Globe GC-1B · Pipe Creek, TX · Accident · No injuries · Limited investigation · Final report · May 2, 1988 · N80799 · Substantial damage > Shortly after takeoff, the engine started running rough. The pilot said he thought he could make the airport and turned toward it. Just short of the airport, the engine quit completely. The pilot was able to get to the airport but crossways to the runway.… - [NTSB ATL88LA161](https://openairdocs.org/ntsb/ATL88LA161.md): Hughes 269C · Greenwood, SC · Accident · Serious injuries · Limited investigation · Final report · May 2, 1988 · N58197 · Substantial damage > The plt reported that the engine RPM began to drop. Shortly after he took off from an open field. He opened the throttle further in an attempt to regain RPM but the engine did not respond. The helicopter subsequently crashed onto a bldg roof as the plt… - [NTSB BFO88LA041](https://openairdocs.org/ntsb/BFO88LA041.md): Cessna 170B · Goldsboro, MD · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N8271A · Substantial damage > The plt said he unsuccessfully tried to climb in ground-effect after the acft lifted off before adequate flying speed was obtained. The acft drifted right of the rwy and touched down in a plowed field where it nosed over. - [NTSB NYC88FA131](https://openairdocs.org/ntsb/NYC88FA131.md): Piper PA-22-150 · Thomasville, PA · Accident · 3 fatal · Field investigation · Final report · Apr 29, 1988 · N3014Z · Destroyed > Due to the pilot's improper preflight planning, he attempted to takeoff with his aircraft weight above the maximum gross weight in a high unfavorable 90 degree crosswind, failed to maintain directional control, and collided with trees. - [NTSB FTW88LA093](https://openairdocs.org/ntsb/FTW88LA093.md): Pezetel PZL-M-18 · Cheneyville, LA · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N4226V · Substantial damage > The pilot said that after takeoff the aircrft seemed extremely tail-heavy and that he used 'both feet and one arm' to hold forward stick. He said the aircraft was almost uncontrollable in pitch and displayed a right turning tendendcy. The pilot returned to… - [NTSB DEN88DTE03](https://openairdocs.org/ntsb/DEN88DTE03.md): Piper PA-25-235 · Akron, CO · Accident · No injuries · Final report · Apr 25, 1988 · N9569P · Substantial damage > The pilot said the wind was from 200 degrees at 10 KTS, as he began his takeoff on runway 13. When the aircraft reached 20-30 feet AGL it began to sink and collided with the ground. The pilot said he thought he encountered a wind shear or change of wind… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=163 ## 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=162 --- 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.