NTSB investigations, 2012
3 cases where NTSB found Braking capability.
Cases per year
| 2009 | 5 |
|---|---|
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 7 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01061050'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01061050')) 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 CEN13LA023Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Sturtevant, WIThe pilot's decision to continue the landing after touching down long and on a wet runway that reduced the airplane’s braking capability, which resulted in an overrun.NTSB CEN12CA454Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jenks, OKThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway overrun and impact with obstructions.NTSB ERA12CA278Accident · Minor injuriesData collectionFinal reportPiper PA-18A · West Palm Beach, FLThe inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.