NTSB investigations, 2019, CA
7 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
Latest 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\") = 2019
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") = 2019 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 GAA20CA034Accident · Minor injuriesData collectionFinal reportBell 47G · King City, CAThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing and the main rotor blades striking the tailboom.NTSB GAA19CA537Accident · No injuriesData collectionFinal reportCzech Sport Sportcruiser · Murrieta, CAThe student pilot's improper landing flare, which resulted in a bounced landing, and his subsequent loss of directional control and a hard landing.NTSB GAA19CA508Accident · No injuriesData collectionFinal reportPiper PA28 · Hemet, CAThe student pilot's failure to maintain directional control while attempting to go around, which resulted in a runway excursion and impact with a ditch.NTSB WPR19LA228Accident · Serious injuriesClass 3 · LimitedFinal reportHead AX9-118 · Galt, CAA loss of control following an adverse wind encounter.NTSB WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.NTSB GAA19CA284Accident · No injuriesData collectionFinal reportSchweizer 269C · Riverside, CAThe student pilot's failure to maintain yaw control and the engine's rpm during transition to a hover, which resulted in hard landing.NTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.