NTSB investigations: Maule M-5-210TC
5 cases on aircraft the registry lists as Maule M-5-210TC. 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
| 1987 | 1 |
|---|---|
| 1994 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2015 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5460140'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5460140'))
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 GAA16CA028Accident · No injuriesData collectionFinal reportMaule M5 · Goodland, KSThe pilot's inadequate crosswind compensation and subsequent loss of directional control during the landing roll, resulting in a runway excursion and nose over.NTSB NYC01LA002Accident · Serious injuriesLimited investigationFinal reportMaule M-5 · Leicester, MAThe pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.NTSB CHI96LA251Accident · No injuriesLimited investigationFinal reportMaule M5-210TC · Olathe, KSthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the uncontrolled porpoise encountered and the pilot's lack of recent experience in tailwheel airplanes.NTSB FTW94LA260Accident · Serious injuriesLimited investigationFinal reportMaule M-5-210TC · Mosca, COThe pilot's failure to attain the proper touchdown point.NTSB DEN87LA238Accident · No injuriesLimited investigationFinal reportMaule M-5-210TC · Moab, UTThe pilot aborted his approach to runway 21 at canyon lands airport when he had 'indications of a crosswind.' The pilot radioed Moab UNICOM and reported he could not find the windsock and requested wind information. Moab UNICOM reported thewind was 'straight…