NTSB investigations: Maule M-5-235C
7 cases on aircraft the registry lists as Maule M-5-235C, where the first occurrence was “Hard landing”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2001 | 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 ('5460135', '5470010')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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 ('5460135', '5470010')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.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 NYC91LA008Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Moscow, PAA hard landing due to the failure of the pilot to properly arrest his descent rate and the failure of the flight instructor to adequately monitor the actions of the pilot.NTSB ANC88LA144Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Porcupine Butte, AKThe plt rprtd he landed harder than he intended from about 3 to 5 ft above the ground. The right main gear collapsed & the acft veered to the right. Subsequently, the left main gear collapsed & the acft came to rest off the airstrip.NTSB NYC84DNC04Accident · No injuriesFinal reportMaule M-5-235C · Millinocket Lke, METhe acft was landed hard on the glassy smooth surface of a lake. The plt admitted that the landing was hard and that after the touchdown the left float split open and the acft sank in 40 ft of water. Witnesses stated that the lake surface was calm and smooth…NTSB SEA82DA100Accident · No injuriesFinal reportMaule M-5-235C · Mt. Vernon, WAThe purpose of the flight was dual training for short field obstacle landings. On the third approach, a delayed flare resulted in a hard landing and gear collapse.