NTSB investigations: Beech A36, CO
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
| 1973 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1988 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2018 | 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\" = 'CO' 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" = 'CO' 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 CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…NTSB CEN14CA018Accident · No injuriesData collectionFinal reportBeech A36 · Telluride, COThe pilot's decision to take off in gusting tailwinds resulting in exceeding the performance capabilities of the airplane and subsequent loss of control.NTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.NTSB FTW95LA388Accident · No injuriesLimited investigationFinal reportBeech A36 · Broomfield, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain proper alignment with the runway after lift-off. A factor relating to the accident was: the unfavorable wind condition (gusty crosswind).NTSB DEN93FA032Accident · 2 fatalField investigationFinal reportBeech A36 · Englewood, COPower loss due to fuel exhaustion as a result of failing to refuel en route. Factors were: inaccurate fuel consumption calculations, lack of suitable terrain for a forced landing, lack of total experience in the type of aircraft being flown, and becoming lost…NTSB DEN88LA148Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Craig, COWhile on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,…NTSB DEN88FA090Accident · 4 fatalField investigationFinal reportBeech A36 · Colorado Spring, COAfter takeoff the acft failed to climb sufficiently to clear a utility pole one-half mile off the end of the runway. The acft collided with the pole and crashed in a residential street. The plt and three pax were fatally injured and the acft was consumed by…NTSB DEN79FA061Accident · 2 fatalClosedBeech A-36 · Garfield, CONTSB DEN77FTE69Accident · Serious injuriesClosedBeech A-36 · Breckenridge, CONTSB DEN76AD047Accident · 2 fatalClosedBeech A36 · Aspen, CONTSB DEN73DTE60Accident · Minor injuriesClosedBeech A36 · Glenwood Spg, CO