NTSB investigations, 2014, VA

6 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2014, VA per year, 2008–2026: 68 cases
20088
20092
20104
20113
20123
20132
20146
20155
20167
20178
20186
20191
20203
20212
20223
20231
20242
20252

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\") = 2014
    AND c.\"eventStateOrRegion\" = 'VA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA15CA059Accident · No injuriesData collectionFinal reportHiller OH 23B · Leesburg, VAA loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.Nov 24, 2014 · N6057 · Substantial damageNTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.Oct 4, 2014 · N3619T · Substantial damageNTSB ERA14CA367Accident · No injuriesData collectionFinal reportCessna 162 · Winchester, VAThe student pilot's failure to maintain aircraft control during an aborted landing.Jul 30, 2014 · N6004U · Substantial damageNTSB ERA14LA302Accident · Minor injuriesLimited investigationFinal reportBailey Robert Moyes Dragonfly · Melfa, VAThe pilot’s failure to maintain roll control during the initial takeoff and his decision to take off with only partial power applied.Jun 16, 2014 · N286A · Substantial damageNTSB ERA14CA320Accident · No injuriesData collectionFinal reportFairchild M 62C(PT-23A) · Petersburg, VAThe flight instructor's failure to maintain control of the airplane during the landing attempt. Contributing to the accident was the changing wind conditions.May 22, 2014 · N60418 · Substantial damageNTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.Apr 8, 2014 · N4862U · Substantial damage