NTSB investigations, 1997, NC
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
Latest 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\") = 1997
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") = 1997 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 MIA98FA045Accident · 1 fatalField investigationFinal reportCessna 172M · Raleigh-Durham, NCWas loss of control of the airplane on initial climb after entering instrument flight conditions resulting in a turn opposite in direction from that given by ATC, and eventual collision with terrain.NTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…NTSB ATL98FA023Accident · 1 fatalField investigationFinal reportBeech A100 · Charlotte, NCThe pilot's continued approach below decision height without reference to the runway environment, and his failure to execute a missed approach.NTSB ATL98LA020Accident · No injuriesLimited investigationFinal reportCessna 172B · Henderson, NCThe loss of engine power for undetermined reasons.NTSB MIA98FA039Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Lansing, NCthe pilot's failure to maintain clearance from a wire.NTSB MIA98LA027Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Spruce Pine, NCThe unintentional locking-up of the left brake for undetermined reasons resulting in the on ground loss of control. Contributing to the accident was the inability of the pilot to maintain directional control.NTSB MIA98LA028Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCimproper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.NTSB MIA98FA025Accident · No injuriesField investigationFinal reportFokker F100 · Charlotte, NCImproper written instructions (job/task card) by company maintenance personnel. The procedures did not reflect the correct manufactures maintenance manual servicing procedure, and did not ensure that the proper tool (replenishing gun) was available for the…NTSB MIA98LA023Accident · No injuriesLimited investigationFinal reportLet L-13 · Elkin, NCThe instructor's pilot's misjudgment of altitude and distance, and his inadequate compensation for the wind conditions. Unfavorable winds and a fence were contributing factors.NTSB ATL98LA005Accident · No injuriesLimited investigationFinal reportMooney M20C · Hendersonville, NCThe undetermined malfunction of the nose gear steering assembly that resulted in the loss of directional control during a full stop landing. A factor was the rough and uneven runway condition. .NTSB MIA98FA007Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Robbins, NCfailure of the pilots in both aircraft to see-and-avoid each other's airplane (inadequate visual lookout), and failure of the Beech pilot to operate his airplane at a correct Visual Flight Rules (VFR) cruising altitude for his route of flight.NTSB MIA97LA251Accident · No injuriesLimited investigationFinal reportCessna 170 · Troy, NCdelay of the pilot to abort the takeoff after noting sluggish acceleration during the takeoff roll. Factors relating to the accident were: improper timing of the magneto(s), and a malfunction of the carburetor.NTSB ATL97LA142Accident · No injuriesLimited investigationFinal reportBeech 33 · Winston-Salem, NCthe pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.NTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.NTSB ATL97LA138Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairview, NCfuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.NTSB MIA97LA243Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Oxford, NCfatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…NTSB MIA97LA240Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, NCThe failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB ATL97LA126Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164C · Beaufort, NCfailure of the pilot to ensure the tailwheel was properly locked, while taking off on an asphalt runway, which led to loss of directional control and a ground swerve.NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.NTSB MIA97LA229Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Pink Hill, NCFailure of the dual student to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact. Contributing to the accident was improper supervision of the dual student by the pilot-in-command flight instructor.NTSB MIA97LA221Accident · No injuriesLimited investigationFinal reportCessna 188 · Benson, NCThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with a cable, subsequent loss of engine power, forced landing, and an in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB MIA97LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Burnsville, NCThe failure of the pilot to use the checklist to confirm that the main cabin door was closed and locked before takeoff. Also, failure of the pilot to attain the proper touchdown point during the precautionary landing. Contributing to the accident was the self…NTSB MIA97LA205Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Mooresville, NCThe pilot's failure to obtain the proper touchdown point on landing resulting in a go-around, and a subsequent in-flight collision with trees and terrain.NTSB ATL97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Swansboro, NCThe pilot's failure to maintain directional control. A factor was the gusting winds.NTSB ATL97LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Spruce Pine, NCThe pilot's failure to maintain terrain clearance after turning the wrong way in a traffic pattern.NTSB MIA97LA204Accident · No injuriesLimited investigationFinal reportMoran Teenie TWO · Pinehurst, NCThe pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…NTSB ATL97LA102Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Smithfield, NCan animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.NTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…NTSB MIA97FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Asheboro, NCfailure of the pilots in both airplanes to see and/or avoid a collision with each other.NTSB ATL97LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sophia, NCimproper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…NTSB ATL97LA073Accident · 1 fatalLimited investigationFinal reportCapstaff Challenger II · Southern Pines, NCThe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain clearance from obstacles.NTSB MIA97LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wilgrove, NCthe pilot's improper planning, which resulted in fuel exhaustion and a forced landing short of the intended destination airport.NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.NTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.NTSB MIA97LA143Accident · No injuriesLimited investigationFinal reportCessna 150G · Raleigh, NCfailure of the pilot to maintain proper runway alignment during the attempted landing and go-around. Factors relating to the accident were: the gusty crosswind condition, and proximity of trees to the runway.NTSB MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…NTSB MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.NTSB MIA97LA117Accident · No injuriesLimited investigationFinal reportNorth American T6G · Wilmington, NCThe pilot's failure to maintain directional control on landing. Factors were: the crosswind and the pilot's lack of experience in type airplane.NTSB ATL97LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Southern Pines, NCthe student pilot's improper landing flare and the flight instructor's inadequate supervision of the training flight, which led to a hard landing.NTSB MIA97FA097Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Andrews, NCThe pilot's poor in-flight planning in attempting to maintain VFR conditions at night over mountainous terrain, and his failure to maintain clearance from the mountain. Contributing to the accident was: the pilot's inadequate preflight planning for not…NTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.NTSB ATL97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Winston Salem, NCthe pilot's inadequate compensation for wind conditions and failure to maintain directional cntrol of the airplane, which resulted in a ground swerve and collapse of the right main landing gear. The crosswind was a related factor.NTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.NTSB MIA97LA075Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Whiteville, NCThe pilot's intentional operation of the helicopter with known deficiencies in equipment and a false indication of the fuel gauge, resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was inadequate maintenance of…NTSB MIA97LA067Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Salisbury, NCcontinued operation of the aircraft by the flight instructor (CFI) and student after identifying a brake problem, which resulted in a fire that erupted from the brake system and subsequently destroyed the aircraft.NTSB MIA97LA061Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lincolnton, NCThe student pilot's improper use of flaps and failure to maintain airspeed during a go-around.NTSB MIA97FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Edenton, NCthe pilot's continued VFR flight into instrument meteorological conditions. Factors in this accident were: fog, the low ceiling, and the dark night.