NTSB investigations, 2002, 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\") = 2002
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") = 2002 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 NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.NTSB NYC03LA029Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Suffolk, VAThe pilot's inadequate visual lookout while landing, which resulted in a collision with an embankment.NTSB IAD03FA019Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Bastian, VAThe pilot's failure to maintain an adequate altitude above terrain. Factors in the accident were the dark night conditions and the low cloud ceiling.NTSB NYC03IA027Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Rockville, VAThe PIC's inadvertent encounter with turbulence while operating in an area of forecast occasional severe turbulence.NTSB NYC03LA017Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75 · Glade Spring, VAthe pilot's improper in-flight decision to fly at an altitude that did not allow for successful completion of a forced landing, after the engine lost power for undetermined reason(s). A factor was the unsuitable terrain.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB IAD03IA017Incident · No injuriesIncident investigationFinal reportCraig N. Moen RV-8 · Leesburg, VAA low-stress, high-cycle fatigue fracture of the right ignition timing rotor.NTSB NYC03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Hartwood, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB IAD02LA097Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Front Royal, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the airplane's proximity to the ground when the spin commenced.NTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.NTSB IAD02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Edinburg, VAA loss of engine power for undetermined reasons.NTSB NYC02LA180Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Louisa, VAA loss of engine power for an undetermined reason.NTSB NYC02LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manassas, VAThe pilot's inadequate pre-flight planning, and his inadequate visual lookout while taxing on an off airport road. A factor related to the accident was the dark night conditions.NTSB IAD02FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Stanardsville, VAThe pilot's failure to maintain sufficient altitude/clearance while descending over mountainous terrain. A factor was the night lighting conditions.NTSB NYC02FA166Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Deerfield, VAThe pilot's improper preflight decision to takeoff on an up-sloping runway with a tailwind, which resulted in an inadvertent stall and collision with a tree. Factors were the pilot's lack of familiarity with the geographic area, and a tailwind.NTSB NYC02LA149Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Madison Heights, VAThe pilot's failure to attain the proper touchdown point on the helipad, which resulted in a rollover. A factor in this accident was pilot fatigue.NTSB NYC02LA148Accident · Minor injuriesLimited investigationFinal reportBird CK · Harrisonburg, VAThe pilot's improper decision to perform a 180-degree turn with insufficient altitude remaining after experiencing a total loss of power. A factor related to the accident was the inadequate alignment of the fuel selector placard markings, resulting in an…NTSB NYC02LA139Accident · No injuriesLimited investigationFinal reportMicket Avid Aerobat · Chesapeake, VAA total loss of engine power due to a seized cylinder, and the pilot's improper decision to conduct the flight with a known deficiency to the engine.NTSB NYC02FA131Accident · 1 fatalField investigationFinal reportDiamond Aircraft Industries DA 20C-1 · Leesburg, VAA loss of engine power for undetermined reasons.NTSB NYC02LA128Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Moneta, VAThe loss of a clip and subsequent loss of the spring on the right side of the tail wheel assembly, for undetermined reasons, which led to a loss of directional control. A factor was the berm.NTSB NYC02LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Lynchburg, VAThe pilot's failure to maintain control of the airplane, a factor was the tailwind.NTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.NTSB IAD02LA059Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK21 · Woodstock, VAThe pilot's failure to recognize the loss of orographic lift conditions. A factor was the loss of orographic lift.NTSB NYC02FA098Accident · 3 fatalField investigationFinal reportBeech 23 · King George, VAThe pilot's improper in-flight decision to perform low passes; and his failure to maintain airspeed which resulted in a stall and collision with trees.NTSB NYC02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 152M · Forest, VAThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a nose over.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB NYC02LA081Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Louisa, VAThe airplane's inadvertent collision with a deer while landing at night. A factor in the accident was the night condition.NTSB NYC02LA074Accident · No injuriesLimited investigationFinal reportCessna 182C · Moneta, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB NYC02LA073Accident · Minor injuriesLimited investigationFinal reportAnnis Fisher FP-202 · Parksley, VAThe pilot's decision to continue the takeoff. A factor in the accident was the soft wet runway.NTSB IAD02LA036Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Strausburg, VAThe pilot's inadequate evaluation of weather resulted in a loss of thermal lift, which resulted in an impact with trees.NTSB DCA02MA026Accident · No injuriesMajor investigationFinal reportCanadair CL-600-2B19 · Dulles Airport, VAthe airplane's collision with two wild turkeys.NTSB IAD02LA034Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Fredericksburg, VAThe unauthorized modification of the air control box by unknown persons, and the failure of subsequent mechanics to note and correct the deficiency. Factors included the carburetor icing conditions and the unsuitable terrain mandated by the forced landing.NTSB NYC02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fredericksburg, VAThe private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.NTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.NTSB IAD02LA028Accident · 1 fatalLimited investigationFinal reportWilburn Jodel F-12 · Clarksville, VAThe pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Also causal, was the loss of engine power for undetermined reasons.NTSB NYC02LA054Accident · No injuriesLimited investigationFinal reportBeech F33A · Lynchburg, VAThe pilot's failure to maintain directional control and delay in aborting the takeoff.NTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…NTSB NYC02LA050Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Manassas, VAThe pilot's improper autorotation, which resulted in a hard landing and bent airframe support tube. A factor in this accident was previous damage to the airframe support tube.