# 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 67 of 718 · 35,883 cases

## Cases, newest first

- [NTSB ERA16WA249](https://openairdocs.org/ntsb/ERA16WA249.md): Beech B200 · Lima, Peru · Incident · No injuries · Foreign investigation · Jun 21, 2016 · OB-2104-P · Minor damage
  > On June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…
- [NTSB DCA16WA194](https://openairdocs.org/ntsb/DCA16WA194.md): Boeing 747 · Los Angeles, CA · Incident · No injuries · Foreign investigation · Jun 21, 2016 · VH-OJS · Minor damage
  > Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on June 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…
- [NTSB ERA16LA226](https://openairdocs.org/ntsb/ERA16LA226.md): Rockwell International 112A · Dayton, TN · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 2016 · N1299J · Substantial damage
  > A total loss of engine power due to the failure of the engine-driven fuel pump.
- [NTSB CEN16LA227](https://openairdocs.org/ntsb/CEN16LA227.md): Piper PA 28R-200 · Bowie, TX · Accident · No injuries · Limited investigation · Final report · Jun 20, 2016 · N9336N · Substantial damage
  > The inadequate maintenance and inspection of the throttle control arm, which resulted in its in-flight separation and the subsequent loss of engine power.
- [NTSB WPR16FA126](https://openairdocs.org/ntsb/WPR16FA126.md): Piper PA 23-150 · Hayward, CA · Accident · 1 fatal · Field investigation · Final report · Jun 19, 2016 · N1270P · Destroyed
  > The failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…
- [NTSB ANC16LA034](https://openairdocs.org/ntsb/ANC16LA034.md): De Havilland DHC3 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 2016 · N104BM · Substantial damage
  > An in-flight collision with a bald eagle, which resulted in substantial damage to the left wing.
- [NTSB WPR16LA128](https://openairdocs.org/ntsb/WPR16LA128.md): Beech C23 · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2016 · N9246S · Substantial damage
  > The pilots' improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA16LA217](https://openairdocs.org/ntsb/ERA16LA217.md): Beech P35 · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2016 · N112MB · Substantial damage
  > A total loss of engine power due to inadequate maintenance of the oil filter adapter, which resulted in an oil leak and subsequent oil starvation to the engine.
- [NTSB ERA16CA246](https://openairdocs.org/ntsb/ERA16CA246.md): Mooney M20 · Clifton, TN · Accident · No injuries · Data collection · Final report · Jun 18, 2016 · N3877H · Substantial damage
  > The flight's encounter with unforecast extreme turbulence, which resulted in a loss of airplane control and structural damage.
- [NTSB CEN16LA223](https://openairdocs.org/ntsb/CEN16LA223.md): Cirrus Design SR22 · Colorado Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2016 · N678Z · Substantial damage
  > A hard landing on rough terrain due to a faulty deployment of the airplane’s airframe parachute system following a partial loss of engine power for reasons that could not be determined, because postaccident examination revealed no malfunctions or anomalies…
- [NTSB GAA16LA325](https://openairdocs.org/ntsb/GAA16LA325.md): MD Helicopter 369E · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Jun 17, 2016 · N155NR · Substantial damage
  > The failure of the helicopter’s windscreen for reasons that could not be determined based on the available information, which resulted in substantial damage to the main rotor blades and horizontal stabilizer.
- [NTSB ANC16LA032](https://openairdocs.org/ntsb/ANC16LA032.md): Cessna 207 · Goodnews Bay, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 2016 · N91170 · Substantial damage
  > The pilot’s failure to select the correct route through the mountains as a result of geographic disorientation, and his subsequent visual flight into instrument meteorological conditions, which resulted in collision with terrain.
- [NTSB DCA16WA185](https://openairdocs.org/ntsb/DCA16WA185.md): Embraer ERJ190 · Madrid, Spain · Accident · Serious injuries · Foreign investigation · Jun 15, 2016 · EC-LKX · No damage
  > The Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) Spain has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on June 15, 2016. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB CEN16FA224](https://openairdocs.org/ntsb/CEN16FA224.md): Cessna 320E · Creede, CO · Accident · 3 fatal · Field investigation · Final report · Jun 15, 2016 · N777GY · Destroyed
  > The pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…
- [NTSB WPR16LA125](https://openairdocs.org/ntsb/WPR16LA125.md): Bell 206 · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Jun 14, 2016 · N1076Y · Substantial damage
  > The pilot’s improper preflight weather planning, fuel planning, and fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the severity of the accident was the pilot's initiation of the landing flare at a high altitude,…
- [NTSB CEN16LA249](https://openairdocs.org/ntsb/CEN16LA249.md): Aero Commander 100 180 · Port Lavaca, TX · Accident · No injuries · Limited investigation · Final report · Jun 14, 2016 · N3718X · Substantial damage
  > Loss of engine power due to failure of a connecting rod.
- [NTSB GAA16CA317](https://openairdocs.org/ntsb/GAA16CA317.md): Ryan Navion · McMinnville, OR · Accident · Minor injuries · Data collection · Final report · Jun 13, 2016 · N4171K · Substantial damage
  > The pilot's failure to replace the oil filler cap following the preflight inspection, which resulted in a loss of engine oil and engine power, an emergency landing, and impact with terrain.
- [NTSB DCA16CA202](https://openairdocs.org/ntsb/DCA16CA202.md): Airbus A321 231 · Jamaica, NY · Accident · Serious injuries · Data collection · Final report · Jun 12, 2016 · N104NN · No damage
  > an encounter with convective turbulence that resulted in a flight attendant injury.
- [NTSB CEN16LA218](https://openairdocs.org/ntsb/CEN16LA218.md): Aeronca 7AC · East St. Louis, IL · Accident · No injuries · Limited investigation · Final report · Jun 11, 2016 · N82694 · Substantial damage
  > A total loss of engine power due to fracture of the piston pin, which led to fatigue cracking and eventual fracture of the adjacent connecting rod.
- [NTSB CEN16LA217](https://openairdocs.org/ntsb/CEN16LA217.md): Bellanca 17 30 · Westport, OK · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 2016 · N7346V · Substantial damage
  > A total loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.
- [NTSB GAA16CA302](https://openairdocs.org/ntsb/GAA16CA302.md): Piper PA 28 · Rowesville, SC · Accident · No injuries · Data collection · Final report · Jun 9, 2016 · N7355W · Substantial damage
  > The fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.
- [NTSB ENG16WA038](https://openairdocs.org/ntsb/ENG16WA038.md): Boeing 737 · Toulouse, France, France · Incident · No injuries · Foreign investigation · Jun 8, 2016 · EI-CSG
  > The Accident Investigation Bureau of Mongolia (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on June 8, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…
- [NTSB CEN16FA210](https://openairdocs.org/ntsb/CEN16FA210.md): Cessna 175 · Pine Bluff, AR · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2016 · N6649E · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because a test run of the engine did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation. Contributing to the accident were the…
- [NTSB ANC16LA029](https://openairdocs.org/ntsb/ANC16LA029.md): Air Tractor AT 802 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Jun 6, 2016 · N802CE · Substantial damage
  > The pilot's inadequate preflight fuel planning, his reliance on the fuel flow indicator without verifying the initial fuel level input, and his improper decision to continue the flight with the low fuel light illuminated, which resulted in fuel exhaustion,…
- [NTSB GAA16CA277](https://openairdocs.org/ntsb/GAA16CA277.md): Piper PA 24 · Loda, IL · Accident · Minor injuries · Data collection · Final report · Jun 4, 2016 · N5376P · Substantial damage
  > The pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…
- [NTSB DCA16WA188](https://openairdocs.org/ntsb/DCA16WA188.md): Boeing 737 · Sofia, Bulgaria · Incident · No injuries · Foreign investigation · Jun 4, 2016 · TC-JGE · No damage
  > The Aircraft Accident Investigation Unit (AAIU) of Bulgaria has notified the NTSB of an incident involving a Boeing 737 that occurred on June 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…
- [NTSB CEN16LA207](https://openairdocs.org/ntsb/CEN16LA207.md): Smith Capella FW2R · Alamo, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 2016 · N418DS · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted in a forced landing and a collision with a tree.
- [NTSB CEN16LA203](https://openairdocs.org/ntsb/CEN16LA203.md): Cessna 150 · Penwell, TX · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2016 · N5679G · Destroyed
  > The pilot’s intentional flight into a silo.
- [NTSB GAA16CA267](https://openairdocs.org/ntsb/GAA16CA267.md): Cessna 150 · Albuquerque, NM · Accident · Minor injuries · Data collection · Final report · May 27, 2016 · N60252 · Substantial damage
  > The student pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, loss of engine power, and impact with terrain.
- [NTSB ERA16LA195](https://openairdocs.org/ntsb/ERA16LA195.md): Republic P 47D · New York, NY · Accident · 1 fatal · Limited investigation · Final report · May 27, 2016 · N1345B · Substantial damage
  > A catastrophic engine failure of undetermined origin, which resulted in a total loss of engine power and subsequent ditching. Contributing to the accident was the pilot's failure to jettison the canopy before ditching, which resulted in his inability to…
- [NTSB GAA16CA261](https://openairdocs.org/ntsb/GAA16CA261.md): Rolladen-Schneider OHG LS3 · Blairstown, NJ · Accident · Serious injuries · Data collection · Final report · May 25, 2016 · N63761 · Substantial damage
  > The pilot's failure to maintain clearance from trees on final.
- [NTSB DCA16WA166](https://openairdocs.org/ntsb/DCA16WA166.md): Embraer ERJ190 · Boston, MA · Incident · No injuries · Foreign investigation · May 25, 2016 · C-FHOS · Minor damage
  > Transport Safety Board (TSB) of Canada has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on May 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…
- [NTSB GAA16CA259](https://openairdocs.org/ntsb/GAA16CA259.md): Cessna 182 · Reno, NV · Accident · No injuries · Data collection · Final report · May 24, 2016 · N4793D · Substantial damage
  > The pilot's inadequate fuel planning, resulting in fuel exhaustion and substantial damage to the firewall during the forced landing.
- [NTSB CEN16LA197](https://openairdocs.org/ntsb/CEN16LA197.md): Cessna 501 · Texarkana, AR · Accident · Minor injuries · Limited investigation · Final report · May 24, 2016 · N804ST · Substantial damage
  > The pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…
- [NTSB WPR16LA119](https://openairdocs.org/ntsb/WPR16LA119.md): Beech C23 · Waianae, HI · Accident · Minor injuries · Limited investigation · Final report · May 23, 2016 · N6697Y · Substantial damage
  > The total loss of engine power during cruise flight due to carburetor icing. Contributing to the accident was the pilot’s delay in applying carburetor heat during flight while operating in an area conducive to carburetor icing.
- [NTSB ERA16LA193](https://openairdocs.org/ntsb/ERA16LA193.md): Cessna 152 · Melrose, FL · Accident · Minor injuries · Limited investigation · Final report · May 23, 2016 · N952SA · Substantial damage
  > A total loss of engine power due to fuel exhaustion.
- [NTSB WPR16LA114](https://openairdocs.org/ntsb/WPR16LA114.md): Michael Burton Calidus · Fruitland, UT · Accident · Serious injuries · Limited investigation · Final report · May 20, 2016 · N50NE · Substantial damage
  > The pilot's improper judgment in conducting a flight in a gyroplane over mountainous terrain near its demonstrated maximum operating altitude and his subsequent failure to maintain adequate clearance with terrain during cruise flight in turbulent weather…
- [NTSB DCA16RA156](https://openairdocs.org/ntsb/DCA16RA156.md): Airbus A320 · Cairo, Egypt · Accident · 66 fatal · Foreign investigation · May 19, 2016 · SU-GCC · Destroyed
  > The Egyptian Ministry of Civil Aviation (EMCA) has notified the NTSB of an accident involving an AIRBUS A320, equipped with IAE V2500 engines, that occurred on May 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the EMCA's…
- [NTSB CEN16LA196](https://openairdocs.org/ntsb/CEN16LA196.md): Waco Classic YMF · West Des Moines, IA · Accident · Serious injuries · Limited investigation · Final report · May 19, 2016 · N56ED · Substantial damage
  > The pilot's mismanagement of the airplane's fuel supply, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR16LA113](https://openairdocs.org/ntsb/WPR16LA113.md): Beech C23 · Delano, CA · Accident · Minor injuries · Limited investigation · Final report · May 14, 2016 · N3724Y · Substantial damage
  > The student pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR16LA107](https://openairdocs.org/ntsb/WPR16LA107.md): Cessna 208B · Acampo, CA · Accident · Minor injuries · Limited investigation · Final report · May 12, 2016 · N1114A · Substantial damage
  > A total loss of engine power due to a fatigue fracture of the fuel pressure line that connected the fuel control unit and the fuel flow transducer due to vibration as the result of a fatigue fracture of an associated support clamp. Contributing to the…
- [NTSB CEN16WA351](https://openairdocs.org/ntsb/CEN16WA351.md): Robinson R22 · Aube, France · Accident · 1 fatal · Foreign investigation · May 9, 2016 · G-SPEE · Destroyed
- [NTSB WPR16FA103](https://openairdocs.org/ntsb/WPR16FA103.md): Piper PA28 · Pomona, CA · Accident · Serious injuries · Field investigation · Final report · May 8, 2016 · N5046W · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN16WA402](https://openairdocs.org/ntsb/CEN16WA402.md): Bell 206 · Mexico City, Mexico · Accident · Serious injuries · Foreign investigation · May 8, 2016 · N531RR · Substantial damage
- [NTSB WPR16FA102](https://openairdocs.org/ntsb/WPR16FA102.md): Beech G35 · Surprise, AZ · Accident · 1 fatal · Field investigation · Final report · May 7, 2016 · N4401D · Substantial damage
  > The mechanic's failure to properly secure the bolt connecting the throttle cable to the carburetor during the installation of the carburetor, which resulted in a loss of engine power.
- [NTSB ANC16WA028](https://openairdocs.org/ntsb/ANC16WA028.md): Vans RV4 · Eckville, Canada · Accident · 1 fatal · Foreign investigation · May 7, 2016 · C-GGYT · Substantial damage
  > On May 07, 2016, about 2000 Coordinated Universal Time, an amateur-built Van's Thiessen RV-4 airplane, C-GGYT, impacted terrain near Eckville, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…
- [NTSB ANC16FA023](https://openairdocs.org/ntsb/ANC16FA023.md): Airbus AS350 · Skagway, AK · Accident · 1 fatal · Field investigation · Final report · May 7, 2016 · N94TH · Substantial damage
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident were the…
- [NTSB WPR16LA101](https://openairdocs.org/ntsb/WPR16LA101.md): Antonov AN2 · San Bernardino, CA · Accident · No injuries · Limited investigation · Final report · May 6, 2016 · N2AN · Substantial damage
  > The mechanic’s failure to inspect the fine fuel filter gascolator as required during the most recent inspection, which resulted in a total loss of engine power due to fuel contamination.
- [NTSB ERA16WA175](https://openairdocs.org/ntsb/ERA16WA175.md): Robinson R44 · Avacha`, Russia · Accident · 3 fatal · Foreign investigation · May 3, 2016 · RA-2118G · Destroyed
  > On May 3, 2016, about 0347 UTC, a Robinson Helicopter R44, Russian registered RA-2118G was destroyed when it impacted mountainous terrain near Kamchatka, Russia, while on a flight from Khalaktyrka, Russia to Karymshina, Russia. The pilot and two passengers…
- [NTSB ERA16FA176](https://openairdocs.org/ntsb/ERA16FA176.md): Beech V35 · Syosset, NY · Accident · 3 fatal · Field investigation · Final report · May 3, 2016 · N440H · Destroyed
  > The pilot's loss of airplane control while operating in instrument meteorological conditions with only a partial instrument panel due to a failure of the airplane's vacuum pump. Contributing to the accident were the pilot's spatial disorientation and the…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=68

## 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=67

---
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.