NTSB investigations: Beech A36, MS
6 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 2005 | 1 |
| 2013 | 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\" = 'MS' 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 ('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 c."eventStateOrRegion" = 'MS' 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 ('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 ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC05LA029Accident · No injuriesLimited investigationFinal reportBeech A36 · Bay St. Louis, MSThe pilot's failure to use the manual emergency landing gear extension mechanism during the approach to land, which resulted in the electrically actuated main landing gear collapsing during the landing roll. A factor associated with the accident is an…NTSB MIA89FA178Accident · 1 fatalField investigationFinal reportBeech A36 · Shelby, MSFailure of the pilot to maintain adequate airspeed while maneuvering back to the runway which resulted in an inadvertentstall. Contributing factors were: failure of the pilot to insure the cabin door (on the passenger's side) was properlyclosed and secured…NTSB ATL85LA093Accident · Minor injuriesLimited investigationFinal reportBeech A36 · New Albany, MSPIC had 1/2 hour check-out in A-36 but over 3900 total flight hours. His 14 hours in this acft was cross country flying. He stated that the fuel was kept evenly didtributed by switching the fuel selector between tanks during the nearly three hour flight. The…NTSB ATL84FA059Accident · 3 fatalField investigationFinal reportBeech A36 · Gulfport, MSPrior to the approach the plt was advised that the wx was sky obscured & visibility 1/4 mi in fog. The plt acknowledged 'roger we'll come on in and give it a shot.' The acft collided with trees about 500 ft short of the middle marker. It was reported that the…NTSB ATL83LA056Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Holly Springs, MSThe acft was at 4,000 ft in cruise flight when the eng failed. The acft crashed 1/4 mi short of an arpt. The right wing bladder was completely torn in two & the left wing bladder contained a minute amount of fuel. There was reportedly a lot of fuel spillage…