Skip to content

NTSB investigations · 24

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1152808') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1152808')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1152808')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA94WA136Accident · 4 fatalForeign investigationBeech BE65-A80 · Moca, Dominican RepublicMay 10, 1994 · N8021Q · Destroyed NTSB LAX86FVM03Accident · No injuriesFinal reportBeech 65-A80 · Cuyama, CAThe acft contacted two cows while operating along the side of a road in a remote area. Vehicle tracks were found near the wreckage, however, no persons were found at or near the wreckage. Trained drug sniffing dogs were used at the accident site and it is…Mar 21, 1986 · N29DS · Substantial damage NTSB MIA86LA011Accident · No injuriesLimited investigationFinal reportBeech 65A-80 · Ochopee, FLWhile on a night pleasure flt, both engs surged and lost pwr and an emergency landing was made. The plt stated that he had a total of 3 hrs flt time in this type of acft. He later recanted his statement & stated that he had never flown this type acft before.…Oct 12, 1985 · N8000R · Substantial damage NTSB DCA85AA012Accident · 9 fatalFinal reportBeech 65-A80 · Soldotna, AKDuring arrival, the crew of npa flt 1802 contacted the company wx observer at Soldotna who advised the wx was: wnd calm,ceiling 600 to 800 ft, vis 8 to 10 mi, no precip. They made an NDB apch, but missed the apch & requested another apch. Aprx 1 min later,…Feb 4, 1985 · N50NP · Destroyed NTSB ATL84FKG01Accident · Minor injuriesFinal reportBeech 65-A80 · Edison, GAAt aprx 2130 EDT, the acft collided with a tree while the plt was making a low pass over a wooded area. After hitting the tree, the plane crashed into a pond. Reportedly, the acft had returned from columbia (south america) & the aircrew were preparing to drop…Oct 13, 1983 · N62TG · Substantial damage NTSB LAX81DXQ21Accident · No injuriesClosedBeech 65-80 · Gerlach, NVJul 17, 1981 · N6867Q · Destroyed NTSB DCA81AA017Accident · 3 fatalClosedExcalibur 65-A80 · Madisonville, TXJul 2, 1981 · N100UV · Destroyed NTSB MIA81FA088Accident · No injuriesClosedBeech 65-80 · St.Croix, VIJun 26, 1981 · N314Q · Substantial damage NTSB OAK79IA023Incident · No injuriesClosedBeech 65-A80 · San Francisco, CAApr 17, 1979 · N978Q · Minor damage NTSB OAK78DA053Accident · No injuriesClosedBeech 65A-80 · Columbia, CASep 15, 1978 · N978Q · Substantial damage NTSB MIA78FKT77Accident · 1 fatalClosedBeech 65-A80 · South Bay, FLSep 4, 1978 · N44SG · Destroyed NTSB UNK78X0112Accident · No injuriesClosedBeech 80 · Indian Hbr, CanadaMar 27, 1978 · N28BL · Substantial damage NTSB ANC78DA006Accident · No injuriesClosedBeech 65-A80 · Allakaket, AKDec 23, 1977 · N140RH · Substantial damage NTSB MIA76FKJ40Accident · No injuriesClosedBeech 65-80 · Birmingham, ALDec 31, 1975 · N1110P · Substantial damage NTSB NYC74AN034Accident · 2 fatalClosedBeech 65-A80 · Cincinnati, OHOct 25, 1973 · N6875Q · Destroyed NTSB NYC73AN132Accident · 6 fatalClosedBeech 65-A80 · Bricktown, NJApr 16, 1973 · N456WM · Destroyed NTSB NYC73DIJ12Accident · No injuriesClosedBeech 65-A80 · Ceredo, WVDec 11, 1972 · N314Q · Substantial damage NTSB MIA72IM144Incident · No injuriesClosedBeech 65-A80 · Columbia, SCJun 27, 1972 · N32TM · Minor damage NTSB MIA72FKJ31Accident · No injuriesClosedBeech 65-A80 · Birmingham, ALNov 13, 1971 · N277Q · Substantial damage NTSB LAX71FUG58Accident · No injuriesClosedBeech 65-A80 · Ontario, CAMar 15, 1971 · N456WM · Substantial damage NTSB CHI70AC060Accident · 1 fatalClosedBeech 65-A80 · Wheeling, ILMar 25, 1970 · N242U · Destroyed NTSB NYC70FFM05Accident · No injuriesClosedBeech 65-A80 · Danbury, CTFeb 14, 1970 · N312PE · Substantial damage NTSB CHI67F0653Accident · Minor injuriesClosedBeech 65-A80 · Rhinelander, WIApr 13, 1967 · N314Q · Substantial damage NTSB NYC66F0035Accident · No injuriesClosedBeechcraft 65-A80 · Teterboro, NJJun 12, 1965 · N312PE · Substantial damage

Back to Beech 65-A80