NTSB investigations, CO
5 cases where the first occurrence was “Gear retraction on ground”.
Cases per year
| 1996 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 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\" = 198)
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" = 198) 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 DEN06LA070Accident · No injuriesLimited investigationFinal reportCessna T-R182RG · Englewood, COthe pilot inadvertently retracting the landing gear.NTSB DEN02LA104Accident · No injuriesLimited investigationFinal reportBeech D95A · Broomfield, COthe dual student pilot's inadvertent retraction of the landing gear. Contributing factors included the dual student's lack of familiarity with the airplane, and inadequate supervision by the flight instructor.NTSB DEN01LA124Accident · No injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Englewood, COthe pilot receiving instruction inadvertently retracting the landing gear during the landing roll. A contributing factor was the flight instructor's inadequate supervision of the pilot receiving instruction.NTSB DEN00FA063Accident · No injuriesField investigationFinal reportDornier 328-100 · Denver, COuncommanded retraction of the nose and right main landing gears during landing roll for reasons undetermined.NTSB FTW96FA198Accident · No injuriesField investigationFinal reportBeech 1900D · Denver, COfatigue failure of the right main landing gear hydraulic actuator rod at the spherical bearing due to a lack of lubrication.