NTSB investigations, 2010
7 cases where the sequence of events included Airport occurrence.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 4 |
| 2010 | 7 |
| 2011 | 3 |
| 2012 | 4 |
| 2014 | 1 |
| 2015 | 6 |
| 2016 | 7 |
| 2017 | 1 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '070' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '070' 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 WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.NTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.NTSB WPR10CA327Accident · No injuriesData collectionFinal reportCessna 172 · Cascade, IDThe pilot’s encounter with an unknown hole in the runway during the landing roll.NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB CEN10CA195Accident · No injuriesData collectionFinal reportCessna 175 · Eveleth, MNThe pilot's selection of unsuitable terrain for landing.NTSB OPS10IA015Incident · No injuriesIncident investigationFinal reportCessna 208B · Phoenix, AZThe Cessna 208 pilot’s failure to identify the correct landing runway.NTSB ERA10TA142Accident · No injuriesFinal reportEurocopter AS 365 N2 Dauphin · Cheverly, MDIncomplete clearing of snow from the helipad and vicinity. Contributing to the accident was the lack of a NOTAM regarding the presence of snow banks and the pilot's failure to ensure that the helicopter was clear of a snow bank prior to departure.