NTSB investigations: Beech 76
11 cases on aircraft the registry lists as Beech 76, where the first occurrence was “Loss of control - in flight”. 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
| 1988 | 1 |
|---|---|
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1153005')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('1153005')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX07CA174Accident · No injuriesData collectionFinal reportBeech 76 · Pahokee, FLthe flying pilot's inadequate compensation for the known gusty crosswind conditions, and failure to maintain proper alignment with the landing runway.NTSB ATL06CA037Accident · Serious injuriesData collectionFinal reportBeech BE-76 · Hinesville, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with trees.NTSB DFW05FA152Accident · 1 fatalField investigationFinal reportBeech 76 · Conroe, TXThe pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.NTSB LAX02LA139Accident · No injuriesLimited investigationFinal reportBeech 76 · Petaluma, CAThe flight instructor's decision to execute a simulated single engine go-around at an altitude insufficient to preclude the inadvertent ground contact of the airplane and the resultant loss of directional control. The flight instructor's delayed remedial…NTSB MIA00LA089Accident · No injuriesLimited investigationFinal reportBeech 76 · Salisbury, NCThe flight instructors inadequate supervision of a dual student who attempted a go around using one engine which resulted in loss of control and impact with the ground.NTSB FTW99LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE-76 · Mesquite, TXThe flight instructor's inadequate supervision of the multi-engine rated instrument student during a simulated single engine landing, resulting in loss of control of the airplane. Factors were the dark night light condition, the flight instructor's inadequate…NTSB FTW98FA215Accident · 1 fatalField investigationFinal reportBeech 76 · Frisco, TXThe pilot's failure to maintain control resulting in an inadvertent stall while performing simulated single engine maneuvers during a practical test for a multiengine rating.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.NTSB BFO94FA120Accident · 2 fatalField investigationFinal reportBeech 76 · Elizabeth, PA1) The failure of the pilot-in-command (CFI) to provide adequate supervision of the dual student during a simulated single-engine approach, and 2) his failure to perform remedial action. This led to a loss of aircraft control in close proximity to the ground.…NTSB LAX88FA264Accident · 1 fatalField investigationFinal reportBeech 76 · Portola Valley, CAWhile dining with friends with whom he resided, the pilot told them that he was 'going flying'. At the completion of the flight he would fly over the house before he returned to palo alto airport (pao). The pilot twice circled the residence which is abt 7…