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

## Cases, newest first

- [NTSB LAX06FA104](https://openairdocs.org/ntsb/LAX06FA104.md): Robinson R44 II · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2006 · N447SH · Substantial damage
  > The divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in main rotor/tail boom contact and loss of control.
- [NTSB SEA06LA052](https://openairdocs.org/ntsb/SEA06LA052.md): Robinson R44 · Helena, MT · Accident · 1 fatal · Limited investigation · Final report · Feb 6, 2006 · N7085U · Destroyed
  > The pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.
- [NTSB CHI06LA078](https://openairdocs.org/ntsb/CHI06LA078.md): Cirrus Design SR22 · Wagner, SD · Accident · No injuries · Limited investigation · Final report · Feb 6, 2006 · N751CD · Substantial damage
  > The pilot not maintaining airplane control and the inadvertent stall encountered during the climb. A factor was the instrument meteorological conditions.
- [NTSB DFW06CA064](https://openairdocs.org/ntsb/DFW06CA064.md): Wsk-Pzl Warzawaokecie PZL-104 Wilga 80 · Comstock, TX · Accident · No injuries · Data collection · Final report · Feb 2, 2006 · N192D · Substantial damage
  > The pilot's inadequate preflight planning and preparation leading to him becoming lost. Contributing factors were the unfavorable winds and the lack of suitable terrain for a precautionary landing.
- [NTSB LAX06FA099](https://openairdocs.org/ntsb/LAX06FA099.md): Beechcraft F33A · Buckeye, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 1, 2006 · N1563A · Destroyed
  > The student pilot's failure to maintain aircraft control for undetermined reasons.
- [NTSB ATL06CA042](https://openairdocs.org/ntsb/ATL06CA042.md): Cessna T210N · Rome, GA · Accident · No injuries · Data collection · Final report · Feb 1, 2006 · N2134U · Substantial damage
  > The pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB LAX06LA098](https://openairdocs.org/ntsb/LAX06LA098.md): Eurocopter AS350D · Kahului, HI · Accident · No injuries · Limited investigation · Final report · Jan 29, 2006 · N90Q · Substantial damage
  > A total loss of engine power due to the internal effects on the bearings consistent with an operating event of insufficient oil supply. Contributing to the accident was the pilot’s improper flare during the autorotative descent.
- [NTSB NYC06LA064](https://openairdocs.org/ntsb/NYC06LA064.md): Piper PA-28-161 · Smoketown, PA · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 2006 · N9183Y · Substantial damage
  > The pilot's improper pre-flight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.
- [NTSB ATL06FA038](https://openairdocs.org/ntsb/ATL06FA038.md): Piper PA-32R-300 · Camden, AL · Accident · 1 fatal · Field investigation · Final report · Jan 28, 2006 · N38510 · Destroyed
  > The pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.
- [NTSB MIA06LA049](https://openairdocs.org/ntsb/MIA06LA049.md): Globe GC-1B · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 26, 2006 · N3292K · Substantial damage
  > A loss of engine power during descent due to an undetermined reason, which resulted in an off-airport forced landing and collision with a culvert.
- [NTSB DEN06LA036](https://openairdocs.org/ntsb/DEN06LA036.md): Cessna 172C · Pagosa Springs, CO · Accident · No injuries · Limited investigation · Final report · Jan 25, 2006 · N1407Y · Substantial damage
  > the pilot initiating flight into known adverse weather, and his delay in not taking remedial action sooner by not making a precautionary landing. Contributing factors include the pilot's failure to obtain preflight and in-flight weather briefings, his…
- [NTSB LAX06LA094](https://openairdocs.org/ntsb/LAX06LA094.md): Cessna T210N · Mariposa, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 2006 · N4791C · Substantial damage
  > The failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.
- [NTSB CHI06LA072](https://openairdocs.org/ntsb/CHI06LA072.md): Piper PA-32-260 · Jackson, MI · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 2006 · N3946W · Destroyed
  > the blocked induction air filter due to ice accumulation which resulted in a loss of engine power. The pilot's improper weather evaluation, trees, snow, fog, and icing conditions were factors.
- [NTSB CHI06LA071](https://openairdocs.org/ntsb/CHI06LA071.md): Villarubia RV-6 · Decatur, NE · Accident · 1 fatal · Limited investigation · Final report · Jan 23, 2006 · N242EV · Substantial damage
  > An inflight collision with the terrain for undetermined reasons.
- [NTSB CHI06LA070](https://openairdocs.org/ntsb/CHI06LA070.md): Cessna 172 · Harrison, MI · Accident · 1 fatal · Limited investigation · Final report · Jan 22, 2006 · N8540B · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.
- [NTSB NYC06CA056](https://openairdocs.org/ntsb/NYC06CA056.md): Piper PA-28-140 · East Killingly, CT · Accident · Serious injuries · Data collection · Final report · Jan 21, 2006 · N32729 · Substantial damage
  > The flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.
- [NTSB LAX06LA092](https://openairdocs.org/ntsb/LAX06LA092.md): Croman SH-3H · Ely, NV · Accident · No injuries · Limited investigation · Final report · Jan 18, 2006 · N612CK · Substantial damage
  > the loss of power in both engines due to the ingestion of ice and snow. Also causal was the pilot's preflight and in-flight decisions to fly into areas of known and forecast moderate icing conditions in contravention to the prohibitions contained in the…
- [NTSB LAX06FA091](https://openairdocs.org/ntsb/LAX06FA091.md): Cessna 182P · Big Pine, CA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 2006 · N6034J · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition.
- [NTSB CHI06LA069](https://openairdocs.org/ntsb/CHI06LA069.md): Zilz Zenith CH801 · Moscow Mills, MO · Accident · No injuries · Limited investigation · Final report · Jan 18, 2006 · N143ZT · Substantial damage
  > A loss of engine power due to inadequate design of the engine compartment which resulted in inadequate engine cooling and fuel starvation due to vapor lock. Factors associated with the accident were the utility pole and trees which were contacted during the…
- [NTSB SEA06LA044](https://openairdocs.org/ntsb/SEA06LA044.md): Piper PA-28-181 · Brookings, OR · Accident · No injuries · Limited investigation · Final report · Jan 13, 2006 · N35681 · Substantial damage
  > The pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.
- [NTSB ATL06LA035](https://openairdocs.org/ntsb/ATL06LA035.md): Cirrus SR22 · Childersburg, AL · Accident · No injuries · Limited investigation · Final report · Jan 13, 2006 · N87HK · Substantial damage
  > The pilot's inadequate preflight planning, failure to obtain a current weather briefing, and his decision to operate the airplane into a known area of icing outside the airplanes certification standards resulting in the aircraft accumulating ice, a loss of…
- [NTSB NYC06LA054](https://openairdocs.org/ntsb/NYC06LA054.md): Cessna 206 · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 2006 · N308M · Substantial damage
  > Failure of the throttle cable. Contributing to the accident was unsuitable terrain for a forced landing.
- [NTSB LAX06LA072](https://openairdocs.org/ntsb/LAX06LA072.md): Eurocopter AS350BA · Hana, HI · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 2006 · N3607P · Destroyed
  > The total loss of engine power due to a fatigue failure of a turbine blade. A factor in the accident was the lack of a suitable forced landing site.
- [NTSB DFW06CA051](https://openairdocs.org/ntsb/DFW06CA051.md): Cessna 177 · Antlers, OK · Accident · Minor injuries · Data collection · Final report · Jan 10, 2006 · N2233Y · Substantial damage
  > The loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight planning. A contributing factor was the encounter with windshear during the forced landing.
- [NTSB CHI06LA060](https://openairdocs.org/ntsb/CHI06LA060.md): Cessna 310R · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Jan 9, 2006 · N310CK · Substantial damage
  > The in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.
- [NTSB SEA06LA040](https://openairdocs.org/ntsb/SEA06LA040.md): Holscher KR II · McNeil Island, WA · Accident · No injuries · Limited investigation · Final report · Jan 8, 2006 · N395JT · Substantial damage
  > Fuel exhaustion while in cruise flight due to inaccurate fuel quantity indications. Factors included the pilot's failure to positively determine the quantity of fuel onboard the aircraft during preflight, and rough, uneven grassy terrain at the location where…
- [NTSB LAX06FA080](https://openairdocs.org/ntsb/LAX06FA080.md): Eurocopter EC 130B4 · Lahaina, HI · Accident · No injuries · Field investigation · Final report · Jan 5, 2006 · N11QD · Substantial damage
  > An intermittent electrical continuity failure and short of the DECU-XPC wiring harness, which resulted in an uncommanded and an initially undetected engine deceleration and a resulting loss of main rotor rpm. Also causal was the manufacturer's inadequate…
- [NTSB DFW06CA050](https://openairdocs.org/ntsb/DFW06CA050.md): Cessna T210 · Midland, TX · Accident · No injuries · Data collection · Final report · Jan 5, 2006 · N5279A · Substantial damage
  > The loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.
- [NTSB SEA06FA036](https://openairdocs.org/ntsb/SEA06FA036.md): Beech 35-A33 · Heber City, UT · Accident · 1 fatal · Field investigation · Final report · Jan 2, 2006 · N1254Z · Substantial damage
  > The pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.
- [NTSB NYC06LA050](https://openairdocs.org/ntsb/NYC06LA050.md): Piper PA-28-161 · Yonkers, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 2006 · N2759M · Substantial damage
  > A loss of engine power for undetermined reasons, which resulted in a ditching.
- [NTSB MIA06FA039](https://openairdocs.org/ntsb/MIA06FA039.md): Robinson R44 · Grand Ridge, FL · Accident · 3 fatal · Field investigation · Final report · Jan 2, 2006 · N442DH · Destroyed
  > The pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.
- [NTSB LAX06IA076](https://openairdocs.org/ntsb/LAX06IA076.md): Saab-Scania SF340B+ · Santa Maria, CA · Incident · No injuries · Incident investigation · Final report · Jan 2, 2006 · N390AE · No damage
  > An in-flight loss of control due to ice accreted in supercooled liquid droplets (SLD) conditions, and the flight crew's failure to maintain the specified minimum airspeed in icing conditions. Contributing to the accident was the flight crew's decision to…
- [NTSB ATL06CA031](https://openairdocs.org/ntsb/ATL06CA031.md): Piper PA-23-160 · Phenix City, AL · Accident · Serious injuries · Data collection · Final report · Jan 2, 2006 · N4370P · Substantial damage
  > The pilot's inadequate decision to continue VFR flight into IMC conditions, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC06LA015](https://openairdocs.org/ntsb/ANC06LA015.md): Cessna 180 · Seward, AK · Accident · 1 fatal · Limited investigation · Final report · Jan 2, 2006 · N212RF · Substantial damage
  > The pilot's inadequate weather evaluation, which resulted in an in-flight encounter with low ceilings, turbulence, and downdrafts in cruise flight, and the pilot's failure to maintain altitude/clearance while maneuvering, which resulted in an in-flight…
- [NTSB DEN06FA028](https://openairdocs.org/ntsb/DEN06FA028.md): Cessna 182D · Heber, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2006 · N182GV · Destroyed
  > the pilot's failure to maintain altitude/clearance from terrain. Contributing factors included the pilot's lack of night flying experience and the dark night.
- [NTSB DFW06CA048](https://openairdocs.org/ntsb/DFW06CA048.md): Bell 206L-4 · Washington, LA · Accident · Minor injuries · Data collection · Final report · Dec 30, 2005 · N1811 · Substantial damage
  > The in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.
- [NTSB ATL06FA029](https://openairdocs.org/ntsb/ATL06FA029.md): Cirrus Design SR22 · Sylva, NC · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2005 · N799TM · Destroyed
  > The pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.
- [NTSB SEA06LA033](https://openairdocs.org/ntsb/SEA06LA033.md): McDonnell Douglas MD-83 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Dec 27, 2005 · N979AS · Substantial damage
  > The ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.
- [NTSB ATL06LA028](https://openairdocs.org/ntsb/ATL06LA028.md): Cessna 177-RG · Locust Grove, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2005 · N53257 · Substantial damage
  > The total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.
- [NTSB ATL06LA027](https://openairdocs.org/ntsb/ATL06LA027.md): Piper PA32-300 · Maiden, NC · Accident · No injuries · Limited investigation · Final report · Dec 27, 2005 · N2887M · Substantial damage
  > The total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.
- [NTSB DFW06LA041](https://openairdocs.org/ntsb/DFW06LA041.md): Boeing A75N1 (PT17) · Fort Worth, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 26, 2005 · N67195 · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing factors were the reported loss of engine power for undetermined reasons and the low altitude maneuver.
- [NTSB SEA06CA032](https://openairdocs.org/ntsb/SEA06CA032.md): Piper PA-28-151 · Emmett, ID · Accident · No injuries · Data collection · Final report · Dec 25, 2005 · N5695V · Destroyed
  > The pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.
- [NTSB LAX06LA068](https://openairdocs.org/ntsb/LAX06LA068.md): Piper PA-28-180 · Hopland, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 25, 2005 · N3953R · Destroyed
  > The non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.
- [NTSB MIA06CA040](https://openairdocs.org/ntsb/MIA06CA040.md): Beech BE23 · Palatka, FL · Accident · No injuries · Data collection · Final report · Dec 24, 2005 · N7657R · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB MIA06CA034](https://openairdocs.org/ntsb/MIA06CA034.md): Cessna 182 · Haines City, FL · Accident · No injuries · Data collection · Final report · Dec 24, 2005 · N8304S · Substantial damage
  > The pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX06LA067](https://openairdocs.org/ntsb/LAX06LA067.md): Forrest Haynes Lancair 320 · Ramona, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 2005 · N320WH · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB LAX06LA064](https://openairdocs.org/ntsb/LAX06LA064.md): Cessna 172 · Gilroy, CA · Accident · 4 fatal · Limited investigation · Final report · Dec 22, 2005 · N7383A · Destroyed
  > The non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…
- [NTSB ATL06CA026](https://openairdocs.org/ntsb/ATL06CA026.md): Eurocopter France AS-350-B2 · Jasper, AL · Accident · Serious injuries · Data collection · Final report · Dec 22, 2005 · N350ET · Substantial damage
  > The pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.
- [NTSB DCA06MA010](https://openairdocs.org/ntsb/DCA06MA010.md): Grumman G-73T · Miami, FL · Accident · 20 fatal · Class 1 · Major · Final report · Dec 19, 2005 · N2969 · Destroyed
  > The in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…
- [NTSB MIA06LA041](https://openairdocs.org/ntsb/MIA06LA041.md): Cessna 195 · St. Augustine, FL · Accident · 3 fatal · Limited investigation · Final report · Dec 18, 2005 · N22L · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.

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

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

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