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 MIA70FLG08Accident · No injuriesClosedCessna 150 · Gaffney, SCMar 7, 1970 · N3931U · Substantial damage NTSB MIA70DLG07Accident · No injuriesClosedPiper PA-28 · Isle Of Palms, SCMar 7, 1970 · N406AF · Substantial damage NTSB MIA70FLG06Accident · No injuriesClosedPiper PA-12 · Calhoun Falls, SCFeb 27, 1970 · N7975H · Substantial damage NTSB MIA70DLG05Accident · Minor injuriesClosedCessna 182D · Varnville, SCFeb 18, 1970 · N8864X · Substantial damage NTSB MIA70DLG04Accident · No injuriesClosedChampion 7ECA · Allendale, SCFeb 14, 1970 · N1873G · Substantial damage NTSB MIA70DLG03Accident · No injuriesClosedPiper PA-23 · Timmonsville, SCFeb 9, 1970 · N5682Y · Substantial damage NTSB MIA70DLG02Accident · No injuriesClosedPiper PA-32 · Bamberg, SCFeb 5, 1970 · N3278W · Substantial damage NTSB MIA70DLG01Accident · Minor injuriesClosedJay Tee RCB-1 · Johns Island, SCJan 31, 1970 · N8142 · Substantial damage NTSB MIA70D0304Accident · No injuriesClosedCessna 310H · Lamar, SCDec 30, 1969 · N433R · Substantial damage NTSB MIA70D0278Accident · No injuriesClosedCessna 170B · Whitmire, SCDec 25, 1969 · N2578C · Substantial damage NTSB MIA70F0280Accident · Minor injuriesClosedBeech 95-C55 · West Columbia, SCDec 24, 1969 · N3045C · Substantial damage NTSB MIA70D0245Accident · Minor injuriesClosedPiper PA-28 · Jenkinsville, SCDec 14, 1969 · N1829J · Substantial damage NTSB MIA70F0237Accident · No injuriesClosedCessna 150J · Charleston, SCNov 11, 1969 · N55168 · Substantial damage NTSB MIA70D0227Accident · No injuriesClosedChampion 7ECA · St George, SCNov 11, 1969 · N2500F · Substantial damage NTSB MIA70F0228Accident · No injuriesClosedCessna 172B · Crescent Beach, SCOct 30, 1969 · N7446X · Substantial damage NTSB MIA70F0233Accident · Minor injuriesClosedLuscombe 8A · Charleston, SCOct 27, 1969 · N71421 · Substantial damage NTSB MIA70F0216Accident · No injuriesClosedCallair A-9 · Fairfax, SCOct 1, 1969 · N7233V · Substantial damage NTSB MIA70D0211Accident · No injuriesClosedCessna 172K · St Stephen, SCSep 26, 1969 · N78339 · Substantial damage NTSB MIA70F0215Accident · No injuriesClosedHughes 269A · Rembert, SCSep 23, 1969 · N8848F · Destroyed NTSB MIA70F0155Accident · Serious injuriesClosedSturgeon A1 · Sumter, SCSep 14, 1969 · N2158 · Destroyed NTSB MIA70D0201Accident · No injuriesClosedChampion 7ECA · Santee, SCSep 14, 1969 · N9584S · Substantial damage NTSB MIA70D0188Accident · No injuriesClosedHughes 269A · Gilbert, SCSep 3, 1969 · N8858F · Substantial damage NTSB MIA70D0220Accident · No injuriesClosedHughes 269A · Lugoff, SCAug 29, 1969 · N8937F · Substantial damage NTSB MIA70F0121Accident · No injuriesClosedBeech 23 · Camden, SCAug 25, 1969 · N2371Z · Substantial damage NTSB MIA70A0013Accident · 1 fatalClosedMooney M20E · Whitmire, SCAug 19, 1969 · N79353 · Destroyed NTSB MIA70D0116Accident · No injuriesClosedStinson 108-2 · Cameron, SCAug 17, 1969 · N290C · Substantial damage NTSB MIA70D0132Accident · No injuriesClosedCessna 182 · Rock Hill, SCAug 13, 1969 · N6352A · Substantial damage NTSB MIA70F0087Accident · No injuriesClosedPiper PA-20 · Ravenel, SCJul 4, 1969 · N7631K · Substantial damage NTSB MIA69A0094Accident · 1 fatalClosedHughes 269A · Brunson, SCJun 27, 1969 · N8809F · Destroyed NTSB MIA70D0106Accident · Minor injuriesClosedCessna 140 · Walterboro, SCJun 26, 1969 · N76115 · Substantial damage NTSB MIA69A0091Accident · 1 fatalClosedPiper PA-30 · Ocean Drive B, SCJun 17, 1969 · N8003Y · Destroyed NTSB MIA70D0056Accident · No injuriesClosedLuscombe 8E · Aiken, SCJun 16, 1969 · N1607K · Substantial damage NTSB MIA70F0026Accident · No injuriesClosedMooney M20C · Columbia, SCJun 15, 1969 · N2592W · Substantial damage NTSB MIA70D0113Accident · No injuriesClosedCessna 182 · Hilton Head, SCJun 13, 1969 · N2869Y · Substantial damage NTSB MIA69A0084Accident · 1 fatalClosedBeech P35 · Bluffton, SCJun 6, 1969 · N9573Y · Destroyed NTSB MIA70D0119Accident · No injuriesClosedBoeing A75 · West Columbia, SCJun 4, 1969 · N55718 · Substantial damage NTSB MIA69F0474Accident · Serious injuriesClosedPiper PA-28 · Pelzer, SCApr 20, 1969 · N6307J · Destroyed NTSB MIA69A0068Accident · 1 fatalClosedCessna 172D · Summerton, SCApr 16, 1969 · N50001 · Substantial damage NTSB MIA69F0443Accident · No injuriesClosedTaylorcraft BC12-D · Summerville, SCApr 3, 1969 · N95233 · Substantial damage NTSB MIA69D0447Accident · Serious injuriesClosedCessna 150 · Clemson, SCMar 23, 1969 · N4010J · Substantial damage NTSB MIA69F0412Accident · No injuriesClosedCessna 172H · Spartanburg, SCMar 13, 1969 · N726F · Substantial damage NTSB MIA69F0444Accident · Serious injuriesClosedCessna 210 · York, SCMar 7, 1969 · N9440T · Substantial damage NTSB MIA69D0362Accident · No injuriesClosedPiper PA-28 · Florence, SCFeb 10, 1969 · N410AF · Substantial damage NTSB MIA69F0352Accident · No injuriesClosedCessna 310 · Shaw Afb, SCJan 25, 1969 · N639F · Substantial damage NTSB MIA69F0337Accident · No injuriesClosedCessna 120 · Kingstree, SCJan 18, 1969 · N1803N · Substantial damage NTSB MIA69F0344Accident · No injuriesClosedBeech N35 · Spartanburg, SCJan 5, 1969 · N2845V · Substantial damage NTSB MIA69F0367Accident · No injuriesClosedBeech 95-C55 · Florence, SCJan 2, 1969 · N5701V · Substantial damage NTSB MIA69D0366Accident · No injuriesClosedPiper PA-32 · Walterboro, SCDec 28, 1968 · N3256W · Substantial damage NTSB MIA69F0318Accident · No injuriesClosedLuscombe 8E · Blenheim, SCDec 26, 1968 · N944BL · Substantial damage NTSB MIA69D0334Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCDec 13, 1968 · N5186L · Substantial damage