NTSB investigations, 1968, 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.
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\") = 1968
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") = 1968 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 MIA69F0311Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PRNTSB MIA69F0236Accident · No injuriesClosedCessna 175 · San Juan, PRNTSB MIA69F0274Accident · Serious injuriesClosedBeech A23A · Dorado Beach, PRNTSB MIA68F0104Accident · Minor injuriesClosedCessna 150 · Mayaguez, PRNTSB MIA69F0110Accident · Minor injuriesClosedAero Comdr 600S2D · Loiza Aldea, PRNTSB MIA69D0109Accident · Minor injuriesClosedPiper PA-28 · Loiza Aldea, PRNTSB MIA69F0101Accident · No injuriesClosedPiper PA-25 · Salinas, PRNTSB MIA69F0087Accident · Minor injuriesClosedChampion 7ECA · San Sebastion, PRNTSB MIA69F0004Accident · Serious injuriesClosedHiller UH-12 · Manati, PRNTSB MIA69D0097Accident · No injuriesClosedPiper PA-32 · San Juan, PRNTSB MIA68D0510Accident · No injuriesClosedPiper PA-25 · Santa Isabel, PRNTSB MIA68A0090Accident · 1 fatalClosedAero Comdr 680 · San Juan, PRNTSB MIA68A0089Accident · No injuriesClosedBeech D18S · San Juan, PRNTSB MIA68A0072Accident · 4 fatalClosedBeech 35-33 · Gurabo, PRNTSB MIA68D0434Accident · Minor injuriesClosedCessna 172 · Isabela, PRNTSB MIA68D0382Accident · No injuriesClosedCessna 150 · Yabucoa, PRNTSB MIA68F0415Accident · No injuriesClosedCessna 150 · Humacao, PRNTSB MIA68F0352Accident · Minor injuriesClosedPiper PA-28 · Mayaguez, PR