Fatal NTSB investigations: Vans RV-12
8 cases on aircraft the registry lists as Vans RV-12. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2016 | 1 |
|---|---|
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0690009', '060009Y', '05622D3'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0690009', '060009Y', '05622D3'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…NTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB ERA22LA031Accident · 1 fatalClass 3 · LimitedFinal reportVans RV-12 · Folkston, GAThe pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.NTSB ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.NTSB ERA19FA048Accident · 1 fatalField investigationFinal reportVans RV-12 · Niceville, FLA partial loss of engine power during initial climb for undetermined reasons, and pilot's failure to maintain airspeed during a turn back to the runway, which resulted in an exceedance of the airplane's critical angle of attack, and subsequent aerodynamic…NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB ERA16FA165Accident · 2 fatalField investigationFinal reportVans RV12 · Stevensville, MDThe pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.