NTSB investigations, HI
20 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 3 |
| 2013 | 3 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 2 |
| 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 ANC21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Lanai, HIA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR19LA041Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hawker Hntr FMK 58 · Honolulu, HIA total loss of engine power for undetermined reasons.NTSB WPR18TA239Accident · Minor injuriesClass 3Final reportEurocopter EC130 · Hilo, HIThe separation of the left sliding door in flight after it opened for reasons that could not be determined based on the available evidence, which resulted in damage to the main rotor blades.NTSB WPR18LA010Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R44 · Molokai, HIA descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information.NTSB WPR17FA170Accident · 4 fatalField investigationFinal reportBeech 19A · Waipi'o, HIThe pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.NTSB WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.NTSB WPR17FAMS2Accident · 3 fatalMissing aircraftFinal reportCessna 172M · Open water, HIUndetermined because the airplane was not located.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 WPR16LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA 23-150 · Kona, HIThe total loss of power in both engines during cruise flight for reasons that could not be determined because the airplane was not recovered from the ocean.NTSB WPR16FA116Accident · 5 fatalField investigationFinal reportCessna 182 · Hanapepe, HIThe pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…NTSB WPR15CA091Accident · Minor injuriesData collectionFinal reportCessna 172N · Makaha, HIA partial loss of engine power for reasons that could not be determined because the airplane was ditched and not recovered.NTSB WPR15LA086Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ualapue, HIA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB WPR14LA045Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Mokuleia, HIA landing gear brake malfunction during the landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA389Accident · Serious injuriesLimited investigationFinal reportChampion 8KCAB · Wahiawa, HIA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waihee-Waiehu, HIThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies due to saltwater immersion.NTSB WPR12LA314Accident · No injuriesLimited investigationFinal reportCessna 182R · Hilo, HIThe damage to the engine firewall for a reason that was undetermined because the damage was not reported when it occurred.NTSB WPR12LA195Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Kailua-Kona, HIA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA176Accident · Serious injuriesLimited investigationFinal reportSkykits USA Savannah ADV · Ookala, HIA loss of engine power during cruise for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s failure to avoid an…NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.NTSB LAX08LA139Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kekaha, HIA loss of engine power for undetermined reasons.