NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 DCA06FA068Accident · No injuriesField investigationFinal reportBoeing B757-232 · San Juan, PRthe first officer's inadvertent application of full nose-up trim during a prolonged flare, resulting in an excessive pitch angle during landing and subsequent tailstrike. Contributing to the accident was the flight crew's failure to correct the airplane's…NTSB ANC06LA112Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Culebra, PRA loss of engine power due to fuel starvation/exhaustion in all engines for an undetermined reason during cruise flight, which resulted in a forced landing and ditching.NTSB ANC06LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Borinquen, PRFuel starvation/exhaustion for an undetermined reason during cruise flight, which resulted in a complete loss of engine power to both engines and a ditching in the ocean.NTSB MIA06LA071Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Dorado, PRThe failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.NTSB MIA06CA059Accident · No injuriesData collectionFinal reportPiper PA-18 · SanJuan, PRThe pilot's failure to maintain directional control during landing.NTSB MIA06LA044Accident · Minor injuriesLimited investigationFinal reportMBB BO-105S · Ponce, PRA loose B-nut on the PC line connecting the power turbine governor (PTGOV) to the fuel control unit (FCU) that created a leak and caused the engine to roll back to an idle condition, causing a low hydraulic system pressure and subsequent control lock. A…