NTSB investigations: Beech A36, 2006
9 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
| 1965 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 5 |
| 1978 | 8 |
| 1979 | 13 |
| 1980 | 14 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 13 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 12 |
| 1989 | 14 |
| 1990 | 7 |
| 1991 | 10 |
| 1992 | 13 |
| 1993 | 15 |
| 1994 | 10 |
| 1995 | 12 |
| 1996 | 10 |
| 1997 | 7 |
| 1998 | 9 |
| 1999 | 4 |
| 2000 | 10 |
| 2001 | 5 |
| 2002 | 5 |
| 2003 | 16 |
| 2004 | 8 |
| 2005 | 13 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 12 |
| 2009 | 12 |
| 2010 | 9 |
| 2011 | 9 |
| 2012 | 10 |
| 2013 | 11 |
| 2014 | 8 |
| 2015 | 14 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 11 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 12 |
| 2024 | 9 |
| 2025 | 8 |
| 2026 | 6 |
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 year(c.\"eventDate\") = 2006
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 year(c."eventDate") = 2006
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 LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB DEN07LA040Accident · No injuriesLimited investigationFinal reportBeech A-36 · Great Bend, KSThe pilot's spatial disorientation and subsequent loss of aircraft control while changing radio frequencies and abruptly applying control forces in excess of the design limits of the airframe.NTSB ATL06CA131Accident · No injuriesData collectionFinal reportBeech A36 · Macon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing.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 NYC06CA177Accident · No injuriesData collectionFinal reportBeech A36 · Somerville, NJThe pilot's continued flight into known adverse weather.NTSB LAX06LA210Accident · No injuriesLimited investigationFinal reportBeech A36 · Schellville, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB SEA06LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Ennis, MTThe loss of engine power during takeoff due to an excessively lean fuel-to-air mixture ratio as a result of excessive mating surface wear between the mixture control arm and metering shaft. A factor was the improper installation of the new engine, which…NTSB LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.