NTSB investigations, 2003, 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, 2003, 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\") = 2003
    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 CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.Dec 6, 2003 · N7543E · Substantial damageNTSB CHI03LA299Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · South Shore, SDA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.Sep 4, 2003 · N38435 · Substantial damageNTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.Aug 29, 2003 · N651EJ · No damageNTSB CHI03LA271Accident · No injuriesLimited investigationFinal reportCessna 188A · Freeman, SDThe pilot's failure to maintain directional control and clearance during landing roll. Additional factors included the pilot's improper recovery from a bounced landing, the crosswind and the corn crop.Aug 20, 2003 · N8150V · Substantial damageNTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.Aug 10, 2003 · N4656M · Substantial damageNTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.Aug 7, 2003 · N9272K · Substantial damageNTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.Aug 2, 2003 · N4923X · Substantial damageNTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.Jul 28, 2003 · N9032L · Substantial damageNTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.Jul 27, 2003 · N512EA · DestroyedNTSB CHI03LA199Accident · No injuriesLimited investigationFinal reportAviat A-1B · Okobojo, SDThe failure of the float strut during a water landing.Jul 5, 2003 · N700KY · Substantial damageNTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.Jul 4, 2003 · N7256M · DestroyedNTSB CHI03LA154Accident · Minor injuriesLimited investigationFinal reportBraunschmidt RV-6A · Tea, SDThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.Jun 9, 2003 · N160BM · Substantial damageNTSB CHI03FA141Accident · 1 fatalField investigationFinal reportCessna 182Q · Gettysburg, SDThe pilot not maintaining aircraft control in cruise flight leading to his inadvertent spiral. A factor was the pilot's in-flight encounter with moderate to heavy rain.Jun 3, 2003 · N630SW · DestroyedNTSB CHI03LA133Accident · 1 fatalLimited investigationFinal reportAir & Space 18A · South Shore, SDThe pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.May 19, 2003 · N6155S · DestroyedNTSB CHI03LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pierre, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the collapse of the main landing gear.May 19, 2003 · N9601D · Substantial damageNTSB CHI03LA109Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Red Owl, SDThe pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.Apr 21, 2003 · N93564 · Substantial damage