# NTSB investigations, NC: Initial climb

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 8 · 384 cases

## Latest cases

- [NTSB ERA26LA219](https://openairdocs.org/ntsb/ERA26LA219.md): Rainbow Cheetah XLS · Knightdale, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 27, 2026 · N146RC · Substantial damage
  > On May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were…
- [NTSB ERA26LA211](https://openairdocs.org/ntsb/ERA26LA211.md): Patsch Thorp T-18 · Hendersonville, NC · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N2KP · Substantial damage
  > On May 15, 2026, about 1853 eastern daylight time, an experimental amateur-built Thorp T-18, N2KP, was substantially damaged when it was involved in an accident near Hendersonville, North Carolina. The commercial pilot was not injured. The airplane was…
- [NTSB ERA26LA144](https://openairdocs.org/ntsb/ERA26LA144.md): Piper PA-28-140 · Indian Trail, NC · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N98360 · Substantial damage
  > On March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…
- [NTSB ERA26LA008](https://openairdocs.org/ntsb/ERA26LA008.md): Champion 7ECA · East Rockingham, NC · Accident · No injuries · Class 4 · Limited · Final report · Oct 7, 2025 · N63BC · Substantial damage
  > The pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.
- [NTSB ERA25LA198](https://openairdocs.org/ntsb/ERA25LA198.md): Diamond Aircraft Ind DA 40 NG · Sanford, NC · Accident · Serious injuries · Class 3 · Limited · Final report · May 7, 2025 · N499BW · Substantial damage
  > The mechanic’s re-use of worm drive clamps, which resulted in a separation of the turbocharger air discharge duct and a partial loss of engine power during initial climb.
- [NTSB ERA25LA188](https://openairdocs.org/ntsb/ERA25LA188.md): Cessna 172RG · Louisburg, NC · Accident · No injuries · Class 3 · Limited · Final report · Apr 23, 2025 · N6386V · Substantial damage
  > Maintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.
- [NTSB ERA25LA164](https://openairdocs.org/ntsb/ERA25LA164.md): Cessna 172N · Hickory, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 1, 2025 · N79514 · Substantial damage
  > The student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.
- [NTSB ERA25FA143](https://openairdocs.org/ntsb/ERA25FA143.md): Raytheon A36 · Greenville, NC · Accident · 2 fatal · Class 3 · Field · Final report · Mar 14, 2025 · N566C · Destroyed
  > The pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).
- [NTSB ERA25LA062](https://openairdocs.org/ntsb/ERA25LA062.md): Alexander S Rolinski BOT Journey · Ocean Isle Beach, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 27, 2024 · N814B · Substantial damage
  > Maintenance personnel’s failure to identify and remediate a buildup of oxides in one of the engine’s carburetors, which resulted in the seizure of the carburetor’s piston slide and a subsequent total loss of engine power during initial climb.
- [NTSB ERA24LA230](https://openairdocs.org/ntsb/ERA24LA230.md): Piper PA-28-151 · Hope Mills, NC · Accident · Serious injuries · Class 3 · Limited · Final report · May 26, 2024 · N33563 · Substantial damage
  > A loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.
- [NTSB ERA24LA191](https://openairdocs.org/ntsb/ERA24LA191.md): Socata TBM 850 · Raleigh, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 24, 2024 · N228CH · Substantial damage
  > The pilot’s decision to continue an unstabilized approach, which resulted in a bounced landing, and his failure to maintain proper airspeed and climb attitude after aborting the landing, which led to the airplane exceeding its critical angle of attack and…
- [NTSB ERA24LA169](https://openairdocs.org/ntsb/ERA24LA169.md): Snyder Robert L Challenger II · Hendersonville, NC · Accident · No injuries · Class 4 · Limited · Final report · Apr 7, 2024 · N381RS · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ERA24LA010](https://openairdocs.org/ntsb/ERA24LA010.md): Czech Aircraft Works Spol Sro Sportcruiser · Southport, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 15, 2023 · N72FU · Substantial damage
  > The student pilot’s use of carburetor heat during takeoff, which resulted in a partial loss of engine power during initial climb due to an excessively rich fuel-air mixture.
- [NTSB ERA23FA273](https://openairdocs.org/ntsb/ERA23FA273.md): Mooney M20R · Southport, NC · Accident · 1 fatal · Class 3 · Field · Final report · Jun 25, 2023 · N13LV · Destroyed
  > The pilot’s improper decision to fly a known unairworthy airplane, which resulted in a total loss of engine power due to oil starvation.
- [NTSB ERA23LA240](https://openairdocs.org/ntsb/ERA23LA240.md): Cessna R182 · Macon, NC · Accident · 1 fatal · Class 3 · Limited · Final report · May 21, 2023 · N182LG · Destroyed
  > The pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.
- [NTSB ERA23FA194](https://openairdocs.org/ntsb/ERA23FA194.md): Holland Travis E Velocity · Andrews, NC · Accident · 1 fatal · Class 3 · Field · Final report · Apr 15, 2023 · N2357 · Destroyed
  > The pilot’s failure to engage the turbocharger for takeoff and his improper decision to continue the takeoff with partial power, rather than reject the takeoff.
- [NTSB ERA23FA188](https://openairdocs.org/ntsb/ERA23FA188.md): Miller Glenn F RV-12 · Climax, NC · Accident · 1 fatal · Class 3 · Field · Final report · Apr 11, 2023 · N543GM · Destroyed
  > The airplane owner/builder’s inappropriate use of a lower grade fuel than that required by the airplane and engine operations manual, which resulted in engine detonation and the degradation and eventual obliteration of the Nos. 1 and 2 cylinder spark plug…
- [NTSB ERA23LA076](https://openairdocs.org/ntsb/ERA23LA076.md): Phantom Aeronautics X1 · Trinity, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 27, 2022 · N5205A · Substantial damage
  > The pilot's failure to maintain control of the airplane during initial climb in gusting wind conditions, which resulted in a collision with power lines and trees.
- [NTSB ERA22LA432](https://openairdocs.org/ntsb/ERA22LA432.md): Cessna 140 · Winterville, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 28, 2022 · N2509N · Substantial damage
  > The student pilot’s improper recovery from a bounced landing. A factor in the accident was the instructor’s delayed remedial action which resulted in an inability to recover the airplane from an aerodynamic stall.
- [NTSB ERA22LA366](https://openairdocs.org/ntsb/ERA22LA366.md): Piper PA-32RT · Wilmington, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 29, 2022 · N4321M · Substantial damage
  > A partial loss of engine power during initial climb for reasons that could not be determined.
- [NTSB ERA22LA169](https://openairdocs.org/ntsb/ERA22LA169.md): Diamond Aircraft Ind DA 40 NG · Smithfield, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 25, 2022 · N471BL · Substantial damage
  > Maintenance personnel’s failure to set the correct engine timing after the replacement of a cylinder head and exhaust camshaft before the accident flight, which resulted in a total loss of engine power.
- [NTSB ERA22FA024](https://openairdocs.org/ntsb/ERA22FA024.md): Mooney M20J · Holly Ridge, NC · Accident · 2 fatal · Class 3 · Field · Final report · Oct 21, 2021 · N3933H · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack, which resulted in a stall/mush during takeoff and initial climb. Contributing to the accident was the pilot’s loading the airplane near its maximum allowable gross weight and near its aft cg…
- [NTSB ERA22FA001](https://openairdocs.org/ntsb/ERA22FA001.md): Beech S35 · Andrews, NC · Accident · 2 fatal · Class 3 · Field · Final report · Oct 3, 2021 · N876T · Destroyed
  > The pilot’s decision to fly toward rapidly rising, obscured mountainous terrain after departing under visual flight rules at night.
- [NTSB ERA22LA068](https://openairdocs.org/ntsb/ERA22LA068.md): Cessna 172M · Indian Trail, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 27, 2021 · N1401U · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff and initial climb. Contributing was the pilot’s physical limitation which caused an inadvertent application of left rudder.
- [NTSB ERA21FA333](https://openairdocs.org/ntsb/ERA21FA333.md): Piper PA24 · Wadesboro, NC · Accident · 2 fatal · Class 3 · Field · Final report · Aug 20, 2021 · N8262P · Destroyed
  > A partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.
- [NTSB ERA21LA287](https://openairdocs.org/ntsb/ERA21LA287.md): Piper PA46-500TP · Manteo, NC · Accident · No injuries · Class 3 · Limited · Final report · Jul 6, 2021 · N31062 · Substantial damage
  > The improperly secured pneumatic compressor discharge air (P3) line coupling nut on the engine, which ultimately allowed the nut to back off resulting in a partial loss of engine power.
- [NTSB WPR21FA210](https://openairdocs.org/ntsb/WPR21FA210.md): Mark Coby Early Bird Jenny · Stoneville, NC · Accident · 1 fatal · Class 3 · Field · Final report · May 27, 2021 · N831HC · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.
- [NTSB ERA21LA188](https://openairdocs.org/ntsb/ERA21LA188.md): Cessna A188 · Dover, NC · Accident · No injuries · Class 3 · Limited · Final report · Apr 15, 2021 · N731TB · Substantial damage
  > A total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.
- [NTSB ENG20LA043](https://openairdocs.org/ntsb/ENG20LA043.md): Bombardier CL-600-2D24 · Charlotte, NC · Incident · No injuries · Class 3 · Limited · Final report · Jul 24, 2020 · N561NN · Minor damage
  > The windshield failed due to arcing from an inadequate solder connection at the anti-ice power terminal block.
- [NTSB ERA20CA205](https://openairdocs.org/ntsb/ERA20CA205.md): Mooney M20C · Durham, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Jun 2, 2020 · N2768W · Substantial damage
  > The pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall..
- [NTSB ERA20LA127](https://openairdocs.org/ntsb/ERA20LA127.md): Piper PA23 · Albemarle, NC · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2020 · N335W · Substantial damage
  > The pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.
- [NTSB ERA20LA105](https://openairdocs.org/ntsb/ERA20LA105.md): Cessna 172 · Fayetteville, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 17, 2020 · N5185R · Substantial damage
  > The passenger’s excessive control application during the takeoff and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA20LA062](https://openairdocs.org/ntsb/ERA20LA062.md): Piper PA32RT · Fletcher, NC · Accident · No injuries · Class 3 · Limited · Final report · Dec 28, 2019 · N27GB · Destroyed
  > A failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.
- [NTSB GAA19CA439](https://openairdocs.org/ntsb/GAA19CA439.md): Cessna 172 · Manteo, NC · Accident · Minor injuries · Data collection · Final report · Jun 30, 2019 · N78658 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA19FA200](https://openairdocs.org/ntsb/ERA19FA200.md): Rans S6 · Fletcher, NC · Accident · 2 fatal · Class 2 · Field · Final report · Jun 26, 2019 · N661PF · Destroyed
  > The exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.
- [NTSB ERA19LA135](https://openairdocs.org/ntsb/ERA19LA135.md): Piper PA22 · Blanch, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 24, 2019 · N1933P · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA19FA113](https://openairdocs.org/ntsb/ERA19FA113.md): Cessna 182 · Louisburg, NC · Accident · 3 fatal · Field investigation · Final report · Mar 2, 2019 · N26617 · Destroyed
  > The pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.
- [NTSB ERA18FA197](https://openairdocs.org/ntsb/ERA18FA197.md): Piper PA32R · Lincolnton, NC · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2018 · N38523 · Substantial damage
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing the accident was the pilot's self-induced pressure to complete…
- [NTSB ERA18FA180](https://openairdocs.org/ntsb/ERA18FA180.md): Cessna 150J · Manteo, NC · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2018 · N60111 · Destroyed
  > A loss of control due to the banner tow rope becoming entangled with the left horizontal stabilizer in crosswind conditions.
- [NTSB ERA18LA172](https://openairdocs.org/ntsb/ERA18LA172.md): Mooney M20J · Monroe, NC · Accident · No injuries · Limited investigation · Final report · Jun 19, 2018 · N201FD · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA087](https://openairdocs.org/ntsb/ERA18LA087.md): Aero Commander Callair A 9 · Bunn, NC · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 24, 2018 · N8401V · Substantial damage
  > The glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…
- [NTSB ERA18LA027](https://openairdocs.org/ntsb/ERA18LA027.md): Homer Autogyro Cavalon · Oak Island, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N470CH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA010](https://openairdocs.org/ntsb/ERA18LA010.md): Beech A24 · Manteo, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 18, 2017 · N400LE · Substantial damage
  > The failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…
- [NTSB ERA17LA215](https://openairdocs.org/ntsb/ERA17LA215.md): Beech B23 · Ocean Isle Beach, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2017 · N4023T · Substantial damage
  > The pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.
- [NTSB ERA17LA102](https://openairdocs.org/ntsb/ERA17LA102.md): Shell John Super SIX · Morganton, NC · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 6, 2017 · N426KS · Substantial damage
  > A loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.
- [NTSB ERA17LA032](https://openairdocs.org/ntsb/ERA17LA032.md): Bell OH 58C · Cameron, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2016 · N139RD · Substantial damage
  > An in-flight failure of a main rotor blade due to fatigue cracks. Contributing to the failure of the main rotor blade was the absence of guidance to the operator to inspect an area of the main rotor blade known to be susceptible to fatigue cracks and the…
- [NTSB ERA16FA169](https://openairdocs.org/ntsb/ERA16FA169.md): Piper PA32 · Boone, NC · Accident · 1 fatal · Field investigation · Final report · Apr 25, 2016 · N43576 · Destroyed
  > The pilot's delayed decision to conduct a go-around following an unstabilized landing approach and his subsequent failure to maintain clearance from trees near the end of the runway.
- [NTSB ERA16LA041](https://openairdocs.org/ntsb/ERA16LA041.md): Woodrow Larry W Sonex · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Nov 15, 2015 · N7035Z · Substantial damage
  > The pilot/owner’s inadequate maintenance inspection following a propeller strike, which resulted in the subsequent in-flight propeller separation due to propagation of fatigue cracks in the crankshaft.
- [NTSB ERA15LA358](https://openairdocs.org/ntsb/ERA15LA358.md): Bellanca 7KCAB · Manteo, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 2015 · N86705 · Substantial damage
  > The inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.
- [NTSB ERA15CA321](https://openairdocs.org/ntsb/ERA15CA321.md): Quicksilver MXL II Sport · Pittsboro, NC · Accident · Serious injuries · Data collection · Final report · Aug 15, 2015 · UNREG · Substantial damage
  > The pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.

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

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