NTSB investigations: Beech A36, AK
10 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2013 | 1 |
| 2020 | 1 |
| 2021 | 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\" = 'AK' 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" = 'AK' 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 ANC21LA027Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Port Alsworth, AKThe pilot's misidentification of the airport’s active runway, which resulted in an off runway landing and a collision with a snow berm. Contributing to the accident was the runway’s lack of identifying markings.NTSB ANC20CA061Accident · No injuriesClass 4 · Data collectionFinal reportBeech A36 · Chignik Lagoon, AKThe pilot's improper approach, which resulted in a long landing and a runway overrun.NTSB ANC13CA038Accident · No injuriesData collectionFinal reportBeech A36 · Port Alsworth, AKThe failure of the left main landing gear retraction brace assembly, resulting in the collapse of the left main landing gear.NTSB ANC01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-A36 · Nondalton, AKThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB ANC98LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · New Stuyahok, AKThe pilot's failure to extend the landing gear prior to landing. Factors associated with this accident were the pilot's interference with his normal habit pattern, turbulence, and the crosswind condition during landing.NTSB ANC83LA013Accident · No injuriesLimited investigationFinal reportBeech A36 · Fort Yukon, AKDuring a night approach to runway 03 at Fort Yukon, AK, the pilot neglected to activate the runway lights, as prescribed on the jeppeson approach chart, and mistook a row of white lights on buildings as the runway lights. Upon landing on a parking ramp the…NTSB ANC82DA003Accident · Minor injuriesClosedBeech A36 · Quinhagak, AKNTSB ANC80DAG08Accident · No injuriesClosedBeech A36 · Quinhagak, AKNTSB ANC79DAG25Accident · No injuriesClosedBeech 36 · Anchorage, AKNTSB ANC78FA070Accident · 6 fatalClosedBeech A36 · Ketchikan, AK