NTSB investigations, 2002, NC
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2002
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") = 2002 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 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 MIA03LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Cashiers, NCThe pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain.NTSB MIA03LA021Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Brevard, NCthe jamming of the elevator control system for undetermined reason, which resulted in the airplane departing the runway, and impacting with a ditch, during the aborted takeoff.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB MIA03FA016Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Climax, NCThe pilot's operation of the airplane at a low altitude during final approach that resulted in an in-flight collision with a tree, a witness reported pitch-up, and subsequent stall and in-flight collision with terrain.NTSB ATL03FA010Accident · 3 fatalField investigationFinal reportCessna R182 · Greensboro, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.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 MIA02CA174Accident · Minor injuriesData collectionFinal reportCessna 188B · Pikesville, NCThe inability of the pilot to see the .250 inch diameter unmarked cable resulting in the in-flight collision with the cable and substantial damage to the airplane.NTSB MIA02LA171Accident · No injuriesLimited investigationFinal reportJohnson Hornet · Archdale, NCthe pilot's failure to maintain directional control during final approach, which resulted in the airplane drifting off course and impacting with trees. Factors in this accident were the pilot's attention being diverted due to the right door not being secured.NTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.NTSB ATL02LA170Accident · 1 fatalLimited investigationFinal reportMikoyan Gurevich Mig-15 · Whiteville, NCThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation which resulted in a loss of control and the subsequent collision with the ground .NTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.NTSB MIA02LA158Accident · No injuriesLimited investigationFinal reportCessna 172N · Tarboro, NCThe failure of the solo student to maintain directional control of the airplane during the takeoff roll/run which resulted in the airplane veering off the runway and impacting trees, incurring substantial damage.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB ATL02LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Burnsville, NCThe pilot misjudged distance and speed, and did not attain the proper touchdown point during landing, resulting in an overrun of the runway.NTSB MIA02GA137Accident · 3 fatalFinal reportCessna 172S · Tyner, NCThe loss of power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB ATL02LA139Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Weaverville, NCThe pilot's inadequate preflight and in-flight planning of fuel to complete the flight that resulted in the exhaustion of the fuel supply.NTSB MIA02LA127Accident · 2 fatalLimited investigationFinal reportThomas Outback · Edenton, NCThe pilot/owner's failure to establish an adequate climb rate and his failure to maintain obstacle clearance.NTSB MIA02LA123Accident · Serious injuriesLimited investigationFinal reportCessna CE-182-A · Siler City, NCThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA02LA118Accident · No injuriesLimited investigationFinal reportCessna 150D · Louisburg, NCthe failure of the pilot-in-command to follow emergency procedures after smelling smoke that resulted in an electrical fire, damage to the airplane, and a forced landing.NTSB ATL02LA129Accident · Minor injuriesLimited investigationFinal reportEames Acro Sport · Burlington, NCA total loss of engine power due to fuel starvation. This resulted in a forced landing and subsequent hard landing while maneuvering around trees.NTSB MIA02LA116Accident · No injuriesLimited investigationFinal reportNavion Nav4 · Raleigh, NCthe pilot's inadequate preflight planning, improper fuel consumption calculations, and selection of the auxiliary fuel tank for landing, which resulted in a loss of engine power due to fuel starvation, and forced landing in trees. A factor in this accident…NTSB ATL02LA125Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Concord, NCThe pilot's improper use of cyclic while attempting a hover resulting in dynamic rollover.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.NTSB MIA02LA112Accident · No injuriesLimited investigationFinal reportCessna 172S · Kill Devil Hill, NCthe pilot's failure to maintain control of the airplane after an attempted aborted landing, and while braking during the landing roll, which resulted in the airplane departing the end of the runway and impacting with a ditch.NTSB MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.NTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.NTSB ATL02LA114Accident · No injuriesLimited investigationFinal reportBeech 23 · Greensboro, NCThe loss of engine power for undetermined reasons, A factor was the pilot's intentional ground loop during a forced landing.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB ATL02LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Smithfield, NCThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB MIA02FA075Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Charlotte, NCThe failure of the aircraft operator to comply with, in a timely manner, on the No. 2 engine, Boeing Alert Service Bulletin MD11-71A086, resulting in the integrated drive generator feeder cable chaffing through a fire warning loop and failure of the fire…NTSB ATL02FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Apex, NCThe pilot experienced spatial disorientation that resulted in the loss of control and the overload failure of the airframe. A factor was low visibility and ceilings.NTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.