NTSB investigations, VA
97 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 9 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 3 |
| 2006 | 4 |
| 2007 | 4 |
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\" = 260)
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" = 260) 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 NYC07CA158Accident · No injuriesData collectionFinal reportCessna 195 · Warrenton, VAThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and impact with terrain.NTSB MIA07CA099Accident · No injuriesData collectionFinal reportCessna 172K · Emporia, VAThe failure of the student pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.NTSB NYC06CA153Accident · No injuriesData collectionFinal reportPiper PA-22-108 · South Boston, VAThe pilot's failure to maintain directional control, which resulted in a collision with a rising embankment. A factor in the accident was the pilot's lack of recent flight experience.NTSB NYC06CA158Accident · No injuriesData collectionFinal reportBoeing A75N1 · South Hill, VAThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop and a subsequent nose over.NTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.NTSB NYC06CA067Accident · No injuriesData collectionFinal reportPergerson Highlander · Appomattox, VAThe pilot's failure to maintain directional control during landing. A factor in the accident was the pilot's improper use of flaps.NTSB NYC05CA031Accident · No injuriesData collectionFinal reportFlight Design CT-2K · Waynesboro, VAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB NYC04LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Quantico, VAThe pilot's failure to maintain directional control during landing. A factor was the tail wind.NTSB NYC04LA015Accident · No injuriesLimited investigationFinal reportHarris BRC 540C · Leesburg, VAThe pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.NTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.NTSB NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.NTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.NTSB NYC02LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Lynchburg, VAThe pilot's failure to maintain control of the airplane, a factor was the tailwind.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB NYC02LA054Accident · No injuriesLimited investigationFinal reportBeech F33A · Lynchburg, VAThe pilot's failure to maintain directional control and delay in aborting the takeoff.NTSB IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.NTSB NYC02LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Farmville, VAThe CFI's failure to maintain directional control during the takeoff. A factor in the accident was the CFI's decision to conduct the flight from the airplane's right seat, which was not equipped with brakes.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.NTSB NYC01LA105Accident · No injuriesLimited investigationFinal reportCessna 337F · Quinton, VAThe pilot's improper recovery from a bounced landing. Factors in the accident were the crosswind, and the pilot's lack of experience in make and model.NTSB NYC01LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmville, VAthe failure of the pilot to maintain directional control.NTSB NYC01LA018Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ridgeway, VAThe pilot's failure to maintain proper runway alignment during the landing roll. A factor in this accident was a slight bend in the runway.NTSB IAD00LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Lynchburg, VAPilot's failure to maintain directional control during the landing roll-out.NTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB NYC99LA034Accident · No injuriesLimited investigationFinal reportUnivair 7GC-AA · Garner, VAA jammed right wheel for undetermined reasons.NTSB IAD99FA008Accident · Minor injuriesField investigationFinal reportLearjet 45 · Wallops Island, VAThe failure of the pilot to obtain/maintain alignment with the water pool, which resulted in the loss of control. Factors in the accident were the inadequate preflight planning of the flight test facility and the airplane manufacturer which resulted in…NTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.NTSB NYC98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Weyers Cave, VAthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing roll, which resulted in an encounter with a fence on uneven terrain and a nose over.NTSB NYC97LA074Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Waynesboro, VAThe pilot's failure to maintain directional control during landing.NTSB IAD97LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Warrenton, VAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.NTSB IAD96LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAthe student pilot's failure to maintain adequate control of the aircraft during the touch and go landing. Related factors were the crosswind condition and the student pilot's lack of experience.NTSB IAD96LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culpeper, VAThe pilot's improper compensation for the crosswind.NTSB IAD96LA068Accident · No injuriesLimited investigationFinal reportBeech B55 · Lynchburg, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve and landing gear collapse. A related factor was the strong crosswind.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB NYC95LA085Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Tangier Island, VAThe pilot's failure to maintain obstacle clearance which resulted in an inflight collision with a tree. Contributing factors are a crosswind and the pilot's failure to maintain directional control and his inadequate compensation for wind conditionsNTSB NYC94LA177Accident · No injuriesLimited investigationFinal reportCessna 195 B · Richmond, VAThe pilot's failure to maintain directional control which resulted in a ground loop. Contributing factors are excessive airspeed, fatigue, and improper recovery from a bounced landing.NTSB NYC94LA118Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Leesburg, VAThe pilot's inadequate incompensation for wind conditions resulting in loss of directional control.