NTSB investigations, HI
28 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 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\" = 230)
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" = 230) 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 LAX06LA155Accident · Serious injuriesLimited investigationFinal reportPartenavia P68 · Kaunakakai, HIthe pilot's failure to attain a proper climb rate and to maintain adequate clearance from the terrain during the initial climb in dark night conditions, which resulted in an in-flight collision with terrain.NTSB LAX06FA059Accident · 1 fatalField investigationFinal reportCessna 172S · Hana, HICollision with mountainous terrain for undetermined reasons.NTSB LAX05CA102Accident · No injuriesData collectionFinal reportAerospatiale AS350BA · Lihue, HIthe pilot's failure to maintain adequate terrain clearance, which resulted in the in-flight collision with terrain.NTSB LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.NTSB LAX02LA217Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 BA · Honolulu, HIthe pilot's failure to maintain adequate tail rotor clearance from the sloping terrain in unfavorable wind conditions.NTSB LAX00FA191Accident · 6 fatalField investigationFinal reportRockwell NA-265-65 · Kaunakakai, HIInadequate crew coordination led to the captain's decision to discontinue the instrument approach procedure and initiate a maneuvering descent solely by visual references at night in an area of mountainous terrain. The crew failed to review the instrument…NTSB DCA99MA088Accident · 10 fatalMajor investigationFinal reportPiper PA-31-350 · Volcano, HIthe pilot's decision to continue visual flight into instrument meteorological conditions (IMC) in an area of cloud-covered mountainous terrain. Contributing to the accident were the pilot's failure to properly navigate and his disregard for standard operating…NTSB LAX99LA190Accident · 1 fatalLimited investigationFinal reportBeech B90 · Mokuleia, HIThe pilot's incapacitation due to the effects of hypoxia from repeated flights to altitudes above 18,000 feet msl without supplemental oxygen.NTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…NTSB CHI96FA048Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Laupahoehoe, HIthe pilot falling asleep at the controls due to fatigue. Factors were: the pilot's inadequate preflight preparation and the dark night.NTSB LAX95LA184Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Honolulu, HIthe pilot's attempted flight in close proximity to terrain under gusty wind conditions at an inadequate terrain clearance altitude.NTSB LAX95FA144Accident · 1 fatalField investigationFinal reportCessna 310Q · Kahului, Maui, HIthe pilot's failure to maintain an adequate terrain clearance altitude while flying in a mountainous area at night.NTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.NTSB LAX93FA068Accident · 3 fatalField investigationFinal reportCessna 172M · Laie, HIThe pilot's inadvertent flight into a mountainous area where he lost visual reference to illuminated ground features which resulted in his becoming disoriented. Factors which contributed to the accident were: 1) the dark sky and low cloud conditions; 2) the…NTSB LAX92FA388Accident · 7 fatalField investigationFinal reportAerospatiale AS-350B · Hana, HIThe pilot inadequately evaluating the enroute weather conditions, and the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see and avoid the mountainous…NTSB LAX91LA391Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Kahului, HIThe student pilot entry into an uncontrolled descent while attempting to perform an autorotation. The student pilot's lack of total experience was a factor in the accident.NTSB DCA89MA058Accident · 11 fatalMajor investigationFinal reportBeech H18 · Waipio Valley, HIThe pilot's improper in-flight planning/decision to maneuver with insufficient altitude over or in a a canyon area. Factors related to the accident were: the terrain conditions and scenic air tour's lack of specific direction to its pilots concerning safety…NTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…NTSB LAX87LA189Accident · 4 fatalLimited investigationFinal reportCessna 172N · Lihue, HIThe pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…NTSB LAX87DJA04Accident · 1 fatalFinal reportGlaser-Dirks DG-400 · Dillingham, HIThe aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical…NTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…NTSB LAX85FJA04Accident · Minor injuriesFinal reportCessna 152 · Laupahoehoe, HIThe acft collided with rising terrain while on a training alt. The student plt was scheduled to proceed to the practice area near puna for this first extended solo flt. At aprx 1200 HST, he returned to general lyman flt, hilo, ha, for touch-&-go landing…NTSB LAX85FJA01Accident · No injuriesFinal reportEmair MA-1 · Paanilo, HIThe plt initiated his 1st spray pass uphill with about a 5 to 10 kt quartering tail wind. While on the swath run, he noted the airspeed was decaying, so he aborted the pass by turning into the wind. However, this resulted in flying over more rapidly rising…NTSB LAX84FJA02Accident · Serious injuriesFinal reportPiper PA-28-140 · Wailuku Maui, HIThe acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence.NTSB LAX84LA217Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Hana, HIThe acft disappeared from radar about 8 mi north of Hana, HI, while on an over-water flt. When it did not return from the flt, a search was intiated, but the acft was not found. Only the nose wheel strut (which washed ashore) and a life vest (found by…NTSB LAX84FA130Accident · 1 fatalField investigationFinal reportBell 47J-2 · Kahuku, HIAbout 3 min after takeoff, the helicopter was observed descending in a 'gliding fashion' until water impact. A witness reported that it appeared to be flying straight & did not appear to be in trouble. The witness reported that she could hear the eng & it…NTSB LAX83FJA06Accident · 1 fatalFinal reportGrumman American AA-5B · Waimanalo, Oahu, HIThe acft was observed maneuvering over the water at low altitude prior to impact with the water. A surviving pax stated that he & the plt had a big party the day before the flt & they both had hangovers the following morning. He further stated that they had a…NTSB LAX83FJA01Accident · 3 fatalFinal reportBeech C-45G · Waimanalo, HIThe purpose of the flt was to be a reindoctrination/training flt for the second-in-command. Witnesses observed the acft off shore flying parallel to the cliffs approximately 500 ft over the water. The acft banked left then right to a 90 deg right wing low…