NTSB investigations, NV
8 cases where the sequence of events included Ground collision.
Cases per year
| 2009 | 2 |
|---|---|
| 2014 | 2 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.NTSB WPR20LA322Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32-300 · Silver Springs, NVThe pilot’s failure to maintain directional control during a nighttime landing with a crosswind, which resulted in a runway excursion and impact with a sign.NTSB GAA19CA366Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Yerington, NVThe pilot's failure to properly secure the airplane before hand propping it, which resulted in the unmanned airplane moving and colliding with a fence.NTSB WPR15LA253Accident · No injuriesLimited investigationFinal reportBeech C90 · Las Vegas, NVThe jet flight crew's use of an inappropriate checklist to resolve a parking brake hydraulic system pressure anomaly, which resulted in the airplane rolling down a slight incline and colliding with a parked twin-engine turboprop airplane. Contributing to the…NTSB WPR14CA387Accident · No injuriesData collectionFinal reportBeech E33A · Las Vegas, NVThe pilot's incorrect engine start procedures, which included improper throttle position and failure to keep the brakes applied, which resulted in a loss of directional control and subsequent collision with a parked airplane.NTSB WPR14LA313Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVThe airplane flight crew’s failure to exercise the necessary vigilance and precautions and yield the right of way to the landing helicopter, which resulted in the airplane colliding with the helicopter. Contributing to the accident was the helicopter pilot’s…NTSB WPR09CA438Accident · No injuriesData collectionFinal reportBeech S35 · Fallon, NVThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB WPR09FA165Accident · No injuriesField investigationFinal reportBeech 200 · Henderson, NVThe pilot's failure to monitor and maintain clearance from an obstacle during taxi.