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

## Cases, newest first

- [NTSB WPR20WA061](https://openairdocs.org/ntsb/WPR20WA061.md): Cessna 172 · Dhana, India · Accident · No injuries · Foreign investigation · Jan 3, 2020 · VT-CAF · Substantial damage
  > The government of India has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on January 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of…
- [NTSB WPR20CA069](https://openairdocs.org/ntsb/WPR20CA069.md): Gulfstream G IV · Van Nuys, CA · Accident · Serious injuries · Data collection · Final report · Jan 2, 2020 · N962SS · No damage
  > The airplane’s encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.
- [NTSB ERA20LA064](https://openairdocs.org/ntsb/ERA20LA064.md): Cirrus SR22 · Kenansville, NC · Accident · No injuries · Class 3 · Limited · Final report · Jan 2, 2020 · N323SR · Substantial damage
  > A fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.
- [NTSB CEN20LA053](https://openairdocs.org/ntsb/CEN20LA053.md): Cessna T210 · Ada, OK · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 1, 2020 · N94227 · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation, and the pilot’s inadequate preflight inspection and preflight fuel planning.
- [NTSB ANC20CA011](https://openairdocs.org/ntsb/ANC20CA011.md): Cessna 170 · Fairbanks, AK · Accident · No injuries · Class 4 · Data collection · Final report · Jan 1, 2020 · N4667C · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency off-airport landing, and a nose over.
- [NTSB ERA20WA067](https://openairdocs.org/ntsb/ERA20WA067.md): Cessna 560 · Cmte Nicanor Otamendi, Argentina · Accident · No injuries · Foreign investigation · Dec 28, 2019 · LV-FQD · Substantial damage
  > The government of Argentina has notified the NTSB of an accident involving a CESSNA 560XLS airplane that occurred on December 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…
- [NTSB ANC20MA010](https://openairdocs.org/ntsb/ANC20MA010.md): Airbus AS350B2 · Kekaha, HI · Accident · 7 fatal · Class 1 · Major · Final report · Dec 27, 2019 · N985SA · Destroyed
  > The pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…
- [NTSB CEN20WA045](https://openairdocs.org/ntsb/CEN20WA045.md): Cessna 208 · San Rafael, Mexico · Accident · No injuries · Foreign investigation · Dec 24, 2019 · XA-TWN · Destroyed
  > On December 24, 2019, about 1529 coordinated universal time, a Cessna 208B airplane, XA-TWN, impacted desert terrain near San Rafael, Sonoroa, Mexico, while enroute to the Guerrero Negro Airport (MMGR), Baja California, Mexico. The two occupants sustained…
- [NTSB ENG20WA011](https://openairdocs.org/ntsb/ENG20WA011.md): Airbus A320 · Guwahati, India · Incident · No injuries · Foreign investigation · Dec 23, 2019 · VT-WGL · No damage
  > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 23, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an inflight shutdown…
- [NTSB WPR20CA056](https://openairdocs.org/ntsb/WPR20CA056.md): Cosmos Phase II · Lake Havasu City, AZ · Accident · Serious injuries · Data collection · Final report · Dec 22, 2019 · N5057Z · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel inspection.
- [NTSB ERA20CA059](https://openairdocs.org/ntsb/ERA20CA059.md): Eipper Quicksilver · Mayaguez, PR · Accident · Minor injuries · Data collection · Final report · Dec 22, 2019 · N211RR · Substantial damage
  > The student pilot's inadvertent movement of the fuel shutoff switch to the “off” position while attempting to take a picture of himself, which resulted in a total loss of engine power due to fuel starvation and a subsequent ditching in open water.
- [NTSB ENG20WA009](https://openairdocs.org/ntsb/ENG20WA009.md): Airbus A320 · Mumbai, India · Incident · No injuries · Foreign investigation · Dec 22, 2019 · VT-WJE · No damage
  > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…
- [NTSB DCA20CA050](https://openairdocs.org/ntsb/DCA20CA050.md): Boeing 737 · Kansas City, MO · Accident · No injuries · Class 4 · Data collection · Final report · Dec 22, 2019 · N7739A · Substantial damage
  > a bird strike during descent
- [NTSB ERA20LA057](https://openairdocs.org/ntsb/ERA20LA057.md): Piper PA32 · Florida, MA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 20, 2019 · N4726S · Substantial damage
  > The pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation and a forced landing in a remote, wooded terrain.
- [NTSB ERA20WA066](https://openairdocs.org/ntsb/ERA20WA066.md): Beech A100 · Charallave, Venezuela · Accident · 9 fatal · Class 3 · Foreign · Dec 19, 2019 · YV1104 · Destroyed
- [NTSB ERA20CA090](https://openairdocs.org/ntsb/ERA20CA090.md): Pitts A · Hickory Valley, TN · Accident · No injuries · Class 4 · Data collection · Final report · Dec 19, 2019 · N113A · Substantial damage
  > The pilot’s improper fuel planning which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ENG20WA035](https://openairdocs.org/ntsb/ENG20WA035.md): Cessna P210 · Moruya, Australia · Accident · Serious injuries · Foreign investigation · Dec 19, 2019 · N210BA · Substantial damage
- [NTSB DCA20CA043](https://openairdocs.org/ntsb/DCA20CA043.md): Embraer ERJ190 · Disputanta, VA · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 18, 2019 · N959UW · No damage
  > an encounter with clear air turbulence during cruise flight.
- [NTSB CEN20WA056](https://openairdocs.org/ntsb/CEN20WA056.md): Learjet 45 · Geneva, Switzerland · Incident · No injuries · Foreign investigation · Dec 18, 2019 · D-CNMB · No damage
  > The government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…
- [NTSB CEN20LA041](https://openairdocs.org/ntsb/CEN20LA041.md): Cessna 525A · Scotts Bluff, NE · Accident · No injuries · Class 3 · Limited · Final report · Dec 18, 2019 · CGOJG · Substantial damage
  > The installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.
- [NTSB CEN20LA036](https://openairdocs.org/ntsb/CEN20LA036.md): Champion 7ECA · Starkville, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 18, 2019 · N9566S · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision not to visually confirm the remaining fuel onboard during the intermediate stop.
- [NTSB DCA20WA039](https://openairdocs.org/ntsb/DCA20WA039.md): Boeing 767 · Shannon, Ireland · Incident · No injuries · Foreign investigation · Dec 16, 2019 · N642UA · No damage
  > The government of Ireland has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on December 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…
- [NTSB DCA20CA038](https://openairdocs.org/ntsb/DCA20CA038.md): Embraer EMB 135KL · Alexandria, LA · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 16, 2019 · N805AE · No damage
  > an encounter with convectively induced turbulence while overflying an area of known convective activity.
- [NTSB ERA20LA054](https://openairdocs.org/ntsb/ERA20LA054.md): Robinson R44 · San Antonio, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 14, 2019 · N440AH · Substantial damage
  > Maintenance personnel’s failure to complete all necessary steps of a service bulletin and subsequent failure to identify the loose lower actuator bearing support bracket during inspections, which resulted in the misalignment of the clutch actuator, resulted…
- [NTSB WPR20LA042](https://openairdocs.org/ntsb/WPR20LA042.md): Cessna 182 · Carlsbad, CA · Accident · No injuries · Class 3 · Limited · Final report · Dec 13, 2019 · N182EF · Substantial damage
  > The fatigue failure of the crankshaft. Contributing to the accident was the undocumented installation of the supercharger, which resulted in increased stress on the crankshaft.
- [NTSB GAA20WA103](https://openairdocs.org/ntsb/GAA20WA103.md): Cessna 150 · Region del Bio Bio, Chile · Accident · 1 fatal · Foreign investigation · Dec 13, 2019 · CC-PGU · Destroyed
  > The government of Chile has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on December 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…
- [NTSB ANC20WA009](https://openairdocs.org/ntsb/ANC20WA009.md): Piper PA60 · Nanaimo, Canada · Accident · 3 fatal · Foreign investigation · Dec 11, 2019 · C-FQYW · Destroyed
  > The government of Canada has notified the NTSB of an accident involving a Piper PA60 airplane that occurred on December 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…
- [NTSB ENG20IA006](https://openairdocs.org/ntsb/ENG20IA006.md): De Havilland DHC8 · Keene, NH · Incident · No injuries · Class 3 · Incident · Final report · Dec 9, 2019 · C-GNON · Minor damage
  > The arcing failure of the windshield heat L2 power wire on the right windshield due to unknown reasons.
- [NTSB ERA20LA051](https://openairdocs.org/ntsb/ERA20LA051.md): Parsons Two Place #1 · Naguabo, PR · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 8, 2019 · N446PS · Substantial damage
  > A failure of the rudder attachment bolt, which resulted in the rudder’s subsequent inflight separation from the fuselage.
- [NTSB CEN20FA034](https://openairdocs.org/ntsb/CEN20FA034.md): Mooney M20C · Flower Pot, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Dec 8, 2019 · N5557Q · Destroyed
  > The noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…
- [NTSB WPR20WA081](https://openairdocs.org/ntsb/WPR20WA081.md): Oas UH-1H · Williamtown Aerodrome, Australia · Accident · Minor injuries · Foreign investigation · Dec 7, 2019 · VH-OXI · Substantial damage
  > The government of Australia has notified the NTSB of an accident involving a OAS UH-1H helicopter that occurred on December 07, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…
- [NTSB CEN20FA035](https://openairdocs.org/ntsb/CEN20FA035.md): Bell 407 · Gulf of Mexico (Gulf of Mexico) · Accident · 2 fatal · Class 3 · Field · Final report · Dec 7, 2019 · N79LP · Destroyed
  > A total loss of engine power due to the failure of the engine’s Nos. 3 and 4 bearings and the power turbine pinion gear, and subsequent loss of main rotor rpm, which resulted in a loss of control and impact with the water.
- [NTSB WPR20LA040](https://openairdocs.org/ntsb/WPR20LA040.md): Vans RV 6 · Pima, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 5, 2019 · N616RV · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB DCA20IA034](https://openairdocs.org/ntsb/DCA20IA034.md): Airbus AS 350 B2 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Dec 5, 2019 · N71HD · 2 aircraft · Minor damage
  > an inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).
- [NTSB ERA20LA047](https://openairdocs.org/ntsb/ERA20LA047.md): Cessna 172 · Potts Camp, MS · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 4, 2019 · N2876Q · Substantial damage
  > The pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.
- [NTSB GAA20WA102](https://openairdocs.org/ntsb/GAA20WA102.md): Beech C90 · Caieiras, SP, Brazil · Accident · 1 fatal · Foreign investigation · Dec 2, 2019 · PP-BSS · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB CEN20FA023](https://openairdocs.org/ntsb/CEN20FA023.md): Piper PA24 · San Antonio, TX · Accident · 3 fatal · Class 3 · Field · Final report · Dec 2, 2019 · N6678P · Substantial damage
  > The loss of engine power for reason that could not be determined. Contributing to the accident was the pilot’s failure to maintain aircraft control while maneuvering to landing which resulted in an inadvertent stall/spin with insufficient altitude to recover.
- [NTSB ERA20LA045](https://openairdocs.org/ntsb/ERA20LA045.md): Yakovlev YAK 52 · Wrightsville, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 30, 2019 · N52CY · Substantial damage
  > A total loss of engine power due to the failure of the No. 5 cylinder exhaust valve, which resulted in an forced off-airport landing.
- [NTSB ANC20WA008](https://openairdocs.org/ntsb/ANC20WA008.md): Robinson R66 · Krasnodarsky Krai, Russia · Accident · 1 fatal · Foreign investigation · Nov 30, 2019 · RA-05795 · Destroyed
  > The government of Russia has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on November 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…
- [NTSB ANC20FA007](https://openairdocs.org/ntsb/ANC20FA007.md): Piper PA-31-350 · Cooper Landing, AK · Accident · 3 fatal · Class 3 · Field · Final report · Nov 30, 2019 · N4087G · Destroyed
  > The pilot’s failure to maintain clearance from terrain during gusty wind and reduced visibility night conditions.
- [NTSB CEN20WA024](https://openairdocs.org/ntsb/CEN20WA024.md): Piper PA32 · Kingston, Canada · Accident · 7 fatal · Foreign investigation · Nov 28, 2019 · N50DK · Destroyed
- [NTSB WPR20FA034](https://openairdocs.org/ntsb/WPR20FA034.md): Cirrus SR-22 · North Las Vegas, NV · Accident · 3 fatal · Class 3 · Field · Final report · Nov 27, 2019 · N7GA · Destroyed
  > The pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.
- [NTSB GAA20WA097](https://openairdocs.org/ntsb/GAA20WA097.md): Cessna 172 · Near Puffin Island, Anglesey, United Kingdom · Accident · 1 fatal · Foreign investigation · Nov 25, 2019 · G-CBXJ · Destroyed
  > The government of United Kingdom has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…
- [NTSB CEN20LA020](https://openairdocs.org/ntsb/CEN20LA020.md): Cirrus SR22 · Tyler, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 22, 2019 · N969JM · Substantial damage
  > A total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.
- [NTSB CEN20WA080](https://openairdocs.org/ntsb/CEN20WA080.md): Beech 95-B55 · Malmo, Sweden · Accident · No injuries · Foreign investigation · Nov 17, 2019 · SE-LUX · Substantial damage
  > The government of Sweden has notified the NTSB of an accident involving a Beech 95-B55 airplane that occurred on November 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions…
- [NTSB ENG20IA005](https://openairdocs.org/ntsb/ENG20IA005.md): Agusta A109 · Penobscot, ME · Incident · No injuries · Class 3 · Incident · Final report · Nov 16, 2019 · N901EM · Minor damage
  > Fatigue fracture of the main rotor blade tip cap leading edge and subsequent partial separation of the tip cap, resulting in increased vibrations in the main rotor.
- [NTSB ERA20LA039](https://openairdocs.org/ntsb/ERA20LA039.md): Rans Rans S7 Courier · West Liberty, KY · Accident · No injuries · Class 3 · Limited · Final report · Nov 15, 2019 · N831RS · Substantial damage
  > The pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…
- [NTSB WPR20LA029](https://openairdocs.org/ntsb/WPR20LA029.md): Agusta A109 · Salt Lake City, UT · Accident · No injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N271HC · Substantial damage
  > The flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.
- [NTSB WPR20WA021](https://openairdocs.org/ntsb/WPR20WA021.md): Robinson R44 · Tunis, Tunisia · Accident · 1 fatal · Foreign investigation · Nov 11, 2019 · TS-HAE · Destroyed
  > The government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…
- [NTSB WPR20LA028](https://openairdocs.org/ntsb/WPR20LA028.md): Cessna 182 · Metaline, WA · Accident · 1 fatal · Class 3 · Limited · Final report · Nov 11, 2019 · N8749T · Destroyed
  > Impact with a lake for reasons that could not be determined.

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

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

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