NTSB investigations, 1992, 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\") = 1992
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") = 1992 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 NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.NTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.NTSB BFO93LA015Accident · No injuriesLimited investigationFinal reportMooney M20K · Orange, VAWater contamination in the fuel, and inadequate preflight inspection.NTSB BFO93LA009Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Dublin, VAImproper adjustment of the fuel pressure regulator which produced an inadequate fuel flow and subsequent fuel starvation. Factors related to the accident were: the rough terrain and trees in the emergency landing area.NTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.NTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayNTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB BFO92FA153Accident · 1 fatalField investigationFinal reportCessna 152 · Gloucester, VAThe pilot's failure to recover from an intentional stall, which resluted in inflight collision with the ground. Pilot inexperience is a contributing factor.NTSB BFO92FA135Accident · 2 fatalField investigationFinal reportBeech G35 · Hillsville, VALoss of engine power for an undetermined reason and failure of the pilot to maintain airspeed, which resulted in a stall/spin.NTSB NYC92FA153Accident · 2 fatalField investigationFinal reportDanny M Damron Long EZ · Front Royal, VAThe pilot's self induced pressure to complete the flight which resulted in intentional flight into IMC conditions, and a collision with trees. Factors related to the accident were the pilot's over confidence in his abilities, and the low clouds and fog which…NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.NTSB BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.NTSB BFO92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Moneta, VAFailure of the student pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's improper recovery from a bounced landing and proximity of the tree.NTSB BFO92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Greenville, VAThe fatigue failure of the fuel injector fuel line resulting in engine failure. Contributing to the accident was the unsuitable terrain in which the forced landing was made.NTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.NTSB NYC92LA126Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Waynesboro, VAThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall while on approach. Factors related to the accident were: the pilot's lack of experience, an improperly planned approach, and the gusty winds.NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.NTSB BFO92FA051Accident · 2 fatalField investigationFinal reportSam R. Crowell SH-2R · Somerville, VAThe pilot's inadequate handling of aircraft during aerobatic maneuver which resulted in a loss of control. Contributing factors were lack of experience in operation.NTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.NTSB BFO92LA053Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Amelia, VAThe pilot's misjudgement of distance and altitude that resulted in an landing overrun and collision with an embankment. Contributing was failure to initiate a go around and inadequate supervision.NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.NTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.NTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.NTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.NTSB BFO92FA025Accident · 1 fatalField investigationFinal reportBeech V35B · Manassas, VAThe pilot's failure to remove ice from the wings during the preflight inspection which resulted in a stall during takeoff due to ice on the wings.