NTSB investigations, NC
333 cases where NTSB found Task performance.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 17 |
| 2010 | 8 |
| 2011 | 18 |
| 2012 | 16 |
| 2013 | 17 |
| 2014 | 24 |
| 2015 | 36 |
| 2016 | 17 |
| 2017 | 21 |
| 2018 | 13 |
| 2019 | 20 |
| 2020 | 17 |
| 2021 | 24 |
| 2022 | 18 |
| 2023 | 16 |
| 2024 | 19 |
| 2025 | 10 |
| 2026 | 7 |
Where
Latest 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\", '0206'))
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", '0206')) 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 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 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 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 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 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 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 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 CEN23LA300Accident · No injuriesClass 4 · LimitedFinal reportAcrosport II · Hertford, NCThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with vegetation.NTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.NTSB ERA23LA278Accident · No injuriesClass 4 · LimitedFinal reportGopalan Hariharan 4 Place · Sanford, NCThe pilot’s failure to maintain directional control while landing in a crosswind, which resulted in a nose over.NTSB CEN23LA230Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Rutherfordton, NCThe disengagement of the tailwheel locking mechanism during the landing roll which resulted in a loss of directional control during landing with a crosswind.NTSB ERA23LA244Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Reidsville, NCThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind.NTSB ERA23LA218Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Greenville, NCInadequate maintenance by the operator and maintenance personnel, which resulted in a loss of engine power due to oil starvation.NTSB DCA23LA278Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Charlotte, NCThe captain’s failure to maintain the appropriate airspeed and pitch attitude during landing which resulted in a tailstrike.NTSB ERA23LA207Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Wake Forest, NCThe student pilot’s failure to maintain airspeed during the landing approach, which resulted in an exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a loss of control.NTSB ERA23FA194Accident · 1 fatalClass 3 · FieldFinal reportHolland Travis E Velocity · Andrews, NCThe 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 ERA23LA155Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, NCA loss of directional control while landing, which resulted in a runway excursion and impact with a ditch.