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 MIA80FKA05Accident · No injuriesClosedCessna 150 · Rio Grande, PRFeb 23, 1980 · N566PR · Destroyed NTSB MIA80FA030Accident · No injuriesClosedDouglas DC-3 · San Juan, PRJan 28, 1980 · N28346 · 2 aircraft · Substantial damage NTSB MIA80FKA03Accident · No injuriesClosedCessna 336 · Mona Island, PRJan 10, 1980 · N1788Z · Substantial damage NTSB MIA80FKA02Accident · No injuriesClosedCessna 172 · Mona Island, PRDec 9, 1979 · N737ME · Substantial damage NTSB MIA80FKA01Accident · No injuriesClosedCessna 188 · Sabana, PRNov 13, 1979 · N53374 · Substantial damage NTSB MIA79FA116Accident · No injuriesClosedConvair 440 · San Juan, PRAug 25, 1979 · N14478 · Substantial damage NTSB MIA79FA115Accident · 2 fatalClosedCessna 336 · San Juan, PRAug 24, 1979 · N1709Z · Destroyed NTSB MIA79FKA12Accident · Minor injuriesClosedPiper PA-38 · Camuy, PRAug 22, 1979 · N2415G · Destroyed NTSB MIA79FKA11Accident · Serious injuriesClosedBeech B24R · Arecibo, PRAug 9, 1979 · N24678 · Destroyed NTSB MIA79FKA10Accident · No injuriesClosedPiper PA-28 · Mayaguez, PRJul 24, 1979 · N9155J · Destroyed NTSB MIA79FKA08Accident · No injuriesClosedBeech E18S · San Juan, PRJul 13, 1979 · N62B · Destroyed NTSB MIA79FKA06Accident · Minor injuriesClosedCessna 182 · Vieques, PRJun 2, 1979 · N707AB · Destroyed NTSB MIA79FA082Accident · 4 fatalClosedCessna 172M · San Juan, PRMay 13, 1979 · N707AC · Destroyed NTSB MIA79FA084Accident · No injuriesClosedBeech G18S · San Juan, PRMay 11, 1979 · N966YH · Substantial damage NTSB MIA79FKA04Accident · Minor injuriesClosedAerostar 600A · Ponce, PRFeb 25, 1979 · N8077J · Substantial damage NTSB MIA79DKA04Accident · No injuriesClosedPiper PA-28 · San Juan, PRJan 26, 1979 · N7309J · Destroyed NTSB MIA79FKA03Accident · No injuriesClosedCessna A185F · Aguadilla, PRDec 28, 1978 · N9373H · Substantial damage NTSB MIA79DKA02Accident · No injuriesClosedCessna 206 · Vieques, PRDec 1, 1978 · N4615F · Destroyed NTSB MIA79FKA01Accident · Serious injuriesClosedCessna 172 · San Juan, PROct 25, 1978 · N61567 · Substantial damage NTSB DCA78AA024Accident · 6 fatalClosedBeech D18S · San Juan, PRSep 26, 1978 · N500L · Destroyed NTSB MIA78FA120Accident · 2 fatalClosedGrum-Amer AA1A · Toa Baja, PRAug 26, 1978 · N6330L · Destroyed NTSB MIA78FKA06Accident · No injuriesClosedPiper PA-31 · Culebra Is, PRApr 27, 1978 · N6772L · Substantial damage NTSB MIA78FA047Accident · No injuriesClosedDouglas DC-6B · San Juan, PRFeb 24, 1978 · N6103C · Destroyed NTSB MIA78DKA05Accident · Serious injuriesClosedBell UH-1H · Barranquitas, PRFeb 3, 1978 · USA70-16 · Destroyed NTSB MIA78FKA03Accident · No injuriesClosedPiper PA-22 · Arecibo, PRJan 13, 1978 · N5518Z · Substantial damage NTSB MIA78FA027Accident · No injuriesClosedDouglas DC-3 · Rio Grande, PRJan 2, 1978 · N15598 · Substantial damage NTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · Destroyed NTSB MIA78DKA04Accident · No injuriesClosedCessna 172 · Utuado, PRDec 5, 1977 · N2160Y · Substantial damage NTSB MIA78FKA01Accident · Minor injuriesClosedCessna 337 · San Juan, PRNov 10, 1977 · N2194X · Destroyed NTSB MIA77DA070Accident · Serious injuriesClosedBeech 65B80 · Ponce, PRJul 12, 1977 · N99JL · Destroyed NTSB MIA77FA058Accident · No injuriesClosedGrumman G-73 · San Juan, PRMay 17, 1977 · N7338 · Substantial damage NTSB MIA77FA053Accident · No injuriesClosedDouglas DC-3 · San Juan, PRApr 14, 1977 · N28392 · Substantial damage NTSB MIA77DKA05Accident · Minor injuriesClosedPiper PA-23 · San Juan, PRApr 6, 1977 · N5519Y · Destroyed NTSB MIA77FKA06Accident · No injuriesClosedAero Comdr 100 · Lajas, PRApr 3, 1977 · N4037X · Substantial damage NTSB MIA77FKA04Accident · Serious injuriesClosedMooney M20E · Ponce, PRApr 2, 1977 · N6841V · No damage NTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRFeb 17, 1977 · N4046G · Destroyed NTSB MIA77FA028Accident · No injuriesClosedCurtiss C-46A · San Juan, PRFeb 8, 1977 · HI-208 · Destroyed NTSB NYC77IA021Incident · No injuriesClosedBoeing 747 · San Juan, PRDec 12, 1976 · N9664 · Minor damage NTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRDec 12, 1976 · N9954L · Destroyed NTSB MIA77DKA03Accident · Minor injuriesClosedPiper PA-32 · Isla Verde, PRDec 4, 1976 · N3334W · Destroyed NTSB MIA77DKA02Accident · No injuriesClosedGrum Amer AA-1B · Manati, PRNov 9, 1976 · N1492R · Substantial damage NTSB MIA77FKA01Accident · No injuriesClosedGrumman G-164 · Yauco, PRNov 1, 1976 · N460Y · Substantial damage NTSB MIA76DKA08Accident · No injuriesClosedCessna 310 · Vieques, PRSep 29, 1976 · N8010M · Substantial damage NTSB MIA78FKA09Accident · No injuriesClosedPiper PA-28 · Las Marias, PRSep 22, 1976 · N5941U · Destroyed NTSB MIA76DKA06Accident · No injuriesClosedCessna 150L · Moca, PRMay 16, 1976 · N1707Q · Substantial damage NTSB MIA76FKA05Accident · Minor injuriesClosedCessna 411 · San Juan, PRApr 15, 1976 · N73344 · Destroyed NTSB MIA76AM035Accident · No injuriesClosedDouglas DC-6B · San Juan, PROct 20, 1975 · AN-BFO · Substantial damage NTSB NYC76AN034Accident · Serious injuriesClosedBoeing 747 · San Juan, PRSep 15, 1975 · N735PA · No damage NTSB MIA75AM024Accident · Minor injuriesClosedBrittnorm BN-2A · San Juan, PRSep 15, 1975 · N122DW · Substantial damage NTSB MIA76DKA02Accident · No injuriesClosedCessna 188 · Guayama, PRSep 12, 1975 · N3921G · Substantial damage