NTSB investigations, 2010, VA
4 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
Where
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\") = 2010
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.
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") = 2010 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
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 ERA10CA477Accident · Minor injuriesData collectionFinal reportBeam-Walter RS-15 · Windsor, VAThe pilot's inadequate installation and preflight inspection of the right rudervator assembly, which resulted in a loss control during takeoff.NTSB ERA10FA435Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Amherst, VAThe pilot's loss of aircraft control for an undetermined reason.NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.