NTSB investigations, VA
5 cases where the defining event was Part(s) separation from AC.
Cases per year
| 2011 | 1 |
|---|---|
| 2018 | 1 |
| 2022 | 1 |
| 2025 | 1 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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 ERA26LA232Accident · No injuriesClass 3 · LimitedPreliminary reportNorth American SNJ-5C · Midland, VAOn June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA25LA236Accident · No injuriesClass 4 · LimitedFinal reportSting Sport TL-2000 · Dunavant, VAThe inflight failure of the propeller due to its exceedance of the manufacturer’s overhaul requirement.NTSB ERA23LA013Accident · No injuriesClass 3 · LimitedFinal reportSchempp-Hirth Discus CS · Woodstock, VAImproper repair of a crack by maintenance personnel, which resulted in a subsequent failure of the glider canopy.NTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…NTSB ERA12CA024Accident · No injuriesData collectionFinal reportCessna 182A · Warrenton, VAThe pilot did not ensure that the forward door latch was secured prior to initiating the descent.