NTSB investigations, CA
8 cases where the first occurrence was “Propeller failure/malfunction”.
Cases per year
| 1994 | 1 |
|---|---|
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 3 |
| 2007 | 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\" = 'CA' 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" = 'CA' 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 LAX07LA078Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Julian, CAThe failure of the propeller to crankshaft attachment bolts due to fatigue. A contributing factor was the improper installation of the propeller assembly by maintenance personnel.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 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 LAX97FA291Accident · 1 fatalField investigationFinal reportHefner Pitts S1S · Van Nuys, CAthe operation of the propeller beyond the design rpm limitations and the resultant gyroscopic loads from aerobatics. Contributing to the accident was the lack of a required instrument panel rpm restriction for the propeller mandated by an airworthiness…NTSB LAX96LA142Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Fremont, CAthe in-flight separation of a portion of one wooden propeller blade due to undetected dry rot in the wood fibers.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 LAX94LA259Accident · Serious injuriesLimited investigationFinal reportMascari Discovery S-12 · Salinas, CAThe failure of the muffler assembly due to preexisting cracking in the oxidized area of the weld, with subsequent damage and separation of the propeller and reduction gear box. A related factor was the excessive taxispeed which resulted in the airplane…