NTSB investigations, CO
70 cases where the sequence of events included Other weather encounter.
Cases, newest first
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\" = 'CO' 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\" = '400' 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" = 'CO' 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" = '400' 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 CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.NTSB CEN11CA517Accident · Serious injuriesData collectionFinal reportKubicek BB85 · Hartsel, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.NTSB CEN11CA520Accident · Serious injuriesData collectionFinal reportCameron Balloons US AX10 · Clark, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.NTSB CEN11CA492Accident · No injuriesData collectionFinal reportCessna 182S · Meeker, COThe pilot's inadvertent flight into a downdraft, which resulted in an in-flight collision with trees.NTSB CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.NTSB CEN11FA465Accident · 1 fatalField investigationFinal reportPipistrel Taurus · Durango, COThe pilot’s loss of control during the off-airport landing in strong winds, which resulted in a hard landing.NTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.NTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.NTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.NTSB CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.NTSB CEN10CA545Accident · Serious injuriesData collectionFinal reportAerospatiale AS 355F1 · Pikes Peak, COThe helicopter's encounter with an unexpected downdraft, which resulted in a hard landing.NTSB CEN10LA380Accident · Minor injuriesLimited investigationFinal reportChampion 8KCAB · Estes Park, COThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB CEN09CA528Accident · No injuriesData collectionFinal reportMorse, Frank L. Kitfox · Crawford, COThe pilot's continued flight into a severe downdraft at low altitude after encountering tailwind over the area.NTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.NTSB CEN09CA159Accident · Serious injuriesData collectionFinal reportCameron Balloons US V-90 · La Junta, COThe pilot's failure to maintain a safe rate of descent during landing. Contributing to the accident was the strong surface winds.NTSB DCA09MA021Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-524 · Denver, COThe captain’s cessation of right rudder input, which was needed to maintain directional control of the airplane, about 4 seconds before the excursion, when the airplane encountered a strong and gusty crosswind that exceeded the captain’s training and…NTSB CEN09FA097Accident · 2 fatalField investigationFinal reportHawker Beechcraft 58P · Stonewall, COThe pilot's inadvertent flight into mountain wave activity resulting in a loss of control and subsequent impact with mountainous terrain.NTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.NTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB DEN08LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Glenwood Spring, COThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was the strong left quartering tailwind and gust.