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 MIA68F0186Accident · No injuriesClosedCessna 182B · Greenville, SCFeb 23, 1967 · N7230E · Minor damage NTSB MIA67D0544Accident · No injuriesClosedBeech A23 · Batesburg, SCFeb 23, 1967 · N8863M · Destroyed NTSB MIA67A0088Accident · 1 fatalClosedCessna 401 · Anderson, SCFeb 22, 1967 · N3212Q · Destroyed NTSB MIA67F0467Accident · No injuriesClosedPiper PA-23 · Cayce, SCFeb 13, 1967 · N1189P · Substantial damage NTSB MIA68D0192Accident · Minor injuriesClosedNavion B · Lane, SCFeb 5, 1967 · N5345K · Substantial damage NTSB MIA67D0537Accident · Minor injuriesClosedCessna 150G · Winnsboro, SCJan 28, 1967 · N4095J · Substantial damage NTSB MIA67D0001Accident · Minor injuriesClosedCessna 172D · Ridgeland, SCJan 22, 1967 · N2732U · Substantial damage NTSB MIA67D0551Accident · Minor injuriesClosedCessna 172B · Allendale, SCJan 21, 1967 · N7651X · Destroyed NTSB MIA67F0373Accident · No injuriesClosedPiper PA-30 · Greenville, SCDec 19, 1966 · N8147Y · Substantial damage NTSB MIA67A0067Accident · 2 fatalClosedCessna 337A · Nbowling Green, SCDec 19, 1966 · N5303S · Destroyed NTSB MIA67F0342Accident · No injuriesClosedPiper PA-22 · West Columbia, SCDec 16, 1966 · N5482Z · Substantial damage NTSB MIA67F0350Accident · No injuriesClosedPiper PA-23 · Charleston, SCDec 8, 1966 · N6162Y · Substantial damage NTSB MIA67D0316Accident · No injuriesClosedBeech T-34A · Spartanburg, SCNov 19, 1966 · N94595 · Substantial damage NTSB MIA67A0049Accident · 4 fatalClosedPiper PA-22 · Cross, SCOct 17, 1966 · N4502A · Destroyed NTSB MIA67D0264Accident · No injuriesClosedBoeing B75N1 · Trenton, SCOct 13, 1966 · N1390V · Destroyed NTSB MIA67F0262Accident · No injuriesClosedMooney M20E · Columbia, SCSep 22, 1966 · N9359M · Substantial damage NTSB MIA67F0255Accident · No injuriesClosedErcoupe 415-C · Lancaster, SCSep 21, 1966 · N2249H · Substantial damage NTSB MIA67D0260Accident · No injuriesClosedCessna 150 · Hartsville, SCSep 18, 1966 · N8680S · Substantial damage NTSB MIA67A0034Accident · 2 fatalClosedPiper PA-22 · Newberry, SCSep 11, 1966 · N1923P · Destroyed NTSB MIA67F0261Accident · Minor injuriesClosedAeronca 65-LB · St-Stephens, SCSep 10, 1966 · N33701 · Destroyed NTSB MIA67F0252Accident · No injuriesClosedPiper PA-30 · Columbia, SCSep 5, 1966 · N7628Y · Substantial damage NTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCSep 4, 1966 · N8070X · Substantial damage NTSB MIA67F0304Accident · No injuriesClosedCallair A-9 · Estill, SCSep 3, 1966 · N3574G · Destroyed NTSB MIA67F0251Accident · No injuriesClosedWaco ASO · Timmonsville, SCSep 2, 1966 · N9500 · Substantial damage NTSB MIA67D0254Accident · No injuriesClosedCessna 210 · Spartanburg, SCSep 2, 1966 · N9542T · Substantial damage NTSB MIA67F0259Accident · No injuriesClosedPiper PA-22 · Pageland, SCAug 22, 1966 · N606A · Substantial damage NTSB MIA67A0028Accident · 1 fatalClosedBoeing D75N1 · Reidville, SCAug 22, 1966 · N65W · Destroyed NTSB MIA67F0253Accident · No injuriesClosedCallair A-9 · Allendale, SCAug 19, 1966 · N3579G · Destroyed NTSB MIA67D0237Accident · No injuriesClosedChampion 7GCB · Darlington, SCAug 18, 1966 · N9951Y · Substantial damage NTSB MIA67A0025Accident · No injuriesClosedBell 47D1 · Crescent Beach, SCAug 13, 1966 · N4253A · Substantial damage NTSB MIA67F0216Accident · Minor injuriesClosedCessna 150D · No. Charleston, SCAug 8, 1966 · N5975T · Substantial damage NTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCAug 8, 1966 · N42595 · Substantial damage NTSB MIA67F0184Accident · No injuriesClosedPiper PA-25 · Darlington, SCAug 4, 1966 · N7276Z · Substantial damage NTSB MIA67A0021Accident · 1 fatalClosedBrantly B-2 · Charleston Hts, SCAug 4, 1966 · N5943X · Substantial damage NTSB MIA67D0180Accident · No injuriesClosedCessna 185E · Moncks Corner, SCJul 25, 1966 · N4552F · Substantial damage NTSB MIA67A0016Accident · No injuriesClosedBeech D18S · Landrum, SCJul 24, 1966 · N84U · Substantial damage NTSB MIA67A0004Accident · No injuriesClosedHughes 269B · Cope, SCJul 7, 1966 · N9410F · Substantial damage NTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCJul 4, 1966 · N8483G · Substantial damage NTSB MIA67D0131Accident · No injuriesClosedPiper PA-22 · Johns Island, SCJul 2, 1966 · N3164Z · Substantial damage NTSB MIA67D0089Accident · Minor injuriesClosedAeronca 7AC · Denmark, SCJun 30, 1966 · N85026 · Substantial damage NTSB MIA67F0079Accident · Minor injuriesClosedPiper PA-22 · Starr, SCJun 15, 1966 · N3659P · Substantial damage NTSB MIA67F0053Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCJun 4, 1966 · N4586R · Substantial damage NTSB MIA66A0139Accident · 1 fatalClosedStits Ray SA3 · Columbia, SCMay 29, 1966 · N177S · Destroyed NTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCMay 20, 1966 · N8479G · Substantial damage NTSB MIA66A0135Accident · 1 fatalClosedPiper PA-28 · Summerton, SCMay 19, 1966 · N8632W · Destroyed NTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCMay 18, 1966 · N73023 · Substantial damage NTSB MIA67F0004Accident · No injuriesClosedPiper PA-28 · Ridgeland, SCMay 13, 1966 · N4586R · Substantial damage NTSB MIA66D0626Accident · No injuriesClosedPiper PA-22 · Cayce, SCMay 12, 1966 · N5668Z · Substantial damage NTSB MIA66D0600Accident · Serious injuriesClosedCessna 170 · Darlington, SCMay 7, 1966 · N2595V · Minor damage NTSB MIA66D0589Accident · No injuriesClosedBeech A23 · Greenville, SCMay 5, 1966 · N1467L · Substantial damage