NTSB investigations, PR
8 cases where NTSB found Object/animal/substance.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2023 | 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\", '030220'))
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", '030220')) 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 ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.NTSB GAA18CA378Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369 · Yabucoa, PRThe pilot's failure to maintain main rotor clearance from a fiber line while picking up a lineman.NTSB ERA18LA091Accident · Serious injuriesLimited investigationFinal reportHughes 369 · San Juan, PRThe helicopter pilot's improper decision to use an open-end grapple, instead of an A-frame attachment, to lift and move a ladder with a lineman on it and the lineman's improper decision to be lifted on a ladder via an open-end grapple, which were contrary to…NTSB GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.NTSB GAA16CA348Accident · No injuriesData collectionFinal reportBeech B200 · Carolina, PRThe pilot's failure to actuate the parking brake prior to leaving his seat, resulting in substantial damage.NTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA433Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Humacao, PRThe pilot's failure to maintain clearance from a building during landing.NTSB ERA10CA090Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Patillas, PRThe pilot's inadequate visual lookout and failure to maintain clearance from a tree.