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 MIA76AM023Accident · Minor injuriesClosedBoeing 747 · San Juan, PRSep 8, 1975 · N9655A · Substantial damage NTSB MIA76AM019Accident · 2 fatalClosedCessna 337C · San Juan, PRAug 25, 1975 · N102CH · Destroyed NTSB MIA76AM013Accident · No injuriesClosedCurtis-Wrt C-46F · Aguadilla, PRAug 8, 1975 · N4873V · Destroyed NTSB MIA76AM007Accident · Minor injuriesClosedDehavilland DH114 · San Juan, PRJul 11, 1975 · N570PR · Substantial damage NTSB MIA7KAM086Accident · 1 fatalClosedGrum Amer AA-5 · Fajardo, PRJun 7, 1975 · N7176L · Destroyed NTSB MIA75FKA09Accident · No injuriesClosedHiller Acft UH-12E · San Juan, PRApr 28, 1975 · N9781C · Substantial damage NTSB MIA75FKA07Accident · No injuriesClosedBeech B95 · Arecibo, PRApr 3, 1975 · N695Q · Substantial damage NTSB MIA75FKA05Accident · Serious injuriesClosedCessna 150 · Adjuntas, PRFeb 3, 1975 · N2887V · Substantial damage NTSB MIA75AM050Accident · Minor injuriesClosedPiper PA-23 · Vieques, PRJan 31, 1975 · N5030Y · Destroyed NTSB MIA75IM047Incident · No injuriesClosedLockheed 1011 · San Juan, PRJan 17, 1975 · N304EA · Minor damage NTSB MIA75AM023Accident · Serious injuriesClosedBrittnorman BN-2A · San Juan, PROct 20, 1974 · N46JA · No damage NTSB MIA75DKA01Accident · No injuriesClosedHelio Acft H-295 · Mayaguez, PRSep 8, 1974 · N68870 · Substantial damage NTSB MIA74AM100Accident · No injuriesClosedDouglas DC-3 · San Juan, PRJun 13, 1974 · N87628 · Substantial damage NTSB MIA74FKA10Accident · No injuriesClosedCessna 172M · Dorado, PRApr 26, 1974 · N13420 · Substantial damage NTSB MIA74FKA09Accident · Serious injuriesClosedBell 47G2A1 · San Sabastian, PRApr 18, 1974 · N73264 · Destroyed NTSB MIA75AM028Accident · No injuriesClosedBoeing 747 · San Juan, PRApr 16, 1974 · N653PA · No damage NTSB MIA74FKA08Accident · No injuriesClosedPiper PA-28 · Culebra, PRFeb 22, 1974 · N5158S · Substantial damage NTSB MIA74FKA07Accident · No injuriesClosedCessna 150 · Humacao, PRDec 9, 1973 · N1707Q · Substantial damage NTSB MIA74AM042Accident · No injuriesClosedBeech E18S · San Juan, PRNov 13, 1973 · N3628B · Substantial damage NTSB MIA74AM033Accident · Minor injuriesClosedSikorsky S-62A · Jayuya, PROct 16, 1973 · N1166U · Destroyed NTSB MIA74AM031Accident · No injuriesClosedGrumman G-21A · Christiansted, PROct 13, 1973 · N4772C · Substantial damage NTSB MIA74DKA11Accident · No injuriesClosedGrumman G-164 · Ponce, PRSep 13, 1973 · N10398 · Substantial damage NTSB MIA74DKA03Accident · No injuriesClosedCessna 150 · Humacao, PRAug 9, 1973 · N50141 · Destroyed NTSB MIA74DKA01Accident · No injuriesClosedAeronca 7FC · Ponce, PRJul 7, 1973 · N9889B · Substantial damage NTSB MIA73FKA10Accident · Minor injuriesClosedPiper PA-32 · Humacao, PRMay 24, 1973 · N4795S · Destroyed NTSB MIA73AM065Accident · 2 fatalClosedCessna 182H · Culebra Island, PRMay 3, 1973 · N1905X · Destroyed NTSB MIA73FKA08Accident · No injuriesClosedBrittnorman BN-2A · Culebra, PRFeb 18, 1973 · N871JA · Substantial damage NTSB FTW73AF051Incident · No injuriesClosedLockheed 1011 · San Juan, PRFeb 9, 1973 · N315EA · Minor damage NTSB NYC73AN094Accident · 5 fatalClosedDouglas DC-7CF · San Juan, PRDec 31, 1972 · N23N · Destroyed NTSB MIA73FKA07Accident · 1 fatalClosedAmer Avco AA1 · San Juan, PRDec 30, 1972 · N6230L · Destroyed NTSB MIA73FKA05Accident · Serious injuriesClosedCessna 172C · Culebra, PRNov 1, 1972 · N8293X · Destroyed NTSB MIA73FKA04Accident · No injuriesClosedPiper PA-23 · Barceloneta, PROct 21, 1972 · N6642Y · Substantial damage NTSB MIA73IM005Incident · No injuriesClosedDouglas DC-9 · San Juan, PRJul 3, 1972 · N967PR · Minor damage NTSB MIA72AM142Accident · 5 fatalClosedDehavilland DH114 · Ponce, PRJun 24, 1972 · N554PR · Destroyed NTSB MIA72FKA15Accident · Minor injuriesClosedAmer Avco AA-1A · San Juan, PRJun 3, 1972 · N9292L · Destroyed NTSB MIA72AM112Accident · No injuriesClosedDouglas DC-8 · San Juan, PRApr 21, 1972 · N8776 · No damage NTSB MIA72IM097Incident · No injuriesClosedConvair 640 · San Juan, PRMar 23, 1972 · N3407 · Minor damage NTSB MIA72AM090Accident · No injuriesClosedDehavilland DH104 · San Juan, PRMar 14, 1972 · N562PR · Substantial damage NTSB MIA72AM057Accident · Serious injuriesClosedBrittnorman BN-2 · Culebra, PRDec 21, 1971 · N589JA · Destroyed NTSB MIA72DKA08Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRDec 14, 1971 · N5991W · Substantial damage NTSB MIA72FKA06Accident · No injuriesClosedPiper PA-23 · Culebra Town, PRNov 2, 1971 · N3495P · Substantial damage NTSB MIA72IM023Incident · Minor injuriesClosedDouglas DC-8F · San Juan, PRSep 1, 1971 · N801U · No damage NTSB MIA72FKA02Accident · No injuriesClosedAmer Avco AA1 · San Sebastian, PRJul 26, 1971 · N6239L · Destroyed NTSB MIA71FKA12Accident · 1 fatalClosedGrumman G-164 · Ponce, PRJun 22, 1971 · N399Y · Destroyed NTSB MIA71AM114Accident · 2 fatalClosedGrumman G-21A · Culebra Island, PRJun 18, 1971 · N703A · Destroyed NTSB MIA71DKA14Accident · No injuriesClosedGrumann G164 · Yauco, PRJun 7, 1971 · N10296 · Destroyed NTSB MIA71AM108Accident · 1 fatalClosedCessna 172E · Villalba, PRJun 6, 1971 · N3710S · Destroyed NTSB MIA71DKA13Accident · No injuriesClosedCessna 150J · Ponce, PRMay 23, 1971 · N61318 · Substantial damage NTSB MIA71AM089Accident · 4 fatalClosedPiper PA-28 · Yabucoa, PRApr 18, 1971 · N4853L · Destroyed NTSB MIA71AM081Accident · No injuriesClosedPiper PA-32 · Vieques Island, PRMar 9, 1971 · N3996W · Substantial damage