Skip to content

NTSB investigations · 15

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 ('1151044') 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 ('1151044')
  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 ('1151044')
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 WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.May 12, 2012 · N9540 · Substantial damage NTSB LAX03FA111Accident · 3 fatalField investigationFinal reportBeech 3NM · Anza, CAthe failure of the pilot to maintain an adequate airspeed resulting in a stall and loss of control.Mar 11, 2003 · N14437 · Destroyed NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.Dec 9, 1990 · N9159B · Substantial damage NTSB ANC85LA006Accident · No injuriesLimited investigationFinal reportBeech 3NM · Selawik, AKMaintaining visual separation with other acft, flying a straight-in apch instead of a conventional pattern, and concern over the landing on a short strip interfered with the plt's habit pattern. The gear was not extended and the gear-up landing resulted.Oct 16, 1984 · N9540 · Substantial damage NTSB ATL82FKJ05Accident · No injuriesClosedBeech 3NM · Ohatchee, ALNov 2, 1981 · N16139 · Substantial damage NTSB CHI82FA001Accident · 1 fatalClosedBeech D-18S · Fraser, MIOct 4, 1981 · N6675 · Destroyed NTSB MIA81IA110Incident · No injuriesClosedBeech 3NM · Jacksonville, FLAug 31, 1981 · N9539 · Minor damage NTSB LAX81FJA01Accident · No injuriesClosedBeech 3NM · Hilo, HIOct 1, 1980 · N6620 · Substantial damage NTSB IAD79AA034Accident · Minor injuriesClosedBeech 3NM · Memphis, TNFeb 24, 1979 · N12VT · 2 aircraft · Destroyed NTSB CHI78FA067Accident · No injuriesClosedBeech 18T · Chicago, ILSep 13, 1978 · N12VT · Substantial damage NTSB NYC78FFJ21Accident · No injuriesClosedBeech 3NM · Syracuse, NYMay 23, 1978 · N3127B · Substantial damage NTSB MIA78FA040Accident · 2 fatalClosedBeech D18S · Clewiston, FLFeb 11, 1978 · N80FA · Destroyed NTSB LAX77DUJ17Accident · No injuriesClosedBeech D18S · Yucca, AZOct 26, 1976 · N14437 · No damage NTSB OAK72DVW28Accident · Minor injuriesClosedBeech 3NM · Coso Junctn, CAApr 17, 1972 · N16144 · Substantial damage NTSB CHI72AC072Accident · 1 fatalClosedBeech 3NM · Brook Park, OHMar 15, 1972 · N6133 · Destroyed

Back to Beech 3NM