NTSB investigations, 2010, ND
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 | 32 |
|---|---|
| 1965 | 51 |
| 1966 | 49 |
| 1967 | 44 |
| 1968 | 50 |
| 1969 | 35 |
| 1970 | 33 |
| 1971 | 33 |
| 1972 | 23 |
| 1973 | 28 |
| 1974 | 27 |
| 1975 | 24 |
| 1976 | 22 |
| 1977 | 13 |
| 1978 | 21 |
| 1979 | 17 |
| 1980 | 21 |
| 1981 | 25 |
| 1982 | 29 |
| 1983 | 24 |
| 1984 | 27 |
| 1985 | 22 |
| 1986 | 30 |
| 1987 | 34 |
| 1988 | 5 |
| 1989 | 13 |
| 1990 | 18 |
| 1991 | 14 |
| 1992 | 17 |
| 1993 | 14 |
| 1994 | 24 |
| 1995 | 18 |
| 1996 | 18 |
| 1997 | 16 |
| 1998 | 22 |
| 1999 | 11 |
| 2000 | 12 |
| 2001 | 13 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 14 |
| 2007 | 15 |
| 2008 | 7 |
| 2009 | 10 |
| 2010 | 8 |
| 2011 | 13 |
| 2012 | 13 |
| 2013 | 4 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 9 |
| 2017 | 3 |
| 2018 | 10 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 6 |
| 2022 | 7 |
| 2023 | 10 |
| 2024 | 4 |
| 2025 | 5 |
| 2026 | 2 |
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\") = 2010
AND c.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
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") = 2010 AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' 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 CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN11CA071Accident · No injuriesData collectionFinal reportGrumman G-164 · Michigan, NDThe pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.NTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.NTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.NTSB CEN10CA333Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL-104 Wilga 80 · Linton, NDThe pilot's failure to maintain aircraft control during landing with a 90-degree crosswind.NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB CEN10TA194Accident · Serious injuriesFinal reportBeech 95-B55 · Center, NDThe inadvertent in-flight collision with several Mallard ducks.NTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.