NTSB investigations: Beech 58, NY
7 cases on aircraft the registry lists as Beech 58. 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
| 1979 | 1 |
|---|---|
| 1983 | 2 |
| 1987 | 1 |
| 1991 | 3 |
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\" = 'NY' 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 ('1152740'))
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" = 'NY' 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 ('1152740'))
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 NYC91FA212Accident · 1 fatalField investigationFinal reportBeech 58 · Brookhaven, NYPilot physiological incapacitation which resulted in a loss of control in flight, and an uncontrolled descent into water.NTSB NYC91FA073Accident · 2 fatalField investigationFinal reportBeech BE-58 · Skaneateles, NYThe pilot's loss of situational awareness/disorientation due to the influences of cocaine, which resulted in the loss of airplane control in instrument meteorological conditions. Factors related to the accident were: psychological impairment, fatigue and…NTSB NYC91LA064Accident · 1 fatalLimited investigationFinal reportBeech 58 · Batavia, NYThe failure of the pilot to ensure an adequate amount of fuel was on board for the planned flight which resulted in a double power loss due to the fuel exhaustion.NTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…NTSB NYC83FA253Accident · 1 fatalField investigationFinal reportBeech 58 · Arkville, NYPrior to taking off, the plt advised company personnel that he planned to fly vfr-on-top at 8500 ft MSL. He planned to depart at 1400 EDT, but did not specify his route of flt. When the acft did not arrive, a search was initiated, it was found where it had…NTSB NYC83LA149Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Glens Falls, NYThe acft landed with the wheels up on a dual instructional flight. The flight had been doing air work before returning to glen Falls to continue training with takeoffs and landings. During the 1st landing the acft came over the threshold a little low but it…NTSB NYC79FA025Accident · Serious injuriesClosedBeech 58 · Oneonta, NY