NTSB investigations, 1989, NE
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1989
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") = 1989 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 MKC90LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Norfolk, NEInproper in-flight planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the adverse weather conditions, the pilot's lack…NTSB MKC90FA038Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Lynch, NEAirspeed was not maintained by the pilot resulting in a stall/spin.NTSB MKC90FA019Accident · 2 fatalField investigationFinal reportCessna 320 · Nebraska City, NEThe pilot's decision to continue the flight into IFR conditions and the failure to maintain adequate alittude. Factors related to the accident were the pilot's over confidence in his ability and the lack of instrument flight experience.NTSB MKC90LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Omaha, NEFailure of the throttle cable assembly which resulted in a forced landing and subsequent collision with a fence.NTSB MKC89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · North Omaha, NEThe pilot's selection of unsuitable terrain on which to make a simulated forced landing.NTSB MKC89FA197Accident · Serious injuriesField investigationFinal reportCessna 172N · Hyannis, NEFailure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.NTSB MKC89FA165Accident · 2 fatalField investigationFinal reportBeech C23 · Neligh, NEFailure of the pilot to maintain adequate airspeed after intiating a steep climbing maneuver from low altitude. Factors related to the accident were: the pilot's lack of total flying experience and lack of sufficient altitude.NTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.NTSB MKC89LA155Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Wymore, NEThe pilot's failure to maintain airspeed and altitude during climbout. Contributing to the accident was the high density altitude.NTSB MKC89FA153Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Broken Bow, NEImproper planning/decision by the pilot by performing acrobatic flight with baggage in the rear cockpit of the aircraft, which probably restricted movement of the flight controls and resulted in uncontrolled flight and a spin.NTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.NTSB MKC89LA114Accident · No injuriesLimited investigationFinal reportCessna 188 · Table Rock, NEThe catastrophic failure of the internal engine components due to oil starvation. Contributing to the severity of the accident was the rough terrain the pilot was forced to land on.NTSB MKC89LA113Accident · Minor injuriesLimited investigationFinal reportAmerican AA5-B · Valentine, NEThe pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.NTSB MKC89FA099Accident · 3 fatalField investigationFinal reportMaule M-5 · Ainsworth, NEThe pilot continued flight into IFR conditions and the loss of aicraft control due to spatial disorientation. Contributing to the accident were the cloud conditions and fog.NTSB MKC89FA094Accident · 2 fatalField investigationFinal reportPiper J3C · Ashland, NEPoor judgement of the pilot by flying while physically impaired from alcohol consumption, and his failure to maintain adequate airspeed, while flying over a meandering river, which resulted in a stall. A contributing factor was the pilot's inadequate altitude…NTSB MKC89DCJ02Accident · 1 fatalFinal reportSchmahl Volksplane VP-1 · Papillion, NEThe pilot failed to maintain the proper climb rate and inadvertently stalled the aircraft which entered an uncontrolled descent into an open field.NTSB MKC89LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Papillion, NEThe contamination of the fuel screen by foreign matter and operation of the aircraft with known deficiencies.NTSB MKC89LA078Accident · No injuriesLimited investigationFinal reportCessna 175 · Murray, NEWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the ditch in the emergency landing area.NTSB MKC89LA077Accident · No injuriesLimited investigationFinal reportJennings Pietenpol Aircamper · Lincoln, NEFailure of the pilot in command to adequately preflight the aircraft resulting in a front cockpit seat cushion interfering with the rudder pedals and brakes.NTSB MKC89LA073Accident · No injuriesLimited investigationFinal reportCessna 310Q · Norfolk, NEThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadequate flare. Contributingto the accident were the icing conditions and ice accumulation of the wings of the airplane.NTSB MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.NTSB MKC89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chadron, NEThe plt failed to devote full time & attention to flying the acft, with a resulting loss of control and collision with the ground. Contributing to the accident was the dark night conditions.