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 WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.NTSB DCA20CA095Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Las Vegas, NVthe excessive pitch attitude at touchdown.NTSB DCA20WA076Incident · No injuriesForeign investigationBoeing 787 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 787-900, which occurred on February 9, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB DCA19LA193Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321 · Orlando, FLEncountering gusty conditions at a low altitude during landing and the crew’s decision to do a go-around at a low altitude with an excessive rotation rate.NTSB DCA19WA184Incident · No injuriesForeign investigationBoeing 737 · San Jose, Costa RicaThe CETAC of Costa Rica has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CETAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19CA169Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Denver, COthe early initiation of the landing flare that resulted in a high pitch attitude and tailstrike.NTSB DCA19CA066Accident · No injuriesData collectionFinal reportBoeing 757 · Charlotte, NCan inadvertent loss of airspeed and increased pitch attitude prior to touchdown.NTSB DCA19WA043Accident · No injuriesForeign investigationBoeing 777 · Hong Kong, Hong Kong SAR ChinaThe Air Accident Investigation Authority (AAIA) of Hong Kong has notified the NTSB of an accident involving a Boeing 777-300ER, which occurred on December 11, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB DCA19WA022Accident · No injuriesForeign investigationBoeing 737 · Callao, PeruThe CIAA of Peru has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA of Peru's investigation under the provisions of ICAO Annex 13…NTSB DCA18CA266Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Philadelphia, PAThe captain's improper control of the airplane during the landing flare.NTSB DCA18WA263Incident · No injuriesForeign investigationBoeing 737 · Birmingham, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB DCA18WA270Accident · No injuriesForeign investigationBoeing 737 · Iguazu Province of Misiones, ArgentinaThe Junta de Investigacion de Accidentes de Aviacion Civil (JIAAC) of Argentina has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA18WA222Accident · No injuriesForeign investigationBoeing 737 800 · Crete, GreeceNTSB DCA18WA123Accident · No injuriesForeign investigationBoeing 737 · Osaka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB DCA18WA100Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandThe AAIB of New Zealand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of New Zealand's investigation under the provisions of…NTSB GAA18CA072Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Fort Pierce, FLThe pilot’s improper landing flare, which resulted in a tail strike and hard landing.NTSB DCA17WA209Accident · No injuriesForeign investigationAirbus A321 231 · Christ Church, BarbadosThe Barbados Civil Aviation Department has notified the NTSB of an accident involving a AIRBUS A321 231 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Barbados's investigation…NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB DCA17LA145Accident · No injuriesClass 3 · LimitedFinal reportAirbus A321 · Atlanta, GAThe first officer's improper landing flare, which resulted in a hard, bounced landing, and the flight crew’s improper bounced landing recovery procedures.NTSB DCA17LA122Accident · No injuriesLimited investigationFinal reportBoeing 757 · Raleigh, NCthe first officer's failure to attain a proper landing flare, which resulted in a tail strike.NTSB DCA17WA097Incident · No injuriesForeign investigationBoeing 777 · Amsterdam, NetherlandsThe government of Netherlands has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands's investigation under the…NTSB DCA17WA073Accident · No injuriesForeign investigationBoeing 767 33A · Azraq, JordanNTSB DCA17WA152Incident · No injuriesForeign investigationBoeing 737 · Baraloche, ArgentinaThe Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) of Argentina has notified the NTSB of an incident involving a Boeing 737-800, which occurred on February 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…NTSB DCA17WA068Incident · No injuriesForeign investigationBoeing 737 · Dhaka, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…NTSB CEN17LA055Accident · Serious injuriesLimited investigationFinal reportHiller OH 23B · Tynan, TXThe student pilot's delayed and improper landing flare during a practice autorotation, which resulted in the tail rotor striking terrain.NTSB DCA17WA006Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on October 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.NTSB GAA16CA439Accident · No injuriesData collectionFinal reportBell 206 L4 · Broussard, LAThe pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.NTSB GAA16CA328Accident · No injuriesData collectionFinal reportAirbus AS350 · McAllen, TXThe pilot's inadvertent input of the right tail rotor pedal, which resulted in a loss of directional control and an impact with service equipment.NTSB GAA16CA256Accident · No injuriesData collectionFinal reportCirrus Design SR20 · South St Paul, MNThe pilot's excessive nose high pitch attitude, which resulted in a tail strike during the landing flare.NTSB GAA16CA157Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.NTSB DCA16WA111Incident · No injuriesForeign investigationBoeing 737 · Billund, DenmarkThe Turkish Directorate General of Civil Aviation (DGCA) has notified the NTSB of an accident involving a Boeing 737 that occurred on March 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA of Turkey's investigation under…NTSB DCA16CA113Accident · No injuriesData collectionFinal reportBoeing 767 34AF · Albuquerque, NMthe pilot flying's failure to maintain airspeed and correct pitch attitude. Contributing to the accident was the pilot's failure to maintain appropriate thrust after disconnecting the autothrottles. Also contributing was the first officer's failure to monitor…NTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.NTSB GAA15CA262Accident · No injuriesData collectionFinal reportAero Commander 500 B · The Dalles, ORA motor vehicle's runway incursion causing the premature rotation of the departing airplane, which resulted in a tail strike.NTSB GAA15CA174Accident · No injuriesData collectionFinal reportPilatus PC12 · Belgrade, MTThe pilot's improper use of pitch control during an instructional maneuver, which resulted in a tail strike during landing.NTSB GAA15CA061Accident · Minor injuriesData collectionFinal reportHughes TH 55 · Morganton, NCThe flight instructor's delayed flare during a simulated auto rotation, which resulted in a tail rotor strike and rollover.NTSB GAA15CA013Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Lake Hamilton, ARThe pilot's overcorrection to the landing pad shifting, which resulted in the helicopter impacting trees. A factor contributing to the accident was the collapse of the landing pad.NTSB ERA15CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Barranquitas, PRThe pilot's failure to maintain control of the helicopter while landing which resulted in a tailrotor ground strike and collision with terrain.NTSB CEN15CA093Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Horseshoe Bay, TXThe helicopter's contact with the landing pad during a rejected landing.NTSB DCA14LA137Accident · No injuriesLimited investigationFinal reportBoeing 757 · San Diego, CAthe first officer's failure to maintain the correct airspeed and pitch attitude during landing that resulted in a tailstrike.NTSB DCA14FA122Accident · Minor injuriesField investigationFinal reportBoeing 767 36N · Kabul, Afghanistanthe early reduction of engine thrust that resulted in an excessive sink rate and nose high pitch attitude during the landing flare. Contributing to the accident was a significant change in the vertical and horizontal wind components just prior to touchdown.NTSB CEN14LA296Accident · Minor injuriesLimited investigationFinal reportBell 206B · Decatur, TXThe flight instructor’s improper recovery from a practice autorotation, which resulted in a hard landing.NTSB DCA14WA175Accident · No injuriesForeign investigationBoeing 737 - 8K2 · Madeira, PortugalNTSB DCA14CA034Accident · No injuriesData collectionFinal reportBoeing 737 · Las Vegas, NVthe captain's over rotation during the bounced landing.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.