NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 ERA09LA106Accident · 1 fatalLimited investigationFinal reportReamer RV7A · Wadesboro, NCThe pilot's failure to maintain adequate airspeed while on approach for a precautionary landing, which resulted in an aerodynamic stall.NTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.NTSB ERA09LA072Accident · Serious injuriesLimited investigationFinal reportLeroy Lakey Corben ACE · Cherryville, NCA throttle control malfunction during initial climb, as reported by the pilot.NTSB ERA09CA122Accident · No injuriesData collectionFinal reportDassault-Breguet Falcon 50 · Asheville, NCThe pilot's failure to ensure that the airplane's wheels were properly secured before releasing the parking brake.NTSB ERA09CA065Accident · No injuriesData collectionFinal reportPiper PA46 · Oak Island, NCThe pilot's failure to maintain directional control during takeoff. Contributing to the accident were gusting crosswinds.NTSB ERA09CA040Accident · Minor injuriesData collectionFinal reportFox Jack G Mong Biwin · Thomasville, NCThe builder’s failure to set adequate propeller pitch during propeller installation.NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB ERA09LA025Accident · 1 fatalLimited investigationFinal reportMoses Tim C Quicksilver · Wingate, NCA loss of engine power due to a fractured crankshaft.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB MIA08LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wallace, NCThe pilot's failure to abort the takeoff when the engine failed to develop full power. Contributing to the accident was the pilot's failure to remove the intake plugs prior to takeoff.NTSB MIA08CA184Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Pantego, NCThe pilot's failure to maintain directional control on the landing roll out.NTSB NYC08CA269Accident · Minor injuriesData collectionFinal reportCessna 172M · Jefferson, NCA loss of directional control during the takeoff roll for undetermined reasons. Contributing to the severity of the event was the descending embankment adjacent to the runway.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB NYC08FA260Accident · 2 fatalField investigationFinal reportPiper PA-23 · Highlands, NCThe pilot's improper decision to fly into an area of thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the air traffic controller's failure to comply with FAA directives regarding issuance of precipitation location and…NTSB NYC08LA234Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Charlotte, NCThe tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.NTSB NYC08CA229Accident · No injuriesData collectionFinal reportPiper PA-18-105 · Fayetteville, NCThe pilot's failure to maintain directional control during the landing roll out.NTSB LAX08LA181Accident · 1 fatalLimited investigationFinal reportAirborne Edge · Dunn, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB NYC08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Greenville, NCThe malfunction and premature retraction of the landing gear for undetermined reasons.NTSB MIA08LA109Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Durham, NCThe pilot's failure to maintain clearance from trees while approaching to land.NTSB NYC08CA188Accident · No injuriesData collectionFinal reportPilatus PC-12 · Burnsville, NCThe pilot's failure to maintain directional control while landing. Contributing to the accident was the gusty wind conditions.NTSB NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.NTSB NYC08LA176Accident · 2 fatalLimited investigationFinal reportDesalvatore Al Lancair IV-P · Snow Hill, NCAn inadvertent encounter with icing conditions, resulting in a loss of aircraft control. Contributing to the accident was the pilot's inadequate preflight and in-flight decision making.NTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.NTSB NYC08CA169Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Chapel Hill, NCThe pilot's improper recovery from a bounced landing. Contributing to the accident was the gusty wind conditions.NTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.NTSB MIA08FA081Accident · 1 fatalField investigationFinal reportCirrus SR22 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the tailwind.NTSB NYC08FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta II · Wilmington, NCThe pilot's failure to maintain proper rotor rpm after a partial loss of engine power.NTSB NYC08CA097Accident · Minor injuriesData collectionFinal reportChristen Industries Eagle II · Boone, NCThe pilot's failure to maintain clearance/altitude while on the final leg of the traffic pattern. Contributing to the accident were the proximity of the trees to the threshold, and the lack of a displaced threshold.NTSB MIA08FA052Accident · 1 fatalField investigationFinal reportKaylor J E/Strahlmann R L RV-4 · Elkin, NCThe pilot's decision to attempt an aerobatic maneuver in close proximity to the ground.NTSB NYC08MA090Accident · 6 fatalMajor investigationFinal reportRaytheon C90A · Mount Airy, NCThe pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…NTSB NYC08CA088Accident · No injuriesData collectionFinal reportBombardier 35A · Charlotte, NCThe tug driver's failure to stop for a taxiway stop sign.