NTSB investigations, HI
9 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1986 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2007 | 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\" = 430)
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" = 430) 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 LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.NTSB LAX03IA098Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Kahului, HIthe flight crew's failure to follow the checklist and detect an out of trim condition prior to takeoff.NTSB LAX02LA007Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahoolawe Isle, HIInadequate visual surveillance by the pilot before takeoff resulting in liftoff with a deplaning passenger still partially aboard the helicopter. A factor in the accident was the operator's inadequate procedures.NTSB LAX97LA204Accident · No injuriesLimited investigationFinal reportBell 204-B · Kaneohe, HIfailure of the pilot to verify that the load was properly rigged before attempting to pick it up. The uneven (sloping) terrain was a related factor.NTSB LAX97LA157Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Hilo, HIthe pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.NTSB LAX93LA371Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Kepuhi Molokai, HIA loss of main rotor RPM for undetermined reasons.NTSB LAX91LA306Accident · 1 fatalLimited investigationFinal reportCessna 182 · Wailua, HIThe accidental deployment of jumpers reserve parachute inside the airplane.NTSB LAX90LA189Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIImproper supervision and absence of assistance by the company to passengers disembarking the helicopter.NTSB LAX86MA238Accident · Minor injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Kameula, HIThe plt rprtd that as he 'hovered' the helicopter btn 5 & 10 ft after lift-off, he noted a 'slight lateral vibration.' He lndd immediately, but the vibration/ground resonance (vib) increased in severity, so he 'shut-off' both throttles. The vib contd to the…