NTSB investigations, 1996, 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\") = 1996
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") = 1996 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 CHI97LA046Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Hayes Center, NEinadequate fuel management by the pilot, which resulted in fuel starvation. The factors relating to the accident were: a fuel leak at the engine driven fuel pump, and the engine driven fuel pump pressure was too low.NTSB CHI97LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Alliance, NEthe instructor-pilot's inadequate supervision by not taking timely action after the student started losing directional control. A factor was the loss of directional control by the student pilot.NTSB CHI97LA006Accident · Minor injuriesLimited investigationFinal reportCallair B1A · Nebraska City, NEa supercharger bearing failure. A factor was the excessive sink rate during the forced landing.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB CHI96LA287Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Wellfleet, NEfailure of the pilot to maintain aircraft control, while maneuvering at low latitude. The hilly (rolling) terrain and unfavorable wind were related factors.NTSB CHI96LA291Accident · No injuriesLimited investigationFinal reportCessna 150 · Plattsmouth, NEfailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB CHI96LA281Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164 · Grant, NEfatigue failure and subsequent catastrophic failure of the number nine cylinder. A factor was the corn.NTSB CHI96LA212Accident · No injuriesLimited investigationFinal reportBeech C23 · Ainsworth, NEthe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and the pilot's selection of an unsuitable landing area for the forced landing.NTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB CHI96LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · David City, NEthe instructor pilot failed to maintain control of the aircraft during a soft field takeoff. Factors were the gusting winds and the soft field.NTSB CHI96FA135Accident · 2 fatalField investigationFinal reportPiper J-3 · Raymond, NEfailure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…NTSB CHI96FA091Accident · 2 fatalField investigationFinal reportHughes 369D · Dweese, NEthe pilot's improper in-flight planning and decision, and his lack of total experience in the type of operation. A factor was the crosswind.NTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.NTSB CHI96FA073Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hallam, NEimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.