NTSB investigations
124 cases where the sequence of events included Tailstrike.
Cases, newest first
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 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 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 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…NTSB DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.NTSB ANC12CA042Accident · No injuriesData collectionFinal reportBeech 1900C · McGrath, AKThe pilot's unstable approach and overrotation, which resulted in a tailstrike.NTSB DCA12WA066Accident · No injuriesForeign investigationBoeing 777 - 206 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-246ER that occurred on March 31, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…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.NTSB ERA11CA433Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Humacao, PRThe pilot's failure to maintain clearance from a building during landing.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…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.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…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…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…NTSB CEN11CA126Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Hemphill, TXThe student pilot’s improper decision to carry an unauthorized passenger and the passenger’s loss of control of the helicopter during take-off.NTSB ERA10TA429Accident · No injuriesFinal reportBell UH1H · Warrenton, VAThe pilot receiving instruction's failure to maintain a proper pitch attitude during the practice autorotation maneuver.NTSB CEN10LA455Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · Kountze, TXA loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA390Accident · No injuriesData collectionFinal reportSchweizer 269C · Santa Rosa, NMThe student pilot's failure to maintain control of the helicopter while landing in gusty surface winds conditions. Contributing to the accident was the flight instructor's inadequate monitoring of the flight.NTSB ERA10TA292Accident · No injuriesFinal reportBell 206B · Memphis, TNThe pilot’s failure to maintain adequate rotor rpm and the certificated flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB DCA09FA047Accident · Minor injuriesField investigationFinal reportAirbus A320 · Denver, COThe first officer’s excessive pitch-up of the airplane while landing with a tailwind, which resulted in a tailstrike following a bounced landing. Contributing to the bounced landing were a high descent rate and excessive thrust resulting from the first…NTSB WPR09WA138Accident · No injuriesForeign investigationEurocopter EC225 · North Sea, United Kingdom.NTSB DCA09FA004Accident · No injuriesField investigationFinal reportAirbus 320 · Phoenix, AZThe failure of the flightcrew to arrest an excessive sink rate during the flare for landing.NTSB DFW08CA215Accident · No injuriesData collectionFinal reportEmbraer EMB-145LR · St. Louis, MOThe flying pilot's excessive angle of attack during the landing flare resulting in abnormal runway contact.