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

## Cases, newest first

- [NTSB ERA17LA098](https://openairdocs.org/ntsb/ERA17LA098.md): Cessna P210 · Pottsville, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2017 · N4796P · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA089](https://openairdocs.org/ntsb/CEN17LA089.md): Ercoupe 415-C · Butterfield, TX · Accident · No injuries · Limited investigation · Final report · Jan 28, 2017 · N94694 · Substantial damage
  > A malfunction of the fuel transfer system for reasons that could not be determined based on the available information, a stuck float in the header tank sight gauge that resulted in an inaccurate fuel quantity indication, and the pilot’s inadequate monitoring…
- [NTSB CEN17IA094](https://openairdocs.org/ntsb/CEN17IA094.md): Eurocopter Deutschland MBB BK 117 C-2 · Sioux Falls, SD · Incident · No injuries · Class 2 · Incident · Final report · Jan 27, 2017 · N911MK · Minor damage
  > The gas generator rear bearing oil scavenge line blocked with coke, which resulted in a failed rear bearing due to an excess of oil lubrication. Contributing to the incident was the operator not completely performing the maintenance items and not utilizing an…
- [NTSB WPR17LA058](https://openairdocs.org/ntsb/WPR17LA058.md): Beech E17L · Discovery Bay, WA · Accident · No injuries · Limited investigation · Final report · Jan 24, 2017 · N41663 · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB GAA17CA121](https://openairdocs.org/ntsb/GAA17CA121.md): Cessna 150 · Denton, TX · Accident · No injuries · Data collection · Final report · Jan 23, 2017 · N3545L · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ENG17IA008](https://openairdocs.org/ntsb/ENG17IA008.md): Bombardier CL 600 2B19 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Jan 23, 2017 · N8986B · No damage
  > A Bombardier CRJ200 No. 2 engine failure due to the separation of a fan blade airfoil at a low cycle fatigue crack that originated at the forward fan blade pin hole attachment. The separated fan blade had previously undergone a hot form repair and both…
- [NTSB CEN17LA081](https://openairdocs.org/ntsb/CEN17LA081.md): Bellanca 17 30 · Kidron, OH · Accident · No injuries · Limited investigation · Final report · Jan 21, 2017 · N39819 · Substantial damage
  > Maintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.
- [NTSB ANC17TA015](https://openairdocs.org/ntsb/ANC17TA015.md): Piper PA-32 · Pilot Point, AK · Accident · Serious injuries · Final report · Jan 17, 2017 · N4261T · Substantial damage
  > The pilot's continued flight into known icing conditions, which resulted in structural icing and a forced landing on icy, snow-covered terrain.
- [NTSB DCA17WA139](https://openairdocs.org/ntsb/DCA17WA139.md): Boeing 737 · Manchester, United Kingdom · Accident · No injuries · Foreign investigation · Jan 14, 2017 · EI-EBW · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-800, which occurred on January 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…
- [NTSB WPR17FA052](https://openairdocs.org/ntsb/WPR17FA052.md): Piper PA 28-236 · Port Orford, OR · Accident · 1 fatal · Field investigation · Final report · Jan 13, 2017 · N81839 · Substantial damage
  > The pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.
- [NTSB WPR17FA055](https://openairdocs.org/ntsb/WPR17FA055.md): Mooney M20J · Lake Hughes, CA · Accident · 1 fatal · Field investigation · Final report · Jan 12, 2017 · N6201N · Substantial damage
  > The pilot's controlled flight into mountainous terrain while attempting to operate under visual flight rules in instrument meteorological conditions (IMC).
- [NTSB CEN17LA076](https://openairdocs.org/ntsb/CEN17LA076.md): Cessna 182T · Green Bay, WI · Accident · No injuries · Limited investigation · Final report · Jan 11, 2017 · C-GTBI · Substantial damage
  > The airplane’s encounter with unforecast icing conditions, which led to structural icing that obscured the pilot’s vision, an aerodynamic stall, and a subsequent hard landing.
- [NTSB DCA17WA094](https://openairdocs.org/ntsb/DCA17WA094.md): Canadair CL604 · Arabian Sea, A1 · Accident · No injuries · Foreign investigation · Jan 7, 2017 · D-AMSC
  > The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Canadair CL-604, which occurred on January 7, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of…
- [NTSB CEN17LA073](https://openairdocs.org/ntsb/CEN17LA073.md): Cirrus SR22 · Meeker, CO · Accident · No injuries · Limited investigation · Final report · Jan 7, 2017 · N5VK · Substantial damage
  > A partial loss of engine power due to fuel contamination from an undetermined source.
- [NTSB CEN17FA071](https://openairdocs.org/ntsb/CEN17FA071.md): Columbia Aircraft Mfg LC41 550FG · Gurdon, AR · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2017 · N972JK · Destroyed
  > The loss of control in flight for reasons that could not be determined because of the severe impact and postcrash fire damage to the airplane and the lack of information about the airplane emergency that the pilot was experiencing.
- [NTSB WPR17LA046](https://openairdocs.org/ntsb/WPR17LA046.md): Softex Invest V-24L · Paradise, MT · Accident · Serious injuries · Limited investigation · Final report · Jan 3, 2017 · N710XP · Substantial damage
  > A partial loss of power during cruise flight for reasons that could not be determined because postaccident examination of the engines did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR17FA045](https://openairdocs.org/ntsb/WPR17FA045.md): Cessna T210K · Payson, AZ · Accident · 4 fatal · Field investigation · Final report · Jan 2, 2017 · N272EF · Destroyed
  > The non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB CEN17LA079](https://openairdocs.org/ntsb/CEN17LA079.md): Quicksilver GT-400 R503 · New Braunfels, TX · Accident · No injuries · Limited investigation · Final report · Jan 1, 2017 · N415HC · Substantial damage
  > The partial loss of engine power due to a loose spark plug. Contributing to the accident was the pilot's improper preflight inspection of the airplane.
- [NTSB CEN17LA066](https://openairdocs.org/ntsb/CEN17LA066.md): Gosselin Charles Glastar · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2016 · N120CG · Substantial damage
  > Partial failure of the electric system due to a battery short, which resulted in a total loss of engine power.
- [NTSB CEN17FA064](https://openairdocs.org/ntsb/CEN17FA064.md): Piper PA 28R-200 · Vienna, IL · Accident · 4 fatal · Field investigation · Final report · Dec 31, 2016 · N2806R · Destroyed
  > The non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.
- [NTSB WPR17FA044](https://openairdocs.org/ntsb/WPR17FA044.md): Cessna 182 · Dabob, WA · Accident · 4 fatal · Field investigation · Final report · Dec 30, 2016 · N52388 · Substantial damage
  > The non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…
- [NTSB WPR17LA050](https://openairdocs.org/ntsb/WPR17LA050.md): Diamond Aircraft Ind DA 40 NG · Kingman, AZ · Accident · No injuries · Class 3 · Limited · Final report · Dec 29, 2016 · N605SJ · Substantial damage
  > The loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…
- [NTSB DCA17WA086](https://openairdocs.org/ntsb/DCA17WA086.md): Boeing 737 · Bucharest, Romania · Incident · No injuries · Foreign investigation · Dec 29, 2016 · YR-BAR · No damage
  > The Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a Boeing 737, which occurred on December 29, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…
- [NTSB ERA17FA073](https://openairdocs.org/ntsb/ERA17FA073.md): Cessna 182 · Gatlinburg, TN · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2016 · N1839X · Destroyed
  > The non-instrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's established anti-authority attitude.
- [NTSB GAA17CA098](https://openairdocs.org/ntsb/GAA17CA098.md): Cessna 182 · Apple Valley, CA · Accident · Serious injuries · Data collection · Final report · Dec 19, 2016 · N5954B · Substantial damage
  > The pilot’s mismanagement of the available fuel, which resulted in a loss of engine power and a subsequent hard, off-airport landing and nose-over.
- [NTSB ERA17LA071](https://openairdocs.org/ntsb/ERA17LA071.md): Cessna 150 · Palm Bay, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 2016 · N150EC · Substantial damage
  > Unknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.
- [NTSB CEN17LA058](https://openairdocs.org/ntsb/CEN17LA058.md): Bellanca 17 30A · Blaine, MN · Accident · No injuries · Limited investigation · Final report · Dec 18, 2016 · N4204B · Substantial damage
  > A total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.
- [NTSB OPS17IA010](https://openairdocs.org/ntsb/OPS17IA010.md): Boeing 777 · Mt. Wilson, CA · Incident · No injuries · Incident investigation · Final report · Dec 16, 2016 · B-16726 · No damage
  > The incident was caused by the air traffic controller assigning the pilots a left turn instead of the required right turn after departure which placed the aircraft in an unsafe proximity with terrain and obstructions. Contributing to the incident was the air…
- [NTSB ANC17FA012](https://openairdocs.org/ntsb/ANC17FA012.md): Piper PA 11 · Aniak, AK · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2016 · N5028H · Substantial damage
  > The pilot's intentional flight of the airplane into terrain in an act of suicide.
- [NTSB DCA17CA042](https://openairdocs.org/ntsb/DCA17CA042.md): Boeing 737 824 · Denver, CO · Accident · Serious injuries · Data collection · Final report · Dec 14, 2016 · N24202 · No damage
  > An inadvertent encounter with mountain wave turbulence.
- [NTSB WPR17LA036](https://openairdocs.org/ntsb/WPR17LA036.md): Cessna T210M · Mecca, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 12, 2016 · N761SZ · Substantial damage
  > The total loss of engine power due to fuel starvation during approach, which necessitated a gear-up landing on unsuitable terrain.
- [NTSB ERA17LA069](https://openairdocs.org/ntsb/ERA17LA069.md): Beech A36 · Shoreham, NY · Accident · No injuries · Limited investigation · Final report · Dec 11, 2016 · N69286 · Substantial damage
  > A fatigue crack of the crankshaft at the No. 4 main bearing journal.
- [NTSB CEN17WA222](https://openairdocs.org/ntsb/CEN17WA222.md): Piper PA38 · Ingenio La Cabana, El Salvador · Accident · 2 fatal · Foreign investigation · Dec 11, 2016 · YS-332-PE · Substantial damage
  > On December 11, 2016, a Piper PA-38, YS-332-PE, crashed near Ingenio La Cabana, El Salvador, a 0715 local time and was destroyed. The flight instructor and student pilot were fatally injured. The accident investigation is under the jurisdiction and control of…
- [NTSB CEN17FA053](https://openairdocs.org/ntsb/CEN17FA053.md): Aircraft Mfg & Design CH601XL Slsa · Marengo, IL · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2016 · N4218 · Destroyed
  > A loss of control in flight for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were identified during the investigation.
- [NTSB ENG17RA010](https://openairdocs.org/ntsb/ENG17RA010.md): ATR ATR42 · Havelian, Pakistan · Accident · No injuries · Foreign investigation · Dec 7, 2016 · AP-BHO · Destroyed
  > Pakistan has notified the NTSB of an accident involving an ATR 42-500 that occurred on December 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Pakistan Safety Investigation Board investigation under the provisions of ICAO Annex…
- [NTSB ANC17FA010](https://openairdocs.org/ntsb/ANC17FA010.md): Piper PA 28-180 · Port Alsworth, AK · Accident · 4 fatal · Field investigation · Final report · Dec 7, 2016 · N8648N · Substantial damage
  > Undetermined due to a lack of physical evidence.
- [NTSB WPR17LA031](https://openairdocs.org/ntsb/WPR17LA031.md): Piper PA 31T · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Dec 5, 2016 · N909PW · Substantial damage
  > Failure of the left windshield due to moisture ingression into the windshield laminate, which deteriorated the strength of the windshield.
- [NTSB CEN17LA136](https://openairdocs.org/ntsb/CEN17LA136.md): Cessna 550 · Port Aransas, TX · Accident · No injuries · Limited investigation · Final report · Dec 5, 2016 · N75WL · Substantial damage
  > An in-flight collision with multiple birds, which resulted in separation of the right engine's fan rotor and subsequent total loss of power of the right engine.
- [NTSB DCA17WA035](https://openairdocs.org/ntsb/DCA17WA035.md): Boeing 777 · Lajes Terceira Island, Portugal · Accident · Serious injuries · Foreign investigation · Dec 4, 2016 · A7-BAN · No damage
  > The government of Portugal has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on December 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the…
- [NTSB CEN17WA049](https://openairdocs.org/ntsb/CEN17WA049.md): Beech E 90 · Toledo, Spain · Accident · 4 fatal · Foreign investigation · Dec 4, 2016 · N79CT · Destroyed
- [NTSB CEN17LA048](https://openairdocs.org/ntsb/CEN17LA048.md): Arion Lightning LS-1 · Goshen, IN · Accident · No injuries · Limited investigation · Final report · Dec 3, 2016 · N218D · Substantial damage
  > A partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.
- [NTSB GAA17CA088](https://openairdocs.org/ntsb/GAA17CA088.md): Diamond Aircraft Ind DA-20 · Payson, UT · Accident · No injuries · Data collection · Final report · Dec 2, 2016 · N992CT · Substantial damage
  > The student pilot's improper in-flight fuel planning, which resulted in fuel exhaustion.
- [NTSB DCA17WA219](https://openairdocs.org/ntsb/DCA17WA219.md): Boeing 737 · Nagpur, India · Incident · No injuries · Foreign investigation · Dec 2, 2016 · VT-JFP · 2 aircraft · No damage
  > The Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a ATR-72 airplane that occurred on December 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…
- [NTSB CEN17FA046](https://openairdocs.org/ntsb/CEN17FA046.md): Gordon Pegazair P 100 · Mt Vernon, IN · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2016 · N129LZ · Destroyed
  > The pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.
- [NTSB ENG17IA006](https://openairdocs.org/ntsb/ENG17IA006.md): Bombardier CL 600 2C10 · Kansas, IL · Incident · No injuries · Incident investigation · Final report · Nov 29, 2016 · N367CA · No damage
  > The probable cause of the uncontained No. 1 (left) engine failure was a separated high pressure turbine 2nd stage blade that failed due to a fatigue crack that originated below the blade platform from an area of corrosion.
- [NTSB ANC17LA008](https://openairdocs.org/ntsb/ANC17LA008.md): Airborne Extreme SQ-12 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Nov 25, 2016 · N37PX · Substantial damage
  > The fuel injector manufacturer's inappropriate guidance to use a 5-ampere circuit breaker in place of the required 10-ampere circuit breaker on the fuel injector circuit, which resulted in the circuit breaker opening, a loss of electrical power to the…
- [NTSB WPR17LA038](https://openairdocs.org/ntsb/WPR17LA038.md): Cessna 182A · Safford, AZ · Accident · No injuries · Limited investigation · Final report · Nov 24, 2016 · N6077B · Substantial damage
  > The total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.
- [NTSB ERA17WA055](https://openairdocs.org/ntsb/ERA17WA055.md): Ayres S2R · Valparaiso, Chile · Accident · 1 fatal · Foreign investigation · Nov 23, 2016 · N5532G · Substantial damage
  > On November 23, 2016, about 1410 universal coordinated time, an Ayres S2-R, United States registration N5532G, was destroyed when it impacted mountainous terrain near Paso Internacional Los Libertadores, Chile. The pilot was fatally injured. The flight…
- [NTSB WPR17FA025](https://openairdocs.org/ntsb/WPR17FA025.md): Piper PA 28-181 · Upland, CA · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2016 · N6912C · Substantial damage
  > The pilot's failure to maintain clearance from rising terrain in dark night conditions, which resulted in controlled flight into terrain.
- [NTSB DCA17CA096](https://openairdocs.org/ntsb/DCA17CA096.md): Boeing 717 200 · Hopewell, VA · Accident · Serious injuries · Data collection · Final report · Nov 21, 2016 · N930AT · No damage
  > the flight attendant's inadvertent bump into a retractable galley tray.

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

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

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