NTSB investigations, 2013, 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\") = 2013
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") = 2013 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 ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…NTSB ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.NTSB ENG13IA036Incident · No injuriesIncident investigationFinal reportBoeing Company, Long Beach Div Boeing MD-11 · Aguadilla, PRan insufficiently robust flange attachment hardware design, which failed to contain engine components that were liberated during an LPT mechanical failure, resulting in engine/nacelle uncontainment. A factor in the incident was the lack of a module-level LPT…NTSB ERA13LA152Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ciales, PRA loss of main rotor rpm for reasons that could not be determined because an examination of the helicopter’s engine and associated components did not reveal any mechanical malfunctions or failures that would have precluded normal operation.