# NTSB investigations, NV: 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 1 of 11 · 503 cases

## Latest cases

- [NTSB WPR26LA356](https://openairdocs.org/ntsb/WPR26LA356.md): Zenith CH 750 Stol · Spring Creek, NV · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 24, 2026 · N750WZ · Substantial damage
  > On September 24, 2026, about 0958 mountain daylight time, an experimental amateur-built Zenith CH750 STOL airplane, N750WZ, was substantially damaged when it was involved in an accident near Silver Creek, Nevada. The pilot was not injured. The airplane was…
- [NTSB WPR26LA196](https://openairdocs.org/ntsb/WPR26LA196.md): Diamond DA40 · Wells, NV · Accident · Serious injuries · Class 4 · Limited · Final report · May 17, 2026 · N787PV · Substantial damage
  > The pilot’s inability to maintain climb performance and clearance from mountainous terrain due to a downdraft.
- [NTSB WPR26FA189](https://openairdocs.org/ntsb/WPR26FA189.md): Piper PA-32-300 · Empire, NV · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 17, 2026 · N8502N · Substantial damage
  > On May 17, 2026, about 0738 PDT, a Piper PA-32-300, N8502N, was substantially damaged when it was involved in an accident near Empire, Nevada. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA019](https://openairdocs.org/ntsb/WPR26FA019.md): Beech V35 · Austin, NV · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 15, 2025 · CFETM · Substantial damage
  > On October 15, 2025, about 1447 Pacific daylight time, a Beech V35, C-FETM, was substantially damaged when it was involved in an accident near Austin, Nevada. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB DCA25LA341](https://openairdocs.org/ntsb/DCA25LA341.md): Airbus A321 · Las Vegas, NV · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 30, 2025 · N670NK · No damage
  > The airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant who was standing at the time of the encounter.
- [NTSB WPR25LA236](https://openairdocs.org/ntsb/WPR25LA236.md): Piper PA-28-180 · Silver Springs, NV · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 3, 2025 · N8359W · Substantial damage
  > On August 3, 2025, at about 0730 Pacific daylight time, a Piper PA28-180, N8359W, was substantially damaged when it was involved in an accident near Stagecoach, Nevada. The student pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA152](https://openairdocs.org/ntsb/WPR25LA152.md): Dehavilland DHC-6-300 · Boulder City, NV · Accident · No injuries · Class 3 · Limited · Preliminary report · May 6, 2025 · N142SA · Substantial damage
  > On May 6, 2023, about 1450 Pacific daylight time, a DeHavilland DHC-6-300, N142SA, was substantially damaged when it was involved in an accident near Boulder City, Nevada. The 2 pilots and 11 passengers were not injured. The airplane was operated as a Title…
- [NTSB WPR25LA133](https://openairdocs.org/ntsb/WPR25LA133.md): Cessna 182L · Erie, NV · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2025 · N182VE · No damage
  > On April 13, 2025, about 0850 Pacific daylight time, a Cessna 182L, N182VE, was substantially damaged when it was involved in an accident near Erie, Nevada. The pilot and two passengers were uninjured, and one passenger sustained minor injuries. The airplane…
- [NTSB DCA25FA071](https://openairdocs.org/ntsb/DCA25FA071.md): Boeing 737 · Henderson, NV · Accident · Serious injuries · Class 3 · Field · Preliminary report · Dec 26, 2024 · N958AK · No damage
  > On December 26, 2024, at 1335 pacific standard time, Alaska Airlines flight 700, a Boeing 737-9, N958AK, encountered severe turbulence during cruise flight, near Henderson, Nevada. Of the 181 passengers and crew, two flight attendants received serious…
- [NTSB WPR25LA025](https://openairdocs.org/ntsb/WPR25LA025.md): Badlands Vaquero · West Wendover, NV · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 27, 2024 · N510DH · Substantial damage
  > On October 27, 2024, about 0915 Pacific daylight time, an experimental amateur-built Badlands Vaquero airplane, N510DH, was destroyed when it was involved in an accident near West Wendover, Nevada. The pilot sustained minor injuries. The airplane was operated…
- [NTSB DCA25LA001](https://openairdocs.org/ntsb/DCA25LA001.md): Airbus A321-211 · Las Vegas, NV · Incident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 5, 2024 · N701FR
  > On October 5, 2024, at 1510 Pacific daylight time, Frontier Airlines flight 1326, an Airbus A321-211, N701FR, was involved in an incident due to a brake fire during landing on runway 26L at Harry Reid International Airport (LAS), Las Vegas, Nevada. The…
- [NTSB WPR24LA274](https://openairdocs.org/ntsb/WPR24LA274.md): Burkhart Grob Flugzeugbau G103 Twin Astir · Minden, NV · Accident · No injuries · Class 4 · Limited · Final report · Aug 9, 2024 · N125CC · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and a subsequent collision with an obstacle during an off-field landing.
- [NTSB WPR24LA060](https://openairdocs.org/ntsb/WPR24LA060.md): Mooney M20J · Carlin, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 21, 2023 · N2073K · Substantial damage
  > Improper spacing of the magneto’s breaker point contact assemblies, which led to a loss of engine ignition during cruise flight and resulted in a total loss of engine power.
- [NTSB WPR23LA232](https://openairdocs.org/ntsb/WPR23LA232.md): Piper PA-28-140 · Rochester, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 17, 2023 · N3508K · Substantial damage
  > A broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR23MA113](https://openairdocs.org/ntsb/WPR23MA113.md): Pilatus PC-12/45 · Stagecoach, NV · Accident · 5 fatal · Class 2 · Major · Final report · Feb 25, 2023 · N273SM · Substantial damage
  > The pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…
- [NTSB WPR23LA003](https://openairdocs.org/ntsb/WPR23LA003.md): Cessna 182C · Boulder City, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2022 · N511W · Substantial damage
  > A total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.
- [NTSB WPR22LA246](https://openairdocs.org/ntsb/WPR22LA246.md): Cessna 172B · Silver Springs, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 7, 2022 · N7609X · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR21LA308](https://openairdocs.org/ntsb/WPR21LA308.md): Cessna 172 · Reno, NV · Accident · No injuries · Class 4 · Limited · Final report · Aug 9, 2021 · N5735R · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.
- [NTSB WPR21LA294](https://openairdocs.org/ntsb/WPR21LA294.md): Kuykendall Charles Lancair IV · Indian Springs, NV · Accident · No injuries · Class 3 · Limited · Final report · Jul 28, 2021 · N26PD · Destroyed
  > An in-flight fire due to an undetermined electrical malfunction.
- [NTSB WPR21LA030](https://openairdocs.org/ntsb/WPR21LA030.md): Cessna 310 · Las Vegas, NV · Accident · 2 fatal · Class 3 · Limited · Final report · Oct 29, 2020 · N101G · Destroyed
  > The pilot’s failure to maintain the airplane’s minimum controllable airspeed while maneuvering with one engine inoperative. Also causal was the loss of power in the left engine due to oil starvation. Contributing to the accident were inadequate maintenance…
- [NTSB WPR20LA246](https://openairdocs.org/ntsb/WPR20LA246.md): Air Tractor AT802 · Elgin, NV · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 30, 2020 · N8510M · 2 aircraft · Destroyed
  > The trailing pilot’s failure to maintain separation from the lead airplane during a fire retardant deployment flight, which resulted in the trailing airplane flying through a plume of retardant and the trailing pilot’s subsequent loss of visibility that led…
- [NTSB WPR20LA244](https://openairdocs.org/ntsb/WPR20LA244.md): American Eurocopter AS350 · Pioche, NV · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 29, 2020 · N755AE · Destroyed
  > The pilot’s failure to maintain altitude from terrain and subsequent loss of helicopter control due to entanglement of the external load cable with the tail rotor.
- [NTSB WPR20FA034](https://openairdocs.org/ntsb/WPR20FA034.md): Cirrus SR-22 · North Las Vegas, NV · Accident · 3 fatal · Class 3 · Field · Final report · Nov 27, 2019 · N7GA · Destroyed
  > The pilot’s failure to maintain clearance from terrain during cruise flight in dark night conditions.
- [NTSB WPR19FA263](https://openairdocs.org/ntsb/WPR19FA263.md): Cessna 182 · Nixon, NV · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2019 · N1891X · Destroyed
  > A loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.
- [NTSB WPR19FA084](https://openairdocs.org/ntsb/WPR19FA084.md): Cirrus SR22 · Ely, NV · Accident · 2 fatal · Class 2 · Field · Final report · Feb 16, 2019 · N917SR · Destroyed
  > The pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and icing conditions which resulted in a high rate of descent and impact with terrain. Contributing to the accident was the inaccurate weather reporting…
- [NTSB DCA19CA081](https://openairdocs.org/ntsb/DCA19CA081.md): Embraer ERJ170 · Reno, NV · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 13, 2019 · N613CZ · Minor damage
  > an inadvertent encounter with convective turbulence that resulted in a TCAS RA, which required an abrupt control input by the flight crew to resolve the conflict.
- [NTSB DCA19CA037](https://openairdocs.org/ntsb/DCA19CA037.md): Airbus A320 · LAS Vegas, NV · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 1, 2018 · N632NK · No damage
  > The airplane’s encounter with severe turbulence.
- [NTSB GAA18CA468](https://openairdocs.org/ntsb/GAA18CA468.md): Cessna 185 · Lovelock, NV · Accident · No injuries · Data collection · Final report · Aug 5, 2018 · N9867X · Substantial damage
  > The pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB WPR18TA192](https://openairdocs.org/ntsb/WPR18TA192.md): Schempp Hirth Discus CS · Goldfield, NV · Accident · Serious injuries · Final report · Jul 11, 2018 · N104TH · Substantial damage
  > The glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.
- [NTSB WPR18LA156](https://openairdocs.org/ntsb/WPR18LA156.md): Beech A36 · Tonopah, NV · Accident · Minor injuries · Limited investigation · Final report · May 30, 2018 · N191HL · Substantial damage
  > The pilot's failure to properly lean the fuel/air mixture and to monitor critical engine parameters during the en route climb to cruise level, which resulted in excessive engine heat and oil starvation and the subsequent catastrophic engine failure.
- [NTSB WPR18FA131](https://openairdocs.org/ntsb/WPR18FA131.md): American Air Racing Thunder Mustang · Reno, NV · Accident · 1 fatal · Field investigation · Final report · May 2, 2018 · N352BT · Substantial damage
  > The pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…
- [NTSB WPR18FA091](https://openairdocs.org/ntsb/WPR18FA091.md): Piper PA34 · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2018 · N14GQ · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.
- [NTSB WPR18FA073](https://openairdocs.org/ntsb/WPR18FA073.md): Piper PA 23-250 · Elko, NV · Accident · 1 fatal · Field investigation · Final report · Jan 12, 2018 · N54857 · Destroyed
  > The pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.
- [NTSB WPR18LA002](https://openairdocs.org/ntsb/WPR18LA002.md): Cessna 172S · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Oct 2, 2017 · N5311H · Substantial damage
  > The pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…
- [NTSB WPR17LA133](https://openairdocs.org/ntsb/WPR17LA133.md): Eurocopter EC 130 B4 · Boulder City, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 2017 · N151GC · Substantial damage
  > A loss of engine power due to the failure of the manufacturer to reinstall the oil filter after it was removed for inspection, which led to coke pollution that obstructed the oil jet and resulted in the subsequent oil starvation of the axial compressor rear…
- [NTSB WPR17LA012](https://openairdocs.org/ntsb/WPR17LA012.md): Northland IVP · Lovelock, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 2016 · N4YB · Substantial damage
  > A total loss of engine power due to the failure of the intake valve in the No. 3 cylinder for reasons that could not be determined based on the available information.
- [NTSB WPR16FA160](https://openairdocs.org/ntsb/WPR16FA160.md): AMS Flight Carat A · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2016 · N11DY · Substantial damage
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB GAA16CA259](https://openairdocs.org/ntsb/GAA16CA259.md): Cessna 182 · Reno, NV · Accident · No injuries · Data collection · Final report · May 24, 2016 · N4793D · Substantial damage
  > The pilot's inadequate fuel planning, resulting in fuel exhaustion and substantial damage to the firewall during the forced landing.
- [NTSB WPR15LA196](https://openairdocs.org/ntsb/WPR15LA196.md): Piper PA 32R-301 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Jun 22, 2015 · N35590 · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.
- [NTSB WPR15LA090](https://openairdocs.org/ntsb/WPR15LA090.md): Cessna 150E · Silver Springs, NV · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2015 · N4017U · Substantial damage
  > The loss of engine power for reasons that could not be determined during a postaccident examination of the airplane.
- [NTSB WPR15TA071](https://openairdocs.org/ntsb/WPR15TA071.md): MD Helicopter 369FF · Las Vegas, NV · Accident · Serious injuries · Final report · Dec 31, 2014 · N530KK · 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 anomalies that would have precluded normal operation.
- [NTSB WPR15FA010](https://openairdocs.org/ntsb/WPR15FA010.md): Cessna 170B · Yerington, NV · Accident · 2 fatal · Field investigation · Final report · Oct 12, 2014 · N3558C · 2 aircraft · Destroyed
  > The failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…
- [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 WPR14FA132](https://openairdocs.org/ntsb/WPR14FA132.md): Cessna 120 · Carson City, NV · Accident · 1 fatal · Field investigation · Final report · Mar 9, 2014 · N76856 · Destroyed
  > The pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…
- [NTSB WPR14CA069](https://openairdocs.org/ntsb/WPR14CA069.md): Cessna 150F · Henderson, NV · Accident · Minor injuries · Data collection · Final report · Dec 14, 2013 · N7015F · Substantial damage
  > The flight crew's improper in-flight fuel planning lead to fuel exhaustion, which resulted in a complete loss of engine power.
- [NTSB WPR13FA284](https://openairdocs.org/ntsb/WPR13FA284.md): Beech A45 · Boulder City, NV · Accident · 2 fatal · Field investigation · Final report · Jun 23, 2013 · N434M · Substantial damage
  > The pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…
- [NTSB WPR13CA231](https://openairdocs.org/ntsb/WPR13CA231.md): Cessna 182P · Carson City, NV · Accident · No injuries · Data collection · Final report · May 15, 2013 · N911HE · Substantial damage
  > The pilot's failure to maintain aircraft control after an encounter with downdrafts while flying over mountainous terrain.
- [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 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 WPR13FA070](https://openairdocs.org/ntsb/WPR13FA070.md): Piper PA-31T1 · Ely, NV · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N93CN · Destroyed
  > The pilot’s failure to regain airplane control following a sudden rapid descent during cruise flight, which resulted in an exceedance of the design stress limits of the aircraft and led to an in-flight structural failure.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=NV&page=2

## 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."eventStateOrRegion" = 'NV' AND c."eventCountry" = 'USA'
  AND 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?state=NV

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