NTSB investigations, 1993, SD

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1993, 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\") = 1993
    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 CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.Dec 22, 1993 · N8003P · DestroyedNTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.Nov 10, 1993 · N7112M · Substantial damageNTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.Oct 26, 1993 · N39952 · DestroyedNTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.Oct 12, 1993 · N4788Q · Substantial damageNTSB CHI93LA314Accident · No injuriesLimited investigationFinal reportCessna 188 · Martin, SDthe pilot's failure to maintain control of the airplane during the takeoff roll.Aug 7, 1993 · N78516 · Substantial damageNTSB CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.Aug 7, 1993 · N4724K · Substantial damageNTSB CHI93DTK02Accident · Minor injuriesFinal reportHiller UH-12E · Milbank, SDUndeterminedJul 18, 1993 · N4028M · DestroyedNTSB CHI93DTK01Accident · 1 fatalFinal reportCrowser Avid MK 3.75 · Philip, SDThe pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.Jul 5, 1993 · N42CJ · DestroyedNTSB CHI93LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rapid City, SDThe pilot in command's inadequate compensation for wind conditions.Jun 23, 1993 · N5435E · Substantial damageNTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.Jun 11, 1993 · N3890E · Substantial damageNTSB CHI93LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Yankton, SDThe pilot in command's failure to maintain proper clearance. Gusty wind conditions were a factor.Apr 24, 1993 · N5548W · Destroyed