NTSB investigations, 2013
10 cases where the sequence of events included Tailstrike.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 10 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 9 |
| 2017 | 9 |
| 2018 | 9 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 11 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 7 |
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\") = 2013
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '091' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2013 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '091' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA13LA308Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Florence, ALThe student pilot’s failure to maintain control of the helicopter while landing, which resulted in a tail rotor ground strike and collision with terrain.NTSB DCA13CA088Accident · No injuriesData collectionFinal reportGeneral Atomics MQ-9 · Cocoa Beach, FLan improper flare leading to a nose-wheel first touchdown, which resulted in a pilot induced oscillation (PIO). The PIO caused the UAS to pitch up abruptly on the third nose gear contact with the runway, resulting in the separation of the nose wheel assembly…NTSB WPR13CA206Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe failure of the flight instructor and the pilot receiving instruction to recognize before entering the flare that the wind had shifted to a tailwind and terminate the practice autorotation.NTSB DCA13WA092Accident · No injuriesForeign investigationBoeing 767 · Madrid, SpainOn April 16,2013, about 1235 UTC, an Aero Mexico B767-200, registration XA-TOJ, operated as flight 071 from Madrid-Barajas International Airport, Madrid, Spain, to Benito Juarez International Airport, Mexico City, Mexico, experienced a tail strike while…NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.NTSB DCA13FA071Accident · No injuriesField investigationFinal reportAirbus 321 · Las Vegas, NVthe captain's improper recovery from a bounced landing which resulted in a tailstrike.NTSB DCA13CA065Accident · No injuriesData collectionFinal reportBoeing 757-232 · Atlanta, GAthe pilot's failure to maintain correct airspeed and pitch attitude at touchdown.NTSB DCA13WA064Incident · No injuriesForeign investigationBoeing 737 · Keflavik, IcelandThe AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 that occurred on March 06, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB Iceland's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA13WA062Incident · No injuriesForeign investigationAirbus · Chicago, ILThe BFU-DE of Germany has notified the NTSB of an accident involving an Airbus 330 that occurred on March 06, 2013 in Chicago, Illinois. The NTSB delegated the investigation to Germany and has appointed a U.S. Accredited Representative to assist the BFU-DE's…NTSB DCA13CA043Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD11 · Denver, COthe flight crews failure to perform a takeoff performance data briefing following the final entries into the Flight Management System, which would have alerted them to the incorrect weight entry and resulting incorrect landing speeds. Contributing to the…