NTSB investigations
6 cases where NTSB found Grease.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2023 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01071035')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01071035')) 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 CEN23LA429Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Muncie, INA loss of directional control during the landing roll due to the left wheel seizing from insufficient grease in the left wheel bearing.NTSB ANC15LA015Accident · No injuriesLimited investigationFinal reportAirbus AS350 B2 · Anchorage, AKThe failure of the ball bearing within the pitch change spider assembly due to its operation with no grease within the bearing, which resulted in the subsequent fracture of the spider assembly and a loss of tail rotor control authority. Also causal to the…NTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…NTSB WPR13LA132Accident · No injuriesLimited investigationFinal reportCessna T310R · Casper, WYThe separation of the right main gear bracket assembly from its wing attachment fitting due to lack of lubrication of the torque tube bearing.NTSB ERA12IA097Incident · No injuriesIncident investigationFinal reportCessna 560XL · Ocoee, FLWater contamination in the pitch trim actuators.NTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.