NTSB investigations: Beech A36
13 cases on aircraft the registry lists as Beech A36, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 |
|---|---|
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 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 ('1151604')
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\" = 351))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 SEA08LA033Accident · No injuriesLimited investigationFinal reportBeech A36 · El Centro, CAThe failure of maintenance personnel to properly secure the #2 cylinder through bolts. A contributing factor was the lack of suitable terrain for landing.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.NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB LAX04LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAA loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.NTSB CHI04LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Davenport, IAA loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…NTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…NTSB CHI01LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · Sugar Grove, ILthe inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.NTSB NYC00LA125Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Nassawadox, VAA loss of engine power caused by detonation of the #2 piston.NTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…NTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB LAX89LA146Accident · No injuriesLimited investigationFinal reportBeech A36 · Sacramento, CAFailure of the number four piston assembly. A factor related to the accident was: the soft/uneven terrain in the emergency landing area.NTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…