NTSB investigations, 1994, 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\") = 1994
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") = 1994 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 NYC95LA023Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Coventry, RIimproper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.NTSB NYC94LA164Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Block Island, RIThe pilot maintaining excessive airspeed during the landing, resulting in a touchdown on the runway with insufficient distance to stop, and a subsequent intentional ground loop and collision with the terrain. Also causal was the pilot's failure to abort the…NTSB NYC94LA150Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Newport, RIThe pilot's inflight planning/decision and failure to attain the proper touchdown point.NTSB NYC94LA139Accident · No injuriesLimited investigationFinal reportCessna 172A · Block Island, RIThe pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.NTSB NYC94FA106Accident · No injuriesField investigationFinal reportSikorsky S-76B · Newport, RIthe failure of the left hand helical gear in the main gear box (MGB), due to undertorqued attaching bolts installed by the manufacturer, which resulted in a partial MGB failure. This failure resulted in the loss of the number one engine, illumination of the…