NTSB investigations, 2012
6 cases where NTSB found Surface speed/braking.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 13 |
| 2010 | 5 |
| 2011 | 9 |
| 2012 | 6 |
| 2013 | 11 |
| 2014 | 23 |
| 2015 | 21 |
| 2016 | 27 |
| 2017 | 14 |
| 2018 | 12 |
| 2019 | 14 |
| 2020 | 12 |
| 2021 | 14 |
| 2022 | 12 |
| 2023 | 14 |
| 2024 | 7 |
| 2025 | 10 |
| 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\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062045'))
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", '01062045')) 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 ERA12FA567Accident · Minor injuriesField investigationFinal reportBeech 400 · Macon, GAThe pilot’s failure to maintain proper airspeed, which resulted in the airplane touching down too fast on the wet runway with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the landing overrun were the flight crewmembers’…NTSB CEN12LA323Accident · No injuriesLimited investigationFinal reportThrush S2RHG-T65 · Alicia, ARThe pilot of the Thrush did not execute a go-around prior to landing, which resulted in excessive ground speed after touchdown, and his subsequent loss of directional control, which resulted in a collision with the Air Tractor.NTSB WPR12CA210Accident · No injuriesData collectionFinal reportPiper PA-28RT-201T · Mariposa, CAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB CEN12CA225Accident · No injuriesData collectionFinal reportBeech V35B · Malvern, ARThe pilot did not fly a stabilized approach and elected not to perform a go-around, which resulted in a runway excursion.NTSB ERA12CA173Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Winter Haven, FLThe flight instructor’s delayed remedial action to prevent the airplane from hitting the hangar door. Contributing to the accident was the student pilot's misuse of the airplane's throttle, and his incorrect use of the wheel brakes.