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

## Latest cases

- [NTSB ERA27LA007](https://openairdocs.org/ntsb/ERA27LA007.md): Piper PA-32-260 · Whiteville, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 8, 2026 · N31RF · Substantial damage
  > On October 7, 2026, at 2219 eastern daylight time, a Piper PA-32-260, N31RF, was substantially damaged when it was involved in an accident near Whiteville, North Carolina. The private pilot and one passenger sustained minor injuries. The airplane was operated…
- [NTSB ERA26LA323](https://openairdocs.org/ntsb/ERA26LA323.md): Mooney M-20 · Stanfield, NC · Accident · No injuries · Class 4 · Limited · Final report · Sep 1, 2026 · N3706N · Substantial damage
  > The pilot’s failure to adequately manage the available fuel onboard the airplane, which resulted in a total loss of power due to fuel starvation and a forced landing on uneven terrain.
- [NTSB ANC26LA080](https://openairdocs.org/ntsb/ANC26LA080.md): Piper PA-32-260 · Pinetown, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 6, 2026 · N8791E · Substantial damage
  > On August 6, 2026, about 1355 eastern daylight time, a Piper Aircraft PA-32-260 airplane, N8791E, was substantially damaged when it was involved in an accident near Pinetown, North Carolina. The private pilot and two passengers sustained minor injuries. The…
- [NTSB ERA26LA191](https://openairdocs.org/ntsb/ERA26LA191.md): Beech F33A · Sanford, NC · Accident · No injuries · Class 4 · Limited · Final report · Apr 24, 2026 · N85WM · Substantial damage
  > A loss of electrical power as a result of broken stator leads within the alternator, which resulted in the pilot’s inability to extend the airplane’s landing gear.
- [NTSB CEN26LA162](https://openairdocs.org/ntsb/CEN26LA162.md): Lancair IV · Camden, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 4, 2026 · N94PT · Substantial damage
  > On April 04, 2026, 1155 local, a Lancair IV, N94PT, sustained substantial damage when it was involved in a forced landing on Scotland Road, Camden, North Carolina. The pilot and passenger on board sustained no injuries. The flight was conducted under Title 14…
- [NTSB ERA26LA138](https://openairdocs.org/ntsb/ERA26LA138.md): Glasflugel Kestrel · Little Switzerland, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 5, 2026 · N9919 · Substantial damage
  > A loss of thermal lift during a glider flight, which resulted in a collision with trees during a landing approach to a diversionary airport.
- [NTSB ENG26LA018](https://openairdocs.org/ntsb/ENG26LA018.md): Airbus A319 · Charlotte, NC · Incident · Class 4 · Limited · Investigation open · Feb 11, 2026 · N9010R
- [NTSB ERA25LA289](https://openairdocs.org/ntsb/ERA25LA289.md): Jabiru Aircraft PTY J230-D · Oak Island, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 2, 2025 · N784J · Substantial damage
  > On August 2, 2025, about 1925 eastern daylight time, a Jabiru Aircraft Pty Ltd J-230-D, N784J, was substantially damaged when it was involved in an accident near Oak Island, North Carolina. The private pilot received minor injuries. The airplane was operated…
- [NTSB ERA25FA231](https://openairdocs.org/ntsb/ERA25FA231.md): Pitts S2 · Broadway, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 20, 2025 · N79AV · Substantial damage
  > On June 20, 2025, at 0900 eastern daylight time, a Pitts Aerobatics S-2B, N79AV, was destroyed when it was involved in an accident near Broadway, North Carolina. The private pilot and the commercial pilot-rated passenger were fatally injured. The airplane was…
- [NTSB ERA25LA157](https://openairdocs.org/ntsb/ERA25LA157.md): Beech E33 · Lenoir, NC · Accident · No injuries · Class 3 · Limited · Final report · Feb 25, 2025 · N7697N · Substantial damage
  > The mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.
- [NTSB ERA25LA126](https://openairdocs.org/ntsb/ERA25LA126.md): Eurocopter Deutschland EC 135 P2+ · Hampstead, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Feb 25, 2025 · N930NH · Substantial damage
  > On February 24, 2025, about 1945 eastern standard time, a Eurocopter Deutschland GMBH EC 135P2+, N930NH, was destroyed when it was involved in an accident near Hampstead, North Carolina. The pilot, flight paramedic, and flight nurse were seriously injured.…
- [NTSB ERA25LA087](https://openairdocs.org/ntsb/ERA25LA087.md): Cessna 172K · Southport, NC · Accident · No injuries · Class 4 · Limited · Final report · Dec 19, 2024 · N7085G · Substantial damage
  > The pilot’s loss of aircraft control due to spatial disorientation, and the flight instructor’s inadequate supervision, which resulted in the subsequent overstress of the airplane during recovery.
- [NTSB ERA24LA311](https://openairdocs.org/ntsb/ERA24LA311.md): Champion 7ECA · Beaufort, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 21, 2024 · N9581S · Substantial damage
  > The pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.
- [NTSB ERA24FA294](https://openairdocs.org/ntsb/ERA24FA294.md): Cessna 182 · Rutherfordton, NC · Accident · 3 fatal · Class 3 · Field · Final report · Jul 8, 2024 · N2198G · Substantial damage
  > The pilot’s failure to maintain clearance from clouds, resulting in controlled flight into terrain due to mountain obscuration.
- [NTSB ERA24LA289](https://openairdocs.org/ntsb/ERA24LA289.md): Cessna 172 · Lewiston Woodville, NC · Accident · No injuries · Class 3 · Limited · Final report · Jun 29, 2024 · N46118 · Substantial damage
  > The obstruction of the engine’s cooling system by foreign object debris (residential-type insulation), which resulted in smoke, an elevated oil temperature, and a subsequent off-airport landing on unsuitable terrain.
- [NTSB ERA24LA179](https://openairdocs.org/ntsb/ERA24LA179.md): Cessna R172 · Rocky Mount, NC · Accident · No injuries · Class 3 · Limited · Final report · Apr 15, 2024 · N3FR · Substantial damage
  > The pilot and mechanic’s failure to identify and completely eliminate the water and debris contamination present in the airplane’s fuel system before embarking on the flight, which resulted in a total loss of engine power.
- [NTSB DCA24LA144](https://openairdocs.org/ntsb/DCA24LA144.md): Boeing 717-200 · Cecil, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 3, 2024 · N899AT · No damage
  > An encounter with clear air turbulence.
- [NTSB ERA24FA078](https://openairdocs.org/ntsb/ERA24FA078.md): Piper PA46R-350T · Mooresville, NC · Accident · 1 fatal · Class 3 · Field · Final report · Dec 31, 2023 · N539MA · Substantial damage
  > A missing induction clamp, which allowed the induction hose to the left side intercooler to become disconnected, resulting in a total loss of engine power due to an overly rich fuel/air mixture.
- [NTSB ERA23LA338](https://openairdocs.org/ntsb/ERA23LA338.md): Stephen J Moorman Just Aircraft Highla · Edenton, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 13, 2023 · N169SM · Substantial damage
  > The pilot’s inadequate fuel planning, which led to a total loss of engine power due to fuel exhaustion.
- [NTSB ERA23LA310](https://openairdocs.org/ntsb/ERA23LA310.md): Piper PA-28-140 · New London, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 24, 2023 · N98134 · Substantial damage
  > A partial loss of engine power due to the No. 4 cylinder’s stuck exhaust valve.
- [NTSB ERA23FA238](https://openairdocs.org/ntsb/ERA23FA238.md): Beech V35 · Rougemont, NC · Accident · 1 fatal · Class 3 · Field · Final report · May 21, 2023 · N272S · Destroyed
  > A total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.
- [NTSB ERA23LA241](https://openairdocs.org/ntsb/ERA23LA241.md): Burril Benjamin D BDB001 · Wadesboro, NC · Accident · Minor injuries · Class 3 · Limited · Final report · May 17, 2023 · N191CK · Substantial damage
  > A reported total loss of engine power and a subsequent forced landing for reasons that could not be determined because the pilot did not make the wreckage available for examination.
- [NTSB ERA23LA147](https://openairdocs.org/ntsb/ERA23LA147.md): Eurocopter Deutschland EC 135 P2+ · Franklin, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 9, 2023 · N558MT · Substantial damage
  > The pilot’s improper decision to review an aircraft logbook while enroute, which resulted in controlled flight into terrain.
- [NTSB ERA22LA427](https://openairdocs.org/ntsb/ERA22LA427.md): Northwing Design Apache Sport · Southern Shores, NC · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 21, 2022 · N3283N · Substantial damage
  > A loss of aircraft control due to movement of the outer portion of the right wing fabric and displacement of wing ribs for reasons that could not be determined based on the available information.
- [NTSB ERA22LA406](https://openairdocs.org/ntsb/ERA22LA406.md): Cessna 177B · Ivanhoe, NC · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 5, 2022 · N35243 · Substantial damage
  > The pilot's inadequate preflight and inflight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA22LA277](https://openairdocs.org/ntsb/ERA22LA277.md): Hawker Hunter · Wilmington, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 20, 2022 · N337AX · Substantial damage
  > A bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.
- [NTSB ERA22LA268](https://openairdocs.org/ntsb/ERA22LA268.md): Wingren Norman Escapade · Brasstown, NC · Accident · No injuries · Class 3 · Limited · Final report · May 9, 2022 · N86RD · Substantial damage
  > The failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.
- [NTSB ERA22LA120](https://openairdocs.org/ntsb/ERA22LA120.md): Pilatus PC-12/47E · Beaufort, NC · Accident · 8 fatal · Class 3 · Limited · Final report · Feb 13, 2022 · N79NX · Destroyed
  > The pilot’s inadequate preflight planning, inadequate inflight monitoring of the airplane’s flight parameters, and his failure to regain control of the airplane following entry into an inadvertent aerodynamic stall. The pilot’s likely spatial disorientation…
- [NTSB ERA21LA297](https://openairdocs.org/ntsb/ERA21LA297.md): Cessna 150 · Arden, NC · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2021 · N3059X · Substantial damage
  > The inadequate inspection of the throttle control cable assembly, which resulted in a partial loss of engine power during cruise flight.
- [NTSB ERA21LA298](https://openairdocs.org/ntsb/ERA21LA298.md): Carpenter Stol CH750 · Rockwell, NC · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2021 · N750RS · Substantial damage
  > The total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.
- [NTSB ERA21LA295](https://openairdocs.org/ntsb/ERA21LA295.md): Robinson Helicopter R44 II · Point Harbor, NC · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 19, 2021 · N4529J · Destroyed
  > The noncertificated pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation over a large body of water and a high velocity impact with the water. Contributing to the accident…
- [NTSB ERA21LA075](https://openairdocs.org/ntsb/ERA21LA075.md): Kolb Firestar · Durham, NC · Accident · No injuries · Class 3 · Limited · Final report · Dec 11, 2020 · N7094T · Substantial damage
  > A total loss of engine power due to fuel starvation as the result of a degraded fuel primer check valve.
- [NTSB ERA21LA047](https://openairdocs.org/ntsb/ERA21LA047.md): American Legend AL3 · Greenville, NC · Accident · No injuries · Class 4 · Limited · Final report · Nov 16, 2020 · N30BX · Substantial damage
  > The airplane’s collision with a bird during initial climb, which resulted in a forced landing.
- [NTSB ERA20LA295](https://openairdocs.org/ntsb/ERA20LA295.md): Aeronca 11AC · Nebo, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 22, 2020 · N86002 · Substantial damage
  > A leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA20CA226](https://openairdocs.org/ntsb/ERA20CA226.md): Cessna 150 · Shelby, NC · Accident · No injuries · Class 4 · Data collection · Final report · Jun 22, 2020 · N1718Q · Substantial damage
  > The pilot's inadequate preflight and inflight fuel planning, which resulted in fuel exhaustion.
- [NTSB ERA20LA134](https://openairdocs.org/ntsb/ERA20LA134.md): Maule MT-7 · Swansboro, NC · Accident · 2 fatal · Class 3 · Limited · Final report · Mar 24, 2020 · N899ZZ · Destroyed
  > The airplane’s turning descent into water while enroute in night instrument meteorological conditions for reasons that could not be determined.
- [NTSB DCA20CA071](https://openairdocs.org/ntsb/DCA20CA071.md): Bombardier CL-600-2D24 · Waynesville, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 7, 2020 · N610NN · Minor damage
  > An encounter with severe convective turbulence associated with a strong sheared environment associated with the jet stream.
- [NTSB ERA20LA064](https://openairdocs.org/ntsb/ERA20LA064.md): Cirrus SR22 · Kenansville, NC · Accident · No injuries · Class 3 · Limited · Final report · Jan 2, 2020 · N323SR · Substantial damage
  > A fatigue failure of the camshaft due to a manufacturing defect, which resulted in a partial loss of engine power.
- [NTSB ERA19LA257](https://openairdocs.org/ntsb/ERA19LA257.md): Cirrus SR22 · Burnsville, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 22, 2019 · N404PE · Substantial damage
  > The pilot’s reliance on latent satellite weather imagery for tactical weather avoidance, which resulted in flight into thunderstorms and a loss of control. Also causal was an engine overspeed during the uncontrolled descent, which resulted in catastrophic…
- [NTSB ERA19FA188](https://openairdocs.org/ntsb/ERA19FA188.md): Piper PA46 · Castalia, NC · Accident · 4 fatal · Class 3 · Field · Final report · Jun 7, 2019 · N709CH · Destroyed
  > The pilot’s failure to navigate around hazardous weather, resulting in the penetration of a thunderstorm, a loss of airplane control, and an inflight breakup. The air traffic controller’s failure to provide the pilot with adequate and timely weather…
- [NTSB ERA19LA159](https://openairdocs.org/ntsb/ERA19LA159.md): Zenair Zodiac CH601 · Angier, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 27, 2019 · N61PG · Substantial damage
  > A partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.
- [NTSB ERA19FA130](https://openairdocs.org/ntsb/ERA19FA130.md): Mooney M20C · Cashiers, NC · Accident · 1 fatal · Class 3 · Field · Final report · Mar 14, 2019 · N6075Q · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.
- [NTSB ERA19LA095](https://openairdocs.org/ntsb/ERA19LA095.md): Cessna 150 · Knotts Island, NC · Accident · No injuries · Class 3 · Limited · Final report · Feb 2, 2019 · N6789F · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot's improper fuel planning.
- [NTSB ERA19TA051](https://openairdocs.org/ntsb/ERA19TA051.md): Cessna E162 · Franklin, NC · Accident · Minor injuries · Final report · Nov 16, 2018 · N70252 · Substantial damage
  > The pilot's delay in applying carburetor heat, which resulted in a total loss of engine power during descent due to carburetor icing.
- [NTSB ERA18LA239](https://openairdocs.org/ntsb/ERA18LA239.md): Avid MK-4 · Harnett, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 30, 2018 · N628X · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA224](https://openairdocs.org/ntsb/ERA18LA224.md): Glasair SHA · Greenville, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 18, 2018 · N38WS · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s misjudgment of the airplane’s glidepath during the forced landing, which resulted in the airplane touching…
- [NTSB GAA18CA475](https://openairdocs.org/ntsb/GAA18CA475.md): Beech B300 · Wilmington, NC · Accident · No injuries · Data collection · Final report · Aug 1, 2018 · N557AP · Substantial damage
  > The airplane’s collision with a bird during approach.
- [NTSB DCA18CA251](https://openairdocs.org/ntsb/DCA18CA251.md): Mcdonnell Douglas MD88 · Charlotte, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Jul 23, 2018 · N918DE · No damage
  > An inadvertent encounter with convective turbulence.
- [NTSB WPR18LA194](https://openairdocs.org/ntsb/WPR18LA194.md): Piper PA32 · Salisbury, NC · Accident · No injuries · Class 3 · Limited · Final report · Jun 29, 2018 · N8440F · Substantial damage
  > A total loss of engine power due to fuel starvation for reasons that could not be determined based on the available information.
- [NTSB ERA18LA055](https://openairdocs.org/ntsb/ERA18LA055.md): Cessna 182 · Burlington, NC · Accident · No injuries · Limited investigation · Final report · Dec 16, 2017 · N199RN · 2 aircraft · Substantial damage
  > The pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright.

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

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