NTSB investigations, 2020, TX
4 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 8 |
| 2010 | 7 |
| 2011 | 6 |
| 2012 | 12 |
| 2013 | 7 |
| 2014 | 14 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 6 |
| 2018 | 9 |
| 2019 | 12 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 9 |
| 2024 | 6 |
| 2025 | 7 |
| 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\") = 2020
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\" = '096' 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") = 2020 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" = '096' 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 CEN21LA078Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV4 · Sadler, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA079Accident · No injuriesClass 4 · LimitedFinal reportHutson Star-Lite · San Antonio, TXThe pilot’s decision to land on a soft terrain which resulted in the failure of the nose landing gear.NTSB CEN20CA393Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 172 · Houston, TXThe student pilot’s failure to maintain directional control upon landing.NTSB CEN20CA388Accident · No injuriesClass 4 · Data collectionFinal reportMaule MX7 · Brazoria, TXThe pilot’s failure to maintain airplane control during a go-around from unsuitable terrain.