NTSB investigations, NC
54 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 1 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL07CA035Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Siler City, NCThe pilot's failure to perform an aborted landing which resulted in an inflight collision with the runway.NTSB ATL05CA030Accident · No injuriesData collectionFinal reportMooney M20J · Statesville, NCthe flight instructors improper use of the flight controls on rotation during a short field takeoff resulting in the airplane becoming airborne, stall, and collision with the ground. A factor in the accident was the instructors failure to brief procedures for…NTSB ATL04LA198Accident · Serious injuriesLimited investigationFinal reportThunder & Colt 210A · Huntersville, NCGusty weather conditions which resulted in an in-flight collision with terrain during touchdown.NTSB ATL03FA070Accident · 1 fatalField investigationFinal reportCessna 172R · Cherokee, NCThe pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.NTSB MIA03FA034Accident · 1 fatalField investigationFinal reportCessna 208B · Manteo, NCThe pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…NTSB ATL03LA001Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Louisburg, NCThe pilot's improper use of flight controls (collective and cyclic) during an attempted takeoff to a hover, that resulted in an in-flight collision with terrain, and dynamic rollover.NTSB ATL01FA109Accident · 1 fatalField investigationFinal reportCessna T-210F · Hendersonville, NCThe pilot's failure to follow the air traffic controllers verbal instructions pertaining to heading and minimum safe vectoring altitude while being vectored for an ILS approach to his destination airport. This resulted in an in-flight collision with trees and…NTSB MIA01FA193Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Black Mountain, NCThe pilot's continued VFR flight into IMC conditions resulting in the airplane colliding with mountainous terrain.NTSB MIA01LA172Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Garner, NCThe pilot's failure to maintain altitude clearance above the terrain while maneuvering, resulting in a collision with the terrain, and subsequent rollover.NTSB MIA01FA107Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Concord, NCAn in-flight collision with terrain for undetermined reasons.NTSB MIA00LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ocracoke, NCThe pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.NTSB ATL00LA054Accident · No injuriesLimited investigationFinal reportSchweizer SGU2-22E · Farmington, NCThe pilot's misjudgment of traffic pattern altitude that resulted in an off-field landing and the subsequent collision with the ground. A factor was rough terrain.NTSB MIA99LA178Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Charlotte, NCThe pilot misjudged the flare during the landing.NTSB MIA98LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Lumber Bridge, NCThe pilot's delay in aborting a takeoff from a wet grass runway.NTSB MIA97LA204Accident · No injuriesLimited investigationFinal reportMoran Teenie TWO · Pinehurst, NCThe pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB MIA97FA097Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Andrews, NCThe pilot's poor in-flight planning in attempting to maintain VFR conditions at night over mountainous terrain, and his failure to maintain clearance from the mountain. Contributing to the accident was: the pilot's inadequate preflight planning for not…NTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB ATL95FA128Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe pilot's failure to follow proper IFR procedures by descending below the decision height. Factors relating to the accident were the weather conditions and the dark night.NTSB ATL95LA073Accident · No injuriesLimited investigationFinal reportCessna 150M · Fuquay-Varina, NCThe certified flight instructor's failure to complete the takeoff checklist which resulted in an attempted takeoff with the wing flaps extended.NTSB DCA94MA065Accident · 37 fatalClass 1 · MajorFinal reportDouglas DC-9-31 · Charlotte, NC1) The flightcrew's decision to continue an approach into severe convective activity that was conducive to a microburst; 2) the flightcrew's failure to recognize a windshear situation in a timely manner; 3)the flightcrew's failure to establish and maintain…NTSB ATL94FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Murphy, NCThe failure of the pilot to maintain clearance from the terrain. Factors in the accident were the dark night, and the mountainous terrain.NTSB ATL93LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student pilot's inadequate compensation for wind conditions during the touch and go landing. Factors were the crosswind conditions, and the hidden obstruction (rock) in the grass adjacent to the runway.NTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.NTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.NTSB MIA92LA042Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Charlotte, NCThe pilot in commands failure to maintain tailrotor ground clearance while hovering resulting in the tail striking the ground and the subsequent separation of the tailrotor and gearbox.NTSB ATL91FA043Accident · 1 fatalField investigationFinal reportCessna 337C · Bryson City, NCThe inadvertent flight into instrument meteorological conditions in mountainous terrain by the noninstrument rated pilot.NTSB ATL90LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, NCThe pilot's delayed pull up from an intentional descent during an aborted suicide attempt.NTSB ATL89DMG03Accident · Serious injuriesFinal reportSmithgall Pitts Special S-1C · Fuquay-Varina, NCPilot did not maintain sufficient altitude to insure recovery from an aerobatic maneuver and spin.NTSB ATL88LA111Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Maiden, NCThe aircraft had been flying a series of low level maneuvers over the city. The pilot was attempting to recover from an intentional spin close to the ground when the aircraft struck utility lines and impacted the ground.NTSB ATL87FA268Accident · 5 fatalField investigationFinal reportBeech 95-B55 · Manteo, NCWitness observed acft settle into ocean during low level cruise flt adjacent to beach. Wx was ovrcst, indistinct horizon & calm sea. IFR flt plan had been filed but no contact was made with ATC. Engines and propeller examination did not reveal a mechanical…NTSB ATL87LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Union Grove, NCThe plt reported that he was attempting to make a soft-field ldg in a plowed field at a friend's farm. He had not landed there previously. After initial touchdown was made on the main ldg gear, the nosewheel dug into a rise in the terrain and the airplane…NTSB ATL86LA229Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Benson, NCThe acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site…NTSB ATL86LA210Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Huntersville, NCPlt was practicing touch-and-go and emer proc. He was high on base and attempted to correct alt, struck a ditch 200 feet short of the rwy with rt ldg gear. Acft came to a stop 100 feet short of rwy in second grass filled ditch.NTSB ATL86FA120Accident · 4 fatalField investigationFinal reportPiper PA-28-160 · Winton, NCBefore the flt, the student plt & passengers had been socializing & drinking beer. At aprx 0200 EDT, while at a friend'shome near murfreesboro, NC, they decided to go flying. At about 0300, an acft was observed to fly over the friend's home at low alt, then…NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…NTSB ATL85FA256Accident · 5 fatalField investigationFinal reportPiper PA-31T · Flat Rock, NCAcft hit northwest side of ridge in level attitude,cruise speed,heading southeast. Conditions were dark night and the cloud ceiling was about 40 feet above the ridge. Pilot received wx brief before take off and en route which reported a ceiling of 10,000 feet…NTSB ATL85LA195Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wingate, NCThe plt & passenger consumed several beers shortly before boarding the helicopter for a flt in the local area. The flt lasted aprx 15 min. The passenger reported that during a landing, the skid on the right side contacted the ground causing the helicopter to…NTSB ATL85FMG04Accident · 1 fatalFinal reportGross Taylor Titch · Liberty, NCAccording to witnesses interviewed, pilot made a takeoff on runway 2, holding the plane just a few feet off the runway with a steep pull up at the end of the runway. It was then observed doing a steep bank, low altitude 180 degree turn and proceeded…NTSB ATL86FA028Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Robbinsville, NCMsg acft found after 9 mos. Remains found on east side of coline ridge in graham co NC. Path of broken limbs/trees about level into mountainside. Both occupants fatal.NTSB ATL85LA115Incident · No injuriesLimited investigationFinal reportEnstrom F-28A · Jacksonville, NCThe plt lost directional control of the acft while attempting to air taxi the helicopter to another position on the ramp.NTSB ATL84IA262Incident · No injuriesIncident investigationFinal reportCessna 150H · Gastonia, NCPlt reached charlotte, NC, and discovered he could not transmit on the acft radio. Plt diverted to gasotnia, NC, but could not locate the arpt because of lowering visibility. Plt flew around for a few minutes looking for identifiable landmarks. Precautionary…NTSB ATL84FA250Accident · 1 fatalField investigationFinal reportCessna 150F · Banner Elk, NCAcft observed to depart short strip in hi dens alt conditions, 'wobbled into the air.' Acft did not circle for altitude, but headed straight ahead toward rising terrain 'wings rocking' at slow speed before right wing dropped and acft collided with terrain. No…NTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…NTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…NTSB ATL84LA186Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · New Bern, NCThe plt was performing a low level fly-by simulating an inexperienced flyers erratic maneuvers when the acft fell vertically to the ground and bounced into a fence before it came to rest in a field. The plt said he hit a down draft at a tree line. The fly-by…NTSB ATL84FA044Accident · 1 fatalField investigationFinal reportPiper PA-31-300 · Charlotte, NCThe acft was first radar identified about 18 mi north of the arpt & was given radar vectors for a right downwind & base to rwy 36R. While on a downwind heading 150 deg, the plt was assigned a heading of 270 deg & was queried if the arpt wasin sight. The plt…NTSB ATL83AA029Accident · 1 fatalFinal reportPiper PA-31-350 · Brevard, NCAfter a missed approach at asheville the flt was cleared to the greenville-spartanburg arpt at greer,SC. Enroute to greer radar contact was lost. In response to a query from atlanta ARTCC the plt verified his position as being on the 235 deg radial of…NTSB ATL82DA270Accident · No injuriesFinal reportCessna 150 · Goldsboro, NCThe aircraft was flown by an unauthorized person after it had been secured for the night and the flight operation had been closed. On the next morning, the plane was found about 200 yards from the departure end of runway 04, where it had crashed. An…