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 MIA78FLG34Accident · No injuriesClosedBell 47G · Murrels Inlet, SCAug 16, 1978 · N25802 · Substantial damage NTSB MIA78FLG33Accident · No injuriesClosedGrumman G-164B · Little Rock, SCAug 16, 1978 · N6764Q · Destroyed NTSB MIA78DA112Accident · 1 fatalClosedSchemp Nimbus · Mt Groghan, SCAug 9, 1978 · N2WH · Destroyed NTSB MIA78DLG31Accident · Minor injuriesClosedLake LA-4 · Lexington, SCAug 6, 1978 · N6676L · Destroyed NTSB MIA78FLG30Accident · No injuriesClosedMooney M20E · Lexington, SCJul 27, 1978 · N6992U · Substantial damage NTSB MIA78FLG29Accident · Minor injuriesClosedCessna 182P · Ehrhardt, SCJul 22, 1978 · N9437M · Substantial damage NTSB MIA78DLG28Accident · No injuriesClosedCessna 310K · Landrum, SCJul 12, 1978 · N18HF · Substantial damage NTSB MIA78FLG27Accident · Minor injuriesClosedPiper PA-32 · Beaufort, SCJul 5, 1978 · N9885K · Destroyed NTSB MIA78DLG26Accident · No injuriesClosedPiper J-3 · Newberry, SCJul 2, 1978 · N2152M · Substantial damage NTSB MIA78FLG25Accident · Serious injuriesClosedPiper J3C · Harleyville, SCJun 21, 1978 · N70998 · Substantial damage NTSB MIA78DLG24Accident · No injuriesClosedCessna 177 · Hilton Head, SCJun 16, 1978 · N29607 · Substantial damage NTSB MIA78FLG23Accident · No injuriesClosedGrumman G-164B · Lane, SCJun 14, 1978 · N6648Q · Destroyed NTSB MIA78FLG21Accident · Serious injuriesClosedCessna 150L · Columbia, SCJun 12, 1978 · N6751G · Destroyed NTSB MIA78DLG12Accident · No injuriesClosedCessna 188A · Ehrhardt, SCMay 31, 1978 · N731KJ · Substantial damage NTSB MIA78FLG19Accident · Serious injuriesClosedJungster 1 · Ridgeville, SCMay 15, 1978 · N8VM · Substantial damage NTSB MIA78DLG20Accident · No injuriesClosedMolino PIK20B · York, SCApr 23, 1978 · N21AW · Substantial damage NTSB MIA78FLG18Accident · No injuriesClosedAeronca 7AC · Loris, SCApr 15, 1978 · N83649 · Substantial damage NTSB MIA78FLG17Accident · Minor injuriesClosedPiper PA-30 · Landrum, SCApr 8, 1978 · N8563Y · Destroyed NTSB MIA78FLG16Accident · Serious injuriesClosedRockwell 114 · Charleston, SCApr 1, 1978 · N4762 · Substantial damage NTSB MIA78DLG12Accident · No injuriesClosedCessna 182 · Pelzer, SCApr 1, 1978 · N58469 · Substantial damage NTSB MIA78DLG15Accident · No injuriesClosedPiper PA32 · Summerville, SCMar 26, 1978 · N1104X · Substantial damage NTSB MIA78DLG14Accident · No injuriesClosedNavion B · Abbeville, SCMar 26, 1978 · N5156K · Substantial damage NTSB MIA78FLG13Accident · No injuriesClosedBeech 65-80 · Columbia, SCMar 22, 1978 · N3YY · Substantial damage NTSB MIA78FLG11Accident · No injuriesClosedBeech E18S · West Columbia, SCMar 14, 1978 · N383B · Substantial damage NTSB MIA78FA049Accident · 1 fatalClosedPiper PA-28 · Bishopville, SCMar 5, 1978 · N8827J · Destroyed NTSB MIA78DLG09Accident · Minor injuriesClosedCessna 172 · Greenville, SCFeb 20, 1978 · N6882A · Substantial damage NTSB MIA78FLG10Accident · No injuriesClosedCessna 152 · High Falls, SCFeb 19, 1978 · N49799 · Substantial damage NTSB MIA78FA043Accident · 2 fatalClosedBeech V35B · Myrtle Beach, SCFeb 17, 1978 · N17523 · Destroyed NTSB MIA78FLG07Accident · No injuriesClosedCessna 401 · Spartanburg, SCFeb 13, 1978 · N4091Q · Substantial damage NTSB MIA78FLG08Accident · Minor injuriesClosedPitts S1-S · Spartanburg, SCFeb 11, 1978 · N39CH · Destroyed NTSB MIA78FLG05Accident · Minor injuriesClosedCessna 172M · Camden, SCJan 10, 1978 · N9634H · Destroyed NTSB MIA78DLG06Accident · Minor injuriesClosedPiper PA-28 · Sheldon, SCNov 30, 1977 · N2047M · Destroyed NTSB MIA78DA033Accident · No injuriesClosedBeech B90 · Charleston, SCNov 26, 1977 · N55MG · Destroyed NTSB MIA78FLG04Accident · No injuriesClosedBeech 58 · Hilton Head, SCNov 25, 1977 · N10VS · Substantial damage NTSB MIA78FLG03Accident · No injuriesClosedCessna 182D · Summerville, SCNov 20, 1977 · N9994T · Substantial damage NTSB MIA78FLG02Accident · No injuriesClosedBeech A23-A · Iva, SCOct 30, 1977 · N2308W · Substantial damage NTSB MIA78FA002Accident · 2 fatalClosedPiper PA-30 · Charleston, SCOct 10, 1977 · N7585Y · Destroyed NTSB UNK78X0100Accident · No injuriesClosedCessna 188B · St Matthews, SCOct 1, 1977 · N53354 · Substantial damage NTSB MIA77FLG38Accident · No injuriesClosedPiper PA-32 · Beaufort, SCSep 25, 1977 · N7744J · Substantial damage NTSB MIA77FLG37Accident · Minor injuriesClosedCessna 305A · Aiken, SCSep 18, 1977 · N5257G · Substantial damage NTSB MIA77FLG36Accident · No injuriesClosedCessna A188B · Bennettsville, SCSep 5, 1977 · N4454Q · Substantial damage NTSB MIA77FA083Accident · 2 fatalClosedPiper PA-28 · Lodge, SCSep 4, 1977 · N6334W · Destroyed NTSB MIA77FLG35Accident · Minor injuriesClosedAmateur ACE-E · Allendale, SCSep 2, 1977 · N91706 · Substantial damage NTSB MIA77FLG34Accident · No injuriesClosedPiper PA-25 · Ehrhardt, SCAug 29, 1977 · N82313 · Substantial damage NTSB MIA77FLG33Accident · 1 fatalClosedCessna 182 · Myrtle Beach, SCAug 22, 1977 · N3256U · Destroyed NTSB MIA77FLG30Accident · No injuriesClosedCessna 188 · Edgemoor, SCAug 17, 1977 · N8014V · Substantial damage NTSB MIA77FLG32Accident · No injuriesClosedPiper PA-25 · Belton, SCAug 13, 1977 · N6370Z · Substantial damage NTSB MIA77FLG29Accident · No injuriesClosedHughes 269B · Johnston, SCAug 8, 1977 · N9325F · Substantial damage NTSB MIA77FLG27Accident · Minor injuriesClosedPiper PA-36 · Darlington, SCAug 7, 1977 · N59655 · Substantial damage NTSB MIA77FA076Accident · 2 fatalClosedChampion 7ECA · Greenville, SCAug 7, 1977 · N9103L · Destroyed