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 IAD74II054Incident · No injuriesClosedGrumman G-159 · Charlestown, SCApr 8, 1974 · N8E · Minor damage NTSB MIA74AM084Accident · 1 fatalClosedCessna 182A · Seneca, SCApr 4, 1974 · N6044B · Destroyed NTSB MIA74FLG26Accident · Serious injuriesClosedCessna 177 · Hilton Head, SCMar 30, 1974 · N2245Y · Substantial damage NTSB MIA74FLG25Accident · Serious injuriesClosedCessna 182 · Allendale, SCMar 10, 1974 · N5412B · Substantial damage NTSB MIA74AM073Accident · 1 fatalClosedPiper PA-28 · Georgetown, SCFeb 22, 1974 · N1894J · Destroyed NTSB MIA74DLG24Accident · No injuriesClosedPiper PA-28 · Florence, SCFeb 18, 1974 · N56821 · Substantial damage NTSB MIA74DLG23Accident · Minor injuriesClosedChampion 7ECA · Plantersville, SCFeb 13, 1974 · N2986G · Substantial damage NTSB MIA74DLG22Accident · No injuriesClosedCessna 150 · N Myrtle Bch, SCJan 27, 1974 · N6551F · Substantial damage NTSB MIA74FLG21Accident · No injuriesClosedHughes 269-A · St Matthews, SCJan 22, 1974 · N8718F · Substantial damage NTSB MIA74DLG20Accident · No injuriesClosedCessna 150 · Union, SCJan 22, 1974 · N62795 · Substantial damage NTSB MIA74DLG19Accident · No injuriesClosedCessna 150 · Myrtle Beach, SCJan 14, 1974 · N6534G · Substantial damage NTSB MIA74FLG18Accident · Serious injuriesClosedPiper J-3C · Sumter, SCJan 6, 1974 · N98000 · Destroyed NTSB NYC74IN062Incident · No injuriesClosedDouglas DC-8 · Columbia, SCJan 3, 1974 · N8148PA · Minor damage NTSB MIA74AM053Accident · 2 fatalClosedPiper PA-30 · Charleston, SCJan 1, 1974 · N8546Y · Destroyed NTSB MIA74AM049Accident · 2 fatalClosedBeech C90 · W Columbia, SCDec 20, 1973 · N711FC · Destroyed NTSB MIA74FLG17Accident · No injuriesClosedPiper PA-28R · Winnsboro, SCDec 19, 1973 · N16361 · Substantial damage NTSB MIA74FLG16Accident · Serious injuriesClosedBeech A35 · Easley, SCNov 14, 1973 · N528B · Destroyed NTSB MIA74DLG14Accident · No injuriesClosedCessna 182 · Summerville, SCNov 11, 1973 · N2708G · Substantial damage NTSB MIA74FLG13Accident · No injuriesClosedCessna 150F · Barnwell, SCNov 4, 1973 · N8297F · Substantial damage NTSB MIA74FLG12Accident · Serious injuriesClosedPiper PA-18A · Fairfax, SCSep 1, 1973 · N9087D · Destroyed NTSB MIA74D1011Accident · Minor injuriesClosedBell 47G-2 · Dalzell, SCAug 31, 1973 · N6711D · Substantial damage NTSB MIA74DLG10Accident · No injuriesClosedAmer Avco AA-1 · Conway, SCAug 30, 1973 · N5962L · Substantial damage NTSB MIA74DLG09Accident · Minor injuriesClosedPiper PA-18A · Bishopville, SCAug 30, 1973 · N8991D · Substantial damage NTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCAug 25, 1973 · N7001H · Substantial damage NTSB MIA74DLG07Accident · No injuriesClosedCessna 188 · Bennettsville, SCAug 24, 1973 · N4454Q · Substantial damage NTSB MIA74AM015Accident · 1 fatalClosedAmer Avco AA-5 · Abbeville, SCAug 16, 1973 · N5478L · Destroyed NTSB MIA74FLG06Accident · No injuriesClosedBoeing A75N1 · Allendale, SCAug 13, 1973 · N64980 · Substantial damage NTSB MIA74FLG05Accident · Minor injuriesClosedCessna 182K · Abbeville, SCAug 7, 1973 · N2731Q · Substantial damage NTSB MIA74DLG04Accident · No injuriesClosedBell 47D-1 · Bennettsville, SCAug 4, 1973 · N1MH · Substantial damage NTSB MIA74FLG03Accident · No injuriesClosedPiper PA-25 · Mcclellanville, SCJul 25, 1973 · N6177Z · Substantial damage NTSB MIA74FLG02Accident · No injuriesClosedGrumman G-164A · Marion, SCJul 20, 1973 · N8497 · Destroyed NTSB MIA74AM006Accident · 3 fatalClosedCessna 150E · Andrews, SCJul 19, 1973 · N2549J · Destroyed NTSB MIA73FLG01Accident · No injuriesClosedHughes 269B · Wagener, SCJul 13, 1973 · N9380F · Substantial damage NTSB MIA74AM001Accident · 3 fatalClosedAeronca 7AC · Kershaw, SCJul 8, 1973 · N82561 · Destroyed NTSB MIA73DLG52Accident · No injuriesClosedCessna 150 · New Ellenton, SCJun 29, 1973 · N3269J · Substantial damage NTSB MIA73DLG51Accident · No injuriesClosedCessna 182J · Cross, SCJun 25, 1973 · N2630F · Substantial damage NTSB MIA73FLG50Accident · Serious injuriesClosedSchemp Cirrus · Chester, SCJun 24, 1973 · N8083 · Destroyed NTSB MIA73DLG49Accident · No injuriesClosedHelio Acft H-295 · Greenville, SCJun 20, 1973 · N275ZD · Substantial damage NTSB MIA73FLG48Accident · No injuriesClosedCessna U206C · Little River, SCJun 1, 1973 · N29147 · Substantial damage NTSB MIA73FLG47Accident · No injuriesClosedThurston TSC-1A · Florence, SCMay 18, 1973 · N2010T · Substantial damage NTSB MIA73DLG46Accident · No injuriesClosedPiper PA-22 · Rock Hill, SCMay 17, 1973 · N606A · Substantial damage NTSB MIA73FLG45Accident · No injuriesClosedAero Comdr 560F · Greer, SCApr 24, 1973 · N59JR · Substantial damage NTSB MIA73FLG44Accident · Serious injuriesClosedCessna 150B · Columbia, SCApr 18, 1973 · N2860S · Destroyed NTSB MIA73FLG43Accident · No injuriesClosedPiper PA-23 · Cameron, SCApr 6, 1973 · N681M · Destroyed NTSB MIA73FLG42Accident · No injuriesClosedBeech 95-C55 · Orangeburg, SCApr 5, 1973 · N4112 · Substantial damage NTSB MIA73DLG41Accident · No injuriesClosedPiper PA-28 · Little River, SCApr 2, 1973 · N9466W · Substantial damage NTSB MIA73DLG40Accident · No injuriesClosedPiper PA-12 · Kinards, SCMar 27, 1973 · N92536 · Substantial damage NTSB MIA73DLG39Accident · No injuriesClosedNavion A · Pelzer, SCMar 26, 1973 · N27A · Substantial damage NTSB MIA73FLG38Accident · Minor injuriesClosedCessna 170 · Georgetown, SCMar 25, 1973 · N2557V · Substantial damage NTSB MIA73DLG37Accident · No injuriesClosedCessna 150F · Timmonsville, SCMar 24, 1973 · N3086X · Substantial damage