NTSB investigations, NV
5 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 2 |
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\" = 330)
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" = 330) 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 LAX91LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Tonopah, NVThe airplane's encounter with a wind gust while taxiing from landing. Contributing factors related to the pilot's improper weather evaluation and his lack of experience in making weather evaluations.NTSB SEA90LA033Accident · No injuriesLimited investigationFinal reportCessna 172A · Reno, NVThe pilot's improper use of the flight controls. Factors in the accident were the high, gusty wind conditions, the pilot's self induced pressure to arrive at work on time, and his lack of total pilot experience.NTSB SEA87LA117Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Reno, NVWhile soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno…NTSB SEA85LA102Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder City, NVDuring arrival, a person answering the UNICOM reported that rwy 3 was the active rwy & that the wind was 10 KTS. The plt made a wheel landing on rwy 3 in winds that were from 210 deg at 10 KTS. He stated that when the tailwheel came down during the landing…NTSB LAX82DA104Accident · Serious injuriesFinal reportCessna 172 · Las Vegas, NVWhile preparing to takeoff, the pilot was cautioned to beware of wake turbulence from a departing jet and was cleared into position to hold. Preceding the accident, the winds were reported to be from 230 deg gusting to 29 KTS. While turning to align with the…