NTSB investigations, 1996, 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\") = 1996
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") = 1996 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 CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.NTSB CHI97LA002Accident · No injuriesLimited investigationFinal reportCessna 185 · Finley, NDfailure of the flight instructor (CFI) to ensure that clearance from the dock was maintained, while starting to taxi. The crosswind was a related factor.NTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.NTSB CHI96LA343Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Minot, NDfuel management was not performed and starvation of the fuel system. A factor involved was inadequate in-flight planning/decision.NTSB CHI96LA277Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Fargo, NDthe pilot's failure to maintain clearance from a wire, while crossing under a transmission line. The proximity of wires to the work area was a related factor.NTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.NTSB CHI96LA259Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Hazelton, NDinadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…NTSB CHI96LA250Accident · Minor injuriesLimited investigationFinal reportPoppenhagen PUD Knocker Special · Grafton, NDthe inadequate fuel system design by the builder which led to fuel starvation.NTSB CHI96LA228Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDthe pilot's improper refueling procedure, inadequate preflight and the inadvertent stall. A factor related to the accident was the low altitude at which the loss of power occurred.NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.NTSB CHI96LA223Accident · No injuriesLimited investigationFinal reportBell TH-13T · Mandan, NDthe pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.NTSB CHI96FA216Accident · No injuriesField investigationFinal reportFairchild SA227AC · Grand Forks, NDinsufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.NTSB CHI96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Grand Forks, NDthe instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.NTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.NTSB CHI96LA162Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Fargo, NDthe flight crew did not comply with the gear down and lock checklist. The factors were a jammed nose gear and inattentive preflight planning/preparations by the pilot-in-command.NTSB CHI96LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Forks, NDthe pilot's failure to maintain control of the airplane while taxiing. Factors in the accident were the icy condition of the taxiway and the high gusting wind.