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

## Cases, newest first

- [NTSB MIA89LA255](https://openairdocs.org/ntsb/MIA89LA255.md): Hughes 269B · Lexington, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1989 · N9318F · Substantial damage
  > Fatigue failure of the linear actuator lug. A related factor was: trees in the emergency landing area.
- [NTSB ANC89LA171](https://openairdocs.org/ntsb/ANC89LA171.md): Helio H-250 · Near Iliamna, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1989 · N5450E · Substantial damage
  > Inadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.
- [NTSB NYC89LA219](https://openairdocs.org/ntsb/NYC89LA219.md): Piper PA-22 · Montague, NJ · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1989 · N2467A · Substantial damage
  > Improper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions and soft terrain in the emergency landing area.
- [NTSB ANC89LA170](https://openairdocs.org/ntsb/ANC89LA170.md): Cessna 185 · Mulchatna River, AK · Accident · No injuries · Limited investigation · Final report · Sep 20, 1989 · N4443R · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: loss of fuel that had siphoned (leaked) from the aircraft before takeoff and tree(s) overhanging the fast…
- [NTSB LAX89FA319](https://openairdocs.org/ntsb/LAX89FA319.md): Cessna 310K · Ojai, CA · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1989 · N6958L · Destroyed
  > The pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…
- [NTSB FTW89LA169](https://openairdocs.org/ntsb/FTW89LA169.md): Cessna 150 · Powell, TX · Accident · No injuries · Limited investigation · Final report · Sep 19, 1989 · N8256F · Substantial damage
  > The pilot's improper use of carburetor heat resulting in a partial, non-mechanical power loss from carburetor icing conditions.
- [NTSB CHI89LA191](https://openairdocs.org/ntsb/CHI89LA191.md): Bell 206B-3 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Sep 19, 1989 · N9229X · Substantial damage
  > A hard landing caused by the pilot not being able to judge his altitude above or his closure rate to terrain because of high vegetation in the area available for a forced landing. An engine faulure caused by material failure of the compressor section is a…
- [NTSB FTW89GA170](https://openairdocs.org/ntsb/FTW89GA170.md): Beech A35 · Escondido, CA · Accident · 2 fatal · Final report · Sep 18, 1989 · N566B · Destroyed
  > Spatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…
- [NTSB DEN89LA221](https://openairdocs.org/ntsb/DEN89LA221.md): Mooney M20C · Neihart, MT · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1989 · N3456X · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.
- [NTSB DEN89FA222](https://openairdocs.org/ntsb/DEN89FA222.md): Cessna 172N · Afton, WY · Accident · 2 fatal · Field investigation · Final report · Sep 18, 1989 · N739XX · Destroyed
  > The non-instrument rated pilot's continued flight into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude to clear the terrain. Factors related to the accident were: darkness, adverse weather conditions, and…
- [NTSB CHI89DEC08](https://openairdocs.org/ntsb/CHI89DEC08.md): Wesley Striplin Ranger · Smith Creek, MI · Accident · 1 fatal · Final report · Sep 18, 1989 · N46WW · Destroyed
  > The improper installation of the wingtip fuel tank which resulted in its inflight separation and the subsequent loss of control.
- [NTSB FTW89LA167](https://openairdocs.org/ntsb/FTW89LA167.md): Mooney M20E · Brenham, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1989 · N9462V · Substantial damage
  > Improper maintenance, improperly secured oil line to the propeller governor, failure of the propeller governor oil line, and subsequent loss of oil, which resulted in oil exhaustion. Factors related to the accident were: failure of maintenance personnel to…
- [NTSB FTW89LA165](https://openairdocs.org/ntsb/FTW89LA165.md): Cessna 172N · Waxahachie, TX · Accident · No injuries · Limited investigation · Final report · Sep 17, 1989 · N738BB · Substantial damage
  > Failure of the #3 exhaust valve due to exposure to overtemperature operating conditions.
- [NTSB DEN89FA218](https://openairdocs.org/ntsb/DEN89FA218.md): Cessna 310I · Hesperia, CA · Accident · 2 fatal · Field investigation · Final report · Sep 17, 1989 · N8087M · Destroyed
  > The non-instrument rated pilot continued VFR flight into instrument meteorological conditions (IMC) and misjudged his altitude above the terrain. Contributing factors were: the pilot's lack of instrument experience, pressure induced by his wife (the…
- [NTSB BFO89LA080](https://openairdocs.org/ntsb/BFO89LA080.md): Piper PA-28-180 · Haymarket, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1989 · N40892 · Destroyed
  > Improper use of the fuel selector, which resulted in fuel starvation & loss of engine power; and improper use of emergency procedures after loss of engine power. The presence of high obstructions (trees) in the approach path to the emergency landing area was…
- [NTSB ATL89FA214](https://openairdocs.org/ntsb/ATL89FA214.md): Piper PA-28R-180 · Gordon, AL · Accident · 3 fatal · Field investigation · Final report · Sep 17, 1989 · N7503J · Substantial damage
  > The improper installation of the fuel gascolator bowl by maintenance personnel, which resulted in fuel leakage and a loss of fuel pressure to the engine.
- [NTSB MIA89LA251](https://openairdocs.org/ntsb/MIA89LA251.md): Cessna 152 · Yulee, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1989 · N67785 · Substantial damage
  > Improper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.
- [NTSB LAX89FA304](https://openairdocs.org/ntsb/LAX89FA304.md): Rockwell 112B · La Grange, CA · Accident · 2 fatal · Field investigation · Final report · Sep 16, 1989 · N1232J · Destroyed
  > Continued VFR flight into instrument meteorlogical conditions (IMC) by the pilot, which resulted in spatial disorientation and loss of aircraft control. Related factors were: flight into known adverse weather by the pilot, the adverse weather conditions, and…
- [NTSB MKC89LA183](https://openairdocs.org/ntsb/MKC89LA183.md): Cessna 172 · Barnesville, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1989 · N3610L · Substantial damage
  > The pilot's failure to insure that the aircraft contained an adequate fuel supply to complete the flight.
- [NTSB CHI89FA183](https://openairdocs.org/ntsb/CHI89FA183.md): McDonnell Douglas MD-80 · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Sep 12, 1989 · N244AA · Substantial damage
  > A loss of hydraulic system pressure due to the operator's failure to replace a system component that had a known history of failures, and the pilot's improper use powerplant controls resulting in a degradation of rudder effectiveness. A contributing factor…
- [NTSB SEA89LA171](https://openairdocs.org/ntsb/SEA89LA171.md): Yakovlev YAK 11 · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1989 · N134JK · Substantial damage
  > The right main landing gear did not fully extend for an undetermined reason. Factors that contributed to the accident were: an engine power loss for unknown reasons and the rough terrain.
- [NTSB SEA89LA169](https://openairdocs.org/ntsb/SEA89LA169.md): Cessna 152 · Ellensburg, WA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1989 · N25228 · Substantial damage
  > The pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.
- [NTSB SEA89LA167](https://openairdocs.org/ntsb/SEA89LA167.md): Robinson R22 · Kent, WA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1989 · N8034J · Destroyed
  > The instructor pilot's failure to take timely corrective action to recover from a low rotor RPM condition, resulting in impact with the ground.
- [NTSB DEN89FA209](https://openairdocs.org/ntsb/DEN89FA209.md): Piper PA-32-260 · Lk Havasu City, CA · Accident · 2 fatal · Field investigation · Final report · Sep 7, 1989 · N3999W · Destroyed
  > Pilot's attention diverted outside the airplane. This diversion resulted in the pilot failing to monitor his altitude while in a descending turn and inadvertently flying the airplane into the water.
- [NTSB MKC89LA192](https://openairdocs.org/ntsb/MKC89LA192.md): Pietenpol AIR Camper B4A · Horatio, AR · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1989 · N10GF · Substantial damage
  > Improper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.
- [NTSB LAX89LA297](https://openairdocs.org/ntsb/LAX89LA297.md): Bell 206B · Murrieta, CA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1989 · N111JG · Substantial damage
  > A partial loss of engine power due to contaminates in the fuel control unit. The origin of the contaminates was not determined. Contributing factor(s) was: the helicopter was not equipped with floats.
- [NTSB SEA89LA164](https://openairdocs.org/ntsb/SEA89LA164.md): Cessna 182 · Lester, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1989 · N44888 · Destroyed
  > The pilot's loss of control of the aircraft due to his improper use of the aircraft flight controls. Contributing factors in the accident were the moderate turbulence and trace mixed icing in clouds.
- [NTSB MKC89LA193](https://openairdocs.org/ntsb/MKC89LA193.md): Piper PA-28-161 · Chanhassen, MN · Accident · No injuries · Limited investigation · Final report · Sep 5, 1989 · N8068C · Substantial damage
  > Engine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.
- [NTSB CHI89IA179](https://openairdocs.org/ntsb/CHI89IA179.md): Boeing 767-231 · Knox, IN · Incident · Minor injuries · Incident investigation · Final report · Sep 5, 1989 · N608TW · No damage
  > The radar controlller's failure to maintain radar separation. Factors contributing to the incident were: misunderstanding of an ATC instruction by the pilot of the incident airplane, and unclear phraseology used in the instructions issued by the radar…
- [NTSB DEN89LA206](https://openairdocs.org/ntsb/DEN89LA206.md): Cessna T210M · Rangely, CO · Accident · No injuries · Limited investigation · Final report · Sep 4, 1989 · N761RP · Substantial damage
  > Forced landing in unsuitable terrain as a result of an engine crankshaft failure.
- [NTSB MIA89LA242](https://openairdocs.org/ntsb/MIA89LA242.md): Piper PA-24-250 · Perry, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 1989 · N4CD · Substantial damage
  > Fuel starvation due to wear and restricted movement of the carburetor float, which resulted in loss of engine power. Soft terrain in the emergency landing area contributed to overload failure of the nose gear.
- [NTSB MIA89LA240](https://openairdocs.org/ntsb/MIA89LA240.md): Bell 47G-2 · Cayey, PR · Accident · No injuries · Limited investigation · Final report · Sep 3, 1989 · N37870 · Substantial damage
  > Loss of engine power for an unknown reason. A factor related to the accident was: the presence of trees in the emergency landing area.
- [NTSB FTW89LA157](https://openairdocs.org/ntsb/FTW89LA157.md): Cessna 150J · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 1989 · N60062 · Substantial damage
  > Pilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.
- [NTSB NYC89LA207](https://openairdocs.org/ntsb/NYC89LA207.md): Piper PA-28-180 · Sanbornton, NH · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1989 · N9334J · Substantial damage
  > VFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.
- [NTSB NYC89FA206](https://openairdocs.org/ntsb/NYC89FA206.md): Cessna 172P · Northfield, NH · Accident · 4 fatal · Field investigation · Final report · Sep 2, 1989 · N65595 · Destroyed
  > The pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.
- [NTSB MIA89LA238](https://openairdocs.org/ntsb/MIA89LA238.md): Cessna 177 · Woodville, MS · Accident · No injuries · Limited investigation · Final report · Sep 2, 1989 · N2921X · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.
- [NTSB LAX89DUQ05](https://openairdocs.org/ntsb/LAX89DUQ05.md): Ruppercht Varieze · California City, CA · Accident · 2 fatal · Final report · Sep 2, 1989 · N393D · Destroyed
  > The wing failed due to the pilot/owners overtorquing the wing bolts and the improper installation of the wing attach plates/cones.
- [NTSB ATL89LA208](https://openairdocs.org/ntsb/ATL89LA208.md): Cessna 175 · Spruce Pine, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 1989 · N7174M · Substantial damage
  > A loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).
- [NTSB ATL89LA206](https://openairdocs.org/ntsb/ATL89LA206.md): Piper PA-24-250 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Sep 2, 1989 · N5210P · Substantial damage
  > Pilot's failure to adequately monitor the engine fuel consumption in flight.
- [NTSB ANC89FA155](https://openairdocs.org/ntsb/ANC89FA155.md): Cessna 180 · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Sep 2, 1989 · N2137Z · Substantial damage
  > Oil leak in the oil cooler. Contributing factors were: oil film on the windshield, which obscured the pilot's vision (visual perception) and hampered his ability to attain proper runway alignment, an object (rock), and high vegetation beside the airstrip.
- [NTSB NYC89LA209](https://openairdocs.org/ntsb/NYC89LA209.md): Cessna 210 · No. Windham, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1989 · N2054S · Destroyed
  > The pilot's failure to assure an adequate supply of fuel was available.
- [NTSB LAX89LA298](https://openairdocs.org/ntsb/LAX89LA298.md): Stinson 108 · Cool, CA · Accident · No injuries · Limited investigation · Final report · Sep 1, 1989 · N97628 · Substantial damage
  > Failure of the #2 piston. Failure of the mechanic to properly overhaul the engine was a related factor.
- [NTSB NYC89LA205](https://openairdocs.org/ntsb/NYC89LA205.md): Cessna 210N · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Aug 31, 1989 · N873PJ · Destroyed
  > The pilot-in-command's failure to properly ensure a sufficient quantity of fuel for the intended flight.
- [NTSB LAX89LA292](https://openairdocs.org/ntsb/LAX89LA292.md): Cessna 172 · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Aug 31, 1989 · N6270E · Substantial damage
  > Failure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…
- [NTSB SEA89FA160](https://openairdocs.org/ntsb/SEA89FA160.md): Cessna 152 · Snohomish, WA · Accident · 4 fatal · Field investigation · Final report · Aug 30, 1989 · N49231 · 2 aircraft · Destroyed
  > The pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.
- [NTSB MKC89FA191](https://openairdocs.org/ntsb/MKC89FA191.md): Piper PA-20 · Moose Lake, MN · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1989 · N2841P · Destroyed
  > Severe corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…
- [NTSB FTW89GA156](https://openairdocs.org/ntsb/FTW89GA156.md): Piper PA-18-150 · Grand Chenier, LA · Accident · Minor injuries · Final report · Aug 30, 1989 · N4423Z · Substantial damage
  > On August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…
- [NTSB NYC89FA204](https://openairdocs.org/ntsb/NYC89FA204.md): Cessna U206F · West Point, NY · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1989 · N8559Q · Destroyed
  > Continued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…
- [NTSB FTW89FA155](https://openairdocs.org/ntsb/FTW89FA155.md): Piper PA-28R-180 · Pauls Valley, OK · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1989 · N7593J · Destroyed
  > Improper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…
- [NTSB DEN89FA202](https://openairdocs.org/ntsb/DEN89FA202.md): Aerospatiale AS-350D · Blanchard, ID · Accident · 4 fatal · Field investigation · Final report · Aug 28, 1989 · N132SH · Destroyed
  > Overheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.

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

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

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