Fatal NTSB investigations, 1991, ND
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 4 |
|---|---|
| 1965 | 7 |
| 1966 | 2 |
| 1967 | 5 |
| 1968 | 2 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 5 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 4 |
| 1975 | 5 |
| 1976 | 5 |
| 1977 | 1 |
| 1978 | 7 |
| 1979 | 3 |
| 1980 | 2 |
| 1981 | 6 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 2 |
| 2026 | 1 |
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\") = 1991
AND c.\"eventStateOrRegion\" = 'ND' 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") = 1991 AND c."eventStateOrRegion" = 'ND' 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 CHI91FA291Accident · 2 fatalField investigationFinal reportBeech 95 · Killdeer, NDThe pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…NTSB CHI91DTG01Accident · 1 fatalFinal reportCessna 172P · Bismarck, NDSpatial disorientation. Factors related to the accident are failure to obtain a preflight weather brief, vrf flight into IMC conditions and lack of total experience.