NTSB investigations, 2003, 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\") = 2003
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") = 2003 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 ATL04LA060Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · King, NCA loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.NTSB ATL04LA059Accident · No injuriesLimited investigationFinal reportSocata TB21 · Spruce Pine, NCThe pilot's inadequate flare, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing, and trees are a contributing factor.NTSB ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB ATL04FA056Accident · 1 fatalField investigationFinal reportCessna 206H · Sanford, NCThe pilot's loss of control of the airplane during takeoff initial climb due to spatial disorientation, which resulted in an inflight collision with trees and the ground. Factors were the dark night, fog, and low ceilings.NTSB ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.NTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.NTSB ATL04LA033Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · Waxhaw, NCThe pilot's failure to maintain airspeed while maneuvering on final approach resulting in an inadvertent stall and in-flight collision with trees and the ground.NTSB ATL04LA031Accident · No injuriesLimited investigationFinal reportCessna 172R · New Bern, NCThe student pilot's improper landing flare resulting in a hard landing.NTSB ATL04LA030Accident · No injuriesLimited investigationFinal reportThocker Vans RV-4 · Liberty, NCThe pilot's failure to maintain airspeed on initial takeoff climb resulting in an in-flight loss of control, inadvertent stall, and collision with the runway.NTSB ATL04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kinston, NCThe pilot's failure to maintain aircraft control which resulted in the dragging of the right wing tip and the on ground collision with a roadway.NTSB ATL04IA028Incident · No injuriesIncident investigationFinal reportPiper PA-32RT-300T · Fayetteville, NCFlight control elevator attachment turnbuckle corrosion and fracture resulting in the loss of aircraft control in flight.NTSB ATL04LA020Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Beaufort, NCThe pilot's misjudgment of speed and distance, and his failure to perform a go-around which resulted in an overrun and on ground collision with terrain.NTSB ATL04LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe student pilot's failure to maintain directional control on landing roll resulting in a collision with a ditch, and subsequent nose over.NTSB ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL04LA014Accident · Minor injuriesLimited investigationFinal reportMcCan Velox Revolution II · Mooresville, NCThe pilot's inadequate in-flight planning/decision to conduct an aerobatic maneuver at an altitude too low to initiate a recovery.NTSB ATL04LA003Accident · 1 fatalLimited investigationFinal reportWhitty Mustang II · Holly Ridge, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed while maneuvering for a forced landing.NTSB ATL03LA149Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Beaufort, NCLoss of engine power due to undetermined reasons.NTSB ATL03LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hendersonville, NCThe pilot's inadequate evaluation of the weather. The downdraft was a contributing factor.NTSB ATL03LA129Accident · Serious injuriesLimited investigationFinal reportWilliam Allen MONI-1 · Timberlake, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent collision with the ground.NTSB ATL03FA127Accident · 2 fatalField investigationFinal reportBoeing PT-17 Stearman · Tuckasegee, NCThe pilot's failure to maintain visual lookout which resulted in an in-flight collision with trees. A factor was drug impairment.NTSB ATL03IA126Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Raleigh Durham, NCThe failure of a utility bus relay which resulted in an electrical fire and subsequent smoke in the cockpit.NTSB MIA03LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Charlotte, NCThe pilot-in-command's failure to sufficiently deviate to avoid known weather, and his failure to activate the seatbelt sign to ensure flight attendants and passengers were seated, which resulted in a passenger receiving serious injuries when the flight…NTSB ATL03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Greenville, NCThe pilot's failure to maintain directional control after an aborted landing and subsequent collision with an airport runway sign.NTSB ATL03LA118Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Hendersonville, NCThe pilot's inadequate preflight planning/preparation of fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion. A factor in the accident was pilot impairment due to alcohol consumption.NTSB ATL03LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Hatteras, NCThe pilot's failure to maintain directional control during the landing roll. A factor was a go-around not performed.NTSB ATL03LA119Accident · No injuriesLimited investigationFinal reportCessna 182J · Southern Pines, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL03FA104Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Battleboro, NCThe certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.NTSB ATL03LA099Accident · No injuriesLimited investigationFinal reportCessna 177RG · Wilmington, NCThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the ditch.NTSB ATL03LA087Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Beaufort, NCThe pilot's failure to follow the checklist and set the parking brake which resulted in the airplane colliding with a parked airplane.NTSB ATL03LA071Accident · Minor injuriesLimited investigationFinal reportCessna 310F · Reidsville, NCThe failure of maintenance personnel to properly install the nose gear landing door link during an annual inspection that resulted in the failure of the nose gear to fully extend.NTSB ATL03FA070Accident · 1 fatalField investigationFinal reportCessna 172R · Cherokee, NCThe pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.NTSB ATL03LA072Accident · No injuriesLimited investigationFinal reportRotorway 162F · Greensboro, NCThe pilot's inadequate preflight planning of fuel required for flight which resulted in fuel exhaustion, and a complete loss of engine power followed by a forced landing, and a dynamic rollover during the autorotative touchdown.NTSB ATL03FA061Accident · 3 fatalField investigationFinal reportCessna 177 · Old Fort, NCThe pilot's decision to continue VFR flight into IMC and his failure to maintain terrain clearance which resulted in an in-flight collision with mountainous terrain.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB ATL03LA056Accident · No injuriesLimited investigationFinal reportFokker F.27MK 500 · Kinston, NCThe fatigue failure of the main drag stay tube. A factor is no inspection procedure required.NTSB ATL03FA052Accident · 5 fatalField investigationFinal reportBeech BE-36A · Mount Airy, NCThe pilots failure to maintain control of the aircraft due to spatial disorientation. A factor was low clouds.NTSB ATL03LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hendersonville, NCThe pilot's failure to maintain directional control and clearence from power lines during a go-around, resulting in an in-flight collision with a powerline.NTSB DCA03MA022Accident · 21 fatalClass 1 · MajorFinal reportBeech 1900D · Charlotte, NCthe airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…