NTSB investigations, VA
5 cases where the sequence of events included Loss of visual reference.
Cases per year
| 2015 | 1 |
|---|---|
| 2018 | 4 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '402' 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '402' 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
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 ERA19FA010Accident · 1 fatalClass 2 · FieldFinal reportVans RV8 · Culpeper, VAThe pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.NTSB ERA19FA003Accident · 1 fatalField investigationFinal reportPiper J3C · Fancy Gap, VAThe non-instrument-rated pilot's improper decision to undertake a flight into forecast instrument meteorological conditions (IMC) and his subsequent decision to continue the flight after encountering IMC, which resulted in controlled flight into terrain.…NTSB ERA18FA127Accident · 1 fatalField investigationFinal reportCessna 525 · Crozet, VAThe pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting…NTSB GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…NTSB GAA16CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5 · West Point, VAThe pilot's decision to fly a traffic pattern following an aborted instrument landing in night instrument metrological conditions, which resulted in a loss of visual reference to the runway, an inadvertent aerodynamic stall, and a collision with terrain.