# NTSB investigations: Enroute 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 66 of 718 · 35,883 cases ## Cases, newest first - [NTSB CEN16WA325](https://openairdocs.org/ntsb/CEN16WA325.md): Piper PA38 · Peterborough, Canada · Accident · 1 fatal · Foreign investigation · Aug 11, 2016 · C-FSYH · Substantial damage > On August 11, 2016, at 0520 coordinated universal time, a Piper PA-38-112, Canadian-registered C-FSYH, was damaged when it struck several metal poles during a forced landing near Peterborough, Ontario, Canada. Visual meteorological conditions prevailed at the… - [NTSB ERA16WA287](https://openairdocs.org/ntsb/ERA16WA287.md): Cessna 172 · Fredonia, Colombia · Accident · 2 fatal · Foreign investigation · Aug 9, 2016 · HK4822G · Substantial damage > On August 9, 2016, about 2156 universal coordinated time, a Cessna 172N, Colombian registration HK4822G, was substantially damaged when it impacted terrain near Fredonia, Antioquia, Colombia. The flight instructor and student pilot were fatally injured and… - [NTSB WPR16FA160](https://openairdocs.org/ntsb/WPR16FA160.md): AMS Flight Carat A · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2016 · N11DY · Substantial damage > Impact with terrain for reasons that could not be determined based on the available information. - [NTSB ERA16WA283](https://openairdocs.org/ntsb/ERA16WA283.md): Robinson R66 · Voronezhskaya oblast, Russia · Accident · Serious injuries · Foreign investigation · Aug 7, 2016 · RA-06347 · Substantial damage > On August 7, 2016, about 1030 coordinated universal time, a Robinson Helicopter R66, Russian registration RA-06347, was substantially damaged when it impacted electrical transmission lines near Borki village, Ramogn region, Voronezhskaya oblast, Russia. The… - [NTSB ENG16WA032](https://openairdocs.org/ntsb/ENG16WA032.md): Boeing 787 · Over the Pacific, A1 · Incident · No injuries · Foreign investigation · Aug 7, 2016 · VH-VKK · No damage > On August 7, 2016, a Jetstar Boeing 787, powered by 2 General Electric (GE) GEnx-1B64/P2 engines experienced a right engine (No. 2) low oil quantity indication while cruising over the Pacific. The engine was shutdown and the airplane was diverted to Guam… - [NTSB CEN16LA310](https://openairdocs.org/ntsb/CEN16LA310.md): Piper PA-11 · Indianola, IA · Accident · 2 fatal · Limited investigation · Final report · Aug 5, 2016 · N4707M · Destroyed > The pilot's inadequate preflight planning, which resulted in the airplane being operated above its maximum gross weight, degraded its climb performance, and led to an aerodynamic stall during the initial climb. - [NTSB CEN16LA306](https://openairdocs.org/ntsb/CEN16LA306.md): Cessna 150L · Russellville, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 2016 · N10770 · Substantial damage > A partial loss of engine power due to a fatigue crack of the No. 2 cylinder cooling fin, which resulted in failure of the No. 2 cylinder. - [NTSB ANC16CA051](https://openairdocs.org/ntsb/ANC16CA051.md): Robinson Helicopter R44 II · Homer, AK · Accident · No injuries · Data collection · Final report · Aug 4, 2016 · N719TF · Substantial damage > An in-flight collision with a bird resulting in damage to a tail rotor blade, which required replacement. - [NTSB WPR16FA158](https://openairdocs.org/ntsb/WPR16FA158.md): Piper PA 34-200T · Flagstaff, AZ · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2016 · N82806 · Destroyed > A departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence. - [NTSB DCA16CA209](https://openairdocs.org/ntsb/DCA16CA209.md): Airbus A319 115 · Grand Cayman Island (GCM), Cayman Islands · Accident · Serious injuries · Data collection · Final report · Aug 3, 2016 · N9010R · No damage > an inadvertent encounter with clear air turbulence. - [NTSB WPR16LA155](https://openairdocs.org/ntsb/WPR16LA155.md): Beech C 99 · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Aug 2, 2016 · N234AV · Substantial damage > An in-flight collision with power lines. - [NTSB CEN16LA309](https://openairdocs.org/ntsb/CEN16LA309.md): Cessna 172K · Neenah, WI · Accident · No injuries · Limited investigation · Final report · Aug 2, 2016 · N46459 · Substantial damage > A loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump. - [NTSB CEN16LA297](https://openairdocs.org/ntsb/CEN16LA297.md): Cessna 172F · Newark, IL · Accident · No injuries · Limited investigation · Final report · Jul 31, 2016 · N211FC · Substantial damage > The failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul. - [NTSB WPR16FA153](https://openairdocs.org/ntsb/WPR16FA153.md): Piper PA-31T · McKinleyville, CA · Accident · 4 fatal · Field investigation · Final report · Jul 29, 2016 · N661TC · Destroyed > An inflight fire in the floor area near the main bus tie circuit breaker panel that resulted from chafing between an electrical wire and a hydraulic line and/or airplane structure. - [NTSB DCA16CA205](https://openairdocs.org/ntsb/DCA16CA205.md): Airbus A321 231 · Bermuda, Bermuda · Accident · Serious injuries · Data collection · Final report · Jul 28, 2016 · N913JB · No damage > an inadvertent encounter with clear air turbulence. - [NTSB DCA16CA208](https://openairdocs.org/ntsb/DCA16CA208.md): Embraer ERJ 170 100 SE · Cleveland, OH · Accident · Serious injuries · Data collection · Final report · Jul 26, 2016 · N655RW · No damage > an inadvertent encounter with turbulence. - [NTSB WPR16LA150](https://openairdocs.org/ntsb/WPR16LA150.md): Beech 65 A90 · Byron, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2016 · N256TA · Substantial damage > The pilot’s failure to maintain an adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Also causal to the accident was the pilot’s failure to follow prescribed spin… - [NTSB WPR16FA148](https://openairdocs.org/ntsb/WPR16FA148.md): Air Tractor AT 502B · Zamora, CA · Accident · 1 fatal · Field investigation · Final report · Jul 23, 2016 · N502WC · 2 aircraft · Substantial damage > The failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which… - [NTSB ERA16WA275](https://openairdocs.org/ntsb/ERA16WA275.md): Cessna TU206 · San Martin, Colombia · Accident · Serious injuries · Foreign investigation · Jul 23, 2016 · HK2787 · Substantial damage > On July 23, 2016, at 1910 coordinated universal time, a Cessna TU206G, Columbian registration HK2787, was substantially damaged following an in-flight loss of engine power and subsequent forced landing in the Municipality of San Martin, Colombia. The pilot… - [NTSB GAA16CA387](https://openairdocs.org/ntsb/GAA16CA387.md): Cessna 182 · Hogansville, GA · Accident · Minor injuries · Data collection · Final report · Jul 22, 2016 · N9072X · Substantial damage > The pilot's failure to replace the left fuel cap following the preflight inspection, which resulted in fuel exhaustion, a loss of engine power, an emergency landing, and impact with terrain. - [NTSB CEN16LA287](https://openairdocs.org/ntsb/CEN16LA287.md): Stinson 108 · Dodge Center, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2016 · N8019K · Substantial damage > A partial loss of engine power due to carburetor ice. - [NTSB CEN16LA281](https://openairdocs.org/ntsb/CEN16LA281.md): Vans RV9 · Springfield, OH · Accident · 2 fatal · Limited investigation · Final report · Jul 22, 2016 · N807LK · Destroyed > The pilot’s decision to fly into known thunderstorms, which resulted in an in-flight breakup. - [NTSB CEN16FA276](https://openairdocs.org/ntsb/CEN16FA276.md): Piper PA 30 · Plainfield, IL · Accident · 1 fatal · Field investigation · Final report · Jul 21, 2016 · N7409Y · Destroyed > The pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load… - [NTSB CEN16LA275](https://openairdocs.org/ntsb/CEN16LA275.md): Meyers 200 · Huron, SD · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 20, 2016 · N229RS · Substantial damage > The partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined. - [NTSB CEN16LA273](https://openairdocs.org/ntsb/CEN16LA273.md): Brandt Sonex · Lodi, WI · Accident · No injuries · Limited investigation · Final report · Jul 19, 2016 · N393SX · Substantial damage > The separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing. - [NTSB GAA16CA383](https://openairdocs.org/ntsb/GAA16CA383.md): Aeronca 7AC · Lenoir, NC · Accident · No injuries · Data collection · Final report · Jul 18, 2016 · N84690 · Substantial damage > The pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to… - [NTSB WPR16LA146](https://openairdocs.org/ntsb/WPR16LA146.md): Cessna 172 · Emmett, ID · Accident · No injuries · Limited investigation · Final report · Jul 17, 2016 · N8184B · 2 aircraft · Substantial damage > The failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. - [NTSB ANC16WA045](https://openairdocs.org/ntsb/ANC16WA045.md): Dehavilland DHC-2 MK. I · Telegraph Creek, Canada · Accident · 1 fatal · Foreign investigation · Jul 16, 2016 · C-GWDW · Substantial damage > On July 15, 2016, about 0520 Coordinated Universal Time, a Canadian registered De Havilland DHC-2 Mk I airplane on floats, C-GWDW, owned and operated by Tsayta Aviation Ltd, impacted terrain approximately 15 nm east south east of Telegraph Creek, British… - [NTSB WPR16LA140](https://openairdocs.org/ntsb/WPR16LA140.md): Piper PA 23-150 · Kona, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2016 · N3180P · Destroyed > The total loss of power in both engines during cruise flight for reasons that could not be determined because the airplane was not recovered from the ocean. - [NTSB ERA16WA262](https://openairdocs.org/ntsb/ERA16WA262.md): Cessna TU206 · Charrasquera, Colombia · Accident · 5 fatal · Foreign investigation · Jul 11, 2016 · HK2940 · Destroyed > On July 11, 2016, about 1507 coordinated universal time, a Cessna TU206G airplane, Colombian registration HK2940, was destroyed when it impacted dense jungle near Charrasquera-San Jose del Guaviare, Colombia. The Colombian certificated pilot and four… - [NTSB CEN16LA264](https://openairdocs.org/ntsb/CEN16LA264.md): Alonso CH 701 · Dexter, MI · Accident · No injuries · Limited investigation · Final report · Jul 10, 2016 · N701ZG · Substantial damage > The total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. - [NTSB ENG16RA030](https://openairdocs.org/ntsb/ENG16RA030.md): Airbus A320 · Narita, Japan · Incident · No injuries · Foreign investigation · Jul 9, 2016 · JA04JJ · No damage > The Japan Transport Safety Board has notified the NTSB of an incident involving an Airbus A320, which occurred on July 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Japan Transport Safety Board investigation under the… - [NTSB ERA16LA250](https://openairdocs.org/ntsb/ERA16LA250.md): Piper PA32 · Windermere, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2016 · N1495J · Substantial damage > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation. - [NTSB ERA16LA272](https://openairdocs.org/ntsb/ERA16LA272.md): Harrity William V Glasair (SH2F) · Maynardville, TN · Accident · No injuries · Limited investigation · Final report · Jul 6, 2016 · N67WH · Substantial damage > The in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination. - [NTSB CEN16LA251](https://openairdocs.org/ntsb/CEN16LA251.md): Champion 7EC · Placedo, TX · Accident · No injuries · Limited investigation · Final report · Jul 6, 2016 · N9891B · Substantial damage > The inadequate annual inspection of the fuel system that failed to detect a deteriorated fuel line and a misrigged fuel selector, which resulted in fuel starvation and a subsequent total loss of engine power. Contributing to the accident was the mechanic’s… - [NTSB CEN16FA241](https://openairdocs.org/ntsb/CEN16FA241.md): Boeve Earl Seawind · Buena Vista, CO · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2016 · N46EB · Destroyed > The pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of… - [NTSB ERA16FA238](https://openairdocs.org/ntsb/ERA16FA238.md): Gerdts Mark E RV7A · Weston, FL · Accident · 1 fatal · Field investigation · Final report · Jul 3, 2016 · N1075F · Destroyed > The pilot's loss of airplane control for reasons that could not be determined based on the available evidence. - [NTSB ERA16WA256](https://openairdocs.org/ntsb/ERA16WA256.md): Cessna 182 · Belem, Brazil · Accident · 4 fatal · Foreign investigation · Jul 2, 2016 · PT-DJH · Destroyed > On July 2, 2016, about 1625 coordinated universal time (1325 local time), a Cessna 182E, Brazilian registration PT-DJH, operated by Aerotur Taxi Aereo LTDA, was destroyed after it impacted the ground shortly after takeoff from Julio Cesar Airport (SBJC),… - [NTSB CEN16LA254](https://openairdocs.org/ntsb/CEN16LA254.md): Waco YMF-F5C · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 2016 · N30AB · Substantial damage > A total loss of engine power for undetermined reasons. - [NTSB ERA16CA277](https://openairdocs.org/ntsb/ERA16CA277.md): Cessna 172 · Gray, GA · Accident · Minor injuries · Data collection · Final report · Jun 29, 2016 · N288GB · Substantial damage > The pilot's failure to properly manage the available fuel supply, which resulted in a total loss of engine power due to fuel starvation. - [NTSB WPR16LA132](https://openairdocs.org/ntsb/WPR16LA132.md): Robinson Helicopter R44 · El Centro, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 28, 2016 · N8325X · Substantial damage > A loss of main rotor rpm and airframe vibration for reasons that could not be determined based on the available information, which resulted in a forced landing to sloping terrain and the helicopter rolling over. - [NTSB ERA16WA240](https://openairdocs.org/ntsb/ERA16WA240.md): Bell Helicopter 407 · Jundiaí, Brazil · Accident · 5 fatal · Foreign investigation · Jun 26, 2016 · PR-CBB · Destroyed > On June 26, 2016, about 1110 coordinated universal time, a Bell 407, Brazilian registration PR-CBB, was destroyed during a collision with terrain and post-crash fire in Jundiaí, Brazil. The pilot and four passengers were fatally injured.The flight had… - [NTSB DCA16CA193](https://openairdocs.org/ntsb/DCA16CA193.md): Boeing 737 · New Orleans, LA · Accident · Serious injuries · Data collection · Final report · Jun 26, 2016 · N69806 · No damage > the improper placement of the coffee pot on the beverage cart and failure to use a safe-pour lid. - [NTSB CEN16RA233](https://openairdocs.org/ntsb/CEN16RA233.md): Bell 407 · Kassel, Hesse, Germany, Germany · Accident · No injuries · Foreign investigation · Jun 26, 2016 · D-HEAB · Substantial damage > On June 26, 2016, about 1420 hours universal coordinated time, a Bell model 407 helicopter, German registration D-HEAB, sustained substantial damage during a hard landing following a loss of engine power near Kassel, Hesse, Germany. The pilot was not injured.… - [NTSB ANC16LA035](https://openairdocs.org/ntsb/ANC16LA035.md): Universal Stinson 108 · Big Lake, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 2016 · N9063K · Substantial damage > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical malfunctions or failures that would have precluded normal operation. - [NTSB GAA16CA333](https://openairdocs.org/ntsb/GAA16CA333.md): Cessna 172 · Anthony, NM · Accident · Minor injuries · Data collection · Final report · Jun 25, 2016 · N46204 · Substantial damage > The pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water. - [NTSB ERA16WA245](https://openairdocs.org/ntsb/ERA16WA245.md): Lake LA4 · Región de Los Lagos, Chile · Accident · 2 fatal · Foreign investigation · Jun 25, 2016 · CC-POK · Substantial damage > On June 25, 2016, about 2045 coordinated universal time (1645 local time), a Lake L-4-200, amphibious airplane, Chilean registration CC-POK, was substantially damaged when it collided with a powerline during a local flight over the Región de Los Lagos, Chile.… - [NTSB WPR16FA130](https://openairdocs.org/ntsb/WPR16FA130.md): Robinson Helicopter R66 · Wikieup, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 23, 2016 · N117TW · Destroyed > An encounter with turbulence due to updrafts and/or dust devils that resulted in mast bumping and an in-flight break-up. - [NTSB GAA16CA330](https://openairdocs.org/ntsb/GAA16CA330.md): Cessna 152 · Clearlake Oaks, CA · Accident · Minor injuries · Data collection · Final report · Jun 22, 2016 · N67889 · Substantial damage > The pilot's deviation from his original flight plan, which resulted in becoming lost in mountainous terrain at night, fuel exhaustion, loss of engine power, and a collision with power lines during a forced landing. - [NTSB CEN16LA229](https://openairdocs.org/ntsb/CEN16LA229.md): Cessna 182P · Humansville, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 2016 · N9434M · Substantial damage > A partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=67 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=66 --- 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.