NTSB investigations: Maule M-5-235C, ID
7 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
| 1981 | 1 |
|---|---|
| 1986 | 2 |
| 1992 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2024 | 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\" = 'ID' 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" = 'ID' 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 WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.NTSB WPR21LA212Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Stanley, IDThe pilot’s failure to use carburetor heat in weather conditions conducive to carburetor icing, resulting in a partial loss of engine power and a forced landing during which the airplane struck an object and nosed over.NTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB SEA86FA203Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Grangeville, IDA passenger in the acft reported the plt made more than one pass over 'a salt lick', each time coming closer and closer to the trees. On the last pass the acft 'just fell out of the sky', hit the trees, and landed upside down. Fire broke out almost…NTSB SEA86LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Boise, IDWhile taxiing for takeoff an inadvertant ground loop occurred during which the acft veered left striking another parked acft. The plt stated it felt as though the tailwheel jammed; however, post accident exam failed to disclose any failure/malfunction.NTSB SEA81FA039Accident · 1 fatalClosedMaule M5235C · Dixie, ID