# NTSB investigations, NC: Unknown

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.

## Latest cases

- [NTSB ERA25FA260](https://openairdocs.org/ntsb/ERA25FA260.md): Cirrus Design SR22T · Sanford, NC · Accident · 4 fatal · Class 3 · Field · Preliminary report · Jul 7, 2025 · N5656M · Substantial damage
  > On July 7, 2025, about 1330 eastern daylight time, a Cirrus SR22T, N5656M, was substantially damaged when it was involved in an accident near Sanford, North Carolina. The private pilot and three passengers were fatally injured. The airplane was operated as a…
- [NTSB CEN25FA194](https://openairdocs.org/ntsb/CEN25FA194.md): Universal Stinson 108 · Farmington, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 3, 2025 · N40158 · Substantial damage
  > On June 3, 2025, about 1145 eastern daylight time, a Universal Stinson 108 airplane, N40518 was destroyed when it was involved in an accident near Farmington, North Carolina. The pilot and one passenger were fatally injured, and one passenger was seriously…
- [NTSB ATL05LA140](https://openairdocs.org/ntsb/ATL05LA140.md): Allegro 2000 · Supply, NC · Accident · 2 fatal · Limited investigation · Final report · Aug 7, 2005 · N9164M · Substantial damage
  > The instructor pilot's failure to maintain airspeed for unknown reasons, resulting in an aerodynamic stall and subsequent collision with the ground.
- [NTSB MIA01LA026](https://openairdocs.org/ntsb/MIA01LA026.md): J and J Tukan · Hayesville, NC · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2000 · UNREG · Destroyed
  > The ultralight pilot's in-flight loss of control for unknown reasons resulting in an in-flight collision with the terrain.
- [NTSB MIA00LA013](https://openairdocs.org/ntsb/MIA00LA013.md): British Aerospace HS 125-700A · Fayetteville, NC · Accident · No injuries · Limited investigation · Final report · Oct 19, 1999 · N34GG · Substantial damage
  > The overstress failure of the lugs of the cylinder head of the left main landing gear jack for undetermined reasons. Also, inability of the flight crew to extend the left main landing gear.
- [NTSB ATL86FA064](https://openairdocs.org/ntsb/ATL86FA064.md): Piper PA-32RT-300T · Milwaukee, NC · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1986 · N222HD · Destroyed
  > The acft was observed to descend and level off at low alt. Witnesses indicated that it leveled off just above the trees, then rolled to the right and dove into wooded terrain. The eng was reported to be running loud and steady until impact. No preimpact part…
- [NTSB ATL86FMG04](https://openairdocs.org/ntsb/ATL86FMG04.md): Cessna 177RG · Kenansville, NC · Accident · No injuries · Final report · Nov 11, 1985 · N2012Q · Substantial damage
  > The acft contacted two piles of dirt during a gear-up landing. The plt took off with intensions of practicing touch and go landings. On the second apch, the plt was unable to fully extend the landing gear. The plt had one passenger check the hydraulic fluid…
- [NTSB ATL83FA366](https://openairdocs.org/ntsb/ATL83FA366.md): Pterodactyl/Lambert None · Mt. Holly, NC · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1983 · N2084Q · Destroyed
  > The plt was on a x-country accompanied by a plt in another ultralight vehicle. The accident acft was faster, so the plt maneuvered around while en route. During a turn, the accident vehicle got out of sight from the plt of the other vehicle & became…
- [NTSB ATL81IA004](https://openairdocs.org/ntsb/ATL81IA004.md): Fairchild F-27 · Raliegh, NC · Incident · No injuries · Closed · Oct 9, 1980 · N112TA · Minor damage
- [NTSB IAD80FA041](https://openairdocs.org/ntsb/IAD80FA041.md): Cessna 182 · Waynesville, NC · Accident · 2 fatal · Closed · May 31, 1979 · N618WC · Destroyed
- [NTSB DIA70F0034](https://openairdocs.org/ntsb/DIA70F0034.md): Piper J3C-65 · Clayton, NC · Accident · 1 fatal · Closed · Jul 10, 1969 · N70684 · Destroyed
- [NTSB DIA68A0052](https://openairdocs.org/ntsb/DIA68A0052.md): Piper PA-23 · New Bern, NC · Accident · 1 fatal · Closed · Jun 21, 1968 · N5355Y · Destroyed
- [NTSB MIA67A0152](https://openairdocs.org/ntsb/MIA67A0152.md): Cessna 172 · Hatteras, NC · Accident · 2 fatal · Closed · Jun 26, 1966 · N4106F · Destroyed
- [NTSB MIA66F0144](https://openairdocs.org/ntsb/MIA66F0144.md): Stinson 108 · Booneville, NC · Accident · Serious injuries · Closed · Jul 5, 1965 · N8450K · Substantial damage

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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