NTSB investigations: Beech A36, MI
11 cases on aircraft the registry lists as Beech A36. 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 |
|---|---|
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2022 | 2 |
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\" = 'MI' 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 ('1151604'))
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" = 'MI' 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 ('1151604'))
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 CEN22LA403Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Houghton Lake, MIA loss of engine power during cruise flight for undetermined reasons.NTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.NTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN11FA417Accident · 2 fatalField investigationFinal reportBeech A36 · Charlevoix, MIThe pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.NTSB CHI06CA201Accident · Minor injuriesData collectionFinal reportBeech A36 · Mason, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush on takeoff. Factors associated with the accident were the building and vehicles that were contacted.NTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.NTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…NTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.NTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.NTSB CHI90FA146Accident · 4 fatalField investigationFinal reportBeech A36 · Gaylord, MIThe pilot's inadequate airspeed, while maneuvering (turning) after takeoff, which resulted in a stall/mush. Factors related to the accident were: the pilot's improper planning/decision, failure to maintain weight and balance limits, and adverse wind…NTSB CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…