NTSB investigations, 1992, 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\") = 1992
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") = 1992 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 CHI93LA057Accident · No injuriesLimited investigationFinal reportBeech V35A · Marshall, MNThe pilot's improper aircraft handling during ground operation with a gusty tailwind.NTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB CHI92LA295Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B85C · Buffalo, MNThe contamination of the carburetor, inadequate maintenance inspection by maintenance personnel, and the inadequate maintenance servicing by the pilot/owner.NTSB CHI92LA285Accident · No injuriesLimited investigationFinal reportCessna 177B · Norcross, MNThe pilot's premature liftoff which resulted in inadequate airspeed for takeoff. Factors related to the accident were the crosswind conditions, the pilot's inadequate compensation for the crosswind, and the pilot's total lack of experience.NTSB CHI92FA257Accident · 3 fatalField investigationFinal reportCessna 310D · Crystal, MNThe pilot's failure to maintain aircraft control during takeoff/initial climb in gusty, shifting crosswind conditions.NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.NTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.NTSB CHI92DER03Accident · No injuriesFinal reportSchneider/Brashear Sorrell SNS-7 · Alexandria, MNThe pilot's failure to maintain directional control during the landing roll.NTSB CHI92LA235Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Paul, MNThe pilot's inattentiveness and improper use of the airplanes brakes. A factor which contributed to this accident was the incorrect brake system installed on the airplane.NTSB CHI92LA234Accident · No injuriesLimited investigationFinal reportGrumman AA5 · Pinecreek, MNThe pilot-in-command's failure to obtain a proper climb rate.NTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.NTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.NTSB CHI92DER02Accident · No injuriesFinal reportPiper PA-25-235 · Badger, MNThe pilot's failure to maintain aircraft control while maneuvering at low altitude in gusty winds.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB CHI92DER01Accident · Serious injuriesFinal reportGoehring Quickie · So. St. Paul, MNA loss of engine power due to carburetor ice. The lack of suitable terrain for the forced landing was a factor.NTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.NTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.NTSB CHI92LA108Accident · No injuriesLimited investigationFinal reportCessna 150 · Waseca, MNDirectional control was not maintained by the pilot.NTSB CHI92LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Sandstone, MNThe collision with the deer, the damage to the gascolator which resulted from the collision and the pilot's decision to abort the landing after the collision.NTSB CHI92LA081Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Minneapolis, MNA misjudged autorotation.NTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.