NTSB investigations
108 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '091') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '091') 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 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 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 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.