NTSB investigations, 2016, SC

6 cases where NTSB found Environmental issues.

Cases per year

20082026
NTSB investigations, 2016, SC per year, 2008–2026: 107 cases
20087
20095
20107
20117
20129
20134
20145
20153
20166
20174
20189
20198
20203
202110
20224
20236
20242
20254
20264

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\") = 2016
    AND c.\"eventStateOrRegion\" = 'SC' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
  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 GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.Sep 5, 2016 · N451SW · Substantial damageNTSB GAA16CA426Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Cordova, SCThe pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.Jul 24, 2016 · N68JK · Substantial damageNTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).Jun 11, 2016 · N319RA · Substantial damageNTSB GAA16CA291Accident · Minor injuriesData collectionFinal reportBilly Amerson Stol CH 750 · Manning, SCThe pilot's failure to maintain directional control during landing, which resulted in an impact with a fence and trees.Jun 7, 2016 · N80XY · Substantial damageNTSB ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.Apr 6, 2016 · N466CT · Substantial damageNTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.Mar 12, 2016 · N3180S · No damage