NTSB investigations, 2011, TX
6 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 7 |
| 2010 | 7 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 5 |
| 2015 | 9 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 8 |
| 2020 | 8 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 9 |
| 2025 | 2 |
| 2026 | 3 |
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\" = '241' 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" = '241' 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 CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.NTSB CEN11LA672Accident · Serious injuriesLimited investigationFinal reportPorbeck John M Slipstream Genesis · Bryan, TXThe pilot’s failure to maintain adequate airspeed and attitude during a turn toward downwind, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's limited experience in the experimental airplane.NTSB CEN11CA342Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Spicewood, TXThe pilot's failure to maintain adequate airspeed during takeoff which resulted in an aerodynamic stall.NTSB CEN11CA287Accident · Minor injuriesData collectionFinal reportAir Tractor AT503 · Telephone, TXThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.