NTSB investigations, 1987, SD

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1987, 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\") = 1987
    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 DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…Dec 6, 1987 · N2562Z · Substantial damageNTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…Nov 25, 1987 · N1380Q · Substantial damageNTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…Oct 26, 1987 · N1257E · DestroyedNTSB DEN87DTK01Accident · 1 fatalFinal reportBushby Mustang II · Aberdeen, SDWitnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near…Aug 21, 1987 · N44TA · DestroyedNTSB DEN87LA195Accident · No injuriesLimited investigationFinal reportCessna 182L · Aberdeen, SDThe plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed…Jul 26, 1987 · N3371R · DestroyedNTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…Jul 26, 1987 · N2346U · Substantial damageNTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.Jul 4, 1987 · N6933V · DestroyedNTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…May 26, 1987 · N5448Z · Substantial damageNTSB DEN87LA100Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9B · Wood, SDA commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…Apr 24, 1987 · N2755V · DestroyedNTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…Apr 21, 1987 · N9069T · Substantial damageNTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.Feb 11, 1987 · N3451X · Substantial damage