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

## Cases, newest first

- [NTSB CHI97IA134](https://openairdocs.org/ntsb/CHI97IA134.md): Lockheed L-1011-385-1 · Saint Louis, MO · Incident · No injuries · Incident investigation · Final report · May 15, 1997 · N11003 · Minor damage
  > failure of company maintenance personnel to properly install a mounting eyebolt (and associated cotter pin, washer, spacer and castellated nut) on the lower forward bracket of the left main landing gear strut door.
- [NTSB MIA97LA163](https://openairdocs.org/ntsb/MIA97LA163.md): Piper PA-24-180 · Yakkama City, FL · Accident · No injuries · Limited investigation · Final report · May 14, 1997 · N7931P · Substantial damage
  > a complete loss of engine power due to the separation of the connecting rod bolts, resulting in a forced landing and impact with a tree. A factor in this accident was improper installation of the rod bolts by a mechanic.
- [NTSB FTW97LA190](https://openairdocs.org/ntsb/FTW97LA190.md): Schweizer 269C · Laredo, TX · Accident · No injuries · Limited investigation · Final report · May 13, 1997 · N107SM · Substantial damage
  > loss of engine power due to fuel contamination, and the pilot's failure to properly check the fuel system for evidence of water during the preflight inspection. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX97LA181](https://openairdocs.org/ntsb/LAX97LA181.md): Piper PA-32R-300 · Burbank, CA · Accident · No injuries · Limited investigation · Final report · May 12, 1997 · N3609Q · Substantial damage
  > improperly secured upper cowl fasteners by unknown person(s).
- [NTSB DCA97MA049](https://openairdocs.org/ntsb/DCA97MA049.md): Airbus Industrie A300B4-605R · West Palm Beach, FL · Accident · Serious injuries · Major investigation · Final report · May 12, 1997 · N90070 · Minor damage
  > The flightcrew's failure to maintain adequate airspeed during leveloff which led to an inadvertent stall, and their subsequent failure to use proper stall recovery techniques. A factor contributing to the accident was the flightcrew's failure to properly use…
- [NTSB LAX97LA176](https://openairdocs.org/ntsb/LAX97LA176.md): Hughes 369D · Puako, HI · Accident · 2 fatal · Limited investigation · Final report · May 11, 1997 · N5105N · Destroyed
  > erosion of second stage stator vanes, inadequate maintenance inspection for the erosion, and subsequent fatigue failure of a stator vane, which resulted in loss of engine power and a forced landing on mountainous/hilly terrain. Also causal was: the pilot's…
- [NTSB SEA97FA105](https://openairdocs.org/ntsb/SEA97FA105.md): Cessna 182 · Clinton, UT · Accident · 3 fatal · Field investigation · Final report · May 10, 1997 · N5434B · 2 aircraft · Destroyed
  > Inadequate prior arrangements for formation flight by the pilot-in-command of the Cessna 182, N5434B, and his subsequent failure to see-and-avoid the Piper PA-28R, N5270T. Factors were: the Cessna pilot's visibility of the Piper impaired by the sun;…
- [NTSB IAD97LA074](https://openairdocs.org/ntsb/IAD97LA074.md): American AA-1 · Lewisburg, WV · Accident · No injuries · Limited investigation · Final report · May 10, 1997 · N5734L · Destroyed
  > The pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.
- [NTSB FTW97LA189](https://openairdocs.org/ntsb/FTW97LA189.md): Townsend Kitfox · Greeley, CO · Accident · No injuries · Limited investigation · Final report · May 10, 1997 · N950AW · Substantial damage
  > The engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.
- [NTSB FTW97LA185](https://openairdocs.org/ntsb/FTW97LA185.md): Mooney M20C · Torreon, NM · Accident · Minor injuries · Limited investigation · Final report · May 9, 1997 · N7853V · Substantial damage
  > failure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…
- [NTSB LAX97LA182](https://openairdocs.org/ntsb/LAX97LA182.md): Ayres S2R-T-34 · Tonopah, AZ · Accident · No injuries · Limited investigation · Final report · May 8, 1997 · N4011G · Substantial damage
  > the failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.
- [NTSB FTW97FA181](https://openairdocs.org/ntsb/FTW97FA181.md): Cessna 172RG · Intracoastal, LA · Accident · 1 fatal · Field investigation · Final report · May 8, 1997 · N6505V · Destroyed
  > the pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.
- [NTSB CHI97IA127](https://openairdocs.org/ntsb/CHI97IA127.md): Cessna T210 · Winona, MN · Incident · No injuries · Incident investigation · Final report · May 8, 1997 · N7398M · No damage
  > Loss of engine power due to improper maintenance installation.
- [NTSB FTW97LA180](https://openairdocs.org/ntsb/FTW97LA180.md): Cessna 172N · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · May 7, 1997 · N733WJ · Substantial damage
  > The improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL97LA080](https://openairdocs.org/ntsb/ATL97LA080.md): Learjet 31A · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · May 7, 1997 · N31PV · Substantial damage
  > the pilot-in-command's failure to maintain airspeed within the design structural limits of the airplane.
- [NTSB SEA97LA099](https://openairdocs.org/ntsb/SEA97LA099.md): Grumman G-164A · Rosalia, WA · Accident · 1 fatal · Limited investigation · Final report · May 6, 1997 · N7926 · Destroyed
  > The pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.
- [NTSB NYC97LA085](https://openairdocs.org/ntsb/NYC97LA085.md): Marsh-Turner BG-12A · Marion, OH · Accident · 1 fatal · Limited investigation · Final report · May 4, 1997 · N8711R · Destroyed
  > Disconnection of the elevator control rod which resulted in the loss of elevator control. A factor was failure to complete the required maintenance inspection.
- [NTSB IAD97LA071](https://openairdocs.org/ntsb/IAD97LA071.md): Piper PA-23 · Washington, DC · Accident · Minor injuries · Limited investigation · Final report · May 2, 1997 · N1044P · Substantial damage
  > total loss of power on both engines due to fuel exhaustion as a result of the pilot's improper fuel consumption calculations.
- [NTSB ATL97LA066](https://openairdocs.org/ntsb/ATL97LA066.md): Piper PA-22-180 · Russellville, AL · Accident · No injuries · Limited investigation · Final report · May 1, 1997 · N5778Z · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.
- [NTSB ANC97LA065](https://openairdocs.org/ntsb/ANC97LA065.md): Cessna U206F · Hope, AK · Accident · Minor injuries · Limited investigation · Final report · May 1, 1997 · N14C · Substantial damage
  > a loss of engine power resulting from fuel starvation due to the pilot's improper positioning of the fuel selector, and the pilot's failure to identify and correct the deficiency during the ensuing emergency descent.
- [NTSB FTW97LA170](https://openairdocs.org/ntsb/FTW97LA170.md): Ayres S2R-G6 · El Dorado, AR · Accident · No injuries · Limited investigation · Final report · Apr 29, 1997 · N31575 · Substantial damage
  > The pilot misjudging his altitude above the airport, resulting in not attaining the proper touchdown point. A factor was the separation of teeth from the aft gear of the spur gear assembly, which resulted in the interruption of fuel.
- [NTSB CHI97LA119](https://openairdocs.org/ntsb/CHI97LA119.md): Beech D35 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Apr 29, 1997 · N5985C · Substantial damage
  > flutter for an undetermined reason, which resulted in structural damage to the aft fuselage.
- [NTSB CHI97IA122](https://openairdocs.org/ntsb/CHI97IA122.md): Beech 35 · Spokane, WA · Incident · No injuries · Incident investigation · Final report · Apr 29, 1997 · N2839V · No damage
  > the vibration of the fuselage was due to flutter.
- [NTSB ATL97LA069](https://openairdocs.org/ntsb/ATL97LA069.md): Beech 33 · Carrollton, GA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1997 · N5863S · Substantial damage
  > The inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…
- [NTSB ATL97LA065](https://openairdocs.org/ntsb/ATL97LA065.md): Piper PA-28-180 · Hazelhurst, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 1997 · N4979L · Substantial damage
  > The loss of engine power for undetermined reasons. Factors were, conditions were favorable for the formation of carburetor ice, and the pilot lack of qualification for the flight.
- [NTSB ATL97LA064](https://openairdocs.org/ntsb/ATL97LA064.md): Boeing 737-200 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1997 · N14245 · No damage
  > The failure of the flight crew to alert the cabin crew to the possibility of turbulence, leading to a serious injury when severe turbulence was encountered..
- [NTSB LAX97LA168](https://openairdocs.org/ntsb/LAX97LA168.md): Cessna T182 · Hemet, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 26, 1997 · N5482N · Destroyed
  > the pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…
- [NTSB FTW97FA171](https://openairdocs.org/ntsb/FTW97FA171.md): Piper PA-32RT-300T · Rye, CO · Accident · 3 fatal · Field investigation · Final report · Apr 26, 1997 · N2225A · Destroyed
  > The pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.
- [NTSB MIA97LA148](https://openairdocs.org/ntsb/MIA97LA148.md): Piper PA-38-112 · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Apr 24, 1997 · N6299A · Substantial damage
  > loss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.
- [NTSB FTW97FA166](https://openairdocs.org/ntsb/FTW97FA166.md): Socata TB-20 · Pagosa Springs, CO · Accident · 1 fatal · Field investigation · Final report · Apr 23, 1997 · N20NK · Destroyed
  > inadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.
- [NTSB ANC97LA075](https://openairdocs.org/ntsb/ANC97LA075.md): Cessna 207A · Minto, AK · Accident · No injuries · Limited investigation · Final report · Apr 23, 1997 · N1785U · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.
- [NTSB MIA97LA146](https://openairdocs.org/ntsb/MIA97LA146.md): Grumman G-164B · Ackerman, MS · Accident · No injuries · Limited investigation · Final report · Apr 21, 1997 · N6601Q · Substantial damage
  > installation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…
- [NTSB ATL97IA061](https://openairdocs.org/ntsb/ATL97IA061.md): British Aerospace 125-800A · Chamblee, GA · Incident · No injuries · Incident investigation · Final report · Apr 21, 1997 · N900KC · No damage
  > physical impairmant of the captain during flight, which was the resulted of a kidney stone.
- [NTSB MIA97LA144](https://openairdocs.org/ntsb/MIA97LA144.md): Stinson 108-1 · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · Apr 19, 1997 · N9063K · Substantial damage
  > a fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.
- [NTSB MIA97IA147](https://openairdocs.org/ntsb/MIA97IA147.md): Boeing 747-2R7F · Miami, FL · Incident · No injuries · Incident investigation · Final report · Apr 19, 1997 · N639FE · Minor damage
  > disbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.
- [NTSB LAX97FA164](https://openairdocs.org/ntsb/LAX97FA164.md): Boeing 737-3S3 · Las Vegas, NV · Accident · Serious injuries · Field investigation · Final report · Apr 19, 1997 · N313AW · No damage
  > inadequate service provided by the TRACON controller, by issuing a radar vector to the Boeing 737 flight, which resulted in inadequate separation from a Beech 99 that the controller had just terminated from radar service; and failure of the controller to…
- [NTSB SEA97LA086](https://openairdocs.org/ntsb/SEA97LA086.md): Piper PA-24-260 · Sequim, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 1997 · N8645P · Substantial damage
  > The pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.
- [NTSB ATL97LA059](https://openairdocs.org/ntsb/ATL97LA059.md): Cessna 210D · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Apr 14, 1997 · N3761Y · Substantial damage
  > corrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.
- [NTSB LAX97LA157](https://openairdocs.org/ntsb/LAX97LA157.md): de Havilland DHC-6-300 · Hilo, HI · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1997 · N242CA · Destroyed
  > the pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.
- [NTSB CHI97LA105](https://openairdocs.org/ntsb/CHI97LA105.md): Piper PA-24 · Elk Falls, KS · Accident · No injuries · Limited investigation · Final report · Apr 12, 1997 · N8739P · Substantial damage
  > fracture of the fuel selector assembly which resulted in fuel starvation.
- [NTSB ANC97LA055](https://openairdocs.org/ntsb/ANC97LA055.md): Piper PA-32 · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Apr 12, 1997 · N9000N · Substantial damage
  > A disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.
- [NTSB MIA97LA133](https://openairdocs.org/ntsb/MIA97LA133.md): Cessna 152 · La Crosse, FL · Accident · No injuries · Limited investigation · Final report · Apr 10, 1997 · N5442B · Substantial damage
  > The student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…
- [NTSB MIA97LA127](https://openairdocs.org/ntsb/MIA97LA127.md): Cessna 182B · Tullahoma, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 1997 · N2515G · Substantial damage
  > Fuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…
- [NTSB LAX97LA154](https://openairdocs.org/ntsb/LAX97LA154.md): Piper PA-31-350 · Pacific Ocean (Pacific Ocean) · Accident · No injuries · Limited investigation · Final report · Apr 10, 1997 · N27659 · Destroyed
  > The loss of engine power in one engine for undetermined reasons. A factor in the accident was the aircraft's diminished single engine performance during the early portion of the overweight ferry flight.
- [NTSB ANC97LA052](https://openairdocs.org/ntsb/ANC97LA052.md): Piper PA-28-140 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Apr 10, 1997 · N6472R · Substantial damage
  > loss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.
- [NTSB ANC97FA051](https://openairdocs.org/ntsb/ANC97FA051.md): Cessna 185 · Tatitlek, AK · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1997 · N59AK · 2 aircraft · Minor damage
  > The command pilots of both airplanes inadequate visual outlook which led to their failure to see and avoid each other's airplane. A factor associated with the accident was sunglare.
- [NTSB NYC97LA071](https://openairdocs.org/ntsb/NYC97LA071.md): Airbus Industrie A-320-232 · Newark, NJ · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1997 · N413UA · No damage
  > an encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.
- [NTSB MIA97LA121](https://openairdocs.org/ntsb/MIA97LA121.md): Cessna 150J · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N50918 · Substantial damage
  > The student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA97LA115](https://openairdocs.org/ntsb/MIA97LA115.md): Boeing Stearman B75N1 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Apr 6, 1997 · N52507 · Substantial damage
  > The pilot's inadequate planning/decision and failure to assure an adequate supply of fuel was on board the airplane.
- [NTSB LAX97FA148](https://openairdocs.org/ntsb/LAX97FA148.md): Cessna 152 · S. Lake Tahoe, CA · Accident · 1 fatal · Field investigation · Final report · Apr 6, 1997 · N64845 · Destroyed
  > The pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…

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

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

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