NTSB investigations, 2004, VA
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
| 1963 | 1 |
|---|---|
| 1964 | 75 |
| 1965 | 76 |
| 1966 | 91 |
| 1967 | 75 |
| 1968 | 90 |
| 1969 | 87 |
| 1970 | 74 |
| 1971 | 53 |
| 1972 | 60 |
| 1973 | 56 |
| 1974 | 61 |
| 1975 | 53 |
| 1976 | 59 |
| 1977 | 60 |
| 1978 | 64 |
| 1979 | 65 |
| 1980 | 63 |
| 1981 | 42 |
| 1982 | 38 |
| 1983 | 52 |
| 1984 | 53 |
| 1985 | 44 |
| 1986 | 42 |
| 1987 | 35 |
| 1988 | 43 |
| 1989 | 36 |
| 1990 | 34 |
| 1991 | 33 |
| 1992 | 31 |
| 1993 | 32 |
| 1994 | 27 |
| 1995 | 30 |
| 1996 | 26 |
| 1997 | 26 |
| 1998 | 30 |
| 1999 | 31 |
| 2000 | 39 |
| 2001 | 42 |
| 2002 | 38 |
| 2003 | 31 |
| 2004 | 22 |
| 2005 | 15 |
| 2006 | 32 |
| 2007 | 36 |
| 2008 | 30 |
| 2009 | 34 |
| 2010 | 27 |
| 2011 | 30 |
| 2012 | 24 |
| 2013 | 17 |
| 2014 | 25 |
| 2015 | 21 |
| 2016 | 30 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 24 |
| 2020 | 15 |
| 2021 | 18 |
| 2022 | 21 |
| 2023 | 25 |
| 2024 | 27 |
| 2025 | 24 |
| 2026 | 12 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'VA' 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") = 2004 AND c."eventStateOrRegion" = 'VA' 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 NYC05CA031Accident · No injuriesData collectionFinal reportFlight Design CT-2K · Waynesboro, VAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB NYC05LA030Accident · No injuriesLimited investigationFinal reportDay VP-2 · Warrenton, VAA loss of engine power for an undetermined reason.NTSB IAD05LA022Accident · No injuriesLimited investigationFinal reportCessna 414 · Petersburg, VAThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).NTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB NYC05FA021Accident · 2 fatalField investigationFinal reportCessna 310R · Paeonian Spring, VAThe pilot's failure to follow the published instrument approach procedure, which resulted in an in-flight collision with terrain. A factor related to the accident was the low cloud ceiling.NTSB NYC05LA020Accident · Serious injuriesLimited investigationFinal reportUnknown Sky Raider · Rappahannock Ac, VAThe uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.NTSB NYC05LA009Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Dulles, VAThe pilot's improper in-flight decision to continue the instrument approach and landing, which resulted in a collision with a sign. A factor was the below instrument approach landing minimum weather conditions.NTSB IAD05MA006Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Stuart, VAThe flight crew's failure to properly execute the published instrument approach procedure, including the published missed approach procedure, which resulted in controlled flight into terrain. Contributing to the cause of the accident was the flight crew's…NTSB NYC05FA006Accident · 1 fatalField investigationFinal reportBeech H50 · Hartwood, VAThe pilot's inadequate preflight preparation, which resulted in an attempted takeoff with full flaps, and subsequent loss of control.NTSB NYC05CA007Accident · No injuriesData collectionFinal reportBeech A23 · New Market, VAA collision with a deer during the takeoff roll. A factor in the accident was the night.NTSB NYC04LA219Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-22A · Richmond, VAThe pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…NTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB NYC04LA182Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-27 · Windsor, VAThe pilot's improper use of a navigation aid, which resulted in him becoming lost, and having to perform a forced landing.NTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.NTSB NYC04LA168Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319 · Flat Rock, VAAn inadvertent encounter with turbulence in clouds during descent.NTSB NYC04LA162Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Norfolk, VAThe pilot's failure to complete an autorotation due to the restrictive movement of the collective control.NTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB NYC04CA112Accident · No injuriesData collectionFinal reportBolger Scott RV-6A · Fredericksburg, VAThe pilots failure to maintain airspeed during a precautionary landing which resulted in an undershoot and subsequent impact with terrain. A factor was the inadequate pre-flight inspection.NTSB NYC04LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Harrisonburg, VAThe pilot's improper decision to attempt a landing with an excessive tailwind, which resulted in an inadvertent stall while attempting to climb during a go-around. A factor related to the accident was the tailwind conditions and the rising terrain beyond the…NTSB NYC04LA065Accident · No injuriesLimited investigationFinal reportCessna 150F · Suffolk, VAThe failure of the number four cylinder barrel due to fatigue which originated from a corrosion pit at the base of a cooling fin.