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

## Cases, newest first

- [NTSB FTW95LA098](https://openairdocs.org/ntsb/FTW95LA098.md): Robinson R22 Beta · Placitas, NM · Accident · No injuries · Limited investigation · Final report · Jan 22, 1995 · N269ME · Substantial damage
  > The pilot operated beyond the climb capability of the helicopter, resulting in inadequate altitude and terrain clearance over mountainous rising terrain. A factor was turbulence.
- [NTSB SEA95LA040](https://openairdocs.org/ntsb/SEA95LA040.md): Cessna A185E · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Jan 21, 1995 · N748 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI95FA071](https://openairdocs.org/ntsb/CHI95FA071.md): Bacon QUESTAIR-VENTURE · Des Moines, IA · Accident · 2 fatal · Field investigation · Final report · Jan 21, 1995 · N4QV · Destroyed
  > The pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall/spin. Factors were material defects in the material used to manufacture the crankshaft, resulting in the crankshaft fracturing after approximately 200 hours in…
- [NTSB FTW95LA097](https://openairdocs.org/ntsb/FTW95LA097.md): Cessna 150M · Prescott, AR · Accident · No injuries · Limited investigation · Final report · Jan 20, 1995 · N704CH · Substantial damage
  > Fuel exhaustion due to the pilot's failure to refuel. Factors were the pilot's disorientation and lack of suitable terrain for a forced landing.
- [NTSB MIA95FA060](https://openairdocs.org/ntsb/MIA95FA060.md): Piper PA-28-236 · York, SC · Accident · 2 fatal · Field investigation · Final report · Jan 19, 1995 · N8423B · Destroyed
  > The noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…
- [NTSB ATL95LA042](https://openairdocs.org/ntsb/ATL95LA042.md): Matto KR-2A Modified · Boone, NC · Accident · No injuries · Limited investigation · Final report · Jan 18, 1995 · N612W · Substantial damage
  > The failure of the propeller retaining bolts for an undetermined reason, which resulted in the separation of the propeller from the engine. The rising, mountainous terrain was a factor.
- [NTSB BFO95LA027](https://openairdocs.org/ntsb/BFO95LA027.md): Cessna 310Q · Clarion, PA · Accident · Serious injuries · Limited investigation · Final report · Jan 16, 1995 · N7943Q · Destroyed
  > The failure of the right wing de-ice boot during operation in conditions of ice accumulation, which resulted in a loss of aircraft controllability during the approach/landing. The icing condition was a factor.
- [NTSB LAX95FA079](https://openairdocs.org/ntsb/LAX95FA079.md): Bell 206B · Los Angeles, CA · Accident · 2 fatal · Field investigation · Final report · Jan 15, 1995 · N2209P · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's and operator's failure to follow their established dispatch procedures, the pilot's poor judgment in initiating the flight,…
- [NTSB ANC95LA028](https://openairdocs.org/ntsb/ANC95LA028.md): Cessna 172 · Anvik, AK · Accident · No injuries · Limited investigation · Final report · Jan 15, 1995 · N6867X · Substantial damage
  > The pilot's failure to follow the procedure in the pilot's operating handbook concerning the uneven distribution of fuel, and starvation of the fuel intake line by unporting.
- [NTSB SEA95FA037](https://openairdocs.org/ntsb/SEA95FA037.md): Cessna 172N · Blyn, WA · Accident · 3 fatal · Field investigation · Final report · Jan 14, 1995 · N1535E · Destroyed
  > The pilot's VFR flight into instrument meteorological conditions. Factors in the accident were the weather conditions and the dark night.
- [NTSB LAX95FA077](https://openairdocs.org/ntsb/LAX95FA077.md): Cessna 208B · Pleasanton, CA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1995 · N754FE · Destroyed
  > failure of the pilot-in-command to maintain visual contact with terrain and sufficient altitude for terrain clearance. Factors in the accident were the pilot's decision to initiate a descent 14 miles from the airport, and weather, specifically cloud…
- [NTSB CHI95IA066](https://openairdocs.org/ntsb/CHI95IA066.md): Beech 1900D · Williston, ND · Incident · No injuries · Incident investigation · Final report · Jan 12, 1995 · N118UX · Minor damage
  > the improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.
- [NTSB ATL95FA044](https://openairdocs.org/ntsb/ATL95FA044.md): Piper PA-28-161 · Spring City, TN · Accident · 1 fatal · Field investigation · Final report · Jan 12, 1995 · N75PF · Destroyed
  > The pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.
- [NTSB ATL95FA036](https://openairdocs.org/ntsb/ATL95FA036.md): Cessna 414 · Augusta, GA · Accident · 4 fatal · Field investigation · Final report · Jan 12, 1995 · N13SE · Destroyed
  > The loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.
- [NTSB NYC95FA049](https://openairdocs.org/ntsb/NYC95FA049.md): Beech G35 · West Palm Beach, FL · Accident · 1 fatal · Field investigation · Final report · Jan 9, 1995 · N32TS · Destroyed
  > Improper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…
- [NTSB MIA95LA056](https://openairdocs.org/ntsb/MIA95LA056.md): Mooney 20J · St. Petersburg, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1995 · N205MD · Substantial damage
  > The failure of the No. 3 connecting rod bolt due to oil starvation for undetermined reasons. This resulted in a total loss of engine power, forced landing, and subsequent ditching.
- [NTSB MIA95LA055](https://openairdocs.org/ntsb/MIA95LA055.md): McDonnell Douglas MD-88 · Monroe, LA · Accident · Serious injuries · Limited investigation · Final report · Jan 6, 1995 · N981DL · No damage
  > an in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.
- [NTSB FTW95FA084](https://openairdocs.org/ntsb/FTW95FA084.md): Piper PA-30 · Georgetown, TX · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1995 · N8398Y · Destroyed
  > Loss of power in both engines and loss of aircraft control for unknown reasons.
- [NTSB FTW95FA082](https://openairdocs.org/ntsb/FTW95FA082.md): Beech A60 · Hurley, NM · Accident · 3 fatal · Field investigation · Final report · Jan 6, 1995 · N3LP · Destroyed
  > The pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…
- [NTSB LAX95LA074](https://openairdocs.org/ntsb/LAX95LA074.md): Cessna 152 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jan 5, 1995 · N25953 · Substantial damage
  > The improper supervision of the student pilot by the instructor by allowing the student to inadvertently pull the mixture control handle too far out causing the engine to lose power. The wet terrain condition was a factor.
- [NTSB CHI95LA065](https://openairdocs.org/ntsb/CHI95LA065.md): Lake LA-4-200 · Int'L Falls, MN · Accident · No injuries · Limited investigation · Final report · Jan 4, 1995 · CFGDZ · Substantial damage
  > engine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.
- [NTSB BFO95FA026](https://openairdocs.org/ntsb/BFO95FA026.md): Piper PA-28-181 · Miamisburg, OH · Accident · 1 fatal · Field investigation · Final report · Jan 4, 1995 · N8435P · Destroyed
  > The pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.
- [NTSB MIA95LA054](https://openairdocs.org/ntsb/MIA95LA054.md): Bell 47G · Bunnell, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 1995 · N6172 · Substantial damage
  > The pilot's failure to maintain altitude while descending over a lake, resulting in an in-flight collision with water.
- [NTSB LAX95FA072](https://openairdocs.org/ntsb/LAX95FA072.md): Cessna A185F · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Jan 3, 1995 · N94296 · Destroyed
  > The noninstrument-rated pilot's continued flight into known adverse weather, and his failure to maintain adequate airspeed while maneuvering to reverse direction. Factors relating to the accident were: the mountainous terrain, and adverse weather conditions.
- [NTSB LAX95LA070](https://openairdocs.org/ntsb/LAX95LA070.md): Aero Commander 200D · Lancaster, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 2, 1995 · N200AW · Substantial damage
  > fuel starvation due to the pilot's failure to select a tank containing fuel.
- [NTSB ATL95LA032](https://openairdocs.org/ntsb/ATL95LA032.md): Beech V35B · Union City, TN · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 1995 · N77FH · Substantial damage
  > The improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.
- [NTSB MIA95LA051](https://openairdocs.org/ntsb/MIA95LA051.md): Piper PA-28-161 · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Dec 31, 1994 · N4300S · Substantial damage
  > Fatigue failure of the engine no.1 valve spring that jammed the intake valve open resulting in partial loss of engine power.
- [NTSB LAX95LA067](https://openairdocs.org/ntsb/LAX95LA067.md): Harris BD-10 · Gardnerville, NV · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 1994 · N9WZ · Destroyed
  > the in-flight overload failure of the left vertical stabilizer spars, at force levels substantially below the predicted ultimate failure loads, due to inadequate substantiation by the designer.
- [NTSB LAX95FA340](https://openairdocs.org/ntsb/LAX95FA340.md): Cessna 182B · Rancho Cucamong, CA · Accident · 1 fatal · Field investigation · Final report · Dec 31, 1994 · N2569G · Destroyed
  > the failure of the pilot to maintain adequate altitude above mountainous terrain.
- [NTSB LAX95FA068](https://openairdocs.org/ntsb/LAX95FA068.md): Grumman AA-5A · San Luis Obispo, CA · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1994 · N26443 · Destroyed
  > the pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…
- [NTSB CHI95LA064](https://openairdocs.org/ntsb/CHI95LA064.md): North American F-51D · Round Lake, IL · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1994 · N51TK · Substantial damage
  > fuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.
- [NTSB SEA95LA033](https://openairdocs.org/ntsb/SEA95LA033.md): Cessna 182 · Murphy, ID · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1994 · N9107X · Destroyed
  > The pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.
- [NTSB MIA95FA042](https://openairdocs.org/ntsb/MIA95FA042.md): Piper PA-32-260 · Plant City, FL · Accident · Serious injuries · Field investigation · Final report · Dec 28, 1994 · N33456 · Destroyed
  > The opening of the engine cowling latch in cruise flight for undetermined reasons. This resulted in the puncture of the engine oil cooler, total exhaustion of the engine oil, failure of the No. 6 connecting rod, rod bolts, forced landing while on final…
- [NTSB LAX95LA061](https://openairdocs.org/ntsb/LAX95LA061.md): Cessna 150L · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Dec 27, 1994 · N7446G · Substantial damage
  > the pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.
- [NTSB FTW95FA075](https://openairdocs.org/ntsb/FTW95FA075.md): Piper PA-24-250 · Van Horn, TX · Accident · 2 fatal · Field investigation · Final report · Dec 27, 1994 · N8112P · Destroyed
  > The pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.
- [NTSB MIA95LA049](https://openairdocs.org/ntsb/MIA95LA049.md): Piper PA-22-150 · Tavares, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1994 · N2829P · Substantial damage
  > The failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.
- [NTSB LAX95LA060](https://openairdocs.org/ntsb/LAX95LA060.md): Piper PA-28R-180 · Searchlight, NV · Accident · 1 fatal · Limited investigation · Final report · Dec 24, 1994 · N3836T · Destroyed
  > the pilot's intentional continued flight into instrument meteorological conditions in mountainous terrain.
- [NTSB FTW95LA072](https://openairdocs.org/ntsb/FTW95LA072.md): Piper PA-12 · La Porte, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1994 · N2820M · Substantial damage
  > Loss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.
- [NTSB MIA95LA048](https://openairdocs.org/ntsb/MIA95LA048.md): Piper PA-28-140 · La Belle, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1994 · N41774 · Substantial damage
  > Partial loss of engine power due to total failure of the no. 3 cylinder exhaust valve for undetermined reasons. Also, unsuitable terrain encountered during the forced landing.
- [NTSB ATL95LA030](https://openairdocs.org/ntsb/ATL95LA030.md): Cessna 150G · Rhine, GA · Accident · No injuries · Limited investigation · Final report · Dec 23, 1994 · N3221J · Substantial damage
  > The failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.
- [NTSB CHI95FA061](https://openairdocs.org/ntsb/CHI95FA061.md): Piper PA-46-350P · Rochester, MN · Accident · 3 fatal · Field investigation · Final report · Dec 22, 1994 · N133MA · Destroyed
  > Failure of the pilot to maintain control of the airplane, while climbing in instrument meteorological conditions (IMC) after takeoff. Factors related to the accident were: fog, low ceiling, the pilot's lack of recent instrument experience, and the excessive…
- [NTSB BFO95LA022](https://openairdocs.org/ntsb/BFO95LA022.md): Cessna 172C · Laurel, MD · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1994 · N1620Y · Destroyed
  > The pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.
- [NTSB SEA95LA034](https://openairdocs.org/ntsb/SEA95LA034.md): Cessna T210 · Kellogg, ID · Accident · No injuries · Limited investigation · Final report · Dec 21, 1994 · N4607Q · Substantial damage
  > The pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.
- [NTSB LAX95LA058](https://openairdocs.org/ntsb/LAX95LA058.md): Render LONG-EZ · Kailua-Kona, HI · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1994 · N3250K · Destroyed
  > a delamination of the wooden propeller.
- [NTSB SEA95FA031](https://openairdocs.org/ntsb/SEA95FA031.md): Piper PA-32R-300 · Grantsville, UT · Accident · 4 fatal · Field investigation · Final report · Dec 19, 1994 · N175MC · Destroyed
  > The VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.
- [NTSB FTW95LA068](https://openairdocs.org/ntsb/FTW95LA068.md): Cessna A150L · Newark, TX · Accident · No injuries · Limited investigation · Final report · Dec 18, 1994 · N6030J · Substantial damage
  > The loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.
- [NTSB FTW95FA069](https://openairdocs.org/ntsb/FTW95FA069.md): Piper PA-32RT · San Antonio, TX · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1994 · N21590 · Destroyed
  > The loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.
- [NTSB FTW95LA067](https://openairdocs.org/ntsb/FTW95LA067.md): Timothy J Brown Pitts S2SE · Grand Prairie, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 1994 · N604SB · Destroyed
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.
- [NTSB DCA95MA007](https://openairdocs.org/ntsb/DCA95MA007.md): Learjet 35A · Fresno, CA · Accident · 2 fatal · Class 1 · Major · Final report · Dec 14, 1994 · N521PA · Destroyed
  > 1) Improperly installed electrical wiring for special mission operations that led to an in-flight fire that caused airplane systems and structural damage and subsequent airplane control difficulties; 2) improper maintenance and inspection procedures followed…
- [NTSB BFO95FA020](https://openairdocs.org/ntsb/BFO95FA020.md): Piper PA-28R-200 · Nesquehoning, PA · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1994 · N33049 · Destroyed
  > the non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…

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

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

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