NTSB investigations, CO
6 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2003 | 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\" = 160)
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" = 160) 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 DEN03LA097Accident · No injuriesLimited investigationFinal reportBell 206B III · Broomfield, COthe student pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB DEN03FA090Accident · 1 fatalField investigationFinal reportHughes 269C · Watkins, COfailure of both pilots to initiate a timely recovery from a practice autorotation. A contributing factor was the instructor's inadequate supervision of the pilot receiving instruction.NTSB FTW98LA168Accident · No injuriesLimited investigationFinal reportBoeing A75N (PT-17) · Grand Junction, COFailure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.NTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.NTSB DEN86LA158Accident · No injuriesLimited investigationFinal reportBeaver Evans VP-1 · Glade Park, COThe plt said that during the take-off roll, high grass restricted the acft from attaining sufficient airspeed to achieve flt. According to the plt the acft struck a barbed wire fence, substantially damaging the acft.NTSB DEN83FTE10Accident · No injuriesFinal reportDouglas DC-3C · Englewood, COThe acft dragged a wing during landing touchdown in IMC weather conditions. The pilot had broken out misaligned with therwy. As the airspeed decayed during the transition from IFR to VFR the co-pilot took control because he thought he couldsee the rwy better.…