NTSB investigations, 1972, PR
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 32 |
| 1965 | 28 |
| 1966 | 19 |
| 1967 | 25 |
| 1968 | 18 |
| 1969 | 19 |
| 1970 | 14 |
| 1971 | 15 |
| 1972 | 10 |
| 1973 | 11 |
| 1974 | 7 |
| 1975 | 14 |
| 1976 | 9 |
| 1977 | 11 |
| 1978 | 10 |
| 1979 | 13 |
| 1980 | 13 |
| 1981 | 15 |
| 1984 | 1 |
| 1999 | 1 |
| 2001 | 8 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 6 |
| 2007 | 7 |
| 2008 | 4 |
| 2009 | 6 |
| 2010 | 9 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 8 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 3 |
Latest cases
Query with SQL
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 year(c.\"eventDate\") = 1972
AND 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 year(c."eventDate") = 1972 AND 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 NYC73AN094Accident · 5 fatalClosedDouglas DC-7CF · San Juan, PRNTSB MIA73FKA07Accident · 1 fatalClosedAmer Avco AA1 · San Juan, PRNTSB MIA73FKA05Accident · Serious injuriesClosedCessna 172C · Culebra, PRNTSB MIA73FKA04Accident · No injuriesClosedPiper PA-23 · Barceloneta, PRNTSB MIA73IM005Incident · No injuriesClosedDouglas DC-9 · San Juan, PRNTSB MIA72AM142Accident · 5 fatalClosedDehavilland DH114 · Ponce, PRNTSB MIA72FKA15Accident · Minor injuriesClosedAmer Avco AA-1A · San Juan, PRNTSB MIA72AM112Accident · No injuriesClosedDouglas DC-8 · San Juan, PRNTSB MIA72IM097Incident · No injuriesClosedConvair 640 · San Juan, PRNTSB MIA72AM090Accident · No injuriesClosedDehavilland DH104 · San Juan, PR