NTSB investigations, CO
12 cases where the first occurrence was “Forced landing”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 4 |
| 1999 | 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\" = 180)
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" = 180) 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 DEN00LA006Accident · No injuriesLimited investigationFinal reportKendall/Mckaughlin Rans S-10 Sakota · Hudson, COInadequate preflight planning when the pilot failed to evaluate aircraft performance and weather. Factors were high density altitude, and unsuitable terrain for a forced landing.NTSB DEN99LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Aspen, COThe pilot's inadequate in flight planning. Factors were the high density altitude, the lack of suitable terrain for a forced landing, and the sign post that the right wing impacted.NTSB DEN91FA111Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Colorado Spring, COThe pilot exceeded weight and balance limitations. Factors were: high density altitude and unsuitable terrain.NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB DEN91FA083Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus C · Durango, COThe absence of thermal lift, the pilot's apprehension, and his lack of familiarity with the geographic area.NTSB DEN91FA072Accident · Serious injuriesField investigationFinal reportBeech C23 · Boulder, COInadvertent stall/mush due to the passengers's delay in relinquishing aircraft control, and inadequate supervision of the flight by the pilot in command. Factors were: mixture not leaned, and a high density altitude takeoff with a slight quartering tailwind.NTSB DEN88LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Garfield, COThe plt was ferrying his acft from burlington, NC to kelso, WA. After refueling his acft to capacity (26 gal.), he stayed overnight in lamar, CO. He departed lamar the next morning at 0800. He passed pueblo, CO at 7500 ft., and obtained a wx briefing from the…NTSB DEN87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Steamboat Sprin, CON7494J took off from a high alt arpt and climbed in the vic of the arpt to 9500 feet before proceeding on course. Upon approaching high terrain the plt realized he did not have enough alt to clear the terrain and was in a valley too narrow to turn around. He…NTSB DEN85LA185Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20B · Grand Lake, COOn returning from a 300-kilometer cross-country flight, in a glider the pilot noticed the absence of thermal activity and was forced to land in an open field. The pilot said he landed with a 2-5 knot tailwind and his approach and touchdown speed was too fast.…NTSB DEN85LA143Accident · No injuriesLimited investigationFinal reportCessna 340A · Englewood, COOn may 24, 1985, a Cessna 340, landed gear up off the runway at contennial arpt, Englewood, CO. The single eng ILS apch and 2 eng missed apch was planned. The instructor simulated the loss of the right eng at the outer marker by turning off the fuel supply.…NTSB DEN85LA078Accident · No injuriesLimited investigationFinal reportRaven S55A · Littleton, COThe balloon envelope collided with power lines after dragging the basket & occupants aprx 200 yards along an open fld and through a fence which damaged the basket containing the occupants. The balloon plt said that the wind was only 5 KTS at takeoff but after…NTSB DEN83LA002Accident · No injuriesLimited investigationFinal reportBell 47G3B · Nr. Englewood, COPilot was practicing maneuvers for certification test. He said he made a precautionary landing due to suspected engine trouble and a fire started under the aircraft in the grass. He exited the aircraft but left battery and radio on. This investigation…