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 MIA72FLG34Accident · No injuriesClosedCessna 177B · Anderson, SCApr 22, 1972 · N34251 · Substantial damage NTSB MIA72AM110Accident · 1 fatalClosedGlobe GC-1B · Hanahan, SCApr 14, 1972 · N80716 · Destroyed NTSB MIA72FLG33Accident · Serious injuriesClosedPiper PA-24 · Greenville, SCApr 2, 1972 · N5893P · Substantial damage NTSB MIA72AM104Accident · 5 fatalClosedCessna 320E · Charleston, SCMar 31, 1972 · N3421Q · Destroyed NTSB MIA72DLG32Accident · Minor injuriesClosedCessna 140 · Laurens, SCMar 25, 1972 · N81081 · Substantial damage NTSB MIA72DLG31Accident · No injuriesClosedCessna 150 · Pelzer, SCMar 15, 1972 · N6679F · Substantial damage NTSB MIA72FLG29Accident · Minor injuriesClosedPiper PA-28 · Cheraw, SCMar 14, 1972 · N419FL · Destroyed NTSB MIA72DLG30Accident · No injuriesClosedTaylorcraft BC12-D · Myrtle Beach, SCMar 9, 1972 · N95301 · Substantial damage NTSB MIA72FLG28Accident · No injuriesClosedChampion 7GCAA · Edgefield, SCMar 3, 1972 · N2760G · Substantial damage NTSB MIA72DLG27Accident · No injuriesClosedCessna 305A · Johns Island, SCFeb 29, 1972 · N12755 · Substantial damage NTSB MIA72DLG26Accident · No injuriesClosedMaule M-4 · Mt.Pleasant, SCFeb 20, 1972 · N40319 · Substantial damage NTSB MIA72DLG25Accident · Minor injuriesClosedCessna 172B · Greenville, SCFeb 19, 1972 · N6982X · Substantial damage NTSB MIA72FLG24Accident · Minor injuriesClosedPiper PA-28 · Andrews, SCJan 30, 1972 · N8044W · Substantial damage NTSB MIA72DLG23Accident · No injuriesClosedCessna 170 · Columbia, SCJan 16, 1972 · N8152A · Substantial damage NTSB MIA72FLG22Accident · Serious injuriesClosedCessna 172K · Greer, SCJan 12, 1972 · N7142G · Substantial damage NTSB MIA72DLG21Accident · No injuriesClosedCessna 172 · Lancaster, SCDec 28, 1971 · N8560X · Substantial damage NTSB MIA72FLG20Accident · Minor injuriesClosedCessna 172D · Clinton, SCDec 26, 1971 · N2441U · Destroyed NTSB MIA72FLG19Accident · Serious injuriesClosedPiper PA-28 · Charleston, SCDec 22, 1971 · N8253N · Substantial damage NTSB MIA72AM054Accident · 2 fatalClosedLuscombe 8A · Santee, SCDec 19, 1971 · N45961 · Destroyed NTSB MIA72FLG18Accident · No injuriesClosedPiper PA-24 · Florence, SCDec 13, 1971 · N8552P · Substantial damage NTSB MIA72DLG17Accident · No injuriesClosedPiper PA-28 · Greer, SCNov 27, 1971 · N98095 · Substantial damage NTSB MIA72AM043Accident · No injuriesClosedTed Smith 600 · Hilton Head Is, SCNov 14, 1971 · N7414S · Substantial damage NTSB MIA72FLG16Accident · Serious injuriesClosedPiper PA-25 · Edisto Is, SCOct 28, 1971 · N162W · Destroyed NTSB MIA72FLG12Accident · No injuriesClosedBeech 95-B55 · Greenwood, SCOct 25, 1971 · N6545L · Substantial damage NTSB MIA72FLG15Accident · Minor injuriesClosedCessna 177 · Walterboro, SCOct 15, 1971 · N3403T · Substantial damage NTSB MIA72FLG14Accident · No injuriesClosedPiper J3C-65 · Clio, SCOct 3, 1971 · N37949 · Substantial damage NTSB MIA72DLG13Accident · No injuriesClosedBeech B23 · Florence, SCSep 26, 1971 · N2311Q · Substantial damage NTSB MIA72FLG11Accident · No injuriesClosedCessna 177 · Spartanburg, SCSep 16, 1971 · N3113T · Substantial damage NTSB MIA72FLG10Accident · No injuriesClosedChampion 7ECA · West Columbia, SCSep 11, 1971 · N7599F · Substantial damage NTSB MIA72DLG09Accident · No injuriesClosedBell 47D-1 · Rembert, SCAug 20, 1971 · N586T · Substantial damage NTSB MIA72FLG08Accident · No injuriesClosedBell 47D-1 · Cheraw, SCAug 14, 1971 · N908B · Substantial damage NTSB MIA72FLG07Accident · No injuriesClosedPiper PA-28 · Greenville, SCAug 11, 1971 · N8820N · Substantial damage NTSB MIA72FLG06Accident · No injuriesClosedTaylorcraft BC12 · Sullivans Is., SCAug 10, 1971 · N36452 · Substantial damage NTSB NYC72AN019Accident · Serious injuriesClosedConvair 880 · Spartanburg, SCAug 5, 1971 · N8803E · No damage NTSB MIA72FLG05Accident · No injuriesClosedBell 47G · Sumter, SCAug 2, 1971 · N73871 · Destroyed NTSB MIA72FLG04Accident · Serious injuriesClosedEnstrom F-28A · Saluda, SCJul 31, 1971 · N22WP · Substantial damage NTSB MIA72DLG03Accident · No injuriesClosedLuscombe 8A · Timmonsville, SCJul 24, 1971 · N1342B · Substantial damage NTSB MIA72DLG02Accident · Minor injuriesClosedCessna 150F · Harleyville, SCJul 18, 1971 · N8827G · Substantial damage NTSB MIA72DLG01Accident · No injuriesClosedCessna 172C · Spartanburg, SCJul 18, 1971 · N1887Y · Substantial damage NTSB MIA71FLG34Accident · Serious injuriesClosedAero Comdr 680E · Camden, SCJun 25, 1971 · N8458C · Substantial damage NTSB MIA71DLG33Accident · No injuriesClosedCessna 177 · Greenville, SCJun 20, 1971 · N29612 · Substantial damage NTSB MIA71DLG32Accident · No injuriesClosedBeech G35 · Rock Hill, SCJun 15, 1971 · N4491D · Substantial damage NTSB MIA71FLG30Accident · Serious injuriesClosedAero Comdr 100 · Allendale, SCJun 14, 1971 · N3624X · Destroyed NTSB MIA71FLG31Accident · No injuriesClosedCessna 175B · Rock Hill, SCJun 10, 1971 · N8140T · Substantial damage NTSB MIA71DLG29Accident · No injuriesClosedPiper PA-16 · Isle Of Palms, SCMay 30, 1971 · N5906H · Substantial damage NTSB MIA71FLG28Accident · Serious injuriesClosedCessna 337 · Hilton Head Is., SCMay 10, 1971 · N6343F · Destroyed NTSB MIA71AM093Accident · 4 fatalClosedCessna 421A · Conestee, SCMay 2, 1971 · N3194K · Destroyed NTSB MIA71FLG27Accident · No injuriesClosedPiper J3C-65 · Pageland, SCApr 7, 1971 · N92308 · Substantial damage NTSB MIA71FLG26Accident · No injuriesClosedPitts S1S · Pelion, SCApr 7, 1971 · N2788 · Substantial damage NTSB MIA71FLG25Accident · No injuriesClosedCessna 210E · Fort Lawn, SCMar 23, 1971 · N2322T · Substantial damage