NTSB investigations, PR
12 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'PR' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0303'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 ERA26LA047Accident · Minor injuriesClass 4 · LimitedFinal reportTorres Ruben Aventura II · Culebrita Beach, PRThe pilot's failure to maintain directional control during the initial climb, which resulted in abnormal contact with the water and a subsequent collision with vegetation.NTSB DCA19CA189Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · San Juan, PRAn encounter with convective turbulence during cruise flight.NTSB ERA18LA002Accident · 1 fatalLimited investigationFinal reportCessna 182 · San Juan, PRThe pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.NTSB ERA16LA323Accident · No injuriesLimited investigationFinal reportLearjet 25 · San Juan, PRThe pilot’s improper decision to land the airplane on a wet runway, in heavy rain, with tires worn beyond safe limits, which resulted in a hydroplaning condition and subsequent loss of directional control.NTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.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 ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.NTSB ERA11FA376Accident · 5 fatalField investigationFinal reportCessna A185F · Yabucoa, PRThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.NTSB DCA09CA051Accident · Serious injuriesData collectionFinal reportBoeing 767 332 · San Juan, PRInadvertent encounter with convective turbulence while in cruise.NTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.NTSB ERA09FA078Accident · 3 fatalField investigationFinal reportRockwell International 690B · Rio Grande, PRThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB NYC08CA300Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II · Barceloneta, PRThe student pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the high winds.