NTSB investigations, 2003, 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\") = 2003
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") = 2003 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 CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.NTSB CHI04LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Argusville, NDThe altitude/clearance not maintained from transmission wire(s) by the pilot during an unknown phase of flight. The transmission wire(s) were a contributing factor.NTSB CHI03LA275Accident · No injuriesLimited investigationFinal reportCessna 170 · Neche, NDThe unsuitable terrain encountered during the precautionary landing. Contributing factors to the accident include the pilot becoming lost/disoriented, his decision to perform a precautionary landing, and the soft terrain encountered during landing.NTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.NTSB CHI03LA215Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Esmond, NDThe obstruction of the windshield by the application chemical restricting the pilot's visual lookout, and the pilot's failure to perform an aborted takeoff. Factors contributing to the accident were the leak in the hopper lid and the drainage ditch.NTSB CHI03LA204Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Ft. Yates, NDThe inadvertent settling with power and unsuccessful remedial action by the pilot. A factor to the accident was the potato crop.NTSB CHI03LA160Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Harvey, NDThe aborted takeoff not performed by the pilot. The inadequate short field takeoff procedure by the pilot and the short grass runway were contributing factors.NTSB CHI03LA139Accident · No injuriesLimited investigationFinal reportErcoupe 415E · Manvel, NDThe pilot's improper flare and inadequate recovery from a bounced landing. A factor contributing to the accident was the collapse of the nose landing gear strut.NTSB CHI03LA134Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Melville, NDThe pilot's failure to maintain clearance from the wires. The low altitude operation and the wires were contributing factors.NTSB CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.