NTSB investigations, 2005, DE
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 | 12 |
| 1965 | 18 |
| 1966 | 8 |
| 1967 | 21 |
| 1968 | 6 |
| 1969 | 14 |
| 1970 | 15 |
| 1971 | 9 |
| 1972 | 6 |
| 1973 | 9 |
| 1974 | 10 |
| 1975 | 12 |
| 1976 | 6 |
| 1977 | 2 |
| 1978 | 7 |
| 1979 | 3 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 6 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 3 |
| 2005 | 5 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 4 |
| 2022 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 2005
AND c.\"eventStateOrRegion\" = 'DE' 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") = 2005 AND c."eventStateOrRegion" = 'DE' 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 NYC06LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Laurel, DEThe pilot's improper decision to takeoff from an unimproved field, and his subsequent failure to abort the takeoff prior to collision with a sign and an embankment. Factors in the accident were his improper soft field technique, and the dark night conditions.NTSB NYC05LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Felton, DEThe mechanic's inadequate annual inspection, and failure to comply with an airworthiness directive, which resulted in a total failure of the second stage turbine rotor.NTSB IAD05FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Georgetown, DEThe pilot's misjudged distance/altitude while on final approach to land, which resulted in an in-flight collision with a vehicle. Factors associated with the accident are the pilot's improper use of the flaps, and the state of Delaware's insufficient…NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.