NTSB investigations, HI
11 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' 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 c."eventStateOrRegion" = 'HI' 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" = '230' 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 ANC21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172P · Lanai City, HIThe solo student pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and a nose-over.NTSB ANC20CA027Accident · No injuriesData collectionFinal reportCessna TP206 · Kahului, HIThe pilot's improper landing flare in gusting crosswind conditions, which resulted in the airplane porpoising and a subsequent a loss of directional control, runway excursion, and nose-over.NTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.NTSB WPR18LA065Accident · No injuriesLimited investigationFinal reportJust JA30 Superstol · Kapolei, HIThe collapse and separation of the right landing gear suspension strut due to overload.NTSB GAA17CA094Accident · No injuriesData collectionFinal reportSchauer William A JR Starduster TOO SA300 · Kapolei, HIThe pilot's failure to maintain directional control during the landing roll.NTSB WPR16LA168Accident · No injuriesLimited investigationFinal reportRobinson R44 · Kailua/Kona, HIAn on-ground upset for reasons that could not be determined because postaccident examination of the helicopter revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR15LA148Accident · No injuriesLimited investigationFinal reportCessna 206H · Honolulu, HIA blown nose landing gear tire during landing, which resulted in the pilot’s inability to maintain directional control.NTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.NTSB WPR11LA081Accident · No injuriesLimited investigationFinal reportApollo AS-III · Poipu, HIThe pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.NTSB WPR10CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kona, HIThe student pilot's improper use of the anti-torque controls and failure to maintain directional control during takeoff.NTSB WPR09CA045Accident · Minor injuriesData collectionFinal reportPiper PA-30 · Kona, HIThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll. Contributing factors were the delayed remedial action by the check pilot, the crosswind condition, and the rough uneven…