NTSB investigations, PR
8 cases where the sequence of events included Hard landing.
Cases per year
| 2012 | 1 |
|---|---|
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2025 | 1 |
| 2026 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA26LA176Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Levittown, PRAn oil line separation at a barbed fitting in an experimental airplane, which resulted in a total loss of engine power due to oil starvation.NTSB DCA25LA184Incident · No injuriesClass 3 · LimitedPreliminary reportAirbus A321-271NX · San Juan, PROn April 15, 2025, about 2140, Atlantic daylight time (ADT), Frontier Airlines, flight 3506, an Airbus A321-271NX, N607FR, sustained nose wheel and engine damage during an attempted landing at the Luis Munoz Marin International Airport (SJU), San Juan, Puerto…NTSB ERA22LA123Accident · No injuriesClass 3 · LimitedFinal reportBritten-Norman BN-2A-9 · Culebra, PRThe flight crew’s failure to arrest the descent rate during the non-standard approach, which resulted in a hard landing and failure of the right-wing structure. Contributing was the flight instructor’s selection of a challenging approach for initial training.NTSB ERA20CA073Accident · No injuriesData collectionFinal reportBeech Hawker 900XP · San Juan, PRThe pilot's failure to maintain a proper descent rate during landing, which resulted in a hard landing short of the runway.NTSB ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.NTSB ERA17CA056Accident · No injuriesData collectionFinal reportBell OH 58A · Ponce, PRThe helicopter flight instructor's inadequate demonstration of a simulated engine failure, which resulted in a hard landing.NTSB ERA15LA280Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369FF · Vega Baja, PRA total loss of engine power due to insufficient lubrication to the engine's No. 2 bearing, which resulted in the failure of the bearing and a subsequent forced landing.NTSB ERA12TA515Accident · No injuriesFinal reportBell 206B · San Juan, PRThe crew’s inadequate preflight inspection and failure to monitor the fuel state during flight, which resulted in a total loss of engine power due to fuel exhaustion.