NTSB investigations, 2008, TX
6 cases where the sequence of events included Low altitude operation/event.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 10 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 3 |
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\") = 2008
AND c.\"eventStateOrRegion\" = 'TX' 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\" = '220' 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") = 2008 AND c."eventStateOrRegion" = 'TX' 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" = '220' 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 CEN09CA037Accident · Serious injuriesData collectionFinal reportCessna R172E · Palo Pinto, TXThe pilot's intentional low-level flight and failure to maintain a visual lookout.NTSB CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.NTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.NTSB CEN09CA108Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Sunrise Beach, TXThe pilot's failure to maintain altitude/clearance from a powerline while maneuvering. A contributing factor was the powerline.NTSB DEN08LA077Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Angleton, TXThe pilot's inadequate visual lookout and his failure to maintain clearance from the tranmission lines. A factor in this accident was the unmarked transmission wires.NTSB DFW08FA078Accident · 1 fatalField investigationFinal reportCessna 172M · Gun Barrel City, TXThe pilot's failure to avoid the transmission line. A contributing factor was the pilot's decision to perform a low-level maneuver.