NTSB investigations, 2016, SD

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.

Cases per year

19622026
NTSB investigations, 2016, SD per year, 1962–2026: 1,074 cases
19621
196440
196543
196642
196746
196839
196935
197037
197130
197227
197320
197428
197535
197621
197744
197838
197927
198024
198128
198218
198322
198422
198515
198614
198711
198811
19896
199016
199112
19929
199311
199410
199512
199611
199712
199814
19998
200012
200111
20028
200316
200410
20059
20065
200710
20089
20098
20108
201113
201215
20138
20147
20159
20168
20177
20189
201911
20207
20212
20227
20236
20245
202510
20265

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\" = 'SD' 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.

NTSB CEN16FA344Accident · 2 fatalField investigationFinal reportAves Douglas James RV 6 · Viborg, SDThe pilot's failure to maintain airplane control, which resulted in the airplane exceeding its critical angle of attack, an aerodynamic stall, and subsequent flat spin into terrain.Sep 2, 2016 · N676DT · DestroyedNTSB CEN16CA364Accident · No injuriesData collectionFinal reportBeech V35B · Sioux Falls, SDThe pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate preflight by the pilot and flight instructor, and the flight instructor's…Aug 30, 2016 · N23583 · Substantial damageNTSB DCA16IA215Incident · Minor injuriesIncident investigationFinal reportAirbus A320 232 · Wood, SDan inadvertent encounter with convective turbulence while in cruise flight.Aug 12, 2016 · N632JB · Minor damageNTSB CEN16LA275Accident · Minor injuriesClass 3 · LimitedFinal reportMeyers 200 · Huron, SDThe partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.Jul 20, 2016 · N229RS · Substantial damageNTSB DCA16IA200Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 211 · Rapid City, SDThe flight crew's misidentification of the desired landing runway due to excess altitude requiring an extended downwind, and failure to use all available navigation information.Jul 8, 2016 · N333NW · No damageNTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.Jun 7, 2016 · N921RP · Substantial damageNTSB CEN16LA201Accident · No injuriesLimited investigationFinal reportCessna 402B · Sioux Falls, SDThe failure of the No. 4 cylinder head, which resulted in an engine fire and subsequent damage to the wing structure.May 27, 2016 · N76MD · Substantial damageNTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.Feb 12, 2016 · N6691P · Substantial damage