NTSB investigations, 1999, VA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1999
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") = 1999 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 NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB IAD00LA014Accident · Minor injuriesLimited investigationFinal reportPrudhomme Velocity RG 173 · Richmond, VAthe improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.NTSB NYC00LA059Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Blacksburg, VAThe pilot in command's failure to recover from a bounced landing.NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB IAD00FA003Accident · 1 fatalField investigationFinal reportCoughlin LONG-EZ · Remington, VAthe pilot's failure to maintain adequate altitude/clearance from the trees while maneuvering at low altitude.NTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC99LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Manassas, VAThe pilot's failure to recover from a sideslip maneuver, and flare the airplane before touchdown.NTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB NYC99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Isle Of Wight, VAThe improper visual inspection of overhauled engine components by maintenance personnel.NTSB NYC99LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, VAThe pilot's failure to adequately calculate required fuel for the flight, which resulted in a total loss of engine power.NTSB NYC99LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · New Castle, VAThe pilot tookoff with the fuel tank selector in an improper position (OFF), resulting in fuel starvation.NTSB NYC99FA163Accident · 1 fatalField investigationFinal reportPiper PA-31T · Deerfield, VALoss of control of the airplane due to pilot incapacitation following a heart attack.NTSB NYC99LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Forest, VAThe pilot's misjudgment of distance/speed, also causal was his failure to execute a go-around. Contributing factors were the night conditions and the tailwind.NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.NTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB IAD99LA044Accident · Serious injuriesLimited investigationFinal reportMayers SEA REY · Ashland, VAwas a loss of engine power for undetermined reasons.NTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB IAD99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Manassas, VAThe student pilot's failure to maintain the proper rate of descend on final approach followed by an improper flare which resulted on a hard landing.NTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…NTSB NYC99FA074Accident · 2 fatalField investigationFinal reportCessna 340A · Chesapeake, VAThe pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.NTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.NTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.NTSB NYC99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Richmond, VAThe pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.NTSB NYC99LA063Accident · 1 fatalLimited investigationFinal reportPiper PA 32R-301 · Dulles, VAThe FBO employee's diverted attention, resulting in an inadvertent encounter with a rotating propeller.NTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.NTSB NYC99LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lynchburg, VAFuel exhaustion for undetermined reasons.NTSB IAD99LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Fairfield, VAThe owner's failure to comply with the Airworthiness Directive and the subsequent fuel system filter blockage by ice leading to fuel starvation and power loss of the right engine. Additionally, the pilot's improper selection of the left auxiliary fuel tank…