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

## Cases, newest first

- [NTSB MIA97IA151](https://openairdocs.org/ntsb/MIA97IA151.md): Beech 100 · Kenly, NC · Incident · No injuries · Incident investigation · Final report · Apr 5, 1997 · N402G · Minor damage
  > Inadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.
- [NTSB MIA97LA113](https://openairdocs.org/ntsb/MIA97LA113.md): Chance Vought F4U · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · Apr 4, 1997 · N45NL · Substantial damage
  > The pilot's failure to assure that an adequate supply of fuel was on board for the intended flight.
- [NTSB MIA97LA118](https://openairdocs.org/ntsb/MIA97LA118.md): Cessna 210M · Troy, AL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1997 · N761VX · Substantial damage
  > The pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.
- [NTSB LAX97FA143](https://openairdocs.org/ntsb/LAX97FA143.md): Cessna T210N · Grand Canyon, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 3, 1997 · N6172C · Destroyed
  > The pilot's failure to maintain aircraft control due to spatial disorientation and his lack of proficiency in conducting instrument flight. Contributing were the inoperative alternator, cockpit lighting, and vacuum system.
- [NTSB IAD97LA056](https://openairdocs.org/ntsb/IAD97LA056.md): Cessna 150 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1997 · N3616J · Substantial damage
  > the student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.
- [NTSB CHI97LA097](https://openairdocs.org/ntsb/CHI97LA097.md): Piper PA-28-235 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1997 · N9004W · Substantial damage
  > oil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.
- [NTSB IAD97FA060](https://openairdocs.org/ntsb/IAD97FA060.md): Cessna 337D · Hickory, PA · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1997 · N2685S · Destroyed
  > Servicing of the pilots portable oxygen system with compressed air, which resulted in pilot incapacitation due to Hypoxia.
- [NTSB ATL97LA053](https://openairdocs.org/ntsb/ATL97LA053.md): Catchot Hauler · Centerville, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1997 · N301A · Substantial damage
  > the engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.
- [NTSB LAX97LA137](https://openairdocs.org/ntsb/LAX97LA137.md): Piper PA-28R-200 · Continental, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1997 · N2226T · Substantial damage
  > loss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.
- [NTSB LAX97FA142](https://openairdocs.org/ntsb/LAX97FA142.md): Cessna P210N · Corona, CA · Accident · 2 fatal · Field investigation · Final report · Mar 31, 1997 · N3894P · Destroyed
  > The pilot's failure to maintain adequate terrain clearance during a nighttime flight at low altitude through a mountainous area. Factors in the accident were the conditions of low clouds and dark light conditions.
- [NTSB NYC97LA066](https://openairdocs.org/ntsb/NYC97LA066.md): Lowe Super Koala · Perry Township, PA · Accident · 2 fatal · Limited investigation · Final report · Mar 30, 1997 · N4424V · Substantial damage
  > improper construction by the builder which led to the failure of the strut and wing assembly.
- [NTSB MIA97LA109](https://openairdocs.org/ntsb/MIA97LA109.md): Piper PA-32-260 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Mar 30, 1997 · N576PR · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident was: the pilot's poor in-flight planning/decision by flying at too low of an altitude to glide to shore for a forced landing.
- [NTSB MIA97LA106](https://openairdocs.org/ntsb/MIA97LA106.md): Piper PA22-150 · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1997 · N3201Z · Substantial damage
  > a loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.
- [NTSB LAX97LA134](https://openairdocs.org/ntsb/LAX97LA134.md): Bellanca 14-13 · Oroville, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1997 · N86851 · Substantial damage
  > a loss of engine power due to connecting rod bolt failure. The reason for the bolt failure was not determined. A contributing factor was the presence of trees in the emergency landing path.
- [NTSB FTW97LA146](https://openairdocs.org/ntsb/FTW97LA146.md): Beech G33 · Bixby, OK · Accident · No injuries · Limited investigation · Final report · Mar 28, 1997 · N166B · Substantial damage
  > failure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.
- [NTSB SEA97FA076](https://openairdocs.org/ntsb/SEA97FA076.md): Cessna 172P · Burlington, WY · Accident · 1 fatal · Field investigation · Final report · Mar 26, 1997 · N97527 · Destroyed
  > loss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.
- [NTSB FTW97LA141](https://openairdocs.org/ntsb/FTW97LA141.md): Piper PA-17 · N Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Mar 26, 1997 · N4802H · Substantial damage
  > loss of engine power due to failure of the crankshaft. A factor relating to the accident was: the lack of suitable terrain for the forced landing.
- [NTSB ATL97LA055](https://openairdocs.org/ntsb/ATL97LA055.md): Dassault Falcon 900B · Chamblee, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 26, 1997 · N332MC · No damage
  > an encounter with clear air turbulence, which led to injury of the flight attendant. A factor associated with the accident was: that the flight attendant was not being restrained by a seat belt.
- [NTSB ATL97FA054](https://openairdocs.org/ntsb/ATL97FA054.md): Beech V35 · Marco Island, FL · Accident · 3 fatal · Field investigation · Final report · Mar 25, 1997 · N9049S · Destroyed
  > inadvertent flight by the pilot into adverse weather conditions (severe thunderstorms), which led the design stress limits of the airplane being exceeded, subsequent in-flight break-up of the airplane, and an uncontrolled collision with water.
- [NTSB ANC97FA037](https://openairdocs.org/ntsb/ANC97FA037.md): Short Brothers SC7 · Nunapitchuk, AK · Accident · 2 fatal · Field investigation · Final report · Mar 25, 1997 · N451SA · 2 aircraft · Destroyed
  > inadequate visual look-out by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplanes.
- [NTSB SEA97FA075](https://openairdocs.org/ntsb/SEA97FA075.md): Cessna T210L · Dillon, MT · Accident · 4 fatal · Field investigation · Final report · Mar 23, 1997 · N22219 · Destroyed
  > flight by the pilot into adverse weather conditions, and his failure to maintaint altitude/clearance from terrain. The adverse weather condition was a related factor.
- [NTSB NYC97LA061](https://openairdocs.org/ntsb/NYC97LA061.md): Piper PA-24-250 · Bowling Green, OH · Accident · No injuries · Limited investigation · Final report · Mar 23, 1997 · N6561P · Substantial damage
  > the pilot's improper planning/decision, which resulted in airframe ice and the loss of adequate lift to maintain continued flight. The adverse weather (icing) condition was a related factor.
- [NTSB LAX97LA131](https://openairdocs.org/ntsb/LAX97LA131.md): Zenair 601 · Penn Valley, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 23, 1997 · N4073T · Destroyed
  > Loss of engine power for undetermined reasons. Factors in the accident were the pilot's lack of recent experience, lack of experience in the type aircraft, and physical impairment due to drugs.
- [NTSB MIA97LA126](https://openairdocs.org/ntsb/MIA97LA126.md): Socata TB-21C · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Mar 21, 1997 · N55510 · Substantial damage
  > continued flight by the pilot into adverse weather conditions, and the pilot allowing the aircraft to exceed its design stress limits. Weather associated with the thunderstorm was a related factor.
- [NTSB LAX97LA129](https://openairdocs.org/ntsb/LAX97LA129.md): Cessna 150L · Nogales, AZ · Accident · No injuries · Limited investigation · Final report · Mar 21, 1997 · N21993 · Substantial damage
  > Loss of engine power due to fuel contamination resulting from the pilot's inadequate fuel storage and filtering procedures.
- [NTSB FTW97LA142](https://openairdocs.org/ntsb/FTW97LA142.md): Cessna T210L · Durango, CO · Accident · No injuries · Limited investigation · Final report · Mar 21, 1997 · N613CW · Substantial damage
  > the pilot's improper planning/decision, and failure to ensure there was sufficient fuel aboard for the flight, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a successful…
- [NTSB ANC97LA046](https://openairdocs.org/ntsb/ANC97LA046.md): Beech G18S · Nome, AK · Accident · No injuries · Limited investigation · Final report · Mar 21, 1997 · N555CG · Substantial damage
  > fracture of a propeller blade tip.
- [NTSB IAD97GA054](https://openairdocs.org/ntsb/IAD97GA054.md): Schweizer 269C · Cleveland, OH · Accident · No injuries · Final report · Mar 20, 1997 · N892CP · Substantial damage
  > The engine failure from the rod cap bolt being sheared and the separation of the number two cylinder separating from the crankcase.
- [NTSB FTW97FA130](https://openairdocs.org/ntsb/FTW97FA130.md): Cessna 421 · League City, TX · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1997 · N4050L · Substantial damage
  > The pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.
- [NTSB CHI97LA088](https://openairdocs.org/ntsb/CHI97LA088.md): Cessna 150J · La Valle, WI · Accident · No injuries · Limited investigation · Final report · Mar 20, 1997 · N5526G · Substantial damage
  > the pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.
- [NTSB FTW97LA129](https://openairdocs.org/ntsb/FTW97LA129.md): Piper PA-28-140B · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Mar 19, 1997 · N98150 · Substantial damage
  > a total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.
- [NTSB FTW97LA123](https://openairdocs.org/ntsb/FTW97LA123.md): Cessna 172 · Manchaca, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1997 · N6320E · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain obstacle clearance. A factor was the weather condition.
- [NTSB FTW97LA125](https://openairdocs.org/ntsb/FTW97LA125.md): Piper PA-28R-201T · Hartsel, CO · Accident · No injuries · Limited investigation · Final report · Mar 16, 1997 · N38703 · Destroyed
  > The pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…
- [NTSB MIA97LA098](https://openairdocs.org/ntsb/MIA97LA098.md): Piper PA-28-181 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Mar 15, 1997 · N2505Q · Substantial damage
  > improper planning/decision by the pilot, by failing to ensure there was sufficient fuel to reach a suitable landing area, which resulted in fuel exhaustion, loss of engine power, a forced landing, and collision with a tree. The faulty fuel indication was a…
- [NTSB MIA97FA097](https://openairdocs.org/ntsb/MIA97FA097.md): Piper PA-24-260 · Andrews, NC · Accident · 2 fatal · Field investigation · Final report · Mar 15, 1997 · N8857P · Destroyed
  > The pilot's poor in-flight planning in attempting to maintain VFR conditions at night over mountainous terrain, and his failure to maintain clearance from the mountain. Contributing to the accident was: the pilot's inadequate preflight planning for not…
- [NTSB LAX97LA128](https://openairdocs.org/ntsb/LAX97LA128.md): Piper PA-28-140 · Santa Barbara, CA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1997 · N7163R · Substantial damage
  > the pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.
- [NTSB CHI97FA084](https://openairdocs.org/ntsb/CHI97FA084.md): Douglas DC-3C/BT-67R · Newton, WI · Accident · 4 fatal · Field investigation · Final report · Mar 15, 1997 · TZ389 · 2 aircraft · Destroyed
  > failure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.
- [NTSB ANC97IA035](https://openairdocs.org/ntsb/ANC97IA035.md): Piper PA-31-350 · Kotzebue, AK · Incident · No injuries · Incident investigation · Final report · Mar 15, 1997 · N3542H · Minor damage
  > the jammed main landing gear which was caused by a binding main landing gear door with a broken hinge. The fractured, inadequate main landing gear door hinge was also causal.
- [NTSB SEA97LA069](https://openairdocs.org/ntsb/SEA97LA069.md): Gulfstream American AA-5A · North Bend, OR · Accident · No injuries · Limited investigation · Final report · Mar 12, 1997 · N26848 · Substantial damage
  > The pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…
- [NTSB LAX97LA121](https://openairdocs.org/ntsb/LAX97LA121.md): Grumman G-164B · Winters, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1997 · N36265 · Substantial damage
  > the failure of the engine cylinder head assembly due to operational fatigue.
- [NTSB CHI97LA085](https://openairdocs.org/ntsb/CHI97LA085.md): Cessna 172 · Marquette, MI · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1997 · N171AS · Substantial damage
  > multiple oil leaks in the engine lubrication system. Factors were the disconnected wet vacuum pump line and the oil exhaustion.
- [NTSB SEA97FA070](https://openairdocs.org/ntsb/SEA97FA070.md): Piper PA-24-250 · Boise, ID · Accident · 3 fatal · Field investigation · Final report · Mar 7, 1997 · N7583P · Destroyed
  > the accumulation of airframe ice on the aircraft, and the pilot's delayed remedial action after intentionally flying into forecast adverse weather conditions. The adverse weather (icing) conditions were related factors.
- [NTSB CHI97LA081](https://openairdocs.org/ntsb/CHI97LA081.md): Piper PA-28-181 · Mosinee, WI · Accident · No injuries · Limited investigation · Final report · Mar 7, 1997 · N8259M · Substantial damage
  > The formation of carburetor ice and the instructor pilot's failure to recognize conditions leading to carburetor icing and to take appropriate preventative action. Factors relating to this accident were the late application of carburetor heat, the icing…
- [NTSB ATL97LA047](https://openairdocs.org/ntsb/ATL97LA047.md): Convair 240-27 · Hampton, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1997 · N357T · Substantial damage
  > a partial loss of power on one engine for undetermined reason(s), and the pilot's failure to follow aircraft emergency procedures. A factor was inadequate transition/upgrade training.
- [NTSB ANC97FA031](https://openairdocs.org/ntsb/ANC97FA031.md): Buesing SX-300 · Sitka, AK · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1997 · N357SX · Destroyed
  > the pilot's failure to properly evaluate the presence of icing conditions, and his failure to comply with procedures to use alternate engine air in icing conditions. Factors relating to the accident were: icing (weather) conditions, the pilot's improper…
- [NTSB NYC97FA057](https://openairdocs.org/ntsb/NYC97FA057.md): Beech E-18S · Mabie, WV · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1997 · N54BT · Destroyed
  > The pilot's disregard of the preflight weather briefing for severe weather along his route of flight, and his departure into the known and forecasted severe weather. A factor in the accident was the inadequate FAA oversight of the operator, which fostered an…
- [NTSB ATL97LA045](https://openairdocs.org/ntsb/ATL97LA045.md): Bellanca 17-30 · Aikens, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 1997 · N7312V · Substantial damage
  > excessive wear of the fuel metering unit/shaft, which resulted in a fuel leak and premature exhaustion of the fuel supply.
- [NTSB MIA97LA093](https://openairdocs.org/ntsb/MIA97LA093.md): Beech E35 · Nashville, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 1997 · N3257C · Substantial damage
  > a stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…
- [NTSB FTW97LA114](https://openairdocs.org/ntsb/FTW97LA114.md): Bell 206L-1 · Jamaica Beach, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1997 · N5829D · Destroyed
  > The pilot's encounter with instrument meteorological conditions, and his subsequent loss of aircraft control due to the loss of visual cues to detect his height above the water. Factors were the low ceilings and fog, and the loss of tail rotor effectiveness.
- [NTSB FTW97LA113](https://openairdocs.org/ntsb/FTW97LA113.md): Piper PA-28R-200 · Thibodaux, LA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1997 · N2654T · Substantial damage
  > The failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…

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

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

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