NTSB investigations, NV
5 cases where the sequence of events included Landing area overshoot.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2026 | 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\" = '380' 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" = '380' 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 WPR26LA087Accident · Serious injuriesClass 4 · LimitedFinal reportKitfox Series 7 · Lemmon Valley-Golden Valley, NVThe pilot’s inability to maintain clearance from terrain during a go-around.NTSB WPR22LA039Accident · No injuriesClass 3 · LimitedFinal reportIai 1125 Westwind Astra · North Las Vegas, NVThe pilot landed long and failed to deploy the thrust reversers, which resulted in a runway overrun and impact with terrain. Contributing to the accident was the pilot’s decision to operate the airplane as a single pilot instead of the required minimum crew…NTSB GAA19CA242Accident · No injuriesData collectionFinal reportFlight Design Ctls · Sandy Valley, NVThe pilot's steep bank turn at low altitude, which resulted in a rapid descent and hard landing.NTSB WPR12CA069Accident · Minor injuriesData collectionFinal reportCessna 208 · Mesquite, NVThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR10CA244Accident · Minor injuriesData collectionFinal reportSchweizer SGS136 · Reno, NVThe student pilot’s selection of the wrong runway for the wind conditions and his failure to attain the proper touchdown point. Contributing to the accident was the student's lack of total experience, lack of experience in the operating area, lack of…