# 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 30 of 412 · 20,559 cases ## Cases, newest first - [NTSB DCA17WA029](https://openairdocs.org/ntsb/DCA17WA029.md): Boeing 767 · Kagoshima, Japan · Accident · No injuries · Foreign investigation · Nov 10, 2016 · JA658J · No damage > The Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767, which occurred on November 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO… - [NTSB CEN17LA036](https://openairdocs.org/ntsb/CEN17LA036.md): Stinson L 5 · San Marcos, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2016 · N4252K · Substantial damage > The pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn. - [NTSB ERA17LA032](https://openairdocs.org/ntsb/ERA17LA032.md): Bell OH 58C · Cameron, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2016 · N139RD · Substantial damage > An in-flight failure of a main rotor blade due to fatigue cracks. Contributing to the failure of the main rotor blade was the absence of guidance to the operator to inspect an area of the main rotor blade known to be susceptible to fatigue cracks and the… - [NTSB GAA17CA198](https://openairdocs.org/ntsb/GAA17CA198.md): Aeros 2 · Blountstown, FL · Accident · Serious injuries · Data collection · Final report · Oct 29, 2016 · UNREG · Substantial damage > The noncertificated pilot's decision to fly the weight-shift-controlled aircraft without having received training in the aircraft type, which resulted in his loss of aircraft control shortly after takeoff. - [NTSB ENG17IA003](https://openairdocs.org/ntsb/ENG17IA003.md): Airbus A330 223 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 26, 2016 · N855NW · No damage > A No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration… - [NTSB ERA17WA051](https://openairdocs.org/ntsb/ERA17WA051.md): Embraer EMB711 · Espumoso, Brazil · Accident · 2 fatal · Foreign investigation · Oct 25, 2016 · PT-NQS · Substantial damage > On October 25, 2016, about 1250 coordinated universal time (1050 local time), an Embraer 711C, Brazilian registration PT-NQS, operated by a private individual, was destroyed after it impacted the ground shortly after takeoff from Espumoso Airport (SSEZ),… - [NTSB DCA17WA015](https://openairdocs.org/ntsb/DCA17WA015.md): Lockheed Stalker · Avoca, Australia · Accident · No injuries · Foreign investigation · Oct 25, 2016 · UNREG · Substantial damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's… - [NTSB DCA17WA014](https://openairdocs.org/ntsb/DCA17WA014.md): Lockheed Stalker · Mount Disappointment, Australia · Accident · No injuries · Foreign investigation · Oct 24, 2016 · UNREG · Substantial damage > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a Lockheed Martin Stalker XE unmanned aircraft that occurred on October 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's… - [NTSB WPR17LA015](https://openairdocs.org/ntsb/WPR17LA015.md): Ryan W Gross Arion Lighting · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Oct 22, 2016 · N235SC · Substantial damage > The pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane. - [NTSB CEN17FA024](https://openairdocs.org/ntsb/CEN17FA024.md): Beech C23 · Osage Beach, MO · Accident · 2 fatal · Field investigation · Final report · Oct 22, 2016 · N20087 · Substantial damage > The pilot's loss of control while maneuvering shortly after takeoff. Contributing to the loss of control was the pilot's attempt to climb with the flaps fully extended. - [NTSB CEN17LA021](https://openairdocs.org/ntsb/CEN17LA021.md): Zenith CH-750 · Morristown, MN · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 2016 · N8681 · Substantial damage > A total loss of engine power due to fuel vapor lock. Contributing to the loss of engine power were the corrosion of the spark plugs and the spacing of the electrode gaps. - [NTSB ERA17LA015](https://openairdocs.org/ntsb/ERA17LA015.md): Cessna 150 · Stockbridge, GA · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2016 · N7948F · Substantial damage > A partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. - [NTSB ANC17WA030](https://openairdocs.org/ntsb/ANC17WA030.md): Cessna 500 · Kelowna, Canada · Accident · 4 fatal · Foreign investigation · Oct 14, 2016 · C-GTNG · Destroyed > On October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft… - [NTSB WPR17LA005](https://openairdocs.org/ntsb/WPR17LA005.md): Mcdonnell Douglas Helicopter 369E · Waimea, HI · Accident · No injuries · Limited investigation · Final report · Oct 4, 2016 · N311VT · Substantial damage > Impact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter. - [NTSB CEN17LA011](https://openairdocs.org/ntsb/CEN17LA011.md): Fokker DR-1 · Fulshear, TX · Accident · No injuries · Limited investigation · Final report · Oct 3, 2016 · N83WR · Substantial damage > A partial loss of engine power due to the improper assembly of the mechanical fuel pump. - [NTSB ENG16RA041](https://openairdocs.org/ntsb/ENG16RA041.md): BAE AVRO146RJ · Malmo, Sweden · Incident · No injuries · Foreign investigation · Sep 29, 2016 · SE-DSP · No damage > The Swedish Accident Investigation Authority has notified the NTSB of an incident involving a BAE Systems (Operations) Limited Avro 146-RJ100 which occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Swedish… - [NTSB ERA16LA330](https://openairdocs.org/ntsb/ERA16LA330.md): Tatkovsky James G Safari · Andover, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2016 · N330JT · Destroyed > The noncertificated pilot’s failure to maintain helicopter control during initial climb. - [NTSB GAA16CA514](https://openairdocs.org/ntsb/GAA16CA514.md): Cessna 205 · Ellington, CT · Accident · No injuries · Data collection · Final report · Sep 26, 2016 · N8433Z · Substantial damage > The pilot's exceedance of the airplane's critical angle-of-attack during the initial climb after an attempted go-around, which resulted in an aerodynamic stall. - [NTSB ERA16FA325](https://openairdocs.org/ntsb/ERA16FA325.md): Mooney M20J · Pittstown, NJ · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2016 · N526AM · Substantial damage > The pilot's improper landing touchdown attitude, which resulted in a propeller strike, and his inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and led to an aerodynamic stall during… - [NTSB CEN16WA384](https://openairdocs.org/ntsb/CEN16WA384.md): Cessna 206 · Lake Kuashkuapishiu, Canada · Accident · 2 fatal · Foreign investigation · Sep 25, 2016 · C-FWBQ · Substantial damage > On September 25, 2016, a Cessna U206F airplane, C-FWBQ, collided with terrain after departing from Lake Kuashkuapishiu, Quebec. The pilot was seriously injured and two passengers were fatally injured. This investigation is under the jurisdiction and control… - [NTSB CEN16LA394](https://openairdocs.org/ntsb/CEN16LA394.md): Piper PA 22-108 · Pearland, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 2016 · N4920Z · Substantial damage > A partial loss of engine power during takeoff for reasons that could not be determined based on the available information following a thorough postaccident examination. - [NTSB CEN16LA379](https://openairdocs.org/ntsb/CEN16LA379.md): Cessna 172S · Chesterfield, MO · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2016 · N52265 · Destroyed > The pilot's unstable approach and subsequent loss of airplane control during an attempted go-around. - [NTSB ERA16LA319](https://openairdocs.org/ntsb/ERA16LA319.md): Grumman G164 · Chestertown, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 18, 2016 · N75EP · Substantial damage > Loss of engine power due to a failure of the No. 3 cylinder head, which resulted in a forced landing and collision with ground equipment. - [NTSB ERA16WA317](https://openairdocs.org/ntsb/ERA16WA317.md): Piper PA28 · Flanders, Colombia · Accident · 2 fatal · Foreign investigation · Sep 15, 2016 · HK1328G · 2 aircraft · Substantial damage > On September 15, 2016, about 1523 universal coordinated time, a Piper PA-28-140; Colombian registration, HK1328G, operated by Aeroandes Flight Training School, and a Cessna 152; Columbian registration, HK2092G, operated by Acahel Flight Training School… - [NTSB WPR16FA178](https://openairdocs.org/ntsb/WPR16FA178.md): Piper PA 28R-201T · Reno, NV · Accident · 3 fatal · Field investigation · Final report · Sep 12, 2016 · N821ET · Destroyed > The pilot's decision to depart with the airplane loaded above its maximum gross weight and at or just beyond its aft center of gravity limitations, which resulted in a loss of control during the initial climb. Contributing to the accident was the pressure to… - [NTSB CEN16LA366](https://openairdocs.org/ntsb/CEN16LA366.md): Piper PA 18 · Greenville, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 2016 · N3286Z · Substantial damage > The pilot's premature turn during the takeoff climb and subsequent turn to avoid trees, which resulted in his exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall. - [NTSB CEN16CA383](https://openairdocs.org/ntsb/CEN16CA383.md): Mooney M20D · Brodhead, WI · Accident · Minor injuries · Data collection · Final report · Sep 11, 2016 · N6919U · Substantial damage > The pilot's loss of airplane control during initial climb due to an excessively nose-high attitude. Contributing to the accident was the pilot's failure to properly set the elevator trim before takeoff in accordance with the Before Takeoff checklist. - [NTSB ANC16LA062](https://openairdocs.org/ntsb/ANC16LA062.md): Dehavilland DHC-2 · Kodiak, AK · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 9, 2016 · N91AK · Substantial damage > The pilot's failure to maintain adequate airspeed during the initial climb and turn after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB DCA16WA237](https://openairdocs.org/ntsb/DCA16WA237.md): Cessna 210 · Naivasha, Nakuru County, Kenya · Accident · No injuries · Foreign investigation · Sep 8, 2016 · 5Y-CKK · Destroyed > The Kenya Air Accident Investigation Department (AAID) has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on September 08, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID's investigation under… - [NTSB CEN16LA363](https://openairdocs.org/ntsb/CEN16LA363.md): CGS Hawk Aero II · Holland, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 2016 · N4513S · Destroyed > The improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.… - [NTSB WPR16LA175](https://openairdocs.org/ntsb/WPR16LA175.md): Mcdonnell Douglas Helicopter 500N · Honolulu, HI · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2016 · N5232G · No damage > The pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the… - [NTSB CEN16LA342](https://openairdocs.org/ntsb/CEN16LA342.md): Fairchild M 62A-3 · Madison, OH · Accident · No injuries · Limited investigation · Final report · Aug 30, 2016 · N47164 · Substantial damage > The pilot's failure to follow the Before Takeoff checklist and his improper use of flaps during takeoff, which degraded the airplane's climb performance and resulted in a collision with trees. - [NTSB CEN16LA339](https://openairdocs.org/ntsb/CEN16LA339.md): Rans Coyote S 4 · Clarksville, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 2016 · N8024J · Substantial damage > The total loss of engine power due to a deteriorated and disconnected fuel line, which resulted in fuel starvation and a subsequent hard, off-field landing. - [NTSB ERA16WA298](https://openairdocs.org/ntsb/ERA16WA298.md): Cessna 550 · Charallave, Venezuela · Accident · 2 fatal · Class 3 · Foreign · Aug 16, 2016 · YV3051 · Destroyed - [NTSB CEN16LA320](https://openairdocs.org/ntsb/CEN16LA320.md): Cirrus Design SR20 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2016 · N314BF · Destroyed > The two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb. - [NTSB ANC16FA057](https://openairdocs.org/ntsb/ANC16FA057.md): Champion 7ECA · Chugiak, AK · Accident · 1 fatal · Field investigation · Final report · Aug 13, 2016 · N9541S · Destroyed > The pilot's failure to maintain proper airspeed and his exceedance of the airplane's critical angle of attack during a steep low-altitude turn following a loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control at too low… - [NTSB ERA16FA288](https://openairdocs.org/ntsb/ERA16FA288.md): Beech 95 B55 (T42A) · Fredericksburg, VA · Accident · 6 fatal · Field investigation · Final report · Aug 12, 2016 · N128VB · Substantial damage > The pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB ANC16LA054](https://openairdocs.org/ntsb/ANC16LA054.md): De Havilland Beaver DHC-2 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2016 · N95RC · Substantial damage > The pilot's decision to perform the takeoff despite calculations showing that the distance available was inadequate, which resulted in impact with terrain. - [NTSB ERA16LA280](https://openairdocs.org/ntsb/ERA16LA280.md): Piper PA 28R-201 · Northampton, MA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2016 · N3783M · Substantial damage > The failure of the alternate air valve plate hinge pin, which caused the alternate air valve plate to lodge in the fuel servo assembly, which resulted in a restriction of air to the fuel servo assembly, a loss of engine power, and an off-airport emergency… - [NTSB CEN16FA308](https://openairdocs.org/ntsb/CEN16FA308.md): Pzl-Bielsko SZD 55-1 · Channahon, IL · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2016 · N551DR · Substantial damage > The glider pilot's failure to maintain adequate pitch control while being towed and his subsequent failure to maintain adequate airspeed control after releasing from the towline, which resulted in the glider exceeding its critical angle of attack and an… - [NTSB CEN16LA305](https://openairdocs.org/ntsb/CEN16LA305.md): Gilchrist PA14EXP · Sparta, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2016 · N18PG · Substantial damage > A total loss of engine power for reasons that could not be determined, since postaccident examination revealed no malfunctions or anomalies that would have precluded normal operation. - [NTSB ERA16FA279](https://openairdocs.org/ntsb/ERA16FA279.md): Cessna 414 · Destin, FL · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2016 · N2735A · Destroyed > The pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions. - [NTSB CEN16LA300](https://openairdocs.org/ntsb/CEN16LA300.md): Wings AN Things Avid Flyer · Bluffton, IN · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2016 · N430WT · Substantial damage > The loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation. - [NTSB WPR16FA157](https://openairdocs.org/ntsb/WPR16FA157.md): Arion Lightning LS-1 · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Aug 2, 2016 · N341AL · Substantial damage > The pilot's loss of airplane control due to an exceedance of the airplane's critical angle of attack, which resulted in an accelerated stall and subsequent impact with a building. Contributing to the accident was the pilot's unreported physiological… - [NTSB GAA16CA411](https://openairdocs.org/ntsb/GAA16CA411.md): Beech F33 · Blythe, CA · Accident · No injuries · Data collection · Final report · Aug 1, 2016 · N6728X · Substantial damage > The pilot's failure to attain adequate airspeed to climb and her exceedance of the airplane's critical angle-of-attack during takeoff initial climb at night, which resulted in an aerodynamic stall at low altitude. - [NTSB GAA16CA406](https://openairdocs.org/ntsb/GAA16CA406.md): Cessna 177 · Kalispell, MT · Accident · No injuries · Data collection · Final report · Jul 31, 2016 · N30550 · Substantial damage > The airplane's hard landing during an aborted takeoff, following an encounter with a downdraft during takeoff initial climb from a remote mountain airstrip, resulting in an uncontrolled descent, attempt to land on the runway remaining, and subsequent nose… - [NTSB CEN16LA296](https://openairdocs.org/ntsb/CEN16LA296.md): Ryan Navion B · Manitowoc, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2016 · N5294K · Substantial damage > A leak in the gascolator due to degraded rubber gaskets, which allowed air to enter the fuel system and resulted in fuel starvation and a total loss of engine power during takeoff. - [NTSB WPR16FA152](https://openairdocs.org/ntsb/WPR16FA152.md): Cessna 310B · Columbia, CA · Accident · 4 fatal · Field investigation · Final report · Jul 27, 2016 · N6605B · Substantial damage > The pilot's failure to maintain control during takeoff initial climb for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA16LA270](https://openairdocs.org/ntsb/ERA16LA270.md): Craig D Carter Stol CH 750 · Waynesburg, PA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2016 · N750AZ · Substantial damage > The partial loss of engine power due to carburetor icing. - [NTSB ERA16LA268](https://openairdocs.org/ntsb/ERA16LA268.md): Frank Ware Velocity TXL · Sebastian, FL · Accident · No injuries · Limited investigation · Final report · Jul 23, 2016 · N916TC · Substantial damage > The total loss of engine power due to maintenance personnel’s improper setting of the aneroid adjustment. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=31 ## 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=30 --- 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.