NTSB investigations, 2009, WV

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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

19632026
NTSB investigations, 2009, WV per year, 1963–2026: 869 cases
19631
196420
196528
196626
196721
196831
196935
197032
197116
197228
197323
197431
197525
197618
197721
197819
197928
198021
198121
198216
198318
198417
198521
19867
19879
198822
198913
199016
199113
199216
199311
19949
19955
199613
199715
19988
19998
20007
200115
20027
200311
200412
20057
20067
20076
20083
200911
201010
20119
20127
20135
20146
20153
20168
20176
20183
20194
20201
20214
20225
20236
202410
20254
202610

Latest 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\") = 2009
    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.

NTSB ERA10FA088Accident · 1 fatalField investigationFinal reportPiper PA-30 · Raneille, WVThe pilot's improper decision to attempt visual flight into deteriorating night weather conditions, and his subsequent controlled flight into terrain.Nov 23, 2009 · N8923Y · Substantial damageNTSB ERA09CA534Accident · No injuriesData collectionFinal reportAeromot AMT200 · Wheeling, WVThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the pilot's failure to properly secure the canopy latch which resulted in an in-flight canopy opening.Sep 20, 2009 · N46068 · Substantial damageNTSB ERA09LA530Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Fairmont, WVThe pilot's delay in aborting the takeoff, resulting in an overun. Contributing to the accident was the overweight condition of the airplane.Sep 19, 2009 · N57S · Substantial damageNTSB ERA09FA429Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Ravenswood, WVThe pilot's improper modification of the certified, on-board oxygen system, which resulted in incapacitation due to hypoxia, and the airplane's subsequent uncontrolled descent into terrain.Jul 31, 2009 · N581DS · DestroyedNTSB DCA09FA065Accident · No injuriesField investigationFinal reportBoeing 737 · Charleston, WVFuselage skin failure due to preexisting fatigue at a chemically milled step.Jul 13, 2009 · N387SW · Substantial damageNTSB ERA09CA390Accident · No injuriesData collectionFinal reportPiper J3C · South Charleston, WVThe pilot's failure to maintain control during the attempted go-around.Jul 8, 2009 · N88025 · Substantial damageNTSB ERA09FA377Accident · 2 fatalField investigationFinal reportCessna 400 · Huntington, WVThe pilot's failure to maintain control of the airplane due to spatial disorientation.Jul 5, 2009 · N207JB · DestroyedNTSB ERA09CA367Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Morgantown, WVThe pilot’s failure to maintain control of the helicopter during the practice hovering autorotation. Contributing to the accident was the pilot’s lack of experience in night vision goggle helicopter operations.Jun 24, 2009 · N106HN · Substantial damageNTSB ERA09LA348Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Fairmont, WVThe pilot’s failure to maintain control of the airplane during takeoff. Contributing to the accident was the pilot's inadequate use of the checklist.Jun 14, 2009 · N7544E · Substantial damageNTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.May 31, 2009 · N4824A · Substantial damageNTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…Jan 30, 2009 · N8047C · Destroyed