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
| 1964 | 14 |
|---|---|
| 1965 | 7 |
| 1966 | 15 |
| 1967 | 12 |
| 1968 | 7 |
| 1969 | 9 |
| 1970 | 9 |
| 1971 | 9 |
| 1972 | 12 |
| 1973 | 5 |
| 1974 | 10 |
| 1975 | 6 |
| 1976 | 11 |
| 1977 | 5 |
| 1978 | 11 |
| 1979 | 3 |
| 1980 | 11 |
| 1981 | 5 |
| 1982 | 6 |
| 1983 | 7 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 9 |
| 1989 | 4 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 2 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 8 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 6 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 5 |
Where
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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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…NTSB 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.NTSB 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,…NTSB 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…NTSB 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…NTSB 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…