NTSB investigations, 1994, NE
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
Latest 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\") = 1994
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") = 1994 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 CHI95LA051Accident · 2 fatalLimited investigationFinal reportP. D. Chambers Swift PC-1V8 · Lincoln, NEThe pilot's failure to maintain control of the airplane, resulting in a stall-spin. Factors were an inadequate preflight and the loss of engine power resulting from water contamination in the automotive fuel.NTSB CHI94LA313Accident · Serious injuriesLimited investigationFinal reportWilliam P. Bouda Varieze · Millard, NEthe loss of engine power due to fuel starvation from vapor lock. A factor associated with the accident is the soft terrain the pilot was forced to land upon.NTSB CHI94FA282Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Humphrey, NEthe pilot's failure to maintain control of the airplane. A factor associated with the accident is the pilot's buzzing of the passenger's brother-in-law's house.NTSB CHI94LA266Accident · Serious injuriesLimited investigationFinal reportBeech B33 · Imperial, NEthe failure of the pilot-in-command to maintain directional of the airplane during takeoff.NTSB CHI94FA263Accident · 2 fatalField investigationFinal reportPiper PA-25 · Decatur, NELoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB CHI94LA240Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Wymore, NEfailure of the fuel injector pump due to improper assembly.NTSB CHI94LA235Accident · No injuriesLimited investigationFinal reportBeech 17 · Elgin, NEthe pilot's failure to maintain clearance with the road sign. Factors in the accident were the sign and the failure of the landing gear to extend into the full down and locked position.NTSB CHI94DCJ02Accident · Minor injuriesFinal reportMueller Q2 · Utica, NEThe failure of the carburetor float valve. A related factor is the high vegetation at the landing site.NTSB CHI94DCJ01Accident · Serious injuriesFinal reportMustari Dragonfly Mark II · Scottsbluff, NEthe private pilot's inadequate preflight planning/preparation. A related factor is the high density altitude.NTSB CHI94LA190Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEinadvertant VFR flight into IMC conditions and the pilot's failure to maintain directional control of the airplane. Factors related to the accident were the ground fog and rough terrain encountered.NTSB CHI94LA180Accident · No injuriesLimited investigationFinal reportMooney M20E · Omaha, NEinaccurate fuel consumption calculations and the inadequate fuel supply for the flight. Factors related to the accident were the ditch and the quantity gage which gave a false indication.NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.NTSB CHI94LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Chapman, NEThe pilot-in-command's attempted VFR flight into instrument weather conditions which resulted in spatial disorientation. Factors associated with the accident were the pilot-in-command's over confidence in his personal ability.NTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.NTSB CHI94LA129Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Hebron, NEThe failure of the student pilot to maintain adequate clearance from obstructions during aerial taxi.NTSB CHI94FA128Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Alliance, NEThe pilot's spatial disorientation and inadvertant entry into a spiral dive. Factors were the pilot's lack of total instrument experience and the weather conditions of blowing snow and turbulence.NTSB CHI94LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ellsworth, NEthe jammed impulse coupling on the left magneto which caused the crankshaft drive gear to shear from the crankshaft.NTSB CHI94FA116Accident · Serious injuriesField investigationFinal reportCanadair CL=601-3A · Bassett, NEthe pilot in command's inadequate planning/decision making and inadequate preflight inspection after receiving a load of contaminated fuel. Related factors are the contaminated fuel, improper refueling by FBO personnel, and the dark night light conditions.NTSB CHI94LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Aurora, NEan inadequate fuel supply for the flight and the pilot's failure to refuel while en route. A factor related to the accident was the soft terrain on which the airplane was landed.NTSB CHI94MA072Accident · 2 fatalMajor investigationFinal reportCessna 421C · Mccook, NEImproper in-flight planning/decision by the pilot, and the accumulation of airframe ice, which resulted in an inadvertent stall. Factors associated with the accident were: partial failure of both alternators, which resulted in a subsequent electrical system…