NTSB investigations, 2011

7 cases where the sequence of events included Tailstrike.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations, 2011 per year, 2008–2026: 124 cases
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 map

Latest cases

Query with SQL

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 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

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 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") = 2011
  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 ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.Sep 3, 2011 · N7197W · Substantial damage NTSB ERA11CA433Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Humacao, PRThe pilot's failure to maintain clearance from a building during landing.Jul 30, 2011 · N413LP · Substantial damage NTSB DCA11WA086Incident · No injuriesForeign investigationMcdonnell Douglas MD11 - F · Mumbai, IndiaThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an accident involving a Cargo MD-11F that occurred on June 11, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the…Jun 11, 2011 · D-ALCS · Minor damage NTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.Apr 10, 2011 · N6338F · Substantial damage NTSB DCA11WA041Incident · No injuriesForeign investigationBoeing B737 · Bucharest, RomaniaOn April 4, 2011, a Boeing 737-300, Romanian registration YR-BGD, operated by TAROM Airlines experienced a tailstrike on takeoff from the Henri Coanda Airport, Bucharest, Romania (LROP). The flight crew reported a loss of lift after rotation, and was…Apr 4, 2011 · YR-BGD · Substantial damage NTSB DCA11WA016Incident · No injuriesForeign investigationAirbus A300 · East Midlands, United KingdomOn January 10, 2011, at 2150 UTC, an Air Atlanta Icelandic Airbus A300 B4-622R, registered in Iceland as TF-ELK, experienced a tailstrike while attempting to land at East Midlands Airport (EGNX), United Kingdom. The flightcrew performed a go-around and…Jan 10, 2011 · TF-ELK · Minor damage NTSB DCA11FA050Accident · No injuriesField investigationFinal reportBoeing 737-823 · Los Angeles, CAthe early rotation of the airplane to an angle at which the fuselage contacted the runway. Contributing to early rotation was the Captain’s reaction to the erroneous V1 automated callout, likely assuming that the airplane was at or close to the correct Vr at…Jan 3, 2011 · N831NN · Substantial damage