# 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 159 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI88LA235](https://openairdocs.org/ntsb/CHI88LA235.md): Cessna 182K · Detroit Lakes, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1988 · N2616R · Substantial damage > During the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine… - [NTSB BFO88FA082](https://openairdocs.org/ntsb/BFO88FA082.md): Piper J3C-65 · Orange, VA · Accident · 2 fatal · Field investigation · Final report · Sep 11, 1988 · N98121 · Destroyed > Pilot initiated lift off before flying speed was gained and as a result the aircraft had a loss of aerodynamic lift and stalled on the initial takeoff climb. The pilot's inadequate inflight decision and failure to abort the takeoff are contributing factors. - [NTSB SEA88LA177](https://openairdocs.org/ntsb/SEA88LA177.md): Cessna 172M · Battle Mountain, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 1988 · N8895V · Destroyed > At about 1 mile from the departure airport and 200 feet AGL, the pilot elected to make a right turn back to the airport, as the aircraft was not climbing and power lines were in the flight path. During the turn, the pilot lost control of the aircraft. The… - [NTSB NYC88LA234](https://openairdocs.org/ntsb/NYC88LA234.md): Piper PA-28-180 · Griswold, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 1988 · N1840T · Destroyed > The takeoff was made with the temp at about 90 deg f. the acft was about 60 lbs over the authorized max gross wt. Witnesses said the nose of the acft was high as it passed over trees just beyond the end of the rwy. The acft then descended with the wings… - [NTSB LAX88DVA16](https://openairdocs.org/ntsb/LAX88DVA16.md): Hiller UH-12E · Helm, CA · Accident · Minor injuries · Final report · Sep 10, 1988 · N4029Y · Substantial damage > During an aerial application flight, the pilot lost control of the helicopter just after liftoff and collided with the terrain. Inspection of the wreckage revealed that the chemical trucks filler hose was still attached to the helicopter when it lifted off. - [NTSB CHI88LA234](https://openairdocs.org/ntsb/CHI88LA234.md): Fairchild PT-19 · Converse, IN · Accident · No injuries · Limited investigation · Final report · Sep 10, 1988 · N46876 · Substantial damage > During initial climbout after takeoff, the aircraft experienced a loss of engine power. After an unsuccessful attempt to restart the engine, the pilot executed a forced landing in a corn field. Post accident exam revealed a broken universal joint in the fuel… - [NTSB ATL88DKG18](https://openairdocs.org/ntsb/ATL88DKG18.md): Grumman G-164B · Smithville, GA · Accident · No injuries · Final report · Sep 9, 1988 · N8132K · Destroyed > Soon after takeoff from a private sod airstrip for aerial application maneuvering, the engine lost power. The plt was forced to land in soft muddy terrain where the acft nosed over. Post acc invest revealed that the float assy in the carburetor jammed which… - [NTSB LAX88FA312](https://openairdocs.org/ntsb/LAX88FA312.md): Piper PA-28-235 · Camarillo, CA · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1988 · N8743W · Destroyed > The pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the… - [NTSB CHI88LA232](https://openairdocs.org/ntsb/CHI88LA232.md): Piper PA-32-260 · Watertown, WI · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1988 · N9346C · Destroyed > The pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft. - [NTSB SEA88LA171](https://openairdocs.org/ntsb/SEA88LA171.md): Cessna 172L · Leavenworth, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 1988 · N2811Q · Substantial damage > On initial climb over trees bordering 2500-FT mountain strip, plt experienced sudden and severe wind gusts beyond his capability to counter. Acft collided with trees and terrain. - [NTSB FTW88LA163](https://openairdocs.org/ntsb/FTW88LA163.md): American AA1B · Houston, TX · Accident · No injuries · Limited investigation · Final report · Sep 5, 1988 · N6208L · Substantial damage > Shortly after liftoff, the engine lost power and the pilot turned toward a field. The nose wheel struck a levee and the airplane flipped inverted. During a post-crash inspection, a large mud dauber nest was found inside the air induction system, just behind… - [NTSB LAX88FA308](https://openairdocs.org/ntsb/LAX88FA308.md): Cessna 150F · Chino, CA · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1988 · N7093F · Destroyed > Pilot's in flight loss of control of the aircraft during a banner pickup sequence. - [NTSB CHI88LA236](https://openairdocs.org/ntsb/CHI88LA236.md): Schweizer 2-33A · Hinckley, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 4, 1988 · N3613F · Substantial damage > During the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the… - [NTSB ANC88LA124](https://openairdocs.org/ntsb/ANC88LA124.md): Piper PA-18-150 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1988 · N7697D · Substantial damage > The pilot stated that during the takeoff roll and initial climb from the gravel bar, he lost directional control of the airplane causing the airplane to stall, then the airplane ground looped. - [NTSB ANC88LA123](https://openairdocs.org/ntsb/ANC88LA123.md): de Havilland DHC-2 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1988 · N906JS · Substantial damage > The airplane was on a climbout at approximately 1000 to 1200 feet m.s.l. when the engine quit and the pilot encountered an engine fire. The pilot elected to go back to the airport. The airplane crashed on the taxiway, and the airplane was substantially… - [NTSB DEN88LA198](https://openairdocs.org/ntsb/DEN88LA198.md): Cessna 150F · Peyton, CO · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1988 · N6737F · Substantial damage - [NTSB MIA88LA263](https://openairdocs.org/ntsb/MIA88LA263.md): Piper PA-28-181 · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1988 · HBPLH · Substantial damage > While on a ferry flt shortly after takeoff the plt reported that the eng slowly began to lose power. He then attempted to land on another rwy but lost control of the acft & crashed short. An eng run was accomplished which revealed no evidence of pre-impact… - [NTSB DCA88MA072](https://openairdocs.org/ntsb/DCA88MA072.md): Boeing 727-232 · Dallas/Ft Worth, TX · Accident · 14 fatal · Class 1 · Major · Final report · Aug 31, 1988 · N473DA · Destroyed > (1) The captain and first officer's inadequate cockpit discipline which resulted in the flightcrew's attempt to takeoff without the wing flaps and slats properly configured; and (2) the failure of the takeoff configuration warning system to alert the crew… - [NTSB ANC88LA120](https://openairdocs.org/ntsb/ANC88LA120.md): Cessna 170B · Willow, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N2905D · Substantial damage > After the student did a touch and go, during the initial climb out, the airplane stalled and crashed into a row of trees at the end of the runway. The student pilot reportedly startled by turbulence, pulled rapidly back on the control yoke, and the aircraft… - [NTSB SEA88FA166](https://openairdocs.org/ntsb/SEA88FA166.md): Cessna 150H · Caldwell, ID · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1988 · N23204 · Substantial damage > The plt flew to hubler field (a pvt 2800' strip) & landed. After landing on rwy 10, he taxied back to the apch end & took off again. As the acft was climbing, about 60' over trees at the departure end, it rolled abruptly to the left, entered a steep descent &… - [NTSB LAX88LA302](https://openairdocs.org/ntsb/LAX88LA302.md): Bellanca 7ECA · Dunsmuir, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1988 · N5058K · Substantial damage > Just after takeoff, the airplane gained just enough altitude to clear trees at the end of the runway. The pilot turned up a valley to gain altitude. The airplane was gaining altitude at 150 fpm, however, the valley turned into a box canyon and the airplane… - [NTSB MKC88FA164](https://openairdocs.org/ntsb/MKC88FA164.md): Piper J3 · York, NE · Accident · Serious injuries · Field investigation · Final report · Aug 28, 1988 · N3J · Substantial damage > Visual outlook not maintained by pilot in command. - [NTSB CHI88DEC07](https://openairdocs.org/ntsb/CHI88DEC07.md): Cessna 305A · Gregory, MI · Accident · No injuries · Final report · Aug 28, 1988 · N5166G · Substantial damage > Failure (at first partial, then total) of the aircraft's powerplant at an altitude of about 100 feet above the ground during the initial climbout with a glider in tow; a forced landing ensued, during which the aircraft struck a fence, a small tree, and… - [NTSB NYC88DFJ03](https://openairdocs.org/ntsb/NYC88DFJ03.md): Garlick/Guppy SNS-2 · Honeoye Falls, NY · Accident · Serious injuries · Final report · Aug 27, 1988 · N222AG · Substantial damage > The homebuilt airplane was being operated on the first test flight after its completion. During takeoff, the airplane climbed about 100 ft AGL, then crashed in an open field adjacent to the airport. No preimpact part failure/malfunction of the airplane was… - [NTSB LAX88LA298](https://openairdocs.org/ntsb/LAX88LA298.md): Stinson L-5 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1988 · N723E · Substantial damage > During the initial climb, the pilot reported that the engine lost power. The pilot initiated a forced landing and during the descent, the airplane collided with a fence coming to rest inverted. Fuel was observed to be leaking from the left wing. When the fuel… - [NTSB ATL88DKG14](https://openairdocs.org/ntsb/ATL88DKG14.md): Ayres Thrush S2R · Ochlocknee, GA · Accident · Minor injuries · Final report · Aug 26, 1988 · N4006P · Substantial damage > Shortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he… - [NTSB MIA88FA261](https://openairdocs.org/ntsb/MIA88FA261.md): Piper PA-60 · Pembroke Pines, FL · Accident · 3 fatal · Field investigation · Final report · Aug 25, 1988 · N6069W · Destroyed > Witnesses stated that the acft used almost the entire length of the runway during the ground run. After rotation & gear retraction, it continued to climb in a nose high attitude to aprx 100-150 feet, then it started an aprx 20 degree bank to the right until… - [NTSB NYC88LA228](https://openairdocs.org/ntsb/NYC88LA228.md): Luscombe 8A · Doylestown, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1988 · N1203K · Destroyed > The CFI and student plt took off from a 2330 ft turf rwy. Witnesses said the wind was calm and it was hot. The pilots both said that everything seemed normal until the acft reached about 200 ft AGL at which time they lost lift due to either a power loss or… - [NTSB DEN88LA176](https://openairdocs.org/ntsb/DEN88LA176.md): Piper PA-28R-201 · Lordsburg, NM · Accident · No injuries · Limited investigation · Final report · Aug 24, 1988 · N6189H · Substantial damage > Following takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the… - [NTSB CHI88FA218](https://openairdocs.org/ntsb/CHI88FA218.md): Cessna 150F · Bellbrook, OH · Accident · 2 fatal · Field investigation · Final report · Aug 23, 1988 · N8660G · Destroyed > Failure of the PIC to maintain sufficient airspeed to sustain flight during initial climb to clear a barrier after taking off from an off airport area. - [NTSB MKC88LA162](https://openairdocs.org/ntsb/MKC88LA162.md): Grumman G-164A · Elaine, AR · Accident · No injuries · Limited investigation · Final report · Aug 22, 1988 · N6661Q · Substantial damage > During an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine… - [NTSB NYC88DHA03](https://openairdocs.org/ntsb/NYC88DHA03.md): Debarry/Starduster SA100 · Slatington, PA · Accident · No injuries · Final report · Aug 21, 1988 · N22GT · Substantial damage > As the homebuilt acft was climbing thru about 300 ft AGL during initial climb after takeoff, the eng lost power. The plt was able to restart the eng (once), but as he turned the acft back toward the arpt, the eng lost power again. During an emerg landing, the… - [NTSB CHI88LA215](https://openairdocs.org/ntsb/CHI88LA215.md): Cessna 170 · Boyceville, WI · Accident · No injuries · Limited investigation · Final report · Aug 21, 1988 · N3804V · Substantial damage > Shortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft… - [NTSB LAX88DUQ04](https://openairdocs.org/ntsb/LAX88DUQ04.md): Texas Helicopter M74A · Lancaster, CA · Accident · No injuries · Final report · Aug 19, 1988 · N51862 · Substantial damage > During an aerial application flight, just after takeoff, the nose of the helicopter suddenly pitched up. The pilot reduced power to keep from climbing. The fore/aft cyclic control had no effect. The helicopter settled to the ground resulting in substantial… - [NTSB DEN88FA186](https://openairdocs.org/ntsb/DEN88FA186.md): Luscombe 8A · Dimock, SD · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1988 · N71572 · Destroyed > The plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked… - [NTSB CHI88LA213](https://openairdocs.org/ntsb/CHI88LA213.md): Piper PA-28-140E · Glidden, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1988 · N4476T · Substantial damage > While attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was… - [NTSB NYC88LA219](https://openairdocs.org/ntsb/NYC88LA219.md): Piper PA-12 · Georges Mills, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1988 · N2906M · Substantial damage > Witnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the… - [NTSB LAX88LA289](https://openairdocs.org/ntsb/LAX88LA289.md): Cessna 177 · Jackson, CA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1988 · N3270T · Substantial damage > Just after takeoff, the engine quit at aprx 50 ft AGL. The pilot made an emergency forced landing off the runway, where during the landing roll the airplane collided into a fence. There were no mechanical failures or malfunctions found during an engine… - [NTSB MKC88LA159](https://openairdocs.org/ntsb/MKC88LA159.md): Rockwell S-2R · Swifton, AR · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N8856Q · Substantial damage > Shortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused… - [NTSB CHI88FA206](https://openairdocs.org/ntsb/CHI88FA206.md): Aeronca 7CCM · Barker, NY · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1988 · N83255 · Destroyed > The pilot in command failed to maintain control of the airplane. - [NTSB LAX88LA285](https://openairdocs.org/ntsb/LAX88LA285.md): Cessna 172N · Lake Arrowhead, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 1988 · N4788F · Substantial damage > During a local parachute jump flight, the airplane was unable to gain enough altitude to clear rising terrain. The airplane collided with a tree and eventually the terrain. There were no reported mechanical failures or malfunctions. The acft handbook lists… - [NTSB DEN88LA182](https://openairdocs.org/ntsb/DEN88LA182.md): Beech 23 · Pueblo, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 1988 · N2341Z · Substantial damage - [NTSB NYC88FA216](https://openairdocs.org/ntsb/NYC88FA216.md): Cessna TU206G · White Lake, NY · Accident · 2 fatal · Field investigation · Final report · Aug 12, 1988 · N4613Z · Substantial damage > The float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn… - [NTSB CHI88LA202](https://openairdocs.org/ntsb/CHI88LA202.md): Waco ATO · Middletown, OH · Accident · No injuries · Limited investigation · Final report · Aug 12, 1988 · N763E · Substantial damage > The plt stated that during initial climb the engine sputtered and he discovered that the fuel pressure gauge read zero. He made an immediate right turn back toward the airport. While attempting to glide to the airport he noticed that the fuel selector was set… - [NTSB NYC88LA215](https://openairdocs.org/ntsb/NYC88LA215.md): Piper PA-28-140 · Montgomeryville, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1988 · N8233N · Destroyed > The plt reported that the flt took off with light & variable winds. He said he used the short fld, obstacle clearance procedure to avoid powerlines which are located 1000 ft from the end of the rwy. After the acft became airborne it would not climb. A turn… - [NTSB MIA88LA250](https://openairdocs.org/ntsb/MIA88LA250.md): Continental Copters MK-5A · Valley Park, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1988 · N9086T · Substantial damage > The pilot stated that he thought he had 8 gallons of fuel prior to takeoff. The engine failed about 100 ft AGL and he attempted to stretch the glide of the helicopter by using collective pitch. The aircraft hit hard and rolled over. Only 1 quart of fuel was… - [NTSB FTW88IA147](https://openairdocs.org/ntsb/FTW88IA147.md): Piper PA-31-350 · Oklahoma City, OK · Incident · No injuries · Incident investigation · Final report · Aug 10, 1988 · N3589B · Minor damage > The flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an… - [NTSB CHI88FA198](https://openairdocs.org/ntsb/CHI88FA198.md): Piper PA-28 · Auburn, IN · Accident · 2 fatal · Field investigation · Final report · Aug 10, 1988 · N3828K · Destroyed > Flight known adverse weather conditions. - [NTSB MKC88LA151](https://openairdocs.org/ntsb/MKC88LA151.md): Cessna 150 · Lees Summit, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1988 · N51390 · Substantial damage > Shortly after takeoff, on a touch and go, after a full flap landing, the CFI and student said they heard a loud bang about 150 AGL on climbout. The CFI took over the controls and said they were nonresponsive in pitch. Full throttle was maintained and they… - [NTSB NYC88LA206](https://openairdocs.org/ntsb/NYC88LA206.md): Schweizer SGS 1-34 · Kutztown, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 1988 · N65920 · Substantial damage > Loss of control during takeoff after the canopy came open. Contributing was the failure of the pilot to properly close the canopy prior to takeoff. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=160 ## 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=159 --- 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.