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

## Cases, newest first

- [NTSB ERA13LA211](https://openairdocs.org/ntsb/ERA13LA211.md): Piper PA-18-135 · Inlet, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 2013 · N18JP · Substantial damage
  > A loss of engine power for reasons that could not be determined during postaccident examination.
- [NTSB CEN13LA232](https://openairdocs.org/ntsb/CEN13LA232.md): Cessna 172G · Reading, MI · Accident · No injuries · Limited investigation · Final report · Apr 20, 2013 · N3682L · Substantial damage
  > The partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.
- [NTSB CEN13LA233](https://openairdocs.org/ntsb/CEN13LA233.md): Piper PA-32-301 · Paris, TX · Accident · No injuries · Limited investigation · Final report · Apr 19, 2013 · N82723 · Substantial damage
  > The improper installation of the connecting rod bolts, which resulted in an engine failure.
- [NTSB WPR13FA201](https://openairdocs.org/ntsb/WPR13FA201.md): Cessna 182D · Wellington, NV · Accident · 2 fatal · Field investigation · Final report · Apr 15, 2013 · N9078X · Destroyed
  > The pilot’s failure to maintain clearance from mountainous terrain during a night, visual descent to the destination airport, which resulted in controlled flight into terrain.
- [NTSB ERA13LA204](https://openairdocs.org/ntsb/ERA13LA204.md): Harris Pierce Velocity XL RG · Avon Park, FL · Accident · No injuries · Limited investigation · Final report · Apr 12, 2013 · N101ME · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB WPR13LA186](https://openairdocs.org/ntsb/WPR13LA186.md): Cirrus Design SR22 · Silver Peak, NV · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 2013 · N205KT · Substantial damage
  > The pilot’s incapacitation due to sleeping pills, which led to the airplane impacting terrain in an autopilot-controlled descent following a loss of engine power due to fuel exhaustion.
- [NTSB DCA13WA089](https://openairdocs.org/ntsb/DCA13WA089.md): Beech 1900 · Unkown, São Tomé & Príncipe · Accident · 1 fatal · Foreign investigation · Apr 7, 2013 · ZS-PHL · Destroyed
  > The Sao Tome and Principe Civil Aviation Authority (STPCAA) has notified the NTSB of an accident involving a Beech 1900 that occurred on April 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist STPCAA investigation under the…
- [NTSB CEN13FA221](https://openairdocs.org/ntsb/CEN13FA221.md): Mooney M20J · Collinsville, OK · Accident · 2 fatal · Field investigation · Final report · Apr 7, 2013 · N57672 · Destroyed
  > The pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.
- [NTSB WPR13FA183](https://openairdocs.org/ntsb/WPR13FA183.md): Cessna 182C · Circle, MT · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2013 · N8721T · Destroyed
  > The pilot’s failure to maintain airplane control as a result of spatial disorientation. Contributing to the accident was the pilot’s decision to continue flight into low visibility conditions.
- [NTSB ERA13CA195](https://openairdocs.org/ntsb/ERA13CA195.md): Phoenix Air U15 · Foscoe, NC · Accident · No injuries · Data collection · Final report · Apr 6, 2013 · N94DK · Substantial damage
  > The motorized glider’s encounter with clear air turbulence, which resulted in substantial damage to the empennage.
- [NTSB CEN13LA220](https://openairdocs.org/ntsb/CEN13LA220.md): Walker Phil RV-6A · Spearfish, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 2013 · N525PW · Substantial damage
  > The coil-distributor wire loosening in flight, which rendered the ignition system inoperative and subsequently caused the loss of engine power.
- [NTSB CEN13FA217](https://openairdocs.org/ntsb/CEN13FA217.md): Mooney M20E · Guymon, OK · Accident · 2 fatal · Field investigation · Final report · Apr 1, 2013 · N9330M · Destroyed
  > The noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…
- [NTSB ERA13FA184](https://openairdocs.org/ntsb/ERA13FA184.md): Lancair LC42 - 550FG · Winston-Salem, NC · Accident · 2 fatal · Field investigation · Final report · Mar 31, 2013 · N6506L · Destroyed
  > The pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…
- [NTSB CEN13FA219](https://openairdocs.org/ntsb/CEN13FA219.md): Piper PA-28-140 · Castle Rock, CO · Accident · 1 fatal · Field investigation · Final report · Mar 31, 2013 · N55093 · Substantial damage
  > The pilot's loss of airplane control while maneuvering between two convective storms that likely produced low-level windshear. Contributing to the accident was the pilot's relatively low overall flight experience and low night flight experience, which…
- [NTSB ERA13LA183](https://openairdocs.org/ntsb/ERA13LA183.md): Andrews Zodiac · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Mar 29, 2013 · N999NA · Minor damage
  > The pilot's failure to ensure that his seatbelt was fastened and the pilots' failure to ensure that the canopy was latched properly, which resulted in the pilot's ejection from the cockpit following the opening of the canopy and the subsequent in-flight upset.
- [NTSB CEN13FA214](https://openairdocs.org/ntsb/CEN13FA214.md): Cessna 152 · Hawley, MN · Accident · 1 fatal · Field investigation · Final report · Mar 29, 2013 · N5367B · Substantial damage
  > The noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.
- [NTSB WPR13FA169](https://openairdocs.org/ntsb/WPR13FA169.md): Mooney M20A · Wikieup, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2013 · N6018X · Substantial damage
  > The manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…
- [NTSB DCA13WA087](https://openairdocs.org/ntsb/DCA13WA087.md): Boeing Boeing 757-300 · Gran Canaria, Spain · Incident · No injuries · Foreign investigation · Mar 27, 2013 · D-ABOC · No damage
- [NTSB CEN13LA211](https://openairdocs.org/ntsb/CEN13LA211.md): Bellanca 17-30A · Plainview, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 2013 · N96JG · Substantial damage
  > The student pilot's improper decision to fly in night visual meteorological conditions and his failure to maintain altitude and clearance from obstacles.
- [NTSB WPR13LA161](https://openairdocs.org/ntsb/WPR13LA161.md): Owens Velocity 173 · Maricopa, AZ · Accident · No injuries · Limited investigation · Final report · Mar 25, 2013 · N33SV · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the throttle body revealed no anomalies that would have precluded normal operation.
- [NTSB ERA13LA179](https://openairdocs.org/ntsb/ERA13LA179.md): Piper PA-23-250 · Perry, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 2013 · N625SR · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA13LA174](https://openairdocs.org/ntsb/ERA13LA174.md): Piper PA-25-235 · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2013 · N86AB · Substantial damage
  > A loss of preload to the crankshaft gear attachment bolt, resulting in rotation of the crankshaft gear and a subsequent total loss of engine power. The root cause for the loss of preload could not be determined during a postaccident examination of the…
- [NTSB CEN13FA196](https://openairdocs.org/ntsb/CEN13FA196.md): Hawker Beechcraft 390 · South Bend, IN · Accident · 2 fatal · Field investigation · Final report · Mar 17, 2013 · N26DK · Destroyed
  > The private pilot's inadequate response to the dual engine shutdown during cruise descent, including his failure to adhere to procedures, which ultimately resulted in his failure to maintain airplane control during a single-engine go-around. An additional…
- [NTSB CEN13CA197](https://openairdocs.org/ntsb/CEN13CA197.md): Cessna 150G · Baytown, TX · Accident · Minor injuries · Data collection · Final report · Mar 17, 2013 · N6389S · Substantial damage
  > The pilot’s poor in-flight decision-making and improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN13LA194](https://openairdocs.org/ntsb/CEN13LA194.md): Robinson Helicopter R44 II · Eagle Nest, NM · Accident · No injuries · Limited investigation · Final report · Mar 14, 2013 · N392GP · Substantial damage
  > A total loss of engine power due to a rapid throttle change during autorotation, which the flight instructor initiated in response to a low rotor rpm warning, which resulted from the separation of one of the magnets used to provide rotor rpm indications from…
- [NTSB ANC13LA033](https://openairdocs.org/ntsb/ANC13LA033.md): Piper PA-23-250 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Mar 14, 2013 · N6008Y · Substantial damage
  > A total loss of engine power of both engines for reasons that could not be determined because the engines were not made available for examination.
- [NTSB WPR13LA147](https://openairdocs.org/ntsb/WPR13LA147.md): Franklin Glasair II · Spanish Fork, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 2013 · N61RA · Substantial damage
  > A loss of engine power due to fuel starvation, which likely resulted from air being introduced into the fuel system through the worn shaft of an electric fuel boost pump.
- [NTSB WPR13FA141](https://openairdocs.org/ntsb/WPR13FA141.md): Maule M5 · Woodinville, WA · Accident · 1 fatal · Field investigation · Final report · Mar 9, 2013 · N17PR · Substantial damage
  > The pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination, which resulted in a stall/spin and subsequent impact with terrain.
- [NTSB ERA13WA162](https://openairdocs.org/ntsb/ERA13WA162.md): Beech 35 · Los Amores, Santa Fe, Argentina · Accident · 3 fatal · Foreign investigation · Mar 9, 2013 · ZP-BAM · Destroyed
  > On March 9, 2013, about 2030 coordinated universal time (UTC), a Beech 35, Paraguayan registration ZP-BAM, was destroyed when it impacted terrain in Los Amores, Santa Fe Province, Argentina. The pilot and two passengers were fatally injured. The flight…
- [NTSB ANC13FA030](https://openairdocs.org/ntsb/ANC13FA030.md): Beech 1900C · Aleknagik, AK · Accident · 2 fatal · Field investigation · Final report · Mar 8, 2013 · N116AX · Destroyed
  > The flight crew's failure to maintain terrain clearance, which resulted in controlled flight into terrain in instrument meteorological conditions. Contributing to the accident were the flight crew's failure to correctly read back and interpret clearance…
- [NTSB ANC13LA029](https://openairdocs.org/ntsb/ANC13LA029.md): Cessna 207 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Mar 6, 2013 · N1704U · Substantial damage
  > The failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue fracturing, which resulted in a loss of engine power during cruise flight.
- [NTSB WPR13IA144](https://openairdocs.org/ntsb/WPR13IA144.md): Bombardier DHC-8-402 · Danville, CA · Incident · No injuries · Incident investigation · Final report · Mar 5, 2013 · N417QX · Minor damage
  > The failure and separation of a section of the No. 2 engine's combustion chamber's small exit duct (SED), which created an airflow disruption that led to an engine surge and subsequent fire. Contributing to the accident was the insufficient weld penetration…
- [NTSB ANC13FA027](https://openairdocs.org/ntsb/ANC13FA027.md): Cessna 182B · Nikolai, AK · Accident · 3 fatal · Field investigation · Final report · Mar 4, 2013 · N2343G · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering inside a box canyon and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot’s visual…
- [NTSB WPR13FA138](https://openairdocs.org/ntsb/WPR13FA138.md): Cessna 172M · Saratoga, WY · Accident · 1 fatal · Field investigation · Final report · Mar 3, 2013 · N5129R · Substantial damage
  > The pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…
- [NTSB WPR13CA136](https://openairdocs.org/ntsb/WPR13CA136.md): Buckeye Dream Machine · Tracy, CA · Accident · Serious injuries · Data collection · Final report · Mar 2, 2013 · N7193K · Substantial damage
  > The pilot’s failure to see and avoid power lines during a climb.
- [NTSB ERA13LA152](https://openairdocs.org/ntsb/ERA13LA152.md): Robinson Helicopter R44 II · Ciales, PR · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 2013 · N834RC · Destroyed
  > A loss of main rotor rpm for reasons that could not be determined because an examination of the helicopter’s engine and associated components did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN13LA179](https://openairdocs.org/ntsb/CEN13LA179.md): Cessna 150M · Deming, NM · Accident · 1 fatal · Limited investigation · Final report · Feb 27, 2013 · N9172U · Substantial damage
  > The pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.
- [NTSB DCA13WA070](https://openairdocs.org/ntsb/DCA13WA070.md): Boeing 737 · Brisbane, Australia · Incident · No injuries · Foreign investigation · Feb 25, 2013 · VH-VYE · No damage
  > The Australian Transportation Safety Board (ATSB) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on February 25, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the…
- [NTSB ERA13LA143](https://openairdocs.org/ntsb/ERA13LA143.md): Cessna T337G · Homestead, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 2013 · N8594M · Substantial damage
  > The reported partial loss of engine power from the rear engine for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13FA172](https://openairdocs.org/ntsb/CEN13FA172.md): Maule MXT-7-180 · Parkers Parairie, MN · Accident · 1 fatal · Field investigation · Final report · Feb 21, 2013 · N9229Y · Substantial damage
  > The pilot’s failure to transfer fuel from the auxiliary fuel tanks to the main fuel tanks in a timely manner, which resulted in fuel starvation to the engine.
- [NTSB WPR13LA131](https://openairdocs.org/ntsb/WPR13LA131.md): Boeing 747-422 · Pacific Ocean, A1 · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2013 · N174UA · No damage
  > The flight’s encounter with moderate clear air turbulence while en route, which resulted in a serious injury to a flight attendant. Contributing to the accident was the lack of communication equipment in the rest compartment, which, if installed, could have…
- [NTSB CEN13CA175](https://openairdocs.org/ntsb/CEN13CA175.md): Cessna 177 · Elcho, WI · Accident · Minor injuries · Data collection · Final report · Feb 17, 2013 · N30227 · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.
- [NTSB WPR13LA125](https://openairdocs.org/ntsb/WPR13LA125.md): Temco D-16A · Heber, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2013 · N716T · Substantial damage
  > A loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight and fuel planning.
- [NTSB ERA13LA138](https://openairdocs.org/ntsb/ERA13LA138.md): Ayres S2R-T34 · Fort Gaines, GA · Accident · No injuries · Limited investigation · Final report · Feb 15, 2013 · N3095X · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of debris in the fuel control unit.
- [NTSB WPR13FA123](https://openairdocs.org/ntsb/WPR13FA123.md): Avions Fairey Tipsy Nipper T-66 · Winters, CA · Accident · 1 fatal · Field investigation · Final report · Feb 14, 2013 · N1959N · Substantial damage
  > The airplane's impact with a turkey vulture in cruise flight, which resulted in the structural failure of the right wing and the subsequent loss of control.
- [NTSB ERA13FA133](https://openairdocs.org/ntsb/ERA13FA133.md): Cessna 310H · Yeehaw Junction, FL · Accident · 3 fatal · Field investigation · Final report · Feb 14, 2013 · N104DR · Substantial damage
  > The noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…
- [NTSB CEN13CA162](https://openairdocs.org/ntsb/CEN13CA162.md): Beech A60 · Abilene, TX · Accident · No injuries · Data collection · Final report · Feb 14, 2013 · N7466D · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR13LA122](https://openairdocs.org/ntsb/WPR13LA122.md): ST Clair Lancair 360 · Williams, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 2013 · N123ST · Destroyed
  > An in-flight fire due to an electrical short circuit.
- [NTSB CEN13LA158](https://openairdocs.org/ntsb/CEN13LA158.md): Bell 206B III · Ponderosa, NM · Accident · No injuries · Limited investigation · Final report · Feb 11, 2013 · N360AW · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB DCA13IA058](https://openairdocs.org/ntsb/DCA13IA058.md): Bombardier CL-600-2B19 · Bowman, GA · Incident · Minor injuries · Incident investigation · Final report · Feb 7, 2013 · N261PS · Minor damage
  > the captain's inappropriate climb speed, his failure to monitor airspeed during the level off, and his inappropriate response to multiple stall warnings.

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

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

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