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 MIA80FA008Accident · 5 fatalClosedPiper PA-31 · Greenville, SCNov 2, 1979 · N66893 · Destroyed NTSB MIA80DLG02Accident · No injuriesClosedCessna 150 · Moncks Corner, SCOct 21, 1979 · N8669S · Substantial damage NTSB MIA80DLG01Accident · Minor injuriesClosedQuickie 1 · Allendale, SCOct 19, 1979 · N9662 · Destroyed NTSB MIA79DLG38Accident · Minor injuriesClosedHughes 269A · Trenton, SCSep 29, 1979 · N8853F · Destroyed NTSB MIA79FA129Accident · No injuriesClosedBeech D18S · Sumter, SCSep 28, 1979 · N646B · Substantial damage NTSB MIA79FA126Accident · 2 fatalClosedPiper PA-28 · Hartsville, SCSep 20, 1979 · N5137S · Destroyed NTSB MIA79FLG32Accident · No injuriesClosedCallair A-9 · Johnsonville, SCSep 11, 1979 · N3582G · Destroyed NTSB MIA79DLG31Accident · No injuriesClosedPiper PA-16 · Ridgeland, SCSep 8, 1979 · N5343H · Substantial damage NTSB MIA79IA119Incident · No injuriesClosedNamc YS-11A · Anderson, SCSep 1, 1979 · N158P · No damage NTSB MIA79FLG27Accident · No injuriesClosedCessna 177RG · Charleston, SCAug 26, 1979 · N1888Q · Substantial damage NTSB MIA79DLG29Accident · Minor injuriesClosedHiller UH-12E · Timmonsville, SCAug 20, 1979 · N121NR · Substantial damage NTSB MIA79FLG28Accident · No injuriesClosedPiper PA-18 · Greeleyville, SCAug 17, 1979 · N4508Y · Substantial damage NTSB MIA79DLG30Accident · No injuriesClosedBellanca 8GCBC · Sycamore, SCAug 17, 1979 · N7686S · Destroyed NTSB MIA79FLG26Accident · No injuriesClosedMooney M20E · St Matthews, SCJul 27, 1979 · N1270X · Substantial damage NTSB MIA79FLG25Accident · No injuriesClosedCessna 152 · Greeleyville, SCJul 2, 1979 · N41022 · Substantial damage NTSB MIA79FLG24Accident · No injuriesClosedCessna 421B · Trenton, SCJun 21, 1979 · N41022 · Substantial damage NTSB MIA79DLG23Accident · No injuriesClosedCessna 172 · Laurens, SCMay 26, 1979 · N21124 · Substantial damage NTSB MIA79FA085Accident · 1 fatalClosedCessna 182P · Eastover, SCMay 17, 1979 · N78744 · Destroyed NTSB MIA79FLG22Accident · Minor injuriesClosedPiper PA-28 · Ridgeland, SCApr 28, 1979 · N15197 · Destroyed NTSB MIA79DLG21Accident · No injuriesClosedCessna 152 · Williamton, SCApr 23, 1979 · N25833 · Substantial damage NTSB MIA79FLG20Accident · No injuriesClosedCessna 210M · Beech Island, SCApr 2, 1979 · N9898M · Substantial damage NTSB MIA79FLG19Accident · 1 fatalClosedScorpion TOO · Johns Island, SCMar 27, 1979 · N97521 · Substantial damage NTSB MIA79FA057Accident · 1 fatalClosedPiper PA-28 · Camden, SCMar 18, 1979 · N6920W · Destroyed NTSB MIA79FLG18Accident · Serious injuriesClosedCessna 152 · Folly Beach, SCFeb 2, 1979 · N65492 · Substantial damage NTSB MIA79FLG12Accident · Minor injuriesClosedPiper PA-25 · Holly Hill, SCJan 3, 1979 · N8534L · Substantial damage NTSB MIA79FLG15Accident · No injuriesClosedCessna 152 · Mullins, SCDec 26, 1978 · N648CA · Substantial damage NTSB MIA79DLG16Accident · No injuriesClosedCessna 152 · Ridgeland, SCDec 26, 1978 · N757DT · Substantial damage NTSB MIA79FLG14Accident · No injuriesClosedCessna 150 · Mccoll, SCDec 23, 1978 · N3010S · Substantial damage NTSB MIA79FLG13Accident · Minor injuriesClosedCessna R172E · Clover, SCDec 23, 1978 · N94461 · Substantial damage NTSB MIA79DLG11Accident · No injuriesClosedCessna 172D · Johns Island, SCDec 16, 1978 · N855X · Substantial damage NTSB MIA79DLG10Accident · No injuriesClosedBeech B24 · Rock Hill, SCDec 16, 1978 · N6543R · Substantial damage NTSB MIA79DLG09Accident · No injuriesClosedCessna 152 · Manning, SCDec 6, 1978 · N714WK · Substantial damage NTSB MIA79FA028Accident · 1 fatalClosedCessna 182 · Union, SCDec 5, 1978 · N7535N · Destroyed NTSB MIA79FLG08Accident · Serious injuriesClosedM00ney M20C · Clio, SCDec 3, 1978 · N2647W · Destroyed NTSB MIA79FLG07Accident · Minor injuriesClosedHughes 269B · Camden, SCDec 3, 1978 · N9455F · Substantial damage NTSB MIA79FLG04Accident · Minor injuriesClosedBrittnorman BN-2A · Beaufort, SCDec 3, 1978 · N25DA · Substantial damage NTSB MIA79FLG06Accident · 1 fatalClosedFly Baby 1A · Moncks Corner, SCDec 2, 1978 · N8371 · Destroyed NTSB MIA79FLG17Accident · No injuriesClosedHiller FH1100 · West Columbia, SCDec 1, 1978 · N8126H · Substantial damage NTSB MIA79FLG05Accident · No injuriesClosedPiper PA-12 · N.Myrtle Bch, SCNov 29, 1978 · N3976M · Substantial damage NTSB MIA79FA022Accident · 2 fatalClosedPiper PA32RT · Charleston, SCNov 29, 1978 · N9771C · Destroyed NTSB MIA79FLG03Accident · Serious injuriesClosedCessna 182 · Clemson, SCOct 21, 1978 · N2243G · Destroyed NTSB MIA79FLG02Accident · No injuriesClosedPiper PA-28 · Columbia, SCOct 16, 1978 · N6927J · Substantial damage NTSB MIA79FLG01Accident · No injuriesClosedCessna 182P · Hilton Head, SCOct 10, 1978 · N7419Q · Substantial damage NTSB MIA78FLG39Accident · Minor injuriesClosedPiper PA-15 · Isle Of Palms, SCSep 18, 1978 · N4390H · Substantial damage NTSB MIA78FLG38Accident · No injuriesClosedCessna 310 · Gaston, SCSep 18, 1978 · N6942T · Substantial damage NTSB MIA78FLG37Accident · Serious injuriesClosedCessna 172 · Trenton, SCSep 8, 1978 · N9816V · Substantial damage NTSB MIA78FA122Accident · 2 fatalClosedPiper PA-38 · Florence, SCSep 8, 1978 · N4425E · Destroyed NTSB MIA78DLG36Accident · No injuriesClosedBell 47D1 · Summerville, SCAug 26, 1978 · N4116A · Substantial damage NTSB MIA78FLG33Accident · No injuriesClosedBellanca 8GCBC · Ulmer, SCAug 25, 1978 · N7686S · Substantial damage NTSB MIA78FLG32Accident · Serious injuriesClosedPiper PA-25 · Bennettsville, SCAug 21, 1978 · N7190Z · Destroyed