Skip to content

NTSB investigations, SC

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 MIA71FLG24Accident · No injuriesClosedPiper PA-24 · Florence, SCMar 18, 1971 · N8552P · Substantial damage NTSB MIA71DLG23Accident · No injuriesClosedPiper J-5A · Georgetown, SCMar 14, 1971 · N31172 · Substantial damage NTSB MIA71DLG22Accident · No injuriesClosedLuscombe 8A · Johns Is., SCMar 7, 1971 · N1352K · Substantial damage NTSB MIA71AM076Accident · 8 fatalClosedVolpar E18S · Columbia, SCFeb 26, 1971 · N47A · Destroyed NTSB MIA71AM068Accident · 2 fatalClosedBoeing A75N1 · Beaufort, SCFeb 6, 1971 · N49784 · Destroyed NTSB MIA71AM065Accident · 6 fatalClosedAero Comdr 520 · Columbia, SCFeb 3, 1971 · N4190B · Destroyed NTSB MIA71FLG21Accident · Minor injuriesClosedPiper PA-22 · Calhoun Falls, SCJan 3, 1971 · N802A · Substantial damage NTSB MIA71FLG20Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCDec 16, 1970 · N7923N · Substantial damage NTSB MIA71DLG18Accident · No injuriesClosedCessna 172 · Spartanburg, SCDec 4, 1970 · N6909A · Substantial damage NTSB MIA71FLG19Accident · No injuriesClosedBeech D95A · Hampton, SCDec 3, 1970 · N5740K · Substantial damage NTSB MIA71AM044Accident · 1 fatalClosedBeech H35 · Charleston, SCNov 28, 1970 · N5464D · Destroyed NTSB MIA71DLG17Accident · No injuriesClosedPiper PA-24 · Florence, SCNov 22, 1970 · N8552P · Substantial damage NTSB MIA71DLG16Accident · No injuriesClosedCessna 210 · Clemson, SCNov 21, 1970 · N9491X · Substantial damage NTSB MIA71DLG15Accident · Minor injuriesClosedChampion 7ECA · Allendale, SCNov 15, 1970 · N11045 · Destroyed NTSB MIA71FLG14Accident · Serious injuriesClosedHelio Acft H-295 · Pelion, SCOct 2, 1970 · N6474V · Substantial damage NTSB MIA71FLG12Accident · Minor injuriesClosedCessna 172H · Greenville, SCSep 30, 1970 · N8205L · Destroyed NTSB MIA71FLG11Accident · Minor injuriesClosedPiper PA-32 · Newberry, SCSep 28, 1970 · N3399W · Destroyed NTSB MIA71FLG13Accident · No injuriesClosedCurtiss-Wrt 16K · Rock Hill, SCSep 27, 1970 · N422W · Substantial damage NTSB MIA71AM027Accident · 1 fatalClosedCessna 182B · Darlington, SCSep 17, 1970 · N2570G · Destroyed NTSB MIA71DLG10Accident · No injuriesClosedPiper PA-28 · Greenville, SCSep 1, 1970 · N7254J · Substantial damage NTSB MIA71FLG09Accident · Minor injuriesClosedHughes 269A · Lexington, SCAug 30, 1970 · N8947F · Substantial damage NTSB MIA71FLG08Accident · No injuriesClosedPiper J3C-65 · Hartsville, SCAug 23, 1970 · N98105 · Substantial damage NTSB MIA71DLG07Accident · No injuriesClosedCallair A-9 · Allendale, SCAug 19, 1970 · N3578G · Destroyed NTSB MIA71DLG06Accident · Minor injuriesClosedSchleicher ASW-15 · Chester, SCAug 16, 1970 · N291W · Substantial damage NTSB MIA71FLG05Accident · Serious injuriesClosedPiper J3C · St Charles, SCAug 15, 1970 · N88317 · Destroyed NTSB MIA71FLG04Accident · No injuriesClosedBeech 35 · Jackson, SCAug 13, 1970 · N3027V · Substantial damage NTSB MIA71AM020Accident · 2 fatalClosedPiper PA-30 · Georgetown, SCAug 4, 1970 · N8047Y · Destroyed NTSB MIA71FLG03Accident · No injuriesClosedPiper PA-23 · Charleston, SCJul 30, 1970 · N6279Y · Substantial damage NTSB MIA71FLG02Accident · No injuriesClosedBeech H35 · Cayce, SCJul 15, 1970 · N7920D · Substantial damage NTSB MIA71FLG01Accident · Serious injuriesClosedJeanies T G-W · Spartanburg, SCJul 12, 1970 · N6418 · Substantial damage NTSB MIA70FLG27Accident · No injuriesClosedCessna 175 · Charleston, SCJun 27, 1970 · N7360M · Substantial damage NTSB MIA70AM098Accident · No injuriesClosedLockheed T-33A · Myrtle Beach, SCJun 19, 1970 · AF580501 · 2 aircraft · Minor damage NTSB MIA70DLG24Accident · Serious injuriesClosedPiper PA-18A · Darlington, SCJun 17, 1970 · N1862A · Destroyed NTSB MIA70DLG23Accident · Minor injuriesClosedPiper PA-12 · Mt Pleasant, SCMay 31, 1970 · N3621M · Substantial damage NTSB MIA70DLG21Accident · No injuriesClosedBeech A23-19 · Greenville, SCMay 24, 1970 · N3609Q · Substantial damage NTSB MIA70DLG19Accident · No injuriesClosedCessna 182E · Saluda, SCMay 20, 1970 · N2939Y · Substantial damage NTSB MIA70DLG22Accident · No injuriesClosedBeech P35 · Santee, SCMay 16, 1970 · N1537Z · Substantial damage NTSB MIA70FLG18Accident · Serious injuriesClosedCessna 182B · Charleston, SCMay 8, 1970 · N2452G · Substantial damage NTSB MIA70DLG17Accident · Serious injuriesClosedMooney M20E · Prichardville, SCApr 25, 1970 · N3221F · Substantial damage NTSB MIA70DLG16Accident · Minor injuriesClosedChampion 7HC · Taxahaw, SCApr 22, 1970 · N9968Y · Substantial damage NTSB MIA70FLG15Accident · Minor injuriesClosedCessna 182K · Columbia, SCApr 9, 1970 · N2633Q · Substantial damage NTSB MIA70DLG14Accident · No injuriesClosedCessna 150 · Moncks Corner, SCApr 6, 1970 · N761MA · Substantial damage NTSB MIA70DLG13Accident · No injuriesClosedPiper J3C · Conway, SCMar 30, 1970 · N38341 · Substantial damage NTSB MIA70DLG26Accident · No injuriesClosedSchweizer 1-23 · Catawba, SCMar 29, 1970 · N2704Z · Substantial damage NTSB MIA70DLG12Accident · No injuriesClosedCessna 172 · Columbia, SCMar 24, 1970 · N3784L · Substantial damage NTSB MIA70DLG11Accident · Minor injuriesClosedGlasflugel H-301B · Clover, SCMar 23, 1970 · N1615 · Substantial damage NTSB IAD70II051Incident · No injuriesClosedDouglas DC-8 · Charleston, SCMar 21, 1970 · N4907C · Minor damage NTSB IAD70AI050Accident · 1 fatalClosedCessna 150 · Swansea, SCMar 12, 1970 · N5782G · Destroyed NTSB MIA70DLG10Accident · Minor injuriesClosedCessna 150 · Gaffney, SCMar 10, 1970 · N8356G · Substantial damage NTSB MIA70DLG09Accident · Minor injuriesClosedPiper PA-28 · Walterboro, SCMar 10, 1970 · N4923L · Substantial damage