NTSB investigations, VA
7 cases where the first occurrence was “Nose over”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 300)
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" = 300) 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 IAD01LA014Accident · No injuriesLimited investigationFinal reportGick Aerocomp CA6WB · White Post, VAThe pilot's inadequate preflight. Also causal in the accident was the under-inflated tire that flattened and locked during landing, and collapsed the nose landing gear.NTSB NYC01LA011Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Warrenton, VAThe pilot's improper recovery from a bounced landing.NTSB NYC98LA054Accident · Minor injuriesLimited investigationFinal reportMayers SEA REY · Gloucester, VAThe pilot's failure to maintain aircraft control during landing, which resulted in a nose over.NTSB BFO87FA003Accident · Minor injuriesField investigationFinal reportBellanca 8GCBC · Keysville, VAThe pilot made a tailwheel high touchdown on the 1850 foot grass strip. Shortly after touchdown, the nose dropped and, although the pilot said he moved the control stick fully aft, the propeller struck the ground, and the aircraft flipped inverted.NTSB ATL84LA269Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Virginia Beach, VAOn landing roll plt diverted aircraft to right to avoid a truck which had pulled onto the runway. This placed the aircraft in line with banner towing equipment. The plt applied the brakes while the tail wheel was still off the ground in attempts to stop prior…NTSB ATL84LA210Accident · Minor injuriesLimited investigationFinal reportJohnson Skyote · Portsmouth, VAThe acft was a recently manufactured, home built plane that was equipped with brakes that were designed for a much larger (Piper PA-23) acft. The plt stated that the brakes were too sensitive for his acft, a skyote. Also, he equipped it with a high quality…NTSB ATL83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Front Royal, VAThe acft nosed over during landing. There were no mechanical malfunctions. The pilot said that as he landed, the acft skipped. He said the acft was relanded but the tail came up. The tail was lowered, came up again and with back pressure on the control stick…