NTSB investigations, 2003, 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
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\") = 2003
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") = 2003 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 CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…NTSB CHI03LA322Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Lincoln, NEThe total loss of engine power due to the fatigue fracture of the engine accessory gear drive. A factor was the concrete marker.NTSB CHI03LA285Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Omaha, NEThe pilot not maintaining aircraft control during the landing roll. Factors were the grass the airplane encountered when the airplane ground looped off the runway and the main gear collapsed.NTSB CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.NTSB CHI03LA226Accident · No injuriesLimited investigationFinal reportCessna 177 · Murdock, NEThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.NTSB CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…NTSB CHI03LA144Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Superior, NEThe pilot's failure to maintain adequate airspeed, and the delayed remedial action by the pilot, resulting in a stall. Factors to the accident included the aircraft’s low altitude and the pilot's lack of experience in the make/model of aircraft.NTSB CHI03LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · North Platte, NEThe pilot's failure to maintain directional control and the collapse of the main landing gear. A factor to the accident was the quartering tailwind.NTSB CHI03LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Benkelman, NEThe pilot's failure to maintain altitude clearance while maneuvering. Contributing factors were the wheat crop and the ground.NTSB CHI03LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gordon, NEThe pilots failure to maintain adequate airspeed which resulted in a stall. Contributing factors to this accident were the rain, hail, and wind gusts.NTSB CHI03LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Grand Island, NEThe loss of engine power due to fuel contamination and the pilot's inadequate preflight inspection.NTSB CHI03LA052Accident · 1 fatalLimited investigationFinal reportHavir Avid Flyer · Cambridge, NEThe inadvertent stall by the pilot following a total loss of engine power and the seizure of the engine. A factor to the accident was the engine overhaul not performed in accordance with the manufacturer's recommendations.