NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 NYC98LA056Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Ferncliff, VAthe improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…NTSB NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.NTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.NTSB NYC98LA022Accident · Serious injuriesLimited investigationFinal reportBeech B200 · Norfolk, VAThe passenger tripped for an undetermined reason.NTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..NTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.NTSB IAD98LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Oceana, VAImproper flare by the pilot, which resulted in a hard landing. A related factor was the diverted attention.NTSB NYC98LA007Accident · No injuriesLimited investigationFinal reportCessna 120 · Prince George, VAThe pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.NTSB NYC97LA192Accident · No injuriesLimited investigationFinal reportCessna 150G · Forest, VAthe pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.NTSB NYC97LA182Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Crimora, VAThe pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..NTSB NYC97LA175Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fredericksburg, VAA loss of engine power for undetermined reasons.NTSB NYC97LA158Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Quinton, VAThe pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.NTSB IAD97LA097Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Culpeper, VAThe pilot's inadequate preflight planning which fail to provide an adequate fuel supplyNTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.NTSB NYC97LA117Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harrisonburg, VAthe pilot's failure to obtain the proper touchdown point. A contributing factor was the transmission line.NTSB NYC97LA112Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-E · Charlottesville, VAThe left main landing gear collapsed due to corrosion.NTSB NYC97LA105Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Fredericksburg, VAThe pilot's delayed go-around which resulted in the inflight collision with trees off the departure end of the runway.NTSB IAD97GA081Accident · Minor injuriesFinal reportPiper PA-18-150 · Harrisonburg, VAThe pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.NTSB NYC97FA103Accident · 3 fatalField investigationFinal reportCessna 210M · Elliston, VAfailure of the PIC to maintain control of the airplane, due to spatial disorientation.NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.NTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.NTSB NYC97LA074Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Waynesboro, VAThe pilot's failure to maintain directional control during landing.NTSB IAD97LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Warrenton, VAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.NTSB IAD97FA039Accident · 4 fatalField investigationFinal reportAerostar 601P · Chesapeake, VAfailure of the pilot to maintain proper altitude/clearance above the ground after takeoff. A related factor was the pilot's self-induced pressure to depart before the arrival of bad weather.