NTSB investigations, 2007, 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\") = 2007
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") = 2007 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 CHI08IA022Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Fargo, NDThe failure of the Brake and Steering Control Unit, which allowed the nose landing gear to turn to the 90-degree position.NTSB CHI08CA021Accident · Minor injuriesData collectionFinal reportBell 206B-III · Medora, NDThe pilot failed to maintain clearance from the fence while maneuvering at a low altitude, which resuled in the helicopter rolling over and impacting the terrain. A factor associated with the accident was the fence.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB CHI07CA298Accident · Minor injuriesData collectionFinal reportMaule M-4-220C · Keene, NDThe pilot's failure to maintain control of the airplane during takeoff due to the high crosswind condition. Contributing factors were the high, gusting crosswind, and the tree.NTSB CHI07CA267Accident · No injuriesData collectionFinal reportSnow S-2C · Hazelton, NDThe loss of engine power for undetermined reasons.NTSB CHI07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Overly, NDThe pilot's failure to maintain terrain clearance during the agricultural application flight. Contributing to the accident was the wheat crop.NTSB CHI07CA248Accident · No injuriesData collectionFinal reportBeech B60 · Bismark, NDThe improper fuel grade due to the improper fueling of the airplane by the fixed base operator, which led to the loss of engine power of both engines. A factor was the unsuitable terrain encountered during the forced landing.NTSB CHI07CA226Accident · No injuriesData collectionFinal reportHamilton Rotorway Exec 90 · Harvey, NDThe pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.NTSB CHI07CA215Accident · No injuriesData collectionFinal reportRotorway 162F · Heart, NDThe pilot inadvertently shut off the fuel pump switch which resulted in fuel starvation and the subsequent loss of engine power. An additional cause was the pilot's poorly executed autorotation/flare which resulted in a hard landing.NTSB CHI07CA209Accident · Serious injuriesData collectionFinal reportAir Tractor AT-301 · Lignite, NDThe pilot's poor in-flight planning and failure to maintain control of the airplane when he encountered his own vortex turbulence at a low altitude.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.NTSB CHI07CA161Accident · No injuriesData collectionFinal reportWeatherly 201C · Mc Clusky, NDThe pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…NTSB ENG07IA030Incident · No injuriesIncident investigationFinal reportLearjet 36 · Bismarck, NDA total loss of engine power during takeoff due to the right engine sustaining a fractured fan blade after the ingestion of a mallard duck. Some liberated fan blade fragments were uncontained, penetrating the nacelle.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.