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

## Cases, newest first

- [NTSB NYC99FA163](https://openairdocs.org/ntsb/NYC99FA163.md): Piper PA-31T · Deerfield, VA · Accident · 1 fatal · Field investigation · Final report · Jul 1, 1999 · N602RM · Destroyed
  > Loss of control of the airplane due to pilot incapacitation following a heart attack.
- [NTSB MIA99LA192](https://openairdocs.org/ntsb/MIA99LA192.md): Cessna 182Q · Rock Springs, NC · Accident · No injuries · Limited investigation · Final report · Jun 30, 1999 · N4784N · Substantial damage
  > **This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.
- [NTSB ANC99LA083](https://openairdocs.org/ntsb/ANC99LA083.md): Cessna TU206 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1999 · N126KT · Substantial damage
  > The pilot not following emergency procedures, and improper use of the electric fuel boost pump, while attempting to restart the engine in flight. A factor associated with this accident was the inadequate fuel consumption calculations by the pilot.
- [NTSB MIA99LA191](https://openairdocs.org/ntsb/MIA99LA191.md): Mooney M20F · Liberty, NC · Accident · No injuries · Limited investigation · Final report · Jun 29, 1999 · N7114V · Substantial damage
  > Improper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…
- [NTSB LAX99LA233](https://openairdocs.org/ntsb/LAX99LA233.md): Ercoupe E · Winnemucca, NV · Accident · No injuries · Limited investigation · Final report · Jun 29, 1999 · N3640H · Substantial damage
  > An improperly installed and maintained float needle in the carburetor, which would not seat sufficiently to stop fuel flow and caused the engine to run excessively rich, resulting in a complete loss of engine power.
- [NTSB DEN99FA109](https://openairdocs.org/ntsb/DEN99FA109.md): Boeing Stearman A75 · Carpenter, WY · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1999 · N801RB · Destroyed
  > Pilot incapacitation for unknown reasons.
- [NTSB FTW99LA174](https://openairdocs.org/ntsb/FTW99LA174.md): Piper PA-34-220T · Laredo, TX · Accident · No injuries · Limited investigation · Final report · Jun 27, 1999 · N8329M · Substantial damage
  > The pilot's failure to refuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW99LA207](https://openairdocs.org/ntsb/FTW99LA207.md): Boeing 737-3H4 · Lafayette, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1999 · N650SW · No damage
  > The pilot's inadvertent flight into an adverse weather condition. A factor was the turbulence.
- [NTSB CHI99LA200](https://openairdocs.org/ntsb/CHI99LA200.md): Gillmore Benson B&M · Greencastle, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1999 · N2152G · Substantial damage
  > the failure of the cyclic control rod. Factors were aircraft control not possible for the pilot.
- [NTSB CHI99FA196](https://openairdocs.org/ntsb/CHI99FA196.md): Beech C-23 · Mandan, ND · Accident · 1 fatal · Field investigation · Final report · Jun 26, 1999 · N9703Q · Destroyed
  > the pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.
- [NTSB MIA99FA188](https://openairdocs.org/ntsb/MIA99FA188.md): Beech C90 · Munson, FL · Accident · 2 fatal · Field investigation · Final report · Jun 25, 1999 · N3019W · Destroyed
  > The poor in-flight weather evaluation by the pilot-in-command and his operation of the airplane at an indicated airspeed greater than the design maneuvering speed (Va) in a thunderstorm contrary to the pilot's operating handbook resulting in an in-flight…
- [NTSB LAX99LA231](https://openairdocs.org/ntsb/LAX99LA231.md): Cessna TU206F · Saline Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1999 · N8728Q · Substantial damage
  > The pilot's failure to verify the fuel quantity prior to departure, which led to fuel exhaustion.
- [NTSB IAD99LA050](https://openairdocs.org/ntsb/IAD99LA050.md): Boeing Stearman PT17 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1999 · N61467 · Destroyed
  > the pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.
- [NTSB ANC99LA082](https://openairdocs.org/ntsb/ANC99LA082.md): Maule M-4-220C · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Jun 24, 1999 · N40677 · Substantial damage
  > A separation of the number 4 engine cylinder, and a fracture of the number 4 engine connecting rod.
- [NTSB SEA99LA093](https://openairdocs.org/ntsb/SEA99LA093.md): Modrow Avid Flyer · Poulsbo, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1999 · N700RM · Substantial damage
  > Engine seizing due to failure of main bearing assemblies. Factors include foreign material in the labyrinth sleeve, and a stall encountered while the pilot was attempting his emergency landing.
- [NTSB NYC99FA157](https://openairdocs.org/ntsb/NYC99FA157.md): Robinson R-22 · Hurricane, WV · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1999 · N9070F · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.
- [NTSB SEA99LA089](https://openairdocs.org/ntsb/SEA99LA089.md): Weatherly 620B · Tetonia, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1999 · N2033N · Substantial damage
  > A failure of the right magneto drive gear shaft. Factors include the absence of any suitable terrain on which to perform an emergency landing, and the rough/uneven condition of the terrain on which the pilot was forced to land.
- [NTSB NYC99LA153](https://openairdocs.org/ntsb/NYC99LA153.md): Cessna 182Q · Rising Sun, MD · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1999 · N937FB · Destroyed
  > The failure of the connecting rod end bolts, due to an overtemperature condition.
- [NTSB MIA99LA186](https://openairdocs.org/ntsb/MIA99LA186.md): Robert R. Callahan Exec 90 · Lutz, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1999 · N4359N · Substantial damage
  > The excessive cyclic input by the non-qualified passenger during the autorotative landing following a reported loss of engine power. A factor in the accident was the inadequate preflight of the helicopter by the unqualified pilot for his failure to detect…
- [NTSB LAX99LA221](https://openairdocs.org/ntsb/LAX99LA221.md): Cessna 172M · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1999 · N61560 · Destroyed
  > The mechanic's improper installation of nonapproved automotive electrical system parts, and his failure to ensure that all electrical connections were secure during the reinstallation, which resulted in the failure of the electrical system. The pilot's…
- [NTSB FTW99FA172](https://openairdocs.org/ntsb/FTW99FA172.md): Keen Glasair I · Albany, TX · Accident · 1 fatal · Field investigation · Final report · Jun 20, 1999 · N233TK · Destroyed
  > The pilot's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines. Factors were the night light condition and the pilot's decision to fly at low altitude.
- [NTSB LAX99LA228](https://openairdocs.org/ntsb/LAX99LA228.md): Let Blanik L-13 · Barstow, CA · Accident · No injuries · Limited investigation · Final report · Jun 19, 1999 · N136AS · Substantial damage
  > The loss of thermal lift that resulted in a forced landing and the pilot's improper glide path that resulted in a collision with a light pole.
- [NTSB LAX99FA214](https://openairdocs.org/ntsb/LAX99FA214.md): Piper PA-28R-200 · Bass Lake, CA · Accident · 4 fatal · Field investigation · Final report · Jun 18, 1999 · N2706R · Destroyed
  > Inadequate in-flight planning and decision making resulted in a failure to maintain clearance from terrain. A factor in the accident was the pilot's low total time and lack of experience in this make and model of airplane.
- [NTSB NYC99LA144](https://openairdocs.org/ntsb/NYC99LA144.md): Taylorcraft BC-65 · Corinna, ME · Accident · No injuries · Limited investigation · Final report · Jun 17, 1999 · N36205 · Substantial damage
  > The pilot-in-command's failure to maintain adequate airspeed which resulted in an inadvertent stall.
- [NTSB NYC99LA146](https://openairdocs.org/ntsb/NYC99LA146.md): Hiller UH-12C · Delphos, OH · Accident · No injuries · Limited investigation · Final report · Jun 16, 1999 · N57CR · Substantial damage
  > A blocked fuel line, from an unknown object, that resulted in fuel starvation, and total loss of engine power. A factor in the accident was the pilot's failure to maintain rotor rpm during the autorotation.
- [NTSB DEN99LA104](https://openairdocs.org/ntsb/DEN99LA104.md): Mooney M20E · Canon City, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1999 · N9355M · Destroyed
  > The pilot's poor judgement due to his intentional and continued flight into instrument meteorological conditions. Factors were the existing weather conditions that included clouds and obscuration.
- [NTSB CHI99LA186](https://openairdocs.org/ntsb/CHI99LA186.md): North American Navion L-17A · Osceola, WI · Accident · No injuries · Limited investigation · Final report · Jun 16, 1999 · N109F · Substantial damage
  > the pilot's mismanagement of the fuel system in that he had the fuel selector positioned to a tank which did not contain sufficient fuel for the flight. Factors associated with the accident were the crop and the ditch which the airplane encountered during the…
- [NTSB MIA99LA184](https://openairdocs.org/ntsb/MIA99LA184.md): Donald White Velocity XL/RG · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Jun 15, 1999 · N19DW · Substantial damage
  > The owner/pilot mechanic's failure to adjust the newly installed wing fuel caps resulting in the loss of engine power while in cruise flight due to fuel starvation and the subsequent collision with transmission wires while attempting a forced landing to a…
- [NTSB FTW99LA165](https://openairdocs.org/ntsb/FTW99LA165.md): Piper PA-12 · Panhandle, TX · Accident · No injuries · Limited investigation · Final report · Jun 12, 1999 · N2699M · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.
- [NTSB CHI99LA184](https://openairdocs.org/ntsb/CHI99LA184.md): Boeing 777-222 · Madison, WI · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1999 · N781UA · No damage
  > the pilot-in-command's inadequate evaluation of the weather conditions. Factors associated with the accident were the turbulence encountered and the seat belt sign was not illuminated.
- [NTSB MIA99LA181](https://openairdocs.org/ntsb/MIA99LA181.md): Robinson R-44 · Sevierville, TN · Accident · No injuries · Limited investigation · Final report · Jun 11, 1999 · N49669 · Substantial damage
  > The induced fatigue fracture of a component in the engine-to-transmission rotor drive system resulting in a disconnection of the drive system during cruise flight caused by inadequate inspection processes by the manufacturer and the subsequent autorotative…
- [NTSB MIA99FA172](https://openairdocs.org/ntsb/MIA99FA172.md): Piper PA-28R-200 · Cape Canaveral, FL · Accident · 1 fatal · Field investigation · Final report · Jun 10, 1999 · N56192 · Destroyed
  > The pilot's VFR flight into Instrument meteorological conditions and his subsequent failure to maintain control of the aircraft resulting in overload and separation of both wings. Contributing factors were the pilot's failure to obtain a preflight and…
- [NTSB DEN99LA102](https://openairdocs.org/ntsb/DEN99LA102.md): Schweizer SGU-2-22E · Hobbs, NM · Accident · No injuries · Limited investigation · Final report · Jun 10, 1999 · N5823V · Substantial damage
  > Pilot incapacitation (loss of consciousness) due to dehydration and hyperventilation. Factors were the turbulence and excessive workload (task overload) that induced anxiety/apprehension, and striking the sign and the pole.
- [NTSB MIA99LA170](https://openairdocs.org/ntsb/MIA99LA170.md): Piper PA-28-181 · Auburn, AL · Accident · No injuries · Limited investigation · Final report · Jun 9, 1999 · N983DB · Destroyed
  > The pilot' failure to refuel the airplane prior to fuel exhaustion.
- [NTSB MIA99LA169](https://openairdocs.org/ntsb/MIA99LA169.md): Cessna 140 · Woodstock, GA · Accident · No injuries · Limited investigation · Final report · Jun 9, 1999 · N76390 · Substantial damage
  > a total loss of engine power due to fuel starvation because of contaminated fuel, resulting in a forced landing and subsequent impact with a tree.
- [NTSB LAX99LA212](https://openairdocs.org/ntsb/LAX99LA212.md): Boeing 747-422 · Pacific Ocean (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 1999 · N198UA · No damage
  > intentional tampering/altering of a galley lift interlock microswitch by unknown persons.
- [NTSB FTW99LA162](https://openairdocs.org/ntsb/FTW99LA162.md): Bell 412 · Eugene Is. 313 · Accident · No injuries · Limited investigation · Final report · Jun 9, 1999 · N3893S · Substantial damage
  > The separation of a section of the tail rotor blade, and subsequent separation of the tail rotor system, as a result of fatigue cracking due to corrosion in the tail rotor blade spar.
- [NTSB CHI99LA180](https://openairdocs.org/ntsb/CHI99LA180.md): Cessna 182D · Zurich, KS · Accident · No injuries · Limited investigation · Final report · Jun 9, 1999 · N9169X · Substantial damage
  > the pilot's inadequate preflight planning/preparation. A factor was fuel exhaustion.
- [NTSB CHI99FA177](https://openairdocs.org/ntsb/CHI99FA177.md): Cessna 340A · Phillipsburg, KS · Accident · 2 fatal · Field investigation · Final report · Jun 8, 1999 · N1372G · Destroyed
  > the pilot not maintaining flying speed. Factors to the accident were the fuel transfer problem of unknown origin.
- [NTSB MIA99LA166](https://openairdocs.org/ntsb/MIA99LA166.md): Cessna 182E · Rolling Fork, MS · Accident · No injuries · Limited investigation · Final report · Jun 6, 1999 · N9267X · Substantial damage
  > Improper torqueing of the connecting rod bolts which resulted in the bolts being loose and rubbing in the dowel area which resulted in fatigue emanation and cracking and separation of the number 3 connecting rod after bolt failure.
- [NTSB MIA99LA164](https://openairdocs.org/ntsb/MIA99LA164.md): Cessna 177RG · Timmonsville, SC · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1999 · N1982Q · Substantial damage
  > The loss of engine power due to the improper installation and in-flight separation of an engine cylinder.
- [NTSB LAX99LA209](https://openairdocs.org/ntsb/LAX99LA209.md): Blanco SEA Hawker · Yucca Valley, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 6, 1999 · N2485 · Destroyed
  > A loss of control in flight for undetermined reasons that resulted in an in flight collision with terrain. A factor was turbulent weather conditions in mountainous/hilly terrain.
- [NTSB DEN99LA096](https://openairdocs.org/ntsb/DEN99LA096.md): Cessna 177RG · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jun 6, 1999 · N2637V · Substantial damage
  > The pilot's inadequate flight planning, and lack of suitable terrain for the forced landing. Factor's were the pilot's inadequate aircraft preflight, and the subsequent engine power loss due to fuel exhaustion.
- [NTSB LAX99LA219](https://openairdocs.org/ntsb/LAX99LA219.md): Beech A-36 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1999 · N126GL · Substantial damage
  > The failure of the pilot to verify that the alternator was activated after engine start, subsequently resulting in a total electrical failure; and his inadequate emergency procedures for manual extension of the landing gear following the electrical failure.
- [NTSB FTW99LA160](https://openairdocs.org/ntsb/FTW99LA160.md): Cessna P210N · Cleburne, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1999 · N4774K · Substantial damage
  > The total loss of engine power resulting from a failure of the #4 cylinder exhaust valve and/or piston. Factors were the dark night conditions and the lack of suitable terrain for the forced landing.
- [NTSB DEN99FA093](https://openairdocs.org/ntsb/DEN99FA093.md): Beech V35A · Nederland, CO · Accident · 1 fatal · Field investigation · Final report · Jun 5, 1999 · N68VT · Destroyed
  > The pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.
- [NTSB LAX99LA208](https://openairdocs.org/ntsb/LAX99LA208.md): Culver V · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1999 · N44549 · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate in-flight planning and failure to refuel the aircraft during an en route stop.
- [NTSB NYC99LA128](https://openairdocs.org/ntsb/NYC99LA128.md): Cessna T310Q · West Laurens, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 3, 1999 · N1273G · Substantial damage
  > the pilot's impairment due to hypoxia, which resulted in reduced situational awareness and a power loss due to fuel exhaustion.
- [NTSB NYC99LA134](https://openairdocs.org/ntsb/NYC99LA134.md): Saliba Long EZ · Friendly, MD · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 1999 · N555L · Destroyed
  > The separation of the airplane canopy for undetermined reasons, the diminished controllability of the airplane, and the pilot's failure to maintain airspeed resulting in a stall/mush into trees short of the runway.
- [NTSB FTW99LA155](https://openairdocs.org/ntsb/FTW99LA155.md): Bell 206B · Venice, LA · Accident · No injuries · Limited investigation · Final report · Jun 1, 1999 · N7131U · Substantial damage
  > The pilot's improper touchdown procedure, resulting in a main rotor blade contacting the tailboom. Factors were the soft and wet terrain conditions, and the loss of engine power due to the spiral fatigue failure of the gas generator turbine shafting due to…

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

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

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