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

## Cases, newest first

- [NTSB NYC99FA033](https://openairdocs.org/ntsb/NYC99FA033.md): Gulfstream American AA-1 · Brooklyn, CT · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1998 · N6166L · Destroyed
  > The student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.
- [NTSB DEN99FA024](https://openairdocs.org/ntsb/DEN99FA024.md): Robinson R-22 Beta II · Deming, NM · Accident · 1 fatal · Field investigation · Final report · Dec 4, 1998 · N8340J · Destroyed
  > The pilot's failure to maintain clearance of the transmission wire. Factors were the transmission wire, and the glaring sunlight condition.
- [NTSB CHI99LA048](https://openairdocs.org/ntsb/CHI99LA048.md): Bellanca 8GCBC · Burlington, WI · Accident · No injuries · Limited investigation · Final report · Dec 4, 1998 · N395AC · Substantial damage
  > Carburetor ice, the pilot's inadequate pre-flight planning/preparation resulting in his flight into poor weather conditions, and the pilot's improper use of carburetor heat. Factors contributing to this accident were the carburetor icing conditions, the…
- [NTSB ANC99LA015](https://openairdocs.org/ntsb/ANC99LA015.md): Stinson 10A · Nondalton, AK · Accident · No injuries · Limited investigation · Final report · Dec 4, 1998 · N36755 · Substantial damage
  > The pilot's continued operation of the airplane with known deficiencies, a failure of company maintenance personnel to replace an inoperative fuel gauge, and subsequent fuel exhaustion. Factors in the accident were siphoning of fuel from the right wing fuel…
- [NTSB NYC99FA032](https://openairdocs.org/ntsb/NYC99FA032.md): Eurocopter EC-135-P1 · Newark, NJ · Accident · Minor injuries · Field investigation · Final report · Dec 3, 1998 · N44NY · Destroyed
  > the pilot's failure to maintain proper rotor rpm and his improper in flight decision to enter autorotation due to his lack of knowledge of the power plant controls. Factors in the accident were the night conditions and the pilot's improper decision to fly…
- [NTSB ATL99LA027](https://openairdocs.org/ntsb/ATL99LA027.md): Cessna 150 · Columbia, NC · Accident · No injuries · Limited investigation · Final report · Dec 3, 1998 · N18022 · Substantial damage
  > The failure of the #2 exhaust valve that resulted in the total loss of engine power. A factor is the lack of suitable emergency landing terrain.
- [NTSB FTW99FA041](https://openairdocs.org/ntsb/FTW99FA041.md): Cessna 501 · Umpire, AR · Accident · 1 fatal · Field investigation · Final report · Dec 2, 1998 · N501EZ · Destroyed
  > The pilot's in flight loss of control for undetermined reasons.
- [NTSB MIA99LA039](https://openairdocs.org/ntsb/MIA99LA039.md): Aerospatiale ATR-72-212 · Fort Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 1998 · N414WF · No damage
  > an abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.
- [NTSB SEA99LA016](https://openairdocs.org/ntsb/SEA99LA016.md): McDonnell Douglas MD-900 · Idaho City, ID · Accident · No injuries · Limited investigation · Final report · Nov 30, 1998 · N977LF · Substantial damage
  > The pilot-in-command's not obtaining/maintaining clearance with the unmarked transmission lines. Contributing factors were environmental (dusk) conditions, the transmission lines, and both the pilot-in-command and the ground personnel not identifying the…
- [NTSB MIA99LA045](https://openairdocs.org/ntsb/MIA99LA045.md): Quicksilver MXL-2 · Humacao, PR · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1998 · N6153E · Substantial damage
  > The pilot's use of a synthetic oil that is not recommended by the engine manufacturer when premixing his two cycle gasoline/oil fuel mixture, resulting is a total loss of engine power due to decreased lubricating properties, and the subsequent forced landing…
- [NTSB IAD99FA023](https://openairdocs.org/ntsb/IAD99FA023.md): Armbruster MINI-500 · Midland, VA · Accident · 1 fatal · Field investigation · Final report · Nov 29, 1998 · N500GH · Destroyed
  > the improper repair of the engine following a previous engine seizure which resulted in the loss of engine power over unsuitable terrain.
- [NTSB ATL99LA026](https://openairdocs.org/ntsb/ATL99LA026.md): Beech 65-A90 · La Tortue, Haiti · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1998 · N171TE · Destroyed
  > Inadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).
- [NTSB FTW99FA038](https://openairdocs.org/ntsb/FTW99FA038.md): Blanton RAF 2000 · The Colony, TX · Accident · 1 fatal · Field investigation · Final report · Nov 28, 1998 · N14GR · Destroyed
  > The pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.
- [NTSB ATL99LA024](https://openairdocs.org/ntsb/ATL99LA024.md): Beech 33-F33A · Fernandina Bch, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1998 · N69FL · Substantial damage
  > The Pilot's failure to maintain flying airspeed that resulted in a loss of control and an inadvertent stall. Factors were several electrical system component malfunction.
- [NTSB NYC99LA031](https://openairdocs.org/ntsb/NYC99LA031.md): Piper PA-28-180 · Reno, OH · Accident · No injuries · Limited investigation · Final report · Nov 25, 1998 · N7177W · Substantial damage
  > The pilot's disregard of the information provided by the fuel gauges, which resulted in fuel exhaustion. Factors in the accident included leaks in the fuel system, and the pilot's reliance on using timing alone to determine fuel consumption.
- [NTSB LAX99LA040](https://openairdocs.org/ntsb/LAX99LA040.md): Grumman-Schweizer G-164C · Oroville, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1998 · N6596K · Substantial damage
  > The pilot's decision to attempt readjustment of the rudder pedal in-flight.
- [NTSB ATL99LA031](https://openairdocs.org/ntsb/ATL99LA031.md): Piper PA-28-140 · Aiken, SC · Accident · No injuries · Limited investigation · Final report · Nov 25, 1998 · N3350T · Substantial damage
  > The pilot's failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.
- [NTSB ATL99LA023](https://openairdocs.org/ntsb/ATL99LA023.md): Cessna 175 · Locust Grove, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1998 · N565ML · Substantial damage
  > Loss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.
- [NTSB FTW99FA033](https://openairdocs.org/ntsb/FTW99FA033.md): Cessna 172N · Bacliff, TX · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1998 · N4908D · Substantial damage
  > The pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.
- [NTSB LAX99LA039](https://openairdocs.org/ntsb/LAX99LA039.md): Varga 2150A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Nov 22, 1998 · N78114 · Substantial damage
  > Fuel exhaustion due to the pilot's failure to perform an adequate preflight of the aircraft to ensure that adequate fuel was available for the flight.
- [NTSB CHI99LA034](https://openairdocs.org/ntsb/CHI99LA034.md): Piper PA-12 · Carrol, IA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1998 · N92585 · Substantial damage
  > the pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.
- [NTSB CHI99LA032](https://openairdocs.org/ntsb/CHI99LA032.md): Piper PA-28-180 · Iowa Falls, IA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1998 · N2691T · Substantial damage
  > the pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.
- [NTSB LAX99LA054](https://openairdocs.org/ntsb/LAX99LA054.md): Williams Hurrican HP · Corona, CA · Accident · No injuries · Limited investigation · Final report · Nov 21, 1998 · N323DW · Substantial damage
  > The seizure of the engine due to a cylinder/piston overheat condition for undetermined reasons.
- [NTSB LAX99FA038](https://openairdocs.org/ntsb/LAX99FA038.md): Cessna T210L · Oakland, CA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 1998 · N9222T · Destroyed
  > The pilot-in-command's inadequate fuel management which led to fuel starvation and subsequent loss of engine power. Also causal was the pilot's failure to maintain adequate altitude and his ostentatious display.
- [NTSB NYC99FA026](https://openairdocs.org/ntsb/NYC99FA026.md): Cessna 414A · Mattapoisett, MA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1998 · N6820J · Destroyed
  > The pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.
- [NTSB FTW99LA032](https://openairdocs.org/ntsb/FTW99LA032.md): Piper PA32-300 · New Iberia, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 1998 · N2881U · Substantial damage
  > The mechanic's failure to properly torque the connecting rod's bolt and nut during engine overhaul. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX99LA034](https://openairdocs.org/ntsb/LAX99LA034.md): Cessna 152 · Orinda, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 1998 · N48201 · Destroyed
  > A loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.
- [NTSB FTW99LA027](https://openairdocs.org/ntsb/FTW99LA027.md): Mooney M20J · San Angelo, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1998 · N201QK · Substantial damage
  > The total loss of engine power due to the magneto failure resulting from oil contamination when the bearing plate retainer screw fractured due to improper manufacturing. Factors were the lack of suitable terrain for the forced landing, and the dark night…
- [NTSB SEA99FA015](https://openairdocs.org/ntsb/SEA99FA015.md): Piper PA-23-150 · Ferndale, WA · Accident · Serious injuries · Field investigation · Final report · Nov 16, 1998 · CFJXG · Substantial damage
  > The pilot's improper decision to attempt to reach his final destination after a partial loss of engine power, instead of making a precautionary landing at one of the airports he overflew along his route. Factors include an inadequate preflight, a fuel filter…
- [NTSB ATL99FA019](https://openairdocs.org/ntsb/ATL99FA019.md): Cessna 182P · Santee, SC · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1998 · N6522M · Destroyed
  > The pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.
- [NTSB MIA99FA034](https://openairdocs.org/ntsb/MIA99FA034.md): Piper PA-32R-301 · Olive Branch, MS · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1998 · N83396 · Destroyed
  > The pilot's failure to follow IFR procedures when he descended below the published minimum descent altitude.
- [NTSB CHI99FA029](https://openairdocs.org/ntsb/CHI99FA029.md): Cessna 182F · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Nov 14, 1998 · N3240U · Substantial damage
  > The pilot's inadequate preflight inspection and contaminated fuel supply.
- [NTSB ATL99FA016](https://openairdocs.org/ntsb/ATL99FA016.md): Cessna 152 · Daytona Beach, FL · Accident · 1 fatal · Field investigation · Final report · Nov 14, 1998 · N48882 · Substantial damage
  > An interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.
- [NTSB MIA99LA032](https://openairdocs.org/ntsb/MIA99LA032.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 12, 1998 · N48013 · Substantial damage
  > The loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.
- [NTSB LAX99LA029](https://openairdocs.org/ntsb/LAX99LA029.md): Piper PA-28-150 · Gila Bend, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 1998 · N991PK · Substantial damage
  > The crankshaft gear attach bolt loosening and backing out of its crankshaft bore, which led to the fatigue failure of the crankshaft gear dowel pin due to excessive working of the gear. The sequence of failures was the result of the engine overhaul shop's…
- [NTSB IAD99LA015](https://openairdocs.org/ntsb/IAD99LA015.md): Bell 206-B · Louisville, KY · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1998 · N32KY · Substantial damage
  > A loose 'B' nut on the aircraft's PC Air line which resulted in fuel starvation, and the pilot's abrupt application of aft cyclic to prevent a nose over. Contributing factors were soft terrain and dark night conditions.
- [NTSB DEN99LA020](https://openairdocs.org/ntsb/DEN99LA020.md): Piper PA-28-161 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Nov 11, 1998 · N8236Z · Destroyed
  > The shorting of the aluminum battery wire and the subsequent failure of the fuel line. Factors were the weak/deteriorated battery, the insufficient information in the airplane's POH about charging an airplane's battery, and the fire in the crew compartment.
- [NTSB SEA99FA013](https://openairdocs.org/ntsb/SEA99FA013.md): Hiller UH-12E · Marshall, WA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 1998 · N752GB · Destroyed
  > The loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.
- [NTSB FTW99LA023](https://openairdocs.org/ntsb/FTW99LA023.md): Beech 35-C33 · Tulsa, OK · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 1998 · N24TH · Substantial damage
  > The loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW99FA020](https://openairdocs.org/ntsb/FTW99FA020.md): Beech B19 · Hobart, OK · Accident · 2 fatal · Field investigation · Final report · Nov 8, 1998 · N9740L · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.
- [NTSB ATL99LA013](https://openairdocs.org/ntsb/ATL99LA013.md): Cessna 172N · Lima, SC · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1998 · N4696G · Destroyed
  > The flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.
- [NTSB MIA99FA031](https://openairdocs.org/ntsb/MIA99FA031.md): Piper PA-28-151 · Chattanooga, TN · Accident · Minor injuries · Field investigation · Final report · Nov 7, 1998 · N44240 · Substantial damage
  > The pilot's inadequate in-flight planning/decision which led to fuel exhaustion.
- [NTSB ATL99LA012](https://openairdocs.org/ntsb/ATL99LA012.md): AeroSport WS-15-2 · Parkton, NC · Accident · No injuries · Limited investigation · Final report · Nov 7, 1998 · N88760 · Substantial damage
  > The collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.
- [NTSB SEA99TA010](https://openairdocs.org/ntsb/SEA99TA010.md): Cessna TR182 · Desert Aire, WA · Accident · 2 fatal · Final report · Nov 6, 1998 · N756YE · Substantial damage
  > The pilot's failure to maintain adequate altitude and/or clearance over a power line crossing the river, resulting in collision with a static wire at the top of the crossing structure. Factors included the static wire, and inadequate marking of the static…
- [NTSB LAX99FA028](https://openairdocs.org/ntsb/LAX99FA028.md): Piper PA-28R-200 · Bishop, CA · Accident · 3 fatal · Field investigation · Final report · Nov 6, 1998 · N2737R · Destroyed
  > The failure of the pilot-in-command, after encountering a downdraft, to maneuver and maintain clearance from mountainous terrain. Physical impairment due to hypoxia was a factor in the accident.
- [NTSB CHI99LA026](https://openairdocs.org/ntsb/CHI99LA026.md): Tomschin Mini 500 · Clinton, MN · Accident · No injuries · Limited investigation · Final report · Nov 6, 1998 · N316AZ · Substantial damage
  > the non-pilot's failure to maintain clearance from the power lines. Factors contributing to this accident were the non-pilot's lack of total experience and the power lines.
- [NTSB CHI99FA023](https://openairdocs.org/ntsb/CHI99FA023.md): Mitsubishi MU-2B-60 · Rock, KS · Accident · 2 fatal · Field investigation · Final report · Nov 5, 1998 · N5LN · Destroyed
  > the pilot failed to maintain control of the aircraft and made an improper evaluation of the weather. Additional factors were flying a test flight at night with the icing conditions in the clouds.
- [NTSB LAX99LA024](https://openairdocs.org/ntsb/LAX99LA024.md): Cessna T210L · Lodi, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 4, 1998 · N29058 · Destroyed
  > Fuel exhaustion due to a leaking engine driven fuel pump nose seal, which increased the engine fuel consumption rate above the published performance chart values.
- [NTSB IAD99GA013](https://openairdocs.org/ntsb/IAD99GA013.md): Schweizer 269C · Baltimore, MD · Accident · 1 fatal · Final report · Nov 4, 1998 · N2100B · Destroyed
  > inadequate assembly instructions from the engine manufacturer which resulted in improper engine assembly, and subsequent power loss over unsuitable terrain, with insufficient altitude for a successful autorotation.
- [NTSB ATL99FA136](https://openairdocs.org/ntsb/ATL99FA136.md): Piper PA-28-180 · Robbinsville, NC · Accident · 1 fatal · Field investigation · Final report · Nov 4, 1998 · N2820T · Destroyed
  > "This case was changed from ATL05FA014." The pilot's improper in-flight decision to continue VFR flight into IMC, which resulted in an in-flight encounter with weather and controlled flight into terrain. Factors were the pilot's inadequate preflight planning…

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

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

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