NTSB investigations, 2011, TX
7 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 10 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 7 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 5 |
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\") = 2011
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\" = '090' 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") = 2011 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" = '090' 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 CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.NTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.NTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.NTSB CEN11CA257Accident · No injuriesData collectionFinal reportCessna 172K · San Antonio, TXThe student pilot's inadequate compensation for wind while landing in gusty wind conditions.NTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.NTSB CEN11CA215Accident · No injuriesData collectionFinal reportArion Lightning · Brownsville, TXThe pilot’s failure to maintain adequate airspeed on final approach, resulting in a loss of control and a hard landing.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.