NTSB investigations, 1993, NE
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1993
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") = 1993 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 CHI94LA055Accident · No injuriesLimited investigationFinal reportCessna 185 · Grand Island, NEthe pilot's failure to maintain directional control of the airplane. A factor related to the accident was the gusty quartering tailwind condition.NTSB CHI94LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the pilot's lack of total flight experience.NTSB CHI94FA018Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Atkinson, NEthe instrument rated commercial pilot's failure to maintain adequate clearance from terrain/obstructions during the initial climb after takeoff. Related factors are the weather conditions (fog) and the pilot's failure to maintain the proper rate of climb.NTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.NTSB CHI93LA328Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Wilber, NEthe loss of engine power for an undetermined reason.NTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.NTSB CHI93LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Millard, NEImproper maintenance/inspection of the aircraft by (other) maintenance personnel, and subsequent blockage of the induction air system by an object (alternate air door) that was not removed during previous maintenance.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.NTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.NTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.NTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.NTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB CHI93FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Plattsmouth, NEThe pilot-in-command (CFI)'s failure to maintain airspeed.NTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.NTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.NTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.NTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.NTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.