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

## Cases, newest first

- [NTSB FTW97LA080](https://openairdocs.org/ntsb/FTW97LA080.md): Piper PA-28-180 · Baton Rouge, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1997 · N33037 · Substantial damage
  > fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX97LA087](https://openairdocs.org/ntsb/LAX97LA087.md): Beech C24R · Santa Cruz Is., CA · Accident · No injuries · Limited investigation · Final report · Jan 10, 1997 · N18892 · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB ATL97LA033](https://openairdocs.org/ntsb/ATL97LA033.md): Piper PA-28R-200 · Lebanon, TN · Accident · No injuries · Limited investigation · Final report · Jan 9, 1997 · N1434X · Substantial damage
  > The pilot's improper short, soft field takeof. A factor was the pilot's poor in-flight decision to operate over an overcast until near the airplane's maximum endurance.
- [NTSB SEA97FA044](https://openairdocs.org/ntsb/SEA97FA044.md): Piper PA-24-260 · Winston, MT · Accident · 3 fatal · Field investigation · Final report · Jan 7, 1997 · N9080P · Destroyed
  > Pilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.
- [NTSB NYC97LA040](https://openairdocs.org/ntsb/NYC97LA040.md): Airbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1997 · N50051 · Minor damage
  > an encounter with unforecast clear air turbulence and the flight attendant's failure to use the seat belt.
- [NTSB SEA97FA043](https://openairdocs.org/ntsb/SEA97FA043.md): Piper PA-28R · Fort Smith, MT · Accident · 2 fatal · Field investigation · Final report · Jan 6, 1997 · N3347Q · Destroyed
  > The pilot's failure to maintain clearance from terrain. Factors include the pilot inadvertently becoming lost/disoriented, the dark night (minimum ambient light), and mountainous/hilly terrain.
- [NTSB LAX97FA082](https://openairdocs.org/ntsb/LAX97FA082.md): Fairchild SA227-AC · Bullhead City, AZ · Accident · Minor injuries · Field investigation · Final report · Jan 5, 1997 · N165SW · Destroyed
  > failure of the pilot(s) to use 'override' ignition as prescribed by checklist procedures during an encounter with icing conditions, which subsequently led to ice ingestion and dual engine flame-outs. Factors related to the accident were: the adverse weather…
- [NTSB SEA97FA041](https://openairdocs.org/ntsb/SEA97FA041.md): Cessna P210N · Cambridge, ID · Accident · 5 fatal · Field investigation · Final report · Jan 2, 1997 · N6425W · Destroyed
  > the pilot's failure to maintain control of the aircraft. Flight into adverse weather and turbulence were factors.
- [NTSB IAD97FA038](https://openairdocs.org/ntsb/IAD97FA038.md): Cessna 150F · Bittinger, MD · Accident · 1 fatal · Field investigation · Final report · Jan 1, 1997 · N8925S · Destroyed
  > VFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…
- [NTSB FTW97LA077](https://openairdocs.org/ntsb/FTW97LA077.md): Piper PA-28R-201T · Raton, NM · Accident · No injuries · Limited investigation · Final report · Dec 31, 1996 · N40437 · Substantial damage
  > failure of the exhaust rocker arm retaining studs due to over torquing of the attachment bolts by maintenance personnel during installation. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA97LA045](https://openairdocs.org/ntsb/MIA97LA045.md): Issoire-Aviation PIK-30 · Boynton Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 28, 1996 · N25RJ · Substantial damage
  > failure of the engine to restart for undetermined reason(s), after gliding (sailing) for about 3 hours, resulting in a forced landing in a swamp.
- [NTSB ATL97FA029](https://openairdocs.org/ntsb/ATL97FA029.md): Mooney M20C · Roxboro, NC · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1996 · N7773M · Destroyed
  > failure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: the pilot's use of an unapproved drug, low ceiling, restricted visibility (fog), and an undetermined anomaly with the vacuum system.
- [NTSB MIA97FA047](https://openairdocs.org/ntsb/MIA97FA047.md): Champion 7GCBC · Fort Lauderdale, FL · Accident · 2 fatal · Field investigation · Final report · Dec 26, 1996 · N7596F · Substantial damage
  > Intentional aerobatics at too low an altitude that did not allow for recovery from an intentional maneuver. Contributing to the accident was the operation of the airplane at an overgross weight condition.
- [NTSB FTW97FA073](https://openairdocs.org/ntsb/FTW97FA073.md): Cessna 210L · Brackettville, TX · Accident · 2 fatal · Field investigation · Final report · Dec 26, 1996 · N30891 · Destroyed
  > failure of the pilot to maintain sufficient altitude and/or clearance from terrain, while on a cross-country flight at night. Factors relating to the accident were: darkness, the prevailing low ceilings, and mountainous/hilly terrain.
- [NTSB CHI97LA046](https://openairdocs.org/ntsb/CHI97LA046.md): Bellanca 17-30 · Hayes Center, NE · Accident · Serious injuries · Limited investigation · Final report · Dec 26, 1996 · N4836V · Substantial damage
  > inadequate fuel management by the pilot, which resulted in fuel starvation. The factors relating to the accident were: a fuel leak at the engine driven fuel pump, and the engine driven fuel pump pressure was too low.
- [NTSB ATL97LA028](https://openairdocs.org/ntsb/ATL97LA028.md): Mooney M20F · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 26, 1996 · N737JC · Substantial damage
  > The pilot's inadequate in-flight fuel consumption calculations, and the excessive flow of the fuel injector servo, that combined to result in fuel exhaustion.
- [NTSB LAX97LA076](https://openairdocs.org/ntsb/LAX97LA076.md): Trickle TR-4 · Davis, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1996 · N91RT · Substantial damage
  > The fatigue fracture and separation of one rod end cap bolt. A factor in the accident was the nature of the terrain for the forced landing.
- [NTSB LAX97LA072](https://openairdocs.org/ntsb/LAX97LA072.md): McDonnell Douglas MD-83 · San Jose, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1996 · N590AA · No damage
  > The flight's encounter with severe turbulence while the injured cabin crew was standing.
- [NTSB LAX97LA071](https://openairdocs.org/ntsb/LAX97LA071.md): Farhat RV6A · Julian, CA · Accident · 2 fatal · Limited investigation · Final report · Dec 22, 1996 · N961CP · Destroyed
  > flight by the pilot into known adverse weather conditions, which resulted in the accumulation of airframe ice and an inability to maintain clearance (proper altitude) from mountainous terrain. Moderate to severe icing conditions in clouds, turbulence, and…
- [NTSB LAX97FA070](https://openairdocs.org/ntsb/LAX97FA070.md): Piper PA-23-250 · Lucerne Valley, CA · Accident · 4 fatal · Field investigation · Final report · Dec 22, 1996 · N2377T · Destroyed
  > the pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.
- [NTSB DCA97MA016](https://openairdocs.org/ntsb/DCA97MA016.md): Douglas DC-8-63F · Narrows, VA · Accident · 6 fatal · Class 1 · Major · Final report · Dec 22, 1996 · N827AX · Destroyed
  > the inappropriate control inputs applied by the flying pilot during a stall recovery attempt, the failure of the nonflying pilot-in-command to recognize, address, and correct these inappropriate control inputs, and the failure of ABX to establish a formal…
- [NTSB ANC97LA015](https://openairdocs.org/ntsb/ANC97LA015.md): Boeing 737-400 · Yakutat, AK · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1996 · N775AS · No damage
  > an in-flight encounter with unforecast severe clear air turbulence.
- [NTSB NYC97LA035](https://openairdocs.org/ntsb/NYC97LA035.md): Cessna T210M · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1996 · N732UH · Substantial damage
  > failure of #5 exhaust valve and/or #5 exhaust valve guide, which resulted in a progressive engine failure (debris puncturing the #5 piston crown, exhaust gasses entering the crankcase, loss of oil through the breather system, oil exhaustion, and subsequent…
- [NTSB NYC97LA032](https://openairdocs.org/ntsb/NYC97LA032.md): Cessna 172RG · Stamford, CT · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1996 · N4829V · Destroyed
  > inadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.
- [NTSB FTW97LA070](https://openairdocs.org/ntsb/FTW97LA070.md): British Aerospace BAE 146-200A · Denver, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1996 · N606AW · No damage
  > an inflight encounter with unreported and unanticipated clear air turbulence during landing descent.
- [NTSB FTW97FA067](https://openairdocs.org/ntsb/FTW97FA067.md): Beech A36 · Chacon, NM · Accident · 6 fatal · Field investigation · Final report · Dec 21, 1996 · N3869A · Destroyed
  > The pilot's failure to maintain altitude and clearance from the high, mountainous terrain. Factors were; high wind, turbulence, and mountain wave conditions.
- [NTSB SEA97LA039](https://openairdocs.org/ntsb/SEA97LA039.md): Stinson 108-2 · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Dec 20, 1996 · N233C · Destroyed
  > failure of the engine (powerplant) for undetermined reason(s). A factor relating to the accident include: being over water at the time of power failure.
- [NTSB FTW97LA066](https://openairdocs.org/ntsb/FTW97LA066.md): Cessna 210N · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Dec 19, 1996 · N6555Y · Substantial damage
  > the pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB CHI97LA050](https://openairdocs.org/ntsb/CHI97LA050.md): Piper PA-46 · Red Oak, IA · Accident · No injuries · Limited investigation · Final report · Dec 19, 1996 · N446RD · Substantial damage
  > the pilot's inadequate preflight and failure to make a precautionary landing. Additional factors included oil starvation and the failed connecting rod and rod bearing.
- [NTSB FTW97LA064](https://openairdocs.org/ntsb/FTW97LA064.md): Cessna P210N · Muskogee, OK · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1996 · N210BG · Substantial damage
  > the pilot's improper planning/decision and inaccurate fuel consumption calculations, which resulted in an inadequate supply of fuel, fuel exhaustion, and a subsequent forced landing at night. Darkness was a related factor.
- [NTSB FTW97LA065](https://openairdocs.org/ntsb/FTW97LA065.md): Cessna A188 · La Porte, TX · Accident · No injuries · Limited investigation · Final report · Dec 17, 1996 · N9860V · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB IAD97LA033](https://openairdocs.org/ntsb/IAD97LA033.md): Cessna 172B · Charleston, WV · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 1996 · N6937X · Destroyed
  > improper planning/decision by the pilot, and his mismanagement of the fuel supply, which resulted in fuel exhaustion, loss of engine power, and a forced landing into wooded terrain.
- [NTSB FTW97LA063](https://openairdocs.org/ntsb/FTW97LA063.md): Ercoupe 415-D · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Dec 14, 1996 · N87226 · Substantial damage
  > failure of the #1 exhaust valve, which resulted in loss of engine power and a forced landing on rough/uneven terrain. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB IAD97FA032](https://openairdocs.org/ntsb/IAD97FA032.md): Mbb BO-105CBS · Penn Yan, NY · Accident · 3 fatal · Field investigation · Final report · Dec 13, 1996 · N90750 · Destroyed
  > the pilot's failure to maintain altitude/clearance from the terrain. Factors relating to the accident were: the pilot's diverted attention to the GPS, darkness, low ceiling, rising terrain, and high wind condition.
- [NTSB MIA97LA036](https://openairdocs.org/ntsb/MIA97LA036.md): Beech 18G · Roosevelt Roads, PR · Accident · 1 fatal · Limited investigation · Final report · Dec 11, 1996 · N353T · Destroyed
  > The pilot's improper planning/decision concerning separation of the left engine cowling. Factors relating to the accident were: the pilot's failure to perform weight and balance calculations, and/or to ensure the airplane was loaded in accordance with company…
- [NTSB CHI97IA041](https://openairdocs.org/ntsb/CHI97IA041.md): Boeing 757-225 · Terre Haute, IN · Incident · No injuries · Incident investigation · Final report · Dec 11, 1996 · N603AU · Minor damage
  > inadequate installation of electrical wiring for an audio entertainment system associated with Supplemental Type Certificate (STC) SA5537NM, and a subsequent short in the wiring. Factors relating to the accident were: inadequate design (installation…
- [NTSB ATL97LA023](https://openairdocs.org/ntsb/ATL97LA023.md): Pereyra Aventura II · Rockledge, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 9, 1996 · N32913 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB SEA97FA033](https://openairdocs.org/ntsb/SEA97FA033.md): Beech B36TC · Jackson, WY · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1996 · N3000R · Substantial damage
  > failure of the pilot to follow IFR procedures. High terrain, low ceiling, icing conditions, and a possible anomaly with the VOR were related factors.
- [NTSB NYC97LA027](https://openairdocs.org/ntsb/NYC97LA027.md): Lake LA-4 · Gallipolis, OH · Accident · No injuries · Limited investigation · Final report · Dec 8, 1996 · N7632L · Substantial damage
  > the pilot's improper recovery from a bounced landing, and his failure to maintain directional control, which resulted in a collision with a hangar and parked aircraft. Factors relating to the accident were: the pilot's encounter with rain, sleet, snow, and…
- [NTSB ATL97LA022](https://openairdocs.org/ntsb/ATL97LA022.md): Cessna 421C · St. Petersburg, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 1996 · N5195C · Substantial damage
  > improper installation of the new starter adapter by maintenance personnel.
- [NTSB MIA97FA034](https://openairdocs.org/ntsb/MIA97FA034.md): Beech D-45 · Poplarville, MS · Accident · 2 fatal · Field investigation · Final report · Dec 7, 1996 · N99065 · Destroyed
  > the noninstrument-rated pilot's intentional operation of the airplane with known deficiencies in equipment (inoperative attitude indicator and directional gyro) with an estimated time of arrival after official twilight. Also, poor in-flight planning decision…
- [NTSB LAX97FA067](https://openairdocs.org/ntsb/LAX97FA067.md): Beech V35B · Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1996 · N6056M · Destroyed
  > the pilot's intentional flight into adverse weather and improper in-flight planning and decision making.
- [NTSB MIA97FA031](https://openairdocs.org/ntsb/MIA97FA031.md): Piper PA32-300D · Reform, AL · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1996 · N8603N · Destroyed
  > a complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.
- [NTSB ANC97LA012](https://openairdocs.org/ntsb/ANC97LA012.md): Piper PA-31 · Nunapitchuk, AK · Accident · No injuries · Limited investigation · Final report · Dec 5, 1996 · N54272 · Substantial damage
  > the pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing. Factors associated with the accident were: the low fuel condition, which led to a single engine landing, and the crosswind condition.
- [NTSB IAD97LA028](https://openairdocs.org/ntsb/IAD97LA028.md): Hughes 269C · Mayfield, KY · Accident · No injuries · Limited investigation · Final report · Dec 4, 1996 · N1105P · Substantial damage
  > disengagement of the main transmission aft pinion nut, allowing the tail rotor splined drive sleeve to disengage from the pinion, which resulted in loss of directional control and an emergency (autorotative) landing.
- [NTSB IAD97LA027](https://openairdocs.org/ntsb/IAD97LA027.md): Piper PA-32-260 · Claverack, NY · Accident · No injuries · Limited investigation · Final report · Dec 4, 1996 · N3324W · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB NYC97FA025](https://openairdocs.org/ntsb/NYC97FA025.md): Piper PA-32-260 · Felton, PA · Accident · 1 fatal · Field investigation · Final report · Dec 3, 1996 · N5538J · Destroyed
  > The pilot's inadequate preflight planning and preparation, and his failure to refuel which resulted in fuel exhaustion and the subsequent collision with trees during the forced landing.
- [NTSB MIA97LA033](https://openairdocs.org/ntsb/MIA97LA033.md): Cessna 150H · Homerville, GA · Accident · No injuries · Limited investigation · Final report · Dec 3, 1996 · N6532S · Substantial damage
  > carburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.
- [NTSB CHI97LA036](https://openairdocs.org/ntsb/CHI97LA036.md): Cessna 177 · Regan, ND · Accident · No injuries · Limited investigation · Final report · Dec 3, 1996 · N30255 · Substantial damage
  > the pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.
- [NTSB NYC97LA024](https://openairdocs.org/ntsb/NYC97LA024.md): Piper PA-46-350P · Myerstown, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1996 · N394PM · Substantial damage
  > fatigue failure of the connecting rod to crankshaft attachments, due to inadequate overhaul of the engine by the manufacturer, which resulted in a loss of engine power and a forced landing. Factors relating to the accident included the discharge of oil from…

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

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

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