NTSB investigations, HI
14 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2005 | 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\" = 260)
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" = 260) 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 LAX06CA078Accident · No injuriesData collectionFinal reportWaco YMF-5C · Lihue, HIthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the aircraft on landing.NTSB LAX05LA103Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Kapolei, HIthe pilot's inadequate compensation for the quartering tailwind conditions, and his failure to maintain directional control of the airplane during landing. Related factors were the tailwind and crosswind.NTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.NTSB LAX01LA046Accident · No injuriesLimited investigationFinal reportCessna 305A · Mokuleia, HIThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control and subsequent ground loop.NTSB LAX00LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Honolulu, HIThe pilot's improper use of the brakes during the landing rollout. The pilot's self induced pressure and the quartering tailwind were factors in the accident.NTSB LAX98LA286Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Lihue, HIThe failure of the pilot to maintain directional control of the aircraft during the landing.NTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…NTSB LAX96LA064Accident · No injuriesLimited investigationFinal reportEmroth Emair MA-1B · Pahala, HIthe failure of the pilot to adequately compensate for wind conditions, and to maintain directional control of the aircraft during the landing.NTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB LAX88LA136Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIAfter touchdown the plt reduced the throttle and removed his left hand from the throttle/collective pitch control to retune the radio. His attention was directed to the frequency indicator during the procedure. The helicopter became airborne and moved to the…NTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…NTSB LAX85LA116Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Makakilo, HIOn an air taxi flt, after landing at a prearranged site the plt signaled to his 3 pax to board the helicopter. As the pax attempted to board from the right side of the acft, the rotor blades went out of track/phase. The acft began uncontrollable bouncing up…NTSB LAX82FJA03Accident · No injuriesFinal reportCessna 305 (L-19) · Mokuleia, HIDuring the landing roll, the aircraft began to veer left and would not respond to right rudder or brake application. The plane continued off the left side of the runway, and the right wing was damaged. An investigation revealed that the right brake had…