NTSB investigations, 1990, NE
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
| 1962 | 1 |
|---|---|
| 1964 | 58 |
| 1965 | 67 |
| 1966 | 72 |
| 1967 | 89 |
| 1968 | 80 |
| 1969 | 88 |
| 1970 | 74 |
| 1971 | 93 |
| 1972 | 64 |
| 1973 | 52 |
| 1974 | 71 |
| 1975 | 47 |
| 1976 | 64 |
| 1977 | 52 |
| 1978 | 49 |
| 1979 | 41 |
| 1980 | 36 |
| 1981 | 34 |
| 1982 | 42 |
| 1983 | 39 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 27 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 22 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 21 |
| 1994 | 20 |
| 1995 | 16 |
| 1996 | 14 |
| 1997 | 14 |
| 1998 | 28 |
| 1999 | 23 |
| 2000 | 13 |
| 2001 | 19 |
| 2002 | 14 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 15 |
| 2006 | 17 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 7 |
| 2012 | 21 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 17 |
| 2025 | 11 |
| 2026 | 4 |
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\") = 1990
AND c.\"eventStateOrRegion\" = 'NE' 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") = 1990 AND c."eventStateOrRegion" = 'NE' 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 CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.NTSB CHI90DCJ02Accident · 1 fatalFinal reportAero Commander Calair A9B · Ord, NEThe pilot's failure to maintain aircraft control during low altitude maneuvering.NTSB CHI90LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-150 · Minden, NEA stall encountered because of aircraft control not maintained by the PIC. Factors were a partial powerplant failure due to carburetor icing conditions, carburetor heat not used by the PIC, and load jettison not performed by the PIC.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB CHI90DCJ01Accident · 1 fatalFinal reportCessna A188B · Amherst, NEThe pilot's failure to see and avoid power lines in his area of operation.NTSB CHI90LA203Accident · Minor injuriesLimited investigationFinal reportForbing Longeze · Yutan, NEFuel exhaustion due to an inadequate supply of fuel and the pilot's lack of familiarity with this home-built aircraft. Factors related to the accident were: darkness and obstructions (vehicle & road sign) in the emergency landing area.NTSB MKC90LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Tecumseh, NEExcessive taxi speed and directional control not maintained by the pilot in command.NTSB MKC90DCJ01Accident · 1 fatalFinal reportK. W. Jeffers Varieze · Brainard, NEPilot used poor judgement in attempting aerobatics with inadequate altitude which resulted in loss of aircraft control. Contributing factors were a low pass performed, over confidence in personal ability and ostentatious display by the PIC.NTSB MKC90LA096Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot in command's failure to compensate for wind while landing resulting in loss of directional control and collision with terrain.NTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.NTSB MKC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Hyannis, NEFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and a subsequent nose over. Factors related to the accident were: the pilot's lack of experience in this aircraft, and the soft terrain.NTSB MKC90LA073Accident · No injuriesLimited investigationFinal reportBeech B35 · Hartington, NEDirectional control not maintained by the pilot in command.NTSB MKC90LA063Accident · No injuriesLimited investigationFinal reportCessna 310G · O'Neill, NEFailure of the pilot to select the proper runway or go around. Factors related to the accident were: inadequate wind indicator, tailwind, failure of the pilot to attain the proper touchdown point, and the ditch.