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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 ERA25LA210Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV-12 · Abingdon, VAThe pilot’s inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.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 WPR24LA322Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Paris, IDThe pilot’s failure to properly configure the flaps, which resulted in a loss of directional control during takeoff.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 WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB CEN23FA016Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Chandler, TXThe loss of control inflight for reasons that could not be determined.NTSB ERA22LA374Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Westfield, MAThe pilot’s loss of directional control while taxiing for takeoff.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 GAA17CA358Accident · No injuriesData collectionFinal reportVans RV-12 · Eugene, ORThe student pilot’s failure to maintain directional control during takeoff.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.NTSB GAA15CA159Accident · No injuriesData collectionFinal reportVans RV-12 · Oshkosh, WIThe pilot's failure to monitor the airplane's glide path during the final approach, which resulted in a low approach path and impact with terrain.NTSB ERA14LA181Accident · No injuriesLimited investigationFinal reportVans RV-12 · Bayport, NYThe failure of both pilots to see and avoid each other, which resulted in a collision.NTSB CEN13CA569Accident · No injuriesData collectionFinal reportRans RV 12 · Hatley, WIThe pilot did not maintain control of the airplane while landing with a crosswind.NTSB WPR13LA174Accident · No injuriesLimited investigationFinal reportVans RV12 · Waldport, ORThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.NTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.
Back to Vans RV-12