NTSB investigations, 1994, CT
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
| 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\") = 1994
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") = 1994 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 NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.NTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.NTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.NTSB NYC94FA135Accident · 2 fatalField investigationFinal reportMooney M20C · Wallingford, CTthe pilot's decision to exhaust the fuel supply in the selected tank in-flight, and his failure to maintain the minimum stall speed during engine out conditions. This resulted in a complete loss of engine power and the inadvertent stall and impact with the…NTSB IAD94LA109Accident · No injuriesLimited investigationFinal reportbourque experimental Kitfox · Chester, CTThe fracture of the tailwheel assembly for undetermined reasons during the takeoff roll, and the subsequent loss of directional control and collision with a hangar.NTSB BFO94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Oxford, CTThe pilot's inadvertent encounter with fog during landing.NTSB NYC94LA093Accident · No injuriesLimited investigationFinal reportCessna 172M · Groton, CTthe pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.NTSB NYC94LA080Accident · No injuriesLimited investigationFinal reportDavis DK-1 · East Haddam, CTThe pilot's failure to maintain the proper glidepath during landing approach.NTSB NYC94LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTThe student pilot's improper recovery from a bounced landing which resulted in a loss of directional control. A factor was the student pilot's imroper landing flare, which resulted in a hard landing.NTSB NYC94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Danbury, CTThe student pilot's inadequate compensattion for wind conditions. The crosswind was a factor.NTSB DCA94MA053Accident · 8 fatalClass 1 · MajorFinal reportPiper PA31 · Stratford, CTThe failure of the captain to use the available ILS glideslope, his failure to execute a go-around when conditions were not suitable for landing, and his failure to land the airplane at a point sufficient to allow for a safe stopping distance; the fatalities…NTSB BFO94LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Willimantic, CTThe instructor's inadequate supervision and the student's improper landing flare.NTSB NYC94GA066Accident · 1 fatalFinal reportHughes 369A · Northford, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM during the forced landing autorotation, resulting in a loss of aircraft control and collision with trees. Also causal to the accident was the pilot's lack of…