NTSB investigations, HI
11 cases where the defining event was Hard landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2023 | 2 |
| 2026 | 1 |
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 c.\"eventStateOrRegion\" = 'HI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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."eventStateOrRegion" = 'HI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB ANC24LA010Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kapolei, HIThe first pilot’s failure to maintain a stabilized approach, in gusty crosswind conditions, in an environment favoring wake turbulence.NTSB ANC23LA038Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS350B2 · Honolulu, HIThe instructor pilot’s inadequate supervision of the pilot receiving instruction, which resulted in a hard landing, and substantial damage to the tail boom.NTSB GAA17CA025Accident · No injuriesData collectionFinal reportCessna 172 · Kapolei, HIThe pilot’s use of an excessive pitch attitude during the landing flare, which resulted in a bounced landing.NTSB GAA16CA472Accident · No injuriesData collectionFinal reportCessna 172 · Kahului, HIThe pilot's incorrect pitch control during the landing flare, which resulted in a porpoise and hard landing.NTSB WPR14CA187Accident · No injuriesData collectionFinal reportPiper PA28 - 181 · Ho'olehua, HIThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR13CA107Accident · No injuriesData collectionFinal reportRobinson R22 · Kona, HIThe pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.NTSB WPR12CA056Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Waipahu, HIThe certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.NTSB LAX08LA139Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kekaha, HIA loss of engine power for undetermined reasons.NTSB LAX08CA084Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and his subsequent failure to maintain an adequate airspeed during landing. A contributing factor was the weather windshear condition.