Skip to content

NTSB investigations · 96

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 ('1440502') 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 ('1440502')
  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 ('1440502')
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 SEA69F0025Accident · No injuriesClosedBrantly B-2 · Albany, ORJun 13, 1968 · N5963X · Substantial damage NTSB MKC68A0041Accident · No injuriesClosedBrantly B-2A · Gordon, NEDec 23, 1967 · N5918X · Destroyed NTSB NYC68A0058Accident · No injuriesClosedBrantly B-2 · Philadelphia, PAOct 16, 1967 · N2119U · Substantial damage NTSB MKC68A0026Accident · No injuriesClosedBrantly B-2 · Merriman, NESep 28, 1967 · N5988X · Substantial damage NTSB CHI68A0009Accident · Serious injuriesClosedBrantly B2A · Milwaukee, WIJul 19, 1967 · N6794D · Destroyed NTSB NYC68A0005Accident · No injuriesClosedBrantly B-2 · Medford, NJJul 10, 1967 · N5976X · Substantial damage NTSB CHI68F0054Accident · No injuriesClosedBrantly B-2 · Troy, MIJul 3, 1967 · N2127U · Substantial damage NTSB ANC67A0060Accident · No injuriesClosedBrantly B-2 · Chitina, AKJun 5, 1967 · N2132U · Substantial damage NTSB MKC67A0045Accident · Serious injuriesClosedBrantly B-2 · Waverly, NEJan 29, 1967 · N5940X · Destroyed NTSB NYC67A0086Accident · No injuriesClosedBrantly B-2 · Belfast, NYNov 25, 1966 · N5958X · Substantial damage NTSB MIA67A0053Accident · No injuriesClosedBrantly B-2 · Prt Canaveral, FLOct 28, 1966 · N5904X · Substantial damage NTSB ANC67A0042Accident · No injuriesClosedBrantly B-2 · Scotty Creek, AKOct 27, 1966 · N5980X · Substantial damage NTSB MIA67A0021Accident · 1 fatalClosedBrantly B-2 · Charleston Hts, SCAug 4, 1966 · N5943X · Substantial damage NTSB CHI67A0010Accident · No injuriesClosedBrantly B-2 · Washington, ILJul 23, 1966 · N2130U · Destroyed NTSB MKC66A0066Accident · No injuriesClosedBrantly B-2 · N.Platte, NEJun 16, 1966 · N2131U · Substantial damage NTSB MKC66A0051Accident · No injuriesClosedBrantly B-2 · Bismark, NDMar 5, 1966 · N5932X · Substantial damage NTSB OAK66A0036Accident · Minor injuriesClosedBrantly B-2 · Sonoma, CAMar 2, 1966 · N2136U · Substantial damage NTSB MIA66A0074Accident · No injuriesClosedBrantly B-2 · Tampa, FLDec 30, 1965 · N5906X · Substantial damage NTSB SEA66A0030Accident · No injuriesClosedBrantly B-2 · Bigfork, MTNov 3, 1965 · N5991X · Destroyed NTSB MIA66A0051Accident · No injuriesClosedBrantly B-2 · Opa Locka, FLNov 3, 1965 · N5954X · Destroyed NTSB MIA66A0041Accident · 2 fatalClosedBrantly B-2 · Griffin, GAOct 13, 1965 · N5975X · Destroyed NTSB MKC66A0003Accident · Minor injuriesClosedBrantly B-2 · Cedar Rapids, IAJul 13, 1965 · N4990C · Substantial damage NTSB MIA66A0007Accident · Minor injuriesClosedBrantly B2 · Bessemer, ALJul 12, 1965 · N6796D · Destroyed NTSB CHI65A0107Accident · Serious injuriesClosedBrantly B2 · Prophetstown, ILJun 28, 1965 · N2100U · Substantial damage NTSB NYC65A0155Accident · Minor injuriesClosedBrantly B-2 · Bayville Li, NYJun 27, 1965 · N2138U · Substantial damage NTSB SEA65A0065Accident · No injuriesClosedBrantly B-2 · Martha Lake, WAMay 31, 1965 · N5901X · Substantial damage NTSB FTW65A0092Accident · Minor injuriesClosedBrantly B2 · Mustang, OKMar 15, 1965 · N5969X · Destroyed NTSB CHI65A0074Accident · No injuriesClosedBrantly B2 · Franklin, INFeb 14, 1965 · N5933X · Substantial damage NTSB NYC65A0107Incident · No injuriesClosedBrantly B2 · Clinton, MDFeb 12, 1965 · N5973X · Substantial damage NTSB SEA65A0043Accident · No injuriesClosedBrantly B2 · St Mary, MTFeb 8, 1965 · N5967X · Substantial damage NTSB UNK65X1205Accident · No injuriesClosedBrantly B2 · Peck, IDDec 31, 1964 · N5917X · Substantial damage NTSB UNK65X0767Accident · No injuriesClosedBrantly B2 · Muskogee, OKNov 20, 1964 · N5947X · Substantial damage NTSB UNK65X0345Accident · 1 fatalClosedBrantly B2 · Broadwater, NEOct 20, 1964 · N5924X · Destroyed NTSB UNK64X3924Accident · Minor injuriesClosedBrantly B2 · Costa Mesa, CASep 11, 1964 · N5982X · Substantial damage NTSB UNK64X3349Accident · Minor injuriesClosedBrantly B2 · Beaver Falls, PAAug 12, 1964 · N5997X · Substantial damage NTSB UNK64X2693Accident · Serious injuriesClosedBrantly B2 · Quartzsite, AZJul 6, 1964 · N2144U · Substantial damage NTSB UNK64X2136Accident · Serious injuriesClosedBrantly B2 · Okla City, OKJun 5, 1964 · N5907X · Substantial damage NTSB UNK64X2040Accident · No injuriesClosedBrantly B2 · Upland, CAMay 30, 1964 · N5953X · Substantial damage NTSB UNK64X1812Accident · No injuriesClosedBrantly B2 · Manville, NJMay 17, 1964 · N5968X · Substantial damage NTSB UNK64X1774Accident · No injuriesClosedBrantly B2 · Mesa, AZMay 15, 1964 · N2144U · Substantial damage NTSB UNK64X1768Accident · No injuriesClosedBrantly B2 · Bryant, WAMay 14, 1964 · N5900X · Substantial damage NTSB UNK64X1673Accident · Serious injuriesClosedBrantly B2 · Ampton Bays, NYMay 8, 1964 · N5961X · Substantial damage NTSB UNK64X1476Accident · No injuriesClosedBrantly B2 · Thetford, VTApr 26, 1964 · N4997C · Substantial damage NTSB UNK64X0739Accident · No injuriesClosedBrantly B2 · Santa Ana, CAFeb 29, 1964 · N5926X · Substantial damage NTSB UNK64X0642Accident · Serious injuriesClosedBrantly B2A · Tucson, AZFeb 22, 1964 · N2138U · Substantial damage NTSB UNK64X0450Accident · 1 fatalClosedBrantly B2 · Lyons, PAFeb 3, 1964 · N5960X · Destroyed

Back to Brantly B-2