NTSB investigations, VA
227 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 13 |
| 2010 | 12 |
| 2011 | 14 |
| 2012 | 12 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 14 |
| 2016 | 21 |
| 2017 | 13 |
| 2018 | 19 |
| 2019 | 12 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 13 |
| 2024 | 11 |
| 2025 | 8 |
| 2026 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106')) 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 ERA26LA315Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Rural Retreat, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA26LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Chesapeake, VAThe pilot’s improper decision to continue with an unstabilized approach, which resulted in a hard landing, loss of directional control, and collision with a runway marker light and sign.NTSB ERA26LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Suffolk, VAThe pilot’s failure to maintain control of the airplane during landing, which resulted in a nose over.NTSB ERA26LA005Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Reedville, VAThe pilot’s sudden incapacitation by an episode of abnormal heartbeat due to heart disease during a takeoff attempt, which resulted in a loss of directional control and runway excursion.NTSB ERA25LA355Accident · No injuriesClass 4 · LimitedFinal reportLamphere David A Wittman Buttercup · Monterey, VAThe pilot’s failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA25LA354Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 · New Castle, VAThe pilot’s failure to properly configure the glider for landing, which resulted in an excessive descent rate during approach, and subsequent collision with trees short of the intended landing area.NTSB ERA25LA203Accident · Serious injuriesClass 3 · LimitedFinal reportSeamax Aircraft Ltda Seamax M-22 · Dahlgren Center, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a known…NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB ERA25LA150Accident · No injuriesClass 4 · LimitedFinal reportTextron T240 · Midland, VAThe pilot’s improper landing flare, which resulted in a bounced landing and the nose landing gear collapsing.NTSB ERA25LA133Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Culpeper, VAThe pilot’s failure to maintain directional control of the airplane during the takeoff roll, resulting in a runway excursion.NTSB ERA25LA024Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Williamsburg, VAThe pilot’s failure to maintain directional control on landing.NTSB ERA25LA009Accident · Minor injuriesClass 4 · LimitedFinal reportSchleicher ASK-21 · Front Royal, VAThe pilot’s improper landing flare and subsequent improper recovery from a hard, bounced landing.NTSB ERA24LA381Accident · Minor injuriesClass 4 · LimitedFinal reportWalden Robert Vans Aircraft RV-7A · Williamsburg, VAThe pilot’s decision to continue with an unstabilized approach which resulted in a hard landing and loss of directional control during a subsequent landing.NTSB ERA24LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Louisa, VAThe pilot’s improper landing flare which resulted in a hard landing.NTSB ERA24LA312Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Rural Retreat, VAA loss of directional control during the landing roll.NTSB ERA24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Richmond, VAThe pilot’s failure to maintain directional control of the airplane while landing in rain and gusting wind conditions.NTSB ERA24LA281Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Chesapeake, VAThe pilot’s improper recovery from a bounced landing.NTSB ERA24LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Ridgeway, VAThe pilot's failure to attain a proper touchdown point while landing, which resulted in a runway overrun.NTSB ERA24LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Chesapeake, VAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop, runway excursion, and subsequent landing gear collapse.NTSB ERA24FA136Accident · 5 fatalClass 3 · FieldFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Hot Springs, VAThe PIC’s continuation of an unstabilized approach in gusting wind conditions and his failure to monitor the airplane’s altitude during the approach, which led to a descent into terrain short of the runway. Contributing was the flight crew’s failure to set…NTSB ERA24LA094Incident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Dulles, VAThe pilot-in-command’s approach to the critical angle of attack during initial climb, which resulted in a vibration the flight crew improperly identified as an engine issue and resulted in the subsequent off-airport landing. Contributing to the accident was…NTSB ERA24LA084Accident · No injuriesClass 4 · LimitedFinal reportGolden Avio S R L F30 Brio · Midland, VAThe pilot’s improper recovery from a bounced landing, which resulted in damage to, and the separation of the nose wheel and fork bracket assembly, and subsequent collapse of the nose landing gear assembly.NTSB ERA24FA053Accident · 1 fatalClass 3 · FieldFinal reportBeech C23 · Midland, VAThe pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…NTSB ERA24LA052Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Martinsville, VAThe pilot’s failure to maintain directional control during a wheel landing in crosswind conditions and the flight instructor’s delayed remedial action, which resulted in a ground loop on the runway.NTSB ERA24LA045Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Chesterfield, VAA hard landing, which resulted in a main rotor strike of the left vertical stablizer.NTSB ERA24LA007Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Martinsville, VAThe pilot’s failure to maintain a positive climb rate after takeoff while distracted by primary flight display anomaly and terrain alerts. Contributing to the accident was the pilot’s decision to take off with the airplane over its maximum gross weight, which…NTSB ERA24LA013AccidentClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2010 · Chesterfield, VAA hard landing that resulted in substantial damage to the airplane’s right wing.NTSB ERA23LA345Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Warrenton, VAA ground loop during landing resulting from a partial separation of the right main landing gear strut during takeoff.NTSB ERA23LA312Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Roanoke, VAThe student pilot’s failure to maintain directional control during the landing, and the flight instructor’s inadequate remedial action.NTSB ERA23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Suffolk, VAThe pilot’s inadequate landing flare, which resulted in a nose landing gear collapse.NTSB ERA23FA260Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Colonial Beach, VAThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB ERA23LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 421C · Leesburg, VASeparation of the left man landing gear scissor hardware, which resulted in a loss of directional control and subsequent runway excursion during landing.NTSB ERA23FA108Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Dayton, VAThe pilot’s controlled flight into terrain while descending over mountainous terrain at night.NTSB ERA23FA103Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Suffolk, VAThe pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…NTSB ERA23FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newport News, VAThe flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.NTSB ERA22LA302Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502B · Center Cross, VAA loss of engine power for reasons that could not be determined.NTSB ERA22LA365Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26D · Windsor, VAThe glider’s encounter with atmospheric conditions, where lift was not sufficient to maintain flight.NTSB ERA22LA292Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Market, VAImpact with a fence during an attempted takeoff from a short, uphill turf airstrip.NTSB ERA22LA285Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Manassas, VAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB ERA22LA222Accident · No injuriesClass 4 · LimitedFinal reportCharles R Kyle Zenith Stol CH 701 · Culpepper, VAThe pilot’s failure to maintain the proper glidepath, which resulted in a hard landing and landing gear collapse.NTSB ERA22LA145Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters MBB-BK 117 C-2 · Abingdon, VAThe pilot’s misalignment of the helicopter skids while landing on a dolly at night, which resulted in the skids becoming entangled with the dolly and a loss of control. Contributing to the accident was the pilot’s fatigue as a result of the time the accident…NTSB ERA22FA114Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · Danville, VAThe pilot’s impairment due to exposure to carbon monoxide as a result of undetected engine exhaust penetration into the cockpit, resulting in the pilot's failure to maintain a minimum controllable airspeed after partially securing an engine after takeoff.NTSB ERA22LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Waynesboro, VAThe student pilot’s loss of directional control while landing.NTSB ERA22LA061Accident · No injuriesClass 4 · LimitedFinal reportEric A Munzer Dornier D027-B2 · Martinsville, VAThe pilot’s failure to maintain directional control during landing rollout, which resulted in a runway excursion and an impact with a ditch.NTSB ERA22LA012Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Winchester, VAThe pilot’s misapplication of brakes during the landing roll which resulted in a nose-over event and substantial damage to the airplane.NTSB ERA21LA294Accident · No injuriesClass 4 · LimitedFinal reportTurbine Cubs Of Wyoming PA-18 Super CUB · Dinwiddie, VAThe pilot’s failure to maintain control while taxiing on soft ground, which resulted in a nose-over.NTSB ERA21LA248Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Nellysford, VAThe student pilot's failure to maintain an appropriate glide path to the runway.NTSB ERA21LA204Accident · Minor injuriesClass 4 · LimitedFinal reportJabiru Aircraft PTY J170-D · Winchester, VAThe pilot’s loss of directional control on landing. Contributing to the outcome was the pilot’s decision to continue the aborted landing after the airplane had departed the runway surface.NTSB ERA21LA202Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Martinsville, VAThe pilot’s improper pitch control during a go-around in gusting crosswind conditions, which resulted in a tail strike and a runway excursion.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…