# NTSB investigations, NE: 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 4 · 174 cases

## Latest cases

- [NTSB CEN26LA199](https://openairdocs.org/ntsb/CEN26LA199.md): Cessna A188B · Blair, NE · Accident · No injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N84497 · Substantial damage
  > On May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25FA348](https://openairdocs.org/ntsb/CEN25FA348.md): Cessna 210D · Kearney, NE · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 28, 2025 · N3806Y · Substantial damage
  > On August 27, 2025, about 20:57 central daylight time, a Cessna 210D, N3806Y was destroyed when it was involved in an accident near Kearney, Nebraska. Both pilots were fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…
- [NTSB CEN23FA077](https://openairdocs.org/ntsb/CEN23FA077.md): Cessna 150H · Auburn, NE · Accident · 2 fatal · Class 3 · Field · Final report · Jan 12, 2023 · N22859 · Substantial damage
  > The flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.
- [NTSB CEN23FA031](https://openairdocs.org/ntsb/CEN23FA031.md): Piper PA46-500TP · Bignell, NE · Accident · 2 fatal · Class 3 · Field · Final report · Nov 9, 2022 · N234PM · Destroyed
  > The pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.
- [NTSB CEN22LA341](https://openairdocs.org/ntsb/CEN22LA341.md): Cessna 421B · Riverdale, NE · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2022 · N21GF · Substantial damage
  > A total loss of engine power as a result of fuel exhaustion.
- [NTSB ERA22FA233](https://openairdocs.org/ntsb/ERA22FA233.md): Cessna 140 · Wayne, NE · Accident · 1 fatal · Class 3 · Field · Final report · May 20, 2022 · N76075 · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…
- [NTSB GAA19CA570](https://openairdocs.org/ntsb/GAA19CA570.md): Cirrus SR22 · Lexington, NE · Accident · Serious injuries · Data collection · Final report · Sep 25, 2019 · N1216N · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.
- [NTSB CEN19FA236](https://openairdocs.org/ntsb/CEN19FA236.md): Beech 95B55 · Chadron, NE · Accident · 3 fatal · Class 2 · Field · Final report · Jul 24, 2019 · N8910U · Substantial damage
  > The pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN19LA186](https://openairdocs.org/ntsb/CEN19LA186.md): Cessna 150 · Omaha, NE · Accident · No injuries · Class 3 · Limited · Final report · Jun 28, 2019 · N5256Q · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB CEN18FA126](https://openairdocs.org/ntsb/CEN18FA126.md): Rans S-16 Shekari · Pierce, NE · Accident · 1 fatal · Field investigation · Final report · Mar 21, 2018 · N741WT · Substantial damage
  > The pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.
- [NTSB CEN18LA085](https://openairdocs.org/ntsb/CEN18LA085.md): Quartz Mountain Aerospace L-11E · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Jan 24, 2018 · N515BW · Substantial damage
  > The instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB CEN16LA352](https://openairdocs.org/ntsb/CEN16LA352.md): Cameron Z90 · Morrill, NE · Accident · No injuries · Limited investigation · Final report · Sep 4, 2016 · N982ZS · Substantial damage
  > The pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.
- [NTSB CEN13LA109](https://openairdocs.org/ntsb/CEN13LA109.md): Beech A23 · Grand Isle, NE · Accident · No injuries · Limited investigation · Final report · Dec 18, 2012 · N3573R · Substantial damage
  > The student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.
- [NTSB CEN13FA081](https://openairdocs.org/ntsb/CEN13FA081.md): Ercoupe 415-C · Blair, NE · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2012 · N720RC · Substantial damage
  > The pilot's loss of control due to physical incapacitation.
- [NTSB CEN13FA045](https://openairdocs.org/ntsb/CEN13FA045.md): Cessna 150F · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Nov 4, 2012 · N8375G · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN12FA210](https://openairdocs.org/ntsb/CEN12FA210.md): Beech E-55 · Broken Bow, NE · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2012 · N1567W · Substantial damage
  > The pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…
- [NTSB CEN11LA089](https://openairdocs.org/ntsb/CEN11LA089.md): Cessna 180 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Dec 2, 2010 · N3246D · Substantial damage
  > A loss of engine power due to a stuck check valve in the carburetor acceleration pump, resulting in an improper fuel mixture when the pilot attempted to add power.
- [NTSB CEN09IA161](https://openairdocs.org/ntsb/CEN09IA161.md): Piper PA28 · Fairmont, NE · Incident · No injuries · Incident investigation · Final report · Feb 7, 2009 · N55502 · 2 aircraft · Minor damage
  > Both pilots' failure to see and avoid the other aircraft.
- [NTSB CHI07FA068](https://openairdocs.org/ntsb/CHI07FA068.md): Cessna 208B · Alliance, NE · Accident · Serious injuries · Field investigation · Final report · Feb 8, 2007 · N1116Y · Substantial damage
  > The pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.
- [NTSB CHI06CA169](https://openairdocs.org/ntsb/CHI06CA169.md): Beech 35-33 · Lincoln, NE · Accident · Serious injuries · Data collection · Final report · Jun 26, 2006 · N983T · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…
- [NTSB CHI06CA029](https://openairdocs.org/ntsb/CHI06CA029.md): Hughes 269A · Omaha, NE · Accident · No injuries · Data collection · Final report · Nov 5, 2005 · N1020Q · Substantial damage
  > The loss of engine power for an undetermined reason and the pilot's improper execution of the emergency procedure which resulted in an excessive descent rate and subsequent hard landing.
- [NTSB CHI05CA153](https://openairdocs.org/ntsb/CHI05CA153.md): S C Aerostar S A YAK-52 · Columbus, NE · Accident · Minor injuries · Data collection · Final report · Jun 21, 2005 · N962KY · Substantial damage
  > The mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.
- [NTSB CHI05LA088](https://openairdocs.org/ntsb/CHI05LA088.md): Air Tractor AT-602 · Imperial, NE · Accident · No injuries · Limited investigation · Final report · Apr 4, 2005 · N5015K · Substantial damage
  > The pilot's inadequate preflight planning which led to fuel exhaustion and subsequent loss of engine power. The soft ground was a factor.
- [NTSB CHI05LA050](https://openairdocs.org/ntsb/CHI05LA050.md): Cessna 551 · Ainsworth, NE · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 2005 · N35403 · Substantial damage
  > The pilot's decision to continue below the minimum descent altitude (MDA) and his failure to fly the published missed-approach procedure. A factor to the accident was the pilot's improper use of windshield heat which resulted in the windshield becoming…
- [NTSB CHI05LA030](https://openairdocs.org/ntsb/CHI05LA030.md): Hedge Bede-4 · Omaha, NE · Accident · 1 fatal · Limited investigation · Final report · Nov 13, 2004 · N435BD · Substantial damage
  > The pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.
- [NTSB CHI03LA152](https://openairdocs.org/ntsb/CHI03LA152.md): Zimmerman Glastar · Pierce, NE · Accident · No injuries · Limited investigation · Final report · Jun 7, 2003 · N109BZ · Substantial damage
  > The pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…
- [NTSB CHI01LA184](https://openairdocs.org/ntsb/CHI01LA184.md): Piper PA-32R-300 · Plattsmouth, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 2001 · N5659V · Substantial damage
  > the loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.
- [NTSB CHI01FA080](https://openairdocs.org/ntsb/CHI01FA080.md): Beech 58 · Ainsworth, NE · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2001 · N52BA · Destroyed
  > the pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.
- [NTSB CHI00LA272](https://openairdocs.org/ntsb/CHI00LA272.md): Piper PA-28-180 · Plattsmouth, NE · Accident · No injuries · Limited investigation · Final report · Aug 27, 2000 · N2451R · Substantial damage
  > the pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.
- [NTSB CHI98LA072](https://openairdocs.org/ntsb/CHI98LA072.md): Piper PA-30/A · Hastings, NE · Accident · 1 fatal · Limited investigation · Final report · Dec 24, 1997 · N9WG · Destroyed
  > The pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.
- [NTSB CHI98FA010](https://openairdocs.org/ntsb/CHI98FA010.md): Aero Commander 100-180 · Auburn, NE · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1997 · N4028X · Destroyed
  > the pilot misjudged distance/altitude to the runway, while on final approach to land, allowing the airplane to get too low and collide with a truck. A related factor was: the proximity of the truck (and highway) to the runway.
- [NTSB CHI95LA304](https://openairdocs.org/ntsb/CHI95LA304.md): Kevin Naser Renegade Spirit · Tekamah, NE · Accident · No injuries · Limited investigation · Final report · Sep 3, 1995 · N494KN · Substantial damage
  > the reason for the loss of engine power was undetermined.
- [NTSB CHI94FA128](https://openairdocs.org/ntsb/CHI94FA128.md): Piper PA-23-250 · Alliance, NE · Accident · 2 fatal · Field investigation · Final report · Apr 4, 1994 · N5399Y · Destroyed
  > The pilot's spatial disorientation and inadvertant entry into a spiral dive. Factors were the pilot's lack of total instrument experience and the weather conditions of blowing snow and turbulence.
- [NTSB CHI93FA302](https://openairdocs.org/ntsb/CHI93FA302.md): Rockwell 690-A · Norfolk, NE · Accident · 5 fatal · Field investigation · Final report · Jul 30, 1993 · N707BP · 2 aircraft · Destroyed
  > The failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…
- [NTSB CHI93LA117](https://openairdocs.org/ntsb/CHI93LA117.md): Cessna 150J · Hastings, NE · Accident · No injuries · Limited investigation · Final report · Mar 13, 1993 · N50467 · Substantial damage
  > The pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.
- [NTSB CHI92LA241](https://openairdocs.org/ntsb/CHI92LA241.md): Beech A36TC · Valentine, NE · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 1992 · N1812E · Destroyed
  > The pilot's failure to maintain adequate airspeed. Factors related to the accident were the weather obscuration and failure to attain proper runway alignment.
- [NTSB CHI91LA106](https://openairdocs.org/ntsb/CHI91LA106.md): Beech A36 · Ogallala, NE · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1991 · N6687U · Destroyed
  > Improper planning/decision by the pilot and the lack of sufficient airspeed to maneuver (circle to land) in unfavorable wind conditions with structural ice on the aircraft. The adverse weather conditions and structural (wing) ice were related factors.
- [NTSB CHI91LA068](https://openairdocs.org/ntsb/CHI91LA068.md): Cessna 182A · Chadron, NE · Accident · No injuries · Limited investigation · Final report · Jan 12, 1991 · N6082B · Substantial damage
  > An engine power loss for undetermined reasons.
- [NTSB MKC90LA040](https://openairdocs.org/ntsb/MKC90LA040.md): Piper PA-32-301 · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Dec 29, 1989 · N8157R · Substantial damage
  > Inproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…
- [NTSB MKC90LA010](https://openairdocs.org/ntsb/MKC90LA010.md): Cessna 172 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N5336R · Substantial damage
  > Failure of the throttle cable assembly which resulted in a forced landing and subsequent collision with a fence.
- [NTSB MKC89LA113](https://openairdocs.org/ntsb/MKC89LA113.md): American AA5-B · Valentine, NE · Accident · Minor injuries · Limited investigation · Final report · May 24, 1989 · N45278 · Substantial damage
  > The pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.
- [NTSB MKC89LA056](https://openairdocs.org/ntsb/MKC89LA056.md): Cessna 172 · Ainsworth, NE · Accident · No injuries · Limited investigation · Final report · Jan 29, 1989 · N4843G · Substantial damage
  > The loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.
- [NTSB MKC88LA177](https://openairdocs.org/ntsb/MKC88LA177.md): Aerospatiale TB-20 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N31TB · Substantial damage
  > The plt rprtd that when the acft was at aprx 150' to 200' AGL on final apch, the eng lost pwr & would not restart. Unable to rch the rwy, he lndd about 50' short on soft trrn, where the gear collapsed & the acft was dmgd. Only about 12 ounces of fuel was…
- [NTSB MKC88FA032](https://openairdocs.org/ntsb/MKC88FA032.md): Cessna 402C · Chadron, NE · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1987 · N105GP · Destroyed
  > The acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the…
- [NTSB MKC87LA127](https://openairdocs.org/ntsb/MKC87LA127.md): Cessna 150 · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N66686 · Substantial damage
  > After completing an IFR simulated NDB approach to runway 35L, PIC side-stepped to land VFR on 35R. During base leg acft had a partial power loss followed shortly by total power loss. PIC informed control tower of the emergency and made a forced ldg in a farm…
- [NTSB MKC86LA154](https://openairdocs.org/ntsb/MKC86LA154.md): Piper PA-23-250T · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Jul 22, 1986 · N62719 · Substantial damage
  > A fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…
- [NTSB MKC86FA101](https://openairdocs.org/ntsb/MKC86FA101.md): Aero Commander 680FL · Grand Island, NE · Accident · 1 fatal · Field investigation · Final report · May 9, 1986 · N1198Z · Destroyed
  > The twin eng acft crashed and burned 4 miles north of the arpt while on an instrument apch. The plt had transmitted that he had an engine problem. The #5 cylinder was found detached from the left engine but the left propeller was not feathered. An engine…
- [NTSB MKC86LA025](https://openairdocs.org/ntsb/MKC86LA025.md): Boeing 727-23 · Bellevue, NE · Accident · No injuries · Limited investigation · Final report · Nov 8, 1985 · N1908 · Substantial damage
  > During a night arrival, a Boeing 727, operating as American flt 334, was vectored for an apch to rwy 32L. While descending thru about 5000 ft MSL, aprx 12 mi south of the arpt, the acft reportedly collided with a flock of snow geese. The ATC controller had…
- [NTSB MKC85LA130](https://openairdocs.org/ntsb/MKC85LA130.md): Cessna 172M · Bingham, NE · Accident · No injuries · Limited investigation · Final report · Jun 13, 1985 · N80747 · Substantial damage
  > The plt reports that the acft began to settle while on final apch for landing. Full power was applied but the acft continued to settle. The acft hit nose gear collapsed and the acft nosed over. The plt had flown 11 hrs since receiving private plt certificate…
- [NTSB MKC85LA117](https://openairdocs.org/ntsb/MKC85LA117.md): Luscombe 8A · Harrison, NE · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N71407 · Substantial damage
  > The acft stalled during an attempted go-around. The plt initiated the go-around while attempting to land on rwy 30 with winds from 270 degs at 40 KTS gusting to 60 KTS. The acft stalled, contacted the rwy and veered left off the rwy surface. The plt received…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=NE&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" = 'NE' 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=NE

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