NTSB investigations, CO
15 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 3 |
| 2004 | 2 |
| 2007 | 2 |
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\" = 'CO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 330)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330) 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 DEN07IA144Incident · No injuriesIncident investigationFinal reportNunn KR2 · Pueblo, COThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions . A contributing factor in this accident was the crosswind.NTSB DEN07IA069Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COFracturing of the aircraft windscreens due to impact with foreign object debris. Contributing to the event was the high, gusty surface winds.NTSB DEN05MA029Accident · 3 fatalClass 1 · MajorFinal reportCanadair CL-600-2A12 · Montrose, COthe flight crew's failure to ensure that the airplane’s wings were free of ice or snow contamination that accumulated while the airplane was on the ground, which resulted in an attempted takeoff with upper wing contamination that induced the subsequent stall…NTSB DEN04LA135Accident · No injuriesLimited investigationFinal reportCessna 180 · Buena Vista, COThe pilot's failure to maintain directional control. Contributing to the accident was the gusty winds and the dirt devil encountered by the aircraft.NTSB DEN99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COAn encounter with a sudden tailwind gust windshift during landing roll, resulting in an inadvertent ground loop.NTSB DEN99LA135Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe unforecasted sudden wind change, and the pilot's failure to maintain aircraft control. A factor was the down sloping terrain next to the runway.NTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB FTW98LA003Accident · No injuriesLimited investigationFinal reportCessna 172A · Grand Junction, COEncounter with high gusting winds while standing with the engine runningNTSB FTW95LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-180 · Westcliffe, COThe loss of control due to the encounter with the dust devil.NTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.NTSB DEN88LA211Accident · No injuriesLimited investigationFinal reportCessna 172Q · Broomfield, CONTSB DEN86LA133Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Walsh, COThe plt reports that he was landing to the south on the turf rwy with calm winds when the accident occurred. He said the landing was normal until the acft slowed to 40 to 50 mph at which time a whirlwind was encountered which lifted the right wing. The left…NTSB DEN86LA114Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S-1S · Loveland, COAccording to the plt, the acft encountered a tailwind during the landing roll. The plt said the acft nosed over onto its back when he applied brakes. The plt had indicated his total flt experience in this tail wheel acft to be aprx 4 hrs.NTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.NTSB DEN82DA043Accident · No injuriesFinal reportCessna 172 · Broomfield, COAfter landing the aircraft was taxiing to the ramp when a gust of wind lifted the left wing up and tipped the Cessna over on its back. Wind was gusting over 40 KTS.