NTSB investigations, CO

5 cases where the first occurrence was “Undetermined”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations, CO per year, 1985–2026: 5 cases
1985	1
1991	1
1992	2
2005	1

Where

Open the map

Latest cases

Query with SQL

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" = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 400)
  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" = 400)
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 DCA05IA072Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2D15 · colorado spring, COUndetermined.Jun 10, 2005 · CGJAZ · No damage NTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.Dec 2, 1992 · N2751G · Substantial damage NTSB DEN92LA043Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COUndetermined.Mar 18, 1992 · N66076 · Substantial damage NTSB DEN91LA059Accident · No injuriesLimited investigationFinal reportBeech A36 · Salida, COThe dual student's poor takeoff technique, his failure to maintain directional control, and inadequate supervision by the PIC CFI. A factor was: the dual student's lack of experience in mountain flying.Apr 6, 1991 · N4595S · Substantial damage NTSB DEN86FTE02Accident · 1 fatalFinal reportBeech 58 · Elbert, COThe acft crashed in a open field & was not found for 4 days. The home built acft, maintained largely by the plt, had the engine destroyed so completely that no determination could be made as to power being developed at impact. The plt reportedly had been…Nov 2, 1985 · N26BW · Destroyed