NTSB investigations, 2007, NE
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2007
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") = 2007 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 CHI08CA043Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Loop City, NEThe obstruction clearance not maintained by the pilot during an aerial application of a field and the subsequent hard landing onto the field. Contributing factors were the power line and rough/uneven terrain.NTSB CHI08CA025Accident · No injuriesData collectionFinal reportCessna 152 · O'Neill, NEThe pilot's failure to assure the oil filter was installed on the airplane which resulted in oil starvation. Factors associated with the accident were the mechanic not installing the oil filter, the low altitude at which the loss of engine power occurred, and…NTSB CHI07CA297Accident · No injuriesData collectionFinal reportBoeing Stearman E75 · Gordon, NEThe pilot's failure to maintain directional control during the crosswind landing which resulted in the inadvertent ground loop.NTSB CHI07CA292Accident · No injuriesData collectionFinal reportMaule M5-210C · Central City, NEThe pilot's improper compensation for the crosswind condition and his failure to maintain directional control during landing, which resulted in an inadvertent ground loop. A contributing factor was the crosswind.NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.NTSB CHI07CA251Accident · No injuriesData collectionFinal reportPiper PA-17 · Scribner, NEThe pilot's failure to maintain directional control during landing. A contributing factor was the gusting crosswind condition.NTSB CHI07CA223Accident · Minor injuriesData collectionFinal reportBush Caddy USA LSA · Chadron, NEThe pilot's failure to maintain control of the aircraft during landing. A contributing factor was the gusty, crosswind condition.NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…NTSB CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB CHI07LA098Accident · 2 fatalLimited investigationFinal reportWakewood Lancair O-200 · Scottsbluff, NEThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident were the low altitude at which the airplane was operating and the gusty wind conditions.NTSB CHI07FA068Accident · Serious injuriesField investigationFinal reportCessna 208B · Alliance, NEThe pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.