NTSB investigations, NV
11 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 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\" = 320)
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" = 320) 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 LAX01LA242Accident · No injuriesLimited investigationFinal reportCessna 310I · Amargosa Valley, NVThe pilot's attempt to depart on a taxiway unsuitable for takeoff under existing conditions. An additional factor was a berm at the end of the taxiway.NTSB LAX00LA241Accident · No injuriesLimited investigationFinal reportCessna 206 · Gerlach, NVThe pilot's attempt to takeoff from an unsuitable area and his collision with a dirt berm.NTSB LAX99LA070Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 Broussard · Minden, NVThe pilot's failure to maintain proper runway alignment during a rejected takeoff. A factor in the accident was the undetermined pitch control/trim system problem, which led to the pilot's rejected takeoff decision and may have distracted him during attempts…NTSB LAX98IA261Incident · No injuriesIncident investigationFinal reportBoeing 727-2Q8 · Las Vegas, NVThe airport personnel's failure to properly mark the ditch hazard and the taxiway boundaries surrounding it, and, the captain's failure to maintain a situational awareness of his location with respect to the taxiway layout. The dark night lighting condition…NTSB LAX94LA275Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Las Vegas, NVThe failure of the pilot to obtain the proper takeoff speed. Factors are the high density altitude and the crosswind.NTSB LAX94LA078Accident · No injuriesLimited investigationFinal reportBell 206B · Las Vegas, NVthe pilot's failure to properly position the helicopter away from the dolly edge during the initial touchdown.NTSB LAX92LA006Accident · 2 fatalLimited investigationFinal reportBentley Mongoose A · Boulder City, NVThe pilot's selection of an inadequate takeoff area which was too short for the prevailing conditions.NTSB SEA90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Boulder City, NVThe pilot did not attain proper alignment with the runway. Contributing to the accident was the ditch and the pilot's diverted attention.NTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.NTSB SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.NTSB LAX82DA281Accident · No injuriesFinal reportBeech 95-B55 · Henderson, NVPilot raised landing gear instead of flaps on a touch and go landing. Pilot owns a C-411 and a BE-B55. Switches are reversed on these aircraft.