Fatal NTSB investigations, 2002, ID
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 5 |
|---|---|
| 1965 | 6 |
| 1966 | 10 |
| 1967 | 5 |
| 1968 | 12 |
| 1969 | 5 |
| 1970 | 10 |
| 1971 | 6 |
| 1972 | 6 |
| 1973 | 7 |
| 1974 | 10 |
| 1975 | 4 |
| 1976 | 14 |
| 1977 | 12 |
| 1978 | 9 |
| 1979 | 17 |
| 1980 | 12 |
| 1981 | 10 |
| 1982 | 9 |
| 1983 | 11 |
| 1984 | 8 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 4 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 12 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 4 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 9 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 6 |
| 2002 | 9 |
| 2003 | 11 |
| 2004 | 7 |
| 2005 | 7 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 6 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 3 |
Where
Latest 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\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'ID' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.NTSB SEA02FA180Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Yellow Pine, IDThe pilot's failure to maintain clearance from trees. A factor was trees south of the departure end of the runway.NTSB SEA02FA175Accident · 3 fatalField investigationFinal reportCessna TR182 · Twin Falls, IDThe pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…NTSB SEA02FA146Accident · 3 fatalField investigationFinal reportBeech BE-35 · Idaho Falls, IDThe flying pilot's failure to maintain adequate airspeed resulting in a stall/spin. An additional cause was the flight instructor's inadequate supervision of the flight.NTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.NTSB SEA02GA053Accident · 3 fatalFinal reportPiper PA-31 · Atlanta, IDThe pilot's failure to maintain aircraft control while in cruise flight which resulted in the in-flight separation due to overload of the spar at the right wing root. Hypoxia was a factor.