NTSB investigations: Maule BEE DEE M-4
11 cases on aircraft the registry lists as Maule BEE DEE M-4. 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
| 1967 | 2 |
|---|---|
| 1969 | 1 |
| 1970 | 3 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 2005 | 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 ('5460102'))
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 ('5460102'))
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 SEA05FA180Accident · 1 fatalField investigationFinal reportMaule Bee Dee M-4 · Ritter, ORThe loss of control for an undetermined reason which resulted in a ground collision.NTSB SEA82DA147Accident · Minor injuriesFinal reportMaule BEE DEE M-4 · Yakima, WAThe pilot reported that just as he became airborne, an uncontrollable left roll developed. The left wing contacted the ground and the aircraft cartwheeled. An investigation revealed that the aileron balance and control cables were reversed to the aileron…NTSB MIA78FKJ54Accident · No injuriesClosedMaule M-4 · Brewton, ALNTSB DEN77FA053Accident · 2 fatalClosedMaule M4 · Estes Park, CONTSB LAX75DUG32Accident · No injuriesClosedMaule BD-4 · Big Bear City, CANTSB OAK71DVD21Accident · No injuriesClosedMaule M-4 · Newark, CANTSB CHI71FBJ39Accident · No injuriesClosedMaule M-4 · Ludington, MINTSB CHI70FBJ24Accident · No injuriesClosedMaule M-4 · Charlotte, MINTSB MIA70A0017Accident · 1 fatalClosedMaule M-4 · Lithia, FLNTSB SEA68D0195Accident · No injuriesClosedMaule M-4 · Scappoose, ORNTSB SEA67F0329Accident · No injuriesClosedMaule M-4 · Vancouver, WA