NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 CHI95LA304Accident · No injuriesLimited investigationFinal reportKevin Naser Renegade Spirit · Tekamah, NEthe reason for the loss of engine power was undetermined.NTSB CHI95FA305Accident · 1 fatalField investigationFinal reportBeech C35 · Omaha, NEthe pilot's failure to maintain airspeed during the takeoff climb. Factors associated with the accident were the pilot's inadequate compensation for the crosswind condition and exceeding the aircraft weight and balance.NTSB CHI95LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Fremont, NEa loss of engine power for undetermined reasons. A factor in the accident was the unsuitable landing terrain.NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.NTSB CHI95LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Aurora, NEthe cracked engine assembly that caused the power loss during a critical phase of flight. Factors associated with this accident were the restricted airplane performance due to the power loss, the airplane's altitude was too low, and remedial action, by, the…NTSB CHI95LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Crete, NEthe pilot's failure to maintain clearance with the runway marker.NTSB CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.NTSB CHI95LA160Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Clarks, NEa partial failure of the engine supercharger.NTSB CHI95FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · North Loup, NEFailure to the student pilot to maintain control of the airplane during a forced landing, after experiencing fuel starvation due to fuel mismanagement. Factors relating to the accident were: inadequate oversight (supervision) by the flight instructor (CFI),…NTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.NTSB CHI95LA117Accident · No injuriesLimited investigationFinal reportLewis KR-2 · Ogallala, NEthe owner/builder's improper maintenance (installation). Factors were the carburetor reversed and the mixture control cable not secured.NTSB CHI95LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Table Rock, NEthe pilot's failure to maintain directional control during an aborted takeoff. Factors related to the accident were the crosswind conditions and the berm which the airplane contacted.NTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.NTSB CHI95LA089Accident · No injuriesLimited investigationFinal reportCessna T310R · Grand Island, NEthe pilot's failure to deploy the deicing boots during the approach and the failure to maintain aircraft control during the landing. A factor related to the accident was the existing icing conditions.NTSB CHI95LA080Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brule, NELoss of engine power due to undetermined reasons.NTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.