NTSB investigations, HI
19 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 2 |
| 1990 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 2 |
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\" = 220)
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" = 220) 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 LAX06CA227Accident · No injuriesData collectionFinal reportHughes 369D · Kihei, HIthe pilot's failure to maintain an adequate clearance from obstructions, which led to a main rotor blade strike.NTSB LAX06CA184Accident · Minor injuriesData collectionFinal reportRobinson R44 · Wailuku, HIthe pilot's inadequate compensation for the existing gusty wind conditions that resulted in his failure to maintain proper alignment with the landing area.NTSB LAX04CA268Accident · No injuriesData collectionFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot misjudging the clearance between the tree and the main rotor blades. Contributing factors to the accident were the high workload of the pilot and his lack of experience with bambi bucket operations.NTSB LAX03CA284Accident · No injuriesData collectionFinal reportHiller UH12E · Kekaha, HIthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB LAX03LA160Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Kahoolawe, HIThe pilot's failure to remove the external load cable before the repositioning flight, which resulted in the cable striking the tail rotor in cruise flight.NTSB LAX00FA159Accident · Serious injuriesField investigationFinal reportConvair BT-13A · Pearl Harbor, HIthe pilot's failure to anticipate turbulence from the formation lead airplane. Contributing to the accident was the pilot's failure to maintain control of the airplane.NTSB LAX99LA226Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Kaunakakai, HIThe pilot encountered a dust devil during the takeoff transition from a dirt and grass area resulting in a loss of vision, disorientation, and subsequent collision with trees.NTSB LAX97LA057Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mcgregor Point, HIthe pilot's failure to maintain control of the aircraft and distance from the pole.NTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.NTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.NTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…NTSB LAX87LA137Accident · No injuriesLimited investigationFinal reportCessna 172C · Kahului, HIThe acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…NTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…NTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…NTSB LAX86FJA01Accident · No injuriesFinal reportSchweizer 2-32 · Dillingham Fld, HIThe glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident.NTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…NTSB LAX85LA117Accident · No injuriesLimited investigationFinal reportHughes 369E · Honolulu, HIWhile in flt over water at about 400 ft AGL & 1/2 mi from shore, the plt saw a large flock of white birds. He reported that he flared to a stop, but was unable to avoid the birds. After the helicopter struck bird(s), an extreme vibration developed. The plt…NTSB LAX83FJA05Accident · 1 fatalFinal reportMurrayair MA1B · Nr Lihue Arpt, HIThe acft collided with a tree during a turn-around while engaged in aerial application operations. The pilot had made a few runs over the same field until he exhausted his load. After landing and reloading he returned to the area to finish the job and on the…