# NTSB investigations, NC: 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 10 · 480 cases

## Latest cases

- [NTSB WPR26LA347](https://openairdocs.org/ntsb/WPR26LA347.md): Bell 206B-III · Creswell, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 18, 2026 · N50141 · Substantial damage
  > On September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…
- [NTSB ERA26LA143](https://openairdocs.org/ntsb/ERA26LA143.md): Cessna 172 · Carthage, NC · Accident · No injuries · Class 4 · Limited · Final report · Mar 1, 2026 · N972WW · Substantial damage
  > The pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.
- [NTSB ERA25FA352](https://openairdocs.org/ntsb/ERA25FA352.md): Cirrus Design SR22T · Franklin, NC · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 18, 2025 · N218VB · Substantial damage
  > On September 18, 2025, at 1456 eastern daylight time, a Cirrus SR22T, N218VB, was substantially damaged when it was involved in an accident near Franklin, North Carolina. The private pilot and two passengers were fatally injured. The airplane was operated as…
- [NTSB ERA25LA183](https://openairdocs.org/ntsb/ERA25LA183.md): Frank Lowell C Pietenpol · Taylorsville, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 18, 2025 · N497AR · Substantial damage
  > The pilot’s failure to maintain control of the airplane during an attempted go around in gusty tailwind conditions, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA25LA007](https://openairdocs.org/ntsb/ERA25LA007.md): North American Navion · Rutherfordton, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 3, 2024 · N9117R · Substantial damage
  > An in-flight fire, the origin of which could not be determined based on the available evidence.
- [NTSB ERA24LA307](https://openairdocs.org/ntsb/ERA24LA307.md): Beech 95-B55 · Greenville, NC · Accident · No injuries · Class 4 · Limited · Final report · Jul 1, 2024 · N9308Q · Substantial damage
  > A landing with the nose gear retracted as a result of an intermittent landing gear relay.
- [NTSB ERA24FA261](https://openairdocs.org/ntsb/ERA24FA261.md): Piper PA28 · Siler City, NC · Accident · 2 fatal · Class 3 · Field · Final report · Jun 14, 2024 · N515DH · Destroyed
  > The flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.
- [NTSB ERA24LA203](https://openairdocs.org/ntsb/ERA24LA203.md): Robinson Helicopter R22 Beta · Louisburg, NC · Accident · No injuries · Class 4 · Limited · Final report · Apr 30, 2024 · N7535Z · Substantial damage
  > The pilot under instruction’s inadvertent use of the mixture control, which resulted in a total loss of engine power.
- [NTSB ERA24LA186](https://openairdocs.org/ntsb/ERA24LA186.md): Cessna 210 · Concord, NC · Accident · No injuries · Class 4 · Limited · Final report · Apr 12, 2024 · N777NT · Substantial damage
  > Failure of a landing gear extension system hydraulic hose, which resulted in a landing with the landing gear retracted.
- [NTSB ERA24LA151](https://openairdocs.org/ntsb/ERA24LA151.md): Palmetto Electronics X-AIR H · Ellenboro, NC · Accident · No injuries · Class 3 · Limited · Final report · Mar 4, 2024 · N3505W · Substantial damage
  > A total loss of engine power due to an inoperative ignition system.
- [NTSB ERA24LA090](https://openairdocs.org/ntsb/ERA24LA090.md): Cessna 172 · Mooresville, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 14, 2024 · N512SP · Substantial damage
  > The pilot’s failure to maintain control of the airplane during a go-around in gusting crosswind conditions.
- [NTSB ERA23LA316](https://openairdocs.org/ntsb/ERA23LA316.md): Cessna 152 · Maiden, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 27, 2023 · N6194Q · Substantial damage
  > The flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.
- [NTSB ERA23LA218](https://openairdocs.org/ntsb/ERA23LA218.md): Piper PA-28-180 · Greenville, NC · Accident · Serious injuries · Class 3 · Limited · Final report · May 5, 2023 · N180LR · Substantial damage
  > Inadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.
- [NTSB ERA23LA089](https://openairdocs.org/ntsb/ERA23LA089.md): Piper PA-38-112 · Rockingham, NC · Accident · No injuries · Class 4 · Limited · Final report · Dec 13, 2022 · N498DS · Substantial damage
  > The pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA23LA009](https://openairdocs.org/ntsb/ERA23LA009.md): Swensen Fisher Celebrity · Greensboro, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 6, 2022 · N655WP · Substantial damage
  > The pilot/mechanic’s failure to remove excess sealant from the header fuel tank after recent maintenance, which resulted in fuel starvation to the engine and a loss of engine power. Contributing to the accident was the pilot’s inflight decision making…
- [NTSB ERA22LA356](https://openairdocs.org/ntsb/ERA22LA356.md): Cessna 182C · Holly Ridge, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 4, 2022 · N8865T · Substantial damage
  > The pilot’s failure to maintain clearance of powerlines on final approach.
- [NTSB ERA22LA348](https://openairdocs.org/ntsb/ERA22LA348.md): CASA C212 · Raeford, NC · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 29, 2022 · N497CA · Substantial damage
  > The airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.
- [NTSB ERA22LA276](https://openairdocs.org/ntsb/ERA22LA276.md): Piper PA-28-180 · Laurinburg, NC · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2022 · N9676J · Substantial damage
  > The pilot’s decision to depart with insufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion on final approach for landing.
- [NTSB ERA22LA177](https://openairdocs.org/ntsb/ERA22LA177.md): Cessna 170 · Stoney Point, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 2, 2022 · N2656V · Substantial damage
  > The pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.
- [NTSB ERA22LA130](https://openairdocs.org/ntsb/ERA22LA130.md): Piper PA32R · Washington, NC · Accident · No injuries · Class 4 · Limited · Final report · Feb 16, 2022 · N114BR · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.
- [NTSB ERA22LA125](https://openairdocs.org/ntsb/ERA22LA125.md): Cirrus Design SR22 · Pinehurst, NC · Accident · No injuries · Class 4 · Limited · Final report · Feb 9, 2022 · N987AA · Substantial damage
  > The in-flight encounter while on final approach with high-speed trailing vortices from a military helicopter, resulting in abnormal runway contact. Contributing to the accident was the Cirrus pilot’s incorrect selection of the common traffic advisory…
- [NTSB ERA22LA124](https://openairdocs.org/ntsb/ERA22LA124.md): Cessna 172RG · Rocky Mount, NC · Accident · No injuries · Class 4 · Limited · Final report · Feb 6, 2022 · N9382D · Substantial damage
  > An inflight collision with a bird, which resulted in substantial damage to the left wing.
- [NTSB ERA22LA110](https://openairdocs.org/ntsb/ERA22LA110.md): Miller Roger Thatcher CX4 · Angier, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 18, 2022 · N254RM · Substantial damage
  > The pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.
- [NTSB ERA22LA046](https://openairdocs.org/ntsb/ERA22LA046.md): Cessna 150M · Margarettsville, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 4, 2021 · N704HQ · Substantial damage
  > The pilot’s delayed application of carburetor heat during the descent, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB DCA21LA109](https://openairdocs.org/ntsb/DCA21LA109.md): Embraer EMB-145LR · Charlotte, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 28, 2021 · N650AE · No damage
  > an encounter with convective turbulence during descent.
- [NTSB ERA21LA089](https://openairdocs.org/ntsb/ERA21LA089.md): Glasflugel Club Libelle 205 · Bunn, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 27, 2020 · N205HL · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees during an off-airport landing.
- [NTSB ERA21LA042](https://openairdocs.org/ntsb/ERA21LA042.md): Republic RC3 · Advance, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 16, 2020 · N451E · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA21LA040](https://openairdocs.org/ntsb/ERA21LA040.md): Bell 206 · Raleigh, NC · Accident · No injuries · Class 4 · Limited · Final report · Nov 8, 2020 · N123NC · Substantial damage
  > The pilot's loss of helicopter control after entry into vortex ring state, which resulted in main rotor blade contact with the tailboom, and impact with the ground.
- [NTSB ERA20LA336](https://openairdocs.org/ntsb/ERA20LA336.md): Cessna 172 · La Grange, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 23, 2020 · N5439E · Substantial damage
  > The pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.
- [NTSB ERA20FA014](https://openairdocs.org/ntsb/ERA20FA014.md): Piper PA32 · Raleigh, NC · Accident · 2 fatal · Class 3 · Field · Final report · Oct 20, 2019 · N534Z · Destroyed
  > The pilot’s failure to maintain a safe glidepath during final approach to the runway, which resulted in a collision with trees and terrain. Contributing was the pilot’s lack of recent instrument flight experience.
- [NTSB ERA20FA009](https://openairdocs.org/ntsb/ERA20FA009.md): Vans RV4 · Cameron, NC · Accident · 1 fatal · Class 3 · Field · Final report · Oct 14, 2019 · N4332J · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack during the landing approach, which resulted in a loss of control and a subsequent aerodynamic stall/spin. Contributing to the accident was the pilot's decision to fly the airplane in a…
- [NTSB ERA19LA247](https://openairdocs.org/ntsb/ERA19LA247.md): Fantasy Air Allegro · Boone, NC · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 14, 2019 · N5020X · Destroyed
  > The reported total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA19FA201](https://openairdocs.org/ntsb/ERA19FA201.md): Beech E55 · Hope Mills, NC · Accident · 2 fatal · Class 2 · Field · Final report · Jun 27, 2019 · N664AR · Destroyed
  > The pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.
- [NTSB ERA19LA157](https://openairdocs.org/ntsb/ERA19LA157.md): Barrows Bearhawk LSA · Holly Springs, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 22, 2019 · N289EH · Substantial damage
  > The pilot's failure to maintain clearance from powerlines during the visual approach.
- [NTSB GAA18CA394](https://openairdocs.org/ntsb/GAA18CA394.md): Evektor Aerotechnik Sportstar · Louisburg, NC · Accident · No injuries · Data collection · Final report · Jul 5, 2018 · N902HB · Substantial damage
  > The student pilot's distraction due to a previous runway excursion and navigational issues during the accident flight and his failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the downwind leg, which…
- [NTSB ERA18TA059](https://openairdocs.org/ntsb/ERA18TA059.md): Cessna 172 · Union Mills, NC · Accident · Minor injuries · Final report · Dec 24, 2017 · N91SP · Substantial damage
  > The pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.
- [NTSB ERA18LA026](https://openairdocs.org/ntsb/ERA18LA026.md): Piper PA28 · Bladenboro, NC · Accident · No injuries · Limited investigation · Final report · Nov 18, 2017 · N8758N · Substantial damage
  > A loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.
- [NTSB ERA18FA012](https://openairdocs.org/ntsb/ERA18FA012.md): Beech 35C33 · Whiteville, NC · Accident · 1 fatal · Field investigation · Final report · Oct 31, 2017 · N293GC · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…
- [NTSB ERA17FA123](https://openairdocs.org/ntsb/ERA17FA123.md): Jordan Bruce C Pitts S2E · Apex, NC · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2017 · N30BJ · Substantial damage
  > The pilot's failure to maintain airplane control during the final approach to the runway in gusting tailwind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB GAA17CA140](https://openairdocs.org/ntsb/GAA17CA140.md): Cessna 172 · Burlington, NC · Accident · No injuries · Data collection · Final report · Feb 16, 2017 · N381MG · Substantial damage
  > The pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.
- [NTSB ERA16LA085](https://openairdocs.org/ntsb/ERA16LA085.md): Cirrus SR22 · Concord, NC · Accident · No injuries · Class 3 · Limited · Final report · Jan 8, 2016 · C-GXXJ · Substantial damage
  > The pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.
- [NTSB DCA16CA053](https://openairdocs.org/ntsb/DCA16CA053.md): Boeing 737 7H4 · Charlotte, NC · Accident · Serious injuries · Data collection · Final report · Dec 23, 2015 · N475WN · No damage
  > An inadvertent encounter with clear air turbulence.
- [NTSB ERA16LA067](https://openairdocs.org/ntsb/ERA16LA067.md): Golden Circle Air T Bird II · Lenoir, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 2015 · N92744 · Destroyed
  > The pilot’s failure to maintain airspeed and a coordinated turn in the traffic pattern, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to…
- [NTSB ERA16LA045](https://openairdocs.org/ntsb/ERA16LA045.md): Phantom Aeronautics Phantom X 1 · Monroe, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 21, 2015 · N28365 · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any preimpact anomalies that would have precluded normal operation.
- [NTSB ERA16CA011](https://openairdocs.org/ntsb/ERA16CA011.md): Piper PA-32RT-300T · Salisbury, NC · Accident · No injuries · Data collection · Final report · Oct 13, 2015 · N300KG · Substantial damage
  > The pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA15FA340](https://openairdocs.org/ntsb/ERA15FA340.md): Beech A36 · Kernersville, NC · Accident · 3 fatal · Field investigation · Final report · Sep 7, 2015 · N36HT · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…
- [NTSB ERA15LA343](https://openairdocs.org/ntsb/ERA15LA343.md): Dehavilland DHC-6 · Louisburg, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2015 · N181CS · Substantial damage
  > The propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.
- [NTSB DCA15LA173](https://openairdocs.org/ntsb/DCA15LA173.md): Airbus A321 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Aug 15, 2015 · N564UW · Substantial damage
  > an encounter with a small microburst on short final at low altitude that resulted in a loss of lift and a tail strike during the go-around. Contributing to the accident was the captain's decision to continue the approach without applying appropriate windshear…
- [NTSB ERA15LA231](https://openairdocs.org/ntsb/ERA15LA231.md): Beech A36 · Siler City, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2015 · N985K · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.
- [NTSB GAA15CA017](https://openairdocs.org/ntsb/GAA15CA017.md): American Champion 7GCAA · Greensboro, NC · Accident · No injuries · Data collection · Final report · Mar 18, 2015 · N43MT · Substantial damage
  > The pilot's failure to maintain directional/pitch control during final approach, resulting in a collision with terrain.

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

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