NTSB investigations, 1996, 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\") = 1996
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") = 1996 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 NYC97LA014Accident · Serious injuriesLimited investigationFinal reportCessna 340A · Pawtucket, RIfailure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…NTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…NTSB NYC96LA148Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Westerly, RIinsufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…NTSB NYC96LA150Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Providence, RIthe passenger inadvertently lost his balance and fell, while deplaning.NTSB NYC96LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Block Island, RIthe pilot's inadequate preflight, by failing to remove the control lock and checking the flight controls before takeoff, and his failure to abort the takeoff in a timely manner, which resulted in an overrun, an encounter with brush, and a subsequent nose over…