Skip to content

NTSB investigations, NV

16 cases where the first occurrence was “Miscellaneous/other”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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" = 430) 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\" = 430)
  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" = 430)
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 LAX07CA086Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-3C · Jean, NVthe tow hook jamming and failing to release from the glider.Feb 9, 2007 · N2438W · Substantial damage NTSB LAX05LA151Accident · 1 fatalLimited investigationFinal reportGulfstream 695A · North Las Vegas, NVThe incapacitation of the pilot.May 5, 2005 · N337DR · Substantial damage NTSB LAX04FA078Accident · 6 fatalField investigationFinal reportBeech A36TC · North Las Vegas, NVAn in-flight collision with terrain for an undetermined reason while the pilot was maneuvering to return for a landing during an unknown emergency.Dec 25, 2003 · N364JR · Destroyed NTSB LAX03LA157Accident · 1 fatalLimited investigationFinal reportSabre Trike 330 · Jean, NVThe pilot's excessive taxi speed, which resulted in an inadvertent liftoff at an inadequate airspeed and a subsequent stall. A factor was the pilot's lack of experience in the airplane.May 20, 2003 · UNREG · Substantial damage NTSB LAX02LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Henderson, NVThe pilot's misjudged landing flare during an autorotation, which resulted in a hard landing. The pilot's failure to follow the listed emergency procedures in the rotorcraft flight manual and the partial failure of the rotor system's drive belts were factors.Jun 8, 2002 · N7176S · Substantial damage NTSB LAX02LA016Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 600N · Laughlin, NVthe manufacturer's failure to provide warning information and ground training about the possibilities of boom strikes by the rotor blades in windy conditions and low rotor rpm situations.Oct 24, 2001 · N451DL · Substantial damage NTSB LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.May 20, 2001 · N9344X · Substantial damage NTSB LAX00LA223Accident · No injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the mechanic to refasten the cowling door prior to returning the aircraft to service.Jun 12, 2000 · N655AW · Substantial damage NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.Feb 1, 1999 · N640AW · No damage NTSB LAX97LA073Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-15 · Las Vegas, NVthe ramp agent's failure to maintain a good situational awareness of the push-back. A factor was the dark night lighting conditions and the general communication failure of the ground push-back crew.Dec 23, 1996 · N151SY · No damage NTSB LAX96IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 737-5H4 · Las Vegas, NVThe flying pilot's inadvertent exposure to an unidentified ground-based laser beam. A factor in the incident is the lack of appropriate standards by the FAA and FDA for laser light exposure levels to aircrew in navigable airspace.Oct 31, 1995 · N508SW · No damage NTSB LAX93LA217Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jean, NV1) The pilots inadequate preflight inspection of the aircraft, 2) his failure to adequately compensate for the existing gusty wind conditions, and, 3) his failure to maintain an adequate landing approach airspeed. Contributing to the accident was the pilots…May 17, 1993 · N410DS · Substantial damage NTSB SEA91LA126Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3G7 · Elko, NVAn unsecured cart. The factors to the accident were: turbulent weather conditions, and poor judgement by the flight attendant.Jun 6, 1991 · N304AW · No damage NTSB SEA86LA114Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20-D · Minden, NVThe cockpit canopy opened during takeoff roll. The glider became airborne and climbed to an alt of aprx 10 ft AGL before descending to ground impact in a nose low attitude.Apr 27, 1986 · N6VS · Substantial damage NTSB DCA85AA010Accident · 70 fatalFinal reportLockheed 188C · Reno, NVShortly after galaxy airlines flt 203 lifted off from rwy 16R, the coplt transmitted that they would like to 'make a left downwind, we gotta get back on the ground.' He then rprtd that there was a hvy vibration in the acft. Flt 203 was cleared as requested,…Jan 21, 1985 · N5532 · Destroyed NTSB MKC82IA042Incident · 1 fatalIncident investigationFinal reportBoeing 707-131B · Las Vegas, NVThis incident occurred when there was no intent to fly. On 3-8-82, a Boeing 707-131, owned and operated by twa, was receiving routine maintenance in Las Vegas, NV. During the check, the servicing valve on the forward water tank would not open. A twa mechanic…Mar 8, 1982 · N6728 · No damage