NTSB investigations, 2003
9 cases where the first occurrence was “Propeller failure/malfunction”.
Cases per year
| 1994 | 6 |
|---|---|
| 1995 | 10 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 10 |
| 2000 | 9 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 9 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 4 |
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 year(c.\"eventDate\") = 2003
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 year(c."eventDate") = 2003 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 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 ATL03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winchester, TNA maintenance personnel failure to follow propeller inspection procedures that resulted in a fatigue failure of a propeller blade and the subsequent forced landing.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 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 LAX03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baker, CAthe separation of a propeller blade tip due to fatigue cracking that resulted from improper maintenance repair procedures.NTSB LAX03LA110Accident · No injuriesLimited investigationFinal reportKolb Firestar · San Diego, CApropeller delamination due to the pilot's failure to properly secure the rear seat shoulder harness prior to flight. A contributing factor was the soft ground in which the airplane landed.NTSB MIA03LA069Accident · No injuriesLimited investigationFinal reportBeech A45 · Merritt Island, FLThe separation of both propeller blades in-flight for undetermined reasons and the failure of the pilot to attain the proper touchdown during the forced landing resulting in overrun during landing and subsequent collapse of the nose landing gear. A…NTSB LAX03FA074Accident · 1 fatalField investigationFinal reportBeech 95 · Rancho Cucamong, CAThe fracture and separation of a propeller blade during cruise flight due to fatigue and corrosion pits in the blade pilot bore, and an improper overhaul of the separated propeller by repair station personnel. Factors contributing to the accident were the…NTSB LAX03LA063Accident · Serious injuriesLimited investigationFinal reportDavis YAK-3 UR-2000 · Parker, AZfailure of the propeller shaft extension mechanism resulting in a loss of power, and the pilot's failure to attain the proper touchdown point.