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

## Cases, newest first

- [NTSB ERA20LA305](https://openairdocs.org/ntsb/ERA20LA305.md): Piper PA20 · Luray, VA · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 31, 2020 · N7323K · Destroyed
  > The noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.
- [NTSB ERA20LA297](https://openairdocs.org/ntsb/ERA20LA297.md): Rockwell 500 · Pembroke Park, FL · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 28, 2020 · N900DT · Destroyed
  > A total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.
- [NTSB DCA20WA141](https://openairdocs.org/ntsb/DCA20WA141.md): Boeing 737 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Aug 24, 2020 · N806NN · No damage
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…
- [NTSB CEN20LA361](https://openairdocs.org/ntsb/CEN20LA361.md): Cessna R182 · Crowley, LA · Accident · No injuries · Class 3 · Limited · Final report · Aug 24, 2020 · N639RR · Substantial damage
  > The failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.
- [NTSB ERA20LA295](https://openairdocs.org/ntsb/ERA20LA295.md): Aeronca 11AC · Nebo, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 22, 2020 · N86002 · Substantial damage
  > A leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN20LA360](https://openairdocs.org/ntsb/CEN20LA360.md): Cessna 180 · St Louis, MO · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 22, 2020 · N7620A · Substantial damage
  > A total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.
- [NTSB CEN20WA434](https://openairdocs.org/ntsb/CEN20WA434.md): Raytheon Hawker · Le Bourget, France · Incident · Class 5 · Foreign · Aug 21, 2020 · F-HREX · No damage
- [NTSB CEN20LA354](https://openairdocs.org/ntsb/CEN20LA354.md): Lancair Lancair Super ES · Ely, MN · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 21, 2020 · N997S · Destroyed
  > The non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.
- [NTSB WPR21WA103](https://openairdocs.org/ntsb/WPR21WA103.md): Cessna 150 · Kenitra, Morocco · Accident · Class 5 · Foreign · Aug 20, 2020 · CN-TCG · Substantial damage
- [NTSB ERA20LA289](https://openairdocs.org/ntsb/ERA20LA289.md): Cessna 150 · Surry, ME · Accident · No injuries · Class 3 · Limited · Final report · Aug 17, 2020 · N45083 · Substantial damage
  > The pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.
- [NTSB WPR20CA273](https://openairdocs.org/ntsb/WPR20CA273.md): Schweizer SGS233 · Warner Springs, CA · Accident · No injuries · Class 4 · Data collection · Final report · Aug 14, 2020 · N7547 · Substantial damage
  > The pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.
- [NTSB CEN20LA342](https://openairdocs.org/ntsb/CEN20LA342.md): Siebel Auriga · Rockford, IL · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 14, 2020 · N505JS · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on available information.
- [NTSB CEN20CA335](https://openairdocs.org/ntsb/CEN20CA335.md): Cirrus SR22 · Lafayette, IN · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 11, 2020 · N678EC · No damage
  > The pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.
- [NTSB WPR20LA259](https://openairdocs.org/ntsb/WPR20LA259.md): Rutan Vari EZE · Kelso Valley, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 9, 2020 · N2ZE · Destroyed
  > The pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB GAA20WA129](https://openairdocs.org/ntsb/GAA20WA129.md): Hawker SEA Fury · Button End, Harston, Cambridgeshire, United Kingdom · Accident · No injuries · Foreign investigation · Aug 8, 2020 · G-INVN · Substantial damage
  > The government of United Kingdom has notified the NTSB of an accident involving a HAWKER SEA FURY airplane that occurred on August 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…
- [NTSB CEN20WA376](https://openairdocs.org/ntsb/CEN20WA376.md): Canadair CL215 1A10 · Lobios (Ourense), Portugal · Accident · 1 fatal · Foreign investigation · Aug 8, 2020 · EC-HET · Substantial damage
  > The Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…
- [NTSB ERA20LA275](https://openairdocs.org/ntsb/ERA20LA275.md): Piper PA25 · Miami, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 5, 2020 · N223AB · Substantial damage
  > A total loss of engine power due to carburetor ice that was not detected by the pilot.
- [NTSB GAA20WA128](https://openairdocs.org/ntsb/GAA20WA128.md): Rans S6 · Heathfield East Sussex, United Kingdom · Accident · 1 fatal · Foreign investigation · Aug 4, 2020 · G-BUWK · Destroyed
  > The government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…
- [NTSB WPR20CA262](https://openairdocs.org/ntsb/WPR20CA262.md): Head AX8 88 · Jackson, WY · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 3, 2020 · N45303 · Minor damage
  > The balloon pilot’s inability to maintain altitude during un-forecasted weather, which resulted in a hard landing.
- [NTSB WPR20LA249](https://openairdocs.org/ntsb/WPR20LA249.md): North American Navion · Cedar City, UT · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 2, 2020 · N225HJ · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s improper fuel planning and failure to see and avoid the communications tower support guy wire.
- [NTSB CEN20LA322](https://openairdocs.org/ntsb/CEN20LA322.md): Quad City Challenger · Jonesboro, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 2, 2020 · N990SS · Substantial damage
  > Loss of engine power due to the use of improper fuel in the airplane by the non-certificated pilot.
- [NTSB ANC20LA074](https://openairdocs.org/ntsb/ANC20LA074.md): De Havilland DHC-2 · Soldotna, AK · Accident · 7 fatal · Class 3 · Limited · Final report · Jul 31, 2020 · N4982U · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane. Contributing to the accident were (1) the PA-12 pilot’s decision to fly with a known severe vision deficiency that had resulted in denial of his most recent application for medical certification…
- [NTSB WPR20LA246](https://openairdocs.org/ntsb/WPR20LA246.md): Air Tractor AT802 · Elgin, NV · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 30, 2020 · N8510M · 2 aircraft · Destroyed
  > The trailing pilot’s failure to maintain separation from the lead airplane during a fire retardant deployment flight, which resulted in the trailing airplane flying through a plume of retardant and the trailing pilot’s subsequent loss of visibility that led…
- [NTSB GAA20WA125](https://openairdocs.org/ntsb/GAA20WA125.md): Cessna R172 · Tarapaca-Amazonas, Colombia · Accident · 1 fatal · Foreign investigation · Jul 30, 2020 · HK2129 · Destroyed
- [NTSB WPR20LA244](https://openairdocs.org/ntsb/WPR20LA244.md): American Eurocopter AS350 · Pioche, NV · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 29, 2020 · N755AE · Destroyed
  > The pilot’s failure to maintain altitude from terrain and subsequent loss of helicopter control due to entanglement of the external load cable with the tail rotor.
- [NTSB ERA20LA262](https://openairdocs.org/ntsb/ERA20LA262.md): Beech F33 · Malbis, AL · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 29, 2020 · N3156W · Substantial damage
  > The noninstrument-rated pilot’s decision to depart in deteriorating weather conditions, which led to restricted visibility and the pilot’s loss of airplane control due to spatial disorientation. Contributing to the pilot’s poor decision-making was…
- [NTSB CEN20LA314](https://openairdocs.org/ntsb/CEN20LA314.md): Piper PA28R · Houston, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 28, 2020 · N15302 · Substantial damage
  > The loss of engine power for a reason that could not be determined based on available evidence.
- [NTSB ANC20WA073](https://openairdocs.org/ntsb/ANC20WA073.md): Cessna 140 · Abbotsford, Canada · Accident · 1 fatal · Foreign investigation · Jul 28, 2020 · C-GOFK
  > The government of Canada has notified the NTSB of an accident involving a CESSNA 140 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…
- [NTSB GAA20WA126](https://openairdocs.org/ntsb/GAA20WA126.md): Cessna 172 · Blatten - VS, Switzerland · Accident · 4 fatal · Foreign investigation · Jul 25, 2020 · HB-TLF · Destroyed
  > The government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…
- [NTSB ERA20LA261](https://openairdocs.org/ntsb/ERA20LA261.md): Cessna 177RG · Salinas, PR · Accident · No injuries · Class 3 · Limited · Final report · Jul 24, 2020 · N1813Q · Substantial damage
  > Contamination and corrosion within the fuel system that resulted in a blockage, starvation of fuel to the engine, and the total loss of engine power.
- [NTSB WPR20LA234](https://openairdocs.org/ntsb/WPR20LA234.md): Montana Coyote · Jamul, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2020 · N125MC · Substantial damage
  > A total loss of engine power due to an obstructed fuel line and fuel starvation, which resulted in a forced landing and collision with a fence. Contributing to the accident was the long duration of aircraft storage that allowed for contaminants to develop and…
- [NTSB WPR20WA241](https://openairdocs.org/ntsb/WPR20WA241.md): Cessna 441 · Djugun, Australia · Incident · No injuries · Foreign investigation · Jul 22, 2020 · VH-LBY · Minor damage
  > The government of Australia has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on July 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…
- [NTSB CEN20LA301](https://openairdocs.org/ntsb/CEN20LA301.md): Vans RV4 · Idabel, OK · Accident · No injuries · Class 3 · Limited · Final report · Jul 22, 2020 · N54WP · Substantial damage
  > The pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.
- [NTSB CEN20CA303](https://openairdocs.org/ntsb/CEN20CA303.md): Stearman N2S 3 · Jacksonville, AR · Accident · No injuries · Class 4 · Data collection · Final report · Jul 22, 2020 · N2158P · Substantial damage
  > The pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA20LA258](https://openairdocs.org/ntsb/ERA20LA258.md): Cessna 182 · Pottstown, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2020 · N4092D · Substantial damage
  > The pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA20WA118](https://openairdocs.org/ntsb/GAA20WA118.md): Robinson R44 · Thorburn Lake, Canada · Accident · 1 fatal · Foreign investigation · Jul 20, 2020 · C-FPBL · Substantial damage
  > The government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…
- [NTSB CEN20LA292](https://openairdocs.org/ntsb/CEN20LA292.md): Beech A23-24 · Burns Flat, OK · Accident · No injuries · Class 3 · Limited · Final report · Jul 19, 2020 · N3412C · Substantial damage
  > The mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.
- [NTSB CEN20LA291](https://openairdocs.org/ntsb/CEN20LA291.md): Cessna 140 · Arlington, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2020 · N140AB · Substantial damage
  > The pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.
- [NTSB CEN20LA290](https://openairdocs.org/ntsb/CEN20LA290.md): Piper PA22 · Loveland, OH · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2020 · N4816A · Substantial damage
  > The loss of engine power due to fuel starvation
- [NTSB ENG20WA039](https://openairdocs.org/ntsb/ENG20WA039.md): Hawker Siddeley HS125 · Port Harcourt, Nigeria · Incident · No injuries · Foreign investigation · Jul 16, 2020 · 5N-BOO
  > On July 16, 2020 a Hawker-Siddeley (Textron Aviation), powered by two Honeywell TFE731 5R-1H turbofan engines experienced a No. 1 (left engine) audible fire warning during cruise. The flight crew declared an emergency and made an uneventful landing at Port…
- [NTSB CEN20LA288](https://openairdocs.org/ntsb/CEN20LA288.md): Beech 36 · Independence, MO · Accident · No injuries · Class 3 · Limited · Final report · Jul 16, 2020 · N630JL · Substantial damage
  > Failure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.
- [NTSB WPR20LA223](https://openairdocs.org/ntsb/WPR20LA223.md): Piper PA 30 · Vaughn, NM · Accident · No injuries · Class 3 · Limited · Final report · Jul 15, 2020 · N8488Y · Substantial damage
  > The total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.
- [NTSB DCA20WA131](https://openairdocs.org/ntsb/DCA20WA131.md): Boeing 737 · Durban, South Africa · Accident · Serious injuries · Foreign investigation · Jul 14, 2020 · ZS-SJB · No damage
  > The CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…
- [NTSB ERA20LA245](https://openairdocs.org/ntsb/ERA20LA245.md): Cessna 177 · Falmouth, KY · Accident · No injuries · Class 3 · Limited · Final report · Jul 12, 2020 · N30309 · Substantial damage
  > The pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB DCA20WA132](https://openairdocs.org/ntsb/DCA20WA132.md): Boeing 737 · Tijuana, Mexico · Incident · No injuries · Foreign investigation · Jul 11, 2020 · XA-MCG · No damage
  > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC of Mexico's investigation under the provisions of ICAO Annex…
- [NTSB CEN20WA293](https://openairdocs.org/ntsb/CEN20WA293.md): Cessna FR172 · Galway, Ireland · Accident · Serious injuries · Foreign investigation · Jul 11, 2020 · EI-EZU · Destroyed
  > The government of the Ireland has notified the NTSB of an accident involving a Cessna FR172K airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…
- [NTSB CEN20LA279](https://openairdocs.org/ntsb/CEN20LA279.md): Air Tractor AT502 · Dalhart, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 10, 2020 · N61315 · Substantial damage
  > The total loss of engine power due to a failed fuel control unit bearing.
- [NTSB DCA20CA122](https://openairdocs.org/ntsb/DCA20CA122.md): Embraer ERJ170 · Plainfield, IL · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 9, 2020 · N226NN · No damage
  > an encounter with convective turbulence.
- [NTSB GAA20WA121](https://openairdocs.org/ntsb/GAA20WA121.md): Beech 58 · Sao Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jul 8, 2020 · PR-OFI · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…
- [NTSB WPR20LA211](https://openairdocs.org/ntsb/WPR20LA211.md): Bell UH1H · Payson, AZ · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 7, 2020 · N623PB · Destroyed
  > A flight control malfunction due to either a hydraulic hardover or a flight control stiffness event, which resulted in a loss of control.

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

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

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