NTSB investigations, 1983, SC

4 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 1983, SC per year, 1982–2026: 53 cases
19824
19834
19844
19854
19861
19871
19882
19891
19901
19913
19923
19944
19954
19962
19972
19982
19992
20011
20021
20032
20042
20051
20072

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1983
    AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
  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.

NTSB ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.Nov 23, 1983 · N7221P · Substantial damageNTSB ATL84LA040Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe purpose of the flt was to take pictures over lake murray. The plt stated that after taking off, he proceeded over the lake, then descended & varied his altitude between 400 & 800 ft MSL, so the passenger could take pictures. Shortly after rounding a bend…Nov 5, 1983 · N3055V · Substantial damageNTSB ATL83LA245Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe student plt was practicing landings on rwy 7 & completed 1 successful landing. He reported that on the 2nd approach, a gust of wind blew the acft to the left, so he made a go-around. A 3rd approach was made with the acft lined up slightly to the left of…Jun 27, 1983 · N714HA · Substantial damageNTSB ATL83LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Pickens, SCThe acft collided with two birds while cruising at 6000 ft MSL. The weather was VFR but the acft was on IFR flt plan. The acfts left wing was damaged but there were no injuries. The plt stated that although he heard a thud on the left side of the acft he was…Feb 16, 1983 · N8472E · Substantial damage