# 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 26 of 412 · 20,559 cases ## Cases, newest first - [NTSB WPR18LA158](https://openairdocs.org/ntsb/WPR18LA158.md): Rhoads Autogyro MTO Sport · San Manuel, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 21, 2018 · N574BR · Substantial damage > The fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue. - [NTSB ERA18FA149](https://openairdocs.org/ntsb/ERA18FA149.md): Taylorcraft BC12 · Commerce, GA · Accident · 1 fatal · Field investigation · Final report · May 21, 2018 · N94909 · Substantial damage > The pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff. - [NTSB CEN18FA168](https://openairdocs.org/ntsb/CEN18FA168.md): Cirrus Design SR22 · Lone Tree, CO · Accident · 1 fatal · Field investigation · Final report · May 12, 2018 · N507TX · Destroyed > The pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions. - [NTSB CEN18LA171](https://openairdocs.org/ntsb/CEN18LA171.md): Cessna 172N · Orrville, OH · Accident · Serious injuries · Limited investigation · Final report · May 11, 2018 · N738XT · Substantial damage > The pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. - [NTSB ERA18FA141](https://openairdocs.org/ntsb/ERA18FA141.md): Aeronca 7AC · Middletown, NY · Accident · 1 fatal · Field investigation · Final report · May 5, 2018 · N84396 · Substantial damage > The pilot's exceedance of the airplane's critical angle of attack during climbout, which resulted in an aerodynamic stall from which the pilot could not recover. - [NTSB WPR18LA132](https://openairdocs.org/ntsb/WPR18LA132.md): Cosmos Phase III · Fernandina Beach, FL · Accident · Minor injuries · Limited investigation · Final report · May 1, 2018 · N6466 · Substantial damage > The student pilot's failure to maintain aircraft control and the flight instructor’s failure to adequately monitor the student pilot before aircraft control was lost at a low altitude. - [NTSB CEN18WA154](https://openairdocs.org/ntsb/CEN18WA154.md): Amateur Construction Vari EZE · Innsbruck, Austria · Accident · 2 fatal · Foreign investigation · Apr 29, 2018 · HB-YCM · Destroyed > On April 29, 2018, about 0819 hours universal coordinated time, an amateur-built Vari-Eze airplane, Swiss registration HB-YCM, impacted terrain shortly after takeoff from the Innsbruck Airport (LOWI), Innsbruck, Austria. The pilot and passenger were fatally… - [NTSB CEN18LA152](https://openairdocs.org/ntsb/CEN18LA152.md): Grumman G 164A · Garwood, TX · Accident · No injuries · Limited investigation · Final report · Apr 27, 2018 · N6637 · Substantial damage > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA18LA134](https://openairdocs.org/ntsb/ERA18LA134.md): Stanley Ernie Sigurd Kolb Mark · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Apr 20, 2018 · N9123R · Destroyed > The pilot's loss of airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to take off in the nonairworthy airplane in which he had no training and his lack of flight experience in the 17… - [NTSB DCA18LA163](https://openairdocs.org/ntsb/DCA18LA163.md): Airbus A330 323 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2018 · N806NW · Substantial damage > The flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that… - [NTSB ENG18WA025](https://openairdocs.org/ntsb/ENG18WA025.md): Airbus A330 · Brisbane, QLD, Australia · Incident · No injuries · Foreign investigation · Apr 14, 2018 · VH-EBR · No damage > The Australian Government has notified the NTSB of an incident involving an Airbus A330-202 that occurred April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau (ATSB) investigation under the… - [NTSB DCA18WA140](https://openairdocs.org/ntsb/DCA18WA140.md): Airbus A320 · Orlando, FL · Incident · No injuries · Foreign investigation · Apr 14, 2018 · C-FTJR · Minor damage > The Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the TSB's investigation under the… - [NTSB DCA18WA308](https://openairdocs.org/ntsb/DCA18WA308.md): Airbus A320 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Apr 12, 2018 · XA-BAV · Minor damage > The government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of… - [NTSB WPR18FA119](https://openairdocs.org/ntsb/WPR18FA119.md): Piper PA 24-260 · Scottsdale, AZ · Accident · 6 fatal · Field investigation · Final report · Apr 10, 2018 · N9456P · Destroyed > The flight instructor's failure to maintain airplane control during the initial climb as a result of the airplane being loaded above its maximum gross weight and beyond its aft center of gravity limits. Contributing to the accident was a degraded engine power… - [NTSB ANC18FA028](https://openairdocs.org/ntsb/ANC18FA028.md): Mooney M20J · Petaluma, CA · Accident · 1 fatal · Field investigation · Final report · Apr 7, 2018 · N9133Z · Destroyed > The pilot's failure to maintain adequate airspeed while departing in instrument meteorological conditions, moderate turbulence, and low-level wind shear, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall. - [NTSB ERA18FA120](https://openairdocs.org/ntsb/ERA18FA120.md): Piper PA28R · Daytona Beach, FL · Accident · 2 fatal · Class 3 · Field · Final report · Apr 4, 2018 · N106ER · Destroyed > Extensive fatigue cracking in the left-wing main spar lower cap and doublers, which resulted in the in-flight separation of the left wing. The fatigue cracks initiated and grew to a critical size due to flight and ground loads associated with flight-training… - [NTSB WPR18FA112](https://openairdocs.org/ntsb/WPR18FA112.md): Mooney M20E · Marina, CA · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2018 · N213EJ · Destroyed > The pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin. - [NTSB CEN18LA125](https://openairdocs.org/ntsb/CEN18LA125.md): Cub Crafters PA18 150 · Beggs, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 2018 · N226JK · Substantial damage > The pilot's failure to verify that the fuel selector was properly set before takeoff, which resulted in a total loss of engine power due to fuel starvation. - [NTSB ERA18LA107](https://openairdocs.org/ntsb/ERA18LA107.md): Cessna 177 · Key West, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 2018 · N713CX · Substantial damage > A partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation. - [NTSB ERA18LA103](https://openairdocs.org/ntsb/ERA18LA103.md): Cessna T210 · Orlando, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 13, 2018 · N5382A · Substantial damage > The improper adjustment of the fuel pump by maintenance personnel, which resulted in an overly rich fuel/air mixture and a total loss of engine power. - [NTSB ERA18LA101](https://openairdocs.org/ntsb/ERA18LA101.md): Piper PA28 · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · Mar 13, 2018 · N5646V · Substantial damage > The pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff. - [NTSB WPR18LA105](https://openairdocs.org/ntsb/WPR18LA105.md): Piper PA 28-180 · Montague, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 11, 2018 · N6611J · Substantial damage > Impact with powerlines and terrain after takeoff for reasons that could not be determined based on the available information. - [NTSB CEN18LA119](https://openairdocs.org/ntsb/CEN18LA119.md): Czech Sport Piper Sport · Addison, TX · Accident · Serious injuries · Class 2 · Limited · Final report · Mar 10, 2018 · N422PS · Substantial damage > The operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock. - [NTSB WPR18LA101](https://openairdocs.org/ntsb/WPR18LA101.md): Piper PA28R · Paso Robles, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2018 · N33807 · Substantial damage > The pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power. - [NTSB CEN18LA177](https://openairdocs.org/ntsb/CEN18LA177.md): Cessna 150M · Sinton, TX · Accident · No injuries · Limited investigation · Final report · Mar 7, 2018 · N66786 · Substantial damage > The inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing. - [NTSB ERA18LA102](https://openairdocs.org/ntsb/ERA18LA102.md): Piper PA 32-300 · Pompano Beach, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 1, 2018 · N54476 · Substantial damage > The pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach… - [NTSB CEN18LA114](https://openairdocs.org/ntsb/CEN18LA114.md): Beech 77 · Odessa, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2018 · N6699B · Substantial damage > The pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane. - [NTSB ERA18LA087](https://openairdocs.org/ntsb/ERA18LA087.md): Aero Commander Callair A 9 · Bunn, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 24, 2018 · N8401V · Substantial damage > The glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and… - [NTSB DCA18RA093](https://openairdocs.org/ntsb/DCA18RA093.md): Airbus A330 · Lagos, Nigeria · Incident · Minor injuries · Foreign investigation · Feb 13, 2018 · N858NW · Minor damage > The AIB of Nigeria has notified the NTSB of an incident involving a Airbus A330 airplane that occurred on February 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB of Nigeria's investigation under the provisions of ICAO… - [NTSB DCA18WA107](https://openairdocs.org/ntsb/DCA18WA107.md): Antonov AN148 · Argunovo, Russia · Accident · 71 fatal · Foreign investigation · Feb 11, 2018 · RA-61704 · Destroyed > The Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a ANTONOV AN-148 airplane that occurred on February 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the… - [NTSB ERA18WA261](https://openairdocs.org/ntsb/ERA18WA261.md): Skyrunner MK 3.2 · Margham, Dubai, United Arab Emirates · Accident · Serious injuries · Foreign investigation · Feb 9, 2018 · N143SR · Substantial damage > The government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab… - [NTSB ERA18LA083](https://openairdocs.org/ntsb/ERA18LA083.md): Gregory Newman Sonex Trainer · Carrabelle, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 5, 2018 · N543SX · Substantial damage > A loss of engine power for reasons that could not be determined because the airplane was not recovered. Also causal was the pilot's decision to conduct a low-altitude turn following the loss of engine power, which resulted in an exceedance of the airplane's… - [NTSB ERA18LA068](https://openairdocs.org/ntsb/ERA18LA068.md): Schweizer 269C · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Jan 24, 2018 · N3947C · Substantial damage > The partial loss of engine power during the initial climb due to a stuck intake valve on the No. 4 cylinder. - [NTSB WPR18WA159](https://openairdocs.org/ntsb/WPR18WA159.md): Robinson R44 · Ayers Rock, Australia · Accident · Serious injuries · Foreign investigation · Jan 17, 2018 · VH-HGX · Substantial damage > On January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot… - [NTSB WPR18LA070](https://openairdocs.org/ntsb/WPR18LA070.md): Piper PA 32-300 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jan 17, 2018 · N4027W · Substantial damage > A total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the pilot/owner to ensure that the airplane was airworthy before flight. - [NTSB CEN18LA076](https://openairdocs.org/ntsb/CEN18LA076.md): Beech K35 · Longmont, CO · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 2018 · N803R · Substantial damage > A total loss of engine power for reasons that could not be determined because a postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation. - [NTSB WPR18WA060](https://openairdocs.org/ntsb/WPR18WA060.md): De Havilland DHC2 · Cottage Point, Australia · Accident · 6 fatal · Foreign investigation · Dec 31, 2017 · VH-NOO · Destroyed > On December 31, 2017, at 1515 local time, a De Havilland DHC-2, VH-NOO, collided with water during takeoff initial climb near Cottage Point, Australia. The airplane was destroyed and the pilot and five passengers were fatally injured. The flight was operated… - [NTSB DCA18CA056](https://openairdocs.org/ntsb/DCA18CA056.md): Mcdonnell Douglas DC 9 33F · Bethel, AK · Accident · No injuries · Data collection · Final report · Dec 23, 2017 · N935CE · Substantial damage > failure of a cargo tie-down fastener, resulting in unsecured cargo striking the pressure bulkhead. - [NTSB WPR18WA054](https://openairdocs.org/ntsb/WPR18WA054.md): Bell UH1H · Bredasdorp, South Africa · Accident · Serious injuries · Foreign investigation · Dec 21, 2017 · ZS-HLI · Substantial damage > On December 21, 2017, about 1105 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLI, was substantially damaged when it impacted terrain shortly after liftoff from Bredasdorp fire station, Western Cape Province, South Africa. The helicopter was… - [NTSB WPR18LA049](https://openairdocs.org/ntsb/WPR18LA049.md): North American Navion · El Cajon, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2017 · N8884H · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. - [NTSB ERA18LA062](https://openairdocs.org/ntsb/ERA18LA062.md): Piper PA32 · Oakland Park, FL · Accident · No injuries · Limited investigation · Final report · Dec 13, 2017 · C6RVT · Substantial damage > The loss of engine power for reasons that could not be determined based on the available evidence. - [NTSB CEN18LA051](https://openairdocs.org/ntsb/CEN18LA051.md): Cessna 172C · Algona, IA · Accident · No injuries · Limited investigation · Final report · Dec 9, 2017 · N8856B · Substantial damage > The No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power. - [NTSB GAA18CA071](https://openairdocs.org/ntsb/GAA18CA071.md): Cessna 402 · Hyannis, MA · Accident · No injuries · Data collection · Final report · Dec 4, 2017 · N2748Y · Substantial damage > Encounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage. - [NTSB ANC18LA013](https://openairdocs.org/ntsb/ANC18LA013.md): Cessna 172R · Huntingdon, TN · Accident · No injuries · Limited investigation · Final report · Dec 2, 2017 · N9730F · Substantial damage > A total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation. - [NTSB ERA18CA035](https://openairdocs.org/ntsb/ERA18CA035.md): Driggers Quillan E Titan Tornado · Mechanicsville, VA · Accident · No injuries · Data collection · Final report · Nov 29, 2017 · N50F · Substantial damage > The pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff. - [NTSB DCA18WA028](https://openairdocs.org/ntsb/DCA18WA028.md): Boeing 737 · Latvia, Latvia · Incident · No injuries · Foreign investigation · Nov 23, 2017 · LNN-II · No damage > The Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 23, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO… - [NTSB ERA18LA033](https://openairdocs.org/ntsb/ERA18LA033.md): Cessna 421 · Presque Isle, ME · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 2017 · N421RX · Substantial damage > The in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing. - [NTSB WPR18LA034](https://openairdocs.org/ntsb/WPR18LA034.md): Cessna 172P · San Jose, CA · Accident · Serious injuries · Class 2 · Limited · Final report · Nov 19, 2017 · N52492 · Substantial damage > The pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the… - [NTSB ERA18LA027](https://openairdocs.org/ntsb/ERA18LA027.md): Homer Autogyro Cavalon · Oak Island, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N470CH · Substantial damage > A partial loss of engine power for reasons that could not be determined based on the available information. - [NTSB CEN18LA027](https://openairdocs.org/ntsb/CEN18LA027.md): Riggs Kenneth W T Bird II · St Mary's, KS · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2017 · N618ER · Substantial damage > The loss of engine power due to a propeller failure when the passenger’s hat exited the cockpit and impacted the three-bladed pusher propeller, separating one of the propeller blades. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=27 ## 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=26 --- 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.