NTSB investigations, NC
452 cases where NTSB found Personnel issues.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 27 |
| 2010 | 26 |
| 2011 | 32 |
| 2012 | 23 |
| 2013 | 22 |
| 2014 | 26 |
| 2015 | 40 |
| 2016 | 20 |
| 2017 | 28 |
| 2018 | 19 |
| 2019 | 25 |
| 2020 | 20 |
| 2021 | 33 |
| 2022 | 21 |
| 2023 | 25 |
| 2024 | 23 |
| 2025 | 11 |
| 2026 | 10 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02')) 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 ERA26LA323Accident · No injuriesClass 4 · LimitedFinal reportMooney M-20 · Stanfield, NCThe 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 ERA26LA339Accident · No injuriesClass 4 · LimitedFinal reportCessna 680 · Statesville, NCThe pilot’s failure to maintain directional control while landing in a strong gusting crosswind.NTSB ERA26LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mooresville, NCThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.NTSB ERA26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Morganton, NCThe pilot and flight instructor’s failure to maintain directional control while maneuvering on the runway, which resulted in a runway excursion. Contributing to the accident was the pilot’s failure to complete a positive exchange of flight control following…NTSB ERA26LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Statesville, NCThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Maiden, NCThe flight instructor’s inadequate preflight planning, which resulted in a rejected takeoff from a tailwind departure and subsequent runway excursion.NTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe 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 ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Monroe, NCThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA26LA081Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Louisburg, NCThe pilot’s failure to compensate for gusting crosswind conditions and subsequent loss of directional control following an aborted go-around attempt, which resulted in a runway excursion.NTSB ERA26LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · Southern Pines, NCThe pilot’s failure to maintain directional control during takeoff at night, while distracted by an animal approaching the runway, which resulted in collision with a runway light.NTSB ERA26LA008Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · East Rockingham, NCThe pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.NTSB ERA25LA198Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Sanford, NCThe 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 ERA25LA196Accident · Serious injuriesClass 4 · LimitedFinal reportChris Wallen/Michael Pliske Just Acft Highlander · Brasstown, NCThe pilot’s inadvertent application of brake pressure during landing, which resulted in a nose over.NTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance 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 ERA25LA183Accident · Serious injuriesClass 4 · LimitedFinal reportFrank Lowell C Pietenpol · Taylorsville, NCThe 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 ERA25LA164Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Hickory, NCThe 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 ERA25FA143Accident · 2 fatalClass 3 · FieldFinal reportRaytheon A36 · Greenville, NCThe pilot’s loss of airplane control shortly after climbing into instrument meteorological conditions due to spatial disorientation (somatogyral illusion).NTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe 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 ERA25LA099Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Wilmington, NCThe pilot’s improper landing flare, which resulted in a wing strike.NTSB ERA25LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Southport, NCThe 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 ERA25LA062Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski BOT Journey · Ocean Isle Beach, NCMaintenance 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 ERA24FA397Accident · 5 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Kill Devil Hills, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA24LA354Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Asheboro, NCThe pilot’s failure to extend the landing gear before landing.NTSB ERA24LA351Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 680 · Washington, NCThe flight crew’s failure to properly configure the airplane before landing and the captain’s subsequent failure to recognize the landing gear aural warning, which resulted in a gear-up landing. Contributing to the accident was the flight crew’s inadequate…NTSB ERA24LA311Accident · Serious injuriesClass 3 · LimitedFinal reportChampion 7ECA · Beaufort, NCThe pilot’s inadequate fuel planning and preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB ERA24LA321Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Pisgah Forest, NCThe pilot’s failure to maintain proper altitude and airspeed on final approach, resulting in a runway excursion and substantial damage to the airplane.NTSB ERA24FA294Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Rutherfordton, NCThe pilot’s failure to maintain clearance from clouds, resulting in controlled flight into terrain due to mountain obscuration.NTSB ERA24LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Smithfield, NCThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe 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 ERA24LA280Accident · No injuriesClass 4 · LimitedFinal reportLancair LC42-550FG · Beaufort, NCThe pilot's failure to attain a proper touchdown point during landing, which resulted in a runway overrun.NTSB ERA24LA244Accident · No injuriesClass 4 · LimitedFinal reportRuth Hummingbird · New Hill, NCThe pilot's failure to maintain control of the helicopter while hovering.NTSB ERA24LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAero Commander Callair A-9B · Zebulon, NCA total loss of engine power while maneuvering due to fuel starvation.NTSB ERA24LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Greensboro, NCThe pilot's improper landing flare, which resulted in a hard landing and a subsequent loss of directional control.NTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA 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 ERA24LA203Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louisburg, NCThe pilot under instruction’s inadvertent use of the mixture control, which resulted in a total loss of engine power.NTSB ERA24LA191Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TBM 850 · Raleigh, NCThe 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 ERA24LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Stoneville, NCThe student pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB ERA24LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna R172 · Rocky Mount, NCThe 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 ERA24LA133Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Greensboro, NCThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA24LA107Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Elizabethtown, NCThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, right main landing gear collapse, and a collision with a ditch.NTSB ERA24LA090Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Mooresville, NCThe pilot’s failure to maintain control of the airplane during a go-around in gusting crosswind conditions.NTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.NTSB ERA24LA010Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Southport, NCThe 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 ERA23LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Winston-Salem, NCThe pilot’s loss of directional control upon landing which resulted in substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23LA338Accident · No injuriesClass 3 · LimitedFinal reportStephen J Moorman Just Aircraft Highla · Edenton, NCThe pilot’s inadequate fuel planning, which led to a total loss of engine power due to fuel exhaustion.NTSB ERA23LA334Accident · 2 fatalClass 3 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Hickory, NCThe pilot’s failure to maintain clearance from powerlines while maneuvering at a low altitude over water, which resulted in a collision and loss of control.NTSB ERA23LA316Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Maiden, NCThe flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.