NTSB investigations, 2007, MN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 113 |
|---|---|
| 1965 | 115 |
| 1966 | 117 |
| 1967 | 130 |
| 1968 | 95 |
| 1969 | 113 |
| 1970 | 88 |
| 1971 | 80 |
| 1972 | 82 |
| 1973 | 77 |
| 1974 | 83 |
| 1975 | 98 |
| 1976 | 78 |
| 1977 | 92 |
| 1978 | 98 |
| 1979 | 76 |
| 1980 | 66 |
| 1981 | 89 |
| 1982 | 61 |
| 1983 | 68 |
| 1984 | 51 |
| 1985 | 57 |
| 1986 | 43 |
| 1987 | 40 |
| 1988 | 52 |
| 1989 | 50 |
| 1990 | 42 |
| 1991 | 59 |
| 1992 | 25 |
| 1993 | 40 |
| 1994 | 39 |
| 1995 | 37 |
| 1996 | 40 |
| 1997 | 37 |
| 1998 | 36 |
| 1999 | 33 |
| 2000 | 39 |
| 2001 | 40 |
| 2002 | 46 |
| 2003 | 40 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 29 |
| 2007 | 25 |
| 2008 | 31 |
| 2009 | 29 |
| 2010 | 32 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 33 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 26 |
| 2017 | 20 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 26 |
| 2021 | 12 |
| 2022 | 24 |
| 2023 | 34 |
| 2024 | 24 |
| 2025 | 22 |
| 2026 | 13 |
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\" = 'MN' 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" = 'MN' 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 CHI08CA057Accident · No injuriesData collectionFinal reportLerohl RV-8 · Alexandria, MNThe loss of engine power for undetermined reasons.NTSB CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.NTSB CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.NTSB CHI08FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Browerville, MNAn in-flight collision with at least one Canada goose, and the resulting damage to the left stabilator that caused the airplane to become uncontrollable. Contributing to the accident was the night lighting condition, which precluded any possibility of the…NTSB CHI08CA018Accident · No injuriesData collectionFinal reportBell 407 · St Cloud, MNThe pilot's failure to execute a go-around when a normal approach to the intended landing point could not be maintained. An additional cause was the excessive descent rate that developed during the approach. Contributing factors were the tailwind condition…NTSB CHI08CA004Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey · Cokato, MNThe inadequate flare by the pilot during landing. Contributing factors were the lack of an endorsement by the pilot, the lack of total experience in the type of aircraft by the pilot, and the glassy water.NTSB CHI07CA315Accident · Minor injuriesData collectionFinal reportAerotechnik Sportstar-Evektor · Maple Lake, MNThe student pilot's failure to relinquish the flight controls and the flight instructor's inadequate supervision which resulted in the certified flight instructor not being able to maintain directional control. Contributing factors included the student…NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB CHI07CA299Accident · No injuriesData collectionFinal reportSchweizer 300 CBI · Minneapolis, MNThe dual student's improper flare during the simulated autorotation, and the flight instructor's delayed remedial action.NTSB CHI07LA277Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Anoka, MNThe loss of helicopter pitch control for undetermined reasons during the aerial application maneuver and the pilot's inability to control the aircraft during the descent.. A contributing factor to the accident was the soft terrain.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB CHI07CA263Accident · Minor injuriesData collectionFinal reportCessna 180 · Princeton, MNThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the fuel siphoning from the right fuel tank.NTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.NTSB CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.NTSB CHI07CA239Accident · No injuriesData collectionFinal reportCessna 150H · Cook, MNThe pilot not maintaining airspeed leading to the stall/mush encountered during takeoff and the unsuitable terrain the pilot selected during the forced landing. Factors were the vehicle encountered during the forced landing and the ditch the pilot steered the…NTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.NTSB CHI07LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Eden Prairie, MNThe pilot's inability to maintain control of the airplane for undetermined reasons. Contributing to the accident were the embankment and the fence.NTSB CHI07LA193Accident · No injuriesLimited investigationFinal reportHughes 369D · Comfrey, MNThe loss of engine power due to the loose pressure line during aerial application maneuvers which resulted in a hard forced landing.NTSB CHI07LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Oak Grove, MNA loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.NTSB CHI07FA176Accident · 1 fatalField investigationFinal reportBeech A36TC · Cannon Falls, MNThe pilot's continued flight into instrument meteorological conditions, which resulted in spatial disorientaton and loss of control.NTSB CHI07LA173Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fergus Falls, MNThe propeller blade failure during climb due to a fatigue crack. The oil leak that obstructed the pilot's vision was a factor in the accident.NTSB CHI07CA120Accident · No injuriesData collectionFinal reportChampion 7GCAA · Grand Rapids, MNThe pilot's failure to maintain directional control and his excessive use of brakes during the landing which resulted in a nose-over. The downhill slope was a contributing factor.NTSB CHI07CA105Accident · No injuriesData collectionFinal reportPavliga Hatz CB-1 · Buffalo, MNThe loss of engine power due to the carburetor fuel flow valve becoming stuck in the closed position, which resulted in fuel starvation.NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.