NTSB investigations, TN
5 cases where the defining event was Low altitude operation/event.
Cases per year
| 2009 | 2 |
|---|---|
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 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\" = 'TN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '220')
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" = 'TN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '220') 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 GAA19CA457Accident · Minor injuriesData collectionFinal reportBell 206 · Dukedom, TNThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB ERA17FA144Accident · 1 fatalField investigationFinal reportBuckeye Dream Machine · Knoxville, TNThe pilot's decision to maneuver the aircraft at low altitude, towards rising terrain, which resulted in an inflight collision with trees.NTSB ERA17CA012Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Knoxville, TNThe pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.NTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.NTSB ERA09CA292Accident · No injuriesData collectionFinal reportCessna 152 · Memphis, TNThe pilots' decision to fly at a low altitude and their inadequate visual lookout while maneuvering.