NTSB investigations, 2015, VA

6 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2015, VA per year, 2008–2026: 69 cases
20082
20095
20105
20116
20125
20135
20144
20156
20162
20174
20187
20191
20205
20211
20222
20244
20254
20261

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\") = 2015
    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\" = '440' 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 ERA16LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bluemont, VAA total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.Oct 23, 2015 · N43249 · Substantial damageNTSB ERA16LA016Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado · Mitchells, VAA total loss of engine power due to fatigue cracking and separation of the No. 3 cylinder exhaust valve stem.Oct 15, 2015 · N4070F · Substantial damageNTSB ERA15LA375Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Blacksburg, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.Sep 24, 2015 · N710JC · Substantial damageNTSB ERA15LA300Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hot Springs, VAA partial loss of engine power during initial climb due to the failure of a magneto. Contributing to the accident was the pilot's decision to operate the airplane without a current annual inspection.Aug 8, 2015 · N7506S · Substantial damageNTSB ERA15CA120Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Brookneal, VAThe flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Feb 4, 2015 · N619GB · Substantial damageNTSB ERA15LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Norfolk, VAThe engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.Jan 6, 2015 · N2102P · Substantial damage