Skip to content

NTSB investigations · 35

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 ('1152806') 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 ('1152806')
  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 ('1152806')
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 LAX00LA064Accident · No injuriesLimited investigationFinal reportBeech 65-80 · Mesa, AZThe collapse of a main landing gear due to damage from a hard landing at an undetermined time.Dec 26, 1999 · N184R · Substantial damage NTSB NYC98LA125Accident · Serious injuriesLimited investigationFinal reportBeech BE 65-80 · Malone, NYThe pilot's failure to follow emergency procedures, and his failure to maintain control of the airplane after a loss of power from one engine. Factors include fuel filter blockage, inadequate maintenance, and the pilot's lack of experience in multi-engine…Jun 5, 1998 · N215AB · Destroyed NTSB FTW87FA045Accident · No injuriesField investigationFinal reportBeech 65-80 · Brownsville, TXCommercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…Jan 15, 1987 · N1590S · Substantial damage NTSB MIA84FA163Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Opa Locka, FLThe plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel…May 8, 1984 · N741H · Substantial damage NTSB MIA83FA235Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Miami, FLSeveral days prior, a fam flt was intended in the acft to be given to the plt by another person who represented himself as a plt. The flt was cancelled due to a problem with the left eng. On the day of the accident, the other person told the plt that the eng…Sep 19, 1983 · N55ED · Destroyed NTSB ATL83LA092Accident · Minor injuriesLimited investigationFinal reportBeech 65-80 · Brodnax, VAThe acft was damaged during a landing in a field at night near the intersection of route 623 & route 53 north. After the accident, 2 individuals were observed leaving the acft & running into the woods with duffel bags. The acft contained aprx 1000 lbs of…Jan 31, 1983 · N2711J · Substantial damage NTSB MIA80FLD96Accident · No injuriesClosedBeech 65-B80 · Lake Marion, FLSep 7, 1980 · N242Q · Destroyed NTSB MIA80DA094Accident · 1 fatalClosedBeech 65-80 · Pt.Maria (Gulf of Mexico)Aug 25, 1980 · N218K · Destroyed NTSB MIA80FLD52Accident · Serious injuriesClosedBeech 65-80 · Sebring, FLApr 6, 1980 · N717Q · Destroyed NTSB LAX80FJA01Accident · No injuriesClosedBeech 65-80 · Princeville, HIOct 5, 1979 · N1590S · Substantial damage NTSB IAD79IA066Incident · No injuriesClosedBeech 65-80 · Washington, DCAug 7, 1979 · N99FA · Minor damage NTSB CHI79FA038Accident · 1 fatalClosedBeech 65-80 · Wheeling, ILMar 29, 1979 · N723Q · Destroyed NTSB FTW79DA061Accident · 2 fatalClosedBeech 65-A80 · New Orleans, LAMar 11, 1979 · N10QH · Substantial damage NTSB DEN79FA005Accident · 4 fatalClosedBeech 65-80 · Torreon, NMOct 24, 1978 · N886G · Destroyed NTSB MIA78FA100Accident · 1 fatalClosedBeechcraft 65-80 · Mobile, ALJun 27, 1978 · N975SQ · Destroyed NTSB MIA78FLG13Accident · No injuriesClosedBeech 65-80 · Columbia, SCMar 22, 1978 · N3YY · Substantial damage NTSB OAK78FVD06Accident · No injuriesClosedBeech 65-80 · Concord, CAOct 26, 1977 · N711DE · Substantial damage NTSB MIA77FA080Accident · 3 fatalClosedBeech 65-80 · Vancleave, MSAug 13, 1977 · N6DG · Destroyed NTSB MIA7LDLD77Accident · No injuriesClosedBeech 65-80 · Lake Placid, FLAug 15, 1976 · N345X · Destroyed NTSB DEN76FQA07Accident · No injuriesClosedBeech 65-80 · Santa Fe, NMJul 31, 1975 · N716AG · Substantial damage NTSB MIA76FLD68Accident · No injuriesClosedBeech 65-80 · Clearwater, FLApr 22, 1975 · N6811Q · Substantial damage NTSB IAD75FIJ06Accident · No injuriesClosedBeech 65-80 · Charleston, WVAug 1, 1974 · N242Q · Substantial damage NTSB MIA74FLA28Accident · No injuriesClosedBeech 65-80 · Crestview, FLDec 5, 1973 · N741H · Substantial damage NTSB FTW73AF033Accident · 4 fatalClosedBeech 65-80 · Kent, TXDec 29, 1972 · N9867 · Destroyed NTSB MKC72FER45Accident · No injuriesClosedBeech 65-80 · Mankato, MNMar 26, 1972 · N270D · Substantial damage NTSB MKC70A0035Accident · 1 fatalClosedBeech 65-80 · Republic, MODec 21, 1969 · N1539S · Destroyed NTSB MIA70D0013Accident · No injuriesClosedBeech 65-80 · Ft.Meyers, FLMay 27, 1969 · N366Q · Substantial damage NTSB OAK69D0203Accident · No injuriesClosedBeech 65-80 · Fresno, CADec 19, 1968 · N6800Q · Substantial damage NTSB CHI69A0044Accident · 3 fatalClosedBeech 65-80 · Houghton, MIOct 23, 1968 · N303D · Destroyed NTSB DEN68F0168Accident · Serious injuriesClosedBeech 65-80 · Salt Lake City, UTDec 9, 1967 · N814B · Destroyed NTSB OAK68F0253Accident · No injuriesClosedBeech 65-80 · Sacramento, CANov 22, 1967 · N716AG · Substantial damage NTSB DEN67F0191Accident · No injuriesClosedBeech 65-80 · Farmington, NMJan 16, 1967 · N380C · Substantial damage NTSB MIA67F0162Accident · No injuriesClosedBeech 65-80 · Merritt Isl., FLSep 8, 1966 · N601F · Substantial damage NTSB UNK64X3971Accident · No injuriesClosedBeechcraft 65-80 · Seward Afb, TNSep 13, 1964 · N6811Q · Substantial damage NTSB UNK64X1655Accident · No injuriesClosedBeech A35 · Bristow, OKMay 7, 1964 · N576B · Substantial damage

Back to Beech 65-80