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

## Cases, newest first

- [NTSB LAX00LA067](https://openairdocs.org/ntsb/LAX00LA067.md): Piper PA-28-181 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Dec 2, 1999 · N4319Y · Substantial damage
  > The failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…
- [NTSB NYC00LA042](https://openairdocs.org/ntsb/NYC00LA042.md): Schempp-Hirth Discus A · Palmerton, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1999 · N117TB · Substantial damage
  > The pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.
- [NTSB IAD00LA008](https://openairdocs.org/ntsb/IAD00LA008.md): Piper PA-28-140 · Olean, NY · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1999 · N7407J · Destroyed
  > the loss of engine power from water-contaminated fuel due to the pilot's inadequate preflight inspection.
- [NTSB FTW00LA038](https://openairdocs.org/ntsb/FTW00LA038.md): Beech BE35 · Stillwater, OK · Accident · Serious injuries · Limited investigation · Final report · Nov 28, 1999 · N444D · Substantial damage
  > The total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.
- [NTSB MIA00FA030](https://openairdocs.org/ntsb/MIA00FA030.md): Bell 212 · Philadelphia, MS · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1999 · N8144M · Destroyed
  > The failure of the pilot and company maintenance personnel during preflight and periodic inspections to identify the signs of fretting and looseness in the "red" main rotor blade pitch change horn to main rotor blade grip attachment, resulting in the…
- [NTSB NYC00FA039](https://openairdocs.org/ntsb/NYC00FA039.md): Beech S35 · Newark, NJ · Accident · 3 fatal · Field investigation · Final report · Nov 26, 1999 · N8992M · Destroyed
  > The pilot's failure to maintain aircraft control. Factors in the accident were failure of the horizontal situation indicator for undetermined reasons, and the pilot's use of inappropriate medication.
- [NTSB MIA00FA029](https://openairdocs.org/ntsb/MIA00FA029.md): Hughes 369HS · Helena, AL · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1999 · N395WM · Destroyed
  > The pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.
- [NTSB DEN00GA022](https://openairdocs.org/ntsb/DEN00GA022.md): Bell 206 L-3 · Rifle, CO · Accident · No injuries · Final report · Nov 24, 1999 · N617DE · Substantial damage
  > a forced landing on rough, unsuitable terrain. A contributing factor was the partial loss of engine power, which resulted from improper maintenance by repair station personnel.
- [NTSB MIA00LA028](https://openairdocs.org/ntsb/MIA00LA028.md): Cessna 172N · Defuniak Spgs, FL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1999 · N733AH · Substantial damage
  > Was the pilot's failure to obtain a proper weather briefing resulting in his encounter with fog, his having to make a precautionary landing in a field when the aircraft became low on fuel, and the on ground collision with trees during landing roll.
- [NTSB LAX00LA039](https://openairdocs.org/ntsb/LAX00LA039.md): Piper PA-28-181 · Hilo, HI · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 1999 · N4148X · Destroyed
  > An oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.
- [NTSB LAX00LA037](https://openairdocs.org/ntsb/LAX00LA037.md): Cessna 150K · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 19, 1999 · N6199G · Substantial damage
  > Fuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.
- [NTSB SEA00FA021](https://openairdocs.org/ntsb/SEA00FA021.md): Bell 206L-3 · Seattle, WA · Accident · Minor injuries · Field investigation · Final report · Nov 17, 1999 · N206AC · 2 aircraft · Substantial damage
  > Adequate separation and lookout not maintained by the pilots of both aircraft.
- [NTSB FTW00LA033](https://openairdocs.org/ntsb/FTW00LA033.md): Cessna TU206G · Lafayette, LA · Accident · No injuries · Limited investigation · Final report · Nov 17, 1999 · N4803U · Substantial damage
  > The partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…
- [NTSB CHI00LA031](https://openairdocs.org/ntsb/CHI00LA031.md): Cessna 182 · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Nov 16, 1999 · N5388B · Substantial damage
  > the inadequate preflight planning by the pilot and the exhaustion of usable fuel. A factor was the drainage ditch encountered on landing.
- [NTSB LAX00LA033](https://openairdocs.org/ntsb/LAX00LA033.md): Raven RX-7 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1999 · N4046M · Substantial damage
  > The pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.
- [NTSB DEN00LA018](https://openairdocs.org/ntsb/DEN00LA018.md): Cessna 172N · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Nov 12, 1999 · N5225D · Substantial damage
  > The pilot's inadequate preflight planning preparation which resulted in fuel exhaustion. Factors in the accident were the unsuitable terrain on which to make a forced landing and the pilot's lack of experience in aircraft type.
- [NTSB SEA00IA019](https://openairdocs.org/ntsb/SEA00IA019.md): Boeing 737-400 · Portland, OR · Incident · No injuries · Incident investigation · Final report · Nov 11, 1999 · N772AS · Minor damage
  > Arcing in the electrical system wiring for undetermined reasons.
- [NTSB CHI00LA028](https://openairdocs.org/ntsb/CHI00LA028.md): Shaffer Evans Volksplane · Stanley, ND · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1999 · N78VS · Substantial damage
  > refueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.
- [NTSB DEN00FA135](https://openairdocs.org/ntsb/DEN00FA135.md): Bellanca 17-30 · Lake City, CO · Accident · 2 fatal · Field investigation · Final report · Nov 10, 1999 · N6691V · Destroyed
  > the pilot's inadequate flight planning and preparation, and his inadvertent flight into adverse weather during a cross-country flight over mountainous terrain. Contributing factors were, the cloudy obscuration weather condition, the high density altitude, and…
- [NTSB NYC00LA030](https://openairdocs.org/ntsb/NYC00LA030.md): Cessna 150 · New Hope, PA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1999 · N8323G · Substantial damage
  > The pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.
- [NTSB DEN00IA075](https://openairdocs.org/ntsb/DEN00IA075.md): Beech A60 · Boulder, CO · Incident · No injuries · Incident investigation · Final report · Nov 9, 1999 · N457DA · Minor damage
  > The fatigue failure of the #6 cylinder connecting rod cap.
- [NTSB LAX00FA041](https://openairdocs.org/ntsb/LAX00FA041.md): McDonnell Douglas DC-10-30F · Honolulu, HI · Accident · No injuries · Field investigation · Final report · Nov 8, 1999 · N602GC · Substantial damage
  > The pilot-in-command initiated an evasive manuver during a near midair collission. The airplane entered a prestall buffet, which resulted in buckling of the elevator skins.
- [NTSB LAX00TA030](https://openairdocs.org/ntsb/LAX00TA030.md): Bell OH-58A · La Puente, CA · Accident · Minor injuries · Final report · Nov 6, 1999 · N911RN · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB MIA00LA022](https://openairdocs.org/ntsb/MIA00LA022.md): Cessna 150M · Jacksonville, NC · Accident · No injuries · Limited investigation · Final report · Nov 5, 1999 · N714RA · Substantial damage
  > The flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB SEA00TA013](https://openairdocs.org/ntsb/SEA00TA013.md): Hiller UH-12E · Stites, ID · Accident · Serious injuries · Final report · Nov 2, 1999 · N5388V · Substantial damage
  > Inadequate inspection of the control rotor cuff by a company mechanic and subsequent fatigue fracture of the cuff, resulting in an inflight separation of the control rotor blade. Factors contributing to the accident were: inadequate quality control during…
- [NTSB NYC00FA023](https://openairdocs.org/ntsb/NYC00FA023.md): Cessna T303 · Binghampton, NY · Accident · Serious injuries · Field investigation · Final report · Nov 1, 1999 · N511AR · Substantial damage
  > The pilot's improper in-flight decision to descend below the decision height without the runway environment in sight, and his failure to execute a missed approach. A factor in the accident was the failed crankshaft.
- [NTSB FTW00LA028](https://openairdocs.org/ntsb/FTW00LA028.md): Cessna 210K · Ponca City, OK · Accident · No injuries · Limited investigation · Final report · Oct 30, 1999 · N1162M · Substantial damage
  > Inadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA00LA018](https://openairdocs.org/ntsb/MIA00LA018.md): Piper PA-22-150 · Newberry, SC · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 1999 · N2648P · Substantial damage
  > a fire in the cockpit caused by the exhaust muffler, which resulted in a forced landing in a field, and subsequent impact with a berm.
- [NTSB CHI00IA018](https://openairdocs.org/ntsb/CHI00IA018.md): Boeing 757-222 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Oct 29, 1999 · N575UA · No damage
  > the in-flight vibration of the airplane's elevator due to excessive freeplay in the elevator control system. Factors included the corrosion of the elevator PCA reaction link bearings and the elevator hinge bearings, excessive axial and radial wear of the…
- [NTSB ATL00LA006](https://openairdocs.org/ntsb/ATL00LA006.md): Cessna 152 · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Oct 29, 1999 · N757YQ · Substantial damage
  > The student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.
- [NTSB MIA00LA015](https://openairdocs.org/ntsb/MIA00LA015.md): Cessna 172G · Itta Bena, MS · Accident · No injuries · Limited investigation · Final report · Oct 28, 1999 · N1171F · Substantial damage
  > a loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.
- [NTSB ANC00LA009](https://openairdocs.org/ntsb/ANC00LA009.md): Piper PA-32-300 · Russian Mission, AK · Accident · No injuries · Limited investigation · Final report · Oct 28, 1999 · N31606 · Substantial damage
  > The pilot's continued flight into adverse weather, and an inadvertent stall. Factors in the accident were adverse weather consisting of icing conditions, and airframe icing.
- [NTSB NYC00LA021](https://openairdocs.org/ntsb/NYC00LA021.md): Eurocopter AS-350-BA · Westbury, NY · Accident · No injuries · Limited investigation · Final report · Oct 27, 1999 · N350SL · Substantial damage
  > the failure of the operator to ensure the pilot was adequately trained to conduct all inspections required by the flight manual, which resulted in the pilot's inadequate preflight and subsequent failure of the tail rotor pitch change rod. Factors were the…
- [NTSB ANC00LA008](https://openairdocs.org/ntsb/ANC00LA008.md): Cessna 207 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Oct 27, 1999 · N207SE · Substantial damage
  > The pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…
- [NTSB DCA00MA005](https://openairdocs.org/ntsb/DCA00MA005.md): Learjet 35 · Aberdeen, SD · Accident · 6 fatal · Class 1 · Major · Final report · Oct 25, 1999 · N47BA · Destroyed
  > Incapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.
- [NTSB FTW00LA017](https://openairdocs.org/ntsb/FTW00LA017.md): Wright Avid Flyer Mark IV · Seabrook, TX · Accident · No injuries · Limited investigation · Final report · Oct 23, 1999 · N583AF · Substantial damage
  > The pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.
- [NTSB DEN00FA009](https://openairdocs.org/ntsb/DEN00FA009.md): Cessna 172R · Aspen, CO · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1999 · N9548A · Substantial damage
  > the pilot's improper decision to fly directly up the center of the valley and not circle climb to gain sufficient terrain clearance altitude. A factor was inadequate route performance planning by the pilot.
- [NTSB ATL00LA002](https://openairdocs.org/ntsb/ATL00LA002.md): Piper PA-28-161 · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Oct 23, 1999 · N616FT · Substantial damage
  > The carburetor icing conditions that were present. Factors were the failure of the pilot to follow the emergency procedures checklist, and the objects that included a flag pole, a road sign and a tractor trailer vehicle.
- [NTSB CHI00LA014](https://openairdocs.org/ntsb/CHI00LA014.md): Howlett KR-2 · Denison, IA · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 1999 · N7057V · Destroyed
  > the pilot not maintaining altitude/clearance from rising terrain and the intentional low altitude flight. Factors were the known turbulence, rising terrain, and the inadequate in-flight decision to fly at low altitudes.
- [NTSB LAX00LA021](https://openairdocs.org/ntsb/LAX00LA021.md): Cessna 172N · Deer Valley, AZ · Accident · No injuries · Limited investigation · Final report · Oct 21, 1999 · N738FY · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.
- [NTSB LAX00LA020](https://openairdocs.org/ntsb/LAX00LA020.md): Cessna 150H · El Monte, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1999 · N22795 · Substantial damage
  > A cracked No. 2 engine cylinder, which led to a loss of power. A factor was the ditch in the forced landing area.
- [NTSB LAX00LA019](https://openairdocs.org/ntsb/LAX00LA019.md): Cessna TR182 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1999 · N756LE · Substantial damage
  > Inadequate maintenance inspection mandated by the FAA, and the inadequate design of the exhaust heater core/muffler and deflectors that failed to divert hot exhaust gasses away from the battery and cabin heat valve.
- [NTSB DEN00FA007](https://openairdocs.org/ntsb/DEN00FA007.md): Gardner Varieze · Quemado, NM · Accident · 1 fatal · Field investigation · Final report · Oct 18, 1999 · N13WM · Substantial damage
  > The pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…
- [NTSB MIA00LA009](https://openairdocs.org/ntsb/MIA00LA009.md): Cessna A185E · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1999 · N85PR · Substantial damage
  > The partial loss of engine power due to the inadequate annual inspection of the airplane by the mechanic with IA for his failure to assure that the mixture control cable jam nut at the rod end was secured following the reported adjustment by the airplane…
- [NTSB MIA00LA006](https://openairdocs.org/ntsb/MIA00LA006.md): Cessna 152 · Bayou La Batre, AL · Accident · No injuries · Limited investigation · Final report · Oct 17, 1999 · N6504L · Substantial damage
  > The pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB LAX00LA010](https://openairdocs.org/ntsb/LAX00LA010.md): Mintz Vari EZE · Jean, NV · Accident · No injuries · Limited investigation · Final report · Oct 17, 1999 · N86KM · Substantial damage
  > The failure of the engine cylinder head due to detonation and subsequent over temperature for undetermined reasons.
- [NTSB ANC00LA006](https://openairdocs.org/ntsb/ANC00LA006.md): Piper PA-31-T3 · Gambell, AK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1999 · N220CS · Substantial damage
  > An in-flight collision with a bird.
- [NTSB LAX00FA014](https://openairdocs.org/ntsb/LAX00FA014.md): Piper PA-31-350 · North Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1999 · N1024B · Destroyed
  > The failure of the pilot-in-command to maintain separation from terrain while operating under visual flight rules. Contributing factors were the improper issuance of a suggested heading by air traffic control personnel, inadequate flight progress monitoring…
- [NTSB LAX00LA009](https://openairdocs.org/ntsb/LAX00LA009.md): Schweizer SGS-2-33A · Waialua, HI · Accident · No injuries · Limited investigation · Final report · Oct 14, 1999 · N17914 · Substantial damage
  > The pilot's delay in recognizing the onset of a wind direction change resulting in the downward flow of wind on the leeward side of the mountain (strong sink rate).
- [NTSB DEN00FA005](https://openairdocs.org/ntsb/DEN00FA005.md): Watkins Christen Eagle · Brigham City, UT · Accident · 1 fatal · Field investigation · Final report · Oct 11, 1999 · N24JT · Destroyed
  > The pilot's inability to maintain aircraft control due to an unknown physical impairment.

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

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

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