NTSB investigations: Beech 76, AZ
5 cases on aircraft the registry lists as Beech 76. 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
| 1993 | 1 |
|---|---|
| 2002 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2009 | 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\" = 'AZ' 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 ('1153005'))
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" = 'AZ' 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 ('1153005'))
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 WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.NTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.NTSB LAX05LA215Accident · Minor injuriesLimited investigationFinal reportBeech BE76 · Glendale, AZthe flight instructor's decision to attempt a single engine go-around with multiple aircraft system failures, and his improper in-flight decision to pass up one airport for landing and continue the flight to the home base airport with known mechanical…NTSB LAX02LA206Accident · No injuriesLimited investigationFinal reportBeech BE76 · Prescott, AZThe student pilot's decision to abort the takeoff with insufficient runway remaining, resulting in a runway overrun and collision with a berm. A factor was the cabin door opening during the takeoff roll.NTSB LAX94LA021Accident · No injuriesLimited investigationFinal reportBeech 76 · Scottsdale, AZthe flight instructor's failure to adequately supervise the flight, follow proper procedures/directives regarding leaning and clearing the idling engine, and his delay in applying power to the idling engine. The fouled spark plugs were a factor in this…