Fatal NTSB investigations, 2012, OR
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 | 13 |
|---|---|
| 1965 | 8 |
| 1966 | 15 |
| 1967 | 17 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 11 |
| 1971 | 18 |
| 1972 | 18 |
| 1973 | 13 |
| 1974 | 11 |
| 1975 | 15 |
| 1976 | 16 |
| 1977 | 20 |
| 1978 | 23 |
| 1979 | 7 |
| 1980 | 11 |
| 1981 | 16 |
| 1982 | 14 |
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 9 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 10 |
| 1990 | 12 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 7 |
| 1994 | 11 |
| 1995 | 11 |
| 1996 | 8 |
| 1997 | 14 |
| 1998 | 5 |
| 1999 | 12 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 11 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 12 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 2 |
| 2026 | 6 |
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\") = 2012
AND c.\"eventStateOrRegion\" = 'OR' 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" = 'OR' 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 WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR12FA274Accident · 4 fatalField investigationFinal reportCessna 172 · Veneta, ORThe pilot’s failure to maintain adequate airspeed and altitude to clear trees during the initial climb after takeoff.NTSB WPR12FA237Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Lakeview, ORThe pilot’s decision to take off in known adverse weather conditions and his subsequent failure to maintain sufficient airspeed while maneuvering in mountainous terrain and an area of low ceilings, snow, and fog, which resulted in a loss of airplane control.NTSB WPR12FA180Accident · 2 fatalField investigationFinal reportLeague Lancair IV-TP · Sisters, ORThe pilots’ inability to maintain control of the airplane and arrest a steep spiral dive while maneuvering for reasons that could not be determined because postaccident examination could not identify any anomalies that would have precluded normal operation…NTSB WPR12FA136Accident · 2 fatalField investigationFinal reportCessna 150L · Goble, ORThe flight instructor's decision to continue flight into the area of reduced visibility and the pilots’ subsequent failure to maintain clearance from the hilly terrain while operating in an area of low ceilings, rain, and fog.