NTSB investigations, 1982, 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
Open the mapLatest 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\") = 1982
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") = 1982 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 NYC82FNA16Accident · 1 fatalFinal reportDavis DA-2A · Lincoln, RIThe pilot was on a local pleasure flight to see that the aircraft was functioning properly after a routine inspection. Just prior to the accident, witnesses heard the engine sputter, then become quiet. The plane was observed to continue straight ahead for…NTSB NYC82DA128Accident · No injuriesFinal reportBell 206B · Jamestown, RIThe helicopter was being used to photograph ships. According to the pilot, it began to spin while he was in a low level hover over the water. Subsequently, the helicopter struck the water, rolled over, then sank in about 104 ft of water and was not recovered.NTSB NYC82DA046Accident · No injuriesFinal reportCessna T188C · Block Island, RIWhile on a ferry flight approaching the nantucket VOR the pilot stated that the engine began to run rough. The aircraft was turned back towards Block Island at which time the fuel pressure began to fluctuate and decrease along with the manifold pressure. The…NTSB NYC82DA044Accident · No injuriesFinal reportCessna 182RG · Smithfield, RIAccording to the pilot, while on final approach to runway 33, a severe downdraft was experienced and he was unable to recover. He landed short of the runway on firm grass, bounced and came to rest a short distance from the downwind end of the runway.…NTSB NYC82DA049Accident · No injuriesFinal reportCessna 421C · Westerly, RIThe aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…NTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…