NTSB investigations, 2009, VA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2009
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") = 2009 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 ERA10LA098Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · Suffolk, VAThe pilot's inadequate recovery from a stall and inadvertent spin. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information. Also contributing was the instructor's inadequate…NTSB ERA10CA087Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Ashland, VAThe pilot’s failure to maintain adequate clearance from trees during the landing approach.NTSB DCA10FA012Accident · Serious injuriesField investigationFinal reportBoeing 777-200 · New Market, VAThe flight crew’s inadvertent encounter with a small area of cumulous clouds at night that resulted in moderate to severe convectively induced turbulence.NTSB ERA10LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Luray, VAThe pilot's premature rotation and liftoff and her subsequent failure to recognize and correct for the influence of ground effect on the airplane's takeoff performance.NTSB DCA10IA006Incident · No injuriesIncident investigationFinal reportBoeing 767 · Dulles International Airport, VAThe failure of the lead and left side marshallers to identify the B40 jetway obstacle and stop the airplane's taxi before the wingtip contacted the jetway. Contributing to the cause of this incident were inadequate marshalling procedures used by the ground…NTSB ERA10CA017Accident · Serious injuriesData collectionFinal reportPiper PA28 · Lebanon, VAThe pilot’s decision to continue flight under visual flight rules into known deteriorating weather conditions, which resulted in controlled flight into terrain.NTSB ERA10CA003Accident · No injuriesData collectionFinal reportMalone Henry O Howland · Gloucester, VAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning .NTSB ERA09LA528Accident · No injuriesLimited investigationFinal reportMooney M20K · Farmville, VAThe pilot’s failure to maintain directional control during the landing rollout.NTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.NTSB ERA09CA508Accident · No injuriesData collectionFinal reportMooney 231 · Charlottesville, VAThe pilot’s inadequate preflight planning and lack of familiarity with the airport diagram, which resulted in a runway excursion onto a grassy area.NTSB ERA09LA529Accident · No injuriesLimited investigationFinal reportBombardier DHC-8-202 · Sterling, VAUndetermined.NTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA09CA463Accident · No injuriesData collectionFinal reportAmerican Legend AL3C · Warrenton, VAThe pilot's improper application of brakes during the landing rollout.NTSB ERA09LA452Accident · 1 fatalLimited investigationFinal reportMaxair Drifter · Bumpass, VAThe accelerated stall induced by the pilot in a steep turn to avoid obstacles during takeoff. Contributing to the accident were the pilot’s chosen takeoff path and the density altitude.NTSB ERA09LA456Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight inspection and failure to ensure an adequate quantity of fuel was available for the flight.NTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.NTSB ERA09LA435Accident · 1 fatalLimited investigationFinal reportBeech B90 · West Point, VAThe inadvertent deployment of the instructor's reserve parachute.NTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.NTSB DCA09FA068Accident · Serious injuriesField investigationFinal reportEmbraer EMB170 · Norfolk, VAan inadvertent encounter with convective turbulence that resulted in serious injuries to a flight attendant.NTSB ERA09CA422Accident · Minor injuriesData collectionFinal reportDart GW · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the wet turf landing surface.NTSB ERA09CA405Accident · No injuriesData collectionFinal reportPiper PA28 · Blacksburg, VAThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.NTSB ERA09CA374Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Quinton, VAA loss of directional control on landing for undetermined reasons.NTSB ERA09LA370Accident · Serious injuriesLimited investigationFinal reportMichael J. Kohout Glassair III · Manassas, VAThe pilot's failure to maintain aircraft control while attempting an emergency landing after takeoff. Contributing to the accident was the pilot's inadequate preflight inspection and distraction due to a separated fuel cap in flight.NTSB ERA09CA365Accident · No injuriesData collectionFinal reportCessna 172H · Lovingston, VAThe pilot's failure to maintain directional control during takeoff.NTSB ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.NTSB ERA09LA344Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 Twin · Orange, VAThe pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.NTSB ERA09LA330Accident · No injuriesLimited investigationFinal reportYakovlev/Day YAK-11 · Culpeper, VAThe pilot’s failure to maintain directional control during landing.NTSB ERA09LA317Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Greenville, VAThe inadequate design of the fourth-stage turbine wheel, resulting in the fatigue failure of one airfoil and a subsequent loss of engine power.NTSB ERA09FA311Accident · 1 fatalField investigationFinal reportMooney M20D · Clintwood, VAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB ERA09CA260Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Chesapeake, VAThe student pilot's improper recovery from a bounced landing.NTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.NTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.