NTSB investigations, VA
19 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 4 |
| 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\" = 430)
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" = 430) 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 NYC07FA217Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Syria, VAThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain aircraft control. Contributing to the accident was the dark night conditions.NTSB NYC07FA007Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau Gmbh 300 · Culpeper, VAThe pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.NTSB NYC06LA151Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Dulles, VAThe driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.NTSB NYC06CA211Accident · No injuriesData collectionFinal reportErcoupe 415-C · Harrisonburg, VAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with trees.NTSB NYC06LA115Accident · Serious injuriesLimited investigationFinal reportEmbraer 145LR · Winchester, VAThe passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.NTSB NYC04LA174Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600 · Snow Hill, VAThe pilot's excessive maneuvering in response to a TCAS alert, which resulted in a serious injury to the flight attendant.NTSB NYC03LA199Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Norfolk, VAthe airline ground person's failure to properly control the pushback tug, and her subsequent failure to maintain adequate clearance between the tug and the airplane. Factors contributing to the accident were the airline ground person's operation of the tug…NTSB IAD03LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesapeake, VAThe pilot's failure to adequately remove snow and ice from the airplane's wings prior to takeoff.NTSB IAD02LA007Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Dulles, VAA passenger sustained a broken ankle during an emergency evacuation.NTSB NYC02LA011Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ashland, VAThe line technician's inadvertent contact with the propeller during a hand-propped engine start.NTSB NYC02LA027Accident · No injuriesLimited investigationFinal reportLet Blanik L 33 Solo · Windsor, VAThe pilot's inadequate preflight inspection, which resulted in a loose battery charger becoming entangled in the rudder pedals during a spin recovery, and a subsequent overstress of the glider. Factors included the loose battery charger, and the non-standard…NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB NYC98LA022Accident · Serious injuriesLimited investigationFinal reportBeech B200 · Norfolk, VAThe passenger tripped for an undetermined reason.NTSB BFO95FA050Accident · 1 fatalField investigationFinal reportCessna 172F · Tappahanock, VAThe student pilot's misjudgment of distance/speed during the approach to land, and her failure to go around while there was still sufficient runway remaining. Factors related to the accident were: inadequate supervision by the flight instructor, the student's…NTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.NTSB BFO91LA073Accident · Minor injuriesLimited investigationFinal reportBeech H50 · Hartwood, VAThe parachutist failure to properly monitor and secure his release handle to protect against accidental parachute deployment.NTSB BFO88LA017Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Petersburg, VAThe plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third…NTSB BFO87DID02Accident · Serious injuriesFinal reportEagle Balloons C-7 · Montvale, VAThe balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to…NTSB ATL84LA300Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe plt inadvertantly deployed the flaps on final apch instead of the spoilers. The glider overshot the airstrip touching down in rough terrain off the departure end.