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

## Cases, newest first

- [NTSB ANC02FA029](https://openairdocs.org/ntsb/ANC02FA029.md): Eurocopter AS-350-B2 · Valdez, AK · Accident · No injuries · Field investigation · Final report · Apr 11, 2002 · N917JT · Substantial damage
  > The pilot's failure to disengage the hydraulic system, and maintain forward airspeed during landing as delineated in the emergency procedures section of the helicopter's operations manual, which resulted in a loss of control while hovering. Factors…
- [NTSB LAX02LA132](https://openairdocs.org/ntsb/LAX02LA132.md): Cox Aeros Ltd Skyranger · Gila Bend, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 2002 · UNREG · Substantial damage
  > The failure of the engine for undetermined reasons.
- [NTSB ATL02IA079](https://openairdocs.org/ntsb/ATL02IA079.md): Rockwell International 500-S · Jackson, AL · Incident · No injuries · Incident investigation · Final report · Apr 8, 2002 · N8536 · No damage
  > The pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.
- [NTSB CHI02LA100](https://openairdocs.org/ntsb/CHI02LA100.md): Piper PA-46-310P · Hastings, MN · Accident · No injuries · Limited investigation · Final report · Apr 7, 2002 · N9184F · Substantial damage
  > The engine failure due to oil starvation as a result of the fatigue fracture of the number 6 piston. Additional factors were the unsuitable terrain for landing encountered by the pilot, and the inadequate piston design by the manufacturer.
- [NTSB ATL02LA075](https://openairdocs.org/ntsb/ATL02LA075.md): Boeing 767-332ER · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Apr 5, 2002 · N1608 · Substantial damage
  > Company maintenance personnel inadequate maintenance inspection that resulted in the in-flight separation of the APU inspection doors.
- [NTSB MIA02LA078](https://openairdocs.org/ntsb/MIA02LA078.md): Ultravia Aero Int' Pelican Club PL · Crystal River, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2002 · N60980 · Substantial damage
  > The loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.
- [NTSB LAX02LA124](https://openairdocs.org/ntsb/LAX02LA124.md): Cessna 152 · Lake Elsinore, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 2002 · N69000 · Substantial damage
  > The pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.
- [NTSB MIA02FA079](https://openairdocs.org/ntsb/MIA02FA079.md): Piper PA-23-250 · Palm Bay, FL · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2002 · N91FK · Destroyed
  > The in-flight loss of control for undetermined reasons resulting in the in-flight collision with terrain.
- [NTSB IAD02LA039](https://openairdocs.org/ntsb/IAD02LA039.md): Boeing 747-400 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2002 · G-BNLS · No damage
  > The airplane's encounter with turbulence, while climbing to an assigned altitude.
- [NTSB MIA02FA075](https://openairdocs.org/ntsb/MIA02FA075.md): McDonnell Douglas MD-11 · Charlotte, NC · Accident · Serious injuries · Field investigation · Final report · Apr 1, 2002 · N809DE · Minor damage
  > The failure of the aircraft operator to comply with, in a timely manner, on the No. 2 engine, Boeing Alert Service Bulletin MD11-71A086, resulting in the integrated drive generator feeder cable chaffing through a fire warning loop and failure of the fire…
- [NTSB CHI02LA106](https://openairdocs.org/ntsb/CHI02LA106.md): Piper PA-28-235 · Fulton, IN · Accident · No injuries · Limited investigation · Final report · Mar 31, 2002 · N9060W · Substantial damage
  > A loss of engine power due to excessive clearance of the connecting rod bearing resulting in engine seizure. A related factor was the muddy field.
- [NTSB CHI02LA099](https://openairdocs.org/ntsb/CHI02LA099.md): Piper PA-46-310P · South St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Mar 31, 2002 · N9103Q · Substantial damage
  > A loss of engine power due to an electrical short of the P-lead, and loose fuel line connection as a result of improper maintenance.
- [NTSB FTW02LA108](https://openairdocs.org/ntsb/FTW02LA108.md): Mooney M20F · Grapeland, TX · Accident · No injuries · Limited investigation · Final report · Mar 30, 2002 · N9530M · Substantial damage
  > The loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.
- [NTSB LAX02TA118](https://openairdocs.org/ntsb/LAX02TA118.md): Bell OH-58A · Chico, CA · Accident · No injuries · Final report · Mar 29, 2002 · N487BC · Substantial damage
  > the loss of engine power for an undetermined reason. Factors in the accident were the pilot's misjudged flare resulting in a hard landing and the lack of recent experience in emergency procedures by the pilot.
- [NTSB FTW02FA106](https://openairdocs.org/ntsb/FTW02FA106.md): Beech D35 · Nacogdoches, TX · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2002 · N2966B · Substantial damage
  > The failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.
- [NTSB ANC02LA026](https://openairdocs.org/ntsb/ANC02LA026.md): Interstate S-1B1 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Mar 29, 2002 · N48027 · Substantial damage
  > The separation of the exhaust system stack from the heat exchanger. A factor associated with the accident was an engine compartment fire.
- [NTSB NYC02LA078](https://openairdocs.org/ntsb/NYC02LA078.md): Cessna 150M · Salisbury Ctr, NY · Accident · No injuries · Limited investigation · Final report · Mar 28, 2002 · N3006V · Substantial damage
  > The pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.
- [NTSB NYC02IA076](https://openairdocs.org/ntsb/NYC02IA076.md): Embraer EMB-145LR · Jefferson, NY · Incident · No injuries · Incident investigation · Final report · Mar 27, 2002 · N290SK · Minor damage
  > An in-flight encounter with lightning, which severed two of the four elevator cables.
- [NTSB FTW02LA129](https://openairdocs.org/ntsb/FTW02LA129.md): Beech F35 · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Mar 25, 2002 · N4257B · Substantial damage
  > Flutter due to the improper balance of the ruddervator, which resulted in structural damage to the aft fuselage.
- [NTSB FTW02LA101](https://openairdocs.org/ntsb/FTW02LA101.md): Grumman AA-5 · Lamar, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 2002 · N9265L · Substantial damage
  > the pilot's delay in taking immediate remedial action after the flight encountered icing conditions, which resulted in a collision with terrain. A contributing factor to the accident was the icing condition.
- [NTSB ANC02FA025](https://openairdocs.org/ntsb/ANC02FA025.md): Piper PA-28-235 · Manokotak, AK · Accident · 1 fatal · Field investigation · Final report · Mar 23, 2002 · N1220R · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with terrain during cruise flight. Factors in the accident were low ceilings, snow, and mountainous snow-covered terrain.
- [NTSB DCA02MA029](https://openairdocs.org/ntsb/DCA02MA029.md): McDonnell Douglas DC-10-30 · int'l waters · Accident · Serious injuries · Major investigation · Final report · Mar 22, 2002 · N234NW · Minor damage
  > The flight attendant's injuries were a result of her unsecured lap belt and shoulder harness for undetermined reasons, and the oscillations of the airplane, which were caused by turbulence and large control column inputs by the first officer. Contributing to…
- [NTSB LAX02FA114](https://openairdocs.org/ntsb/LAX02FA114.md): Eurocopter AS-350B · Susanville, CA · Accident · 1 fatal · Field investigation · Final report · Mar 21, 2002 · N1184H · Substantial damage
  > Failure of the pilot to maintain sufficient altitude/clearance above the water while performing a low altitude flight. Factors relating to the accident were the glassy water condition, and a lack of visual cues concerning perception of altitude.
- [NTSB DEN02LA033](https://openairdocs.org/ntsb/DEN02LA033.md): Cessna 172Q · Fruitland, UT · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 2002 · N66076 · Destroyed
  > the pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.
- [NTSB LAX02LA107](https://openairdocs.org/ntsb/LAX02LA107.md): Cessna 177B · Santa Clarita, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 2002 · N11487 · Substantial damage
  > The pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.
- [NTSB MIA02FA067](https://openairdocs.org/ntsb/MIA02FA067.md): Piper PA32R-300 · Broadway, NC · Accident · 1 fatal · Field investigation · Final report · Mar 14, 2002 · N4451X · Destroyed
  > The pilot's inadequate visual lookout and his failure to maintain obstacle clearance.
- [NTSB CHI02LA092](https://openairdocs.org/ntsb/CHI02LA092.md): Cessna 152 · Christopher, IL · Accident · No injuries · Limited investigation · Final report · Mar 14, 2002 · N5111H · Substantial damage
  > The in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.
- [NTSB FTW02FA095](https://openairdocs.org/ntsb/FTW02FA095.md): Piper PA-28RT-201T · Marianna, AR · Accident · 2 fatal · Field investigation · Final report · Mar 13, 2002 · N84719 · Substantial damage
  > The pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.
- [NTSB CHI02LA091](https://openairdocs.org/ntsb/CHI02LA091.md): Aviat Pitts S-2B · Milwaukee, WI · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 2002 · N29RG · Substantial damage
  > The loss of engine power for undetermined reasons. A factor in the accident was the telephone pole.
- [NTSB DEN02LA031](https://openairdocs.org/ntsb/DEN02LA031.md): Doyle Kitfox III · Windsor, CO · Accident · No injuries · Limited investigation · Final report · Mar 10, 2002 · N8SD · Substantial damage
  > loss of engine power due to restricted fuel flow for reasons undetermined. A contributing factor was the unsuitable terrain on which to make a forced landing.
- [NTSB SEA02LA051](https://openairdocs.org/ntsb/SEA02LA051.md): Bell/Garlick UH-1H · Dayton, WA · Accident · No injuries · Limited investigation · Final report · Mar 8, 2002 · N116DR · Substantial damage
  > A loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.
- [NTSB CHI02LA087](https://openairdocs.org/ntsb/CHI02LA087.md): Cessna 182H · West Plains, MO · Accident · No injuries · Limited investigation · Final report · Mar 8, 2002 · N64AE · Substantial damage
  > The engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…
- [NTSB CHI02FA088](https://openairdocs.org/ntsb/CHI02FA088.md): Piper PA-28-140 · Niles, MI · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2002 · N5246T · Destroyed
  > Flight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.
- [NTSB LAX02FA101](https://openairdocs.org/ntsb/LAX02FA101.md): Cessna 425 · San Jose, CA · Accident · 3 fatal · Field investigation · Final report · Mar 6, 2002 · N444JV · Destroyed
  > the pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…
- [NTSB CHI02IA085](https://openairdocs.org/ntsb/CHI02IA085.md): Beech BE-55 · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Mar 4, 2002 · N66X · 2 aircraft · Minor damage
  > The inadequate visual lookout by the flightcrew of the other airplane.
- [NTSB SEA02IA044](https://openairdocs.org/ntsb/SEA02IA044.md): Bombardier DHC-8-401 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Mar 2, 2002 · N410QX · No damage
  > The partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…
- [NTSB ATL02FA057](https://openairdocs.org/ntsb/ATL02FA057.md): Piper PA-32-300 · Hamilton, GA · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2002 · N33584 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CHI02IA083](https://openairdocs.org/ntsb/CHI02IA083.md): Canadair CL-600-2B19 · Appleton, WI · Incident · No injuries · Incident investigation · Final report · Feb 27, 2002 · N991CA · Minor damage
  > The separation of the low pressure turbine module due to coke resulting in the blockage of the oil system.
- [NTSB ATL02LA052](https://openairdocs.org/ntsb/ATL02LA052.md): Cessna 152 · Hudson, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 2002 · N6420M · Substantial damage
  > Total loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…
- [NTSB DEN02LA028](https://openairdocs.org/ntsb/DEN02LA028.md): Piper PA-32R-300 · Ferron, UT · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 2002 · N47465 · Destroyed
  > a loss of engine power due to the ingestion of foreign object(s) into the meshing of the gears, causing a malfunction of the magneto idler gear and failure of maintenance personnel to detect the signs of imminent failure during a mandatory oil filter…
- [NTSB ATL02FA051](https://openairdocs.org/ntsb/ATL02FA051.md): Piper PA-28-180 · Vero Beach, FL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2002 · N7345W · Destroyed
  > The flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.
- [NTSB FTW02LA083](https://openairdocs.org/ntsb/FTW02LA083.md): North American T28C · Fredericksburg, TX · Accident · No injuries · Limited investigation · Final report · Feb 21, 2002 · N71546 · Substantial damage
  > the failure of the pilot to refuel the airplane resulting in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC02LA065](https://openairdocs.org/ntsb/NYC02LA065.md): Boeing 737-724 · Beaumont, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 2002 · N24736 · No damage
  > An inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…
- [NTSB CHI02LA081](https://openairdocs.org/ntsb/CHI02LA081.md): Cessna 172F · Lynxville, WI · Accident · No injuries · Limited investigation · Final report · Feb 18, 2002 · N5527R · Substantial damage
  > The pilots delayed use of carburetor heat during carburetor icing conditions, and the unsuitable terrain encountered for the forced landing. The carburetor icing conditions, the powerline, the brush, and the nose gear collapse were contributing factors.
- [NTSB NYC02LA062](https://openairdocs.org/ntsb/NYC02LA062.md): Piper PA-28-140 · Newbolds Corner, NJ · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 2002 · N56885 · Substantial damage
  > Improper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.
- [NTSB ATL02FA048](https://openairdocs.org/ntsb/ATL02FA048.md): Bell 206L-1 · New Smyrna Bch., FL · Accident · 2 fatal · Field investigation · Final report · Feb 16, 2002 · N23PJ · Destroyed
  > The pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.
- [NTSB ATL02LA046](https://openairdocs.org/ntsb/ATL02LA046.md): Aero Commander 500U · Copperhill, TN · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 2002 · N441WW · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with trees during emergency landing on unsuitable terrain
- [NTSB FTW02LA079](https://openairdocs.org/ntsb/FTW02LA079.md): Cessna 172N · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Feb 8, 2002 · N75616 · Substantial damage
  > the loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.
- [NTSB DEN02LA029](https://openairdocs.org/ntsb/DEN02LA029.md): Gulfstream Aerospace G-IV · Broomfield, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 2002 · N434QS · No damage
  > the flight attendant's failure to fasten his seatbelt when warned of possible turbulence. A contributing factor was the severe turbulence.
- [NTSB ATL02FA043](https://openairdocs.org/ntsb/ATL02FA043.md): Piper PA-32-300 · Atlanta, GA · Accident · 4 fatal · Field investigation · Final report · Feb 6, 2002 · N4105W · Destroyed
  > The pilot experienced spatial disorientation that resulted in the loss of control.

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

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

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