NTSB investigations, ID
12 cases where NTSB found Brake.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 2 |
| 2015 | 2 |
| 2019 | 3 |
| 2022 | 2 |
| 2023 | 1 |
Where
Latest 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\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023242'))
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" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01023242')) 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 WPR24LA027Accident · No injuriesClass 4 · LimitedFinal reportKitfox S5 · Ririe, IDThe pilot’s inadvertent excessive use of brakes which resulted in a nose-over.NTSB WPR22LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna T210R · Stanley, IDThe pilot’s failure to provide adequate braking during a tailwind landing, which resulted in a runway excursion.NTSB WPR22LA217Accident · No injuriesClass 3 · LimitedFinal reportCub Crafters CC19-215 · McCall, IDA loss of directional control during the landing roll due to a fractured brake line fitting on the brake caliper.NTSB GAA20CA004Accident · No injuriesData collectionFinal reportReed Mike Smiths Super CUB · Triangle, IDThe pilot's excessive use of brakes during the landing roll, which resulted in a nose-over.NTSB GAA19CA393Accident · No injuriesData collectionFinal reportCessna A185 · Stanley, IDThe pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA240Accident · No injuriesData collectionFinal reportLuscombe 8 · Orofino, IDThe pilot's improper brake application during the landing roll, which resulted in a nose-over. Contributing to the accident was the pilot's lack of recent experience using heel brakes.NTSB WPR15LA234Accident · No injuriesLimited investigationFinal reportCessna 180J · Dixie, IDThe failure of the right brake hydraulic line during taxi due to fatigue, which caused a loss of hydraulic fluid and rendered the brake inoperative.NTSB WPR15LA218Accident · No injuriesLimited investigationFinal reportDafoe Gerald W Tcow Smith CUB · Cascade, IDA gouge in the right brake master cylinder piston O-ring, which resulted in a loss of brake pressure and reduced effectiveness after landing. Contributing to the accident was the pilot’s decision to operate the airplane with an ongoing brake issue.NTSB WPR12CA322Accident · No injuriesData collectionFinal reportCubCrafters CC 11-160 · Stanley, IDThe pilot’s excessive use of the brakes during the landing roll.NTSB WPR12CA355Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Rexburg, IDThe student pilot's failure to maintain directional control and subsequent excessive braking during the landing roll with a tailwind, which resulted in a noseover.NTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.NTSB LAX08LA217Accident · No injuriesLimited investigationFinal reportLancair LC41-550FG · Hailey, IDThe loss of directional control while taxiing due to the failure of the right brake.