Skip to content

NTSB investigations · 25

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 ('1152506') 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 ('1152506')
  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 ('1152506')
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 MIA02LA130Accident · No injuriesLimited investigationFinal reportBeech B50 · Clanton, ALThe pilot's failure to maintain directional control of the airplane during an aborted landing that resulted in a ground swerve and the airplane exiting the runway and collided with a fence, incurring damage.Jul 7, 2002 · N550G · Substantial damage NTSB BFO89FA069Accident · 3 fatalField investigationFinal reportBeech B50 · Church Creek, MDVFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.Aug 23, 1989 · N3688B · Destroyed NTSB ATL85FA085Accident · 3 fatalField investigationFinal reportBeech B-50 · Edgewood, KYDuring a VFR flt from london, KY, to detroit, MI, the acft crashed into a single family home while attempting a landing at cvg arpt. The plt reported a right eng pwr loss, from suspected impact ice. The alternate air source did not change the acft…Jan 31, 1985 · N3669B · Destroyed NTSB ANC83LA011Accident · No injuriesLimited investigationFinal reportBeech 50 · Quinhagak, AKLeft engine lost power after takeoff. Pilot feathered left engine and returned to runway on one engine. Since he was overshooting he elected to land on grass wheels up to avoid overrun and collision with ditch. The following discrepancies were found: exhaust…Nov 3, 1982 · N3582B · Substantial damage NTSB ANC81DA114Accident · 5 fatalClosedBeech B50 · Cape Yakataga, AKSep 13, 1981 · N3580B NTSB MIA75DLD44Accident · Minor injuriesClosedBeech B50 · Tampa, FLDec 25, 1974 · N4862T · Substantial damage NTSB DEN75FTM02Accident · No injuriesClosedBeech B50 · Salt Lake City, UTJul 20, 1974 · N415T · Substantial damage NTSB UNK72X0109Accident · Serious injuriesClosedBeech 50 · Elk Is, CanadaJun 24, 1972 · N3674B · Destroyed NTSB NYC72FIG19Accident · No injuriesClosedBeech B50 · Petersburg, WVFeb 12, 1972 · N3749B · Substantial damage NTSB FTW71FRA06Accident · Minor injuriesClosedBeech B50 · Friendswood, TXJul 18, 1970 · N41U · Substantial damage NTSB CHI70F0389Accident · Minor injuriesClosedBeech B50 · Terre Haute, INDec 30, 1969 · N3678B · Substantial damage NTSB LAX70D0221Accident · No injuriesClosedBeech B50 · Riverside, CANov 23, 1969 · N3670B · Substantial damage NTSB FTW68F0326Accident · No injuriesClosedBeech B50 · Mcallen, TXNov 3, 1967 · N3674B · Substantial damage NTSB DEN67D0245Accident · No injuriesClosedBeech B50 · Hobbs, NMApr 11, 1967 · N3577B · Substantial damage NTSB SEA67F0274Accident · No injuriesClosedBeech B50 · Wenatchee, WAApr 3, 1967 · N104W · Substantial damage NTSB MIA67F0406Accident · No injuriesClosedBeech B50 · Atlanta, GAJan 22, 1967 · N85TM · Substantial damage NTSB MIA67F0295Accident · No injuriesClosedBeech B50 · Nashville, TNNov 22, 1966 · N3665B · Substantial damage NTSB DEN67D0007Accident · No injuriesClosedBeech B50 · Hobbs, NMJun 17, 1966 · N3577B · Substantial damage NTSB CHI66F0741Accident · No injuriesClosedBeech B-50 · Cascade, MIApr 29, 1966 · N3571B · Substantial damage NTSB MIA66F0495Accident · No injuriesClosedBeech B50 · Jackson, MSApr 6, 1966 · N3570B · Substantial damage NTSB CHI66F0653Accident · Serious injuriesClosedBeech B50 · Waukegan, ILFeb 1, 1966 · N3660B · Destroyed NTSB MKC66F0110Accident · No injuriesClosedBeechcraft B-50 · Emporia, KSJul 25, 1965 · N3597B · Substantial damage NTSB LAX65D0043Accident · Minor injuriesClosedBeechcraft B50 · Coso Junction, CAFeb 24, 1965 · N3568B · Substantial damage NTSB UNK65X1278Accident · No injuriesClosedBeech B50 · Las Vegas, NVJan 12, 1965 · N3697B · Substantial damage NTSB UNK65X0539Accident · No injuriesClosedBeechcraft B50 · Waynesburg, PANov 3, 1964 · N3561B · Substantial damage

Back to Beech B50