NTSB investigations, 1995
10 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\") = 1995
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") = 1995 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 LAX96FA049Accident · 1 fatalField investigationFinal reportBeech S35 · Oxnard, CAfailure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…NTSB BFO96LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, VAfailure of the propeller blade due to fatigue cracking originating from corrosion damage. A related factor was the soft terrain encountered during the forced landing.NTSB SEA96LA008Accident · No injuriesLimited investigationFinal reportNord Stampe SV4C · Cottage Grove, ORA propeller blade separation due to inadequate material. The lack of a suitable area for the forced landing was a factor.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.NTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.NTSB LAX95LA314Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Marana, AZthe pilot's poor installation of the propeller which allowed the propeller to become loose, and the pilot's improper emergency procedure by feathering the wrong propeller.NTSB ANC95IA151Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Juneau, AKfailure and separation of the propeller blade due to foreign object damage and fatigue.NTSB DCA95MA054Accident · 8 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Carrollton, GAthe in-flight fatigue fracture and separation of a propeller blade resulting in distortion of the left engine nacelle, causing excessive drag, loss of wing lift, and reduced directional control of the airplane. The fracture was caused by a fatigue crack from…NTSB ANC95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Alsworth, AKAn in-flight separation of a propeller blade, which resulted in a severe vibration, shutdown of the engine, and a forced landing in alder bushes.NTSB NYC95LA137Accident · No injuriesLimited investigationFinal reportField VARI-EZE · Malone, NYfailure of the propeller speed reduction unit due to an inadequate design change by the manufacturer, which resulted in a complete loss of thrust. A factor was the rough terrain.