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

## Cases, newest first

- [NTSB ERA11LA418](https://openairdocs.org/ntsb/ERA11LA418.md): Floyd Joseph B RV6 · Hartford, KY · Accident · No injuries · Limited investigation · Final report · Jul 24, 2011 · N164BF · Substantial damage
  > A loss of engine power due to fuel contamination as a result of the pilot/owner's inadequate maintenance of the airplane's fuel system, which resulted in blockage of the fuel lines and filters.
- [NTSB ERA11CA419](https://openairdocs.org/ntsb/ERA11CA419.md): Cessna 177 · Americus, GA · Accident · No injuries · Data collection · Final report · Jul 24, 2011 · N30214 · Substantial damage
  > The CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC11FA069](https://openairdocs.org/ntsb/ANC11FA069.md): Cessna 182P · Juneau, AK · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2011 · N7304S · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.
- [NTSB WPR11FA348](https://openairdocs.org/ntsb/WPR11FA348.md): Cessna 210-5(205) · Darby, MT · Accident · Minor injuries · Field investigation · Final report · Jul 22, 2011 · N8427Z · Substantial damage
  > The fatigue failure of the aluminum air intake duct, which resulted in material being ingested into the engine cylinders and a subsequent loss of engine power during cruise flight.
- [NTSB CEN11LA544](https://openairdocs.org/ntsb/CEN11LA544.md): Air Tractor AT802 · Ullin, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2011 · N396LA · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN11LA499](https://openairdocs.org/ntsb/CEN11LA499.md): Air Tractor AT-502 · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Jul 22, 2011 · N1516G · Substantial damage
  > The total loss of engine power for reasons that could not be determined because the airplane came to rest inverted in water.
- [NTSB WPR11CA342](https://openairdocs.org/ntsb/WPR11CA342.md): Schleicher ASW-27 · Preston, ID · Accident · No injuries · Data collection · Final report · Jul 21, 2011 · N78AB · Substantial damage
  > The glider's impact with crops during the off-airport landing.
- [NTSB CEN11LA491](https://openairdocs.org/ntsb/CEN11LA491.md): Beech C35 · Medina, OH · Accident · No injuries · Limited investigation · Final report · Jul 20, 2011 · N1883D · Substantial damage
  > The loss of engine power due to fuel starvation due to an age-related failure of the engine-driven fuel pump. Also causal was the failure of the maintenance facility to overhaul the fuel pump and the failure of the operator to ensure that the pump was…
- [NTSB WPR11CA486](https://openairdocs.org/ntsb/WPR11CA486.md): Schleicher ASW-27 · Brigham City, UT · Accident · No injuries · Data collection · Final report · Jul 19, 2011 · N797V · Substantial damage
  > The glider pilot did not take timely action to locate a safe outlanding area after entering an area where atmospheric lift was not sufficient to maintain soaring flight.
- [NTSB CEN11CA492](https://openairdocs.org/ntsb/CEN11CA492.md): Cessna 182S · Meeker, CO · Accident · No injuries · Data collection · Final report · Jul 19, 2011 · N314FR · Substantial damage
  > The pilot's inadvertent flight into a downdraft, which resulted in an in-flight collision with trees.
- [NTSB WPR11LA340](https://openairdocs.org/ntsb/WPR11LA340.md): Piper PA-24-250 · Lopez, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2011 · N5532P · Substantial damage
  > A partial loss of engine power due to a cracked engine case near the rear cylinder.
- [NTSB WPR11CA329](https://openairdocs.org/ntsb/WPR11CA329.md): Bellanca 7KCAB · Albany, OR · Accident · No injuries · Data collection · Final report · Jul 14, 2011 · N16TP · Substantial damage
  > The pilot's inadequate preflight inspection and failure to ensure the fuel cap was secured after refueling, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR11CA327](https://openairdocs.org/ntsb/WPR11CA327.md): Cessna 150J · Wheatland, WY · Accident · Minor injuries · Data collection · Final report · Jul 13, 2011 · N60060 · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to continue flight with known equipment deficiencies.
- [NTSB CEN11LA490](https://openairdocs.org/ntsb/CEN11LA490.md): Darrow Stephen AL-6 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Jul 13, 2011 · N61262 · Substantial damage
  > The loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.
- [NTSB ERA11RA398](https://openairdocs.org/ntsb/ERA11RA398.md): Robinson R66 · Girardot, Colombia · Accident · 2 fatal · Foreign investigation · Jul 12, 2011 · N810AG · Substantial damage
  > On July 12, 2011, about 2041 UTC, or 1541 local, a Robinson Helicopter Company R66, N810AG, registered to Aircraft Guaranty Corporation Trustee, operated by a private individual, collided with terrain near Girardot, Colombia. Visual meteorological conditions…
- [NTSB WPR11CA321](https://openairdocs.org/ntsb/WPR11CA321.md): Leineke Walter L Thorp T-211 · Cedar City, UT · Accident · Minor injuries · Data collection · Final report · Jul 10, 2011 · N2075U · Substantial damage
  > The pilot's misjudgment of the fuel consumption, which lead to fuel exhaustion. Contributing to the accident was the pilot's lack of experience in the accident airplane.
- [NTSB ANC11FA062](https://openairdocs.org/ntsb/ANC11FA062.md): Cessna U206 · Port Alsworth, AK · Accident · No injuries · Field investigation · Final report · Jul 10, 2011 · N2186F · 2 aircraft · Minor damage
  > The pilot’s failure to see and avoid the approaching airplane. Contributing to the accident was that the pilot’s failure to listen to radio position reports from the other airplane on the common traffic advisory frequency and the absence of any forward-facing…
- [NTSB CEN11LA472](https://openairdocs.org/ntsb/CEN11LA472.md): Cessna 150J · Lacassine, LA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2011 · N50575 · Substantial damage
  > A total loss of engine power due to fuel exhaustion, as a result of the pilot's improper fuel planning.
- [NTSB CEN11FA469](https://openairdocs.org/ntsb/CEN11FA469.md): Bowie Richard Sonerai II · Dudley, MO · Accident · 1 fatal · Field investigation · Final report · Jul 9, 2011 · N113RB · Substantial damage
  > Fuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.
- [NTSB CEN11FA468](https://openairdocs.org/ntsb/CEN11FA468.md): Robinson Helicopter R44 II · Rising Sun, IN · Accident · 1 fatal · Field investigation · Final report · Jul 9, 2011 · N42333 · Substantial damage
  > The noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.
- [NTSB ANC11LA061](https://openairdocs.org/ntsb/ANC11LA061.md): Cessna U206E · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2011 · N9129M · Substantial damage
  > The pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…
- [NTSB WPR11FA319](https://openairdocs.org/ntsb/WPR11FA319.md): Piper PA-22-135 · Verlot, WA · Accident · 2 fatal · Field investigation · Final report · Jul 8, 2011 · N8721C · Substantial damage
  > The non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.
- [NTSB WPR11WA488](https://openairdocs.org/ntsb/WPR11WA488.md): Eurocopter BO105 · Tari, Papua New Guinea · Accident · No injuries · Foreign investigation · Jul 7, 2011 · P2-LAE · Substantial damage
  > On July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…
- [NTSB WPR11LA311](https://openairdocs.org/ntsb/WPR11LA311.md): Cessna R182 · Hesperia, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 2011 · N7392X · Substantial damage
  > The separation of the end baffle cone inside the muffler, which blocked airflow through the engine after takeoff and resulted in a loss of engine power and an off-airport landing into obstacles.
- [NTSB WPR11LA306](https://openairdocs.org/ntsb/WPR11LA306.md): Grumman American Avn. AA-5 · Yacoit, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 2011 · N1334R · Substantial damage
  > The pilot’s failure to maintain clearance from terrain.
- [NTSB ANC11IA059](https://openairdocs.org/ntsb/ANC11IA059.md): Hughes 500D · McGrath, AK · Incident · No injuries · Incident investigation · Final report · Jul 5, 2011 · N315SH · Minor damage
  > A fatigue fracture of the governor-to-fuel control Pc line, which resulted in a partial loss of engine power.
- [NTSB WPR11FA304](https://openairdocs.org/ntsb/WPR11FA304.md): Cessna 180D · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2011 · N6451X · Substantial damage
  > The pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.
- [NTSB ERA11LA388](https://openairdocs.org/ntsb/ERA11LA388.md): Cessna 172N · Orange Beach, AL · Accident · No injuries · Limited investigation · Final report · Jul 4, 2011 · N109DP · Substantial damage
  > The operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…
- [NTSB ERA11FA376](https://openairdocs.org/ntsb/ERA11FA376.md): Cessna A185F · Yabucoa, PR · Accident · 5 fatal · Field investigation · Final report · Jul 1, 2011 · N8436Q · Substantial damage
  > The pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.
- [NTSB CEN11LA441](https://openairdocs.org/ntsb/CEN11LA441.md): Piper PA-28-180 · Flippin, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 2011 · N56417 · Substantial damage
  > The loss of engine power due to improper maintenance and resultant oil starvation.
- [NTSB ERA11CA373](https://openairdocs.org/ntsb/ERA11CA373.md): Leatherman Karl L Zodiac CH 601 HDS · Gray Court, SC · Accident · No injuries · Data collection · Final report · Jun 30, 2011 · N67KL · Substantial damage
  > The total loss of engine power due to the failure of the radiator coolant supply fitting.
- [NTSB CEN11FA436](https://openairdocs.org/ntsb/CEN11FA436.md): Ray Aerial Spraying 773 Racer · Ottumwa, IA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2011 · N773RY · Destroyed
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airplane’s engine and ignition system did not reveal any anomalies that would have precluded normal operation, and extensive postaccident fire damage…
- [NTSB CEN11LA430](https://openairdocs.org/ntsb/CEN11LA430.md): Piper PA-28-180 · Barron, WI · Accident · No injuries · Limited investigation · Final report · Jun 29, 2011 · N9002J · Substantial damage
  > The loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.
- [NTSB CEN11FA428](https://openairdocs.org/ntsb/CEN11FA428.md): Cessna R182 · Thornton, CO · Accident · 1 fatal · Field investigation · Final report · Jun 29, 2011 · N2344C · Substantial damage
  > The pilot's inadvertent encounter with a microburst while operating at a low altitude, which resulted in a loss of control from which the pilot could not recover. Contributing to the accident was the pilot’s inadequate preflight planning for the forecasted…
- [NTSB CEN11CA427](https://openairdocs.org/ntsb/CEN11CA427.md): Mooney M20E · Frankston, TX · Accident · No injuries · Data collection · Final report · Jun 29, 2011 · N55FE · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN11FA422](https://openairdocs.org/ntsb/CEN11FA422.md): Robinson R22 Beta · Del Valle, TX · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2011 · N7779M · Substantial damage
  > The divergence of the main rotor from its normal plane of rotation for reasons that cannot be determined because the pilot’s control inputs leading up to the event are unknown, resulting in mast bumping and main rotor blade separation.
- [NTSB WPR11LA290](https://openairdocs.org/ntsb/WPR11LA290.md): Christen Industries Pitts S-1T · Alkali Lake, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 2011 · N77MN · Substantial damage
  > The loss of engine oil during cruise flight due to the failure of the front bearing oil seal.
- [NTSB CEN11FA425](https://openairdocs.org/ntsb/CEN11FA425.md): Cessna T210L · Romeoville, IL · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2011 · N732BX · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.
- [NTSB WPR11LA288](https://openairdocs.org/ntsb/WPR11LA288.md): Air Tractor AT-502 · Lewistown, MT · Accident · No injuries · Limited investigation · Final report · Jun 25, 2011 · N1022N · Substantial damage
  > The fatigue fracture and separation of the fuel bypass line, which resulted in a total loss of engine power.
- [NTSB ERA11CA364](https://openairdocs.org/ntsb/ERA11CA364.md): Helio H-295 · Brasstown, NC · Accident · Minor injuries · Data collection · Final report · Jun 25, 2011 · N99PM · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR11LA283](https://openairdocs.org/ntsb/WPR11LA283.md): Beech A36 · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 2011 · N2206L · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the forced landing, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the loss of engine power due to fuel starvation as a result of the pilot's improper fuel…
- [NTSB WPR11LA279](https://openairdocs.org/ntsb/WPR11LA279.md): Rockwell International S-2R · Brawley, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 2011 · N8520V · Substantial damage
  > The partial loss of engine power shortly after takeoff, which likely resulted from the failure of the piston connecting rod in cylinder number 3 due to hydraulic lock in that cylinder.
- [NTSB ERA11WA368](https://openairdocs.org/ntsb/ERA11WA368.md): Cirrus SR20 · Cairo Montenotte, Italy · Accident · 3 fatal · Foreign investigation · Jun 23, 2011 · LX-MPR · Substantial damage
  > On June 23, 2011, about 1000 UTC, a Cirrus SR20, Luxembourg registration LX-MPR, operated by a private individual, collided with mountainous terrain near Cairo Montenotte, Italy. Instrument meteorological conditions prevailed in the area at the time and…
- [NTSB ERA11CA367](https://openairdocs.org/ntsb/ERA11CA367.md): Mcdonnell Douglas MD88 · Miami, FL · Accident · Serious injuries · Data collection · Final report · Jun 22, 2011 · N884DA · No damage
  > The in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.
- [NTSB WPR11FA268](https://openairdocs.org/ntsb/WPR11FA268.md): Trusty Thorp T-18 · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Jun 20, 2011 · N851LT · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.
- [NTSB ERA11CA352](https://openairdocs.org/ntsb/ERA11CA352.md): Piper PA18-160 · Ridgeville, SC · Accident · No injuries · Data collection · Final report · Jun 19, 2011 · N177SC · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.
- [NTSB CEN11WA412](https://openairdocs.org/ntsb/CEN11WA412.md): McDonnell Douglas Helicopter 369E · Glastonbury, United Kingdom · Accident · Serious injuries · Foreign investigation · Jun 19, 2011 · G-KSWI · Substantial damage
  > On June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…
- [NTSB CEN11LA413](https://openairdocs.org/ntsb/CEN11LA413.md): Cessna 172N · Bedford Park, IL · Accident · No injuries · Limited investigation · Final report · Jun 18, 2011 · N172NT · Substantial damage
  > A loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.
- [NTSB CEN11LA402](https://openairdocs.org/ntsb/CEN11LA402.md): Cessna P210R · Albia, IA · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2011 · N900SR · Substantial damage
  > The pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.
- [NTSB CEN11WA407](https://openairdocs.org/ntsb/CEN11WA407.md): Piper PA-39 · Mont Agel, France · Accident · 2 fatal · Foreign investigation · Jun 17, 2011 · G-AYZE · Destroyed
  > Under the jurisdiction and control of the French government.

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

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

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