NTSB investigations: Beech 77, CA
10 cases on aircraft the registry lists as Beech 77. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2022 | 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\" = 'CA' 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 ('1153007'))
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" = 'CA' 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 ('1153007'))
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 WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.NTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.NTSB LAX02LA089Accident · No injuriesLimited investigationFinal reportBeech 77 · Long Beach, CAA loss of directional control due to the pilot's inadequate compensation for the existing crosswind condition.NTSB LAX01LA168Accident · Minor injuriesLimited investigationFinal reportBeech BE77 · Riverside, CAThe student pilot's failure to maintain appropriate airspeed and to configure the airplane for climb-out.NTSB LAX01LA099Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Auburn, CAA partial loss of engine power during initial takeoff climb due to the formation of carburetor ice. A contributing factor was the pilot's improper pretakeoff actions. A finding was that the improper rigging of the mixture control cable may have precluded…NTSB LAX95LA270Accident · No injuriesLimited investigationFinal reportBeech 77 · Madera, CAThe student pilot's improper compensation for the wind condition and improper use of the rudder. The whirlwind was a factor in this accident.NTSB LAX91LA118Accident · Serious injuriesLimited investigationFinal reportBeech BE-77 · Carmel Valley, CAThe failure of the PIC to supervise a non-certificated pilot and to maintain adequate airspeed with subsequent collision with trees. Contributing to the accident was the failure of the PIC to obtain a weather briefing and assess hazardous wind conditions and…NTSB LAX90LA214Accident · No injuriesLimited investigationFinal reportBeech 77 · Taft, CAThe pilot's improper remedial action. Related to this accident was the pilot's inadvertent encounter with unfavorable winds.NTSB LAX88LA225Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Santa Barbara, CANTSB LAX85LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · San Martin, CAOn a night pleasure flt the afct's alternator went off line. The plt elected to make an immediate landing at the arpt he was overflying rather than flying to a fld which had operating rwy lights. The fld he was over had a plt-controlled lighting system, but…