NTSB investigations, 2012
4 cases where NTSB found Towing and taxiing.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\", '010109'))
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", '010109')) 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 ERA13CA100Accident · No injuriesData collectionFinal reportRaytheon A36 · Rutland, VTThe pilot's failure to maintain control of the airplane while maneuvering on a snow-packed surface after landing, which resulted in a collision with a fuel truck.NTSB CEN12LA605Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G 103 Twin II · El Paso, TXThe pilot‘s failure to maintain glider control while attempting to take off using a ground winch, which resulted in an inadvertent stall low to the ground. Contributing to the accident was the ground winch, which was unable to produce enough speed for a…NTSB ERA12CA382Accident · No injuriesData collectionFinal reportBeech B90 · Savannah, GAThe pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.NTSB CEN12CA226Accident · No injuriesData collectionFinal reportRuiz E RAF 2000 · Anahuac, TXThe student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.