NTSB investigations, 1991, 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\") = 1991
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") = 1991 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 CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…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 CHI91DTG08Accident · No injuriesFinal reportGrumman G164B · Minto, NDInadequate aircraft servicing, inadequate aircraft preflight, fuel contamination, and unsuitable soft terrain in which to effect an emergency landing.NTSB CHI91DTG07Accident · No injuriesFinal reportAyres S2R · Drayton, NDMisjudged clearance by the pilot. A factor related to the accident is overconfidence in personal ability.NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.NTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB CHI91DTG02Accident · No injuriesFinal reportSikorsky H-19-UH19D · Mcclusky, NDFailure of the engine blower/supercharger assembly. A factor related to the accident was: no suitable terrain in which to make an immediate emergency landing.NTSB CHI91DTG03Accident · No injuriesFinal reportSchweizer G164 · Gwinner, NDInadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.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.NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.NTSB CHI91LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe pilot's failure to maintain directional control during the landing roll. Related to the accident was the pilot's lack of total experience.NTSB CHI91LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDInadequate visual outlook by the pilot in command.NTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.