Skip to content

NTSB investigations, SC

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MIA77DLG31Accident · No injuriesClosedSchweizer SGS135 · Rock Hill, SCAug 7, 1977 · N34176 · Substantial damage NTSB MIA77FLG28Accident · No injuriesClosedCessna A188B · Lynchburg, SCAug 6, 1977 · N5619G · Substantial damage NTSB MIA77FLG26Accident · No injuriesClosedCessna A188B · Livingston, SCAug 6, 1977 · N5854G · Destroyed NTSB MIA77DLG25Accident · No injuriesClosedLake LA-4 · Charleston, SCJul 25, 1977 · N6058V · Substantial damage NTSB MIA77FLG24Accident · No injuriesClosedBeech E33 · St Matthews, SCJul 18, 1977 · N7842R · Destroyed NTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCJul 17, 1977 · N2418N · Destroyed NTSB MIA77DLG22Accident · No injuriesClosedBeech 95-A55 · Greenville, SCJul 13, 1977 · N48C · Substantial damage NTSB MIA77DLG21Accident · Minor injuriesClosedMooney M20C · Darlington, SCJul 1, 1977 · N6857N · Substantial damage NTSB MIA77DA066Accident · 2 fatalClosedDavis D-1-W · Camden, SCJun 29, 1977 · N13576 · Destroyed NTSB MIA77DLG20Accident · No injuriesClosedBell 47D · Oswego, SCJun 25, 1977 · N586T · Substantial damage NTSB MIA77FLG19Accident · No injuriesClosedPiper PA-23 · Charleston, SCJun 21, 1977 · N444VM · Substantial damage NTSB MIA77FLG18Accident · No injuriesClosedPiper PA-28 · Barnwell, SCJun 4, 1977 · N56648 · Substantial damage NTSB MIA77DLG17Accident · No injuriesClosedPiper PA-24 · N.Myrtle Beach, SCMay 22, 1977 · N8350P · Substantial damage NTSB MIA77FLG16Accident · Minor injuriesClosedCessna A188B · Hampton, SCMay 7, 1977 · N21675 · Destroyed NTSB MIA77FLG15Accident · 2 fatalClosedStarduster 2 · Camden, SCApr 30, 1977 · N2JL · Destroyed NTSB MIA77FLG14Accident · No injuriesClosedAero Comdr 112A · Union, SCApr 18, 1977 · N1368J · Substantial damage NTSB MIA77DLG13Accident · No injuriesClosedCessna 180 · Chester, SCApr 17, 1977 · N6500A · Substantial damage NTSB MIA77FA046Accident · 1 fatalClosedPiper PA-32 · Charleston, SCMar 15, 1977 · N43216 · Destroyed NTSB MIA77DLG12Accident · Minor injuriesClosedPiper PA-28 · Conway, SCMar 12, 1977 · N75037 · Substantial damage NTSB MIA77FLG11Accident · No injuriesClosedMooney M20F · Whitmire, SCMar 1, 1977 · N6479Q · Substantial damage NTSB MIA77DLG10Accident · No injuriesClosedCessna 150 · Moncks Corner, SCFeb 14, 1977 · N11545 · Substantial damage NTSB MIA77FLG09Accident · No injuriesClosedCessna 210T · Charleston, SCJan 26, 1977 · N732HZ · Substantial damage NTSB MIA77FLG08Accident · No injuriesClosedAero Comdr 100 · Georgetown, SCJan 23, 1977 · N4046X · Destroyed NTSB MIA77DLG07Accident · No injuriesClosedCessna 205 · Charleston, SCJan 10, 1977 · N4831U · Substantial damage NTSB MIA77FLG06Accident · No injuriesClosedCessna 150M · Isle Of Palms, SCJan 8, 1977 · N8805U · Substantial damage NTSB MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCDec 29, 1976 · N5529T · Substantial damage NTSB MIA77FLG04Accident · No injuriesClosedBeech D55 · Charleston, SCDec 27, 1976 · N535Q · Substantial damage NTSB MIA77DLG03Accident · No injuriesClosedPiper PA-28 · Liberty, SCDec 16, 1976 · N5272T · Substantial damage NTSB MIA77FA009Accident · 3 fatalClosedPiper PA-28 · Beaufort, SCNov 15, 1976 · N7286J · Destroyed NTSB MIA77FLG02Accident · No injuriesClosedCessna U206E · Lancaster, SCOct 25, 1976 · N9427G · Destroyed NTSB MIA77FL901Accident · 1 fatalClosedBensen B-8M · Laurens, SCOct 16, 1976 · N6536 · Destroyed NTSB MIA76DLG54Accident · No injuriesClosedCessna 172 · Landrum, SCSep 26, 1976 · N5895R · Substantial damage NTSB MIA76FLG53Accident · Serious injuriesClosedHughes 269B · Batesburg, SCSep 11, 1976 · N9380F · Substantial damage NTSB MIA76FLG51Accident · No injuriesClosedBell 47G · Ridge Spring, SCSep 8, 1976 · N1273 · Substantial damage NTSB MIA76 LG52Accident · No injuriesClosedPiper PA-34 · Timmonsville, SCSep 8, 1976 · N1135X · Substantial damage NTSB MIA76FLG50Accident · Minor injuriesClosedPiper PA-22 · Mcclellanville, SCSep 5, 1976 · N7890D · Destroyed NTSB MIA76FLG49Accident · No injuriesClosedChampion 7ECA · Charleston, SCSep 4, 1976 · N2953G · Substantial damage NTSB MIA76DLG48Accident · No injuriesClosedCessna 188 · Irmo, SCAug 29, 1976 · N21664 · Substantial damage NTSB MIA76DLG39Accident · No injuriesClosedCessna 172 · Neeses, SCAug 29, 1976 · N6482E · Substantial damage NTSB MIA76DLG47Accident · No injuriesClosedCessna 188 · Sumter, SCAug 18, 1976 · N9888V · Substantial damage NTSB MIA76FLG46Accident · No injuriesClosedCessna 195A · Charleston, SCAug 12, 1976 · N1009D · Substantial damage NTSB MIA76FLG45Accident · Minor injuriesClosedPiper PA-30 · Summerton, SCAug 5, 1976 · N1139T · Destroyed NTSB MIA76FLG44Accident · Minor injuriesClosedCessna 180 · Clinton, SCJul 26, 1976 · N9029C · Substantial damage NTSB MIA76FLG43Accident · No injuriesClosedPiper J-3 · Aiken, SCJul 21, 1976 · N35096 · Substantial damage NTSB MIA76DLG42Accident · No injuriesClosedCessna 188 · St Matthews, SCJul 20, 1976 · N53168 · Substantial damage NTSB MIA76FLG41Accident · No injuriesClosedHughes 269B · Orangeburg, SCJul 15, 1976 · N9436F · Destroyed NTSB MIA76FLG40Accident · No injuriesClosedPiper PA-24 · Columbia, SCJul 13, 1976 · N9374P · Substantial damage NTSB MIA76FLG38Accident · Minor injuriesClosedHughes 269A · Fair Play, SCJul 12, 1976 · N8718F · Substantial damage NTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damage NTSB MIA76DLG36Accident · No injuriesClosedCessna 182 · Ridgeland, SCJun 25, 1976 · N6479F · Substantial damage