NTSB investigations, NV
16 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2007 | 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\" = 390)
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" = 390) 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 LAX07CA149Accident · Minor injuriesData collectionFinal reportBurkhart Grob G102 Club Astir Iiib · Minden, NVthe pilot's misjudgment of distance and altitude that resulted in an undershoot of the runway.NTSB LAX04CA246Accident · No injuriesData collectionFinal reportSchweizer 1-35 · Sparks, NVthe pilot's misjudgment of altitude and distance resulting in an undershoot of the runway.NTSB LAX01LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Dayton Valley, NVThe pilot's failure to attain a proper glide path during the final approach resulting in an undershoot of the runway. Factors were the lack of runway lights and night lighting condition.NTSB LAX00LA201Accident · 1 fatalLimited investigationFinal reportIssoire-Aviation PIK-30 · Minden, NVThe pilot's inadequate in-flight planning/decision to attempt to make it back to the runway for landing after experiencing a loss of lift and not maintaining a proper descent rate.NTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.NTSB LAX97LA333Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG 15UTI · Fallon, NVThe pilot misjudged his altitude and airspeed. A related factor was his diverted attention.NTSB LAX96LA158Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Jean, NVthe pilot's poorly planned approach. The flight's encounter with a downdraft is a factor in this accident.NTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.NTSB LAX92LA077Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Carson City, NVThe failure of the pilot to arrest an excessive sink rate resulting in not attaining the proper touch down point and landing short of the runway threshold. Contributing to the accident was an excessive runway end lip due to inadequate runway end maintenance.NTSB SEA90LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Las Vegas, NVThe pilot misjudged his altitude and distance to the runway, while on final approach, and failed to attain the proper touchdown point or flare the aircraft during the landing. Darkness was a related factor.NTSB SEA87LA012Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Boulder City, NVThe plt stated that a downdraft was encountered and an undershoot occurred while on base leg. A high sink rate developed and the plt did not take corrective action soon enough. The acft struck the ground, rolled a short distance through bushes, and across a…NTSB SEA85LA207Accident · No injuriesLimited investigationFinal reportStolt-Adams Starduster SA101 · Yerington, NVWhile attempting to land the plt allowed the acft to become too low on short final. The plt did not add pwr soon enough and an undershoot occurred.NTSB SEA84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Gerlach, NVThe acft went off the 1500 ft rwy during a x-wind landing and nosed over. The plt said a gust of wind 'blew the plane too FAR down the runway, applied power, lost altitude, landed off the runway and the plane flipped upside down.'NTSB LAX83LA460Accident · No injuriesLimited investigationFinal reportCessna 150 · Sparks, NVThe stu plt stated he encountered wind shear on short final and applied full pwr but the nose wheel struck a dirt bank at the rwy threshold. The acft bounced back into the air and came down on the rwy at which time the nose gear departed the acft as it slid…NTSB LAX82DA158Accident · No injuriesFinal reportPiper PA-28-161 · North Las Vegas, NVDuring an instructional flight the instructor was demonstrating a short field landing using the minimum length of the runway. On final the aircraft hit a dirt bank separating the right main landing gear. The instructor stated there were no markings on the…NTSB LAX82DA087Accident · Minor injuriesFinal reportPiper J3-F65 · Yerington, NVDuring final approach for a hard dirt field the pilot reported that the bottom fell out and he hit short resulting in substantial damage to the aircraft.