NTSB investigations, 1996, 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\") = 1996
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") = 1996 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 MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…NTSB ATL97FA029Accident · 2 fatalField investigationFinal reportMooney M20C · Roxboro, NCfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: the pilot's use of an unapproved drug, low ceiling, restricted visibility (fog), and an undetermined anomaly with the vacuum system.NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.NTSB MIA97LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Walnut Cove, NCfailure of the pilot/owner (PIC) to either go around while there was sufficient runway remaining or apply adequate braking to stop the aircraft before overrunning the runway. Factors relating to the accident were: the pilot/owner's misjudgment of distance and…NTSB MIA97FA020Accident · 3 fatalField investigationFinal reportPiper PA-60-600 · New Bern, NCthe pilot's failure to maintain airspeed (VMC). Contributing to the accident was his lack of total experience in kind of aircraft.NTSB ATL97LA006Accident · No injuriesLimited investigationFinal reportCessna 337G · Fayetteville, NCThe unapproved maintenance modification of the landing gear electrical system by maintenance personnel that prevented the extension of the landing gear.NTSB ATL97LA004Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Angier, NCThe Aeronca 65's pilots selection of the wrong taxi route, and his inadequate visual lookout during back taxi.NTSB ATL96LA131Accident · No injuriesLimited investigationFinal reportBeech A23 · Tarboro, NCfatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.NTSB MIA96LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Farmville, NCThe pilot's inadequate fuel consumption calculations which resulted in loss of engine power do to fuel exhaustion and a hard landing during a forced landing in a field.NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.NTSB ATL96LA109Accident · No injuriesLimited investigationFinal reportBeech 58P · Banner Elk, NCthe pilot's misjudgment of distance and speed during the approach to land, and his failure to attain the proper touchdown point on the runway for the landing, which resulted in an overrun and collision with a tree.NTSB ATL96LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gatesville, NCThe pilot's inadequate preflight inspection which resulted in engine stoppage due to water contamination in the fuel system. A factor was the lack of suitable terrain for a forced landing.NTSB ATL96LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Hickory, NCEngine stoppage for undetermined reasons. A factor was the terrain furrows.NTSB ATL96LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsborough, NCThe failure of the magneto impulse coupling spring. A factor was the power line at the approach end of the forced landing site.NTSB MIA96LA174Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Kinston, NCfailure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.NTSB MIA96LA167Accident · Minor injuriesLimited investigationFinal reportBeech B55B · Clinton, NCa loss of right engine power for undetermined reasons, resulting in the pilot loosing control of the airplane and impact with tress.NTSB MIA96LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCfailure of the flight instructor (CFI) to ensure proper use of the carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent emergency landing.NTSB ATL96LA089Accident · No injuriesLimited investigationFinal reportSchweizer SGS233A · Franklinton, NCthe failure of the instructor pilot to maintain control of the aircraft.NTSB MIA96GA138Accident · 1 fatalFinal reportWsk Pzl Mielec M18A · Kinston, NCa cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB MIA96LA135Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Raeford, NCfailure of the passenger to follow the instructions of ground personnel as she exited the aircraft.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB MIA96LA126Accident · No injuriesLimited investigationFinal reportLuttrell-Lacky Breezy · Hendersonville, NCinadequate preflight planning/preparation by the pilot, by not adequately surveying the area to be used for takeoff, which resulted in a collision with a fence.NTSB MIA96LA123Accident · Serious injuriesLimited investigationFinal reportVernon L. Cox COX-HAWK · Mebane, NCThe pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…NTSB ATL96LA073Accident · No injuriesLimited investigationFinal reportCanadair CL-600S · Raleigh, NCthe flight crew's inadequate emergency procedure in that they did not manually extend the landing gear, as specified in the airplane flight manual. A factor relating to the accident was: the intermittent operation of the extend solenoid in the nose gear…NTSB ATL96LA072Accident · No injuriesLimited investigationFinal reportCessna 140 · Elkin, NCfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.NTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.NTSB ATL96LA054Accident · No injuriesLimited investigationFinal reportCessna 210 · Kinston, NCThe pilot's failure to compensate for the crosswind and his inadequate weather evaluation. A factor was the gusty crosswind.NTSB ATL96IA053Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Raleigh, NCThe operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…NTSB MIA96FA082Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Morganton, NCthe pilot's delay in initiating a go-around (aborted landing), which resulted in his failure to obtain/maintain sufficient altitude or clearance from trees beyond the end of the runway. Factors relating to the accident were: the pilot's failure to ensure…