NTSB investigations, CO
14 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1992 | 1 |
| 1997 | 2 |
| 1999 | 2 |
| 2004 | 1 |
| 2007 | 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\" = 300)
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" = 300) 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 DEN08CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cortez, COThe passenger's inadvertent application of brakes, causing the airplane to nose over on landing. A contributing factor was the pilot's failure top adequately brief the passenger.NTSB DEN04LA144Accident · No injuriesLimited investigationFinal reportAviat A-1 · Greeley, COthe pilot's improper in-flight decision to land on an unimproved surface and the pilot's failure to maintain aircraft control. Contributing to the accident was the soft landing surface.NTSB DEN99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lamar, COThe left brake locked during takeoff roll for undetermined reasons.NTSB DEN99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to maintain control of the aircraft during landing roll.NTSB FTW97LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Arriba, COfailure of the pilot to properly plan the flight and determine the field conditions before landing. The soft runway condition was a related factor.NTSB FTW97LA283Accident · No injuriesLimited investigationFinal reportWonder RV-6 · Franktown, COthe pilot's failure to maintain control of the aircraft during landing roll. A factor was the uneven runway surface.NTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.NTSB DEN87LA106Accident · Minor injuriesLimited investigationFinal reportShort Brothers SC7 · Denver, COThe plt said that he made a normal crosswind landing on rwy 26L at stapleton international arpt, Denver, Colorado. After leaving the rwy and taxiing parallel to the rwy he observed the wind increasing in velocity. He stopped the acft but a strong gust of wind…NTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…NTSB DEN85LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · Erie, COThe plt stated after the accident that she had landed and the acft rolled aprx 600 ft when she attempted to turn off onto the taxiway while the acft was traveling at a moderate speed. A witness stated that he saw the trees 'lock up' as the acft approached the…NTSB DEN84LA114Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Monte Vista, COThe acft landed on a snow covered private airstrip and nosed over. The plt said that the 4 inch deep snow caused the acft to go over on its top.NTSB DEN83LA188Accident · No injuriesLimited investigationFinal reportPitts Special S-1C · Hudson, COAfter arriving, the plt landed the acft on a turf rwy that was still wet due to a heavy rain on the previous day. During the landing roll-out, wet grass & mud accumulated in the main wheel pants. The plt said that the wheels subsequently locked up & the acft…NTSB DEN83LA078Accident · No injuriesLimited investigationFinal reportGulfstream G-164A · Cortez, COThe acft nosed over during landing. According to the pilot the left brake was locked at touchdown. To compensate the pilot applied the right brake. The rapid stopping of the acft caused it to nose over. The braking system was inspected and no reason could be…NTSB DEN82DA071Accident · No injuriesFinal reportCessna 172 · Westcliffe, COThe pilot stated he was taxiing for takeoff when the wind lifted the tail of the aircraft and it nosed over. The wind was reported at 250 degrees, at 15 to 20 KTS.