Skip to content

NTSB investigations · 92

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 ('3080202') 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 ('3080202')
  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 ('3080202')
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 CHI72FEI46Accident · 1 fatalClosedRepublic RC-3 · Cleveland, OHJun 1, 1972 · N370 · Substantial damage NTSB OAK72FJA03Accident · No injuriesClosedRepublic RC-3 · Kasumiga-Ur, JAFeb 15, 1972 · N114N · Substantial damage NTSB NYC72FNE23Accident · No injuriesClosedRepublic RC-3 · Danbury, CTFeb 1, 1972 · N6111K · Destroyed NTSB OAK72FVW17Accident · Minor injuriesClosedRepublic RC-3 · Las Vegas, NVNov 8, 1971 · N87545 · Destroyed NTSB SEA71FYE31Accident · No injuriesClosedRepublic RC-3-1 · Renton, WAApr 27, 1971 · N6278K · Substantial damage NTSB MIA71DLD33Accident · No injuriesClosedRepublic RC-3 · Winter Haven, FLNov 8, 1970 · N87537 · Substantial damage NTSB LAX71FUA21Accident · No injuriesClosedRepublic RC-3 · Avalon, CAOct 7, 1970 · N87564 · Substantial damage NTSB CHI71FDW04Accident · Serious injuriesClosedRepublic RC-3 · Port Huron, MIJul 11, 1970 · N6465K · Substantial damage NTSB CHI70D0223Accident · No injuriesClosedRepublic RC-3 · Port Austin, MIAug 3, 1969 · N6679K · Substantial damage NTSB MIA70F0163Accident · Serious injuriesClosedRepublic RC-3 · Jacksonville, FLJun 16, 1969 · N6629K · Substantial damage NTSB CHI70D0010Accident · No injuriesClosedRepublic RC-3 · Albany, KYJun 8, 1969 · N6011K · Substantial damage NTSB MIA69D0403Accident · No injuriesClosedRepublic RC-3 · Lake Placid, FLMar 7, 1969 · N87550 · Substantial damage NTSB CHI69A0043Accident · 2 fatalClosedRepublic RC-3 · Lake Erie, OHOct 17, 1968 · N6194K · Destroyed NTSB SEA69D0068Accident · No injuriesClosedRepublic RC-3 · The Dalles, ORJun 30, 1968 · N6272K · Substantial damage NTSB OAK69F0098Accident · Serious injuriesClosedRepublic RC-3 · Sacramento, CAJun 16, 1968 · N6375K · Destroyed NTSB LAX68D0193Accident · No injuriesClosedRebublic RC-3 · Goleta, CAOct 20, 1967 · N6728K · Substantial damage NTSB NYC68A0061Accident · 1 fatalClosedRepublic RC-3 · Ashland, MEOct 18, 1967 · N6569K · Destroyed NTSB UNK67X0158Accident · 1 fatalClosedRepublic RC-3 · Mcneil Lake, CanadaSep 21, 1967 · N6316K · Substantial damage NTSB UNK67X0145Accident · Minor injuriesClosedRepublic RC-3 · Wanapitei Lke, CanadaAug 6, 1967 · N6443K · Substantial damage NTSB MKC68F0112Accident · No injuriesClosedRepublic RC-3 · Nisswa, MNJul 26, 1967 · N6342K · Substantial damage NTSB NYC68F0075Accident · No injuriesClosedRepublic RC-3 · Beaver, PAJul 22, 1967 · N6055K · Substantial damage NTSB NYC68A0001Accident · 5 fatalClosedRepublic RC-3 · Searsport, MEJul 2, 1967 · N6475K · Destroyed NTSB FTW67F0189Accident · No injuriesClosedRepublic RC-3 · Benton, ARAug 28, 1966 · N87515 · Substantial damage NTSB MKC67F0167Accident · No injuriesClosedRepublic RC-3 · Wyoming, MNJul 29, 1966 · N6629K · Substantial damage NTSB MIA67A0005Accident · 2 fatalClosedRepublic RC-3 · Jonesboro, GAJul 9, 1966 · N6697K · Substantial damage NTSB MKC67D0144Accident · No injuriesClosedRepublic RC-3 · Warrensburg, MOJul 2, 1966 · N6438K · Substantial damage NTSB CHI67F0145Accident · Serious injuriesClosedRepublic RC-3 · Walloon Lake, MIJul 2, 1966 · N6339K · Destroyed NTSB MIA66F0500Accident · No injuriesClosedRepublic RC-3 · Fransvilla, FLMar 27, 1966 · N335G · Destroyed NTSB LAX66F0222Accident · No injuriesClosedRepublic RC-3 · Pacoima, CAJan 8, 1966 · N87545 · Substantial damage NTSB FTW66D0333Accident · No injuriesClosedRepublic RC-3 · Fort Worth, TXSep 25, 1965 · N6328K · Substantial damage NTSB NYC66D0184Accident · No injuriesClosedRepublic RC-3 · East Rodman, NYAug 15, 1965 · N6294K · Substantial damage NTSB NYC66F0174Accident · Minor injuriesClosedRepublic RC-3 · Camillus, NYAug 12, 1965 · N6657K · Substantial damage NTSB MKC66D0182Accident · No injuriesClosedRepublic RC-3 · Onamia, MNAug 3, 1965 · N6204K · Substantial damage NTSB CHI66F0127Accident · Minor injuriesClosedRepublic RC-3 · Youngstown, OHAug 1, 1965 · N6175K · Substantial damage NTSB CHI66F0068Accident · No injuriesClosedRepublic RC3 · Gnadenhutten, OHMay 30, 1965 · N87522 · Destroyed NTSB CHI66F0063Accident · No injuriesClosedRepublic RC-3 · Muskegon, MIMay 28, 1965 · N87537 · Substantial damage NTSB MIA65F0060Accident · No injuriesClosedRepublic RC-3 · Georgetown, SCApr 6, 1965 · N6103K · Substantial damage NTSB UNK64X3941Accident · No injuriesClosedRepublic RC3 · Nenana, AKSep 12, 1964 · N6187K · Substantial damage NTSB UNK64X3740Accident · Serious injuriesClosedRepublic RC3 · Eliott Key, FLSep 2, 1964 · N6356K · Destroyed NTSB UNK64X3330Accident · No injuriesClosedRepublic RC3 · Seattle, WAAug 11, 1964 · N6401K · Destroyed NTSB UNK64X2628Accident · No injuriesClosedRepublic RC-3 · Brightsand Lk, CanadaJul 4, 1964 · N6564K · Substantial damage NTSB UNK64X1829Accident · No injuriesClosedRepublic RC3 · Everett, WAMay 18, 1964 · N6728K · Substantial damage

Back to Republic RC-3