Fatal NTSB investigations, 2002, PA
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 | 11 |
|---|---|
| 1965 | 17 |
| 1966 | 17 |
| 1967 | 16 |
| 1968 | 26 |
| 1969 | 14 |
| 1970 | 20 |
| 1971 | 24 |
| 1972 | 19 |
| 1973 | 18 |
| 1974 | 20 |
| 1975 | 12 |
| 1976 | 19 |
| 1977 | 19 |
| 1978 | 20 |
| 1979 | 19 |
| 1980 | 14 |
| 1981 | 9 |
| 1982 | 16 |
| 1983 | 21 |
| 1984 | 14 |
| 1985 | 20 |
| 1986 | 11 |
| 1987 | 11 |
| 1988 | 18 |
| 1989 | 8 |
| 1990 | 13 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 10 |
| 1995 | 10 |
| 1996 | 5 |
| 1997 | 13 |
| 1998 | 9 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 7 |
| 2005 | 10 |
| 2006 | 10 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 3 |
| 2026 | 1 |
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\" = 'PA' 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" = 'PA' 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 IAD03FA001Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Bradford, PAThe pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.NTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.NTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.NTSB NYC02FA152Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's improper decision to operate an airplane with known mechanical deficiencies, his improper decision to return to the airport with inadequate altitude remaining, and his failure to maintain airspeed. A factor related to the accident was the…NTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.NTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.