Skip to content

NTSB investigations · 221

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 ('1151532') 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 ('1151532')
  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 ('1151532')
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 MKC67F0040Accident · No injuriesClosedBeech S35 · Wahpeton, NDJul 12, 1966 · N198Q · Substantial damage NTSB NYC66A0158Accident · 6 fatalClosedBeech S35 · Hyannis, MAJun 26, 1966 · N8838M · Destroyed NTSB DEN67D0018Accident · No injuriesClosedBeech S35 · Gillette, WYMay 26, 1966 · N385CA · Substantial damage NTSB CHI66A0091Accident · 1 fatalClosedBeech S35 · Monticello, ILMay 24, 1966 · N5842S · Destroyed NTSB LAX66F0355Accident · No injuriesClosedBeech S35 · Blythe, CAApr 19, 1966 · N8633Q · Substantial damage NTSB MKC66D0512Accident · No injuriesClosedBeech S35 · Hawarden, IAMar 14, 1966 · N198Q · Substantial damage NTSB NYC66F0501Accident · No injuriesClosedBeechcraft S35 · Windsor Locks, CTFeb 26, 1966 · N2021W · Substantial damage NTSB DEN66D0186Accident · No injuriesClosedBeechcraft S35 · Phoenix, AZDec 4, 1965 · N8944M · Substantial damage NTSB DEN66F0178Accident · No injuriesClosedBeechcraft S35 · Tucson, AZNov 25, 1965 · N8699Q · Substantial damage NTSB NYC66D0328Accident · No injuriesClosedBeechcraft S35 · Flushing, NYOct 20, 1965 · N5826K · Substantial damage NTSB SEA66F0069Accident · No injuriesClosedBeechcraft S-35 · Hailey, IDAug 5, 1965 · N8922U · Substantial damage NTSB FTW66D0100Accident · No injuriesClosedBeechcraft S-35 · Hereford, TXJun 14, 1965 · N5633K · Substantial damage NTSB NYC66D0051Accident · No injuriesClosedBeechcraft S-35 · Aliquippa, PAMay 2, 1965 · N5775K · Substantial damage NTSB SEA65A0056Accident · 2 fatalClosedBeechcraft S35 · Mill City, ORApr 23, 1965 · N6825Q · Destroyed NTSB MKC65F0073Accident · No injuriesClosedBeechcraft S-35 · Donnellson, IAMar 27, 1965 · N7936K · Substantial damage NTSB DEN65F0011Accident · No injuriesClosedBeechcraft S-35 · Cheyenne, WYFeb 4, 1965 · N5877S · Substantial damage NTSB DEN65D0001Accident · No injuriesClosedBeechcraft S-35 · Cody, WYJan 3, 1965 · N182Q · Substantial damage NTSB CHI65D0001Accident · No injuriesClosedBeechraft S-35 · Ft Atkinson, WIJan 2, 1965 · N216Q · Substantial damage NTSB UNK65X0983Accident · No injuriesClosedBeechcraft S35 · Plainfield, KSDec 12, 1964 · N6864Q · Substantial damage NTSB UNK65X0881Accident · 4 fatalClosedBeechcraft S35 · Tacoma, WANov 29, 1964 · N5723K · Destroyed NTSB UNK64X2649Accident · Serious injuriesClosedBeechcraft S35 · Canandaigua, NYJul 4, 1964 · N6839Q · Destroyed

Back to Beech S35