NTSB investigations, VA
12 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases per year
| 2008 | 2 |
|---|---|
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '330' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA24LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Stafford, VAAn overloading of the landing gear push/pull cable rod ends, which resulted in the landing gear being seized in an intermediate position during the subsequent landing.NTSB ERA23LA075Accident · No injuriesClass 3 · LimitedFinal reportGates Lear Jet 36 · Newport News, VAA left main landing gear tire rupture during takeoff, which resulted in a runway overrun.NTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.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…NTSB ERA21LA183Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Weyers Cave, VAMaintenance personnel’s inadequate inspection of the rudder control system, which resulted in failure of the rudder control assembly and the pilot’s loss of control during a go-around.NTSB ERA21LA062Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · South Boston, VAThe improper installation of a fuel filter screen cover gasket, which resulted in its failure, fuel starvation, and a subsequent total loss of engine power during cruise flight. Contributing to the accident was the unapproved fuel sight gauge, which obscured…NTSB DCA16CA226Accident · No injuriesData collectionFinal reportBombardier DHC 8 202 · Dulles, VAincorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.NTSB ERA16FA194Accident · 2 fatalField investigationFinal reportJihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VAThe pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…NTSB ERA15LA212Accident · No injuriesClass 2 · LimitedFinal reportGates Lear Jet 35 · Newport News, VAThe flight crew’s inadequate preflight inspection of the nose landing gear strut, which resulted in the nosewheel not being aligned during retraction and the subsequent loss of directional control. Contributing to the accident was the failure of the nose…NTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…NTSB MIA08CA191Accident · No injuriesData collectionFinal reportAirframes Unlimited USA-1B · Surry, VAThe pilot's improper handling of the powered parachute during takeoff/initial climb.NTSB CHI08LA143Accident · No injuriesLimited investigationFinal reportBeech A36 · Norfolk, VAThe failure of the left main landing gear tire for undetermined reasons.