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

## Cases, newest first

- [NTSB CHI96LA296](https://openairdocs.org/ntsb/CHI96LA296.md): Cessna 150 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Aug 14, 1996 · N61094 · Substantial damage
  > improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.
- [NTSB FTW96LA341](https://openairdocs.org/ntsb/FTW96LA341.md): Ayres S-2R · Wharton, TX · Accident · No injuries · Limited investigation · Final report · Aug 12, 1996 · N3084X · Substantial damage
  > total loss of engine power due to a fractured torque sensor shaft. Factors relating to the accident were: the obstructions (fence and trees) in the emergency landing area.
- [NTSB CHI96LA292](https://openairdocs.org/ntsb/CHI96LA292.md): Cessna 210E · Clarksville, MO · Accident · No injuries · Limited investigation · Final report · Aug 11, 1996 · N4963U · Substantial damage
  > fuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.
- [NTSB LAX96LA303](https://openairdocs.org/ntsb/LAX96LA303.md): Cessna 182B · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1996 · N2487G · Substantial damage
  > Improper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.
- [NTSB SEA96LA183](https://openairdocs.org/ntsb/SEA96LA183.md): Cessna 172N · Enumclaw, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1996 · N738PM · Substantial damage
  > failure of the engine magneto drive, which resulted in a loss of engine power. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB MIA96LA211](https://openairdocs.org/ntsb/MIA96LA211.md): Piper PA-25-235 · Farmville, NC · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1996 · N82313 · Substantial damage
  > The pilot's inadequate fuel consumption calculations which resulted in loss of engine power do to fuel exhaustion and a hard landing during a forced landing in a field.
- [NTSB MIA96LA208](https://openairdocs.org/ntsb/MIA96LA208.md): Beech A36 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Aug 9, 1996 · N976WL · Destroyed
  > an inflight collision with the terrain (water) for undetermined reason(s). Factors relating to the accident were: failure of the pilot to obtain a preflight weather briefing, his failure to obtain in-flight weather avoidance assistance, and his resultant…
- [NTSB MIA96LA207](https://openairdocs.org/ntsb/MIA96LA207.md): Stout Glasair III · Boynton Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1996 · N340 · Substantial damage
  > inadequate preflight by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.
- [NTSB CHI96FA284](https://openairdocs.org/ntsb/CHI96FA284.md): Piper PA-28-181 · Muncie, IN · Accident · 2 fatal · Field investigation · Final report · Aug 8, 1996 · N9137N · Destroyed
  > the inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.
- [NTSB CHI96FA278](https://openairdocs.org/ntsb/CHI96FA278.md): Lancair 320 · Fond Du Lac, WI · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1996 · N320L · Destroyed
  > the fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.
- [NTSB IAD96LA129](https://openairdocs.org/ntsb/IAD96LA129.md): Aerofab Lake 250 · Adirondack, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1996 · N8428F · Destroyed
  > the pilot's improper in-flight planning/decision, which resulted in his failure to ensure that he could maintain sufficient altitude and clearance from mountainous terrain after entering a blind canyon. Haze and the terrain were related factors.
- [NTSB FTW96LA345](https://openairdocs.org/ntsb/FTW96LA345.md): Cessna 210-5 · Muskogee, OK · Accident · No injuries · Limited investigation · Final report · Aug 7, 1996 · N8139Z · Substantial damage
  > loss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB FTW96LA335](https://openairdocs.org/ntsb/FTW96LA335.md): Beech V35B · Deer Park, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 1996 · N6054Q · Destroyed
  > loss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and obstructions in the emergency landing area (transmission lines and poles).
- [NTSB MIA96LA205](https://openairdocs.org/ntsb/MIA96LA205.md): Hampson Velocity · Dublin, GA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1996 · N637KM · Substantial damage
  > the failure of the exhaust of the cylinder Nos. 2 and 4 at each exhaust flange for undetermined reasons. The unsuitable terrain encountered during the forced landing was a factor.
- [NTSB ANC96FA118](https://openairdocs.org/ntsb/ANC96FA118.md): Cessna P206 · Nome, AK · Accident · 1 fatal · Field investigation · Final report · Aug 5, 1996 · CFRVD · Destroyed
  > The pilot's failure to maintain terrain clearance. Factors include mountainous terrain, low ceilings and mountain obscuration.
- [NTSB MIA96LA200](https://openairdocs.org/ntsb/MIA96LA200.md): Bell 206B III · Barton, AL · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 1996 · N5015T · Destroyed
  > failure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.
- [NTSB CHI96LA270](https://openairdocs.org/ntsb/CHI96LA270.md): Geide SPORT-A · Slater, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1996 · N1033B · Substantial damage
  > failure of a #2 connecting rod bolt, which led to a jammed connecting rod and subsequent overload separation of the #2 cylinder. A factor relating to the accident was: lack of suitable terrain for an emergency landing.
- [NTSB ANC96LA111](https://openairdocs.org/ntsb/ANC96LA111.md): McDonnell Douglas MD369D · Healy, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1996 · N58269 · 2 aircraft · No damage
  > The inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.
- [NTSB SEA96LA176](https://openairdocs.org/ntsb/SEA96LA176.md): Grumman-Schweizer G-164A · Belgrade, MT · Accident · No injuries · Limited investigation · Final report · Aug 3, 1996 · N9853 · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.
- [NTSB SEA96FA175](https://openairdocs.org/ntsb/SEA96FA175.md): Mooney M20E · Purdy, WA · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1996 · N9360M · Destroyed
  > The noninstrument-rated pilot's continuation of VFR flight into instrument meteorological conditions which led to pilot spatial disorientation and loss of control of the aircraft. Factors were: pilot self-induced pressure, night conditions, low ceilings, and…
- [NTSB LAX96FA294](https://openairdocs.org/ntsb/LAX96FA294.md): Mooney M20K · Grand Canyon, AZ · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1996 · N4634H · Destroyed
  > due to an in-flight loss of control resulting from a probable incapacitation for unknown reasons. The loss of control occurred while the aircraft was being flown in close proximity to a level 6 thunderstorm. The failure of the pilot to obtain current weather…
- [NTSB CHI96LA273](https://openairdocs.org/ntsb/CHI96LA273.md): Beech 77 · South Elgin, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1996 · N18259 · Substantial damage
  > water contamination in the carburetor.
- [NTSB CHI96LA271](https://openairdocs.org/ntsb/CHI96LA271.md): Cessna 150 · Wisconsin Rapid, WI · Accident · No injuries · Limited investigation · Final report · Aug 2, 1996 · N3238X · Substantial damage
  > fuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.
- [NTSB ATL96FA114](https://openairdocs.org/ntsb/ATL96FA114.md): Cessna TU206A · Greer, SC · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1996 · N4813F · Substantial damage
  > The disintegration of the number 3 piston, and the pilot's inadequate selection of terrain for the landing.
- [NTSB SEA96LA181](https://openairdocs.org/ntsb/SEA96LA181.md): Beech 35 · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1996 · N2839V · Substantial damage
  > failure (cracking) of the aft fuselage bulkhead for undetermined reason(s).
- [NTSB MIA96LA199](https://openairdocs.org/ntsb/MIA96LA199.md): Cessna 172N · Victoria, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1996 · N737DK · Substantial damage
  > The pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB CHI96LA269](https://openairdocs.org/ntsb/CHI96LA269.md): Vanwinkle Kitfox · Mt Vernon, IL · Accident · 1 fatal · Limited investigation · Final report · Jul 30, 1996 · N8200Q · Destroyed
  > failure of the pilot to maintain control of the airplane.
- [NTSB ANC96LA110](https://openairdocs.org/ntsb/ANC96LA110.md): Cessna 180 · Mc Carthy, AK · Accident · No injuries · Limited investigation · Final report · Jul 30, 1996 · N1746C · Substantial damage
  > The pilot's inadequate weather evaluation, and his inadvertent flight into instrument meteorological conditions.
- [NTSB LAX96LA291](https://openairdocs.org/ntsb/LAX96LA291.md): Boeing A75N1 · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Jul 29, 1996 · N68251 · Destroyed
  > A loss of engine power due to the disengagement of the crankshaft gear from it's hub due to the overload shear of the eight retaining screws.
- [NTSB NYC96LA160](https://openairdocs.org/ntsb/NYC96LA160.md): Cessna 152 · Castine, ME · Accident · No injuries · Limited investigation · Final report · Jul 28, 1996 · N65530 · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…
- [NTSB MIA96LA195](https://openairdocs.org/ntsb/MIA96LA195.md): Aeronca 11AC · Wedowee, AL · Accident · No injuries · Limited investigation · Final report · Jul 28, 1996 · N3905E · Substantial damage
  > The failure of the pilot to obtain a preflight weather briefing and his failure to maintain directional control during the landing roll following a precautionary landing due to adverse weather encountered during the flight.
- [NTSB CHI96LA255](https://openairdocs.org/ntsb/CHI96LA255.md): Piper PA-28-151 · New Melle, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1996 · N44059 · Substantial damage
  > the pilot's selection of an unsuitable area for an emergency/precautionary landing. Factors relating to the accident were: the pilot's continual operation of the airplane with a known deficiency (broken trim switch); an uncommanded activation of the elevator…
- [NTSB CHI96LA259](https://openairdocs.org/ntsb/CHI96LA259.md): Beech C24R · Hazelton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1996 · N5247M · Substantial damage
  > inadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…
- [NTSB ANC96FA109](https://openairdocs.org/ntsb/ANC96FA109.md): Cessna 180B · Iliamna, AK · Accident · 2 fatal · Field investigation · Final report · Jul 27, 1996 · N9141T · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and failure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the adverse weather condition (low ceiling and…
- [NTSB LAX96FA290](https://openairdocs.org/ntsb/LAX96FA290.md): Bellanca 8KCAB · Mound House, NV · Accident · 1 fatal · Field investigation · Final report · Jul 25, 1996 · N57438 · Destroyed
  > the flight instructor's improper in-flight planning/decision by allowing the student pilot to get too low during a simulated emergency landing before initiating a go-around.
- [NTSB IAD96LA123](https://openairdocs.org/ntsb/IAD96LA123.md): Cessna 172 RG · Union Bridge, MD · Accident · No injuries · Limited investigation · Final report · Jul 25, 1996 · N6169R · Substantial damage
  > loss of engine power for undetermined reason(s).
- [NTSB FTW96LA326](https://openairdocs.org/ntsb/FTW96LA326.md): Rockwell International S2R · Tahlequah, OK · Accident · No injuries · Limited investigation · Final report · Jul 25, 1996 · N4886X · Substantial damage
  > the pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA317](https://openairdocs.org/ntsb/FTW96LA317.md): Rockwell 112TC · Santa Rosa, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1996 · N1874J · Destroyed
  > loss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.
- [NTSB FTW96LA316](https://openairdocs.org/ntsb/FTW96LA316.md): Kraft AIR Master · Katy, TX · Accident · 2 fatal · Limited investigation · Final report · Jul 25, 1996 · N222Y · Destroyed
  > the pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation, loss of engine power, and a forced landing. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB NYC96FA158](https://openairdocs.org/ntsb/NYC96FA158.md): Piper PA-28-181 · Sea Bright, NJ · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1996 · N84280 · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane, due to spatial disorientation, which resulted in a collision with water. Factors relating to the accident were the pilot's…
- [NTSB FTW96FA319](https://openairdocs.org/ntsb/FTW96FA319.md): Chester Glasair RG · Lafayette, LA · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1996 · N127E · Destroyed
  > failure of the pilot to maintain proper altitude (and clearance above wooded terrain), while diverting to an alternate destination. Factors relating to the accident were: the loss of the comm/nav equipment as a result of an electrostatic discharge, darkness,…
- [NTSB LAX96LA288](https://openairdocs.org/ntsb/LAX96LA288.md): Cessna 182 · Weed, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1996 · N8787X · Substantial damage
  > The pilot's improper fuel management. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA96LA161](https://openairdocs.org/ntsb/SEA96LA161.md): Cessna T210N · Sunnyside, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1996 · N6439N · Substantial damage
  > inadequate preflight by the pilot, and subsequent fuel exhaustion. Factors relating to the accident were: darkness, and high vegetation (brush and small trees) in the emergency landing area.
- [NTSB LAX96LA285](https://openairdocs.org/ntsb/LAX96LA285.md): Diamond Aircraft Industries Katana DA-20-A1 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1996 · N236BR · Substantial damage
  > improper planning/decision by the instructor pilot, which resulted in subsequent fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.
- [NTSB LAX96FA284](https://openairdocs.org/ntsb/LAX96FA284.md): Cessna 210M · Corning, CA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 1996 · N6002N · Destroyed
  > improper installation of an electrical component, during an alteration of the aircraft electrical system; and subsequent electrical insulation failure, which resulted in electrical shorting, arcing, and an electrical fire. Factors relating to the accident…
- [NTSB ANC96LA103](https://openairdocs.org/ntsb/ANC96LA103.md): Cessna 172XP · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Jul 21, 1996 · N736LB · Substantial damage
  > The loss of engine power due to seized piston connecting rod bearings, and subsequent failure of the piston connecting rod cap and fracture of the piston connecting rod. A factor associated with the accident was the rough and uneven emergency landing site.
- [NTSB LAX96LA282](https://openairdocs.org/ntsb/LAX96LA282.md): Ercoupe 415-C · Page, AZ · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N2915H · Substantial damage
  > decision of the pilot to operate the airplane with an inoperative transfer pump and inaccurate fuel consumption calculations.
- [NTSB LAX96LA279](https://openairdocs.org/ntsb/LAX96LA279.md): Hiller UH-12E · Healdsburg, CA · Accident · No injuries · Limited investigation · Final report · Jul 20, 1996 · N124HA · Substantial damage
  > The failure of the pilot to confirm a loss of power before entering autorotation after reading an erroneous instrument indication on the helicopter's dual tachometer. Factors in the accident were the erratic instrument, and maintenance personnel who failed to…
- [NTSB CHI96LA247](https://openairdocs.org/ntsb/CHI96LA247.md): Grumman-Schweizer G-164A · Dighton, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1996 · N9544 · Substantial damage
  > loss of engine power for undetermined reason(s). The crop and soft terrain in the emergency landing area were related factors.
- [NTSB ANC96FA102](https://openairdocs.org/ntsb/ANC96FA102.md): Douglas DC-6A · Russian Mission, AK · Accident · 4 fatal · Field investigation · Final report · Jul 20, 1996 · N313RS · Destroyed
  > fatigue failure of the master connecting rod, which originated from corrosion pitting, subsequently compromised the engine crankcase, and resulted in a fire; and failure of the flight crew to follow emergency procedures by pulling the fire handle before…

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

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

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