NTSB investigations, 2010, NC
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 102 |
| 1965 | 83 |
| 1966 | 81 |
| 1967 | 101 |
| 1968 | 85 |
| 1969 | 77 |
| 1970 | 67 |
| 1971 | 86 |
| 1972 | 89 |
| 1973 | 118 |
| 1974 | 100 |
| 1975 | 90 |
| 1976 | 76 |
| 1977 | 77 |
| 1978 | 77 |
| 1979 | 52 |
| 1980 | 59 |
| 1981 | 47 |
| 1982 | 59 |
| 1983 | 56 |
| 1984 | 53 |
| 1985 | 51 |
| 1986 | 60 |
| 1987 | 47 |
| 1988 | 52 |
| 1989 | 52 |
| 1990 | 48 |
| 1991 | 52 |
| 1992 | 50 |
| 1993 | 37 |
| 1994 | 52 |
| 1995 | 39 |
| 1996 | 32 |
| 1997 | 49 |
| 1998 | 35 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 40 |
| 2002 | 37 |
| 2003 | 38 |
| 2004 | 27 |
| 2005 | 42 |
| 2006 | 39 |
| 2007 | 37 |
| 2008 | 33 |
| 2009 | 37 |
| 2010 | 31 |
| 2011 | 37 |
| 2012 | 28 |
| 2013 | 30 |
| 2014 | 29 |
| 2015 | 44 |
| 2016 | 25 |
| 2017 | 34 |
| 2018 | 24 |
| 2019 | 29 |
| 2020 | 30 |
| 2021 | 41 |
| 2022 | 30 |
| 2023 | 34 |
| 2024 | 33 |
| 2025 | 22 |
| 2026 | 27 |
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 year(c.\"eventDate\") = 2010
AND c.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2010 AND c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA' 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 ERA11LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Dublin, NCThe pilot’s improper touchdown speed which resulted in a runway overrun. Contributing to the accident was the undetermined malfunction of the airspeed indicator.NTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.NTSB ERA11CA040Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Julian, NCThe pilot's failure to attain the proper touchdown point.NTSB ERA11LA023Accident · Serious injuriesLimited investigationFinal reportBobo Christopher J Loehle 5151 · Southern Pines, NCThe reported fluttering of the wings in flight and the pilot's subsequent in-flight loss of control for undetermined reasons.NTSB ERA11FA001Accident · Minor injuriesField investigationFinal reportCessna 550 · Manteo, NCThe pilot-in-command's failure to maintain proper airspeed and his failure to initiate a go-around, which resulted in the airplane touching down too fast on a short, wet runway and a subsequent runway overrun. Contributing to the accident was the copilot's…NTSB ERA10CA480Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Pleasant Garden, NCThe pilot's loss of directional control on takeoff during an encounter with a wind gust.NTSB ERA10CA470Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2 · Winterville, NCThe pilot's loss of directional control while landing during an encounter with a wind gust.NTSB ERA10CA452Accident · No injuriesData collectionFinal reportKilishek George T RV-8 · Yadkinville, NCThe pilot's inadequate flare, which resulted in a hard landing.NTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.NTSB ERA10CA448Accident · No injuriesData collectionFinal reportCessna 182E · Edenton, NCThe pilot's inadequate compensation for crosswind conditions while landing, which resulted in a loss of directional control.NTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.NTSB ERA10CA427Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Erwin, NCThe pilot's excessive use of spoiler on final approach, which resulted in a landing short of the runway.NTSB ERA10LA424Accident · No injuriesLimited investigationFinal reportW.H. Hunnicutt Hobo · Fletcher, NCA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to select an adequate forced landing site.NTSB ERA10LA374Accident · Serious injuriesLimited investigationFinal reportMulloy Charles Zodiac 601XL · Enochville, NCLoss of engine power due to fuel contamination, and the pilot’s inadequate preflight of the fuel system.NTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB ERA10LA349Accident · No injuriesLimited investigationFinal reportBeech F33A · Mooresville, NCA loss of engine power for undetermined reasons.NTSB ERA10CA343Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Burnsville, NCThe pilot's failure to maintain a proper visual glideslope during final approach.NTSB ERA10LA323Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Asheville, NCThe pilot's failure to maintain forward airspeed, which resulted in a settling with power encounter.NTSB ERA10CA311Accident · Serious injuriesData collectionFinal reportDwight Lohr Baby Ace · Carolina Beach, NCThe pilot's failure to maintain clearance from a tree during initial climb after takeoff.NTSB ERA10LA302Accident · 1 fatalLimited investigationFinal reportBeech 60 · Edenton, NCThe flight instructor’s initiation of a simulated single engine scenario at or below the airplane’s minimum single engine control speed, resulting in a loss of airplane control. Contributing to the accident was the flight instructor’s failure to set full…NTSB ERA10LA299Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-323 · Charlotte, NCThe Airbus A330 flight crew's failure to maintain clearance from a standing airplane while taxiing.NTSB ERA10CA274Accident · No injuriesData collectionFinal reportCessna T210N · Fuquay-Varina, NCThe pilot's improper decision to land with a tailwind resulting in an overrun.NTSB ERA10CA227Accident · No injuriesData collectionFinal reportMaule MX7 · Greenville, NCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA10CA224Accident · Minor injuriesData collectionFinal reportPiper PA17 · Louisburg, NCThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.NTSB ERA10CA217Accident · No injuriesData collectionFinal reportMason Aventura II · Greensboro, NCThe pilot's inadequate compensation for a wind gust during the landing approach, which resulted in a loss of directional control.NTSB ERA10LA177Accident · No injuriesLimited investigationFinal reportCessna T337G · Shelby, NCThe pilot's improper landing flare and touchdown during landing in gusty crosswind conditions.NTSB ERA10CA168Accident · No injuriesData collectionFinal reportAeronca 7AC · Roanoke Rapids, NCThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10CA156Accident · No injuriesData collectionFinal reportPiaggio P180 · Greensboro, NCThe pilot's failure to properly configure the landing gear for landing. Contributing to the accident was the pilot's diverted attention looking for traffic and manipulating the secondary trim controls.NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.