NTSB investigations: Maule M-5-235C, CA
10 cases on aircraft the registry lists as Maule M-5-235C. 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 2009 | 1 |
| 2026 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5460135', '5470010'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5460135', '5470010'))
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 WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CANTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.NTSB LAX99LA045Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Inyokern, CAThe failure of the pilot to maintain control of the aircraft while landing.NTSB LAX95FA046Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Springville, CAthe pilot's entry into a box canyon at an altitude insufficient to maintain clearance from the surrounding terrain and obstacles. Factors in the accident were the high density altitude condition and the steep, rapidly rising nature of the mountainous terrain.NTSB SEA94LA118Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Columbia, CAThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB LAX92LA372Accident · No injuriesLimited investigationFinal reportMaule M5-180C · San Jose, CAThe pilot's misjudged landing flare which resulted in a bounced landing and the pilot's improper recovery from the bounced landing.NTSB LAX81FVG46Accident · No injuriesClosedMaule M5-235 · Redding, CANTSB LAX79FA067Accident · 2 fatalClosedMaule M-5 · Mammoth Lakes, CANTSB LAX78FUA27Accident · No injuriesClosedMaule M-5 · Long Beach, CANTSB OAK78DVM26Accident · No injuriesClosedMaule 235C · San Jose, CA