NTSB investigations, 2004, CT
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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
| 1962 | 1 |
|---|---|
| 1964 | 32 |
| 1965 | 45 |
| 1966 | 50 |
| 1967 | 48 |
| 1968 | 34 |
| 1969 | 31 |
| 1970 | 34 |
| 1971 | 40 |
| 1972 | 31 |
| 1973 | 34 |
| 1974 | 24 |
| 1975 | 22 |
| 1976 | 18 |
| 1977 | 27 |
| 1978 | 26 |
| 1979 | 26 |
| 1980 | 21 |
| 1981 | 14 |
| 1982 | 22 |
| 1983 | 21 |
| 1984 | 33 |
| 1985 | 17 |
| 1986 | 23 |
| 1987 | 24 |
| 1988 | 17 |
| 1989 | 18 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 21 |
| 1993 | 15 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 14 |
| 1997 | 8 |
| 1998 | 16 |
| 1999 | 10 |
| 2000 | 9 |
| 2001 | 15 |
| 2002 | 12 |
| 2003 | 8 |
| 2004 | 13 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 7 |
| 2008 | 9 |
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 11 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 5 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 13 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 3 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'CT' 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") = 2004 AND c."eventStateOrRegion" = 'CT' 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 NYC05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hartford, CTThe pilot's failure to maintain adequate clearance from trees during the approach to the runway. A factor related to the accident was the nighttime conditions.NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.NTSB NYC04CA216Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Milford, CTThe pilot's improper flair, which resulted in a nose over.NTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.NTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.NTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB NYC04FA127Accident · 1 fatalField investigationFinal reportMooney M20J · Oxford, CTThe pilot's failure to maintain altitude/clearance during an instrument approach, which resulted in a collision with trees prior to the runway. Factors were nighttime conditions and cloud cover.NTSB NYC04CA104Accident · No injuriesData collectionFinal reportCessna 172N · Bridgeport, CTThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control which resulted in a hard landing. A factor was the gusty winds.NTSB NYC04LA106Accident · No injuriesLimited investigationFinal reportCessna 182S · Plainville, CTThe failure of the elevator servo which resulted in restricted elevator movement and the pilot's inability to initiate a landing flare.NTSB NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.NTSB NYC04FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Danbury, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed.