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

## Cases, newest first

- [NTSB NYC92LA109](https://openairdocs.org/ntsb/NYC92LA109.md): Cessna 150L · Gettysburg, PA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1992 · N1793Q · Substantial damage
  > The student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…
- [NTSB FTW92FA169](https://openairdocs.org/ntsb/FTW92FA169.md): Rockwell 690B · Konawa, OK · Accident · 1 fatal · Field investigation · Final report · Jun 25, 1992 · N690JC · Destroyed
  > The pilot's failure to maintain control of the airplane which resulted in an inadvertent spiral and subsequent rapid descent. The design stress limits of the airframe were exceeded resulting in an overload failure of the empennage. Factors related to the…
- [NTSB DEN92FA064](https://openairdocs.org/ntsb/DEN92FA064.md): Mitsubishi MU-2B-30 · Alamagordo, NM · Accident · 6 fatal · Field investigation · Final report · Jun 25, 1992 · N108SC · Destroyed
  > The failure of the pilot to exercise adequate VFR departure terrain avoidance procedures, and the failure of the controller to issue a safety alert to the pilot. Factors which contributed to the accident were: the pilot's lack of familiarity with the…
- [NTSB CHI92FA188](https://openairdocs.org/ntsb/CHI92FA188.md): Beech 24R · Oak Creek, WI · Accident · Minor injuries · Field investigation · Final report · Jun 25, 1992 · N2195W · Destroyed
  > A result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.
- [NTSB LAX92LA258](https://openairdocs.org/ntsb/LAX92LA258.md): Cessna T210N · Georgetown, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1992 · N9933N · Substantial damage
  > The under torque of the crankcase through bolts during overhaul causing; 1) the number 2 main bearing to spin, 2) the resultant blockage of the internal oil passage, and 3) the oil starvation induced failure of the number 2 connecting rod and cap. A factor in…
- [NTSB LAX92FA260](https://openairdocs.org/ntsb/LAX92FA260.md): Cessna 421B · Monterey, CA · Accident · 3 fatal · Field investigation · Final report · Jun 24, 1992 · N628RJ · Destroyed
  > The owner/pilot's poor judgement in attempting an operation beyond his experience and ability, which resulted in his failure to attain an adequate climb profile necessary for terrain clearance. Also, the owner/pilot lacked instrument experience, and was…
- [NTSB LAX92FA257](https://openairdocs.org/ntsb/LAX92FA257.md): Waco UPF-7 · Sedona, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 23, 1992 · N29926 · Destroyed
  > Fuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…
- [NTSB SEA92IA136](https://openairdocs.org/ntsb/SEA92IA136.md): Fokker F.28 MK 1000 · Portland, OR · Incident · No injuries · Incident investigation · Final report · Jun 22, 1992 · CGTAH · No damage
  > The partial failure of the horizontal stabilizer trim drive system, the restricted movement of the stabilizer, and the overtorque of a system component.
- [NTSB NYC92LA124](https://openairdocs.org/ntsb/NYC92LA124.md): Cessna 421B · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Jun 22, 1992 · N39PW · Substantial damage
  > The electrical fire which started in a component that was part of a door seal modification. Also causal to the accident was the installation of this unapproved airplane modification.
- [NTSB CHI92LA185](https://openairdocs.org/ntsb/CHI92LA185.md): Cessna 150H · Three Rivers, MI · Accident · No injuries · Limited investigation · Final report · Jun 21, 1992 · N22120 · Substantial damage
  > The pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.
- [NTSB DEN92LA062](https://openairdocs.org/ntsb/DEN92LA062.md): Air Tractor AT-301 · Rocky Ford, CO · Accident · 1 fatal · Limited investigation · Final report · Jun 20, 1992 · N3649D · Destroyed
  > The pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.
- [NTSB NYC92DGM02](https://openairdocs.org/ntsb/NYC92DGM02.md): Peres 5151 · Erie, PA · Accident · No injuries · Final report · Jun 19, 1992 · N5151M · Substantial damage
  > Seizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.
- [NTSB FTW92LA164](https://openairdocs.org/ntsb/FTW92LA164.md): Cessna 320D · Aztec, NM · Accident · No injuries · Limited investigation · Final report · Jun 18, 1992 · N3307Q · Substantial damage
  > Failure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.
- [NTSB MIA92LA139](https://openairdocs.org/ntsb/MIA92LA139.md): Extra Flugzeugbau 300 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Jun 17, 1992 · N300XL · Substantial damage
  > Separation of the propeller governor cover from the body for undetermined reasons and visual restriction of the pilot due to leaking oil which covered the windscreen.
- [NTSB NYC92LA119](https://openairdocs.org/ntsb/NYC92LA119.md): Piper PA-24-180 · Felton, PA · Accident · No injuries · Limited investigation · Final report · Jun 16, 1992 · N21RE · Substantial damage
  > A precautionary landing in unsuitable terrain. An additional cause was the failure of the mechanic to tighten the oil return line on the number three cylinder. A factor related to the accident was the pressure the mechanic felt to complete the job in a timely…
- [NTSB NYC92FA117](https://openairdocs.org/ntsb/NYC92FA117.md): Bell 47-G4A · Shelburne Falls, MA · Accident · 3 fatal · Field investigation · Final report · Jun 16, 1992 · N1041B · Destroyed
  > The pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.
- [NTSB LAX92LA251](https://openairdocs.org/ntsb/LAX92LA251.md): Cessna 182E · Big Bear Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1992 · N7133E · Substantial damage
  > The lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.
- [NTSB ATL92FA126](https://openairdocs.org/ntsb/ATL92FA126.md): Aerospatiale AS-355-F · Fort Bragg, NC · Accident · No injuries · Field investigation · Final report · Jun 15, 1992 · N365DU · Substantial damage
  > The total blockage of the oil supply line for the rear main bearing in engine module three which resulted in the failure of the bearing, and the subsequent leak from the engine start drain valve.
- [NTSB SEA92LA126](https://openairdocs.org/ntsb/SEA92LA126.md): Beech K35 · Sula, MT · Accident · No injuries · Limited investigation · Final report · Jun 14, 1992 · N212M · Substantial damage
  > Poor inflight planning/decision. Factors to the accident were: delayed remedial action, a white out weather condition and inadequate clearance.
- [NTSB FTW92LA155](https://openairdocs.org/ntsb/FTW92LA155.md): Sikorsky S-76A · Morgan City, LA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1992 · N2620 · Substantial damage
  > The second pilot's failure to maintain aircraft control.
- [NTSB DEN92LA059](https://openairdocs.org/ntsb/DEN92LA059.md): Cessna 177RG · Gunnison, CO · Accident · No injuries · Limited investigation · Final report · Jun 14, 1992 · N52658 · Substantial damage
  > The pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.
- [NTSB MIA92LA137](https://openairdocs.org/ntsb/MIA92LA137.md): Cessna 402B · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1992 · N402PB · Substantial damage
  > For undetermined reason(s), the right engine failed and the right propeller would not feather.
- [NTSB LAX92LA243](https://openairdocs.org/ntsb/LAX92LA243.md): Cessna 150 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jun 12, 1992 · N6972G · Substantial damage
  > The pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.
- [NTSB LAX92FA242](https://openairdocs.org/ntsb/LAX92FA242.md): Cessna 172I · Chino Hills, CA · Accident · 3 fatal · Field investigation · Final report · Jun 11, 1992 · N225EB · Destroyed
  > The pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.
- [NTSB NYC92LA107](https://openairdocs.org/ntsb/NYC92LA107.md): Piper PA-32R-300 · Denton, MD · Accident · No injuries · Limited investigation · Final report · Jun 10, 1992 · N4552X · Substantial damage
  > The failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.
- [NTSB MIA92LA135](https://openairdocs.org/ntsb/MIA92LA135.md): Hiller UH12C · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1992 · N46937 · Substantial damage
  > The pilot in command's failure to monitor fuel consumption and flight time resulting in exhaustion of fuel and engine failure. Contributing to the accident was the pilot in command's improper autorotation following engine failure which resulted in a hard…
- [NTSB MIA92LA133](https://openairdocs.org/ntsb/MIA92LA133.md): Cessna T210L · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1992 · N5123Q · Substantial damage
  > The pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.
- [NTSB LAX92FA241](https://openairdocs.org/ntsb/LAX92FA241.md): Cessna 172P · Big Sur, CA · Accident · 3 fatal · Field investigation · Final report · Jun 9, 1992 · N5449K · Destroyed
  > Pilot incapacition.
- [NTSB CHI92LA167](https://openairdocs.org/ntsb/CHI92LA167.md): Piper PA-34-200 · Wyatt, MO · Accident · No injuries · Limited investigation · Final report · Jun 9, 1992 · N1050X · Substantial damage
  > An improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.
- [NTSB SEA92LA121](https://openairdocs.org/ntsb/SEA92LA121.md): Mooney M20E · Freeland, WA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1992 · N5887Q · Substantial damage
  > Blockage of the fuel injector servo system. Factors contributing to the accident were: fuel injection system corroded and animals in the landing area.
- [NTSB NYC92LA101](https://openairdocs.org/ntsb/NYC92LA101.md): Piper PA-28-140 · Danville, NY · Accident · No injuries · Limited investigation · Final report · Jun 7, 1992 · N98276 · Substantial damage
  > The decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.
- [NTSB FTW92FA152](https://openairdocs.org/ntsb/FTW92FA152.md): Siai-Marchetti SF260B · Decatur, TX · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1992 · N22FD · Destroyed
  > The loss of engine power as the result of the failure of the engine oil pump. Factors were non compliance with a service bulletin, the lack of suitable terrain, and inadvertent stall.
- [NTSB ATL92GA121](https://openairdocs.org/ntsb/ATL92GA121.md): Enstrom 280FX · Summerville, SC · Accident · 2 fatal · Final report · Jun 7, 1992 · N86262 · Destroyed
  > The pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.
- [NTSB MIA92LA130](https://openairdocs.org/ntsb/MIA92LA130.md): Cessna 310-R · Summerfield, FL · Accident · No injuries · Limited investigation · Final report · Jun 6, 1992 · N69HS · Substantial damage
  > The failure of the pilot-in-command to switch the fuel selectors in flight which caused both engines to fail due to fuel starvation. Contributing to the accident was the complacency of the pilot-in-command.
- [NTSB CHI92LA163](https://openairdocs.org/ntsb/CHI92LA163.md): Cessna 120 · Elk River, MN · Accident · No injuries · Limited investigation · Final report · Jun 6, 1992 · N76028 · Substantial damage
  > The pilot's improper preflight inspection.
- [NTSB NYC92LA100](https://openairdocs.org/ntsb/NYC92LA100.md): Enstrom F28A · Malvern, PA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1992 · N296Q · Substantial damage
  > The pilot abruptly moved the cyclic rearward which resulted in the main rotor blades striking and separating the tail boom. A factor in this accident was the soft muddy field.
- [NTSB FTW92LA147](https://openairdocs.org/ntsb/FTW92LA147.md): Cessna 182 · Coweta, OK · Accident · No injuries · Limited investigation · Final report · Jun 5, 1992 · N5381B · Substantial damage
  > The total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.
- [NTSB FTW92LA146](https://openairdocs.org/ntsb/FTW92LA146.md): Cessna 152 · Henrietta, TX · Accident · No injuries · Limited investigation · Final report · Jun 4, 1992 · N68735 · Substantial damage
  > Loss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.
- [NTSB LAX92LA232](https://openairdocs.org/ntsb/LAX92LA232.md): Wayne K. Giles Glasair Garg · Valencia, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 3, 1992 · N555HV · Substantial damage
  > The loss of engine power because of an undetermined interruption in the flow of fuel to the engine. Factors which contributed to the power loss were related to fuel line or fitting leaks and to inadequate maintenance of the fuel system.
- [NTSB ATL92IA113](https://openairdocs.org/ntsb/ATL92IA113.md): Lockheed L-1011-1 · Atlanta, GA · Incident · Minor injuries · Incident investigation · Final report · Jun 2, 1992 · N718DA · No damage
  > The overheating of the number 2 air cycle machine which resulted in an emergency evacuation via slides; the failure of the flight attendants to secure the slide girt bars.
- [NTSB CHI92LA160](https://openairdocs.org/ntsb/CHI92LA160.md): Piper PA-32R-300 · Round Lake, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1992 · N812PC · Destroyed
  > The pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.
- [NTSB ATL92FA111](https://openairdocs.org/ntsb/ATL92FA111.md): Cessna 152 · Lake Waccamaw, NC · Accident · 1 fatal · Field investigation · Final report · Jun 1, 1992 · N757VN · Substantial damage
  > The failure of the pilot to follow proper procedures while operating the aircraft in weather conditions favorable to carburetor icing. A factor in the accident was the weather condition, which was favorable for the formation of carburetor ice.
- [NTSB LAX92LA228](https://openairdocs.org/ntsb/LAX92LA228.md): Cessna 172RG · Strawberry, AZ · Accident · 1 fatal · Limited investigation · Final report · May 31, 1992 · N9645B · Destroyed
  > The pilot committed suicide due to the pilot's emotional state from interpersonal relations.
- [NTSB LAX92LA225](https://openairdocs.org/ntsb/LAX92LA225.md): Schempp-Hirth Ventus A/16.6 · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · May 31, 1992 · N8KS · Destroyed
  > The inflight disconnection of the right aileron 'otellier coupler fitting due to lubricants on the coupler slide lock plate, and the failure of the glider manufacturer to include appropriate precautionary information in the maintenance and/or flight manual.…
- [NTSB FTW94LA288](https://openairdocs.org/ntsb/FTW94LA288.md): Beech 35-C33 · Lake City, CO · Accident · 1 fatal · Limited investigation · Final report · May 31, 1992 · N2742T · Destroyed
  > Flight by the pilot into adverse weather conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument experience.
- [NTSB LAX92LA224](https://openairdocs.org/ntsb/LAX92LA224.md): Hughes 369D · Volcanoes Ntl P, HI · Accident · No injuries · Limited investigation · Final report · May 30, 1992 · N1100A · Substantial damage
  > The total loss of engine power due to a failure of the number 8 bearing. The bearing failure was caused by a lack of engine oil supply and inadequate maintenance.
- [NTSB SEA92LA110](https://openairdocs.org/ntsb/SEA92LA110.md): Piper PA-28-140 · Monarch, MT · Accident · Minor injuries · Limited investigation · Final report · May 29, 1992 · N6434R · Destroyed
  > The pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…
- [NTSB ATL92FA109](https://openairdocs.org/ntsb/ATL92FA109.md): Aerospatiale AS350B · Winnsboro, SC · Accident · Serious injuries · Field investigation · Final report · May 29, 1992 · N5806K · Destroyed
  > The inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.
- [NTSB MIA92LA129](https://openairdocs.org/ntsb/MIA92LA129.md): Piper PA-28-140 · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · May 28, 1992 · N5830U · Substantial damage
  > Total loss of engine power due to improper placement of the fuel selector by the pilot-in-command following partial loss of engine power due to partial blockage of a fuel line. Contributing to the accident was the dark night condition and improper maintenance…
- [NTSB ATL92LA112](https://openairdocs.org/ntsb/ATL92LA112.md): Cessna 210F · Manteo, NC · Accident · No injuries · Limited investigation · Final report · May 26, 1992 · N5811F · Substantial damage
  > The pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.

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

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

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