Fatal NTSB investigations, 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 3 |
| 1970 | 2 |
| 1971 | 5 |
| 1972 | 3 |
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 3 |
| 2001 | 2 |
| 2002 | 4 |
| 2004 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2024 | 2 |
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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal' 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 ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.NTSB ERA24FA301Accident · 1 fatalClass 3 · FieldFinal reportCessna 402B · Aguadilla, PRThe pilot’s decision to operate the airplane with known maintenance discrepancies, which resulted in a total loss of right engine power. Contributing to the outcome was the pilot’s failure to maintain airspeed while returning to the airport with a single…NTSB ERA20LA202Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA23 · San Juan, PRThe pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…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 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 ERA17FA195Accident · 1 fatalField investigationFinal reportPiper PA23 · San Juan, PRThe pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.NTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.NTSB ERA15FA096Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Catano, PRThe student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…NTSB ERA14LA174Accident · 1 fatalLimited investigationFinal reportN/A N/A · Patillas, PRThe pilot’s failure to maintain airplane control during approach for landing, which resulted in a stall/spin.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 ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…NTSB DCA12FA051Accident · 2 fatalClass 1 · FieldFinal reportConvair 440 - NO Series · San Juan, PRthe flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.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 ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.NTSB ERA10LA207Accident · 1 fatalLimited investigationFinal reportLuciano Edison HA-2 Sportster · Humacao, PRThe failure of the pilot to maintain control of the gyrocraft while maneuvering after takeoff. Contributing to the accident was the pilot’s operation of the gyrocraft with an inoperative right magneto.NTSB ERA10LA158Accident · 1 fatalLimited investigationFinal reportMonroig Pedro J Rans S-6S · Mayaguez, PRThe sport pilot's failure to maintain adequate airspeed during landing in crosswind conditions resulting in an aerodynamic stall.NTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.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 NYC08LA225Accident · 2 fatalLimited investigationFinal reportRans Rans S-6ES · Lajas, PRThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB MIA07FA042Accident · 2 fatalField investigationFinal reportPartenavia P 68C · Adjuntas, PRThe pilot's failure to maintain altitude/clearance with mountainous terrain for undetermined reasons during a normal descent under instrument meteorological and dark night conditions.NTSB MIA04LA133Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-27 · Vega Baja, PRThe pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.NTSB NYC04FA223Accident · 1 fatalField investigationFinal reportAero Commander 112 · Vieques, PRThe pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…NTSB ATL03FA023Accident · 2 fatalField investigationFinal reportCessna 150L · Arecibo, PRThe pilots failure to follow the normal takeoff checklist (Wing Flaps-Up) and failure to maintain airspeed after takeoff that resulted in an inadvertent stall.NTSB ATL02FA107Accident · 1 fatalField investigationFinal reportBell 47G-4A · Yauco, PRThe pilot's failure to apply carburetor heat that resulted in a partial loss of engine power and the subsequent collision with an object during the forced landing. A factor was weather conditions favorable for the formation of carburetor ice.NTSB MIA02FA084Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-35 · Carolina, PRThe failure of the pilot to maintain airspeed (Vs) while maneuvering following inadvertent encounter with clouds resulting in an inadvertent stall and uncontrolled descent and subsequent in-flight collision with trees, a wall, and a building.NTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.NTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.NTSB MIA01FA072Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ponce, PRThe pilot's decision to attempt flight with known deficiencies in the airplanes right engine, his failure to feather the right propeller after the engine failed , his failure to retract the landing gear following the engine failure, and his failure to…NTSB MIA82DKA04Accident · 1 fatalClosedBensen B-8M · Sandin, PRNTSB MIA81FA054Accident · 3 fatalClosedMooney M20F · San Juan, PRNTSB MIA81FA046Accident · 5 fatalClosedPiper PA-32R · El Duque, PRNTSB MIA81FA001Accident · 4 fatalClosedPiper PA-28 · Aguadilla, PRNTSB MIA80FA106Accident · 4 fatalClosedCessna 182 · Rio Grande, PRNTSB MIA79FA115Accident · 2 fatalClosedCessna 336 · San Juan, PRNTSB MIA79FA082Accident · 4 fatalClosedCessna 172M · San Juan, PRNTSB DCA78AA024Accident · 6 fatalClosedBeech D18S · San Juan, PRNTSB MIA78FA120Accident · 2 fatalClosedGrum-Amer AA1A · Toa Baja, PRNTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRNTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRNTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRNTSB MIA76AM019Accident · 2 fatalClosedCessna 337C · San Juan, PRNTSB MIA7KAM086Accident · 1 fatalClosedGrum Amer AA-5 · Fajardo, PRNTSB MIA73AM065Accident · 2 fatalClosedCessna 182H · Culebra Island, PRNTSB NYC73AN094Accident · 5 fatalClosedDouglas DC-7CF · San Juan, PRNTSB MIA73FKA07Accident · 1 fatalClosedAmer Avco AA1 · San Juan, PRNTSB MIA72AM142Accident · 5 fatalClosedDehavilland DH114 · Ponce, PRNTSB MIA71FKA12Accident · 1 fatalClosedGrumman G-164 · Ponce, PRNTSB MIA71AM114Accident · 2 fatalClosedGrumman G-21A · Culebra Island, PR