NTSB investigations, 2002, 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\") = 2002
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") = 2002 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 IAD03FA024Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Woodbury, CTAn engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.NTSB IAD02LA090Accident · No injuriesLimited investigationFinal reportCessna T210N · Glastonbury, CTA partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.NTSB NYC02LA169Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Guilford, CTFatigue cracking of the number 3 cylinder head. A factor was the presence of protruding material on the cylinder barrel.NTSB IAD02FA086Accident · 2 fatalField investigationFinal reportCessna 172S · Plainville, CTAn in-flight engine compartment fire of unknown origin, and a loss of engine power for undetermined reasons. Also causal, was the pilot's failure to maintain airspeed during a turn back to the airfield, which resulted in an inadvertent stall and subsequent…NTSB NYC02LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's failure to maintain airspeed and the flight instructor's delayed remedial action, which resulted in an inadvertent stall during a simulated forced landing. A factor was the rising terrain.NTSB IAD02LA069Accident · No injuriesLimited investigationFinal reportCessna 182T · Plainville, CTThe pilot's improper recovery from a bounced landing.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.NTSB NYC02IA118Incident · No injuriesIncident investigationFinal reportLearjet 35A · Oxford, CTThe flight instructor's inadequate supervision of the commercial pilot during a touch and go landing, including his failure to properly brief the commercial to not use reverse thrust during a touch and go landing.NTSB IAD02FA043Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, CTThe pilot's failure to follow the published instrument approach procedure. Factors were the night and low ceiling conditions.NTSB IAD02LA032Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Harwinton, CTpilot's failure to obtain adequate airspeed during take-off, which resulted in an aerodynamic stall.NTSB NYC02FA055Accident · 2 fatalField investigationFinal reportBeech V35B · Chester, CTThe pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.