NTSB investigations: Agusta AGUSTA A109
7 cases on aircraft the registry lists as Agusta AGUSTA A109. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1987 | 2 |
|---|---|
| 1989 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0260109'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0260109'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA08CA040Accident · No injuriesData collectionFinal reportAgusta A109 · ST. Augustine, FLThe pilot's failure to maintain a visual lookout while taxiing.NTSB LAX04FA076Accident · 3 fatalField investigationFinal reportAgusta A109A · Redwood Valley, CAThe pilot's improper in-flight planning and decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in an inadvertent in-flight encounter with instrument meteorological conditions and a collision with rising…NTSB SEA96LA139Accident · No injuriesLimited investigationFinal reportAgusta A109 · Newport, ORthe pilot's failure to adequately compensate for the gusty wind condition during the landing. The gusty wind was a related factor.NTSB SEA95FA214Accident · 3 fatalField investigationFinal reportAgusta A109A II · Winslow, WAthe pilot failed to maintain sufficient altitude/clearance above the surface of water, while flying over calm water conditions at night. Factors relating to the accident were: darkness, low ceiling, fog, glassy (calm) water conditions, and the lack of visual…NTSB NYC90MA009Accident · 5 fatalMajor investigationFinal reportAgusta A109A Mkii · Lacey Township, NJIn-flight separation of a main rotor blade due to fatigue failure of the main rotor blade spar, which originated at a manufacturing induced scratch (tool mark) that was the result of inadequate quality control.NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB NYC87LA058Accident · Minor injuriesLimited investigationFinal reportAgusta A109AII · So. Dartmouth, MAAgusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated…