Fatal NTSB investigations: Avions Mudry ET Cie CAP 10B
3 cases on aircraft the registry lists as Avions Mudry ET Cie CAP 10B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1996 | 1 |
|---|---|
| 2000 | 1 |
| 2003 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0950102'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0950102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW03LA173Accident · 1 fatalLimited investigationFinal reportApex CAP 10B · Gladewater, TXThe failure of the left wing, which resulted from progressive compressive fractures in the upper wooden spar cap. Contributing the accident was the difficulty in performing adequate inspections of the spar caps in an attempt to detect the compressive…NTSB MIA00FA172Accident · 2 fatalField investigationFinal reportAvions Mudry ET Cie CAP 10B · Bunnell, FLA midair collision due to the failure of the wingman to maintain proper clearance between his aircraft and the lead aircraft while conducting formation aerobatics and the subsequent loss of control of both aircraft resulting in an uncontrolled descent and…NTSB SEA96FA214Accident · 1 fatalField investigationFinal reportMudry CAP 10B · Fairchild Afb, WAloss of control due to a jammed aileron pushpull tube, due to improper installation/routing of electrical wire bundles through the right aileron bellcrank mechanism by unknown person(s).