NTSB investigations, 1991, RI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1991
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") = 1991 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 NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…NTSB NYC92LA039Accident · No injuriesLimited investigationFinal reportCessna 182 · Westerly, RIThe failure of the pilot to remove all the water from the fuel system prior to takeoff which resulted in a power loss.NTSB NYC91LA254Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Point Judith, RIThe pilot become disoriented and lost control of the helicopter. Contributing to the accident was a dark night, flight over water, and the pilot's lack of total flight experience.NTSB NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.NTSB NYC91LA216Accident · No injuriesLimited investigationFinal reportCessna TU206G · Block Island, RIImproper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.NTSB NYC91LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Westerly, RIEngine failure for an undetermined reason. A factor was the pilot misjudging the clearance over a fence during an attempted forced landing.NTSB NYC91LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Westerly, RIImproper installation of the right propeller which resulted in thread failure in the propeller hub and separation of the propeller in flight. A factor related to the accident was the right propeller striking the right main landing gear causing its separation…NTSB NYC91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Arcadia, RIInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the lack of a suitable area for a forced landing.