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

## Cases, newest first

- [NTSB WPR14FA316](https://openairdocs.org/ntsb/WPR14FA316.md): Meyer Legacy · Lolo Pass, ID · Accident · 1 fatal · Field investigation · Final report · Jul 28, 2014 · N29MM · Substantial damage
  > The fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.
- [NTSB WPR14LA315](https://openairdocs.org/ntsb/WPR14LA315.md): Ercoupe 415 C · Susanville, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2014 · N2013H · Substantial damage
  > The pilot’s failure to follow the checklist while starting the engine and to lock the engine primer plunger, which resulted in the partial loss of engine power during cruise flight in high density altitude conditions.
- [NTSB ERA14LA362](https://openairdocs.org/ntsb/ERA14LA362.md): Piper PA28 · Venice, FL · Accident · 2 fatal · Limited investigation · Final report · Jul 27, 2014 · N8826C · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s…
- [NTSB WPR14LA312](https://openairdocs.org/ntsb/WPR14LA312.md): Roscher Frederick Thunder Mustang · Spanish Springs, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2014 · N695HR · Destroyed
  > A complete loss of engine power during climb for reasons that could not be determined due to the severity of postcrash fire damage to the airplane.
- [NTSB ERA14LA368](https://openairdocs.org/ntsb/ERA14LA368.md): Gulfstream-Schweizer A/C G-164B · Bonifay, FL · Accident · No injuries · Limited investigation · Final report · Jul 25, 2014 · N425LS · Substantial damage
  > A partial blockage of the No. 2 bearing oil nozzle jet by bearing material, which resulted in oil starvation and the subsequent failure of the No. 2 bearing and total loss of engine power.
- [NTSB DCA14RA129](https://openairdocs.org/ntsb/DCA14RA129.md): Mcdonnell Douglas MD80 - 80 · Gossi, Mali · Accident · No injuries · Foreign investigation · Jul 24, 2014 · EC-LTV · Destroyed
  > The Mali Commission d'Enquete Accident et Incident d'Aviation Civile (CEAIAC) has notified the NTSB of an accident involving a McDonald Douglas DC-9-83 that occurred on July 24, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB CEN14LA417](https://openairdocs.org/ntsb/CEN14LA417.md): Stinson 108 1 · Bruno, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 2014 · N9034K · Substantial damage
  > The total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.
- [NTSB CEN14LA376](https://openairdocs.org/ntsb/CEN14LA376.md): Air Tractor AT 401B · Ellis, KS · Accident · 1 fatal · Limited investigation · Final report · Jul 18, 2014 · N4223F · Substantial damage
  > The noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…
- [NTSB CEN14LA375](https://openairdocs.org/ntsb/CEN14LA375.md): Grumman Acft ENG Cor-Schweizer G 164A · Fairview, KS · Accident · No injuries · Limited investigation · Final report · Jul 18, 2014 · N6743Q · Substantial damage
  > The backfire of the engine and its loss of power for reasons that could not be determined based on the available evidence.
- [NTSB WPR14IA297](https://openairdocs.org/ntsb/WPR14IA297.md): Beech B100 · Bakersfield, CA · Incident · No injuries · Incident investigation · Final report · Jul 17, 2014 · N6756P · Minor damage
  > The failure of the 2nd-stage turbine wheel due to an improper repair of the 2nd-stage stator assembly, which the manufacturer does not consider a repairable item. Contributing to the incident was the designated engineering representative's approval of the…
- [NTSB DCA14RA127](https://openairdocs.org/ntsb/DCA14RA127.md): Boeing 777 - 206 · Hrabove, Ukraine · Accident · 298 fatal · Foreign investigation · Jul 17, 2014 · 9M-MRD · Destroyed
  > import
- [NTSB CEN14LA373](https://openairdocs.org/ntsb/CEN14LA373.md): Garramone Mike A Vixen · Columbus, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2014 · N153PR · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.
- [NTSB CEN14FA369](https://openairdocs.org/ntsb/CEN14FA369.md): Agusta A109E · Newkirk, NM · Accident · 3 fatal · Field investigation · Final report · Jul 17, 2014 · N507CF · Destroyed
  > The pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.
- [NTSB CEN14WA394](https://openairdocs.org/ntsb/CEN14WA394.md): MD Helicopter 600N · Kungsangen, Sweden · Accident · No injuries · Foreign investigation · Jul 14, 2014 · SE-JKJ · Substantial damage
  > On July 14, 2014, at 1333 coordinated universal time, an MD Helicopters MD600N, SE-JKJ, was substantially damaged following an autorotation near Kungsängen, Stockholm, Sweden. The pilot was not injured. Visual meteorological conditions prevailed for the…
- [NTSB CEN14LA372](https://openairdocs.org/ntsb/CEN14LA372.md): Jonker Sailplanes JS1-C · Wallis, TX · Accident · 1 fatal · Limited investigation · Final report · Jul 13, 2014 · N60XJ · Substantial damage
  > The pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.
- [NTSB CEN14WA363](https://openairdocs.org/ntsb/CEN14WA363.md): Piper PA 28R-201T · Urtaca, France · Accident · 3 fatal · Foreign investigation · Jul 12, 2014 · N717ND · Destroyed
- [NTSB ERA14LA344](https://openairdocs.org/ntsb/ERA14LA344.md): Costruzioni Aeronautiche Tecna P2004 Bravo · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Jul 10, 2014 · N128LS · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined based on the available information.
- [NTSB ERA14LA336](https://openairdocs.org/ntsb/ERA14LA336.md): Beech C24R · Titusville, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2014 · N6222Q · Substantial damage
  > The pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA350](https://openairdocs.org/ntsb/CEN14LA350.md): Piper PA 28R-200 · Mt. Vernon, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2014 · N9469N · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC14LA052](https://openairdocs.org/ntsb/ANC14LA052.md): Aeronca 7BCM · Palmer, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2014 · N68593 · Substantial damage
  > The pilot’s failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.
- [NTSB WPR14FA283](https://openairdocs.org/ntsb/WPR14FA283.md): American Champion 7GCBC · Landmark, ID · Accident · 1 fatal · Field investigation · Final report · Jul 7, 2014 · N162CG · 2 aircraft · Substantial damage
  > The failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.
- [NTSB ERA14LA332](https://openairdocs.org/ntsb/ERA14LA332.md): Aeronca 7CCM · Prentiss, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 2014 · N82442 · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN14LA351](https://openairdocs.org/ntsb/CEN14LA351.md): Cessna 152 · Denton, TX · Accident · No injuries · Limited investigation · Final report · Jul 5, 2014 · N49785 · Substantial damage
  > The in-flight failure of the right wing’s rear spar.
- [NTSB CEN14FA328](https://openairdocs.org/ntsb/CEN14FA328.md): Piper PA 28-235 · Georgetown, CO · Accident · 3 fatal · Field investigation · Final report · Jun 30, 2014 · N8814W · Destroyed
  > The pilot’s inability to maintain a climb while maneuvering the airplane in high-density altitude conditions that degraded the airplane’s climb performance and his exceedance of the airplane’s critical angle-of-attack, which led to an aerodynamic stall and…
- [NTSB WPR14LA272](https://openairdocs.org/ntsb/WPR14LA272.md): Aerospatiale AS350B2 · Dietrich, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N350CR · Substantial damage
  > The pilot’s sudden incapacitation from a previously undiagnosed medical condition while in cruise flight, which resulted in his inability to maintain helicopter control.
- [NTSB ERA14RA318](https://openairdocs.org/ntsb/ERA14RA318.md): Robinson R66 · Krasnodar Krai, Russia · Accident · 4 fatal · Class 5 · Foreign · Jun 28, 2014 · RA-15880 · Substantial damage
  > On June 28, 2014, at 1518 Coordinated Universal Time (UTC), a Robinson R66, Russian registration RA-15880, impacted terrain, in Krasnodar Krai, Russia. The pilot and three passengers were fatally injured. The investigation is under the jurisdiction of the…
- [NTSB DCA14WA176](https://openairdocs.org/ntsb/DCA14WA176.md): Boeing Boeing 737-8AS · Tarragona, Spain · Accident · Serious injuries · Foreign investigation · Jun 23, 2014 · EI-ENB · No damage
  > The CIAIAC of Spain has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on June 23, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB CEN14LA312](https://openairdocs.org/ntsb/CEN14LA312.md): Airbus Helicopters AS-350B2 · Texarkana, TX · Accident · No injuries · Limited investigation · Final report · Jun 23, 2014 · N407EM · Substantial damage
  > The failure of the two fuel control unit drive bearings for reasons that could not be determined based on the available evidence, which resulted in an uncommanded engine acceleration and subsequent overspeed condition. Contributing to the accident was the…
- [NTSB WPR14CA400](https://openairdocs.org/ntsb/WPR14CA400.md): Mazurek Keith P Zodiac 601XL · Hurricane, UT · Accident · No injuries · Data collection · Final report · Jun 22, 2014 · N599KM · Substantial damage
  > Loss of engine power due to fuel exhaustion. Contributing to the accident was an incorrectly calibrated fuel totalizer.
- [NTSB WPR14CA276](https://openairdocs.org/ntsb/WPR14CA276.md): Christen Industries A 1 · Moses Lake, WA · Accident · No injuries · Data collection · Final report · Jun 22, 2014 · N2914Q · Substantial damage
  > The airplane impacted a bird during low level flight.
- [NTSB CEN14LA309](https://openairdocs.org/ntsb/CEN14LA309.md): Schumacher Challenger II · St. Joesph, IL · Accident · No injuries · Limited investigation · Final report · Jun 21, 2014 · N441MS · Substantial damage
  > The total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…
- [NTSB CEN14FA306](https://openairdocs.org/ntsb/CEN14FA306.md): Brumwell RV-6 · Sauk Rapids, MN · Accident · 2 fatal · Field investigation · Final report · Jun 21, 2014 · N135BB · Destroyed
  > The pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.
- [NTSB ERA14WA304](https://openairdocs.org/ntsb/ERA14WA304.md): Cessna U206E · Cerro Militar, Municipio de Calima, Colombia · Accident · 3 fatal · Foreign investigation · Jun 19, 2014 · N4258 · Substantial damage
- [NTSB WPR14FA252](https://openairdocs.org/ntsb/WPR14FA252.md): Cessna 175 · Moab, UT · Accident · 1 fatal · Field investigation · Final report · Jun 18, 2014 · N7043M · Destroyed
  > The pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.
- [NTSB CEN14FA300](https://openairdocs.org/ntsb/CEN14FA300.md): Piper PA 46-310P · Lehman, TX · Accident · 3 fatal · Field investigation · Final report · Jun 18, 2014 · N2428Q · Substantial damage
  > The pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…
- [NTSB WPR14LA251](https://openairdocs.org/ntsb/WPR14LA251.md): Airbus AS 350 BA FX1 · Wailuku, HI · Accident · No injuries · Limited investigation · Final report · Jun 17, 2014 · N6094H · Substantial damage
  > The failure of the engine’s pneumatic fuel control line fitting, resulting in a loss of engine power. Contributing to the failure was the repeated loosening and re-torqueing of the fitting during required maintenance and inspection.
- [NTSB DCA14CA124](https://openairdocs.org/ntsb/DCA14CA124.md): Boeing 767 424ER · Newark, NJ · Accident · Serious injuries · Data collection · Final report · Jun 17, 2014 · N77066 · No damage
  > A hot liquid splashed from a meal box onto the flight attendant's hand, resulting in a 2nd degree burn.
- [NTSB DCA14CA120](https://openairdocs.org/ntsb/DCA14CA120.md): Boeing 737 7H4 · Dallas, TX · Accident · Serious injuries · Data collection · Final report · Jun 17, 2014 · N968WN · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking handle was raised, which resulted in 2nd and 3rd degree burns.
- [NTSB CEN14LA293](https://openairdocs.org/ntsb/CEN14LA293.md): Knauf RV-7 · Rockwall, TX · Accident · No injuries · Limited investigation · Final report · Jun 16, 2014 · N707HK · Substantial damage
  > The pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.
- [NTSB ERA14CA310](https://openairdocs.org/ntsb/ERA14CA310.md): Jackson Fred M Clipper · Altamont, NY · Accident · No injuries · Data collection · Final report · Jun 14, 2014 · N2754A · Substantial damage
  > The pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.
- [NTSB CEN14WA294](https://openairdocs.org/ntsb/CEN14WA294.md): Piper J3C 65 · Rolleville, France · Accident · No injuries · Foreign investigation · Jun 11, 2014 · N61903 · Substantial damage
- [NTSB ERA14WA287](https://openairdocs.org/ntsb/ERA14WA287.md): Cessna 172N · Premana Lecco, Italy · Accident · 3 fatal · Foreign investigation · Jun 9, 2014 · I-SIPI · Destroyed
- [NTSB ANC14LA040](https://openairdocs.org/ntsb/ANC14LA040.md): Cessna U206C · Chitina, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 2014 · N29137 · Substantial damage
  > The failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue, which resulted in a total loss of engine power during cruise flight.
- [NTSB WPR14TA236](https://openairdocs.org/ntsb/WPR14TA236.md): Mcdonnell Douglas Helicopter 369E · Mesa, AZ · Accident · No injuries · Final report · Jun 8, 2014 · N504MP · Substantial damage
  > The loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…
- [NTSB WPR14LA237](https://openairdocs.org/ntsb/WPR14LA237.md): Craig W Sherman Super Glasair TT · Madera, CA · Accident · No injuries · Limited investigation · Final report · Jun 8, 2014 · N400MC · Substantial damage
  > The loosening of a B-nut in the fuel system which resulted in a rapid, undetected fuel leak and subsequent fuel exhaustion.
- [NTSB CEN14FA278](https://openairdocs.org/ntsb/CEN14FA278.md): Hermann Bjorn Lancair IV · Duluth, MN · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2014 · N86NW · Substantial damage
  > The pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…
- [NTSB ANC14LA038](https://openairdocs.org/ntsb/ANC14LA038.md): Aeronca 15AC · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jun 6, 2014 · N1301H · Substantial damage
  > Maintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…
- [NTSB WPR14CA227](https://openairdocs.org/ntsb/WPR14CA227.md): Robinson Helicopter R22 Beta · Prescott, AZ · Accident · No injuries · Data collection · Final report · Jun 4, 2014 · N223G · Substantial damage
  > The inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…
- [NTSB CEN14LA276](https://openairdocs.org/ntsb/CEN14LA276.md): Cessna 172N · Padre Island, TX · Accident · No injuries · Limited investigation · Final report · Jun 3, 2014 · N734BY · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB DCA14WA103](https://openairdocs.org/ntsb/DCA14WA103.md): Airbus A300 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Jun 1, 2014 · N137UP · No damage
  > The Mexican Directorate General of Civil Aviation (DGAC) has notified the NTSB of an incident involving an Airbus A300 operated by United Parcel Service (UPS), that occurred on June 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist…

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

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

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