NTSB investigations, 2012
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\") = 2012
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") = 2012 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 CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.NTSB CEN12LA678Accident · Minor injuriesLimited investigationFinal reportInfinity 2003 · Merrill, MIThe pilot's improper decision to attempt a takeoff from midfield, resulting in a collision with trees at the departure end of the field.NTSB ERA12LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe student pilot’s decision to depart from an intersection with insufficient runway remaining for takeoff, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB CEN12CA264Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Cheyenne Wells, COThe pilot’s inadequate compensation for the wind conditions during takeoff.