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.

NTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.Feb 27, 2012 · N3196F · Substantial damageNTSB CEN11CA517Accident · Serious injuriesData collectionFinal reportKubicek BB85 · Hartsel, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.Jul 27, 2011 · N1545T · No damageNTSB 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.Jul 22, 2011 · N2012J · No damageNTSB CEN11CA492Accident · No injuriesData collectionFinal reportCessna 182S · Meeker, COThe pilot's inadvertent flight into a downdraft, which resulted in an in-flight collision with trees.Jul 19, 2011 · N314FR · Substantial damageNTSB CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.Jul 16, 2011 · N731JD · Substantial damageNTSB 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.Jul 8, 2011 · N261T · Substantial damageNTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.Apr 3, 2011 · N3484E · Substantial damageNTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.Apr 2, 2011 · N4914V · Substantial damageNTSB CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.Mar 23, 2011 · N144LP · Substantial damageNTSB CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.Jan 9, 2011 · N727MC · Substantial damageNTSB CEN10CA545Accident · Serious injuriesData collectionFinal reportAerospatiale AS 355F1 · Pikes Peak, COThe helicopter's encounter with an unexpected downdraft, which resulted in a hard landing.Sep 17, 2010 · N5802W · Substantial damageNTSB 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.Jul 8, 2010 · N56BC · Substantial damageNTSB 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.Aug 16, 2009 · N39FM · Substantial damageNTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.Feb 26, 2009 · N737KR · Substantial damageNTSB 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.Jan 31, 2009 · N2097H · Minor damageNTSB 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…Dec 21, 2008 · N18611 · Substantial damageNTSB 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.Dec 21, 2008 · C-GGBT · DestroyedNTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.Nov 2, 2008 · N18338 · Substantial damageNTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.Aug 28, 2008 · N190RV · Substantial damageNTSB 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.Mar 18, 2008 · N67WW · Substantial damage