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

## Cases, newest first

- [NTSB CHI05LA037](https://openairdocs.org/ntsb/CHI05LA037.md): Cessna 172H · Belle Plaine, MN · Accident · No injuries · Limited investigation · Final report · Nov 28, 2004 · N2663L · Substantial damage
  > A loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.
- [NTSB SEA05FA019](https://openairdocs.org/ntsb/SEA05FA019.md): Robinson R22 Beta · Arlington, WA · Accident · 2 fatal · Field investigation · Final report · Nov 27, 2004 · N4029Q · Destroyed
  > The divergence of the main rotor from its normal plane of rotation for an undetermined reason, resulting in rotor contact with the aircraft's left windscreen. The failure of the door pins to be installed was a factor.
- [NTSB IAD05LA017](https://openairdocs.org/ntsb/IAD05LA017.md): Chumsae Kitfox Speedster · Sterling, MA · Accident · No injuries · Limited investigation · Final report · Nov 27, 2004 · N124KF · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB IAD05FA023](https://openairdocs.org/ntsb/IAD05FA023.md): CASA 212-200-CC · Bamiyan, Afghanistan · Accident · 6 fatal · Class 1 · Field · Final report · Nov 27, 2004 · N960BW · Destroyed
  > the captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…
- [NTSB DFW05LA025](https://openairdocs.org/ntsb/DFW05LA025.md): Wingo Long-Ez · Huntsville, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2004 · N234BW · Substantial damage
  > Loss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.
- [NTSB CHI05CA036](https://openairdocs.org/ntsb/CHI05CA036.md): Spaulding Tailwind W-8 · Davey, NE · Accident · No injuries · Data collection · Final report · Nov 24, 2004 · N191AS · Substantial damage
  > The loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.
- [NTSB IAD05LA013](https://openairdocs.org/ntsb/IAD05LA013.md): Cessna 172E · Rupert, WV · Accident · No injuries · Limited investigation · Final report · Nov 21, 2004 · N3750S · Substantial damage
  > The pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.
- [NTSB CHI05CA032](https://openairdocs.org/ntsb/CHI05CA032.md): Olson Sonex · Oconomowoc, WI · Accident · Serious injuries · Data collection · Final report · Nov 21, 2004 · N478SX · Substantial damage
  > The loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…
- [NTSB MIA05CA030](https://openairdocs.org/ntsb/MIA05CA030.md): Enstrom F-28C · Panama City Bch, FL · Accident · Minor injuries · Data collection · Final report · Nov 17, 2004 · N595H · Substantial damage
  > The pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.
- [NTSB MIA05FA028](https://openairdocs.org/ntsb/MIA05FA028.md): Piper PA-28R-200 · Dubbs, MS · Accident · 3 fatal · Field investigation · Final report · Nov 14, 2004 · N56960 · Substantial damage
  > The pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.
- [NTSB LAX05FA034](https://openairdocs.org/ntsb/LAX05FA034.md): Beech A36 · Lake Havasu, CA · Accident · 2 fatal · Field investigation · Final report · Nov 14, 2004 · N6111C · Destroyed
  > the pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.
- [NTSB DEN05LA023](https://openairdocs.org/ntsb/DEN05LA023.md): Cessna 152 · Lyons, CO · Accident · No injuries · Limited investigation · Final report · Nov 14, 2004 · N48943 · Destroyed
  > the pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.
- [NTSB ATL05CA024](https://openairdocs.org/ntsb/ATL05CA024.md): Cessna 172N · Wilmington, NC · Accident · No injuries · Data collection · Final report · Nov 14, 2004 · N75776 · Substantial damage
  > The student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…
- [NTSB IAD05FA012](https://openairdocs.org/ntsb/IAD05FA012.md): Cessna P210 · Paint Lick, KY · Accident · 1 fatal · Field investigation · Final report · Nov 12, 2004 · N6539P · Destroyed
  > Improper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.
- [NTSB LAX05FA032](https://openairdocs.org/ntsb/LAX05FA032.md): Piper PA-32R-301T · Santa Barbara, CA · Accident · 3 fatal · Field investigation · Final report · Nov 11, 2004 · N803ZG · Destroyed
  > The pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…
- [NTSB LAX05CA030](https://openairdocs.org/ntsb/LAX05CA030.md): Cessna P210N · Rancho Cordova, CA · Accident · No injuries · Data collection · Final report · Nov 11, 2004 · N6416W · Substantial damage
  > The pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…
- [NTSB LAX05LA020](https://openairdocs.org/ntsb/LAX05LA020.md): American Eurocopter AS350-BA · Oxnard, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2004 · N655TV · Substantial damage
  > The inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…
- [NTSB DFW05LA019](https://openairdocs.org/ntsb/DFW05LA019.md): Bell 206L1 · Sapulpa, OK · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2004 · N1075P · Substantial damage
  > The loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.
- [NTSB DFW05LA023](https://openairdocs.org/ntsb/DFW05LA023.md): Cessna 150M · Longview, TX · Accident · No injuries · Limited investigation · Final report · Nov 6, 2004 · N704KX · Substantial damage
  > The pilot's improper inflight 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 CHI05CA025](https://openairdocs.org/ntsb/CHI05CA025.md): Jabat Avid Flyer · Cleveland, MO · Accident · No injuries · Data collection · Final report · Nov 6, 2004 · N90JW · Substantial damage
  > The separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.
- [NTSB MIA05FA024](https://openairdocs.org/ntsb/MIA05FA024.md): Socata TB 20 · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2004 · N1905S · Destroyed
  > The pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.
- [NTSB DFW05LA017](https://openairdocs.org/ntsb/DFW05LA017.md): Bell 206B · S.Timbelier 187 · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N496RL · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB DEN05CA020](https://openairdocs.org/ntsb/DEN05CA020.md): Mooney M20E · Santa Rosa, NM · Accident · No injuries · Data collection · Final report · Nov 5, 2004 · N2695W · Substantial damage
  > Inadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.
- [NTSB ATL05LA020](https://openairdocs.org/ntsb/ATL05LA020.md): Franzreb Loehle 5151 Mustang · Athens, TN · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N711AH · Substantial damage
  > The loss of engine power due to the electrical fuel pump failure, and fuel starvation.
- [NTSB LAX05FA023](https://openairdocs.org/ntsb/LAX05FA023.md): Cessna 182Q · Lebec, CA · Accident · 4 fatal · Field investigation · Final report · Oct 31, 2004 · N95902 · Destroyed
  > the pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.
- [NTSB DEN05LA017](https://openairdocs.org/ntsb/DEN05LA017.md): Miller Vans RV4 · Dotsero, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 2004 · N25HM · Destroyed
  > the pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.
- [NTSB CHI05FA020](https://openairdocs.org/ntsb/CHI05FA020.md): Beech A36 · Downing, MO · Accident · 3 fatal · Field investigation · Final report · Oct 30, 2004 · N55448 · Destroyed
  > The pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.
- [NTSB ATL05LA018](https://openairdocs.org/ntsb/ATL05LA018.md): Bellanca Citabria 7ECA · Summerville, SC · Accident · 2 fatal · Limited investigation · Final report · Oct 30, 2004 · N57388 · Substantial damage
  > The loss of engine power due to undetermined reasons.
- [NTSB ATL05CA016](https://openairdocs.org/ntsb/ATL05CA016.md): Cessna 172 · Mobile, AL · Accident · No injuries · Data collection · Final report · Oct 29, 2004 · N2845Q · Substantial damage
  > The pilot's inadequate preflight planning and his inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent collision with the ground.
- [NTSB MIA05LA019](https://openairdocs.org/ntsb/MIA05LA019.md): Scottish Bulldog 120/121 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 2004 · N556WH · Substantial damage
  > The pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.
- [NTSB MIA05LA016](https://openairdocs.org/ntsb/MIA05LA016.md): Cessna T210N · Raymond, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2004 · N6108Y · Destroyed
  > The total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…
- [NTSB DFW05CA024](https://openairdocs.org/ntsb/DFW05CA024.md): McCulloch J2 · Camden, AR · Accident · No injuries · Data collection · Final report · Oct 27, 2004 · N62SJ · Substantial damage
  > The separation of the engine exhaust stack for undetermined reasons.
- [NTSB CHI05FA016](https://openairdocs.org/ntsb/CHI05FA016.md): Cessna P210N · Wautoma, WI · Accident · 2 fatal · Field investigation · Final report · Oct 26, 2004 · N5485W · Destroyed
  > The pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…
- [NTSB DEN05CA015](https://openairdocs.org/ntsb/DEN05CA015.md): Cessna 310I · Draper, UT · Accident · Minor injuries · Data collection · Final report · Oct 25, 2004 · N8175M · Substantial damage
  > the pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.
- [NTSB CHI05LA014](https://openairdocs.org/ntsb/CHI05LA014.md): Cessna P206B · Taylorville, IL · Accident · 1 fatal · Limited investigation · Final report · Oct 24, 2004 · N8619Z · Destroyed
  > Aircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.
- [NTSB ATL05LA009](https://openairdocs.org/ntsb/ATL05LA009.md): North American Harvard II T-6 · Leesville, SC · Accident · 2 fatal · Limited investigation · Final report · Oct 23, 2004 · N92871 · Substantial damage
  > Loss of engine power due to fuel system contamination which blocked the flow of fuel which resulted in fuel starvation.
- [NTSB LAX05LA012](https://openairdocs.org/ntsb/LAX05LA012.md): Beech C24R · Cloverdale, CA · Accident · No injuries · Limited investigation · Final report · Oct 22, 2004 · N18942 · Substantial damage
  > the loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.
- [NTSB MIA05LA011](https://openairdocs.org/ntsb/MIA05LA011.md): Piper PA-31-350 · Pompano Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2004 · N61518 · Destroyed
  > The pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…
- [NTSB DEN05FA012](https://openairdocs.org/ntsb/DEN05FA012.md): Beech F35 · Chester, AR · Accident · 2 fatal · Field investigation · Final report · Oct 21, 2004 · N3889B · Destroyed
  > the pilot's inadequate planning/decision which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were the pilot's failure to follow the briefing recommendation, fog, mist, and observation.
- [NTSB CHI05MA011](https://openairdocs.org/ntsb/CHI05MA011.md): Boeing 747-132 · Lake Michigan · Accident · No injuries · Major investigation · Final report · Oct 21, 2004 · N709CK · Substantial damage
  > The number one engine separated from the airplane during climb due to the uncontained separation of a portion of the second stage turbine disk rim after the second stage turbine vanes contacted the disk. The second stage turbine vanes contacted the second…
- [NTSB CHI05LA012](https://openairdocs.org/ntsb/CHI05LA012.md): Cessna 150M · Ashley, ND · Accident · 1 fatal · Limited investigation · Final report · Oct 21, 2004 · N63439 · Destroyed
  > The non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.
- [NTSB ATL05LA007](https://openairdocs.org/ntsb/ATL05LA007.md): Piper PA-32RT-300T · Guntersville, AL · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 2004 · N19TL · Substantial damage
  > Total loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.
- [NTSB MIA05FA008](https://openairdocs.org/ntsb/MIA05FA008.md): Eurocopter Deutschland BO-105 CBS5 · Santa Rosa Bch, FL · Accident · 3 fatal · Field investigation · Final report · Oct 20, 2004 · N916SH · Destroyed
  > The pilot's spatial disorientation and in-flight loss of control of the helicopter after encountering night instrument meteorological conditions resulting in collision with water during the resultant uncontrolled descent. A factor in the accident was the…
- [NTSB SEA05LA133](https://openairdocs.org/ntsb/SEA05LA133.md): Aero Vodochody Aero. Works L-39C · Hyak, WA · Accident · 2 fatal · Limited investigation · Final report · Oct 19, 2004 · N39TJ · Destroyed
  > The loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.
- [NTSB ATL05FA010](https://openairdocs.org/ntsb/ATL05FA010.md): Beech B-55 · Atlanta, GA · Accident · 2 fatal · Field investigation · Final report · Oct 19, 2004 · N322WW · Substantial damage
  > The pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.
- [NTSB LAX05FA011](https://openairdocs.org/ntsb/LAX05FA011.md): Cessna 310K · Kula, HI · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2004 · N7049L · Destroyed
  > The failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.
- [NTSB CHI05CA006](https://openairdocs.org/ntsb/CHI05CA006.md): Piper PA-28-160 · Altoona, WI · Accident · No injuries · Data collection · Final report · Oct 18, 2004 · N5520W · Substantial damage
  > The pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.
- [NTSB DFW05LA007](https://openairdocs.org/ntsb/DFW05LA007.md): Cessna T210N · Seven Points, TX · Accident · No injuries · Limited investigation · Final report · Oct 16, 2004 · N11FB · Substantial damage
  > The loss of engine power due to the failure of the number one connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD05IA004](https://openairdocs.org/ntsb/IAD05IA004.md): Raven Industries S-60A · Auburn, ME · Incident · Minor injuries · Incident investigation · Final report · Oct 14, 2004 · C-GGAX · No damage
  > The pilot's maneuver into a tree, which resulted in an inadvertent contact between a branch and a passenger.
- [NTSB DCA05MA003](https://openairdocs.org/ntsb/DCA05MA003.md): Canadair CL-600 · Jefferson City, MO · Accident · 2 fatal · Class 1 · Major · Final report · Oct 14, 2004 · N8396A · Destroyed
  > (1) the pilots’ unprofessional behavior, deviation from standard operating procedures, and poor airmanship, which resulted in an in-flight emergency from which they were unable to recover, in part because of the pilots’ inadequate training; (2) the pilots’…

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

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

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