OpenAirDocs.org

NTSB investigations, 2009, HI

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026

Where

Open the map

Latest 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 year(c.\"eventDate\") = 2009
    AND c.\"eventStateOrRegion\" = 'HI' AND c.\"eventCountry\" = 'USA'
  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.

NTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…Dec 16, 2009 · N87EW · Substantial damageNTSB WPR10LA060Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Heli 369E · Kahuku, HIThe fatigue failure of the landing gear strut and maintenance personnel’s failure to perform an adequate inspection of the landing gear.Nov 20, 2009 · N551CR · Substantial damageNTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.Oct 17, 2009 · N5329L · Substantial damageNTSB WPR10LA022Accident · No injuriesLimited investigationFinal reportCessna 208B · Molokai, HIThe failure of the ramp agent to use a tail stand.Oct 15, 2009 · N861MA · Substantial damageNTSB WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.Aug 2, 2009 · N44VZ · Substantial damageNTSB WPR09CA481Accident · No injuriesData collectionFinal reportS.C. Aerostar YAK-52W · Kaunakakai, HIThe pilot's failure to maintain clearance from terrain while in the airport traffic pattern in dark night conditions.Jul 25, 2009 · N691T · Substantial damageNTSB WPR09LA097Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Honolulu, HIAn oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.Jan 21, 2009 · N30740 · Substantial damageNTSB WPR09CA090Accident · Minor injuriesData collectionFinal reportMulec Frank A FP-404 · Hilo, HIA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.Jan 18, 2009 · N81633 · Substantial damageNTSB WPR09FA089Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-400 · Volcano, HIThe pilot's loss of pitch control and subsequent exceedance of the glider's airspeed limit for undetermined reasons.Jan 16, 2009 · N777WN · DestroyedNTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.Jan 5, 2009 · N141MK · Substantial damage