NTSB investigations, 2011
6 cases where NTSB found Takeoff distance.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 2 |
| 2010 | 8 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 2 |
| 2015 | 3 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 7 |
| 2024 | 1 |
| 2025 | 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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01061025'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01061025')) 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 ANC11CA106Accident · No injuriesData collectionFinal reportPiper PA-12 · Beluga, AKThe pilot's decision to take off uphill into rising terrain.NTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.NTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.NTSB ANC11CA083Accident · No injuriesData collectionFinal reportCessna 180A · Igiugig, AKThe pilot's decision to take off in a variable wind, resulting in a shallow climb and collision with terrain.NTSB ERA11LA454Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Hodgenville, KYThe pilot's inadequate takeoff performance planning, which resulted in collision with an obstacle during takeoff from a turf runway that was not long enough for the given conditions.NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.