NTSB investigations: Maule BEE DEE M-4-210

10 cases on aircraft the registry lists as Maule BEE DEE M-4-210. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Maule BEE DEE M-4-210 per year, 1965–2026: 10 cases
1965	1
1968	1
1971	1
1972	1
1973	1
1976	1
1977	1
1997	1
2002	1
2013	1

Where

Open the map

Latest cases

Query with SQL

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 ('5460106')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('5460106'))
  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 ('5460106'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Jun 5, 2013 · N9807M · Substantial damage NTSB DEN03LA022Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Creede, COthe pilot's inadequate compensation for wind. Contributing factors are the crosswind and the pilot's lack of experience.Nov 26, 2002 · N4746T · Substantial damage NTSB ANC97LA149Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Bethel, AKThe pilot's abrupt application of brakes during the landing roll.Sep 15, 1997 · N9804M · Substantial damage NTSB ANC77FAA20Accident · No injuriesClosedMaule M-4 · Fairbanks, AKMay 19, 1977 · N9804M · Substantial damage NTSB ANC76DAG88Accident · No injuriesClosedMaule M-4210 · Talkeetna, AKFeb 7, 1976 · N9804M · Substantial damage NTSB ANC73DAA24Accident · Minor injuriesClosedMaule M4-210 · North Pole, AKMay 31, 1973 · N4617T · Substantial damage NTSB ANC72DAG90Accident · No injuriesClosedMaule M4-210 · Anchorage, AKFeb 11, 1972 · N9804M · Substantial damage NTSB ANC72DAG31Accident · Minor injuriesClosedMaule M4210C · Soldotna, AKJul 10, 1971 · N4738T · Destroyed NTSB SEA69F0041Accident · No injuriesClosedMaule M4-210 · Kalispel, MTJul 3, 1968 · N4738T · Substantial damage NTSB CHI65F0118Accident · Minor injuriesClosedMaule M-4 · Jackson, MIApr 16, 1965 · N4614T · Substantial damage