NTSB investigations, 1997, 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
Latest 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\") = 1997
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") = 1997 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 CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.NTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…NTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.NTSB CHI98LA001Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe circuit breaker for the hydraulic pump popped during gear extension which resulting in the failure of the landing gear to lock in the extended position.NTSB CHI97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fargo, NDthe pilot's misjudgment of altitude and distance to the runway, while on final approach to land, and failure to attain the proper touchdown point on the runway during the landing. The exposed runway lip was a related factor.NTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.NTSB CHI97LA278Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Larimore, NDthe pilot delaying the swath run turnaround maneuver at the end of the field boundary, and his failure to maintain clearance between the airplane and the high tension wires. A factor was the pilot's inattentiveness regarding the time to begin the swath run…NTSB CHI97LA238Accident · No injuriesLimited investigationFinal reportVelocity Velocity Elite RG · Langdon, NDfailure of the pilot to maintain directional control during the landing roll. The crosswind and proximity of the taxiway sign were related factors.NTSB CHI97LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fessenden, NDthe pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.NTSB FTW97IA261Incident · Minor injuriesIncident investigationFinal reportBoeing 757-223 · Dickinson, NDan encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.NTSB CHI97LA184Accident · Minor injuriesLimited investigationFinal reportWeatherly 201C · Buffalo, NDthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control of the airplane. Water on the runway and the soft terrain were related factors.NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.NTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.NTSB CHI97LA120Accident · No injuriesLimited investigationFinal reportMaule M-5 · West Fargo, NDthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point. Factors relating to the accident were: the unfavorable wind conditions, and the terrain condition where the airplane touched down.NTSB CHI97LA101Accident · Serious injuriesLimited investigationFinal reportAeronca 7CCM · Carson, NDa loss of engine power due to ice in the fuel line. A factor was inadequate maintenance and inspection.NTSB CHI97LA090Accident · No injuriesLimited investigationFinal reportCurtiss-Wright P-40E · Grand Forks, NDthe pilot's improper flare during landing.