NTSB investigations, NV
5 cases where the first occurrence was “Roll over”.
Cases per year
| 1988 | 1 |
|---|---|
| 1990 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'NV' 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\" = 380)
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" = 'NV' 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" = 380) 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 LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB LAX02LA196Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · North Las Vegas, NVthe student pilot's improper liftoff into tailwind conditions, improper use of the collective, and failure to relinquish the flight controls to the CFI, resulting in the helicopter colliding with terrain. Also causal was the CFI's inadequate supervision and…NTSB LAX00LA248Accident · Serious injuriesLimited investigationFinal reportKashan Michael Berkut 540 · Jackpot, NVthe pilot's loss of control on landing after encountering a dust devil/whirlwind.NTSB LAX90LA335Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Beatty, NVThe pilot's selection of unsuitable terrain on which to land. Loose shale rock and sloping downhill terrain were factors in the accident.NTSB SEA88LA064Accident · Serious injuriesLimited investigationFinal reportMarlow Hilyard Executive · Elko, NVThe pilot made a landing on sloping terrain. The gyrocopter rolled to the left with the main rotor striking sage brush. The engine was twisted from its mounts rupturing a fuel line. A fire resulted consuming the gyrocopter. The pilot did not hold a pilot or…