NTSB investigations, 2018, TX
13 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 9 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 12 |
| 2013 | 10 |
| 2014 | 7 |
| 2015 | 8 |
| 2016 | 6 |
| 2017 | 7 |
| 2018 | 13 |
| 2019 | 10 |
| 2020 | 7 |
| 2021 | 6 |
| 2022 | 9 |
| 2023 | 9 |
| 2024 | 8 |
| 2025 | 8 |
| 2026 | 3 |
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\") = 2018
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' 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") = 2018 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' 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 GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB WPR19LA019Accident · Serious injuriesClass 3 · LimitedFinal reportBell 47G · Wichita Falls, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB GAA18CA464Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.NTSB GAA18CA393Accident · No injuriesData collectionFinal reportZenair Zenith Stol CH 701 · San Saba, TXThe pilot’s improper landing flare during the aborted takeoff, which resulted in a hard landing and a nose-over.NTSB CEN18LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Lago Vista, TXThe separation of the left main landing gear spring during landing due to a preexisting fatigue crack.NTSB GAA18CA390Accident · No injuriesData collectionFinal reportCessna 421 · Clifton, TXThe pilot's improper landing flare in crosswind conditions, which resulted in a hard landing.NTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.NTSB CEN18LA079Accident · No injuriesLimited investigationFinal reportDayton A Dabbs Magni M-16 · Point Venture, TXThe loss of engine power for reasons that could not be determined because a postaccident engine test run showed no anomalies that would have precluded normal operation, and the pilot's decision to conduct the flight at a low altitude.NTSB CEN18LA069Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Albany, TXA loss of helicopter control for reasons that could not be determined because postaccident examination did not reveal any evidence of mechanical malfunctions or failures of the main rotor and tail rotor systems that would have precluded normal operation.