NTSB investigations, 2002, NE
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2002
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") = 2002 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 CHI02LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369D · O'Neill, NEA loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…NTSB CHI02CA253Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Ohiawa, NEThe pilot failed to verify the aircraft refueling and he did not follow emergency procedures for engine restart. Factors to the accident included fuel starvation and the fence post.NTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB CHI02LA242Accident · No injuriesLimited investigationFinal reportRare Waco T-10 · Omaha, NEThe partial loss of engine power due to fuel starvation as a result of a restricted fuel line, and the unsuitable terrain for landing encountered by the pilot. A contributing factor was the bean field.NTSB CHI02LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, NEThe pilot not maintaining sufficient airspeed during the takeoff, and the inadvertent stall encountered by the pilot. The low altitude was a factor.NTSB CHI02LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Central City, NEThe pilot was not able to maintain clearance with the trees when the airplane encountered a downdraft at a low altitude. An additional cause was the pilot's inadequate evaluation of the approaching weather conditions. Factors associated with the accident were…NTSB CHI02LA207Accident · No injuriesLimited investigationFinal reportCessna C180A · Ogallala, NEThe pilot's failure to maintain directional control of the aircraft. The open window diverting the pilot's attention was a contributing factor.NTSB CHI02CA198Accident · No injuriesData collectionFinal reportBaughman KR-2 · Scribner, NEThe pilot's excessive rotation and his failure to attain climb which resulted in a stall/mush.NTSB CHI02LA179Accident · No injuriesLimited investigationFinal reportWaltz RV-8 · Omaha, NEA loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.NTSB CHI02FA174Accident · 3 fatalField investigationFinal reportEurocopter France AS-350-B2 · Norfolk, NEA loss of tail rotor effectiveness and the pilot's failure to maintain control of the helicopter. Factors associated with the accident were the binding of the tail rotor pitch changed rod, the gusty wind conditions, and the pilot’s lack of total experience in…NTSB CHI02LA132Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hordville, NEA loss of engine power due to a fractured rocker arm shaf. Contributing to the accident was the soft, furrowed field.NTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.NTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.NTSB CHI02LA064Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Wahoo, NEThe student, who was a private pilot, used excessive braking during the landing roll.