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

## Cases, newest first

- [NTSB ERA19FA240](https://openairdocs.org/ntsb/ERA19FA240.md): Beech F33 · Hatboro, PA · Accident · 3 fatal · Class 3 · Field · Final report · Aug 8, 2019 · N4082S · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.
- [NTSB DCA19CA198](https://openairdocs.org/ntsb/DCA19CA198.md): Airbus A320 · Charlottesville, VA · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 8, 2019 · N505JB · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB CEN19LA266](https://openairdocs.org/ntsb/CEN19LA266.md): Canadair CL600 2B16 · Lubbock, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 8, 2019 · N237QS · No damage
  > The unexpected wake turbulence encounter while climbing in smooth air to cruise, resulting in passenger injuries. Contributing to the accident was the passenger seat belt sign was off.
- [NTSB CEN19LA260](https://openairdocs.org/ntsb/CEN19LA260.md): Moth DH60GM · Cortez, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 8, 2019 · N919DH · Substantial damage
  > A partial loss of engine power due to carburetor ice accumulation, which resulted in a loss of altitude and impact with trees.
- [NTSB CEN19LA258](https://openairdocs.org/ntsb/CEN19LA258.md): Cessna R172 · North Garden, VA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 8, 2019 · N1609V · Substantial damage
  > A total loss of engine power due to the failure of the oil pump drive gear.
- [NTSB GAA19WA533](https://openairdocs.org/ntsb/GAA19WA533.md): Piper PA25 · Totatlan, Jalisco, Mexico · Accident · 1 fatal · Foreign investigation · Aug 6, 2019 · XB-TOP · Destroyed
  > The government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB ANC19WA052](https://openairdocs.org/ntsb/ANC19WA052.md): Cessna 208 · Mayo, Canada · Accident · 2 fatal · Foreign investigation · Aug 6, 2019 · C-FSKF
  > The government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…
- [NTSB CEN19LA249](https://openairdocs.org/ntsb/CEN19LA249.md): Cessna A185 · Saginaw, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 3, 2019 · N5806J · Substantial damage
  > Maintenance personnel’s failure to properly align the crankshaft during an engine reassembly which led to a fatigue failure of the crankshaft and the loss of all engine power.
- [NTSB CEN19FA247](https://openairdocs.org/ntsb/CEN19FA247.md): Piper PA28 · Ontonagon, MI · Accident · 1 fatal · Class 3 · Field · Final report · Aug 3, 2019 · N5167L · Destroyed
  > The non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions with thunderstorm activity, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB WPR19WA234](https://openairdocs.org/ntsb/WPR19WA234.md): Robinson R44 · Korotasere, Cakaudrove, Fiji · Accident · 3 fatal · Foreign investigation · Aug 2, 2019 · DQ-HPT
  > On August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…
- [NTSB GAA19WA579](https://openairdocs.org/ntsb/GAA19WA579.md): Hughes 369 · Follebu, Norway · Accident · No injuries · Foreign investigation · Aug 1, 2019 · SE-JVJ · Substantial damage
  > The government of Norway has notified the NTSB of an accident involving a HUGHES 369 helicopter that occurred on August 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…
- [NTSB CEN19WA268](https://openairdocs.org/ntsb/CEN19WA268.md): Beech V35 · Senneterre, Quebec, Canada · Accident · 1 fatal · Foreign investigation · Jul 30, 2019 · N3804X · Destroyed
- [NTSB CEN19LA265](https://openairdocs.org/ntsb/CEN19LA265.md): Piper PA28 · Fairhope, AL · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2019 · N6754J · Substantial damage
  > Failure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.
- [NTSB CEN19CA239](https://openairdocs.org/ntsb/CEN19CA239.md): Cessna 172 · Oshkosh, WI · Accident · No injuries · Data collection · Final report · Jul 28, 2019 · N79575 · Substantial damage
  > The pilot's improper fuel planning and decision to not divert to a closer airport when the planned flight profile changed, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR19LA226](https://openairdocs.org/ntsb/WPR19LA226.md): Cessna 177RG · Fall City, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 27, 2019 · N1828Q · Substantial damage
  > The failure of the No. 3 cylinder intake valve that resulted in a partial loss of engine power and a forced landing on uneven terrain.
- [NTSB ANC19WA043](https://openairdocs.org/ntsb/ANC19WA043.md): Cessna 208 · Bella Bella, Canada · Accident · 4 fatal · Foreign investigation · Jul 26, 2019 · C-GURL
  > On July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…
- [NTSB ERA19LA238](https://openairdocs.org/ntsb/ERA19LA238.md): Aero Commander S2R · Cuthbert, GA · Accident · No injuries · Class 3 · Limited · Final report · Jul 25, 2019 · N5680X · Substantial damage
  > The failure of the No. 1 bearing due to fatigue which resulted in a partial loss of engine power. The reason for the bearing failure could not be determined based on the available information.
- [NTSB ENG19IA029](https://openairdocs.org/ntsb/ENG19IA029.md): Airbus A220 · Perrigny-sur-Armançon, France · Incident · No injuries · Class 3 · Incident · Final report · Jul 25, 2019 · HB-JCM · Minor damage
  > A No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed as a result of a…
- [NTSB CEN19LA243](https://openairdocs.org/ntsb/CEN19LA243.md): Culver LCA · Viroqua, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 25, 2019 · N29272 · Substantial damage
  > A total loss of engine power due to fuel exhaustion.
- [NTSB WPR19WA203](https://openairdocs.org/ntsb/WPR19WA203.md): RIchards Heavylift UH-1H · Limpopo Province, South Africa · Accident · No injuries · Foreign investigation · Jul 23, 2019 · ZS-HLJ · Substantial damage
  > On July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…
- [NTSB DCA19CA189](https://openairdocs.org/ntsb/DCA19CA189.md): Boeing 767 · San Juan, PR · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 22, 2019 · N663UA · No damage
  > An encounter with convective turbulence during cruise flight.
- [NTSB WPR19LA201](https://openairdocs.org/ntsb/WPR19LA201.md): Cessna R182 · King City, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2019 · N3268C · Substantial damage
  > A landing gear collapse following an undetermined loss of electrical power, which prevented the landing gear from fully extending.
- [NTSB GAA19WA460](https://openairdocs.org/ntsb/GAA19WA460.md): De Havilland DH82 · Hythe, United Kingdom · Accident · 1 fatal · Foreign investigation · Jul 21, 2019 · N54556 · Destroyed
- [NTSB GAA19CA446](https://openairdocs.org/ntsb/GAA19CA446.md): Evektor Aerotechnik Sportstar · Tracy, CA · Accident · No injuries · Data collection · Final report · Jul 21, 2019 · N409EV · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing and collision with a tree.
- [NTSB CEN19LA232](https://openairdocs.org/ntsb/CEN19LA232.md): Cessna 152 · Fredericksburg, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2019 · N48410 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN19IA234](https://openairdocs.org/ntsb/CEN19IA234.md): Mooney M20J · Oshkosh, WI · Incident · No injuries · Class 3 · Incident · Final report · Jul 21, 2019 · N9201A · 2 aircraft · Minor damage
  > The failure of both pilots to remain clear of the other while flying in formation.
- [NTSB WPR19LA192](https://openairdocs.org/ntsb/WPR19LA192.md): Judd Challenger II · Draper, UT · Accident · No injuries · Class 3 · Limited · Final report · Jul 19, 2019 · N77YD · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB ERA19LA231](https://openairdocs.org/ntsb/ERA19LA231.md): Piper PA46 · Poughkeepsie, NY · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 19, 2019 · N811SK · Substantial damage
  > A total loss of engine power due to fuel exhaustion as the result of a higher-than-expected fuel quantity reduction. Contributing was the pilot’s continued flight away from his selected precautionary landing site after identification of a fuel emergency,…
- [NTSB GAA19WA444](https://openairdocs.org/ntsb/GAA19WA444.md): Cirrus SR22 · Leutasch, Austria, Austria · Accident · 1 fatal · Foreign investigation · Jul 18, 2019 · D-EUFO · Destroyed
  > The government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions of…
- [NTSB ANC19LA036](https://openairdocs.org/ntsb/ANC19LA036.md): Stoddard Hamilton Glasair II · Chattanooga, TN · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 17, 2019 · C-GAFT · Substantial damage
  > The pilot's failure to switch to the secondary electrical system after the primary electrical system failed for unknown reasons.
- [NTSB WPR19LA189](https://openairdocs.org/ntsb/WPR19LA189.md): Vans RV14 · Aumsville, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N365EM · Destroyed
  > An inflight fire that originated in the engine compartment for reasons that could not be determined based on available evidence.
- [NTSB ERA19LA228](https://openairdocs.org/ntsb/ERA19LA228.md): Pietenpol BIG Piet · Gainesboro, TN · Accident · No injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N973BP · Substantial damage
  > Separation of the spinner cap for reasons that could not be determined based on available evidence, which resulted in contact and subsequent separation of the wooden propeller blade tip.
- [NTSB GAA19WA441](https://openairdocs.org/ntsb/GAA19WA441.md): De Havilland DHC2 · Mistastin Lake, NL, Canada · Accident · 7 fatal · Foreign investigation · Jul 15, 2019 · C-FJKI · Substantial damage
  > The government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…
- [NTSB ENG19WA043](https://openairdocs.org/ntsb/ENG19WA043.md): Airbus A320 · Goa, India · Incident · No injuries · Foreign investigation · Jul 15, 2019 · VT-ITU · No damage
  > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on July 15, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…
- [NTSB CEN19FA221](https://openairdocs.org/ntsb/CEN19FA221.md): Cessna 172 · Katy, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jul 13, 2019 · N517LA · Destroyed
  > The pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.
- [NTSB GAA19WA417](https://openairdocs.org/ntsb/GAA19WA417.md): De Havilland DHC2 · Chibogamau, Canada · Accident · 3 fatal · Foreign investigation · Jul 12, 2019 · C-GRHF · Substantial damage
  > The government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…
- [NTSB ERA19WA237](https://openairdocs.org/ntsb/ERA19WA237.md): Piper PA28 · Atibaia, Brazil · Accident · 2 fatal · Foreign investigation · Jul 12, 2019 · PT-CON · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a Piper PA-28-140 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN19WA337](https://openairdocs.org/ntsb/CEN19WA337.md): Robinson R44 · Mt Tremblank, Canada · Accident · 2 fatal · Foreign investigation · Jul 10, 2019 · C-FJLH · Destroyed
  > The government of Canada has notified the NTSB of an accident involving a Robinson R-44 helicopter, Canadian registration C-FJLH, that occurred on July 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's…
- [NTSB CEN19LA245](https://openairdocs.org/ntsb/CEN19LA245.md): Robinson R22 · Water Valley, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 8, 2019 · N334DC · Substantial damage
  > The loss of helicopter performance for undetermined reasons.
- [NTSB CEN19LA216](https://openairdocs.org/ntsb/CEN19LA216.md): Rutan Varieze · Kaneville, IL · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 8, 2019 · N112EZ · Substantial damage
  > The pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.
- [NTSB ANC19LA032](https://openairdocs.org/ntsb/ANC19LA032.md): Cessna 172 · Newport, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 8, 2019 · N9919V · Substantial damage
  > The pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB CEN19WA338](https://openairdocs.org/ntsb/CEN19WA338.md): Gulfstream Gulfstream GVI · Waterford, Ireland · Incident · No injuries · Foreign investigation · Jul 7, 2019 · EI-JSK · No damage
  > On July 7, 2019, about 1645 coordinated universal time, a Gulfstream GVI airplane, EI-JSK, had an uncommanded engine shutdown in flight near Waterford, Ireland. The flight departed from and returned to Shannon Airport. The flight was destined for Farnborough…
- [NTSB GAA19WA592](https://openairdocs.org/ntsb/GAA19WA592.md): Beech B36 · Mexico, Mexico · Accident · No injuries · Foreign investigation · Jul 5, 2019 · XB-HYS
  > The government of Mexico has notified the NTSB of an accident involving a BEECH B36 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB CEN19FA210](https://openairdocs.org/ntsb/CEN19FA210.md): Beech A36 · Chebanse, IL · Accident · 1 fatal · Class 2 · Field · Final report · Jul 5, 2019 · N1809S · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB CEN19LA206](https://openairdocs.org/ntsb/CEN19LA206.md): Cessna 140 · Reeves, LA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 4, 2019 · N3725V · Substantial damage
  > The pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.
- [NTSB WPR19LA185](https://openairdocs.org/ntsb/WPR19LA185.md): Cessna TU206 · Waikoloa Village, HI · Accident · No injuries · Class 3 · Limited · Final report · Jul 3, 2019 · N150SC · Substantial damage
  > The total loss of engine power due to the failure of the No. 4 connecting rod crankshaft end and cap.
- [NTSB CEN19WA197](https://openairdocs.org/ntsb/CEN19WA197.md): Rans S6 · Rougemont, Canada · Accident · 2 fatal · Foreign investigation · Jul 1, 2019 · C-IIJJ · Destroyed
- [NTSB CEN19LA194](https://openairdocs.org/ntsb/CEN19LA194.md): Beech A23 · Fort Smith, AR · Accident · No injuries · Class 3 · Limited · Final report · Jul 1, 2019 · N3598R · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.
- [NTSB WPR19LA187](https://openairdocs.org/ntsb/WPR19LA187.md): Beech C23 · Ludlow, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 30, 2019 · N24580 · Substantial damage
  > Maintenance personnel’s failure to properly tighten an oil line fitting, which resulted in a total loss of engine power.
- [NTSB WPR19LA181](https://openairdocs.org/ntsb/WPR19LA181.md): Rolladen Schneider LS4 · Moriarty, NM · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 29, 2019 · N7LR · Minor damage
  > An in-flight cardiac event which necessitated an emergency landing, and which the pilot succumbed to.

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

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

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