NTSB investigations, VA
6 cases where the defining event was VFR encounter with IMC.
Cases per year
| 2014 | 1 |
|---|---|
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'VA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '401')
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 c."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '401') 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 CEN25FA124Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Danville, VAOn March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.NTSB ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.NTSB ERA18TA142Accident · Minor injuriesFinal reportBarry Maggio Apollo AG-1 · Smith Beach, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning, which resulted in an off-airport precautionary landing to avoid weather and a subsequent collision with power lines.NTSB ERA17CA008Accident · Serious injuriesData collectionFinal reportAlgimantas Jonusas RV-10 · Ashwood, VAThe noninstrument-rated pilot's inadequate preflight and in-flight weather planning and continued flight into instrument meteorological conditions, which resulted in impact with trees and terrain.NTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…