NTSB investigations, 2015
5 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
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\") = 2015
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") = 2015 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 GAA16CA096Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe student pilot's failure to maintain obstacle clearance while taxiing on the ramp, resulting in a collision with an object.NTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…NTSB GAA16CA012Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Kanab, UTThe pilot's failure to monitor the airplane's movement on the ground while programming the GPS, which resulted in a collision with a pole.NTSB DCA15CA176Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Oakland, CAinadvertent jet blast, resulting in debris striking ground operations personnel.NTSB ERA15IA206Incident · No injuriesIncident investigationFinal reportCessna 525B · Teterboro, NJThe overstress fracture of the nose landing gear actuator (NLG) attachment lug during tow operations, which resulted in the collapse of the NLG.