NTSB investigations, 1998, 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\") = 1998
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") = 1998 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 CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.NTSB CHI98LA361Accident · 2 fatalLimited investigationFinal reportChampion BL-7-GCBC · Upham, NDThe pilot's steep pull and failure to maintain adequate airspeed, which resulted in a stall/spin. Contributing factors were the pilot's lack of familiarity with the airplane's handling qualities, and a lack of recent experience in the airplane.NTSB CHI98LA337Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL M18B · Tappen, NDthe pilot's improper preflight preparation resulting in the airplane exceeding the available airstrip distance during takeoff. A factor contributing to this accident was the swamp.NTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.NTSB CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB CHI98LA292Accident · No injuriesLimited investigationFinal reportBell M74L · Grand Forks, NDThe worn rotor clutch shoes, and subsequent loss of main rotor rpm.NTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.NTSB CHI98LA259Accident · 1 fatalLimited investigationFinal reportAnderson T Craft Special · Pick City, NDThe pilot's failure to maintain sufficient altitude/clearance with terrain. A factor was the pilot's attempted low altitude acrobatic maneuver.NTSB CHI98LA271Accident · Minor injuriesLimited investigationFinal reportVollmers Sonerai II L · Lincoln, NDLoss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.NTSB CHI98LA243Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Minto, NDthe pilot's selection of unsuitable terrain for takeoff. Factors were wet and soft runway conditions, and a ditch and the end of the overrun area.NTSB CHI98LA241Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fort Ransom, NDA loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.NTSB CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.NTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.NTSB CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…NTSB CHI98LA220Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDthe pilot's failure to maintain clearance with the powerline during a swath run. A factor associated with the accident was the powerline.NTSB CHI98LA175Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75-N1 · West Fargo, NDthe pilot's failure to assure an adequate fuel supply in order to complete the flight. A factor associated with the accident was the soft terrain on which the forced landing was made.NTSB CHI98LA155Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Dawson, NDthe pilot's failure to maintain clearance with the telephone pole. Factors associated with the accident were the pole and the glare from the rising sun.NTSB CHI98FA119Accident · 1 fatalField investigationFinal reportCessna 208B · Bismarck, NDthe pilot's failure to maintain adequate airspeed during the approach which resulted in an inadvertant stall. Factors associated with the accident were the icing conditions and the pilot's low level experience in this make and model of airplane.NTSB CHI98LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Edgeley, NDThe pilot's inadequate in-flight planning/decision making which resulted in a delayed go-around and his not maintaining aircraft control. A factor was the crosswind.