NTSB investigations, CO
7 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 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.\"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\" = 110)
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" = 110) 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 FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.NTSB FTW94LA188Accident · No injuriesLimited investigationFinal reportCessna 182H · Telluride, COWas the pilot's improper recovery from a bounced landing. Factors were gusty winds and runway downslope.NTSB DEN92IA005Incident · No injuriesIncident investigationFinal reportBoeing 747-122 · Denver, COA malfunction in the stabilizer trim control module.NTSB DEN88GA185Accident · 1 fatalFinal reportCessna 182R · Georgetown, CONTSB DEN84LA276Accident · Serious injuriesLimited investigationFinal reportMolino PIK-20 · Calhan, COThe glider struck a barbed wire fence while landing in a pasture. The plt said he encountered a downwash at the edge of a storm that resulted in an 800 fpm rate of descent and forced landing.NTSB DEN84LA150Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Nucla, COPlt stated, 'I made one pass on low boundry spreading 100% of seed and began a climbing left turn to make a pass from high side down east boundry. I reached altitude of approximately 300 ft AGL (above ground level) and attempted to pass over telephone draw…NTSB DEN84IA007Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Pueblo, COThe acft experienced an uncontrolled altitude deviation as a result of encountering cat at 27000 ft. it climbed at 6000 fpm to 3200 ft. the acft was 40 to 50 miles north & slightlybelow the jet core. No turbulence was forecast.