NTSB investigations, VA
11 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1999 | 2 |
| 2005 | 1 |
| 2006 | 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\" = '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\" = 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" = '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" = 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 NYC07LA191Accident · No injuriesLimited investigationFinal reportBass RV-6A · Harrisonburg, VAThe limited fork-to-ground clearance provided by the nose gear design. Contributing to the accident was the uneven turf/dirt surface of the runway.NTSB NYC06CA087Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Warrenton, VAThe pilot's failure to maintain directional control during the landing roll. A factor was the gusting winds.NTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.NTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.NTSB BFO90LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesterfield, VAThe student pilot's improper compensation for wind conditions and failure to maintain runway alignment.NTSB BFO90FA012Accident · No injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Staunton, VAThe pilot's failure to properly align the airplane with the runway heading during the takeoff run. Factors related to the accident were: airport personnel's failure to assure that runway marking and edge lights were adequately cleared of snow, adverse…NTSB BFO89LA002Accident · No injuriesLimited investigationFinal reportPitts S-1S · Ridgeway, VAThe pilot landed to the south on the private airstrip. In an attempt to make a left 180 deg turn to back taxi on the runway and avoid acft parked along the left side of the runway, the pilot steered his airplane to the right. While turning to the right, the…NTSB BFO88LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Reedville, VAAfter back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the…NTSB BFO85LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student plt reported that after the acft touched down on a touch-&-go landing, he observed about 1000 birds at the departure end of the rwy. He elected to turn off at the 1st available taxiway. However, his speed was too fast to negotiate the turn & the…NTSB ATL84LA154Accident · No injuriesLimited investigationFinal reportCessna 182P · Louisa, VAThe plt reported that the grass & ridges on the strip held the acft's speed down more than expected during the takeoff roll, so the plt decided to abort. The plt later stated that he could have made it safely, but his 'instinct' was stronger so he decided to…