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

## Cases, newest first

- [NTSB MIA99LA137](https://openairdocs.org/ntsb/MIA99LA137.md): Beech A36 · Courtland, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 1999 · N769LW · Substantial damage
  > The failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…
- [NTSB LAX99LA159](https://openairdocs.org/ntsb/LAX99LA159.md): Cessna R182 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Apr 21, 1999 · N7317X · Substantial damage
  > The inadequate preflight inspection of the aircraft by the pilot-in-command which resulted in a loss of engine power due to water contamination in the fuel system. A factor in the accident was an improper maintenance alteration which disabled a fuel sump…
- [NTSB MIA99LA135](https://openairdocs.org/ntsb/MIA99LA135.md): Cessna 150M · S. Rockledge, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1999 · N66560 · Substantial damage
  > A total loss of engine power while in cruise flight due to the pilot's failure to use carburetor heat during carburetor icing conditions and the subsequent emergency landing to unsuitable terrain and collision with a tree.
- [NTSB LAX99LA155](https://openairdocs.org/ntsb/LAX99LA155.md): Cessna 150H · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1999 · N22710 · Substantial damage
  > A total loss of engine power resulting from the fatigue failure of a cylinder's exhaust valve. A contributing factor was the uneven terrain at the forced landing site. The reason for the fatigue could not be determined.
- [NTSB NYC99LA093](https://openairdocs.org/ntsb/NYC99LA093.md): Mooney M20E · Brooksville, KY · Accident · 1 fatal · Limited investigation · Final report · Apr 17, 1999 · N1987Y · Substantial damage
  > Contaminated fuel which resulted in the forced landing, and a heart attack from an adrenaline rush that interacted with preexisting coronary disease which resulted in the pilot's death.
- [NTSB MIA99LA131](https://openairdocs.org/ntsb/MIA99LA131.md): Piper J-3C · Jackson, MS · Accident · 1 fatal · Limited investigation · Final report · Apr 17, 1999 · N38272 · No damage
  > The failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…
- [NTSB LAX99LA181](https://openairdocs.org/ntsb/LAX99LA181.md): Piper PA-31-310 · La Verne, CA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1999 · N57AS · Substantial damage
  > The in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.
- [NTSB LAX99LA149](https://openairdocs.org/ntsb/LAX99LA149.md): Piper PA-31 · Pacific Ocean (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1999 · N141CM · Destroyed
  > An undetermined system malfunction in the right engine, which led to an increase in fuel usage beyond the pilot's planned fuel consumption rate and eventual fuel supply exhaustion.
- [NTSB MIA99LA130](https://openairdocs.org/ntsb/MIA99LA130.md): Zemp Avid Catalina · Sebring, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 1999 · N9224T · Substantial damage
  > The in-flight separation of one of the propeller blade's and one of the engine's exhaust pipes causing the engine to vibrate until it stopped running. A related factor was the unsuitable terrain for the forced landing.
- [NTSB ANC99LA046](https://openairdocs.org/ntsb/ANC99LA046.md): Stinson 108-2 · Kenai, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 14, 1999 · N221C · Substantial damage
  > The pilot's inadequate compensation for wind conditions. A factor associated with the accident was high winds.
- [NTSB ANC99FA047](https://openairdocs.org/ntsb/ANC99FA047.md): Cessna 207A · Kotzebue, AK · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1999 · N73188 · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, spatial disorientation, and an inadvertent stall. Factors in the accident were weather conditions consisting of snow and mist, and flat lighting conditions.
- [NTSB CHI99LA128](https://openairdocs.org/ntsb/CHI99LA128.md): Cessna T-188C · Dalton, NE · Accident · No injuries · Limited investigation · Final report · Apr 13, 1999 · N2173J · Substantial damage
  > the improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.
- [NTSB NYC99LA089](https://openairdocs.org/ntsb/NYC99LA089.md): American AA-5 · Stiefler Corner, PA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1999 · N8764J · Substantial damage
  > The pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.
- [NTSB MIA99LA124](https://openairdocs.org/ntsb/MIA99LA124.md): Bean Whitman W-10 · Wimauma, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1999 · N173RS · Substantial damage
  > The pilot's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a ditch and subsequent nose over.
- [NTSB MIA99FA125](https://openairdocs.org/ntsb/MIA99FA125.md): Piper PA-16 · Hardeeville, SC · Accident · 2 fatal · Field investigation · Final report · Apr 12, 1999 · N5796H · Destroyed
  > An inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.
- [NTSB LAX99LA165](https://openairdocs.org/ntsb/LAX99LA165.md): Parker Vans RV-4 · Red Bluff, CA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1999 · N6420E · Substantial damage
  > A crack which developed in the automotive-type oil cooler of the experimental, amateur built aircraft and permitted the engine oil supply to flow overboard.
- [NTSB IAD99FA038](https://openairdocs.org/ntsb/IAD99FA038.md): Beech BE-95A · Shawsville, VA · Accident · 4 fatal · Field investigation · Final report · Apr 12, 1999 · N3113K · Destroyed
  > the pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…
- [NTSB MIA99LA122](https://openairdocs.org/ntsb/MIA99LA122.md): Harris VARI-EZE · Eufaula, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 1999 · N250GH · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB SEA99LA059](https://openairdocs.org/ntsb/SEA99LA059.md): Cessna 172D · Glenns Ferry, ID · Accident · No injuries · Limited investigation · Final report · Apr 10, 1999 · N2650U · Substantial damage
  > The failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.
- [NTSB CHI99LA130](https://openairdocs.org/ntsb/CHI99LA130.md): Bell 206B · Cloquet, MN · Accident · No injuries · Limited investigation · Final report · Apr 10, 1999 · N119SP · Substantial damage
  > The pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pole and dusk light conditions.
- [NTSB CHI99IA136](https://openairdocs.org/ntsb/CHI99IA136.md): McDonnell Douglas DC-9-32 · Dubuque, IA · Incident · No injuries · Incident investigation · Final report · Apr 9, 1999 · N205ME · No damage
  > the frozen elevator control. Factors to the incident were the rain and the low temperature.
- [NTSB DEN99LA063](https://openairdocs.org/ntsb/DEN99LA063.md): Cessna 172P · Dulce, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1999 · N96212 · Substantial damage
  > The pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…
- [NTSB MIA99LA118](https://openairdocs.org/ntsb/MIA99LA118.md): Steve Hill Staudacher S600 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Apr 7, 1999 · N600SH · Substantial damage
  > The pilot's improper fuel consumption calculations which resulted in fuel exhaustion.
- [NTSB CHI99LA122](https://openairdocs.org/ntsb/CHI99LA122.md): Mooney M20J · Vienna, IL · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1999 · N9969X · Destroyed
  > The worn ignition points/cam follower assembly, and uneven landing terrain.
- [NTSB FTW99LA114](https://openairdocs.org/ntsb/FTW99LA114.md): Cessna 172N · Cleburne, TX · Accident · No injuries · Limited investigation · Final report · Apr 6, 1999 · N734SV · Substantial damage
  > The pilot's failure to maintain adequate altitude/ clearance from the wires.
- [NTSB LAX99LA140](https://openairdocs.org/ntsb/LAX99LA140.md): Cessna 210D · El Monte, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1999 · N2340F · Substantial damage
  > A loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.
- [NTSB FTW99LA105](https://openairdocs.org/ntsb/FTW99LA105.md): Bell 206L-1 · Shawnee, OK · Accident · No injuries · Limited investigation · Final report · Apr 5, 1999 · N255AL · Substantial damage
  > The improper flare during an autorotation by the pilot-in-command. A factor was the loss of engine power for an undetermined reason.
- [NTSB LAX99FA138](https://openairdocs.org/ntsb/LAX99FA138.md): Piper PA-32R-301 · Warner Springs, CA · Accident · 4 fatal · Field investigation · Final report · Apr 4, 1999 · N9254Q · Destroyed
  > The pilot disregarded his weather briefing and attempted flight into areas of forecast and reported icing and moderate to severe turbulence. The airplane encountered mountain wave activity resulting in an overload condition and in-flight separation of the…
- [NTSB FTW99FA104](https://openairdocs.org/ntsb/FTW99FA104.md): Piper PA-46-350P · Waldron, AR · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1999 · N497CA · Destroyed
  > The pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…
- [NTSB NYC99LA088](https://openairdocs.org/ntsb/NYC99LA088.md): Cessna 172XP · Ramapo, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1999 · N2743V · Substantial damage
  > Fuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor in the accident was the flight instructor's inadequate supervision of the solo cross-country flight.
- [NTSB SEA99LA046](https://openairdocs.org/ntsb/SEA99LA046.md): Cessna 205 · Edison, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 1999 · N8464K · Substantial damage
  > A total loss of engine power due to fatigue of the number six crankcheek resulting in crankshaft separation, and the lack of suitable terrain. Contributing factors were the sign and the ditch.
- [NTSB DEN99LA062](https://openairdocs.org/ntsb/DEN99LA062.md): Sly RV-6A · Payson, UT · Accident · No injuries · Limited investigation · Final report · Apr 2, 1999 · N80287 · Substantial damage
  > The development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…
- [NTSB SEA99IA045](https://openairdocs.org/ntsb/SEA99IA045.md): Fokker F.28 MK 4000 · Spokane, WA · Incident · No injuries · Incident investigation · Final report · Apr 1, 1999 · N477AU · No damage
  > A chafed hydraulic line.
- [NTSB LAX99FA136](https://openairdocs.org/ntsb/LAX99FA136.md): Bell 206B · Grand Canyon, AZ · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1999 · N992UC · Destroyed
  > The failure of the flight crew to properly preflight the helicopter and to detect and remove accumulated snow from the engine inlets and plenum chamber. Factors in the accident were the clouded plenum chamber inspection window and the failure of preceding…
- [NTSB CHI99FA227](https://openairdocs.org/ntsb/CHI99FA227.md): Smith, Ted Aerostar Aerostar 601P · St. Clair Shore, MI · Accident · 2 fatal · Field investigation · Final report · Apr 1, 1999 · N441CB · Destroyed
  > Undetermined as the aircraft was not recovered.
- [NTSB ATL99LA061](https://openairdocs.org/ntsb/ATL99LA061.md): Cessna 150J · Pembroke Pines, FL · Accident · No injuries · Limited investigation · Final report · Mar 29, 1999 · N60476 · Substantial damage
  > The pilot's inadequate in-flight/planning decision and his mismanagement of the fuel supply.
- [NTSB NYC99LA081](https://openairdocs.org/ntsb/NYC99LA081.md): Cessna 177RG · Pottstown, PA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1999 · N177AR · Substantial damage
  > The failure of maintenance personnel to properly inspect and torque the crankcase bolts.
- [NTSB MIA99LA115](https://openairdocs.org/ntsb/MIA99LA115.md): Beech A23 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Mar 28, 1999 · N8883M · Substantial damage
  > The pilots improper decision not to land straight ahead after sustaining a reported loss of engine power on initial take off climb with sufficient runway remaining, and improper recovery from a bounced landing resulting in a subsequent in-flight collision…
- [NTSB DEN99LA061](https://openairdocs.org/ntsb/DEN99LA061.md): Mooney M20K · Medicine Bow, WY · Accident · No injuries · Limited investigation · Final report · Mar 28, 1999 · N12HW · Substantial damage
  > A fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.
- [NTSB DEN99LA060](https://openairdocs.org/ntsb/DEN99LA060.md): Diamond Aircraft Industries DA 20-A1 · Coyote, NM · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1999 · N528SS · Destroyed
  > The pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…
- [NTSB DEN99FA064](https://openairdocs.org/ntsb/DEN99FA064.md): Piper PA-32-300 · Pagosa Springs, CO · Accident · 3 fatal · Field investigation · Final report · Mar 27, 1999 · N56306 · Destroyed
  > The pilot's continued VFR flight into IMC conditions. Related factors were flight into known adverse weather, the adverse weather, mountain obscuration, snow, icing, and high density altitude.
- [NTSB ATL99LA059](https://openairdocs.org/ntsb/ATL99LA059.md): Cessna 172 · Florala, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 1999 · N8968B · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.
- [NTSB MIA99LA113](https://openairdocs.org/ntsb/MIA99LA113.md): Dryer Fisher 404 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Mar 25, 1999 · N82435 · Substantial damage
  > The pilots improper in-flight planning/decision of an available forced landing area. This resulted in a subsequent in-flight collision with trees. Contributing to the accident was a total loss of engine power due to an inoperative generator coil.
- [NTSB MIA99FA114](https://openairdocs.org/ntsb/MIA99FA114.md): Grumman G-21A · Lauderdale Lake, FL · Accident · 1 fatal · Field investigation · Final report · Mar 25, 1999 · N5548A · Destroyed
  > The pilots failure to correctly identify an in-flight emergency (fluctuating manifold pressure and rpm due to a disconnected spark plug lead / unscrewed ignition lead shroud) and failure to complete the engine shutdown procedure once it was initiated…
- [NTSB MIA99LA112](https://openairdocs.org/ntsb/MIA99LA112.md): Cessna 15OF · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Mar 24, 1999 · N8397G · Substantial damage
  > The pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…
- [NTSB LAX99FA129](https://openairdocs.org/ntsb/LAX99FA129.md): Cessna 152 · Rancho Cucamong, CA · Accident · 1 fatal · Field investigation · Final report · Mar 22, 1999 · N67821 · Destroyed
  > the pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.
- [NTSB IAD99LA035](https://openairdocs.org/ntsb/IAD99LA035.md): Mooney M20C · Irving, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1999 · N5878Q · Substantial damage
  > was the pilot's intentional flight into known icing conditions.
- [NTSB CHI99IA115](https://openairdocs.org/ntsb/CHI99IA115.md): McDonnell Douglas DC-9-14 · Grand Rapids, MI · Incident · No injuries · Incident investigation · Final report · Mar 22, 1999 · N600ME · No damage
  > the frozen elevator control. Factors were the rain and the low temperatures.
- [NTSB NYC99FA078](https://openairdocs.org/ntsb/NYC99FA078.md): Deleeuw Sprint 1000 · Lakewood, NJ · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1999 · UNREG · Destroyed
  > The pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.
- [NTSB MIA99FA108](https://openairdocs.org/ntsb/MIA99FA108.md): Pushkar Hornet · Fort Lauderdale, FL · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1999 · N4376N · Destroyed
  > the pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.

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

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

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