Skip to content

NTSB investigations, PR

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA' 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'PR' AND c.\"eventCountry\" = 'USA'
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'PR' AND c."eventCountry" = 'USA'
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 MIA66F0251Accident · Minor injuriesClosedCessna 172E · Cabo Rojo, PROct 10, 1965 · N5462T · Substantial damage NTSB MIA66F0247Accident · No injuriesClosedChampion 7FC · Cabo Rojo, PRSep 22, 1965 · N8909R · Substantial damage NTSB MIA66F0221Accident · No injuriesClosedBeechcraft Dumod · San Juan, PRSep 21, 1965 · N496DM · Substantial damage NTSB MIA66D0201Accident · No injuriesClosedPiper PA-22 · Guayama, PRSep 6, 1965 · N5817Z · Substantial damage NTSB MIA66F0237Accident · No injuriesClosedPiper PA-23 · San Juan, PRAug 23, 1965 · N4325Y · Substantial damage NTSB MIA66F0183Accident · No injuriesClosedPiper PA-24 · Coloso, PRAug 15, 1965 · N7330P · Substantial damage NTSB MIA66F0154Accident · No injuriesClosedMooney M21 · Arecibo, PRAug 13, 1965 · N6840U · Substantial damage NTSB MIA66F0207Accident · No injuriesClosedBeechcraft P-35 · Arecibo, PRJul 20, 1965 · N1489G · Substantial damage NTSB MIA66A0013Accident · 1 fatalClosedCessna 170B · Corozal, PRJul 20, 1965 · N2860C · Destroyed NTSB MIA66F0137Accident · No injuriesClosedCessna 205 · Fajardo, PRJul 4, 1965 · N8131Z · Substantial damage NTSB MIA66F0151Accident · No injuriesClosedBeechcraft C-45H · Mercedita, PRJul 1, 1965 · N496DM · Substantial damage NTSB MIA66F0058Accident · No injuriesClosedBeechcraft C45H · San Juan, PRJun 30, 1965 · N494DM · Substantial damage NTSB MIA65A0118Accident · No injuriesClosedHughes 269B · Anasco, PRJun 12, 1965 · N9395F · Substantial damage NTSB MIA66F0036Accident · No injuriesClosedDe Haviland 114-2A · Ponce, PRJun 4, 1965 · N3999A · Substantial damage NTSB MIA65D0093Accident · No injuriesClosedCessna 172 · Vieques Is, PRMay 4, 1965 · N5408T · Substantial damage NTSB MIA65A0109Accident · No injuriesClosedConvair CV-340 · Ponce, PRApr 27, 1965 · N3412 · Substantial damage NTSB MIA65F0072Accident · Minor injuriesClosedHiller UH12 · Guaynabo, PRApr 26, 1965 · N9795C · Substantial damage NTSB MIA66F0009Accident · No injuriesClosedCessna 310F · Vieques Island, PRApr 15, 1965 · N6763X · Substantial damage NTSB MIA65A0110Accident · No injuriesClosedHughes 269B · Lares, PRApr 3, 1965 · N9395F · Substantial damage NTSB MIA65A0096Accident · 3 fatalClosedPiper PA-22 · Caguas, PRMar 27, 1965 · N9518D · Destroyed NTSB MIA65F0035Accident · No injuriesClosedBeechcraft C45H · San Juan, PRMar 26, 1965 · N494DM · Substantial damage NTSB MIA65A0094Accident · No injuriesClosedHiller UH12E · San Sebastian, PRMar 26, 1965 · N5363V · Substantial damage NTSB MIA65F0128Accident · No injuriesClosedPiper PA-25 · Cabo Rojo, PRMar 16, 1965 · N6878Z · Substantial damage NTSB MIA65F0014Accident · Minor injuriesClosedBeechcraft C-18S · San Juan, PRFeb 15, 1965 · N8025H · Substantial damage NTSB UNK65X1309Accident · No injuriesClosedBeechcraft C18S · Mayaguez, PRJan 18, 1965 · N65432 · Substantial damage NTSB MIA65A0073Accident · No injuriesClosedDouglas DC-8 · San Juan, PRJan 8, 1965 · N8781 · Substantial damage NTSB MIA65D0013Accident · No injuriesClosedBeechraft F35 · Ponce, PRDec 30, 1964 · N3365C · Substantial damage NTSB UNK65X1097Accident · Minor injuriesClosedHughes 269A · Cortada, PRDec 22, 1964 · N9383F · Substantial damage NTSB UNK65X0957Accident · No injuriesClosedPiper PA23 · San Juan, PRDec 9, 1964 · N4082P · Substantial damage NTSB UNK65X0910Accident · No injuriesClosedPiper PA23 · San Juan, PRDec 3, 1964 · N3473P · Substantial damage NTSB UNK65X0751Accident · No injuriesClosedBeechcraft F35 · Arecibo, PRNov 18, 1964 · N3327C · Substantial damage NTSB UNK65X0651Accident · No injuriesClosedCessna 150 · Ramey Afb, PRNov 11, 1964 · N4275U · Substantial damage NTSB UNK65X0627Accident · No injuriesClosedMooney M21 · Fajardo, PRNov 9, 1964 · N7102U · Substantial damage NTSB UNK65X0569Accident · No injuriesClosedBeechcraft C45G · Fajardo, PRNov 5, 1964 · N161U · Substantial damage NTSB UNK65X0552Accident · No injuriesClosedPiper PA28 · Mayaguez, PRNov 4, 1964 · N6051W · Substantial damage NTSB UNK65X0315AccidentClosedCessna 150 · Las Piedras, PROct 18, 1964 · N7995Z · Destroyed NTSB UNK64X4128Accident · No injuriesClosedErcoupe E · Vieques, PRSep 24, 1964 · N94822 · Substantial damage NTSB UNK64X4120Accident · No injuriesClosedDouglas DC-8 · San Juan, PRSep 23, 1964 · N8612 · No damage NTSB UNK64X4104Accident · No injuriesClosedDouglas DC-3 · San Juan, PRSep 22, 1964 · N1549V · Substantial damage NTSB UNK64X4058Accident · Minor injuriesClosedChampion 7FC · Humacao, PRSep 20, 1964 · N8915R · Substantial damage NTSB UNK64X4043Incident · No injuriesClosedConvair CV-340 · San Juan, PRSep 19, 1964 · N3410 · No damage NTSB UNK64X4027Accident · Minor injuriesClosedPiper PA28 · Parguera, PRSep 17, 1964 · N7038W · Destroyed NTSB UNK64X3327Accident · No injuriesClosedPiper PA22 · Yabucoa, PRAug 11, 1964 · N5899Z · Substantial damage NTSB UNK64X2730Accident · No injuriesClosedPiper PA22 · Roosevelt Rds, PRJul 9, 1964 · N3815P · Destroyed NTSB UNK64X2721Accident · No injuriesClosedHiller 12E · San Juan, PRJul 8, 1964 · N5386V · Substantial damage NTSB UNK64X2515Accident · No injuriesClosedBeechcraft K35 · San Juan, PRJun 27, 1964 · N555E · Substantial damage NTSB UNK64X2441Accident · No injuriesClosedPiper PA22 · San German, PRJun 23, 1964 · N5915Z · Substantial damage NTSB UNK64X2275Incident · Minor injuriesClosedBoeing 707 121 · San Juan, PRJun 14, 1964 · N778PA · Minor damage NTSB UNK64X2055Accident · No injuriesClosedPiper PA28 · Lobos Island, PRMay 31, 1964 · N7038W · Substantial damage NTSB UNK64X1943Accident · No injuriesClosedBeechcraft 23 · Lobos Island, PRMay 24, 1964 · N8733M · Substantial damage