NTSB investigations, 2003, 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\") = 2003
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") = 2003 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 NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.NTSB NYC04LA004Accident · 1 fatalLimited investigationFinal reportPfeifler Edge-540 · Warrenton, VAThe pilot's failure to maintain aircraft control while performing aerobatic maneuvers.NTSB IAD04CA002Accident · No injuriesData collectionFinal reportCessna 140 · Ridegway, VAThe pilot's improper pre-flight planning, which resulted in an engine failure due to fuel exhaustion.NTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.NTSB NYC03LA199Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Norfolk, VAthe airline ground person's failure to properly control the pushback tug, and her subsequent failure to maintain adequate clearance between the tug and the airplane. Factors contributing to the accident were the airline ground person's operation of the tug…NTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.NTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.NTSB NYC03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, VALoss of engine power due to unknown circumstances.NTSB IAD03LA073Accident · No injuriesLimited investigationFinal reportMooney M20K · Chesterfield, VAThe loss of engine power due to the fatigue fracture of the #2 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC03LA175Accident · No injuriesLimited investigationFinal reportStinson 108 · White Post, VAThe pilot/ mechanic's improper annual inspection including his rigging of the elevator flight control, and his subsequent inadequate preflight inspection of the airplane prior to flight, when he failed to detect the improperly rigged elevator flight control,…NTSB NYC03LA141Accident · No injuriesLimited investigationFinal reportCessna 170B · Brandy Station, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC03TA138Accident · No injuriesFinal reportAir Tractor 402A · Pearisburg, VAA compressor turbine blade fracture which resulted in a power loss, and forced landing. Factor were the rocks in the landing area, and the operator's decision to operate the engine beyond the engine manufacturer's recommendations for overhaul.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.NTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.NTSB NYC03LA111Accident · Serious injuriesLimited investigationFinal reportVirginia Wright Model B · Midland, VAThe pilot's failure to maintain aircraft control.NTSB NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.NTSB NYC03LA104Accident · Serious injuriesLimited investigationFinal reportBoeing B767-300 · New Market, VAThe inadvertent encounter with turbulence.NTSB IAD03LA048Accident · Serious injuriesLimited investigationFinal reportDornier 328-300 · Roanoke, VAThe airplane's encounter with unforecasted clear air turbulence during cruise flight.NTSB IAD03LA054Accident · Minor injuriesLimited investigationFinal reportRoger Mann Ragwing RW8-PT2S · Hanover, VAA loss of engine power for undetermined reasons. A factor was the wheat in the forced landing field.NTSB NYC03LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Blacksburg, VAThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC03LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Shenandoah, VAThe pilot's inadvertent encounter with snow showers. Factors were the snow and the unsuitable landing area.NTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.NTSB IAD03LA036Accident · 1 fatalLimited investigationFinal reportCessna R172K · Richmond, VAThe passenger's failure to remain clear of the propeller. Factors included the passenger's recent use of marijuana, the pilot's inadequate pre-flight inspection, and the night lighting conditions.NTSB NYC03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mineral, VAThe flight instructor's delayed remedial action.NTSB IAD03FA035Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Leesburg, VAThe pilot's failure to fly a stabilized, published instrument approach procedure, and his failure to maintain adequate airspeed which led to an aerodynamic stall.NTSB IAD03LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesapeake, VAThe pilot's failure to adequately remove snow and ice from the airplane's wings prior to takeoff.