NTSB investigations, NV
4 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1996 | 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\" = 110)
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" = 110) 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 LAX96LA318Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Minden, NVthe pilot's delayed remedial action when encountering downdrafts while approaching high terrain in high density altitude conditions. The pilot's inadequate supervision of the second pilot was a factor in the accident.NTSB SEA85IA080Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-14 · Reno, NVAfter a ground time of 36 minutes during rain/wet snow the aircraft departed Reno. During the climb in below freezing conditions the crew experienced elevator pitch control difficulties which persisted until the descent into seattle. Examination of the…NTSB SEA85LA059Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126E · Reno, NVStudent glider pilot was ridge flying in thermals then lift dropped off. The acft turned downwind, away from rising terrain and the plt made an emergency off arpt landing.NTSB SEA84LA127Accident · No injuriesLimited investigationFinal reportBreezy RLU-1A · Jean, NVThe acft departed on rwy 20 and turned crosswind at an alt of 200 ft AGL. The plt stated that after turning downwind for a non-standard traffic pattern at an airspeed of 60 to 65 mph the acft began to lose altitude. The acft continued the descent even though…