NTSB investigations: Beech A36
9 cases on aircraft the registry lists as Beech A36, where NTSB found Low ceiling. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2015 | 1 |
| 2022 | 2 |
Where
Latest 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 ('1151604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '03035010')))
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 ('1151604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '03035010')))
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 ERA23FA048Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Harlan, KYThe pilot’s visual flight rules flight into instrument meteorological conditions during an approach to land at an airport in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s hazardous…NTSB ERA23FA006Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Arundel, METhe pilot’s loss of situational awareness, which resulted in an unstabilized approach, descent below published minimum altitudes, and collision with terrain.NTSB ERA15FA254Accident · 3 fatalField investigationFinal reportBeech A36 · Plainville, MAThe total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.NTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.NTSB CEN13FA006Accident · 4 fatalField investigationFinal reportBeech A36 · Mabank, TXThe pilot's loss of airplane control while maneuvering in instrument meteorological conditions.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 CEN10FA320Accident · 2 fatalField investigationFinal reportBeech A36 · Lidderdale, IAThe pilot's decision to initiate the flight in marginal weather conditions and his loss of aircraft control.NTSB ERA09FA514Accident · 1 fatalField investigationFinal reportBeech A36 · Flat Rock, NCThe pilot’s attempt to maintain visual flight during instrument meteorological conditions, resulting in controlled flight into mountainous terrain. Contributing to the accident was the pilot’s failure to advise the controller of the weather conditions…NTSB LAX08FA300Accident · 1 fatalField investigationFinal reportBeech A36 · Carlsbad, CAThe pilot's failure to maintain control during the instrument approach and attempted go-around.