NTSB investigations: Maule M-4-210C, CA
7 cases on aircraft the registry lists as Maule M-4-210C. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1974 | 2 |
| 1984 | 1 |
| 2000 | 1 |
| 2008 | 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 ('5460112'))
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 ('5460112'))
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 SEA08LA087Accident · No injuriesLimited investigationFinal reportMaule M-4 · Bishop, CAA loss of engine power due to foreign object ingestion in the induction system, which resulted in a stuck/jammed exhaust valve during the takeoff.NTSB LAX00FA230Accident · 2 fatalField investigationFinal reportMaule M4-210C · Willows, CAFailure of the pilot to maintain an adequate airspeed margin while maneuvering in steep turns at low altitude in gusty and strong tailwind conditions, which lead to a wind shear encounter and a stall/spin. A contributing factor in the accident was the pilot's…NTSB LAX84LA414Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Jackson, CADuring arrival, the plt observed the wind sock indicating a wind from the west at about 15 KTS. He entered the traffic pattern & landed on rwy 19. After touchdown, the acft encountered a gust of wind, ground looped & went off the right side of the rwy,…NTSB OAK75AP002Accident · 2 fatalClosedMaule M4210C · Kyburz, CANTSB OAK75DXQ04Accident · No injuriesClosedMaule M-4 · Lake Tahoe, CANTSB OAK68D0194Accident · No injuriesClosedMaule M4-210 · Tulelake, CANTSB LAX66F0262Accident · No injuriesClosedMaule M-4 · Lancaster, CA