# NTSB investigations, 2011: Master cylinder/brake valve

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR11LA205](https://openairdocs.org/ntsb/WPR11LA205.md): Bennett Midjet Mustang I · Ramona, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 2011 · N611JB · Substantial damage
  > The pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.
- [NTSB WPR11FA158](https://openairdocs.org/ntsb/WPR11FA158.md): Cessna 208B · Bakersfield, CA · Accident · No injuries · Field investigation · Final report · Mar 10, 2011 · N930FE · Substantial damage
  > The malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2011
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01023243'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01023243/cases?year=2011

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
