NTSB investigations, 2011, VA
6 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 7 |
| 2019 | 1 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 2011
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.
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") = 2011 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
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 ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.NTSB ERA12CA059Accident · Minor injuriesData collectionFinal reportBeech F33A · Chesterfield, VAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.NTSB ERA12LA033Accident · No injuriesLimited investigationFinal reportCessna R172K · Williamsburg, VAA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA11CA465Accident · No injuriesData collectionFinal reportLet L 33 Solo · Wakefield, VAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing.NTSB ERA11CA423Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Quinton, VAThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.