NTSB investigations, AR
5 cases where NTSB found Tailwind.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 1 |
| 2014 | 1 |
| 2016 | 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\" = 'AR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03034015'))
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" = 'AR' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03034015')) 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 GAA17CA020Accident · No injuriesData collectionFinal reportRemos Remos GX · Lowell, ARThe pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB CEN10CA265Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Roe, ARThe pilot's decision to take off with a tailwind, resulting in a runway overrun.NTSB CEN09CA102Accident · Serious injuriesData collectionFinal reportBeech 95-B55 · Batesville, ARThe pilot's improper decision to land with a tailwind which resulted in the overrun landing. Factors contributing to the accident include the culvert and the tailwind.NTSB DFW08CA199Accident · No injuriesData collectionFinal reportGrumman G-164A · Newport, ARThe pilot's failure to maintain aircraft control. Contributing factors were the high temperature and tailwind.