NTSB investigations, 2011, CA
15 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\") = 2011
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") = 2011 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 WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB WPR12CA035Accident · Serious injuriesData collectionFinal reportCameron Balloons A-315 · Vacaville, CAThe balloon’s encounter with increased wind, which resulted in a hard landing and passenger injury.NTSB WPR12LA029Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Diego, CAThe flight instructor's inadequate supervision of the student pilot during a simulated autorotation and the pilots’ failure to use carburetor heat while operating at reduced engine power while in carburetor icing conditions, which resulted in a loss of engine…NTSB WPR11CA472Accident · No injuriesData collectionFinal reportCessna 172R · Napa, CAThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR11CA478Accident · No injuriesData collectionFinal reportFpna A-22 Valor · Fresno, CAThe student pilot’s improper flare.NTSB WPR11LA462Accident · No injuriesLimited investigationFinal reportHughes 269C · Ramona, CAThe flight instructor’s failure to follow the proper procedure while demonstrating a practice autorotation, which resulted in a total loss of engine power and subsequent hard landing.NTSB WPR11CA445Accident · No injuriesData collectionFinal reportAero SP Z O O AT-4 LSA · San Diego, CAThe pilot's improper recovery from a bounced landing and failure to maintain control during an attempted go-around.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB WPR11LA283Accident · No injuriesLimited investigationFinal reportBeech A36 · El Monte, CAThe pilot's failure to maintain adequate airspeed during the forced landing, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the loss of engine power due to fuel starvation as a result of the pilot's improper fuel…NTSB WPR11LA267Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lost Hills, CAThe failure of the engine-driven fuel pump, resulting in the loss of all engine power and the pilot's failure to correctly execute an autorotational landing.NTSB WPR11CA251Accident · No injuriesData collectionFinal reportBoeing B75N1 · Torrance, CAThe pilot's inadequate compensation for wind conditions.NTSB WPR11CA152Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, CAThe student pilot's improper flare which resulted in a hard landing. Contributing to the accident was the certified flight instructor's delayed remedial action.NTSB WPR11LA119Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic · Palm Springs, CAInadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.NTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.