NTSB investigations, 2015, TX
4 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 1 |
| 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\") = 2015
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\" = '097' 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") = 2015 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" = '097' 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 CEN16LA015Accident · No injuriesLimited investigationFinal reportBobby Martin Autogyro MTO Sport · Wallisville, TXFracture of the pusher propeller blade due to impact damage from an unknown object while in flight, which resulted in a severe vibration and a loss of thrust.NTSB CEN15LA350Accident · Minor injuriesLimited investigationFinal reportJal R Dennis Trixy Princess · Midland, TXThe pilot's inadequate preflight planning during which he failed to account for the high-density altitude conditions and high gross weight, which degraded the gyroplane's climb performance and resulted in a hard landing.NTSB GAA15LA191Accident · Minor injuriesLimited investigationFinal reportCelier Xenon RST · Livingston, TXThe pilot’s loss of directional control after aborting the takeoff due to a grinding noise coming from the main rotor area, which resulted in a runway excursion.NTSB CEN15LA179Accident · Serious injuriesLimited investigationFinal reportPicard Roy J RV 4 · Marathon, TXA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of any mechanical anomalies that would have precluded normal operation.