NTSB investigations, ID
5 cases where NTSB found Prop/rotor parameters.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2015 | 2 |
| 2024 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062052'))
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" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062052')) 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 WPR24LA262Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Bonners Ferry, IDThe pilot’s improper selection of a landing site, which resulted in a main rotor strike. Contributing to the accident was the pilot’s improper performance planning and altitude selection over water, which resulted in an rpm droop.NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB WPR10CA442Accident · No injuriesData collectionFinal reportSchweizer 269C · Caldwell, IDThe failure of both pilots to maintain adequate main rotor RPM, the flight instructor's delayed remedial actions, and inadequate supervision of the flight.NTSB WPR10CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Marsing, IDThe pilot's failure to maintain adequate main rotor rpm during the approach and subsequent go-around and the certified flight instructor's inadequate supervision of the flight.