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 MIA66D0544Accident · No injuriesClosedCessna 182 · Little River, SCMay 4, 1966 · N8607T · Substantial damage NTSB MIA66A0127Accident · No injuriesClosedHughes 269B · Landrum, SCMay 4, 1966 · N9323F · Substantial damage NTSB MIA66D0581Accident · Minor injuriesClosedPiper PA14 · Lane, SCApr 29, 1966 · N4245H · Substantial damage NTSB MIA66A0123Accident · No injuriesClosedHughes 269A · Orangeburg, SCApr 22, 1966 · N8917F · Substantial damage NTSB MIA66A0122Accident · No injuriesClosedBell 47G-5 · Mcbee, SCApr 21, 1966 · N8556F · Substantial damage NTSB MIA66D0521Accident · No injuriesClosedCessna 172 · Bishopville, SCApr 8, 1966 · N2005Y · Substantial damage NTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCMar 27, 1966 · N5340T · Substantial damage NTSB MIA66F0506Accident · Minor injuriesClosedErco 415-C · St Stephen, SCMar 20, 1966 · N93538 · Substantial damage NTSB MIA66F0502Accident · No injuriesClosedCessna 210 · Bamberg, SCFeb 26, 1966 · N7303E · Substantial damage NTSB MIA66F0441Accident · Minor injuriesClosedPiper J3C · Columbia, SCFeb 20, 1966 · N30551 · Substantial damage NTSB MIA66F0433Accident · No injuriesClosedPiper PA-28 · Columbia, SCFeb 20, 1966 · N7157W · Substantial damage NTSB MIA66F0420Accident · No injuriesClosedCessna 150 · Lake Murray, SCFeb 17, 1966 · N8617G · Substantial damage NTSB MIA66A0088Accident · No injuriesClosedHughes 269A · Sumter, SCFeb 14, 1966 · N8853F · Substantial damage NTSB MIA66F0425Accident · No injuriesClosedBeechcraft 23 · Camden, SCFeb 6, 1966 · N2371Z · Substantial damage NTSB MIA66F0434Accident · No injuriesClosedCessna 180H · Columbia, SCFeb 4, 1966 · CF-RVZ · Substantial damage NTSB MIA66A0080Accident · No injuriesClosedHughes 269B · Saluda, SCJan 8, 1966 · N9356F · Substantial damage NTSB MIA66A0075Accident · 2 fatalClosedUniv Acft GC-1B · Greenville, SCDec 31, 1965 · N2381B · Destroyed NTSB MIA66F0376Accident · Serious injuriesClosedPiper PA22 · Lexington, SCDec 28, 1965 · N4502Z · Substantial damage NTSB MIA66D0361Accident · No injuriesClosedPiper J3C-65 · St George, SCDec 12, 1965 · N98519 · Substantial damage NTSB MIA66F0343Accident · No injuriesClosedPiper PA-22 · Beaufort, SCDec 1, 1965 · N4593Z · Destroyed NTSB MIA66D0339Accident · No injuriesClosedPiper PA-22 · Greenville, SCNov 28, 1965 · N5265Z · Substantial damage NTSB MIA66D0344Accident · No injuriesClosedPiper PA-28 · Pinewood, SCNov 25, 1965 · N8293W · Substantial damage NTSB MIA66D0347Accident · No injuriesClosedPiper PA-24 · Chester, SCNov 13, 1965 · N7375P · Substantial damage NTSB MIA66A0046Accident · 1 fatalClosedPiper PA-18 · Gaffney, SCOct 25, 1965 · N8794D · Destroyed NTSB MIA66D0318Accident · No injuriesClosedPiper J3C-65 · Monetta, SCOct 11, 1965 · N7023H · Substantial damage NTSB MIA66A0039Accident · 1 fatalClosedMong Sport BR SPL · Summerville, SCOct 10, 1965 · N47L · Destroyed NTSB MIA66F0281Accident · No injuriesClosedPiper PA-22 · Columbia, SCOct 5, 1965 · N9630D · Substantial damage NTSB MIA66F0278Accident · No injuriesClosedGlobe GC-1B · Harleyville, SCAug 29, 1965 · N2395B · Destroyed NTSB MIA66D0256Accident · No injuriesClosedPiper PA-24 · Barnwell, SCAug 20, 1965 · N8839P · Substantial damage NTSB MIA66F0174Accident · No injuriesClosedCessna 172 · Little Mtn., SCAug 18, 1965 · N7476A · Substantial damage NTSB MIA66F0146Accident · Serious injuriesClosedPiper PA-25 · Bennettsville, SCAug 6, 1965 · N6673Z · Substantial damage NTSB MIA66D0153Accident · No injuriesClosedCessna 210 · Charleston, SCJul 25, 1965 · N4974U · Substantial damage NTSB MIA66A0015Accident · No injuriesClosedHughes 269B · Cope, SCJul 21, 1965 · N9410F · Substantial damage NTSB MIA66D0087Accident · No injuriesClosedCessna 205 · Florence, SCJul 14, 1965 · N8420Z · Substantial damage NTSB MIA66A0002Accident · No injuriesClosedHughes 269A · Bishopville, SCJul 2, 1965 · N8858F · Substantial damage NTSB MIA65A0121Accident · 1 fatalClosedPiper PA-18 · Hartsville, SCJun 18, 1965 · N7160B · Destroyed NTSB MIA65A0120Accident · No injuriesClosedHughes 269A · Lamar, SCJun 18, 1965 · N8853F · Substantial damage NTSB MIA66F0022Accident · No injuriesClosedPiper PA-30 · Charleston, SCJun 11, 1965 · N7447Y · Substantial damage NTSB MIA66D0038Accident · No injuriesClosedCessna 172E · Bamberg, SCJun 6, 1965 · N3650S · Substantial damage NTSB MIA65F0105Accident · Minor injuriesClosedCessna 172 · Mcbee, SCMay 16, 1965 · N8288B · Substantial damage NTSB MIA65D0109Accident · Serious injuriesClosedCessna 182 · Anderson, SCMay 4, 1965 · N8430T · No damage NTSB MIA65F0127Accident · No injuriesClosedAeronca 7AC · Rock Hill, SCApr 29, 1965 · N82989 · Substantial damage NTSB MIA65D0049Accident · No injuriesClosedCessna 172 · Anderson, SCApr 8, 1965 · N3744S · Substantial damage NTSB MIA65F0060Accident · No injuriesClosedRepublic RC-3 · Georgetown, SCApr 6, 1965 · N6103K · Substantial damage NTSB UNK65X1479Accident · No injuriesClosedCallair A-9 · Allendale, SCMar 27, 1965 · N3579G · Substantial damage NTSB MIA65F0037Accident · Serious injuriesClosedMonocoupe 125 · Johns Island, SCMar 25, 1965 · N797H · Substantial damage NTSB MIA65F0036Accident · No injuriesClosedPiper PA-24 · Georgetown, SCMar 14, 1965 · N8367P · Substantial damage NTSB MIA65F0033Accident · No injuriesClosedStinson 10A · Greenville, SCMar 14, 1965 · N22535 · Substantial damage NTSB MIA65F0041Accident · No injuriesClosedStinson 108-1 · Hampton, SCMar 7, 1965 · N97091 · Substantial damage NTSB MIA65F0016Accident · No injuriesClosedPiper J3C · New Ellenton, SCFeb 27, 1965 · N87841 · Substantial damage