Fatal NTSB investigations, 2012, 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\") = 2012
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") = 2012 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 ERA13FA026Accident · 1 fatalField investigationFinal reportAerospatiale AS 355 · Erwinna, PAThe pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.NTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.NTSB ERA12LA541Accident · 1 fatalLimited investigationFinal reportJohnston Douglas S Safari · McVeytown, PAThe pilot's lack of proficiency and certification, which resulted in his failure to enter an autorotation when the engine lost power. Contributing to the accident was the pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent…NTSB ERA12FA327Accident · 2 fatalField investigationFinal reportMooney M20J · Sterling, PAThe pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.NTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…NTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.