NTSB investigations, 1985, RI

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

19642026
NTSB investigations, 1985, RI per year, 1964–2026: 327 cases
196414
19657
196615
196712
19687
19699
19709
19719
197212
19735
197410
19756
197611
19775
197811
19793
198011
19815
19826
19837
19848
19857
19865
19876
19889
19894
19906
19918
19922
19938
19945
19955
19965
19973
19981
19992
20004
20013
20025
20037
20043
20051
20063
20074
20088
20091
20101
20111
20122
20141
20152
20166
20172
20191
20202
20211
20221
20243
20252
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\") = 1985
    AND c.\"eventStateOrRegion\" = 'RI' 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 ATL86FA032Accident · 2 fatalField investigationFinal reportBeech C90 · East Greenwich, RIThe acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer…Nov 27, 1985 · N220F · DestroyedNTSB NYC86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Block Island, RIThe floatplane experienced a pwr loss about 15 miles south of martha's vineyard VOR. The eng manifold pressure dropped and the RPM became erratic. The plt attempted to restart the eng using primary and emergency fuel pumps but the eng would not restart. The…Oct 23, 1985 · N8475Q · DestroyedNTSB NYC86LA009Accident · No injuriesLimited investigationFinal reportMaule MX 7-235 · Westerly, RIThe acft groundlooped during lndg. The plt reported that a sudden gust of wind was the cause. The sind was reported as calm.Oct 12, 1985 · N5661N · Substantial damageNTSB NYC85FA244Accident · 2 fatalField investigationFinal reportBeech V35B · Warwick, RIWhile en route at 5000' MSL, the plt transmitted that he had an eng problem & requested clearance to land at the providence/theodore francis green state arpt, which was aprx 12 mi away. The plt then asked the controller if that was the closest arpt; however,…Sep 21, 1985 · N5NG · DestroyedNTSB NYC85FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Block Island, RIThe acft departed long Island on a VFR flt plan for Block Island. The plt did not close the flt plan after arrival at Block Island and departed Block Island without refiling a flt plan. The flt departed Block Island at night to the east over the ocean and has…Sep 14, 1985 · N1423E · DestroyedNTSB NYC85LA164Accident · No injuriesLimited investigationFinal reportCessna 182M · Block Island, RIThe plt was checked out in the C-182 on July 9, 1985 and had flown this acft for 1 hr in the previous year. During a normal power off landing with ten degrees of flaps extended, the plt added power and noticed no change in performance. The acft touched down…Jul 11, 1985 · N71359 · Substantial damageNTSB NYC85LA074Accident · No injuriesLimited investigationFinal reportAero Commander 680V · Kingstown, RIWhile en route at 12,500 ft, the plt noted a slight shudder & heard a 'wind noise' then the gear unsafe light illuminated. The plt slowed the acft to 135 KTS & tried recycling the gear, but the gear only dropped to the point where it would twist. All attempts…Mar 6, 1985 · N111SK · Substantial damage