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

## Cases, newest first

- [NTSB ANC96LA027](https://openairdocs.org/ntsb/ANC96LA027.md): Piper PA-32-301 · Nome, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1996 · N8374T · Substantial damage
  > the pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.
- [NTSB MIA96LA088](https://openairdocs.org/ntsb/MIA96LA088.md): Bell 206L4 · Chiefland, FL · Accident · No injuries · Limited investigation · Final report · Mar 1, 1996 · N6248X · Substantial damage
  > Improper cyclic and collective input by the pilot-in-command resulting in the hard landing during the autorotative landing. Contributing to the accident was the total loss of engine power due to undetermined reasons.
- [NTSB LAX96FA121](https://openairdocs.org/ntsb/LAX96FA121.md): Cessna 172D · Julian, CA · Accident · 3 fatal · Field investigation · Final report · Feb 26, 1996 · N2598U · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.
- [NTSB FTW96FA130](https://openairdocs.org/ntsb/FTW96FA130.md): Cessna 182R · Proctor, AR · Accident · 4 fatal · Field investigation · Final report · Feb 24, 1996 · N9303E · 2 aircraft · Destroyed
  > failure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).
- [NTSB CHI96LA096](https://openairdocs.org/ntsb/CHI96LA096.md): Piper PA-22-150 · Bourbon, IN · Accident · No injuries · Limited investigation · Final report · Feb 24, 1996 · N6939B · Substantial damage
  > Water contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.
- [NTSB IAD96LA046](https://openairdocs.org/ntsb/IAD96LA046.md): Cessna P210N · Hazard, KY · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 1996 · N90AD · Substantial damage
  > failure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.
- [NTSB FTW96LA134](https://openairdocs.org/ntsb/FTW96LA134.md): Cessna 172N · Austin, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 1996 · N6601D · Substantial damage
  > the partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA96IA084](https://openairdocs.org/ntsb/MIA96IA084.md): Boeing 707-323C · Miami, FL · Incident · No injuries · Incident investigation · Final report · Feb 22, 1996 · N751MA · Minor damage
  > failure of the flight engineer to follow the appropriate emergency procedure to manually extend the nose landing gear. Factors relating to the incident were: fatigue failure of the utility hydraulic system relief valve, which resulted in an inoperative normal…
- [NTSB LAX96FA120](https://openairdocs.org/ntsb/LAX96FA120.md): Piper J3C-65 · Elk Grove, CA · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1996 · N75772 · Destroyed
  > the pilot's failure to see and avoid the obstruction.
- [NTSB FTW96LA126](https://openairdocs.org/ntsb/FTW96LA126.md): Piper PA-36-300 · Andrews, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1996 · N57828 · Substantial damage
  > the mechanic's improper overhaul of the engine. Factors were: the pilot in command's inability to maintain visual lookout due to oil on the windscreen and unsuitable terrain for the forced landing.
- [NTSB ATL96LA132](https://openairdocs.org/ntsb/ATL96LA132.md): Beech 35 · Griffin, GA · Accident · No injuries · Limited investigation · Final report · Feb 22, 1996 · N3134V · Substantial damage
  > failure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.
- [NTSB MIA96LA080](https://openairdocs.org/ntsb/MIA96LA080.md): Berkshire Concept 70 · Boynton Beach, FL · Accident · No injuries · Limited investigation · Final report · Feb 20, 1996 · N29BW · Destroyed
  > an engine loss of power and fire for undetermined reasons.
- [NTSB LAX96FA115](https://openairdocs.org/ntsb/LAX96FA115.md): Cessna 172N · Julian, CA · Accident · 3 fatal · Field investigation · Final report · Feb 20, 1996 · N738ED · Destroyed
  > the pilot's delay in requesting assistance to avoid high terrain. Factors were: the downdrafts, mountainous terrain, and the pilot's improper in-flight planning.
- [NTSB ATL96IA053](https://openairdocs.org/ntsb/ATL96IA053.md): Embraer 120 · Raleigh, NC · Incident · No injuries · Incident investigation · Final report · Feb 20, 1996 · N129AM · No damage
  > The operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…
- [NTSB LAX96FA119](https://openairdocs.org/ntsb/LAX96FA119.md): Beech C35 · Lee Vining, CA · Accident · 1 fatal · Field investigation · Final report · Feb 19, 1996 · N2PA · Destroyed
  > Fuel starvation due to the pilot's failure to adequate monitor the aircraft's fuel system and select a tank containing fuel in a timely manner. The pilot's failure to monitor the fuel system was due to the effects of hypoxia. Factors in the accident were the…
- [NTSB CHI96FA094](https://openairdocs.org/ntsb/CHI96FA094.md): Cessna 182 · Odell, IL · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1996 · N3243Y · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, probably due to spatial disorientation of the pilot. Factors relating to the accident were: darkness, reduced visibility due to the weather…
- [NTSB CHI96LA093](https://openairdocs.org/ntsb/CHI96LA093.md): Cessna 172 · Worthington, MN · Accident · No injuries · Limited investigation · Final report · Feb 18, 1996 · N758CQ · Substantial damage
  > Progressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.
- [NTSB LAX96LA117](https://openairdocs.org/ntsb/LAX96LA117.md): Cessna 172P · Raymond, CA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1996 · N53115 · Substantial damage
  > The pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.
- [NTSB IAD96LA043](https://openairdocs.org/ntsb/IAD96LA043.md): Cessna 177A · Sidney, OH · Accident · No injuries · Limited investigation · Final report · Feb 17, 1996 · N30422 · Substantial damage
  > fuel contamination, and the pilot's inadequate preflight inspection, which resulted in subsequent loss of engine power during cruise flight. A factor relating to the accident was: rough terrain in the emergency landing area.
- [NTSB SEA96FA061](https://openairdocs.org/ntsb/SEA96FA061.md): Cessna 402B · Estacada, OR · Accident · 1 fatal · Field investigation · Final report · Feb 16, 1996 · N5198J · Destroyed
  > loss of aircraft control for undetermined reason(s).
- [NTSB FTW96LA139](https://openairdocs.org/ntsb/FTW96LA139.md): Rockwell 500U · Hampton, AR · Accident · No injuries · Limited investigation · Final report · Feb 16, 1996 · N197K · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB CHI96FA090](https://openairdocs.org/ntsb/CHI96FA090.md): Piper PA-28-140 · Brookston, IN · Accident · 1 fatal · Field investigation · Final report · Feb 15, 1996 · N4612F · Destroyed
  > the pilot's disregard for the forecast adverse weather conditions, his inadvertent flight into adverse weather conditions, and his disorientation. Factors relating to this accident were the pilot's lack of experience in instrument conditions, the snow and fog.
- [NTSB ATL96TA047](https://openairdocs.org/ntsb/ATL96TA047.md): Piper PA-32-300 · Windermere, FL · Accident · Minor injuries · Final report · Feb 13, 1996 · N8951N · Substantial damage
  > the use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.
- [NTSB FTW96LA116](https://openairdocs.org/ntsb/FTW96LA116.md): Cessna 172K · Hedley, TX · Accident · No injuries · Limited investigation · Final report · Feb 11, 1996 · N7358G · Substantial damage
  > the failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC96FA061](https://openairdocs.org/ntsb/NYC96FA061.md): Cessna P206A · Forks Township, PA · Accident · 1 fatal · Field investigation · Final report · Feb 10, 1996 · N4655F · Destroyed
  > The pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.
- [NTSB CHI96FA088](https://openairdocs.org/ntsb/CHI96FA088.md): Bell 206B-III · Pellston, MI · Accident · 1 fatal · Field investigation · Final report · Feb 10, 1996 · N2157J · Destroyed
  > flight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…
- [NTSB FTW96LA115](https://openairdocs.org/ntsb/FTW96LA115.md): Cessna 172G · Gunnison, CO · Accident · No injuries · Limited investigation · Final report · Feb 9, 1996 · N4262L · Substantial damage
  > Loss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.
- [NTSB MIA96LA075](https://openairdocs.org/ntsb/MIA96LA075.md): Piper PA-28R · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Feb 8, 1996 · N55329 · Substantial damage
  > the partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.
- [NTSB LAX96FA108](https://openairdocs.org/ntsb/LAX96FA108.md): Piper PA-28-181 · Ramona, CA · Accident · Minor injuries · Field investigation · Final report · Feb 8, 1996 · N791CR · 2 aircraft · Substantial damage
  > inadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.
- [NTSB ATL96LA045](https://openairdocs.org/ntsb/ATL96LA045.md): Piper PA-32-RT-300 · Blountville, TN · Accident · No injuries · Limited investigation · Final report · Feb 7, 1996 · N2200J · Substantial damage
  > Inadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.
- [NTSB SEA96LA047](https://openairdocs.org/ntsb/SEA96LA047.md): Cessna 172M · Mcleary, WA · Accident · No injuries · Limited investigation · Final report · Feb 4, 1996 · N6750H · Substantial damage
  > failure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.
- [NTSB FTW96LA110](https://openairdocs.org/ntsb/FTW96LA110.md): Bell 206B · Cushing, OK · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 1996 · N2184Z · No damage
  > The inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.
- [NTSB ATL96LA044](https://openairdocs.org/ntsb/ATL96LA044.md): Beech C-45G · Blountville, TN · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 1996 · N204AA · Substantial damage
  > the pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…
- [NTSB LAX96LA104](https://openairdocs.org/ntsb/LAX96LA104.md): Bell 206BIII · Kamuela, HI · Accident · No injuries · Limited investigation · Final report · Feb 1, 1996 · N90194 · Substantial damage
  > failure of the nose case (No.1) bearing resulting in oil starvation.
- [NTSB FTW96FA145](https://openairdocs.org/ntsb/FTW96FA145.md): Piper PA-34-220T · Estes Park, CO · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1996 · N83809 · Destroyed
  > Descent into mountainous terrain for reasons undetermined.
- [NTSB LAX96LA099](https://openairdocs.org/ntsb/LAX96LA099.md): Piper PA-28 · Oroville, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1996 · N992PK · Substantial damage
  > the failure of the pilot to use carburetor heat, which resulted in loss of engine power due to carburetor ice. The carburetor icing (weather) condition was a related factor.
- [NTSB FTW96LA109](https://openairdocs.org/ntsb/FTW96LA109.md): Beech 77 · Grand Prairie, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1996 · N6706C · Substantial damage
  > a loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA107](https://openairdocs.org/ntsb/FTW96LA107.md): Boeing B75N1 · Bernal, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1996 · N69808 · Substantial damage
  > the pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…
- [NTSB FTW96FA108](https://openairdocs.org/ntsb/FTW96FA108.md): Cessna 152 · Conway, AR · Accident · Serious injuries · Field investigation · Final report · Jan 28, 1996 · N757UK · Destroyed
  > loss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.
- [NTSB BFO96LA041](https://openairdocs.org/ntsb/BFO96LA041.md): Cessna 172D · Rineyville, KY · Accident · No injuries · Limited investigation · Final report · Jan 28, 1996 · N2315U · Substantial damage
  > the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX96LA101](https://openairdocs.org/ntsb/LAX96LA101.md): Boeing A75 · Barstow, CA · Accident · No injuries · Limited investigation · Final report · Jan 27, 1996 · N1359N · Substantial damage
  > a loss of engine power for an undetermined reason(s).
- [NTSB BFO96LA040](https://openairdocs.org/ntsb/BFO96LA040.md): Aerostar 601 · Mount Storm, WV · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 1996 · N162GA · Destroyed
  > loss of power in the right engine for undetermined reason(s), and the accumulation of structural ice on the airplane, which resulted in an increased rate of descent and a subsequent forced landing before the pilot could reach an alternate airport. Factors…
- [NTSB BFO96FA039](https://openairdocs.org/ntsb/BFO96FA039.md): Cessna R172K · Highland Hills, OH · Accident · 2 fatal · Field investigation · Final report · Jan 23, 1996 · N3107V · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.
- [NTSB LAX96FA098](https://openairdocs.org/ntsb/LAX96FA098.md): Cessna T-210N · Gorman, CA · Accident · 2 fatal · Field investigation · Final report · Jan 22, 1996 · N6452N · Destroyed
  > The loss of control of the aircraft in cruise flight for undetermined reasons and subsequent in-flight structural failure of the aircraft.
- [NTSB CHI96FA083](https://openairdocs.org/ntsb/CHI96FA083.md): Piper PA-46-350P · Carlyle, IL · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1996 · N800CE · Destroyed
  > spatial disorientation of the pilot, and his failure to maintain control of the airplane, which resulted in his exceeding the design stress limits of the airframe. A factor relating to the accident was: turbulence in clouds.
- [NTSB FTW96FA100](https://openairdocs.org/ntsb/FTW96FA100.md): Beech 58 · Atkins, AR · Accident · 4 fatal · Field investigation · Final report · Jan 21, 1996 · N3010W · Destroyed
  > Continued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…
- [NTSB LAX96FA097](https://openairdocs.org/ntsb/LAX96FA097.md): Piper PA-28-236 · Seal Beach, CA · Accident · Minor injuries · Field investigation · Final report · Jan 20, 1996 · N2476Y · Substantial damage
  > a total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.
- [NTSB LAX96FA096](https://openairdocs.org/ntsb/LAX96FA096.md): Beech 55 · Cedarville, CA · Accident · 2 fatal · Field investigation · Final report · Jan 20, 1996 · N4088A · Destroyed
  > the pilot's poor preflight planning by not obtaining a weather briefing and his inadvertent encounter with a mountain wave condition. The moonless dark night was a factor in this accident.
- [NTSB MIA96LA066](https://openairdocs.org/ntsb/MIA96LA066.md): Piper PA-32R-300 · Smithville, TN · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1996 · N4457X · Substantial damage
  > The pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…
- [NTSB FTW96LA105](https://openairdocs.org/ntsb/FTW96LA105.md): Piper PA-38-112 · Falfurrias, TX · Accident · No injuries · Limited investigation · Final report · Jan 19, 1996 · N598Z · Substantial damage
  > fuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.

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

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

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