NTSB investigations, SC
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, newest first
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 c.\"eventStateOrRegion\" = 'SC' 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 c."eventStateOrRegion" = 'SC' 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 ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.NTSB ERA09CA333Accident · No injuriesData collectionFinal reportChatham Robert M RV6-A · Gilbert, SCThe pilot’s failure to maintain directional control of the airplane during landing roll. Contributing to the accident was the airspeed indicator that became inoperative during the landing approach.NTSB ERA09CA319Accident · No injuriesData collectionFinal reportCessna A188B · Kingstree, SCThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA09IA315Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Greenville, SCA pitch control malfunction for undetermined reasons.NTSB ERA09LA281Accident · Serious injuriesLimited investigationFinal reportPolaris Motors 582 FIB · Lexington, SCThe non-certificated pilot's failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the non-certificated pilot’s lack of experience in the make and model airplane.NTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.NTSB ERA09LA272Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chesterfield, SCThe partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.NTSB ERA09LA264Accident · No injuriesLimited investigationFinal reportMooney M20J · Moncks Corner, SCThe reported partial loss of engine power for undetermined reasons.NTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.NTSB ERA09CA234Accident · No injuriesData collectionFinal reportCessna 172RG · Charleston, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the diversion of the pilot's attention to an airplane on a converging final approach course.NTSB ERA09CA196Accident · No injuriesData collectionFinal reportPiper PA-28 · Darlington, SCThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the dark night and the pilot's lack of experience.NTSB ERA09LA176Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ridgeland, SCThe pilot's failure to maintain control of the airplane during a precautionary landing. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB ERA09CA165Accident · No injuriesData collectionFinal reportHelio H-295 · Clemson, SCThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB ERA09FA148Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Moncks Corner, SCA loss of aircraft control during the landing approach for undetermined reasons.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.NTSB DCA09IA018Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD88 · Greer, SCThe overheating and arcing of the DC Ground Service Relay and Block Diodes component for undetermined reasons.NTSB ERA09LA019Accident · 1 fatalLimited investigationFinal reportHargett Sky Ranger II · Rock Hill, SCThe non-certificated pilot's failure to maintain airspeed, which resulted in an inadvertent stall and a subsequent impact with the ground. Contributing to the accident were the pilot's lack of training and his impairment due to recent use of marijuana.NTSB ERA09CA012Accident · Minor injuriesData collectionFinal reportCessna 177 · Bluffton, SCThe pilot's inadequate planning and preflight inspection.NTSB NYC08CA325Accident · No injuriesData collectionFinal reportAeronca 7AC · Mt. Pleasant, SCThe pilot's failure to maintain aircraft control during an emergency maneuver. Contributing to the accident was the failure of the left magneto.NTSB DCA08MA098Accident · 4 fatalClass 1 · MajorFinal reportLearjet LR60 · Columbia, SCThe operator’s inadequate maintenance of the airplane’s tires, which resulted in multiple tire failures during takeoff roll due to severe underinflation, and the captain’s execution of a rejected takeoff (RTO) after V1, which was inconsistent with her…NTSB MIA08CA176Accident · Serious injuriesData collectionFinal reportCameron ZL-60 · Anderson, SCThe pilot's improper use of the balloon burners.NTSB NYC08CA277Accident · Minor injuriesData collectionFinal reportMooney M20F · Ridgeland, SCThe pilot's inadequate compensation for a crosswind during landing. A factor contributing to the accident was the crosswind.NTSB NYC08CA272Accident · No injuriesData collectionFinal reportPiper PA32 · Charleston, SCThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the crosswind condition and a wind gust, as reported by the pilot.NTSB MIA08LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB MIA08CA155Accident · No injuriesData collectionFinal reportCubcrafter CC11-100 · Gilbert, SCThe pilot's improper use of brakes during landing roll resulting in a nose-over.NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.NTSB LAX08CA219Accident · No injuriesData collectionFinal reportTallent, Chris M. Putts Special · Sumter, SCthe pilot's failure to maintain the proper glideslope and clearance from obstacles. Contributing to the accident was the pilot's limited experience in the airplane type.NTSB MIA08LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · N Myrtle Beach, SCThe failure of the banner tow operator to inspect banners for deterioration, resulting in a portion of a banner separating in-flight from another banner tow airplane, and colliding with the accident banner tow airplane.NTSB MIA08CA124Accident · No injuriesData collectionFinal reportCessna 172S · Orangeburg, SCThe pilot's failure to obtain the proper touchdown point on landing.NTSB CHI08LA162Accident · No injuriesLimited investigationFinal reportCessna 150L · Summerville, SCA total loss of engine power for undetermined reasons.NTSB NYC08LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCA loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…NTSB CHI08LA125Accident · Serious injuriesLimited investigationFinal reportRans S-12 XL · Pelion, SCA loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.NTSB NYC08TA130Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe pilot's encounter with wake turbulence during approach as a result of his inadequate in-flight planning.NTSB NYC08LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-R200 · York, SCLoss of engine power due to improper welding of the crankcase, which resulted in fatigue failure of the through-studs and a subsequent separation of the number two cylinder. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC08LA061Accident · No injuriesLimited investigationFinal reportCessna 310J · Hilton Head Island, SCThe pilot's failure to maintain aircraft control during a go-around.NTSB NYC08CA006Accident · No injuriesData collectionFinal reportBeech G35 · Lexington, SCThe pilot's inadequate fuel management.NTSB MIA07CA144Accident · Minor injuriesData collectionFinal reportCessna 177 · Columbia, SCThe loss of engine power as a result of the fuel mixture cable failure for undetermined reasons.NTSB NYC07CA220Accident · No injuriesData collectionFinal reportEurocopter AS-350B2 · Greenville, SCThe pilot's failure to maintain a proper descent rate during a precautionary landing, which resulted in a settling with power condition and a subsequent hard landing.NTSB NYC07CA218Accident · No injuriesData collectionFinal reportPiper PA-28-181 · N Myrtle Beach, SCThe pilot's failure to maintain aircraft control during a go-around, which resulted in a collision with water. A factor in this accident was the crosswind conditions.NTSB MIA07LA131Accident · No injuriesLimited investigationFinal reportMBB BK-117 A-4 · Ridgeville, SCThe EMS helicopter pilot's failure to ensure adequate obstacle clearance which resulted in the tail rotor impacting a tree during the takeoff.NTSB NYC07LA157Accident · No injuriesLimited investigationFinal reportMooney M20E · Winnsboro, SCA loss of engine power due to contamination within the fuel injector servo, which was not detected during a recent inadequate annual inspection.NTSB SEA07LA190Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Orangeburg, SCThe pilot's failure to maintain airspeed during go-around which resulted in a stall. The tailwind was a factor.NTSB MIA07CA112Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Greenville, SCThe pilot's inadvertent use of the wrong rudder during initial climb which resulted in a loss of control and collision with the ground.NTSB ATL07LA086Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Columbia, SCThe pilot's improper landing flare, resulting in a hard landing.NTSB SEA07CA136Accident · Minor injuriesData collectionFinal reportLidgard 4-1200 · Spartanburg, SCThe pilot lost directional control of the airplane during takeoff. A contributing factor was the pilot's lack of experience in the accident airplane make/model.NTSB NYC07LA124Accident · 2 fatalLimited investigationFinal reportBoeing Stearman A75N1 · Charleston, SCAn in-flight collision with water for undetermined reasons.NTSB ATL07CA056Accident · No injuriesData collectionFinal reportBeech B24R · Monks Corner, SCThe pilot's misjudgment of speed/distance/altitude which resulted in a undershoot of the runway.NTSB ATL07CA055Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Myrtle Beach, SCThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot's failure to follow emergency procedures when he failed to jettison the advertising banner prior to his forced landing in water.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.