Skip to content

NTSB investigations, NV

10 cases where the first occurrence was “Overrun”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

Query with SQL

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" = 340) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 340)
  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" = 340)
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 LAX06CA061Accident · No injuriesData collectionFinal reportBeech A36 · Fallon, NVThe pilot's failure to abort the takeoff. A factor in the accident was the snow covered runway.Dec 19, 2005 · N3199H · Substantial damage NTSB DCA04MA049Accident · No injuriesMajor investigationFinal reportRaytheon Corporate Jets 390 Premier I · North Las Vegas, NVThe flight's unstabilized approach and excessive speed. Contributing to the excessive touchdown speed was the presence of a tailwind at landing.May 27, 2004 · N5010X · Substantial damage NTSB LAX04CA220Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Sparks, NVthe student pilot's misjudged altitude, distance, and speed, and failure to attain the proper touchdown point, resulting in an overshoot of the runway.May 24, 2004 · N53AS · Substantial damage NTSB LAX95LA220Accident · No injuriesLimited investigationFinal reportCessna 310 · Henderson, NVa brake system malfunction for undetermined reasons.Jun 22, 1995 · N5302A · Substantial damage NTSB LAX94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Las Vegas, NVThe cfi's improper remedial action by failing to go-around instead of landing, the cfi's excessive touchdown speed, and his failure to obtain the proper touchdown point. The dual student's initial excessive airspeed and the ditch were factors in this accident.Feb 19, 1994 · N303AT · Substantial damage NTSB LAX93LA350Accident · No injuriesLimited investigationFinal reportCessna 182E · Minden, NVthe pilot's inadequate preflight planning and failure to use all available runway. A factor in the accident was the high density altitude condition.Sep 12, 1993 · N3393Y · Substantial damage NTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.Sep 22, 1990 · N13686 · Substantial damage NTSB SEA87LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Boulder City, NVThe pilot was attempting to land the aircraft with a 15 knot tailwind gusting to 20 knots. The density altitude was over 6,000 feet and the runway was an uphill runway with rising terrain ahead. The pilot stated that he decided to go-around but that shortly…Aug 19, 1987 · N5549B · Substantial damage NTSB LAX83LA465Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Empire, NVThe plt said that a gust of wind blew the acft half way down the rwy. The touchdown was long and the acft ran off the end of the rwy into a dirt bank and nosed over. Winds were gusting to 20 KTS.Sep 17, 1983 · N9881E · Substantial damage NTSB LAX83LA215Accident · No injuriesLimited investigationFinal reportNorth American Rockwell S2R800 · Fallon, NVThe acft overran the departure end of the rwy during takeoff. The acft had a full load of fuel and about 250 lbs. Of insecticide. The acft had attained a speed of 65 mph as the end of the rwy was approached. The pilot stated that he thought he could make the…May 4, 1983 · N4985X · Destroyed