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 MIA68D0434Accident · Minor injuriesClosedCessna 172 · Isabela, PRFeb 23, 1968 · N2670U · Substantial damage NTSB MIA68D0382Accident · No injuriesClosedCessna 150 · Yabucoa, PRJan 27, 1968 · N6412S · Substantial damage NTSB MIA68F0415Accident · No injuriesClosedCessna 150 · Humacao, PRJan 19, 1968 · N4108U · Substantial damage NTSB MIA68F0352Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRJan 3, 1968 · N9447J · Substantial damage NTSB MIA68A0055Accident · No injuriesClosedDehavilland 114 · Mayaguez, PRDec 20, 1967 · N13663 · Substantial damage NTSB MIA68F0333Accident · No injuriesClosedCessna 206 · Toa Baja, PRDec 17, 1967 · N4650F · Substantial damage NTSB MIA68F0279Accident · No injuriesClosedPiper PA-32 · Humacao, PRNov 12, 1967 · N4041W · Destroyed NTSB MIA68D0217Accident · No injuriesClosedPiper PA-22 · San Juan, PROct 14, 1967 · N5611Z · Substantial damage NTSB MIA68A0034Accident · 2 fatalClosedCessna 172 · Isle Culebra, PROct 8, 1967 · N8372U · Destroyed NTSB MIA68F0214Accident · No injuriesClosedPiper PA-23 · Dorado Beach, PROct 3, 1967 · N377DW · Substantial damage NTSB MIA68F0218Accident · No injuriesClosedPiper PA-22 · Humacao, PRSep 23, 1967 · N5278Z · Substantial damage NTSB MIA68D0215Accident · No injuriesClosedBeech B35 · Fajardo, PRSep 11, 1967 · N5129C · Destroyed NTSB MIA68F0160Accident · No injuriesClosedCessna 172 · Salinas, PRSep 6, 1967 · N2160Y · Substantial damage NTSB MIA68F0158Accident · No injuriesClosedPiper PA-25 · Vega Baja, PRAug 21, 1967 · N13314 · Substantial damage NTSB MIA68A0012Accident · Minor injuriesClosedChampion 7ECA · Vega Baja, PRJul 25, 1967 · N9671S · Destroyed NTSB MIA68A0007Accident · No injuriesClosedBeech C-45H · Ponce, PRJul 13, 1967 · N9978Z · Substantial damage NTSB MIA68F0057Accident · No injuriesClosedCessna 310 · San Juan, PRJul 5, 1967 · N2668C · Substantial damage NTSB MIA68A0002Accident · 4 fatalClosedPiper PA-28 · Mayaguez, PRJul 2, 1967 · N5100W · Destroyed NTSB MIA67A0127Accident · No injuriesClosedHughes 269B · San Sebastian, PRMay 31, 1967 · N9395F · Substantial damage NTSB MIA67D0533Accident · No injuriesClosedCessna 150 · Guanica, PRMay 9, 1967 · N3159X · Substantial damage NTSB MIA67F0500Accident · No injuriesClosedCessna 150 · San Juan, PRApr 28, 1967 · N8470G · Substantial damage NTSB MIA67F0493Accident · No injuriesClosedPiper PA-23 · Isabel Segunda, PRApr 28, 1967 · N5632Y · Substantial damage NTSB MIA67A0112Accident · Minor injuriesClosedConvair 640D · San Juan, PRApr 25, 1967 · N3420 · Substantial damage NTSB MIA67A0107Accident · No injuriesClosedBeech C-45G · Arecibo, PRMar 19, 1967 · N9470Z · Destroyed NTSB MIA67F0425Accident · Minor injuriesClosedPiper PA-28 · Fajardo, PRMar 1, 1967 · N8080W · Substantial damage NTSB MIA67D0397Accident · No injuriesClosedCessna 172 · Cabo Rojo, PRFeb 18, 1967 · N7824X · Substantial damage NTSB MIA67F0361Accident · No injuriesClosedPiper PA-28 · San Juan, PRJan 23, 1967 · N6351R · Substantial damage NTSB MIA67A0080Accident · Minor injuriesClosedConvair 640 · San Juan, PRJan 23, 1967 · N3408 · Substantial damage NTSB MIA67F0370Accident · No injuriesClosedPiper PA-28 · Arecibo, PRJan 15, 1967 · N9439J · Substantial damage NTSB MIA67F0354Accident · Minor injuriesClosedPiper PA-32 · San Juan, PRDec 29, 1966 · N3712W · Substantial damage NTSB MIA67F0325Accident · No injuriesClosedBeech D18S · San Juan, PRDec 20, 1966 · N703D · Substantial damage NTSB MIA67D0318Accident · No injuriesClosedDehavilland 114 · San Juan, PRNov 23, 1966 · N3999A · Substantial damage NTSB MIA67D0240Accident · No injuriesClosedBeech 95 · Salinas, PROct 24, 1966 · N2711V · Substantial damage NTSB MIA67F0249Accident · No injuriesClosedCessna 180 · San Juan, PROct 20, 1966 · N4610A · Substantial damage NTSB MIA67F0236Accident · No injuriesClosedPiper PA-30 · San Juan, PROct 7, 1966 · N7446Y · Substantial damage NTSB MIA67A0019Accident · Minor injuriesClosedDehavilland 114 · San Juan, PRAug 3, 1966 · N4789C · Substantial damage NTSB MIA67A0017Accident · Minor injuriesClosedCessna 205 · Culebra, PRJul 26, 1966 · N8405Z · Substantial damage NTSB MIA67F0120Accident · No injuriesClosedPiper PA-30 · San Juan, PRJul 17, 1966 · N7298Y · Substantial damage NTSB MIA66A0006Accident · No injuriesClosedHughes 269B · Arecibo, PRJul 13, 1966 · N9395F · Substantial damage NTSB MIA66D0631Accident · No injuriesClosedCessna 150 · Humacao, PRJun 20, 1966 · N4108U · Substantial damage NTSB MIA66D0613Accident · No injuriesClosedAeronca 7ECA · Manati, PRJun 9, 1966 · N2531F · Substantial damage NTSB MIA66A0141Accident · No injuriesClosedHughes 269B · Anasco, PRJun 8, 1966 · N9407F · Substantial damage NTSB MIA67F0019Accident · No injuriesClosedBeech 95-B55 · Arecibo, PRMay 3, 1966 · N351RR · Substantial damage NTSB MIA66F0524Accident · No injuriesClosedCessna 150 · San Juan, PRApr 18, 1966 · N8831S · Destroyed NTSB MIA66A0110Accident · Minor injuriesClosedAir Space 18A · Santa Isabel, PRMar 20, 1966 · N6112S · Destroyed NTSB MIA66A0105Accident · No injuriesClosedCessna 310F · San Juan, PRMar 13, 1966 · N6763X · Substantial damage NTSB MIA66A0089Accident · 3 fatalClosedCessna 172F · Palmer, PRFeb 15, 1966 · N7848U · Destroyed NTSB MIA66F0416Accident · Minor injuriesClosedCessna 172 · San Juan, PRFeb 5, 1966 · N8523U · Substantial damage NTSB MIA66D0360Accident · No injuriesClosedPiper PA-28 · La Parguera, PRDec 10, 1965 · N5417W · Substantial damage NTSB MIA66F0321Accident · No injuriesClosedBeechcraft C-45H · San Juan, PRNov 12, 1965 · N493DM · Substantial damage