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 MIA73DLG36Accident · No injuriesClosedPiper PA-28 · Johns Island, SCMar 19, 1973 · N4981T · Substantial damage NTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCMar 9, 1973 · N5310R · Destroyed NTSB MIA73FLG35Accident · No injuriesClosedPiper PA-22 · Gaffney, SCMar 4, 1973 · N6018D · Substantial damage NTSB MIA73DLG34Accident · No injuriesClosedAmer Avco AA-1B · Aiken, SCFeb 28, 1973 · N6323L · Substantial damage NTSB MIA73DLG33Accident · No injuriesClosedPiper PA-11 · Isle Of Palms, SCFeb 4, 1973 · N4827M · Substantial damage NTSB MIA73AM078Accident · 1 fatalClosedBeech 95-B55 · Mauldin, SCFeb 2, 1973 · N9427Q · Destroyed NTSB MIA73FLG32Accident · Serious injuriesClosedPiper PA-28 · No.Myrtle Bch, SCJan 21, 1973 · N5118G · Substantial damage NTSB MIA73FLG31Accident · No injuriesClosedErco 415-C · Inman, SCDec 30, 1972 · N99543 · Substantial damage NTSB MIA73DLG30Accident · No injuriesClosedCessna 140 · N Myrtle Beach, SCDec 27, 1972 · N72137 · Substantial damage NTSB MIA73DLG29Accident · No injuriesClosedCessna 172 · No.Myrtle Bch, SCDec 27, 1972 · N2610L · Substantial damage NTSB MIA73AM060Accident · 3 fatalClosedBeech 58 · Anderson, SCDec 10, 1972 · N1643W · Destroyed NTSB MIA73AM054Accident · 1 fatalClosedMitsubishi MU-2B · Alcolu, SCNov 20, 1972 · N757Q · Destroyed NTSB MIA73DLG28Accident · No injuriesClosedLuscombe 8A · Columbia, SCNov 5, 1972 · N25129 · Substantial damage NTSB MIA73FLG26Accident · No injuriesClosedCessna 310G · Union, SCOct 16, 1972 · N2920R · Substantial damage NTSB MIA73FLG25Accident · No injuriesClosedCessna 206 · Spartanburg, SCOct 12, 1972 · N5017U · Substantial damage NTSB MIA73DLG24Accident · No injuriesClosedCessna 172H · Landrum, SCOct 8, 1972 · N2881L · Substantial damage NTSB MIA73FLG23Accident · No injuriesClosedPiper PA-22 · Ridgeland, SCSep 29, 1972 · N8746D · Substantial damage NTSB MIA73FLG21Accident · Minor injuriesClosedHughes 269A · Ridge Springs, SCSep 21, 1972 · N8735F · Substantial damage NTSB NYC73ANO61Accident · 1 fatalClosedCessna 140 · Gaffney, SCSep 17, 1972 · N2218N · Destroyed NTSB MIA73AM031Accident · 4 fatalClosedBeech E18S · Sumter, SCSep 17, 1972 · N21DD · Destroyed NTSB MIA73DLG20Accident · No injuriesClosedPiper PA-28 · Johns Island, SCSep 15, 1972 · N4825T · Substantial damage NTSB MIA73DLG19Accident · No injuriesClosedBeech E33 · Greenwood, SCSep 13, 1972 · N3162 · Substantial damage NTSB MIA73DLG18Accident · No injuriesClosedPiper PA-18A · Mccoll, SCSep 4, 1972 · N4890A · Substantial damage NTSB MIA73FLG15Accident · Minor injuriesClosedStinson 108 · Pelzer, SCAug 18, 1972 · N97283 · Substantial damage NTSB MIA73FLG14Accident · No injuriesClosedHughes 269B · Rembert, SCAug 17, 1972 · N9305F · Substantial damage NTSB MIA73DLG13Accident · No injuriesClosedLuscombe 8E · Gaffney, SCAug 12, 1972 · N2489K · Substantial damage NTSB MIA73DLG12Accident · No injuriesClosedCessna 172G · Saluda, SCAug 11, 1972 · N4311L · Substantial damage NTSB MIA73DLG16Accident · No injuriesClosedCessna 150 · Waterboro, SCAug 7, 1972 · N3555L · Substantial damage NTSB MIA73FLG11Accident · No injuriesClosedCessna 182 · Conway, SCAug 5, 1972 · N5412B · Substantial damage NTSB MIA73FLG10Accident · Minor injuriesClosedCessna 188 · Kline, SCAug 4, 1972 · N3574Q · Substantial damage NTSB MIA73DLG17Accident · No injuriesClosedCessna A188 · Fairfax, SCJul 31, 1972 · N21735 · Substantial damage NTSB MIA73DLG09Accident · No injuriesClosedCessna 150G · Charleston, SCJul 30, 1972 · N6364S · Substantial damage NTSB MIA73FLG08Accident · No injuriesClosedCessna 421A · Hilton Head, SCJul 28, 1972 · N2983Q · Substantial damage NTSB MIA73FLG07Accident · No injuriesClosedBell 47G-2 · Pinewood, SCJul 22, 1972 · N6711D · Substantial damage NTSB MIA73FLG06Accident · No injuriesClosedPiper J3C · Cades, SCJul 18, 1972 · N77549 · Substantial damage NTSB MIA73DLG04Accident · No injuriesClosedCurtis-Wrt 4C-1A · Columbia, SCJul 9, 1972 · N563N · Substantial damage NTSB MIA72DLG05Accident · No injuriesClosedPiper PA-28 · Myrtle Beach, SCJul 9, 1972 · N5129S · Substantial damage NTSB MIA73FLG01Accident · No injuriesClosedHughes 269A · Gaston, SCJul 2, 1972 · N8947F · Substantial damage NTSB MIA73DLG03Accident · Minor injuriesClosedPiper J-3 · Aiken, SCJul 2, 1972 · N5147B · Substantial damage NTSB MIA72IM144Incident · No injuriesClosedBeech 65-A80 · Columbia, SCJun 27, 1972 · N32TM · Minor damage NTSB MIA72AM141Accident · 1 fatalClosedCessna 172B · Santee, SCJun 24, 1972 · N7516X · Destroyed NTSB MIA72FLG43Accident · No injuriesClosedCallair A-9 · Barnwell, SCJun 5, 1972 · N7244V · Destroyed NTSB MIA72FLG42Accident · No injuriesClosedAeronca 7AC · White Rock, SCJun 3, 1972 · N4328E · Substantial damage NTSB MIA72DLG41Accident · No injuriesClosedPiper PA-28 · Clover, SCMay 31, 1972 · N9177J · Substantial damage NTSB MIA72FLG40Accident · No injuriesClosedCessna A185E · Columbia, SCMay 16, 1972 · N4AC · Substantial damage NTSB MIA72AM120Accident · No injuriesClosedPiper PA-30 · West Columbia, SCMay 9, 1972 · N7809Y · Substantial damage NTSB MIA72FLG37Accident · Minor injuriesClosedParks Thorp T-18 · St.Matthews, SCMay 6, 1972 · N614DP · Substantial damage NTSB MIA72FLG38Accident · No injuriesClosedCessna 310K · Landrum, SCMay 4, 1972 · N3833X · Substantial damage NTSB MIA72FLG35Accident · Minor injuriesClosedHughes 269A · Johns Island, SCApr 28, 1972 · N8909F · Substantial damage NTSB MIA72DLG36Accident · No injuriesClosedCessna 150 · Liberty, SCApr 25, 1972 · N8451M · Substantial damage