NTSB investigations, 1990, 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\") = 1990
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") = 1990 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 BFO91LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Boston, VAThe student pilot's delay in taking appropriate action while encountering adverse weather conditions. Factors which contributed to the accident were: the weather conditions that were worse than forecast, and the unsuitable terrain.NTSB BFO91LA020Accident · No injuriesLimited investigationFinal reportCessna 402 · Richland, VAFailure of the left main landing gear scissor assembly.NTSB BFO91LA016Accident · 1 fatalLimited investigationFinal reportCessna 172P · Axton, VAThe pilot's failure to maintain adequate clearance with an obstacle. Contributing was an unmarked powerline and the pilot's lack of familiarity with the geographical area.NTSB BFO91LA018Accident · No injuriesLimited investigationFinal reportBell 47J2A · Matoaca, VAThe failure of four propeller retention and the pilot's misjudgement of the forced landing approach.NTSB BFO91LA012Accident · Minor injuriesLimited investigationFinal reportTaylor Rotorway Executive · Keysville, VAA jammed engine throttle cable. Factors related to the accident are inadequate maintenance inspection and low rotor RPM.NTSB BFO91DID01Accident · 2 fatalFinal reportAeronca Champion 7BCM · Suffolk, VAA loss of engine power due to low cylinder compression. The low compression was a result of exhaust valve leakage and inadequate maintenance and inspection. In addition, the pilot failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB BFO91LA010Accident · No injuriesLimited investigationFinal reportAeronca L3B · Farmville, VAThe failure of the pilot to properly secure the aircraft while starting the engine by hand proping.NTSB BFO91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Elkton, VAThe pilot's failure to use carburetor heat which resulted in a reduction in engine power. A factor was the rough terrain.NTSB BFO91T#001Incident · No injuriesFinal reportLockheed 188C · Wallops Island, VANTSB BFO91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Amelia, VAThe pilot's improper in-flight planning/decision and his intere uphill runway and tailwind.NTSB BFO91LA003Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Culpeper, VAIntergranular cracking (fatigue) failure of the exhaust clamp, which resulted in a disconnected exhaust manifold (tailpipe), and subsequent fire in the engine compartment.NTSB BFO90LA078Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Bealeton, VAThe pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…NTSB BFO90DID02Accident · 2 fatalFinal reportCessna 182R · Evington, VAThe pilot's failure to maintain control of the aircraft because of spatial disorientation. A contributing cause is failure of the vacuum system.NTSB BFO90FA073Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Richland, VAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain proper clearance from high terrain. Darkness and the adverse weather conditions were related factors.NTSB BFO90DID01Accident · 2 fatalFinal reportCessna 172RG · Onancock, VAThe inflight loss of control because the pilot experienced spatial disorientation. Other factors related to the accident are VFR flight into IMC, night conditions.NTSB BFO90FA070Accident · 2 fatalField investigationFinal reportCessna 150G · Ridgeway, VAFailure of the pilot to maintain adequate airspeed, which resulted in a stall and inflight collision with the terrain.NTSB BFO90LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Tangier Island, VAThe pilot's improper recovery from a bounced landing and premature raising of the flaps.NTSB BFO90DOA01Accident · Minor injuriesFinal reportBell TH-1L · Galax, VAThe lost of engine power because of a compressor stall.NTSB BFO90FA063Accident · 1 fatalField investigationFinal reportBeech P35 · Disputanta, VAThe pilot's indequate inflight decision which resulted in flight into adverse weather condition. Contributing to the accident was thunderstorms and the pilot exceeding the design limits of the airplane.NTSB BFO90LA060Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Newport News, VAFuel exhaustion caused by pilot misjudging the fuel supply. Contributing to the accident was inaccurate fuel gages.NTSB BFO90LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe failure of both pilots (CFI and student pilot) to maintain adequate control of the aircraft during the landing flare and touchdown phase of flight. The student pilot's inexperience was a factor, as was the cfi's inadequate supervision during the dual…NTSB BFO90LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-126E · Warrenton, VAThe pilot misjudged his landing approach.NTSB BFO90LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesterfield, VAThe student pilot's improper compensation for wind conditions and failure to maintain runway alignment.NTSB BFO90FA045Accident · 6 fatalField investigationFinal reportCessna 210N · Shady Grove Cor, VAVFR flight by the non-instument rated pilot into instrument meteorological conditions (IMC), his loss of aircraft control, due to spatial disorientation, and his exceeding the design stress limits of the aircraft, while recovering from an uncontrolled…NTSB BFO90LA041Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Brookneal, VAThe pilot's improper preflight and improper in-flight planning/decision. Pilot fatigue was a related factor.NTSB BFO90LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lovingston, VAPilot failure to climb out of ground effect because of inadequate airspeed. Factor was unfavorable wind at takeoff.NTSB BFO90LA033Accident · No injuriesLimited investigationFinal reportCessna 170B · Winchester, VAThe pilot's failure to assure that the airplane would clear the fence after takeoff.NTSB BFO90FA032Accident · 2 fatalField investigationFinal reportCessna 172N · Bedford, VAThe pilot's decision to fly into known adverse weather conditions and his failure to maintain clearance above the terrain. Contributing to the accident was the pilot's self induced pressure, low ceilings, mountainous terrain and rain.NTSB BFO90LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Dungannon, VAThe pilot's improper planning/decision, which resulted in fuel starvation and loss of engine power, and failure of the pilot to maintain directional control of the aircraft during the emergency landing. Factors related to the accident were: the adverse…NTSB BFO90LA029Accident · No injuriesLimited investigationFinal reportCessna 150M · Leesburg, VAThe pilot's failure to assure an adequate supply of fuel was onboard to complete the flight.NTSB BFO90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Tappahannock, VAFailure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.NTSB BFO90FA024Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Norton, VAPilot's failure to maintain adequate clearance over mountainous terrain when continuing to fly into deteriorating weather conditions. Contributing to the accident was the pilot's lack of instrument experience, low ceilings, fog, and mountainous terrain.NTSB BFO90LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Staunton, VAThe pilot's failure to maintain directional control of the airplane during a crosswind landing.NTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.