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

## Cases, newest first

- [NTSB ERA19FA124](https://openairdocs.org/ntsb/ERA19FA124.md): Piper PA31 · Madeira, OH · Accident · 1 fatal · Field investigation · Final report · Mar 12, 2019 · N400JM · Substantial damage
  > Fuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.
- [NTSB CEN19LA098](https://openairdocs.org/ntsb/CEN19LA098.md): Piper PA32R · Waterloo, IL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 12, 2019 · N750R · Substantial damage
  > The loss of engine power due to a connecting rod failure for reasons that could not be determined due to secondary mechanical damage, which resulted in a subsequent forced landing.
- [NTSB CEN19FA095](https://openairdocs.org/ntsb/CEN19FA095.md): Bell 407 · Galliano, LA · Accident · 2 fatal · Class 2 · Field · Final report · Mar 10, 2019 · N577AL · Destroyed
  > The pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.
- [NTSB GAA19CA166](https://openairdocs.org/ntsb/GAA19CA166.md): Cessna 177RG · Land O' Lakes, WI · Accident · Minor injuries · Data collection · Final report · Mar 9, 2019 · N52047 · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB ERA19WA121](https://openairdocs.org/ntsb/ERA19WA121.md): Douglas DC3 · Vereda La Bendicion, Colombia · Accident · 14 fatal · Foreign investigation · Mar 9, 2019 · HK2494 · Destroyed
  > The government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…
- [NTSB CEN19FA094](https://openairdocs.org/ntsb/CEN19FA094.md): Cessna T337 · Longview, TX · Accident · 4 fatal · Field investigation · Final report · Mar 9, 2019 · N922EJ · Destroyed
  > The noninstrument-rated pilot's improper decision to continue flight into convective weather conditions, which resulted in the airplane exceeding its maximum maneuvering speed and the subsequent in-flight breakup. Contributing to the accident was the pilot's…
- [NTSB GAA19CA160](https://openairdocs.org/ntsb/GAA19CA160.md): Piper PA18 · Rushville, NE · Accident · No injuries · Data collection · Final report · Mar 8, 2019 · N8566D · Substantial damage
  > The partial loss of engine power due to the accumulation of carburetor ice, which resulted in a forced landing on rough terrain.
- [NTSB ENG19WA020](https://openairdocs.org/ntsb/ENG19WA020.md): Airbus A320 · Lucknow, India · Incident · No injuries · Foreign investigation · Mar 7, 2019 · VT-WGT · No damage
  > The government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 7, 2019. A GoAir Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure while…
- [NTSB ANC19FA038](https://openairdocs.org/ntsb/ANC19FA038.md): Cessna 172 · Skwentna, AK · Accident · 1 fatal · Class 2 · Field · Final report · Mar 7, 2019 · N7469A · Substantial damage
  > The pilot’s decision to depart into marginal visual flight rule conditions in mountainous terrain with the potential for icing, and the airplane’s accumulation of structural icing, which resulted in the pilot’s inability to maintain airplane control and the…
- [NTSB CEN19FA093](https://openairdocs.org/ntsb/CEN19FA093.md): Piper PA28 · Summersville, MO · Accident · 1 fatal · Class 3 · Field · Final report · Mar 6, 2019 · N7369W · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight fuel planning and in-flight fuel monitoring.
- [NTSB ERA19TA120](https://openairdocs.org/ntsb/ERA19TA120.md): Cirrus SR22 · Atlantic Ocean (Atlantic Ocean) · Accident · Minor injuries · Class 3 · Final report · Mar 5, 2019 · N345DM · Substantial damage
  > A loss of oil pressure and subsequent total loss of engine power for undetermined reasons.
- [NTSB CEN19WA103](https://openairdocs.org/ntsb/CEN19WA103.md): Robinson R66 · Timmins, CYTS, Canada · Accident · 2 fatal · Foreign investigation · Mar 4, 2019 · C-GAUA · Substantial damage
  > The government of Canada has notified the NTSB of an accident involving a Robinson R66 helicopter that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…
- [NTSB WPR19WA164](https://openairdocs.org/ntsb/WPR19WA164.md): Bell 505X · Londiani, Kericho, Kenya · Accident · 5 fatal · Foreign investigation · Mar 3, 2019 · 5Y-KDL · Destroyed
  > On March 3, 2019, about 0834 local time, a Bell 505X, 5Y-KDL, collided with terrain near Londiani, Kericho, Kenya. The 1 pilot and 4 passengers were fatally injured; the helicopter was destroyed. The helicopter was owned and operated by KWAE Island…
- [NTSB ERA19TA111](https://openairdocs.org/ntsb/ERA19TA111.md): Piper PA32 · West Palm Beach (Atlantic Ocean) · Accident · No injuries · Final report · Feb 28, 2019 · N1563X · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a ditched landing in the ocean.
- [NTSB DCA19CA088](https://openairdocs.org/ntsb/DCA19CA088.md): Boeing 777 · Honolulu, HI · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 27, 2019 · N771AN · No damage
  > the airplanes encounter with clear air turbulence.
- [NTSB ERA19WA128](https://openairdocs.org/ntsb/ERA19WA128.md): Cessna T182 · Jacareacanga County, Brazil · Accident · 2 fatal · Foreign investigation · Feb 23, 2019 · PR-ENM · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB WPR19FA086](https://openairdocs.org/ntsb/WPR19FA086.md): Beech D55 · Stallion Springs, CA · Accident · 3 fatal · Class 3 · Field · Final report · Feb 22, 2019 · N533Q · Destroyed
  > The pilot’s continued visual flight into instrument meteorological conditions associated with mountain obscuration conditions, which resulted in controlled flight into rising terrain. Contributing to the accident was the pilot’s failure to obtain a weather…
- [NTSB DCA19CA091](https://openairdocs.org/ntsb/DCA19CA091.md): Boeing 737 · Franklin, TN · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 18, 2019 · N3730B · No damage
  > an encounter with convective turbulence during descent.
- [NTSB CEN19WA083](https://openairdocs.org/ntsb/CEN19WA083.md): Robinson R44 · Roeldal, Norway · Accident · 2 fatal · Foreign investigation · Feb 17, 2019 · LN-ORH · Destroyed
  > The government of Norway has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the…
- [NTSB WPR19FA084](https://openairdocs.org/ntsb/WPR19FA084.md): Cirrus SR22 · Ely, NV · Accident · 2 fatal · Class 2 · Field · Final report · Feb 16, 2019 · N917SR · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…
- [NTSB CEN19WA089](https://openairdocs.org/ntsb/CEN19WA089.md): Piper PA19 · Brustem Airfield, Belgium, Belgium · Incident · No injuries · Foreign investigation · Feb 16, 2019 · OO-SPQ · Minor damage
  > The government of Belgium has notified the NTSB of an accident involving a PIPER PA19 airplane that occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…
- [NTSB DCA19WA082](https://openairdocs.org/ntsb/DCA19WA082.md): Boeing 737 · Albania, Albania · Incident · No injuries · Foreign investigation · Feb 13, 2019 · F-GZHM · No damage
  > The government of Albania has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Albania's investigation under the provisions…
- [NTSB DCA19CA081](https://openairdocs.org/ntsb/DCA19CA081.md): Embraer ERJ170 · Reno, NV · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 13, 2019 · N613CZ · Minor damage
  > an inadvertent encounter with convective turbulence that resulted in a TCAS RA, which required an abrupt control input by the flight crew to resolve the conflict.
- [NTSB ANC19TA014](https://openairdocs.org/ntsb/ANC19TA014.md): Piper PA32R · Anchorage, AK · Accident · Serious injuries · Class 3 · Final report · Feb 13, 2019 · N40449 · No damage
  > The pilot’s failure to ensure that the passenger’s lap belt was appropriately fastened for the forecast turbulent conditions, and the passenger’s failure to tighten her lap belt appropriately, which resulted in the passenger’s serious injury during an…
- [NTSB WPR19LA088](https://openairdocs.org/ntsb/WPR19LA088.md): Lancair IV · Laramie, WY · Accident · No injuries · Class 3 · Limited · Final report · Feb 10, 2019 · N549CJ · Substantial damage
  > An environmental stress cracking failure of the acrylic windshield, which resulted in a rapid decompression during cruise flight.
- [NTSB DCA19WA084](https://openairdocs.org/ntsb/DCA19WA084.md): Boeing 737 · Nurenburg, Germany · Incident · Minor injuries · Foreign investigation · Feb 10, 2019 · D-ABMQ · No damage
  > The government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…
- [NTSB WPR19FA083](https://openairdocs.org/ntsb/WPR19FA083.md): Mooney M20F · Diablo, CA · Accident · 1 fatal · Class 3 · Field · Final report · Feb 9, 2019 · N3270F · Destroyed
  > The student pilot’s decision to depart on a visual flight rules flight into reduced visibility night conditions and his subsequent failure to maintain clearance from mountainous terrain, which resulted in controlled flight into terrain.
- [NTSB ERA19LA096](https://openairdocs.org/ntsb/ERA19LA096.md): Convair C131 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Feb 8, 2019 · N145GT · Destroyed
  > The captain's decision to continue with the flight with a malfunctioning left engine propeller control and the subsequent loss of engine power on both engines for undetermined reasons, which resulted in ditching into the ocean. Contributing to the accident…
- [NTSB WPR19FA080](https://openairdocs.org/ntsb/WPR19FA080.md): Cessna 172 · Desert Hot Springs, CA · Accident · 2 fatal · Class 2 · Field · Final report · Feb 6, 2019 · N20556 · Destroyed
  > The pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.
- [NTSB ENG19WA012](https://openairdocs.org/ntsb/ENG19WA012.md): Airbus A321 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · Feb 6, 2019 · VNA-621 · No damage
  > On February 2, 2019, a Vietnam Airlines A321-272N Neo, powered by two P&W PW1130G-JM geared fan engines experienced an No. 2 (right) engine failure while in cruise. It was reported that a stall warning was detected followed by high vibration and an exhaust…
- [NTSB DCA19CA090](https://openairdocs.org/ntsb/DCA19CA090.md): Boeing 787 · Pacific Ocean (Pacific Ocean) · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 3, 2019 · N26909 · No damage
  > an inadvertent slip and fall that resulted in a serious injury.
- [NTSB ERA19LA095](https://openairdocs.org/ntsb/ERA19LA095.md): Cessna 150 · Knotts Island, NC · Accident · No injuries · Class 3 · Limited · Final report · Feb 2, 2019 · N6789F · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot's improper fuel planning.
- [NTSB CEN19FA078](https://openairdocs.org/ntsb/CEN19FA078.md): Mooney M20K · Katy, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jan 31, 2019 · N56359 · Destroyed
  > The noninstrument-rated pilot's decision to continue visual flight into an area of instrument meteorological conditions (IMC), which resulted in a loss of control due to spatial disorientation.
- [NTSB WPR19WA149](https://openairdocs.org/ntsb/WPR19WA149.md): Pitts S2 · Kliprivier, South Africa · Accident · No injuries · Foreign investigation · Jan 29, 2019 · ZS-OOB · Substantial damage
  > The government of South Africa has notified the NTSB of an accident involving a Pitts S2 airplane that occurred on January 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…
- [NTSB CEN19LA074](https://openairdocs.org/ntsb/CEN19LA074.md): Cessna 172 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · Jan 29, 2019 · N565SP · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…
- [NTSB CEN19FA072](https://openairdocs.org/ntsb/CEN19FA072.md): Bell 407 · Zaleski, OH · Accident · 3 fatal · Class 1 · Field · Final report · Jan 29, 2019 · N191SF · Destroyed
  > The NTSB determines that the probable cause of this accident was Survival Flight's inadequate management of safety, which normalized pilots' and operations control specialists' noncompliance with risk analysis procedures and resulted in the initiation of the…
- [NTSB CEN19LA076](https://openairdocs.org/ntsb/CEN19LA076.md): Piper PA32RT · Pflugerville, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 2019 · N39650 · Substantial damage
  > The pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.
- [NTSB CEN19WA077](https://openairdocs.org/ntsb/CEN19WA077.md): Rans S12 · Bavispe, Mexico · Accident · 2 fatal · Foreign investigation · Jan 26, 2019 · UNREG · Substantial damage
- [NTSB ERA19WA174](https://openairdocs.org/ntsb/ERA19WA174.md): Eurocopter AS350 · Megeve, Italy · Accident · 7 fatal · Foreign investigation · Jan 25, 2019 · I-EDIC · 2 aircraft · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a midair collision between a Eurocopter AS350-B3 helicopter and a Jodel D.140E airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist…
- [NTSB ERA19WA103](https://openairdocs.org/ntsb/ERA19WA103.md): Britten Norman BN2B · Esmeraldas, Ecuador · Incident · No injuries · Foreign investigation · Jan 25, 2019 · N203PR · No damage
  > The government of Ecuador has notified the NTSB of an incident involving a Britten Norman BN2B airplane that occurred on January 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the…
- [NTSB ANC19LA011](https://openairdocs.org/ntsb/ANC19LA011.md): Piper PA-22-150 · Anchorage, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 22, 2019 · N7640D · Substantial damage
  > A loss of engine power due to oil starvation as the result of a loose B-nut fitting on the engine oil cooler, resulting in a forced landing to a soft, snow-covered surface, and a subsequent nose over.
- [NTSB CEN19WA057](https://openairdocs.org/ntsb/CEN19WA057.md): Piper PA46 · St. Peter Port, United Kingdom · Accident · 2 fatal · Foreign investigation · Jan 21, 2019 · N264DB · Destroyed
  > On January 21, 2013, about 2012 UTC, a Piper PA-46-301P, N264DB, operated by a private individual, disappeared from radar 15 nm north of Guernsey, Channel Island, United Kingdom. The airplane is believed to have crashed in English Channel and is presumed…
- [NTSB CEN19LA063](https://openairdocs.org/ntsb/CEN19LA063.md): Cessna 172 · Aguilares, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 2019 · N99308 · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB WPR19LA070](https://openairdocs.org/ntsb/WPR19LA070.md): Hill Group CCX-2000 · Roll, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jan 19, 2019 · N57FX · Substantial damage
  > The loss of engine power due to a fatigue failure of the crankshaft for reasons that could not be determined based on the available information.
- [NTSB CEN19LA060](https://openairdocs.org/ntsb/CEN19LA060.md): Stinson 108 · Keshena, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 19, 2019 · N97969 · Substantial damage
  > A total loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.
- [NTSB CEN19LA071](https://openairdocs.org/ntsb/CEN19LA071.md): Piper PA24 · Beechwood, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 18, 2019 · N6497P · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR19LA066](https://openairdocs.org/ntsb/WPR19LA066.md): Piper PA23 · Ellensburg, WA · Accident · 1 fatal · Class 2 · Limited · Final report · Jan 17, 2019 · N14372 · Destroyed
  > The instrument rated pilot’s loss of control due to spatial disorientation.
- [NTSB CEN19LA055](https://openairdocs.org/ntsb/CEN19LA055.md): Beech 36 · Fredericksburg, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 17, 2019 · N2021T · Destroyed
  > The loss of engine power due to fatigue failure of the crankshaft.
- [NTSB WPR19LA064](https://openairdocs.org/ntsb/WPR19LA064.md): Beech 35 · Port Hadlock, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 13, 2019 · N5093C · Substantial damage
  > A total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.

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

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

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