NTSB investigations: Pratt & Whitney R-1830 series, FL

10 cases on aircraft whose registry engine model is Pratt & Whitney R-1830 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19742026

NTSB investigations: Pratt & Whitney R-1830 series, FL per year, 1974–2026: 10 cases
1974	1
1977	1
1978	1
1979	1
1980	1
1982	2
1984	1
1987	1
1993	1

Where

Open the map

Latest cases

Query with SQL

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" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52020')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52020'))
  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" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52020'))
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 MIA93LA106Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Zephyrhills, FLThe pilot-in-command's failure to maintain best single-engine rate-of-climb speed which resulted in a forced landing. A factor which contributed to the accident was a possible exhaust system clamp failure.Apr 20, 1993 · N8056 · Substantial damage NTSB MIA87IA195Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Hilliard, FLAccording to the FAA the pilot stated that just after he rotated for takeoff the acft lost power in the left eng. He then aborted the takeoff, set the acft back on the runway & it slid off the left side into some bushes. The plts did not submit an operator…Jun 30, 1987 · N31MS · Minor damage NTSB MIA84FA256Accident · No injuriesField investigationFinal reportDouglas DC3 · Boca Raton, FLFour hours and forty mins after takeoff aprx 6 miles from the dest aprt, both engs stopped running. Attempts to restart the engs were unsuccessful. Thinking they were out of fuel, the crew accomplished a forced landing in a wildlife refuge in 10 ft tall…Sep 18, 1984 · N143D · Substantial damage NTSB MIA82FA128Accident · Serious injuriesField investigationFinal reportDouglas DC-3C · St. Petersburg, FLAfter a local maintenance flight the crew returned to St. Petersburg to practice full stop landings. Shortly after becoming airborne during the 2nd takeoff, the right eng experienced a power loss. The acft was observed to climb to about 50 ft AGL, then veer…Jun 6, 1982 · N95C · Destroyed NTSB MIA82DA046Accident · No injuriesFinal reportHoward 500 · Ft. Lauderdale, FLThe pilot stated that partial power failure of the left engine combined with torque and a crosswind caused a loss of directional control approximately 100 yards into the takeoff roll.Feb 12, 1982 · N1515V · Substantial damage NTSB MIA80FA058Accident · Serious injuriesClosedDouglas C-47B · Dania, FLApr 23, 1980 · N709Z · Destroyed NTSB MIA79FLD79Accident · No injuriesClosedDouglas DC3-C · Tampa, FLJul 22, 1979 · N77B · Substantial damage NTSB MIA79DA001Accident · 1 fatalClosedDouglas DC-3 · Ft Walton Bch, FLOct 1, 1978 · N74Z · Destroyed NTSB MIA77DLD39Accident · No injuriesClosedDouglas DC-3 · Polk City, FLMar 18, 1977 · N25670 · Substantial damage NTSB MIA74AM088Accident · No injuriesClosedDouglas DC3C · Tampa, FLApr 18, 1974 · N90830 · Substantial damage