NTSB investigations, VA
13 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2004 | 2 |
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\" = 'VA' 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" = 'VA' 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 NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.NTSB NYC04CA112Accident · No injuriesData collectionFinal reportBolger Scott RV-6A · Fredericksburg, VAThe pilots failure to maintain airspeed during a precautionary landing which resulted in an undershoot and subsequent impact with terrain. A factor was the inadequate pre-flight inspection.NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.NTSB NYC94LA081Accident · No injuriesLimited investigationFinal reportLet Super Blanik L-33 · New Castle, VAThe pilot's improper use of the flight controls resulting in failure to maintain a proper descent rate during the approach for landing. A factor in this accident was the pilot's lack of total experience in this type of glider.NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB BFO92LA008Accident · No injuriesLimited investigationFinal reportMooney 20F · Basye, VAThe pilot misjudged the altitude and distance to the runway. Factors were the gusty weather conditions and the pilot's delay in executing a go around.NTSB BFO90LA014Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Chesapeake, VAThe pilot misjudged distance and altitude to the runway, while on final approach to land. The light condition at dusk was a related factor.NTSB BFO85LA037Accident · Minor injuriesLimited investigationFinal reportSlingsby Type 43 Series 3F · Lovettsville, VAThe plt stated that he normally avoided landing on the rwy since the glider landed on a skid & it took a few minutes to remount it on a ground handling dolly. On this flt, he planned to land on the grass beside the apch end of the rwy. However, he allowed an…NTSB ATL84LA288Accident · No injuriesLimited investigationFinal reportCessna 182 · Waynesboro, VAThe pilot stated that while on final approach the aircraft encountered a downdraft and was forced down short of the runway. Pilot suggested that he may have also encountered possible wind shear.NTSB ATL84LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAAt about 1,000 ft AGL after takeoff from rwy 17 the eng cowling opened on the left side & began flapping. The CFI took control & returned to the arpt on a downwind for rwy 17. When she saw that the acft was too low to make the field, she turned off the fuel,…NTSB ATL83LA226Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe pilot stated that this was his third flt of the day and his first in this particular acft. He misjudged his glide path and landed about 100 feet short of the runway. The glider rolled into the creek and the nose impacted about 2 feet below the top of the…NTSB ATL83LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Midland, VAThe pilot and flight instructor (CFI) were on an instructional flight for a biennial flight review. The pilot reported that during the landing, the sun was in his eyes. He stated that on final approach, the aircraft encountered a downdraft and struck a…NTSB ATL82FID05Accident · No injuriesFinal reportPiper PA-38-112 · Charlottesville, VAAfter performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a…