NTSB investigations, CO
5 cases where the first occurrence was “Propeller failure/malfunction”.
Cases per year
| 1995 | 1 |
|---|---|
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 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\" = 131)
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" = 131) 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 DEN03LA120Accident · Serious injuriesLimited investigationFinal reportConn Vans RV-4 · Durango, COpartial propeller blade separation for reasons undetermined, and the pilot's misjudgment of distance and altitude during the forced landing approach that resulted in his overshooting the road on intended landing and colliding with trees. A contributing factor…NTSB DEN00FA092Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Denver, COpropeller blade fatigue failure due to stress corrosion.NTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.NTSB FTW96LA350Accident · Minor injuriesLimited investigationFinal reportHardy Quickie Q-200 · Hudson, COdelamination of a propeller blade. A factor relating to the accident was: the terrain condition in the emergency landing area (soft/sandy berm and ditch).NTSB FTW96FA009Accident · 1 fatalField investigationFinal reportRupe RV-4 · Longmont, COthe installation of an unapproved metal propeller which led to a fatigue failure of a blade and loss of aircraft control.