Skip to content

NTSB investigations, SC

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ATL81DLG19Accident · No injuriesClosedAir Tractor AT-301 · Manning, SCAug 6, 1981 · N4358S · Substantial damage NTSB ATL81FLG18Accident · No injuriesClosedHiller Acft FH1100 · Jonesville, SCJul 30, 1981 · N370FH · Substantial damage NTSB ATL81FLG17Accident · Serious injuriesClosedPiper PA-28 · Mcclellanville, SCJul 30, 1981 · N6374R · Substantial damage NTSB ATL81FLG16Accident · No injuriesClosedPiper PA-28 · Summerville, SCJul 23, 1981 · N1955T · Substantial damage NTSB ATL81FLG15Accident · Minor injuriesClosedBeech C24R · Bennettsville, SCJul 15, 1981 · N77VS · Substantial damage NTSB ATL81FLG14Accident · Minor injuriesClosedRockwell S2R · Ridgeland, SCJun 27, 1981 · N4163X · Destroyed NTSB ATL81FLG13Accident · Serious injuriesClosedQuail 1 · Greer, SCJun 23, 1981 · N6703 · Destroyed NTSB ATL81FLG12Accident · No injuriesClosedCessna 150 · Saluda, SCJun 14, 1981 · N45329 · Substantial damage NTSB ATL81FLG11Accident · No injuriesClosedPiper PA-30 · Hilton Head Is, SCJun 11, 1981 · N8264Y · Substantial damage NTSB ATL81DLG10Accident · No injuriesClosedCessna 150 · North, SCJun 10, 1981 · N5679G · Substantial damage NTSB NYC81IA053Incident · Serious injuriesClosedAirbus A300 · Charleston, SCJun 2, 1981 · N291EA · No damage NTSB ATL81FA071Accident · 1 fatalClosedMooney M20J · Cades, SCMay 7, 1981 · N201YX · Destroyed NTSB ATL81FLG09Accident · Serious injuriesClosedSchempp STD CS · Chester, SCApr 24, 1981 · N15PE · Destroyed NTSB ATL81FA066Accident · No injuriesClosedMooney M-20F · Conway, SCApr 17, 1981 · N9661V · Substantial damage NTSB ATL81FA053Accident · 2 fatalClosedPiper PA-23 · Kingstree, SCMar 11, 1981 · N6545Y · Destroyed NTSB ATL81FA047Accident · 2 fatalClosedCessna 172N · Jenkinsville, SCFeb 13, 1981 · N733KW · Destroyed NTSB ATL81FA041Accident · No injuriesClosedPiper PA-28R · Roebuck, SCFeb 2, 1981 · N57373 · Substantial damage NTSB ATL81DLG08Accident · No injuriesClosedCessna 182 · Clemson, SCJan 19, 1981 · N6347B · Substantial damage NTSB ATL81FLG07Accident · No injuriesClosedCessna 150H · Greer, SCNov 30, 1980 · N7075S · Substantial damage NTSB ATL81FA019Accident · 5 fatalClosedPiper PA-32 · Hilton Head, SCNov 30, 1980 · N3242W · 2 aircraft · Destroyed NTSB ATL81FLG06Accident · Serious injuriesClosedPiper PA-28 · Clemson, SCNov 25, 1980 · N6618J · Substantial damage NTSB ATL81DLG05Accident · No injuriesClosedCessna 152 · Murrells Inlet, SCNov 4, 1980 · N89096 · Substantial damage NTSB ATL81FLG04Accident · Serious injuriesClosedCessna 402B · Salley, SCNov 1, 1980 · N8159Q · Destroyed NTSB ATL81DLG03Accident · No injuriesClosedPiper PA-28 · Allendale, SCOct 25, 1980 · N2052R · Substantial damage NTSB ATL81FLG02Accident · Serious injuriesClosedAero Comdr 680FLP · Columbia, SCOct 17, 1980 · N1167Z · Destroyed NTSB ATL80FLG01Accident · No injuriesClosedGrumman G-164B · Kingstree, SCOct 16, 1980 · N6605K · Substantial damage NTSB ATL80FLG19Accident · Minor injuriesClosedCessna 172M · Manning, SCSep 5, 1980 · N92388 · Substantial damage NTSB ATL80FA087Accident · 1 fatalClosedCessna A150L · Anderson, SCSep 1, 1980 · N6082J · Destroyed NTSB ATL80FA086Accident · 1 fatalClosedChampion 7BCM · Lake City, SCAug 26, 1980 · N19CF · Destroyed NTSB ATL80FLG17Accident · No injuriesClosedAir Tractor AT-301 · Ehrhardt, SCAug 15, 1980 · N4411S · Substantial damage NTSB ATL80FA082Accident · 1 fatalClosedCessna 150 · Oswego, SCAug 7, 1980 · N7008G · Destroyed NTSB ATL80FLG16Accident · Serious injuriesClosedPiper PA-28 · Galivant Ferry, SCJul 25, 1980 · N6016W · Destroyed NTSB ATL80FA072Accident · 1 fatalClosedPiper PA-31P · Charleston, SCJul 10, 1980 · N776SW · Destroyed NTSB ATL80FLG14Accident · No injuriesClosedBeech A35 · Saluda, SCJun 28, 1980 · N489B · Substantial damage NTSB ATL80FLG15Accident · No injuriesClosedHughes 269 · Beaufort, SCJun 27, 1980 · N8845F · Destroyed NTSB ATL80FLG13Accident · Serious injuriesClosedCessna 182 · Barnwell, SCJun 5, 1980 · N52641 · Substantial damage NTSB ATL80FLG11Accident · Minor injuriesClosedCessna 120 · Union, SCMay 31, 1980 · N72812 · Substantial damage NTSB ATL80DLG12Accident · No injuriesClosedTexas Heli M-74 · Walterboro, SCMay 30, 1980 · N38099 · Substantial damage NTSB ATL80FA050Accident · 2 fatalClosedBeech P35 · Bennettsville, SCMay 25, 1980 · N1529Z · Destroyed NTSB ATL80DLG10Accident · No injuriesClosedPiper PA-28R · Sumter, SCMay 5, 1980 · N32994 · Substantial damage NTSB ATL80FLG09Accident · No injuriesClosedCessna 180D · Summerton, SCMay 4, 1980 · N6462X · Substantial damage NTSB MIA80DLG08Accident · No injuriesClosedBoeing A75N1 · Columbia, SCApr 6, 1980 · N55718 · Substantial damage NTSB MIA80FLG07Accident · Minor injuriesClosedCessna U206G · Columbia, SCMar 21, 1980 · N733EU · Substantial damage NTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCMar 10, 1980 · N1438X · Destroyed NTSB MIA80DLG06Accident · No injuriesClosedPiper PA-32 · N Myrtle Beach, SCMar 4, 1980 · N3737M · Substantial damage NTSB MIA80FLG05Accident · Serious injuriesClosedCessna 150M · Spartanburg, SCFeb 1, 1980 · N150ED · Substantial damage NTSB MIA80DLG04Accident · No injuriesClosedCessna 180 · Camden, SCJan 6, 1980 · CG-CAJ · Substantial damage NTSB MIA80FLG03Accident · Minor injuriesClosedBellanca 17-31A · Isle Of Palms, SCNov 21, 1979 · N8857V · Substantial damage NTSB MIA80FA012Accident · 2 fatalClosedDouglas C-54D · Mccormick, SCNov 19, 1979 · N8060C · Destroyed NTSB MIA80FA010Accident · 2 fatalClosedErco 415-C · Bishopville, SCNov 18, 1979 · N99484 · Destroyed