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

## Cases, newest first

- [NTSB SEA97LA216](https://openairdocs.org/ntsb/SEA97LA216.md): Cessna P210N · Creswell, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1997 · N6394W · Substantial damage
  > The pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…
- [NTSB NYC97LA187](https://openairdocs.org/ntsb/NYC97LA187.md): Airbus Industrie A-300 · Long Island, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1997 · N14077 · No damage
  > An in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.
- [NTSB LAX97FA331](https://openairdocs.org/ntsb/LAX97FA331.md): Cessna 172K · Sandy Valley, NV · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1997 · N84621 · Destroyed
  > the pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…
- [NTSB CHI97LA301](https://openairdocs.org/ntsb/CHI97LA301.md): Universal D-16 · Howell, MI · Accident · No injuries · Limited investigation · Final report · Sep 25, 1997 · N110N · Substantial damage
  > the emergency landing gear extension system being impeded by flap extension. Factors contributing to this accident are the instructor pilot's intentional feathering of the airplane's left propeller, the instructor pilot's lack of familiarity with the…
- [NTSB NYC97FA186](https://openairdocs.org/ntsb/NYC97FA186.md): Cessna 172 · Normalville, PA · Accident · 1 fatal · Field investigation · Final report · Sep 24, 1997 · N35405 · Destroyed
  > the pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.
- [NTSB NYC97FA185](https://openairdocs.org/ntsb/NYC97FA185.md): Piper PA-28R-200 · Glastenbury, VT · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1997 · CGHUE · Destroyed
  > the pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.
- [NTSB IAD97FA122](https://openairdocs.org/ntsb/IAD97FA122.md): Cessna 172P · Airville, PA · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1997 · N55221 · Destroyed
  > The student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.
- [NTSB FTW97LA358](https://openairdocs.org/ntsb/FTW97LA358.md): Mooney M20C · Pettigrew, AR · Accident · No injuries · Limited investigation · Final report · Sep 20, 1997 · N7045V · Substantial damage
  > The pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…
- [NTSB FTW97LA354](https://openairdocs.org/ntsb/FTW97LA354.md): Bell 206L-3 · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1997 · N210PH · Substantial damage
  > The loss of aircraft control resulting from a bird strike that severed the cyclic flight control.
- [NTSB MIA97LA250](https://openairdocs.org/ntsb/MIA97LA250.md): Piper PA-28R-200 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Sep 19, 1997 · N4315X · Substantial damage
  > The failure of the pilot to properly plan his descent and approach for a forced landing following partial loss of engine power resulting in the aircraft landing short of the intended landing runway. A factor in the accident was improper inspection of the…
- [NTSB MIA97FA249](https://openairdocs.org/ntsb/MIA97FA249.md): Cessna 177RG · Sebring, FL · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1997 · N2562V · Destroyed
  > continued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.
- [NTSB FTW97FA352](https://openairdocs.org/ntsb/FTW97FA352.md): Bell 407 · Grand Isle S108 · Accident · Minor injuries · Field investigation · Final report · Sep 18, 1997 · N467PH · Substantial damage
  > The tail rotor blade strike(s) that severed the aft portion of the tailboom, subsequently rendering the pilot with no tail rotor control while in cruise flight. A factor was the lack of suitable terrain for the forced autorotative landing.
- [NTSB CHI97LA297](https://openairdocs.org/ntsb/CHI97LA297.md): Piper PA-28 · Indianapolis, IN · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1997 · N6421R · Substantial damage
  > the pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.
- [NTSB SEA97LA210](https://openairdocs.org/ntsb/SEA97LA210.md): Piper PA-44-180 · The Dalles, OR · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N357DA · Substantial damage
  > the pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.
- [NTSB CHI97LA292](https://openairdocs.org/ntsb/CHI97LA292.md): Boeing 747-422 · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1997 · N175UA · No damage
  > The flight attendant's seat belt was not secured. A factor was turbulence in the clouds.
- [NTSB ANC97LA137](https://openairdocs.org/ntsb/ANC97LA137.md): Piper PA-12 · Healy, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N7894H · Substantial damage
  > The pilot's inadequate preflight which failed to detect water contamination in the fuel tanks. Factors were the worn gaskets on the fuel tank caps, and the pilot's decision to abort the partial power precautionary landing.
- [NTSB NYC97LA182](https://openairdocs.org/ntsb/NYC97LA182.md): Bellanca 7GCBC · Crimora, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1997 · N5272X · Substantial damage
  > The pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..
- [NTSB MIA97LA243](https://openairdocs.org/ntsb/MIA97LA243.md): Piper PA-32RT-300 · Oxford, NC · Accident · No injuries · Limited investigation · Final report · Sep 13, 1997 · N9385C · Substantial damage
  > fatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…
- [NTSB FTW97LA347](https://openairdocs.org/ntsb/FTW97LA347.md): Hughes MDL-369HS · Brinkley, AR · Accident · No injuries · Limited investigation · Final report · Sep 12, 1997 · N107CW · Substantial damage
  > The in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…
- [NTSB MIA97FA242](https://openairdocs.org/ntsb/MIA97FA242.md): Mooney M20F · Coral Springs, FL · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1997 · N6417Q · Substantial damage
  > The pilot's misjudging the distance vs. altitude resulting in the collision with the water short of the intended touchdown point of the rough field. Contributing to the accident was the total loss of engine power due to failure of the No. 3 cylinder…
- [NTSB LAX97LA321](https://openairdocs.org/ntsb/LAX97LA321.md): Cessna 152 · Murrieta, CA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1997 · N65406 · Substantial damage
  > failure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.
- [NTSB FTW97FA340](https://openairdocs.org/ntsb/FTW97FA340.md): Cessna 182N · Montrose, CO · Accident · 3 fatal · Field investigation · Final report · Sep 8, 1997 · N9043G · Destroyed
  > Inadequate preflight and in-flight planning, preparation and decision making. A related factor was the improper use of flaps.
- [NTSB LAX97LA316](https://openairdocs.org/ntsb/LAX97LA316.md): Cessna 182B · Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1997 · N81MK · Substantial damage
  > fuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.
- [NTSB CHI97LA285](https://openairdocs.org/ntsb/CHI97LA285.md): British Aerospace BAE-ATP · Peru, IL · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 1997 · N855AW · No damage
  > sudden/unexpected encounter with clear air turbulence.
- [NTSB CHI97FA283](https://openairdocs.org/ntsb/CHI97FA283.md): Cessna 177B · Crump, MI · Accident · 1 fatal · Field investigation · Final report · Sep 7, 1997 · N34142 · Destroyed
  > Continued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…
- [NTSB LAX97LA314](https://openairdocs.org/ntsb/LAX97LA314.md): Hallam RV-6 · Woodlake, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1997 · N93SJ · Substantial damage
  > failure of the pilot to accurately determine the quantity of fuel onboard the airplane before flight, and subsequent loss of engine power due to fuel starvation, which resulted in a forced landing.
- [NTSB CHI97LA284](https://openairdocs.org/ntsb/CHI97LA284.md): North American-Aero Classics P-51D · Monroe, MI · Accident · 2 fatal · Limited investigation · Final report · Sep 6, 1997 · N6345T · Destroyed
  > the pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…
- [NTSB ANC97FA143](https://openairdocs.org/ntsb/ANC97FA143.md): Aero Commander AC-500A · Ketchikan, AK · Accident · 2 fatal · Field investigation · Final report · Sep 6, 1997 · N543AN · Destroyed
  > The rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…
- [NTSB LAX97LA319](https://openairdocs.org/ntsb/LAX97LA319.md): Mooney M20E · Gulf Of Ca (Pacific Ocean) · Accident · No injuries · Limited investigation · Final report · Sep 5, 1997 · N9217V · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB IAD97LA119](https://openairdocs.org/ntsb/IAD97LA119.md): Luscombe LL-8-F · Carrollton, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1997 · N1871K · Substantial damage
  > The pilot's inadequate preflight which resulted in fuel exhaustion.
- [NTSB FTW97LA338](https://openairdocs.org/ntsb/FTW97LA338.md): Beech V35B · Saguache, CO · Accident · No injuries · Limited investigation · Final report · Sep 4, 1997 · N7397R · Substantial damage
  > **This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…
- [NTSB FTW97LA337](https://openairdocs.org/ntsb/FTW97LA337.md): Piper PA-22 · Saratoga, WY · Accident · No injuries · Limited investigation · Final report · Sep 3, 1997 · N8731C · Substantial damage
  > The pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.
- [NTSB SEA97FA201](https://openairdocs.org/ntsb/SEA97FA201.md): Cessna 182C · Bremerton, WA · Accident · 5 fatal · Field investigation · Final report · Sep 1, 1997 · N9015T · Destroyed
  > The pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.
- [NTSB CHI97LA275](https://openairdocs.org/ntsb/CHI97LA275.md): Bucker Flugzeugbau Jungmann · Blakesburg, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1997 · N131G · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB NYC97LA175](https://openairdocs.org/ntsb/NYC97LA175.md): Taylorcraft DCO-65 · Fredericksburg, VA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1997 · N4376B · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB SEA97LA198](https://openairdocs.org/ntsb/SEA97LA198.md): Garlick UH-1B · Dayville, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1997 · N22753 · Substantial damage
  > Improper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…
- [NTSB LAX97LA312](https://openairdocs.org/ntsb/LAX97LA312.md): Cessna T210J · Avra Valley, AZ · Accident · No injuries · Limited investigation · Final report · Aug 29, 1997 · N2280R · Substantial damage
  > The pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…
- [NTSB LAX97LA307](https://openairdocs.org/ntsb/LAX97LA307.md): Cessna T210M · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Aug 29, 1997 · N761HQ · Substantial damage
  > Installation of improper connecting hardware by maintenance personnel, and, the inadequate inspection of the installed hardware by inspection personnel resulting in separation of the engine throttle linkage.
- [NTSB FTW97LA332](https://openairdocs.org/ntsb/FTW97LA332.md): Pitts S-2B · Mountain View, AR · Accident · No injuries · Limited investigation · Final report · Aug 27, 1997 · N9QT · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW97LA328](https://openairdocs.org/ntsb/FTW97LA328.md): Fingerhut Revolution Mini 500 · Huffman, TX · Accident · No injuries · Limited investigation · Final report · Aug 27, 1997 · N570F · Substantial damage
  > The disengagement of the helicopter's collective control tube due to improper installation by the builder. Factors were the lack of sufficient information provided by the kit manufacturer and the pilot's inability to cushion the landing.
- [NTSB CHI97FA272](https://openairdocs.org/ntsb/CHI97FA272.md): Kellums Sonerai 1 · Scottsburg, IN · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1997 · N76457 · Destroyed
  > a loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.
- [NTSB ATL97LA125](https://openairdocs.org/ntsb/ATL97LA125.md): Cessna 152 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 26, 1997 · N6216Q · Substantial damage
  > the flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.
- [NTSB NYC97FA170](https://openairdocs.org/ntsb/NYC97FA170.md): Cessna 337B · Warren Township, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 25, 1997 · N2442S · Destroyed
  > the pilot's loss of control in flight for undetermined reasons and the subsequent collision with terrain.
- [NTSB LAX97LA305](https://openairdocs.org/ntsb/LAX97LA305.md): Cessna 152 · Mecca, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1997 · N152RJ · Substantial damage
  > fuel exhaustion as a result of the student pilot's inadequate preflight and failure to refuel.
- [NTSB LAX97LA304](https://openairdocs.org/ntsb/LAX97LA304.md): Walton Velocity STD/FG · Chino Valley, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1997 · N7VX · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB LAX97LA302](https://openairdocs.org/ntsb/LAX97LA302.md): Cessna 172N · Kenwood, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1997 · N733QD · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and a forced landing, due to an inadequate supply of fuel.
- [NTSB LAX97LA301](https://openairdocs.org/ntsb/LAX97LA301.md): Beech H35 · Goleta, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1997 · N222M · Destroyed
  > was a loss of engine power for undetermined reasons.
- [NTSB SEA97LA195](https://openairdocs.org/ntsb/SEA97LA195.md): Cessna 170 · Elk City, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1997 · N3964V · Destroyed
  > Oil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.
- [NTSB FTW97LA327](https://openairdocs.org/ntsb/FTW97LA327.md): Robinson R22 Beta · Terrell, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1997 · N8057Z · Substantial damage
  > the student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).
- [NTSB ATL97LA124](https://openairdocs.org/ntsb/ATL97LA124.md): Cessna 414A · Anderson, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1997 · N4668N · Substantial damage
  > the pilot misjudged distance and speed on final approach to land and failed to attain a proper touchdown point during the landing, which resulted in an overrun of the runway and collision with a fence. A related factor was the loss of engine power during…

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

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

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