NTSB investigations, 1999, 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
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\") = 1999
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") = 1999 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 CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB CHI00LA046Accident · No injuriesLimited investigationFinal reportCessna 150B · Omaha, NEThe pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.NTSB CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.NTSB CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.NTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB CHI99LA272Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · North Platte, NEThe pilot's improper inflight planning decision which resulted in fuel exhaustion. A factor associated with the accident was the dark night conditions.NTSB CHI99FA267Accident · 1 fatalField investigationFinal reportAir Tractor AT502B · Giltner, NEThe pilot's inadequate visual lookout, and his failure to maintain clearance from the guy wire. A factor was the guy wire.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB CHI99LA192Accident · Minor injuriesLimited investigationFinal reportRussell Sport Trainer · Ft. Calhoun, NEthe pilot used an improper engine starting procedure in that he failed to reduce the throttle setting and to assure the airplane was adequately secured prior to starting.NTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.NTSB CHI99LA137Accident · 2 fatalLimited investigationFinal reportBerrick GP-4 · Plattsmouth, NEaircraft control and airspeed not maintained by the pilot-in-command. A factor to the accident was the inadvertent stall.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB CHI99LA128Accident · No injuriesLimited investigationFinal reportCessna T-188C · Dalton, NEthe improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.NTSB CHI99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the gusty, high, wind conditions, and the pilot's continued flight into adverse weather.NTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB CHI99LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Alliance, NEthe unsuitable terrain for landing selected by the pilot-in-command. Factors were the tailwind landing condition and excessive braking by the pilot-in-command.NTSB CHI99LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Hyannis, NEthe pilot's failure to maintain clearance with the transmission line. Factors associated with the accident were the transmission line, the low altitude at which the pilot was flying, and his diverted attention to a person on the ground.