# NTSB investigations, NV: Approach

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 6 · 285 cases

## Latest cases

- [NTSB WPR24FA304](https://openairdocs.org/ntsb/WPR24FA304.md): Globe Swift GC-1B · Minden, NV · Accident · 1 fatal · Class 3 · Field · Final report · Sep 16, 2024 · N78074 · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid the other airplane while operating in the airport traffic pattern, which resulted in a midair collision.
- [NTSB OPS24LA011](https://openairdocs.org/ntsb/OPS24LA011.md): Diamond Aircraft Ind DA20-C1 · North Las Vegas, NV · Incident · No injuries · Class 4 · Limited · Final report · Dec 9, 2023 · N857PA · 2 aircraft · No damage
  > The local controller’s loss of situational awareness, inadequate provision of traffic advisory or safety alert information, and lack of positive control, that resulted in a near-midair collision.
- [NTSB WPR24LA025](https://openairdocs.org/ntsb/WPR24LA025.md): Gulfstream Aerospace Commander 690C · Reno, NV · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 26, 2023 · N840KB · Substantial damage
  > The pilot applicant’s excessive nose down pitch, and the check pilot’s delayed remedial action, which resulted in an impact with terrain.
- [NTSB WPR23FA345](https://openairdocs.org/ntsb/WPR23FA345.md): North American T-6G · Reno, NV · Accident · 2 fatal · Class 3 · Field · Final report · Sep 17, 2023 · N2897G · 2 aircraft · Substantial damage
  > The failure of both the Race 14 and Race 6 pilots to see and avoid each other while in the airport traffic pattern. Contributing to the accident was both pilots’ failure to fly the standard downwind and base legs.
- [NTSB WPR23FA153](https://openairdocs.org/ntsb/WPR23FA153.md): Mullins David J JR Glastar · Cal-Nev-Ari, NV · Accident · 2 fatal · Class 3 · Field · Final report · Apr 11, 2023 · N8488 · Substantial damage
  > The pilot's failure to maintain sufficient altitude for undetermined reasons while maneuvering to land in dark night conditions, which resulted in collision with terrain.
- [NTSB WPR22LA349](https://openairdocs.org/ntsb/WPR22LA349.md): Beech M35 · Henderson, NV · Accident · No injuries · Class 3 · Limited · Final report · Sep 15, 2022 · N9876R · Substantial damage
  > The flight instructor’s failure to verify the fuel quantity and improper fuel management, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA22FA318](https://openairdocs.org/ntsb/ERA22FA318.md): Piper PA-46-350P · North Las Vegas, NV · Accident · 4 fatal · Class 3 · Field · Final report · Jul 17, 2022 · N97CX · 2 aircraft · Destroyed
  > The low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…
- [NTSB WPR22LA040](https://openairdocs.org/ntsb/WPR22LA040.md): Piper PA-28R-200 · Boulder City, NV · Accident · No injuries · Class 3 · Limited · Final report · Nov 14, 2021 · N5057S · Substantial damage
  > The installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.
- [NTSB WPR21FA203](https://openairdocs.org/ntsb/WPR21FA203.md): Dassault Mirage F-1 · Las Vegas, NV · Accident · 1 fatal · Class 3 · Field · Final report · May 24, 2021 · N567EM · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack on approach and failure to fly a traffic pattern track consistent with a no-flap configuration. Contributing to the accident was the failure of the airplane’s flaps to extend while in the…
- [NTSB WPR21LA201](https://openairdocs.org/ntsb/WPR21LA201.md): Cessna 182P · Minden, NV · Accident · No injuries · Class 4 · Limited · Final report · May 18, 2021 · N8488M · Substantial damage
  > The pilot’s failure to maintain airplane control while on approach in microburst or windshear conditions, which resulted in impact with a runway sign.
- [NTSB WPR21LA184](https://openairdocs.org/ntsb/WPR21LA184.md): Cessna 182K · Las Vegas, NV · Accident · No injuries · Class 3 · Limited · Final report · Mar 18, 2021 · N2548R · Substantial damage
  > A total loss of engine power due to fuel exhaustion.
- [NTSB WPR20LA189](https://openairdocs.org/ntsb/WPR20LA189.md): Aerospatiale SA342J · Minden, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 21, 2020 · N342J · Destroyed
  > The total loss of engine power due to a surge; the reason for the surge could not be determined based on available information. Contributing to the helicopter damage was the total loss of power while the pilot was transitioning through an altitude and…
- [NTSB WPR20CA102](https://openairdocs.org/ntsb/WPR20CA102.md): Mooney M20K · Minden, NV · Accident · No injuries · Data collection · Final report · Feb 14, 2020 · N231VM · Substantial damage
  > The pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB GAA20CA010](https://openairdocs.org/ntsb/GAA20CA010.md): Cessna 150 · Fallon, NV · Accident · No injuries · Data collection · Final report · Oct 8, 2019 · N50618 · Substantial damage
  > The pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.
- [NTSB WPR19LA243](https://openairdocs.org/ntsb/WPR19LA243.md): Mooney M20C · Reno, NV · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 26, 2019 · N78988 · Substantial damage
  > The pilot's improper inflight fuel management, which resulted in fuel starvation and a total loss of engine power.
- [NTSB WPR19LA141](https://openairdocs.org/ntsb/WPR19LA141.md): Flight Design Ctls · Boulder City, NV · Accident · Serious injuries · Class 3 · Limited · Final report · May 7, 2019 · N423EB · Substantial damage
  > The pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.
- [NTSB GAA19CA086](https://openairdocs.org/ntsb/GAA19CA086.md): Cessna 182 · Reno, NV · Accident · No injuries · Data collection · Final report · Dec 3, 2018 · N9003M · Substantial damage
  > The airplane’s collision with a bird during a practice instrument approach.
- [NTSB WPR18FA253](https://openairdocs.org/ntsb/WPR18FA253.md): Commander 114 · Jean, NV · Accident · 1 fatal · Class 2 · Field · Final report · Sep 6, 2018 · N6064C · Destroyed
  > The pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.
- [NTSB WPR18LA094](https://openairdocs.org/ntsb/WPR18LA094.md): Soko Galeb G 2 · Elko, NV · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 21, 2018 · N90SR · Substantial damage
  > An improperly installed brake cylinder, which resulted in insufficient hydraulic pressure being provided to three of the brake cylinders and the left brake being inoperable during landing.
- [NTSB GAA18CA123](https://openairdocs.org/ntsb/GAA18CA123.md): Oliver Lawrence R Kitfox IV 1200 · Carson City, NV · Accident · No injuries · Data collection · Final report · Feb 11, 2018 · N76478 · Substantial damage
  > The flight instructor’s failure to maintain directional control during the landing roll and lateral control during the go-around in gusting crosswind conditions. Contributing to the accident was the lack of communication between the flight instructor and the…
- [NTSB WPR18LA082](https://openairdocs.org/ntsb/WPR18LA082.md): Beech 95 · North Las Vegas, NV · Accident · No injuries · Class 3 · Limited · Final report · Feb 2, 2018 · N128W · Substantial damage
  > Loss of aircraft control during an unplanned go-around for reasons that could not be determined based on available information. Contributing to the accident was the delayed remedial action by the flight instructor.
- [NTSB WPR18LA023](https://openairdocs.org/ntsb/WPR18LA023.md): Beech B95 · Las Vegas, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 3, 2017 · N9628R · Substantial damage
  > The flight instructor’s inadequate preflight fuel planning, which resulted in fuel exhaustion, a total loss of power to both engines, and a subsequent forced landing.
- [NTSB WPR16FA172](https://openairdocs.org/ntsb/WPR16FA172.md): Beech A36 · Sparks, NV · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2016 · N985CA · Destroyed
  > The pilot's selection of a landing runway which, given the wind and traffic conditions, was susceptible to high crosswinds and the translation of wake turbulence across its approach path, and the controller's and pilot's failure to ensure separation from the…
- [NTSB WPR16FA166](https://openairdocs.org/ntsb/WPR16FA166.md): Douglas TA-4K · Las Vegas, NV · Accident · Minor injuries · Field investigation · Final report · Aug 18, 2016 · N140EM · Destroyed
  > Foreign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…
- [NTSB DCA16CA182](https://openairdocs.org/ntsb/DCA16CA182.md): Boeing 737-932ER · Las Vegas, NV · Accident · Serious injuries · Data collection · Final report · Jun 5, 2016 · N801DZ · No damage
  > An encounter with wake turbulence that resulted in a flight attendant injury.
- [NTSB WPR16LA048](https://openairdocs.org/ntsb/WPR16LA048.md): Beech 35 C33 · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Jan 5, 2016 · N20XY · Substantial damage
  > A partial loss of engine power during final approach for reasons that could not be determined based on available information.
- [NTSB WPR15LA223](https://openairdocs.org/ntsb/WPR15LA223.md): Stinson 108 - 3 · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Jul 25, 2015 · N6152M · Substantial damage
  > The partial loss of engine power due to a degraded cylinder exhaust valve seal, which resulted in low cylinder compression.
- [NTSB GAA15CA172](https://openairdocs.org/ntsb/GAA15CA172.md): Schweizer SGS 1 26B · Silver Springs, NV · Accident · No injuries · Data collection · Final report · Jul 8, 2015 · N5839V · Substantial damage
  > The pilot's improper decision making in adverse weather conditions, which resulted in an encounter with weather and impact with terrain.
- [NTSB WPR15LA180](https://openairdocs.org/ntsb/WPR15LA180.md): Mooney M20C · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 8, 2015 · N7887V · Destroyed
  > The in-flight separation of the exhaust tube at a weld joint due to erosion and corrosion, which resulted in a subsequent in-flight fire.
- [NTSB WPR15LA127](https://openairdocs.org/ntsb/WPR15LA127.md): Jimenez Vans RV 7A · Dayton, NV · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2015 · N51MJ · Substantial damage
  > A loss of engine power during descent for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB WPR15LA034](https://openairdocs.org/ntsb/WPR15LA034.md): Extra Flugzeugproduktions-Und EA 300 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Nov 5, 2014 · N369XT · Substantial damage
  > A partial loss of engine power during cruise flight 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 WPR14FA243](https://openairdocs.org/ntsb/WPR14FA243.md): Dittenber Thomas J Auriga · Echo Bay, NV · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2014 · N55GM · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.
- [NTSB WPR14LA222](https://openairdocs.org/ntsb/WPR14LA222.md): Phillips BD 4 · Dayton, NV · Accident · 1 fatal · Limited investigation · Final report · Jun 3, 2014 · N11DV · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the turn onto the final base leg in gusting wind conditions, which resulted in a stall/spin at too low an altitude to allow recovery.
- [NTSB WPR14FA167](https://openairdocs.org/ntsb/WPR14FA167.md): Sands Helicycle · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Apr 13, 2014 · N78CS · Substantial damage
  > The pilot’s failure to maintain control of the helicopter while in the traffic pattern.
- [NTSB WPR13LA431](https://openairdocs.org/ntsb/WPR13LA431.md): Bombardier DHC-8-402 · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2013 · N449QX · No damage
  > The airplane’s encounter with known moderate-to-severe turbulence, which resulted in a serious injury to a flight attendant.
- [NTSB WPR13CA373](https://openairdocs.org/ntsb/WPR13CA373.md): Remos Acft Gmbh Flugzeugbau Remos GX · Las Vegas, NV · Accident · Minor injuries · Data collection · Final report · Aug 15, 2013 · N110GX · Substantial damage
  > The pilot's failure to maintain aircraft control during the initial climb following an aborted landing. Contributing to the accident was the pilot's inaccurate fuel planning which resulted in a low fuel state and subsequent precautionary off airport landing.
- [NTSB OPS13IA071](https://openairdocs.org/ntsb/OPS13IA071.md): Gulfstream GIV - Undesignat · Las Vegas, NV · Incident · No injuries · Incident investigation · Final report · Jul 5, 2013 · N0 · No damage
  > The Federal Aviation Administration's (FAA) inadequate procedures, which did not require specific separation between aircraft operating on nonintersecting runways where flightpaths may intersect and led to an airborne conflict between two aircraft.…
- [NTSB WPR13FA001](https://openairdocs.org/ntsb/WPR13FA001.md): Piper PA-28-180 · Beatty, NV · Accident · Serious injuries · Field investigation · Final report · Oct 3, 2012 · N7895W · Substantial damage
  > The pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.
- [NTSB WPR12TA323](https://openairdocs.org/ntsb/WPR12TA323.md): Aero Commander 500 S · Elko, NV · Accident · No injuries · Final report · Jul 24, 2012 · N535SA · Substantial damage
  > A loss of power due to fuel exhaustion. Contributing to the accident were the pilot's failure to comply with required fueling procedures and the pilot's poor decision-making in not monitoring his fuel gauge and turning back when it reached minimum fuel.
- [NTSB WPR12LA313](https://openairdocs.org/ntsb/WPR12LA313.md): Cessna T210M · Wells, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 2012 · N6181N · Substantial damage
  > A loss of engine power during the final landing approach for reasons that could not be determined because postaccident examination did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB DCA12PA049](https://openairdocs.org/ntsb/DCA12PA049.md): Israel Aircraft Industries F21-C2 · Fallon, NV · Accident · 1 fatal · Final report · Mar 6, 2012 · N404AX · Destroyed
  > fuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…
- [NTSB WPR11LA457](https://openairdocs.org/ntsb/WPR11LA457.md): Cessna 170 · Pahrump, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2011 · N1677D · Substantial damage
  > A loss of engine power during the landing approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR09LA458](https://openairdocs.org/ntsb/WPR09LA458.md): Cassutt III M · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2009 · C-FDXO · Substantial damage
  > The loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.
- [NTSB WPR09FA258](https://openairdocs.org/ntsb/WPR09FA258.md): Cessna 320D · Fallon, NV · Accident · 4 fatal · Field investigation · Final report · May 23, 2009 · N320KP · Substantial damage
  > The pilot’s inadequate airspeed, which resulted in an aerodynamic stall.
- [NTSB WPR09LA213](https://openairdocs.org/ntsb/WPR09LA213.md): Schweizer 269C · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Apr 22, 2009 · N17YS · Substantial damage
  > Loss of engine power during approach for undetermined reasons.
- [NTSB WPR09LA083](https://openairdocs.org/ntsb/WPR09LA083.md): Cessna 172RG · Carson City, NV · Accident · No injuries · Limited investigation · Final report · Jan 10, 2009 · N6272R · Substantial damage
  > The overload failure of the landing gear actuator at an undetermined time.
- [NTSB LAX08LA271](https://openairdocs.org/ntsb/LAX08LA271.md): Hawker Sea Fury TMK 20 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Aug 20, 2008 · N51SF · Substantial damage
  > A ruptured center balance diaphragm that resulted in a loss of engine power during final approach and subsequent forced landing on a desert floor.
- [NTSB LAX08LA268](https://openairdocs.org/ntsb/LAX08LA268.md): Rouse Glasair III · Reno, NV · Accident · No injuries · Limited investigation · Final report · Aug 16, 2008 · N1YZ · Substantial damage
  > The excessively worn throttle/mixture linkage arms and pins and a missing mixture control linkage spring washer, which resulted in a loss of power due to an excessively rich mixture.
- [NTSB SEA08CA144](https://openairdocs.org/ntsb/SEA08CA144.md): Schweizer 269C-1 · Reno, NV · Accident · Minor injuries · Data collection · Final report · May 29, 2008 · N2024Z · Substantial damage
  > The student pilot's failure to maintain translational lift airspeed while approaching the pinnacle and the certificated flight instructor's delayed remedial action and inadequate supervision of the flight.
- [NTSB SEA08LA104](https://openairdocs.org/ntsb/SEA08LA104.md): Robinson R44 · Pahrump, NV · Accident · No injuries · Limited investigation · Final report · Apr 5, 2008 · N510JM · Substantial damage
  > The loss of the engine to transmission drive train continuity while on approach for undetermined reasons. Contributing to the accident were lack of suitable terrain for a run-on landing, and cars on the race track.

Next page: https://openairdocs.org/ntsb-phases/500/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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/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.
