NTSB investigations, HI
19 cases where the first occurrence was “Hard landing”.
Cases per year
| 1984 | 2 |
|---|---|
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) 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 LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB LAX05CA314Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kamuela, HIThe student's misjudged landing flare, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.NTSB LAX04CA290Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…NTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.NTSB LAX03CA227Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Waimea, HIThe certified flight instructor (CFI) delayed remedial action in response to the excessive descent rate initiated by the student during the practice autorotation. Also causal, was the CFI's inadequate supervision of the student during the flight. A possible…NTSB LAX03LA170Accident · No injuriesLimited investigationFinal reportCessna 172S · Kapolei, HIThe pilot's misjudged landing flare, and improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear and structural damage to the airplane.NTSB LAX01FA127Accident · No injuriesField investigationFinal reportAgusta A109A · Hanapepe, Kauai, HIthe pilot's misjudged flare during an autorotation, which resulted in a hard landing. A contributing factor was the check airman's failure to demonstrate a stuck pedal maneuver prior to assigning the procedure to the pilot.NTSB LAX01LA008Accident · No injuriesLimited investigationFinal reportCessna 172H · Hilo, HIAn inadvertent pilot-induced porpoise resulting from the pilot's improper landing flare and inadequate power management.NTSB LAX00FA229Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Lihue, Kauai, HIThe first officer's delayed and misjudged landing flare resulting in a tail strike and hard landing. Contributing factors were his relative inexperience flying the type of airplane, and the captain's and the first officer's failure to adhere to required…NTSB LAX00LA192Accident · No injuriesLimited investigationFinal reportLockheed L1011-385-1 · Maui, HIThe captain's failure to maintain the proper wind-adjusted Vref airspeed, by a margin which varied from 7 to 20 knots too slow, during the final 10 seconds of the approach prior to touchdown.NTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.NTSB LAX95LA039Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Honolulu, HIthe student pilot's improper use of the collective and throttle controls and his failure to maintain adequate main rotor rpm during a practice autorotation.NTSB LAX92LA326Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe student's improper use of the flight controls during an attempted recovery from an over rotation during the flare, and, the flight instructor's inadequate supervision of the flight.NTSB LAX92LA116Accident · No injuriesLimited investigationFinal reportBeech D-18H · Lanai, HIFailure of the pilot to compensate for an encounter with a windshear phenomena. Contributing to the accident was the lack of a low level windshear warning system or a system for the collection and dissemination of weather advisories.NTSB LAX91LA405Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Keaau, HIThe pilot's landing hard. A contributing factor in this accident was the aircraft emitting a vibration from an unknown source.NTSB LAX91LA152Accident · No injuriesLimited investigationFinal reportHughes 269C · Honolulu, HIThe instructor's improperly planned approach. A factor was the pilot's failure to observe performance data for the helicopter.NTSB LAX84LA307Accident · No injuriesLimited investigationFinal reportDe Havilland DHC 6-300 · Tau, Manu'A, HIAccording to the pilot, upon arrival in the vicinity of the arpt it was determined that the windsock indicated southeasterly winds at 15 to 20 KTS. This, plus light to moderate turbulence encountered in the traffic pattern led the crew to fly a slightly…NTSB LAX84LA182Accident · No injuriesLimited investigationFinal reportCessna 172M · Barbers Point, HIThe acft was observed to land nose first, collapsing the nosewheel and sustaining subst damage. Investigation revealed that the acft was stalled from an altitude of 20 to 30 ft AGL.