# 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 161 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CHI02FA042](https://openairdocs.org/ntsb/CHI02FA042.md): Mooney M20M · Evansville, IN · Accident · 2 fatal · Field investigation · Final report · Nov 27, 2001 · N7775L · Destroyed
  > The fatigue failure of the turbocharger exhaust band clamp and aircraft control not possible by the pilot due to the fire.
- [NTSB MIA02LA034](https://openairdocs.org/ntsb/MIA02LA034.md): Cessna 310C · Reidsville, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2001 · N1840H · Destroyed
  > Improper fuel management by the pilot resulting in loss of power in both engines, and the pilots lowering of the landing gear prior to having the runway made resulting in a hard landing short of the runway.
- [NTSB MIA02LA027](https://openairdocs.org/ntsb/MIA02LA027.md): Mooney M-20-20 · Hilton Head, SC · Accident · 2 fatal · Limited investigation · Final report · Nov 22, 2001 · N5217B · Destroyed
  > The pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control, an uncontrolled descent, and an impact with the water.
- [NTSB FTW02LA042](https://openairdocs.org/ntsb/FTW02LA042.md): Cessna 152 · New Braunfels, TX · Accident · No injuries · Limited investigation · Final report · Nov 22, 2001 · N48941 · Substantial damage
  > the loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.
- [NTSB FTW02FA040](https://openairdocs.org/ntsb/FTW02FA040.md): Piper PA-28-160 · Ben Wheeler, TX · Accident · 1 fatal · Field investigation · Final report · Nov 22, 2001 · N6321W · Destroyed
  > The pilot's failure to maintain aircraft control for undetermined reasons.
- [NTSB NYC02LA033](https://openairdocs.org/ntsb/NYC02LA033.md): Cessna 182 · Brookville, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2001 · N24KA · Substantial damage
  > Fouling of the engine intake and exhaust valves with bromine and lead deposits.
- [NTSB NYC02FA032](https://openairdocs.org/ntsb/NYC02FA032.md): Beech 95-B55 · Falmouth, MA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 2001 · N3847Q · Destroyed
  > The incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.
- [NTSB MIA02LA030](https://openairdocs.org/ntsb/MIA02LA030.md): Beech A36 · Milton, FL · Accident · No injuries · Limited investigation · Final report · Nov 21, 2001 · N1836L · Substantial damage
  > the pilot's failure to properly manage the available fuel in all fuel tanks, which resulted in the loss of engine power due to fuel starvation, a forced landing, and damage to the aircraft when the proper touch down point was not attained.
- [NTSB LAX02FA031](https://openairdocs.org/ntsb/LAX02FA031.md): Aero Commander 500S · Eagleville, CA · Accident · 5 fatal · Field investigation · Final report · Nov 21, 2001 · N900RA · Destroyed
  > the pilot's encounter with forecast mountain wave conditions, moderate or greater turbulence, and icing, with downdrafts that likely exceeded the climb capability of the airplane, which was encountered at an altitude that precluded recovery. Also causal in…
- [NTSB MIA02LA025](https://openairdocs.org/ntsb/MIA02LA025.md): Piper PA-24-250 · Evans, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 2001 · N6688P · Substantial damage
  > The pilot's improper fuel management and failure switch to the other fuel tank which had fuel available prior to the engine ceasing to operate, which resulted in fuel starvation and damage to the airplane during an off-airport landing.
- [NTSB MIA02LA021](https://openairdocs.org/ntsb/MIA02LA021.md): Ercoupe 415-C · Southern Pines, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N99236 · Substantial damage
  > The dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.
- [NTSB MIA02LA020](https://openairdocs.org/ntsb/MIA02LA020.md): Mooney M20C · High Springs, FL · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N6753U · Substantial damage
  > The pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…
- [NTSB CHI02LA041](https://openairdocs.org/ntsb/CHI02LA041.md): Cessna 152 · Sedalia, MO · Accident · No injuries · Limited investigation · Final report · Nov 18, 2001 · N48285 · Substantial damage
  > The pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.
- [NTSB MIA02LA018](https://openairdocs.org/ntsb/MIA02LA018.md): Beech P35 · Belle Glade, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2001 · N9754Y · Substantial damage
  > The loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.
- [NTSB CHI02FA034](https://openairdocs.org/ntsb/CHI02FA034.md): Piper PA-32R-301 · Spearville, KS · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2001 · N9224X · Destroyed
  > the pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.
- [NTSB MIA02LA017](https://openairdocs.org/ntsb/MIA02LA017.md): Piper PA-24-250 · Peachtree City, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2001 · N8183P · Substantial damage
  > The pilot’s attempted operation of the aircraft with known deficiencies in the engine ignition system resulting in failure of the engine due to ignition system failure and damage to the airplane during the subsequent forced landing.
- [NTSB MIA02FA032](https://openairdocs.org/ntsb/MIA02FA032.md): Cessna 152 · Poplarville, MS · Accident · 1 fatal · Field investigation · Final report · Nov 16, 2001 · N89645 · Destroyed
  > The pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…
- [NTSB CHI02FA033](https://openairdocs.org/ntsb/CHI02FA033.md): Zenair CH2000 · Wentzville, MO · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2001 · N33ZA · Destroyed
  > The improper selection of the fuel selector which resulted in fuel starvation and subsequent engine failure. Factors were the unsuitable terrain for the forced landing encountered by the pilot and the night light condition.
- [NTSB SEA02LA014](https://openairdocs.org/ntsb/SEA02LA014.md): Bölkow BO 105 LS · Mud Lake, ID · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 2001 · N93LF · Destroyed
  > Pilot's failure to maintain adequate separation from terrain during the initial climb. Factors include spatial disorientation and a dark moonless night.
- [NTSB FTW02LA032](https://openairdocs.org/ntsb/FTW02LA032.md): Aero Commander 200D · Houston, TX · Accident · No injuries · Limited investigation · Final report · Nov 13, 2001 · N28PC · Substantial damage
  > the failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.
- [NTSB NYC02TA026](https://openairdocs.org/ntsb/NYC02TA026.md): Bell 407 · Whitley City, KY · Accident · Serious injuries · Final report · Nov 12, 2001 · N11HX · Substantial damage
  > The pilots decision to operate the helicopter at an airspeed in excess of the maximum demonstrated stable airspeed for the water bucket. A factor in the accident was the pilot did not follow the published emergency procedure.
- [NTSB NYC02FA025](https://openairdocs.org/ntsb/NYC02FA025.md): Piper PA-28-180 · Mansfield, OH · Accident · 1 fatal · Field investigation · Final report · Nov 12, 2001 · N3672R · Destroyed
  > the pilot's improper use of carburetor heat, and subsequent forced landing. Factors were the carburetor icing condition, night conditions, trees, and the pilot's impairment from ingestion of an over-the-counter antihistamine.
- [NTSB NYC02LA028](https://openairdocs.org/ntsb/NYC02LA028.md): Piper PA-28R-200 · Cattaraugus, NY · Accident · No injuries · Limited investigation · Final report · Nov 11, 2001 · N3057R · Substantial damage
  > A separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.
- [NTSB FTW02LA033](https://openairdocs.org/ntsb/FTW02LA033.md): Bell 407 · Erath, LA · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N517R · Substantial damage
  > The pilot's inadvertant application of full right pedal which resulted in the baggage compartment door to open in-flight and a tie down rope to become entangled in the tail rotor drive system, and the failure of the tail rotor drive shaft resulting in the…
- [NTSB CHI02LA026](https://openairdocs.org/ntsb/CHI02LA026.md): Cessna 182A · Wahoo, NE · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 2001 · N3916D · Substantial damage
  > The pilot's inadequate preflight planning/preparation resulting in fuel exhaustion during cruise flight, and the unsuitable terrain for landing encountered by the pilot during the subsequent forced landing. Factors relating to the accident were the pilot's…
- [NTSB SEA02LA012](https://openairdocs.org/ntsb/SEA02LA012.md): Thurston Pitts S-1S · Eatonville, WA · Accident · 1 fatal · Limited investigation · Final report · Nov 9, 2001 · N3VT · Substantial damage
  > The pilot's unsuccessful corrective action (recovery) from an inverted spin. A contributing factor was the pilot's encounter with the inverted spin maneuver.
- [NTSB DEN02TA011](https://openairdocs.org/ntsb/DEN02TA011.md): Cessna 206 · Casper, WY · Accident · No injuries · Final report · Nov 9, 2001 · N9582G · Substantial damage
  > failure to maintain aircraft control during landing. Contributing factors were the crosswind and gusting wind conditions.
- [NTSB CHI02LA023](https://openairdocs.org/ntsb/CHI02LA023.md): Taylorcraft F19 · Backus, MN · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 2001 · N20002 · Substantial damage
  > The pilot's improper preflight planning/preparation, and his continued flight into known adverse weather conditions. Factors relating to the accident were the pilot becoming lost/disoriented in the weather, visual lookout by the pilot during the descent not…
- [NTSB SEA02FA009](https://openairdocs.org/ntsb/SEA02FA009.md): Cessna 175C · Miles City, MT · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2001 · N8347T · Substantial damage
  > The separation of the number four cylinder exhaust valve guide from the cylinder head, leading to the failure of the exhaust valve stem and the catastrophic failure of the engine while in cruise flight. Factors include the necessity of attempting a forced…
- [NTSB LAX02LA022](https://openairdocs.org/ntsb/LAX02LA022.md): Piper PA-32-260 · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Nov 4, 2001 · N3516W · Substantial damage
  > the total loss of engine power during departure climb for undetermined reasons.
- [NTSB NYC02LA021](https://openairdocs.org/ntsb/NYC02LA021.md): Piper PA-22-108 · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Nov 3, 2001 · N5207Z · Substantial damage
  > The failure of the pilot ensure the proper position of the fuel selector which resulted in fuel starvation. Factors were the improper placement of the fuel selector valve tank index, and the improper in-flight decision of the pilot to change tanks in…
- [NTSB IAD02LA009](https://openairdocs.org/ntsb/IAD02LA009.md): Schleicher ASW-19 · Jersey Shore, PA · Accident · No injuries · Limited investigation · Final report · Nov 3, 2001 · N19KH · Substantial damage
  > The pilot's in-flight encounter with weather, which led to a forced landing to unsuitable terrain.
- [NTSB FTW02IA027](https://openairdocs.org/ntsb/FTW02IA027.md): Airbus Industrie A319-132 · Midland, TX · Incident · No injuries · Incident investigation · Final report · Nov 2, 2001 · N814AW · No damage
  > the #1 engine's fatigue failure of the #3 bearing due to the manufacturer's inadequate design of the high-pressure compressor stubshaft coating, which resulted in a loss of engine power and an emergency landing.
- [NTSB LAX02FA018](https://openairdocs.org/ntsb/LAX02FA018.md): Cessna P210N · Mt. Charleston, NV · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2001 · N734VM · Destroyed
  > the pilot's failure to maintain an adequate airspeed after continuing flight into forecast adverse meteorological conditions consisting of turbulence, icing, and downdrafts, which resulted in a stall/spin.
- [NTSB LAX02LA015](https://openairdocs.org/ntsb/LAX02LA015.md): Thomson Harmon Rocket II · Perris, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 2001 · N325L · Substantial damage
  > the airplane builder's failure to properly install a bolt and nut into the aileron and elevator flight control system. A contributing factor was the soft terrain conditions for the ensuing forced landing.
- [NTSB FTW02LA074](https://openairdocs.org/ntsb/FTW02LA074.md): Beech 58 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Oct 26, 2001 · N8117V · Substantial damage
  > The failure of the nose gear actuator retract arm due to fatigue.
- [NTSB FTW02LA021](https://openairdocs.org/ntsb/FTW02LA021.md): Cessna 152 · Bethany, OK · Accident · No injuries · Limited investigation · Final report · Oct 26, 2001 · N67797 · Substantial damage
  > the mechanic's failure to properly lock the exhaust valve's clearance adjusting screw locknut, which resulted in a loose nut, disabling of the exhaust valve pushrod, and a partial loss of engine power while in cruise flight. A contributing factor was the…
- [NTSB ATL02LA004](https://openairdocs.org/ntsb/ATL02LA004.md): Piper PA-28-181 · Brunswick, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 2001 · N4149D · Substantial damage
  > The pilot's improper inflight planning which resulted in fuel exhaustion, and subsequent loss of engine power. A factor was the none suitable terrain.
- [NTSB LAX02LA012](https://openairdocs.org/ntsb/LAX02LA012.md): Cessna 152 · Henderson, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 2001 · N67729 · Substantial damage
  > Fuel exhaustion during cruise flight due to the pilot's improper in-flight decision. A contributing factor was his improper preflight planning.
- [NTSB NYC02LA014](https://openairdocs.org/ntsb/NYC02LA014.md): Nicolosi Challenger II · Midland, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 2001 · N843C · Destroyed
  > Loss of engine power for an undetermined reason.
- [NTSB ATL02FA003](https://openairdocs.org/ntsb/ATL02FA003.md): Bell 206B · N. Wilkesboro, NC · Accident · 2 fatal · Field investigation · Final report · Oct 22, 2001 · N8104J · Destroyed
  > The pilot's failure to maintain visual lookout and clearance above obstacles, which resulted in a collision with power lines and subsequent loss of control and collision with terrain.
- [NTSB LAX02LA010](https://openairdocs.org/ntsb/LAX02LA010.md): Rhoades Jodel D-9 · Waialua, HI · Accident · 1 fatal · Limited investigation · Final report · Oct 21, 2001 · N43RR · Substantial damage
  > Loss of engine power for unknown reasons. A factor was the inadvertent stall the pilot encountered while maneuvering to make a forced landing in an open taro field.
- [NTSB IAD02LA005](https://openairdocs.org/ntsb/IAD02LA005.md): Aerostar SA-60A · Luxor, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 2001 · N63069 · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion, and his subsequent inability to avoid power lines.
- [NTSB SEA02FA008](https://openairdocs.org/ntsb/SEA02FA008.md): Bell 206L · Anchorage, AK · Accident · 3 fatal · Field investigation · Final report · Oct 18, 2001 · N400EH · Substantial damage
  > The pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…
- [NTSB FTW02LA019](https://openairdocs.org/ntsb/FTW02LA019.md): Bell 206L-3 · East Cameron 78 · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 2001 · N348AL · Substantial damage
  > The hard landing due to the pilot's failure to maintain proper main rotor rpm. Contributing factors were the loss of engine power for undetermined reasons, and the pilot's failure to deploy the emergency floats.
- [NTSB SEA02FA007](https://openairdocs.org/ntsb/SEA02FA007.md): Cessna TR182 · Dixie, ID · Accident · 2 fatal · Field investigation · Final report · Oct 17, 2001 · N756CE · Destroyed
  > The pilot's failure to refuel en route resulting in fuel exhaustion, and his inadvertent entry into a stall condition during the emergency descent. Contributing factors were dark night conditions and mountainous/hilly terrain.
- [NTSB NYC02LA008](https://openairdocs.org/ntsb/NYC02LA008.md): Aerospatiale ATR 42-320 · Yardley, PA · Accident · No injuries · Limited investigation · Final report · Oct 13, 2001 · N34820 · Substantial damage
  > an in flight collision with birds.
- [NTSB FTW02LA014](https://openairdocs.org/ntsb/FTW02LA014.md): Aerostar Raven S57-A · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 2001 · N3636Z · Substantial damage
  > inadvertent flight into adverse (high wind) weather conditions, which resulted in an inflight collision with objects while landing. A contributing factor was the high wind weather condition.
- [NTSB CHI02LA005](https://openairdocs.org/ntsb/CHI02LA005.md): Cessna 182N · Graham, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 2001 · N92913 · Substantial damage
  > A loss of engine power due to the fatigue failure of the number 2 piston. Contributing to the accident was the unsuitable terrain.
- [NTSB MIA02LA008](https://openairdocs.org/ntsb/MIA02LA008.md): Cessna T206H · LakeLanier Isl., GA · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 2001 · N919LL · Substantial damage
  > The fatigue failure of the crankshaft for undetermined reasons resulting in the total loss of engine power. A contributing factor in the accident was the unsuitable terrain encountered by the pilot during the forced landing.

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

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

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