NTSB investigations, 2024, WV
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 | 20 |
| 1965 | 28 |
| 1966 | 26 |
| 1967 | 21 |
| 1968 | 31 |
| 1969 | 35 |
| 1970 | 32 |
| 1971 | 16 |
| 1972 | 28 |
| 1973 | 23 |
| 1974 | 31 |
| 1975 | 25 |
| 1976 | 18 |
| 1977 | 21 |
| 1978 | 19 |
| 1979 | 28 |
| 1980 | 21 |
| 1981 | 21 |
| 1982 | 16 |
| 1983 | 18 |
| 1984 | 17 |
| 1985 | 21 |
| 1986 | 7 |
| 1987 | 9 |
| 1988 | 22 |
| 1989 | 13 |
| 1990 | 16 |
| 1991 | 13 |
| 1992 | 16 |
| 1993 | 11 |
| 1994 | 9 |
| 1995 | 5 |
| 1996 | 13 |
| 1997 | 15 |
| 1998 | 8 |
| 1999 | 8 |
| 2000 | 7 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 7 |
| 2006 | 7 |
| 2007 | 6 |
| 2008 | 3 |
| 2009 | 11 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 10 |
| 2025 | 4 |
| 2026 | 10 |
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\") = 2024
AND c.\"eventStateOrRegion\" = 'WV' 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") = 2024 AND c."eventStateOrRegion" = 'WV' 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 ERA25LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Huntington, WVThe pilot’s failure to utilize carburetor heat while operating the engine at low power and in conditions conducive to the formation of carburetor ice, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA25LA025Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairmont, WVThe student pilot’s improper flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB ERA25LA032Accident · Serious injuriesClass 4 · LimitedFinal reportAero SP Z O O AT-4 LSA · South Charleston, WVThe pedestrian’s inadequate visual lookout while walking next to an active runway, which resulted in the airplane striking him during taxi.NTSB ERA25LA014Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · South Charleston, WVThe pilot’s decision to continue landing after encountering a strong tailwind, which resulted in a loss of control and subsequent runway excursion.NTSB ERA25LA013Accident · No injuriesClass 4 · LimitedFinal reportMaule M8 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing.NTSB ERA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing roll, resulting in the on-ground collision with trees.NTSB ERA24LA366Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20K · Fairmont, WVThe pilot’s failure to attain the proper touchdown point, and his delay in aborting the landing.NTSB ERA24LA356Accident · No injuriesClass 4 · LimitedFinal reportCanadian Light Acft Sales &Svc Bushcaddy Explorer R80 · Charleston, WVThe pilot’s failure to maintain directional control of the airplane while landing in a crosswind, which resulted in a ground loop and subsequent landing gear collapse.NTSB ERA24LA148Accident · Serious injuriesClass 3 · LimitedFinal reportHughes 369D · Belleville, WVThe ingestion of foreign object debris into the engine, which resulted in a sudden loss of engine power and a subsequent collision with trees and terrain during the forced landing.NTSB ERA24LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Logan, WVThe pilot’s delayed decision to perform a go-around while attempting to land on a wet runway with a tailwind, which resulted in a runway overrun and collision with trees.