NTSB investigations, TX
10 cases where the first occurrence was “Propeller failure/malfunction”.
Cases per year
| 1994 | 1 |
|---|---|
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 2 |
| 2005 | 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\" = 'TX' 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" = 'TX' 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 DFW05CA189Accident · No injuriesData collectionFinal reportRockwell International S-2R · Hamlin, TXThe failure of the propeller blade seal resulting in an oil leak. Contributing factors were the limited forward visibility and lack of suitable terrain for the precautionary landing.NTSB DFW05CA158Accident · Minor injuriesData collectionFinal reportRose Parakeet A-1 · Boyd, TXThe in-flight separation of the outboard section of the propeller for unknown reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA013Accident · Minor injuriesLimited investigationFinal reportPrill RV-6 · Snyder, TXThe failure of the propeller blade for undetermined reason. A contributing factor was the lack of suitable terrain.NTSB FTW03LA171Accident · Minor injuriesLimited investigationFinal reportBoyle Black Eagle BE360 · Celina, TXThe loss of propeller pitch effectiveness for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA005Accident · 2 fatalLimited investigationFinal reportHolt Thorpe T-18C · Imperial, TXthe failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.NTSB FTW00LA242Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Corsicana, TXthe in-flight separation of the propeller blade, which resulted from intergranular corrosion and fatigue cracking.NTSB FTW00LA042Accident · No injuriesLimited investigationFinal reportKing Lancair 235/320 · Sterling City, TXThe fatigue fracture of the propeller attaching bolts, due to improper torque during the installation of the propeller by other maintenance personnel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA025Accident · No injuriesLimited investigationFinal reportMooney M20C · Vernon, TXFatigue cracking of the propeller blade which originated from corrosion pitting on its camber side, resulting in the blade tip separation during cruise flight.NTSB FTW97LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502A · Chesterville, TXan undetermined malfunction/failure of the propeller reversing system.NTSB FTW95LA040Accident · No injuriesLimited investigationFinal reportFighter Escort Wings P-51D · Seymour, TXThe failure of the propeller speed unit. A factor was the lack of suitable terrain for the forced landing.