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

## Cases, newest first

- [NTSB DEN05TA072](https://openairdocs.org/ntsb/DEN05TA072.md): Bell OH-58C · Colorado Sprngs, CO · Accident · No injuries · Final report · Apr 8, 2005 · N198PD · Substantial damage
  > the failure of the N1 tachometer generator which resulted in a precautionary landing. Contributing factors include the frayed wire and the unsuitable terrain for a precautionary landing.
- [NTSB CHI05CA093](https://openairdocs.org/ntsb/CHI05CA093.md): Piper PA-32RT-300 · St. Charles, MO · Accident · No injuries · Data collection · Final report · Apr 8, 2005 · N36691 · Substantial damage
  > The pilot's inadequate in-flight planning/decision by his failure to switch fuel tanks which resulted in fuel starvation and the loss of engine power. A factor was the trees.
- [NTSB LAX05FA132](https://openairdocs.org/ntsb/LAX05FA132.md): Cessna T210L · Tranquility, CA · Accident · 3 fatal · Field investigation · Final report · Apr 7, 2005 · N8126L · Destroyed
  > the pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…
- [NTSB DEN05FA124](https://openairdocs.org/ntsb/DEN05FA124.md): Piper PA-22-135 · Kremmling, CO · Accident · 2 fatal · Field investigation · Final report · Apr 7, 2005 · N3766A · Substantial damage
  > the pilot's failure to maintain clearance from terrain.
- [NTSB ATL05LA071](https://openairdocs.org/ntsb/ATL05LA071.md): Cessna 152 · Jacksonville, NC · Accident · No injuries · Limited investigation · Final report · Apr 5, 2005 · N48820 · Substantial damage
  > The loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.
- [NTSB DEN05FA047](https://openairdocs.org/ntsb/DEN05FA047.md): Beech E55 · Fort Collins, CO · Accident · 1 fatal · Field investigation · Final report · Apr 3, 2005 · N3FJ · Destroyed
  > the pilot's failure to maintain aircraft control. Contributing factors were the left engine loss of power for reasons undetermined, and the pilot allowing the airspeed to drop below Vmc during an attempted single-engine go-around.
- [NTSB IAD05LA051](https://openairdocs.org/ntsb/IAD05LA051.md): Cessna 182N · Marion, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2005 · N3292S · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in an encounter with icing conditions and the accretion of ice on the airframe. Also causal was the pilot's improper setting of the flaps in icing conditions in accordance with operating…
- [NTSB MIA05LA088](https://openairdocs.org/ntsb/MIA05LA088.md): Schweizer 269D · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Mar 29, 2005 · N4767 · Destroyed
  > An inflight collision with the ocean for undetermined reasons.
- [NTSB MIA05LA083](https://openairdocs.org/ntsb/MIA05LA083.md): Cessna 172S · Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 28, 2005 · N53589 · Substantial damage
  > The flight crews inadvertent encounter with turbulence in clouds while being vectored by ATC while operating in instrument meteorological conditions. A factor in the accident was the ATC personnel's (ARTCC) inadequate weather avoidance assistance.
- [NTSB CHI05CA087](https://openairdocs.org/ntsb/CHI05CA087.md): Piper PA-32-300 · Jeffersonville, IN · Accident · No injuries · Data collection · Final report · Mar 28, 2005 · N722RM · Substantial damage
  > The pilot's inadequate preflight of the aircraft by his failure to detect an open fuel drain which resulted in fuel starvation and the loss of engine power. Contributing factors were the pilot's failure to follow emergency procedures, low ceiling, fog and…
- [NTSB SEA05LA067](https://openairdocs.org/ntsb/SEA05LA067.md): Hoover Challenger II STD · La Grande, OR · Accident · 2 fatal · Limited investigation · Final report · Mar 26, 2005 · N4018G · Destroyed
  > The pilot's VFR flight into IMC and his failure to maintain clearance with terrain during cruise flight. Factors were the existing weather conditions that included low ceilings, snow, obscuration, and the mountainous, rising terrain.
- [NTSB LAX05LA278](https://openairdocs.org/ntsb/LAX05LA278.md): Robinson Helicopter R22 Beta · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Mar 26, 2005 · N820SH · Substantial damage
  > the instructor pilot's failure to apply carburetor heat during a simulated engine failure, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB CHI05LA079](https://openairdocs.org/ntsb/CHI05LA079.md): Cessna 210E · Bronson, MI · Accident · No injuries · Limited investigation · Final report · Mar 24, 2005 · N2380F · Substantial damage
  > The pilot's inadequate preflight preparation which failed to detect contaminated fuel that led to a loss of engine power. The unsuitable terrain encountered was a factor.
- [NTSB DEN05LA063](https://openairdocs.org/ntsb/DEN05LA063.md): Mooney M20F · Norwood, CO · Accident · No injuries · Limited investigation · Final report · Mar 20, 2005 · XB-FRU · Substantial damage
  > the reported partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DFW05CA090](https://openairdocs.org/ntsb/DFW05CA090.md): Cessna 172 · Nachogdoches, TX · Accident · Minor injuries · Data collection · Final report · Mar 19, 2005 · N12CT · Substantial damage
  > The pilot's improper in-flight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL05CA064](https://openairdocs.org/ntsb/ATL05CA064.md): Piper PA28-151 · Eastman, GA · Accident · No injuries · Data collection · Final report · Mar 19, 2005 · N32033 · Substantial damage
  > The certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.
- [NTSB IAD05LA045](https://openairdocs.org/ntsb/IAD05LA045.md): Cessna 152 · Port Royal, VA · Accident · No injuries · Limited investigation · Final report · Mar 16, 2005 · N64986 · Substantial damage
  > A loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.
- [NTSB NYC05LA060](https://openairdocs.org/ntsb/NYC05LA060.md): Piper PA-32-300 · Millersburg, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2005 · C-FLPB · Substantial damage
  > The pilot's inadequate preflight which resulted in a loss of engine power due to fuel contamination. A factor in the accident was the deteriorated fuel cap seals.
- [NTSB MIA05LA076](https://openairdocs.org/ntsb/MIA05LA076.md): Piper PA-28-180 · Bradfordville, FL · Accident · No injuries · Limited investigation · Final report · Mar 13, 2005 · N7706N · 2 aircraft · Substantial damage
  > The failure of ATC to provide traffic advisories and safety alerts required in class C airspace and the inability of both pilots to see and avoid each other (low wing on top, high wing below), resulting in the midair collision.
- [NTSB CHI05FA077](https://openairdocs.org/ntsb/CHI05FA077.md): Bombardier CL-600-2B19 · Milwaukee, WI · Accident · No injuries · Field investigation · Final report · Mar 12, 2005 · N8932C · Substantial damage
  > the captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…
- [NTSB SEA05CA060](https://openairdocs.org/ntsb/SEA05CA060.md): Birtch Kitfox II · Dillard, OR · Accident · No injuries · Data collection · Final report · Mar 11, 2005 · N481DB · Substantial damage
  > The pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.
- [NTSB NYC05LA059](https://openairdocs.org/ntsb/NYC05LA059.md): Piper PA-28-160 · Cameron, WV · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 2005 · N5946W · Substantial damage
  > A loss of engine power due to carburetor icing, which resulted in a forced landing. A factor in this accident was the carburetor icing conditions.
- [NTSB SEA05LA058](https://openairdocs.org/ntsb/SEA05LA058.md): Rotorway Exec 162F · Coos Bay, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 2005 · N20539 · Destroyed
  > The disintegration, for undetermined reasons, of the upper main drive pulley assembly bearing, while in cruise flight, leading to the decoupling of the main rotor drive assembly from the engine drive assembly. Factors include the absence of any suitable…
- [NTSB SEA05LA057](https://openairdocs.org/ntsb/SEA05LA057.md): Cessna 152 · Covington, WA · Accident · No injuries · Limited investigation · Final report · Mar 8, 2005 · N65579 · Substantial damage
  > The failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.
- [NTSB DFW05LA083](https://openairdocs.org/ntsb/DFW05LA083.md): Beech 77 · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2005 · N3870W · Substantial damage
  > The loss of engine power due to the failure of the number three connecting rod. Contributing factors were the foreign object located within the engine lubrication system, inadequate inspection of the engine by other maintenance personal, and the lack of…
- [NTSB ANC05LA046](https://openairdocs.org/ntsb/ANC05LA046.md): de Havilland DHC-2 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Mar 7, 2005 · N3307S · Substantial damage
  > Aerodynamic flutter of the ailerons during normal cruise flight due to their improper maintenance/balancing, which resulted in structural damage to the airplane's wings.
- [NTSB IAD05LA041](https://openairdocs.org/ntsb/IAD05LA041.md): Cessna 172B · Princeton, KY · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 2005 · N8211X · Substantial damage
  > A loss of engine power for undetermined reasons over unsuitable terrain.
- [NTSB CHI05LA076](https://openairdocs.org/ntsb/CHI05LA076.md): Cessna 177RG · Rochester, MN · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 2005 · N2019Q · Substantial damage
  > The loss of engine power due to oil starvation and the subsequent failure of a connecting rod. Additional causes were the improper maintenance due to under-torqued fasteners, and inadequate airframe manufacturer maintenance procedures resulting in an improper…
- [NTSB ATL05CA056](https://openairdocs.org/ntsb/ATL05CA056.md): Bellanca 17-30A · Eagleville, TN · Accident · Minor injuries · Data collection · Final report · Mar 4, 2005 · N4024B · Destroyed
  > The pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ATL05TA055](https://openairdocs.org/ntsb/ATL05TA055.md): Cessna T-41B · Sparta, TN · Accident · Serious injuries · Final report · Mar 3, 2005 · N14449 · Substantial damage
  > Improper installation of the timing reference plug by other maintenance personnel, which resulted in oil starvation, and the loss of engine power.
- [NTSB MIA05LA066](https://openairdocs.org/ntsb/MIA05LA066.md): Cessna 402C · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Mar 2, 2005 · N88TN · Substantial damage
  > The improper installation and securing of the elevator trim tab push-rod attaching hardware by maintenance personal resulting in the rod disconnecting and a partial separation of the right elevator in flight.
- [NTSB ANC05FA039](https://openairdocs.org/ntsb/ANC05FA039.md): Piper PA-32-300 · Dunnellon, FL · Accident · Serious injuries · Field investigation · Final report · Mar 2, 2005 · N444NM · Destroyed
  > The improper installation of the bolt that connects the throttle linkage to the fuel control arm by an unknown maintenance person, which resulted in a loss of the bolt, a loss of engine rpm control, and subsequent forced landing and collision with trees.
- [NTSB DFW05CA094](https://openairdocs.org/ntsb/DFW05CA094.md): Grumman G-164A · Tuckerman, AR · Accident · No injuries · Data collection · Final report · Feb 25, 2005 · N8501H · Substantial damage
  > The loss of engine power as result of the failure of the number nine cylinder.
- [NTSB CHI05LA073](https://openairdocs.org/ntsb/CHI05LA073.md): Piper PA-28-140 · Macon, MO · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 2005 · N4468T · Substantial damage
  > The loss of engine power due to failure of the engine exhaust valve. The pilot's inability to maintain clearance from obstacles, the trees, the residence and the pilot's evasive maneuver were factors in the accident.
- [NTSB ATL05LA052](https://openairdocs.org/ntsb/ATL05LA052.md): WSK PZL Mielec M-18A · Macedonia, SC · Accident · No injuries · Limited investigation · Final report · Feb 23, 2005 · N2296Y · Substantial damage
  > The fatigue cracking of the planetary gear housing, which resulted in the loss of engine power.
- [NTSB ANC05LA042](https://openairdocs.org/ntsb/ANC05LA042.md): Piper J-5A · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Feb 20, 2005 · N270JS · Substantial damage
  > The pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a collision with a snow berm during the landing flare. Factors contributing to the accident were flat light conditions, the presence of a snow berm along the edge of a…
- [NTSB SEA05LA049](https://openairdocs.org/ntsb/SEA05LA049.md): Mooney M20K · Roseburg, OR · Accident · No injuries · Limited investigation · Final report · Feb 16, 2005 · N1147D · Substantial damage
  > A fractured piston pin that resulted in a loss of engine power and subsequent forced landing. Factors include rough/uneven mountainous terrain.
- [NTSB DEN05LA058](https://openairdocs.org/ntsb/DEN05LA058.md): Cessna 172 · Montrose, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2005 · N3985F · Destroyed
  > the pilot's improper in-flight planning during the descent which resulted in partial loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to select carburetor heat during the descent and unsuitable terrain for the forced…
- [NTSB LAX05FA099](https://openairdocs.org/ntsb/LAX05FA099.md): Beech 95 · Calistoga, CA · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2005 · N8269D · Destroyed
  > The pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.
- [NTSB IAD05LA038](https://openairdocs.org/ntsb/IAD05LA038.md): Grumman G-21A · Penn Yan, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 2005 · N327 · Destroyed
  > The flight instructor's inadequate planning/decision and his remedial action to conduct or recover from a simulated emergency procedure.
- [NTSB DFW05CA068](https://openairdocs.org/ntsb/DFW05CA068.md): Beech BE77 · Angleton, TX · Accident · No injuries · Data collection · Final report · Feb 13, 2005 · N6717S · Substantial damage
  > The loss of engine power as result of fuel exhaustion due to the pilot's improper in-flight planning. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX05LA105](https://openairdocs.org/ntsb/LAX05LA105.md): Saab-Scania Saab 340B · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 2005 · N394AE · No damage
  > the in-flight encounter with turbulence.
- [NTSB ANC05LA032](https://openairdocs.org/ntsb/ANC05LA032.md): Johnson Revolution Mini 500 · Isabela, PR · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2005 · N38DJ · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in an autorotation and collision with terrain.
- [NTSB LAX05FA092](https://openairdocs.org/ntsb/LAX05FA092.md): Cessna P210N · Lebec, CA · Accident · 2 fatal · Field investigation · Final report · Feb 11, 2005 · N432AR · Destroyed
  > the pilot's in-flight loss of control due to the flight's encounter with unforecasted localized mountain wave activity with severe to potentially extreme turbulence, downdrafts, and rotors.
- [NTSB SEA05LA048](https://openairdocs.org/ntsb/SEA05LA048.md): Piper PA-28-140 · Superior, MT · Accident · No injuries · Limited investigation · Final report · Feb 9, 2005 · N6399W · Substantial damage
  > A loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.
- [NTSB ANC05LA027](https://openairdocs.org/ntsb/ANC05LA027.md): Cessna U206 · Port Alsworth, AK · Accident · 3 fatal · Limited investigation · Final report · Feb 9, 2005 · N206AR · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions (IMC), his improper in-flight planning and decision making, and his failure to maintain clearance from terrain while maneuvering to reverse direction at a low altitude. Factors…
- [NTSB LAX05FA088](https://openairdocs.org/ntsb/LAX05FA088.md): Cirrus Design SR22 G2 · Norden, CA · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2005 · N286CD · Destroyed
  > the pilot's in-flight loss of control following an inadvertent encounter with unforecast severe icing conditions. A factor in the accident was the inaccurate icing forecast developed by the NWS Aviation Weather Center.
- [NTSB LAX05LA087](https://openairdocs.org/ntsb/LAX05LA087.md): Cessna 152 · Hana, HI · Accident · No injuries · Limited investigation · Final report · Feb 6, 2005 · N7332L · Substantial damage
  > Foreign object damage inside an engine cylinder, which resulted in a loss of engine power during climb to cruise, and an off-airport forced landing.
- [NTSB SEA05CA045](https://openairdocs.org/ntsb/SEA05CA045.md): Cessna 182G · Redmond, OR · Accident · Minor injuries · Data collection · Final report · Feb 4, 2005 · N3127S · Substantial damage
  > The pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Trees were factors.
- [NTSB CHI05FA063](https://openairdocs.org/ntsb/CHI05FA063.md): Beech BE-58 · Niles, MI · Accident · 4 fatal · Field investigation · Final report · Feb 4, 2005 · N12AZ · Destroyed
  > The steep nose down descent from cruise for undetermined reasons and the subsequent collision with terrain in a steep nose down attitude.

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

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

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