NTSB investigations, 2015, CA
10 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 19 |
| 2010 | 11 |
| 2011 | 15 |
| 2012 | 9 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 10 |
| 2016 | 11 |
| 2017 | 18 |
| 2018 | 9 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 6 |
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\") = 2015
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2015 AND c."eventStateOrRegion" = 'CA' 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 GAA16CA085Accident · No injuriesData collectionFinal reportKelm David Kitfox 7 · Tracy, CAThe pilot's failure to maintain pitch control during the landing, which resulted in a hard landing, runway excursion and impact with terrain.NTSB WPR16LA019Accident · No injuriesLimited investigationFinal reportAmerican Eurocopter AS350B3 · Folsom, CAThe flight instructor's failure to perform simulated engine failure training in accordance with manufacturer guidance, including his improper recovery from the maneuver, which resulted in an overshoot of the intended landing zone when the engine did not…NTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.NTSB GAA15CA230Accident · Minor injuriesData collectionFinal reportBell 412 · Whittier, CAThe pilot's failure to appropriately monitor the helicopter's fuel supply, resulting in fuel exhaustion, loss of engine power, and an autorotation with a hard landing.NTSB GAA15CA248Accident · No injuriesData collectionFinal reportCessna 177B · Los Angeles, CAThe pilot's failure to maintain pitch control during the landing, resulting in a hard landing.NTSB GAA15LA195Accident · Serious injuriesLimited investigationFinal reportKubicek BB100Z · Hidden Valley Lake, CAThe balloon pilot’s deliberate hard landing to avoid power lines and trees, which resulted in serious passenger injuries.NTSB GAA15CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Palm Springs, CAThe pilot's improper landing flare which resulted in a hard landing and substantial damage to the firewall.NTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.NTSB WPR15LA096Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Calexico, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15CA093Accident · No injuriesData collectionFinal reportFlight Design Ctls · Hanford, CAThe pilot's inadequate flare, which resulted in a hard landing.